Summary
Overview
Work History
Education
Skills
Awards
Personal Information
Certification
Work Preference
Work Availability
Languages
Timeline
Generic
ROHIT BHATT

ROHIT BHATT

Data Analytics || Data Driven Decision || Digital Transformation || Business Intelligence
Gurgaon,HR

Summary

Results-driven data and analytics professional with over 8 years of experience specializing in the aviation sector. Currently contributing to Air India's Performance Management and Data Analytics team, delivering valuable insights to enhance revenue and operational strategies.

Demonstrated expertise in project controls, stakeholder engagement, and effectively translating data into tangible business outcomes. Proven track record of optimizing efficiency and facilitating informed decision-making through strategic data-driven consulting approaches.

Overview

9
9
years of professional experience
1
1
Certification
2
2
Languages

Work History

Manager - Revenue Insights

Air India
05.2023 - Current
  • Developed reports to monitor year-around departures (>250K) to prioritize and strategize for incremental revenue opportunities and induce proactive decision making across Air India network.
  • Analyzed 500+ Origin and destinations across (UK, Europe, Americas, Australia) – India markets, formulated and implemented flight level revenue strategy to keep improving RASK. Streamlined revenue management practices by creating various reports and dashboards to align booking curves and sales mix.
  • Streamlined workflows by identifying bottlenecks in existing business operations and implementing appropriate solutions.
  • Facilitated team brainstorming sessions that led to innovative solutions for long-standing operational challenges.
  • Led cross-functional teams to achieve project goals, fostering collaboration and innovation.

Manager – Project Controls

Tata Projects Ltd.
05.2021 - 05.2023
  • Developed automated Project dashboard in POWER BI connecting directly to Oracle database using SQL query.
  • Brought a transformational shift in Project Reviews from “Financial outcome focused reviews” (Lag indicators) to “Schedule & Progress” driven KPIs based reviews (Lead indicators)
  • Developed Project Planning & scheduling processes for the transformation of the Project Controls functions across all business units
  • Developed and successfully implemented a simplified Cost to Complete (CTC) Management custom Process in Oracle ERP

Deputy Manager – Finance and Accounts

Tata Projects Ltd.
10.2019 - 04.2021
  • Developed workflow-based Claims Application (~1.3 Billion USD) using Zoho Creator and implemented a dashboard in Power BI for Management Reviews
  • Developed an automated tool for the preparation of a Financial Annual Operating Plan (AOP) in alignment with Indian Accounting Standard (INDAS 117).
  • Developed POWER BI dashboard for Project Cost To Complete (CTCs), Estimated Claim settlement Value, Finance MIS Dashboard, and Claims &VTCs, which became the basis for all senior leadership team reviews.
  • Developed and implemented CTC Reliability Tool across the organization comprising standard parameters for assessment of quarterly Project Cost-to-Completion (CTC) Reports resulting in efficient process

Project Control Analyst

GE Grid Solutions (Thru Tech Mahindra Ltd)
10.2016 - 09.2019
  • Part of the Global Project Controls Center of Excellence team, I was accountable for providing expertise in planning & scheduling and project controls.
  • Provide data-driven analysis to improve On-time delivery and established ETL pipeline for automating the flow of information from different Tools (P6, SAP, Time control etc.) directly to Tableau dashboard.
  • Developed & implemented automated Cost Forecasting and BDR claim tool in Unifier for GE Grid Solution (~4BUSD portfolio) using interconnection of various tools such as P6, SAP & Time Control.

Education

Bachelor of Technology - ECE

Bipin Tripathi Kumaon Institute of Technology
01.2012 - 01.2016

Skills

Power BI data visualization

Awards

  • Functional Excellence Award, 12/31/21, For the development of claims application & strengthening Controls in ERP system
  • Pat on Back Award, 03/01/18, For the development of BDR dashboard
  • Pat on Back Award, 10/01/17, For the development of functional and technical aspects of the Consolidated Project Dashboard

Personal Information

  • Date of Birth: 2nd Nov 1994
  • Gender: Male
  • Marital Status: Married

Certification

Execution Excellence Programme from IIM Ahmedabad

Work Preference

Work Type

Full Time

Work Location

On-Site

Important To Me

Company CultureCareer advancementWork-life balance

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Languages

English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)

Timeline

Manager - Revenue Insights

Air India
05.2023 - Current

Execution Excellence Programme from IIM Ahmedabad

12-2022

Manager – Project Controls

Tata Projects Ltd.
05.2021 - 05.2023

Deputy Manager – Finance and Accounts

Tata Projects Ltd.
10.2019 - 04.2021

Project Control Analyst

GE Grid Solutions (Thru Tech Mahindra Ltd)
10.2016 - 09.2019

Bachelor of Technology - ECE

Bipin Tripathi Kumaon Institute of Technology
01.2012 - 01.2016

Similar Profiles

CREATE PROFILE
ROHIT BHATTData Analytics || Data Driven Decision || Digital Transformation || Business Intelligence