In my spare time, I enjoy listening Music and also go for Trekking because it keeps me fit, challenges my physical limits and strengthen me to do task in any condition
JAGRUTI NANEPAG
Pune,MH
Summary
Experienced Data Analyst with 1.5 years of experience in gathering, processing, and interpreting large data sets. Proficient in Python, SQL, Power BI, and data modeling to deliver clear and actionable insights. Skilled at translating complex business requirements into technical solutions and driving data-driven decision-making through impactful analysis.
Overview
1
1
years of professional experience
Work History
Data Analyst
Bharat Software Solutions
Pune, MH
11.2024 - Current
- A streamlined client questionnaire process was established that reduced scope creep by 15% and improved project delivery efficiency by 20% in the first quarter.
- Developed 10+ interactive Power BI dashboards that provided actionable insights to clients in retail and finance, thereby increasing data-driven decision-making by 20%.
- Conceived and optimized 12 SQL queries to support new Power BI dashboards; delivered a 95% on-time completion rate for ad hoc data requests, improving customer satisfaction scores.
- Leveraged advanced Excel functionalities, such as macros, pivot tables, and VLOOKUP, to assist teams in rapid decision-making processes.
- User feedback from 50+ customer interviews was analyzed to identify and resolve the top three causes of crashes, reducing critical incident reports by 15% per quarter.
- Provided senior management with data insights that identified gaps in the current data infrastructure, which resulted in a revamp of data quality control measures and a 25% increase in team efficiency.
Data Analyst Intern
Bharat Software Solutions
Pune, MH
08.2024 - 10.2024
- Designed a KPI library covering 50+ unique job roles, developing a data-driven framework to objectively assess performance metrics aligned with business goals, eliminating 100% of subjective KPIs.
- Conducted data-backed role-mapping analysis for 70+ employees, redesigning processes that reduced turnaround times by 50% through workflow optimization.
Data Operator, Freelancer
Rubicon Pvt. Ltd
Pune, MH
06.2024 - 07.2024
- Develop and generate regular and ad-hoc reports for management and stakeholders.
- Assist in data analysis and interpretation to support decision making processes.
- Train new employees on data entry protocols and software usage.
Education
Master's - Computer Application (Data Science)
Ajeenkya DY Patil University
12.2025
Bachelor - Computer Application
Savitribai Phule Pune University
05.2024
Skills
- Power BI
- SQL
- Python
- NumPy
- Pandas
- Advanced Excel
- Data Visualization
- KPI Design
- Dashboard Development
- Reporting
- Root Cause Analysis
- Competitor Analysis
- Machine Learning
Personal Information
Title: Data Analyst
Certification
Completed hands-on training in Data Analysis and Dashboard Development using Power BI, Python, SQL, and Advanced Excel form Seven Mentor , Pune
Interests
Timeline
Data Analyst
Bharat Software Solutions
11.2024 - Current
Data Analyst Intern
Bharat Software Solutions
08.2024 - 10.2024
Data Operator, Freelancer
Rubicon Pvt. Ltd
06.2024 - 07.2024
Master's - Computer Application (Data Science)
Ajeenkya DY Patil University
Bachelor - Computer Application
Savitribai Phule Pune University