SHIVAM PANDEY
Business Analyst
Nashville,TN
Summary
Results-driven Business Analyst with a proven track record at Amazon, enhancing operational efficiency by 10% through strategic planning and data collaboration. Proficient in SQL and data visualization tools like Tableau, I excel in delivering actionable insights and fostering teamwork to meet critical KPIs and drive impactful decision-making.
Seasoned Business Analyst offering 6 years of Fintech & Supply Chain industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making.
Overview
8
8
years of professional experience
7
7
Certifications
Work History
Business Analyst II - AMZL OTR PPT
Amazon
12.2024 - Current
- Lead short-term planning for 16 delivery stations, impacting over 1 million packages daily.
- Collaborate with station managers for 3-week capacity planning and intraweek caps to avoid any capacity miss. Met capacity goals and helped the team to deliver packages on time 98% of the time in my region.
- Coordinate with the On the Road Production Planning team to identify ramp-up/down opportunities. Handled high-volume events and helped the stations to plan multi-cycle operations.
- Supported new station launches and closures, ensuring smooth transitions. Handled 4 station launches.
- Partnered with Data Scientists and BIE teams to develop dashboards and ETL pipelines, reducing turn around time for the reports by 10%.
- Ensured operational KPIs were met, improving efficiency by 15%.
- Analyzed and interpreted complex operational data to identify trends, enhancing decision-making and process improvements.
- Developed comprehensive reports to support strategic initiatives, driving efficiency in project execution and resource allocation.
- Collaborated with cross-functional teams to implement data-driven solutions, resulting in streamlined operations and improved performance metrics by creating dashboards using AWS Quicksight, S3 and glue.
- Led process optimization projects, analyzing workflows to eliminate bottlenecks and enhance overall productivity and service delivery.
Data Analyst
Meritize
10.2023 - 11.2024
- Analyzed capital market, marketing, risk and compliance, and HR data; led investor reporting.
- Created dashboards and automated processes, reducing delivery time and boosting accuracy.
- Developed a centralized data dictionary and implemented text-based similarity scoring.
- Optimized loan tape generation queries, reducing run time by 70%.
- Analyzed borrower behavior using ML, reducing delinquency by 4%.
- Analyzed large datasets to identify trends, providing actionable insights that informed strategic decision-making across departments.
- Developed and maintained interactive dashboards using Tableau, enhancing data visualization and accessibility for stakeholders.
- Collaborated with cross-functional teams to streamline reporting processes, resulting in improved accuracy and reduced turnaround times.
- Implemented data validation techniques to ensure the integrity of data sets, supporting reliable analytics and reporting.
Data Analyst
WebCraft IT
06.2017 - 09.2021
- Led pricing strategy optimization and sales forecasting using AWS Redshift.
- Built dashboards in Tableau and Power BI; automated reporting processes.
- Reduced data errors by 25% and improved loan collection effectiveness.
- Managed database administration across Salesforce, HubSpot, and Excel.
Education
MS - Business Analytics
Drexel University
Philadelphia, PABE - Electrical & Electronics Engg.
Shri Vaishnav Institute of Technology And Science
Skills
SQL
Data analysis
Data visualization
ETL processes
Dashboard development
Trend analysis
Process optimization
Reporting automation
Cross-functional collaboration
AWS Quicksight
SQL querying
Python (Numpy, Pandas, Seaborn, Selenium)
Tableau
Power BI
Project management
Stakeholder management
Microsoft Office Suite
Certification
SQL (Advanced) - HackerRank
www.linkedin.com/in/sp2195/
Timeline
Business Analyst II - AMZL OTR PPT
Amazon
12.2024 - Current
Data Analyst
Meritize
10.2023 - 11.2024
Data Analyst
WebCraft IT
06.2017 - 09.2021
BE - Electrical & Electronics Engg.
Shri Vaishnav Institute of Technology And Science
MS - Business Analytics
Drexel University