Rajmohan Dhanapal

Computer Expertise:

• More than 8 years of expertise in the Design, Development, Testing and Implementation of client/server applications in technical and functional architecture of Oracle Applications Release 11i

• Rich experience in Oracle Applications Release 11i modules such as Oracle Order Management (OM), Inventory (INV), Purchasing(PO), Account Payables (AP), Account Receivables (AR), Enterprise Asset Management (EAM), Project Accounting (PA) and AOL

• Very good Skills in gathering business requirements, converting them to functional specifications and also to technical design.

• Strong in Configuration, Customization and Maintenance of Oracle Apps and its Interface with Legacy Systems.

• An enthusiastic and project-oriented team player with warm personality.

• Have good skill with people, quick learner and “Can Do” attitude.

• Excellent communication skills with leadership qualities.

• Currently serve as Vice President of Education for Herbalife Toastmasters club

ERP Expertise:

• 8 years of experience in Oracle Applications in operations area on versions 11i, specializing in Technical and Functional knowledge of Oracle Financials, Manufacturing modules.

• Expertise in Reports, Interfaces, Conversions, Extensions Implementation and Customization of various modules including Oracle Order Management (OM), Inventory (INV), Purchasing (PO), Account Payables (AP), Account Receivables (AR) , Enterprise Asset Management (EAM), Project Accounting (PA)

• Customization, Enhancement of Oracle Applications 11i (11.5.5/7/8/10) Forms and Reports.

• In-depth knowledge of Oracle Applications interface tables and API’s (TCA, OM, AR and Quoting API’s).

• Defining, customization and setup of Flex fields, Oracle Alerts & Oracle Work flow.

• Experience in migration, Conversion, developing interfaces between Oracle Financials, Order management and Manufacturing with legacy systems.

• Successful implementation and customization of Oracle Applications 11i (Ver 5.10/5.9/5.8/5.7).

• In-depth knowledge of Oracle Applications interface tables and API’s.

• Involved in documentation in accordance with AIM Standards (RD50, MD50, MD70 and MD200)

• Worked in Forms, Reports, Shell Scripts, Oracle Alerts, Oracle XML Publisher, Oracle Workflow, Form Personalization and BPEL processes.

• Strong interpersonal skills, ability to interact with people at all levels.

• Experience in dealing with clients, understanding their requirements and also handling a Team.

Technical Skills

Operating Systems: Windows 2000/XP, WinNT4.0, LINUX, HPUnix20, Solaris 5.8

GUI: Developer 2000/6i, VB 6.0

Tools / Utilities: Oracle Reports, Oracle Workflow 2.6, Oracle XML Publisher, BPEL

Database: Oracle 8i/9i

Oracle Application: Oracle 11i (11.5.10/11.5.9/11.5.8/11.5.7)

Oracle ERP Modules: Oracle Order Management (OM), Inventory (INV), Purchasing (PO),

Account Payables (AP), Account Receivables (AR), Enterprise Asset Management (EAM), Project Accounting (PA) and AOL

Work Experience:

Jan 2008 to

Till Now Herbalife International, Torrance,

California Sr. Applications Analyst

Herbalife is one of the largest health and Wellbeing Company with $3.0 Billion revenue, which is based out of Los Angeles with Operations in 75 countries around the world through 2 million distributors.

Herbalife follows Multi Level Marketing (MLM) business model, Direct Marketing which consists of extensive Order Management System helps distributors to have better Information Technology services. Besides Order Management, Herbalife uses Inventory, Purchasing, Account Payables, Account Receivables, Warehouse management modules in Oracle Applications.

Responsibilities:

• Involved in setting up Price list and developed program to handle on going changes.

• Design and Development of Herbalife Advantage Program ( HAP ) Order Management System

• Extensively involved to have successful Distributor Annual Requalification Process

(ARQ) for the years 2009, 2010 and 2011

• Developed automated IVR ( Interactive Voice Response ) system for Order Entry process through telephone services by using BPEL process

• Worked on Oracle Application Letter generation applications to replace the legacy system, HP3000

• Provided solutions for Distributor Management marketing plan changes project includes develop forms and reports customization, concurrent programs

• Greatly involved in Web based Global Order Entry System development and support distributors and the users and also the shipping process.

• Worked on OEOH and OEOL workflows changes to customized the Herbalife business process and accommodate distributor requirements

• Worked on generating reports for various countries through XML Publisher

• Provided full proof interfaces design for the third party system – Inbound interfaces for AR Customers to legacy system using TCA APIs

• Helped distributors and the users for the monthly Royalty programs integration with Oracle Applications and Phoenix system

Environment: Oracle Applications 11i (Ver 5.10), Developer 2000, Windows XP, Linux

Modules: Oracle Order Management (OM), Inventory (INV) and Account Receivables (AR)

June 2007 to

Dec 2007 Arbonne International, Irvine,

