Project Oracle

Hitesh Madan

Oracle Financials Consultant, Financial Accounting Transformation

Consultant

******.*****.*****@*****.***, +44-747******* (Mob)

Engagements in brief

Role Client Project Brief Tenure

Principal Consultant Oracle Royal Bank of Scotland Oracle R12 implementation Aug 2012 Mar

FAH, GL, OFSAA, OFSDW, 2014

FSI

OBIEE, ODI

Principal Consultant Oracle Axis Insurance Group Oracle R12 implementation Jul 2010 Jun

FAH, GL, EDW 2012

FSI

WorldPay IT Due Diligence Jun 2010

Lead Consultant Oracle FSI

Lead Consultant Oracle FSI MoneyGram International Oracle R12 Upgrade, Mar 2009 May

Rollouts, CoA change, 2010

Security implementation,

AME, e B Tax,

Lead Consultant Oracle Thermax Limited Oracle 11i implementation Jul 2008 Feb

Financials, Projects, OM, Pur, 2009

Inv, BOM, Localisation, DBI

Arrow Electronics Oracle R12 implementation Jan 2008 Jun

Consultant Oracle

Subledger Accounting 2008

Ministry of Defense, Oman Oracle R12 implementation Jun 2007 Dec

Consultant Oracle

Financials 2007

Gujarat Electricity Board Oracle 11i implementation Feb 2006 May

Consultant Oracle

Financials, Treasury, OM, 2007

Pur, Inv, AME

Practicing Chartered Various Self employed, Practicing Feb 2002 Jan

Chartered Accountant 2006

Accountant

Audit Assistance Various Budhraja and Company, Feb 1999 Jan

Chartered Accountants, India 2002

Skills & Experiences

Qualified Chartered Accountant with post graduation in Information System Audit.

More than 12 years of post qualification experience in Business Analysis, Business Process

Design, ERP implementation, System Integration, Production Support, Operations and Financial

Page 1

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

Audit in a range of verticals such as Banking, Financial Services, Insurance, Payments, Hi tech

Manufacturing, Engineering, and Government verticals across UK, Europe, USA and Asia.

Executed multiple full life cycle Oracle E Business Suite (R12/11i) implementations, Oracle

Rollouts, Upgrade implementation from Oracle 11i to R12, Oracle Feasibility / IT due diligence study,

and several proposals on Finance Transformations and Pre Sale initiatives.

Expertise in Oracle Applications Financial Accounting Hub (FAH), Sub Ledger Accounting (SLA),

General Ledger (GL), Advance Global Intercompany System (AGIS), Account Payables (AP),

Payments, E Business Tax (eBT), Purchasing, Approval Management Engine (AME), Internet

Expenses, Internet Supplier, Fixed Assets (FA), Treasury and Cash Management, Account

Receivables (AR), Inventory, Cost Management, Daily Business Intelligence (DBI), System

Administrator, User Management

Experience in end to end Business cycles Record to Report (R2R), Order to Receipt (O2R), Procure

to Pay (P2P), Acquire to Retire (A2R)

Large Finance Transformation experience involving Oracle Applications, Oracle Financial Services

Data Warehouse (OFSDW), Oracle Financial Services Analytical Applications (OFSAA), Integrations

using Oracle Data Integrator (ODI), BPM/BPEL, Oracle Business Intelligence (OBIEE), Hyperion

etc.

Proficient in building high quality Detailed Solution Blue Prints, Solution Architecture Diagrams,

Business Process Designs, Functional Design Documents, Solution Papers, Key Decision

Documents (KDD), Due diligence Reports, Proposals and Training Material.

Experience to implementation methodologies OUM, AIM and In Track.

Successful delivery experience Chart of Accounts (COA) Design, Multi Org Design, Shared Service

Model, Data Migrations, Conference Room Pilots, Functional Testing, User Training, UAT support,

Cutover activities, Warranty Support etc.

