Oracle Project

Saurav Dutta

Sr. Oracle Financial Functional

SUMMARY

. Master Degree in Computer Applications - Almost 12 years of Oracle

Applications experience on most of the financial modules across various

versions of Oracle Applications including 11.5.9, 11.5.10 and R12.

. Five years of experience as a Business Systems Analyst working closely

with the business at client sites.

. Extensive experience in implementing and supporting Oracle Purchasing,

Accounts Payable, General Ledger, Fixed Assets, Accounts Receivable, Cash

Management, Approval Management Engine and i-procurement modules in

Oracle Applications.

. Experience in understanding business requirements for analysis and

mapping applications per the client requirement.

. Experience in generating Implementation documentation e.g. Process flow,

process mapping, functional gap analysis documentation etc.

. Strong focus on writing High Level Design document, Test Documents,

Application Set Up specifications, etc.

. Excellent knowledge in mapping functional requirements to technical

specifications.

. Strong knowledge in building interfaces and conversion programs from

legacy systems into Oracle Applications.

. Extensive experience in working in varied reporting environments

including both Relational and Multidimensional databases.

. Excellent teamwork, communication, interpersonal, leadership, analytical,

and problem solving skills.

. Strong Analytical, Inter-personnel, Problem-solving and Proven ability to

work under pressure.

ORACLE SKILLS

Oracle Applications Primary Modules

R12, 11.5.x,11.5.10.2, GL, AP, AR, FA,

AME, Cash Management,

i-procurement (Oracle Financials)

Secondary Modules

11.5.x-OM, SCM, Projects

Operating Systems Windows, Linux

Programming Languages PL/SQL, SQL

Database Oracle 9i, Oracle 10g, Oracle Express

GUI Tools: Reports 6i/9i,Forms, Oracle Discoverer,

Business Objects, Oracle Financial

Analyzer, ADI

Utilities/Tools SQL* Plus, SQL* Loader, UTL_FILE, Work

Flow Builder, Toad, SQL Navigator,

Developer 2000

Methodology: Oracle Application Implementation

Methodology

BFA Process Flows: Procure to Pay and Accounting to

Financial Reporting

Experience Profile:

Project Details:

AT&T Mobility, Atlanta, GA, USA

Role Business System Analyst

AT&T Mobility LLC is a wholly owned subsidiary of AT&T

Inc. that provides wireless services to 97.5 million

subscribers in the United States, Puerto Rico and the

U.S. Virgin Islands. AT&T Mobility is the second largest

wireless telecommunications provider in the United States

behind Verizon Wireless, which has 104 million customers

as of the first quarter of 2011. AT&T Mobility is

headquartered in the Lenox Park area of DeKalb Co.

Georgia, just outside Atlanta

Start and End APR 11 to present

Date

Modules Oracle i-procurement, Oracle Purchasing, Oracle

Payables and Communication Asset Tracking System, Oracle

R12

Contribution Design of interfaces between Oracle and legacy systems.

Designing new forms and personalising the existing ones.

Implementing business processes by customising standard

forms and features.

End to End configuration and testing of these interfaces.

Designing business process flows and integrating CATS and

Oracle with external systems.

Rolling out the business solutions to new AT&T regions.

Documentation and preparation of test scripts.

Preparing conversion design documents.

Working with the development team closely on the

technical specifications.

Involved in role out of additional entities to expandable

modules for new Operating Units/locations.

Preparing functional design documents and obtaining sign

off from business owners.

Involved in functional testing and module Integration

testing, fine tuning of processes.

Handling Change Requests and Bug fixes.

Key Task Design and implementation.

Documentation and testing.

Project Details:

GE Energy Services, Atlanta, GA, USA

Oracle Applications Version 11.5.10, R12

Role Oracle Applications Consultant and Team Lead

One of General Electric's largest divisions, GE Energy

serves utility, industrial, and governmental customers

worldwide, supplying products such as compressors,

turbines, generators, and nuclear reactors. It also

provides equipment that supports oil and gas

distribution, and services ranging from consulting and

field engineering to environmental monitoring and product

lifecycle management.GE Energy has Oracle R11i (11.5.10)

that spans multiple Ledgers and operating units for their

US, Europe, Asia and Latin American entities.

Start and End APR 10 to MAR 11

Date

Modules Oracle Purchasing, Receivables.

Contribution Design of interfaces between Oracle Purchasing and third

party systems (both Oracle and legacy).

End to End configuration and testing of these interfaces.

Documentation and preparation of test scripts.

Talking to the developers for explaining functional

requirements and mapping them to technical

specifications.

Working on Form personalizations.

Involved in role out of additional entities to expandable

modules for new Operating Units.

BRD's and CF250 preparation and obtaining sign off from

business owners.

Involved in functional testing and module Integration

testing, fine tuning of processes.

Bug fixing existing Oracle Receivable interfaces with

third party interfaces and rolling them out for

additional Operating Units.

Coordinating testing process by working with multiple

teams and users.

Handling Change Requests and Bug fixes.

Key Task Design and implementation.

Documentation and testing.

Project Details:

Equifax Inc., Atlanta, GA, USA

Oracle Applications Version 11.5.10, R12

Role Oracle Applications Consultant

Equifax Inc. is a consumer credit reporting agency in the

United States, considered one of the big three American

credit agencies along with Experian and Transunion.

