SUMMARY

• Over 8 years of consulting experience in Oracle Applications, focused on Requirement gathering, analyzing, designing, implementing, testing and post implementation support.
• Extensive experience in Oracle Applications (11i / R12) E - Business Suite Modules in Financial (GL, AP, AR, FA, CM), Oracle Manufacturing & Distribution (PO, TCA, OM, QP, INV, WSH, BOM, WIP, WMS), SCM, HRMS.
• In depth knowledge and understanding of Oracle Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports
• Expert in developing programs using SQL*loader, Toad and PL/SQL procedures to transfer data from legacy systems with knowledge in Unix Shell Scripting.
• Experience in manufacturing modules like Work in progress (WIP) and Bills of Management (BOM).
• Good Experience in Oracle Financials and supply chain modules like GL(General Ledger), AP(Accounts Payable), AR(Accounts Receivable), FA(Fixed Asset), CM(Cash Management), PO(Purchase Order), OM(Order Management), INV(Inventory), Install Base, Service Contracts, iExpenses, iProcurement, isupplier and AOL(Application Object Library).
• Extensive Knowledge in writing Packages, Procedures, Functions, Triggers and API’s using SQL, PL/SQL, UTL file, TOAD.
• Expertise in creating inbound and outbound interfaces, creation of automated processes using Application Program Interfaces (API).
• Extensive experience in writing conversion scripts for migrating legacy data into Oracle Applications using Oracle Open Interface and Oracle API’s.
• Developed Open Purchase Orders report using XML.
• Good experience in managing, tracking and reporting the execution of the deliverables. Has performed these activities multiple times for Global large scale implementations.
• Experience in interacting with onsite clients while being responsible for deliverables and ability to work with limited resources.
• Extensive experience in customization of workflows and in fine-tuning code for better performance.
• Good communication, collaboration & team building skills with proficiency in grasping new concepts quickly and utilize the productive manner.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite R12, 11i

Databases: Oracle 11i/10g/9i/8i, MS-Access, Sybase, SQL server 2008

Oracle Apps Modules: Fixed Assets (FA), Cash Management (CE), Bill Of Materials (BOM), General Ledger (GL), iProcurement, iSupplier, and iStore, Order Management (OM), Purchasing (PO), Project Accounting (PA), Receivables (AR), Payables (AP), AOL, Trading Community Architecture (TCA), Inventory (INV), Pricing (QP) and Shipping (WSH).

Operating Systems: Windows 98/2000/NT/XP/07/08, UNIX and LINUX.

Languages: SQL, PL/SQL, C, C++, HTML and Java.

GUI: Discoverer10g/9i/4i,Oracle Forms 6i/9i/10g, Workflow Builder 2.5/2.6, AME, EDI, XML Gateway, Noetix, ADI, Reports 6i/9i/10g and XML Publisher 2.5.

Tools: XML Publisher, Load Runner, Toad, SQL *Loader, PL/SQL Developer, Discoverer and Data Loader.

PROFESSIONAL EXPERIENCE

Confidential - Waltham, MA

Sr. Oracle Techno Functional Consultant

Responsibilities:

• Analyzing the requirements, preparing data collection templates for PTO models.
• Preparing Structure, Rules and User Interfaces for the models in Oracle Configurator.
• Testing the models to ensure the models are as per data collection templates
• Designed and developed the Models as a Configurator Builder to meet the client’s requirements shared modeler’s responsibility as a part of modeling work and prepared many documents, which would minimize the build defects at the initial phase. Example Macro which would find the duplicates matrix uniqueness for a given model & Build Process for QP & CC Models.
• Project exposure in iStore-Configurator Integration and implementing Multicurrency Pricelists for iStore.
• Good experience in iStore UI Customizations (Shell Scripts, XML Publisher).
• Project experience in iStore Technical Schema (PLSQL/Java API’S, Stored Procedures).
• Extensive experience in Configure-to-Order Implementation which includes Setups (parameters, Profiles etc.), Creating and process the configurations, Order changes and returns, Updating existing configurations and Purging data.
• Extensive experience in configurator architecture which includes tables in CZ SCHEMA, Populating CZ SCHEMA, Migrating, Data, Synchronizing Data, CZ SCHEMA Maintenance, Integration, API's involved in Configurator development.
• Extensive experience in BOM model design and SQL queries used in configurator.
• Involved in Building a Configuration Model Using the Fusion Configurator Engine.
• Helped the ITEM LOAD Team for creating Bills & assignment for the items in the BOM. I was part of maintenance Team delivered simple, complex & very complex Models.
• Key resource in handling the maintenance requests on deliverables in Production after GO-LIVE.
• Worked extensively on XML Publisher. Developed .RTF files for xml reports.
• Work experience in creating LOV based field using Personalization in OA Framework.
• Worked extensively in customizing the workflows and developed workflows from scratch using workflow builder 2.6.
• Developed conversions and interfaces in AR and AP modules. These conversions extract data from the legacy system and importing the extracted data to Oracle R12 base tables using Open Interface import program.

