SUMMARY:

• Highly motivated IT consultant with 17+ years of experience in software applications/development, including 15 years of experience on Oracle E - Business Suite 11i/R12, R12.2.6 and Oracle APPS
• Knowledge on Oracle Fusion R12 Modules.
• Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Expert in requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Oracle Discoverer and XML Publisher Reports (BI Publisher)
• Knowledge on OBIEE using EBS tables for reporting.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• Performed study/audit of existing business processes and prepared issue logs, collection of functional/technical requirements, client/user interaction, GAP Analysis, technical data mapping analysis and design of technical/functional data process flow charts.
• Hands on experience in development and extension of RICE components using SQL and PL/SQL, customization of forms using CUSTOM.pll, Report builder 6i, XML Publisher and exposure to WF, Oracle Discoverer, and OAF using JDeveloper 9i.
• Areas of expertise include technical developments HRMS (Payroll, OTL)
• , GL, AP, AR, FA, PO, Service Contracts (OKS), Project Accounting, iExpense, iProcurement, O2C, P2P and Manufacturing Modules (OM, INV, Shipping, BOM, PO, WIP, OPM) ERP modules.
• Completed 3 full cycle end-to-end implementations and one support project. Implementation experience using AIM Methodology
• Good knowledge on building and customizing Tableau reporting.
• Experience in Application System Administration activities, managing concurrent managers, applications security, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical and functional issues.
• Knowledge with EBTAX setups.
• Experience in Quest STAT for version control software.
• Rich experience in registration/migration of Forms, Reports, OAF UI pages, PLSQL programs,
• Extensive Knowledge on XML Publisher, TCA Architecture, Web services and SOA.
• Worked on Vertex integration with EBS.
• Hands on experience with ADF 11g.
• Performed sysadmin and AOL activities including creation of KFFs, DFFs, users responsibilities, menus, concurrent programs, request sets, request groups, value sets.
• Worked extensively on Integration Projects (Team Connect (Dell Boomi and SailPoint).
• Migration of legacy data to oracle using SQL*Loader and UTL FILE utilities.
• Knowledge of underlying table structure of oracle applications modules for development of enhanced functionalities.
• Participated in CRP meetings for gap analysis.
• Setup of GL chart of accounts and set of books.
• Setup of master items using item templates.
• Good experience in development of functional/technical design documents.
• Support and involvement in risks identifications and risk mitigations
• Implementation and customization in Oracle Financials & Projects (AR, AP, GL, FA, PA).
• Implementation and customization in Oracle CRM (SC, FS, DR).
• Implementation and customization in Oracle Manufacturing (OM, INV, Shipping, BOM, PO, WIP).
• Implementation and customization in Oracle CRM
• Experience in implementation and customization in Oracle Financials (GL, AR, AP, PA).
• Experience in implementation and customizations in Oracle HRMS (HR, Payroll).
• Experience in Technical design and development of various customizations in Inventory, Payables, Receivables, Purchasing, CRM and Order Management. Extensive experience with implementation, upgrade, converts Oracle applications.
• Experience in Reports, Interfaces, Conversions, Extensions.
• Experience on ADF 11g.
• Worked extensively with Oracle Form 6i, Report 6i and Developer 10g.
• Experience in Discoverer 4i and Discoverer 10g.
• Experience in customizing workflows and developing custom workflows using Oracle Workflow Builder 2.6
• Strong knowledge of in using AOL to register forms and reports.
• Familiarity with UNIX shell scripts.
• Experience in GAP Analysis, Test Plan Preparation, Unit testing, and System Integration testing & conducting UAT.
• Excellent problem analysis and troubleshooting skills.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, Java, Shell Scripts.

Web Technologies: ASP3.0, JSP, Servlets, EJB, HTML, Weblogic4.5.

Hardware: Compaq Servers and IBM PC's & Compatibles.

O/Systems: SCO UNIX, Sun Solaris 2.6,8, HP, Windows NT/2000 and DOS.

Databases: Oracle 7.x/8.0/8i,9i, Informix, SQL Server 7.0/2000, DB2

Oracle Applications: Oracle Applications 10.7, 11i and R12 Applications System

Oracle Utilities: SQL* Loader, Export/Import Utility, OEM, Discoverer3.xApplication Desktop Integrator

Tools: TOAD, PL/SQL Developer, Workflow Builder 2.6, Discoverer 4i, SQL*Loader, SQL Navigator, Forms 6i/4.5, Reports 6i/2.5, UTL File Utility, FTP Tools, Developer 11g, ADF and BI Publisher.

PROFESSIONAL EXPERIENCE:

Confidential

Techno-Functional Lead

Responsibilities:

• Managed current 12.2.4 EBS prod issues.
• Managed 12.2.6 upgrade issues with clients’ implementation partner.
• Conducted gap analysis and implementation of modules, interfaces and customizations.
• Lead for all CEMLI components.
• Creating and modifying custom interfaces,forms and reports for HRMS (Payroll, OTL, Self Service)
• Developed Forms, Reports, and XML Publisher Reports.
• Worked on Oracle Application Framework (OAF) to develop custom solutions.
• Worked on OAF customizations, creating new OAF pages and customizing extending pages. This involves extending VO, CO and EO objects.
• Designed and developed oracle BPEL processes for web services that created Oracle OM Service Requests based on pl/sql packages accepting collection parameters and implementing security using Oracle Web Service Manager.
• Building scripts for migrating CEMLI objects (Forms, OAF and Reports) from one instance to another.
• Developed new reports and customization utilizing Xml publisher and rdf Reports.
• Created testing scenarios, scripts and plans for unit, integration and acceptance testing functions.
• Created new interface to load and process employee expenses into Payables.
• Created Metal ink Services requests for R12 issues.
• Wrote Confidential loader Scripts to migrate the programs from existing Production system.
• Involved in gathering client requirements.
• Provided estimates for all technical components.
• Analyzed Report/Interface Specifications and prepared MD50, BR100 and MD 070.

Environment: Oracle R12.2.6 (OTC,OPM,AR, AP, GL, FA, PA, O2C, P2P, HRMS,Payroll,OTL,iSupplier and iPoc), Forms 10g, Reports 10g, Workflow Builder 2.6, OA Framework, Sql/PL Sql, Sun Solaris, JDeveloper10g,11g, BI Publisher.

Confidential

Techno-Functional Lead

Responsibilities:

• Managed current 12.1.3 EBS prod issues.
• Managed 12.2.6 upgrade issues with clients’ implementation partner.
• Conducted gap analysis and implementation of modules, interfaces and customizations.
• Lead for all RICE components.
• Creating and modifying custom interfaces,forms and reports for HRMS (Payroll, OTL, Self Service).
• Developed Forms, Reports, and XML Publisher Reports.
• Created Inbound and Outbound interfaces for Chrome River system.
• Worked on changing the background colors for Self- Service pages.
• Performed data migration activities of Core HR/Payroll through conversion scripts (like personal, assignment, job, position, grade, qualifications, phones, initial balance, bank details, element entry, pay proposals etc)
• Developed new reports and customization utilizing Xml publisher and rdf Reports.
• Implemented procedures for mapping of requirements through Oracle HRMS functionality.
• Created testing scenarios, scripts and plans for unit, integration and acceptance testing functions.
• Integrated Chrome River (Employee expense system) with EBS.
• Building scripts for migrating CEMLI objects(Forms, OAF and Reports) from one instance to another.
• Developed REST services for Chrome River to send JSON/XML format data.
• Created new interface to load and process employee expenses into Payables.
• Created Metal ink Services requests for R12 issues.
• Wrote Confidential loader Scripts to migrate the programs from existing Production system.
• Involved in gathering client requirements.
• Provided estimates for all technical components.
• Analyzed Report/Interface Specifications and prepared MD50, BR100 and MD 070.

Environment: Oracle R12.2.6 (AR, AP, GL, FA, PA, O2C, P2P, HRMS), Forms 10g, Reports 10g, Workflow Builder 2.6, OA Framework, Sql/PL Sql, Sun Solaris, JDeveloper10g,11g, IBM Integration Bus, Chrome River, BI Publisher.

Confidential

Techno-Functional Project Lead

Responsibilities:

• Work involved maintenance of existing R12 EBS system for Confidential and developing components and testing.
• Worked on BI Publisher, OAF, Developer 10g and customizing forms, Report 10g, Discoverer10g, ADF and managing the custom interfaces and conversions.
• Reviewed and updated URS, FRS, Design and Configuration specifications of Oracle EBS
• Developed and executed validation protocols for Custom reports from Oracle EBS as per the Report Specifications
• Reviewed the updated Report Specification of Oracle EBS custom reports
• Acted as the document processor for validation documents
• Developed and executed IQ, OQ and PQ protocols
• Updated the Requirements Traceability Matrix (RTM) of Oracle EBS and Level 4 systems
• Responsible for drafting the summary of Change Control records in TrackWise
• Developed use cases based on the Functional and User Requirements Specifications
• Created, Investigated and closed the deviations
• Performed post execution reviews on IQ/OQ and PQ protocols
• Followed the SDLC process and involved in all stages of project to develop validation deliverables.
• Responsible for managing the RICE development.
• Created business process flows and implementing on Oracle EBS.
• Lead for all RICE components.
• Developed Forms, Reports, Discoverer 10g reports and XML Publisher Reports.
• Created Metal ink Services requests for R12 issues.
• Worked on Vertex and EBS integration issues.
• Wrote Confidential loader Scripts to migrate the programs from existing Production system.
• Involved in gathering client requirement.
• Provided estimates for all technical components.
• Managed and implemented Supplier Onboarding Project (Supplier Lifecycle Management).
• Worked on TeamConnect and Dell Boomi Integration with EBS.
• Worked on configuring AME setups for payables module.
• Worked extensively on EBTAX and Subledger Accounting (SLA).
• Worked on the development of Interfaces, Data Conversions, developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM, BOM & SHIPPING.
• Worked on customizing AP reports and Custom Interfaces.
• Worked on customizing HRMS reports and Interfaces.
• Designed and developed XML Publisher report: XXGIL Barr Packaging Master Record report for Barr. The custom report contains all the OPM information required to produce a Packaging Master Batch Record.
• Involved in OBIEE reports development and testing.
• Worked on Oracle Application Framework (OAF) to develop custom solutions.
• Worked on OAF customizations, creating new OAF pages and customizing extending pages. This involves extending VO, CO and EO objects.
• Designed and developed oracle BPEL processes for web services that created Oracle OM Service Requests based on pl/sql packages accepting collection parameters and implementing security using Oracle Web Service Manager.
• Prepared Data Conversion Strategy for the Confidential system as per the client standards for
• (OM, INV) modules.
• Involved in negotiation of project estimates.
• Helped the business user to create and customize the Tableau dashboard reports.
• Inventory Plan configuration for OPM functionality
• Formula and Recipe configuration for Batching within OPM to allow ASCP and custom code create batches to drive Production Plan.
• Implementation of OPM Costing.
• Analysis, design and development of integration interfaces between Legacy systems and Oracle OPM.
• Designer of integration interfaces for Oracle OPM Costing.
• Developer of custom code to use API’s and integrates data between Oracle and legacy systems.
• OPM Costing account setup and rules definition (MAC).
• Analyst/Developer/Implementer to integrate Master Item’s within OPM Inventory from Customer’s GPRS system (Custom program).
• Developing business layer components using ADF business components to interact with the underlying database and bind the data to ADF UI components.
• Worked on creating a wrapper for a webservice call and generate a data control to bind to ADF UI.
• Worked with view criteria and programmatically applying view criteria and writing service methods in application module implementation.
• Implemented ADF security within the application and worked on creating skins for the application using CSS.
• Customizing the Lot Genealogy reports as per business requirements.
• OAF Personalization’s and Custom Alerts as per client requirements.
• Creating new and modifying existing workflow processes.
• Development and update of technical design/migration documents MD070s, MD50s and BR100s.

Environment: Oracle R12 (AR, AP, GL, FA, PA, O2C, P2P, INV, iExpenses, iProcurement, Shipping, BOM, PO, WIP, OPM, HRMS), Forms 6i, Reports 10g, Workflow Builder 2.6, OA Framework, Sql/PL Sql, Sun Solaris, JDeveloper10g,11g, Dell Boomi, Concur, BI Publisher, ADF 11g and Tableau, Team Connect and Dell Boomi.

Confidential

Techno-Functional Project Lead

Responsibilities:

• Project involved splitting into two different operating units Confidential and Right side.
• Provided maintenance of existing R12 EBS system for Confidential and Developing components and testing for Right side.
• Worked on Data Conversions, BI Publisher, OAF, Developer 10g and customizing forms, Report 10g, Discoverer10g and managing the custom interfaces and conversions.
• Managed the RICE development.
• Created business process flows and implementing on Oracle EBS.
• Lead for all RICE components.
• Creating and modifying custom interfaces,forms and reports for HRMS (Payroll, OTL, Self Service)
• Developing Forms, Reports, Discoverer 10g reports and XML Publisher Reports.
• Created Metal ink Services requests for R12 issues.
• Wrote Confidential loader Scripts to migrate the programs from existing Production system to Right side instance.
• Involved in gathering client requirements.
• Involved in planning and execution of data conversions strategy.
• Provided estimates for all technical components
• Prepared data conversion strategy for the new Right-Side system as per the client standards for (FA, PA, AP, HRMS) modules.
• Built New Custom Application Balance Adjustment Registry.
• Involved in negotiation of project estimates.
• OAF Personalization’s and Custom Alerts as per client requirements.
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involved analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Designed and developed oracle BPEL processes for web services that created Oracle Payables and iExpenses based on pl/sql packages accepting collection parameters and implementing security using Oracle Web Service Manager.
• Created CUSTOM JAVA TOP on server for customized OAF pages.
• Created new and modified existing workflow processes.
• Developed and updated technical design/migration documents MD070s and MD50s.

Environment: Oracle R12 (AR, AP, GL, FA, PA,PO,HRMS,Payroll,Self Service and OTL), Forms 6i, Reports 10g, OA Framework, Sql/PL Sql, Sun Solaris, JDeveloper10g,11g, Discoverer 10g, BI Publisher and Workflow Builder 2.6

Confidential

Techno-Functional Consultant

Responsibilities:

• Managed the offshore, RICE development team
• Created business process flows and implemented Payables, General Ledger and Receivables Modules on Oracle EBS
• Led all RICE components.
• Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involved analyzing MD50 (Functional Spec) and then writing MD70 (Technical Specs).
• Developed XML Publisher Reports
• Created Oracle Services requests for R12 issues
• Involved in gathering client requirements
• Provided estimates for all technical components
• Prepared data Conversion Strategy from legacy to Oracle database, per Client standards
• Involved in negotiation of project estimates
• Developed and updated technical design/migration documents MD070s and MD120s, and CV060s.

Environment: Oracle R12 (AR, AP, GL, FA, PA, HRMS, iExpenses, and iProcurement), Forms 6i, Reports 6i, OA Framework, Sql/PL Sql, Sun Solaris, JDeveloper10g,11g and BI Publisher.

Confidential

Techno-Functional Lead

Responsibilities:

• Managing the offshore, RICE development team
• Created business process flows and implemented iExpense, Payables, General Ledger and Receivables Modules on Oracle EBS
• Led for all RICE components.
• Created custom OAF pages for PO module.
• Worked extensively on Auto Lock Box to bring data from external sources into Receivables AR base tables.
• Customized the Credit Analysis Report, Trucking Manifest and Pick Slip reports in Order Management OM.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing PO by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into vendor information Base tables.
• Created Custom responsibilities: GL, AR, OM, INV and moved all orders booked and status not closed to the new responsibilities for further process.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
• Provided technical support on Oracle Payables, Oracle Receivables, Purchasing, Procure to pay and Oracle Inventory modules.
• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• Worked on the development of Interfaces, Data Conversions, developed new Forms, Reports, Customized Oracle Reports in Order to Cash Cycle touching various modules such as GL, AR, INV, OM, BOM & SHIPPING.
• Worked on Conversions of employees from Legacy System to Oracle HR.
• Developed UNIX Shell scripts to FTP the Flat file from External Server to Oracle UNIX Server location.
• Developed Interface for the Standard Items in INVENTORY generating the SQL Loader scripts and PL/SQL procedures for validating and loading data into oracle tables
• Developed a Discoverer Report to capture the sales order line details for a category of items that were exchanged Developed AP Two Way Match report using Discoverer.
• The PO Approval Workflow was used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Added and Capitalized a CIP asset in Fixed Assets FA module.
• Designed, developed and loaded data using FA MASS ADDITIONS Interface from Legacy systems.
• Developed interfaces to import payable invoices and iExpenses related invoices.
• Responsible for design, development of reports across various modules using XML/BI Publisher and Discoverer. Customized the Master/Detail budget report in GL and the Discounts Available
• Customized existing Oracle Reports in Inventory Module (INV), Pricing using Reports 10g.
• Developed several new forms using TEMPLATE.fmb & customized standard forms through CUSTOM.pll.
• Developed forms using ZOOM Functionality that pops up appropriate form based on the item context. Modified CUSTOM.pll to activate zoom.
• Invoices were imported from the Excel sheets to the Oracle Database using SQL *Loader.
• Worked on performance tuning like Explain Plan to improve the performance of various custom PL/SQL packages developed.
• Personalized custom self-services forms using OA Framework.

Environment: 11.5.10.2 (AR, AP, GL, FA, O2C, iExpenses, P2P, BOM, Shipping, Inventory), Forms 6iReports 6i, OAFramework, Sql/PL Sql, Sun Solaris, JDeveloper10g, 11g, ADF and BI Publisher

Confidential

Techno-Functional Lead

Responsibilities:

• Information Technology Division is the data backbone for Confidential . For each shipment moved by a Confidential affiliate, it is estimated that there are 300 pieces of data associated with each shipment. Confidential - Information Technology Division makes it possible for Confidential to move that data to customers, vendors, agents, and staff worldwide.
• Work involved in Upgrading the Financials system from 11.5.8 to 11.5.10.2 version and Supporting current Production system and managing a team of 5. Upgrading Discoverer 4i to 10g and customizing forms, Report 6i and managing the custom interfaces and integration between the financial and legacy systems.

Environment: Oracle 11.5.8, Oracle 11.5.10.2 and R12 (AR, AP, GL, FA), Forms 6i, Reports 6iOAFramework, Sql/PL Sql, Sun Solaris