Professional Summary:

• Oracle ERP professional with around 8 years of diversified experience in Developing, Implementing, Support, testing and managing full lifecycle projects globally.
• Implemented and supported various Oracle application modules: Account Payable AP , Account Receivable AR , General Ledger GL , Fixed Assets FA , Cash Management CM , Purchasing PO ,Order Management OM , Inventory INV , Bills of Material BOM , Work in Progress WIP , Shipping WSH , Discrete Manufacturing ODM , Process Manufacturing OPM , I-Procurement, i-Expenses, i-Receivables, EBTaxand AOL objects.
• Experience in all phases of complete Life-Cycle Implementation of Oracle SCM including Definition, Operation Analysis, Solution Design, Build, Transition and Production support.
• Proficient in support, upgrade and implementation of Oracle E-Business Suite R12 and 11i.
• Expertise in Financials, Inventory, Purchasing, Order Management, Shipping, Advanced pricing and procurement modules with a very good understanding of the integration between the distribution and finance modules.
• Proficient in functional flow of Order to Cash O2C and Procure to Pay P2P cycles
• Provided technical support for all Inbound / Outbound transactions utilized within Order to Cash O2C and Procure to Pay P2P cycles
• Proficient in registering Concurrent Programs, Form, Functions, Tables, developing Descriptive Flex-fields in Custom Applications and defining Profile values by using Application Object Library AOL ,System Administration and Documentation in Oracle Applications.
• Good knowledge on AIM documents like MD050, MD070 and MD120. Especially on Design and Development of Technical Specifications MD70 based on functional Specifications MD50 , Preparation of Unit Test Cases TE30 and Installation MD120 Documents.
• Proficiency with tools used to support Oracle Applications development including Forms, Reports, and XML Publisher.
• Proficiency in understanding client's needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications.
• Experience in Workflow. Development and Customization of RICE components CEMLI's -Reports, Interfaces, Conversions and Packages related to OracleApps Modules OM, INV, Oracle EDI Ecommerce Gateway inOracle Application 11i, R12.
• Good Knowledge of Multi organization Access control MOAC architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Proficient in writing PL/SQL Scripts and other related tools and techniques on Oracle Database.

Technical Skills:

Professional Experience:

• Worked on gathering the requirement from the user, preparing the Scope and Requirement Document, Functional Document, Technical Design Document.
• Involved in conversion of data from legacy system to Oracle Apps R12 for different modules like Accounts Payables AP ,Accounts Receivable AR , General Ledger GL , Cash Management CM , Order Management OM , and Inventory INV .
• Involved in Oracle analysis, design, development, testing and implementation of the core AR package.
• Implementation of Oracle Accounts Payables to its integration with PO, CE and GL.
• Worked towards Future business flows, Identification of Gaps, Work arounds in order to provide an Integrated Procure to Pay P2P business flow.
• Designed Developed AP Invoice Audit Report andAP Invoice Open Interfacefor the different Sources in Oracle Payables.
• Developed Custom API to invoke the API to load the external data into the corresponding tables at the end of every month.
• Performed Setup steps, defined various Key Flex fields KFF and Descriptive Flex fields DFF for Financial Modules AP, AR, GL .
• Responsible for changing existing forms and reports of Customized Account Receivables AR .
• Define user responsibilities, set up custom menus based on user Responsibilities during Procure to Pay P2P implementation.
• All elements like Product key, Customer data, End User, RMAs, transaction changes like end customer changes are extracted.
• Developed Custom Programs to load Data item into Interfaces in Account Receivables AR .
• Involved in the analysis, design and testing of customizations.
• Worked towards developing and troubleshooting XML publisher reports.
• Worked on assessing XMLpublisher reports for batch reporting needs.
• Customized various reports in OM, AR Module including ARReconciliation Report, Invoice Aging Report.
• Developed a XSL template for customizing the AR Sales profit report using XML/BI Publisher and distribute the offer document generated from XML Publisher.
• Customers are maintained using the Trading Community Architecture TCA .
• Involved in Forms personalizationwith addition of extra information through Descriptive Flex-fields.
• Developed the AOL forms using the TEMPLATE.fmb and built the code as per the AOL coding standards.
• Created flat files using UTL FILE, DBMS utility package which displays GL entries grouped by code combinations.
• Data migration from Legacy systems to APIs and Open Interfaces.
• Analyzed e-Business Suite system configuration and development changes using Gap analysis.
• Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Extensively utilized the Application Object Library AOL to Register PL/SQL Procedures, forms and reports.
• Generated Ad-hoc reports in end user layer.
• Used FNDLOAD for Migrating Concurrent programs, Request Groups, Menus, and Responsibilities.
• Worked as a liaison between the Key Users and Headquarters in order to understand corporate requirements.
• Developed PL/SQL procedures to load Price list Data Qualifiers, Modifiers and Price Lists .

