Dipali Vagare

Results-driven Data and Business Analyst with 5.1+ years of experience in analyzing large datasets, developing data models, and delivering actionable business insights. Proficient in SQL, Power BI, Python (pandas, NumPy, matplotlib, seaborn), Advanced Excel and Power Automate with expertise in designing interactive dashboards and visualizations to support strategic, data-driven decision-making. Skilled in requirement gathering, data validation, and automation, with a strong record of collaborating with cross-functional teams and global stakeholders.

Data Analyst - Sofrego Private Limited

(2024-09)

Client: Nutrilite–Product Intelligence Division Role: Product Analyst Project Skills: MySQL, PowerBI, DAX, Data Modeling, Python

• Spear headed the development of real-time analytical dashboards for newly launched health and wellness products across global markets.
• Extracted and transformed data from SQL Server databases and built semantic models using PowerBI with complex DAX measures, calculated columns, and time intelligence functions.
• Analyzed product performance across 4 major product categories and 37 sub-categories to identify unit sales trends, geographic demand variance, and consumer preferences.
• Created reference tables and lookup models in DAX to streamline filtering, relationships, and KPI calculations across dashboards.
• Enabled business leaders to make data-driven decisions by providing dynamic product performance insights, improving response time to market trends by 40%.
• Collaborated closely with product marketing and finance teams to ensure alignment of data models with business objectives.

Associate - Amazon Development Centre

(2024-05 - 2024-09)

• Collaborated cross-functionally with internal teams during high-volume periods to ensure seamless operations and prompt issue resolution.

Data Analyst - JDIT Software Solutions Pvt. Ltd.

(2021-03 - 2024-05)

Client: Cigna Healthcare, Claims & Policy Analytics Role: Data Analyst Project Skills: MS-SQL, Power BI, Excel, Python (pandas, seaborn, matplotlib)

• Built interactive dashboards in Power BI to analyze claim settlement timelines, fraud detection patterns, and customer demographics, enabling stakeholders to track performance in real time.
• Automated consolidation of policy lapse, renewal, and premium collection reports using SQL stored procedures and Power Query, improving reporting efficiency by 30%.
• Applied Python pandas for data wrangling and validation, identifying data inconsistencies and ensuring integrity across multiple source systems.
• Developed visual analytics using matplotlib & seaborn to detect anomalies in claims data, supporting fraud prevention strategies.
• Delivered data-driven presentations and quarterly businessreviews (QBRs) to leadership teams, helping optimize customer experience and reduce claim processing time.

Data Analyst - JDIT Software Solutions Pvt. Ltd. - North America

(2021-03 - 2024-05)

Client: General Motors, Automotive Analytics, North America Role: Data Analyst Project Skills: MS-SQL, Power BI, Excel, Python (pandas, NumPy, matplotlib, seaborn)

• Designed and developed Power BI dashboards to monitor vehicle performance, warranty claims, and defect trends across multiple model years.
• Utilized SQL queries to extract and transform large datasets from multiple sources, ensuring accuracy and consistency for business reporting.
• Conducted root cause analysis of recurring quality issues by applying Python (pandas, NumPy) for data cleaning, statistical analysis, and trend detection, helping engineering teams reduce defect recurrence by 18%.
• Automated weekly and monthly reporting workflows using Python scripts and Excel macros, reducing manual effort by 25% and increasing timeliness.
• Collaborated with globalstakeholders to align KPIs, integrate data pipelines, and provide actionable insightsthat improved operational efficiency.

Bachelor of Engineering - Information Technology - Pune Vidhyarthi Griha's College of Engineering, Pune (2017)