SUMMARY:

• Around 9 years of professional work experience as techno - functional consultant in Oracle ERP Applications (R12, 11i).
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Performed GAP analysis and prepared solution presentation for review.
• Performed Functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Ability to implement the setups needed for financial, distribution and supply chain modules.
• Good Functional/Technical Knowledge in Oracle Applications with Distribution and Supply Chain Modules like (OM-Order Management, INV-Inventory, PO-Purchasing, WSH-Shipping) Financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables) and Self Service Modules like (iExpenses, iProcurement, iSupplier, iReceivables, iStore) using agile and waterfall environments .
• Strong working knowledge in sub-ledger flows: Order to Cash, procure to pay and drop ship processes.
• Expertise on designing and implementing Oracle Alerts and Lookups.
• Strong exposure on Trading Community Architecture (TCA) and multi-org in 11i and R12.
• Remarkable Oracle Financials Functional and technical experience and practicality in Trading Community Architecture Multi Org Access Control and Role Based Access Control.
• Familiarity with development, quality assurance and testing methodologies
• In-depth Knowledge of Schema Objects (Tables, Global Temporary Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links) and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling and Flashback Operation Concepts
• Ability to write test cases, test execution, defect tracking, and test reporting
• Experience in all aspects of Software Development Life Cycle including System Analysis, Software Design, Development, Implementation and Testing.
• Excellent skills in Oracle 9i,10g,11g environments using SQL, PL/SQL, Developer 6i/2000 (Oracle Forms 6i/10g and Reports 6i/10g), Discoverer 10g.
• Experience in Designing and developing reports using XML/BI Publisher, Demantra Demand Management.
• Strong coding experience in PL/SQL development using Packages, Stored Procedures with Functions, Triggers, Writing and Tuning complex SQL statements.
• Expertise in Design, Development and Customization of RICE (Reports, Interface, Conversions and Extensions) using PL/SQL, SQL *Loader, UTL File etc.
• Extensive experience in customization of forms, Form Personalization, Customization of Reports, defining value sets and Defining Profile values by using Application Object Library (AOL) and Functional setups.
• Worked in designing various Technical and Functional Documents like MD50, MD070, MD120 and Conversion Mapping documents like CV040, CV060 using AIM Methodology.
• Extract, Transform and Load legacy data into Data warehouse and develop analytical SQL queries with CUBE, ROLLUP, GROUPING SETS and MODEL Clause to generate reports using data in Data warehouse and Data marts
• Expert in Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning.
• Experience in Migrating Code to different Environments from SQL Plus interface and develop BAT files to automate code migration
• Knowledge of under-the-hood concepts of SQL execution process, multi table joins, optimizer, indexes and their types, optimizer/access path/join/parallel execution hints
• Expert in debugging, developed package incorporating debugging packages like DBMS TRACE, DBMS METADATA and DBMS DEBUG provided by Oracle to pin point code (Or) logic (Or) data issues
• Knowledge of Job scheduling tools to create, modify, troubleshoot jobs, schedule and automate daily/weekly/monthly/quarterly jobs
• Hands on experience in using UNIX and Shell commands to create jobs, automate processes, moving processes to background and monitoring processes.
• Experience in Data mining and analyzing data to identify the Fact and Dimension tables.
• Involved in physical Data Modeling and document business requirements by reverse engineering from source code
• Experience in providing production support and provide critical to normal patches for technical/ business related bugs
• Active team player with commitment to work to meet deadline, strong communication, good analytical and time management skills

TECHNICAL SKILLS:

ERP Versions: Oracle Applications 11i, R12

Oracle ERP Modules: General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Oracle Purchasing (PO), Oracle Inventory (INV), Order Management (OM), Shipping (WSH), Advanced Pricing

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

Developer Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, XML Publisher, Discoverer 10g/4i, Oracle Workflow Builder 2.4/2.6.5, OA Framework, OBIEE

Operating Systems: Windows XP/2007/2008, HP UNIX, Oracle Linux 6, Sun Solaris, AIX

