Vivek Rajendran

Vivek Rajendran

Senior Commercial  Systems Analyst

Dynamic and professional business intelligence analyst with exceptional skills in supporting global sales teams in the development and implementation of sales and commercial strategies to capture new markets and increase profitability.

  • Effective at investigating business solutions, identifying and evaluating options for improving business systems, defining requirements, managing stakeholders and ensuring effective use of business intelligence in providing insight to the business.
  • Possess excellent communication & presentation skills combined with exceptional analytical ability.
  • Experienced in data modeling, data mining and business analysis, especially in a commercial environment.
  • Extensive end-user KPI reporting and user acceptance testing experience.
Work History
Work History
Jan 2014 - Present
Senior Commercial Analyst
Commercial Strategy & Planning, Etihad Airways

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.
Jan 2012 - Dec 2013
Commercial Data Analyst
Commercial Planning, Etihad Airways

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.
Aug 2010 - Dec 2011
Revenue Systems Coordinator
Yield Management, Emirates Airlines

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.

Aug 2006 - May 2008
IT Consultant
CIT, State University of New York at Buffalo.
  • 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.
May 2007 - Aug 2007
IT Coordinator
Desenu Web Solutions, New York
  • 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.
May 2006 - Jun 2006
IT Intern
Fouad Alghanim & Sons Automotive Company WLL, Kuwait
  • 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.



Oct 2013
IATA Airline Revenue Management with Harvard Leadership and Management Diploma

Activities & Interests

  • Keen international traveler (over 30 countries); enabling activities such as scaling the active volcano Krakatoa in Indonesia, skydiving off Sydney North Coast, etc.
  • Intervention Marshall at the 2014 Abu Dhabi Formula 1 Grand Prix.
  • Volleyball team captain - High school runners-up position at regionals.
  • Violin – Indian classical music
  • Crossfit  Active fitness freak


  • Mother tongue - Malayalam
  • Fluent - English, Hindi
  • Intermediate - Tamil
BI Tools

Tableau, SAP Business Objects

KPI Reporting and Automation
Data modeling and mining
Microsoft Office (2007/2010)

Word, Excel, Access, PowerPoint, VBA

Business Analysis
Databases/ Statistics

Oracle, SQL, SSIS, MS Access, SPSS