ABDELSALAM ELSHARIF, Senior Oracle Developer

ABDELSALAM ELSHARIF

Senior Oracle Developer

Gulf computers LLC

Location
United Arab Emirates - Dubai
Education
Diploma,  Project Management Professional (PMP) 5TH Edition
Experience
16 years, 11 months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 11 months

Senior Oracle Developer at Gulf computers LLC
  • United Arab Emirates - Dubai
  • My current job since May 2012

• Senior Oracle developer at Gulf Computers LLC (UAE) since May 2012 until now.
Working at client side (Dubai Courts)
Role : Senior Oracle Developer
Responsibilities:
 Worked on courts projects involving Oracle RDBMS and Developer 6i, 10g, 11g.
 Develop new system to manage cases types and financial transactions related to cases .
 Develop Reports to be in many form like (Word, Excel, PDF)
 Interact with development team to find out the solution keeping in mind the requirements provided by the customer.
 Worked extensively on oracle forms which includes usage of oracle forms tool bars, libraries, alerts, templates, calling forms from forms and reports from forms.
 Developing new forms based on single table and multiple tables, single or multiple database blocks, Used pop up menu, alerts, program units, LOVs, visual attributes and libraries to make the front end application to make it user friendly interface as much as possible.
 Designed and developed more than reports using oracle developer 6i.
 Written complex SQL queries using sub queries, inline views and joins.
 Developing new forms based on single table and multiple tables, single or multiple database blocks, Used pop up menu, alerts, program units, LOVs, visual attributes and libraries to make the front end application to make it user friendly interface as much as possible.
 Developed and enhance multiple Oracle Forms to improve the user friendly interfaces.

Job Course:
 Project Management Professional (PMP) 5TH Edition
Topics : 1- PROJECT INTEGRATION MANAGEMENT .
2- PROJECT SCOPE MANAGEMENT
3- PROJECT TIME MANAGEMENT.
4- PROJECT COST MANAGEMENT.
5- PROJECT QUALITY MANAGEMENT.
6- PROJECT HUMAN RESOURCE MANAGEMENT.
7- PROJECT COMMUNICATIONS MANAGEMENT.
8- PROJECT RISK MANAGEMENT.
9- PROJECT PROCUREMENT MANAGEMENT.
10-PROJECT STAKEHOLDER MANAGEMENT.

SENIOR ORACLE DEVELOPER at SMARTCARD
  • Egypt - Cairo
  • July 2011 to June 2012

 Senior Oracle developer at Smart Card company since May 2011 to May 2012 .
Role : Senior Oracle Developer
Responsibilities:
 Analyze and design and develop Solidarity system project that use for ministry
of solidarity in Egypt.
 working with large-scale (100+ entities) relational data models.
 leading development team.
 Write scripts with SQL, PL/SQL, performance tuning techniques for working with very large volume tables.
 Excellent communication and facilitation skills.
 make implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end-user tools, database and SQL performance tuning.
 Identify business and functional requirements, and actively participate in the requirements, design and build phases; delivering high quality deliverables
 Direct interact with client.



Job Course:
 ORACLE Application (E-Business) Technical Consultant
Topics : 1- Oracle E-Business Suite Essentials .
2- API's & Interface tables.
3- Oracle Concurrent Program.
4- Forms personalization.
5- Oracle Alert Manager.
6- Oracle Discoverer.
7- BI publisher(XML).
8- Oracle Work Flow.

SENIOR ORACLE DEVELOPER at OFISSOFT
  • Egypt - Cairo
  • June 2008 to July 2011

• Oracle developer at Ofissoft company from June 2008 to April 2011.
Role : Oracle Developer
Responsibilities:
 Working on (El-Motkamel) ERP system that local ERP have all modules (Modifications & Maintain bugs).
 Mainly I was responsible of any issue or modification on costing and planning and general ledger modules plus fix bugs and modify some issues in stores, customer and sales, vendors, point of sales modules.
 Design, develop and implement new small modules like (Cost by ratio, Attendance) .

 Working at very large-scale DB objects like(DB triggers, tables, views, materialized view)
 Working with very large numbers of clients.
 Worked directly with the customers to gather requirements to prepare Business Process requirement (BPR) and Software System Requirement (SSR).
 Worked on multiple projects involving Oracle RDBMS and Developer 10g.
 Interact with development team to find out the solution keeping in mind the requirements provided by the customer.
 Design and Development of external interfaces using sql scripts .
 Fix day to day issues in oracle forms (10g) and oracle reports(10g)
 Worked extensively on oracle forms which includes usage of oracle forms tool bars, libraries, alerts, templates, calling forms from forms and reports from forms.
 Designed forms which have base table setup and mater detail forms.
 Write triggers at forms and database level to validate the application level as well as business level validations.
 Designed and developed several reports includes almost all format of reports which included tabular, form like, group above, group left, matrix and matrix with group.
 Used triggers at report level as well like before after report and other components of reports like formula column, summary columns and place holders, additional layouts and conditional formatting.
 Written scripts which are used to modify the database schema like changing table definition, adding or modifying existing triggers, packages, procedures or functions.
 Debugging and enhancing existing applications.
 Designed and developed more than reports using oracle developer suite 10g.
