Data Analyst - SQL, Python, BI, Analytics Excellence

Bhargavi Prodduturi Data Analyst

********@***********.*** 201-***-**** U S A LinkedIn

Summary

Data Analyst with 3+ years of experience delivering analytics solutions in consulting and financial environments. Skilled in advanced SQL, Python (Pandas), and BI tools to support KPI tracking, A/B testing, and data-driven business decisions. Experienced in collaborating with cross-functional stakeholders to translate business requirements into scalable reporting and data modeling solutions. Technical Skills

Analytics & Programming: SQL (CTEs, Window Functions, Query Optimization), Python (Pandas, NumPy), R, Customer Lifecycle Analysis, KPI & Product Analytics, Dimensional Modeling

Data Visualization & Reporting: Power BI (DAX, KPI Dashboards, Drill-through), Tableau (LOD, Parameters), Excel (Advanced Formulas, Pivot Tables, XLOOKUP, INDEX/MATCH, Data Modeling)

Data Management & Cloud: Azure Data Factory, AWS (Athena, S3), dbt, Snowflake

Statistical Techniques: Regression, Forecasting, Hypothesis Testing, A/B Testing, Time-Series Analysis

Collaboration & Tools: Git, Jira, Confluence, Agile Professional Experience

Data Analyst, Mercer 05/2024 – Present Remote, USA

Optimized SQL-based reporting workflows in AWS Athena, improving dashboard refresh speed by 30% and enabling timely workforce planning decisions.

Automated Python-driven data cleaning and transformation for 100K+ records, reducing manual reporting effort by 40% and accelerating HR analytics cycles.

Queried cloud-based data warehouses including AWS Athena and Snowflake to analyze large structured datasets.

Built KPI dashboards in Power BI to track user engagement, operational performance, and business impact metrics for cross- functional stakeholders.

Conducted hypothesis testing and trend analysis to identify performance drivers and improvement opportunities across business operations.

Partnered with HR and DEI stakeholders to define KPIs and standardize reporting metrics, improving dashboard clarity and cross-department alignment by 20%.

Gathered and documented business and reporting requirements in collaboration with cross-functional stakeholders.

Maintained documentation including data dictionaries and process flows to ensure transparency and governance. Associate Data Analyst, S&P Global 01/2022 – 12/2023 Hyderabad, India

Developed optimized SQL queries and automated pipelines to support financial market reporting, reducing ETL latency by 35% and improving data reliability.

Analyzed large-scale financial datasets to identify performance trends, risk indicators, and business growth opportunities.

Automated large-scale data ingestion processes for 2M+ records using Python, reducing manual preparation time by 40%.

Built Tableau dashboards to monitor financial KPIs, portfolio performance metrics, and customer behavior trends for executive leadership.

Performed deep-dive analyses using SQL and Python to uncover drivers of sector performance and inform strategic investment decisions.

Strengthened reporting integrity by implementing automated validation checks, achieving 98.5%+ data accuracy.

Collaborated with cross-functional Agile teams to refine KPI definitions and reporting deliverables, improving project transparency and delivery efficiency by 22%.

Education

Sacred Heart University — Fairfield, CT, USA

Master’s Degree Computer and Information Science 01/2024 – 03/2025 TKR College of Engineering and Technology — Hyderabad, India Bachelor of Engineering Computer Science 08/2019 – 04/2023

Contact this candidate