Milind Prabhakar Bhute [pic]

Sr Oracle ERP Functional, IT Business Analyst-Partner Oracle

Certified

CompuSearch Prism Functional

abicua@r.postjobfree.com / 703-***-**** (cell)

Professio

nal Summary:

o More than 13 years of strong Functional Design, Functional Development

support, Implementation and Testing experience in Oracle Applications

(Federal Financials / Commercial ) Oracle 12i/11i/11.0/10.7/10.5 (AR,

AP, PO, iProc, OM, GL, Projects, Inventory, Cash Management, Asset,

Treasury, AME, Oracle iExpense and Oracle iTime.

o Full SDLC project implementation experience includes - data

conversions, supporting custom apps development, gap and map analysis

and system design. User needs analysis, improving procedures,

identifying and solving problems. Feasibility study, fit/gap analysis

and AIM documents (e.g. MD050, MD070, BR040, BR100). Functional

support for Form and Reports Customization. Migration from 10.7 to

11i, design and customization as per the business rules. Analysis and

Design of RICEW elements (Reports, Interfaces, Conversions,

Extensions). Developed Functional Specs for RICEW objects. Extensive

experience in Oracle TARs/Oracle Support. Business Process Analysis

using Business Process Modeling, Data Analysis and Data Mapping,

writing BRD (Business Reqts), FSDs (Functional Specs), Use Cases, UAT.

Project Management experience.

o Business Analysis experience- Oracle R12(12.1.3)

developed business reqts, Process designing, Systems analysis

involving delivering business plan, Functional reqts, As-Is processes,

To-Be processes.

o Oracle 12i Assessment: Knowledge about Architectural and Closely-

related Enhancements wrt Multi-Org Access, Oracle GL, Cash Mgt, Sub-

ledger Accounting, Legal Entity, Global Intercompany System, Taxation,

Financial Consolidation Hub, Internal Controls Manager, I-Expenses,

AP, AR, Daily BI.

o Experience in Six Sigma Methodology for Oracle Applications.

o BI (Cognos) Functional Implementation support and validations, data

alignment with Oracle Apps.

o Oracle Federal Financials, implementation, upgrade and testing of

Oracle AP, PO, AR, GL, Projects, Fed Admin, Fed Budgeting, Public

Sector Budgeting 12i, Prism, Sunflower Assets, Federal Reporting,

Federal Accounting. Exposure to FASAB (Federal),GASB (Public Sector)

Accounting Standards.

o IT Governance related functionalities for Oracle apps. Eg - Sox

compliances for Internal Control.

o Oracle Process Improvement - Oracle GIS, Month End Redesign of Oracle

AP, FA, GL, AR flows.

o Oracle Financial Analyzer (OFA) - Functional User for Financial

Reporting.

o Financial Reporting and Analysis in US GAAP and International

Accounting Standards.

o Domain knowledge of Finalization of Accounts, MIS, Costing, Management

Acctg, Budgetary Control, Audits - Statutory Internal Audits, Tax

Audits, Management Audits and Cost Audits.

o Tools / Software used : Oracle apps 11i/11.0/10.7/10.5, Toad, PL/SQL,

SQL* Plus, SQL* Loader Data loader, ADI, Account Hierarchy Editor

(AHE), FSG-based reports building, Oracle Meta link, Noetix, Oracle

AIM, Sabrix Tax engine, 170 Systems,Kintana, Clarity Project

Management, TM-1 (OLAP tool), UPK, data loader,Ora-excel, Sabrix

(Transaction tax), Remedy Service Management, Mercury Test Director

8.2, AccPac (Semi-ERP), Cayenta Financials (Public sector),PPM, SVN

for code Management.

o Very good understanding of Business Acctg Theories and Practices and

Financial Business Processes

o Knowledge of Application Table Structures and their relationships

across tables.

o User Training development -Oracle Financials

o Working knowledge of Agile and Waterfall models - SDLC methodologies

o Strong analytical,interpersonal, communication, and client-facing skills

at all levels of Management

Customer Service attitude, Strong Work ethics.

Education/Professional Training/Certification

o MS - Information Systems Management, Virginia

o ICWA, CA (I), Bachelors of Commerce, Pune University - CPA

Equivalent and Bachelor's degree

o Certified Management Accountant (CMA),USA

o Oracle 9i SQL and PL/SQL programming - Oracle Corporation Certified

o Oracle Corporation Trained - Oracle Financials, Project Costing &

Billing

o Trained in Cognos BI, Oracle Federal, Public Sector and Commercial,

Semi-ERP AccPac

Organization Experience -Lead / Sr Oracle ERP Con/SME/BA/QA :

13+yrs

Federal / Public Sector Projects: Sr Oracle ERP Functional Consultant and Business

U.S.Dept of Health & Human Analyst / IT Business Partner (R12 (12.1.3), 11i )

Services, MD

City of Jackson, Mississippi / UFMS Application Support in an Operations and

Virginia Maintenance (O&M) and Testing environment, including

DHS / CACI, Virginia Oracle Federal Financials, CompuSearch Prism,

FCC / SRA, Virginia Sunflower applications for Extensions, Interfaces,

US Department of Education, DC Workflow and Reports

Federal Aviation Administration Previous clients -Oracle eBS Apps 11i

(FAA), DC Implementation, Upgrade, Production Support -PO,

I-Proc, AP, GL, Budget Execution, AR, Projects, Fed

Admin, Inventory, Fixed Assets, Oracle Public Sector

Budgeting. FASAB (Federal) and GASB (Public Sector)

Accounting Standards. Other legacy Systems -Prism,

Sunflower Assets, RM online, Cayenta (Public Sector

Budgeting).

Commercial Projects: Oracle E-Business Suite Apps 12i, 11i(12.1.3,

Celgene Corporation, New Jersey 11.0.3 to11.5.10) Implementation, Upgrade,

Cisco, California Production Support -AP,PO,I-Procurement, OM,

Symantec, California Inventory, AR, Contracts, GL, Global Intercompany

Kulicke & Soffa Industries, System (GIS), Sys Admin, Cash management, Treasury,

Pennsylvania Oracle Process Improvement for Month End Redesign.

First Data Corporation (FDC), US GAAP and International Accounting Standards.

Colorado BI / Reporting - Cognos Business Intelligence,

Alcoa, Pittsburgh, Pennsylvania Noetix.

General Electric (GE), New York 3rd Party Systems - Mark View 170 System, Sabrix

Transaction Tax engine, Basware, Zycus contract

mgt.

Projects Profile

Project / Client: Celgene Corporation, NJ

Role Oracle Apps Functional and Lead Business Duratio From 05/2014

Analyst n

Software Oracle Apps 12.1.3, Oracle 11g, Oracle Hyperion 11.1.1.2

apps Enterprise Performance Management System, Basware, Zycus

contract mgt.

Project Description: Leverage Oracle Application functionality/automation

for process efficiencies which are scalable and flexible to accommodate

business demands, Establish global harmonized processes and Standard

Operating Procedures (SOPs), Facilitate accurate and efficient operational

reporting to aid internal and external stakeholders with their business

needs for US and International Legal Entities, Operating Units.

Contribution:

Contributed as Oracle Functional / Oracle Business Analyst for Oracle

Procure to Pay, Order to Cash, and Record to Report processes. This

included Supplier Master Data Management (MDM) governance; Reporting &

Analytics for Finance and Procurement; Customer MDM, AP/PO Improvements for

spend data access / transactional process enablement; Common enterprise

wide definition of Chart of Accounts, AR Account Reconciliation process.

Lead Requirements Gathering workshops (JAD) for Procure to Pay, Order to

Cash, Record to Report business processes. (Oracle GL, AP/PO,

iProcurement, AR, Order Management modules - Local and International

Operating Units). Demonstrated Functional Experience of Oracle EBS AP,

AR, GL, PO, iProcurement, Order Management, Project Accounting,

Purchasing and Inventory

Documented Business Requirement Document (BRD), Developed UML based use

cases, workflow, and screen mock-ups, Prepared Business Case Summary for

the Requirements in scope.

Contributed to Oracle Apps Set-ups (BR 100) and Functional Design Specs

(MD050) for Oracle AP, AR, Cash Management, eBusiness Tax, Fixed Assets,

General Ledger, Project Accounting, Purchasing, Inventory and Order

Management.

Supported Application Extension design (MD 070) for Oracle AP, PO, Order

Management extensions.

Evaluated existing business, operational flows and defined As-Is and

To-Be process models and created process maps for business process

re-engineering initiatives. Did Functional fit-gap analysis. Worked with

users to understand and recreate system problems.

Supplier Master Data Management - performed detailed design, cleansing of

Supplier master data.

Lead Citibank V-Card Requirements gathering for Working capital/Rebates

efficiency

Oracle UAT Manager Role - did UAT planning, supported Oracle R12 Unit

Test, Integration and Regression scenarios, test scripts creation and

execution - was Responsible for UAT sign off.

Validated solution with the internal Stakeholders and Oracle Corp,

Supported Oracle R12 (12.1.3) demos

Applied working knowledge of Agile scrum and Waterfall models - SDLC

methodologies

Project / Client: - U. S. Dept of Health & Human Services, MD

Role Sr Oracle Federal Financials, Compusearch Duratio 09/2009-

Prism and Sunflower (PMIS) apps Functional n 04/2014

Consultant - O&M and Testing support for

Reports, Extensions, Interfaces, and

Workflow (REIW )

Software Oracle Federal Financials 11.5.10,Compusearch Prism 6.3 and

apps 7.1,Sunflower 4.5 (PMIS)

Project Description: Operations and Maintenance (O&M) and Testing project

providing support to the Federal Financial Management solution of DHHS for

its four primary agencies - Center for Disease Control and Prevention

(CDC), Food and Drug Administration (FDA), Program Support Center (PSC),

and Indian Health Services (IHS).

Contribution:

Modules supported within Oracle Federal Financials 11.5.10 were GL, AR, AP,

PO, iProcurement, Sys Admin, AOL, Fed Admin, PA for transactions,

accounting and configuration management. Supported PRISM 6.3 and 7.1

(Procurement), SUNFLOWER 4.5 (Fixed Assets-PMIS) testing. Involved as

'Functional/ Business Lead' analyst for developing business requirements,

identifying OU business needs, Process designing (workflow, etc)

o Did Production support for Federal Financials 11.5.10 - GL, AR, AP,

PO, I-procurement, Sys Admin, Fed Admin, and Projects modules.

o Supported enhancements for IPAC, PO Mass Cancellations, and Cash

management (GOALS system). This enhanced data classification,

processing and control, Audit controls, Data reconciliation, Data pre-

processing, error handling.

o Performed Systems analysis using business rules and requirements for

Oracle, Prism applications

o Configured and Tested Oracle Procure to Pay Process for Requisitions,

RFQ, Suppliers, Orders, Receiving, invoicing and Payments for standard

and Custom solutions.

o Assessed Impact of Oracle R12 Design structure in Procure to Pay

Accounting Flow and its related changes to R11 test scripts. Also

worked on OCI interface initiative for R12.

o Supported Grants extension interface ( GATES system), Performance and

Reconciliation Enhancements

o Worked on Performance areas including Grants to GL Interface,

and Receivables Transfer to GL, etc.

o Supported Troubleshooting of eTravel interface (GovTrip) related

functionality issues in UFMS

o Resolved MFAR code and data issues within Oracle AR module.

o Worked on Data fixes for-IPAC, Cash Management, Grants, Supplier

management, MFAR.

o Managed Release Defects in IT,Regression, UAT phases of each release

as POC for Apps Support Team

o Involved in Patch analysis, User Provisioning.

o Did Reporting on The American Recovery and Reinvestment Act (ARRA),

2009 for agency set of books.

o Involved in Yearend support tests in the Mock Instances.

o Involved in initial Problem management analysis for HHS business

processes gaps and enhancements-did problem logging, validated problem

classification, prioritized, did Root Cause Analysis, identified

Workaround or permanent solutions, conducted Error Assessment, logged

and monitored CR. Worked on related deployment activities like

scoping, scheduling deployment, release process, configuration

documentation, closing CRs.

o Performed Oracle Federal Financials Configuration & Testing of

Release / Non point Release CRs (Standard and Custom changes) and

Regression for Oracle GL, AR, AP, PO, Can-Bacs, OCI, Budget Execution,

Projects. Grants, IPAC, EHRP, ETravel (GovTrip), UPA (User

Provisioning), App Worx application code changes.

o Supported GTAS (Government wide Treasury Account Symbol Adjusted Trial

Balance System) analysis for bulk file uploads, validated GTAS

reporting. Did analysis of Patches for supporting the GTAS Reporting

requirement for replacing FACTS I/II functionality. Validated GTAS

test scenarios and testing including error resolutions.

o Oracle GL reporting - Setup GL summary Templates, Cross Validation,

Security Rules and Report structure as per the business requirement

and rules. Ensured Financial statements are in sync with in the

reporting hierarchies. Revised/ updated the existing security and

Cross validation rules based on changes of responsibilities. Tested

and prepared test documentation for the enhancement and creation of

custom Oracle GL reports and GL reports migration.

o Performed CompuSearch Prism Configuration & Testing of Release / Non

point Release CRs (Std & Custom changes ) and Regression for BPA,

Contract, DOTO, IAA, Solicitation, Amendments, PO, OCI DCIS interface

o Supported Sunflower (PMIS) application for Fixed assets Testing of

Release / Non point Release Code change Requests (Std and Custom

changes), Regression tests for Finance, Inventory .module scenarios,

Custom and Std Report validations.

o Tools/Software: Oracle Apps 11.5.10, Toad, Mercury Test Director 8.2

for QA/Release testing and Defect Management, PPM, Oracle Metalink,

and SVN for code management.

Project / Client: City of Jackson, Mississippi

Role Lead Oracle 12i Public Sector Budgeting Duratio (07/2009)-(08/

Consultant n /2009)

Software Oracle Apps 12i - Oracle Public Sector Budgeting, GL, Budget

Legacy System - Cayenta.

Project Description: Implementation of Oracle 12i PSB to Automate Budget

Preparation and Maintainence.

Contribution: Lead the Full life cycle implementation of Oracle 12i Public

Sector Budgeting (PSB) including setting up Oracle GL and Oracle System

administration functionalities for enabling PSB.

o Assessed Business Needs/ Analyzed Fit Gaps for PSB - Did the fit gap

for Budgeting business processes by functional area, all key data

elements that needed to be converted, established data conversion

rules. This fit gap helped to ensure that Oracle PSB would meet all

current business processes of the City, use Best Practices for

Budgeting, was able to identify necessary interfaces and issues that

require policy changes for PSB functionality.

o Interfaced with business users, Super users, and various members of

the project team to improve the understanding of User Requirements and

any need for customization by solutioning ideas resulting in a

business process change.

o Finalized PSB Deliverables based on Fit gaps/ CRP sessions-Functional

specs (scoped the conversion, interfaces, reports, security,

testing,reporting and test scenarios), Fit Gaps, scoped draft

prototype oracle database to explain the fit gap results to the users

to show how Oracle PSB will work at the City's.

o Prepared Future State Design (FSD) - prepared FSD which included

Budget development,adjustments, reductions, monitoring of budget,

Chart of Accounts, inbound-outbound interface(Oracle -Excel),Budget

load and maintainence of the budget system (spreadsheets),Reporting

Policy and Procedures.

o Converted / interfaced data (Conversion specs) - identified data,

established data conversion rules. Legacy data converted was Budget

load- current year and history, Actual expenditures and encumbrances,

COA elements mapped to Oracle. Prepared Specs for Conversion which

included assumptions, business reqts, functional reqts, technical

reqts, programs/processes involved, impact/implementation

considerations, processing logic(execution, table and view usage,

error handling),Unit test plan, integration issues.

o Configured PSB and GL - Configured Budget Development Process by

Creating budget worksheets, Approving budget worksheets,

Revising/analyzing budget worksheets, creating budget revision rules,

'What-If' analysis related Budget Development Process, Budget Groups

and Budget Revision Rules, and Budget System maintenance

functionalities. Established Budget Groups and Budget Revision Rules.

o Configured Budget System maintenance functionality which involved

setting up Budget Year Types, Budget Calendar, Budget Items, GL

Interfaces, GL Budget Sets, Global Account Sets, Budget Group

Categories, Budget Stages, Budget Groups and Security, Budget Review

Groups and Budget Review Group Rules for Account Sets, Line-Item

Budgeting Profile Options, GL Budget Sets, Budget Stage Constraint,

Constraint set, Distribution Rule Parent Budget Group, Parameter Set,

Period Allocation Rule, Period Allocation Rule Set.

o Other setups done- Set-up and mapped Chart of Accounts between Oracle

and Cayenta (Legacy) Flex field mapping, developed Excel interface,

performed Worksheet Operations, Budgets to the GL posting, Workflow,

Profile Options, Encumbrance accounting .Generated Budget Reports and

Concurrent Processes. Followed GASB Accounting Stds for PSB accounting

setup.

o Demonstrated final CRP for PSB - demonstrated Oracle 12i PSB

environment to the City's users, accomplished walkthrough of the

City's business processes within an Oracle database environment,

validated the City's business processes within Oracle PSB. Draft

prototype PSB application was developed to explain fit gap results and

show how the resulting system will work at the City.

o Custom Report Specs prepared for producing the City of Jackson's

budget books and agenda.These specs reports included Adopted Budget

for CY and PY by Fund, Adopted Revenue by Source, Adopted Revenue by

Fund, Adopted Expenditures by Dept, Adopted Expenditures by Fund,

Adopted Budget Report, and Proposed Detailed Budget Report.

o System Testing done - (Unit, Integrated Testing) - Tested PSB

Configurations, Budget Creation/Revisions, Excel Interface, GL

postings, Reports, Conversions, and Interfaces.

o End User PSB Training done - for Standard PSB functionality,

Customizations, Conversions, Interface. Reports, Workflow, Application

Security and System Security.

o Infrastructure - supported the DBA in estimating data storage reqts,

for ensuring hardware and software reqts are met prior to installing

Oracle, for managing Oracle installation and initial security design.

o Go Live Readiness check being done for data conversion, interfaces,

PSB application,system integration,reporting.

Project / Client: CACI, VA

Role Lead Oracle Functional Duration (04/2009) - (06/2009)

Analyst

Software Oracle Applications - Financials R12, 11.5.10 PO, I-Proc, AP,

GL, Budget Execution, Fed Admin & Inventory. Prism, Sunflower

Assets, RM online.

Project Description: CACI is Demonstrating the integration of financial,

asset and procurement management capabilities by integrating Oracle PRISM

and Sunflower Assets, and using Integration Web services.

Contribution: Request to Procure, Procure to Pay, Record to Report, Acquire

to Dispose

o Pre-Demo Activities accomplished:

Integration Requirement (SOA integration) designed - Requisitions,

Funds Check, Awards creation & Acknowledgement, and Fixed Assets (FA)

Creation

. Finalized Assumptions, Business Process flows, Requirements for the

business processes as above.

. Gathered, Translated user requirements into UML Use Cases &

Activity Diagrams

. Created High level and Low level design documents as well as

programming some of the use cases of the project

. Configured and tested Validations within Oracle and Prism and for

the web-services integrations.

. Data mapped between Prism and Oracle for Req to Procure and Procure

to Pay integration

. Data mapped between Oracle and Sunflower Asset system for Fixed

Assets (FA) integration.

o Functional Set-ups - Oracle iProc, PO, AP, GL, Inventory, Fed Admin,

Bud Execution and PRISM

i-Procurement: Set-up pre-requisites in GL, sys admin, hrms,

inventory, workflow options, PO and AP. Set-up req templates, buyers,

internal requisitions, attachments, catalog management including

realms, profile options, sys admin, responsibility security, workflow,

Requestor Usage features. Receipt set-up including receipt, return,

correction, receipt notification. Created and loaded catalog items in

Oracle (spreadsheet loader)

o Purchasing: Set-up done for accounting, suppliers, items, supplier

sourcing, document approvals, requisitions, POs, workflow and,

receiving transactions.

o Accounts Payables: Set-up Supplier Invoicing, Payments, Taxes. This

involved setting up profile options, sys profile options, financial

and payable options, invoice tolerances, invoice holds and releases,

payment formats, payable periods, aging periods,budgetary control,

dff's, payment terms, look ups, bank accounts, supplier sites,

document sequences.

o GL set-up: validated Chart of Accounts structure consistent with CGAC,

Mapped/Scoped Oracle Governance, Risk, and Compliance Controls (GRC)

for Demo Use cases (R12 testing)

o Fed Admin set-up for GL, AP, PO, Budgeting: Configured FedAdmin for

Budget Execution/transactions including budgetary accounting (USSGL

TC), US Treasury integration for AP payments and for reporting files

of Facts I/II. IPAC Transactions, Reporting configuration for SF224

and other reports,

o Specific AR/AP federal demo functionality set-up. Validated Budgetary

set-ups for Position and non-position budgeting, GL set-up for

Budgetary control, defined other budgetary set-ups like budget types,

orgs, years, categories, defined and assigned account sets, GL

interface for budgeting, position attributes, budget worksheet related

set-up.

Inventory set-up: set-up inventory for Set of Book designed,

Transaction accounting, Items and UOM.

o PRISM set-up (R2P, Acquire to Dispose integration ): Set-up: Users,

security groups, vendors, product service codes, agencies, user

product codes, document level set-up for auto-numbering, buyer

assignment (workflow). Interface validations: Validated external

interfaces for financial approval, requisitions, accounting, awards,

acceptance and Invoice.

o Demo / Testing done - R2P, P2P, Record to Report: Requisitions, POs

(Awards) and modifications, Oracle integrations with PRISM, Sunflower,

RM online. Integrations tested were Req/Req amendments, Req

attachments, PO/PO modifications, Funds check, Award Approval,

PO/Receipt testing for assets, IPAC and Prompt Pay transactions, GL,

RM online, Fed Admin, Unit and Integration testing within Oracle for

iProc, AP, PO, GL.

o OBIEE Reporting Requirements- Finance (GL, Budget), Procurement

(iProc, PO) and Fixed Assets.

. Reqts gathered for finance, procurement, asset mgmt domains for

real-time or near real-time data.

. Data mining done

Project / Client: Cisco, San Jose, California

Role Sr Oracle Apps Functional Duration (09/2008) - (02/2009)

Consultant

Software Oracle 11i Quote to Cash (OM, Inventory), Sabrix ( Indirect

Transaction Tax ), PA

Project Description: Cisco Joint Order ability initiative was to integrate

hardware, software and services into Quote to Cash processes and systems

and financial reporting to enable Joint Order ability on a single PO.

Contribution:

o Set up (BR100) for Oracle Order to Cash and financial reporting for

Test Cycles. set-ups related to job scheduling, suppliers, calendars,

shipping point addresses, Transaction types, Customer data, EDI

related set ups for new CIDs / BIDs/ Collectors, ship form's, Global

Scheduling Rule, accounting for Intercompany and COGS, Org, SRC - Opt-

in and Opt-out, Product Hierarchy, PIDs loading, Purchasing related

set-up. Trained the Users for processing the orders through different

order cycle steps like Order Entry, Order Booking, Order Scheduling,

Manufacturing Release, Pick Release, Ship Confirm, and Receivables

Interface. Configured setups for OM and Shipping (including

configurator setup)

o Partnered with business process team lead during current state

analysis and requirements gathering and contributed to future state

solution design. Configuration of CRP instance for initial solution

testing and validation for PA module.

o Performed AS-IS analysis for Order Management and Contracts

integration with Receivables through Open Interface.

o Sabrix ( Indirect Transaction Tax BRD contained the following:

-matrix or mapping for Items (pids) to be attached to correct product

code for tax calc per state/country rules/regulations, and also

maintenance of new items (pids) created for on-going sales support.

-Current process flows: product categories in Oracle matching the set-

ups in Sabrix, Category setups in Oracle and Sabrix to be mapped to

products, New product additions in Oracle to be mapped to product

categories, Product category for tax set-up, Custom oracle report for

new products, manual changes to product mappings, product

categorizations in Oracle, some additional business requirements like:

Automated reconciliation of VAT accounts, Relevant data to be fed to

Sabrix in order for correct indirect tax treatment to be calculated,

Freight charges to be fed into Oracle to be included in taxable base

for indirect tax calculation (SAP to Oracle) EMEA, able to identify

products vs. services for a correct calculation of indirect tax, VAT

credits for transactions to be discontinued and only to do a full

credit and rebill without VAT, etc

o Testing methodology followed for Oracle Quote to Cash and Sabrix tax

testing: for Product shipments:

- Test business scenarios were got approved from business, Managed

test cases including review, reload and corrections, Manually

executed each test script for Sabrix related Quote to Cash test

script, Logged defects in Mercury Test Director (QC tool),Tracked

specific Bug Fix/Issue Mgt and bug resolution, Coordination with

development bug fix team, Tracked test execution throughout test

cycle.

o SDLC project scheduling for functional testing deliverables was

achieved for each phase of SDLC:

(Entry and Exit Criteria)

-Analysis: Business Requirements and Use Cases analyzed, QA draft test

plan prepared, BRDs.

Completeness reviewed, incorporated Functional specs details in the

test scenarios.

-Design: Refined Test Plan, Identified Test Scenarios, supported Test

Env Setup. Involved in Creating detail design document, Use cases,

and Class Diagrams using UML.Developed the System use cases from

Functional use case requirements.

-Build: Test Cases (QA) built and got approved from business.

-Test: (Integration, End to End Testing): Test data Mining, QC

activities like Requirements plan, Test

Scenarios upload, Test lab executions, Status Reports, Defect

Reports, System Test, Business sign-off.

-Deploy- Testing Exit Report. Ensured that system functionality

met user requirement

o Test scenarios data mining was done for the following data in Oracle:

- 5 Operating units were US/Canada/Australia/Japan/Netherlands, Order

source of OM, Orders types as Standard and Trade-in, Intended use -

Resale, Warehouses were in-house and external to Cisco for Order

booking, org enabled PIDs, Customers with specific ship-to, bill-to

and VAT no's shipping preferences were opt-in/opt-out, Customers with

exemption certificates and VAT no's, Custom Inv print.

o Tools used: Toad for data-mining, database query. Mercury Test

Director 8.2 for QA testing.

Project / Client: Symantec, Mountain View, California

Role Sr Oracle Apps and Sabrix Duration (04/2008) - (09/2008)

Functional

Software Oracle 11.5.10 AR,OM and Contracts. Sabrix ( Indirect

Transaction Tax )

Project Description : Integration between Oracle and SABRIX (5.0.3.0)

transaction tax management in US, Canada, and EMEA.

Contribution:

o Set up Oracle apps to create reusable data sets for validation in

integrated environment.

o Development Testing -This involved functional, application, regression

and performance testing for Oracle AR, OM and OKS and its integration

with Sabrix. Developed and executed test plans and test cases based on

business requirements.

o Kept record of test progress and results (Risk and Issue logs

maintenance)

o Verified data and investigated product integrity and software

functionality.

o Oracle and Sabrix Documentation delivered were-Functional specs for

Oracle AR and Sbx integration - (Post-installation) for US, Europe OUs

Functional support for Tax solution flow logic (Oracle OE, OKS and

AR) - Tax Estimation (OM, OKS), Tax Actual (Invoice).

o Functional Support for Change Requests (CR) and Software Reqts

Specification (FD) were created for

Business Requirements.

AR interface trigger - for OKS Credit Memos after Sabrix cut-off date,

for PA Credit Memos after Sabrix cut-off date, for RMA Credits after

Sabrix cut-off date, Auto-Invoice Testing when Invoice was pre-cut-off

and tax code on Invoice was Non-Sabrix, Auto-Invoice Testing when

Invoice was post-cut-off and tax code on Invoice was Non-Sabrix)

o Product attribute mappings - this involved Configuration of the Look

Up table, Population of the Look up table by way of script upload,

Product Mapping with Sabrix Tax Category, Value Sets validation for

Sabrix Tax Category attributes, Special Items Mapping: Truncating and

populating - SKU# mapping with Sabrix tax Category Values.

o EDI Extract change -this involved EDI Set-ups, Invoice Printing and

EDI extraction, Creation of Manual Credit Memos, Auto-Invoice -

summary tax line for each invoice line having multiple tax lines.

Invoice Print changes- Custom Invoice Print reports for OUs.Instance

Migration document for Custom Configs. Requirements traceability

matrix for Sabrix quality assurance - business reqts, functional

reqts, Technical reqts, CRs, BA testing, QA testing and UAT testing

was maintained in this matrix, Test matrices (test scenarios, test

cases) created for approved CRs. Sample Prod'n data mined.

o Reported Oracle diagnostics for Auto-Invoicing and Order Entry for the

Sabrix testing done.

o Did Sabrix architecture related Functional support.

o Reviewed Sarbanes-Oxley compliances for Oracle and Sabrix Tax

integration.

o Involved in Tax System Evaluation - comparison of Sabrix and Vertex

based on business requirements.

o Involved in functional design of the Sabrix solution (Sabrix

workbench) -Sabrix configurations, dependencies and extensions

(pre/post calcs)

o Tools Used - Data Loader, SQL Navigator, Remedy Service Management,

PVCS.

Project / Client: Federal Communications Commission (FCC),

SRA, Virginia

Role Sr Oracle Duration (03/2008) - (04/2008)

FinancialsFunctional

Software Oracle Financials - AP,PO,AR,Fed Admin,Budget Execution

Project Description: SRA Demonstrated the Operational Capability for

replacing Federal Communications Commission (FCC) Core Financial System

with Oracle Federal financials.

Contribution:

? Prototype set up of Oracle Federal financials for Budget

Formulation, Budget Execution, Payment Management, Receivable and

Revenue Management, General Ledger Management.

? Prepared Demonstration scenarios for Budget Formulation, Budget

Execution, Payment Management, Receivable and Revenue Management,

General Ledger Management.

? Tested Demo Test Scripts -

Budget Formulation and Execution: tested scripts for budget planning

and preparation, distributing and controlling funds, fund status

reporting.

Payment management: tested scripts for payee information maintenance,

account payable, invoice management, disbursement, and payment follow-

up.

Receivable and Revenue management: tested scripts for customer

information maintenance, receivable and billing, debt management,

collections and offsets, revenue cycle management.

General Ledger Management: tested scripts for account definition,

transaction definition, GL analysis and reconciliation, accounting

period maintenance and closing, and financial reporting.

Project / Client: Kulicke & Soffa Industries, Pennsylvania

and Singapore

Role Sr Oracle Apps Functional Duration (04/2007) - (03/2008)

Software Oracle Applications - GL,AR,AP,PO,FA . Cognos Business

Intelligence, UPK.

Project Description: Functional Upgrade (11.5.8 to 11.5.10) for Oracle apps

and Business Intelligence (Cognos) Functional Production support,

Implementation of Oracle Financial Consolidation & Budgeting in Oracle GL.

Contribution: Acted as facilitator of communication and interface between

senior business managers (VPs) and upper management of IT group and as an

Oracle functional SME / Consultant.

o Performed AS-IS analysis of the existing legacy systems (TM-1) and

presented GAP analysis documents and high level Software Requirements

Document(SRD) and Solutions Design Document(SDD) for the

implementation of Oracle GL .

o Delivered Business requirements (business plan, KPI, project plan),

Functional requirements technical specifications, use case scenarios,

reports)

