Sr Oracle Functional Consultant , Lead Business Analyst R12 Prism Functional Oracle Certified

Professional Summary:

• More than 13 years of strong Functional Design, Functional Development support, Implementation and Testing experience in Oracle Applications 12i/11i/11.0/10.7/10.5 AR, AP, PO, iProcurement OM, GL, Projects, Inventory, Cash Management, Asset, Treasury, AME, Oracle iExpense and Oracle iTime modules.
• 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.
• Business Analysis experience developed business requirements, Process designing, Systems analysis involving delivering business plan, Functional requirements, 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, Taxation, Financial Consolidation Hub, Internal Controls Manager, I Expenses, AP, AR, Daily BI.
• Experience in Six Sigma Methodology for Oracle Applications. BI Cognos Functional Implementation support and validations, data alignment with Oracle Apps. Oracle Federal Financials, Public sector functional implementation, upgrade and testing of Oracle AP, PO, AR, GL, Projects, Fed Admin, Fed Budgeting, Public Sector Budgeting 12i, Prism, Sunflower Assets, and Federal Reporting, Federal Accounting. Worked on Federal Fin Demo executions. Exposure to FASAB Federal and GASB Public Sector Accounting Standards. IT Governance related functionalities for Oracle apps. Eg Sox compliances for Internal Control.
• 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 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.
• Very 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 Strong analytical ,interpersonal, communication, and client facing skills at all levels of Management Customer Service attitude, Strong Work ethics.

Projects Profile

• 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
• Did Production support for Federal Financials 11.5.10 GL, AR, AP, PO, I procurement, Sys Admin, Fed Admin, and Projects modules.
• 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 Process for Requisitions, RFQ, Suppliers, Orders, Receiving, invoicing and Payments for standard and Custom solutions.
• 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.
• Supported Grants extension interface GATES system , Performance and Reconciliation Enhancements
• Worked on Performance areas including Grants to GL Interface, and Receivables Transfer to GL, etc.
• Supported Troubleshooting of eTravel interface GovTrip related functionality issues in UFMS
• 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 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.
• 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.
• 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.
• 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 change Requests Std and Custom changes , Regression tests for Finance , Inventory .module scenarios, Custom and Std Report validations.
• 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 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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. 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.
• 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.
• 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.
• 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.
• System Testing done Unit, Integrated Testing Tested PSB Configurations, Budget Creation/Revisions, Excel Interface, GL postings, Reports, Conversions, and Interfaces.
• End User PSB Training done for Standard PSB functionality, Customizations, Conversions, Interface. Reports, Workflow, Application Security and System Security.
• 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.
• Go Live Readiness check being done for data conversion, interfaces, PSB application,system integration,reporting.

• Project Description: Confidential 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
• 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 and translated user requirements into use cases for the development team
• 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 Re to Procure and Procure to Pay integration
• Data mapped between Oracle and Sunflower Asset system for Fixed Assets FA integration.
• 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 re 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
• Purchasing: Set up done for accounting, suppliers, items, supplier sourcing, document approvals, requisitions, POs, workflow and, receiving transactions.
• 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.
• 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
• 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, 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.
• 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/Re amendments, Re 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 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 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:

• 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
• 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.
• Performed AS IS analysis for Order Management and Contracts integration with Receivables through Open Interface.
• Documentation and Review Business Requirements BRD for Oracle Quote to Cash and Indirect Taxes Sabrix to integrate products into Oracle Quote to Cash processes, systems and financial reporting to enable Joint Orderability on a single PO. 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
• 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.
• 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
• 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.
• Tools used: Toad for data mining, database query. Mercury Test Director 8.2 for QA testing.

Project Description : Integration between Oracle and SABRIX 5.0.3.0 transaction tax management in US, Canada, and EMEA.

Contribution:

• Set up Oracle apps to create reusable data sets for validation in integrated environment.
• 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.
• Kept record of test progress and results Risk and Issue logs maintenance
• Verified data and investigated product integrity and software functionality.
• 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 .
• 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
• 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.
• EDI Extract change this involved EDI Set ups, Invoice Printing and EDI extraction
• Create 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.
• Oracle diagnostics for Auto Invoicing and Order Entry was reported for the Sabrix testing done.
• Sabrix architecture related Functional support
• Sarbanes Oxley compliances reviewed for Oracle and Sabrix Tax integration
• Involvement in Tax System Evaluation comparison of Sabrix and Vertex based on business reqts
• Involved in functional design of the Sabrix solution Sbx workbench this was for Sabrix configurations, dependencies and extensions pre/post calcs
• Tools Used Data Loader, SQL Navigator, Remedy Service Management, PVCS.

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 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.
• 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 . Delivered Business requirements business plan, KPI, project plan , Functional requirements technical specifications, use case scenarios, reports Delivered To Be processes flowcharts , etc 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.
• 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
• Discoverer Used Analytical, Operational reporting trend analysis, actual vs. Bud, Trial Bal, Aging. FSG Reporting in GL built custom reports for monthly and quarterly reporting 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. 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.
• 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.
• Involved in Oracle Roadmap creation, Product evaluations, Presentations to Business, Demos of oracle system functionalities for Oracle Financials for client VP Finance and CEO.
• Provided Functional Production Support for Oracle Financials 11.5.8. Tools used: Clarity Project Management, Toad, UPK for User Training, data loader, Ora excel, UPK.

Project Description: Oracle Process Improvement for Month End Redesign for Oracle.

Contribution:

• 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.
• 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.
• 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.
• 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. 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.
• 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.
• 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 Description: Sys Admin functions for Procurement Requisition to Pay COE Solution and Process.

Contribution:

• 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
• Analyzed all Concurrent programs, Menus, Responsibilities for AP, PO, Inventory.
• Evaluated inappropriate access and suggested remedial measures.
• Set Up new users. Created new Custom responsibilities and maintained users profiles in Oracle.
• Tools used Toad, UNIX.

Project Description: Functional Reimplementation of Oracle Federal Financials 11.5.10.

Contribution:

• Oracle AP, PO, GL Business Requirement BRD analysis, To Be processes and workflows, Functional Specifications, Custom Reporting requirements, Enterprise Pilot Documentation.
• CRP executed AP,GL scenarios , issues and action items , configuration , gaps and issue analysis
• Data Conversion functional testing and Interface testing done.
• Grants Management Created new Awards and updated GL with the new Awards
• Tested Federal Reports for GL, AP, AR SF 1166, Form 1099 G, Facts I, Facts II, SF 133 Report for Budget Execution Process, etc.
• 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.
• 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 .
• 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.
• 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.
• Tools used Rational Test Manager, Clear quest, Toad

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:

• 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
• 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.
• 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.
• 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.
• 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
• Oracle set ups done like tax codes, accounting, UNSPSC, vendors, Profile options
• Tested pre calc and post calc procedure of Sabrix and its accounting customization
• 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.
• 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.
• Created Sabrix Test cases and scenarios for AP Connection for areas like Tax estimation at PO level, Tested Tax determination for Invoices through 170 system / imported invoices, tax logic / process testing , data / Sabrix configuration related scenarios.
• 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. Conduct QA Tested iProcurement Security, Approval Hierarchy, Creation and conversion of Requisition to PO.QA 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.
• 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.
• Implemented new functionalities including Customizations Functional aspects of customizations built to meet client requirements.
• Tools used: ADI, Oracle AIM, Oracle Metalink.

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:

• 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.
• Reported Daily and weekly reporting / status of Oracle AR ,GL and Projects issues and their resolutions
• Supported Error / issue analysis , resolution of errors, Creation of Service change requests SCR
• Documented issue wise process for Oracle AR and Projects post implementation error resolutions.
• 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.
• Designed functional requirements specification for Oracle AR, GL and Projects.
• Updated Year end check list and procedures , Maintained test scripts used for training and testing
• Tools used: Oracle Metalink, ADI, Oracle Application Implementation Methodology AIM .

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:

• 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.
• Documented Set ups BR 100 , Functional Design specs MD 200 , Data Conv CV010 Legacy Oracle.
• Did Patch Testing, Workflow tests, Functionally supported Custom Interfaces and Data Migration
• 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
• 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.
• 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.
• As a GL super user, maintained COA, processed GL journals, did month end and Year end closings of books, ran and analyzed financial reports.
• Set up i Expenses as an extension Oracle Payables
• Supported Purchasing and Payables with integration with iProcurement, supplier, iExpenses , Services Procurement, Sourcing, Procurement Contracts, Approval Management, EBTax, and Payments
• Did the role of Purchasing super user I have managed the supply base, did set ups, managed requisitions, PO and receipt/ inspection process.
• Supported Post implementation issues for Oracle GL, AR, AP and Projects, i expenses, Noetix rollout functional support Reporting Tool .
• Set up Financial Statement Generator FSG reports in Oracle General Ledger including various financial reports Balance Sheet and P L
• Supported Monthly Accounting Closure of Oracle GL, AR, AP Project and i Expense modules.
• 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.
• Validated Interfaced GL data from external system to the Oracle GL for GL reporting. Reconciled Sub ledgers to GL.
• 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.
• Oracle Cross Functional Training given for Oracle GL, AR and AP modules
• Set ups and validations done for Oracle GL, AR, AP. eg Global Chart of Accounts Design
• 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.
• 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 .
• Supported Customization components for Gaps for Oracle reports, Discoverer reports.
• 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 .
• Global Consolidation System Oracle GL TB data finalized consolidation levels, recalculations for consolidation Acctg, translations, elimination entries, etc, creating consolidation fin sts and schedules.
• 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.
• Knowledge Transfer to Key Users / Process Owners and End users
• 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
• Involved in Post Implementation Support support strategy.
• Tools used for implementation and post implementation support: SQL plus, Toad, Account Hierarchy Editor AHE , Oracle Metalink, Data loader, ADI, FSG, Oracle AIM.
• Configured , Tested and documented 11i upgrade related enhancements :
• Tested GL data migration for 11i
• Supported functional UAT plan for 11i upgrade for Oracle GL,AR,AP,PO,FA, Inventory and OE
• Monthly FSG Consolidation done in Oracle GL
• Set up Monthly period closure procedures for Oracle GL, AR and AP modules.
• Oracle Financial Analyzer OFA Implementation functional / User support.
• Supported functional Production issues, trained end users / accounting staff and documented training.
• Managed RFC Request for Change projects, Initiated all TARS for the Finance modules.
• Tools used: SQL plus, Toad, Acct Hierarchy Editor AHE , Oracle Metalink, Data loader, ADI, FSG.
• 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.
• Supported Implementation of Treasury, Purchasing and GL
• Sys Admin: Set Up new users in Oracle Financials and maintained users profiles.
• Tools used: Toad, SQL Plus, Oracle Meta link database query, SQL queries, analyzed underlying structure of the Oracle Apps tables.