Environment: Oracle Applications R12 GL, AP, AR, OM, INV, PO , Oracle 11i,BI/XML Publisher, Forms 10g, Reports 10g, PL/SQL, TOAD.

Responsibilities:

• Worked with team for support of Oracle Financials General Ledger GL , Account Payables AP , Account Receivables AR , Cash Management CM , Fixed Assets FA modules.
• Involved in resolution of issues logged in by the end users and also updating the online issue database.
• Developed customized solution for clients, coordinating with business users and functional team members for the functional requirement.
• Validated, monitored, and modified EDI documents before they were transmitted trading partners, ensuring that clients received accurate and timely advance data.
• Involved in setting up users and defining resources for AR and assign roles as per the requirements using CRM Administrator responsibility.
• Worked for Procure to Pay P2P Process and Order to Cash O2C Processes and module integrations with Accounts Receivables AR , General Ledger GL , Accounts Payables AP , Order Management OM and Inventory INV with in EBS System.
• Assigned to the implementation of Oracle 9I database for HRMS/PAYROLL on UNIX platform.
• Designed and developed new Forms in Forms 10g and Reports in Report 10g for Custom Application through Concurrent Request from Oracle Forms Custom Applications, which is implemented with Oracle Financial Release R12 Modules.
• Modified Workflow Account Generator according to the business needs. The client had 8 segments on the account segment field, customized using Oracle workflow attributes. Designed the Account Structure as per client requirements.
• Extensively used CRM API's for upload the service request information from Legacy System to oracle apps ERP.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Developed data entry forms, complex and template forms in Forms 10g. Creation of Pop-up Menus and maintaining Master Detail relationship.
• Analyzed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Responsibilities included new Reports, year-end, data clean up and all around HRMS Benefits /PAYROLL support.
• Worked on the Autolockbox interface program for the processing of credit card related data.
• Worked on various workflow customizations.
• Preparing functional/technical specifications for reporting, interfaces and customizations.
• Stored reformatted data from relational, flat file, XML files.
• Performed fit/gap analysis between the client's business processes and their intended use of the software, identified and communicated the solutions for the problems to the client.
• Assists in obtaining the approved/signed Final Acceptance Sheet from the client on his/her own module s within the project.
• Attended to, researched and fixed issues that emerged from production environment.
• Involved in data loading using PL/SQL and SQL Loader calling UNIX scripts to download and manipulate files.
• Worked on PVCS Version Control for to migrated codes to other instances.

Environment: Oracle EBS12.1.3 AR, AP, PO, GL, CM, FA, OM, INV, HRMS , Oracle 9i, Pl/SQL, SQL Plus, SQL Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Oracle Configurator, Shell Scripting, TOAD, PVCS, UNIX.

Responsibilities:

• Worked on EBS R12 upgrade project upgrading from 11.5.10.2 to R 12.1.3.
• Customized forms to make changes related to R12 for MOAC changes and tables changes.
• Developed code for Conversion of GL balances from 11i to r12, which includes both YTD and PTD balances.
• Upgraded Oracle reports, discoverer reports and BI publisher reports for financials and HRMS.
• Did analysis to identify and prioritize PL/SQL and database objects upgrade according to dependencies.
• Developed custom reports using oracle reports 10g for Missing contacts and contacts points for customers.
• Customized AP Approval Workflow according to the business needs for r12.
• Developed a custom Customer Statement rtf Report using BI publisher.
• Developed code for Oracle Fixed Assets FA conversion from 11i to r12, which includes conversion for both corporate book and Tax books.
• Implemented interface for Vendors. Also developed packages to load and update vendor and vendor site information.
• Developed common SQL Loader script using UNIX shell script which is been used for most of the conversions.
• Identifying the patches that are mandatory for the applications to address the current issue or for the future issues, planning and conducting the regression testing and migrating to production environment.
• Developed Custom Order Entry screen for user convenience and developed an interface to import these sales orders into OM.
• Developed major enhancements required for business process in Order to Cash O 2 C and Procure-to-Pay P 2 P cycles.
• Involved in developing custom XML/BI Publisher reports like Open Sales Order Summary, Purchase Order Summary.
• Customized Order Management OM Header and Line workflows to meet business requirements.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Developed Shipping Report to show data from Install Base and Service Contracts data using Discoverer.
• Involved in creating Discoverer reports to generate Purchase Order PO reports.
• Worked on different interfaces like importing AR invoices from one of third party legacy system which validates and submits a standard interface program.
• Developed custom AR INTERFACE program which validates and modifies data in the interface tables. This program is designed to update Sales order based data in AR interface tables. Validations and changes based on different custom tables and forms.
• Experienced in project costing including Load project costs from sub ledger and Capture costs in a timely manner.
• Implemented Work in Process for Discrete manufacturing ODM that interfaced with MES software.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table.
• Designed and developed a program to convert Bill Rate Schedules of Project Accounting.
• Developed the programs for to convert projects, tasks, budgets, Agreement and funding, event and cost as a part of Project Accounting.
• Involved in setting up punch out stores in I-Procurement.
• Developed and customized various custom reports like PO Requisition Details Report, Open PO Report by Buyer, Open Receipts Report and PO Unsourced Requisitions Reportin Reports 10g builder.

