SUMMARY

• Proficient in all phases of Oracle Applications implementation with major focus in Order Management (OM), Application Object Library (AOL), Accounts Receivable (AR), Accounts payables (AP) and Purchasing (PO).
• Strong Technical and Functional knowledge in Business flows like Order - to-cash and procure-to-pay.
• Good understanding and implementation experience in TCA architecture.
• Good Knowledge of Multi organization Access control (MOAC) architecture and its impact on custom Program development.
• Extensive experience in customizing and developing Reports in Oracle applications using Oracle Report Builder (10g/9i/6i), XML publisher/BI Publisher.
• Expertise in developing and customizing Forms using Oracle Forms Builder (10g/9i/6i) 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 Developer.
• Good Knowledge of Oracle RDBMS concepts.
• Expertise in UNIX Shell Scripting.
• Experienced in Implementation, version upgrade, 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.
• Excellent communication skills, experience in communicating with business users to gather and understand business requirements.

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i (OM, INV, AR, AP, BOM, PO, Shipping)

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, SQL * Loader, SQL*Plus, XML Publisher2.0

Other tools: TOAD, Oracle Export and Import.

Operating Systems: UNIX, Windows Vista/XP/ME/NT 4.0/2000/98 SE/95.

Languages: C, C++, SQL and PL/ SQL, XML.

Database: Oracle 10g/9i.

PROFESSIONAL EXPERIENCE

Confidential, Fort wright, KY

R12 Implementation Project

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

Responsibilities:

• Involved in requirements analysis and design documentation
• Prepared Functional specifications documents (MD 50) for conversions, outbound interfaces, Work flows and reports based on business requirements
• Prepared Technical specification documents (MD 70) for conversions
• Developed Custom program to convert Parties, Accounts and Account Sites in TCA using API approach
• Worked on converting 3 million party records in TCA using Oracle interface approach
• Worked on monthly scheduled inbound interface custom program using API approach
• Worked and supported offshore team on all the 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 and developed custom programs to generate flat files monthly on a scheduled basis
• Supported offshore team for developing 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)

Confidential

R12 Implementation Project

Environment: Oracle Application R12(AP, PO, AR), SQL*Loader, Toad, UNIX, Discoverer, Workflow Builder 2.6.3.5, 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
• Journals - Entry
• AR All Invoice aging report By Date.
• Aging - 4 Bucket Report in AR.
• 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, Dayton, OH

R12 Up gradation Project

Environment: Oracle Apps R12 (AP, AR, OM), Reports Builder 10.1.X, Workflow Builder 2.6.X, Forms Builder 10x, PL/SQL, SQL*Loader, Unix and System Administration.

Responsibilities:

• Active participation in implementation team analyzing the key business process requirements
• Process Order API and Order Import interface used for order conversion, processing the orders using standard actions - Book Order, Apply Holds
• Written custom scripts for Journal Entries Import Interface for GL entries migration
• Worked on Payables Open Interface (AP Invoice Import) for invoice data conversions
• Used Receivables Import Interface, and Auto-Invoice Master Program ensuring seamless integration of OM and Receivables
• Customized standard workflows using Workflow Builder 2.6.x (e.g. OEOL-OM Order line), managed the versions, and connected to the customized transaction types
• Customized OM Order Line workflow (by adding Apply Holds API) and tested it from the front end
• Developed scripts for entering transactions like Regular orders, Inter Company Invoicing, Regular Invoicing, Invoicing Rules and different methods of Receipt Processing and application in OM and AR (Order Management and Accounts Receivable).
• Enhancement and development of new custom reports: ‘Order-Lines Detailed Status Report’
• Customized new forms meeting business needs (e.g. Quick Feasibility Study Form)
• Customized Flex fields to capture sales order specific field, restricted usage to specific operating units
• Worked on mass data loading using SQL*Loader utility, used .dat and csv files, SQL scripts
• Regular status meetings with project team members to manage deliverables and time scopes

Confidential, San Antonio, TX

Enhancement and Maintenance

Environment: Oracle Apps 11.5.10 (OM, AR, AP, EDI, GL, PO, BOM, INV, SCM), Oracle D2k, PL/SQL, TOAD, SQL, Reports 6i, Oracle 10g, Windows NT, Unix.

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and production support.
• Prepared on the Module design Technical documentation MD070 for the changes performed.
• Developed the Item Master conversion code to convert the data from Focus to oracle system and registered as a Concurrent Program.
• Developed a custom Interface to handle the Inbound Purchase Order (850) through EDI, to validate the additional Header and line information.
• Developed the BOM conversion code to convert the data from Focus to oracle system and registered as a Concurrent Program.
• Created custom Shell scripts to call the PL/SQL code that creates the files, FTP and archive the data files.
• Worked on Creating the Monthly AP Extract file and FTPing it to CRS server, so as to fit the client requirement.
• Worked on Creating the Daily AP Extract file and FTPing it to CRS server, so as to fit the client requirement.
• Created a SQL Report to display the list of Vendors on hold and registered as a concurrent Program.
• Worked on Creating a Daily COA Refresh Program to update COA values from another Database on a nightly basis.
• Worked on customizing the Bechtel Custom Report Bechtel Invoice Register Report to add and display the extra fields on the report.
• Worked on form customization by creating shortcuts to get to another form.
• Involved in ad hoc querying and reporting.
• Weekly Development Interaction with Technical lead and Business team for status and any other outstanding issues.

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 8i RDBMS, UNIX, PL/SQL, SQL Plus, Reports 2.5, Forms 4.5

Responsibilities:

• Developed Control scripts and loaded existing data using SQL * Loader.
• Involved in writing PL/SQL Triggers, Procedures, Functions, Packages and performance tuning.
• 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.