Oracle EBS Technofunctional Finance

Khushbu Bhatia +1-513-***-****

Email: - *******.******@*****.***

Experience Summary

Around 9 years of experience with Oracle EBS as techno-functional Finance Consultant. Coming from a technical background, have developed sound functional knowledge in Oracle Applications Financials and its reporting. My latest responsibilities were as a Functional Consultant for an offshore team for Implementation, Configuration and Production support of Oracle e-Business Suite Applications - R12, managing financial modules such as – Accounts Payables, Accounts Receivables, Fixed Assets, General Ledger, which includes the system study, design, development, post implementation maintenance and support of Oracle EBS.

Employment Summary

Dates

Role

Jul-2012 till Dec-2016

Oracle EBS Configurator for R12 for AR, AP, GL, FA and SLA

Nov 2011 till Jun-2012

Business Analyst for Ultimatix- Enterprise reporting for Billing, Costing and HR – RMG

June-2010 till Oct -2011

E2E Test Manager for Oracle EBS - Financials for British Telecommunications at Onsite (Ipswich - UK)

Mar-2007 till May-2011

Oracle EBS Technical developer and also deputed as a project lead working in ERP domain-Oracle EBS support for Ultimatix.

Professional Summary

Extensive experience in Configuration, Migration, Customization, Production and Support of various modules in Oracle Applications with General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Fixed Assets(FA).

Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.

Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions).

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

Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay(P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.

Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).

Expertise on designing and implementing Oracle Alerts and Lookups.

Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.

Collaboration with the Business users during the various stages of project lifecycle.

Wide experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Configuration, Data Conversion Management, Testing (unit/integration/system).

Expertise in post implementation support, prepared training manuals and also trained end users.

Excel in team collaboration, quick adaptation and problem solving with good communication skills.

Experience in handling customer facing issues which requires high interaction and co-ordination with various teams across the platform

Key Competencies

Tools

PL/SQL Developer, Forms and Reports builder, XML gateway, XML Publisher, Workflow builder

Oracle E-Business R12.0 Financials

Extensive experience in Configuration, Migration, Customization, Production and support of various modules in General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO) and Fixed Assets(FA)

Software Products

Oracle 10g/11g/12c, Oracle Apps 11i/R12

Educational Qualifications

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Customer

Scandinavian Airlines System

Period

Jul-2012 till date

Description

Scandinavian Airline system is the major carrier of Denmark, Norway, and Sweden, is the largest airline in Scandinavia and as a part of the project we deployed a globally accessible cloud based platform, which had enabled integrated and standardized operations across all business units.

Project involved implementation and support of Oracle EBS finance modules - General Ledger, Receivables, Payables, Fixed Assets and custom cash Management Module for reconciling the bank statement to AP and AR.

Location

Mumbai, India

Roles Played

Oracle EBS Configurator for Finance

Solution Environment

Oracle Applications R12.0

Oracle 11g

Tools

PL/SQL Developer, Data loader, SVN, Forms and Reports builder, XML Gateway, XML Publisher, Workflow builder

Highlights

As Project Lead

Requirement Analysis for new business requirements & major developments of interfaces.

Successful closure of all the ledgers

Planning and successfully execution of the Financial data cleanup as required by the client

Successfully and regularly archiving the Sub ledger Data

User interaction through meetings & presentations.

Production Support & User Acceptance Testing

As Oracle Apps EBS Configurator

Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports for various modules such as AR, PO, AP and GL.

Involved in Requirement gathering, designing and testing of Oracle Applications Financial R12 GL, AP,AR and SLA modules

Involved in requirement gathering and analysis and design of the application.

Worked with the client team to understand the current Business Process.

Configured GL, AR, AP and FA modules in R12 Environment.

Determined business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.

Working on post upgrade support and interacting with Business users on Issue resolutions.

Prepared Module design ( MD050) Documents for Customization.

Prepared Config documents for all the finance modules such as AR, AP, GL and FA.

