Project Oracle

Suvendu Mishra

Finance Functional Consultant - Oracle E-Business Suite

Oracle Apps:-Over 9+ years of extensive experience in analysis, design, development, implementation, Upgrades,

support and maintenance of Oracle Applications (ERP) 11i/ R12 which includes all Financial Modules ( Oracle

Payables, Oracle Assets, Oracle Receivables, Oracle Cash management, General Ledger, e-business tax,

purchasing, iProcurement, iReceivables &SLA ), Oracle Manufacturing & Distribution ( PO, OM, INV), I

procurement and I Expenses. Well experienced in identifying Gaps & developing Custom components as per

business requirements.

My experience includes 5 Full Cycle implementations and 3 Support projects and Localizations.

Finance Domain: - 4+ years in managing finance and accounting functions related to the Company and Support the

accounts head to meeting the finance and account management .To ensure financial and accounting standards and

procedures are complied with. Provide range of financial support to management. Supervise and support staff in

accounting & financial functions. Use judgment on routine functions and work with minimal supervision. Working as a

end user in Oracle ERP environment for more than four years

Email: ***********@*****.*** Mobile: Rwanda (Africa): +250*********

EXPERIENCE/SKILL SUMMARY

• Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in

various industries like Banking, healthcare, Manufacturing, aviation, and Pharmaceutical.

• Five full life cycle Implementations R11 & R12 with GL,AP,AR,FA,CE,iProcurement, iReceivables,

iExpenses, E-business tax and Sub ledger Accounting(SLA) .

• Solid understanding of integration of Oracle Applications modules, Multi Org, Reporting Currencies Setups,

Chart of Accounts, FSG, Budgets and Flex fields.

• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company

Accounting and MOAC.

• Designed process flows for each functional area during the implementation, carrying out requirement

gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.

• Expertise in AIM Methodology to enrich project management and documentation processes.

• Designed solutions to enhance standard oracle flows for Order to Cash(O2C), Procure to Pay(P2P), Assets to

GL, Inventory, GL Accounting processes.

• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements)

Implementation, Conversion, Data Migration.

• Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization, Reports.

• Wide experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Data

Conversion Management, Testing (unit/integration/system).

• Strong project management skills which include balancing multiple priorities with aggressive timelines and

budget initiatives.

• Ability to work in a team, worked effectively in a multi-cultural environment and good at learning and teaching

others.

• Excellent process orientation with analytical thinking and problem solving skills.

• Ability to prioritize and execute tasks in a high-pressure environment.

• Interpersonal skills, self-motivation, and quick adaption to new applications and technologies.

2

• Hard working, excellent in handling the team, aggressive in acquiring new skills, very innovative in

programming methodology, debugging skills and client interaction

Professional Experience

Company Designation Years of Exp Projects

Mahindra Satyam Computer Project lead Working Electronic Arts, Qatari Diar, Tesco,

services Ltd. since Balfour Beatty, MAJID AL FUTTAIM

July’2008 PROPERTIES. National Bank Of

Rwanda.

Polaris Software Lab Ltd. Senior Functional 2 Years Action Construction Equipments, GE

Consultant CoE Mercury

Sonata Software Lab ltd. Functional 1 Years Su-Kam Power System Ltd.

Consultant

iGenix Technologies Functional 1.5 Years Visaka Industries Ltd.

Consultants

Transaport Corporation Of India Sr .Supervisor 3.5 Years Finance Domain

Ltd Finance&

secretarial

Education

B.Com (Hons)

ICWA

Technical IT Skills

GUI Tools : Form 6i, Report 6i

Microsoft Technologies : Visual Basic 6.0, Visual FoxPro 6.0

Other Tools : Data Loader, TOAD

Project Management Tool : Microsoft Office Visio / Microsoft Project

Training and Certifications

Having Oracle University Workshop Certification AP/AR/FA/GL/CM Modules

Oracle Apps Project Details

Project-1 Oracle e-Business Suite R12 Implementation at National Bank of Rwanda, Africa

Project Duration: - From Jun-13 to till date

The National Bank of Rwanda is the central bank of the Republic of Rwanda Established to supervise and regulate the

activities of financial institutions notably banks, micro finance institutions, insurance companies, social security

institutions, collective placement companies and pension funds institutions and to support Government's general

economic policies.

• Performing Business Requirement Study in Financials and modelling Future Process Model and