o Delivered To-Be processes ( flowcharts, etc )

o BI Cognos 8.1.2 implementation support and Integration Testing with

Oracle GL and Oracle AR (TM-1 OLAP tool was replaced with Cognos BI

reporting for analytical, operational and monitoring)

- set up Chart of account multipliers

- supported dimensions data load for Time and Currency, COA,

Company, Cost Center, Product, location, Inter Company, budget

data, facts data load.

- User testing, validated oracle Data and its alignment with Cognos

data

- Functional support for new reports development

- Validated and supported Historical data load

- Supported BI enhancements - additional COA segments, currency

conversion (consolidated SOB to local SOB), COA and other

Segments rollups for reporting, Reports development.

o Supported Migraton Legacy Data to Oracle apps -Configuration data

migrated for Chart of accounts, Org, payment terms, currency,

calendar, tax codes, etc. Master data migrated for item master, item

category, locations, asset category, supplier master, customer, etc.

Transactional data migrated for open AR, open AP, open SO and PO,

historical transactions, etc. Summary balance data migrated for GL

balances, inventory balance and item cost.

- Master and Transactional data mapped to Oracle and consolidated.

- got the data approved from the Users and uploaded to Oracle for

Oracle reports generation.

- Loading tools used: data loader program, sql scripts, Ora-excel

