Company:
Abacus Service Corporation
Location: Washington Highlands
Closing Date: 26/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Job Title
IT Functional Expert Consultant
Client Company/Dept. Name
Department of Justice Office of U.S. Attorneys
Address
601 D St NW, Washington, DC
City Name
Washington
State Name
DC-District Of Columbia
Zip Code
If others (Address)
Mark up % (if any)
Duration of the project
Project Start Date:
December 13, 2024
Project End Date
December 12, 2025
Due date for Resume submission
October 28, 2024
No. of Openings
3
No. of Maximum Submissions
3
Job Description
TASK 1 Construction and Implementation of USAODC Case Statistics Data Warehouse and Other Required Data Warehouses
" Complete gathering of user requirements, Prosecutor Performance Indicators, and use cases for the Case Statistics data warehouse.
" Construct, test, implement and maintain ETLs (Extract, Transform, and Load) processes for the Case Statistics data warehouses.
" Finalize and implement Case Statistics data warehouse prototype including design of schema structures, staging areas, data marts, fact tables, dashboards and use cases.
" Maintain and modify Case Statistics data warehouse and ETLs as user requirements evolve.
" Using a similar methodology, construct and implement additional data warehouses as required by USAODC.
" Provide technical documentation all data warehouses and their components as required by USAODC.
TASK 2 Implementation of COTS/Government Software to replace Legacy systems
" Provide technical research and recommendations for COTS software or government-provided software to replace USAODC Legacy systems.
" Provide technical support for Legacy to COTS/Government software data mapping.
" Provide technical support for development of Legacy to COTS/government software data migration plans.
" Provide technical support for identification of Legacy features to be implemented in the COTS/government software environment.
" Provide technical support for develop and document system cut-over plans.
" Provide user liaison support to ensure system functionality is retained and/or improved.
" Provide technical support for User Acceptance Testing. Document results and ensure defects are corrected.
" Construct and execute data migration scripts as needed.
" Provide user and technical documentation as needed.
" Construct, test, and implement interfaces as required for the new COTS/government system to other USAO systems.
TASK 3 Development and Modification of Multi-Agency Interfaces
Contractor shall provide technical support in the development and implementation of new or existing interfaces with the Criminal Justice Coordinating Council (CJCC), Metropolitan Police Department (MPD), the DC Superior Court (DCSC), the DC Office of Attorney General (OAG), and the Pre-Trial Services Agency (PSA). These interfaces include the import and export of data and documents in support of the prosecution of criminal cases. Some of these interfaces involve loading the data and documents to a
staging area and then subsequently processing the data to the USAODC application. Specific tasks shall include the following:
" Provide support to modify current transaction loading and processing of data and documents in the current environment as need arises.
" Transition current transaction environment from Oracle to SQL Server.
" Transition current SOAP web services to REST API.
" Modify current and new multi-agency interfaces to support loading data and documents to new staging area environments.
" Migrate current processes to populate USAODC data sources with transaction data and documents from new staging areas.
" Conduct interface testing - internally and externally with other agencies as needed.
" Go Live and post-implementation support.
TASK 4 - Web Development of User Interfaces on Existing and New Applications
Contractor shall support the development and implementation of updated user interfaces using Web technologies on existing and/or new applications. In addition, MS SQL Server database in an MS Windows environment will be used for the backend RDBMS. Specific tasks shall include the following:
" Analysis of user requirements documented in a Functional Requirements Document
" Design and creation of data structures and database objects in MS SQL Server
environment.
" Design of the new module, interfaces documented in a Design Document
" Construction of forms, reports, interfaces, and processes required for User Interface
" Migration of data to new MS SQL Server environment, as needed.
" Unit and system integration testing
" Go Live and post-implementation support
TASK 5 Provide Maintenance Support for Existing USAODC Applications and
Processes
Contractor shall support the development and implementation of required modifications
for existing USAODC applications, processes, and interfaces. Specific tasks shall
include the following:
" Develop a system architecture document to illustrate USAODC application inter
connectivity.
3
" Design, develop, test, implement and document modifications of existing
USAODC applications including, but not limited to, Oracle Forms and Reports,
and MS Access.
" Design, test and implement roles-based application access vs direct grants
application access for Oracle applications.
" Develop and implement solutions for identified application security issues.
" Develop, implement, and maintain scripting solutions for various interfaces
including, but not limited to, MS Office 365 components and MS Windows.
" Construct and execute mass data update scripts as required.
" Conduct unit and system integration testing as required.
" Provide Go Live and post-implementation support.
" Provide recommendations and solutions for day-to-day user adhoc requests.
Skill set info
Skills in data modeling and process modeling.
o Knowledge of requirements analysis and system definition reports and
documentation.
o Skills in providing end user training.
o Skills in project planning.
o Skills writing user and system manuals.
" Web Technologies:
o XML (Extensible Markup Language)
o JSON (JavaScript Object Notation)
o Web Services (SOAP, SoapUI, REST API)
o Internet Authentication Service (IAS) for Windows Server
o Dynamic web pages using CSS, Ajax and HTML5
o .Net Applications using C#
o Java
" Databases, Operating Systems, Application Servers
o MS SQL Server
o PostgreSQL
o Oracle
o Linux
o Windows
o Apache
o Apache Tomcat
" Development Tools, APIs, and Scripting
o .Net Applications using C#
o VB Script
o Java
o Data modeling and data management using ERWin and TOAD
o Interactive Dashboards using Tableau, Power BI
o SQL Server Integration Services
o MS Access
o Oracle 12c Developer Tool Suite
PL/SQL
This is a senior level technical position, often the most senior level technical position for all work for a particular DOJ component. Must demonstrate substantial, hands-on, successful experience in actually doing the work on the systems being used, usually at least five years of such experience. Other systems environments will require other specific sets of skills. Requires broad knowledge of the Government's IT environments, including office automation networks, and PC and server-based databases and applications. Experience in a litigation support environment extremely helpful. Excellent oral and written communication skills are required. Supervisory experience very strongly preferred. Ability to lead a technical team, and to give it direction, will be very important, as will the demonstrated ability to analyze the attorneys' needs, and to design and implement a whole system solution responsive to those needs.
Education
Bachelor's degree in computer science, engineering, or related field, and 3 years of experience in the appropriate area.
Certifications (if required)
Public Trust clearance
Documentation Required for submission
Signed letters of commitment from candidate is required.
Work Hours
The place of performance will be in the office of the United States Attorneys, currently
located at 601 D St NW, Washington, DC or remotely, as determined by the USAODC IT
Applications Manager. USAO-DC will provide workspace for the vendor at 601 D St NW.
Contractor personnel shall generally work eight hours a day within normal business hours
between 8:00 a.m. and 5:30 p.m.
Work authorization required
US Citizen Only
Relocation is accepted
Yes
Remote work
No
Additional Notes if any
This is for a full time role and candidates should demonstrate a proven track record in delivering IT functional expertise within government or related sectors, with an emphasis on the skills specified.
Job Title
IT Functional Expert Consultant
Client Company/Dept. Name
Department of Justice Office of U.S. Attorneys
Address
601 D St NW, Washington, DC
City Name
Washington
State Name
DC-District Of Columbia
Zip Code
If others (Address)
Mark up % (if any)
Duration of the project
Project Start Date:
December 13, 2024
Project End Date
December 12, 2025
Due date for Resume submission
October 28, 2024
No. of Openings
3
No. of Maximum Submissions
3
Job Description
TASK 1 Construction and Implementation of USAODC Case Statistics Data Warehouse and Other Required Data Warehouses
" Complete gathering of user requirements, Prosecutor Performance Indicators, and use cases for the Case Statistics data warehouse.
" Construct, test, implement and maintain ETLs (Extract, Transform, and Load) processes for the Case Statistics data warehouses.
" Finalize and implement Case Statistics data warehouse prototype including design of schema structures, staging areas, data marts, fact tables, dashboards and use cases.
" Maintain and modify Case Statistics data warehouse and ETLs as user requirements evolve.
" Using a similar methodology, construct and implement additional data warehouses as required by USAODC.
" Provide technical documentation all data warehouses and their components as required by USAODC.
TASK 2 Implementation of COTS/Government Software to replace Legacy systems
" Provide technical research and recommendations for COTS software or government-provided software to replace USAODC Legacy systems.
" Provide technical support for Legacy to COTS/Government software data mapping.
" Provide technical support for development of Legacy to COTS/government software data migration plans.
" Provide technical support for identification of Legacy features to be implemented in the COTS/government software environment.
" Provide technical support for develop and document system cut-over plans.
" Provide user liaison support to ensure system functionality is retained and/or improved.
" Provide technical support for User Acceptance Testing. Document results and ensure defects are corrected.
" Construct and execute data migration scripts as needed.
" Provide user and technical documentation as needed.
" Construct, test, and implement interfaces as required for the new COTS/government system to other USAO systems.
TASK 3 Development and Modification of Multi-Agency Interfaces
Contractor shall provide technical support in the development and implementation of new or existing interfaces with the Criminal Justice Coordinating Council (CJCC), Metropolitan Police Department (MPD), the DC Superior Court (DCSC), the DC Office of Attorney General (OAG), and the Pre-Trial Services Agency (PSA). These interfaces include the import and export of data and documents in support of the prosecution of criminal cases. Some of these interfaces involve loading the data and documents to a
staging area and then subsequently processing the data to the USAODC application. Specific tasks shall include the following:
" Provide support to modify current transaction loading and processing of data and documents in the current environment as need arises.
" Transition current transaction environment from Oracle to SQL Server.
" Transition current SOAP web services to REST API.
" Modify current and new multi-agency interfaces to support loading data and documents to new staging area environments.
" Migrate current processes to populate USAODC data sources with transaction data and documents from new staging areas.
" Conduct interface testing - internally and externally with other agencies as needed.
" Go Live and post-implementation support.
TASK 4 - Web Development of User Interfaces on Existing and New Applications
Contractor shall support the development and implementation of updated user interfaces using Web technologies on existing and/or new applications. In addition, MS SQL Server database in an MS Windows environment will be used for the backend RDBMS. Specific tasks shall include the following:
" Analysis of user requirements documented in a Functional Requirements Document
" Design and creation of data structures and database objects in MS SQL Server
environment.
" Design of the new module, interfaces documented in a Design Document
" Construction of forms, reports, interfaces, and processes required for User Interface
" Migration of data to new MS SQL Server environment, as needed.
" Unit and system integration testing
" Go Live and post-implementation support
TASK 5 Provide Maintenance Support for Existing USAODC Applications and
Processes
Contractor shall support the development and implementation of required modifications
for existing USAODC applications, processes, and interfaces. Specific tasks shall
include the following:
" Develop a system architecture document to illustrate USAODC application inter
connectivity.
3
" Design, develop, test, implement and document modifications of existing
USAODC applications including, but not limited to, Oracle Forms and Reports,
and MS Access.
" Design, test and implement roles-based application access vs direct grants
application access for Oracle applications.
" Develop and implement solutions for identified application security issues.
" Develop, implement, and maintain scripting solutions for various interfaces
including, but not limited to, MS Office 365 components and MS Windows.
" Construct and execute mass data update scripts as required.
" Conduct unit and system integration testing as required.
" Provide Go Live and post-implementation support.
" Provide recommendations and solutions for day-to-day user adhoc requests.
Skill set info
Skills in data modeling and process modeling.
o Knowledge of requirements analysis and system definition reports and
documentation.
o Skills in providing end user training.
o Skills in project planning.
o Skills writing user and system manuals.
" Web Technologies:
o XML (Extensible Markup Language)
o JSON (JavaScript Object Notation)
o Web Services (SOAP, SoapUI, REST API)
o Internet Authentication Service (IAS) for Windows Server
o Dynamic web pages using CSS, Ajax and HTML5
o .Net Applications using C#
o Java
" Databases, Operating Systems, Application Servers
o MS SQL Server
o PostgreSQL
o Oracle
o Linux
o Windows
o Apache
o Apache Tomcat
" Development Tools, APIs, and Scripting
o .Net Applications using C#
o VB Script
o Java
o Data modeling and data management using ERWin and TOAD
o Interactive Dashboards using Tableau, Power BI
o SQL Server Integration Services
o MS Access
o Oracle 12c Developer Tool Suite
PL/SQL
This is a senior level technical position, often the most senior level technical position for all work for a particular DOJ component. Must demonstrate substantial, hands-on, successful experience in actually doing the work on the systems being used, usually at least five years of such experience. Other systems environments will require other specific sets of skills. Requires broad knowledge of the Government's IT environments, including office automation networks, and PC and server-based databases and applications. Experience in a litigation support environment extremely helpful. Excellent oral and written communication skills are required. Supervisory experience very strongly preferred. Ability to lead a technical team, and to give it direction, will be very important, as will the demonstrated ability to analyze the attorneys' needs, and to design and implement a whole system solution responsive to those needs.
Education
Bachelor's degree in computer science, engineering, or related field, and 3 years of experience in the appropriate area.
Certifications (if required)
Public Trust clearance
Documentation Required for submission
Signed letters of commitment from candidate is required.
Work Hours
The place of performance will be in the office of the United States Attorneys, currently
located at 601 D St NW, Washington, DC or remotely, as determined by the USAODC IT
Applications Manager. USAO-DC will provide workspace for the vendor at 601 D St NW.
Contractor personnel shall generally work eight hours a day within normal business hours
between 8:00 a.m. and 5:30 p.m.
Work authorization required
US Citizen Only
Relocation is accepted
Yes
Remote work
No
Additional Notes if any
This is for a full time role and candidates should demonstrate a proven track record in delivering IT functional expertise within government or related sectors, with an emphasis on the skills specified.
Share this job
Useful Links
Similar Jobs
- View Job
IT Functional Expert Consultant - Part Time
Washington Highlands - View Job
PeopleSoft Functional Consultant
Washington Highlands - View Job
PeopleSoft Functional Consultant
Washington Highlands - View Job
PeopleSoft Functional Consultant - Washington, D.C
Washington Highlands - View Job
IT - Consultant I Consultant I
Washington Highlands