Headline

Data Analyst | SQL Server | Power BI | Advanced Excel | T-SQL | MBA Finance & Marketing

Location

Pune Division

AI stack

codex

opencode

Work experience

Software Engineer at Dyad, Jul 2024 - Jun 2026 · 2 yrs, Ahmedabad, Gujarat, India, Working on multi-MGA insurance platforms — PUMAA and Nexsure — handling policy lifecycle, endorsements, compliance workflows, and CRM operations. - Designed and developed complex T-SQL stored procedures for policy issuance, endorsements, and compliance workflows across multiple MGAs - Improved SQL query execution time by 25% through advanced T-SQL tuning and index optimization - Integrated JSON-based dynamic rate structures to onboard new MGA business lines - Contributed to Nexsure — enterprise P&C insurance platform (C#, ASP.NET, SQL Server, Entity Framework, Git) - Collaborated with QA and BA teams on requirements gathering, UAT, and Agile feature releases - Provided L1/L2 production support ensuring zero-downtime operations and 100% policy compliance Tech Stack: SQL Server, T-SQL, Stored Procedures, SSMS, JSON, C#, ASP.NET, Git, Jira

Executive Analyst at TTK HEALTHCARE LIMITED, Jul 2021 - Nov 2023 · 2 yrs 5 mos, PUNE,MUMBAI,NAGPUR,CHHATTISGARH, Handled territory MIS reporting, sales analytics, and distributor intelligence across 4 major markets covering 200+ outlets. - Built area-wise Power BI sales dashboards presented monthly to senior management — used for sales strategy, demand forecasting, and advertising decisions - Designed Advanced Excel MIS dashboards (Pivot Tables, VLOOKUP, Conditional Formatting) tracking daily/weekly/monthly KPIs across product lines and territories - Prepared market-wise and category-wise stock reports; tracked SKU performance and distributor stock velocity - Led and managed a field sales team of 8 people — joint market visits, KPI tracking, outlet-level compliance - Managed distributor relationships across 4 territories; identified slow-moving SKUs and flagged replenishment needs Tools: Power BI, Advanced Excel, Pivot Tables, VLOOKUP, MIS Dashboards

Executive Sales Representative at TTK HEALTHCARE LIMITED, Jul 2021 - Nov 2023 · 2 yrs 5 mos, Created area-wise Power BI sales dashboards and Advanced Excel MIS reports across 4 territories and 200+ outlets; data used by management for sales strategy, demand forecasting, and advertising campaign decisions. Prepared monthly market-wise and category-wise stock reports; tracked SKU performance, distributor stock velocity, and outlet-level KPIs including shelf visibility and display compliance. Led and managed a field sales team of 8 people; conducted joint market visits, tracked individual KPI performance, and ensured outlet-level compliance across all assigned territories. Managed distributor relationships across 4 territories; proactively identified slow-moving SKUs and flagged replenishment needs to reduce dead stock.

Digital Marketing Intern at Hindustan Unilever Ltd. (HUL), Aug 2020 - Nov 2020 · 4 mos, Mumbai, Maharashtra, India, - Assisted in digital campaign analytics and consumer data reporting for FMCG product lines - Tracked market performance metrics and supported brand management initiatives - Gained exposure to data-driven marketing strategies at one of India's largest FMCG companies

Market Research Analyst at Ekande's Foods, Jul 2020 - Aug 2020 · 2 mos

Social Media Marketing Intern at Rachana Group, Jun 2020 - Aug 2020 · 3 mos

Education

Department of Management Sciences (PUMBA), Savitribai Phule Pune University

Bachelor of Science - BS, Chemistry, Sir Parashurambhau College - India