Professional Summary:

• An accomplished IT professional with 8 years of Professional experience on Oracle Applications as a Techno-Functional consultant in Oracle ERP Application R12, 11i .
• Significant experience in performing day-to-day maintenance and support of existing Oracle ERP applications in parallel with the analysis, design, development and co-ordination activities for new applications.
• 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 .
• Involved in Implementations, Version Upgrades, Data Conversions and Customization of Reports and Forms in Oracle Supply chain management and Manufacturing.
• Strong programming knowledge in creating Procedures, Functions, Packages, Triggers, Reports and registering them as Concurrent programs and other database objects using SQL and PL/SQL.
• Good Knowledge on Development skills in developing RICE Components in the domain of Oracle Applications E-Business Suite.
• 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.
• Experience in development of concurrent programs, customization and modifications of reports.
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Main focus on Implementation, Upgrade, Support and tuning of Oracle Financials, Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules.
• 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 a lot of Complex, Optimized data queries and performed constant QA checks.
• 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.
• 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.
• Strong aptitude to learn and acquire new skills. Self-Confident and ability to work independently as well as in a group.
• 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.

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:

• Working in NEBF ERP implementation project as an Oracle Applications Technical Consultant.
• Experience on Oracle Manufacturing and Oracle Purchasing, Order Management and Supply Chain modules
• Designed Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Configured Oracle GL, AP, AR, Ebiz Tax and PO from scratch and simultaneously createdBR100 documentation for the setups
• 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.
• 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, Purchasing and Payables and Fixed Assets Module.
• Worked with GL tables, AR Interface, Customer Interface and GL interface GL INTERFACE, GL BUDGET INTERFACE .
• 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.
• Responsibilities included technical design, development and support for Order to Cash and Procure to Pay business processes.
• 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
• 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 .
• Developed custom reports: Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Technical Design of Reports in Oracle Lease Management Development of the same using Oracle Reports 6i.
• Was directly interacting with Client at onsite and coordinating activities during full software life cycle model.
• Implementation and Enhancement of Oracle Lease management module along with implementation of Oracle Financials GL,AR, FA .
• 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 .
• Preparation of technical and Solution Design document for the offshore developer.Gathered requirements, wrote functional MD050 and technical MD070 specifications, provided recommendations for user concerns and implement process and system modification.
• Have good knowledge in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively

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:

• Developed SQL scripts to create temporary tables and SQL Loader control files to load the item legacy data into the temporary tables.
• Analyze project specifications and procedures and translate into detailed technical specifications
• 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.
• Defined Account Setups in Ebiz for AP, AR and GL
• Imported new, changed and completed sales orders from legacy system to oracle using order import order management open interface .
• Participated in technical discussions to ensure the business requirements met
• Involved in Implementations, Data Conversions and Forms in Oracle Supply chain management and Manufacturing
• Experience in defining Testing Methodologies, Test Environment, Designing Test Plans, Writing Test Cases and Test Scripts, Verifying and Validating Application Software.
• Developed Business Areas, Custom folders, Item classes, Hierarchies in Discoverer Administration Edition.
• Created 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.
• Implementation and Customization of MODULES AP, AR GL, FA in Multi Org environment.
• Developed AP Invoice interface to load data from legacy system to AP interface tables.
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Designing and development of custom interfaces on the Oracle AR and Oracle AP.
• Designed and developed reports to handle multi-currency exchange gain and losses.
• 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 GL Budget Interface table using SQL Loader.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables
• 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.
• Used Template, sub Template method for a creating single report with multiple Layouts
• Created new custom reports in XML/BI Publisher.
• Involved in Developed Advanced Shipment Notice ASN process and printing.Created new OAF pages which includes custom simple search, advanced search, PPR partial page rendering select option, committing data through EO Entity Objects .
• Modified and created new concurrent programs as well as executable files when new reports were created.
• Strong knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library AOL .
• 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.
• Used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.
• Driven requirement gathering sessions and provide functional assistance to business users for Quick Service
• 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.
• Experienced in Performance Tuning of SQL queries Views using Explain Plan, Hints and indexes.
• Preparation of technical and Solution Design document for the offshore developer.

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, , Shell Scripting, TOAD, PVCS, UNIX.

Confidential

Role:Oracle Apps Techno-Functional Consultant.

Responsibilities:

