SUMMARY

• 7+ Years of Oracle Applications experience - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, interfaces, user training.
• Developed functional and technical specifications (MD.050, MD.070, MD.120) as well as test plans and test scenarios using AIM methodology.
• Strong expertise in implementing Order-to-Cash and Procure-to-Pay Business Process flows.
• Over 7 years of experience in Implementation and RICE Customization of Oracle Applications 11.5.9/11.5.10 and Release 12 modules such as OM, INV, AP, AR, GL, PO.
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations.
• Experience in database programming using Oracle 8i/9i/10g/12g databases.
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle JDeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i
• Work experience with XML Publisher, BI Publisher, Workflow Customizations
• Experience in developing UNIX Shell scripts for loading data into staging tables
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc
• Expert in Oracle Application Framework (OAF) applications,customization ofOAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Expert inrequirement gathering, design and development ofcustom applicationsinOracle Applications Framework(OAF)environment.
• Worked on Oracle Applications AIM methodology for process of implementation and documented as per BR100
• Worked on Oracle Applications AIM methodology for process of implementation and documented as per MD050 and BR100
• Excellent communication skills, adapt in client interaction and understanding business applications.
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support.

TECHNICAL SKILLS

ERP Applications: Oracle EBS (12.1.3) /11i (11.5.8, 11.5.9, 11.5.10)

Modules: Financials -- (GL, AP, AR, FA), Supply Chain -- (INV, PO, OM), Manufacturing -- (BOM, WIP), CRM, ASCP, iProcurement, iExpenses, Service Contracts, TeleService, iSupport.

Methodology: Application Implementation Methodology (AIM)

Languages/Frameworks: SQL, PL/SQL, Java, JSP, OAF, ADF, HTML, XML, C, C++

GUI/Tools: JDeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i, SQL*Loader, SQL*Plus, SQL Developer, Toad, VSS, PVCS, Forms Personalization, Workflow Builder

Databases: Oracle 12g/11g/10g/9i/8i, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9iUtilities IE 5.0/5.5, Netscape 4.7/6.0, Mozilla, Putty, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Oracle EBS Technical Consultant

Responsibilities:

• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement
• Develop PL/SQL program that extracts and generate a flat file with the information from Ariba. Automate the data load process from Ariba by scheduling PL/SQL packaged procedure as a concurrent program
• Develop Account Analysis report that shows current A/R balance, credit limit and past 12 months transaction history for the customer(s) defined in TCA. This report is being used by credit department in order to analyze the customer history and approve for higher credit limits
• Resolved issues in embedded workflow of Order flow in OM module and had the modified workflow re-deployed in the instance
• Worked on Oracle Application Framework (OAF) to develop custom solutions foriExpenseandiProcurementmodule. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked onrounding customizationsof dollar amount in iExpense usingOAF.This involves customizing and extending controllerCO andentity objectEO.
• Worked on customPassword resetapplication on timeout issue inOA framework.
• Customized Workflow Order routing process and Notification process based on the approval Hierarchies to notify the stake holders
• Requisition approval process and order routing process validation logic has been customized using the custom functions at activity nodes on the standard workflow processes
• Created and customized reports using XML Publisher in OM, AR, AP and INV
• Extensive Experience in OM API's like order creation, order updates and advanced pricing
• Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module
• 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
• Develop 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
• Create and define template and data definitions for Open Purchase Order report. Conditionally display company logo information based on run time parameters
• Developed Sales by Customer Ship-To Location report that shows the sales information with corresponding order number, invoice number, Item number, and PO and customer ship-to location
• Customized PO Approval workflow process using Workflow Builder and define processes based on the purchasing amount and ship to location
• Trouble shoot issues with run time performance of the reports and use lexical parameters and bind variables wherever required to improve the performance
• Involved in setting up users and defining resources for AR and assign roles as per the requirements using CRM Administrator responsibility.

Environment: Oracle Applications 12.1.3, Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder, SQL*Loader, DB2 and UNIX. Modules: Financials (AP, AR, GL), OM, PO ; XML Publisher, SQL, PL-SQL, Forms 6i, Reports 6i, Workflow, Putty, Winscp 3, FTP, Windows XP and UNIX

Confidential, Richardson, TX

Oracle EBS Consultant

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Worked with SQL Loader and PL-SQL Built in packages to convert VAX data into Oracle Applications as necessary.
• Prepared Module Design technical documentation MD070.
• Developed the BOM conversion code to convert the data from VAX to oracle system and registered as a Concurrent Program.
• Designed and developed custom program to load EDI 850 inbound Orders into Order Management.
• Involved in the Personalization of the custom international budget form so as to fit the US requirements.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Came up with the custom code to customize the Outbound EDI 856, 810 documents to add the extra fields as per the business requirements.
• Developed the Contact Conversion code to convert the contact data from legacy system to oracle system and registered as a Concurrent Program.
• Customized the Order entry form as per the requirements so as to display the Allowance details.
• Worked on creating the pricelists based on the customer requirement.
• Worked on creation of Contact Allowance maintenance form and handled the contact allowance conversion to convert the allowance information for each contact from the legacy system
• Coordinated with the offshore team to get the requests done.
• Daily Development Interaction with Technical leads for status and any other outstanding issues.