Source Control Software: Visual Source Safe, Clear Case, CVS, TFS

Other Tools: INFORMATICA, XML spy, Microsoft office suite, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Oracle EBS Techno Functional Consultant

Responsibilities:

• Worked on Customization of REQAPPRV Workflow based on the business requirement.
• Creation of Management Reports on Project /Deliverable status, identifying the Risks and issues and providing the mitigations and solutions; Presentations to the Global teams on Project issues and Solution discussions; Functional designs(MD050s)/Technical Designs(MD070S) for FRICEW requirements.
• Developed approval rules for purchase orders using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables.
• Worked on OAF Extensions for prospective supplier webpage in iSupplier, iProcurement modules.
• Worked on BC4J Components for customizations, Extensions and modifications to AM (Application Module), VO (View Object) and CO(Controller).
• Developed Bursting report in isupplier to send notifications to the vendors.
• Customized POS Supplier approval management workflow in isupplier.
• Developed Detail Expenditure Report in General Ledger.
• Developed Sub Ledger Accounting Report and New Account Code Combination Report using XML Publisher.
• Developed extensive modifications to PO Account Generator using work flow builder.
• Developed GL interface for importing journals from legacy systems into GL INTERFACE tables.
• Generated GL reports like intercompany transaction detail report, Open-Debit memo report , Supplier Payment History report to meet Client requirements.

Environment: Apps R12.1.3 (GL, AP, AR, INV, PO, Fixed Assets, iProcurement, iSupplier, iLeasing), Oracle Database 10g, Reports 10g, Forms 10g, EDI, PL/SQL, TOAD, XML Publisher, Workflow Builder, WINSCP, UNIX, SQL*Developer.

Confidential, Chicago, IL

Sr. Oracle EBS Manufacturing Techno Functional Analyst

Responsibilities:

• Responsible for Design, Development and support of O2C processing project and support.
• Designed and developed custom forms to enter the customer operations as the client’s requirements.
• Using the API(QP PRICE LIST PUB.Process Price List) Import of Price List records in advanced pricing module
• Worked on Order Import in Order Management (OM), Purchase Order conversions for PO.
• Developed stored procedures to populate the interface tables in the process of importing customer’s information into AR and Purchase Order information into PO.
• Developed in bound Custom PL/SQL Package for validating the PO Acknowledgement, Shipments, and Invoices from the legacy.
• Worked on designing EDI outbound 856 to export ASN in ADF file format using UTL FILE to the Trading Partners setup in oracle.
• Developing customized purchasing, shipment, Sales order and AR invoice reports using XML publisher.
• Worked for Inventory Application Setups and e-Commerce gateway setups.
• Developing customized Pricing, Sales order report using XML publisher.
• Identify the long running and frequently used pricing Interfaces and tune this Interfaces to reduce the runtime considerably
• Worked on Advanced Pricing RICEW objects like Price List conversion program, Mass Price Update from, Custom PL/SQL procedure to return Prices for products, Custom Price Book reports based on Client Requirements in Advanced Pricing .

Environment: Apps R12.1.3 (GL, AR, INV, OM, Advance Pricing, Fixed Assets), Oracle Database 10g, Reports 10g, Forms 10g, EDI, PL/SQL, TOAD, XML Publisher, Workflow Builder, WINSCP, UNIX, SQL*Developer.

Confidential, Springs, GA

Sr. Oracle EBS Techno Functional Analyst

Responsibilities:

• Developed Open Purchase Orders report using XML that queries all Open PO's at header, line and shipment levels and shows the quantity of goods received and balance quantity of goods to be received against the shipment line.
• Personalized various forms to include additional information such as adding IBAN number on Invoice, mandatory description for Invoice Header line , etc.,
• Modified the Client's Custom Check template to reflect the changes requested by the users for limiting the number of lines appearing on the single page, Length and font of different fields on the check and bank code location.
• Customized and developed various reports to user community for day to day operational support in Receivables, General Ledger, Advanced Purchasing and Payables and iprocurement.
• The PO Approval Workflow is used to approve new documents as well as approve revisions to the Purchase Orders using workflow builder.
• Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.
• Created PO alerts
• Designed and customized workflows in PO and OM and debugged errors like duplicate rows in modules schema.
• Modified the Client's Custom Check template to reflect the changes requested by the users for limiting the number of lines appearing on the single page, Length and font of different fields on the check and bank code location.
• Customized PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow PO Account Generator Workflow
• Created PO alerts.

