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]