Professional Summary:

• A distinguished IT professional with 8 years of Professional experience on Oracle Applications as a Techno-Functional consultant in Oracle ERP Application R12, 11i
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Outstanding Functional/Technical knowledge in Oracle Applications Oracle Financials like GL -General Ledger, AP-Accounts Payables, AR-Accounts Receivables ,FA-Fixed Assets, CM-Cash Management ,
• PO-Oracle Purchasing, OM Order Management/Advanced Pricing , Supply Chain Management SCM Manufacturing INV-Inventory, WIP-Work in Progress, BOM-Bills of Materials , Install Base, Service Contracts , iExpenses , iProcurement and AOL Application Object Library .
• Main focus on Implementation, Upgrade, Support and tuning of Oracle Financials, Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules.
• Experienced in ERP Applications Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Experience in all phases of the Software Development Life Cycle SDLC in an ERP environment.
• Strong implementation knowledge of O2C Order to Cash , P2P Procure to Pay and Drop Ship end to end Cycles.
• Excellent skills in SQL, PL/SQL, Developer 6i/2000 Oracle Forms and Reports , Discoverer Reports
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Designed Reports based upon specifications and also determined reporting needs based upon specifications.
• Hands on experience in implementing RICE Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions components, workflows, Oracle Alerts, Lookups, OA Framework OAF , XML Publisher Reports.
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Created a lot of Complex, Optimized data queries and performed constant QA checks.
• Hands on experience in using various Oracle technologies to effectively implement an end-to-end solution to an organization's strategic goals and objectives including: Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Application Server and Oracle PL/SQL and SQL and Oracle RDBMS, Oracle Developer Oracle Forms and Reports Developer
• Possess good expertise in developing programs using SQL loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Perform and maintain logs to track reporting activities.
• 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.
• Experience in development of concurrent programs, customization and modifications of reports.
• Extensive experience in designing, developing and testing the RICE components Reports, Interfaces, Conversions, Extensions as per Oracle Standards.
• Possess good project management skills and also have lead in many projects.
• Strong familiarity with AIM methodology in creating BRD, MD-50, MD-70, MD-120 and also testing documents throughout multiple Projects.
• Knowledge and Experience of TCA Trading Community Architecture .
• Expertise in developing custom reports in XML Publisher.
• Demonstrated ability to identify root causes/ debugging of problems and troubleshoot, considering both long and short-term impact of proposed solutions and developed workable solutions
• Onsite coordination experience and work with the offshore team to knowledge transfer and development support.
• An Excellent Team Player with good problem solving approach having strong communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Extensive Functional Technical skills in the area of Business User Interaction, System Requirement gathering, Application Development, Customizations and Implementation of software applications in client-server, database and enterprise software environments.

Technical Skills:

ERP :Oracle E-Business Suite: Versions 12i/11.5.10/11.0.3

Modules :Order Management OM , Inventory INV , Bills Of Materials BOM , Account Receivables AR ,Purchase Order PO ,Fixed Assets FA , Account Payables AP ,General Ledger GL , Cash Management CM , Application Object Library AOL , Work In Process WIP , Material Resource Planning MRP , Flex fields, TCA, CRM, Service Contracts, Service Fields, SYSADMIN, INSTALLBASE

Tools : Toad, SQL Loader, PL/SQL Developer, Discoverer, Data Loader,

BI/XML Publisher, Load Runner

GUI : Developer 6i, Developer 2000, Forms 6i/10g, Reports 6i/10g

Programming Languages : SQL, PL/SQL, C, C , Java, HTML5, PHP, UNIX Shell Scripting

Database : Oracle 9i/10g/11g, Microsoft SQL Server 2010, MS Access

Operating Systems : Windows 98/2000/NT/XP/7/8, UNIX Solaris, HP-UX , Linux.

Professional Experience:

Confidential

Role: Oracle Apps Techno-Functional Consultant.

Responsibilities:

• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Loaded the vendor's information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Develop AP/AR/GL/PO reports using discoverer which include the following
• Techno-functional analyst for reporting and interfaces of Oracle EBS in OM, AR and AP modules.
• Imported new, changed and completed sales orders from legacy system to oracle using order import order management open interface .
• Customized MODULES AP, AR GL, FA in Multi Org environment.
• Migrated AP Invoice interface to load data from legacy system to AP interface tables.
• Migrated custom interfaces on the Oracle AR and Oracle AP from oracle 11i to R12.
• Developed reports to handle multi-currency exchange gain and losses.
• Worked with AP Team to reconcile AP with General Ledger by running Accounts Payable Trail Balance report, Posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Imported Open Payables Invoices from legacy system into Oracle AP using Ap-Invoices-Interface and Ap-Invoice-Lines-Interface tables.
• Worked on the Budget Upload Open Interface to load the data from legacy systems to the