Environment: Oracle Applications R12.2.4, (OM, PO, AR, AP, GL, CM), Oracle Database 11g, Forms Builder 10g, Reports Builder 10g, XML Publisher 5.6, HP Service Center, SQL, PL/SQL, UNIX

Confidential, Englewood, CO

Sr. Oracle EBS Manufacturing Techno Functional Consultant

Responsibilities:

• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.
• Designed and developed custom USER APPROVAL WORKFLOW to meet the client application’s user creation and maintenance according to the business requirement.
• Worked on Version Control software to check-in codes and integrated with MKS for file migration.
• Developed PL/SQL scripts for validating the data and Storing the data into MTL SYSTEM ITEMS INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
• Worked on supporting Receiving Transactions Interface errors in Purchasing, fixing the stuck records, investigating the issues in receiving and following up with the Receiving users at Distribution Centers.
• Extensively worked with version control and migration software for deploying the changes to production.
• Designed and developed an interface program to Load Item information for the newly created items and also updated the existing item information in Inventory using Item Import.
• Responsible for developing mass update of Item Attributes process as desired by users at both the Organization and Sub-inventory levels.
• Customized various standard Oracle reports such as AR Invoice Detail, PO Printed Purchase Order Report, vendor register and others according to the business requirements.
• Developed customer interface using Oracle standard TCA APIs including DQM rules.
• Implemented and managed an EDI solution interfacing Trading Partners with legacy systems and Oracle Applications, and managing data to support Order Entry, Purchasing, Accounts Payable, Shipping, and Accounts Receivables.
• Built a periodic Oracle alert with sales order#, item, order and shipping quantities information
• Built item import and BOM import load programs to create raw material items (components) first and creating Bills structures.
• Customized PO Approval Workflow: Implemented notification reminder and Timeout needs for the PO Approval workflow PO Account Generator Workflow
• Developed interface program for conversion of sales orders using the Order Import Open Interface program.
• Developed custom program to create orders SCM (Supply Chain Management) Orders.
• Worked on developing RMA which updates the return orders in the OM Module
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• Developed Backlog Summary report for Sales Orders.

