Software Engineer
Emirates Airlines
Total years of experience :18 years, 9 Months
•Data warehouse and Business Intelligence specialist across different business domains like Network and Flight Operations, Catering, Finance and Management, Service Management, etc.
•Understand business requirements and device technical solution
•Analyse data to support flight catering domain within the data analytics layer
•Develop ETL mappings and workflows using Informatica to providing technical solutions and resolving issues.
•Responsible for building and managing universes, creating complex ad-hoc reports and charts using Business Objects (BO)
•Interact with business users to support ad-hoc operational issue and business queries.
•Adhere to defined quality assurance procedures to ensure bugs free delivery of assigned task.
•Established the ETL Code Quality and Review Panel. Defined its best practices and standards to ensure all enhancements, developments and support fixes are reviewed.
•Designed Microstrategy dashboards for incident management team to provide quick insight on events raised across all divisions in Emirates Group over a period of 13 months. The dashboard provides an ability to segregate information by its severity and to drill from month to incident details. It also gives visibility on the ageing of each incident raised.
•Designed a self service module for change management team. This functionality enables users to created ad-hoc report using Microstrategy Visual Insight.
•Designed and developed management information system for Airport and Operations line of business of Emirates Group. This MIS allows business users to forecast flight crew training for next 5 years, optimize flight and cabin crew duty rosters for next two months, predict and plan for crew availability based on aviation legal restrictions and conduct post duty analysis on crew and flights.
•Automated financial reports for dnata Travel business using BO. These reports consolidate data from various data sources and line of businesses including Dubai Airport Services, International Airport Operations, Catering, Travel and Group Services and are accessible through a SharePoint portal - dnata MIS
•Created interfaces with multiple sources (flat files and relational databases) through Informatica workflows to extract data and make it available for:
oPerformance management systems; Agent Performance Portal and My Business Contribution - An Employee Performance Management System
oService management system HPSM (HP Service Manager)used by change and configuration management team to analyze and report on changes, incidents, problems, service desk related interactions raised
oFinancial reporting systems used by Emirates Group Finance division including outstation credit risk management teams
•Acted as module lead for ERP Gems-HR & Payroll Module
•Aided clients during payroll processing, assistance to create and update the prerequisite information to a successful salary processing such as master data entry, employee profile updates, salary updates, promotions and increments, transfers, etc. in the HRMS
•Audited the accuracy of all the entered data using MS Excel and PL/SQL queries
•Diligently kept control of the releases documents
•Designed, developed, analysed and tested the application including Oracle procedures and functions that involve complex queries.
GPA : 3.92