o Discoverer Used - Analytical, Operational reporting-trend analysis,

actual vs. Bud, Trial Bal, Aging.

o FSG Reporting in GL - built custom reports for monthly and quarterly

reporting

o Implemented SOX Controls in Oracle apps - disabled accounts naming

conventions, gatekeepers assigned for system access, internal audit

for system access and approval tracking .removed conflicting access to

record journals, restricted certain transaction types, compensating

controls for database level and Unix level changes. Designed and

Implemented role based Oracle ERP access, supported SOX audit.

o Involved in Implementation of Oracle Financial Consolidation &

Budgeting in Oracle GL

- Pain points dealt with of legacy TM-1 consolidation process: Manual

Consolidation. TM-1 system related issues like Disconnect with other

ERP and Non-ERP BU systems, No Drill Down to Subsidiary Ledgers (LE

Books), and Support Issues. Corporate Level Operating/Accounting

issues like Inter-Company, Reclass, Mapping, Journaling including top

sides, Data security and Access security. Operating Units / BU level

inconsistencies like Multiple Data Centers, Databases and

Environments, Variety of Applications Deployed, Variety of platforms

and Operating Systems, Inconsistent Usage of Applications and Business

Practices. No canned reporting.

- Scope of work / documentation delivered: Project Plan, Requirements

