Nitin Khanna Email & Phone Number

Bengaluru Area, India

Airline Domain Experience in Busienss Analyst with senior stakeholders. Experience in Pre-Sales, Center of Excellence (CoE), Bid Management, Proposal Writing, Driving large Proposals RFP/RFI, Customer Workshops, Strategic Planning, Business Analysis, Opportunity Analysis, Capability Presentation, Prospect Research (Must win and other prospect account), facilitating Solution Demos / PoCs, Capability Deck, Reusable Content for Proposal, Win Loss Analysis, Setting up Presales Repository Template Management, Case Studies etc.

Bangalore

1. Project: Sonata Airlines Solutions Management Description: Sonata’s Airlines Solution Management team is focused on Airlines Industry Research, Solutions Development and positioning solutions to achieve Organizational goals. Nitin‘s Responsibilities include:Research, Gap Analysis, Market Need, and comparison of solutions with other competitors, Prepare Solution Blueprints, Business Case, Documentation, building solution accelerators, business process and making client presentations1. March 2011 – till dateWeb Analytics E-Commerce Implementation Solution using Omniture- Sonata Software LtdDescription: This is a Web Analytics Solution Accelerator for Airlines and Travel domain. For this Solution Accelerators, we start with Website Assessment for various airlines and travel domain websites. This will give Clickstream Analysis, Gap Analysis between the needs of the travelers and offering of the website and give the recommendations to enhance the airlines customer reach and market share. Main function for Website Assessment for comparison for websites spread across different geographic, concept & creativity, features and functionality and content & structure, usability, navigation, browser compatibility, accessibility and page wise analysis for booking. Also Web Analytics Function - Generating reports for traffic analysis, KPI for Visitor Tracking, Loyalty and repeat visitor analysis, search engine optimization, user details, daily/weekly/monthly trends, browser details, web booking growth, business trend, revenue trend analysis etc. Also data collection and reporting – daily/weekly/monthly reportsDifferent modules – Reports and AnalyticsDashboard creationSocial Media Analytics Mobile AnalyticsCampaign Analytics Designation Sr Business AnalystRole Research, Analysis, Project Plan, Requirement Analysis, Functional Testing, Business Flow, Business Plan and Report Development Tools Omniture – Site Catalyst, SQL Server, MS – Excel, Access

Bangalore

Business Analytics- Conceptualized and delivered intelligent, innovative, analytical automated solutions/ products that was focused towards acquisition, growth, profitability and retention. My role involves directing the team to ensure data management is in place, conceptualize and create standard automated reports and data analysis that helps management make data driven decisions, customize analytical solutions to suit operators to help achieve their KPI’s & provide strategic and operational data-based insights. Have specialized in marketing analytics, and have worked on various data models. Help managed customer life cycle by positioning the right products to the right subscribers at the right time by analyzing customer behavior through primary and secondary research and providing valuable insights that helped in enhancing product offerings and user experience.

Banglore

Market Analysis for Arabesk Country (9 carriers):This project is based on Market Analysis Research for Arabesk country for 9 carriers. This Market analysis shows position of markets for each carriers• It compares GDD (Global Demand Dataset) airline performance data in 184 markets for 9 Arabesk carriers• It contain 13 month trend reports for industry key performance indicators• Produces gap reports comparing the Arabesk carriers with their competitors.Market Performance Analysis for Arabesk Country (9 carriers)- GF, IY, ME, MS, RB, RJ, SV and TU Airline:This project is based on Market Performance Analysis for Arabesk country for 9 carriers. This performance analysis shows codeshare pax and revenue analysis for codeshare revenue received and codeshare revenue contributed by each carrier• Used by the 9 Arabesk carriers to reconcile their codeshare revenue sharing• Reports Codeshare Frequency, Revenue, Traffic by each carrier• Uses GDD data to calculates Codeshare Revenue to be received and contributed from each partnerMarket Evaluation: Annual Demand, capacity, fare, SBR, LF, PDEW and revenue analysis, forecasting the demand using growth factors Market wise for the Host airline (Regression Analysis) using SAS. Revenue share and Market share and capacity share analysis: based on Airlines, city, country, region, hubs and airport wise for the customers (Airlines) using SAS. Ad-hoc reports: regarding market competition, profiles, revenue share, capacity share, ASKs, RPKs, SBR, LF, Itinerary level, leg level analysis and data validation and research on airlines using SAS. Tool used for the analysis: SAS, Excel internal tools like CRT, Planet, Awaken and Airflite and Statistical tools.

Noida Area, India

This is a IT solutions company, my role is to Research, data analysis, Database Design and development, MIS reporting using SAS, SQL, Toad, MS- Acesss and MS - Excel

Delhi

Analyze-it Technology, Delhi it sa Datawarehousing solutions software company. My role is toimplement Data warehouse for Analytics, Reporting, MIS etc.Project #9 Implementation for MakeMyTrip.com (Business intelligence Repository) Client MakeMyTrip.com, New DelhiDescription This project is based on Travel as Airlines, Hotels and Package for India and US Sources, in this there are different types of sources, which having different database as Oracle, SQL Server, ERP, MS-Access, Excel sheet and Flat files also, so we have created a repository into SQL Server and extract the data from all these sources into this repository then using Transformation and using ETL tool, load the Build data into Front end (Analyze-this), then creating Key Performance Indicators. In this project, we have done different type of analytics for hidden patterns, Data Mining, analysis as how many customers purchase as Flight, Hotel and Package, how many purchase as Flight, Hotel but not in Package by Venn Diagram, City wise segmentation, how many tickets purchases, how much revenue earns, repeating customers rate, how many passenger travel from where to where etc. CEO, Manager etc can take the decisions on the run time basis.Designation Team Leader (Technical Consultants)Role Research, Analysis. Project Plan, Project Lead, SRS, Requirement Analysis, Functional Testing, Business Flow, Design and Development for repository, KPI for analysisTools SAS, SQL Server, Oracle, MS-Access and ExcelTeam Size 4

Mca, Computers

Education record