Rahul Trehan Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

New Delhi

• Collaborate with zonal heads to identify opportunities for sales and operational improvement and work on strategies for their respective functions based on Data.
• Track key performance indicators for existing functions and new sales initiatives across the region.
• Creating Sales Dashboards for regional teams on CRM (Microsoft Dynamics) & Tableau.
• Assisting senior management with key performance insights at country/regional/individual level for monthly/quarterly and annual strategic meetings.
• Data Representation and analysis using Excel and SQL using V-lookup, H-lookup, Pivot Table, Slices, Joins, etc.
• Created basic Python programs for Data Automation. Primarily focusing on automating data spooling, data manipulation and data processing of monthly production files which reduced the processing time, response time and.

New Delhi Area, India

• Crunching and Manipulation of Data to work out strategic sales decisions
• Responsible for working closely, collaborated with functional heads, GM’s and Sales Heads of the business units to identify opportunities for operational improvement and strategic decisions in respective.
• Budget forecast creation for all business units in lieu of the target segments and source channel management.
• Maintained and automated reports for monitoring the performance of initiatives and campaigns.
• Created Interactive Dashboards for key stakeholders in sales and operations to measure key performance indicators.
• Providing business insights to Unit GM’s to ensure effective performance tracking.

Mumbai Area, India

• Responsible for managing the entire reporting for sales department including e-commerce.
• Spooling multiple reports from the SAP system, manipulating and processing of data through advance excel functions to generate key performance interactive dashboards.
• Assisting senior management with formulation of company annual budgets with breakup of annual budget on half yearly/quarterly and monthly targets.
• Setting up sales and operational report structure for all individual units/regional teams and conduct weekly calls with all sales members to ensure efficient tracking of individual performance data.

• Managing rates and inventory on all online channels as per forecast report.
• Devising Revenue Management technique for daily rate changes.
• Creating weekly performance presentations.
• Creating reports to track online business performance for all the hotels.

Integrated Program For Business Analyst, Business Analytics

• Data Handling and Extraction with SQL and Python • Data Visualization with Tableau and Python • Statistical Data Analysis with Excel and.

Post Graduate Certificate, Business Administration And Management, General

Bachelor Of Science, Hotel And Restaurant Management, First Class Hons.

Education record