SUMMARY:

• More than 12 years of experience with PL/SQL and ANSI SQL Development, SQL Database Development, Dynamic SQL
• More than 10 years of experience in Oracle Database (Table, views, indexs, sequences, synonyms,).
• Perform Performance tuning of complex SQL queries (Explain Plan, Table Partition, Hints, Indexes).
• More than 10 years’ experience with PL/SQL skills, experience in an Oracle 10g, 11g and 12g
• Experience with Oracle OFSAA application
• Full Life Cycle Project Experience starting from System Analysis., System Design, System Integration, Data Modeling and Control, Production System Support, Programming and Training.
• Experience with T - SQL scripts for SQL Server.
• Experience with Analytics, SAS (Statistical Analytical System).
• Extensive experience in porting applications including Informix to Oracle.
• Experience with Oracle Forms & Reports Developer.
• Experience with tableau
• Participated in requirements and design of Data Warehouse Architecture.
• Experience with ETL concepts. ( ODI & Informatica )
• Installation, administration and maintenance of Oracle 11g.
• Experience with Data Management, Data Marts, Data Mapping, Data Modeling.
• Experience with SQL*Loader, TOAD, PL/SQL Developer.
• Experience with data modeling tools like ERWIN.
• Experience with Oracle OLTP and OLAP Data Warehouse
• Understanding of Snowflake and Star Schema design strategies and process.
• Knowledge of Java and WEB Services.
• Experience UNIX and Unix shell scripting and Windows, Linux experience.
• Experience with Asp.net Net C#, Windows Forms, Visual Studio 2010.
• Excellent understanding of Entity Relationship Diagrams (ERDs) and the translationf business requirements into them.
• Installing, operating and maintenance of LAN H.W & S.W.
• Have background in Project Costing and Billing.
• Experience with Data immigration to oracle
• Experience with Oracle DRM (Data Relationship Management).
• Experience with Agile/ Scrum

TECHNICAL SKILLS:

Oracle 10g/11g/12g, PL/SQL, T-SQL, UNIX, LINUX, Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Culver City, CA

Oracle PL/SQL Developer

Responsibilities:

• Perform Performance tuning of complex SQL Queries(Table partition, hints, indexes).
• Perform and maintain the database design Create database objects (Schemas, table space etc.) and Write database procedures, functions, triggers Packages, Views, Cursors and Triggers
• Perform and maintain database security (create and maintain users and roles, assign privileges)
• Work with Oracle 11g
• Write Code Migration experience.
• Installed the Oracle software using silent feature and also created databases.
• Supported & maintained the Production/Development databases on various servers.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Working with SQL Plus and Toad and PL/SQL developer.
• Working on Data Modeling and OLAP technology.
• Working with ETL.
• Optimize Stored Procedures for better performance.
• Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
• Working with Data Modeling, Data source mapping, Production process troubleshooting,
• Working with Unix shell scripting
• Working with Agile/ Scrum

Confidential, San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

• Understand project requirements and develop design specifications.
• Perform and maintain the database design Create database objects (Schemas, table space etc.) and Create object ( procedures, functions, triggers, Exception, Packages, Views, Cursors and Triggers)
• Perform initial design reviews and recommend improvements
• Write Code Migration experience.
• Working with SQL Plus and Toad and PL/SQL developer.
• Working on Data Modeling and OLAP technology & ETL. ( ODI )
• Working on oracle 11g and 12g
• Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
• Working with Agile/ Scrum
• Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines
• Unix/Linux Shell scripting and Windows batch scripts, FTP and SFTP protocols and data transfer processes
• Provide technical assistance to other Developers as needed
• Working with Autosys
• Woring on Oracle OFSAA application
• Working with Installation< -- -->, configuration, patching and upgrading of Tableau tool across the environments

Confidential

Oracle PL/SQL Developer Lead

Responsibilities:

• Understand project requirements and develop design specifications.
• Perform and maintain the database design Create database objects (Schemas, table space etc.) and Create object ( procedures, functions, triggers, Exception, Packages, Views, Cursors and Triggers)
• Perform and maintain database security (create and maintain users and roles, assign privileges)
• Perform initial design reviews and recommend improvements
• Write Code Migration experience.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Working with SQL Plus and Toad and PL/SQL developer.
• Working on Data Modeling and OLAP technology & ETL. ( ODI )
• Write clear codes and prepare coding documentations
• Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
• Working with Agile/ Scrum
• Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines
• Provide technical assistance to other Developers as needed
• Working with tableau migration and scheduling.

Confidential, Germantown, MD

Sr. Oracle PL/SQL Developer

Responsibilities:

• Perform Performance tuning of complex SQL Queries(Table partition, hints, indexes).
• Perform and maintain the database design Create database objects (Schemas, table space etc.) and Write database procedures, functions, triggers Packages, Views, Cursors and Triggers
• Perform and maintain database security (create and maintain users and roles, assign privileges)
• Work with Oracle 10g and 11g and with SQL Server 2005 and 2008.
• Installed, configured, and maintained Oracle 10g and 11 g and Upgraded from Oracle 10g to 11g.
• Write Code Migration experience.
• Installed the Oracle software using silent feature and also created databases.
• Supported & maintained the Production/Development databases on various servers.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Working with SQL Plus and Toad and PL/SQL developer.
• Working on Data Modeling and OLAP technology.
• Working with ETL. ( ODI )
• Optimize Stored Procedures for better performance.
• Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)
• Working with Data Modeling, Data source mapping, Production process troubleshooting,
• Working with Unix shell scripting
• Working with Agile/ Scrum
• Working on Oracle OFSAA application

Confidential, Cary, NC

Sr. Oracle PL/SQL Developer

Responsibilities:

• Perform Performance tuning of complex SQL Queries(Table partition, hints, indexes)
• Develop PL/SQL Procedures, Functions, Packages, Views, Cursors and Triggers with SAS
• Working on Oracle 10g and 11g and with SQL Server 2005 and 2008.
• Installed, configured, and maintained Oracle 10g and 11 g and Upgraded from Oracle 10g to 11g.
• Write Code Migration experience
• Installed the Oracle software using silent feature and also created databases
• Supported & maintained the Production/Development databases on various servers
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Working on SQL Plus and Toad and PL/SQL developer.
• Working on data modeling and OLAP technology.
• Optimize Stored Procedures for better performance.
• Working on UNIX and Windows, Linux.
• Working with Data Modeling, Data source mapping, Production process troubleshooting,
• Perform daily DBA tasks (export, import, review PL/SQL code, deploy releases, …etc)

Environment: Oracle 9i/10g to 10gR2, SQL Server 2005/2008

Confidential, Cairo, Egypt

Lead Oracle PL/SQL Developer / DBA

Responsibilities:

• Perform PL/SQL development for a variety of projects including sales calculations, update tables, query tables and triggers for integration.
• Develop a lot of PL/SQL Procedures, Functions, Packages and Triggers using the new Oracle features like autonomous transactions, start with connect by, analytical functions, etc.
• Convert code from Oracle to SQL Server.
• Analyze problems and create solutions for very complex performance tuning situations.
• Create and modify UNIX Shell Scripts.
• Create PL/SQL scripts for Oracle and T-SQL scripts for SQL Server.
• Perform Data Modeling and Design
• Start to learn Java (Attended training, understood OOB concepts and started to write application).
• Work in Data Warehouse environment and writing PL/SQL code

Confidential, Cairo, Egypt

Oracle PL/SQL Developer

Responsibilities:

• Develop PL/SQL Procedures, Functions, Packages, Views, Cursors and Triggers.
• Perform Performance tuning of complex SQL queries.
• Write technical design specifications for projects.
• Identify any issues as soon as possible in the planning process and resolve them.
• Participate in analysis, modeling, and design.
• Work with Java and WEB Services.
• Perform Export/Import data using Oracle utilities expdp and impdp.
• Performed Data Warehouse processing using PL/SQL Packages, Procedures and Functions.
• Write efficient SQL queries.
• Working on UNIX and Windows, Linux.
• Lead Development team.