BI Analyst with Power BI, SQL, excel, data modeling, power query

Priyanka Naikwadi

91+762******* / 932-***-**** Mail - ********.************@*****.***

Objective:

Results-driven Data and Business Analyst with 3.6+ years of experience in analyzing large datasets and delivering actionable insights. Proficient in Advanced Excel, SQL, Power BI, Python and DAX, with a strong focus on creating interactive dashboards and data visualizations to support data-driven decision-making. Seeking to leverage my expertise in data analysis and visualization to drive organizational growth and efficiency. Technical Skills:

• Programming Languages : Python, SQL

• Data Visualization Tool : Power BI, MS Excel, Tableau

• Databases : SQL Server

• Microsoft Office : Advanced Excel, Power Point Presentation, MS Word

• Python Libraries : Pandas, NumPy, Seaborn, Matplotlib

• Additional Skills : Statistics, DAX, Data modeling, Data Cleaning, Business Analysis, Google Sheet, ETL, Dashboard, Business KPI, business KPI, Power Query, M Language

• Soft Skills : Project Management, Problem Solving, Time Management Technical Summary:

• Proficient in creating and maintaining interactive dashboards in Excel and Power BI, using customized charts, KPIs, and DAX for advanced analysis.

• Experienced in analyzing BI needs, interpreting business requirements, and delivering actionable insights through tailored reports and visualizations.

• Skilled in data analysis, modeling (Star/Snowflake schemas), and developing logical and physical models for efficient reporting.

• Proficient in developing SQL scripts to validate database tables and report data using DML and DDL commands for database testing.

• Adept at building and enhancing dashboards, reports, and applications to support strategic business objectives. Professional Experience:

IDmission Solution Pvt. Ltd Dec 2021 – July 2025

Power BI Developer

• Designed and maintained interactive dashboards using Excel and BI tools to monitor key performance indicators (KPIs), enhance operational efficiency, and support data-driven decision-making.

• Developed comprehensive business reports analyzing customer behavior, market trends, and overall performance to inform strategic initiatives.

• Automated and consolidated multiple reports using Tableau, SQL, and Power Query, leading to a 30% boost in efficiency by removing redundancies and streamlining workflows.

• Created and delivered data-driven presentations summarizing critical insights to senior management and stakeholders for informed decision-making.

• Identified and resolved data inconsistencies, conducted root cause analysis, and implemented process improvements to enhance data quality and integrity.

• Collaborated cross-functionally with business operations teams to gather requirements and design tailored dashboards that addressed specific operational needs.

• Actively engaged in business meetings to align with stakeholders, review project milestones, and address delivery.

Key Projects:

Client: Standard Chartered Bank – Retail Banking, Asia Pacific Project Skills: MS-SQL, Power BI, Python

• Delivered end-to-end reporting of key performance indicators (KPIs) through automated daily, weekly, monthly, and quarterly reports.

• Collaborated with upstream/downstream teams to validate data integrity and optimize report accuracy.

• Led process improvements by retiring redundant reports and centralizing critical KPIs into unified dashboards for stakeholders.

• Built new dashboards and scorecards from scratch, tailored to specific country teams (especially Hong Kong), using Power BI.

• Performed ad-hoc analyses to support regional strategies and regulatory compliance.

• Mentored associate programmers and contributed to team capability building. Client: Herbalife Nutrition – Product Intelligence Division Project Skills: MySQL, Power BI, DAX, Data Modeling, Python

• Spearheaded the development of real-time analytical dashboards for newly launched health and wellness products across global markets.

• Extracted and transformed data from MySQL databases and built semantic models using Power BI with complex DAX measures, calculated columns, and time intelligence functions.

• Analyzed product performance across 4 major product categories and 37 sub-categories to identify unit sales trends, geographic demand variance, and consumer preferences.

• Created reference tables and lookup models in DAX to streamline filtering, relationships, and KPI calculations across dashboards.

• Enabled business leaders to make data-driven decisions by providing dynamic product performance insights, improving response time to market trends by 40%

• Collaborated closely with product marketing and finance teams to ensure alignment of data models with business objectives.

Education:

Master of Computer Applications (MCA) — Savitribai Phule Pune University — 2023 Bachelor of Computer Science (B.Sc.) — Savitribai Phule Pune University — 2021

Contact this candidate