Environment: Oracle Applications 11i, R12, PL/SQL, SQL*Plus, TOAD, SQL Developer, OA Framework, Windows XP, SQL * Loader, Reports 10g, forms 10g and workflow builder 2.6

Confidential - Boston, MA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Used flex fields and provided techno-functional support for oracle R12/11i-order management.
• Developed PL/SQL Packages, Procedures and Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated the base tables.
• Used Application Object Library (AOL) components to Register Reports and Concurrent Programs.
• Created PL/SQL stored procedures, functions and packages for moving and working with the data from staging area.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Configured the Cash management module for GL Accounts Mapping, setting up transaction codes, file upload, Customization of out file as per Confidential requirements, automatic transmission and import of bank files.
• Upgraded ERP systems like OPM.
• Developed Interfaces for Oracle Applications modules, XML Publisher, Oracle Discoverer, OA Frame work etc in co-ordination with the functional consultants.
• Extensively used bulk collection in PL/SQL objects for improving the performance.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Imported Bills and Routings through BOM Interfaces.
• Developed custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report etc.
• Implemented Daily Conversion Rates Interface in General Ledger (GL).
• Worked on customization of several standard reports in Purchasing (PO) using Oracle Reports builder such as, printed Open Purchase Order Report and Purchase Requisition Status Report.
• Developed custom Oracle Reports in GL / AP and AR modules.
• Performed Customization of Purchase History Report in PO.
• Provided day-to-day Production support for Oracle Discoverer.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the Journal import interface in Oracle General Ledger (GL).
• Performed Auto lockbox interface program to load customer’s payments information into receivables (AR) base tables by using SQL*loader and auto lockbox interface program.
• Developed Work Order Interface to import discrete job information into oracle apps base tables.

Environment: Oracle Applications 11i, XML Publisher, Oracle10g, Accounts Receivables (AR), Cash Management (CM), Account Payables (AP), General Ledger (GL), Order Management (OM), I Expenses, AOL, Purchasing (PO), Reports 6i, SQL*Loader, PL/SQL, UNIX, Toad 9.0.1.8, Windows XP, forms 6i, Workflow, Discoverer 10g.

Confidential - Huntersville, NC

Associate Technical Consultant

Responsibilities:

• Interacted with Information Technology Directors, Managers, Full time employees, off shore team and key Business Users to gather requirements and capture present business process flows to communicate solutions.
• Designed Staging Tables, Conversion Routines, and Custom PL/SQL API for conversion of Items.
• Provided customized reports and processes to support ongoing systems, including changes to FA, GL, and HR modules.
• Developed PL/SQL Packages, Procedures, Functions for validating the journals (for accrual and payment information) in the staging table and importing them into Oracle Application using the GL Open Interface and populated the base tables, which involved in creation of multiple journal entries for each type (accrual and payment) and journal import.
• Developed PL/SQL Scripts/Packages for Payables Invoice Import, AR Auto-Invoices Interface.
• Extensively utilized the Application Object Library (AOL) to register SQL*Loader programs, PL/SQL 0packages and procedures, forms and reports.
• Worked on inventory to create the items from legacy systems into Oracle EBS.
• Worked on conversions for Items, Item Categories, and templates in Inventory.
• Worked on setups for Items Templates, Categories, Unit Of measure, organizations, Locations in Inventory.
• Worked on Procure to Pay Cycle and Order to Cash Cycle.
• Developed programs for creating new items and update new items using Items Interface.
• Worked on extracting the xml file using a shell script and Packages to load the data into staging tables.
• Worked on some of the new customized reports.
• Created PL/SQL packages to perform validations on the imported data from legacy system.
• Participated in performance tuning using Explain Plan and TKProf.
• Developed new reports and customized seeded oracle reports Using BI Publisher Report.
• Tuning of customized application including reports and back end programs by using different application tuning techniques.

Environment: Oracle applications EBS 11i (11.5.10), R12, PL/SQL, SQL*Plus, TOAD, Developer 2000(Reports 6i/10g and Forms 6i/10g), Oracle Designer 6i/10g, SQL Developer, XML Publisher, BI Publisher, SQL*Loader and Windows XP.

Confidential

Business Technology Analyst

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Wrote automated Unix Shell Scripts to process the files on daily & quarterly basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Created PL/SQL stored procedures, functions and packages for moving and working with the data from staging area.
• Extensively used bulk collection in PL/SQL objects for improving the performance.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Successfully tested and implemented the product “Navigator”, which is used with internal BoA clients, in 80% of the speculated timeframe.
• Oversaw quality assurance, verification and validation, and reliability estimation of the project.
• Worked on automation of applications for functional testing using IBM Rational Functional Tester tool.
• Suggested and implemented a new internal project, which automated and streamlined the monitoring of millions of data records produced in a daily, monthly and quarterly basis and generated respective reports.
• Developed programs and scripts that increased efficiency by 80% by reducing the errors and discrepancies across systems.

Environment: Oracle applications EBS 11i, Forms 10g, Reports 10g, SQL and PL/SQL.