SUMMARY

• 8+ Years of experience as Oracle Apps Functional consultant in AP, AR, GL, OM, INV,OTC, PO, ALERTS, AOL expertise in developing RICE components in Financial Modules (CM,AP,AR,FA and GL) and Distribution Modules (INV, OM, PO).
• Worked on Oracle EBS R12.
• Worked in Oracle Front - end programming like Forms Personalization and Back-end development using tools like SQL*Loader, PL/SQL, SQL*Plus, Oracle Forms, Oracle report Oracle Discoverer 4i/10g, BI/XML Publisher.
• Involved in Design, development, implementation, testing and documentation of business applications.
• Experience and good knowledge on Workflow customizations.
• Expertise in writing Functions, Procedures, Packages and Database Triggers using PL/SQL.
• Good Knowledge in Trading Community Architecture (TCA) APIs to import data from legacy systems to Oracle Systems.
• Financial knowledge in oracle financialmodules (AP, GL, AR and FA).
• Expertise in maintenance of tables, indexes, views and optimizing queries.
• Experience with developing reports in Discoverer and XML Publisher.
• Knowledge in AME (Oracle Approval Management).
• Extensive experience in Application Development using Forms 6i and Reports 6i in UNIX and Windows environment.
• Worked on P2P (PROCURE- TO -PAY) and OTC (ORDER- TO- CASH) process.
• Designed user interfaces with Forms.
• Knowledge in AIM (Application Implementation Methodology).
• Worked in manufacturing modules (BOM, WIP, QA and Pricing).
• Extensively used QUEST Tools (TOAD, Navigator), SQL*PLUS, SQL * Loader, PL/SQL developer & utilities such as UTL FILE.
• Experience in registering a component to concurrent program.
• Knowledge on OTL.
• Knowledge on Oracle CRM.
• Developed and supported custom Invoice Interface betweenOTC and legacy system.
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL and SQL*Loader.
• Experience with migrating and managing code changes, maintaining versions of code using Code version control tools like SVN etc.
• Worked on Integration.
• Involved in designing Functional Documents, Technical Documents, and AIM documents like MD050 and MD070, BR100 documents.
• Worked on upgrades, experience in INV, OM, WIP and BOM.
• Expertise in new system implementations, new module implementations, upgrades, Customizations and extensions, interfaces, data conversion and troubleshooting.
• Experience with Performance Tuning for Oracle RDBMS.
• Expertise in Shell Scripting and debugging.
• Strong interpersonal skills, quick learner, ability to interact with people at all level.
• Ability to work with teams and close interactions with end-users.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, HTML, XML, JavaScript

Development Tool: Oracle Form Builder 10g/9i/6i, Oracle Report Builder 10g/9i/6i, SQL*Plus, SQL *Loader, PLSQL Developer, Toad, Workflow Builder

ERP Packages: Oracle E Business Suite Release R12

Operating System: UNIX, Linux, DOS, Windows NT/XP/2007, Sun Solaris

Oracle Applications Modules: Inventory (INV), Purchasing (PO), Service Contract, Order Management (OM), Accounts Payables (AP), Accounts Receivables (AR),OTC, Fixed Assets (FA), General Ledger (GL)

Technology Modules: Oracle Alert, AOL, Workflow and SYSADMIN

Tools: TOAD, Oracle Enterprise Manager, Oracle SQL Developer, Putty, Eclipse, WinSCP, Clear Quest, SQL Loader, SVN (version control), MS Office

Scripting Languages: Perl, UNIX shell script

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Oracle Apps Technical consultant

Responsibilities:

• Coordinated on shore and off shore teams on regular basis for the project.
• Involved in discussions with cross functional teams in designing and development of Interface between systems.
• Involved in preparation of package for UAT and providing UAT support.
• Worked on Integration for AP, OM, AR, GL, PO and INV modules.
• Involved in requirement gathering, design and development and testing of System.
• Preparing functional and technical document.
• Worked on workflow customization to stop updating base tables when supplier is registered and created new work flow for approval hierarchy.
• POS supplier approval management (POSSPAPP) and POS supplier registration and profile management (POSSPM1) workflows are modified.
• Used Desktop Integrator (WEB ADI) to import excels data to lookup's table
• Done the Personalization and customization for supplier in I Supplier.
• Worked on Outbound Interface for Customers, Tax Exemptions and Tax Zones.
• Created the Descriptive Flex fields (DFFs) in AP, AR, INV, BOM and PO for capturing the item.
• Customized the XML publisher Template for Sales Order Acknowledgement Report.
• Written the SQL Loader Concurrent program for the various purposes.
• Worked on P2P Process and OTC process.
• Modified purchase order workflow to implement approvals using AME
• Worked on Sales Order Acknowledgement Report.
• Worked on various forms personalization requirements in OM and PO.
• Worked on MD-50 and MD-70 documentation.
• Providing key ideas on monthly bases, which would help in reducing the recurrence of issues and enhance business process.
• Knowledge sharing and presentation new team members.
• Assure Quality of Code is maintained by following the Standards of Coding.
• Understand all kinds of issues/enhancement and make sure of the service assurance within the mentioned SLA.
• Managing and coordinating with other teams to carry out day-to-day work, handle critical situations to maintain business continuity.
• Provided User training at various company locations.

Environment: Oracle Applications 11i (GL, AP, AR, OM, PO, Inventory), Oracle Workflow, OTC, Oracle Reports Builder 6i, Oracle Forms Builder 6i, Oracle database 9i/10g, SQL Loader, TOAD, UNIX, putty, FTP GUI Client, UNIX.

Confidential, Tampa, FL

Oracle Techno functional Consultant

Responsibilities:

• Prepared Functional and Technical design documentation based on user requirements.
• Worked on Order-to-Cash (OTC) process.
• Responsible to conduct and participate in status meeting to gather requirements from business Users.
• Worked in Service Contract module.
• Designed and developed a notification engine and workflow engine using PL/SQL for the Progress of each transaction and notify corresponding person for each step.
• Developed reports from scratch and also customized standard oracle reports according to Business requirements, using Oracle Reports Builder.
• Worked as team member for designing the data migration plan from the legacy system to Oracle Applications, and coordinated with the other developers for preparing test plansReconciliation reports and detailed design.
• Developed and supported custom Invoice Interface betweenOTC and legacy system.
• Worked in Project accounting and project billing module.
• Developed Customized PL/SQL Packages, Procedures and Triggers to accommodate the Changes to the Existing Manufacturing / Financial Business Application as per client Requirements.
• Worked in service contract module
• As techno functional consultant, responsible for Communicating to the end users, Requirements Analysis, designing Specifications, Coding, Testing, QA and support the Customizations and application extension.
• Worked on OTC process and developed functional documents(MD050)
• Involved in design of AIM (Application Implementation Methodology) document MD070.
• Worked extensively on TCA Customer Conversion in loading the new Customer details from Legacy System to Oracle AR Tables.
• Worked in INV,WIP (Work in Progress), BOM (Bill of Materials).
• Worked with Material handling devices to define, assign, initiate them
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context using forms personalization.
• Experienced in using the performance tuning methods like TKPROF, Explain plan, Trace and Creating Indexes.
• Involved in developing/migrating existing/new reports in Oracle Apps.
• Worked in Data Conversions between Legacy systems and Oracle Applications in the areas of
• Inventory, Order Management, Bill of Material.
• Involved in post-production support and enhancements of RICE objects in all phases of the Project.
• Created generic procedures which can be used by various applications for debug, email Notifications, work flow process using lookup tables
• Designed various interactive reports and reports to keep track of requests in various stages
• Create custom authorization schemes for various regions, items and buttons.
• Enhanced the existing Oracle ERP (R12) components by reviewing the existing work flow and made enhancements to the work flow. Analyzed the reporting needs in the GL and HRMS and developed reports using Oracle Discoverer and BI publisher.

Environment: Oracle E-Business Suite 11i/R12, Oracle 10g, Oracle Forms 6i/10g and Reports 6i/10g, BI publisher, SQL * Plus, OTC,TOAD, XML, SQL Loader, PL/SQL, Quality Center, Putty, Win SCP, Windows.

Confidential, Boston, MA

Oracle Apps Functional consultant

Responsibilities:

• Configured and built the database objects, packages, stored procedures, and functions and extensively worked on exception handling for the business scenarios for the huge implementation of tracking the Product and Sales information for the client.
• Developed the conversion programs by creating packages, reconciliation programs, staging programs, scripts for Item, Item costs for data conversion from one entity to another entity.
• Developed PL/SQL programs using TCA API's to validate and import customers from legacy system into base tables.
• Involved in understanding the Google System Architecture of Oracle Apps connected with Legacy Systems.
• Extensively used FNDLOAD utility to Download Concurrent Programs, Responsibilities, Lookups, Flex fields, Value sets, Request Sets, Request Groups, Menus, Forms Personalization, Profile Options, Printer styles into ltd files and written a shell script to upload them to another instance.
• Registered Customized reports in AOL and System Administration.
• Created and registered new concurrent programs as well as executables when new reports were created.
• Worked on MD050 document.
• Involved in development of custom reports and forms for AP, AR, GL, OM, CM and INV modules.
• Worked on CRM (Customer Relationship Management).
• Worked for Procure- to -Pay Process (P2P) and Order- to- Cash (OTC) Processes and module integrations with AR, AP, OM, GL, INV and PO and within EBS System.
• As a techno functional consultant, responsible for Communicating with the end users, Requirements analysis, Design (MD070) (MD050), Coding, Testing, QA and support of the Customizations and application extension.
• Developed plug-in payrollformulas which calculate the custom requirement logic and re-used as the formula in SQL scripts and Discoverer reports.
• Getting the functional inputs from the users and worked on the technical enhancements.
• Extensively worked on Cursors, PL/SQL Tables on TOAD in the interface development and used exceptions wherever necessary to improve the performance.
• Worked on FTP in the UNIX environment to import and export the data files and place the scripts in the appropriate locations so that they could be executed with Shell scripts.

Environment: Oracle Applications R12/11I, OM, PO, BOM and INV, UNIX, SQL*Plus, PL/SQL, TOAD, Reports 10g, Forms10g, OTC,XML/BI Publisher, SQL*Loader.

Confidential

Oracle Apps Techno functional consultant

Responsibilities:

• Performed the Test Plans for various scenarios and Execution of the same.
• Designed, created and maintained the Discoverer End User Layer.
• Developed several Oracle Discoverer workbooks using Discoverer Admin, Discoverer Desktop and Discoverer Viewer.
• Developed reports using Oracle BI Discoverer, Reports Builder 6i.
• Designed and developed custom forms using Template.fmb.
• Involved in end user training and support.
• Designed and Developed Forms 6i and Reports 6i by using Forms Builder and Reports Builder.
• Developed a PL/SQL script to automatically e-mail the report output run in oracle applications to the desired users.
• Developed various crucial financial analysis reports (for all modules) using Oracle Discoverer.
• Used FNDLOAD to move concurrent programs, menus, and forms personalization between instances.
• Customized standard PO Approval workflow as per the requirement.

Environment: Oracle Applications 11.5.10.2, Oracle 9i, Forms 6i, Reports 6i, SQL*Loader, Discoverer 4i, UNIX.