Power Bi Data Analyst

Mahendrakumar Chaudhari St. Louis, MO • 314-***-****

• ********************@*****.*** • LinkedIn • GitHub • Power BI & Tableau Projects

Data Analyst with 4+ years of experience in data analytics, business intelligence, and data engineering. Skilled in SQL, Power BI, Excel, Python, and Microsoft Fabric, with expertise in data modeling, KPI analysis, data governance, and ETL pipeline optimization. Proven track record of building scalable data pipelines (+25% efficiency), automating dashboards (-15% manual effort), and delivering actionable insights. Certified in Microsoft Azure Data Engineering and Power BI.

WORK EXPERIENCE

Data Analyst Propper International Mar 2024 – Mar 2025

St. Charles County, Missouri, United States

•Architected scalable data pipelines using Azure Data Factory and Databricks, reducing processing time by 25% and saving $8K/year.

•Engineered 15+ Power BI dashboards to track sales/finance KPIs, automating 85% of manual reporting.

•Led data governance initiatives, implementing validation frameworks that reduced errors by 30%.

•Collaborated with finance to build real-time budgeting tools, improving forecast accuracy by 20%.

Supply Chain & Operations Analyst Anantam Impex July 2021 – June 2022

Ahmedabad, Gujarat, India

•Optimized inventory management using SQL and Tableau, reducing excess stock by 15% without impacting availability.

•Built dynamic Tableau dashboards, slashing report generation time from 8 hours to 2 hours/week.

Monitored team performance and managed Agile operations, consistently achieving sprint objectives and improving on-time product delivery by 20%.

PROJECTS

Real-Time Earthquake Data Analysis with Microsoft Fabric & Power BI Apr 2025- June 2025

Ingested real-time earthquake data from the USGS API and processed JSON feeds using PySpark in Microsoft Fabric, implementing a medallion architecture (Bronze Silver Gold) for efficient data transformation.

Developed ETL pipelines to clean, filter, and aggregate seismic data, reducing processing time by 30% compared to manual methods.

Created an interactive Power BI dashboard to visualize global earthquake trends, identifying high-activity regions (e.g., Greece – 1,132 events) and enabling real-time monitoring.

Demonstrated expertise in real-time data analytics, cloud-based ETL, and geospatial data visualization, with applications in risk assessment and disaster response.

GitHub: Project Link

Azure Data Engineering Project – Adventure Works Data Pipeline Feb 2025 - Feb 2025

Designed and implemented a data pipeline on Azure using Data Factory, Databricks, and Synapse Analytics to analyse sales, customer demographics, and product performance.

Built a centralized data warehouse in Azure Synapse, enabling efficient querying and detailed processing of transformed data.

Developed an interactive Power BI dashboard to visualize KPIs, empowering stakeholders with data-driven decision-making capabilities.

Mortgage Payback Analytics Apr 2024 - May 2024

Developed predictive models (Logistic Regression, Naïve Bayes) to classify mortgage default stages, achieving 86.38% sensitivity.

Built regression models (Linear Regression) to predict outstanding loan balances, achieving an RMSE of 2.97.

Performed cluster analysis (K-means) to segment borrowers into risk groups, enabling targeted risk management strategies.

Olympics Data Analysis Using SQL and Spark Aug 2023 - Sep 2023

Ingested and processed large-scale Olympics data using Azure Data Factory and Databricks, enabling efficient ETL workflows.

Developed Power BI dashboards to visualize key trends, supporting data-driven decision-making.

Instant Noodles Consumption Analysis using Azure & Power BI Mar 2023 - Apr 2023

Built data pipelines in Azure Databricks to ingest and transform global consumption data.

Designed interactive Power BI dashboards with DAX calculations, enabling stakeholders to explore consumption trends.

TECHNICAL SKILLS, AND EXPERTISE

Databases: SQL Server, PostgreSQL, Snowflake, Google BigQuery

Cloud & Big Data: Azure (Synapse, Data Factory, Databricks), AWS (S3, Redshift), Delta Lake

BI & Visualization: Power BI (DAX, Power Query), Tableau, Excel (Advanced)

Data Science: Python (Pandas, PySpark, Scikit-learn), Regression/Classification (86% model accuracy)

Tools: Git, Docker, JIRA, Apache Airflow (basic), CI/CD pipelines

Methodologies: Agile/Scrum, Data Warehousing, UAT Testing, Root Cause Analysis, Statistical Analysis

CERTIFICATION

Microsoft Azure for Data Engineering (Microsoft)

Power BI Data Modeling with DAX (LinkedIn Learning)

Power BI: Dashboards for Beginners (LinkedIn Learning)

Excel: Dashboards for Beginners (LinkedIn Learning)

Data Ethics: Making Data-Driven Decisions (LinkedIn Learning)

.

EDUCATION

Webster University, St Louis, MO, USA MS in Data Analytics (3.62) Graduated 2024

Sardar Patel University, Anand, Gujarat, India BS in Mathematics Graduated 2018

Contact this candidate