SUMMARY:

• More than 13 years of strong Functional Design, Functional Development support, Implementation and Testing experience in Oracle Apps (Commercial/Federal Financials) Oracle 12i/11i/ 11.0/10.7/10.5 (AR, AP, PO, iProc, OM, GL, SLA, Projects, Inventory, Cash Management, Fixed Asset, Treasury, AME, iExpenses, iSupplier and iReceivables )
• Full SDLC project implementation experience includes - data conversions, supporting custom apps development, gap 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 FSDs, Use Cases, UAT. Project Management.
• Oracle 12i Assessment and support- Lead Oracle Functional, Oracle Business Analyst -Multi-Org Access, Oracle GL, Cash Mgt, SLA, Legal Entity, GIS, EB-Tax, FCH, Internal Controls Manager, AP, AR, GL, Project Accounting, PO, iProcurement, Order Management and Inventory.
• Experience in Six Sigma Methodology for Oracle Applications.
• BI (Cognos) Functional Implementation support and validations, data alignment with Oracle Apps.
• 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.
• IT Governance- Sox compliances for Internal Control. Supported Oracle GRC for Real-Time Enforcement of SOD and Access Policies. SOD Assessment and Remediation Process - Gathered SOD conflicts, Analyzed SOD Output, did remediation and clean up.
• Oracle Process Improvement - Oracle GIS, Month End Redesign of Oracle AP, FA, GL, AR flows.
• Oracle Financial Analyzer (OFA) - Functional User for Financial Reporting.
• Domain knowledge of Finalization of Accounts, MIS, Costing, Management Acctg, Budgetary Control, Audits - Statutory Internal Audits, Tax Audits, Management Audits and Cost Audits.
• Tools / Software used: Oracle apps 12i/11i/ 11.0/10.7/10.5 , Toad, PL/SQL, SQL* Plus, SQL* Loader Data loader, ADI, Account Hierarchy Editor (AHE), FSG-based reports, Oracle Meta link, Noetix, Oracle AIM, Sabrix Tax engine, 170 Systems, Kintana, Clarity Project Mgt, 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.
• Good understanding of Business Acctg Theories and Practices and Financial Business Processes
• Knowledge of Application Table Structures and their relationships across tables.
• User Training development -Oracle Financials and SCM
• Working knowledge of Agile and Waterfall models - SDLC methodologies
• Strong A nalytical, C lient-facing skills , Customer Service attitude and High w ork ethics

PROFESSIONAL EXPERIENCE:

Lead / Sr Oracle ERP SME/BA/QA

Confidential, Ohio

Environment: Oracle Apps 12.1.3, Microsoft Dynamics AX, Oracle 11g, Hyperion 11.1.1.2, Basware, Zycus contract mgt. IBM Rational RequisitePro.

Responsibilities:

• Lead Requirements Gathering workshops (JAD) for Procure to Pay, Order to Cash, and Record to Report business process. (Oracle GL, AP/PO, iProcurement, AR, Order Management modules - Local and International Operating Units). Demonstrated R12 Functional Experience of Oracle EBS AP, AR, GL, PO, iProcurement, Order Management, Project Accounting, Purchasing and Inventory.
• Documented Business Requirement Document (BRD-RD120), Prepared Business Case Summary for the Requirements in scope for Oracle apps enhancements. Applied Agile Methodology (Requirements to QA) and performed Scrum Master Role - did Acceptance test-driven development for UAT testing, Developed UML based use cases, workflow, and screen mock-ups, user stories (P toP, Order to Cash, Oracle EDI enhancements, etc). Maintained Traceability Matrix (Use Cases to Test Cases)
• Evaluated existing business, operational flows and defined As-Is and To-Be process models. Did Functional fit-gap analysis. Worked with users to understand and recreate system problems
• Documented setups (BR100), Functional Design Specs (MD050) for Oracle AP, AR, Cash Management, eBusiness Tax, Fixed Assets, GL, Project Accounting, Purchasing, Inventory, Order Management.
• Supported Application Extension design (MD 070) for Oracle AP, PO, Order Management extensions.
• Master Data Management - evaluated design, cleansing of Supplier /Customer master data and COA.
• Lead Citibank V-Card Requirements gathering for Working capital/Rebates efficiency
• Performed 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.

Confidential, MD

Funcitional SME

Environment: Oracle Federal Financials 11.5.10,Compusearch Prism 6.3 and 7.1,Sunflower 4.5 (PMIS)

Responsibilities:

• Did Production support for Oracle Federal Financials 11.5.10 - GL, AR, AP, PO, I-procurement, Sys Admin, Fed Admin, and Project accounting.
• 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.
• Performed Systems analysis using business rules and requirements for Oracle, Prism applications
• Configured and Tested Oracle Procure to Pay, Order to Cash and Records to Report business process.
• Supported Grants extension interface ( GATES system), Performance and Reconciliation Enhancements
• Supported Troubleshooting of eTravel interface (GovTrip) related functionality issues in UFMS
• Worked on Performance areas including Grants to GL Interface Receivables Transfer to GL, etc.
• Resolved MFAR code and data issues within Oracle AR module.
• Worked on Data fixes for - IPAC, Cash Management, Grants, Supplier management, MFAR.
• Managed Release Defects in IT, Regression, UAT phases of each release as POC for Apps Support Team
• Involved in Patch analysis, User Provisioning.
• Did Reporting on The American Recovery and Reinvestment Act (ARRA), 2009 for agency set of books.
• Involved in Yearend support testing in the Mock Instances.
• Involved in 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.
• Performed Oracle Federal Financials Configuration & Testing of Release / Non point Release CRs (Standard, 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.
• Supported GTAS (Government wide Treasury Account Symbol Adjusted Trial Balance System) analysis for bulk file uploads, validated GTAS reporting. Patches analyzed for GTAS Reporting requirement for replacing FACTS I/II functionality. Tested / validated GTAS test scenarios, did error resolutions.
• 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.
• 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.
• Supported Sunflower (PMIS) application for Fixed Assets Testing of Release/Non point Release Code changes (Std and Custom changes), Regression tests for Finance and Inventory .module scenarios.
• 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

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.

Confidential, Mississippi

Lead Oracle 12i Public Sector Budgeting Consultant

Environment: Oracle Apps 12i - Oracle Public Sector Budgeting, GL, Budget Legacy System - Cayenta.

Responsibilities:

• Assessed Business Needs/ Analyzed Fit Gaps (BR150) for Public Sector Budgeting.
• Interfaced with business users for User Requirements and any need for customization
• Finalized PSB Deliverables based on Fit gaps/ CRP sessions- Functional specs.
• Prepared Future State Design (FSD) 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.
• Legacy conversion (CV040, CV130)-identified data, established data conversion rules. Legacy data converted was Budget load- current year and history, Actual expenditures, encumbrances, COA mapping
• Configured PSB and GL, Established Budget Groups and Budget Revision Rules.
• Configured Budget System maintenance functionality
• 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.
• End User PSB Training done for Standard PSB functionality, Customizations, Conversions, Interface. Reports, Workflow, Application Security and System Security.

Confidential , VA

Lead Oracle Functional Analyst

Environment: Oracle R12, 11.5.10 PO, I-Proc, AP, GL, Budgeting, Fed Admin, Inventory. Prism, Sunflower Assets, RM online.

Responsibilities:

• Functional Set-ups- Oracle iProcurement, PO, AP, GL, Inventory, Fed Admin, Bud Execution, and Prism
• Mapped Oracle Governance, Risk, and Compliance Controls (GRC) for Demo Use cases (R12 testing).
• 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,
• AR/AP federal demo functionality set-up. Set-up inventory for Transaction accounting, Items and UOM.
• 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.
• 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.
• OBIEE Reporting Requirements gathered, data mining done - GL, Budget, iProc, PO and Fixed Assets.

Confidential, San Jose, California

Sr Oracle Apps Functional Consultant

Environment: Oracle 11i Quote to Cash (OM, Inventory), Sabrix ( Indirect Transaction Tax ), Project Accounting

Responsibilities:

• Set ups done (BR100) for Oracle Order to Cash and Financial Reporting Test Cycles
• Partnered with business process team lead during current state analysis and requirements gathering and contributed to future state solution design.
• Performed AS-IS analysis (RD120), Configured CRP instance for Order Management and Contracts integration with Receivables through Open Interface.
• Provided SME inputs on decisions and priorities regarding Role Based Access Control (RBAC). Worked with members of the application development teams to design and integrate applications with Role-Based Access Control system (RBAC). Contributed to GRC process automation.
• Sabrix (Indirect Transaction Tax) - documented BRD, Current process flows.
• Tested Oracle Quote to Cash and Sabrix tax scenarios for OUs - US/Canada/Australia/Japan/Netherlands
• Tools used: Toad for data-mining, database query. Mercury Test Director 8.2 for QA testing.

Confidential, Mountain View, California

Sr Oracle Apps and Sabrix Functional

Environment: Oracle 11.5.10 AR,OM and Contracts. Sabrix 5.0.3.0 ( Indirect Transaction Tax )

Responsibilities:

• Set up Oracle apps for Sabrix, did Sabrix architecture related Functional support, contributed to functional design of the Sabrix solution (Sabrix workbench) - Sabrix configurations, dependencies and extensions (pre/post calcs)
• Development Testing done (TE040, TE060) - 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 for AR interface trigger, Product attribute mappings, etc
• Oracle and Sabrix Documentation delivered -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).
• Supported 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.
• GRC analysis done - Reviewed the Segregation of Duties (SOD) controls, and developed operational compliance and security provisioning processes. Helped client with the remediation process including but not limited to report generation, incident analysis and clean-ups. Performed end user training and documenting procedures for Oracle GRC processes and controls.
• Reported Oracle diagnostics for Auto-Invoicing and Order Entry for the Sabrix testing done.
• Reviewed Sarbanes-Oxley compliances for Oracle and Sabrix Tax integration.
• Contributed to Tax System Evaluation –Sabrix vs Vertex based on business requirements. functional design of the Sabrix solution (Sabrix workbench) –Sabrix configurations, dependencies and extensions (pre/post calcs)

