SUMMARY

PMP Certified hands on Project Lead / Functional Consultant experienced in business process re-engineering, implementation and support of business systems, COTS packages like Oracle Financials, Oracle Federal Financials and Oracle data warehouses

Skills Summary:

• Expertise in implementing / supporting Oracle Payables, Purchasing, Receivables, Projects at different client sites. Conducted requirements workshops RD-20, RD-50 , fit gap analysis BR050 , configurations BR100 , functional design documents MD050 , test scripts TE020, TE040 .
• Involved in full purchasing life cycle from configurations to setting up requisitions and purchase orders,
• setting up sourcing rules, supply base management, document approvals hierarchy, budgetary control for funds availability, receiving.
• Involved in full payables life cycle from configurations to creating invoices, matching to purchase orders 2 way or 3 way, paying invoices in batches / quick payments, treasury confirmations.
• Experience interfacing Sunflower and PRISM to Oracle Financials. Used Sunflower to interface to Oracle Fixed Assets. Created procurement documents in PRISM and interfaced them to Oracle EBS via the OCI interface. Wrote scripts to expedite transactions stuck in the OCI interface.
• Used Oracle Receivables to records receipts, invoices and collections. Configuring receivables to set payment terms, transaction types, organizations and customers, autoinvoice and lockbox.
• Used new R12 features like Trading Community Architecture TCA , Oracle E-Business Tax, Use of Multi Org Access Control and enhanced catalog access.
• Used complete projects lifecycle project billing and costing to create projects, use templates and transaction control, collect costs, use burden functionality, collect expenditures, generate invoices and revenues, interface transactions to other module, use the tieback process and transaction import.
• Used the Federal Budget Execution process to develop and record budgets. Define budget levels like appropriation, apportionments, grant access to user privileges, enter funds distributions, define transaction types and use of funds checking to prevent overspending of budgets.
• Experience in Oracle tools like Forms, Reports, PL-SQL, SQL Loader and Oracle Discoverer.
• Used Oracle iProcurement in the Procure to Pay process. Used Catalog Management, Shopping cart, Checkout, Requisition Tracking and Management, Desktop Receiving.
• Used Oracle UPK to generate documentation for Oracle training material.
• Experience with R12 Sub Ledger Accounting. Used Application Accounting Definitions, Journal Line definitions to define journal entry descriptions, journal line types and account derivation rules. Used Accounting methods builder components like event entity, event class and event types to customize accounting rules.
• Experience with Oracle R12 upgrade process.

Accomplishments:

• Worked in federal agencies like Federal Aviation Administration, National Institute of Health, Coast Guard public sector enterprises like American Red Cross commercial organizations like Lockheed Martin, US West.
• Extensive experience working on Oracle Financials Help Desk, creating operating procedures and designing service level agreements.
• Managed functional and technical teams of around 10 people.
• Gave power point presentations to top level management on functional and technical topics.
• Implemented Oracle Federal Financial modules like Purchasing, Payables and Receivables.
• Led data conversions from legacy systems to Oracle based systems.
• Participated in upgrade projects from Oracle Financials Release 11 to Release 12.
• Conducted training in Oracle Financials.

Professional Experience:

CONFIDENTAIL

Oracle Applications Functional Consultant

• Involved with Accenture in the implementation of Oracle Applications R12 at DSCA to Manage Foreign Military Sales Solution Trust Fund 8242 as a functional consultant.
• Presented and managed customer workshops to understand user requirements.
• Conducted business process analysis to create requirement documents.
• Prepare functional MD-50 and technical MD-70 design documents for RICE objects.
• User Oracle Discoverer to create workbooks and worksheets and integrate them into Oracle EBS.
• Involved in design and development of complex interfaces like DMRS.
• User Oracle R12 SLA features to create customized accounting rules.
• Used Oracle R12 Ebusiness tax feature for calculating taxes.
• Worked on design documents for converting open AR invoices, open receipts, open GL budget balances and open GL actual balances.
• Conduct business process analysis to create requirements documents.

CONFIDENTAIL

Oracle Applications Functional Consultant

