Vivek Rajendran

Part of the business intelligence project team leading the development of multiple BI projects to support global and local commercial strategies that provided sales direction thus steering business development opportunities to Etihad and its equity partner airlines. Highlights of achievements include:

• Developing a global sales economic value model to align sales to the drivers of the company revenue budget while within Finance COS limits, contributing to a significant market share benefit from targeted sales distribution channels.
  
• Providing strong analytical results using multiple data sources (MIDT, PaxIS, etc.) to analyze strategic market opportunities, identify progress of key sales activities and assess performance of top agents; defining areas of competitive advantage or new growth opportunities.
  
• Driving sales strategy development and working with senior leaders to help identify and address strategic business opportunities, through the deployment of business intelligence reports.
• Design and implementation of an innovative suite of sales dashboards for all levels of the business, enabling accurate reporting at an account level and thus more effective account management.

As a member of the Commercial Planning Systems team, served as the system administrator for RevenuePlus in addition to providing fact-based data-driven analysis along with KPI reporting thus providing market insight, competitor analysis and identification of market opportunities. Key responsibilities included:

• Provide support and subject matter expertise on management of key internal and market intelligence data used for fact based analysis of Commercial activities.
• Create, improve and maintain multiple data models, while ensuring data quality and integrity to support key department projects.
• Conceptualization of data and effectively interpreting this information while presenting the output through operative reporting to senior management.
  
• Prepare and manage multiple KPI reports on a weekly/monthly basis, effectively improving team efficiency by reducing manual intervention of report generation through scheduling and automation of reports to the Commercial Planning team and global sales teams.
  
• Provide extensive administrative support of the commercial planning & budgeting system (RevenuePLUS) and various related ad-hoc system and data inquiries.

Reporting and Automation:

• Automated and scheduled multiple routine reports pertaining to passenger and revenue forecasting as well as provided key flight performance reports that enhanced decision making resulting in savings of approximately AED 165 million.
  
• Prepared reports on financial targets on a weekly/monthly basis for Commercial Analysis Managers and out stations; designed to facilitate and support decision making needs of senior executives.

Data Analysis:

• Assisted in analysis of different data using trend and growth techniques so as to help the Flight Analysis team maximize passenger revenue by appropriate overbooking, class mix allocation and flight cancellation/upgrades.
  
• Supported the FRPS team in the critical process of generating and finalizing the company's targets for a financial year based on passenger demand estimation and a variety of growth factors derived from various channels that contribute to the overall demand forecast for the current and target year.
  

System Support / UAT: 

• Provide comprehensive support in administration of commercial and yield management systems (such as Future Revenue Planning System/FRPS, PROMIS and Space) to ensure optimal use of the system for maximizing passenger revenue.
  
• Assisted in designing new functionalities to the revenue management systems as per business objectives.
  
• Worked closely with developers and end users to ensure user satisfaction and technical compatibility.
  
• Conducted acceptance/user testing on multiple reporting applications while liaising with IT support team to bring to attention any system issues or faults.

• Provided technical support to faculty, students and staff regarding computer and applications usage.
  
• Regularly checked the 200 terminals, 7 print stations and 4 scanners available to ensure proper functioning.
  
• Identified and escalated critical issues to the Team Up consultants(level 2 tech support).
  
• Utilized excellent interpersonal skills to assist patrons in communicating their needs and understanding the information necessary to resolve their problems.
  

• Effectively managed and coordinated graphic design projects from concept through completion for local small businesses.
  
• Worked closely with clients to conceive designs and gather user requirements.
  
• Worked with the designers to create various interactive web pages and integrate them with the back-end of the websites using HTML, CSS and PHP coding.
  
• Successfully completed client projects by providing proposal layouts and designs under tight deadlines while meeting standards and focusing on browser compatibility and accessibility.
  

• Facilitated the performance of quality checks on the newly implemented Dealer Management System(DMS) for retail operations.
  
• Assisted in training the sales division on working with the DMS and troubleshooting any issues that surfaced.
  
• Provided valuable inputs and contributed to resolving numerous technical issues.
  
• Compiled a technical documentation to serve as a user manual for the system.