SUMMARY

• More than 16 years of experience and expertise in various stages of software development life cycle and project life cycle using Oracle Applications, Oracle database and Oracle tools.
• Expertise in Configuring Oracle Cloud Applications R12 and R13.
• Expertise in R12 upgrade from 11.5.10
• Expertise in setting up SLA configurations.
• Expertise in resolving any SLA issues
• Expertise in R12 upgrade assessments
• Expertise in Oracle cloud modules such as Supplier invoice Processing, Expenses, Fixed assets, Customer invoice processing, Revenue Management, Intercompany, Budgeting control and BI analytics
• Expertise in Oracle Service contracts to manage user service contracts.
• Expertise in Oracle ERP Federal Financial Modules such as AR, AP, GL and Federal Administrator at clients such as NIH, Dept. of Education (CFO and FSA offices), CMS and Veterans affairs..
• Expertise in Implementation of Project Accounting, interfacing with Accounts receivable.
• Expertise in customizing project accounting workflow.
• Experienced in OBIEE 12C Data modeling and developing.
• Experienced in OBIEE architecture, dashboards, star schemas
• Expertise in Markview Imaging application from Kofax - 170 Systems.
• Expertise in Oracle UPK simulations and preparation of course material.
• Expertise in handling federal user tickets as part of Operations and Maintenance activities.
• Expertise in resolving reconciliation issues arising out of subledgers like PO, AP or AR with General Ledger.
• Expertise in the FSA’s Lender application reporting system (LaRs), Lender Application Process and its interface with IPM.
• Translated business user requirements into functional and technical design documents/specifications.
• Experience in Five full life cycle implementations of Oracle Financials and Distribution (R12, 11i, 11.0.3, 10.7NCA and 10.7SC).
• Experience in Multi-Org, Multi Currency and NLS Implementation of Oracle Applications.
• Experience in functional configuration setup steps, business process analysis and gap analysis and created functional specifications.
• Excellent Communications and interpersonal skills to interact with other teams and the Client.

TECHNICAL SKILLS

Server: HP Net Server LH LI, Dell Servers 1300 & 2400, Sun servers 250 Series

Operating Systems: Windows, Sun Solaris 2.8.

RDBMS & GUI: Oracle 8, forms 4.5, Reports 2.5, Forms and Reports 6i

Languages: PL/SQL, SQL x PLUS, SQL LOADER, C, Java 2.0

Other Applications: Application Desktop Generator, Discoverer 3.1, MS-Office, Dataloader v.4.2.2, Loft ware, Win label, Workflow 2.6, IBM Sympro, ReqPro, GAPS, Rational Clearquest., Clearcase

ERP SUITE: Oracle fusion Cloud Applications R12 and 13

ORACLE Applications: R12.2.6, 11i, 11.0.3, 10.7SC and NCA.

TECHNICAL MODULES: Flexfields, AOL, System Administration.

FUNCTIONAL MODULES: Billing and Revenue Management, Expense Management, Federal Administrator, General Ledger, Accounts Payables, Accounts Receivables, Fixed assets, Order Management, Inventory, Purchasing, Bills of Material, iProcurement, ipayment, iExpenses, Oracle Configurator, Project Accounting

CLOUD MODULES: Service contracts, Supplier invoice Processing, Expenses, Fixed assets, Customer invoice processing, Revenue Management, Intercompany, Budgeting control and BI analytics

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Responsibilities:

• As a Senior Oracle cloud applications architect, I am responsible for providing functional solutions during Upgrade assessment for the Department.
• Reviewing and updated R12 related requirements for the department.
• Setting up and configuring oracle service contracts.
• Preparing the environment for Assessment workshops.
• Review existing business processes and update as needed
• Review and test existing feeder systems webservices.
• Conduct Workshops for Department business process and Interfaces.
• Authored the Upgrade assessment report for final implementation effort.
• Imported SLAM Components to different instances.
• Configured SLA Journal Line Definitions for different accounting events.
• Used Federal Application Accounting Definitions to create AADs for the Department.
• Participated in drafting ATM for accounting scenarios.
• Conducted multiple meetings and demos with the users.

