Himanshu Yadav
Gurgaon
Summary
Driven Business Analyst | Leveraging Data Analysis, Process Optimization, and Strategic Decision-Making Expertise to Drive Business Success | MBA in (Business Analytics)
Overview
3
3
years of professional experience
Work History
Senior Business Analyst- GTM Team
2070 Health
Gurgaon
07.2024 - Current
- Problem: Manual reporting processes in the portfolio company were time-consuming and prone to errors, impacting efficiency and decision-making.
- Solution: Spearheaded the automation of reports using MySQL and Superset, streamlining data retrieval and visualisation processes.
- Impact: Reduced reporting time by 30%, increased data accuracy, and enabled faster, data-driven decision-making, improving overall operational efficiency.
Senior Business Analyst- Founder Office
Brick & Bolt
Bangalore
07.2023 - 07.2024
- Company Overview: It is India's 1st tech-enabled construction company that aims to make construction simple
- Operational Efficiency: Through strategic analysis and optimization in our operations, I successfully reduced project delays by 20%
- This improvement directly impacted our project timelines and client satisfaction
- Supply Chain Enhancement: I designed and implemented a comprehensive supply chain dashboard that provides material-wise and contractor-wise metrics
- This innovation contributed to a remarkable 15% increase in our company's profit margins
- Analytics: Spearheaded the creation of interactive dashboards powered by PostgreSQL, enabling real-time data visualization and analysis, leading to a 40% reduction in manual reporting time and improved data accuracy
- It is India's 1st tech-enabled construction company that aims to make construction simple
Business Analyst - Founder's Office
Mojocare
Bengaluru
01.2023 - 06.2023
- Company Overview: The company's platform allows users to consult with doctors online for health conditions related to hair, weight and Men's Wellness
- Supply: Employed Metabase and PostgreSQL to construct Company First Metabase dashboards, enabling effective monitoring and analysis of supply chain performance
- Demonstrated results by reducing the Return to Origin (RTO) rate from 65% to 57%, marking a significant milestone for the company
- CT (Control Tower): I drove vertical growth by implementing a strategic change resulting in a remarkable 70% monthly increase in Mop (Mode of Payment)
- This ensured vertical profitability and contributed to the organization's overall success
- Inventory: Made Dashboard to establish real-time inventory tracking across multiple channels, optimizing inventory availability for sales operations
- The company's platform allows users to consult with doctors online for health conditions related to hair, weight and Men's Wellness
Data Analyst
Park
Gurgaon
11.2021 - 01.2023
- Implemented a suite of dynamic AWS Athena SQL dashboards and analytical reports, resulting in a significant 8% improvement in renewals, equating to $1.2 million in annual recurring revenue for the company
- Developed and deployed a set of customized AWS Athena SQL dashboards and analytical reports, resulting in a notable increase in renewals from 70% to 78% and providing actionable insights for the sales team
- Fusion: Revamped and streamlined reporting for the company's largest vertical, providing real-time insights into process performance and enabling the management to optimize operations effectively
- Demonstrated exceptional proficiency by owning and managing over 50 dashboards, utilizing a combination of Metabase, MySQL, and Python for data visualization and analysis
Education
Master of Business Administration - MBA - BUSINESS ANALYTICS
Kurukshetra University
06.2021
Skills
- MYSQL
- Advanced Excel
- AWS Athena
- Big Query
- Tableau
- Metabase
Accomplishments
- Secured 1st position in the Inter-University Volleyball Tournament, 2017 - 2018
Hobbies and Interests
- Sports
- Workout
- Gaming
- Music
- Data
Languages
Hindi
First Language
English
Upper Intermediate
B2
Timeline
Senior Business Analyst- GTM Team
2070 Health
07.2024 - Current
Senior Business Analyst- Founder Office
Brick & Bolt
07.2023 - 07.2024
Business Analyst - Founder's Office
Mojocare
01.2023 - 06.2023
Data Analyst
Park
11.2021 - 01.2023
Master of Business Administration - MBA - BUSINESS ANALYTICS
Kurukshetra University