Confidential

SQL Loader.

• Modified custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition
• Modified Workbooks based on the Custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Performance tuning of the discoverer reports.
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. It displays the discount amount calculated for that order basing on the payment terms of the order.
• Upgrade experience in R12
• Customized the existing workflow by adding notifications at the time of Purchase Order approval and also involved in customizing Requisition package in iProcurement modules as client requirements
• Development/modification of custom reports in purchasing and payables.
• Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.
• Preparation of technical and Solution Design document for the offshore developer.

Environment: Oracle Applications R12/11.5.10, Reports 6i/10g, SQL, PL/SQL of Oracle 9i/10g, PL/SQL on UNIX, Windows 2000/NT environment, Java, JSP,Forms 6i/10g, Discoverer10g, XML/BI Publisher, Toad, SQL Loader.

Confidential

Title: Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked in FedEx as an Oracle Applications Techno-Functional Consultant.
• Migrated an Item Conversion to import legacy inventory item data into Oracle base tables.
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Worked with GL tables, AR Interface, Customer Interface and GL interface GL INTERFACE, GL BUDGET INTERFACE .
• Upgrade experience in R12
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables.
• Worked on SQL Loader scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.
• 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 / Quoting with Configurator, 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, Open 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 11.5.8/10.2, GL, AP, AR, PO, OM, Oracle 9i, Pl/SQL, SQL Plus, SQL Loader, Reports 6i, Forms 6i, XML Publisher, Discoverer, Java,AWS,REStFul,Oracle Configurator, Shell Scripting, TOAD, PVCS, UNIX.

Confidential

Title: Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM .
• PO requisition reports,AR sales profit report with cost of goods,GL Summary Report.
• Develop AP/AR/GL/PO reports using discoverer which include the following
• Worked with form personalization for customizing Oracle forms.
• R12 Oracle Configurator, CDL and Configurator extensions, Quote / Order to Cash Order Management, Oracle Advanced Pricing, Inventory, Bills of Material, Installed Base and PLM Advanced Product Catalog for a major Payroll and Benefit processing provider with MACD / TSO solution.
• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Techno-functional analyst for reporting and interfaces of Oracle EBS in Service Contracts, AR and AP modules
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator FSG .
• Developed AP Invoice Conversion and vendors conversion programs.
• Techno-functional analyst for reporting and interfaces of Oracle EBS in integration with GL, AR, AP and PO, iProcurement modules.
• As a Sr. Oracle Techno Functional consultant responsible for Enhancements and Production support of RICE components in GL, SLA, AP, PO and AR with BI / XML Publisher Reports.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Developing PL/SQL code to obtain the required functionality.
• Changed the existing forms and reports of customized Accounts Receivables.
• Troubleshooting of the Order Management OM and Inventory INV modules within Oracle Applications.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Worked on complete Software development Lifecycle SDLC, from gathering requirements to deployment .
• Interfaced legacy system GL data using Journal Import. Run Journal Import to load data into GL JE BATCHES, GL JE HEADERS and GL JE LINES tables.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.

Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL Loader, SQL Plus, TOAD, Discoverer, SOA,UNIX, JDeveloper, Shell scripts

Confidential

Title: Oracle Applications Techno-Functional Consultant

Responsibilities:

• Understanding the existing system and working in a TEVA ERP implementation project as an Oracle Applications Technical Consultant.
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Worked with the functional team while extracting non-Oracle data and Converting to Oracle with validations.
• Designed Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Work with functional setups to create AP invoice sources, Accounting flex field, Chart of accounts.
• Implementation and Customization of MODULES AP, AR GL, FA in Multi Org environment.
• Responsible for creation of MD070s for AP Invoice import.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Purchasing and Payables and Fixed Assets Module.
• Responsibilities included technical design, development and support for Order to Cash and Procure to Pay business processes.
• Developed a custom layout XML format according to the user specifications and worked on incorporating it to the standard print Purchase Order and Invoice reports using XML Publisher BI Publisher .
• Worked with the GL Journal Import, AP Invoices, AR Invoices, Item conversions
• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level
• Created new custom reports in XML/BI Publisher and used Template, sub Template method for a creating single report with multiple Layouts
• Developed conversion program for validating and importing Open AR Transactions Invoices from legacy system to Oracle interface tables. Used Auto invoice Master Program to load the interface table data into Oracle AR base tables.
• Developed custom forms and reports to correct interface errors and send the error messages to legacy system owners.
• Using SQL Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Involved in the development of TCA Model.
• Involved in Developed Advanced Shipment Notice ASN process and printing.
• Designed and Developed the Commission payments project, which loads the all rep groups and percentages information to the custom tables.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects which are being migrated into new instances.
• Developed an outbound interface to export GL data to third party systems, also inbound interfaces to import into GL by populating GL Interface Table.
• Extensively involved in developing Technical Design Documents MD70 using Application Implementation Methodology AIM .
• Developed new and customized existing Oracle and Discoverer reports as per the user request.
• Involved in testing existing FSG reports.
• Developed AIM Documentations for the components.
• Involved in Peer review and Unit testing.
• Involved in resolving daily business issues in Quick time.

Environment: Oracle Apps 11.5.8, Procure-2-Pay, Oracle 10g, Oracle R.I.C.E, Oracle A.I.M, Oracle SQL, Oracle PL/SQL, AP, GL, PO, AR, OM, INV, TCA, JDeveloper,TOAD, Discoverer, XML Publisher, SQL Developer, Forms 6i , UNIX, Shell Scripting, WINDOWS XP.

Confidential

Title: Oracle Applications Techno-Functional consultant

Responsibilities:

• Actively involved in full implementation of E-business suit including gathering the requirements from the user and understanding their business model.
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• Worked in getting the requirements from the users and involved in functional setups in financial modules.
• Defined the descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Support the users when loading AP Invoice and other payment activities like printing payment registers and checks.
• Develop AP/AR/GL/PO reports using discoverer which include the following
• GL Summary Report.
• AR sales profit report with cost of goods,
• Created new reports and Customized standard reports in PO such as Expected Receipts Report, Printed Requisitions Report and Purchase Order Detail Report.
• Customized seeded reports as per the requirement like Customized the standard Purchase Requisition Status report in purchasing and scheduled payment report.
• PO requisition reports,
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM .
• As a Techno Functional consultant, Played a key role in upgrading oracle 11.5.7 to R12 for P2P and O2C Tracks
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator FSG .
• Involved in writing interface program to load the data from external systems into Oracle purchasing PO interface tables.
• Developed AP Invoice Conversion and vendors conversion programs.
• Customization of PO Approval workflow process to ensure the notification is send to next in hierarchy if the first approver doesn't respond using workflow builder and also to stop sending emails upon update of PO for second time onwards.
• Tuned customized application including reports and back end programs by using different application tuning techniques.
• Customized the PO entry form to ensure Revision field is not null when item is entered.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Worked on items in Inventory.
• Imported Bills and Routings through BOM Interfaces.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.

Environment: Oracle Applications 11i, GL, AR, AP, PO, Reports 6i, PL/SQL, SQL Loader, SQL Plus, TOAD, UNIX, Shell scripts.

Confidential

Title: Oracle Applications Techno-Functional consultant

Responsibilities:

• Involved in the complete Order to Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Developed Auto Invoice Interface program to import invoices from legacy systems to Oracle Receivables.
• Used SQL Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• As a Techno functional Consultant, responsible for Analysis, design, development, testing and implementation of customized Oracle ERP solutions for new implementations and upgrades
• Preparation of SQL Loader Control Program and PL/SQL script with validation to upload data from flat file to oracle Applications base tables.
• Configured, tested and built all the financials modules AP, AR, CE, GL and assisted in the Oracle Projects setup.
• Development of GL Daily Rates Inbound Interface to upload data from flat file to Oracle Applications base tables.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Preparing the MD070 Documents based on MD050 for each component.
• Customised of AP invoice aging report as per client requirement.
• Developing Custom Interface Programs and XML Publisher reports.
• Extensively utilized the application object library to register SQL LOADER programs, PL/SQL procedures, forms and reports.
• Developed reports for Order management, BOM modules.
• Development and customization of reports.
• Integration Objects Cross checking with Account Payable, Account Receivables General Ledger Modules.
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters.

Environment: Oracle Applications 11i OM, PO, FA, GL, GA, AP, AR , Workflow Builder, SQL Loader, PL/SQL, Developer 2000/6i, JDeveloper, XML Publisher, TOAD.