Power Bi Data Analyst

Pranay Parsawar

Associate Consultant

****************@*****.*** +91-983******* linkedin.com/in/pranay-parsawar SUMMARY

A detail-oriented Power BI Developer with 3+ years of experience in data visualization and analytics. Strong expertise in designing dashboards, data modeling, and optimizing Power BI performance. Skilled in SQL, DAX. Adept at optimizing SQL queries, stored procedures, data models and creating automated reporting solutions to improve decision-making processes. PROFESSIONAL EXPERIENCE

Associate Consultant, Atos Pvt. Ltd. 2022 – present Pune, India

•Developed 20+ Power BI dashboards, increasing reporting efficiency by 30% and reducing data processing time by 25%.

•Collect, clean and interpret large datasets from multiple sources (SQL Server,,Excel, Cloud) into Power BI using Power Query, ensuring seamless data transformation and analysis.

•Utilized stored procedures in SQL to enhance database efficiency and streamline query execution.

•Collaborated with business stakeholders to gather reporting requirements to define KPIs and data- driven strategies.

•Built complex data models using DAX to support advanced analytics and KPIs, resulting in improvement in data- driven business decisions.

•Automated ETL processes and data refreshing in Power BI, reducing manual intervention by 40%.

•Worked alongside cross-functional teams to ensure data accuracy and timely delivery of business reports.

Data Analyst Intern, Med Tour Easy 05/2024

•Collaborated with a project mentor to conduct hands-on data analysis.

•Developed insights on user engagement and workout patterns from fitness datasets.

•Created visual reports for Analysis of Fitness Data project to effectively communicate findings and recommendations.

SKILLS

Data Warehousing

Data modeling, Star Schema, Snowflake

Schema

Power BI

ETL, Data Modelling, DAX, Power Query,

Report & Dashboard Design

Excel for Data Analysis

Pivot tables, Creating charts, VBA

SQL for Data Science

Data Warehousing, ETL/ELT process

Power BI Service Databases

SQL Server, MySQL

CERTIFICATES

SQL for Data Science

Coursera

Excel Skills virtual Experience Program

JP Morgan Chase & Co.

Google Data Analytics

Coursera

Power BI Data Analyst

Microsoft PL-300

EDUCATION

Bachelor of Engineering,

G. H. Raisoni college of Engineering

2017 – 2021 Nagpur, India

8.50/10

DECLARATION

I solemnly declare that all the above information is correct to the best of my knowledge and belief. Pranay Sudhir Parsawar

Contact this candidate