Oracle Sales

MUTHU ADAIKAPAN

Summary

. Over ** years of Functional & Business experience which includes

around Seven years in Oracle ERP in a variety of large Multinational

Projects across various geographies, with Full Life Cycle

Implementations & up gradation of Oracle Applications. Experienced

with Oracle Financials (GL, AR, AP, FA, and CE), e-Business Tax, Sub

Ledger Accounting, Project Accounting, Purchasing, Inventory and

Costing, Sys Admin modules

. Extensive Functional experience in requirement analysis, design,

development, testing and implementation of various Oracle Application

Modules with a profound knowledge of AIM methodology

. Expertise in developing Business Process documents (BP80), Requirement

Mapping document (BR30), Setup Document implementing (BR100s), Design

Documents (MD050s), Developing and creating Conversion Documents

(CV40s and 60s)

. Experience with Vertex Tax Software integrating it with Oracle AR Module.

. Extensive experience with Release 12 especially modules such as

Financials, e-Business Tax, Sub Ledger Accounting and Payments

. Good exposure and Application of - Cross Regime, Surcharge, GST, HST,

PST, QST and other Taxation methods, Tax feature - Rules,Tax Zones and

Jurisdiction

. Possesses working knowledge of the Oracle Open Interface tables. Held

positions where major responsibilities included mapping of Legacy data

and unit testing of the data conversions and enhancement programs in

an Oracle Applications environment

. Extensive experience in providing solution and customization using of

SQL*Plus, PL/SQL, Forms 6i, Reports 6i, Oracle Workflow. Possesses

strong understanding of programming experience in SQL and PL/SQL with

a sound understanding of Application Object Library (AOL)

. Extensive experience in understanding and providing Gap and Fit

analysis.

. Experience consists of implementation of Financial Applications;

Projects focus on functional solutions to clients for financial system

implementations, migration to modern financial technology, business

development, transitions, and managing accounting projects.

. Established expertise using Oracle Software for applications design

and development environments. Upgraded applications from 10.7 and

11.0.3 and to Release 11i and participated in all aspects of software

development Life Cycle and Production troubleshooting, Software

testing etc.

. Involved in converting different Financial Applications platform to

Oracle E-Business Suite. Involved in different aspects of the

implementation cycle from requirements gathering, "To Be" Process and

creating Implementation Documentation (BR100) Creating Test scripts

and aided in CRPs.

. Functional responsibilities: Interfacing with users, requirements

gathering, functional gap analysis, application design, configuration,

module setup, test script generation, writing training guides,

training end users, and production support.

. Technical activities: identifying functional and technical gaps,

estimating work, architecting system interactions, designing custom

solutions, scheduling, producing documentation, user manual to users

and providing production support.

Tools:

ERP MODULES: Oracle Applications Financials R12/11i/11.0.3 Oracle Payables,

Oracle Receivables, Oracle General Ledger, Fixed Assets, Cash Management,

Project Accounting and Oracle Purchasing

Interfacing Tools: 170 Systems, Desktop ADI, TOAD and Oracle Discoverer

RDBMS: Oracle Database and Access 97/2000

Reporting tools: Reports 6i Discoverer 10g/4i/3i

Languages: SQL

Operating Systems: UNIX, Windows-9x/XP, Linux

PROFESSIONAL EXPERIENCE -

Parexel International, Lowell, MA

May '10 to Present

Functional Consultant

Environment: Oracle Applications R12.0.6 Modules (EBTax,GL, AP, AR and FA)

Parexel Leader in Pharmaceutical Services is present across the Global. Re-

Implemented Oracle EBS in R12 and with new features for 80 Countries.

. Successfully Upgraded and Gathered requirements for implementation of

R12 EBusiness Tax for North America, European and APAC countries

. Implemented EBtax for US with integration from Vertex

. Implemented EBusiness Sales Tax for US - Regime to Rate flow with

Rules and Exceptions and Self assessment Tax

. Testing of each country with all Business Case of Transactions in AP

and AR for All OUs

. Implemented Tax for Argentina without patches using standard EBTax

features to reduce implementation Time and Testing

. Worked on a GAP Analysis between Vetex and eBusiness Tax to convert from

the existing Vertex implementation to eBusiness Tax

. Gathered requirements and Prepared BR100 for EBTax with Tax Rules for

Exceptions and Extensive Rules for Tax calculation bases on the Sales