preparing AS-IS (BP040) and TO-BE (BP080) documents.

Project-2 MAJID AL FUTTAIM PROPERTIES, Dubai:

Project Duration: - From 'July-12 to Jun-13

We were implementing Oracle e-Business Suite R12 Implementation in 12.1.0 version; Implementation

includes Financial, SCM, Projects, Property manager and HRMS modules. Multiple Ledgers were used with

Multiple Chart of Accounts. Majid Al Futtaim Properties develops, owns and manages world-class shopping malls.

The current operations span over 12 countries in the Middle East & North Africa region with over 24,000 employees.

Responsibilities:

• As an Oracle Applications Functional consultant responsible for effective delivery/implementation of oracle

Financials modules of Oracle Release 12 e-Business suite, in order to provide an integrated information system

solution.

• Facilitate and actively participate in all phases of the Implementation cycle, to include Requirements

Gathering & Analysis, System Design and Development, Testing, and Implementation.

• Assist clients in mapping and streamlining/reengineering business practices to implement various Oracle

modules, which include integrating the Oracle Applications with existing client systems, using standardized

implementation methodology including reports specification development and deployment.

• Responsible for developing and adhering to engagement team project standards to ensure the delivery of

quality client deliverables.

• Proficiency in Oracle E-business Suite in AP, AR, FA, CM, GL, iExpense and iReceivables with the good

understanding of finance module interfaces between Manufacturing with Distribution.

• Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training

and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, and FA modules.

• Expert in preparing RD020, BP040, BP080, BR100, MD050 and TE040 documents.

• Working experience in Oracle cost accounting concept.

• Team Player, responsive, organized

Project-3 Oracle Applications R12 Support at Balfour Beatty PLC, United Kingdom

Project Duration: - From 'July-11 to July-12

Balfour Beatty, a global infrastructure group operating around the world - designers and planners, engineers,

builders, project and facilities managers, analysts and consulting.

• Testing modules setup for inconsistencies and missing steps-Test scripts and Users Acceptance Test (UAT)

• Adhering to the Issue Ticket’s SLA and keeping up the Customer Satisfaction Rating to the agreed level

• Handling PMO calls and updating the Patch / Change Request needs

• Working with internal Product Support Team and performing the Patch analysis.

• Performing quarterly Patch Testing with the critical Business scenarios and ensure there is no adverse impact

by the Patch.

• Updating and Maintaining the Unit/Integrated Test scripts time to time.

• Root cause analysis on daily business transaction issues in the form of tickets that will be logged in by the

business users.

• Troubleshoot & Analyze, Functional Testing (Fixes), Provide functional solution

• Be able to cope with multi-tasking assignment excellent analytical, interpersonal and communication skills.

Project.4. Oracle Applications R12 Implementation Support at Tesco Bank and Retail

Project Duration: - From July-10 to Jun-11

One of the world’s largest retailers with over 530,000 employees serve millions of customers a week at stores and online.

• Prepared Functional design documents for customizations/conversions using AIM methodology.

• Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the

solutions in terms of Customizations, workarounds, reengineering and form personalization.

• Create end user training documents with detail instructions based on the business processes and provide

training.

• Customization designs and work around for various business requirements in R12

• Analyzing the issues on Production System and resolving them.

• Testing the functionality of new enhancements for new entitles in R12 (brazil entity).

• Coordinating the Cross Functional teams for customizations and calling out key issues .

• Good understanding in Handling (Analyzing, Debugging and Fixing) the Production Issues.

• Giving the overview on functional modules to technical team. Also willing and has a penchant for Pre-sales activity

• Performed Unit testing, UAT and End-User training for Go-live.

4

• Excellent Interpersonal skills, importantly good communication skills and ability to provide motivation and

open to new and innovative ideas for best possible solutions.

• 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.

• Assist technical team in the development reports, conversions, interfaces and extensions for Oracle

Applications

• Experience in analyzing/collecting the business requirements, designing technical design documents,

developing the Open Interfaces, Reports and migrating to Production systems.

Project-5 Oracle e-Business Suite R12 Implementation at Qatari Diar Real Estate Investment Company

Project Duration: - From 'Oct-09 to Jun-10

Responsibilities:

• Consult with and translate user defined requirements into functional design documents. Prepare business

procedures, gap analysis and other documentation following AIM methodology. Prepare test scenarios, test

scripts, data sets for the 12.1.3 and database upgrades

