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.
