SUMMARY

• 8+ 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 serverUNI 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.
• Designed and developed Fixed Assets Conversion by running Mass Additions Concurrent Program to transfer the data from interface to base tables in Fixed Assets (FA).
• Involved in the User Acceptance testing and Post Production support.
• 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, ASHBURN, VA

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, Philadelphia, PA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• The project involved the implementation of data conversions in various modules like AP, AR, GL and PO. Customization of various RICEW objects in oracle apps R12.
• Worked on different tools like JDeveloper, XML/BI Publisher and Discoverer to generate the reports.
• Developed Sales Order Report, Purchase order report, Purchase Order Arrival using XML Publisher.
• Performed Technical analysis for R12 Implementation.
• Involved in developing Implementation standards for standard Discrete Manufacturing (ODM).
• Creatednew OAFpages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data throughEO(Entity Objects).
• Created customized folders/views in OAF for requested to users based on pickup status.
• Developed, implemented and unit tested AP Invoice interfaces. This involved importing data from the legacy system into staging tables using SQL Loader, validating the data using a PL / SQL procedure, inserting data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
• Developed Profitability Report in PA (Project Accounting).
• Data was converged using standard functionality (Data Loader) to import On Hand balances with Inter-organization transfers, Discrete Jobs and beginning balances in Projects.
• Implemented Trading Community Architecture (TCA) to support complex trading communities and relationships within a trading community using PL/SQL APIs.
• Performed internal costing, revenue accrual, and billing for any type of burdened costs that company applies to raw cost.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Developed multiple custom enhancements in P2P implementation.
• Created new concurrent request sets and scheduled the Order Import interface program to run periodically.
• Used standard Order import to load the open orders from the interface tables to the standard OM tables.
• Designed and developed an Inbound Interface between web based Order management systems to Order Management for Sales Orders import.
• Worked on enhancements to custom ship confirmation process that that takes ship confirmations from the vendor’s warehouse management system and load them into the interface tables so that the data can be populated into OM modules.
• Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
• Developed custom forms to maintain custom tables in P2P process.
• Customized AP invoice form using form personalization. Customizations include adding menus, Hiding fields and changing prompts.

Environment: Oracle Applications R12 (AP, AR, OM, GL, PO), TOAD, PL/SQL, SQL*LOADER Reports 10g, forms 10g, XML Publisher, UNIX shell scripting.

Confidential, Springfield, IL

Oracle Applications Technical Consultant

Responsibilities:

• Involved and responsible in development of Self Service Audit Extract Toolkit to automate the auditing process the client. The Audit toolkit is driven by a package and a set of procedures, functions.
• Developed Audit Toolkit Process Selection Form where the user can select the audit extract/s they have to run when required.
• Developed Supplier Automation Inbound Interface which gets the temporary supplier information.
• Configured Concurrent Executable, Concurrent Programs, Custom Flex fields, Custom Lookups, Request Sets, Request Groups, Functions, Menus, Sub-Menus and Custom Responsibilities.
• Developed Custom Trial Balance Report by GL accounts, Journal Source and Journal Categories.
• Created reports for generating sales invoices.
• Developed BAM dashboard reports for GL, AP, AR and PO
• Developed Audit extraction SQLs involving GL, AP, AR and PO modules.
• Developed Custom API to invoke the API to load the external data into the corresponding tables at the end of every month.
• Designed & Developed AP Invoice Open Interface and AP Invoice Audit Report for the different Sources in Oracle Payables.
• Developed outbound interfaces to export data to Mainframes, Hyperion, and other custom applications using PL/SQL.
• Involved in Handling CR’s (Change Requests) for various Audit tasks.
• Involved in creating the UAT scripts.
• Responsible for fixing various UAT bugs.
• Divided various functional areas of the application into various Risk Levels for effective testing of the application, also risk leveled all the test cases accordingly.
• Created user defined functions and used library functions for easier maintenance of script.

Environment: Oracle Applications Release 11.5.10.2 (AP, GL, AR, PO, FA) Oracle 10g, SQL, PL/SQLForms 10g, SQL * Loader, and TOAD.

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.