SUMMARY

• Highly motivated IT consultant with 17 years of total IT experience in software applications/development including 15 years of experience on Oracle E - Business Suite 11i/R12 as Oracle APPS Consultant plus good project management/team management
• Good team player as PM/Lead/Consultant/Programmer Analyst/Developer.
• Good experience in study/audit of existing business process and preparation 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.
• Good experience on Oracle EBS R12.2.6 Version.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and
• Exposure to WF, Oracle Discoverer, OAF using JDeveloper 9i.
• Areas of expertise include technical developments in HRMS,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.
• Have 3 full cycle end-to-end implementation and one support project(s) experience.
• Good Knowledge on building and customizing Tableau reporting.
• Experience in Application System Administration activities like 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 on EBTAX setups.
• Experience in Quest STAT for version control software.
• Rich experience in registration/migration of Forms, Reports, OAF UI pages, PLSQL programs,
• Oracle Discoverer and XML Publisher Reports(BI Publisher)
• 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 inrequirement gathering, design and development ofcustom applicationsinOracle Applications Framework(OAF)environment.
• Extensive Knowledge onXML Publisher,TCA Architecture,Web services and SOA.
• Worked on Vertex integration with EBS.
• Hands on experience with ADF 11g.
• Knowledge on OBIEE using EBS tables for reporting.
• Good at sysadmin and AOL activities including creation of KFFs, DFFs, users, responsibilities, Menus, concurrent programs, request sets, request groups, value sets.
• Good at development of interface and conversion programs using PLSQL and Oracle Standard APIs.
• 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.
• Participate in CRP meetings for gap analysis.
• Implementation experience using AIM Methodology
• 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
• Good communication skills, inter personal skill and problem solving ability.
• 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 Utilities: SQL* Loader, Export/Import Utility, OEM, Discoverer3.xApplication Desktop Integrator

Oracle Applications: Oracle Applications 10.7, 11i and R12 Applications System Administration, Installation, Up gradation & Patch Management

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

Confidential

Techno-Functional Lead Consultant

Responsibilities:

• Managing current 12.1.3 EBS prod issues.
• Working on 12.2.6 upgrade issues with implementation partner from client end.
• Conducted gap analysis and implementation of modules, interfaces and customizations.
• Lead for all RICE components.
• Developing Forms, Reports, and XML Publisher Reports.
• Creating Inbound and Outbound interfaces for Chrome River system.
• Worked on changing the background colors for Self- Service pages.
• Doing the 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)
• Development of new reports and customization using Reports.(Xml publisher, 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.
• Working on integrating Chrome River(Employee expense system) with EBS.
• Developed REST services for Chrome River to send JSON/XML format data.
• Creating new interface to load and process employee expenses into Payables.
• Creating Metal ink Services requests for R12 issues.
• Writing FND loader Scripts to migrate the programs from existing Production system.
• Involved in gathering client requirement.
• Provide estimates for all technical components.
• Analysis of Report/Interface Specifications and preparing 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, OAFramework, Sql/PL Sql,Sun Solaris, JDeveloper10g,11g, IBM Integration Bus, Crome River,BI Publisher.

Confidential

Techno-Functional Consultant/Project Lead

Responsibilities:

• Responsible for managing the RICE development.
• Create business process flows and implementing on Oracle EBS.
• Lead for all RICE components.
• Developing Forms, Reports, Discoverer 10g reports and XML Publisher Reports.
• Creating Metal ink Services requests for R12 issues.
• Worked on Vertex and EBS integration issues.
• Writing FND loader Scripts to migrate the programs from existing Production system.
• Involved in gathering client requirement.
• Provide 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 onOAF customizations,Creating new OAF pages and customizing extending pages .
• This involves extending VO, CO andEO 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.
• Preparation of 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 requierments.
• 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, OAFramework, Sql/PL Sql,Sun Solaris, JDeveloper10g,11g, Dell Boomi, Concur,BI Publisher,ADF 11g and Tableau, TeamConnect and Dell Boomi .

Confidential

Techno-Functional Consultant/Technical Lead

Responsibilities:

• Responsible for managing the RICE development.
• Create business process flows and implementing on Oracle EBS.
• Lead for all RICE components.
• Developing Forms, Reports, Discoverer 10g reports and XML Publisher Reports.
• Creating Metal ink Services requests for R12 issues.
• Writing FND loader Scripts to migrate the programs from existing Production system to Right side instance.
• Involved in gathering client requirement.
• Involved in planning and execution of Data conversions strategy.
• Provide estimates for all technical components
• Preparation of data Conversion Strategy for the new Right side system as per the client standards for (FA, PA, AP, HRMS) modules.
• Build 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 inOAF. This involves analyzingMD50(Functional Spec) and then writingMD70(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.
• CreatedCUSTOMJAVA TOP on server for customized OAF pages.
• Creating new and modifying existing workflow processes.
• Development and update of technical design/migration documents MD070s and MD50s.

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

Confidential

Techno-Functional Consultant

Responsibilities:

• Responsible for managing the RICE development team at offshore
• Create business process flows and implementing Payables, General Ledger and Receivables Modules on Oracle EBS
• Lead for all RICE components.
• Involved in Requirement Analysis, Design and Develop custom applications inOAF. This involves analyzingMD50(Functional Spec) and then writingMD70(Technical Spec).
• Developing XML Publisher Reports
• Creating Oracle Services requests for R12 issues
• Involved in gathering client requirements
• Provide estimates for all technical components
• Preparation of data Conversion Strategy from legacy to oracle database as per the Client standards
• Involved in negotiation of project estimates
• Development and update of technical design/migration documents MD070s and MD120s, CV060s.

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

Confidential

Techno-Functional Lead

Responsibilities:

• Responsible for managing the RICE development team at offshore
• Create business process flows and implementing iExpense, Payables, General Ledger and Receivables Modules on Oracle EBS
• Lead 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, 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 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 is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Adding and Capitalizing 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 are 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