Environment: Oracle Applications 11.5.10.2, Oracle 11.1.0.7.0 , PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, PVCS, Kintana, DB2, Sybase and UNIX. Modules: SCM (PO, INV, OM), Financials (AP, AR, GL), XML Publisher Administrator, iSupplier, Application Developer, OM and PA; SQL, PL-SQL, Forms 6i, Reports 6i, Putty, Winscp 3, FTP, Windows XP and UNIX.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• This project was an Order management roll out for EMEA countries
• Work closely with Oracle ESS Team (functional team) to gather user requirements
• Created custom Invoice Work Bench (XXAP APXINWKB) form from scratch using template.fmb
• Demonstrated and wrote program logic for custom Invoice Routing and Approval form to work in conjunction with 'Invoice Validation' program
• Resolve database dead lock issues with Invoice Validation program and Invoice Routing and Approval form
• Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module
• Define and set up DFF's using Application Developer responsibility for Purchase Order Header to identify Contract Retention Invoices
• Wrote PL/SQL packaged procedure to be scheduled as concurrent program to identify and place payment holds for 'Contract Retention' invoices
• Provide custom menu using Forms Personalization for Invoice Routing Approval form to provide users to query and view invoice images stored in Document.
• Created an Oracle Alert to send an alert whenever Custom Invoice Metadata Update program runs for more than two hours
• Involved in Planning and implementing data conversion methodology and programs using PL/SQL to receive invoices from Brainware to Oracle
• Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General Ledger Consolidation purposes
• Create HP-PPM package, add database objects to be deployed/migrated from one instance to another. Responsible for AP-PPM package migration from development to production
• Create Change request (CRQ) using Remedy to deploy the tested successfully changes from UAT to production. Document and attach necessary information for Remedy CRQ

Environment: Oracle Applications 11.5.10.2, Oracle 10g, PL/SQL, SQL, Forms, Reports, PVCS, SQL*Loader, HP-PPM, Remedy, BugNet, Clarify, Cool Compliance, Oracle, IBM Maximo and UNIX.

Confidential, Waukesha, WI

Oracle Techno Functional Consultant

Responsibilities:

• As a Techno Functional consultant responsible for creating multiple conversions to support client's migration from a legacy system to Oracle ERP suite of applications including WIP, BOM, Purchasing, Inventory, and Order Management
• Imported Bills and Routings through BOM Interfaces
• Developed Work Order Interface to import discrete job information into oracle apps base tables
• Created MD50, BR 100 documents
• Created Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables
• Created and customized reports using XML Publisher/BI Publisher in OM, BOM, PO, AP, AR, WIP and INV
• Customizing & enhancements on Forms
• Converted Oracle 6i Reports and SCM reports to BI publisher reports
• Extensively used CRM API's for upload the service request information from AFA (Legacy System) to oracle apps ERP
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests

Environment: Oracle Apps Implementation Release (12.0.3), Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX. Modules: SCM (PO, INV, OM), Manufacturing (WIP, BOM),CRM (Teleservice,Service Request), SQL, PL-SQL, Forms 10g, Reports 10g, Putty, Winscp 3, FTP, Windows XP and UNIX.

Confidential, Boston, MA

Oracle Analyst

Responsibilities:

• Supported a pharmaceuticals client in developing database triggers for their custom requirements.
• Critical process design and validations in Order to Cash cycle.
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i.
• Developed custom reports as per client requirement in OPM Forecasting module.
• Extensively used SRW packages in Oracle Reports.
• Created Discoverer Reports for GL, AP, AR, ASCP and OPM modules using Discoverer Administrator and Desktop Edition. Created Custom Folders, Business Areas, and Workbooks. Assigned Privileges and registered the reports in Oracle Applications. Customized the Workbooks by adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling them for the users.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX. Modules: Financials (AP, AR, GL), OPM, ASCP SQL, PL-SQL, Forms 6i, Reports 6i, Putty, Winscp 3, FTP, Windows XP and UNIX.

Confidential, Atlanta, GA

Oracle Consultant

Responsibilities:

• Getting the functional inputs from the users and worked on the technical enhancements
• Analyzed business requirements, designed, implemented business solution design and development
• Created and customized reports using XML Publisher in OM, AR, AP and INV
• Prepared the Technical Design documents, Installation documents and Unit Test Case documents
• To send notifications to users by using oracle work flow builder
• Customized Workflows as per the client requirements
• Worked with Discoverer so users would have the ability to generate ad-hoc reports
• Experience includes application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands
• Creation of Value sets in various Modules of the application

Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX. SCM (PO, INV, OM), Manufacturing (WIP, BOM), Financials (AP, AR, GL, FA); SQL, PL-SQL, Forms 6I, Reports 6i, XML Publisher, Putty, Winscp 3, FTP, Windows XP and UNIX.

Confidential

Technical Consultant

Responsibilities:

• Upgrade of 11i Custom objects from Release 11i (11.0.3) to 11.5.10.2 in all modules
• Developed Sales order conversion using standard API
• Developed Purchase order conversion using standard interface
• Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface. Created SQL*Loader control programs and validation procedures to execute along with Customer Interface (AR)
• When an item is created in inventory, workflow needs to be launched and it should collect the details of the item created and sends a notification to group of users along with the details and link to master item form
• 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
• Developed Warehouse Rules and Production Batches interfaces in OPM
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL FILE package at periodic intervals
• Involved in Custom.pll and Form personalization
• Tuned the reports to improve performance
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes

Environment: Oracle Apps Implementation Release (11.5.10.2), Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, CVS, SQL*Loader, DB2 and UNIX. Modules: SCM (PO, INV, OM), Financials (AP, AR, GL, FA), OPM; SQL, PL-SQL, Forms 6I, Reports 6i, XML Publisher, Putty, Winscp 3, FTP, Windows XP and UNIX.