• Business Requirements Mapping for AR, AP, FA, GL and CM modules. Performed GAP analysis and prepared

solution design presentation for review.

• Prepared ASIS and TOBE Document (BP040 & BP080) mapping document (BR.30), Testing Document TE040

and Setup Document (BR.100).Security Matrix (BR112)

• Configuration of all Financial Modules (Payables, Receivables, Fixed Assets, Cash Management,e-Business

Tax, i-expenses, and General Ledger.)

• Worked on SOX auditing wherein worked with SOX consultants of PwC to submit proofs that ERP

implemented is SOX compliance

• Data Migration from legacy system to Oracle financials for Payables, Receivables, Fixed Assets and General

Ledger.

• Consolidation ledgers are used to consolidate financial transactions.

• Revaluation and Translations, intercompany consolidations and Budget.

• Mass Allocations and Recurring Journals

• Prepared FSG reports for Income statement and Balance sheet.

• Designed customized reports, fit gap analysis, and all documentation and deliverable

• Facilitating end-user training and developing the various user manuals

• Post implementation support for financial modules.

Project-6 Oracle Applications e-Business Suite Support - Electronic Arts

Project Duration: - From July-08 to Oct-09

Responsibilities:

• Business User Interaction, Customer facing, Restoration of services and resolution of tickets

• Functional Expert in the respective service lines & analysis, solution and root cause analysis on daily

business transaction issues in the form of tickets that will be logged in by the business users.

• Carry out Non-Incident related regular support tasks like gathering requirements from business users for new

custom components and coordinating with development team in developing, testing and migrating the same

within the specified timelines.

• Co-Ordinate with Track Leads / Onsite Global team to make sure that the issues raised by his

• Co-ordinate with other 3rd Party AMS teams for Incident management Responsible for Regional Daily Status

Review Meetings. Co-ordinate with Oracle Product Support on Technical TAR’s Work with EA IT and Business

on Prioritizing the Detracts / UAT

• Accountable to ensure that customer's service requests and tickets related to the Oracle applications and

linked systems are completed in a timely manner, as per established

• Root Cause Analysis, User discussion and providing alternative resolutions. Documenting the

Comprehensive Issue Descriptions and Resolutions.

• Good Communication skill, presentation with strong interpersonal skills and having experience in Team

leading, Team Management and Co-Ordination

Project-7 Oracle Applications e-Business Suite Support GE Corporate – CoE Project

Project Duration: - From Apr-07 to July-08

• Analyzing requirement & identifying Scenarios Meeting the Steering committee time to time and update the

status/risks of the project.

• Creating test Scripts to test the scenarios and prepare test plan to execute in quality center.

• Preparation of Project Document, such as Test Scripts, Process Flow Document, Input data document .

• Giving KT to the team of end-users.

• Creating Requirements in Quality Center in various modules: Test Plan, Test Lab, and Requirement.

• Identify the Turnkey components to match the flow and Mapping the Scenarios with the Business

Requirements.

• Created Requirements in the Requirement Module and testing various scenarios in the Development Instance

and verify result of the execution.

• Participating in the Status Update Meetings with the Client and with the Onsite Lead. And Co-ordination with

Team in resolution of defects based upon the priority assigned

• Tracking all the Open issues and allocating to the team based on severity level.

Project-8 Oracle e-Business Suite 11i Implementation at Action Construction Equipments, Faridabad, India

Project Duration: - From Dec-06 to Apr-07

Responsibilities:

• Analysis and identify the functional requirement of client and maintain its visibility throughout the

implementation

• Understanding the organization’s business process and aligns them with business requirements and applicatio

n to be implemented and Representation of all the business functions within a defined scope

• Generated operational analysis questionnaire based on the documents and business processes information gi

ven by the Client Company

• Documenting the main setup steps, definitions and implementation issues according to Application Implement

ation Methods

• Documenting of Current Baseline (RD-20), Future process (BP -80), Business Requirement Mapping (BR-30),

Application Set up (BR-100)for All Financial Modules

• Set-ups for Financial Modules AR, AP, FA, GL, CM

• Finalization of chart of accounts and finalization of reports for finance Modules

• Providing functional inputs to the technical resources for report customization

• Generated test scripts based on the business process of the client and worked on the unit (module) testing

• User Training and Acceptance & Customization Documents using Life Cycle implementation standards