Designed a multi-org structure for the client for configuration

Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.

Created and maintained User Menu objects.

Created responsibilities assigned to users and set profile option

Gathered requirements, design, set up configuration, CRP, UAT, Data migration, post go live support.

Configured Transaction types, Sources, Receipt classes, Sources, Banks and Bank Accounts.

Set-up of invoices, debit and credit memos, guarantees, deposit transaction types

Successfully implemented a new interface system for autolockbox for creating receipts in AR to adhere the new standards of the European banks(Camt.054 XML)

Migrated banks, branches and bank accounts from the legacy system to EBS.

Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).

Designed and created custom module for Reconciling bank statements to AP Payments and AR receipts which used Forms 10g tool develop new forms for reconciling the data and various new reports for the reconciliation by the BPO team. This functionality had replaced the standard Oracle Cash management module to the custom module which was efficient for reporting and also reconciliation and un-reconciling the data.

Migrated all the users and responsibilities of the existing legacy system to Oracle R12

Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

Migrated all the assets from the legacy system to Oracle R12

Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).

Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.

Developed custom templates for the AR invoice reports by calling sub templates in XML/BI Publisher.

Designed menus and responsibilities to different level of users in the organization.

Worked on Version Control software to check-in.

Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.

Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL.

Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace.

Assisting the team in the User Acceptance testing and also providing adhoc report to verify the tested data.

Trained the BPO team to use the new system and provided the benefits of upgrade which saves time and efforts of the BPO team for closing Ledgers.

Customer

TCS Internal

Period

November 2011 till Jun-2012

Description

Ultimatix – Enterprise Reporting (ER) is the internal portal of TCS. It is having the 3 main modules – BILLING, FINANCE, and HR/MATC. This is the online analytical report-generating module in Ultimatix, which caters to the need of the senior management by gathering, processing and providing relevant information for decision making. Being a part of MIS, have worked in Billing and Costing Module as Business Analfyst and have analysed and changed the existing reports as per the new requirements given by the users and management.

Location

Mumbai, India

Roles Played

Business Analyst

Solution Environment

HP Superdome, HP-UX 11i,

Oracle Applications 11.5.10

Oracle 10g, 11g

Tools

PL/SQL Developer, MS VSS

Highlights

As Business Analyst (November 2011 till Jun-2012)

Requirement Analysis for new business requirements & major developments.

Interact with Corporate Finance Group and Change Control Board to draw system and process improvement plans and track adherence in existing Reports.

Discuss the current and new User Requirements and plan the E2E deployment with the Change Control Board.

Analyze the impact of R12 upgrade on the existing and new Financials Reports

Conduct User Training for Financials Reports

Customer

British Telecommunications Plc

Period

June 2010 to October 2011

Description

Global Finance Platform is the Financial Platform for British Telecommunications. It was implemented for some of the Central European Regions, APAC, LATAM. The Project, primarily involved in the E2E Testing which included Requirement Validation, Design Validation, Test Plan preparation, E2E UAT and Regression testing of Oracle EBS financials and 3rd Party interfaces. Few major rollouts were the E2E Testing for APAC (Asia Pacific) regions which included 14 Operating Units for testing and CEE (Central and Eastern Europe) which included 6 Operating Units. Apart from major rollouts there were monthly releases which included every month’s change request and Bridge Cases for E2E Testing.

Location

Onsite – Ipswich(United Kingdom)

Roles Played

E2E Test Manager

Solution Environment

HP Superdome, HP-UX 11i,

Oracle EBS financials 11.5.10

Oracle 10g

Tools

PL/SQL Developer, QC 10, QTP

Highlights

As E2E Test Manager (June 2010 till October 2011)

Reviewed Business Requirement and Software Specification Requirements to achieve better understanding of the Application.

Prepared Test Plan and Test Cases.

Executed Test Cases and Gathered Test Execution results.

