Experience

IME

• United Arab Emirates
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Management Consultant

  • Sep 2022 - Present

  • Tracing problems across ETL maps and Oracle Database and provide solutions. • Developing/Modifying ETLs according to bank’s new requirements. • Develops PowerCenter Workflows and Sessions, and also sets up Power Exchange connections to database and mainframe file. • Design, Develop and Test ETL Mapping, Mapplets, Workflows using informatica Power center. • ETL Mapping, Mapplets, Workflows using informatica Power center • Informatica Data quality, informatica data archive. • Extracted data from flat file applied business logic to load them in the staging database. • Wrote Oracle package and functions to implement business rules and transformations after staging is done. Working with various transformations like router, expression, SQL, lookup, normalizer, and aggregator in building complex mapping. Show less



Optimum Solutions - Outsource at Ooredoo - Telecommunications company

• Doha, Qatar

• Data Engineer Team Lead

  • Jun 2019 - Aug 2022

  • Requirements gathering, analysis, design and documentation activities Involved in SSIS jobs and development tasks and provided few quick solutions which helped to ease the implementation which extracts the data. • Perform source system analysis, provide estimations and prepare technical design documents. • Responsible for Mapping of Business Requirements related to SSIS into technical specifications. • Design and Development of SSIS Jobs from Source to Data Mart Model and Aggregations. Show less



Optimum Solutions - Outsource at Kahramaa - Electricity generation company

• Doha, Qatar

• Senior Data Engineer

  • Jul 2016 - May 2019

  • Provided support for customer issues on site and tackled various performance issues in SSIS/database scripts in fleet management system project. • Maintain existing data pipelines to apply new requirements or to solve performance issues. • Integrate data from data warehouse to other systems and teams as needed • Provided support for customer issues on site and tackled various performance issues in SSIS/database scripts in fleet management system project. • Maintain existing data pipelines to apply new requirements or to solve performance issues. • Integrate data from data warehouse to other systems and teams as needed



Optimum Solutions

• United States
• IT Services and IT Consulting
• 100 - 200 Employee

• Project Manager & Data Engineer

  • Jan 2014 - Jun 2016

  • Revamp fleet management system web-based application with mongo database and SQL to optimize performance. • Integration with IOT devices and making data analysis on devices data. • Using SSIS to manage data from ERP, CRM, CMS to warehouse using SQL Server Integration Service (SSIS). • Revamp fleet management system web-based application with mongo database and SQL to optimize performance. • Integration with IOT devices and making data analysis on devices data. • Using SSIS to manage data from ERP, CRM, CMS to warehouse using SQL Server Integration Service (SSIS).



NAT solutions

• Egypt
• Software Development
• 1 - 100 Employee

• .Net Team Lead

  • Oct 2012 - Dec 2013

  • Booking/Reservations app: A complete booking system with a very tailored work flow and includes epayment, used by major restaurants and other types of businesses. • Business hub: ERP system that includes (Inventory, procurement, sales & POS, finance, production, fleet management, HR and CRM) currently used by major clients. • Coument System: Courier company system that covers Operations and CRM modules and acting as 3PL to major companies like Jumia and Oriflame with thousands of daily transactions. • Restaurant hub: ERP for Restaurants that covers the complete work flow of restaurants, currently used by major restaurants. • Disney System: A system dedicated to tourism companies that covers complete work flow of this business. • Act: A system used for data visualization and generating info-graphic reports based on real live data. Show less



International and Local Technology Agents (ILTA Group) - Outsource at Tallat Moustafa Group (TMG)

• Cairo, Egypt

• Oracle and ECM Developer

  • Mar 2011 - Sep 2012

  •Saperion ECM Installation & implementation forms on Talaat Moustafa Group (TMG). • Making Analysis on customer meta data Documents to Create Forms Using Saperion ECM and Oracle 11g R2 and generate reporting to that required by management. • Manage the customers Documents and making the security on the documents and working on many web application using SQL. • Worked with CDC team to make a Replication between two Servers have ERP System the first server in ELDoky and the Other in ElRehb to make the Two servers working on the same Oracle Database and the same ERP System. • Make a forms and reports to Alaqareya Department to manage The customers Documents and manage it and make The employees manage these forms using The Client Server protocol. Show less



International and Local Technology Agents (ILTA Group)

• Cairo, Egypt

• Software Developer .Net Developer

  • Oct 2010 - Feb 2011

  Build middleware platform with .Net framework to integrate with Saperion ECM to handle module of electronic signature in Saperion using it in a custom workflow to handle employee vacation request process. Build middleware platform with .Net framework to integrate with Saperion ECM to handle module of electronic signature in Saperion using it in a custom workflow to handle employee vacation request process.