SUMMARY

• Strong Technical and Functional knowledge in Order - to-cash and procure-to-pay flows
• Experience in Development, Implementation, and Migration, and Support projects for Oracle SCM (OM, INV, iProc, BOM, WIP, AME, and PO) and Oracle MDM (TCA and Customer Online), and financial modules (AP, AR)
• Good Knowledge of Multi organization Access control ( MOAC ) architecture and its impact on custom Program development.
• Good Knowledge of General Ledger (GL) and Sub Ledger Accounting (SLA).
• Experience in customizing the applications using OAF
• Extensive experience in customizing and developing Reports in Oracle applications using Oracle Report Builder (10g/9i), XML publisher/BI Publisher.
• Experience in the preparation of Functional designs, Technical design and system test scripts for Extensions, Data Conversions/Migrations inbound and outbound interfaces
• Expertise in developing and customizing Forms using Oracle Forms Builder (10g/9i) in Oracle Applications.
• Good knowledge of dependencies and relationships between various application modules with knowledge of interfaces and API’s.
• Proficient in writing PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Well versed in migration of data into corresponding interface tables using a combination of PL/Sql Procedures, SQL Loader or UTL FILE.
• Extensive experience in back end database development using tools SQL*PLUS, TOAD, SQL Navigator.
• Full life cycle O2C implementation going through Development (Dev), Conference room pilot (CRP), User acceptance Testing (UAT) and production, user training, go-live and post go-live support in multi org environment
• Good Knowledge of Oracle RDBMS concepts.
• Expertise in UNIX Shell Scripting.
• Experienced in Implementation, version upgrade (12.1.3 to 12.2.5), support & maintenance projects.
• Ability to learn and adapt to new technologies, good team player in dynamic group work environments and also self motivated to work independently.

TECHNICAL SKILLS

• ERP: Oracle Applications R 12.1.3/12.2.5 (OM, INV, AR, AP, BOM, PO, Shipping)
• Oracle Tools: Forms 10g/9i, Reports 10g/9i, SQL * Loader, SQL*Plus, XML Publisher2.0, J developer 10G
• Other tools: TOAD, Oracle Export and Import.
• Operating Systems: UNIX, Windows Confidential /XP/ME/NT 4.0/2000/98 SE/95.
• Languages: C, SQL and PL/ SQL, XML.
• Database: Oracle 10g/9i, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, Ada, MI

Oracle R12 Techno Functional Consultant

Environment: Oracle Application R12 (INV, PO, AP, OM, AR, AGIS, GL, CM), Toad, UNIX, Workflow Builder, J Developer, ODI

Responsibilities:

• Had opportunity to work for multiple market deployments in Europe, China and Latin America
• Involved in design analysis and process changes for interfaces between EBS to Third party systems
• Involved in Oracle EBS upgradation from 12.1.3 to 12.2.5
• Involved in resolution of functional issues related to Inventory, Purchasing, Order Management, BOM
• Designed Technical documents to EBS inbound interfaces like
• Inventory Item Interface
• For Project and Budgets interface
• Designed CV60 documents for supplier and customer, GL conversions
• Designed MD50 documents for couple of custom extensions
• Designed multiple Technical design documents for different extensions as per client need on OAF pages, Workflows
• Designed Technical documents (MD70) to following Reports
• AP Trial Balance report for secondary ledger
• Confidential Account Analysis Report
• Confidential Credit card outstanding transaction reports
• Developed and involved in multiple conversion activities along using Oracle Data Integrator (ODI) tool in
• Developed multiple interfaces that runs on a daily and hourly basis in
• Involved in designing and extending oracle given hooks on vendor payment method files as per user requirement and generated xml files. Style sheets (.XSL) were used in formatting generated xml files
• Developed custom OAF pages to meet business requirements
• Supplier Unmasked bank details search Page
• AP Invoice Query Workbench
• AR Consolidated Billing Pages
• Extended AGIS Transaction OAF page to capture POET information and few other attributes while creating a transaction
• Developed an Interface that uses SHELL SCRIPTING to identify bank and nonbank statement verification files from specified location in Unix directories received from third party system (Kyriba acts a single source of system to place bank files for all Confidential ’s banking partners) and load the statements in oracle cash management
• Involved in creating WEBADI so users can upload AGIS transactions in bulk as all users do not direct access to the AGIS screens
• Worked on oracle regular expression concepts to read the flat files and dump the data into staging tables
• Developed an extension of PL SQL and workflow process combination to send out email notifications and remainder emails to requisition preparers and their up line if there are holds on AP invoice when there is a mismatch between invoice, purchase order and receipts

