PROFESSIONAL SUMMARY

**+ years of Oracle Financial Application Experience as an Oracle lead consultant, Oracle Senior Financial Functional Consultant, and as a Business Analyst.

Around 12 years of experience of leading successful implementation teams

Oracle Certified consultant in Fusion Financials

Oracle Certified Financials Implementation Specialist in GL and Certified Oracle Financials Expert consultant in Procure to Pay cycle in Oracle R12

Have been part of many Full Implementation cycles of AR, AP, GL, CM, PO, EBTax, FA, iProcurement, Revenue Management, Project Modules (Costing & Billing), INV, WIP, ICM, OTM in Oracle Ver 11i, 12.0.4, 12.1.3, 12.2.3 etc

Configured SLA, EBusiness Tax, AGIS, AME, Financial Statement Generator(FSG), Report Manager etc

Extensive experience in Procure to Pay and Order to Cash cycles

Extensive experience in requirements gathering, mapping requirements, application setup, application testing and conducting User training

Excellent Experience in leading implementation teams, documenting Business Requirements, developing solution designs and prototypes, documenting functional specification of RICE components, User training manuals and test cases, preparing system integration flow and discussion with business users and in using Oracle AIM tools and Methodologies

Good Experience in writing successful RFPs, Proof of Concepts (POC), Master service agreements (MSA), Statement of Work (SOW), Business Process document-BP080, Application setup document-BR100, Functional requirement specification-MD050, Functional and System Integration test cases-TE020 etc

Involved in the presales activities, preparation of project management and risk assessment deliverables

Excellent team player and possess good technical, analytical, interpersonal and communication skills.

Self motivated, Organized, detail oriented and a quick learner with positive “can do” attitude.

Underwent Oracle cloud financials training and possess Indepth Knowledge and hands on experience in Oracle cloud Fusion Financial Modules

Knowledge in Oracle Modules – GL, AP, AR, FA, CM, ICM, EBTax, AGIS, Treasury, PO, iProcurement, Project costing and billing (11i and 12i), INV, WIP, Revenue Management and OTM 5.5

Knowledge in writing SQL queries using TOAD and SQL Developer

Knowledge in using testing tools like HP quality center, Oracle test manager, OBIEE etc

Worked in other ERP products like Workday, Netsuite, Planview, Open air etc

Currently doing Financial modelling course with Fintree and Preparing for other Oracle certifications

EXPERIENCE

TECHNICAL SKILLS

Application

Oracle E-Business Suite Version 11i & 12i – GL, AP, AR, OM, FA, CM, ICM, Treasury, EBtax, AGIS, PO, iProcurement, WIP, INV, Revenue Project costing and billing

Oracle Transportation Management Version 5.5, Open air, Netsuite, Planview, Workday

Languages

C, C++, PL/SQL, Java

Business Modelling Tools

MS Visio, Camstudio, Webex

Application Tools

Oracle Business Intelligence Reporting tool OBIEE Ver 11.1.1.7, Oracle SQL Loader, Report Manager, Toad (Ver 11), WinSCP, PM Smart, PVCS, HP Quality Center V10.0, HP project and portfolio management center V7.5.0, Maestro Job scheduling console V8.3, Oracle Test Manager 12.4.0. 2.0

Other Tools

MS Office Suite, Adobe Suite, Bullzip

Methodologies

AIM, RICE, ASM, Prototyping, SWOT and Cost/Benefit Analysis

EDUCATIONAL QUALIFICATION

BE (EEE), Madurai Kamaraj University

MBA (Finance and Systems), School of Management, Pondicherry Central University

PROJECT EXPERIENCE WITH KEY HIGHLIGHTS

Finastra Aug 2015 – Current

Project: Implementation and support of Oracle Financials, Project and distribution modules (12.2.3) and Fusion Financials

Role: Senior Enterprise Application Business Analyst

Finastra (Earlier D+H)

Finastra is a financial technology company based in London. The firm was formed in late 2017 through the combination of D+H and Misys, after Vista Equity Partners acquired Misys in June 2012 and subsequently purchased D+H in 2017.

Project Description:

This project involves implementation and post production support of Oracle Financials, distribution and project modules