scoping and gathering (RD050), As-is, To-be, Fit-Gaps, Review of

Configuration & Integration Needs (BR-100) (including Data

conversion, Interfaces with PeopleSoft, JDE, Baan, AccPac ) and Data

mapping strategy (RD030) and Prototyping (proof of concept)

demonstrated for select system functionality.

- Details of Consolidation in Oracle GL: Defined Consolidated SOB,

Prepared the Legal Entities Data for Consolidation (Data

Standardization) like Currency Standardization etc (Revalue/Translate

),Created Consolidation mapping -Mapped LE account values to the

Consolidated Parent Values (Roll - ups), Transferred LE Data to

Consolidated Set of Books- Imported data / Loaded Data into

Consolidate Set of Books(Transfer),Consolidation Processing done

-based on consolidation method, rules, tracking changes, incremental

consolidation, real time monitoring, Historical Consolidation (runs)

tracked for incremental consolidation, Adjusted for Consolidation and

Operating transactions( spreadsheet uploads), Automated Inter-company

and intra-company eliminations rules, Automated Consolidation

accounting - rules, Reconciled Statutory Consolidation with Management

Consolidation. Created Reports and Analyzed Consolidated data.

o Used UPK for Budgeting and Fin Consolidation- Created Business Process

guide, User Acceptance Test scripts, Instructor Manual, Training guide

