SUMMARY

• 8 years of extensive work experience in Oracle Applications E - Business Suite 11i (11.5.9 and 11.5.10) and R12 (12.0.4, 12.1.1 and 12.1.3) as Techno Functional Consultant.
• Expertise in translating functional specifications into technical specifications for development of Oracle Applications R12 extensions, modifications and integrations including system interfaces, reports, data conversions and custom extensions.
• Responsible for understand and analyze the provided RICEW Component specifications and develop solutions by using Developer 2000, PL/SQL Developer, XML Publisher, OA Framework(OAF), Unix shell scripting and Workflow Builder.
• Expertise in Oracle Reports, XML Reports, Workflow Development, Oracle Applications Framework(OAF), Oracle Forms Development, Forms Personalization, SQL Loader, PL/SQL Procedures, PL/SQL Functions, PL/SQL Packages, Database Triggers, UTL FILE Programs, SQL*Plus Reports, Database Objects, Shell scripts and Data Loaders.
• Expertise in requirements gathering, gap analysis, user trainings and user acceptance testing.
• Hands on experience in preparation of AIM documentations like MD50, MD70, CV40, CV60, TE20, TE40 and MD120.
• Strong knowledge on Oracle AOL concepts like Multi-Org, System and User Profiles, Executable, Concurrent Programs, Request Groups, Responsibility, Flex fields(DFF and KFF), Lookups, Menus, Functions, Value Sets, WHO Columns, Oracle Alerts and Messages.
• Extensively worked on the Oracle Applications modules below:
• Have full life cycle implementation experience and enhancement experience on Procure to Pay (P2P) and Order to Cash (O2C) business processes with good analytical skills necessary to satisfy development, testing, documentation, and change management requirements.
• Multiple project experience includes implementation, upgrade, customization, migration, and support projects.
• Worked with different teams like Business Users (SME), Functional, UNIX Server and DBA team.
• Good experience in program debugging, issue resolutions and providing effective business solutions.
• Excellent communication and interpersonal skills to handle the client meetings and solution discussions.

TECHNICAL SKILLS

Operating System: MSDOS, UNIX, Linux, Windows 2003/XP/ Windows Vista/Window 7

Languages: SQL, PL/SQL, C, Unix Shell Scripting, RDBMS

GUI: Developer 2000 (Oracle Forms 6i/9i/10g, Reports 6i/9i/10g)

RDBMS: ORACLE 8i/9i/10g

ERP: Oracle Applications 11i & R12

Modules: Application Object Library, Oracle Payables, Oracle Receivables, Oracle General LedgerOracle Cash Management, Oracle Purchasing, Oracle Inventory, Oracle AlertsOracle Order Management, Oracle Configurator, System Administrator

Tools: & Utilities: TOAD, SQL *Plus, SQL*Loader, UTL FILE, Oracle Workflow Builder 2.6, Forms PersonalizationOracle XML Publisher, Shell Scripting, JDeveloper 10g, Remedy, Maestro, Discoverer

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Oracle EBS Consultant

Responsibilities:

• Prepared the knowledge documents, presentations for play back sessions, given the knowledge sharing sessions for offshore team.
• Create Data Loaders to load the setup data like Receivable Activities, Receipt Methods, Lookups, Receipt Classes, and User Responsibilities.
• Developed Dunning Letter Extract Program to send the Dunning Letters to delinquent customers.
• Developed Statement of Account (SOA) program to send the SOA file from Oracle to other systems.
• Performed required Oracle Setups for user testing in System Administrations, Receivables and Collections modules.
• Create SR’s and Work with Confidential for Corrupt Invoice and Corrupt Receipt data fixes.
• Worked on development of Auto Lock Box Process to load the payment and remittance file into Oracle.
• Create or Modify the Territory Management Rules according to the requirements.
• Create or Modify Users, Add Responsibilities, Create Employees, Add Supervisors, Import and Maintain Resources, Add approval limits, Create Collectors.
• Worked on Confidential Transfer File Program.
• Developed Sales Work Item Extracts.

Environment: Oracle Applications 12.1.3(Accounts Receivables, Advanced Collections, General Ledger, System Administration, Territory Management), Oracle Database 10g, SQL*Plus, SQL Developer, WinSCP, Team Forge, Quality Centre, Putty and SQL*Loader.

Confidential

Oracle EBS Technical Lead

Responsibilities:

• Responsible for requirements gathering, develop the solutions, getting sign-off from the users for the solutions.
• Responsible for migrated of custom objects from 11i version to R12.
• Involved in testing the application in various levels like Unit testing, Integration testing, Regression testing Sanity testing and Performance testing before moving to UAT.
• Have good understanding of the Functional, Business Domain Architecture and Design of the applications.
• Migrated Oracle Payables Invoices data from 11. .1.1 of oracle applications.
• Migrated Oracle Receivables Receipts data from 11. .1.1 of oracle applications. The data is imported into oracle receivables using Receipts Applications Programming Interface (API) Program.
• Developed Journals Migration Program to migrate the journals into R12 GL module. The journals are inserted into the GL Interface table and then ran the Journal Import Program to load the data into GL base tables.
• Developed Standard Purchase Order Import Program in PO module.
• Developed XML Report to show the receivables transactions based on distribution accounts in AR Module.
• Developed XML based Sales Order Acknowledgement Report in OM module.
• Developed XML based CEVA Adjustment Register Report in AR Module.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Developed custom AR Receipts Register Page, Open AR Transactions Page, AR Receipt Balances Page, AP Paid Invoices Page using OAF.
• Implemented Forms Personalization as per the business requirements.

Environment: Oracle Applications 12.1.1(GL, AR, AP, PO, OM), Form Builder 10g, Report Builder 10g, Oracle Database 10g, SQL*Plus, PL/SQL Developer, JDeveloper(OAF), Toad, WinSCP, Filezilla, Remedy, Putty, SQL*Loader.

Confidential

Oracle EBS Developer

Responsibilities:

• Developed the Open AR Customer’s Data Outbound Interface Program using UTL FILE utility to transfer data from oracle receivables to a legacy system called Get Paid.
• Developed Open AR Transactions Data Outbound Interface using UTL FILE utility to transfer data from oracle receivables to a legacy system called Get Paid.
• Developed Open AR Receipts Data Outbound Interface Program using UTL FILE utility to transfer data from oracle receivables to a legacy system called Get Paid.
• Designed and developed AR Invoices Import Program to transfer the legacy system transactions into Oracle.
• Designed and developed GL Inbound Interface Program to transfer the journals data from ADP System to Oracle GL base tables using Journal Import Program. The data has been received as flat file and loaded into oracle using SQL*Loader.
• Created and registered the Custom AR Daily Collection Register Report as concurrent program using the AOL module objects like Executable, Concurrent Program, Request Group and Responsibility.
• Registered the custom Collection Summary Report as concurrent program using the AOL module objects like Executable, Concurrent Program, Request Group and Responsibility.
• Developed AR Revenue Stamp Worksheet Report using XML Publisher Administrator so that the business users can get the report output directly in excel format.
• Developing minor/major enhancements and bug-fixings as per the requirements provided by user.
• Wrote stored procedures and triggers in PL/SQL.
• Extensively used AOL and System Administrator modules for Creation of various Concurrent programs, Request sets, Value-sets and Descriptive flex fields, request groups for reports and concurrent requests.
• Development of PL/SQL programs, procedures, functions, and packages. Designed and Developed Supplier Conversion program.
• Designed and developed customized Lockbox Program, lockbox input data file has been validated prior to processing the input file using Auto Lockbox program.
• Setup Descriptive Flex Fields, Value sets for the developed interface to store information as per business requirements in AP and AR modules.
• To help with finding root cause for the issues and primarily be working to help streamline the current issues with the upstream system (EBS + Custom Applications).

Environment: Oracle Applications 12.0.4(GL, AR, AP), Form Builder 9i, Report Builder 9i, Oracle Database 9i, SQL*Plus

Confidential

Oracle EBS Technical Lead

Responsibilities:

• Designed and developed number of different accounts extract program to transfer the account details.
• Using Report builder prepared the report of AP batch vendor analysis and registered that as concurrent program and the user can submit the same from SRS window.
• Worked on Journal balances and Journal Transactions extract programs to extract the data of journal balances from Oracle and transferred to legacy systems using UTL File utility.
• CANDG Journals data has been imported into oracle using the standard GL Inbound Interface process using the loader program and journal import program.
• Designed the outbound extracts by mapping the front end Oracle Application fields with the back end tables and then provided the extract as a file.
• Customized AP Invoice Approval Custom Workflow.
• Resolved number of production issues on oracle applications modules.
• Actively involved in the meetings for requirement gatherings and solution discussions.
• Worked with Confidential for SR’s resolution related to the standard oracle functionality issues.

Environment: Oracle Applications 11.5.10.2(GL, AR, AP), Form Builder 10g, Report Builder 9i, Oracle Database 9i, SQL*Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL*Loader

Confidential

Oracle EBS Developer

Responsibilities:

• Developed AP Statement of Account Report in payables module to get the credit and debit details for a given supplier.
• Actively involved in the user trainings and user reviews.
• Worked on Billing Workbench Report that shows the AR Invoices created from the Billing Solution.
• Prepared the Agreements Report that shows the agreement details between Confidential -NJME and their customers. This report will be scheduled daily and sent the output of the report to mails.
• Involved in the designing of Entitlement Setup Report, Transaction Summary Report, Requisition Summary Report and Uniform Returns Report which is used by the business users for reporting.
• Developed GL Average Balance Report in GL Module which shows the average balances for the given account segment values.
• Created the SQL*Plus method report to show the supplier outstanding details and moved the file into the server SQL path and then registered the same as concurrent program in application.
• Customized Supplier Payments Summary Report in payables module.
• Customized Invoice Details Report in oracle payables in order to change the fields according to business requirement.
• Imported the daily rates from exchange system (BO) into general ledger daily rates base tables.
• Worked on Incentive Invoices Import Interface to load the incentives paid to the employees from legacy to oracle applications payables.
• Developed Custom Forms based on the user requirement.
• Developed Entitlement Setup Custom Workflow and Uniform Requisitions Approval Workflow.
• Worked on Custom XML Publisher Reports design and development.

Environment: Oracle Applications 11.5.9(PO, AP, AR, GL), Form Builder, Report Builder 6i, Oracle Database 6i, SQL*Plus, PL/SQL Developer, Toad, WinSCP, Putty, SQL*Loader