Lead the implementation team right from Requirements gathering till Go-Live and Post Production Support on the Oracle Financial, Project and distribution modules

Involved in various phases like Requirements gathering, Fit gap analysis, Application setup, Functional design, testing, user training, roll out (US,CA, EMEA, APAC regions) and post production support

Involved in the documentation of the above phases like Business Process document, Fit gap analysis document, Functional design document, application setup document, user training document, system integration and functional test cases etc

Involved in Ledger configuration, GL code setup, cross validation rules configuration, vendor master setup, customer master setup, project master setup, project auto accounting rules setup, Service contract setup, iProcurement setup etc

Involved in Tax setup for US sales tax, Use tax, HST and PST for Canada, VAT & GST for India

Involved in revenue recognition rules setup like cash basis, payment term basis etc for recognizing the revenue

Involved in the development and testing of various custom report dashboards for receivables, payables, HR, fixed assets, general ledger trial balance reports, AP and AR aging reports, system admin reports etc using Oracle business intelligence reporting tool

Lead various enhancement projects like Cost center consolidation project, Per Diem Expense report implementation, India GST Implementation project, Oracle Hyperion Integration, Oracle Workday Integration, Oracle Netsuite migration project, Setting Approval Hierarchy for Oracle journal approvals, expense approvals, requisition and PO approvals etc, Oracle-Oanda exchange rate integration project, Oracle Migration project from IBM hosted environment to Finastra Inhouse environment

Worked on data extraction and reconciliation of subledger transactions, month end period close issues like fixing transactions with revenue recognition issues, journal issues, project period close issues, approval rerouting issues, Receivables and Payables period close issues etc

Worked on cost center consolidation project that involves terminating old cost centers and recreating new cost centers, mapping old and new cost centers through and updating all the open transactions with new cost centers, updating fixed asset accounting entries etc

Worked on setting up Per diem expense setup and roll out across all countries

Lead the team for migrating Oracle from IBM hosted environment to Finastra environment, involved in extensive planning and execution till user acceptance testing and sign off

Lead Oracle Hyperion Integration project integrating Oracle GL code and balances to Hyperion

Extracted customer and vendor master data, Journal details, transaction data and performed subledger data reconciliation with trial balance reports

Involved in the integration of workday data from workday to Oracle, employee and cost enter integration between workday and oracle etc

Worked on delegation of approval authority matrix (DOAA), setting up purchase, requisition, journal and expense approvals etc using AME

Worked on other Integration projects like exchange rate integration with Oanda, Oracle-Open air integration etc

Training the users on various modules like receivables, payables, fixed assets, revenue management, general ledger, expenses, procurement and purchasing modules etc

Supported year-end audit reporting and enhancements like 1099 reporting, Israel and India local tax reporting etc

Involved in the ticket handling and issue resolution of Oracle related support tickets using EPIC-Inhouse ticketing tool

Involved in the prototype and planning phase of implementing Oracle cloud fusion financials for various modules like receivables, payables, general ledger, purchasing, fixed assets, revenue management, project (costing & billing), iexpenses, iprocurement, service contract etc

Involved in the oracle cloud financials instance setup involving setting up business units, functions, COA structure, reference set, functional setup manager setups etc

Involved in the testing of various subledger and GL transactions in cloud fusion financials

Involved in the resource and timeline planning of cloud fusion financials implementation.

First Tek Inc May 2012 – Jul 2015

Client: Akamai Technologies

Project: Implementation of Oracle Financials and distribution modules (12.1.3)

Role: Lead Consultant

Akamai Technologies is a global service provider of software and storage space services with a major presence in APAC, EMEA, and North America regions.

Project Description:

The project is a reimplementation of Oracle financials and distribution modules for APAC, EMEA and North America regions

Actively involved in O2C and EBTax implementation right from business requirements till Go-Live

Researched and analyzed business requirement from business users to create documentation

Documented business requirements for Revenue recognition, AR, CM and EBTax modules

Configured AR, Revenue recognition, CM and EBTax modules for implementation

Involved in the demonstration of the Oracle module functionality for CRP1 and CRP2 phases

Configured use tax for US, GST, HST and PST for Canada

Configured Location based, Account based tax rule setup using EBTax rules engine

Involved in the requirement analysis and configuration of VAT for 20 countries