• Performed Testing for various operations like Creation of Journals, Posting the Journals, Reversing the Journa

ls etc in the Testing Environment

Project-9 Oracle e-Business Suite 11i Implementation at Su-Kam Power Systems Limited, Gurgaon

Project Duration: - From Oct-05 to Nov-06

Responsibilities:

• Involved in Business Study of all financial modules and prepare Documenting of Current Baseline (RD20),

Future process (BP -80), Business Requirement mapping (BR-30), Application Set up (BR-100) for GL, AR

• Preparing of Requirement Analysis. Definition, Functional, User Training and Acceptance & Customization

Documents using Life Cycle implementation standards. Business process analysis, mapping of business

requirements and GAP analysis

• Prepare process analysis questionnaires for the client and incorporate the feed back into the task.

• Provide application support to end users for the existing implementation & providing functional inputs for the

custom reports development.

• Generated test scripts based on the business process of the client and worked on the unit (module) testing.

• Providing functional inputs to the technical resources for report customizations

• Involved with business users in preparation of Design documents.

• Preparing of Requirement Analysis Definition, Functional, User Training and Acceptance & Customization

Documents using Life Cycle implementation standards.

• Data Migration from CRP instance to Production instance

6

• Extensive use of Data Loaders for Data Migration from Legacy to Oracle Apps.

Worked as an Associate Consultant and as a co-coordinator to provide support at Oracle e-Business Suite 11i

Implementation at Visaka Industries Ltd

Duration: Apr-04 to Oct-05

As a Associate Consultant-Support, was responsible for

• To get the design document from Client and review that with them. Pass the same to team and clarify any

issue if they have on that document with Client.

• Coordinating between various teams involved in the total support cycle

• Preparing Test Procedure Document and Test Cases and Support for functional issues & preparing the status

reports daily & weekly

• Defining and analyzing the period end process and reports and taking the necessary step to close the periods

• Creation and follow up of Technical Assistance Requests (TAR) with Oracle during setting up and testing of

Development, Test and Production instances

• Generated test scripts based on the business process of the client & worked on the module testing.

• Accepting the Calls and Yanking the Issues and providing timely Resolution of issues faced by users

• Documenting the Comprehensive Issue Descriptions and Resolutions. Performed Testing on various

processes like Creation of different types of Invoices, Payment processes and the application of Prepayments

against the Invoices etc

Finance Executive – Transport Corporation of India Ltd.

Worked as Sr. supervisor Finance & Secretarial for Transport Corporation of India Ltd Reporting to Vice President -

Finance & Secretary from Sep 2000 to Jan’2004 looking after Accounts/ Finance/ Banking operations at

Corporate Office.

Duration: Sep 2000 to Jan’2004 – 4 Years

Key Deliverables:

Preparation of Finance Report /Fund Position Report/Treasurer Report.

Preparation of daily Cash flow statement / bank position report and regulate the utilization of CC limits

Payable management, Credit Monitoring & Management Information reports

Monitoring mobilization of funds / Implementation of cash management system / reduce the cost of borrowing

Support IT team for resolving the issues raised on all financial modules

Making Management Reports like, Daily Collection report, Debtors Age wise report, Weekly Sales Report and

Variance Reports in various issues etc.

Payment and reconciliation of Vendor accounts/ clarify the query from vendors etc.

Inter branch Accounting and Reconciliation. /Transfer the month end balance as per inter branch reconciliation

Monitoring Revenue Collected, fund transfer with regional offices, controlling and branches /Payment towards

Regular and Routine expenditures

Monitoring Accounting & Reconciliation of TDS on contractors/professionals/ rent and generation of monthly

report for filing the same

Through examination of transactions recorded in books of accounts like Cash & Bank Statement, financial

Ledgers, Inter branch and other accounting reports adhere to the standard of accounting procedures as per

the Finance & Account Manual of the Company.

To ensure that the books maintained are regularly reconciled according to the auditable standards at any

point of time

Closely Monitoring of accounts of banks update bank reconciliation on daily basis and take necessary action

on cheque returns /pending entries/rectification entries / communication with bankers regarding unexplained

debit and credits and on various issues.

line banking & manage the banking relationship on various matters

Study on financial Resources and application of funds, Preparation of Financial Statements, Report

generations. Company performance analysis and designing of Key indicators and reporting to the business

area the company financial operations, Profitability index ratios.

Contact this candidate