Notice of Intent to Sole Source: System Architect

Under the authority of FAR 6.302-1, The Federal Highway Administration (FHWA), Central Federal Lands Highway Division (CFLHD), Lakewood, CO, intends to negotiate a sole source contract with Capstone Planning and Control, Inc., 11001 West 120th Avenue, Broomfield, CO 80020, for the acquisition of an Application Architect. 

Central Federal Lands Highway Division (CFLHD) is currently using a combination of Primavera Enterprise System (P6) data for resource hours/dollars and FundsMap, our funds management system to report project financial data.  The primary purpose of the proposed contract is to improve the financial management of program and project budgeting by maintaining and continuing minimal design to improve this automated system using CFL database to receive all key financial information directly from Delphi (Data warehouse Materialized Views) and P6 data using Business Objects (BO) server for user queries and reporting.

This is an Oracle-based system, compatible with other FLH database systems and applications.  Close coordination with a process improvement team consisting of representatives from affected functional groups is necessary.  We are also asking this position to work with our IT personnel to transition the knowledge and responsibility of this position to our IT Department.

It is essential for the Government to obtain services from a firm that has an excellent understanding of Federal Lands Highway's accounting business rules, has the experience and specific skills as listed below:

•·         Knowledge of  FLH Business rules

•·         Knowledge of FHWA's accounting systems, such as:  DELPHI, PRISM, Business Intelligence and project scheduling system (Primavera P6)

•·         Knowledge of the Federal Lands Highway Data Warehouse

•·         Knowledge of CFLHD's business processes, existing hardware and software parameters, and technical environments.

Other general skills required include:

•·         Knowledge of Silverlight, HTML, .net, and SQL

•·         Ability to design data structures to maximize efficiency and flexibility.

•·         Must demonstrate a clear understanding of the logical and physical database design (for both transactional and data warehouse) and the data normalization concepts

•·         Ability to identify and resolve software/hardware interface problems, data requirements, and access methods.

•·         General knowledge of network configuration, programming, and protocols

•·         Ability to identify and troubleshoot data related issues.

•·         Experience in defining, changing, and completing projects independently with strict attention to detail. 

•·         Must have a teamwork-focused attitude and be skilled at building relationships

•·         Assess system operation and development recommendations for improvement

•·         Continuous database analysis during development

•·         Experience gathering and analyzing user requirements.

•·         Strong verbal communication skills and proactive attitude toward research and troubleshooting

•·         Strong time management and timely follow-up

 Summary Description of Work

Contract services will include:

•·         Understanding of CFLHD's mission, business processes, and projects and to make changes to FundsMap according to new system and process requirements.

•·         In FundsMap analyze non-PR calculation issues that's causing error when PM's request budgets, work with Software Developer to fix and rollout non-PR working correctly into production.

•·         In FundsMap analyze PR section and make changes necessary related to how we process PR's in FundsMap due to the DP2 requirements.

•·         In FundsMap analyze Budget Approval section and make changes necessary related to how send e-mail notifications in FundsMap due to FLAP requirements.

•·         In FundsMap analyze Agreements section and make changes necessary related to how we process Agreements due to FLAP requirements.

•·         CFL needs a current developer version of PARS, since we are using about an 18-month-old version.  CFL needs this to use to further troubleshoot issues when they occur.

This is not a formal solicitation. This notice is not considered a Request for Quotation or Proposal. No solicitation document is available and telephone requests will not be honored. No contract will be awarded on the basis of offers received in response to this notice. All responsible sources may submit a capability statement proposal, or quotation, which shall be considered by the agency. If no challenges to acquire these items are received by 2 p.m. MDT, April 5, 2017, the Government reserves the right to execute an award without publishing a solicitation. A determination by the Government not to compete this proposed contract is solely within the discretion of the Government. Detailed capabilities must be submitted to cflcontracts@dot.gov no later than the time and date noted above.