Tools: Used: Data Loader, SQL Navigator, Remedy Service Management, PVCS.

Confidential, Virginia

Sr Oracle FinancialsFunctional

Environment: Oracle Financials – AP,PO,AR,Fed Admin,Budget Execution

Responsibilities:

• Set up Prototype for Oracle Federal financials - 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 Oracle Demo Test Scripts for Budget Formulation and Execution, Payment management, Receivable and Revenue management and General Ledger Management tested scripts for account definition, transaction definition, GL analysis and reconciliation, accounting period maintenance and closing, and financial reporting.

Confidential

Sr Oracle Apps Functional Lead

Environment: OracleApps 11.5.10–GL,AR,AP,PO,FA,AME, iexpense, iSupplier.Cognos BI, UPK, FSG.

Responsibilities:

• Performed AS-IS analysis (RD120) of the existing legacy systems (TM-1),did GAP analysis (BR150 and BR050), Software Requirements Document(SRD), Oracle GL- MD 50 Functional design ,GL To-Be processes.
• Lead the Functional Upgrade Testing for Oracle GL,AR,AP,PO,FA,iexpense ( 11.5.8 to 11.5.10 )
• BI Cognos 8.1.2 implementation support and Integration Testing with Oracle GL and Oracle AR (TM-1 OLAP tool replacement with Cognos BI reporting for analytical, operational and monitoring)
• Supported Migration of Legacy Data to Oracle, Oracle Discoverer enhancements
• Conducted customer-focused user training course for Oracle iSupplier
• FSG Reporting in GL - built custom reports for monthly and quarterly reporting
• Implemented SOX Controls in Oracle apps.
• Supported Implementation of Oracle Financial Consolidation & Budgeting in Oracle GL
• Performed UPK based testing for Budgeting and Fin Consolidation – Created Business Process guide, User Acceptance Test scripts, Instructor Manual, Training guide using UPK documentation component. Conducted web-based user training using UPK Content-player.
• Involved in Oracle Roadmap creation, Product evaluations, Presentations-Oracle Demos to Business.
• Provided Functional Production Support for Oracle apps- GL,AR,AP,PO,FA,iexpense
• Tools used: Clarity Project Management, Toad, UPK -User Training, data loader, Ora-excel, sql scripts.

Confidential, Denver, CO

Oracle Apps Functional SME/Business Analyst-IT Partner

Environment: Oracle Apps 11.5.10– AP, FA, GL, AR, PO, Consolidation-Global Intercompany System (GIS).

Responsibilities:

• Documented Current State (As-Is BP040) for Oracle AP, FA, GL and AR.
• Supported Period Close Stabilization – did Process Evaluation, eliminated non-close critical processes / activities, Oracle Job Processing Efficiency analysis and Redesign and reporting for AP, AR, FA, GL
• Documented Future Process Model (To be Process) (BP080) for Oracle AP month end close
• Prepared Process Flowchart for Month-end close for Oracle GL,AR,AP,PO
• Oracle Fixed Assets Redesign: Created Policies and Procedures for Additions, Retirement and Physical Inventory of Fixed Assets.
• Oracle AP Redesign: Reevaluated the current invoice processing and payment process. Implemented batch processing of invoices.
• Documented Global Intercompany system Std Operating Procedure (SOP) and To be Process- (BP080)

Confidential, Pittsburgh, PA

Oracle Apps Functional SME

Environment: Oracle Apps 11.5.10 AP, PO, AME, Inventory

Responsibilities:

• Sys Administration analysis - Request Groups & Request Sets analyzed for Seeded vs. Custom reports, Read Only vs. Update for Programs / Request Sets
• Analyzed all Concurrent programs, Menus, Responsibilities for AP, PO, and Inventory.
• Set Up new users. Created new Custom responsibilities and maintained users profiles in Oracle.

Tools: used: Toad, UNIX.