Senior Oracle DBA and IT Project Manager

Muhamad ElHady

DW Project Lead & Senior Oracle DBA Consultant

Address : Cairo Egypt Cell : 002*********** Email : *******.*******@*****.***

Summary

•Adaptability, determination are the key attributes that have contributed to my success during the last 15 years of increasingly responsible DW Project Lead & Sr. Oracle DBA Consultant positions

•Comprehensive experience encompass so many thing from DBA Staff Oracle database, Linux,PL/SQL, to Data Warehousing staff like SAS Analytics tools SAS DI,BI, Cost and profitability

•Completed PMP preparation course while preparing for PMP exam is in progress

•Well versed in Oracle Performance Tuning applying state-of-art facilities available in Oracle that Lead to reduce STC Costing Data warehouse solution loading from 15 hour to 50 Minutes

•Oracle Certified Professional (OCP) in Oracle 9i, 10G, 11g DBA

•Managing Oracle Database on Linux Certified Expert

• Experienced with PL/SQL, SQL, and Shell scripting

• Experienced with Data warehouse Dimensional Modeling

• Experienced with Data warehouse Life Cycle & ETL Life Cycle

•Deep understanding of Telecom Business Process eTOM

Education

BSC in Communication and Electronic Engineering (1998) Ain Shams University Cairo -Egypt

Work Experience

DataGear Company Egypt Jan 2012- Present (3 Years 10 Months)

Saudi Telecommunication Company (STC) (11 months)

Project: SAS Costing Solution (ABM) Upgrade and Migration Project

Roles : Outsourced to SAS as Project Tech Lead & Senior Oracle DBA Consultant

Responsibilities:

Was responsible for defining Statement of Work setting project goals and milestones

Build Project plan, systematically identified stakeholders (with specific interest) in each subject area, developed requirement documents and project task time-lines.

Performing Customer Environment assessments and provide the suitable recommendation.

Ensure the timely completion of planned proactive tasks and Customer Requests in best quality

Lead the team responsible for upgrade SAS infrastructure &Applications from release 9.1/win to 9.3/ Linux

Fine-tuned technical issues through validating, troubleshooting, and monitoring systems infrastructure and technical support needs. Oversaw status updates and milestone reporting.

Mohamed Successfully implemented Cross Platform database upgrade and migration from 10g2 /win 2003 to 11gR2/Red hat 6.5 on Production & Development servers remotely with zero impact to productivity, leading all aspects of adoption stages and data management requirements.

Guided 12 team members; consulted with business units, created use cases, and activity diagrams detailing the IT methodology, engagements, standards, resources, risk, and status.

Saudi Telecommunication Company (STC). (21 months)

Project : SAS Cost and profitability Data warehouse Technical Performance Enhancement Project

Role : Outsourced to SAS as DW Project Technical Lead / Senior Oracle DBA Consultant

Responsibilities:

Lead team of ETL and BI Developers to designs and develops enhancement solutions for STC Cost and profitability Data Warehouse., Apply Process analysis to analyze business processes - Built systematic methods for recording and analysis of legacy SQL code (reverse engineering) in order to identify business rules, then used methodology to

Conduct a rigorous analysis of legacy Costing systems.

Analyzed business rules, effectively aligned them to development of strategic and tactical planning initiatives; addressed ad hoc reporting issues, diagnosed and validated redesign specifications and assisted with end user testing and training for assigned client members.

Lead system analysis and walkthroughs with business partners to ensure effective translation of business and user requirements, technology plans, strategies and application development.

Designed and implemented a comprehensive Web UI environment

All designs were accompanied with Conceptual, Logical and Physical Data models.

All designs were accompanied with comprehensive documentation tailored to different stakeholder.

Preform Business analysis to the whole ABM solution and provided a Solution Design Document to update the ABM Costing model through web Application that enforce business rules and guarantee a bulky update for the model structure

Support handover “the Costing Data warehouse Solution “from Costing Department to IT Department.

Mohamed is Well versed in Oracle performance tuning applying state-of-art facilities available in Oracle that Lead to reduce Data warehouse loading from 15 hour to 50 Minutes