using UPK documentation component. Also conducted web-based user

training using UPK Content-player.

o Involved in Oracle Roadmap creation, Product evaluations,

Presentations to Business, Demos of oracle system functionalities for

Oracle Financials for client VP (Finance) and CEO.

o Provided Functional Production Support for Oracle Financials 11.5.8.

o Tools used: Clarity Project Management, Toad, UPK for User Training,

data loader, Ora-excel, UPK.

Project / Client: First Data Corporation (FDC), Denver, CO

Role Oracle Apps Functional SME Duration (12/2006) - (03/2007)

/ Business Analyst-IT

Business Partner

Software Oracle Applications - AP, FA, GL, AR, PO, Consolidation

including Global Intercompany System (GIS).

Project Description: Oracle Process Improvement for Month End Redesign for

Oracle.

Contribution:

o Documented Current State ( As-Is ) ( BP040) - scoped included

accounting processes in oracle and external systems, interfaces,

reporting requirements (RD080), close calendars of BU's for Oracle AP, FA, GL and AR.

o Close Stabilization - this was achieved through following activities /

recommendations:

Process Evaluation, eliminating non-close critical processes /

activities, Oracle Job Processing Efficiency analysis - Redesign the

processing schedules and reporting for AP, AR, FA, GL including GIS,

