SUMMARY:

• Over twelve years of professional experience in Oracle, in all phases of software life cycle with expertise in Oracle Applications R12 and 11i, Taleo and Performance Management.
• Experienced in Oracle Applications Modules include AP, AR, PO, OM, WMS, WSH, Inventory, GL, AGIS, Project Accounting, Grants Accounting, Labor Distribution, Fixed Assets, OTL, HRMS, Payroll, OAB, iProcurement, Oracle Fusion Performance Management and SSHR .
• Very strong in full suite of Oracle Tools including SQL, PL/SQL, Forms 4.5/6i/10g, Reports 2.5/6i/10g, Web ADI, OBIEE, SOA, WSO2, Discoverer4i/10g/11g, JDeveloper 9.0.3, Oracle Data Integrator ODI, Oracle Workflow 2.6, BI Publisher, HTML, Java, SQL*Plus, TOAD .
• Experienced in environments requiring direct customer interaction during design specification, development, and product implementation phases.
• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files into oracle database.
• Experienced in data Extraction, Loading and Transformation
• Experience in Development and Customization of RICE (Reports, Interfaces, Conversions and Extensions) Objects.
• Expertise in developing Oracle Data Conversions, Inbound and Outbound Interface programs.
• Expertise in Developing SQL, PL/SQL, SQL *Loader, UNIX Shell Scripts, Stored Procedures, and Triggers.
• Experienced in Developing Technical Specifications and Design Document per AIM.
• Expertise in using version control software KINTANA, PVCS, Sub Version and VSS.
• Exceptionally well organized with Strong Communication, Inter - personnel, Analyzing Skills and a desire to learn new technologies and tools.

TECHNICAL SKILLS:

ERP: Oracle Applications ( R12.2.5,12.1.3, 11.5.10, 11.5.9, 11.5.4)

Modules: Accounts Receivables, Accounts Payables, Order Management, General Ledger, PA, Grants Accounting, LD, PO, AGIS, Inventory, Install Base, HRMS, Payroll, OAB, SSHR, Oracle Fusion Performance Management.

Technical Expertise: Oracle Forms 10g/6i/4.5, Oracle Reports 10g/6i/2.5, Oracle Workflow2.6, OBIEE, Discoverer 11g/10g/4i, SOA, TOAD, JDeveloper, BI Publisher,Java,XML, WSO2, Oracle Data Integrator ODI

Database: ORACLE 11g,10g, 9i, 8i, 8, 7.3

Windows NT/XP/2000, UNIX, MS: DOS

Languages: SQL, PL/SQL, C, C++, Java, Unix Shell ScriptingHTML,XML

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Worked on fast formulas customization of Payroll, Accrual plans, Absence, OTL.
• Implemented Employee/Manager Self-service.
• Implemented Compensation Work Bench
• Implemented grade step ladder
• Developed XML publisher template to generate Aging report, pick slip, packing slip, tax reports, salary action, pay status, payroll statements.
• Worked in production support to resolve issues in the interfaces, workflow and reports.

Development Environment: Oracle Applications 12.2.5 ( HR , Payroll, SSHR, OAB, INV, OM, AP, PO, AR) , Oracle Form Developer 10g, Workflow Builder, Report Builder 10g, BI Publisher PL/SQL, SQL*Loader, Toad 12, UNIX Scripting.

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Developed new inbound and outbound interfaces from Sales force to Oracle applications.
• Customized and performance tuned Reports in various using Oracle Reports 10g, Discoverer 11g and BI publisher

Development Environment: Oracle Applications 12.1.3 (Taleo, AP, AR, PO, GL, FA, HR , CRM, AGIS, PA and System Administration, iProcurement) , Oracle Form Developer 10g,, Workflow Builder, Report Builder 10g, XML Publisher, SOA, PL/SQL, SQL*Loader, Toad 12, UNIX Scripting.

Confidential

Apps Consultant

Responsibilities:

• Developed Custom module OAF pages for Travel/Position/Job Management/ Grants.
• Worked on the Employee/Manager Self-service customizations.
• Developed OAF pages for Banking Instructions and validated the Banks details using web services.
• Worked on fast formulas customization.
• Developed XML publisher template to generate s, contracts offers.
• Worked in production support to resolve issues in the interfaces, workflow and reports.

Development Environment: Oracle Applications 12.1.3 (AP, AR, PO, GL, FA, HR , Payroll, SSHR, iProcurement, OAB) , Oracle Form Developer 10g, WSO2, Workflow Builder, Report Builder 10g, XML Publisher PL/SQL, SQL*Loader, Toad 12, UNIX Scripting.

Confidential

Apps Consultant

Responsibilities:

• Involved in R12 upgrade and MOAC implementation.
• Developed new inbound and outbound interfaces from Sales force to Oracle applications.
• Developed custom DQM programs to merge parties and suppliers.
• Implemented AGIS (Advanced Global Intercompany System).
• Developed AR cross border payments custom module.
• Created Custom WEBADI for creating Purchase Orders, AP Invoices, AR Invoices and AR Receipts.
• Developed Interfaces to Oracle Fusion Performance Management.
• Developed Interfaces to the Oracle Taleo
• Designed and built SOA composites and BPEL processes for Oracle integration with other systems.
• Customized and performance tuned Reports in various using Oracle Reports 10g, Discoverer 11g and XML publisher

Development Environment: Oracle Applications 12.1.3 (Taleo, AP, AR, PO, GL, FA, HR , CRM,AGIS, PA and System Administration, iProcurement) , Oracle Form Developer 10g,, Workflow Builder, Report Builder 10g, XML Publisher, SOA, PL/SQL, SQL*Loader, Toad 12, UNIX Scripting.

