SUMMARY

• Over five years of experience as a Business Analyst with extensive experience in handling large amounts of data and producing analytical reports for decision making.
• Extensive experience in conducting Interviews, JAD Sessions, Questionnaires & Web Meetings to gather Business Requirements and Functional Requirements.
• Extensive Experience and knowledge of Interline procedures and guidelines from IATA and ICH.
• Extensive experience/knowledge specific to individual Revenue Accounting department
• Extensive experience in Analysis of Raw Data, to help identify trends, develop sales comparison reports and sales forecasts.
• Use MS Excel to create reports to make recommendations for relevancy in data usage in multiple research projects.
• Experience in conducting Revenue Assessment systems with emphasis on Proration.
• Team Leader from Confidential responsible for liaising with Kale Consultants
• SME on Revenue/Sales Accounting functions.
• Key member of a team that designed Airlines Loyalty Program having responsibility of working out revenue information on various alternative products

TECHNICAL SKILLS

MS Office: MS Excel 2010 (Pivot Tables, Formula’s, VLookups, HLookups, Compare Data, Charts, Reports and Data Analysis ), MS Word 2010

Project Management: MS Sharepoint 2010, MS Outlook 2010

Database: MS Access 2010

PROFESSIONAL EXPERIENCE

Confidential, Auburn Hills, MI

Business Analyst

Responsibilities:

• Conduct Interviews, JAD Sessions with Business / Application Owners and gather Business Requirements.
• Conduct one on one interviews and gather application code data and create Excel, Word and PowerPoint documents for Application Code information.
• Charting of data, identifying trends and communication of these findings in MS Excel.
• Create and operate MS Excel pivot tables.
• Upload data files to MS Sharepoint repository.

Confidential, Dallas, TX

Sr. Revenue Accounting Analyst / Business Analyst

Responsibilities:

• Conducted Interviews, JAD sessions with Business Stakeholders to Elicit Business Requirements and Functional Requirements.
• Documented Business Requirements and Functional Requirements for the Interline Module.
• Working on the Hawaiian Airlines Project for the Implementation of REVERA PRA as Subject Matter Expert.
• Responsible to process and validate all interline transaction in our Revenue Accounting system.
• Responsible in Implementing Interline Module for Hawaiian Airlines.
• Used MS Excel for Reporting and Data Analysis
• Extensively used MS Excel Pivot Tables, Formula’s, VLookups and HLookups for Data Analysis.
• Used MS Sharepoint for Document Management & Project Management.
• Responsible in doing the Test Scenario’s for Implementation of new Revenue Accounting System.
• Documented Training Manuals and Procedures for the Hawaian Airlines Team

Confidential, Southfield, MI

Data Analyst / Business Analyst

Responsibilities:

• Gathered Business Requirements and Functional Requirements for the Sales module being developed in PHP
• Responsibilities include making weekly sales reports for all offices in USA using MS Excel.
• Conducted JAD Sessions to gather requirements for the Ad - Hoc Reports.
• Analyzing, planning, implementing various aspects of the sales and marketing department.
• Calculating flown revenues for each Airline represented by Sky Bird Travel using MS Excel
• Use MS Excel to make projection reports based on management variables for preferred and non preferred airlines
• Coding and mapping business processes in order to track all corporate information through various data models.
• Linking these decision support models to Access and Excel databases to give management instant access to information, which included forecasting, budgeting, completed and scheduled activities, customer buying frequency, potential sales, lead management and sales sheets.

Confidential

Sr. Revenue Accounting Analyst

Responsibilities:

• Coding complicated Interline Special Prorate Agreements (SPAs) for their Airline clients.
• Coordinating with Head Quarters to iron out discrepancies in agreements.
• Suggesting alternatives for improving retention through in-depth study of the SPAs
• Documented Procedures and Operation Manual for the end users.

Confidential

Assist Manager

Responsibilities:

• Primarily responsible for interline billing settlements and SPA coding
• Dealt directly with the other Airlines like Lufthansa, British Airways, Air France, and Singapore Airlines for interline billing issues
• Knowledge of Revenue as Reservation Booking Codes. Yield as per RBD’S.
• Represented Confidential during IATA General and Special Prorate Meetings, Revenue Accounting Meetings, Sample Steering Committee Meetings, etc. to set Policies, Procedures and Rules for Industry
• Responsible for the journal entries of the sectional accounts and balancing of the accounts.
• Represented Confidential for Meetings with Other Airlines bilaterally or multi-laterally for Joint Products, Revenue sharing including Resolution of interline billing disputes.
• Worked on fares and rules retrieval from GDS’S like SITA Air Fare, ATPCO, Sabre and Amadeus.
• Responsible for educating the commercial staff on the topics of Revenue proration.
• Knowledge of Fare Construction in detail, stood First in class in Confidential ’s Staff College for Fares II.
• Trained sectional staff in Proration, Interline Settlement Techniques and Procedures
• Provided support to Marketing team in Revenue Information for forming sales and Loyalty Programs