Service Delivery Manager

• Oct 2010 - Present

Data Management Specialist

• Aug 2019 - Aug 2022

• Conduct an architectural system evaluation. • Analyze technology environment. • Define a collaboration framework. • Working with stakeholder to define the vision and implementation strategy • Determine the solution road map and add value • Analyze technical and business requirements. • Define a procedure and process to ensure solution delivery. • Create a solution prototype. • Conduct an architectural system evaluation. • Analyze technology environment. • Define a collaboration framework. • Working with stakeholder to define the vision and implementation strategy • Determine the solution road map and add value • Analyze technical and business requirements. • Define a procedure and process to ensure solution delivery. • Create a solution prototype.

Senior Technical Lead and solution architect

• Oct 2018 - Jun 2019

• Gathering Business requirements • Focuses on enterprise-wide data modeling and database design. • Creates logical and physical data models, mapping logical to physical. • Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes. • Coordinates with other Data Warehouse IT stakeholders to ensure overall health and performance of the data warehouse environment. • Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools. • Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment. • Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products. Show less

Senior Data Management and Solution Architect

• Apr 2018 - Oct 2018

• Define the relationship between enterprise architecture and solution architecture • Receive and manage the Business expectations • Design and implement the solution architecture includes business architecture, information architecture, application architecture, and technology architecture operating at a tactical level • Define the DQ issue that can impact the solution and propose the required solution • Preparing and maintaining project, stage and project risks • monitoring overall progress and use of resources • applying change control and configuration management processes • managing project administration Show less

Technical Solution architect

• Jan 2018 - Feb 2018

• Receive and manage the customer expectations • Preparing and maintaining project, stage and project risks • monitoring overall progress and use of resources • applying change control and configuration management processes • maintaining an awareness of potential interdependencies with other projects and their impact • adopting and applying appropriate technical and quality strategies and standards • managing project administration • preparing any follow-on action recommendations Show less

Senior Data Architect

• Apr 2017 - Sep 2017

• designing and applying appropriate project management standards from technical point of view • managing the production of the required deliverables • planning and monitoring the project • preparing and maintaining project, stage and exception plans as required • managing project risks, including the development of contingency plans • monitoring overall progress and use of resources • applying change control and configuration management processes • reporting through agreed lines on project progress through highlight reports and end-stage assessments • maintaining an awareness of potential interdependencies with other projects and their impact • adopting and applying appropriate technical and quality strategies and standards • identifying and obtaining support and advice required for the management, planning and control of the project • managing project administration • conducting a project evaluation review to assess how well the project was managed • preparing any follow-on action recommendations Show less

Data Architect

• Oct 2016 - Feb 2017

• Define project scopes and objectives, involving all relevant stakeholders • Following the new Data Governance Process, define the Business Terms • Coordinating internal resources and BBI for the flawless execution of projects • Update the Glossary at project review to reflect changes • Ensuring that all projects are delivered on-time, within scope and within budget • Ensuring resource availability and allocation • Develop a detailed project plan to track progress • Measure project performance using appropriate systems, tools and techniques • Manage the relationship with the client and all stakeholders • Perform risk management to minimize project risks • Review and Validate the implementation approach • Create and maintain project documentation Show less

Technical Solutions Architect

• Feb 2016 - Aug 2016

DWH lunch and full ETL implementation project - Maintaining a productive working environment for development teams - Representing the technology perspective on a management - Establishes and/or co-ordinates programmers of work (delivered through development) - Responsible for overall IT headcount - Ensures overall application architecture suitably fits the business problem - Prepare proper planning and defining scope - Prepare the project status and communicate with the stakeholders - Prepare resource planning to achieve the best resource utilization - Work across multiple functional projects to understand data - Analyzed the systems to make appropriate recommendations in implementing changes - Review and validate End to End ETL Design & implementation based on Talend Show less

Data Integration Manager

• Feb 2015 - Nov 2015

new DWH model and full ETL implementation project - Prepare proper planning and defining scope - Prepare resource planning to achieve the best resource utilization - Work across multiple functional projects to understand data - Assist in designing, planning and managing the data migration process - Analyzed the systems to make appropriate recommendations in implementing changes - Maintain Green Plum Server and handling all DBA activities - Design and implement the Project architecture - Review and validate End to End ETL Design & implementation based on Informatica velocity Show less