Evaluate the reporting tools available within the Oracle environment.

Source System Data Access / Manipulation: automation, accuracy, and

reducing system strain. Best Practices suggestions/ implementation -BU

wise implementation across the Org wrt configurations, accounting,

reporting, Improving SOX related internal control points within

Oracle.

o Documented Future Process Model (To be Process) (BP080) for Oracle AP

month end close - the scope included Supplier Invoicing, pre-payments

to suppliers, Payment Process, in-bound and out-bound interfaces for

invoices and payments, expense invoicing, inter-co accounting from AP

to GIS, Auto-approval - Invoices and payments,Soft Close activities,

Auto-posting to GL,AP accounting, transactions sweep to next period,

AP accruals, AP Reconciliation-internal and external, mass additions,

Post Close - Reporting. It also included Process Flow diagrams for the

same.

This above was achieved through working sessions with Business owners

to discuss proposed future state and framing of the Self Reporting

Questionnaire - for each flow.

o Prepared Process Flowchart for Month-end close for Oracle GL,AR,AP,PO

o Oracle Fixed Assets Redesign: Created Policies and Procedures for

Additions, Retirement and Physical Inventory of Fixed Assets.

Evaluated the current process for acquisition of Fixed Assets and made

recommendations to strengthen the process. Created Depreciation

Methods, Depreciation Rules and Prorate Conventions. Reviewed Mass

Additions, Retirement and Reinstatement of Fixed Assets. Ran Periodic

Mass Copy from the Corp to Tax Book. Set up Locations, Asset Key Flex

fields, Asset Categories and Calendars for Depreciation for Fixed

Assets.

o Oracle AP Redesign: Reevaluated the current invoice processing and

payment process. Implemented batch processing of invoices. Set up

Banks, AP Accounting Calendar and Payment Methods. Created Recurring

Payment Journals. Modified setup for Invoice Aging Report. Created

policy for entering new suppliers.DidSupplier\Merge.

Ran Mass Additions Create Program and verified transfer of invoice

lines to Fixed Assets.

o Documented Global Intercompany system Std Operating Procedure (SOP) /

(To be Process) (BP080) - scope included inter-co AR and AP

transactions which involved laying down inter-co rules relating to PO,

Invoicing, Settlement, Inter-co Accounting involving correct accounts,

inter-co closing process, account reconciliations(due to/due from),

cash application, manual entries, forex inter-co transactions, etc .

The issues/pain points addressed were relating to large accounting

lines for exps, materiality threshold for JE creation, timing of JEs

during month end, Number of intercompany relationships allowed, Using

GIS for intra-company as well as intercompany, Manual effort,

Documentation used to approve GIS entries, Some Oracle BU's not using

GIS,AP interface issues for GIS entries, FA related JEs, out of

balance JEs, forex transactions, GIS approvals workflow, Use of GIS

for non-Oracle GL's, GIS enhancements, GIS Administrators training.

Project / Client: Aluminum Company of America (ALCOA),

Pittsburgh, PA

Role Oracle Apps Functional Duration (08/2006) - (11/2006)

Software Oracle Applications - Oracle 11.5.10 AP, PO, Inventory

Project Description: Sys Admin functions for Procurement (Requisition to

Pay) COE Solution and Process.

Contribution:

o Sys Administration- Request Groups & Request Sets analyzed for Seeded

vs. Custom reports, Read Only vs. Update, What is Updated by the

Updatable Programs / Request Sets, Assess Breadth of Access

o Analyzed all Concurrent programs, Menus, Responsibilities for AP, PO,

and Inventory.

o Evaluated inappropriate access and suggested remedial measures.

o Set Up new users. Created new Custom responsibilities and maintained

users profiles in Oracle.

o Tools used - Toad, UNIX.

Project / Client: US Department of Education, Washington DC

Role Oracle Federal Financials Duration (03/2006) - (07/2006)

Functional

Software Oracle Federal Financials 11.5.10 AP, AR, PO, and GL

Project Description: Functional Reimplementation of Oracle Federal

Financials 11.5.10.

Contribution:

o Oracle AP, PO, GL - Business Requirement (BRD) analysis, To-Be

processes and workflows, Functional Specifications, Custom Reporting

requirements, Enterprise Pilot Documentation.

o CRP executed (AP,GL) - scenarios, issues and action items,

configuration, gaps and issue analysis

o Data Conversion functional testing and Interface testing done.

o Grants Management -Created new Awards and updated GL with the new

Awards

o Tested Federal Reports for GL, AP, AR (SF 1166, Form 1099-G, Facts I,

Facts II, SF 133 Report for Budget Execution Process, etc.)

