Data Analyst Intern-SQL, Python, Power BI, Excel

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, exploratory data analysis (EDA), and dashboard development. Strong expertise in writing optimized SQL queries (Joins, CTEs, Window Functions), KPI tracking, and business intelligence reporting. Proven ability to deliver actionable insights that improve operational efficiency and decision-making Technical Skills

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

Data Visualization & BI: Power BI (DAX, Data Modeling), Excel (Advanced formulas, Pivot Tables, Power Query) Analytics & Reporting: EDA, Data Cleaning, KPI Analysis, Statistical Analysis, Reporting Automation Tools: Jupyter Notebook, SSMS, GitHub, Jira, Postman, Linux Work Experience

IntelliPaat Remote/India Dec 2024 – Aug 2025

Data Analyst Intern

• Analyzed 50K+ records using optimized SQL queries (Joins, CTEs, Window Functions) to extract key business KPIs

• Performed order data analysis using Python (Pandas, NumPy) to identify top-selling products, revenue trends, and customer purchase behavior

• Built interactive Power BI dashboards reducing manual reporting effort by 30% Krios Info Solutions Pvt. Ltd., Pune Aug 2021 – Dec 2023 MuleSoft Developer

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

• Designed and maintained relational database schemas ensuring 99% data accuracy across ERP & CRM integrations

• Automated workflows using MuleSoft & Skyvia, reducing manual data processing by 25%

• Created SQL-based filters and automation flows for enterprise-level integrations Eco-Valet Pvt Ltd, Pune Dec-2019 – May 2021

PHP Developer

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

• Optimized backend database queries to enhance system performance 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 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 Education

Amravati University Aug 2011 - Jun 2015

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

Awards and Certificates

• MuleSoft Certified Developer (MCD) – Level 1

Contact this candidate