SUMMARY:

• Self motivated professional with over 10 years experience in Oracle Federal (and non - Federal) financial, including General Ledger, Accounts Payable and Accounts Receivable, Sub ledger Accounting, PRISM
• Expert at analyzing business operations and technological issues and determining successful fixes through interfacing to incorporating new systems in order to effectively resolve issues and increase operations and performance time.
• UPK Guides Develop / update / maintain FEDERAL AVIATION ADMINISTRATION guides using the Oracle UPK Tool. Successfully implemented ERP life cycle upgrades for Federal clients and large commercial firms. Specialize in the implementation of Procure-to-Pay (P2P), Order-to-Cash (O2C) business flows. Excellent communication and problem solving skills.
• Manage effective business meetings where business requirements are discussed, solutions are determined and plans are established with milestones and goals. Stay abreast of current technologies and apply them as needed to improve workflow, independently/or as a team lead. Subject matter expertise in the areas of BI Analytics, OBIEE, Enterprise Reporting and Data Warehousing, areas with a thorough understanding of Oracle Technologies, Data Modeling, RPD, Star Schema design and Oracle Applications

TECHNICAL SKILLS:

Technology and Tools: Business Intelligence, Visual Basic, Oracle Developer 2000, C, Access, Lotus Notes, Developer, Web Development Tools, SQL, Cold Fusion, Rational Rose, Power Builder 6.5, C++, PL/SQL, Oracle Discover, Requisite Pro 3.0, ERP Data Conversion, 0BIEE Developer interactive dashboard, BI Publisher, Informatics (ETL), SharePoint . OracleFinancial Modules 11i and R12 implementation for General Ledger, Accounts Receivable, Accounts Payable, Project Accounting, Purchasing, Procure to Pay, and Oracle supplier Portal. Developing PL/SQL Configuration in (and upgrade) Oracle R12 Environment. SDLC, Configuration of RICE Components. Data Conversion, Contract lifecycle Management Support REMEDY, PCPS (Purchase Card Procurement System), and PRISM, UPK Requirement Gathering, Gap analysis, as - is Process mapping, Re-Engineering, To-be Process mapping, Solution design and Application Setup/Configuration. Designing functional documents for various customizations, Data Conversions, Interfaces to third party systems, Reports, Workflows etc. Custom Funds Control Module, Labor Distribution Interface to Oracle Projects/GL, SLA. Burdening Process Improvements, Reconciliations. Financial Management, Acquisitions, Asset Management Sunflower Assets Management, PRISM Reconciliation In-depth knowledge of Federal FAR/DFARS Knowledge of BR100, MD050, TE020, TE120, and TE40 Documents. MS Word, Excel and Lotus 1-2-3, Power Point, Visio, OBIEE Developer Advanced Global Intercompany Systems (AGIS), Invoice modules.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Federal Financial / R12 UPK Development

Responsibilities:

• Facilitated multi-unit work sessions to determine requirements, screen flows and processes.
• Liaised between management and users to help define requirements and facilitate work flow.
• Interfaced with Tech Support, Helpdesk and Smart define and improve support procedures and capabilities through s, communications, and documentations across related Oracle projects and future system upgrades.
• Trained personnel and management on Oracle modules; Order Management, Purchasing, INV, AP/AR. Development of UPK for Oracle R12 Version. and development. Perform design, problem analysis, and debugging. Works with various teams, resolve issues within the instance. Provide functional support in production environment particularly in the GL (General Ledger), AP (Accounts Payables), FA (Fixed Assets) and Purchasing modules.
• Performed configuration of the GL, AP, FA, Purchasing and Cash Management modules for one set of books for UAT and Production environment.

Confidential

Oracle Federal Consultant/ UPK Development R12 SAIC

Responsibilities:

• Prepare the Designs for Gaps, Functional Specification documents, and Test scripts.
• Work closely with clients to assess issues and respond to inquiries. Ensure Requirements Documents are accurate and properly documented.
• Document findings and develop possible solutions that are presented with recommendations.
• Perform configuration of the General Ledger, Accounts Payable, Sub Ledger Accounting Purchasing and Cash Management modules. Perform design, problem analysis, and debugging. Works with various teams, resolve issues within the instance.
• Trouble shoot between Prism and Delphi (Oracle Federal Financial).
• Develop Oracle UPK, integration with procurement systems, budgeting to reporting process.
• REMEDY, PCPS (Purchase Card Procurement System), and PRISM using various software programs. Provide acquisition support, purchase validation, product delivery and tracking.
• Support to trouble-shoot, set-up and configure modules, and test financial system upgrades.
• Develop business process documentation and conduct on-site for junior staff.
• Functional integration expert, PAC, AME, IPAC Payment Processing and AP Invoicing, AP Disbursements).
• Vast knowledge of DoD Federal Management Regulations, Federal Acquisition Regulation.
• Worked closely with the data modeler in designing the logical data model in star schema in BMM Layer.
• Configured and created repository using OBIEE Administration Tool.
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Repository using Administration Tool.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Managed security privileges for each subject area and dashboards according to the requirements.
• Developed various kinds of request queries using BI Answers and assigned them to specific Dashboards.

Confidential

Projects and PRISM Consultant

Responsibilities:

• Gathered business information and requirements and created fit-gap analysis to reflect current and recommended strategy.
• Provided functional Assessment for Order Management environment particularly in the Purchasing (I procurement), R-12 AP (Accounts Payables), and Purchasing modules. Set up Look up Codes, Profile Values, Recurring Invoices Payable options, Financial Options, and Prepayments.
• Performed configuration and Implementation of the R-12 Order Management
• Managed Purchase orders and Contracts, recorded invoices, and change management.
• Designed, configured, and developed reports, interfaces, conversions and extensions. Set up Chart of Accounts, security rules, budgetary controls, inter-fund management, creating standard and ad hoc reports.
• Supported troubleshooting, set-up and configuration of modules, tested financial system upgrades, conducted, and developed business process documentation.
• Designed solutions for all issues related to Procure to Pay and O2C business processes.
• Responsible for all functional tasks relating to the maintenance and development of Oracle R12, including end-user support and in R12 functionality, setup, navigation and identification and documentation of procedures to execute future customizations . End-users of Comp search’s PRISM, Fed Connect, and SpectrumCLM platforms as a “problem solver” .

Confidential, Fort Belvoir, VA

Oracle Federal Financials Expert

Responsibilities:

• Worked closely with client to determined business issues/requirements and developed written Requirements Definitions.
• Designed process of Oracle EBS implementations to include scenario design and flow mapping.
• Conducted testing and validation of standardized business processes including Acquire to Retire, Budget to Report (SLA), Cost Accounting, projects, Project Accounting, Order to Cash (Account, Receivables, Accounts Payables Collections, etc.), Procure to Pay (procurement, supplier, Purchasing, Payables, etc.), Time & Labor (expense etc.).
• Provided functional support and configurations in production environment in the General Ledger, Accounts Payables, Fixed Assets and Purchasing modules.
• Provided functional support to end users of General Ledger, Accounts Payable and Accounts Receivable. Developed/maintained test plans; conducted system testing, and documented results.
• Supported configuring Multi-Org environment for Business Group, Legal Entities, Operating Units and Set of Books, Approval Hierarchies, Oracle Workflow, Extensions, and Interfaces.
• Supporting configurations, customization, reports and interfaces, testing and user .

Oracle R12 Consultant (Upgrade Assessment)

Confidential, Tyson Corner, VA

Responsibilities:

• Conducted overall Financial Upgrade Assessment including General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, oracle Purchasing, Sub Ledger Accounting.
• Reviewed and analyzed current processes, custom processes,configurations, and provided sound recommendations.
• Worked closely with the client team in understanding their business processes and prepared Requirement Gathering Documents, Gap Analysis, To-be Process Maps, Integration Fit documents and Report Requirement Documents.
• Experience in implementing some combination of Oracle Financials applications such as: General Ledger (GL), Sub-ledger Accounting (SLA), Financial Accounting Hub (FAH), Accounts Receivables (AR), Accounts Payables (AP), Cash Management, Fixed Assets, Treasury, Procure-to-Pay (P2P), Invoice modules, PRISM Integration with Oracle Federal Financial.

Senior Oracle Financials Functional Consultant/OBIEE Develop

Confidential, Ashburn, VA

Environment: EBS R 12 GL, Oracle AP R-12, AR-12 upgrade, procurement, SLA (Sub Ledger), Order Management (, P2P) and (O2C), OBIEE interactive Dashboard report writer.

Responsibilities:

• Implemented Oracle EBS Financials R12 modules for General Ledger. Accounts Payable involved in all phases of the implementation and post-production support.
• Worked with Subject Matter Experts for defining and implementing Best Business Practices.
• Worked with the client team in understanding their business process and prepared Requirement Gathering Documents, Gap Analysis, To-be Process Maps, Integration Fit.
• Functional Setups were performed in R12 GL module and R12 AP module.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.

ERP Senior Business System Consultant

Confidential

Environment: Analyst (R-12 G/L, A/P, Procure to Pay (P2P), Oracle Payment, O2C)

Responsibilities:

• Worked withOracleApplications 11i/R12, specializing in Financial Modules General Ledger, Accounts Payables and Accounts Receivables, Oracle Purchasing.
• Configured Oracle payments and Accounts payable.
• Handled AP conversion requirements and mapping.
• Collected business requirements, conducted thorough analysis, designed, developed, tested, documented and supported production.
• Configured Oracle financials modules for System Administrator and Application Developers.
• Used Application Implementation Methodology (AIM) in implementation documentation procedures.
• Performed Functional integration, RICE Components. Experienced in IPAC, AME, IPAC Payment Processing, IPAC AP Invoice, and AP Disbursements).

Senior Business Analyst

Confidential

Environment: Financial Management, Acquisitions, Asset Management.

Responsibilities:

• Conducted Internal Control and Risk Management assessments.
• Working with Risk Group/Property Reconciliation team, identified Risk Assertions, Risk Analysis, Gap Identified during the Analysis, and recommendations to Gap/Fit Analysis.
• Conducted manual property reconciliations. Developed and implemented a procedure for Manual Reconciliation.
• Analyzed obligations to ensure the Obligations created in PRISM and Obligation entered in FFMS matched.
• Estimated and analyzed costs for labor, material, equipment, and all other direct costs.
• Recommended implementing interface between PRISM and FFMS to reduce the risk of duplication and missing entries.
• Hands on Experience with Comp search PRISM, and with SUNFLOWER.
• Utilized in-depth knowledge of OMB policy regulating federal financial systems.

OracleFederal Financials Business Systems Analyst

Confidential

Environment: Oracle Federal Financials, Oracle Procure to Pay, Oracle General Ledger, Oracle AP, Oracle AR.

Responsibilities:

• Provided worldwide functional support to Military Sealift Command users with their use ofOracleFederal Financial Purchasing Procurement, General Ledger, and Accounts Payable and Accounts Receivable modules.
• Provided support in troubleshooting and resolvingOracleFederal Financial and procurement/SPS/PD2 Integration issues, and communicating resolutions for reported error concerns.
• Utilized vast knowledge of command business processes and procedures to create best practice solutions to users’ issues to help build the command’s knowledge base, and assist users in identifying and analyzing recurring system issues.

Project Lead

Confidential

Environment: Oracle Financials, Procure to Pay, Oracle Payments, Oracle inventory, Order Management

Responsibilities:

• Served as:
• Project Lead responsible for the overallOracleFinancial project and the technical implementation.
• Senior Consultant to Purchasingand oversaw theOracleFinancial Implementation of Nextel Corporation Project.
• Project Lead Procure to Pay, Oracle Payments.
• Participated in developing methods for distributing common services billed centrally.
• Utilized the principles of budget analysis to determine the adequacy of internal controls.
• Analyzed anticipated and actual reimbursable earnings and supporting documentation.

Oracle Computer Systems Analyst

Confidential

Environment: Implementation 11i GSA Project (Oracle Procure To Pay)

Responsibilities:

• Implemented Procure To Pay Processing and Procure to Pay Lifecycle.
• Developed overview of purchasing process.
• Created the integration with other Oracle Applications, Creation of Requisition, Unit of measure, look up codes, employee hierarchy, sub inventory, creating items, approval routing, and auto creating.Created Open Interfaces.

OracleApplication Developer/OracleFinancial

Confidential

Environment: Oracle Financials11i

Responsibilities:

• Supported the software development life cycle, analysis, design, development, testing and implementation of Oracle Financials for the Confidential and Baltimore School System.
• Performed database application programming usingOraclesoftware development tools and system development techniques.
• Served as Analyst for Oracle Accounts payables/Purchasing, Procure to Pay, Inventory, Fixed Assets, andReceivables.

Oracle Financial Application Developer

Confidential

Environment: Oracle General Ledger, Oracle Assets

Responsibilities:

• Utilized Oracle General Ledger andOracle Assets functionality to implement: a chart of accounts, set of books, define the accounting calendar, define currencies, set up financial control, create basic journal entries with multiple currencies and accounting flex field structure, create flex field and cross validation rules, and entering, posting, and reviewing journal entries.