Project Oracle

RAVI MOHAN

Summary:

• ** years of Experience in Information technology as Oracle Projects and Financials Functional

Lead/Analyst. Expertise in Implementations/Business process/configurations/support and

documentation of Oracle Projects and Financials which includes Project Accounting, Project

costing, Project Billing, Project Manufacturing, General Ledger, Accounts payable, Accounts

Receivable, Fixed Assets, Cash Management Experience in complete life cycle implementation of

Oracle ERP

• Expertise in As-is documentation, Business process reengineering, Requirement analysis, To-be

process design, process flow charts, Fit-Gap Analysis, solution design for RICE (Reports,

Integrations, Customizations and Extensions), system integration testing, user acceptance testing,

performance testing, documentation and training end users.

• Proficiency in other Oracle modules such as Oracle Time and Labor, iExpense, iSupplier,

Purchasing, Inventory, Order Management since these have been implemented by me as

supplemental modules to my mainstream implementations for Oracle Projects and Financials.

• Proficiency in several project delivery methodology such as AIM Methodology, DPMM (Digitized

Project Management Methodology), Agile. Above mix of skills helps me succeed under challenging

and demanding conditions.

• Excellent communication and analytical skills in solving business challenges, identify unique

requirements along with good Business knowledge to provide solutions on a broader perspective

• Participation in multimillion dollar Complex Global (multi country/currency) initiatives / project

implementations.

• Required Technical knowledge to support functionality for the above modules using Oracle Tools

including PL/SQL, Toad, SQL Developer, Reports Builder, Oracle Forms/Reports and sufficient

knowledge of Oracle support portal for debugging/Troubleshooting and diagnostics tools.

EDUCATION

• MBA with Finance Specialization

• Bachelors in Commerce with Accounting Honors

KEY SKILLS

ERP: Oracle application R 12.1.3, 11i (11.5.5 thru 11.5.10)

Expertise: Project Accounting comprising of Projects Foundation, Project Costing, Project Billing,

Project Manufacturing, Accounts Payables, Fixed Assets, General Ledger, Accounts

Receivables, Cash Management, Oracle iExpense and Oracle Time and Labor

Reporting Tools: OBIEE, Oracle Discoverer and Cognos

Tools: TOAD/SQL Navigator and SQL Developer

Documentation: MS Visio for process flowcharts and SharePoint for project documents

PROFESSIONAL EXPERIENCE

Qualcomm, San Diego, CA JUL 2010 – Till

Date

ROLE: FUNCTIONAL LEAD/BUSINESS ANALYST

VERSION: ORACLE R 12.1.3

MODULES: PROJECT FOUNDATION, PROJECT COSTING, FIXED ASSETS, ACCOUNTS PAYABLE, GENERAL LEDGER AND

CASH MANAGEMENT

MAJOR ACCOMPLISHMENTS:

• Oracle 11.5.10 to R12.1.3 upgrade: Secondary Ledger and FA Tax Book Implementation

o IMPLEMENTED INDIA CHINA STATUTORY REPORTING. DUE GL

SECONDARY LEDGER FOR AND TO

CALENDAR DIFFERENCE, EARLIER IN 11I THERE WERE SEPARATE SETS OF BOOKS FOR STATUTORY

REPORTING. MONTHLY CONSOLIDATION IS RUN TO COPY JES FROM USGAAP LEDGER TO STATUTORY

LEDGER. WHILE UPGRADING TO R12, ORACLE DOES NOT PROVIDE OPTION TO CONVERT ANY EXISTING

SET OF BOOK INTO SECONDARY LEDGER. THEREFORE WE CREATED TWO NEW SECONDARY LEDGERS

(INDIA & CHINA) IN R12. THERE ARE SEVERAL BENEFITS OF HAVING SECONDARY LEDGER SUCH AS I)

JE LINE LEVEL DRILL DOWN FROM BOTH PRIMARY AND SECONDARY LEDGER II) REAL TIME JOURNAL

CREATION IN BOTH LEDGERS III) REAL TIME REPORTING OF FINANCIALS

o IMPLEMENTED NEW TAX BOOK USING TO IMPROVE OVER 11I IN R12 WITH AN OPTION USING

SECONDARY LEDGER ASSIGNMENT.

o PHASE-OUT OLD LEDGER / FA TAX BOOK AND CARRY OUT A COMPLEX DATA MIGRATION FROM OLD

BOOK TO NEW

• Oracle projects implementation for India, Japan, Taiwan, Korea& China

o IMPLEMENTED PROJECT ACCOUNTING MODULE FOR INDIA AND CHINA CIP (CAPITAL) PROJECTS.

FOR

CONFIGURED AUTO ACCOUNTING RULES AND LOOKUPS

o AS GROWING COMPANY QUALCOMM WAS INVESTING ON SEVERAL REAL ESTATE PROJECTS IN THESE

CIP PROJECTS

COUNTRIES AND TO TRACK COST IT WAS IMPORTANT TO CONFIGURE IN PROJECT

ACCOUNTING

• Oracle Projects Intercompany Billing

o IMPLEMENTED INTERCOMPANY BILLING (ACROSS USA), BORROWED

LEGAL ENTITIES IN AND LENT

METHOD (CROSS CHARGE WITHIN LEGAL ENTITY) AND CUSTOMIZED BORROWED AND LENT METHOD FOR

INTERNATIONAL OPERATING UNITS

o CUSTOMIZED BORROWED AND LENT PROJECT IS VERY COMPLEX, DUE TO INCONSISTENCY IN QUALCOMM

MANAGEMENT REPORTING AND STATUTORY REPORTING

o SEVERAL INDIA, CHINA, CANADA AND UK

INTERNATIONAL EMPLOYEES IN OFFICES WORK ON

QUALCOMM. WHEN WORK ON USA PROJECT THEIR COST

THESE EMPLOYEES IS OWNED PROJECT

OWNING ORGANIZATION. WITH CUSTOMIZED BORROWED AND LENT WE ENSURED THAT COST IS OWNED BY

A SPECIFIC DEPARTMENTS ASSIGNED FOR THE PURPOSE

• Oracle ERP implementation for China, Taiwan, Korea and Japan

o IN CHINA IMPLEMENTING STATUTORY REPORTING SOLUTION WAS CHALLENGING AS OUR CHART OF

CHINESE GOVT. STANDARDS. WE

ACCOUNTS WERE NOT DIRECTLY MAPPING TO THE REQUIREMENTS OF

SUB-ACCOUNT SEGMENT FIELD IN OUR CHART OF ACCOUNTS TO MAP THESE ACCOUNTS

USED

• Oracle ERP implementation for newly acquired company: Atheros

o AFTER GLOBAL ACQUISITION OF ATHEROS BY QUALCOMM IN 2011, WE IMPLEMENTED ORACLE FOR

ATHEROS BUSINESS IN OUR EXISTING ERP

o CRUCIAL SUCCESS FACTOR FOR THIS PROJECT IS DETERMINING CUT-OFFS IN ATHEROS ERP AND DATA

CONVERSION STRATEGY. BY CONDUCTING MEETINGS WITH STAKE HOLDERS AND LOT OF ANALYSIS, WE

COULD SUCCESSFULLY COMPLETE THE PROJECT

• New Corporate Bank addition in Oracle and Interface development

o QUALCOMM’S TREASURY TOOK DECISION TO TRANSITION TO BANK OF AMERICA (BOA) FROM EXISTING

ROYAL BANK OF SCOTLAND (RBS). I WAS PROJECT LEAD FOR THIS TRANSITION.

o IN INDIA WE WERE ABLE TO AUTOMATE COMPLETE IMPORT (GOODS) PAYMENTS PROCESS. WHICH

OTHERWISE IS PRETTY CUMBERSOME AND MANUAL PROCESS. ALSO CHINESE GOVT. IS HAVING SPECIFIC

REQUIREMENT WHEREIN SEPARATE PAYMENT DOCUMENT NUMBERS WERE REQUIRED FOR EACH INVOICE

FOR SPECIFIC SUPPLIERS.

o TECHNICAL DEVELOPMENT, THROUGH TESTING, END USER TRAINING IS KEY ELEMENTS OF THIS PROJECT.

• Cost plus Journal Automation

o QUALCOMM HAS OFFICES USA. EACH

IN SEVERAL COUNTRIES OUTSIDE OF ONE OF THESE COUNTRIES

REQUIRES DIFFERENT REVENUE CALCULATION AS PER TRANSFER PRICING REGULATIONS.

o WE DESIGNED A SOLUTION FOR THIS USING MASS ALLOCATIONS IN ORACLE. THIS SOLUTION WAS NOT

ORACLE MASS ALLOCATIONS FUNCTIONAL CURRENCY,

EASY AS STANDARD ARE GENERATED ONLY IN

COST USD. BY

WHEREAS OUR REQUIREMENT WAS TO GENERATE PLUS JOURNAL ENTRY IN USING A

WORKAROUND WE WERE ABLE TO ACHIEVE REQUIRED RESULTS

• Multi period accounting using SLA

o AMCS (ANNUAL MAINTENANCE CHARGES) AND PREPAID EXPENSES REQUIRE MONTHLY ADJUSTMENTS

BECAUSE THESE CHARGES, LOT OF TIMES, ARE FOR A YEAR OR FEW MONTHS

o ORACLE PROVIDES SLA SOLUTION THAT CAN BE USED TO AMORTIZE THE PREPAID EXPENSES

o WE IMPLEMENTED THIS SOLUTION TO CREATE ACCOUNTING ENTRIES IN SLA FOR SEVERAL FUTURE

PERIODS

o IN QUALCOMM WE TREATED PREPAID EXPENSES BELOW 12 MONTHS AS CURRENT ASSETS AND ABOVE 12

MONTH TIME AS LONG TERM ASSETS. THEREFORE ACCOUNTING TREATMENT HAD TO BE CHANGED AS

12 MONTHS. USING SQL LOGIC WE WERE ABLE TO ADDRESS

SOON AS AMORTIZATION REACHED BELOW

THIS ISSUE.

Responsibilities:

• Work on New Projects & initiatives

• Identify Automation opportunities: Conduct study on cost benefit analysis, time savings, compliance,

control and management reporting

• Prepare Project Scope document

• Interview stakeholders

• Prepare As-Is process document

• Documentation: prepare requirements (RD.50), To-be (BP.80), ERP configuration (BR.100), RICE

(MD.50) functional spec, Test cases (TE.50) and Project transition (PM.10) document

• Prepare detailed process flow charts

• Regular meetings with stakeholders

• Conduct fit-gap analysis, identify RICE requirements based on fit-gap analysis

• Identify data conversion requirements

• Prepare training guides for end users and conduct class room and online training sessions. Prepare

project closure document: Add lessons learnt, best practices

Cricket Communications, San Diego, CA JAN

2009 – JUL-2010

ROLE: FUNCTIONAL LEAD

ERP: ORACLE 11.5.10

MODULES: PROJECT FOUNDATION, PROJECT COSTING, FIXED ASSETS, ACCOUNTS PAYABLE, GENERAL LEDGER AND

ISUPPLIER

MAJOR PROJECTS:

• Oracle Project Accounting rollouts

o PROJECT ACCOUNTING AND FIXED CRICKET

ASSETS ARE IS KEY MODULES FOR WIRELESS AS IT WAS

EXPANDING BY ADDING MORE AND MORE CELL TOWERS AND SWITCHES

o TO HELP THE GROWTH IN NETWORKS WE ADDED SEVERAL OPERATING UNITS

• Project Allocations

o LOT OF COMMON COST HAD TO BE ALLOCATED TO PROJECTS (MOST OF THEM ARE CIP PROJECTS) TO

ENSURE COMPLETE PROJECT COST CAPITALIZED

o WE USED BOTH PRORATE AND TARGET PRORATE ALLOCATIONS

• Asset Creation Automation in Oracle Projects:

o AUTOMATED PROGRAM FOR CREATING ASSETS IN ORACLE PROJECTS USING ORACLE API

o PROGRAMMATICALLY DERIVE DATE PLACED IN SERVICE, ASSET LOCATION AND CATEGORY

• Convergys billing system integration with Oracle Accounts Receivables

o CRICKET IMPLEMENTED CONVERGYS BILLING SYSTEM FOR BILLING MILLIONS OF THEIR CUSTOMERS

o INTEGRATION WITH ORACLE RECEIVABLES WAS NOT EASY, BECAUSE OF SEVERAL BILLING PLANS, OFFERS

AND EXCEPTIONS

• Oracle iSupplier implementation

o ISUPPLIER MODULE WAS IMPLEMENTED AND ACCESS GIVEN TO VENDORS FOR UPLOADING INVOICE

o INVOICES ARE DIRECTLY INTERFACED INTO ORACLE PAYABLES AWAITING VALIDATION

• Excel upload of bulk payables Invoices

o CSV FILE TEMPLATE FOR UPLOADING BULK INVOICES SUCH AS UTILITIES AND RENTALS DIRECTLY INTO

ORACLE

o WEB PAGE FOR UPLOADING FILE INTO DATABASE AND CUSTOM CONCURRENT REQUEST FOR VALIDATING

AND IMPORTING DATA

Responsibilities:

• Work on New Projects & initiatives

• Identify Automation opportunities: Conduct study on cost benefit analysis, time savings, compliance,

control and management reporting

• Prepare Project Scope document

• Interview stakeholders

• Prepare As-Is process document

• Documentation: prepare requirements (RD.50), To-be (BP.80), ERP configuration (BR.100), RICE

(MD.50) functional spec, Test cases (TE.50) and Project transition (PM.10) document

• Prepare detailed process flow charts

• Regular meetings with stakeholders

• Conduct fit-gap analysis, identify RICE requirements based on fit-gap analysis

• Identify data conversion requirements

• Prepare training guides for end users and conduct class room and online training sessions. Prepare

project closure document: Add lessons learnt, best practices

GENPACT, Houston, TX APR-2006 –

JAN-2009

ROLE: FUNCTIONAL LEAD

ERP: ORACLE 11.5.10 AND ORACLE R12 SAND BOX FOR A CLIENT

MODULES: PROJECT FOUNDATION, PROJECT COSTING, PROJECT MANUFACTURING, FIXED ASSETS, ACCOUNTS PAYABLE,

ACCOUNTS RECEIVABLES, GENERAL LEDGER, ORACLE TIME AND LABOR, ORACLE IEXPENSE

CLIENT: GE AERO ENERGY

PROJECTS:

• Oracle upgrade from 11.5.8 to 11.5.10: Lead for Oracle Project costing & Project Billing

• Implementation of Project Management module

o MS PROJECTS INTEGRATION WITH ORACLE PROJECT MANAGEMENT

• MARS (Management Accounting Reporting) Project

o CHANGES TO CHART OF ACCOUNTS FOR MANAGEMENT ACCOUNTING REPORTS

o CHANGES IN AUTO ACCOUNTING AND ACCOUNT GENERATOR RULES AND LOOKUPS

RESPONSIBILITIES: AS-IS AND TO-BE DOCUMENTATION (BP.80 DOCUMENT), PROCESS FLOW CHARTS, REQUIREMENTS

DOCUMENT (RD.50), CONFIGURATION DOCUMENT BR.100, TEST CASES DOCUMENT TE.50

CLIENT: GE GASIFICATION AND PPSD (ORACLE ERP 11.5.10 IMPLEMENTATION: LEAD ORACLE PROJECT

FOR

COSTING & PROJECT BILLING)

CHALLENGE: THIS PROJECT I WAS PART OF, DUE TO 30+

WAS ONE OF THE MOST COMPLEX PROJECTS THAT INTEGRATIONS

WITH 3 PARTY SYSTEMS.

RD

RESPONSIBILITIES: AS-IS AND TO-BE DOCUMENTATION (BP.80 DOCUMENT), PROCESS FLOW CHARTS, REQUIREMENTS

DOCUMENT (RD.50), CONFIGURATION DOCUMENT BR.100, TEST CASES DOCUMENT TE.50

CLIENT: GE ERP CENTER OF EXCELLENCE (REVIEW ERP PROJECTS AND MINIMIZE CUSTOMIZATIONS)

RESPONSIBILITIES:

• SUBJECT MATTER EXPERT FOR ORACLE PROJECTS AND FIXED ASSETS

• REVIEW COMPLETE DOCUMENTATION OF EVERY ORACLE ERP PROJECT BEING IMPLEMENTED FOR VARIOUS

GE BUSINESS. ENSURE THERE ARE NO OR VERY MINIMUM NUMBER OF CUSTOMIZATION

• SUGGEST BETTER SOLUTIONS TO THE PROJECT TEAM

• IMPLEMENTED ORACLE R12 SANDBOX FOR THE FIRST TIME AT GE