Configured Cash management module for all countries

Configured staged and days overdue dunning templates

Planned and executed cutover activities for AR, CM and EBTax

Proactively identified issues related to EBTax during cutover for AP and AR

Prepared functional design document for bank statement reconciliation for Lockbox, Use tax reporting requirement for ABI

Prepared functional design document for Month end process for revenue accruals, revenue reclassifications, revenue allocations and marketing development fund as part of Revenue recognition

Involved in AR Refund processing, AP-AR Netting of AGIS transactions, AR adjustments and write offs, Document sequencing requirements etc

Provided support during various development and testing phases

Resolved AR, EBTax and Cash management issues throughout the implementation

Client: Cummins Inc.

Project: Implementation of Oracle Financials and distribution modules (12.1.3) and Siebel

Role: Lead Consultant

Cummins Inc., a global power leader, is a corporation of complementary business units that design, manufacture, distribute and service engines and related technologies, including fuel systems, controls, air handling, filtration, emission solutions and electrical power generation systems

Project Description:

Phase I: DBU Oracle Implementation: The project is the implementation of Oracle financial and distribution modules for Belgium, Norway, Sweden and Romania

Phase II: DBU Oracle implementation 1.2: The project is the implementation of customer facing OM, service contract, Oracle projects, Internal service job, Item master requirements, Vertex, AR Lockbox and bank statement interface, AP Payments etc

Researched and analyzed business requirement from business users to create documentation

Configured GL, AP, AR and CM modules for Phase 1 implementation

Resolved post production issues for Financial modules in Document sequencing, Warranty Claims, Order management, Receivables, Payables, Ebusiness Tax, General Ledger etc for Phase 1 implementation

Resolved period close issues for financial modules in create accounting, in chart of account mapping etc for Phase 1 implementation

Analyzed Service contract financial requirements and documented gaps for the requirements for Phase II implementation

Involved in the requirements gathering for Project costing and billing modules

Configured Project costing and billing modules for Client Demo of Projects module

Analyzed project requirements and performed fit-gap analysis on the requirements

Analyzed various options of revenue recognition process like invoicing and accounting rules, revenue account management, contingency rules and event based revenue recognition etc

Designed Service contract finance flow from Siebel to EBS

Prepared solution design document for Service contract finance flow to EBS

Prepared functional design document for Deferred revenue report, COGS recognition process, revenue recognition process as part of Service contract finance flow

Prepared solution design and functional design documents for Core accounting flow which overrides auto accounting in AR and derives revenue account in AR based on Quality plan

Prepared solution design on Internal service job in OM

Configured SLA for revenue accounting based on parts, labor and miscellaneous lines

Software Galaxy Systems LLC Feb 2011-Apr 2012

Client: McGraw-Hill

Project: Implementation of Oracle Financials (12.1.3) as a replacement to Lawson Systems

Role: Lead Consultant

The client’s business spans the fields of financial services, education, and business information with leading brand names such as Standard & Poor's, McGraw-Hill Education, Platts, and J.D. Power & Associates.

Project Description:

Phase I: Project Atlas Lawson replacement: The project is a replacement of Lawson Financials with Oracle Financials (12.1.3) solution and Integration of Oracle Financials with McGraw-Hill’s Legacy systems for McGraw-Hill Corporate Company and McGraw-Hill Education. The modules implemented are GL, AP, AR, FA, CM, PO Project costing, iProcurement, iSupplier portal and iExpenses

Phase II: Project Atlas Logical Separation: The project involves implementation of split between McGraw-Hill Financials and McGraw-Hill Education. The modules implemented are GL, AP, AR, FA, CM, PO, iProcurement, iSupplier portal, iExpenses and Project costing

Phase III: Project Atlas HSS: The project involves implementation of split between higher profession education and School education group under McGraw-Hill education. The modules implemented are AP, AR and GL

Phase IV: Project Atlas Physical Separation: The project involves implementation of Hard split between McGraw-Hill Financials and McGraw-Hill Education in two physically separate instances. The modules implemented are GL, AP, AR, FA, CM, PO and Project costing

Phase V: Project Atlas PCR implementation: The project involves replacement of Global CSV Format into XML format for SEPA, replacement of Citibank credit cards with AMEX card transactions, replacement of Citibank payment with HSBC payment in xml format etc. The modules implemented are AP and CM

Responsibilities:

Researched and analyzed business requirements from Business Analysts to understand the client’s request in order to create documentation.

Prepared business requirement documents on GL, AP and AR modules

Configured GL, AP and AR modules

Worked in GL ledger configurations, security and cross validation rules, revaluation, translation and consolidation, AP Payment configurations, Bank account setups, AR receipt method and lockbox configurations

Designed GL Lawson-Oracle translation engine, GL outbound COA interface extracts, Financial statement generators etc

Designed GL web reporting for account validator and translator, Financial statement generator (FSG) and other custom reports

Defined Sub ledger accounting rules(Account derivation rule) for custom journal line type AP accrual, AP liability account(Automatic offset at account level), Item expense account, Tax and withholding tax account etc

Designed AR auto lockbox interface for Citibank, Bank of America, Wells Fargo bank etc

Designed entire Procure to Pay process flow and the interfaces

Designed AP payment files for SEPA payment and HSBC payments in XML format

Designed AP Invoice interface and Payment files for Deutsche bank bottom line checks, ACH and wire payments

Designed and tested AP EDI Invoice interface for EDI 810 format

Prepared End to End Flow process documents for each modules(GL, AP, AR, FA, CM, PO and Project costing) which encompasses the overall functional, integration and cross functional flow for all modules

Lead the Team and provided support and guidance to the team for all modules GL, AP, AR, FA, CM, PO and Project costing

Develop and execute SQL queries using Toad to retrieve data for business users for invoice interfaces, vendor extracts, payment interfaces and also as part of period close and reconciliation activities

Involved in AP Period close and reconciliation activities for about 120 ledgers

Evaluate the development effort for all the phases and System Change Requests (SCR) etc.

Participate in project status meetings, meetings with business analysts, users, other IT technical staff and testing team.

Manage requirement changes and defects during the life cycle of each project.

Awarded with WIPRO ‘Feather in the CAP’ award for outstanding performance in the project

HCL Technologies Jun 2005-Nov 2008

Apr 2010-Jan 2011

Client: AIG Insurance

Project: Implementation of Oracle Financials (12.1.2) and eBaoTech General System (Insurance Software)

Role: Senior Consultant Duration: Apr 2010-Jan 2011

The client is a leading international insurance organization with operations in more than 130 countries and jurisdictions. The client serves commercial, institutional and individual customers through one of the most extensive worldwide property-casualty networks of any insurer. In addition, the Client companies are leading providers of life insurance and retirement services around the world.

Project Description:

The project is an implementation of Oracle Financials (Ver 12.1.2) and eBao Tech General System and integration of these modules using SOA/BPEL as middleware. The approach is to use eBaoTech for General Insurance activities like underwriting & claims processing, policy issuance and premium collection activities and Oracle E-business suite-Financials & Purchasing (12.1.2) for the company’s financial business needs. The financial modules implemented are GL, AGIS, AP, AR, FA, CM and PO.

Responsibilities:

Participated in Client discussion in understanding their current business process, identifying the gaps and providing the future business process flows (BP080)

Participated in Solution design and Gap discussions with business users

Preparation of business requirement document for the client’s Financial process (For Oracle Financials -GL, AP, AR, FA, CM) and Integration process(Between Oracle Financials and eBao tech)

Created functional design specification documents(MD050) and ensure the translation of business requirements to technical staff are incorporated into system design

Worked in Procure to pay cycle process flows and related interfaces

Lead the functional and technical team, mentor the consultants and track the team’s deliverables for completion of Project activities on time

Setup Multiple Organizations, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets Cash Management and AGIS in development instance, SIT, UAT and Training Instances

Prepared Application setup documents (BR100) for financial modules

Configured Financial Statement Generator and Report Generator to generate Financial reports like Balance sheet, Profit and Loss statements etc

Configured Subledger Accounting Method to facilitate multi period accounting to split the expense recognition for different periods

Configured Approval Management Engine to facilitate requisition approval and invoice approval

Developed business scenarios(Test cases) for testing the standard application functionality of Oracle Financial modules (GL, AP, AR, FA, CM) and customizations

Tested standard functionalities, custom components and integration touch points (between eBaotech, mFund and Oracle Financials)

Prepared User Training Manuals and conduct End User training to the Client’s Business Users and IT team

Client: New Jersey Manufacturers Insurance Company

Project: Implementation of Oracle Financials (12.0.6) and Guidewire Insurance suite (Insurance Software)

Role: Senior Consultant Duration: Apr 2010 –Jan 2011

The client is a cost-conscious insurer with a unique history and philosophy of service to policyholders. Formed in 1913 by factory owners who wanted to purchase insurance from a reliable, local safety-oriented carrier, the Company has earned a reputation for efficiency and integrity

Project Description:

The project is a collaboration and implementation effort with Guidewire Software’s Claims Center. Implemented software includes Oracle Financials (Ver 12.0.6) and Guidewire Insurance suite modules and integration of these modules using SOA/BPEL as middleware. The approach is to use Guidewire Insurance suite for the client’s underwriting and claims operations and Oracle E-business suite-Financials (12.0.6) for the company’s financial business needs. The financial modules implemented are GL, AP, AR, FA, and CM.

Responsibilities:

Analyzed Client’s existing business against Oracle Financials capabilities and Guidewire Claims center’s capabilities

Demonstrated Oracle Financial functional capabilities to the Client for each of their business scenarios

Identified Gaps between the Client’s Business process and Oracle financial application and prepared future business process flows (BP080)

Documented the procure to pay process flow for the client and worked on the related interfaces

Created functional design specification documents(MD050) and worked with technical team to ensure that the technical development was done as per the specification

Involved in complex custom development scenarios like fund balance check before making payment, Policy & Claims Search Forms, bank statement upload etc

Setup Multi Org and Oracle modules(GL, AP, AR, FA & CM) for SIT and UAT Instance

Configured AGIS module and AP-AR netting to facilitate intercompany payments and receipts

Configured Financial Statement Generator (FSG) for Profit and Loss and Balance Sheet Statements

Prepared test scenarios for testing standard Oracle Financial components and custom components

Prepared End User Training manuals and conducted End User training for Oracle Financial Modules and custom components

Created User roles and responsibilities in Oracle Application

Client: UTi Worldwide Inc.

Project: Implementation of Oracle Financials (12.0.4) and Oracle Transportation Management 5.5(OTM 5.5/GLog 5.5)

Role: Senior Consultant Duration: Jun 2006-Nov 2008

The Client is an international, non-asset-based global integrated logistics company providing supply chain management and optimization solutions. The client services include air and ocean freight forwarding, contract logistics, customs brokerage, distribution, inbound logistics, truckload brokerage and other supply chain management services including supply chain consulting.

Project Description:

The project is an implementation of Oracle Financials (Ver 12.0.4) and Transportation Modules (Ver 5.5) and integration of these modules with the client’s Legacy and Third party systems. The approach is to implement OTM for operational and Oracle E-business suite for the company’s financial business needs. The financial modules implemented are GL, AP, AR, FA, OM, Trade management, Treasury, HRMS, Projects, Scripting Administrator and ICM. These modules are interfaced with the transportation module through BPEL technology. The Oracle modules are integrated with the company’s existing systems like Hyperion, data warehouse, business intelligence through an integration framework.

Responsibilities:

Bid Phase:

Analyzed client’s Operational and financial business requirements, Proposed Overall Implementation solution and Prepared SWOT analysis of Solution

Lead the Bidding solution team and monitored the tasks allocated to team members

Presented Overall solution to HCL’s Senior Management team

Proposal Phase:

Analyzed Oracle-OTM solution with UTi’s requirements in-depth with more accurate Fit gap analysis

Identified Project phases, Project deliverables and estimated Project cost and effort

Organized client visit and involved in discussions related to Project deliverables and Project effort estimate with client’s senior management team

Participated in senior management discussions between Client and HCL and involved in the preparation of Master Service Agreements(MSA), Statement of Work(SOW) and related deliverable documents

Awarded for winning the $35mn deal for HCL

Project Phase

Collaborated with Onsite and Offshore team in translating client’s business requirements to technical team

Prepared initial version of project management deliverable documents like project plan, risk assessment, project status report, traceability matrix

Identified Integration touch points between Oracle Financials and Oracle Transportation Management

Configured Integration scenario to test one complete cycle of OTM and Financials Integration from Shipment planning, shipment execution, Invoicing in OTM to Invoice creation in Oracle Payables

Designed the multi Org and General ledger structure for the implementation

Designed the overall solution for General ledger module

Designed intercompany process flow for AGIS module

Designed the procure to pay process flow and related interfaces

Involved in the preparation of Solution design and Gap fitment document deliverables for General ledger

Involved in the preparation of Solution design and Gap fitment document deliverables for Advanced Pricing module

Involved in demonstrating the Project costing and billing modules to the client

Demonstrated project interfaces to AP, FA and AR modules

Involved in the requirement gathering in Project costing and billing modules

Analysis on the feasibility of sub ledger accounting feature for shipment accrual accounting

Created functional design specification documents for new forms for General Ledger rent accrual and Asset accruals, customer and vendor master creation, for new/modification of custom report requirements

Setup MultiOrg, General Ledger, Payables, Receivables, Fixed Assets, Treasury, Cash Management, Projects and Internal Control Manager for development instance, CRP and SIT instance

Prepared Test cases and tested Oracle application standard and custom components

Prepared End User training manual and presentation documents

Explored R12 key features like MOAC, EBusiness Tax, AP-AR Netting, AGIS

Conducted training on R12 financial modules for consultants

Awarded for extraordinary effort and for showing positive energy throughout the project

Client: Teradyne Inc.

Project: Demonstration, Project scoping and consultation Inputs in Oracle Financials and ICM (11.5.10.2)

Role: Business Consultant Duration: Feb 2006-May 2006

The client is a leading supplier of Automatic Test Equipment. The client’s divisions Broadband Test, Assembly Test, Semiconductor Test, and Vehicle Diagnostic Solutions, are organized by the products they develop and deliver.

Project Description:

The client wanted to implement Oracle Financial modules along with Oracle Internal Controls Manager (Ver 11.5.10.2). The project is an analysis, effort estimation and demonstration of Oracle financials, ICM capabilities to the Client

Responsibilities:

Prepared Presentation on addressing Gaps between Client’s business needs and Oracle Financials

Analyzed Client’s SOX 404 requirements with Oracle Internal Controls Manager

Demonstrated Oracle Financials capabilities and corresponding Oracle ICM functional capabilities like Risk assessment & audit control procedure and Application monitoring mechanism to the Client

Organized client visit and identified key project deliverables and prepared the project cost-effort estimate against oracle financial modules

Provided support in resolving issues in 11i Oracle financial modules (GL, AP and AR)

Client: MSC Software Corporation

Project: Oracle 11i Functional Support for Global Software Company

Role: Business Consultant Duration: Jun 2005-Jan 2006

The client is a leading global provider of simulation software, with related services and systems, providing simulation technology and services to a broad spectrum of industries which include Aerospace, Shipbuilding, Automotive, Consumer products, Bio-technology, Plastics, Machine Tools, Metal Forming, Computer & electronics manufacturers and Universities.

Project Description:

This project was an implementation, global rollout and application maintenance support of Oracle Financial, Distribution and CRM Modules. The implemented modules were GL, AP, AR, FA, Projects and PO. Apart from implementation, application upgradation was also done for the client to migrate from 10.7 to 11.5.4.

Responsibilities:

Analysis Phase:

Study of the client’s implementation and upgradation processes and their existing billing and utilization frameworks in Oracle projects

Documentation of Client’s implementation and support issues in Oracle Financial modules

Analysis of the various factors influencing the support projects and the time taken to resolve them

Development of a framework showing the average time taken to resolve the issues under a specific category

Development of unique billing and utilization framework which ensures data completeness and eliminates data redundancy

Support Phase:

Resolved Client Support issues in Oracle Financial Modules-AP and AR

Coordinated between Client and technical team for handling technical issues of the application

Tested financial functionalities of the Oracle application

Awards

Oracle Financial Certified Implementation Specialist in General Ledger(R12.1.3)

Oracle Financial Expert consultant in Procure to Pay cycle (R12.1.3)

For winning $35mn deal of Oracle OTM and E-Business Suite implementation project

For

Contact this candidate