Sep 2024 – May 2025 · 8 mos · Gurugram, Haryana, India

• Built an automatic filter recommendation system using SQL for all the landing pages in the fashion category that resulted in doubling of the CTR as compared to the regular adhoc banners.
• Devised a rule-based algorithm to detect potential fraudulent users and the application and preventing them from using certain features to prevent digital cards chargeback. This helped in reducing such chargeback requests by 90%.
• Built and leading the ads analytics team from the growth perspective. Work involves maintaining and updating the live reporting via dashboards and supporting the team with the relevant data.
• Developed a new system to forecast the number of views on every asset on the platform to better estimate the supply for Noon Ads.

May 2023 – Sep 2024 · 1 yr 4 mos · Gurugram, Haryana, India

• Led and developed the logic for keyword to category mapping for all the search keywords that are being searched on the app that helped all the categories better plan their assortment for key events.
• Leveraged SQL to build a up selling algorithm for the fashion category to help them target the relevant customers with the exact article that the customer might be looking for.
• Developed multiple trackers to fetch and report data on a live basis during peak events and sales such as the Yellow Friday Sale and Big Ramadan Sale.
• Utilized looker studio to create dashboards that are used to monitor search performance and user journeys on the platform. These powered multiple automated alerts and emailers related to potential interruptions in user experience.

Jul 2022 – Apr 2023 · 9 mos · Gurugram, Haryana, India

• Developed SAS codes and queries using data steps, SAS functions, SAS macros in conjunction with client specific macros to produce efficient reports.
• Planned and executed data migration from legacy platforms to new age technologies. Was also a part of the team responsible for upgradation of one of the existing data platforms.
• Awarded the "stellar performance" award for the work done for the insurance client.

Jan 2021 – Jul 2022 · 1 yr 6 mos · Gurugram, Haryana, India

• Acted as the single point of contact for a specialised type of motor insurance- telematics. Resolved a potential GDPR breach having an impact of ~£3 million.
• Motor fraud detection project that resulted in savings of ~£1 million and ensured compliance with the local law enforcement authorities.
• Involved in a POC project about bordereau process for an insurance client. Work involved processing raw data, cleaning it, summarising it and eventually preparing loss triangles & calculating loss ratios.
• Performed a diagnostic for a potential client to study the raw data provided by them and suggest interventions to improve both top line as well as the bottom line. Project involved working with Excel, preparing dynamic dashboards, cost-benefit analysis, etc.
• Consulted a vehicle auction business based out of UK as part of a diagnostic study to suggest ways they can improve the customer journey, vehicle acquisition as well as the customer experience processes.
• Worked on solvency-II requests helping client automate their manual excel processes.

Jul 2019 – Jan 2021 · 1 yr 6 mos · Gurugram, Haryana, India

• Part of the analytics team for a major insurer based out of UK. Work involves interacting with cross cultural teams, scoping the business requirements and writing SAS codes for setting up relevant automated reports by extracting and analyzing data.
• Helped the client analyze the costing and strategy by extracting and preparing data with business volumes across different regions. Also assisted a telematics team streamline the data processes having an impact of millions of pounds.
• Worked on a POC involving knowledge of and working on the bordereau process.
• Received the “promising newcomer” and “shining star” awards for exceptional performance.

Jan 2018 – Jul 2018 · 6 mos · Gurgaon, India

• Helped clients conduct strategic procurement by shifting supplier base from initial high cost countries to best cost destinations e.g China, India, South East Asia, Eastern Europe and Latin America. Impact involved bringing savings by cutting down on procurement spend for clients.
• Advised on Global/Best-cost country sourcing excellence
• Supported throughout the global sourcing process for various industries

Jan 2017 – Apr 2017 · 3 mos · Chandigarh Area, India

• Was responsible for uploading quality articles about life in the city beautiful - Chandigarh and worked with wordpress too during the same project.