Confidential, Cincinnati, OH

Techno Functional consultant

Environment: Oracle Application R12 (OM, AR, TCA, GL), Toad, UNIX, Workflow Builder

Responsibilities:

• Involved in requirements analysis and design documentation and process changes as per the requirements
• Prepared Functional specifications documents for conversions, outbound interfaces, Work flows based on requirements
• Prepared Technical specification documents for conversions
• Developed Custom program to convert customer party, Accounts and Account Sites and uses using both API and interface approach
• Different conversions and inbound interfaces that were developed
• Party\Customer conversion and Inbound interface to TCA
• Open AR conversion
• GL interface as of monthly feed
• Different Outbound interface that were developed:
• AR invoices
• Party\Customer outbound from TCA
• Worked on xml outbound interfaces to send messages to legacy systems on instant basis and periodic schedule basis.
• Our custom Program generates xml messages and places them in Advanced Q
• Worked on XML parsing as part of AR Receipts inbound from 3rd party system to Oracle
• Developed custom work flow in order to send Email notifications to the users by creating ad-hoc roles
• Involved in all the functional setups of TCA
• Good hands on experience in working on Oracle TCA out of the box seeded extensions (EGO Attributes)
• Developed/redesigned reports using XML publisher & Report builder
• Custom reports were developed for Bill Presentment Architecture (BPA)
• “Trial Balance report” in BI publisher as per user requirement
• “Journal Entry Report” in BI publisher as per user requirement
• AP Check Payments for Modifications
• Credit card outstanding transactions Management (Aging) report
• Credit card outstanding transaction Management(Summary) report
• Credit Card outstanding transaction Management(Detail) report
• General ledger custom report

Confidential

Oracle Technical Consultant

Environment: Oracle Application R12(AP, PO, AR), SQL*Loader, Toad, UNIX, Workflow Builder, Report Builder 10g, Form Builder 10g, XML publisher.

Responsibilities:

• Involved in system study, requirements analysis and design documentation.
• Developed Custom program to convert Suppliers and Supplier Sites in AP Module.
• Developed Custom program to convert Invoices in AP Module
• Developed Custom program to convert Purchase Order in PO Module
• Developed reports using XML publisher & Report Builder 10g like:
• Purchase Order for Modifications
• Customization of Distribution set listing Report.
• Payables Accounting Entries Report
• Developed PO and AP Analysis Report
• Worked on Forms Personalization like
• Org Name: -Ability to have org name populated as default.
• Cancelled Requisitions: - How to copy cancelled requisitions.
• Support for maintenance, troubleshooting of R12 environment.

Confidential

Senior Software Engineer

Environment: Oracle11i, Forms6i, Reports 6i, AR, INV, Configurator, OM, Forms6i, Reports6i, PL/SQL

Responsibilities:

• Defined payment terms, locations, periods, tolerances etc. Integrated Payment reconciliation information and Purchase Order information with AP.
• Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications.
• Designed and developed Payables interface import program and interface tables to load invoices from the legacy systems into the oracle payables base tables.
• Designed and developed Conversion scripts to convert data from 11.0.3 to 11.5.9 systems for AR Module. For the Customer related data, Scripts were developed to use the standard Customer Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones, Profiles, Profile Amounts etc.
• Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Customer setup, invoice class, bank accounts, and receipts. System options defined. Setup task included defining the payment terms and transaction types, manual invoice entry (invoice, debit memo, credit memo).
• Also defined auto accounting, rules for Auto invoicing from Order Entry Interface, tax set up and customer definition.
• Worked with Oracle Workflow for purchasing.
• Designed and developed complete Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Involved in the Migration of Payables Custom reports from 11.0.3 to 11.5.9 in Reports 6i.

Confidential

Oracle Developer

Environment: Oracle 11i, UNIX, PL/SQL, SQL Plus, Reports, Forms.

Responsibilities:

• Developed Control scripts and loaded existing data using SQL * Loader.
• Involved in writing PL/SQL Triggers, Procedures, Functions, Packages and performance tuning.
• Creation of database links to connect to the other server and Access the required info.
• Created database triggers to validate complex integrity.
• Created SQL Queries using Toad and scheduling some of the custom Reports.
• Import and export of data for development and unit testing of applications
• Developed and enhanced various Business and ad-hoc Reports.