E2E Test Management for 14 Operating Units for APAC Regions which includes countries like Hong Kong, China, India, Sri Lanka, Bangladesh, Singapore, Malaysia. E2E Regression testing for the existing Operating Unit was also done for this Rollout. There were almost 11 customization for these Operating Units which were E2E Validated

Created, maintained and updated test strategy, test conditions, test cases and regression testing based on business requirement.

Performed Back end testing using SQL queries to access the main database.

E2E Test Management for 6 Operating Units for CEE (Central and Eastern European) Regions which includes countries such as Slovakia, Poland, Hungary, Czech etc. E2E Regression testing for the existing Operating Unit was also done for this Rollout.

Customer

TCS – Internal

Period

Mar 2007 to June 2010

Description

Ultimatix is an ERP initiative in Tata Consultancy Services to integrate and automate company wide business processes. As a part of this initiative, Oracle Applications modules are implemented to cover the Finance, Human Resource and Project Accounting areas. The Oracle Applications modules have been integrated with custom-built applications for Employee Self Service, Allowances and Payroll, travel systems etc.

Ultimatix-Finance project involves Oracle Financials modules namely,

General Ledger to maintain financial books

Receivables to track customer receivables / receipts

Payables to track vendor liability / payments

Fixed Assets to maintain assets financial data

Custom revenue recognition as per TCS requirements.

Business Associate management module.

This project also automates various financial processes of TCS and management of transaction such as Revenue recognition setup, Customer/Supplier Creation, Set of books creation, Operating Unit Setup, Invoice/Debit Memo/Credit Memo/Receipt Creation setups, Development of Code for customizations and Reporting.

Roles Played

Oracle EBS Technical Developer, Project Leader of Finance Teamand Cross functional Team Lead(CFT)

Solution Environment

HP Superdome, HP-UX 11i,

Oracle EBS Financial 11.5.10

Oracle 8i, Oracle 10g

Tools

PL/SQL Developer, Edit plus, Data loader, MS VSS, Oracle Apps Form Builder, Oracle Apps Report Builder, XML Publisher

Highlights

As Project Lead (Apr 2009 till June 2010)

Requirement Analysis for new business requirements & major developments.

Interact with Corporate Program Office, Corporate Finance and Change Control Board to draw system and process improvement plans and track adherence in existing ERP Financials Software.

Maintain and track adherence to Business continuity, Disaster recovery, Risk management and Unified Project plans for project.

Maintaining and facilitating of Interface between financial modules and other standard and custom source systems.

Supporting Month end and Quarter end period closure activities and taking care of book closure of TCS and all its subsidiaries

Year End Activities involving Document Sequencing, defining Tax Codes, etc.

Integration testing

Impact analysis of proposed changes in existing components

Bringing out enhancements in the current system like Implementation of Customized Projected Depreciation for all locations, Generic payroll Solutions across Subsidiaries.

Co-ordination with Corporate Finance and the whole Team

User interaction through meetings & presentations.

Production Support & User Acceptance Testing

Domain Knowledge sharing within & across projects

Training and Business Induction of new members.

Functional Support and maintenance of Oracle Apps – Financial Modules

As Oracle EBS Technical Developer (Mar 2007 to Apr 2009)

Customizing Oracle EBS Financial functionalities according to TCS business needs.

Providing various ad hoc audit reports as and when needed

Initiating and implementing process improvements

Developed Customized APIs for Accounts Payable Supplier and Invoice migrations.

Refining the interfaces with other applications by writing customized programs

Took part in requirement Analysis, Design & Development for APAC Cost recovery Solution

Development of back to back debit memo solution for projects involving more than one subsidiary of TCS

Automated the year end AR document sequencing for TCS and subsidiaries through zoom trigger

Designed and implemented Central Excise solution For TCS Hyderabad and Delhi operating units

Developed crucial customized reports such as RBI Softex filing report, TCS Excise Invoice Print using Oracle Reports

Contact this candidate