Power Bi Machine Learning

AKANKSHA PAWAR

Pune, India 880-***-**** Gmail LinkedIn Project Portfolio

Proficient in Data Visualization, Reporting, Dashboarding, and Insight Analysis with a Computer Science Engineering background. Hands-on experience in Python, SQL, Excel, Power BI, and Tableau, with 2 + years of experience in Power BI and MySQL. Strong analytical skills, decision-making, and problem-solving abilities with a proactive mindset. Dedicated to continuous learning and leveraging data-driven insights for business growth.

TECHNICAL SKILLS

Data Analysis: Proficient in Python (Pandas, NumPy, Seaborn), Excel, for data analysis and reporting.

Data Visualization: Experienced in creating dashboards and visual reports using Power BI and Tableau.

Database Management: Skilled in MYSQL, database design, and management.

Programming: Knowledge of Python for data manipulation, analysis, and machine learning (scikit – learn, matplotlib)

Statistics: Proficient in descriptive stats, probability, hypothesis testing, regression, and data distributions.

WORK EXPERIENCE

Software Engineer Hexaware Technologies, Pune 03/2022 – 03/2025

•Designed and developed interactive Power BI dashboards by performing thorough data cleaning, transformation, and modeling, leading to a 40% improvement in reporting efficiency for business users.

• Improved performance of MySQL queries by optimizing joins, filters, and indexes—reduced data loading time by 30%, making reports faster and more efficient.

•Built data models using star schema and Power Query to connect multiple tables, which made dashboards more reliable and easier to maintain.

•Designed and executed complex SQL queries to extract, filter, and summarize data for reporting and analysis—helped stakeholders get the right data without delays.

•Worked closely with senior developers, shadowing them to gain deeper insights into data modeling, query optimization, and best practices in database management.

PROJECTS

Power BI Developer PwC (Virtual Internship from Forage)

Created Call Centre analysis report which gives 3.4/5 average customer rating to see performance trends by setting KPI.

Designed Churn analysis report for 7043 customers, resulting 26.54% churn rate by using charts and DAX functions which helps in data-driven decision making to operability.

Developed Diversity & Inclusion report, harmonizing the workforce based on gender for 500 employees.

Book Store Analysis SQL

•Designed and managed a relational database using MySQL for books, customers, and orders.

• Executed SQL queries for data analysis using joins, subqueries, and aggregate functions.

• Analyzed insights on sales, customer behavior, and inventory management.

Heart Disease Analysis Python, Data Analysis, Machine Learning

• Analyzed key health factors (age, cholesterol, heart rate, blood pressure) to identify heart disease risks.

• Used statistical analysis and visualized trends using heatmaps and box plots.

• Built a machine learning model (Logistic Regression/Random Forest) to predict heart disease.

Cars Sales Analysis Tableau

•Performed YTD and YOY sales analysis using Python with calculated fields for total sales, average prices, and cars sold.

•Visualized trends using line charts, pie charts, and donut charts for body style and color analysis.

• Evaluated regional sales with bar charts, providing actionable insights for business decisions

Coffee Shop Sales Analysis MySQL and Power BI

• Performed data extraction, cleaning, and analysis using MySQL for actionable insights.

•Developed interactive dashboards in Power BI to visualize sales trends and store performance.

•Analyzed customer preferences and provided data-driven recommendations for business growth.

EDUCATION

Bachelor of Engineering in Computer Science 08/2018 – 04/2022

Zeal College of Engineering, Pune, Maharashtra

ACHIEVEMENTS

•Certified in Data Analytics by ETLHive - Project-based training in Python, SQL, Power BI, Excel, Tableau, and data modeling.

•Data Analyst Virtual Internship Deloitte (via Forage)

•Microsoft AZ – 900 Certification

Contact this candidate