CLIENT: GE WIND ENERGY (ORACLE ROLLOUT FOR UK & IRELAND)

RESPONSIBILITIES: AS-IS AND TO-BE DOCUMENTATION (BP.80 DOCUMENT), PROCESS FLOW CHARTS, REQUIREMENTS

DOCUMENT (RD.50), CONFIGURATION DOCUMENT BR.100, TEST CASES DOCUMENT TE.50

UNISYS, Bangalore, India AUG-2005 – APR-

2006

ROLE: FUNCTIONAL LEAD

ERP: ORACLE 11.5.8

MODULES: PROJECT FOUNDATION, PROJECT COSTING, PROJECT MANUFACTURING, FIXED ASSETS, ACCOUNTS PAYABLE,

ACCOUNTS RECEIVABLES, GENERAL LEDGER, ORACLE TIME AND LABOR, ORACLE IEXPENSE

MAJOR PROJECTS:

• CHANGE POINT PROJECT MANAGEMENT TOOL INTEGRATION WITH ORACLE PROJECT ACCOUNTING

RESPONSIBILITIES:

• PREPARE FUNCTIONAL SPECIFICATION (MD.50) DOCUMENTS AND PROCESS FLOW CHARTS

• PROVIDE SUPPORT TO END USERS

• WORK ON ORACLE SERVICE REQUESTS

CAPGEMINI, Mumbai, India MAR-2004 – AUG-

2005

ROLE: FUNCTIONAL CONSULTANT

ERP: ORACLE 11.5.9

MODULES: PROJECT FOUNDATION, PROJECT COSTING, PROJECT MANUFACTURING, FIXED ASSETS, ACCOUNTS PAYABLE,

ACCOUNTS RECEIVABLES, GENERAL LEDGER, ORACLE TIME AND LABOR, ORACLE IEXPENSE

CLIENT: TMN, AUSTRALIA

RESPONSIBILITIES:

• PREPARE FUNCTIONAL SPECIFICATION (MD.50) DOCUMENTS AND PROCESS FLOW CHARTS

• PROVIDE SUPPORT TO END USERS

• WORK ON ORACLE SERVICE REQUESTS

CLIENT: KPMG, NETHERLANDS

RESPONSIBILITIES:

• ORACLE PROJECT ACCOUNTING IMPLEMENTATION

• PREPARE BR.100 DOCUMENT FOR CONFIGURATIONS

• PREPARE FUNCTIONAL SPECIFICATION (MD.50) DOCUMENTS AND PROCESS FLOW CHARTS

CLIENT: CAPGEMINI (IFRS REPORTING ENHANCEMENTS PROJECT)

RESPONSIBILITIES:

• UPDATE AUTO ACCOUNTING RULES AND ACCOUNT GENERATOR IN ORACLE

• UPDATE BR.100 DOCUMENT FOR CONFIGURATIONS

CLIENT: CAPGEMINI (ORACLE 11.5.5 TO 11.5.9 UPGRADE)

RESPONSIBILITIES:

• MULTICURRENCY BILLING IMPLEMENTATION

• NEW FEATURES MATRIX. IMPLEMENTATION OF USEFUL FEATURES

• MULTIPLE ROUNDS OF TESTING

TCS, Mumbai, India APR-2003 –

MAR-2004

ROLE: FUNCTIONAL CONSULTANT (SUPPORT & PROJECTS)

ERP: ORACLE 11.5.5

MODULES: PROJECT COSTING AND PROJECT BILLING

CLIENT: TCS (PROJECT PROFITABILITY CALCULATION)

RESPONSIBILITIES:

• PROJECT PROFITABILITY CALCULATION BASED ON AGREEMENT VALUE, REVENUE BUDGET AND COST BUDGET

• TESTING OF CUSTOM COMPONENTS

CLIENT: TCS (CONTRACT MANAGEMENT APPLICATION INTERFACE)

RESPONSIBILITIES:

• UPDATE CONFIGURATIONS IN ORACLE

• TESTING OF CUSTOM COMPONENTS

CLIENT: TCS (IPMS (TIMECARD) APPLICATION INTERFACE)

RESPONSIBILITIES:

• UPDATE CONFIGURATIONS IN ORACLE

• TESTING OF CUSTOM COMPONENTS

Contact this candidate