DEADLINE: Tue 3rd Dec 2019
Total Scope of request: 1337 hours
Full Time On-Site: 4 days per week
Start Date: 2nd January 2020
Required Security Clearance: NATO SECRET
Equivalent NATO Grade: A2 (107)
Note: For all Level-of-Effort and Completion-Type requests processed outside of the IWC Value Stream, and for which the contractor will not be reimbursed directly by NCIA for travel expenses, additional travel funding shall be allocated on a Not-to-exceed basis when the yearly Option is exercised.
Statement of Work
Contractor will work under guidance of SHAPE FINAC ICF Office Chief. Tasks include:
1.1 Perform as 1st Line Support for ACO HQs staff requiring assistance related to FinS application software and related tool
1.2 Perform duties as ACO POC with NCIA SSBA functional, technical and applications system administrator, ensuring controls/security of system and follow-up of NCIA incidents.
1.3 Troubleshoot FinS problems and workflow issues related to FinS utilization within FINAC as well as other staff elements of all ACO HQs using specific tools (i.e. Oracle Workflow, Oracle Discoverer, GL Wand, etc.).
1.4 Design and build management and financial reports to be used by all ACO Community (Discoverer, GL Wand, XML Publisher, SQL query)
1.5 Function as liaison between FINAC and NCIA for all FinS terminal, server, or software problems, coordinates updates and patches for all ACO sites
1.6 Entering/maintaining other core data elements in FinS (i.e. travel destinations, mode of travel, etc.).
1.7 Perform specific actions to prepare system for new fiscal years in FinS as part of end of year procedure.
1.8 Manage user access controls (user creation, deactivation, reset password) and user responsibilities in FinS, while maintaining proper segregation of duties and security controls.
1.9 Implement any system changes as requested by FinS Configuration Management Board or by NCIA SSBA (CPU, certificates, DB / Server upgrade), tests, documents, coordinates with key user, coordinates resolution of issues between FinS Service Desk and ACO HQs and NCIA SSBA.
1.10 In coordination with ACO Finance and Accounting Community, represents ACO Commands in FinS development activities and establishing procedures with subordinate HQs for linkages into centralized FinS configuration.
1.11 Supervise all transactional processes related to centralized FinS installation, including consolidation, budget, contracting, assets, cash management, accounting activities.
1.12 Is actively involved in execution of different aspects of project, specifically business processes analysis, review and design; oversees development of document, ensuring that all design and configuration aspects are addressed and control and security mechanisms are established.
1.13 Prepares technical, functional and user documentation;
1.14 Keeps abreast of developments in field and determines need for testing and evaluating new products and technologies; provides leadership on introducing and advising technological changes; prepares various technical reports.
1.15 Write SQL query to extract information and investigate issues.
1.16 Performs other related duties as required
Requirements:
- Required Security Clearance: NATO SECRET
- G-01 - 4+ years current, detailed and relevant knowledge and experience
- G-02 - Advanced SQL and SQL*Plus knowledge
- G-03 - Familiarity with configuration management / versioning procedures and tools
- G-04 - Able to work under pressure, on own initiative and without constant supervision, to strict and tight deadlines
- G-05 - Good team player and a good communicator
- G-06 - Experience of working in team that delivers highly available service
- G-07 - Competent in documenting work done
- G-08 - English proficiency level: SLP 3232 according to STANAG 6001
- G-09 - Relevant experience at customer facing service desk and its associated tools and processes during 24 months sustained period of performance
- G-10 - [DESIRABLE] Recent experience of working in NATO
- Oracle E-Business Suite profiles
- E-01 - 4+ years current, detailed and relevant knowledge of and experience with Oracle E-Business Suite Release 12.1.3 (or higher).
- E-02 - Oracle Functional Analyst expert with technical knowledge and profound knowledge in implementing and supporting Oracle e-Business Suites software, with specific experience in providing functional support for Oracle Finance (GL, AP, AR, CE, FA, sub-ledger accounting), Accounting and Procurement modules as well in managing production release process for production changes. Support typically takes form of investigating and resolving problems and providing information about ERP Oracle Financial system.
- E-03 - Basic understanding of data model for Oracle E-Business Suite Release 12.1.3 (or higher)
- E-04 - Profile is mix of functional and technical Oracle EBS profile.
- Oracle E-Business Suite Functional profiles # Essential Requirement
- EF-01 - Ability to handle issues of all E-Business Suite modules in area of responsibility including System Administrator from setup to functional reporting.
- EF-02 - Understanding internal controls, including but not limited to user access, responsibilities, security rules, report groups, profile options.
- EF-03 - Able to configure flexfields
- EF-04 - Workflow monitoring and troubleshooting.
- EF-05 - Understanding standard open interfaces.
- EF-06 - Able to Configure Approval Management Engine configuration.
- EF-07 - Experience with writing detailed functional design documents based on new or changed business requirements.
- EF-08 - Experience with review of business procedures and functional setup. Experience with making recommendations for changes, improvements etc. based on best business practices.
- EF-09 - Experience with preparing, running and documenting unit tests, system tests and user acceptance tests.
- EF-10 - Ability to work with System Administrator and Application Developer responsibilities
- EF-11 - Experience with WebADI
- EF-12 - Accounting knowledge including encumbrance accounting, accrual accounting and experience of Public Sector accounting processes.
- EF-13 - SQL and PL/SQL knowledge
- EF-11 - [DESIRABLE] Experience Oracle Alerts.
- EF-14 - [DESIRABLE] Basic understanding of Oracle User Productivity Kit (UPK).
- EF-15 - [DESIRABLE] Basic understanding of Oracle Business Intelligence (OBI).
•
- Oracle E-Business Suite Technical profiles # Essential Requirement
- ET.03-01 - 5+ years recent practical experience as Oracle E-Business Suite Developer, demonstrating 24 months sustained period of performance on previous 2 most recent assignments.
- ET.03-02 - Detailed knowledge of and experience with Oracle E-Business Suite 12.1.3 (or higher) focusing on Oracle E-Business Suite development, including but not limited to: a. knowledge of and experience with SQL and PL/SQL; b. experience with Oracle E-Business Suite Workflow and Developer tools (SQL Developer); c. experience with Oracle forms personalization; d. experience with Oracle Application Framework (OAF) personalization; e. experience of working with Oracle Discoverer, Financial Statement Generator, Application Desktop Integrator (ADI), Web ADI and XML Publisher; f. detailed understanding of Oracle E-Business Suite Release 12.1.3 (or higher) data model; g. experience in working under software development methodology and with software implementation lifecycle; h. knowledge of accounting fundamentals and experience in development and maintenance of financial software; i. high-level understanding of functional aspects of Oracle E-Business suite
- ET.03-07 - [DESIRABLE] Knowledge of and experience with Oracle Business Intelligence (OBIEE, OBIA
Benefits:Required Security Clearance: NATO SECRET