Project Oracle

Career Objective

To attain professional excellence through my Functional knowledge and

Experience in the areas of Finance, Accounts and ERP consulting by creating

an achievement oriented environment. To become a complete business solution

provider by implementing and managing projects. To work in an open,

exciting and professional environment having excellent growth prospects.

Core Competencies

. Experience on Oracle E-Business Suite R12 (General Ledger,

Account Receivable, Account Payables, Fixed Assets, Cash

Management, Sub-Ledger Accounting, Financial Accounting Hub).

. Experience on EBS integration with ODS, PeopleSoft, Hyperion and

Web-Methods.

. Expertise in Requirement analysis, Requirement gathering and

Documentations, ERP Configurations, Migrations, Testing and

Implementation.

. Working on Financial Modules General Ledger, AR, AP, SLA and

FSAH.

. Expertise in SDLC methodologies like AGILE, Waterfall.

. Have expertise in Oracle Financials Implementations based on

OUM/AIM methodologies.

. Involved in (MOAC) Multi-Org setups for multiple clients.

. Handled User issues / Production issues directly and guide them

on various modules of the system.

. Done end to end Set-ups / configuration in all environments

(Development, QA, UAT, SIT, GOLD and Production).

. Exposure requirement gathering and find out the Gap analysis.

. Exposure in documentations like MD 50, BR 100, TE040, FSDs, TSDs,

Test Cases, Business Process (BP), Training and Design Documents.

. Exposure in preparing business structures for client business and

design the multi org structure based on client requirement.

. Sound knowledge on Financial Accounting, Financial Reporting,

Procure to Pay (P2P) and Order to Cash (O2C) Cycles.

. Worked on ERP Implementation as well as ERP Support Projects at

client locations(onsite)

. Strong skills in Business Analysis with proven success in

analyzing and translating business requirement into functional

and technical requirements.

. Expertise on Business process modeling.

. Capable of thinking in and out of the box with innovative ideas

and solution to make efficient system architecture.

. Effective communication skills maintaining collaborative

relationship among stakeholders, customer and business unit.

. Expertise in End User Trainings and UAT.

. Involved in Period Close Activities, Job Monitoring, and Post go-

live support.

. Good Domain knowledge especially in Banking, Finance,

Manufacturing and Insurance.

. Expertise in working on tools like MS Office, Microsoft Projects,

TOAD, HP QC, Data-Loader, APPSLOAD, PL/SQL Developer, SQL

Developer.

Professional Summary

Overall 7 years experience out of which 3 years of Functional

experience in oracle GL, AR, AP, FA implementation and 4 year of

experience on SLA/FAH implementation and support project.

Education and Certifications

. Masters Certificate in Business Analysis from Villanova

University, Florida.

. Chartered Financial Analyst (CFA) from CFA institute, India.

. B.TECH (Hons.) from NIT Jamshedpur, India.

. Trained (Functional) on Oracle Financial modules (AR, AP, GL, FA

and CM).

. Certified in General, Property & Casualty Insurance.

. Certified SQL IZ0-007.

Achievements and Awards

. I worked for 5 projects which include 2 GL, AR, AP, FA

Implementation, 1 AGILE Project with CISCO and 4 SLA/FAH

implementation and support projects.

. Appreciation from VP on successful implementation of HRIT Project

in CISCO.

. Appreciation from SVP and VP on successful FAH/SLA implementation

in THE HARTFORD.

Experience

Employer: TATA CONSULTANCY SERVICES LTD.

Duration: Jan 2007 - Till Date

KNOWLES Electronics, Itasca, IL USA

Aug 2013 - Till Date

Role: Solution Architect / Functional Consultant (GL / SLA / AP)

Version & Modules: 11i to R12.1.3 Upgrade, GL, FAH and SLA and AP

Responsibilities:

. POC - Providing Solutions on Accounting Reclassification using

SLA features.

. POC - Primary Ledger, Secondary Ledger, COA structures

. Functional setup and configuration and Testing in R12 Development

and QA Instance.

. R12 User training and Presentations to Knowles Functional Team on

R12 Financial Modules.

. Understanding the existing functionality in 11i and helped the

Knowles Functional team during e2e configurations in R12.

THE HARTFORD Financial Services Ltd., Hartford CT USA

May 2011 - July 2013

Role: Functional Consultant / Functional Lead R12

Version & Modules: R12.1.3, GL, FAH and SLA

Responsibilities:

. Requirement Analysis, gathering and AS-IS sessions with the HIG

stakeholders, Finance Team and GL Admins.

. Understanding the existing functionality and financial data flow

from Sub-ledgers to GL and Hyperion.

. Developing new interface and coordinating with technical people

. Explaining Process and functionality to the technical team

. Understanding the integration involved in this project.

. Prepare the end to end solutions on POC instances for all

implementations and enhancements.

. Work as Liaison between TCS Off-shore and HIG Business Team.

. Prepared BR100, DS030, MD50, TE40, FSD and Business Process (BP)

for all implementations and enhancements as per AIM methodology.

. Mapping with Legacy to Oracle FAH.

. Functional owner for integration between Oracle GL and PeopleSoft

GL.

. Done E2E setup in Gold, UAT, QA, Configuration and Development

Instance. (Manual and Automated). (Total 78 Sub-Ledger systems)

. Done Oracle GL /SLA/FAH configuration along with the integration

with PeopleSoft through DVMs.