• Involved in full life cycle R12 implementation from Requirement Analysis, fit gap analysis, identifying customizations and creating design documents for the same.
• Involved in conference room pilots and creating user training material using UPK.
• Created test scripts for different test cycles like unit testing, integration testing and user acceptance testing.
• Prepared training material on business processes.
• Used Oracle R12 SLA to create customized accounting rules.
• Created presentations for best practices to create work plans and work breakdown structures.

CONFIDENTAIL

Data Cleaning Analyst

• Worked on Data Cleaning and Data Extract of entities like Suppliers, Obligations and Invoices from Momentum to Oracle EBS.
• Worked as a Subject Matter Extract for the Data Cleaning Team.
• Created data cleaning templates to accommodate different business rules between Momentum and Oracle Financials.

CONFIDENTAIL

R12 Upgrade Analyst

• Worked on testing business processes in Accounts Payable, Purchasing in R12 instance. Made necessary changes to business processes to make them functional.
• Explored new features of R12 so that they could replace existing customizations in the Release 11 instance.

CONFIDENTAIL

Functional Help Desk Support

• Worked on tickets involving creating customers, flex values. Attended to user queries over the phone and via email.
• Transaction import of expenditures in Oracle Projects.
• Creating missing time cards in Oracle Time and Labor.
• Created Standard Operations Procedures on different functional areas worked so as to create a knowledgebase.
• Involved in maturation of Help Desk Support and resolving help desk tickets in different functional area.
• Wrote SQL queries to support functional issues like identify users assigned to a specific responsibility.

CONFIDENTAIL

Functional Analyst

• Resolved functional issues related to configuration like modifying transaction code setups to create correct journal entries, SQL support for custom interfaces.
• Created functional test scripts and participated in testing of tasks like upgrade to using IMAP protocol, Security Patch upgrade.
• Used Configuration Management tools like Clearquest and Clearcase. Involved in day to day production support issues.
• Created and modified reports in Discoverer as per user needs.
• Explored new features on R12 for future upgrade from Release 11i instance.

CONFIDENTAIL

Functional Analyst

• Resolving production support issues, enhancements in PO, AP, AR, PO, GL and FV.
• Work with Delphi core users, contracting officers to resolve production support issues like fixing invoices with incorrect transaction codes , enter re-class invoices, de-obligating funds on cancelled purchase orders, expediting approval status on purchase orders, expediting receipts stuck in Pending status , resolving holds on invoices. Monitored the progress of help desk tickets so that SLAs are not violated.
• Write, test scripts for Sensitive Personal Identifiable Information SPII Testing to mask sensitive data for Oracle Financials Release 11.5.10.
• Worked on Delphi Help Desk solving tickets in Procure to Pay modules like Purchasing, Payables. Attended to phone calls to resolve customer issues.
• Created and modified reports in Discoverer as per user needs.
• Prepared training materials.

CONFIDENTAIL

Techno-Functional Analyst

• Involved in the implementation of NBS system. Worked on design of interfaces between legacy system and Oracle EBS.
• Worked on requirements gathering, design documents for AP,PO and FA modules and integration of the same with GELCO and Sunflower.

CONFIDENTAIL

Techno-Functional Analyst

• Involved in the support of AP,PO and GL modules
• Design and development of interfaces and other customizations.

CONFIDENTAIL

Technical Analyst

Involved in production support, design and development of customizations, interfaces, reports using SQL,PL-SQL , Oracle Alerts and Reports.

Previous Employment:

CONFIDENTAIL

Involved in analysis, design and programming of application for real property management FIRM for General Services Administration GSA using Designer2000/Developer2000 methodology.

CONFIDENTAIL

Worked on implementation, production support of Oracle Financials at clients like US West Communications group, Lockheed Martin and Applied Physical Laboratory.

CONFIDENTAIL

Worked on design, development of billing system at Warner Insurance.

CONFIDENTAIL

Developed economic model for soluble coffee processing using Oracle Forms, Reports.

CONFIDENTAIL

Worked on programming of business applications using Clipper, COBOL, and Oracle.