Data Analyst Power Bi

Apoorv Pandkar

Dallas, TX 704-***-**** *************@*****.*** LinkedIn GitHub

PROFESSIONAL SUMMARY

Versatile and results-oriented Data Analyst with 4+ years of experience transforming complex healthcare and business data into impactful insights to drive operational efficiency and strategic outcomes. Adept at SQL query optimization, data visualization with Power BI and Tableau, and scripting in Python for automation and analysis. Proven ability to build cloud-integrated pipelines and dashboards using Azure Synapse, GCP Big Query, AWS, and Snowflake. Skilled in stakeholder communication, KPI reporting, and leveraging tools like Power Apps & Automate, and Apache Airflow to streamline workflows and enhance decision-making.

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst, Parallon HCA Healthcare – Dallas, TX 2022 – Present

• Developed and integrated hospital datasets from systems like eClinicalWorks, Valesco, Epic, etc., using SQL and GCP Big Query, enabling unified reporting structures and enhanced visibility across the revenue cycle.

• Developed complex SQL queries and performance-optimized views to support executive reporting and saved millions through effective resource utilization and using Python to automate tasks, reducing manual work by 80%.

• Created trigger-based alerting systems and automated refresh schedules for critical datasets, ensuring real-time access to high-impact metrics and facilitating timely action across financial and clinical teams.

• Created and deployed SQL stored procedures in SQL Server Management Studio (SSMS) to streamline complex data transformations, which were directly used in Power BI reports and supported automated daily data refresh schedules for near real-time decision-making.

Data Analyst, Deloitte Consulting LLP – Dallas, TX 2021 – 2022

• Streamlined ETL pipelines using Apache Spark and Snowflake to consolidate disparate marketing datasets, reducing data processing time and accelerating time-to-insight by 35%, which enabled quicker campaign adjustments and improved customer targeting strategies.

• Designed automated reporting solutions in Python and Apache Airflow, saving 2+ hours weekly per report.

• Created Tableau dashboards for executive use and ensured accurate delivery of business-critical metrics.

• Enhanced data workflows in Azure Synapse, reducing processing time by 10% and increasing team productivity. Associate Data Analyst, Accenture – Pune, India 2017 – 2019

• Analyzed financial datasets for risk assessment and loan approval trends, supporting business decision-making.

• Developed high-accuracy reports using SSRS and Power BI, achieving 90% data reliability.

• Built Tableau dashboards for budget forecasting and implemented SQL performance improvements with CTEs, improving query efficiency by 65%.

• Executed data migration projects using SQL scripts, reducing system errors by 12%. EDUCATION

Master of Science in Data Science and Analytics, New England College, NH 2024-2026 (Expected) Master of Science in Computer Science, University of Texas at Arlington, TX 2019 – 2021 Bachelor of Engineering in Computer Science, University of Pune, India 2013 – 2017

Contact this candidate