Shrey Gupta
Gurugram
Summary
I am a result oriented professional with 5+ years of rich corporate experience in business and growth analytics and 8+ years of experience in entrepreneurial and startup projects.
I bring to the table, strong analytical skillset with knowledge of tools like Power BI, Advance excel, SQL, Microsoft Azure, Launchpad, Google Analytics, Clickhouse and Metabase and building data models, process optimizations & cost saving analysis. Having done MBA & B. tech, I possess skills to grow a business/ start-up with a vision of taking into account both analytical & business requirements.
Hands-on with startups and projects, I am well equipped with understanding of business challenges/ consumer behavior/ product lifecycle / Brand awareness / business model enhancements/ growth mindset.
Dedicated to optimizing existing features to drive product forward creating effective engagement strategies. Excellent communication and relationship building skills.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Sr. Product Analyst - Beyond Air
Fareportal
Gurugram
08.2022 - Current
- Automated Beyond Air Data tracking system reducing 5 Man-hrs daily with an accuracy of 98%
- own the Trip attach Funnel and product growth
- PPC project - Estimated bookings increased 4/Day with 100$ /Day revenue increase
- Streamlined Cancelled booking data with 90% accuracy
- Tracked and corrected 30000 $ worth missing bookings data
- Optimized data queries reducing run time by 50%
- Assisted teams with aligning marketing strategies and objectives based on data-driven insights.
- Recommended changes or updates based on competitive analysis findings for existing products.
- Analyzed customer data to identify trends for product quality issues.
- Created data models and dashboards for leadership for better visibility of business performance.
- Measured core success metrics to improve future product launch phases.
Sr. Business Analyst (OCC)
Interglobe Aviation Ltd (Indigo Airlines)
Gurugram
01.2020 - 07.2022
- Translated business objectives into measurable success criteria that could be tracked over time.
- Developed reports and created dashboards, providing financial-related information to make informed business decisions.
- Improved processes and procedures to achieve key performance metrics.
- Analyzed and tracked data to prepare forecasts and identify trends.
- Successfully increased the hotel utilization data accuracy to about 95-98% & developed our dataset to be the only data source to be considered across all departments (Based on deep segregated levels)
- Conducted cost- benefit analysis and gave leadership a solution which could save up to ~160 Cr in hotel cost in next 10 yrs.
- Developed process improvement solutions using VBA scripts and optimization of logics of critical reports (OTT/ OTP Performance) which is chaired by COO on every alternate day of a week (Saving of ~20 Man hours/Month)
- Performing data UAT and data health checkups for increasing accuracy levels, raising EWS to cater to uncontrollable day of operation situations.
- Analyzed existing systems and processes, identified gaps and recommended improvements.
- Monitored project progress using metrics such as timeline, budget, resources utilization.
Brand Management Intern
Hain Celestial IMEA (A Hain Celestial US Group subsidiary)
05.2019 - 07.2019
- To study and analyze brands of Hain Future in terms of product, positioning, communication, competition with special reference to categories: healthy snacking, natural personal baby care, Non-dairy beverages in the Indian market scenario.
Data Analyst
Hotstar (Live Project)
10.2018 - 11.2018
- To understand and analyze Hotstar- 'customer and consumption datasets' and provide recommendations and strategies for new subscriptions plans that the company should come up with.
- Translated raw data into meaningful information using statistical techniques.
- Collected, tracked and evaluated current business and market trend data.
- Recommended metrics and models based on observed trends.
Business Analyst
Shiv Enterprises Private Limited
New Delhi
07.2017 - 07.2018
- Created digital marketing strategies to achieve more impressions & leads and increase brand awareness
- Process improvement analytics to track, record and study sales growth trend and generate powerful insights
- Developed Dashboards & KPIs for the management to demonstrate sales analysis on various levels (Country wise, state wise, geography wise, dealer wise etc.)
- Developed inventory management tool to save cost and better visibility of raw material planning
- Restructured product pricing into an automated template to increase efficiency
- Enhancing dealer network with various marketing efforts and campaigns
- Assisting CEO in enhancing business model to ensure growth.
Student Advisor (Freelancing) International Student Office Team
MAII Stratford University
New Delhi
04.2016 - 11.2016
- Assisted Sales and Marketing Teams to get admissions from various countries by managing leads generated through online marketing and following up to ensure conversions.
Digital Marketing Intern
Enterprise Monkey Private Limited
Delhi
06.2016 - 07.2016
- Assisted Social Media Marketing Team in promoting Enterprise Monkey in 'Geelong Small Business Festival 2016', Australia.
Education
Class XII (AISSCE) -
Ryan International School
01.2013
Class X (AISSCE) -
Ryan International School
01.2011
MBA (Marketing & Finance) -
Sri Sri University
B. Tech (Computer Science) -
Jaypee Institute of Information Technology
Skills
- Data Analytics
- Business Needs Analysis
- Client Relationship Management
- Data Visualization
- Team Leadership
- Corporate Communications
- Team Collaboration
- Relationship Building
- Business Performance Analysis
- Strategic Planning
Accomplishments
- Citation at Fareportal for Creating Autotmated data models
- Winner of 5th Annual Marketing Conclave Feb 2019
- Head of the Entrepreneurship Cell- Srinovation Club Pvt Ltd Jan 2019- present
- 2nd Runner up of Prahuti- Most Prestigious" Strategy and Marketing competition" of Sri Sri University - Won a cash prize of 10k. Sept 2018- Apr 2019
- Participated in "Big Data Analytics and its Application"-Infosys Bhubaneswar Nov 2018
Affiliations
- Mentor with ThinkStartup
- Entrepreneur and Speaker
- Founder of Trackko.io
- Social Volunteering
- Traveler, Sports enthusiast and music lover
Certification
- Google Analytics
Languages
English
First Language
Timeline
Sr. Product Analyst - Beyond Air
Fareportal
08.2022 - Current
Sr. Business Analyst (OCC)
Interglobe Aviation Ltd (Indigo Airlines)
01.2020 - 07.2022
Brand Management Intern
Hain Celestial IMEA (A Hain Celestial US Group subsidiary)
05.2019 - 07.2019
Data Analyst
Hotstar (Live Project)
10.2018 - 11.2018
Business Analyst
Shiv Enterprises Private Limited
07.2017 - 07.2018
Digital Marketing Intern
Enterprise Monkey Private Limited
06.2016 - 07.2016
Student Advisor (Freelancing) International Student Office Team
MAII Stratford University
04.2016 - 11.2016
Class XII (AISSCE) -
Ryan International School
Class X (AISSCE) -
Ryan International School
MBA (Marketing & Finance) -
Sri Sri University
B. Tech (Computer Science) -
Jaypee Institute of Information Technology
Similar Profiles
Deepika JainDeepika Jain
Director Talent (Head of Talent Acquisition) at FareportalDirector Talent (Head of Talent Acquisition) at Fareportal
Kush BabbarKush Babbar
Senior Executive at FareportalSenior Executive at Fareportal
Kanchan PatroKanchan Patro
Team Leader at FareportalTeam Leader at Fareportal
Priyanshu PathakPriyanshu Pathak
Executive at FareportalExecutive at Fareportal
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture