SUMMARY

• Work Experience with more than 7 years in Oracle Applications E - Business Suite Functional Analyst and Developer in Design, development and implementation of Oracle Applications.
• Worked as functional analyst in Supply Chain Management (Inventory, Purchasing, iprocurement, isupplier, Sourcing, Order Management, Advance pricing (PO, INV, OM,QP)) and Financial Modules (Account Payables, Account Receivables and General Ledger (AP, AR and GL)).
• Carried out number of Full Cycle implementations and various other projects in different versions of Oracle Applications 11i and R12.
• Good experience in AIM methodology for implementing Oracle Applications. Familiar with all the Standard Documents (MD 50, MD 70, MD 120, CV 40, CV 60)
• Good knowledge in Trading Community Architecture (TCA) and Multi organization Access control (MOAC) architecture.
• Good knowledge in Procure To Pay(P2P) and Order To Cash(O2C) cycles.
• Experience in the customization by extension and modification of the standard application suite using Application Object Library (AOL) on features like concurrent programs, request sets, value sets, and profiles and implemented key Oracle Application features like folder form, KFF, DFF.
• Proficient in design, developing Data conversion Programs, validation programs, oracle alerts, customizing forms, reports and workflows.
• Developed and customized RICEW components like Reports, Interfaces, Conversions, Extensions and Workflows.
• Extensive experience in Requirements gathering, Analysis and understanding of AS IS and TO BE models, Documentation and High Level Design. Experience in preparing Functional requirement Document and Test cases.
• Good understanding of data flow in the different modules of Oracle Applications. Involved in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
• Experienced in Reports development and Customization using XML Publisher.
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs).
• Extensively worked on Data Conversion, Migrations and Interface Programs.
• Experienced with Production Support for both Onsite-Offshore project model.
• Proven characteristics of being highly motivated. Strong problem-solving skills and analytical skills. Self-Starter and ability to work independently without any supervision.

TECHNICAL SKILLS

ERP Applications: Oracle Applications R12/11i including Payables (AP), Receivables (AR), General Ledger (GL), Order Management (OM), Purchasing (PO),Inventory (INV),Shipping(WSH),Sub Ledger Accounting, iExpenses, iProcurement, Service Contracts, Adv Pricing and others.

Programming Languages: SQL, PL/SQL, UNIX, HTML, XML, C and Java Scripts.

Database: Oracle 9i/10g/11g.

Tools: TOAD,SQL*Developer, SQL*Loader, FND LOAD,SQL*PLUS, Forms & Reports 10g/6i, Oracle Discoverer10g, XML Publisher, Workflow Builder, ADI & EDI Gateway.

Operating System: Windows, UNIX, SUN SOLARIS, LINUX.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in Requirement gathering, Analysis and Client interaction. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Developed interfaces for purchasing documents to import those as part of migration of inventory org into current system, including identification of business important fields in document, design and coding.
• Developed Packages, Procedures and Functions to validate data in the staging tables and insert into base tables using open interfaces or API’s.
• Worked on Order to Cash (O2C) life cycle and supported Order Management, Inventory, Shipping Execution and PO modules.
• Involved in Implementation of Procure to Pay (P2P) cycle which includes Items and Categories, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Worked on developing the Sales Order Conversion to load orders from legacy system into OM (Order Management).
• Designed and developed Sales Order extract and Customer extract programs as per the client requirements
• Conversions: Developed Item Import Conversion program using Import Item Open Interface. Using this program, we created Master items and assign those items to child Organizations along with Item category assignments.
• Developed On hand quantity conversion for items in Inventory using Material Transaction open Interface. Created a conversion program to load UPC data as Item Cross references in Oracle.
• Worked on Order Import Interface Program to import Sales Orders into Oracle systems instead of manually entering them.
• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the data into Oracle Standard interface tables.
• Involved in AutoLock Box Receipt Interface to load data that is received from bank into interface tables from interface table to the Base Interim tables and finally to the base table.
• Developed AP Invoice interface to load data from legacy system to AP interface tables.
• Customized Purchase Order Detail report to list all purchase orders from a particular vendors over a specific period of times
• Customized a report to compare the on-hand quantity cost v/s the physical count cost.
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into purchasing interface tables
• Developed report to show the rejected and returned quantities and the days between the rejected and returned quantities to the vendor.

Environment: Oracle Application 12.1.3 (PO, AP, AR, INV, OM, Adv Pricing) Oracle10g, XML Publisher, Work Flow Builder.

Confidential, Miami, FL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Understanding of Starbucks business model & integration of different Business Units.
• 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 Purchasing, Inventory, Order Management, WIP and BOM.
• Developed Packages, Procedures and Functions to validate data in the staging tables and insert into base tables using open interfaces or API’s.
• Worked on the implementation of Order to Cash (O2C) cycle including Order Entry, Order Booking, Pick Release, Ship Confirm, and Interfacing to Receivables.
• Involved in Importing the Order Management data from legacy system to Order Entry Interface tables using SQL*Loader, validating the data using PL/SQL Script and Creating Orders using Order Import Program.
• Worked on Order Management API's like order creation, order updation and pricing.
• Worked on the interfaces, APIs and data conversions of Order Management and integration with other modules for the upgrade and tested to the client satisfaction.
• Worked on Supplier and Supplier site Conversion program.
• Designed and developed Sales Order extract and Customer extract programs as per the client requirements.
• Enabled the descriptive flex fields (DFF’s) on Sales orders and Invoices to facilitate additional information.
• Developed Customization of Forms and Reports (using XML) as per client requirements.
• Defined Executables and attached executable to the Concurrent program Definition.
• Worked on 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.
• Designed and developed interface to import sales orders from external system based on external demand.
• Developed custom process in PO approval workflow for generation of PDF document and transmitting it to the supplier.
• Wrote QP CUSTOM code for addition of markup value during intercompany shipments.
• Developed report for the flow and markup visibility which shows information from internal requisition to AP and AR invoice.

Environment: Oracle Applications 12.0.6, R12 (INV, OM, PO, AP, AR, GL), Forms 6i, Reports 6i, iSupplier, Account Payables, iProcurement BI (XML) Publisher, Jdeveloper, SQL*Loader, PL/SQL, TOAD, PUTTY, Winscp, UNIX and Linux.

Confidential, Houston, TX

Oracle Apps Techno Functional Consultant.

Responsibilities:

• Involved in upgrading process from 11i to R12.
• Identifying the list of all custom objects those needs to be migrated from 11i to R12.
• Used FND LOAD extensively for downloading LDTs for form personalization migration to TEST, UAT and production environments.
• Re migrated all custom objects (procedures, forms and reports) into R12.
• Involved in post upgradation support by raising various SRs with Oracle and attended OWC sessions explain them the issue and provided 24/7 support to obtain business critical issue resolution.
• Directly communicated with oracle support for bug fixing.
• Identified gap between 11i to R12 for new features MOAC and SLA and incorporated these in R12 Objects.
• Involved in End-End testing after upgrading to R12.
• Supported for the production issues, resolving them on a timely basis based on ticketing system prioritization.
• Prepared the conversion strategy and managed Conversions. Involved in identifying the data sources, mapping the data, design and develop the feeder system using SQL*Loader and PL/SQL and implementing the conversion.
• Worked extensively on PO, AP and Item conversions.
• Created SQL*Loader scripts to load the data from flat file to staging tables.
• Performed Data Validation on Invoice, Payment, Suppliers, Employee Suppliers and Expense Reports data during Conversions.
• Developed Validation Programs for Purchase orders and Payables conversions.
• Worked extensively in testing conversion programs and critical Bug fixes. Involved in Unit Testing and Performance Testing of all conversion programs.
• Worked on various forms and reports customizations.
• Developed custom PL/SQL conversion program for loading Journals using Oracle Standard GL Interface program.
• Developed AR custom credit process where business use a custom form to feed information and integrated with AR interface Process.
• Involved in PO Approval workflow for sending approval notifications to Buyer and approver along with the preparer, using workflow builder.
• Worked on Oracle Order Import API to validate and load the PO information to the interface tables.
• Used UNIX shell scripting for automating various tasks.
• Created Service requests with oracle support and worked towards solving critical issues.

Environment: Oracle Application R12.0.4 GL, PO, AP, AR, Oracle 9i/10g, Reports10g, Forms 10g, XML Publisher, Work flow Builder.

Confidential, Tewksbury, MA

Oracle Apps Techno Functional Consultant.

Responsibilities:

• Gap Document Analysis, Preparing Technical Design Document, Implementation/Upgradation and Testing of the following customizations.
• Upgradation/development of components for Payables Interface, which loads Expense reports data into payables. Employee Expense reports are processed and approved in Metro/Extensity (third party tool), and is interfaced with payables. Data will be populated into AP INVOICES ALL, AP INVOICE DISTRIBUTIONS ALL tables. Analyzed and modified the code to include schema level changes. Development of “view expense report errors” form where user can query & rectify the errors. This form also includes accounting key flexfield implementation. Testing of customization.
• Upgradation of Custom Reports in payables. EMP ADD/BANK Exception report-(list the employees who are vendors and got incomplete address or bank details), Vendor information report (display vendor information), AP extract summary report (display sum of amount by vendor & account).
• Modifications to the following reports customizations of payable module. Modification includes functionality, Schema level changes, and required changes for multi-org.
• Invoice on hold report-This report display Requestor and Approver information of in addition to the other information of an invoice. The requestor, approver information will be captured in attribute columns.
• Supplier Listing Report-This report displays type of supplier (EDI, Auto load, auto match), buyer information, remittance information, in addition to the supplier name, no, and addresses info, which is captured in attribute columns.
• Upgradation of Custom Supplier Entry Screen. This form will not display bank information and Address information when opened from enquiry responsibilities. Account tab modified to have only one account.
• Development of kit Inventory Report. Report should display similar information like indented BOM screen of bill of materials. Report can be submitted for single or multiple kits. This report is being called from a host program, which is registered as a concurrent program. This customization also includes SQL*loader program. Involved in Design, development and testing of all the components.
• Development of kits maintenance form. User can query the kit information and few fields through this form. The form involves business specific validations and front end duplicate checking and developed using TEMPLATE.fmb following apps standard.
• Unit testing of the customization Migrated/Developed and Preparing Unit Test case Documents.
• Development of Corporate Queue screen using TEMPLATE.fmb. This screen is used query all pending subscriptions to approve/reject them. This form involves QUERY-FIND implementation.
• Development of “adjustments-main” form using template.fmb. This form is the starting point for various adjustments. Constructed special menu using APP SPECIAL. User can navigate to different adjustment form from here.

Environment: Oracle Apps 12.0.1 (GL, PO, INV, OM, AP, AR), SQL, PL/SQL, UNIX, Oracle 9i, Forms and Reports 6i, Developer 2000.

Confidential, Snoqualmie WA

Oracle Apps Techno Functional Consultant.

Responsibilities:

• Technical consultant for Finance modules which includes GL, AP & AR
• Also worked in Inventory, Order Management, Quoting and Purchasing.
• Interaction with functional team for requirements and delivery
• Involved in Preparing Templates and scripts required for Data Migration from Legacy system to Oracle Applications as per Oracle On Demand Standards
• Responsible for Finance Data Migration in all the instances including PRODUCTION instance
• Developed custom forms in Order Management Module
• Worked on Customizations using Oracle Apps standard API & Packages
• Unit testing and System testing (with various other systems deployed in the organization) for the applications built and customization performed
• Have built custom components using PL/SQL, required for integration of Oracle Apps with the legacy system.
• Activity involved post-production support of Oracle Applications 11i
• Performance tuning of system processes to remove the bottlenecks for the system
• Created Deliverables like MD120, MD070, TE20 and CEMLI (Oracle On Demand Performance Analysis Document) pertaining to all developments
• Prepared development guidelines document and review checklists
• Mentor of Junior Team Members. Involved in quality process and reporting.
• Project Management - Project Status Notifications, Setting-Up Business Calls & Preparing necessary project documents in accordance with AIM Methodology

Environment: Oracle 11i (11.5.10), Oracle Alerts, Oracle Forms & Reports, Oracle SQL, PL/SQL, TOAD, Data Loader, File Zilla (FTP)

Confidential, Boston

Oracle Applications Developer

Responsibilities:

• Overseeing project implementation and process changes.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Coding for the Interface programs to extract data into flat file and uploading of data files to the media application.
• Fine tuning the SQL Queries to improve the speed of program execution.
• Coordinated with users to ensure that the User Acceptance Testing is done successfully.
• Ensured the programs, scripts, procedures fully tested to ensure bug free performance.
• Performed SQL Performance tuning using Explain plan, Trace utility & TKProf.
• Developed Forms and Reports as per the client requirement.
• Build the business case for a proposed solution to address the customer’s business needs.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Registering Concurrent Program and Forms. Supporting the Issues from various customizations (forms, reports, and interfaces) during the test cycles on priority basis.

Environment: Oracle E-Business Suite 11i (AP, AR, GL), SQL, PL/SQL, Oracle 9i, Oracle Forms 6i & Reports 6i, TOAD, Developer 2000