o Tested Oracle AP cycle: System Set up and Maintenance, Invoicing,

IPAC, P-Card, Payments, Prior Period Receipts, Due date calculation,

Economically Beneficial Discount, Prompt Pay Interest, Treasury

Confirmation, Alerts, GL transfer, Reporting . Year End Closing,

Responsibilities and Menu Security.

o Tested Oracle PO cycle: System Set up and Maintenance, Vendor Online

interface, CPSS online Requisitions, CPSS online Obligations interface

cycle, Receiving, Close and Reconciliation, Reporting .

o Tested Oracle AR and GL cycle: System Set up and Maintenance,

Customer information maintenance,Receivables Establishment, GL

maintenance, Cross validations, Summary Template set ups, GL

periods, GL journals, sub-ledger journals import, GL posting, GL

closing, GL reporting including FACTS reporting, Custom Alerts

testing.

o Developed Use Cases (Iterative) by focusing on adding more details to

the entire Use case set. Also wrote Use cases scenario Extensions for

alternate scenarios and exceptions for covering sys reqts.

o Tools used - Rational Test Manager, Clear quest, Toad

Project / Client: General Electric (GE), Albany, New York

Role Oracle Apps Functional Duration (08/2005) - (03/2006)

Consultant

Software Oracle 11.5.9 AP, PO, GL, I-Procurement. Mark View 170

Systems

Project Description: Oracle Shared Services BU implementation using Six

Sigma Methodology. Verticals Integration with 3rd party 170 Mark view

system imaging soln and Sabrix Tax engine for U.S. sales tax, Int'l VAT

Contribution:

o 170 Mark view Imaging and Approval Workflow solution for Oracle AP

(Buy to Pay Process) - functional set-up done in Oracle AP, Tested 170

sys integration with Oracle Apps & Workflows:

Set-up Org in 170 system (cookbook documented) - Identified 170-AP

Users, Enabled new OU, defined Responsibilities, Generated Mapping

for Responsibilities, Set Profile Option, Assigned Mark View

Concurrent Requests, created Invoice Entry Folders. Set-up Invoice

Error holds resolution process.

o Tested 170 Systems Workflow for Invoice approval and hold

resolution:This involved testing audit trail, workflow monitoring

capability, reporting. The document types used for workflow testing

were pre-approved invoices, Non-PO Invoices, Previously Entered

Invoices, Supplier Documents, Service PO, 3-way PO, and Cr Memo.

o Tested Invoice retrieval and Exception handling workflow, Tracking of

Invoices, their current status with the help of 170 system Queues,

Invoice printing from 170 Mark View Viewer, Oracle invoice inquiry,

open work item functionality, e-mail reminders, invoice cancellation

process.

Tested 170 Systems solution security (access rights and privileges)

based on the Roles defined in the 170 SQL Flow solutions for business

rules. Tested Enhancements for Fetch Markup, Recreation of Markup, E-

mail notification, Routing Priority, Resubmit functionality,

Prepayments.

o Did the role of AP Super User managing supplier base, invoicing and

its approvals, payments, validated AP accounting, employee reports,

payments, monthly period closures, tax accounting review.

o Sabrix-Oracle i-Procurement connection implementation had the CTQs

like Evaluate Vendor-Charged Tax, Evaluate Self-Assessed Tax, Manage

Partial Recoverability, Improve Classification of Tax, and Simplify

VAT Reporting Process. This was achieved by the following OU

implementation activities:

Integrated Sabrix with 170 systems for Oracle AP Invoicing

Workflow.

o Oracle set-ups done like tax codes, accounting, UNSPSC, vendors,

Profile options.

o Tested pre-calc and post-calc procedure of Sabrix and its accounting

customization

o Documented MD-200 Functional design for Sabrix Integration extension -

outlined the Functional details like Setups and Requirements, Business

Rules to select the method of legal entity calculation and tax accrual

accounting, Invoice selection criteria in the AP connector, process

flow diag, proposed solution,etc.

o Documented MD200 Functional design for Invoice on hold accruals

process

Captured Business Requirements for Reconciling Sabrix Tax Activity and

generating reports and data extracts to facilitate tax compliance and

audit.

o Created Sabrix Test cases and scenarios for AP Connection for areas

like Tax estimation at PO level,

o Tested Tax determination for Invoices through 170 system / imported

invoices, tax logic / process testing, data / Sabrix configuration

related scenarios.

o Worked as Super User for I-Procurement. Supported day-today operation

of I-Procurement. Troubleshoot End user queries. Set up issues from

the creation of a requisition, populating charge accounts for General

Funds and Special Funds, changing the Deliver-to-Location and the

creation of the order.

o Tested iProcurement Security, Approval Hierarchy, Creation and

conversion of Requisition to PO.

o Testing done for Matching of Invoices in Accounts Payables to Purchase

Orders.

Changed /Modified User Profiles and Delivery Locations. Trained End

users in I-Procurement.

o Automated Oracle AP period close process- Prepared Functional specs

involving Business data gathering and diagnostics for Pre-close

requisites, actual close process, accruals, close reporting, post

close process, AP Reconciliation and GL Reconciliation.

o Implemented new functionalities including Customizations- Functional

aspects of customizations built to meet client requirements.

o Tools used: ADI, Oracle AIM, Oracle Metalink.

Project / Client: Federal Aviation Administration (FAA),

Washington DC

Role Oracle Federal Financials Duration (04/2005) - (07/2005)

Software Oracle Applications 11.5.9 AR, Project Accounting, Fed

Financials and Public sector Budgeting integration, GL.

Project Description: Implementation Support for Oracle AR, Projects and GL

(version 11.5.9) involving support strategy, providing support, user

acceptance and monitoring support.

Contribution:

o Did as-is analysis, requirements gathering, solution design, all

testing and UAT cycles, conversion, go-live and post go live support.

Authored all AIM documents for RICEW components for Oracle Projects.

o Reported -Daily and weekly reporting / status of Oracle AR,GL and

Projects issues and their resolutions

o Supported Error / issue analysis, resolution of errors, Creation of

Service change requests (SCR)

o Documented issue wise process for Oracle AR and Projects post-

implementation error resolutions.

o Fed Financials and Public sector Budgeting integration - worked on

release content document (11i10) including overview, new features like

Data Extract By Org,integration/dependency of Public sector budgeting

with U.S. Federal Financials Budget Execution, documenting PSB set-ups

like accounting sets, elements, functional sets, rules, attributes,

G/L, group and budget year types, calendar, position attribute values,

position sets, data extract, budgeting profile options, budgeting

group and security, GL interface, GL budget set, Budget revision set-

up, responsibilities, function security, users, entering/uploading

budget. Worked on budgeting cycle, org structure (employee, hierarchy,

account structure), budget types, position and non-position setups,

budgetary control, set-up excel spreadsheet interface for budget

import.

o Designed functional requirements specification for Oracle AR, GL and

Projects.

o Updated Year end check list and procedures, Maintained test scripts