Handling Customer On site tasks, including planning and implementing backup and recovery strategy

Provided a Solution Design Document to automate the ETL Run Cycle

National Bank of Egypt (NBE). (7 months)

Project: Oracle Data Warehousing Project

Role : Business Analyst & Senior Oracle DBA consultant

Responsibilities:

Analyze business processes, build requirements, specifications, and workflows; formulate project plans, design and functional specifications, and assist with end user training for assigned projects.

Assisted management implementing a data warehouse and feasibility determination, and change control.

Responsibilities included physical design, logical design, Identified data sources, designed and implemented an ETL architecture

Mohamed provide Performance tuning Consultation for SQL Scripts that upload the DW in ETL jobs

Mohamed Tuned Database Server involved in building data warehouse

Zain Saudi Telecom. Company (5 months)

Project: Oracle Data Warehousing Project

Role : Business Analyst &Senior Oracle DBA consultant

Responsibilities:

Back line Senior DBA Consultant analyzing and Tuning SQL queries involved In ETL jobs For better performance

Analyzed business rules, effectively aligned them to development of strategic and tactical planning initiatives; addressed ad hoc reporting issues, diagnosed and validated redesign specifications.

Work with developers in the application design phase for better application performance

Saudi Binladen Group (SBG) - Saudi Arabia April2001- Oct 2011 (10 Years 6 Months)

Project: Payroll application for Permanent and seasonal employee (8months)

Role : Project Lead/Business Analyst (8 months)

Responsibilities:

Developed and documented project plan, reported, tracked, and prioritized critical path, liaised between business units and Developers, and provided input into requirements, timelines, and technical design reviews.

Executed technical design documentation, detailed process flows, QA/quality assurance, critical path, data lineage and traceability to seamlessly translate BRDs functional specifications.

Steered life cycle phases; created work flows and sequence diagrams, performed requirements gathering, status reporting, and managed interface processes between systems.

Developed and documented project plan, reported, tracked, and prioritized critical path, liaised between business units and Developers, and provided input into requirements, timelines, and technical design reviews.

Role: Senior Oracle DBA & Linux Administrator (7 years 9 months)

Responsibilities:

Installed & configured Oracle Database 9i,10g,11g on Win/Linux OS

Oracle Database Server Performance tuning

Administered and provided regular DBA tasks to the several databases

Successfully implemented Standby database as a high availability solutions using Oracle Data Guard technology for business critical databases configuring

Create and implement backup recovery strategies using Data Pump

Real Application Clusters (RAC)

Security Administration

Data Replication

Database Design

Recovery Manager (RMAN)

Oracle Enterprise Manager (OEM)

Bash Shell Scripting

Red Hat Linux Administration

Role: Business Analyst and BI Developer. (2 years 1 months)

Responsibilities:

Prepared ad-hoc reporting queries addressed business needs using Cognos reporting and analysis tool

Heliopolis for Chemical Industries Company Egypt 2000- April 2001 (10 Months)

Role: Electronic engineer

Responsibilities:

Performed the actual Preventive & Corrective Maintenance

Certifications and Training Courses

Certifications

Training Courses

Project Management Earned Value Management (EVM)

PMP in Progress

Managing Oracle Database 10g on Linux Certified Expert

Oracle Database 12c new Features for Administrators

Oracle Certified Professional (OCP) in Oracle 10G DBA

Oracle Data Integration ODI

Oracle Certified Professional (OCP) in Oracle 9i DBA

Oracle Database Security

Platform Administration for SAS 9

Data warehouse Dimensional Modeling

Data Integration Development for SAS 9

Data warehouse Life Cycle & ETL Life Cycle

SAS Data Integration For Activity Based Management 7.x

Teradata Communication logical Data model (CLDM)

SAS Modeling For Activity Based Management 7.x

SAS Cost and Profitability (Previously ABM)

SAS Reporting For Activity Based Management 7.x

SAS Enterprise Guide, SAS BI, SAS Programming

Programming {C,C++,VC++,VB}

Contact this candidate