SUMMARY

• 9+ years of IT experience in design, development and maintenance of Oracle E - Business Applications as a Techno-Functional consultant with expertise in General Ledger (GL), Account Payable (AP), Account Receivable (AR), Fixed Assets (FA), Cash Management (CM), Purchasing (PO), Order Management (OM), Inventory (INV), Shipping (WSH), Discrete Manufacturing (ODM), Process Manufacturing (OPM),Warehouse Management(WMS),Advanced Pricing (QP), I-Procurement and AOL objects.
• Extensive Experience in 11i & R12 implementation and roll-out of SCM modules like PO, INV and OM.
• Hands on experience in 11i & R12 implementation and roll-out of financial modules like GL, AP, AR and FA.
• Experience in Software Development Life Cycle including Analysis, Design, Development, Implementation, Testing and Post Production Support using Oracle Applications R12 (12.1.3), 11i (11.5.9,11.5.10.2).
• Good Experience in business flows like Procure to Pay, Order to Cash and Drop Ship Cycles.
• Good Knowledge in Oracle Application Framework (OAF).
• Good knowledge in I-Store, I-Expenses, Ebtax and TCA modules.
• Extensively Worked on AIM documents like MD050, MD070 and MD120
• Good Experience in RICEFW Components like Reports, Interfaces, Conversions, Extensions, Forms and Workflow as per client requirements.
• Hands-on experience in Customization and Implementation of Oracle Reports 6i/9i/10g, Forms 6i/9i/10g.
• Experience in development & customization of XML/BI Publisher and Discoverer Reports.
• Extensive experience with XML/BI Publisher, Oracle 9i Discoverer, JDeveloper, Developer, Form builder, Report Builder, Workflow Builder, Kintana, VSS, PuTTY, Toad, SQL Developer, SQL* Loader, SQL and PL/ SQL programming on Windows and UNIX with Oracle database.
• Successfully completed three end-to-end Oracle Applications implementations.
• Expertise in using Oracle 8i/9i/10g and 11g databases and Proficient in PL/SQL programming using Stored Procedures/Packages, Database Triggers, Cursor variables, Ref. Cursors, PL/SQL Collections like Nested Tables and Varrays, Records, Exceptions, Exception Handling, Conditional Control Statements, Loop Statements and Dynamic SQL.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Supplier Invoice Interface and Customer Invoice Interface
• Strong knowledge on Purchase Order Approval Matrix
• Experience in Post Production support and on call support for business critical show stoppers.
• Have a good working experience with Service Desk where we track all the tickets.
• Good working experience in JAVA, HTML and Adobe Flex.
• Efficient in creating dimension hierarchies and a level-based measures for various business models.
• Effective communication skills (verbal and written) for both highly technical and non-technical audiences.
• Highly motivated, energetic individual and a very good team player willing to work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Good Technical Ability in understanding a project and the steps followed in completing the project.

TECHNICAL SKILLS

Oracle Apps Versions: R12 & 11i

Oracle Apps Modules: GL, AP, AR, FA, CM, PO, OM, INV, BOM, WIP, I-Procurement, I-Store, Ebtax, SCM,APPLICATION DEVELOPER,SYSTEM ADMINISTRATION

Oracle Apps Business Cycles: P2P, O2C and Drop Ship Cycles

Apps Technical: Oracle Forms (6i/9i/10g), Oracle Reports (6i/9i/10g), Oracle Workflow Builder, XML/BI Publisher, JDeveloper, VSS, PuTTY, SQL, PL/SQL, UNIX, Shell Scripting, XML, HTML, C and JAVA

Environment: Windows 98/XP/ 2000/2003/2007 server, UNI Linux, MS-DOS

Databases: ORACLE 8i/9i/10g/11g and MS Access

Database Tools: Toad, SQL*PLUS, SQL*LOADER, SQL Developer

Other Technologies: Adobe Flex Development, Mat Lab, Net Logo, 8085/8051 Programming and Kiel Microvision2

PROFESSIONAL EXPERIENCE

Confidential, Grafton, WI

Oracle Applications Techno-Functional Consultant

Responsibilities:

• The project is an implementation and production support of Oracle Apps R12. Involved in developing conversion programs, building custom reports, Form personalization’s and writing UNIX shell scripts based on business requirements.
• Analyze business and functional specification documents and design use cases documents and prepare technical specification documents.
• Provide production support for Financial Modules (AR,AP,OM,GL) with constant interaction with the end users
• Create and used stored procedures, packages, cursors and functions to do the validations on the legacy data. Created indexes to enhance the performance of the applications.
• Developed and Customized Oracle Reports in (OM, AR,GL,FA,PO,INV,WIP&BOM).
• Involved in SLA Package Customizations to fix Create accounting errors and working with users to perform month end close activities.
• Create and customize various Views as per the requirements like Snapshot, Items received but not delivered etc.
• Prepare detailed Technical specifications for new/modified extensions, reports and conversions.
• Design and develop interface programs to extract orders from custom web application objects, populate to staging table, validate the data in staging table and send to interface tables.
• Attend design reviews, project status meetings, walk-through and inspections for functional specifications.
• Designed and developed custom packages and SFTP Scripts for bank payment files.
• Develop interface programs to integrate Legacy System with the AR module to import customer information using the Customer Interface.
• Work on in various customization using Workflow, Custom.pll, Form Personalization
• Configured Concurrent Executables, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus, And Custom Responsibilities.
• FND LOAD utility to migrate concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.

Environment: Oracle Apps Financials EBS R12 modules (AP, AR, GL, FA, CM, PO, OM, INV, IB,Service Contracts, WIP, & BOM), SQL, PL/SQL, Oracle Reports 6i/10g, Forms 6i/10g, BI/XML Publisher, and UNIX).

Confidential, Pittsburgh, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• The project is an implementation of Oracle Apps R12. Involved in developing conversion programs, interfaces, building custom reports and writing UNIX shell scripts based on the functional specifications provided.
• Prepared design documents (MD.050), technical documents (MD.070), unit test script documents (TE.020) and Installation documents (MD.120) for all the customizations.
• Developed various RICEW components in modules like OM, INV, WIP, BOM, WMS, GL and PO.
• Designed and developed custom shipping reports like Packing slip, Bill of lading, Pick ticket and Batch Pick Ticket using XML/BI Publisher.
• Developed Custom forms to track Additional shipping information for processing EDI856 files.
• Customized Labels like Shipping Address, GHSHIS, Product, and Warning.
• Customized Shipping Transaction, Purchase Order and WIP Move transaction forms using Form personalization. Customizations include adding menus, Hiding fields and changing prompts.
• Created custom views for BI publisher health checks as per business requirements.
• Provided post go-live support and involved in user training sessions.
• Documented all the work done for future reference and also created various reference manuals for functional testers and users.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, PO, OM, WIP, INV, BOM), Oracle 10g, ToadPL/SQL, Forms10g, Reports 10g, JDeveloper 10g, Discoverer 10g, TOAD and UNIX.

Confidential

Oracle Applications Techno-Functional Consultant

Responsibilities:

• The project is an implementation of Oracle Apps R12. Involved in developing conversion programs, interfaces, Custom OAF pages, building custom reports and writing UNIX shell scripts based on the functional specifications provided.
• Prepared design documents (CF.250), technical documents (MD.200) and Installation documents (MD.120) for all the customizations.
• Developed various RICEW components in modules like OM, INV, WIP, BOM, AR, GL and PO.
• Designed and Developed OAF pages in WIP Labor vouchering process.
• Developed pages like Resource Workbench and Supervisor Workbench.
• Designed and developed OAF pages for the Custom One Step Shipping Process and Custom BOL Solution.
• Created new concurrent request sets and scheduled the Order Import interface program to run periodically.
• Developed custom reports using Report 10g and also customized seeded reports.
• Developed Operational Dashboards for business to view current health of the organizations.
• Developed various custom reports Pick Slip Report, Bill Of Lading (BOL) using Report builder.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Provided post go-live support and involved in user training sessions.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, PO, OM, WIP, INV, BOM), Oracle 10g, SQLPL/SQL, Forms10g, Reports 10g, JDeveloper 10g, Discoverer 10g, TOAD and UNIX.

Confidential, New York City, NY

Oracle Applications Techno-Functional Consultant

Responsibilities:

• The project involved in implementing and developing various RICEW components for financial, supply chain management, Order management, inventory, purchasing in R12.
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder and Application Object Library (AOL).
• Prepared design documents (MD.050), technical documents (MD.070) and Installation documents (MD.120) for all the customizations.
• Created and used stored procedures, packages, cursors and functions to do the validations on the legacy data, Created indexes to enhance the performance of the application.
• Extensively worked on GL, AR and OM Interface and conversions.
• Created Concurrent Program for calculating ITD balances in GL module.
• Worked on conversion of journal entries from old set of books to new set of books.
• Created Staging tables to load the records and uploaded the flat files using SQL*Loader.
• Configured Concurrent Executable, Concurrent Programs, Request Sets, Request Groups, Functions, Menus, Sub-Menus, And Custom Responsibilities.
• Customized the Journal Entries Report in AR, which is used to review the details that make up the general ledger journal entries.
• Created and customized Reports in (OM).
• Customized the existing forms as per the client requirement.
• Registered the PL/SQL scripts using Concurrent Programs and attached the programs to Request Sets.
• Created and customized Reports in AP, AR, FA and Credit & Collections & GL using Reports 10g.
• Created UNIX shell scripts to automate the process of loading the external data.
• Used FND LOAD utility to migrate responsibility, request sets, concurrent programs, value sets, Concurrent Managers, Context-Sensitive DFF, Profile Options, Form Personalization’s etc.
• Develops cash application procedures and training documentation.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, PO, OM), Oracle 10g, SQL, PL/SQLForms 10g, Reports 10g, JDeveloper 10g, Discoverer 10g, TOAD.

Confidential

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Customized forms to make changes related to R12 for MOAC changes and tables changes.
• Developed Custom Order Entry screen for user convenience and developed an interface to import these sales orders into OM.
• Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycles.
• Redeveloped various custom RICE components for R12 upgrade.
• Involved in Requirement Analysis, Design and Develop custom applications inOAF. This involves analyzingMD.050(Functional Spec) and then writingMD.070(Technical Spec).
• Development of new OAF pages and embedded the same to Oracle Apps instances to cater to the business needs.
• Involved in developing custom XML/BI Publisher reports like Open Sales Orders Summary, Purchase Order Summary.
• Worked on the technical design and implementation of custom CFS OM Blood Pricing application and the design of the eProgesa (Third party System) to CFS (Oracle e-Business Suite) interface.
• Involved in AP Check Printing Setups.
• Customized Order Management Header and Line workflows to meet business requirements.
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom.
• Developed Shipping Report to show data from Install Base and Service Contracts data using Discoverer.
• Involved in creating Discoverer reports to generate Purchase Order reports.
• Worked on different interfaces like importing AR invoices from one of third party legacy system which validates and submits a standard interface program.
• Developed custom AR INTERFACE program which validates and modifies data in the interface tables. This program is designed to update Sales order based data in AR interface tables. Validations and changes based on different custom tables and forms.
• Experienced in project costing including Load project costs from sub ledger and Capture costs in a timely manner.
• Implemented Work in Process for Discrete manufacturing (ODM) that interfaced with MES software.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table.
• Designed and developed a program to convert Bill Rate Schedules of Project Accounting.
• Developed the programs for to convert projects, tasks, budgets, Agreement and funding, event and cost as a part of Project Accounting.
• Involved in setting up punch out stores in I-Procurement.
• Developed and customized various custom reports like PO Requisition Details Report, Open PO Report by Buyer, Open Receipts Report and PO Unsourced Requisitions Report in Reports 10g builder.

Environment: Oracle Applications R12.1.3 (OM, AR, AP, PO, GL, TCA), Oracle 10g, SQL, PL/SQLForms 10g, Reports 10g, JDeveloper 10g, Discoverer 10g.

Confidential

Oracle Applications Technical Consultant

Responsibilities:

• This is implementation project which includes various modules like AP, AR, PO, GL, OM and INV.
• My role included developing conversions for modules PO and AP and several reports and other enhancements.
• Developed an extract script for the uninvoiced receipts data from legacy system.
• Worked on AP Invoices Conversion to convert the paid invoices data.
• Designed and developed Staging tables, Conversion routines and Custom PL/SQL API’s for Customer Import, Order Import, Open AP Invoices and Item Import.
• Designed, Documented and Developed an Interface between third party billing system to General Ledger, to post the journal every week from the billing system. Where I developed an UNIX shell script, which calls SQL Loader program to load data into custom staging tables and checks for uniqueness of the files in UNIX directory to avoid duplicate data and to archive the same.
• Worked on Discoverer Administrator, Desktop, Plus and Viewer as part of the development of the above reports.
• Created new business areas, custom views, new folders, custom folders, complex folders, conditions, materialized views and joins in discoverer according to user requirements.
• Worked with Oracle Workflow Builder to develop new processes and customized the existing workflow process.

Environment: Oracle Applications 11.5.10.2 (AR, AP, GL, OM, PO, INV, BOM, WIP), Reports 6i, Forms 6iDiscoverer, Toad, SQL Loader, XML Publisher, PL/SQL Developer, SQL*Plus, TOAD, Workflow Builder.