California Techno Functional Consultant

Arbonne International is a leading Skin Care and Cosmetics company which follows Direct Marketing business model to help distributors in all levels. The company’s product involves Anti Aging system, Face, Body and Hair Creams.

This was an Implementation Project involved Order Management (OM), Inventory (INV) and Account Receivables (AR) integration with different legacy systems ( MLM, WCS ). Mainly involved in design, development and testing of Interfaces, Conversion Programs and Forms.

Responsibilities:

• Designed and developed Back Order Process to identify, release and cancel Sales Order by using Oracle Forms

• Developed Concurrent Programs to Process Back Orders.

• Provided solution with delete reservations in Oracle Order Management (OM)

• Developed Extract Program to provide flat file Oracle Order details to third party system (WCS)

• Worked on Material Transaction Conversion and Interface programs to merge the lot numbers with Item in Oracle Inventory (INV).

• Provided solution for multiple report templates and output types (PDF, EXCEL, HTML, RTF) using Oracle XML Publisher.

• Worked on cutover tasks like Migration Sheets, code Audit Script, Resource Planning and Scheduling document

Environment: Oracle Applications 11i (Ver 5.10), Developer 2000, Windows XP, Linux

Modules: Oracle Order Management (OM), Inventory (INV), Purchasing (PO) and Account Receivables (AR)

Jan 2007 to

May 2007 City of Chattanooga, Chattanooga,

Tennessee Techno Functional Consultant

Implementation project involved with Inventory, Purchasing and Enterprise Asset Management (EAM) modules. Work experience on Oracle Accelerator to perform functional setting up through the automated tool.

• Developed Project Coding standards document for Interface and Conversion Programs

• Worked on design the Conversion flow for Item Conversion Program

• Worked on develop strategy for Item on hand quantity conversion program

• Developed Test scripts to perform business flow testing in Inventory and Order Management

• Involved to apply Oracle patches in Inventory and EAM

• Import Work Orders from various legacy systems to Oracle Enterprise Asset Management and Oracle Order Management (OM) system.

• Designed and developed purchase order import interface program to import standard purchase order

• Worked on Requisitions Import Interface program to upload purchase requisitions data to Oracle Purchasing

• Developed and Executed test scripts to test the data for Purchase Orders, Requisitions and Item Information.

Environment: Oracle Applications 11i (Ver 5.10), Developer 2000, Windows XP, Linux, Toad, PVCS, Kintana

Modules: Order Management (OM), Inventory (INV), Purchasing (PO) and Enterprise Asset Management (EAM)

May 2006 to

Dec 2006 Diebold Inc, North Canton, Ohio Senior Developer

Diebold, Inc. is a leading ATM manufacturer and offers variety of products like comprehensive security solutions, electronic voting technologies and essential services and support. The company’s businesses include Remote teller system, Express delivery teller assist system, Coin deposit machine, security monitoring, ATM status monitoring and ATM Integrated process. It covers the sectors like financials, security, election, government, retail and pharmacy.

This was an implementation project that integrates Diebold process with Servigistics system which is planning tool. The various programs are automated to fetch the data from Diebold System to Servigistics and upload the data to Oracle system after the planning done. Internal Requisitions (IR), Internal Sales Order (ISO) and Purchase Orders (PO) is created in the Oracle system based on the data file provided by the Servigistics tool.

Responsibilities:

Analysis of system requirements with respective Effort Estimation.

Interface program to extract for Inventory item details, price and currency exchange rates in Oracle Inventory (INV)

Extract program for Open orders information (Requisitions, Purchase orders, Internal Sales orders, Move orders information which are not materialized) and corresponding stock amounts program, which shows the costing information for those open orders in Purchasing (PO) and Order Management (OM).

Extract Program for Stock locations information, which has Sub inventory details based on the business logic.

Import Program from the Servigistics data file, which create Requisitions, Purchase orders in Oracle Purchasing (PO) and order import program in Oracle Order Management (OM).

Worked on Project Import Conversion from various legacy systems in Project Accounting (PA).

Developed Projects repair change status history report, Projects role types report in Project Accounting (PA).

Develop & Review of Technical Design for RICE Components.

Code Review adhering to the Development Standards.

Mentoring new team members.

Coordinate with offshore team and ensure the delivery of the components.

Involved in Component support during various stages of Implementation including QA, SIT and UAT.

Part of Post Production Support for client and resolving business critical issues in minimum time

Environment: Oracle Applications 11i (Ver 5.10/5.9), Developer 2000, Windows XP, Linux, Toad, PVCS, Kintana

Modules: Order Management (OM), Inventory (INV), Purchasing (PO) and Project Accounting (PA)

Feb 2005 to Apr 2006 GE Energy, Atlanta, GA and Florence, Italy Application Developer

