SRAVANI PAGADALA
Oakville,ON
Summary
Experienced Data analyst with 6+ years of expertise in data analysis, engineering, and reporting. Skilled in SQL, Big query, SSIS, SSRS, Power BI, Tableau and Looker, with a strong ability to design and implement data solutions that improve business decision making. Proven ability to design and develop scalable ETL pipelines, data warehouses, data lakes, optimizing data integration processes to support analytics at enterprise scale. Expert in creating interactive dashboards, and reports using Power BI, Tableau and Looker. Experienced in partnering with business teams to define needs and provide meaningful analytics.
Overview
8
8
years of professional experience
Work History
Sr Data Analyst
Walmart Canada
Mississauga, Canada
01.2024 - Current
- Performed in-depth analysis on large datasets using Big Query (BQ) to extract valuable insights and support business decisions.
- Designed and optimized Big Query routines to enhance query performance and automate data processing tasks.
- Automated data workflows using Big Query scheduled queries and Apache Airflow to streamline processes and minimize manual intervention by 50%.
- Contributed to the development of enterprise level solutions like Merch One and COIM.
- Utilized Big Query for querying and analyzing large datasets and integrated with visualization tools like Power BI, Tableau, and Looker for reporting.
- Developed and maintained regular reports and dashboards to track key metrics, ensuring stakeholders have access to accurate, timely data.
- Analyzed complex data trends and generated actionable insights to guide business strategy and decision making.
- Met regularly with cross-functional stakeholders (e.g., Store ops, merchandising, operations, marketing, finance) to gather reporting requirements.
- Migrated flows from Tableau Prep to Big Query Routines to improve performance and reducing downtime.
- Translated business requirements into data-driven solutions, ensuring clear communication of technical concepts to nontechnical audiences.
- Provided guidance to stakeholders by identifying key performance indicators (KPIs) and creating custom reports.
- Performed ad-hoc analysis to identify trends and support decision making.
- Conducted exploratory data analysis to uncover trends, anomalies, and optimization opportunities.
- Automated and optimized data workflows and reporting processes, reducing manual effort and increasing efficiency.
- Ensured data accuracy and integrity by implementing rigorous validation processes and cross-checking results across multiple data sources.
BI & Data Warehouse Developer
Intelligent Hospitality
Mississauga, Canada
07.2019 - 07.2022
- Developed and published Power BI dashboards with Role-Level Security (RLS).
- Created multiple dashboards and key performance indicators (KPIs) in Power BI that provided real-time visibility.
- Developed DAX queries to generate computed columns in Power BI.
- Created and maintained workspaces in Power BI Service.
- Generated Views, reports, and dashboards using Power BI.
- Applied Dimensional Modeling techniques to design dimensions, fact tables, and aggregate tables.
- Created SQL Server reports using SSRS based on business requirements.
- Developed and optimized SSIS Packages using transformations like Derived Column, Lookup, Conditional Split, MergeJoin, Union All, Sort, and Execute SQL Task.
- Created staging databases for temporary data processing before loading into the target database.
- Regularly debugged SQL Server SSIS processes and optimized ETL workflows.
- Mentored two junior analysts in ETL best practices and query optimization, improving team efficiency and code quality.
- Collaborated closely with business partners to understand requirements and design efficient data models.
- Maintained and enhanced existing data solutions, reports & dashboards, improving system efficiency.
ETL Developer
Longo Bros. Fruit Markets Inc.
01.2018 - 07.2019
- Developed and debugged complex ETL processes using T-SQL queries, functions, stored procedures, and SQL Server Agent jobs.
- Interacted with business users to gather requirements and designed functional and technical specifications for reporting.
- Designed database structures to support efficient data access in real-time using SSIS.
- Developed ETL processes to extract data from multiple sources and integrate it into a single reporting source.
- Participated in performance tuning and data quality checks to maintain accuracy and reliability across reporting systems.
- Generated complex reports using SQL Server Reporting Services (SSRS).
Education
Master of Technology - Computer Science
Jawaharlal Nehru Technological University
India01.2015
Bachelor of Technology - Informa9on Technology
Jawaharlal Nehru Technological University
India01.2013
Skills
- BigQuery
- Power BI
- Tableau
- Looker
- SQL Server
- Oracle
- SSRS
- Cloud SQL
- Cloud Spanner
- SSIS
- Apache Airflow
- Alteryx
- SQL
- T-SQL
- DAX
- Google Cloud Platform (GCP)
- Google Cloud Storage
Timeline
Sr Data Analyst
Walmart Canada
01.2024 - Current
BI & Data Warehouse Developer
Intelligent Hospitality
07.2019 - 07.2022
ETL Developer
Longo Bros. Fruit Markets Inc.
01.2018 - 07.2019
Master of Technology - Computer Science
Jawaharlal Nehru Technological University
Bachelor of Technology - Informa9on Technology
Jawaharlal Nehru Technological University