used for training and testing

o Tools used: Oracle Metalink, ADI, Oracle Application Implementation

Methodology (AIM).

Project / Clients: Kanbay Software, Taj Group of Hotels,

Kirloskar Group, Modi - Xerox, Kimberly Clark, Kinetic

Engineering

Role Oracle Apps Functional Duration (12/1997) - (02/2005)

Consultant

Software Oracle 11.5.5, 11.5.9 Project Accounting, iExpense, AP, AR,

GL. Noetix Reporting tool.

Projects Description: Full Life cycle implementation, Rollout, Post-

implementation support and upgrade of Oracle Applications 11i (11.5.5 to

11.5.9), customizations for the OUs with multiple set of books and MRC.

Lead User of Oracle PA, GL, AR, AP, FA. Oracle Financial Analyzer (OFA),

FSG Consolidation & reporting. Supported Cash Management, Treasury,

Purchasing, GL, System admin modules.

Contribution:

o Documented BRD, mapped to Oracle, analyzed fit/gaps, solution

designed, configured oracle, did unit, system testing and User

Acceptance Test. Worked with QA to ensure product quality of Release.

o Documented Set-ups (BR-100), Functional Design specs (MD-200), Data

Conv (CV010) Legacy-Oracle.

o Did Patch Testing, Workflow tests, Functionally supported Custom

Interfaces and Data Migration

o Project Accounting: Oracle Projects Costing and Billing: Internal

corporate resource to Oracle Project Costing and Project billing.

Assisted with functional tasks during upgrade from R10.7 to R11.03.

Key responsibilities included configuration, maintenance and testing

as well as management of PA month end closing tasks. Responsible for

the integrity of accounting journal entries generated during the

Project Accounting Costing, Billing, and Invoicing and closing

processes

o Designed & coded all Auto Accounting Rules. Functional support for

Designing & coding of many extensions like Project Security Extension,

Transaction control Extension. Billing Extension. Worked on Interfaces

& Conversions.

o Performed AR Super User and User roles as a Business analyst for

customer invoicing, correcting AR transactions, auto invoicing,

receipt applications, managing collections, monthly period closures

and taxation.

o As a GL super user, maintained COA, processed GL journals, did month

end and Year end closings of books, ran and analyzed financial

reports.

o Set-up i-Expenses as an extension Oracle Payables

o Supported Purchasing and Payables with integration with iProcurement,

supplier, iExpenses, Services Procurement, Sourcing, Procurement

Contracts, Approval Management, EBTax, and Payments

o Did the role of Purchasing super user I have managed the supply base,

did set-ups, managed requisitions, PO and receipt/ inspection process.

o Supported Post- implementation issues for Oracle GL, AR, AP and

Projects, i-expenses, Noetix rollout functional support (Reporting

Tool).

o Set up Financial Statement Generator (FSG) reports in Oracle General

Ledger including various financial reports Balance Sheet and P&L

o Supported Monthly Accounting Closure of Oracle GL, AR, AP Project and

i-Expense modules.

o Analyzed and mapped Requirements for GL, AR, AP-Debtors/Creditors,

online consolidation, allocation of budget and exps, inter-co Acctg

and adjustment of books, closing Annual accounts, capability for

enabling new orgs, drill down and comparison of data.

o Validated Interfaced GL data from external system to the Oracle GL for

GL reporting. Reconciled Sub-ledgers to GL.

o Generated and Published periodic Financial Reports and ensured its

integrity with respect to accounting segment value structure. Also

ensured that financial data generated from Oracle GL, through

different reporting applications are also in synch.

o Oracle Cross Functional Training given for Oracle GL, AR and AP

modules

o Set-ups and validations done for Oracle GL, AR, AP. ( eg - Global

Chart of Accounts Design )

o Responsible for providing functional knowledge of Oracle EBS and

providing functional leadership for implementing the EBS General

Ledger, Project Accounting and Fixed Assets and their integration

with AP, AR and Purchasing.

o Integration / interface- requirements identified, supported interface

dev /API program and its validation and user acceptance (eg- invoice

details and customer details to Oracle AR, payroll details and other

offline hotel finance interfaces to Oracle GL).

o Supported Customization components for Gaps- for Oracle reports,

Discoverer reports.

o Legacy Data migrated - identified requirements, helped in developing

data migration program and its validation and user acceptance (Chart

of accounts, JVs, Customers, Open Invoices, supplier details, Bank

master -used scripts and ADI for migration).

o Global Consolidation System (Oracle GL- TB data) -finalized

consolidation levels, recalculations for consolidation Acctg,

translations, elimination entries, etc, creating consolidation fin sts

and schedules.

o UAT (TE130) delivered for Oracle GL, AR, AP- for set-ups,

customizations, interfaces, and data migrated. Testing strategy was

formulated, prepared business scenarios, Conf room workshops and

Integration test specifications were prepared for testing and

Acceptance.

o Knowledge Transfer to Key Users / Process Owners and End users

o Documentation done (Package implementation methodology, AIM): Business

Requirements and Gap Analysis (RD-050,BR-050), To-Be processes and

workflows (i.e. Process Maps- MD080), Set-ups (BR100), Functional

Design specifications (MD 200)

o Involved in Post Implementation Support- support strategy.

o Tools used for implementation and post implementation support: SQL

plus, Toad, Account Hierarchy Editor (AHE), Oracle Metalink, Data

loader, ADI, FSG, Oracle AIM.

o Configured, Tested and documented 11i upgrade related enhancements :

o Tested GL data migration for 11i

o Supported functional UAT plan for 11i upgrade for Oracle

GL,AR,AP,PO,FA, Inventory and OE

o Monthly FSG Consolidation done in Oracle GL

o Set-up Monthly period closure procedures for Oracle GL, AR and AP

modules.

o Oracle Financial Analyzer (OFA) - Implementation functional / User

support.

o Supported functional Production issues, trained end users / accounting

staff and documented training.

o Managed RFC (Request for Change) projects, Initiated all TARS for the

Finance modules.

o Tools used: SQL plus, Toad, Acct Hierarchy Editor (AHE), Oracle

Metalink, Data loader, ADI, FSG.

o Cash Management: Setup banks, branches and accounts in Cash Management

Module and linked them to AP, AR, and XTR in order to reconcile bank

statements vs. company's transactions recorded in the system. Set up

CE for Cash Flow Positioning and Forecasting on AR, AP, XTR

transactions. Ran reports on Treasury related items in Cash

Management for Cash Flow Positioning and Forecasting. Created Test

Scenarios and Business Process Threads for UAT for Cash Management.

Ran Monthly Bank Reconciliation Report to check monthly AP Check

Activity.

o Supported Implementation of Treasury, Purchasing and GL

o Sys Admin: Set Up new users in Oracle Financials and maintained users

profiles.

o Tools used: Toad, SQL Plus, Oracle Meta link - database query, SQL

queries, analyzed underlying structure of the Oracle Apps tables.[pic]

Contact this candidate