and VAT Taxes for respective countries

. Good exposure on Cross Regime, Surcharge, GST, HST, PST, QST and other

Taxation methods

. Created and Executed the Upgrade Test Scripts for all Financial

modules and integration with EBTax

US Concrete. Houston, TX Oct '09

to Apr '09 Functional Consultant

Environment: Oracle Applications R12.0.4 Modules (GL, AP, AR, OM, INV,

Costing, FA and EBTax)

US Concrete is leading Concrete and Construction Technology provider.

Upgraded from 11i to R12 and implemented with new features.

. Successfully Upgraded and Gathered requirements for upgrade and

implementation of R12

. Gathered requirements and Prepared BR100 Financial Modules for New

features of AP and EBTax

. Gathered requirements and Partially Implemented Financial Accounting

Hub for processing Accounting for external systems

. Implemented EBusiness Sales Tax for US - Regime to Rate flow with

Rules and Exceptions and Self assessment Tax

. Worked on a GAP Analysis between Vetex and eBusiness Tax to convert from

the existing Vertex implementation to eBusiness Tax

. Assisted the client with the functional aspects of upgrade from 11i to

R12 in AR, AP, FA and GL from end to end process cycle, month en close

and reconciliation activities

. Created and Executed the Upgrade Test Scripts for all Financial

modules and integration with EBTax

Dunkin Brands Inc, Canton, MA May

'09 to Sept '09

Dunkin Brands, a holding company of Dunkin and Baskin Robbins a leading

retail chain of Coffee and Ice Cream outlets in North America and spread

across the world. Dunkin performed a cost segregation study to segregate

Assets into multiple Assets to leverage the Tax policies and benefit with

Tax rebates.

Fixed Assets Consultant

. Designed and Implemented New Fixed Asset Tax Books

. Conversion of Assets from Old Tax Book to New Tax Books with complex

sequence of creation of Asset using custom and standard features from

multiple sources of Assets

. Designed and Implemented an Automated solution to Retire Assets in

different Asset Books

State Street Corporation, Boston, MA Oct '07 to

Jun '09

P2P Project Lead

Environment: Oracle Applications Release 11.5.10 Modules (GL, AP, PO, INV,

iExp and FA )

State Street Corporation a leading financial service provider for

institutional investors with a global presence and annual revenue of 10

Billion USD; also holds the world's largest pool of Assets. SSC initiated a

global P2P program to streamline the payables operations spanning

iExpenses, Procurement and Payables to adopt the Shared Services.

. Successfully lead a team in the implementation of Oracle Assets,

Oracle iExpenses, Oracle Purchasing and Oracle Payables tightly

integrated with 170 Imaging systems and AME for North America

. Strategized and executed CRPs Sessions/Requirement Gathering/writing

use cases/Validating QA results/Test Plans for UAT sessions for - FA,

iExp, PO, INV and AP

. Performed As-Is Business process study, worked with Key Business

owners to formulate the New Business Process incorporating Best

Practices

. Formulated detailed Cut-Over plans for Go-Live weekends with vital

checks points

. Performed Data Cleanup, Validations and Conversion of Assets from

Mainframe - IVIS system to Oracle Assets, for over 100K Assets, worth

2.2 billion USD worth assets

. Strategized the conversion migration of Asset data to Production, to

meet stringent reconciliation and cutover requirements

. Designed a Monthly Interface to Oracle Financial Analyzer Systems to

provide the Expenses forecasting of Assets

. Designed a customization to change the Asset Journals creation date in

GL

. Prepared Use Cases for with complete Business process to Aid

development and testing

. Gathered and Reviewed requirements for Oracle iExpenses Implementation

. Define Expense report Templates to control reimbursement for different

groups of employees

. Configuration of Employee Expense Approvals using AME Rules for

specific group of Executives and standard Employee supervisor

hierarchy for employees

. Designed a custom solution for the Generating Taxes for Canada

Operating Unit based on the location of the Expenses

. Designed the Future Process Flow for Expense Report creation to

payments from the Setup of Expense types till they are audited for a

Share Services Model

. Designed a Custom Solution to handle complex Invoice Approval using

AME and 170 Approval Workflows, using custom Table and Form for

creation and maintenance of approval rules which changes frequently

. Provided Custom solutions for Processing Electronic Invoicing and

interfacing between Legacy Employee Expense reimbursement systems

. Designed a Custom Solution to process Check and Electronic Payments

Automatically in a structured and controlled manner; provide process

details to Business on a scheduled basis and with detailed logs

. Designed multiple solutions using Form Personalization to be SOX

compliant and prevent fraudulent activities

. Performed Supplier conversion - Data Clean up, Data Validation and

Conversion of Suppliers

. Worked on the Business Process Model for integration of 170 Imaging

system and Oracle Payables for Shared Services Business Model

. Designed Month end Feedback reports to display Liability and Cash

Position to the management

. Gathered requirements and Designed Reports - Management Metrics,

Operational, Performance and Reconciliation/Integrating of Imaging,

Payables, AME and Fixed Assets

. Designed and Unit Tested complex custom reports for Management review

of the Asset, Expenses, based on a Custom Management Hierarchy at

detailed and a summary levels for PTD, QTD and YTD time ranges

. Conducted - Unit testing, SIT, UAT Testing on the standard and custom

components

. Worked in Daily inbound interface from Perfect Commerce to Oracle

Payables for updating new the Oracle Payables Suppliers and Purchase

Order information to Purchasing

Dell Inc. Austin, TX

Aug '06 to Jul '07

Functional Consultant

Environment: Oracle Applications Release 11.5.9 Modules GL, AP, PO, FA and

PA

Re-Implementation from 11.03 to 11.5.10.2

Responsibilities:

. Worked on Analyzed the GAP and FIT analysis based on the client

requirement and existing plan. Completed BP80 and BR100.

. Designed and worked on Interfaces and Customization for GL and GIS.

. Interacted with client to gather the requirements of the cross

validation rules, security rules.

. Defining: Chart of Accounts, Currencies, Calendars, Flexfield

Structure, Accounting Flexfield Values, Descriptive Flexfield, Set of

Books, Legal Entities, Operating Units, Profile Options, Journal

Categories, Journal Sources, Document Sequencing and other transaction

related setups.

. A challenging task involved defining and setting up Mass Allocation;

since client had a shortcoming Due to the Cost Center segment value

dependent on Business Unit.

. Interacted with client to gather the requirements of the cross

validation rules and security rules and set them up.

. Defined GIS Subsidiaries and assigning them to GIS Responsibilities

for GIS, defined Transaction Types, Auto Accounting rules for GIS

transactions Cross Validations, Security Rules.

. Defined Consolidation for the Statutory books and used the 11i feature

to consolidate Brazil SOB (the client had a customization done in

11.03) Customized Consolidation of Brazil SOB to US Currency with

certain validation and Exclusions.

. Over and above GL also played an important role as a part of the

configuration and implementation team for GL, AP, FA and PA.

. Setting up the instance for CRPs and Production.

. Worked on design of custom interfaces to external system.

. Written Test Scripts and Data Sheet for Testing and User Training.

. Part of the implementation and Testing Team - Validating reports,

testing the standard functionality and custom components for GL, AP

and PA.

. Created FSG reports, Mass Allocation based on the client requirements.

. Aided in Few PA customization for design and testing.

. Defining Organization, Groups and Functional area in projects. Worked

in Projects for creating CIPs and Transfer them as Assets in FA.

. Worked on the custom conversion of code combinations, mapping between

the new and legacy values and related validation for conversions.

. Worked in Project Costing created the corresponding accounting

entries, and interfaced the revenue accounting to Oracle General

Ledger, Fixed Assets and Payables modules, Worked in Project status

Inquiry (PSI) .

. Worked on PA Custom Reports to process the Project Hierarchy, Category

Classification Code rollup and AFE printing for a Project Reports.

Data from PA tables is processed by this package and loaded into

temporary table for reporting purposes.

State of Rhode Island, RI

Apr '06 to July '06

Functional Consultant

Environment: Oracle Applications Release 11.5.9 Modules (GL, AP, PO and I-

Procurement)

Responsibilities:

. Design of Chart of Accounts.

. Design of BR80 BP80 and BR100 for the implementation

. Interacted with client to gather the requirements of the cross

validation rules, security rules.

. Aided in Design and implementation of 600 Cross Validation Rules.

. Designed and tested Monthly Allocation model for allocating expenses

and revenues.

. Executed and tested the reporting attribute configuration, to aid

reporting.

. Designed and developed FSG reports for revenue analysis.

. Analyzed GL, AP and Purchasing reports for report mapping.

. Designed, implemented and tested configuration of Budget Organization,

Parent Child hierarchy, Rollup Groups, Summary Templates and Budgetary

Control.

. Aided in the design of interfaces between the legacy systems and

oracle application for updating the suppliers, AP invoices with the

legacy system

. Created Test Scripts (TE040) for 11 interface programs with multiple

validations for each interface.

New York Stock Exchange, NY

May '05 to Apr '06

Functional Consultant

Environment: Oracle Applications Release 11.5.9 Modules (GL, AR, AP, PO, I-

Procurement)

Responsibilities:

. Designed and implemented of complex Allocation model for Actuals and

Forecast in order to do the profit and loss analysis of NYSE Cost

Centers with complex cost Allocations and calculation, with multiple

layers of Allocation formulas and Validation reports and Analysis

. Interacted with client to gather requirements and performed Gap and

Fit Analysis

. Developed and documented all procedures, processes, and daily

practices that contribute to Business Process flows for key business

activities

. Provided Custom Solution for changing the email Text for reports and

mailing PDF reports to Key stakeholders on a monthly/weekly basis

. Created Intercompany Transaction, Consolidation, Elimination entries

setups and configuration for use. The use of ADI wizards like Budget

wizard, Journal wizard, Report wizard simplified work with General

ledger. Used Account Hierarchy Editor for the maintenance of Accounts.

. Aided in the preparing the 'To-Be' Documentation of the NYSE Group

Merger.

. Prepared the Implementation document for GL Setup, for NYSE and ARCA

Merger BR100.

. Preparation of Test Cases, Test Plans, and Tests scripts (TE 40)

document and Execution of Test cases with coordination with -

Offshore, Onsite and Users

. Provided solutions for conversion from Legacy systems to Oracle

Applications, Data Mapping and Customizations without disturbing the

existing structure at both NYSE and ARCA

. Assisted the Technical Team with Functional Designs for Interfacing

Legacy systems with Oracle GL for driving the reporting requirements

and capabilities

. Defined the Customer and their profile classes with values by grouping

them as per the discounting structure

. Defined the Transaction Sources and Transaction Types as per the

business requirement

. Grouping of Orders onto Invoice is mapped by enabling the Descriptive

Flex fields attribute values at Header and Line level

. Configured the Location based taxation (Sales Tax) structures by

defining the tax codes and the defaulting algorithm

. Setup transaction source for auto-invoice import, transaction type to

distribute revenues to different GL accounts per company, accounting

rule to correctly recognize the revenue

. Extensively used ADI for uploading Journal entries, Budgets and

running reports

. Gathered requirements to configure Receivable Activity, Accounting

Rules, Auto Accounting, AutoInvoice Line ordering & Grouping Rules,

Auto cash rule, Tax Codes, Tax Locations, Tax Authorities, Sales Tax

Rates and Tax Exemptions for the ARCA companies

Ameren UE. St Louis, MO

Apr '04 to Mar '05

Functional Consultant

Environment: Oracle Applications Release 11.5.9 Modules (GL, AR, FA AP, PO,

INV and OM)

Responsibilities:

. Review Business Process and Product Lines that are applicable for

Configure-to-Order Defining Items Master, Locators, Lots, serial

numbers and UOM

. Configured Profile classes, Customer information, Aging Bucket, Auto

Accounting, Auto Invoice, Staged dunning letters. Configured the Auto

lockbox processing of bank receipts using Auto lockbox interfaces

. Developed scenario/scripts for CRP and preparation for Dev, QA and

UAT

. Worked on Auto Invoice Interface and imported invoices from legacy

system to Oracle Receivables. Provided Custom solutions for invoicing,

generating reports and status of the invoices

. Setup Profile classes, Customer information, Aging Bucket, Auto

Accounting, Auto Invoice, Auto Lockbox Defining and creating Staged

dunning letters, Collector Actions

. Design and implement Functional Companions for capturing product

specifications

Dr.Reddy Labs, India

Apr '01 - Jun '04s

Techno-Functional Consultant

Environment: Oracle Applications Release 11.0.3 (General Ledger, Accounts

Receivables), Forms 3.0, Reports 2.5, SQL, PL/SQL, Oracle 7i.

Banyan-Tree Consulting, India Apr '00

- Jun '00

Intern - Oracle Application Testing and Training

Contact this candidate