HIMANSHU PUROHIT
Bengaluru
Summary
Results-driven Business Intelligence Engineer at Amazon, skilled in SQL and Python, with a proven track record of enhancing reporting efficiency and optimizing data processes. Adept at stakeholder collaboration and mentoring, I developed automated ETL pipelines and interactive dashboards, significantly improving recruitment technology and leadership visibility.
Overview
7
7
years of professional experience
Work History
Business Intelligence Engineer
Amazon Global Talent Acquisition
Bangalore
10.2024 - Current
- Designed and automated end-to-end ETL pipelines using SQL, Python, and AWS for scalable data processing.
- Optimized SQL queries and implemented data quality frameworks to ensure accuracy and reliability.
- Collaborated with stakeholders to translate business requirements into effective data solutions, ensuring alignment with strategic goals.
- Developed interactive dashboards and KPI frameworks in QuickSight to improve leadership visibility.
- Consolidated fragmented SharePoint data sources into standardized model, enhancing reporting efficiency.
- Developed engineering solutions that streamlined recruitment processes, improving overall candidate experience.
- Mentored junior engineers on best practices in recruitment technology.
Lead Consultant Business Analyst
LUNA CX
Vishakapatnam
07.2024 - 10.2024
- Partnered with Parachute Home, a US-based retail company, on forecasting and inventory management, improving forecast accuracy by 25% through ARIMA, moving averages, and double exponential smoothing.
- Applied regression techniques to analyze historical data, enhancing accuracy of future unit and revenue sales predictions by 20%.
- Engineered a complete end-to-end data pipeline, integrating multiple data sources, saving 3 hours of manual work per day and improving data processing accuracy and speed.
Business Analyst
Amazon Seller Services Pvt. Ltd
Bengaluru
06.2019 - 07.2024
- Developed automated forecasting models, improving demand prediction accuracy by 90%.
- Collaborated with senior management on predictive modeling initiatives, leading to a 15% reduction in excess inventory holding costs.
- Acted as the sole Business Analyst for 200+ Account Managers, providing process guidance and analytical support.
- Led cross-functional projects resulting in a 20% reduction in fulfillment errors and a 30% increase in seller satisfaction.
- Developed initiatives to mitigate revenue loss and optimize operations, achieving 5% cost savings.
- Implemented automated stack rank system to enhance team performance by 20%.
Education
Bachelors of Computer Applications - Computer Science
Graphic Era University
Dehradun, India05-2019
Skills
- ETL engineering
- SQL and Python
- Power BI and Tableau
- Data visualization
- Advanced Excel and Power Query
- Reporting and KPI monitoring
- Data quality frameworks
- Business analysis and data analysis
- Predictive modeling
- Data mining and ingestion
- Automation and analytical tools
- A/B testing
- AWS services
- Dashboard design
- Agile methodologies
- Problem-solving teamwork
- Stakeholder collaboration and management
Accomplishments
- Cross-Functional Data Analysis and Optimization Project: Led initiatives to analyze and rectify fulfillment errors, resulting in a substantial enhancement of seller satisfaction and operational efficiency.
- Developed predictive models to setup inventory management process, leading to significant cost reductions and simplify operations.
- Supply Chain Optimization Initiative: Spearheaded efforts to enhance delivery routes and service quality, driving notable improvements in efficiency across the supply chain.
Languages
English, First Language
Timeline
Business Intelligence Engineer
Amazon Global Talent Acquisition
10.2024 - Current
Lead Consultant Business Analyst
LUNA CX
07.2024 - 10.2024
Business Analyst
Amazon Seller Services Pvt. Ltd
06.2019 - 07.2024
Bachelors of Computer Applications - Computer Science
Graphic Era University