MOHD SHAZAN
Business Analyst
Lucknow
Summary
Results-driven Business Analyst with over 4 years of experience leveraging cloud-native technologies, data engineering, and business intelligence to deliver actionable insights and scalable reporting solutions. Expertise in AWS services, including Lambda, Redshift, Athena, QuickSight, and CDK, combined with proficiency in Python automation and ETL pipeline development. Demonstrated success in translating complex data into strategic recommendations for senior leadership while fostering process optimization and enhancing cross-functional collaboration. Committed to driving data-informed decision-making that propels organizational growth and efficiency.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Business Analyst
Amazon
Hyderabad
10.2022 - Current
- Led a full-cycle reporting automation initiative, migrating multiple data sources into scalable ETL pipelines, developing automated Excel-based reporting solutions, and applying Python to streamline the end-to-end process from data ingestion through delivery — recovering the project after a major platform deprecation required extensive rearchitecting.
- Designed and implemented a comprehensive Cost Optimization Module using native AWS services and AWS CDK, architecting a decoupled stack infrastructure that improved deployment flexibility and enabled granular cost visibility across cloud resources.
- Delivered multiple high-impact reporting solutions leveraging AWS services (Lambda, SQS, Athena, QuickSight) and Excel automation, including interim executive-level dashboards, operational reporting replications for Stores teams, and cross-functional rollup transitions — each requiring coordinated changes across ETL, visualization, and data layers.
- Developed CDK-based infrastructure-as-code pipelines using TypeScript to automate provisioning of AWS resources including Redshift clusters, IAM roles, and supporting infrastructure — reducing manual setup and ensuring repeatable deployments.
- Built a scalable data pipeline to surface historical scheduling data previously inaccessible due to dataset scalability limitations, unblocking end-user analytics and closing a critical gap in historical data availability.
- Engineered end-to-end data migration and infrastructure onboarding of new Redshift clusters, eliminating critical dependencies on legacy systems and ensuring seamless data access across multiple downstream tools and operational workflows.
- Designed automated weekly business review reports for senior leadership, surfacing key customer service performance metrics through clear, actionable visualizations that informed strategic decision-making.
- Designed scalable and maintainable data models to support business intelligence initiatives and long-term reporting needs across multiple operational domains.
- Served as a go-to technical resource across the team, providing mentorship to junior team members, troubleshooting complex technical challenges, and fostering a collaborative learning environment that improved overall delivery velocity and reduced single points of failure.
- Demonstrated systematic root-cause analysis capabilities, consistently resolving complex data and infrastructure issues through deep investigation rather than surface-level fixes, implementing timely and sustainable solutions that prevented recurring problems.
- Developed high-quality technical documentation to support training efforts and knowledge transfer, helping team members fully understand new systems, procedures, and architectural decisions.
Support Operations Analyst
Amazon
11.2020 - 11.2022
- Increased automation in reporting processes by designing dynamic dashboards using visualization tools like MicroStrategy and QuickSight.
- Reduced data discrepancies by implementing rigorous data validation techniques and automated error detection.
- Enhanced data processing speed by optimizing ETL pipelines for efficient data ingestion and transformation.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Analyzed large datasets to identify trends and patterns in customer behaviors.
- Prioritized scalability in all developed solutions, anticipating future growth and accommodating for it through modular design principles.
- Resolved customer issues related to data quality and availability received via tickets and emails within SLA.
Subject Matter Expert
Amazon
11.2018 - 11.2020
- Collaborated with senior management and business line management to identify and prioritize processes that needed revamping.
- As an SME to the Regulatory Escalation and Grievance Team (REG), supported the team in handling customer issues regarding Amazon Money, Gift card, Recharges and Bill Payments and following up on escalation cases to safeguard customer’s experience.
- Effectively handled Amazon Pay and Bank Cashback escalations from customers to understand the root cause of cashback not getting credited.
- Reduced the invalid cashback escalations by around 25% after analyzing the reasons for these escalations.
- Worked along with the different promotion owners to get the cashback processed for the valid escalations.
- Used SQL to improve the cashback escalation handling to identify the promotions which might have affected majority of customers and brought down the validation time from 10 minutes to 2 minutes.
- Assisted the operations management in analyzing the data of all the refund cheques issued in a period of 4 months in order to replace the refund mode via cheque in Amazon with better alternatives.
- Obtained new sources of data from different database tables in Amazon to update performance reviews and preparing weekly/monthly based reports.
- Ensuring long term fixes to customers' issues by connecting with various POCs from Program, Tech & Category team.
CS Associate
Amazon
03.2016 - 11.2020
- Managed customer relations and customer service through daily communication and interaction.
- Provided basic technical support for clients on wide range of Amazon products such as Kindle, Echo etc.
- Communicated with customers regarding fraudulent activities on their Amazon account.
- Completed in-depth investigations into issues pertaining to grievance related to Amazon Money.
- Improved customer satisfaction ratings by addressing issues and fostering timely resolution.
Holiday Team Lead
Amazon
11.2016 - 03.2017
- Coached team members in customer service techniques, providing feedback and encouragement toward reaching performance goals.
- Initiated timely response to emails, phone and chat correspondence.
- Cross-trained and provided back up for customer service managers.
- Led team of 25 members while providing exceptional customer service.
- Evaluated employee skills and knowledge regularly, providing hands-on training and mentoring to individuals with lagging skills.
Education
Bachelor of Technology - Electrical And Electronics Engineering
BBD Northern India Institute Of Technology
Lucknow06.2014
Higher Secondary Certificate - Science
Unity College
Lucknow02.2010
Senior Secondary Certificate - Science
Unity College
Lucknow02.2008
Skills
SQL data analysis
Excel proficiency
QuickSight analytics expertise
Proficient in MicroStrategy
Experienced in Python programming
Skilled in utilizing AWS tools
Data interpretation
Problem-solving skills
Cross-functional collaboration
Data analysis
Data pipeline architecture
Cross-functional collaboration
Data analysis
Data pipeline architecture
Certification
Amazon Certified Quality Assurance Tester as part of the ATLAS Program 2020
Timeline
Business Analyst
Amazon
10.2022 - Current
Support Operations Analyst
Amazon
11.2020 - 11.2022
Subject Matter Expert
Amazon
11.2018 - 11.2020
Holiday Team Lead
Amazon
11.2016 - 03.2017
CS Associate
Amazon
03.2016 - 11.2020
Senior Secondary Certificate - Science
Unity College
Bachelor of Technology - Electrical And Electronics Engineering
BBD Northern India Institute Of Technology
Higher Secondary Certificate - Science
Unity College
Declaration
I hereby declare that all the information mentioned in my resume is true and correct to my knowledge and I take full responsibility for the accuracy of the particulars mentioned.
Place: Hyderabad
Date: