We provide IT Staff Augmentation Services!

Subject Matter Expert (oracle Federal Financials) Resume

0/5 (Submit Your Rating)

Bowie, MD

SUMMARY:

  • Over twenty years of experience in all phases of the System Development Life Cycles (SDLC). Worked for clients within the services industries, foreign governments as well as the U.S. Federal Government. Extensive experience in the areas of Enterprise Resource Planning (ERP), Data Modeling, Database Management, Business Process Reengineering (BPR), Reverse Engineering, Project Management
  • Hardware and Software Evaluations, Change Management, Systems Integration and System Maintenance. Areas covered by these experiences include consultation, functional implementation, analysis, development, testing, documentation, maintenance, and project management of various integrated data management systems.
  • Involved or led teams to perform systems and applications integration, data modeling and migration, databases, business process reengineering, independent verification and validation, and cost/benefit analyses. Very comfortable with project leadership, and the use of case tools in implementing and maintaining computer applications.

TECHNICAL SKILLS:

Technology: Software, Tools and Languages Databases SQL, PL/SQL, CPG, Oracle FSG, Oracle 8i, 9i,10g,11g, DB2, Golden, Accelerator, Oracle ADI,DATACOM/DB, IDMS Oracle Designer 2000, SQL Loader, Oracle Workflow, IDEF, VISIO, DataLoad, TOAD, The NetBeans IDE, SharePoint, MS Office, SQL Developer, SharePoint, Req Trace, COBOL, Quality Center (QC), etc. Hardware & Operating Systems Windows NT, Windows 2000, UNIX Project Management MS Project, Time Line, MS Power Point, Excel, SharePoint

PROFESSIONAL EXPERIENCE:

Subject Matter Expert (Oracle Federal Financials)

Confidential, Bowie, MD

Responsibilities:

  • Provided expertise in Testing, Independent Validation and Verification (IV&V) on the Oracle EBS UFMS Upgrade from Release 11i to Release 12.2.3, and the migration to the Oracle Managed Cloud Services (OMCS) architecture for the department of Health and Human Services (HHS).
  • Upgraded modules included (GL, SLA, P2P, O2C, Fed Admin, etc.) and other processes such as GTAS, CFRS, FBIS, etc. to meet not only Treasury but also HHS mandates. Some of my responsibilities includes review of artifacts, test observations, assessment, research, meetings, testing, etc. that lead to the development of series of reports including General Observation Report (GOR), Document Observation Report (DOR) and phase deliverables.

Financial Business Analyst Specialist

Confidential, Gaithersburg, MD

Responsibilities:

  • Reviewed requirements and Government Furnished Instruments (GFI);
  • Analyzed legacy COBOL codes to derive current processes and validate requirements;
  • Conduct Requirement Validation (RV) sessions to walkthrough the requirements;
  • Developed Proof of Concept (POC) document for the CLOUD co - tenancy of legal entities;
  • Developed upgrade gap and impact analysis document;
  • Developed Derivation Rules to derive the chart of accounts segment values and combinations;
  • Developed Use Cases to support development;
  • Conducted Design, Development and Implementation (DDI) sessions to walk through the Use Cases;
  • Developed Detail System Design Document (DSDD) for each logical grouping of the claims payments/receivables/receipts that includes internal and external interfaces;
  • Developed Modification Document (MD) and Business Requirement (BR) documents for Oracle setups and interface implementations;
  • Performed setups for GL, SLA, AP and AR functions in a single and/or multi-org environments;
  • Identified and documented risks/action items;
  • Performed testing and reconciliations;
  • Prepared and conducted walk through session for each finance functions/use cases using Power Point;
  • Developed and completed gaps after each session and develop gap reports;
  • Attended design, conference call and status meetings; and
  • Provided weekly status reports and interfaced with Oracle Support.

Independent Consultant

Confidential, Fairfax, VA

Responsibilities:

  • Provided support, sustainment, and research to resolve GDMS issues;
  • Determined the requirements and documented the solution to control and segregate purchases based on buyer accounts and business units in R11i;
  • Performed initial setup and tested the solutions in R11i;
  • Led the effort to setup and implement surcharge functions;
  • Planed the migration of the solutions to R12;
  • Determined the requirements, documented the functional variances between R11 and R12; and provided functional setups/support to upgrade the AMMS from R 11i to R 12;
  • Led the effort to configure and test applicable functions of the financial components of the AMMS after the upgrade from R11i to R12;
  • Led the effort to test and reconcile the financial components of the AMMS after the surcharge implementations;
  • Presented solutions to stakeholders;
  • Developed scripts and documentations to support the month end and year end period closings/reconciliations;
  • Developed Oracle SRs and the follow-ups, and attend meetings;
  • Provided project status, researched issues, provided solutions, conducted presentations, etc. to the stake holders;
  • Documented MD and BR documents; and
  • Provided functional and technical support before and after the AMMS upgrade to r12 and to GDMS.

Senior Product Specialist

Confidential, Falls Church, VA

Responsibilities:

  • From Payables to a disbursement system to produce vendor/customer payments;
  • From P2P to IRS/1099 generating system to produce vendor/customer 1099; and
  • From Payables to a cash accounting system to produce data for reconciliation.

Principal Consultant

Confidential, Reston, VA

Responsibilities:

  • Provided functional and technical support on the Defense Energy Support Center (DESC) contract. The effort involved analysis and developing procedures to track and record fuel movements using Oracle Energy Downstream (OED) and tracking and recording payments/receipts/funding using Oracle Government Financials (OGF) modules. Funding allocations and executions drills down to the proprietary accounting levels and are controlled by using encumbrance accounting setups to prevent over spending the budgeted appropriations. Developed accounting treatment manual to provide definitions for the different accounts and their purpose.
  • Some of my primary responsibilities included setup/maintain/enhance/document Accounts Payable (AP) functions, Purchasing (PO) functions, and Alert functions; analyze requirements and design specifications to support development effort, etc. Other responsibilities included OED contract and supply order creation, movement creation and/or upload and testing; prepare weekly contract briefing report, attended contract briefing meetings and provided functional and technical support to team members and to the customer.

Independent Consultant

Confidential, Mclean, VA

Responsibilities:

  • Provided project support to determine, gather, analyze, develop BPR for the existing system processes and GAP analysis (AS-IS and TO-BE) for the implementation of Oracle E-Business Suite for the Office of the Naval Research (ONR). The effort was on PSB, PSGL and OFA modules and the effort led to a CRP to demonstrate how the integrated BPR satisfied the client’s requirements and expectations.

Independent Consultant

Confidential, Mclean, VA

Responsibilities:

  • Served as a Project Leader to determine, gather, analyze and map requirements (AS-IS and TO-BE) to implement Oracle Financials Modules for the Institute of Development Management (IDM). Developed project plan, templates and procedures for documenting deliverables which included design, interface and conversion documents. Made presentations to management and stakeholders. Configured GL, AR, PO, AP and assisted in the OTA and Project configurations. Defined workflow business requirements and processes. Configured workflow parameters to route documents (requisitions, purchase orders, etc.) to authorized users.
  • Developed and tested PL/SQL programs to satisfy interface and conversion requirements. Served as interface with Confidential in the Module localizations, developed materials, trained the users and facilitated project transition to the client technical staff.

Independent Consultant

Confidential, Mclean, VA

Responsibilities:

  • Team Lead to perform Independent Verification and Validation (IV&V) on the following implemented system components: Oracle Financials, Federal Administrator, Oracle Financial Analyzer, and custom interfaces for the Department of . The team also recommends functional and technical solution scenarios to address functional areas requiring improvement and/or to extend the capabilities of others in order to maximize their full functionality.

Principal Consultant

Confidential, Arlington, Virginia

Responsibilities:

  • On Phase II/III, I led the effort to develop the high-level Budget and GL data conversion analysis deliverable. Joined the configuration team to configure Oracle Financial Analyzer (OFA) module for budget planning, Oracle Federal Administrator module for budget execution and control with fund code as the driving parameters for the treatment of the following budgetary accounts (Appropriation, Apportionment, Allotment, Obligation, Commitment) and used transaction codes to extend the funding allocations to the proprietary accounts, additional
  • GL requirements and Procurement (Purchasing, Account Payable) modules. Also led the effort on the detail design document for Phase II/III data conversion and provided functional and technical guidance to the development team during the code construction, testing and implementation. The team used Financial Statement Generator (FSG) to develop and generate custom reports, and also developed accounting treatment manual to ensure adequate standardizations and definitions are used.

Senior Consultant/Project Lead

Confidential, Germantown, Maryland

Responsibilities:

  • Led the effort to implement the Financial Management modules Budget, (General Ledger (GL) and Fixed Assets (FA)), Procurement modules (Purchasing, Accounts Payable (AP) and Cash Management (CM)), and Order Fulfillment module (Accounts Receivables (AR) and Payroll) for Confidential and other client’s ERP Oracle Financials projects. Some of the deliverables developed included requirements (AS-IS and TO-BE) and implementation documents such as integrated Business Process Analysis (BPA), User Manuals (UM), etc. and trained the users on how to use and navigate through the system. The team used
  • Application Desktop Integrator (ADI) for some aspect of data conversion and used Financial Statement Generator (FSG) for custom report generation. Also served as Project Lead on the ERP projects that required Technology Assessment and Evaluation, selection and implementation of appropriate Technology Solutions for the Government of Trinidad and Tobago (GOTT) and Government of Antigua and Barbuda (GOAB). Provided project briefings to customers and to the home office, and was responsible for organizing and assigning resources to the projects. Also provided technical support when required to assist the sales group in proposal development and marketing support.

Senior Test Engineer

Confidential, Reston, Virginia

Responsibilities:

  • Technical Lead on the Immigration & Naturalization Service (INS) contract.
  • Project Lead on the Time Life Customer Service (TLCS) contract.
  • Provided guidance to the Internal Revenue Service (IRS) on their Tax System Modernization (TSM).
  • Key member of the development team on the Pension Benefit Guaranteed Corporation (PBGC), Federal Energy Regulatory Commission (FERC) and Air Force Logistics Command (AFLC) IT Modernization contracts.

We'd love your feedback!