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 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 Fixed assets.
• Setting up of oracle assets modules including depreciation books and calendars.
• Expertise in Assets additions, quick additions and Mass additions.
• 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 Applications R12.2.6, 11i, 11.0.3, 10.7SC and NCA.

TECHNICAL MODULES: Flexfields, AOL, System Administration.

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

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr. Federal Financials R12 Lead

Responsibilities:

• As a Senior R12 Accounts Receivable Subject Matter expert at Confidential, Washington DC , I am responsible for providing functional solutions during Upgrade assessment for the Department.
• Reviewing and updated R12 related requirements for the department.
• Preparing the environment for Assessment workshops.
• Review existing Accounts Receivables (AR) business processes and update as needed
• Review and test existing feeder systems such as G5 for Grants processing, E2 Travel system.
• Conduct Accounts Receivable Workshops for Department business process and Interfaces.
• Authored the Department R12 assessment report with other SMEs.
• Configured SLA for Accounts receivables, Federal Administrator and Accounts payable modules in ANI instances
• 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 Consultant

Responsibilities:

• Participated as a core member during R12 upgrade.
• Performed Production configurations for R12 for multiple modules.
• Improved process for R12 Accounts receivable in conjunction with Oracle Projects.
• Coordinated with Oracle support to improve month end closing.
• Performed Functional, integration and User acceptance testing for the production users.
• Conducted training sessions
• 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.
• Provide IAA Agreements process support to Multiple ICs of NIH
• Review Oracle Fixed assets module in R12.
• Configure Oracle assets Key Flexfields, Category and Location Flexfields.
• Configure Asset calendars - Fiscal, Depreciation and Prorate.
• Configure Depreciation Book.
• Setting up Depreciation methods.
• Preform Additions and Quick additions of Assets.
• Perform Mass Additions.
• Running Depreciation.
• Processing Retirement and reinstatement of assets.
• 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. Fedadmin and 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, patients 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

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

Sr. Oracle E-Business Consultant

Confidential

• Oracle financials Production support for 10.7 version and Implementation consultant for 11.5.9 at SAFETY AND SECURITY AMERICAS ( ).
• Oracle Functional lead to implement Advanced features of AR and refine business process in Oracle application 11.03 at LEAPFROG Inc., ( )
• Implemented Multi-organization, Multi-currency Oracle Applications 11i using Oracle Fast Forward Methodology and Production support for Elogicity International Pte Ltd, Singapore, ( ). Modules implemented, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets, Inventory, BOM, Purchasing.
• Oracle Applications Specialist to Implement Multi org, and foreign currency Oracle apps 11i for IGLOBAL SERVICES, Singapore ( ). Modules implemented, General Ledger, Accounts Payables, Accounts Receivables, Fixed Assets.
• Oracle Applications Consultant to implement Multi-organization, multi-set of books, GL, AP, FA, INV, PO modules as part of 11.03 version implementation for Saudi Systems corporation in Saudi Arabia. ( ).
• Oracle Functional Consultant in 10.7SC version implementation at CEI Inc., Chennai, India ( 9).