Data Analyst Power Bi

Bhavya Setia

413-***-**** • ******@*****.*** • Bhavya Setia - Linkedin • Github • Boston, MA

EXPERIENCE

Commonwealth of Massachusetts MA, United States

Data Analyst Intern 01/2025-Present

• Engineered an Excel-integrated financial tracking system using SQL, Power BI, and Pivot Tables, reducing manual data consolidation by 35% and enhancing budget allocation insights for 15+ agencies.

• Developed Power BI dashboards with SQL and Power Query, providing real-time variance analysis to finance teams, enabling data-driven decisions that optimized $5M in fund distribution.

• Designed and delivered ad-hoc Power BI reports for sales teams, reducing manual tracking of lead conversions and enabling faster, data- backed pipeline reviews — cutting turnaround time by 40%.

• Evaluated 50+ vendor contracts and usage to ensure pricing alignment with benchmarks, improving cost consistency and compliance. Go See the City FL, United States

Data Analyst Intern 06/2024-12/2024

• Constructed an interactive Tableau dashboard with SQL pipelines, giving marketing real-time insights and cutting reporting delays by 40%.

• Optimized SQL indexing and Power BI data models, accelerating business reporting by 25% and improving executive decision-making.

• Automated compliance tracking in Python, reducing audit review time by 35% while ensuring data accuracy for regulatory reporting. Ernst & Young HR, India

Data Analyst 06/2021-06/2023

• Custom-built SQL-based risk analysis models for a $2B+ healthcare client, enabling compliance teams to identify discrepancies faster and improve regulatory reporting efficiency by 30%.

• Integrated predictive analytics dashboards in Power BI with SQL-based forecasting, enabling risk teams to mitigate financial risks by 18%.

• Collaborated with vendor management and procurement teams to analyze supplier performance metrics, improve contract compliance, and streamline reporting on vendor-related KPIs — enabling data-driven decisions across sales and operations. Gainops DL, India

Data Engineer 05/2020-05/2021

• Implemented Row-Level Security in Power BI dashboards to ensure data integrity and role-based access, enabling ops teams to self-track order fulfillment and SLA KPIs, reducing IT reporting requests by 35%.

• Enhanced SQL-based ETL workflows, accelerating data processing by 40% and improving operational reports accuracy.

• Implemented automated Excel tracking systems with SQL-driven real-time data refresh, reducing manual validation by 25%. Sag Health Science Pvt Ltd DL, India

Financial Analyst Intern 01/2019-08/2019

• Built Power Query dashboards to visualize monthly burn and forecasts, cutting budgeting errors by 15% and boosting cash flow visibility.

• Standardized financial reconciliation frameworks, automating Excel-based variance analysis and reducing manual review efforts by 25% while ensuring regulatory compliance.

• Monitored inventory cost trends and flagged pricing inconsistencies across product SKUs, supporting procurement teams in QBRs. SKILLS

• Data Analysis & Business Intelligence - SQL (DML, DDL, Query Optimization), Power BI (DAX, M Query), Tableau, KPI Reporting, A/B Testing

• Data Management & Automation- SQL-based ETL Pipelines, Data Modeling, Excel (Pivot Tables, VLOOKUP, Macros, Power Query), Python

• Process Optimization & Project Management- Compliance & Risk Reporting, Real-time Dashboards & Ad-hoc Reporting, Agile, JIRA, Cross- Functional Collaboration, Data Storytelling & Process Automation, Business Reporting PROJECTS

Financial Performance and KPI Dashboard

• Engineered a financial performance tracking system using Excel, SQL, and Power BI, automating KPI reporting and eliminating 35% of manual reconciliation efforts, providing real-time insights for leadership.

• Designed and deployed a variance analysis dashboard in Power BI, integrating SQL-based financial datasets to pinpoint inefficiencies in budget allocations, leading to a $5M fund optimization.

• Automated financial reporting workflows using Excel Macros, SQL, and Power Query, optimizing cross-functional decision-making by 40%. EDUCATION

• University of Massachusetts, Amherst

Master of Science in Business Analytics 09/2023-12/2024 Relevant coursework: Business Intelligence, Risk Analytics, Data Visualization, Advanced SQL, Financial Modeling

• Jesus and Mary College, University of Delhi

Bachelor of Commerce (Honors) 07/2017-08/2020

Relevant coursework: Financial Accounting, Business Statistics, Financial Modeling, Market Research, Econometrics, Risk Management CERTIFICATIONS

• Microsoft Power BI Data Analyst Associate (PL-300), Tableau Desktop Specialist

Contact this candidate