GE Energy offers services in support of a wide range of power generating and transmission and distribution equipment. Also it does maintenance services to sophisticated technology upgrades to end-to-end outage services and keeps equipment operating reliably and efficiently.It works in all areas of the energy industry including coal, oil, natural gas and nuclear energy, as well as with renewable resources such as water and wind energy.

This project involved implemention of various manufacturing modules.We have developed interface programs to upload the data from legacy systems,Customized the existing form in Oracle Apps,Developed new forms in Enterprise Asset Management (EAM) and automated processes in Project Manafacturing (PJM) by using Oracle Workflow.

Responsibilities:

Customized Workflows in various modules like PA, EAM and PO.

Customized forms by using CUSTOM.pll in modules like EAM and PO.

Workflow Customization for Project Manufacturing (PJM) with update contract and update budget.

Developed new form for Multi-level Asset Explosion in EAM (Enterprise Asset Management).

Form Customization for Work Order Creation in EAM with different levels of assets. Also involved in form extention for repair work order creation from various item of legacy system.

Project Accounting (PA) tracing the repair status history by using CUSTOM.pll. Also worked on work order form Customization by using CUSTOM.pll

Developed program to import billing methods, contract line and deliverables in Oracle Project Billing.

Developed an Interface program for import items from various legacy systems in Oracle Inventory (INV)

System Integreted Testing at Onsite using remote connectivity from offshore and supporting of User Acceptance Testing.

Preparation of Test plans, MD70’s and Unit Integration Testing of code.

Creating version controlled promotion packages, which include installation shell scripts and LDT files.

Environment: Oracle Applications 11i, Developer 2000, Windows XP, Linux, Toad 7.6, PVCS.

Modules: Project Accounting (PA), Enterprise Asset Management (EAM), Purchasing (PO), and Inventory (INV)

Jun 2003 to Jan 2005 Dayton Power and Light, Dayton, Ohio Application Developer

Dayton Power and Light Company (DP&L), a regulated electric utility, provides service to over 500,000 retails customers in West Central Ohio. DPLE engages in the operation of peaking generation facilities and DPL is a competitive retails electric supplier in Ohio, selling to major industrial and commercial customers. It operates approximately 4,400 Megawatts of generation capacity, of which 2,800 Megawatts are low Cost coal-fired units and 1,600 Mega Watts are natural gas and Diesel peaking units.

This project involved implementation of various modules like Inventory(INV), Purchasing (PO) to develop Interface programs and customizations of Forms and Reports. Also it integrated Oracle System with EDI to process Purchase Orders.

Responsibilities:

Development of Interface to import PO receipts.

GPS Inbound Interface to Oracle Inventory (INV).

PO outbound interface for External EDI system for processing the Purchase Order.

Cost Compare Report for an item in different Organization based upon the operating unit.

Customization of PO Form to view item information by the user used as ZOOM functionality in CUSTOM.pll

Developed conversion program to import projects along with costing and budget information in Oracle Projects.

Used AIM Methodology for completing all documentation CV070, IF70, MD070, etc.

The conversion and interface programs developed are registered as concurrent programs and run from SRS form. Supported the CRPs, SIT, UAT and go-live activities.

Environment: Oracle Applications 11i , Developer 2000, Windows 2000, Unix, Test Director 8, Toad 7.6, PVCS.

Modules: Purchasing(PO), Inventory(INV) and Project Accounting(PA)

Dec 2002 to May 2003 Intuit, Mountain view, CA Technical Consultant

Intuit with more than 7,000 employees has major offices in 13 states across the U.S., Canada and the United Kingdom. Intuit specialises in software products for business and financial management for Businesses and individuals.

This was an Implemention Project involving the following modules: Project Accounting (PA), Purchasing (PO) and Oracle Inventory (INV).This involved development of Reports,Interfaces,Conversion and Extension Programs.Legacy systems data transferred into Oracle Apps system by using SQL Loader.Validation of the data done and was imported through Open Interface tables and Custom Interface program API’s.

Responsibilities:

Projects Import Interface from Maximo (Legacy System) to Projects Accounting(PA)

Global Suppliers Interface in Purchasing (PO) to import supplier details into Oracle Apps system.

PO Notes Conversion in Oracle Purchasing(PO), developed to import notes along with Purchase Order.

Define a trigger to update the PO DFF with Manufacturer Part Number(MPN) in Oracle Inventory (INV).

Developed and Customized various Inventory Reports in Oracle Inventory (INV). Those are related with Inventory item,Cost,status,Open purchase order and Open Sales order details.

Using SQL Loader to transfer the data from flat files to temporary tables.

Developed Invoice Reports for Multi Org Environment in PA Module.

Environment: Oracle Applications 11i , Developer 2000, Windows 2000, Unix, Test Director 8, Toad 7.6, PVCS.

Modules: Purchasing(PO), Inventory(INV) and Project Accounting(PA)

Education: Bachelor of Engineering

References: Will be provided upon request.

Contact this candidate