Professional Summary:

• 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, Fixed Asset, Treasury, AME, Oracle iExpense and Oracle iTime.
• qIT Governance related functionalities for Oracle apps. Eg - Sox compliances for Internal Control. Supported Oracle GRC for Real-Time Enforcement of SOD and Access Policies. Evaluated Sarbanes Oxley SOX Compliance. Worked on SOD Assessment and Remediation Process - Gathered SOD conflicts, Analyzed SOD Output, did remediation and clean up.
• 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.
• 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.
• 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, EB-Tax, Financial Consolidation Hub, Internal Controls Manager, I-Expenses, AP, AR, PO, Daily BI.
• 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.
• Oracle Process Improvement Oracle GIS, Month End Redesign of Oracle AP, FA, GL, AR flows.
• Oracle Financial Analyzer OFA Functional User for Financial Reporting.
• Financial Reporting and Analysis in US GAAP and International Accounting Standards.
• 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 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.
• Very good understanding of Business Acctg Theories and Practices and Financial Business Processes
• Knowledge of Application Tab le Structures and their relationships across tables.

Projects Profile

• 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.
• 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 tests 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.

• Assessed Business Needs/ Analyzed Fit Gaps for Public Sector Budgeting.
• Interfaced with business users for User Requirements and any need for customization
• Demonstarted Best Practices for Budgeting of PSB functionality.
• 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 specs-identified data, established data conversion rules. Legacy data converted was Budget load- current year and history, Actual expenditures and encumbrances, COA elements mapped
• 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.
• Go Live Readiness check being done for data conversion, interfaces, PSB application,system integration,reporting.

• 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,
• Mapped/Scoped Oracle Governance, Risk, and Compliance Controls GRC for Demo Use cases R12 testing .
• Functional Set-ups- Oracle iProcurement, PO, AP, GL, Inventory, Fed Admin, Bud Execution ,and Prism
• Pre-Demo Activities accomplished: Requisitions, Funds Check, Awards creation Acknowledgement, and Fixed Assets FA Creation. Finalized Assumptions, Business Process flows. Gathered, Translated user requirements into UML Use Cases Activity Diagrams. Created High level and Low level design documents. 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.
• Specific AR/AP federal demo functionality set-up. Inventory set-up: set-up inventory for Set of Book designed, 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.

Contribution:

• Set ups done BR100 for Oracle Order to Cash and financial reporting for 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 and 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 5 Operating units - US/Canada/Australia/Japan/Netherlands
• Tools used: Toad for data-mining, database query. Mercury Test Director 8.2 for QA testing.