Sharad Gupta
Bengaluru
Summary
Dynamic Senior Business Analyst with a proven track record at Amazon, excelling in SQL and stakeholder collaboration. Spearheaded automation initiatives, saving 30 man-hours monthly, while enhancing data insights and dashboard development. Passionate about mentoring teams and driving impactful business strategies through innovative data solutions.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
Amazon | PSS Team
Bengaluru
01.2025 - 08.2025
- Created Product Design Recommender (PDR) insights for the US, EU9, MENA, JP, and AU.
- Updated and automated WBR process for PSS, saving 6 man-hours weekly.
- Updated incremental GMS methodology calculation for better accuracy (corrected attribution for approximately USD 400 million across all relevant marketplaces).
- Identified and corrected legacy issues with existing ways of insight generation.
- Established clear SOPs for the insight generation process (requirement analysis, scope definition, timeline alignment).
- Played a crucial role in the automation of approximately 2,000 decks for AVS EU vendors.
- Managed a team of 4 Business Analysts, Automation Experts, and a Research Analyst.
- Mentored and guided a BA intern and a BA academy candidate.
Senior Business Analyst
Amazon | ROW Speed Team
Bengaluru
05.2024 - 12.2024
- Created, managed, and monitored data pipelines to report speed metrics.
- Modified pipelines to accommodate evolving business logic in data processing. Optimized queries, which resulted in annual savings of USD 12,000.
- Standardized and benchmarked speed performance metrics across ECCF geographies, accounting for regional business nuances. Consolidated reporting for seven regions, resulting in a monthly time savings of over ten stakeholder hours.
- Developed and maintained dashboards for stakeholders.
- Created automated mechanisms to ensure data availability and timely updates.
- Worked on reducing redundant dashboards, and optimized pipelines to consume less storage on Redshift and Tableau services.
Senior Business Analyst
Amazon | Softlines Finance
Bengaluru
05.2022 - 05.2024
- Built a P&L framework for Softlines (INR 160,000 MM GMS) at the LOB and cohort levels.
- Prepared weekly and monthly dashboards for stakeholders to track important metrics, and derive actionable insights from findings.
- Automated pipelines save 30 man-hours per month.
- Partnered with business managers to analyze high-visibility areas in the retail business. Worked on reducing the cost to serve, which resulted in savings of INR 800 million.
- Conducted a deep-dive customer journey analysis, increasing conversion by 20 basis points.
- Conducted analysis, shared insights, and created MIS, and dashboards.
- Sought possible problems and investigated inconsistencies with data or processing, taking action to resolve issues.
- Took complete ownership of problems and collaborated with peers to deliver the right technical solutions and business outcomes.
- Directed the gathering of data, and assessed data validity.
Business Associate (Research & Analytics)
Shoppee
Bengaluru
11.2021 - 03.2022
- Led the MIS team to identify operational opportunities and improve products and processes for optimal team efficiency.
- Communicated and presented insights to key stakeholders and senior management.
Business Analyst
Cloudtail
Bengaluru
09.2019 - 10.2021
- Engaged in advanced data analysis to uncover trends and correlations, utilizing statistical methods and tools to drive.
- Insightful recommendations for business strategies and process improvements.
- Developed automated reports and interactive dashboards using BI tools like Qlik, focusing on creating user-friendly and efficient data visualizations to support business decisions.
- Collaborated closely with stakeholders across various departments, including program and product teams, to communicate complex data insights effectively, and implement optimal communication mechanisms based on stakeholder needs.
- Performed data mining from a variety of sources, writing efficient queries with minimal post-processing needs, while handling.
- Large datasets and ensuring data fidelity through triangulation techniques.
- Continuously improved and scaled data processes to enhance efficiency and effectiveness.
Business Development Associate
Amazon | Seller Rewards Program
03.2019 - 09.2019
- Formulated business cases for executing reward promotions for sellers.
- Managed end-to-end operations for implementing promotions.
- Calculated incremental benefits and developed terms and conditions for promotions.
- Created reports and dashboards for internal stakeholders.
- Coordinated with agencies to produce creative materials for promotions.
Onboarding Specialist
Amazon | Ad Success Team
Bengaluru
12.2016 - 03.2019
- Served as the main point of contact for sellers and vendors, providing support for sales and marketing initiatives, primarily.
- Through phone and email communication.
- Delivered onboarding support and facilitated the setup of campaigns for sellers and vendors.
- I analyzed the Sponsored Products and Performance Advertising platform, employing various tools and techniques to resolve campaign setup and related issues.
- Identified opportunities to enhance Amazon products based on customer feedback, data analysis, and feature gaps compared to competitive products.
- Responded promptly and accurately to advertiser queries, assisting them in resolving campaign-related issues.
- Identified common blockers encountered by new and existing sellers.
Education
Post Graduate Diploma in Business Analytics And Management Decision - Analytics
XLRI
Jamshedpur08-2018
MBA - Marketing
Symbiosis Institute of Business Managenement
Bengaluru03-2014
B.Tech - Computer Science
Thapar Institue of Engineering And Technology
Patiala07-2009
Skills
- SQL
- Python
- Python
- Microsoft Power BI
- Tableau
- AWS
- Stakeholder collaboration
- Mentoring and coaching
- Pipeline optimization
- Dashboard development
- Descriptive statistics
- Project management
Accomplishments
- Nominated as Optimization Champ for query optimization in the Speed Team
- Calculated cost to serve (CTS) at the brand level and help the team in identifying the right hot spots for corrective actions
- Analyzed the profitability risks involved in marketing and other programs, for example, New to GL coupons, cashback
- Managed ART (Amazon Roller Thunder) pricing, ART performance (creating goals based on year-end goals, previous year ARTs, and trending performances)
- Drove AVN (Annual Vendor Negotiation) for Softlines and MVR (Mass Vendor Relations)
Certification
- Microsoft Power BI
- Scaler Data Science Course
Timeline
Senior Business Analyst
Amazon | PSS Team
01.2025 - 08.2025
Senior Business Analyst
Amazon | ROW Speed Team
05.2024 - 12.2024
Senior Business Analyst
Amazon | Softlines Finance
05.2022 - 05.2024
Business Associate (Research & Analytics)
Shoppee
11.2021 - 03.2022
Business Analyst
Cloudtail
09.2019 - 10.2021
Business Development Associate
Amazon | Seller Rewards Program
03.2019 - 09.2019
Onboarding Specialist
Amazon | Ad Success Team
12.2016 - 03.2019
Post Graduate Diploma in Business Analytics And Management Decision - Analytics
XLRI
MBA - Marketing
Symbiosis Institute of Business Managenement
B.Tech - Computer Science
Thapar Institue of Engineering And Technology
Similar Profiles
Sara Marie HenrickSara Marie Henrick
Transportation Associate at Amazon Tom TeamTransportation Associate at Amazon Tom Team
Sumesh BhattSumesh Bhatt
Sr. Ads Success Manager (Non Endemic Local & Pub) at Amazon Advertiser Success Team (AST)Sr. Ads Success Manager (Non Endemic Local & Pub) at Amazon Advertiser Success Team (AST)
Blake WilliamsBlake Williams
NA at Amazon, Ont 9 away teamNA at Amazon, Ont 9 away team
Ayushi SharmaAyushi Sharma
Emerging Architect at Shell India Markets Pvt LtdEmerging Architect at Shell India Markets Pvt Ltd
BHANU SHARMABHANU SHARMA
Senior Software Engineer at Q2 SoftwareSenior Software Engineer at Q2 Software