May 2023 – Jan 2025 · 1 yr 8 mos · Gurugram, Haryana, India · On-site

• Solving Quick Commerce problems through Data

Aug 2022 – May 2023 · 9 mos · Gurugram, Haryana, India

• Helping teams make better and insightful decisions using Data

Sep 2021 – Aug 2022 · 11 mos · Gurugram, Haryana, India

• Worked on interactive Cohort analysis report using SQL & Tableau for product team with global filters & parameters that helped improve customer retention by 15%.
• Performed Segmentation of Retail Customers based on demographics & purchase behavior using
• K-Means Clustering and RFM Model to identify Low, Mid, and High-end customers & devise marketing strategies for each segment. Also identified the % Product penetration for different customer range & their Cross-sell ratio.
• Created Workforce Utilization Report for Stores using Python identifying 60-80 stores for potential consolidation & shift reduction resulting in saving of 5,123 monthly hours and annualized savings of $ 1.2 Million.
• Built out the data & reporting infrastructure from the ground up using Tableau & SQL to provide real-time insights into the product, marketing channels & business KPIs. This also reduced manual Reporting by 5 hours weekly.

Jan 2021 – Aug 2021 · 7 mos

• Role entitles taking part in brainstorming sessions with domain expert team, documenting business workflows for stakeholder review, and participating in requirements meetings & data mapping sessions to understand business needs.
• Submitted analytics-backed solution for Netherlands Coax project (having GIS data in JSON format) using Python, performing cost-benefit analysis which leads to a decrease in the total cost of Coax Infrastructure Network by 20%.
• Responsible for managing databases, adding features to Metadata, and developed DB objects, including tables, views, and packages using SQL.
• Revised, modularized, and updated old code bases to modern development standards in C# Dot Net, reducing operating costs and code length by 20%, thus boosting performance.

Jun 2018 – Dec 2020 · 2 yrs 6 mos

• Successfully completed and delivered YVW upgrade task, taking complete ownership of integration & testing of upgraded interfaces for Product Release 3. Managed the database using Oracle SQL, adding necessary features to the Metadata and creating SQL Triggers and Packages according to customer requirements.
• Revised, modularized and updated old code bases to modern development standards in C# Dot Net, reducing operating costs. Awarded POB (Pat on Back) for exceptional performance in whole project completion.
• Consistently met deadlines and requirements for all production work orders. Adjusted software parameters to boost performance and incorporate new customized features.

Jun 2016 – Aug 2016 · 2 mos · Gurgaon, India

• Job Role described increasing brand awareness through targeted initiatives and searching potential customers and areas to expand into.
• Managed database of 1000+ various partner cafes & restaurants, performed analysis using EXCEL to study transactions through app. Assessed KPIs to achieve in-depth understanding of campaign performance.