Nov 2023 – Sep 2024 · 10 mos

• Transformed Finance reporting by creating one-click Macro tool, cutting down 3-4 hours of work per week for 35+ reports.
• Simplified Payroll processes with VBA-powered Excel template, saving 2 days of manual work each month and ensuring smooth transitions within team.

Aug 2022 – Oct 2023 · 1 yr 2 mos

• Headcount Projection
• Streamlined headcount tracking through report built in Tableau, replacing manual processes.
• This significantly reduced data analysis time and enhanced data accuracy, facilitating improved decision-making and visual storytelling.
• Implemented logical mechanisms to identify and manage data anomalies caused by system changes, ensuring data consistency and comprehensiveness. Maintained list of edge cases for collaboration with HR team, resulting in improved data quality and system performance.
• Maintenance Spends Analysis
• Successfully addressed the challenge of tracking high maintenance costs by creating a PowerBI dashboard . Achieved project objective of ensuring precise Maintenance Cost forecasting, timely Year to Go PO Commitment and PO's Expiration Analysis.
• This provided stakeholders with detailed insights, including overall costs, year- on-year trends, granular vendor-level data, and knowledge of which POs are about to expire, resulting in improved cost control and decision-making.

May 2021 – Jul 2022 · 1 yr 2 mos · Bengaluru, Karnataka, India · Hybrid

• Domain: Pharma
• Revamping Customer Service Chatbot Flow
• Assisted the PACE (Post Order Automation & Customer Experience) team in
• identifying the most frequently contacted issue by customers, resulting in a
• change in the Amazon Customer Service chatbots workflow, thereby
• improving the customer experience.
• Contact Routing Mechanism
• Identified a problem with the contact smart routing mechanism, according to which 70% of contacts were routed to primary customer service associates instead of pharmacy-specific trained CSAs
• Domain: Amazon Home Services(AHS)
• Report Streamlining
• In liaison with Category Management team built a modular query to bring the data related to all of the AHS services together in one place and built an automated report leveraging the underlying data.
• This automation helped in reducing the manual effort of 3-4 hours / week.

Jun 2019 – May 2021 · 1 yr 11 mos · Bengaluru, Karnataka, India

• Domain: Asset Management
• Segmentation Analysis
• Helped the clients to reduce the expenditure in 2020 by helping Sales team
• prioritize their engagement on high-yielding advisors
• This involved segmenting financial advisors based on industry tenure and
• transaction behavior
• Lead Scoring
• Helped the Marketing team to achieve a 65% conversion rate in targeting
• potential financial advisors for a digital campaign to launch a new product
• by assigning a score based on their web activities and Sales engagement by
• leveraging CRM data from Sales force
• Redemption Analysis
• In liaison with Central Analytics team worked on identifying advisors having
• predominantly redeeming transactions post COVID-19, to aid the SAM team
• design their strategic decision making
• Report Automation
• Single handedly built the Annual Summary Performance reports using VBA
• automation script for 50 + Advisor Consultants
• The automation script reduced the estimated turnaround time for the
• summary reports from 1 week to less than an hour
• Domain: Banking
• Model Migration
• Helped a leading bank in migrating their infrastructure from SAS to PySpark
• by modularizing various propensity models which reduced the process load
• time by 5X

Aug 2018 – Apr 2019 · 8 mos · Bengaluru, Karnataka, India

• 1. Performed critical upgrades using Linux scripts for HPE Storage environment

Feb 2018 – Jun 2018 · 4 mos · Bengaluru, Karnataka, India