Environment: Oracle Apps EBS Release 12 (12.1.3 (AP, PO, INV, OM, AR, Shipping, CM), XML Gateway, EDI Gateway, SQL, PL-SQL, Oracle 10g, Forms & Reports, Putty, Workflow, UNIX, MKS.

Linkedin, Sunnyvale, CA

Sr. Oracle EBS Techno Functional Consultant

Responsibilities:

• Developed in bound Custom PL/SQL Package for validating the PO Acknowledgement , and Invoices from the legacy.
• Developed Outbound PL/SQL Packages, Procedures, and Functions for validating the Purchasing, Receipts and Invoice Payments and inserting in staging table to transfer data to Third Party.
• Extensively worked on R12 migration analysis, mapping, conversion development and Testing .
• Analyzed, designed and prepared Oracle Technical document (MD 070) to implement PO Outbound to Tradeshift (Legacy System) .
• Customized forms using custom.pll and Form personalization to change the functionality of the standard PO forms.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Extensively worked on RBAC for creating new Instance Sets, Functions, Roles and Grants and managed User authentication process.
• Designed and customized workflows in PO and OM and debugged errors like duplicate rows in modules schema.
• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle.
• Worked on developing RMA which updates the return orders in the OM Module
• Customized the Order Header workflow to place custom holds as per client requirement before the order is booked.
• Developed Backlog Summary report for Sales Orders
• Designed and developed the whole process of extracting data from multiple XML Log files downloaded from bank, and sending out single email with attached log report in legitimate format.
• Supported the team with Post production issues. Acted as a Maintenance technical support for guiding users understanding the new system and solve daily problems.

Environment: Apps R12.1.3 (GL, AP, AR, INV, PO, Fixed Assets, iProcurement, RBAC, AOL), Oracle Database 10g, Reports 10g, Forms 10g, EDI, PL/SQL, TOAD, XML Publisher, Workflow Builder, JIRA, WINSCP, UNIX, SQL*Developer.

Confidential, Detroit, MI Oct

Lead Oracle EBS Consultant

Responsibilities:

• Involved in requirement gathering from business users, designed solutions and authored Technical Specification Documents MD70 and MD120.
• Performed requirements gathering, data analysis, development, testing, integration and maintenance of applications in Oracle EBS, NOETIX and APEX.
• Redesigned and developed various inbound interfaces including AP Invoices, Purchase Orders, Journal Imports, Suppliers, AR Transactions, Receipts/Lockbox integrations, etc.,
• Created various Business Areas and developed worksheets in Discoverer Plus. Shared them with users for accessing through Discoverer Viewer.
• Created various templates for uploading catalogs using Catalog Bulk Loader process in iProcurement .
• Personalized requisition Submission screen in iProcurement to include additional information in DFF.
• Worked on AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR PAYMENTS INTERFACE ALL), from interface table to the Base Interim tables and finally to the base table.
• Used TCA API's for creating Parties, Party Accounts, Contacts, and Account Sites.
• Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs
• Debugged various issues related to AR, AP, PO and OM modules around Dunning letters, Payment Terms, Validation, Mass Additions Create, OM Processing Constraints, Unaccounted receipts and others.
• Developed various custom XML Publisher reports as per business requirement like, AR Statements Generation report, custom Dunning Letters, Payment Register, SO Listing, Packing List, Open Transaction Report, Transportation Register, On hand Quantity Report by Organization etc.,
• Worked in close proximity with Oracle support to fix various data issues in AP, analyzed and applied Global Data Fixes and registered few as concurrent programs. Applied Root Cause Fixes to resolve the cause for data corruptions, tested and deployed to production.
• Customized various workflows using workflow builder to meet business requirements, including Requisition Approval, PO Approval, Invoice Approval, Order Header Workflow, Order Line Workflow, Auto Create.
• Created and maintained printer setups in Oracle, working with Database Administrators to test printer setups.
• Developed scripts to convert data from oracle applications to Cloud ERP.

Environment: Oracle Applications EBS 11i/R12 (AP, AR, GL, FA, PO, INV, OM, AOL), Oracle Database 11g, Forms Developer 10g, Reports Builder 10g, XML/BI Publisher, Discoverer Administrator/Plus 10g, Workflow Builder, PL/SQL, SQL*Plus, SQL Loader, TOAD, Noetix, VSS, Kintana

Confidential

Sr. Oracle Apps Manufacturing Techno-Functional Consultant

Responsibilities:

• Involved in trouble shooting issues and helped development team in bug fixing.
• Followed a strict change management process involving, user tickets assignment, problem analysis, development and bug fixes, unit testing, User acceptance testing support and deployment.
• Documented the required trouble shooting issues maintained at all stages.
• Raising Service Requests (SRs) and working with oracle support for identifying issues, escalating Service Requests and finding resolutions.
• Extensively worked on Multi Organization structure, MRC (Multiple Reporting Currencies), MOAC (Multi Org Access Control), TCA(Trading Community Architecture) and RBAC (Role Based Access Control).
• Imported Legacy Journals data into GL using Journal import interface.
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Listing Report, Payment Register, Supplier Register, etc.,
• Created various AOL object including and not limited to Concurrent Programs, Executables, Request sets, Custom Menus, Forms, Functions, Responsibilities, Value sets, Lookups, Flex fields, Request Groups, etc.,
• Created UNIX shell scripts to automate interface programs on daily basis. Designed and developed multiple file handling system in UNIX.
• Worked on developing custom RMA API to update the order returns in OM module
• Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
• Worked on developing a custom interface for Pick Release, to pick release the orders
• Worked on building a new custom API to check the on-hand availability for a given sub-inventory and warehouse.

