Satya Rellu
Calgary,AB
Summary
- Proficient in statistical and data analysis tools, including Excel, SPSS, SAS, SQL and Python,.
- Experienced in managing and analyzing large datasets using advanced ETL techniques and data visualization practices.
- Developed and maintained risk monitoring dashboards, supporting continuous assurance programs.
- Certified in data visualization tools like Tableau and Power BI, adept at creating actionable insights.
- Skilled in advanced analytics, process automation, and statistical modeling within audit and compliance frameworks.
- Experienced in Azure Data Factory, Synapse Analytics, Data Lake, and Databricks, with a strong foundation in ETL, big data processing, and analytics
- Worked effectively within diverse, cross-functional teams to achieve project and sprint goals using tools like Jira.
- Strong problem-solving abilities, with expertise in root cause analysis and data based decisions.
- Excellent oral and written communication skills, capable of translating complex data findings into understandable insights.
Overview
4
4
years of professional experience
Work History
Technical Support Analyst
Shaw Communications
10.2023 - Current
- Worked within a cross-functional team to achieve the successful implementation and upgrade of satellite receiver versions, following Agile development cycles to ensure timely delivery and adaptation to evolving requirements.
- Implemented ETL pipelines to efficiently move data from SAP to the data warehouse, ensuring seamless data integration and accessibility for analysis.
- Collaborated on integrating SAP data with Power BI, leveraging DAX calculations and data modeling to enhance advanced analytics and visualization.
Developed optimized data models in Power BI, enabling stakeholders to monitor processes in real time and optimize decision-making. - Utilized Python scripts involving modules like pysnow, numpy, and pandas to establish connections with ServiceNow and SAP systems, enabling the extraction, cleansing, and analysis of customer review data.
- Successfully optimized budget allocation utilizing SAP, resulting in a significant increase in resource efficiency across departments with a success rate of over 90%.
- Acted as a liaison among the product, IT, and sales teams to understand customer demand for new features and new potential markets to move into.
Data Analyst (Intern)
Buyerfolio
07.2024 - 12.2024
- Imported raw data from Excel into Python for comprehensive cleaning, transformation, and validation, ensuring accuracy and consistency across property details, individual incomes, taxes, and interest rates.
- Designed and implemented a data warehouse model to efficiently store and analyze mortgage data, enabling seamless KPI tracking and advanced analytics.
- Developed key performance indicators (KPIs) to evaluate loan qualification criteria, providing insights into the percentage of individuals eligible for home loans.
- Developed dynamic Power BI reports utilizing advanced DAX measures to calculate loan eligibility trends, enabling stakeholders to make data-driven decisions.
- Automated data cleaning and transformation using Python, improving efficiency and reducing manual errors in the data preparation process.
Junior Business Analyst
Tata Consultancy Services
11.2020 - 07.2021
- Started as an Intern and continued working with cross-functional teams to manage the project's life cycle and ensured the team achieved 96% of deadlines by communicating realistic expectations.
- Researched and presented to stakeholders obtaining approvals for requirements and changes.
- Collaborated with a team of two members to analyze sales trends for a retail business using Oracle database and SQL. Utilized Power BI to generate and submit reports, resulting in a 15% revenue increase.
- Engaged in all firm projects, employing Agile methodology with a focus on Scrum complemented by waterfall practices.
Education
Master of Science - Computer Engineering
Master of Engineering
University Of Calgary05.2023
Bachelor of Science - Electronics And Communication
MLR Institute of Technology
Hyderabad, India06.2020
Skills
- Proficient in statistical and data analysis tools, including Excel, SPSS, SAS, SQL and Python,
- Experienced in managing and analyzing large datasets using advanced ETL techniques and data visualization practices
- Developed and maintained risk monitoring dashboards, supporting continuous assurance programs
- Certified in data visualization tools like Tableau and Power BI, adept at creating actionable insights
- Skilled in advanced analytics, process automation, and statistical modeling within audit and compliance frameworks
- Experienced in Azure Data Factory, Synapse Analytics, Data Lake, and Databricks, with a strong foundation in ETL, big data processing, and analytics
- Worked effectively within diverse, cross-functional teams to achieve project and sprint goals using tools like Jira
- Strong problem-solving abilities, with expertise in root cause analysis and data based decisions
- Excellent oral and written communication skills, capable of translating complex data findings into understandable insights
Academic Projects
Covid Data Analysis: Analyzed COVID-19 trends using SQL queries to extract and manipulate data based on key performance
indicators (KPIs). Visualized insights with Power BI, facilitating informed decision-making on pandemic response strategies and
resource allocation.
Pneumonia Detection: Developed a machine-learning model to detect pneumonia from chest X-ray images. Utilized deep learning
techniques such as convolutional neural networks (CNNs) to achieve high accuracy in classifying X-ray images as either
pneumonia-positive or pneumonia-negative.
Olympic Data Analysis:
Conducted comprehensive data analysis to unearth pivotal performance trends and insights essential for strategic decision-making.
Streamlined data ingestion procedures, employed Spark for data transformation, and crafted interactive Tableau dashboards to visually represent athlete performances and insights.
Certification
- Data Analyst Associate - Coursera certified
- SQL Server - Udemy Certified
- Azure Fundamentals - Microsoft certified (Pursuing)
Timeline
Data Analyst (Intern)
Buyerfolio
07.2024 - 12.2024
Technical Support Analyst
Shaw Communications
10.2023 - Current
Junior Business Analyst
Tata Consultancy Services
11.2020 - 07.2021
Master of Science - Computer Engineering
Master of Engineering
Bachelor of Science - Electronics And Communication
MLR Institute of Technology
Similar Profiles
Kelly BirchardKelly Birchard
Technical Service Representative at SHAW COMMUNICATIONSTechnical Service Representative at SHAW COMMUNICATIONS
Harpreet KaurHarpreet Kaur
Technical Support Consultant at Shaw CommunicationsTechnical Support Consultant at Shaw Communications
BARATHRAM KOMARAPALAYAM SUBRAMANIANBARATHRAM KOMARAPALAYAM SUBRAMANIAN
BRM Test Lead at Shaw CommunicationsBRM Test Lead at Shaw Communications