Data Analyst Power Bi

Richa Harne

Email: ************@*****.*** Mob. +91-913*******

github.com/RichaHarne1

Professional Summary

Detail-oriented Data Analyst with hands-on experience in SQL, Python, Power BI and Excel for data cleaning, transformation, visualization and reporting. Skills in building dashboards, writing optimized SQL queries (Joins, CTEs, Window Functions) and performing exploratory data analysis (EDA) to generate actionable business insights. Work Experience

Programming & Query Languages: SQL, Python (Pandas, NumPy) Databases: Oracle, SQL Server, MySQL, PostgreSQL

Visualization & Reporting: Power BI, Excel (Advanced formulas, Pivot Tables, Power Query) Tools & Technologies: Jupyter Notebook, SSMS, GitHub, Jira, Postman, Linux OS Data Analytics Skills: Data Cleaning, Data Transformation, & Reporting, EDA, Reporting & Dashboards, KPI Analysis, Statistical Analysis

Work Experience

IntelliPaat Remote/India Dec 2024 – Aug 2025

Data Analyst Intern

• Applied SQL to analyse datasets, writing optimized queries (Joins, CTEs, Window Functions) to extract key KPIs

• Conducted Order Data Analysis using Python (Pandas, NumPy) to identify top-selling products, revenue trends and customer purchase behaviour

• Built interactive dashboards in Power BI to visualize data for decision making Krios Info Solutions Pvt. Ltd., Pune Aug 2021 – Dec 2023 MuleSoft Developer

• Developed and optimized SQL queries, stored procedures and functions, improving data retrieval

• Built and maintained relational database schemas ensuring 99% data accuracy across ERP

& CRM integrations

• Implemented automation workflows using Mulesoft & SkyVia, reducing manual data processing by 25%

• Designed flow of an automation, created several filters using SQL Eco-Valet Pvt Ltd, Pune Dec-2019 – May 2021

PHP Developer

• Developed a Digital Parking Management System, improving real-time tracking and system uptime

GramenSon Engineering Solution Pvt Ltd, Amravati Oct 2018 - Oct 2019 Web Developer

• Designed and deployed responsive client websites, improving user engagement

• Built scalable web applications with optimized database queries for better performance Education

Amravati University Aug 2011 - Jun 2015

B.E. in Computer Science CGPA: 7.48/10

Project Work

Healthcare SQL Analytics Project SQL, MS SQL Server

• Designed and executed complex SQL queries on healthcare appointment data (joins, CTEs, window functions).

• Identified patients with multiple doctors, frequent no-shows and appointment trends. Order Data Analysis Project Python, SQL

• Extracted and aggregated order records using SQL to calculate top products, revenue per region and repeat customer behaviour.

• Built Python scripts for data cleaning, exploratory data analysis (EDA).

• Delivered insights on top 5 selling products per region Awards and Certificates

• MuleSoft Certified Developer (MCD) – Level 1

Contact this candidate