Ayush Gupta

Responsibilities: -

• Analyze inbound and outbound inventory flow in Amazon Inventory crossdock centers with a focus on deep-dives, dashboard development and metric tracking.
• Contribute to inventory placement strategies for IN Fulfilment Centers, emphasizing automation and optimization of operational processes.
• Develop models for long-term planning to enhance efficiency and decision-making.
• Proficiently utilize Amazon Redshift, Spectrum, Datanet and QuickSight for ETL, data modeling, integration, and visualization tasks.
• Harness skills in SQL, PowerBI, and Excel for data analysis and predictive analytics, driving data-driven insights and actionable recommendations.
• Routine checkup for the all the query automation processes.

Projects: -

• Spearheaded the creation of the new Placement WBR deck, incorporating 10+ updated queries and Excel dashboards. Resulted in a 35% improvement in visibility and informed decision-making for Regional Instock, Inbounds, Outbounds, and First Placement Accuracy.
• Developed and implemented QuickSight dashboards for Regional Instock and IXD Inbounds Non-sort inbounds, reducing critical metrics access time by 1 hour and providing real-time insights into key metrics.
• Enhanced leadership decision support by implementing metric jobs and daily/weekly flashes, resulting in a 20% reduction in response time to emerging trends and improving overall decision-making efficiency.
• Worked on Recognized Customer Visits (RCV) dashboard which at Amazon levels gives absolute numbers as well as channel level cuts of RCV for all categories and Product Lines enabling comprehensive understanding of customer engagement and in gaining actionable insights enhancing the overall customer experience and driving business success.
• Worked on creation of Gateway (Amazon homepage) dashboard which gave WoW, MoM and YoY view into impression, clicks, units, OPS, SoV, CTR, Total customers for multiple Gateway marketing assets during Amazon events as well as BAU.
• Identified discrepancy arising due to misuse of New to Amazon (N2A) coupons. Deep dive revealed over 60% fake N2A customers. Corrective measures lead to a monthly savings of ~ ₹7.2M

A week at work: -

• Produced 50+ Weekly Business Review decks, presenting a 1-stop snapshot of the weekly business performance each for the Inventory Placement team and Other Hardlines (OHL) category teams.
• Conducted in-depth analysis on 50+ seller escalations related to inventory placement, ensuring a 25% increase in customer satisfaction and streamlining operational efficiency.
• Collaborated with cross-functional stakeholders to fulfill ad hoc data requests, ensuring timely and accurate information delivery.
• Worked on generating report on Prime Affinity ASINs taking Top 2000 ASINs(products) for each category and computing key metrics for the same like OPS units and N2GL and ASP greater than 500, BxGy, coupons amount.
• Wrote queries for diverse business requirements.

• Participated in user testing initiatives to gather firsthand feedback on site functionality and inform future improvements, ensuring an optimal shopping experience for all customers.
• Collaborated with cross-functional teams to execute successful marketing campaigns and drive brand awareness.
• Merchandised Amazon Food Storefront and handled outbound marketing: created and executed monthly push notifications, performance monitoring.

• Championed a positive work environment through active collaboration with peers while maintaining a focus on delivering top-notch customer service.
• Improved case handling time by effectively prioritizing tasks and utilizing available resources.

• Scaled digital marketing operations by creating and maintaining comprehensive documentation, process maps, and standardized procedures.
• Managed the end-to-end execution of various digital marketing projects, ensuring timely delivery within budget constraints.
• Increased website traffic by implementing search engine optimization strategies and keyword research.

• Development and maintenance of Customer Service pipeline and projected the structured data in PowerBI dashboard.
• Fetched and analyzed customer service data on a daily, weekly and monthly basis and projected the in PowerBI reports.
• Procedure conversion and migrating table data from SQL Server to PostgreSQL.