Confidential

Apps Consultant

Responsibilities:

• Worked in production support to resolve issues in the interfaces, workflow and reports.
• Worked on forms personalization.
• Developed new interfaces from third party systems to Oracle
• Customized and performance tuned Reports in various using Oracle Reports 6i, Noetix and XML publisher
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers). Extensive experience in OBIEE dashboards and reports
• Created new reports using discoverer by developing views from the database to suit the business requirements and used those views in the tool.
• Developed interfaces using ODI to load data from different systems to Oracle Applications
• Involved in Oracle Release 12 upgrade assessments.

Development Environment: Oracle Applications 11.5.10 (AP, AR, PO, GL, FA, INV, OM, WMS, WSH, PA and System Administration) , Oracle Form Developer 6i, Noetix, Workflow Builder, Report Builder 6i, XML Publisher (5.5), OBIEE, PL/SQL, SQL*Loader, Toad 8, UNIX Scripting, Oracle Data Integrator ODI.

Confidential

Apps Consultant

Responsibilities:

• Developed Standard Functional Specification, Technical Specifications and Mapping Documents.
• Involved and Developed Interfaces in AP, PO.
• Developed shell scripts to move the data files.
• Used version control software KINTANA to save all the source code.

Development Environment: Oracle Applications 11.5.9 (AP, PO ), PL/SQL, Toad 8, UNIX Scripting.

Confidential, Columbus OH

Apps Consultant

Responsibilities:

• Involved in the implementation of Oracle Conversions and Interfaces.
• Created Mapping documents based on Functional documents, Legacy data structure.
• Developed Standard Functional Specification, Technical Specifications and Mapping Documents.
• Developed on Custom and Complex Reports in various modules like Payroll and Oracle Human Resource using Oracle Reports 6i, Discoverer 10g and XML publisher.
• Developed UNIX Shell Scripts for executing SQL Loader Control files in UNIX Server and Oracle Applications Environment and Created Concurrent Programs for UNIX Shell Scripts.
• Worked on forms personalization.
• Worked on the Manager Self service customizations.

Development Environment: Oracle Applications R12 and 11.5.10 (AP, AR, PO, GL, HRMS, Payroll, SSHR), Oracle Form Developer 6i, Report Builder 6i, Discoverer 10g, APEX, XML Publisher (5.5), PL/SQL, SQL*Loader, Toad 8, UNIX Scripting.

Confidential, Atlanta

Apps Consultant

Responsibilities:

• Post implementation work included development of reports using Oracle tools, continued support to payroll processes and ongoing testing of system functionality.
• Maintained Custom Interfaces and processes (both inbound and outbound) and fixed bugs.
• Involved in the Payroll Cycle process testing.
• Developed new interfaces from Oracle HRMS to third party systems.
• Designed and developed custom replenishment process for Re order Point Planning.
• Developed Custom form for Demand/Supply, Requisition, Purchase order details.
• Designed and developed Custom Shipping Process.
• Customized Purchase order Report as per requirements and created XML template.
• Developed Custom process to import payroll transactions from payroll to LD.
• Developed on Custom and Complex Reports in various modules like PA, GMS, AP, FA,AR, Payroll and Oracle Human Resource using Oracle Reports 6i and XML publisher.

Development Environment: Oracle Applications 11.5.10 (AP, AR, GL, FA, INV, OM, PA, GMS, WMS, WSH, HRMS, Payroll, Project Accounting, Grants Accounting, LD, AR, AP, Inventory and System Administration) , Oracle Form Developer 6i, Report Builder 6i, XML Publisher (5.5), PL/SQL, SQL*Loader, Toad 8, UNIX Scripting.

Confidential, Atlanta

Apps Consultant

Responsibilities:

• Involved in the implementation of Oracle Conversions and Interfaces.
• Created Mapping documents based on Functional documents, Legacy data structure.
• Developed Standard Functional Specification, Technical Specifications and Mapping Documents.
• Involved and Developed Custom Interfaces(both inbound and outbound) Which Includes PL/SQL Packages and Procedures and Standard API’s in AP, AR, INV, OM, GL, FA, Oracle Human Resource, Payroll, PA, GMS, LD and Benefits.
• Involved in enhancement of custom labor distribution process to PA/GMS.
• Developed custom forms for PA custom labor distribution process to correct errors.
• Developed on Custom and Complex Reports in various modules like PA, GMS, AP, FA,AR, Payroll and Oracle Human Resource using Oracle Reports 6i and XML publisher.
• Used version control software PVCS.

Development Environment: Oracle Applications 11.5.10 (AP, AR, GL, OM, FA, INV, PA, GMS, WMS, WSH, HRMS, Payroll, Project Accounting, Grants Accounting, LD, AR, AP, FA and System Administration) , Oracle Form Developer 6i, Report Builder 6i, XML Publisher (5.5), PL/SQL, SQL*Loader, Toad 8, UNIX Scripting.

Confidential, Foster City, CA

Oracle Technical Consultant

Responsibilities:

• Customized various pages in Confidential custom application.
• Customizing the existing Install Base Advanced Search Screen, Item Instance Details Screen, View Configuration Screen, and Create Item Instance Screen to meet the new business Requirements.
• Test all existing functionalities for any impact after upgrade.

Environnent: Oracle Applications 11.5.10 (Install Base), JSP, PL/SQL, JAVA.