Founded in 1899, Equifax is the oldest of the three

agencies and gathers and maintains information on over

400 million credit holders worldwide. Based in Atlanta,

Georgia, Equifax is a global service provider with US

$1.5 billion in annual revenue and 5,000 employees in 14

countries.This implementation spans over multiple

operating units and business units.

Start and End Jan 08 to Apr 10

Date

Modules Purchasing, Payables, Fixed Assets and Accounts

Receivable.

Contribution Involved in successful design and implementation of

Interfaces and Data Conversions for Purchasing and

General Ledger

Implemented rollouts for new operating units

Conducted UAT and CRP conference room pilots with key

users.

Involved in functional testing and Module Integration

testing, fine tuning of processes.

Worked closely on technical issues with Oracle support

thru SRs.

Handled month end closing issues and user support

Key Tasks ACCOUNTS RECIEVABLE

Validate Invoice creation and receipt generation process

Track customer accounts

Open / Close accounting Periods and its reconciliation

with GL

ACCOUNTS PAYABLES

Validate Invoice creation and Payment generation process

Track supplier liability

Open / Close accounting Periods and its reconciliation

with GL

FIXED ASSETS

Validate Book Controls, Asset Categories and depreciation

calculation setups.

Verify Create asset, merge & split assets, retirement of

assets.

Check Mass additions integration with AP module

Mass additions from AP module

FA Conversions. Upload fixed assets thru ADI

Project Details :

New York Stock Exchange

Oracle Applications Version 11.5.9,11.5.10

Role Oracle Application Consultant

The New York Stock Exchange (NYSE) is the largest stock

exchange in the world by dollar volume and has the second

most securities of all stock exchanges. The NYSE is

operated by NYSE Euronext, which was formed by its merger

with the fully electronic stock exchange Archipelago

Holdings and Euronext. NYSE Group merged with Euronext,

and many of its operations (particularly IT and the

trading platform) were combined with that of the New York

Stock Exchange and NYSE ARCA. New York Stock Exchange

(NYSE) uses Oracle Applications, which underwent changes

as companies like SIAC and ARCA merged into NYSE. This

project involved conversion of SIAC and ARCA data into

NYSE

Start and End Jan 2005 - Dec 2007

Date

Contribution Actively involved in Data conversion design and

implementation for subsidiary businesses of NYSE which

was necessary after a merger.

Both functional and technical support to the iprocurement

and Fixed Assets implementation at NYSE.

Design and support multiple interfaces across various

modules.

Involved in a version upgrade from 11.5.9 to 11.5.10

Journal uploads using ADI and support existing FSG

reporting requirements.

Revamp and support the custom reporting requirements by

specifying new design and modifying the existing once.

Support month end issues and break fixes.

Key Tasks GENERAL LEDGER

Validate 3 C's (char of accounts, calendar and

currencies).Multi Org set up

Data Integrity-Cross validation, Security rules

verification

Data Identification-Journal sources, categories

verification

Open, Post and Close accounting periods and Final

Reconciliation.

FIXED ASSETS

Worked on Mass Additions of Assets

Loaded assets using ADI

Worked on leases and amortization schedules

Worked on integration of payables with Fixed Assets

Ran Depreciation process and validated journals

transferred from Fixed Assets to GL at month end

Worked on opening and closing Assets period

Procure to Pay

. Extensive work experience in Procure to Pay cycle

. Created requisitions and interfaced them from 3rd party

systems both internal and external

. Created Approval Groups

Assigned Approval Groups

Defined flexfields and valuesets

Defined Routing Rules

Created Direct POs and verified Autocreated POs

. Customised requisition workflow

. Worked on ASL and autocreated POs.

. Created POs matched against requisitions.

. Worked on PO interfaces and conversions from third

party legacy systems

. Created invoice batches.

. Created invoices and matched against POs

. Created invoice batches.

. Created payment batches.

. Validated, approved and accounted payment batches.

. Worked on Supplier and Supplier site interfaces

Project Details :

GE Capital International Services

Role Implementation and support of Oracle Financials.

Start and End Sep 2003 - Dec 2004

Date

Contribution Involved in analyzing Chart of accounts, Ledgers and

mapping them to reporting dimensions used in Oracle

Financial Analyzer.

Designing and configuring adhoc custom reports required

for business.

Worked on complex reports used to derive cost allocation

across CoEs.

Supported month end issues with the system.

Worked closely in configuring Budgets and Budget uploads

thru WEB ADI.

Complete planning, designing and implementation of

Financial reports using FSGs.

Project Details :

Unilever India

Role Oracle Consultant

Start and End Aug 2002 to Sep 2003

Date

Modules GL

Contribution Worked on mapping Accounting flex field segments to

reporting dimensions.

Worked on loading Journals using ADI

Used data loaders to upload

Developed financial statements using FSG.

Uploaded open balances using ADI for both actual and

budget balances

Support user issues

I was involved in conversion of Existing Reports from

V10.6 to R11.

Developed custom reports

Developing client procedures to reflect future processes

using Oracle Payables, Oracle Receivables and Functional

inputs for reporting and workflow

Develop the Mapping and the Solution Design.

Developing test scenarios and perform testing of AP,AR, GL

Modules, in an integrated environment with the other

modules

ACADEMIC

EDUCATION

Masters in Computer Applications Passing Year

- 2002

Contact this candidate