Summary
Overview
Work History
Education
Skills
Academic Projects
Timeline
Generic

Satya Rellu

Calgary,AB

Summary

  • Strong analytical skills with experience in conducting in-depth financial analysis, including full cost budgeting, modeling, forecasting, and accruals management.
  • Ability to gather, analyze, and interpret financial data to provide actionable insights and support strategic decision-making and budgetary control.
  • Ability to effectively communicate with stakeholders from various departments to understand their needs and requirements.
  • Knowledge and experience in data visualization, including the ability to design visually appealing and effective dashboards and reports.
  • Proficient in preparing financial reports, presentations, and ad-hoc analysis for executive leadership and other stakeholders.
  • Ability to develop and maintain dynamic Power BI dashboards and reports.
  • Experienced in SQL for data manipulation and analysis.

Overview

4
4
years of professional experience

Work History

Business Intelligence Data Analyst

Shaw Communications
06.2023 - Current
  • Leveraged SQL for in-depth data analysis of existing set-top box performance, identifying drawbacks and limitations.
  • Utilized Power BI to create comprehensive dashboards and reports, visualizing data insights for stakeholders.
  • Gathered requirements for the new set-top box series using SQL, incorporating stakeholder feedback.
  • Managed budget allocation through SQL analysis, optimizing resource utilization.
  • Tracked project progress and communicated insights using Power BI dashboards, facilitating agile decision-making.
  • Involved in various design meetings with the architect and the business team to create best configure the application of the core product.

Risk Analyst (Intern)

AGLC
05.2022 - 08.2022
  • Managed a software upgrade project, overseeing resource allocation, budget planning, and cross-functional communication
  • Participated in project requirement development and contributed to cost reduction planning, playing a vital role in ensuring the project's efficient execution and alignment with organizational objectives.
  • Created weekly reports to present and communicate to leadership on team progress and recommendations.
  • Work closely with counterparts and key stakeholders in Product Management to align on the vision, program backlog, and roadmap.

Business Analyst

Tata Consultancy Services
07.2020 - 07.2021
  • Led a Cost Reduction Initiative project, achieving a 15% reduction in operational expenses for the Sales Division. Conducted process analysis, identified cost drivers, and implemented strategic measures such as renegotiating vendor contracts, resulting in significant cost savings while ensuring productivity and quality standards.
  • Collected and recorded user and business requirements via Joint Application Development (JAD) sessions, interviews, requirement workshops, and creation of user interface mockups.
  • Created interactive dashboards in Power BI to visualize churn trends over time, allowing stakeholders to easily identify periods of high churn and potential contributing factors.
  • Conducted cohort analysis in Power BI to segment customers based on demographics and usage behavior, revealing insights into which customer segments are most prone to churn and informing targeted retention strategies.
  • Engaged in all firm projects, employing Agile methodology with a focus on Scrum complemented by waterfall practices.

Data Analyst (Intern)

Tata Consultancy Services
01.2020 - 06.2020
  • Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
  • Collaborated with the Marketing team to create an extensive Power BI dashboard, identifying inefficiencies and prompting a strategic decision to discontinue certain activities. This action yielded a 15% reduction in marketing expenses, allowing for reallocation of funds towards initiatives with higher return on investment (ROI).
  • Analyzed user concerns, requirements and requests for system features and uses.

Education

Master of Science - Computer Engineering

Master of Engineering
University Of Calgary
05.2023

Bachelor of Science - Electronics And Communication

MLR Institute of Technology
Hyderabad, India
06.2020

Skills

SDLC methodologies : Waterfall, Agile, Scrum

Programming languages: SQL, Python

Reporting Tools: Microsoft Power BI

Databases: MySQL, Oracle, Microsoft SQL Server

Data Analysis: NumPy, Pandas

Business Proficiency : JAD Sessions, Project Planning, SWOT Analysis

Requirement Management tools: MS Office, JIRA, Service Now, Microsoft Azure, SharePoint, Oracle,

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.


Timeline

Business Intelligence Data Analyst

Shaw Communications
06.2023 - Current

Risk Analyst (Intern)

AGLC
05.2022 - 08.2022

Business Analyst

Tata Consultancy Services
07.2020 - 07.2021

Data Analyst (Intern)

Tata Consultancy Services
01.2020 - 06.2020

Master of Science - Computer Engineering

Master of Engineering

Bachelor of Science - Electronics And Communication

MLR Institute of Technology
Satya Rellu