Data Integration Specialist

• Dec 2014 - Jan 2015

Establish Data integration environment - Prepare the Pre-requisites Hard and software - Test the Servers and accessibility - Design Informatica Platform architecture - Install and configure the Informatica platform - Prepare the required documentation - Train the current IT team members how work with Informatica Establish Data integration environment - Prepare the Pre-requisites Hard and software - Test the Servers and accessibility - Design Informatica Platform architecture - Install and configure the Informatica platform - Prepare the required documentation - Train the current IT team members how work with Informatica

Business Analyst Consultant

• Nov 2014 - Nov 2014

- Prepare Full analysis for data integration system - Identify the Data integration issues, Gaps and challenges - Identify the ETL Performance bottle nick - Provided recommended solutions for the development and performance issues - Provide the required architecture for the ETL platform - Prepare Full analysis for data integration system - Identify the Data integration issues, Gaps and challenges - Identify the ETL Performance bottle nick - Provided recommended solutions for the development and performance issues - Provide the required architecture for the ETL platform

BI Team Lead

• Jun 2013 - Aug 2014

ODS Decommission “Provide data to seven down streams from DWH instead of “ODS system” - Understand the ODS solution and architecture- Understand and analyze the Down streams and Business Users requirements- Prepare the required Source to Target matrix- Implement processes and logic to extract, transform, and distribute data across one or more downstream- Develop quality standards to ensure data quality and integrity across various database systems- Optimize data integration platform to provide optimal performance Show less

BI Team Lead

• Jun 2013 - Aug 2014

BSCS / DWH Integration “Integrate BSCS system with CLDM”- Work with Analysts and Business Users to translate functional specifications into technical designs- Conceptualized designs and code reviews.- Design, development and IT implementation experience- Conducted performance monitoring, product evaluation and profitability analysis- Developed scripts to automate administration and management of the environment- Implement processes and logic to extract, transform, and distribute data across one or more data stores- Develop and document the data audit, archiving, and restoration processes Show less

BI Team Lead

• Jun 2013 - Aug 2014

BTeq scripts convention- Design, development and IT implementation experience- Analyze the BTeq scripts- Educated the team regarding quality assurance and operations measures for developed solutions- Handled design and development peer reviews- Develop data integration standards according to the organization's information- Develop the required Teat cases- Develop quality standards processes- Optimize data integration performance

Technical Project Manager

• Dec 2013 - Mar 2014

DWH Migration “Migrate the DWH data and jobs from Teradata to Netezza pure system”- Lead a team of Data Integration, Data Warehouse and Data Quality Developer on migrating current DWH & ETL Process from Teradata to Netezza covering a full revamp of the ETL process & DB structure- Prepare proper planning and defining scope- Prepare resource planning to achieve the best resource utilization- Work across multiple functional projects to understand data - Assist in designing, planning and managing the data migration process- Analyzed the systems to make appropriate recommendations in implementing changes- Maintain Netezza Server and handling all DBA activities- End to End DBs Design & implementation Using Netezza DB implantation best practice- Solve the DB issue and performance problems- Optimize Netezza DB performance- Monitoring the DB capacity and compress ratio- Design and implement the required user matrix- Design and implement the required user Profile- Maintain the History data- Develop logical design , processes, and standards to the whole project- Develop and document the data audit, archiving, and restoration processes- Provide problem-solving expertise- Convert Teradata Functions to Netezza functions- Develop quality standards- Implement quality processes to ensure the data accuracy between Teradata and Netezza- Optimize data integration platform to provide optimal performance under increasing data volumes- Made Proper handover to Etisalate DBA for Netezza server Show less

Data Integration Specialist

• May 2013 - May 2013

Informatica Domain Migration - Prepare the required analysis to the current environment - Work side by side with Djezzy Team (DBA, Admin system & Network team) to put the best way for Domain migration - Take the required backups - Prepare recovery processes and rollback plan in case of issues - Design and implement the Informatica Domain migration from DB server to another one - Prepare and implement the required testing - Handover with OTA team - Prepare Documentation for all re-designed mappings Show less

