CDP Migration, 2022-07-01, Principal Engineer, Migrating the current applications from CDH to CDP, CDH, CDP, Oozie, Spark, Scala, Hive, HBase, ADLS, ADF, 11 Premium Economy, 2021-10-01 to 2022-06-30, Principal Engineer, Enhanced and tested existing code base written in Spark/Scala for all related Pricing, Inventory and Demand applications, Oozie, Spark, Scala, Hive, HBase, 8 Global Pricing System/Competitor Genome/Cloud Migration, 2015-04-01 to 2021-12-31, Principal Engineer/Engineering Manager, A sophisticated pricing system is required to support the growth that will help stimulate market demand through formulation of innovative fares, bundled and unbundled offers. Another business need is to develop a market watch that would monitor competition on all fronts, in the published world, in GDS and on the Internet, to enable us to develop proactive strategies to stay ahead of the competition. Worked on setting up data pipelines using Sqoop/Hive/Spark/HBase/Oozie to ingest raw data into data lake and later transformed/modelled it as per the use case. Assisted the team in building data model/cubes in oracle for MicroStrategy. Entire project is based on the lambda architecture. Currently working on a project to migrate the existing applications and data from on premise to Azure cloud. This includes setting up CI/CD pipelines to migrate the code and data along with Kerberization of existing jobs., JIRA, Oracle 11g hosted on Linux server, Hive, Pig, HBase, Spark, Scala, MicroStrategy, Cloudera Hadoop cluster of 80 Plus Nodes, 15 Dynamic Pricing Model (DPM) Enhancements, 2013-03-01 to 2015-04-30, Software Engineering Manager, We undertook many enhancements to the current DPM process, out of which following were business critical: Developing interface with Reservation System, using TIBCO services, to get missing fares and Surcharges; Identifying the Fare as Strategic/Tactical based on restrictions; Build in sanity/health checks, to monitor data correctness., Oracle 10g hosted on Linux server, PLSQL developer, SVN, Process assets library, 3 Fare and Surcharge Audit, 2013-02-01 to 2013-12-31, Pricing Project Manager/Business Analyst, Surcharge (YQ/YR) Audit in RAPID was performed manually using SLP4014 – Excel Download for Tax Analysis. This development was done to automate the airline specific surcharge (YQ/YR) audit process and fit into the existing Audit and under-collection process. FRR (Fares & Rules Repository) will be the source to provide Surcharges and O&D. Fare Audit functionality in RAPID is template based and manual process. User has to action each template manually. User inputs template details in GDS to fetch a fare and its rules. User compares/verifies all details and takes necessary action based on the findings. This development was done to automate this manual process and fit into the existing Fare Audit module. FRR (Fares & Rules Repository) will be the source to provide Fares and validate Rules to automate the Fare Audit process. This change was complex in terms of validation, as we had to form the OD, and later process/validate and provide the correct fare to RAPID. The processing of Category 25 (Discounted Fares), and combination was challenge, but was delivered successfully on time and within agreed budget., Oracle 10g hosted on Linux server, PLSQL developer, All Fusion Harvest 7.1, Process assets library, 12 Competitor Analysis, 2013-01-01 to 2013-03-31, Project Controller/Business Analyst, This module elaborates on the enhancements required by Revenue Optimization division of Emirates which will enable the team to make real time, consistent and efficient pricing decisions based on competitor, targets, forecast, flown and current bookings. Real time data analysis feed to pricing analyst is key to improvement of productivity and revenue. Designed and Developed Competitor analysis report by processing and validating millions of EK and Other Airline Published Fares to derive lowest published fares for EK and other competitors. This is a daily process, which runs on Oracle database successfully., Oracle 11g hosted on Linux server, PLSQL developer, All Fusion Harvest 7.1, Process assets library, 2 Developed Critical reports for Pricing Decision Support System(PDSS), 2011-04-01 to 2011-07-31, Business Analyst, Enhanced PDSS system, by developing some business critical reports like Rolling weeks. Pricing was having 12 weeks seat factor report. No events were recorded and no comparisons can be done with previous weeks as well. The main objective of this report was to have a dashboard view on how the 52 weeks are forecasted which will allow the senior managers and commercial view and develop strategies to optimize revenue wherever required., Oracle 10g hosted on Linux server, .NET, PLSQL developer, All Fusion Harvest 7.1, Process assets library, 2 PROFIT Enhancements, 2011-04-01 to 2012-12-31, Team Lead/Pricing Business Analyst, After the successful production roll out of PROFIT changes, we took numerous enhancements, and some of the changes were functionality critical as below: Build a functionality in the daily process, to override the filed fare amount by user defined values; Enhanced the business rules to include/exclude fares data in the daily process; Optimized the process to minimize the processing time; Migrated the current interface from AIRFARE to EK Subs Processor for the base data of Fares and Rules., Oracle 10g hosted on Linux server, PLSQL developer, All Fusion Harvest 7.1, Process assets library, 3 PROFIT, 2010-04-01 to 2011-03-31, Team Lead/Pricing Business Analyst, Today’s market place for Airlines is highly volatile, in terms of Pricing. Carriers using various open technology systems are able to manage their inventories on various RM Methodologies. Competing in such a market place involves being able to respond to the dynamic changes in demand as soon as possible. Emirates Revenue Optimization Management Team proposed a methodology for achieving the required agility in capitalizing from opportunities presented by different Markets. The methodology revolves around the philosophy of fine grained revenue management with market focus. This involves linking the revenue classes with the Fares in the market which would be implemented by processing and feeding the fares data from FRR to MARS-FQT system so as to aid in the availability and revenue management process. Analyzed, decipher and developed complex Fare and rule conditions to process and validate the Fare, by validating Travel restrictions to provide Fare levels at OD, Compartment and RBD level. Developed interface with existing EK inventory system (MARS), by providing the data on daily basis in the form of a flat file., Oracle 10g hosted on Linux server, PLSQL developer, All Fusion Harvest 7.1, Process assets library, 4 Implementation of AIRFARE system, 2009-11-01 to 2010-04-30, Team Lead, Worked closely with the Vendor (SITA), and the internal IT team for the hardware procurement/setup, and implementation of AIRFARE application. I was actively involved in the training and Production roll out of the AIRFARE application to Emirates Head office and outstation users. As part of post-implementation support, I liaised with the Vendor and users in getting the issues resolved., Oracle 10g hosted on Linux server, Oracle Web logic server, All Fusion Harvest 7.1, Process assets library, 3 SKYWARDS REVAMP PROGRAM, 2009-04-01 to 2009-06-30, Team Lead, Worked on effort Estimation using parameterized technique. Designed & developed Fares & Rules repository by analyzing in detail the ATPCO format and Skywards requirements. Complete solution definition and technical design was prepared, with peer review at every stage of development. Test cases were documented and every component was tested vigorously. Nonfunctional requirements testing like Load, stress & performance was conducted successfully by the testing team., Oracle 10g hosted on Linux server, TIBCO Business Works Designer 5.4, PLSQL developer, All Fusion Harvest 7.1, Process assets library, 4 EXCESS BAGGAGE RATES AUTOMATION, 2008-07-01 to 2009-04-30, Team Lead, A data repository to store free baggage allowance and excess baggage rates. Business logic of calculating free baggage allowance and excess baggage rates for a passenger booking based on a set of specific criteria. Develop a web service to facilitate seamless access to free baggage allowance and excess baggage rates by various technological environments. Develop JAVA application to interface from Emirates airlines check in system through MQ series to facilitate free baggage allowance and rates fetch., JBoss Application server, jFoundation Framework 2.1, All Fusion Harvest 7.1, MQ Series, Eclipse 3.1, JDK 1.5.0.12, Oracle 10g, PLSQL Developer, Process assets library, 6 PRICING SUPPORT, 2007-07-01, Team Lead, I am an active team member of pricing systems support group, which caters to a business community consisting of more than 1000 users across the globe. Supported Pricing applications namely FACTS, LSOM, AIRFARE, FRR and Pluto. Brief description of the Pricing applications: FACTS: Fare analysis control tracking system is an application purchased from SITA and is used by Emirates pricing users to create and file fares to GDS. LSOM: Local sales office module, used by the outstation users to create proposals. FRR-Pluto: Web Module used to access Fares & Rules Repository. Support activity includes: Monitoring service calls in HPSD tool, and Pricing support mail box. Any call from the customer is treated on high priority and a definite fix is provided depending on the service levels. A complete change/release management process is followed in order to promote the fix to production. Update configuration management database with all the CI details and relationships with other CI’s. Monitor databases, storage and liaise with the technical teams for necessary upgrades. Conduct quarterly causal analysis to analyze the root cause for the service calls, and initiate a plan for rolling a permanent fix. Conduct quarterly configuration audit for pricing support. Process access requests for pricing applications. Liaise with vendor (SITA) for bug fixes and perform complete health check/regression testing of the resolutions before promoting them to production. Plan failovers of pricing databases from primary site to secondary site and back, to ensure IT continuity. Prepare weekly status report. Other than daily support calls, we undertake preventive and adaptive maintenance activities, to improve the service levels and increase the business continuity., Microsoft Visio, Oracle 9i, Oracle 10g, Windows 2000 & 2003 Server, Windows XP on clients, Red hat Linux servers, Process assets library, 5 GROUP ONLINE FARE QUOTE SYSTEM, 2006-11-01 to 2007-07-31, Analyst, Conducted requirements gathering sessions with the business, which included understanding and analyzing each business process in detail. Utilized simulation techniques for complex computation and formulae used. Worked on Alternate solution document using the SWOT technique and proposed the same to business. Prepared user requirement specification document, by outlining a use case for each process with data flow explained in detail., ER Win (Fusion), Microsoft Visio, Oracle 9i, Windows 2000 Server with Application Server, Windows 2000 on clients, 5 FINANCIAL MANAGEMENT SYSTEM (Phase II), 2005-01-01 to 2006-11-30, System Analyst, Identified and documented the Gaps in the existing Financial Application. Conducted a detail BPR, and Redesigned the Processes. Supervised Development, Testing & Implementation., ER Win (Fusion), Developer 2000- Forms6i, ReportVer.3, Oracle 8i - Sun Solaris Release 5.8 on Data server, Windows 2000 Server with Application Server, Windows 2000 on clients, 4 DATA BASE ADMINISTRATION, 2003-07-01 to 2004-12-31, DBA, To Monitor daily DBA activities, which included Scheduling & Checking daily backups, Storage management, Alert log & Trace Files. To trouble shoot & rectify any problem whenever required to do so, using Sql, Oracle Enterprise Manager, Toad & DB Examiner as Database tools. Also played an active role in implementation of Backup solutions using RMAN and Veritas., Oracle 8i, 9i on Sun Solaris Release 5.8 on Data server, 2 VEHICLE INSPECTION CENTER, 2003-12-01 to 2004-04-30, System Analyst/Programmer/DBA, Our company owns Vehicle Inspection centers for testing heavy vehicles in Abu Dhabi, Al Ain & Beda Zayed. I Worked as a System Analyst/ Programmer to support migration of vehicle testing Application from Sun to Maha Systems., Developer 2000 – Forms 6i, Reports 3, Oracle 9i – Release 5.8 on Data Server, Windows 2000 on clients, 3 HUMAN RESOURCE & PAYROLL MANAGEMENT SYSTEM (PHASE I), 2002-07-01, Analyst/Programmer, HR & Payroll management system was completely designed and developed based on the Procedures & Policies of Emirates Transport. A study was conducted to identify each & every Function & Process in minute details. Worked as Analyst Programmer, right from the Project initiation to development. Played an active role in documenting user requirements and Logical design. Developed Forms & Reports., ER Win, Developer 2000- Forms6i, ReportVer.3, Oracle 8i - Sun Solaris Release 5.8 on Data server, Windows 2000 Server with Application Server, Windows 2000 on clients, 3 FINANCIAL MANAGEMENT SYSTEM, 2000-10-01 to 2001-12-31, Analyst/Programmer, Worked on Accounts Receivable, Accounts Payable & GL Modules respectively. I played an active role of Analyst during the case study especially of Accounts Payable module and its overall integration and data flow, with other systems like Inventory control, Purchase, GL, Asset, and FMS Modules., Designer 2000 v. 2.1, Developer 2000- FormsVer.5, ReportVer.3, Oracle Ver 7.3 - Sun Solaris Ver 2.51 on Data server, Windows NT Server Ver.4 with Application Server, Windows 95/NT Workstation/95 clients, 3 Y2K COMPLIANCE, 1999-06-01 to 1999-09-30, Programmer, Modified the Effected Forms & reports for Financial Modules., Forms. Ver 3, Report Ver.2, Oracle Ver 7.3, 6 FIXED ASSET SYSTEM, 1998-09-01 to 1999-02-28, Analyst/Programmer, Worked as Programmer in developing the Module, in coordination with Team leader. Designed & Developed Asset Register, Scrap Request, Asset Transfer, Inventory Control, Depreciation & Insurance Processing., Developer 2000 - FormsVer.4.5, Report Ver.2.5, Oracle Ver.7.3 Client Server Architecture - Sun Solaris Ver.2.5.1 on Data Server, Windows NT 4 on Application Server, Windows 95 on clients, 4 Payroll System for M/s Reem Rubbers pvt.ltd., 1998-03-01, Analyst Programmer, Worked on an advance payroll system for a private concern M/s Reem Rubbers pvt.ltd. Application was designed by keeping in mind all Features of a large organization. In this application we have included all the parameters required to calculate the net salary of an Employee. We have designed data entry screens using Forms, and generated the monthly Reports., SQL PLUS 3.3, PL SQL 2.3, Developer 2000 as front end (Forms 4.5, Reports 2.5) on Windows NT 4.0, 5 M/S Barkat Investments, 1997-08-01 to 1998-01-31, Programmer, Worked on an application designed and programmed for M/S Barkat Investments in maintaining their day to day transactions generating monthly reports and keeping a complete account of their customers in an oracle database. Created stored procedures and database triggers to run the application., Developer 2000 as front-end (forms 4.5, reports 2.5), PL/SQL 2.2, 4 Production Inventory Control System for M/s I.B. Corrugations, 1996-11-01 to 1997-05-31, Programmer, Responsible for the programming, implementation of production inventory control system for M/s I.B. Corrugations, Aligarh. Assisted with the design and programming of purchase order subsystems. Required screens were generated for data entry and monthly reports giving a full account of the monthly stock., Developer 2000 as front-end (forms 4.5, reports 2.5), Leo Pentium PC with Windows 95 As the operating system for the front end and a Unix (sco) server was used., 5 Patient Monitoring System for a private hospital, 1996-02-01 to 1996-08-31, Programmer, Involved in programming & designing of the application. This application was designed to maintain all the details regarding the patients admitted in the database. In this system we have generated forms, Monthly reports giving the complete details of the patient right from the date of admission to discharge., oracle 7.1 as back end (SQL plus 3.1, pl SQL 2.1), Developer 2000 as front end (forms 4.5, reports 2.5) for generating data entry screens, 5 UNIX based application for M/S U.P GLUES, 1996-01-01, Programmer, Responsible for the programming; maintenance of UNIX based application for M/S U.P GLUES this application forms a part of a very critical component of an overall MRP 11 SYSTEM. Also assisted the database teams in database modeling right from the conceptual database design (E-R diagram) to logical database design here database triggers were used for the data flow. Appropriate master-detail relationship was also created at the form side., Oracle 7.1 (PL/SQL 2.1, SQL PLUS 3.1), 5 NUMERICAL METHODS AND ANALYSIS, This Project Was Developed For Solving Various Mathematical Equations., C on UNIX Library Information System, Worked on a project on library information system., Visual Basic 3.0/MS Access