Job courses
1- E- Business Financial consultant
2- ADF course
Topics : J2SE, J2EE, ADF .

ORACLE DEVELOPER at NEW SOFT
  • Egypt - Cairo
  • April 2007 to June 2008

• Oracle developer at New Soft company from April 2007 to May 2008.
Role : Oracle Developer
Responsibilities:
 Participate in developing new company's ERP system.
 Develop new solution that manage & control stores, accounts, fixed assets & retails using Oracle DB 10g and Developer suite 10g tools.
 Maintain existing software (Solving bugs - Adding new features - Testing - Reports… Etc).
 Participating in system analysis & design for new module like (General ledger).
 Develop & improve GUI.
 Implementing & tracking the software life cycle.
 Performed application development and database application programming using Developer/Designer 6i and Uniface developing tools on an Oracle database.
 Worked on design, development and conversion for several other projects using Oracle and Uniface developing tools and Oracle database.
 Design and development using Oracle database platform including building packages, procedures and triggers. Oracle, PLSQL, SQL programming, Forms, Reports, WINDOWS environment.
 Interact with the customers to understand the requirement to generate the process flows of the system.
 Worked with testing team in testing the application after any issue is fixed or any enhancement in the application .

 Heavily worked on SQL and PL/SQL at database level creating Database functions, procedures and triggers.
 Writing scripts for creating primary database objects (tables, views, indexes) using oracle.
 Used triggers at report level as well like before after report and other components of reports like formula column, summary columns and place holders, additional layouts and conditional formatting.
 Designed and developed more than reports using oracle developer 6i.
 Written complex SQL queries using sub queries, inline views and joins.
 Created template that can be used to maintain the look of the application throughout the development, which consists of visual attributes, alerts etc.
 Developed and enhance multiple Oracle Forms to improve the user friendly interfaces.
 Designed and developed various reports on ad-hoc basis to improve the information system.
 Involved in preparing user support documents.

Education

Diploma,  Project Management Professional (PMP) 5TH Edition
  • at MISP
  • September 2013

 Project Management Professional (PMP) 5TH Edition Topics : 1- PROJECT INTEGRATION MANAGEMENT . 2- PROJECT SCOPE MANAGEMENT 3- PROJECT TIME MANAGEMENT. 4- PROJECT COST MANAGEMENT. 5- PROJECT QUALITY MANAGEMENT. 6- PROJECT HUMAN RESOURCE MANAGEMENT. 7- PROJECT COMMUNICATIONS MANAGEMENT. 8- PROJECT RISK MANAGEMENT. 9- PROJECT PROCUREMENT MANAGEMENT. 10-PROJECT STAKEHOLDER MANAGEMENT.

Diploma,  ORACLE Application (E-Business) Technical Consultant
  • at DB EGYPT
  • May 2012

 ORACLE Application (E-Business) Technical Consultant Topics : 1- Oracle E-Business Suite Essentials . 2- API's & Interface tables. 3- Oracle Concurrent Program. 4- Forms personalization. 5- Oracle Alert Manager. 6- Oracle Discoverer. 7- BI publisher(XML). 8- Oracle Work Flow.

Bachelor's degree, Faculty of Computer Science & Information System,
  • at Mansoura university,
  • June 2006

Graduate : Bs.C of Computer Science May 2006. University : Faculty of Computer Science & Information System, Mansoura university, EGYPT Grade : GOOD. Educational Projects  Assembler To convert assembly language to object code Tool: By C#.  Robot motion (AI) Tool: By C#.  Compiler Tool: By c#.  Machine translation Tool: By c#.  Islamic site Tool: Dreamwaver , Asp.net , SQL server 2000. Graduation project  Graduation Project Project : Smart Video Phone. Description : Provide live connection between people in separate locations for the purpose of Communication, Involving audio and text as well as video. Tools : Microsoft Visual C# ,SQL Server 2000 My role :GUI interface & DB Designing Graduation project grade : Very Good

Specialties & Skills

Oracle General Ledger
Oracle Developer 2000
ERP design
ANALYST AND DESIGN FOR NEW MODULE

Languages

English
Intermediate

Training and Certifications

 Project Management Professional (PMP) 5TH Edition (Training)
Training Institute:
MISP
Date Attended:
August 2013
 ORACLE Application (E-Business) Technical Consultant (Training)
Training Institute:
DB EGYPT
Date Attended:
March 2012