Technical Consultant (Data & Integration Architect)
Logic Information Systems
Total des années d'expérience :20 years, 9 Mois
• Analyze, develop and implement the data architecture, data conversion and data migration strategy for the implementation of Oracle Retail Solutions.
• Design, development, and integration of custom ETL code using Unix shell scripting and Oracle technologies by DevOps methodology.
• Ensure that data conversion processes through the Oracle Retail data Conversion tools are efficient.
• Design and Develop Data validation rules (Business rules and technical rules) to ensure data quality and integrity.
• Technical coordination of cross-functional projects as assigned and interact with all areas of the organization to achieve timely results.
• Design, develop and implement integration between different applications using SOAP and REST APIs.
• Analyze, design and develop business applications, KPIs and Dashboards using Oracle Apex - 19/20/21/22 (HTML, CSS, JQuery, Apex Collections and JavaScript libraries) in Cloud environment using Oracle REST Data Services (ORDS).
• Design and develop the REST APIs using Oracle Apex and ORDS to integrate the data between internal systems.
• Develop and implement efficient & highly optimized ETL routines and processes to solve deep technical problems, providing mitigations and root cause analyses.
• Design and implement Data Migration routines for the Extraction of data for multiple retail brands (American Eagle, Boots, Westelm, H&M, Monki, Next & etc.) to Oracle Retail System.
• Provide support for post-go-live conversion issues that may occur.
• Lead all the project and database related activities to monitor and execute the proposed solution with the project teams.
• Analyze business requirements for the system and build the technical design of the system.
• Resolve numerous project issues including staffing shortages, tactical matters and different business and user needs.
• Designed, developed and implemented high availability business applications using Oracle products (Oracle Apex - 19/20/21, Oracle Forms & Reports 12c, Oracle database 18c, Oracle WebLogic 12C, Oracle BI Publisher 12c).
• Developed Oracle Apex business applications using JavaScript libraries, HTML, CSS and JQuery with Agile and DevOps software development life cycle.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Lead and Build the integration routines to send and report different kind of business data to regulatory bodies (SIMAH, SIJIL and BAYAN) by transfer of CSV files via FTP.
• Two-way integration of Internal Financial System with SADAD Payment System for Electronic Bill Presentment and Payment using REST APIs.
• Develop the efficient scripts for Extracting, transforming, Cleansing and Loading the data from staging DB to production DB.
• Monitor, analyze and optimize Oracle Database performance for future expansion using Oracle techniques i.e. AWR, ADDM, EXPLAIN PLAN, TKPROF, and Tracing etc.
• Review and optimize the Queries to improve the performance of the system and reduce the response time.
• Installs, configures and tunes Oracle Fusion Middleware specifically WebLogic and BI Servers and apply patches & updates to ensure compliance with security standards and policies. .
• Upgrade and apply regular security and improvement patches for Oracle Fusion Middleware.
• Guide the work of technical teams with all the technical guidelines and standards.
• Lead all the database related activities to monitor and execute the proposed solution with the project teams.
• Analyze business requirements for the system and build the technical design of the system.
• Ensure performance, security, and availability of databases.
• Designed and Implemented backup and recovery Solution for Databases.
• Setup and managed replication among several databases.
• Designed and implemented high availability solution for database using Oracle, SQL Server and MySQL products.
• Develop the efficient scripts for Extracting, transforming, Cleansing and Loading the data from staging DB to production DB.
• Setup and Implement Database Release Process - As part of go-live need to prepare document, which contain DB architecture for primary and DR sites. SOP to start /stop database and DR switch over to be handover to Operational Support Team.
• Documented and implemented the best practices of Oracle, SQL Server and MySQL Databases for the development.
• Experience as On-Call 24x7-production DBA support.
Projects:
• Flight Ops System: This system provides and supports complete coverage of flight operations processes from Fleet Management, Long Term Maintenance Planning, Tail Assignment, Short Term Maintenance Planning, Pre Ops, Dispatch & Mission Control, Day of Ops Complete Mission Management and Recovery.
• Qloud: This vital Mobility System provides a comprehensive mobility solution for Pilots to have access to all their flight requirement, documentation and company information by using a company issued iPad that will become their main communication tool to cover their full flight requirements in Doha & outstation.
• Crew Metrics: A Data Warehousing application for analytical processing and presenting summary of all the monthly metrics (Resource level, Roster Quality, Operational Performance and Financial Performance) for the Flight Deck and Cabin Crew.
• Mobile Dispatcher: Automates the day to day activities of a dispatcher. It gathers live information from multiple sources on to a single window which will help the dispatcher to have all the information required to dispatch a flight with ease.
• Crew Leave Management System: This system automates the complete process of crew leave management including leaves planning, leaves bidding, leaves allocation/awarding, ad hoc leaves and leaves tracking.
• Electronic Flight Bag Management System: Automates and helps flight crews perform flight management tasks more easily and efficiently by transferring all the relevant data directly to the cockpit from the different ground systems.
• Workflow Management System: Automates and supports business process based integration. It is used to routing information of any type according to business rules within the enterprise.
Job Role/Responsibilities:
• Lead all the project activities to monitor and execute the proposed solution with the project teams.
• Analyze business requirements for the system.
• Design and build the architecture, detailed and technical design of the system.
• Responsible to design, build and implement complete mobile architecture for mobility solutions and multidimensional architecture for data warehousing solutions.
• Integration with other airline related systems such as AIMS (Airline Information Management System), Ground Star, DCS (Departure Control System), BRS (Baggage Reconciliation System), Oryx Cargo System and LIDO (Lufthansa Integrated dispatch Operation).
• Build and implement physical design of the system base on FACT and DIMENSION Tables concept for a warehouse application.
• Liaise and coordinate with the Production DBA’s Team to configure and setup complete Primary (Production) and disaster recovery (DR) environment for implementation.
• Load and Integrate the data into warehouse database from heterogeneous data sources (AIMS, Resource Plan, SSIM File and Jeppesen)
• Data Aggregation and Customization for pre calculated result on the large set of data.
• Develop the efficient scripts for Extracting, transforming, Cleansing and Loading the data from different sources (Databases and file systems).
• Monitor, analyze and optimize Oracle Database performance for future expansion using Oracle techniques i.e. EXPLAIN PLAN, TKPROF, and Tracing etc.
• Review and optimize the Queries to improve the performance of the system and reduce the response time.
• Enhance and propagate Coding Guidelines and Best Practices. Mentor Application developers using these - continuous improvement.
• Build and implement the procedures for MIS reporting and Integrity checks to authenticate the system behavior.
• Build and Implement the database purging and archiving strategy to reduce the size of the database.
• Build and Implement the generalized utility for database auditing to keep track of all the DML statements.
Projects:
• Code Improvement
• Forms & Reports Migration (6i to 10g)
• Document Standardization for Technical Design & Technical Specification documents
• Best Practice Guide (BPG) Enhancement to improve the code quality
• LARA (Line and Agents Real time Application) improvement to optimize and improve the existing code & logics
• Integration of LARA (SOFA) with other systems using Web Services
Job Role/Responsibilities:
• Ensure a thorough understanding of LARA applications and technical architecture
• Specify, design, develop, maintain and troubleshoot software components and framework
• Write technical Design on request and under the supervision of the Application/development architecture manager
• Validate Technical Specifications written by Application Developers
• Enhance and propagate Coding Guidelines and Best Practices. Mentor Application developers using these - continuous improvement
• Conduct code audits - introduce checklists as part of the process to ensure this.
• Liaise with the Application Continuity Team and Production DBA’s for feedback and incorporate this into future developments.
• Provide guidelines to Application Developers for the technical and functional improvement.
Projects:
• Booking and Documentation
• BSR & DSR Enhancements
• Routing Finder
• DIVA Reports
• Export Dashboard
Job Role/Responsibilities:
• Ensure a thorough understanding of LARA.
• Specify, design, develop, test, maintain and troubleshoot LARA.
• Write technical specifications on request and under the supervision of the Domain Team Lead he/she reports to.
• Liaise with customers/suppliers technical contacts to get all necessary details to define comprehensive and consistent technical specifications of the software.
• Develop applications using the technology and framework defined by the CMACGM System IT management group - Oracle Forms/Reports and PL/SQL.
• Participate in defining/validating estimates for the tasks he is in charge of. Is accountable for on time and defect-free delivery of software.
• To ensure time-sheets are timely completed and submitted.
• Continuously update operational data for measurement accuracy across all relevant process areas.
Projects:
• Manufacturing Activities Control System (MACS)
• Educational ERP
• Demand System
• Procurement System
• Inventory Management System
• Move Sanction
Job Role/Responsibilities:
• Application study, system analysis using RUP techniques (Analysis Use Cases, Use Case Model Diagram, Sequence Diagram, Class Diagram and Design Use Cases)
• Involvement in Database designing (part of DB design team)
• Analyze user’s business requirements in detail and proposed new (or changed) system
• Responsible to develop the application using Oracle Developer 6i/9i/10g according to the user’s requirements and specifications
• Write System Development Specifications
• Writing advanced level program routines in Oracle PL/SQL
• Measure application performance using latest Oracle techniques i.e. EXPLAIN PLAN, TKPROF etc
• Understanding of JAVA routines/Predefine Java Components
• Identify technical risks and propose solutions
• Coordination with Quality team to perform complete QALC (Quality Assurance Life Cycle) and to follow CMMI Procedure for the project
• End user training and application user manual
• Oversaw the development inbox for products defects, performing troubleshooting activities and responsible for the implementation of critical fixes for application
• Coordinate with junior team members to guide for the betterment of application
• Unit testing before delivery
Projects:
• Sales & Purchase System
• Inventory Control System
• General Ledger
• Distributed Database Implementation
Job Role/Responsibilities:
• Requirement elicitation
• Database designing
• Software Interface Designing
• Software development & troubleshooting
• System Deployment Plans and end-user training
• Unit testing before delivery
Enterprise architect (TOGAF 9 Foundation level)
Certification Name Max. Marks Obtain Marks Advanced PL/SQL Developer Oracle11g : 68 66 SQL (1Z0-146)
Certification Name Max. Marks Obtain Marks Introduction to Oracle9i : 52 51 SQL (1Z0-007) Program with PL/SQL (1Z0-147) 66 65 Oracle Forms Developer : Build Internet Application (1Z0-141) 69 67