Confidential, Bethesda MD

Senior Principal Project Accounting Lead

Responsibilities:

• Participated as a core member during R12 cloud applications Upgrade assessment.
• Performed Production configurations for R12 for multiple modules.
• Improved process for R12 Accounts receivable in conjunction with Oracle Projects accounting.
• Configured Budgeting using Project Accounting for contracts.
• Implemented Project accounting Agreements for Customer register to facilitate Federal Reimbursable agreements.
• Creation of AR invoices using Project accounting.
• Tieback project accounting process trouble shooting.
• Coordinated with Oracle support to improve month end closing.
• Performed Functional, integration and User acceptance testing for the production users.
• Conducted training sessions for users.
• Preparation of Training materials such as Job Aids, NAVs and Student guides.
• Preparation automated training materials for users using Oracle UPK kit.
• Provide Functional support for Oracle Projects in NBS.
• Processing Orders in Order Management and interfacing to AR.
• Revenue recognition based on service contracts and invoicing .
• Intercompany transfers of assets.
• Conducting Lab working sessions with the users of NIH ICs
• Provides Functional Support for Kofax (Markview) Invoice Document Management and Integration with Oracle E-Business Suite.
• OBIEE 12C Dashboard configuration.
• OBIEE Model data in start schema format, OBIEE Respository RPD, Dashboards.
• Configuring and working on Physical layer, Business Model Mapping (BMM) layer and Presentation layer.
• Integrate OBIEE with MS OFFICE.
• Provided Functional Support for Oracle Accounts Payables, Accounts Receivable. Fedadminand General Ledger issues.
• Implementing change requests as necessary to improve the processes and resolving any legacy issues.
• Coordinate Purchase Card processing and reconciliation.
• Implemented the Government Travel Account (GTA) Reconciliation for travel transactions related NIH Staff, Confidential ts and others from Omega and Govtrip. Streamlines the processes by providing user procedures and conducting discussions involving stake holders to reduce the file errors and successful recording of travel documents, reporting and error handling.
• Support reconciliation and Year-End activities by performing AR Adjustments for cancelled fund invoices that had the positive effect on the balance of accounts reporting..
• Instance validation support by performing testing and validation for Production, Quality, Development and various test instances..
• As a Senior Principle consultant, I am responsible for providing functional solutions to improve business processes in the Office of Financial Management of NIH.

Confidential, Washington, DC

Senior Consultant

Responsibilities:

• As a Senior Functional consultant, responsibility involves implementing projects by coordinating with the appropriate development team member, which are approved by Change control Board (CCB) as part of Task Order awarded by FSA.
• Once the project is assigned, primary responsibilities include requirements Gathering, Gap Analysis, Design, Integration testing, Intersystem testing and User acceptance testing.
• Responsible for preparation of Test Scripts and Test data as per the requirements and updating or creating user procedures to be followed by the client when there is a change in process or procedures.
• Updating the Production handbook to make sure that the operations team have enough information to trouble shoot any issues.
• Interaction with Operations and other teams such as FP DATAMART to make sure that all the AP Invoice and Payment transfers and processes are captured for the successful completion of an Change Request (CR).
• Preparation of Training materials such as Job Aids, NAVs and Student guides.
• Interaction and communicating constantly with the Client (following hierarchy protocol wherever applicable) to make sure the all their requirements or concerns resolved.
• Handled Lender operations enhancements, which involve creating Invoices and processing Payments in Accounts Payables (AP) and Accounts Receivables (AR).
• Setting up the system and making sure for AP and AR netting happens at the line level in the Multiline invoices.
• General Ledger (GL) setup, GL transfer process with ADI and Sub ledgers like AP, AR and other custom applications. Reconciling with the sub ledger transactions, which involves drill down.
• Budgetary control and using Transaction codes for budgetary entries.
• Involved in the custom applications enhancements related federal legislations such as College Cost Reduction and Access Act (CCRAA) for Lender Reporting application (LARS)
• Implemented enhancements to the Splitter process to derive the accounting based on the Line item events such as Lender fee, Origination fee, Excess Interest, Consolidation fee, Special allowance and Interest Benefits.