Environment: Apps R12.1.3 (GL, AP, AR, OM, INV, PO, Advanced Pricing, Payments, SCM), Oracle Database 10g, Reports 10g, Forms 10g, EDI, Windows XP Professional, PL/SQL, TOAD, HP Quality Center, XML Publisher, Workflow Builder.

Confidential, North Wales, PA

Oracle Apps Manufacturing Technical consultant

Responsibilities:

• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Using SQL*Loader loaded the data into staging table, Developed PL/SQL packages to validate the data and load into interface tables.
• Developed conversion program for validating and importing Open AR ( Account Receivable) 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 Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Worked on fixing the special characters issue for international customers in the EDI Ecommerce invoices
• Worked with OE ORDER PUB API to debug the stuck orders in Order Import
• Built customized packing slip report and designed templates for English, Dutch and French languages.
• Customized Create requisition form as per the requirement using CUSTOM.pll
• Built Triggers on HZ tables to transmit customer and party information whenever there are any changes to CRM (Customers online) on different instance
• Developed Customer License Form to save the Customer’s License information.
• Involved in implementing Inventory, BOM, MRP, and Order Management in Multi-Org set up including designing, testing and maintaining interfaces from legacy system.

Environment: Oracle Apps EBS R12(12.0.6)( AP, GL, PO, AR, iSupplier, iProcurement, OM, INV, iExpenses, AOL), Oracle Database 10g, SQL, PL/SQL, TOAD, Discoverer Administrator/Desktop 10g, XML Publisher, SQL*Developer, Forms 10g, Reports 10g, UNIX, Shell Scripting, WINDOWS XP.

Confidential, Newport Beach, CA

Oracle Apps Manufacturing Technical Consultant

Responsibilities:

• This project was an upgrade project which involved the upgradation of Oracle Applications 11.5.8 to Oracle Application R12.
• Customized the components, upgraded shell scripts, which calls reports, control files and SQL files which are in the production.
• Setup Custom Modifiers to derive discounted price for few business requirements.
• Worked on the staging R12 Apps environment to convert suppliers and Open Invoices from 11i to R12.
• Prepared technical design documentation and Unit test plan documents for XML Reports, Conversions and few Extensions.
• Developed the templates for several reports using XML publisher.
• Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.
• Designed & developed the custom interface program to create and update an item in Item Hub with database validations.
• Developed Crystal reports to generate 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.

Environment: Oracle Apps EBS Release 11i (11.5. .0.4/12.0.6 )(AP, PO, INV, OM, AR, Shipping, Advanced Pricing, CM, SCM), XML Gateway, EDI Gateway, SQL, PL-SQL, Oracle 10g, Forms & Reports, Putty, Workflow, UNIX.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Responsible for Design, Development and support of Rebate processing project and support.
• Designed and developed custom forms to enter the customer operations and Medicaid rebates as the client’s requirements.
• Designed and developed custom forms to enter product, location, contacts ad partner master data as per the end user requirement.
• Worked on Order Import in Order Management (OM), Purchase Order conversions for PO.
• Developed stored procedures to populate the interface tables in the process of importing customer’s information into AR and Purchase Order information into PO.
• Registered Concurrent program executable, defined concurrent programs attached to request groups and attaching request groups to responsibilities.
• Developed shell scripts to load data from staging tables into the interface tables and call the concurrent programs to populate the base tables as part of the conversion.
• Customized several standard and custom reports in AP, PO, OM and GL.
• Enabled descriptive flex fields to store additional custom information to develop the complex reports based upon several different custom applications as well as oracle applications.
• Prepared Technical Design Documents (MD70) for all the objects developed.

Environment: Oracle E-Business Suite 11.5.10.2(AP, AR, GL, OM, PO), Oracle Forms/Reports 6i, XML Publisher, Oracle Workflow Builder, TOAD.