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

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.

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

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

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