Data integration administrator

• Feb 2013 - Feb 2013

Lead BBI team for ETL servers migration from 8.6 to 9.5 for OTH-Algeria DWH team - Prepare the required analysis to the current environment - Design and implement the ETL server architecture - Informatica 9.5 Installation and configuration - Design and implement the ETL migration from 8.6 to 9.5 - Converted all the required processes to match the new environment - Fix ETL Workflow Gaps. - Handover with OTA team - Prepare Documentation for all re-designed mappings Lead BBI team for ETL servers migration from 8.6 to 9.5 for OTH-Algeria DWH team - Prepare the required analysis to the current environment - Design and implement the ETL server architecture - Informatica 9.5 Installation and configuration - Design and implement the ETL migration from 8.6 to 9.5 - Converted all the required processes to match the new environment - Fix ETL Workflow Gaps. - Handover with OTA team - Prepare Documentation for all re-designed mappings

Senior Data Integration at (Nadjma)

• Aug 2012 - Jan 2013

Full ETL Migration and Data Quality project for WTA to migration the Current ETL process from SAP Data Service to Informatica as well as Implementation of data quality strategy with implication of business users in order to analyze data, define the rules, integrate• Responsible for overall project quality and timeliness of deliverables• Responsible for managing and leading BBI Resources• Generate weekly Project Progress Report for Status, Risks and Achievements• Responsible for acceptance and handling of Design Change Requests outside the initial project scope• Responsible for Collecting and Analyzing NEDJMA Business/ BODI ETL Requirements• Liaising with BBI technical leads for mapping of requirements to technical specs• Managing customer expectations in terms of the scope and functionality of deliverables• Responsible for Mapping of Business Requirements related to Data Quality and Data profiling ,• Variables Model into technical specifications• Design and Development of Data Quality rules and Profiling KPIs• Providing detailed documentation for the deliverables• Responsible for unit and integration testing of all technical deliverables Show less

Senior Data Integration

• Jan 2012 - Sep 2012