Environment: Oracle Apps R12.1.3,11.5.8/10.2 OM, AR, AP, PO, GL , Oracle 9i, Pl/SQL, SQL Plus, SQL Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Oracle Configurator, Shell Scripting, TOAD, PVCS, UNIX.

Responsibilities:

• The project is an implementation of Oracle Apps R12. Involved in developing conversion programs, interfaces, Custom OAF pages, building custom reports and writing UNIX shell scripts based on the functional specifications provided.
• Developed various interfaces, both inbound and outbound, which are run on the periodic basis. The modules worked on include OM, INV, WIP, BOM, AR, GL and PO.Created new concurrent request sets and scheduled the Order Import interface program to run periodically.
• Developed custom reports using Reports 6i and also customized seeded reports.
• Developed Operational Dashboards for business to view current health of the organizations.
• Developed various custom reports PickSlip Report,Bill Of Lading BOL using Report builder.
• Customized Shipping Transaction form and WIP Move transaction form using Form personalization. Customizations include adding menus, Hiding fields and changing prompts.
• Wrote SQL scripts to create temporary tables and developed SQL Loader control files to load the legacy data into the temporary tables.
• Redeveloped various custom components for R12 Implementation which invoices PL/SQL packages, views, Triggers, Value sets, AOL components.
• Worked on SQL Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Worked with GL tables, AR Interface, Customer Interface and GL interface GL INTERFACE, GL BUDGET INTERFACE .
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Migrated an Item Conversion to import legacy inventory item data into Oracle base tables.
• Involved in Open Transaction Interface to import transactions from legacy system to Oracle Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Used SQL Loader and UTL FILE packages for data conversion and interfaces.
• Customized the reports for Financial Module GL, AP, and AR using Report Builder.
• Migrated Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports from 11i to R12.
• Responsible for the implementation of Oracle Order Management, CDL and Configurator Extensions, BOM, WIP, Inventory, Shipping, Advanced Pricing, Installed Based and Advanced Supply Chain Planning with Global Order Promising for a manufacturing company with different business units.
• Registered customized reports and concurrent program/sets using System Administrator and Application Developer responsibilities.
• Worked on performance tuning of existing reports and PL/SQL programs.
• Developed customized reports using XML Publisher Discoverer.
• Worked on Oracle Discoverer Admin for creating item classes, custom folders and parameterized reports for OM, AR, AP and PO modules.
• Worked on discoverer desktop for creating various workbooks based on custom folders.
• Customized Oracle standard reports like AP and AR Aging Reports, PO report and changed the output format to XML and created new templates for XML Publisher to display in pdf or excel format.
• Converted custom forms using Forms 6i in Installed base for global update of instance.
• Developed Forms, Menus, Object Libraries, and PL/SQL Library using Oracle Form Builder 6i.
• Customized sales order form using Form personalization.
• Gathered requirements, wrote functional MD050 and technical MD070 specifications, provided recommendations for user concerns and implement process and system modification.

Environment: Oracle Apps R12, 11.5.8/10.2, GL, AP, AR, PO, OM, Oracle 9i/10g, Pl/SQL, SQL Plus, SQL Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Oracle Configurator, Shell Scripting, TOAD, PVCS, UNIX.

Responsibilities:

• Gathering functional requirements and created technical documents for custom reports, script files.
• Wrote PL/SQL programs for implementing validation rules and loading data from staging tables to interface tables.
• Involved in analyzing and developing the code as per MD50.
• Created database objects like tables, views, functions, procedures, triggers etc.
• Enhanced the existing process with new functionality to meet the client requirements.
• Involved in developing reports, concurrent programs, AOL objects etc. as per the business requirements.
• Developed inbound interface to load purchase order details into purchasing base tables from legacy systems.
• Extensively worked on FND LOAD for migrating concurrent programs, value sets, descriptive flex fields, lookups from one instance to another.
• Developed UNIX shell script for file transfer and data loading to automate interface programs.
• Registered the shell scripts as concurrent programs and created a scheduling process that invokes the scripts periodically.
• Played vital role in resolving business critical issues in PL/SQL Packages, Reports etc.

Environment: Oracle Apps 11.5.6, Oracle 9i, SQL, PL/SQL, SQL developer, XML Publisher, UNIX.