• Worked in Wells Fargo as an Oracle Applications Techno-Functional Consultant.
• Designed Business Required Documents and detailed Functional Design Documents for Financial modules.
• Worked on various financial modules AP-Accounts Payables, PO-Purchase order, GL-General Ledger, OM -Order Management and AR-Accounts Receivables .
• 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.
• Changed the existing forms and reports of customized Accounts Receivables.
• 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.
• 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.
• In addition, also used the System Administrator responsibility to create users, responsibilities, custom profiles, request groups, request sets and Value sets
• Worked with form personalization for customizing Oracle forms.
• Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller CO and entity object EO.
• PO requisition reports,AR sales profit report with cost of goods,GL Summary Report.
• Defined request sets with concurrent programs to run in stages depending on the output generated by each request.
• Developed Documentation Templates such as Data Mapping, Functional, Technical and Testing like CV60, MD70 using AIM.
• Techno-functional analyst for reporting and interfaces of Oracle EBS in Service Contracts, AR and AP modules
• 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.
• Designed and developed interface programs to extract orders from custom web application objects, populate to staging table, validate the data in staging table and send to interface tables.
• Importing Orders from Legacy EMP to Oracle includes the following interface programs
• EMP Interface Control
• Order defaults and substitution
• Order Import
• Change Order Import
• Used standard Oracle OE ORDER PUB API to create a new sales order and update/cancel an existing sales order in Oracle Apps System.
• Used standard Oracle OE HOLDS PUB API to apply/release holds on the sales order created.
• Worked on requirement gathering, design and development of custom application Supervisor Information Management System SIMS in OA framework
• Developed the below Custom reports using Reports 10g as per the client requirements in OM module
• Consolidated Pick Slip
• Packing Slip
• Daily Inventory Report
• Shipping Exception Report
• Item Label Report
• Bill of Ladding Report
• Form Personalization Tasks
• Pick Release Form: Not allow selection/insert/update of the organization field.
• Copy flags when copying sales orders: Allows picking and choose which sales order elements are copied along with the order.
• Customized the existing forms as per the client requirement.
• Workflow Customization
• Seeded OM Workflows are copied and customized to create Ship only Workflow.
• Dealt with registering / defining of custom applications, tables, concurrent requests, standard report submission etc and also with profile options, defining of application users and responsibilities.
• Workflow notification for Sales Order will be triggered at the launch of Sales Order Book event and an email notification is sent to the concerned.
• Created and used stored procedures, packages, cursors and functions to do the validations on the legacy data.
• Modified the existing code to meet the new business requirements. Interact with the Business users and analyze new business requirements or enhancements or change requests and prepared Functional/Technical Design documents.
• Involved in design of functional setups in Order Management.
• Responsible for Functional testing and Process setup.
• Created indexes to enhance the performance of the applications.
• Involved in recoding some of the existing custom interfaces in PL/SQL to reduce the turnaround time of execution and completion of concurrent processes.
• Involved in design of AIM Application Implementation Methodology documents MD-70 for all conversion and reports.

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:

• This project was an upgrade project which involved the upgradation of Oracle Applications.
• Involved in following modules INV, AP, AR, OM, WIP, BOM, OPM, FA, CM.
• Developed interface to load Receivables invoices from external system, contract base to Oracle using Auto Invoice Concurrent Programs
• Customized the components, upgraded shell scripts, which calls reports, control files and SQL files, which are in the production.
• Migrated objects into Oracle Apps EBS R12.
• Setup Custom Modifiers to derive discounted price for few business requirements.
• Worked on the staging R12 Apps environment to convert AP suppliers and AP Open Invoices from 11i to TCA Model and AP of R12.
• Prepared technical design documentation and Unit test plan documents for XML Reports, Conversions and few Extensions.
• Involved in reviewing the Objects.
• Developed Oracle 10g Reports using XML publisher.
• Developed Program for Item Conversion and Supplier Data Conversion.
• Developed Backlog Summary report for Sales Orders.
• Developed the templates for several reports using XML publisher.
• Developed Open Purchase Order Report.
• Involved in Item Import Interface and Item Cost Import Interface.
• Involved in Personalizing the Custom OAF page.
• Developed Margin Analysis Report which will pull all the sales orders that are ship confirmed and Invoices that are created manually and created through Auto Invoice.
• Developed Price Book Extract Report for various price lists.
• Prepared design documents MD050 and technical documents MD070 for all the customizations.

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 Orderto Cash, Procure to pay cycle, Oracle Grants and Projects implementation.
• Worked as an Technical and Oracle Applications Techno-Functional Consultant
• Configured, tested and built all the financials modules AP, AR, CE, GL and assisted in the Oracle Projects setup.
• Developed Auto Invoice Interface program to import invoices from legacy systems to Oracle Receivables.
• Involved in creating customer invoice reports.
• Extensively worked on UTL FILE Packages in Reading data from data files and put them in database tables.
• Extensively utilized the application object library to register SQL LOADER programs, PL/SQL procedures, forms and reports.
• Developed reports for Order management, BOM modules.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Integration Objects Cross checking with Account Payable, Account Receivables General Ledger Modules.
• Used SQL Loader for import into custom tables and PL/SQL for complete validation of data and inserting into interface tables.
• OM Customization - Forms Personalization for Related Item Price and Quantity.
• Work flow customization to auto creates PO for Low Value requisitions/
• Preparation of SQL Loader Control Program and PL/SQL script with validation to upload data from flat file to oracle Applications base tables.
• Development of GL Daily Rates Inbound Interface to upload data from flat file to Oracle Applications base tables.
• Preparing the MD070 Documents based on MD050 for each component.
• Customised of AP invoice aging report as per client requirement.
• Developed new Custom Oracle 6i, SQL, PL/SQL Reports as per the business requirement.
• Developing Custom Interface Programs and XML Publisher reports.
• Development and customization of reports.
• 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.

Confidential

Title :Pl/SQL Developer

Responsibilities:

• Extensively involved in coding of the Business Rules through PL/SQL using the Functions,Cursors, Triggers, Stored Procedure, and Packages in the server side.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Designed ER diagrams and normalization of database.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL Plus.
• Migrated the data from external files into Database tables using SQL Loader.
• Extensively involved in performance and tuning of all SQL and PL/SQL code.
• Used Built-in Packages provided by oracle for debugging.
• Reviewing / Testing Procedures Functions developed by the team members.
• Wrote triggers to handle user-generated events.
• Developed UNIX shell scripts to schedule the cron jobs.
• Used Developer 2000 to generate reports of statements for users.

Environment: Developer 2000, SQL, PL/SQL, Oracle 9i, UNIX, Windows 2000