. Done Sub-Ledger setup / Template migration among different

instances through FND and AAD upload.

. Done code review for the customized packages to ensure the

requirement is correctly addressed through the prepared

executable.

. Done customizations using Custom Source, PL/SQL Functions, Look

ups and DFFs.

. Prepared Oracle Template for Mapping.

. Tested all end to end functionalities in financial modules.

. Tested on Period end and Financial Closure

. Troubleshooting Journal sub ledger transfer and journal import

issues

. Troubleshooting data issue fail during validation and Processing

stage (Event Creation and Accounting) with in FAH.

. Ownership for Warranty support and later enhancements (CR's).

CISCO System Inc. San Jose CA USA

Sep 2010 - May 2011

Role: Business Analyst / Solution Architect

Version & Modules: SABA, EMS

Responsibilities:

. Requirement Analysis- Requirement gathering, Feasibility analysis

based on SABA 5.4, Resolution of doubts faced by WIRE FRAME team,

requirement owners during Business Requirement Release. Key Role

during Concept commit and Executive commit from IT Analysis &

Solution team.

. Development (Deliverables) - GUI development, Test scenarios,

Business Requirement, Functional Requirement Document, Technical

Requirement, Training Material creation, Communication piece,

Data migration, Quality approvals for all the deliverables.

. Process modeling - Process / Application modeling on ARIS tool.

Use Case (TRD) preparation, Data modeling.

. Process monitoring - On going process monitored after deployment

using impacted production data, bug-fix or data-fix execution if

required for successful implementation of requirement in the live

system.

. Issue resolution with user Facilitating Data-fix/Bug-fix

activity, Analysis of CR raised, Enhancement sign-off with user

taking design & development concerns into account.

. Interface study while discussing the requirement with other system

owners, End to end verification on interface development.

. Policy sign-off, UAT & Final subsidiary creation in production,

. Communication with the end users.

TATA Elexi Mumbai INDIA

Jun 2009 - Sep 2010

Role: Functional Consultant / Functional Configurator

Version & Modules: 12.1.3, GL and SLA

Responsibilities:

. Responsible for handling activities involved in the end to end SDLC

process while implementing Oracle Applications (R12) AR, AP, GL, FA

and SLA.

. Responsible for all the documentation related to Requirement

Gathering, Solution Design & Testing and User Training.

. Financial/Projects Data Analysis and Migration into Oracle Apps from

Legacy system.

. Suggested and implemented the Secondary Ledger solution to handle

multi-period and multi currency reporting requirement of a subsidiary.

. Responsible for e2e OGL setup in Prod, UAT, QA and DEV instance.

. Handling the tickets, resolving the issues on day to day basis on

priority.

. Prepared CR Documents for any changes in Production Instance

. E2E Testing for GL and SLA in Dev, QA and UAT environment.

. Prepared Test documents for All issued and keeping in Share point

. Getting inputs from Users and resolved issues based on priority.

. Done setup configuration for finance modules in all instance-

DEV,QA, UAT and PRODUCTION.

. Suggested to technical consultants for Customization objects.

. Raising the SR to oracle when the issue is critical and follow up

with DBA Team

. Testing thoroughly issues and providing solutions to the end

users

. Prepared Impact Analysis documents and delivered to the Client

TATA E-SERVE Mumbai INDIA

Jan 2007 - May 2009

Role: Financial Functional Analyst / Product Configurator

Version & Modules: 11i and R 12.1.3, - AR, AP, FA and GL

Responsibilities:

. Working on the project by using AIM methodology

. Prepared Business Process documents based on client

requirements(BP80)

. Prepared training documents for CRP1 and CRP2.

. Prepared data migration documents for all financials modules

. Prepared documents for UAT and Test scripts.

. Prepare other project Documents like TE-40, BR-100, MD-50.

. Requirement Gathering and Configuration for AR, AP, GL Modules

. Configured various setup's in GL - Accounting calendar,

Currencies, chart of Accounts, Ledgers, Cross validation

segments, Segment Security Rules, Auto Post criteria, Reversal

Journal, Recurring Journals, Journal Sources & Categories,

Suspense accounts, Intercompany Accounts & Budgets, Financial

Statement Generator.

. Configured various setup's in AP - Supplier Creation, Setting up

Financial, Payables options, Payment Terms, Distribution sets,

Payment formats, Employee Expense Management and Supplier Bank

Creation

. Participated in System Integrated Testing, Regression &

Conversion (instances) Testing.

. Setting up Financial, Payables options, Payment Terms,

Distribution sets, Payment formats and Document sequencing.

. Setting up Data Access Set & Definition Access Set.

. Defining the Ledgers and Ledger sets

. Trained End users & conducted UAT.

. Handled Post Implementation Support for GL, AP and FA.

. Interacting with technical consultants & DBAs.

. Prepared End user Manuals & Deliverable documents

. Supporting and solving day to day end users problems.

. Report to Management on the status of the developments.

. Testing new business requirements in the Test Instance and

validating the same in Production.

. Raising the SR to oracle when the issue is critical.

. Preparing and Reviewing Functional specification and

understanding about Customizations to provide KT to Team members.

. Supporting on Day to Day operational issue on financial modules

. Troubleshooting Journal sub ledger transfer and journal import

issues

. Helping customer on sub ledger and General Ledger balances

reconciliation.

. Supporting on day to day end user issues

. Supporting on Period end and Financial Closure

Contact this candidate