Full DWH revamp project for WTM including migration for the Current ETL process from DATASTAGE to Informatica as well as Migrating current BI tool from Cognos to SAP-BusinessObject while implementation for fully new DWH telecom Models for the main DWH subjects area (Subscribers Bases, Service and Revenue for• Collecting and Analyzing WTM functional requirement Requirements• Design overall ETL structure based on Business Requirements and solution deign document• Development for the End-To-End ETL integration controlling System for Controlling the Daily ETL Load.• Development the ETL mapping to extract data from Sources Systems to DWH• Delta Staging Area• Handling design changes as well as release Management• Prepare the test cases for each developed mappings.• FIX ETL Development Issues.• Generate weekly Project Progress Report for Status, Risks and Achievements• Providing Model Documentation and Handover. Show less

Senior Data Integration

• May 2011 - Oct 2012

Join VFE Commission systems team as a Data Integration expert for addressing their current data integration challenges based on Informatica as well as managed to deploy the Commissioning Cycle to production and pass the UAT phase (Using Data Stage and Informatica OEM at Commissioning): • Execute Gathering statistics about commission system • Checking Data Integration Logic for each Event • Check and Validate Dependencies Between Events • Fix ETL Workflow Gaps resulting wrong commissioning calculations. • Analysis of (Longest path) that have an impact performance • Analysis of each Task to identify performance bottlenecks and do the proper changes for enhancement the performance with more than 70% • Contact with Business to create new events. • Configure new events and interfaced • Prepare require script for NDC (Number digit change). • Prepare recovery scripts • Apply the NDC project on commission tables • Perform performance Enhancement decreasing the execution window from 11 hours to 2 Hour Show less

Senior Data Integration Consultant

• Dec 2011 - May 2012

Working with BBI team and Openet team on BI project for Mobinil including Extract data from Openet CDRs and load into Mobinil DWH • End-to-End responsible for BBI Deliverables and team management • Strategy, Analysis and Quality Assurance Responsibility • Project Status Reporting • Responsible for detailed requirements analysis and documentation • Design of ETL Mappings and Logic • Optimization of Developed Mappings for efficient execution • Identify and raise possible data quality issues impacting ETL • Reporting and follow-up on resolution of all defects or issues impacting ETL Show less

Data Integration Team Lead

• Nov 2011 - Dec 2011

Joining BBI Implementation team for kick-off the Real-Time ODS Project for Etisalat Misr using Informatica Changing Data Capture CDC to perform a real-time extraction from BSCS into the new ODS Database for the main BSCS Customer/Contracts/Services and Kernel Tables. • Installation and configuration for Informatica 9.1 based on high availability environment “Active-Passive” • Installation for Informatica PowerEchange on the source CDC database service for listing on such changes on the BSCS Source Database. • Configuration for Informatica engagement and folder Structure as well as Define the • ETL Development Standard and Shared Metadata and Centration Concept • Analysis for the source Systems tables as well as work closely with ETS Misr DWH • team on Understanding and finalize the ODS final Targets Development for the CDC ETL process templates Show less

Senior Data Integration Consultant

• Feb 2010 - Dec 2011

Joining BBI team for to migrate the Billing system full data from BSCS7 to BSCSIX: o Upgrade Morocco telecom billing system “BSCS” from “BSCS7” to “BSCSIX”. o Migrate the old data from “ BSCS7 “ tables to the new version tables “BSCSIX” in consideration the handling of differences between the two versions database tables. o Intensive use of Informatica in Data Migration of over 1 billion records per table. o Applied Performance Tuning Techniques of Powercenter to optimize CPU and Memory utilization o Build Development Environment. o Prepare the test cases for each developed mappings. o Prepare test scripts for each developed mappings. o Testing/FIX ETL Development Issues. o Analysis for the new Development for the New BSCSIX tables. o Prepare ETL Development for New BSCSIX Tables Show less

Senior Data Integration Consultant

• Oct 2010 - Jan 2011

Joining BBI Implementation team for Vodafone Egypt Seibel Data Arching project using Informatica covering the following • ILM “Data Arching” covering the following responsibility • Execute Gathering statistics about Siebel environment and capacity planning for arching Database. • Checking installation prerequisite and Stability of the environment. • Install and Configure Informatica Data Arching “ILM” application. • Configure ILM data archive environment. • Install Siebel Business accelerators. • Handling accelerators (ILM metadata) based on confirmed business rules for Arching scope. • Developed and run archiving cycles. • Performance Tuning for arching process to minimize the time to retrieved, • load and clean the arching data • Prepare Documentation for ILM Data archive. • Configure Siebel Application Seamless layer that enable VFE to access both Environment data (prod and Arch) Show less

Senior Business analyst

• Jul 2010 - Oct 2010

Joining BBI Assessment and Enhancement team for preforming a quick win ETL enhancement project for OTH-Algeria DWH team • Analysis of (Longest path) that have an impact on the beginning and the end of the • Workflow. • Analysis of each Task to identify performance bottlenecks • Re-organization ETL workflow based on careful analysis • Converting Hand coding SQL scripts (Teradata scripts) into ETL mappings. • Converting Source Qualifier SQL coding into ETL functional Mappings • Consolidating for current transformation logic and data cleansing requirements • Review and redevelop some of the major ETL jobs to breakdown the overall ETL into more sub- processes that utilize temporary mapping tables • Review Recovery Strategy across the Current ETL Sessions/workflow parameters. • Change Default Objects names to Correct Relevant name. • Fix ETL Workflow Gaps. • Set Recovery strategy to ETL Workflow. • Handover sessions with OTA team • Prepare Metadata for Re-designed ETL Tasks • Prepare Documentation for all re-designed mappings Show less

Oracle DBA and Business Intelligence Specialist

• Apr 2004 - Feb 2010

Oracle DBA and Business Intelligence Specialist :- ــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ Interfacing with customers and end-users to collect, document end-users BI requirements .Designing data marts and warehouses .Formulating user requirements into analytical reports using different reporting and analysis tools such as Business Objects .Design/develop business objects universes .Develop jobs to extract and load data into data marts and warehouses using Informatica. .Administering and performance tuning of reports, databases, and data warehouses .Installing and upgrading the Oracle server and application tools. .Develop backup strategy and implementation of disaster recovery . Plans using RMAN .Monitoring and optimizing the performance of the databases. Show less