Out of the box thinking with reliable workarounds and dynamic bolt on solutions where standard

features are inadequate to meet the business requirements.

Proven experience in interpreting complex information to the business communities and reporting to

the senior management at the program level.

Proven experience in project management Project initiation and planning, resourcing, budget –

cost, project scoping and proposals, Service Agreements and Work Order preparation, project

monitoring, hold project meetings, Steering meeting representation, manage RAID logs, Change

Control process, Project Governance, managing large teams across multiple geographic locations

Global Delivery Model.

Excellent troubleshooting skills using SQL and PL SQL.

Sound MS Office skills in Word, Advanced Excel, Visio and Power Point presentations, SharePoint,

well versed with testing tools Mercury QC,

Achievements

Received prestigious Excellence Award from Infosys for exceptional performance in 2010 for

MoneyGram implementation.

Received prestigious Titan Award from Oracle for fastest Upgrade in 2010 for MoneyGram project.

2

Received Award from Thermax Limited for exceptional performance in 2009 for best value solution.

Contribution to White Papers in Oracle (OOW) Conference such as ' Demystifying Legal Entity in Oracle

R12 Architecture'

Contributed significantly in building several re usable artifacts such as Web ADI Integrator for FAH

journals

Certified Implementation Specialist on E Business Suite Financials

Page 3

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

Experience in detail

Project Financial and Accounting Transformation project (First Program) at Royal Bank of

Scotland

Duration Aug 2012 to Mar 2014

Principal Consultant Solution Lead and project manager for Oracle eBS

Role

Summary Royal Bank of Scotland is the largest bank in the UK. The present project aims on

the financial and accounting transformation for the bank. The solution landscape

will replace the legacy systems which are on out dated technology with latest

ERP platform which involves implementation of Oracle EBS (R12), OFSAA,

OBIEE using different technology platform for integration and scheduling like

BPEL, BPM, etc.

Modules Oracle Applications R12 FAH, GL, System Administrator, User Management;

OFSDW, OFSAA, OBIEE, ODI, BPM, BPEL

Responsibilities Design and solution blue print of Oracle FAH and GL (e.g. create event,

create accounting, event model, accounting rules, summarization level etc.)

and integration of the upstream front end banking systems with Oracle FAH.

Financial and Accounting Transformation – phasing out current GL system,

custom hard coding to be replaced with Oracle ERP Financial Accounting

Hub (FAH) and GL. Transactions based on event based and pass through

entries both designed within FAH.

Downstream integration with OFSDW and OFSAA. Implementation of OBBIE

for MI / BI reporting, Hyperion for financial consolidation and planning and

overall arching by SOA suite – BPM, BPEL.

Unified staging area, event model, application accounting definition etc. to

support event based as well as pass through type of transactions

Responsible for overall solution design including CEMLIs outlined in the

solution

Documented DS030 for functional configuration.

Solution Design of the key processes like – revenue recognition, tax

calculations, interest calculation, Strategic Adjustments using Web ADI tool

etc. Documented AN100s and reviewed DS140s for the CEMLIs.

Review of the Design documents of the customization and alignment of the

same to the overall solution landscape and development standards.

Flexible and scalable design to accommodate future releases and to support

voluminous transactions landscape.

Support of System and Integration Testing.

Automation of FAH and GL setups which reduced configuration efforts

drastically.

Solution blue print for implementation of Oracle Advance Global

Intercompany System

Designed Role Based Access Control (RBAC), implemented user

management module

OUM implementation methodology being followed in the project.

Managing team of +20 members in global delivery model.

Client handling, proposal preparation, SoW preparation, project initiation,

cost, resource mobilisation, planning, execution, monitoring, risk evaluation

and mitigation, project governance etc.

4

Project Financial Accounting Transformation project FAH implementation in Oracle R12

at AXIS Insurance Group

Duration Jul 2010 to Jun 2012

Principal Consultant Solution Lead and project manager

Role

Summary AXIS Group is a leading specialty insurance company having worldwide

operations. At present AXIS have multiple systems for underwriting, reinsurance

and claim processing. The project objective was to build centralised accounting

and calculation repository and financial accounting transformation. As part of this

project, Financial Accounting Hub (FAH) and GL were implemented to streamline

accounting for all the front end applications and automation of derivation of

different calculations (e.g. Earned premium etc.). Furthermore, solution was

designed to derive accounting per multi GAAPs US GAAP and US Insurance

Statutory requirements

Oracle Applications R12 FAH, GL; EDW, dot net, java

Modules

Responsibilities Project initiation followed by project scope, SoW, planning, execution with

close monitoring on resource and budget, Change Request process, project

governance, risk assessment, Issue tracking an escalation process, etc.

As Is and requirement gathering of accounting methods as per US GAAP

and US Insurance Statutory conventions, revenue recognition and cost (e.g.

Earned premium, etc.)

Design and solution blue print for the integrated financial and accounting

platform in ERP (Oracle Applications) for global implementation which

covered FAH, GL, DWH integration with legacy insurance and re insurance

systems. Documented BR100s for functional configuration.

Designed Accounting Application Definition to support multiple financial

reporting as per US GAAP and US STAT (Insurance Regulation).

Fit Gap Analysis and Solution Design of the CEMLIs along with use cases.

Documented MD050 and review technical designs for the CEMLIs MD070

Designed organisation structure wrt Oracle implementation.

Data warehouse requirements for standardized data input for financial

accounting hub. Collaborated with Oracle to conduct the fitment for EDW.

Designed transaction objects and common staging area for event based and

pass through type of transactions.

Solution design for CEMLIs, e.g. Web ADI integrator for FAH journals

leveraging public APIs, downstream integration with Enterprise GL, Essbase

etc.

Prototyping and CRP sessions with Business to demonstrate various solution

Page 5

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

per blue print.

Configuration and monitoring of the development of the CEMLIs with

appropriate testing to ensure defect free delivery.

Designed data migration strategy Opening Balances, Historical balances for

retrieval, master data.

Key Decisions on parallel run, fall back strategy etc.

Support System and Integration, User Acceptance Testing

Performance optimisation of create event and create accounting programs.

Planning and execution of cutover activities during go live

Representation to steering committee

Post production support, monitoring of critical defects and processes,

optimisation of critical processes

Project Closure Report, lessons learnt etc.

IT Due Diligence for WorldPay

Project

Duration Jun 2010

Lead Consultant, SME

Role

Summary WorldPay is one of the prominent payment processing company whose

operations are spread globally. As part acquisition of WorldPay by CDR from

RBS, IT due diligence was undertaken to estimate the cost of future

implementation of ERP.

Responsibilities Understanding of As Is process, current complexities and pain areas.

High level design of future processes and solution blue print for the new

organisation operating model, financial and accounting processes.

Blue print of IT Roadmap post separation from RBS.

Project Scoping, High level implementation plan, cost estimates, resource

planning for the implementation of new ERP Oracle Applications.

Project RACI matrix and Functional Security in Oracle R12 for MoneyGram International

Apr 2010 May 2010

Duration

Role Lead Consultant

MoneyGram International Inc. is a leading USD based Global Payment Services

Summary

Company with over $ 1 Bn in revenue in 2009; locations in nearly 190 countries

and territories around the world.

Modules Oracle Applications R12 System Administrator, User Management, GL, AP, CE,

AME, OCO, OIC

Responsibilities Solution blue print of RACI matrix mapping with the people’s structure within

the organisation

Designed application security in Oracle Applications as per RACI matrix and

organisation roles. Modules involved – User Management, System Admin,

Functional developer. Application Security was designed for AP, AR, GL, CM,

OCO, OIC modules.

Designed application security on the basis of RBAC (Role Based Access

Control)

Designed Roles and responsibilities in Oracle Applications for internal and

external users.

Designed SPEL functions, permission set and grants as per role access;

menus and request groups as per organisation roles

Tailor made security solution for different modules for their internal and

external users of Oracle Applications as per organisations IT policy,

segregation of duties and regulatory compliances (SOX).

6

Worldwide rollouts of the solution.

Financial Accounting Transformation CoA Change, e B Tax implementation,

Project

Oracle Applications R 12 rollouts at MoneyGram International

Jul 2009 Mar 2010

Duration

Role Lead Consultant, Rest of the world lead for the implementation

MoneyGram International Inc. is a leading USD based Global Payment Services

Summary

Company with over $ 1 Bn in revenue in 2009;; locations in nearly 190 countries

and territories around the world. As part of this project, Chart of Accounts were

re designed and global rollouts of GL, AP, CM and e B Tax modules for US,

Canada, Europe, APAC and rest of the world. This was one of the financial

transformation executions. Project was executed from multiple locations US, UK

and India (Global Delivery Model).

Modules Oracle Applications R12 GL, AP, CE, AME, e B Tax, AME, GCS

Responsibilities Project Scope and planning, execution and monitoring, project governance,

change request process, risk assessment, Issue tracking an escalation

process, etc.

Financial transformation, design blue print IT Road map and replacing

multiple legacy system with Oracle Applications

Re designing Chart of Accounts as part of global solution

Blue print of the roll out strategy and its implementation for rest of the world

(which included 14 countries across Europe, Asia, Australia)

Sun GL system was replaced with Oracle Applications. Developed data

migration strategy to ensure minimum historical data for business retrieval.

Country wise automated electronic payment solution for UK, Europe, China

and India

Solution Design and configuration of e Business Tax for UK, Germany,

France, Italy

Re designed approval workflow processes for rest of the world leveraging

Oracle AME module.

Solution Design and configuration of Advance Global Consolidation System

to facilitate group consolidation. The solution reduce overall time and efforts

for the financial consolidation within MoneyGram group.

Test strategy and planning; User Training material and core user training

Automation of configuration setups in e Business Suite to reduce business

down time

Production Cutover planning and execution

Post Production Support and system improvements

Major Challenge in the area of country localization, taxation and financial

reporting and consolidation of financial results in multiple currencies

Re designing of month end process, this resulted in reduction in time for

month end process and approved financial and tax reporting

Management and Statutory Reporting compliances

Fostered best practices, quality processes and deliverables

Managed client expectations during the complete SDLC of the project

Page 7

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

Project Oracle Applications Upgrade from 11i to R12 at MoneyGram International

Mar 2009 Jun 2009

Duration

Role Lead Consultant

MoneyGram International Inc. is a leading USD based Global Payment Services

Summary

Company with over $ 1 Bn in revenue in 2009; Locations in nearly 190 countries

and territories around the world. This project was an upgrade from Oracle 11i to

Oracle R12. Existing solution was revisited and new R12 features were leveraged

to replace customisations. This was one of the fastest and successful upgrade in

the Oracle 11i to R12 history and was awarded titan award by Oracle Corporation.

Oracle Applications R12 GL, AP, CE, e B Tax, AME

Modules

Responsibilities Oracle Application upgrade from 11i to R12. Modules – GL, AP, CM;

implementation of e B Tax.

Project Scope and planning, execution and monitoring, strict timelines

observed.

Impact analysis and assessment for upgrading from 11i to R12.

Re consideration of existing customisations. R12 features were leveraged to

cede out customisations.

Upgrade strategy and instance planning.

Multiple mock up upgrades to fine tune the cutover plan with main objective

to reduce cutover time.

Production cutover and deployment planning.

Production upgrade executed during weekend with zero hour black out for

end users.

Post production support.

Blue print of IT Road map to leverage Oracle R12 modules like HCM,

iExpense, FA, AGIS.

Fastest upgrade from 11i to R12 in Oracle history.

8

Project Oracle Applications (11i) implementation at Thermax Limited

Jul 2008 Feb 2009

Duration

Role Lead Consultant

Thermax Ltd, headquartered in Pune (India), USD 1 Bn company, providing range

Summary

of engineering solutions in energy and environment sectors. The project covered

implementation of Oracle Financials, Distributions and Manufacturing modules for

two business units at Thermax.

Oracle Applications 11i GL, AP, AR, FA, Pur, OM, BOM, Inventory, Cost

Modules

Management, Projects, CE, Localisation, DBIs

Responsibilities As Is and Requirement gathering (RD050), Re designing business process

flow

Documented To Be Solution (BR030), functional configuration (BR100),

managed CRP and Training

Documented data migration strategy and ensure that minimum open

transactions are migrated with relevant master data.

Defined integration between Project module with other financial modules (AP,

AR, FA) including localisation

Developed test scripts for system, integration and user acceptance. Executed

system and integration testing. Support User Acceptance Testing and liaison

with Oracle via service requests for product issues and technical team for

defects in customisations.

Defined out of the financial statement generator (FSG) reports and Daily

Business Intelligence (DBI) dashboards for management reporting.

Design and Development of custom components – Excise, Customs and

Service Tax bolt on integrated solution with Oracle Applications

Re designing of month end process

Development and integration of custom components with Oracle Financials,

Distribution modules with reduced month end processing streamlined tax law

compliances and reporting. Furthermore, the project provided 24X7 web

based solution accessible anywhere and anytime.

Production cutover and deployment with zero black out time for end users.

Deployment was performed during weekend.

Post production support followed by project closure and lessons learnt.

Page 9

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

Project Oracle Applications implementation for electronics major worldwide at Arrow

Electronics

Duration Jun 2008 Jul 2008

Lead Consultant Functional Consultant for implementation of Subledger

Role

Accounting (SLA)

Arrow Electronics is a worldwide major in electronics having operations in 90

Summary

countries. The project was end to end implementation of Oracle Applications in

R12 Financials, manufacturing, SCM, iExpense modules.

Modules Oracle Applications R12 Subledger Accounting (SLA)

Responsibilities The project involved re design of SLA (Sub Ledger Accounting) rules for

Oracle Financials and Distributions modules in R12 as per accounting

requirements of Arrow Electronics worldwide

Accounting for AR, Inventory and third party systems were re configured

leveraging out of the box SLA features to achieve accounting entries as per

organisation policy.

Developed solution blue print for the SLA module and implementation of the

same.

End to end support of the testing cycle for the solution delivered.

10

Project Oracle Applications (R12) implementation at Ministry of Defense, Oman

Jun 2007 Dec 2007

Duration

Role Functional Consultant

The project involved end to end implementation of Oracle Applications R12

Summary

version at Ministry of Defense, Oman by replacing multiple legacy system across

their departments. This project was a major financial transformation exercise in

defense sector, one of the early adopters of Oracle Applications Release 12.

Oracle Applications R12 GL, AP, AR, FA, CE, XTR, AME

Modules

Responsibilities As Functional consultant was responsible for ‘As Is’ study and requirement

gathering, documented RD010, RD040 and RD050.

Solution blue print of process flows and conversion of the government

accounting (single entry system) to double entry of book keeping.

To Be process mapping, solution blue print, documented BR030

Designed functional configuration BR100 for General Ledger including

budgets, Account Payables, Account Receivables, Fixed Assets, Cash

Management, Treasury.

Prototyping of the proposed solution and conducted CRP with government

officials to validate the requirement and to be solution.

Designed data migration strategy for the transaction and master data related

to the to be solution.

Page 11

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

Project e Urja program Oracle Applications (11i) implementation at Gujarat Electricity

Board (GEB)

Duration Feb 2006 to May 2007

Functional Consultant GL, Treasury, AP, AR, FA, CM, AME and DBIs modules

Role

and integrations with power trading system

Gujarat Electricity Board is one of the dynamic and growing end to end energy

Summary

solution provided in India. This project was one of the biggest end to end Oracle

eBS implementation and financial transformation in India. Oracle eBS (Financials,

Procurement, EAM, Manufacturing, Risk and Treasury, 3rd Party applications for

power purchase and distributions, India Localization) were implemented for

GUVNL the holding company of GEB, GSECL – power generation company of

GEB, GETCO – power transmission company of GEB and Distribution companies

MGVCL, UGVCL, DGVCL and PGVCL. This was followed by state wide rollouts

of Oracle Applications (11i) at MGVCL, UGVCL, DGVCL and PGVCL (Distribution

companies of GEB). This project was a boon for the newly unbundled Gujarat

Electricity Board into a corporate.

Oracle Applications GL, AP, AR, FA, CM, Treasury, AME and DBIs modules and

Modules

integrations with power trading system

Responsibilities As Functional consultant was responsible for As Is process and Requirement

Gathering, documented RD010, RD040 and RD050.

Designed To Be process mapping and solution blue print across Oracle

Financials modules BR040

Solution design of Treasury module to implement more than USD 2 bn of

loan portfolio across the group along with other treasury features like

hedging, currency swap, share portfolio, bond portfolio, integration with third

party power trading system for the calculation of financial borrowing cost as

part of the overall power cost.

Designed of FSGs for the consolidation reporting of the group companies.

Managed development of integration of third party power trading software

with Oracle Applications. This involved integration with AP, AR and Treasury

modules of Oracle Applications.

Prototyping of to be solution and conducted Conference Room Pilot with

business users.

Monitor development of custom components as per solution design, followed

with detail unit and system testing

Designing of FSGs for the consolidation reporting of the group companies

Development of training materials for core / end users and conduct of training

Co ordinate and supported testing cycles (SIT, UAT)

Data Migration for Oracle Financial modules; Managed production cutover

and post production support

Rollout strategy to implement the solution to the subsidiaries and

departments of Gujarat Electricity Board

Change Management and training to end users for the new processes.

The implementation provided reporting as per Indian GAAPs, Companies Act

and tax compliances as per VAT, Excise and Income Tax.

Furthermore, the to be design provided end to end solution to various

business flows e.g. Planning of power trading to payments to power traders

etc. which brought effectiveness and efficiency in the core business

activities.

The design facilitated online reporting of consolidated financial results for the

group companies which can drill down to lowest level of each division.

12

Further, DBIs provided almost online financial dashboards for timely decision

making and planning.

Organisation: Self employed,

Role: Practicing Chartered Accountant

Tenure: Feb 2002 to Jan 2006

Page 13

Hitesh Madan (Oracle Financials Consultant, Financial Accounting Transformation Consultant)

Project / Client Various

Feb 2002 to Jan 2006

Duration

Role Practicing Chartered Accountant, Independent Financial Consultant

Responsibilities Statutory Branch Auditor for Central Bank of India for their industrial, retail

and agriculture branches for the year 2004, 2005, 2006

Accounting and Advisory Services and Auditor for corporate as per

Companies Act and Tax Auditors for corporate, non banking financial

companies, partnership firms and individuals as per Income Tax Act

System development and business process re engineering for manufacturing

company and automobile dealers

Executed multiples financial due diligence for companies in hotel sector

Key anchor for the formation of Public Company, capital market sub broker

and partnership firms

Project financing and financial consultant for corporate in manufacturing and

financial leasing sectors

Tax planning under direct (Income Tax, Wealth Tax) and indirect taxes (VAT,

Excise, Customs)

Advisors for foreign currency transactions across borders

Academics

Chartered Accountant (ACA), ICAI, New Delhi (2002)

Post graduation in Information System Audit (DISA), ICAI, New Delhi

Bachelor of Arts (Economics), Nagpur University, India (2001)

Best Regards,

Hitesh Madan

******.*****.*****@*****.***

Mob: +44-747*******

14

Contact this candidate