Sameh Mohamed Sewilam

Experience

• 

  Orascom Training & Technology

  Dec 2006 - Dec 2008

  Oracle Instructor

  Instructing Oracle courses (Theoretical and Practical)Supervise the trainees' projectsDevelop and support HR Human Resource System using Oracle developer suite 6iDevelop and support Supply Chain System using Oracle developer suite 10gDeveloped database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problemsWriting Database Triggers, Stored Procedures, Functions and Packages using PL/SQL.Worked on various backend Procedures and Functions using PL/SQL Show less

• 

  Telecom Egypt

  Jan 2009 - Sept 2009

  Oracle Developer and ERP Support

  Implementation of Oracle Financial Modules (GL, AR and AP)Implementation of Oracle Logistics Modules (Inventory and Purchasing)Assessing the business requirements and mapping it to the ApplicationExtending Application Capabilities through developing customized discoverer reports Created SQL*Loader scripts to load data into the temporary staging tablesDesign and Create new Oracle reports and Oracle forms that meets business need

• 

  National Technology

  Sept 2009 - Aug 2016

  Involved in implementation of robust technology solutions within time, budget and qualityInvolved in handling all phases of Project / Program Life Cycle for new projectsInvolved in full Software Development Lifecycle (SDLC)Supervise Oracle team to develop LIS Laboratory Information System using Oracle developer suite 6iDevelop HL7 requirements documentation.Analyzes and documents customer integration requirements and business workflow.Design integration workflowModifying forms using Oracle Forms 6i,10g and 11g for data manipulation purpose and reports using Oracle ReportsImprove Oracle Database performance performing Performance tuning/ SQL tuning and query optimization.Created Materialized Views and partitioning tables for performance reasons.Lead Oracle team to develop and support HIS Hospital Information System using Oracle developer suite 10gLead Oracle team to develop and support Stock System using Oracle developer suite 10gLead Oracle team to develop and support Patient Accounting System using Oracle developer suite 10gLead Oracle team to develop and implement HL7 Health Level 7 System using Oracle developer suite 6iInvolved with .Net team to convert Database from Microsoft SQL Server to OracleCreate Oracle database stored procedures, packages, Functions and Triggers using PL/SQL Scripting. Show less Modifying forms using Oracle Forms 6i,10g and 11g and reports using Oracle ReportsCreate database stored procedures, packages, Functions and Triggers using PL/SQL ScriptingDevelop and support LIS Laboratory Information System using Oracle developer suite 6iDevelop and support HIS Hospital Information System using Oracle developer suite 10gDatabase Development - Relational Databases (RDBMS), Data Modeling and DesignWorked on various backend Procedures and Functions using PL/SQLOracle Database Administration “Backup – Recovery – RMAN"Involved in DBA activities like creating Tables, Complex Views, Public Synonyms, and Database Links Show less

  • Oracle Team Leader

    Jan 2012 - Aug 2016

  • Senior Oracle Developer

    Sept 2009 - Jan 2012
• 

  Islamic University in Madinah

  Dec 2016 - Nov 2018

  Senior Oracle Developer

  Customer Requirement Management.Analyzes and documents customer requirements and business workflowHandling all phases of Project Life Cycle Planning and monitoring the projectImplementation of Oracle Financial Modules (GL, AR and AP)Create database stored procedures, packages, Functions and Triggers using PL/SQL Scripting.Support Data warehousing team to design Data warehouse schema.Created Partition tables by range using date column to increase the performanceTechnical Consultation and Coaching for all ERP modulesExtending Application Capabilities through developing new forms and reports Show less

• 

  Freelance

  Nov 2018 - now

  Software Technical Lead
• 

  ESmart

  Jan 2019 - now

  Technical Director