JAGRUTI NANEPAG
Data Analyst
Pune,MH
Summary
Experienced Data Analyst with 2 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
year of professional experience
Work History
Data Analyst
Bharat Software Solutions
Pune, MH
03.2025 - 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
11.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.
Research Development - Intern
Findem Technologies
08.2024
- Researched and analyzed professional profiles on LinkedIn to gather business and workforce intelligence.
- Collected, cleaned, and validated data from multiple sources, ensuring high data quality and accuracy.
Data Operator, Freelancer
Rubicon Pvt. Ltd
Pune, MH
06.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)
05.2024
Bachelor of Computer Application - undefined
06.2022
Skills
- Power BI
- SQL
- Python
- MySQL
- Pandas
- NumPy
- Advanced Excel
- Git/GitHub
- Data Analysis
- Data Cleaning
- Data Validation
- Exploratory Data Analysis (EDA)
- Data Visualization
- KPI Design
- Dashboard Development
- Reporting
- Root Cause Analysis
- Trend Analysis
- Statistical Analysis
- SQL Query Optimization
- Joins
- CTEs
- Window Functions
- Data Modeling
- ETL Development
- Data Transformation
- Business Intelligence Reporting
- Data Storytelling
- Performance Monitoring
- Sales Analysis
- Customer Analysis
- Competitor Analysis
- Business Performance Analysis
Projects
- Essies Ltd Product & Retail Sales Analysis, Power BI, Designed and automated product performance dashboards using Power BI, enabling real-time tracking of top-selling items and promotional effectiveness, resulting in identification of 5 underperforming products., Developed 3+ Power BI dashboards to track top-selling products, customer behavior, and promotions, leading to a 15% sales increase.
- Exploratory Data Analysis on Diverse Datasets, Python(Jupyter Notebook), Extracted and cleaned 10+ diverse datasets using Pandas and NumPy, reducing data errors by 15% and improving reporting accuracy., Analyzed data from various fields to identify relationships and create dynamic visual representations.
- SQL Data Exploration, MySQL, Wrote complex queries to find attrition trends, average salaries, and department-wise performance., Used count, group by, joins and rank function, str_to_date() functions and joined multiple tables.
Timeline
Data Analyst - Bharat Software Solutions
03.2025 - Current
Data Analyst Intern - Bharat Software Solutions
11.2024
Research Development - Intern - Findem Technologies
08.2024
Data Operator, Freelancer - Rubicon Pvt. Ltd
06.2024
Ajeenkya DY Patil University - Master's, Computer Application (Data Science)
Savitribai Phule Pune University - Bachelor of Computer Application,