BRAC Management Information System Application & Maintenance Support
Department of Navy
- Start Date : September 2008
- End Date : September 2011
- Duration of the project: 3years
Tri-Force Consulting Services, Inc. has provided support to the Department of Navy, Naval Facilities Engineering Command (NAVFAC Atlantic), Base Realignment and Closure Program Management Office's (BRAC PMO), and has taken care of the support and services requirement of the (BRAC MIS).
Tri-Force maintained the entire BRACMIS and KMS systems. Our responsibilities included database management, ensuring availability of services and functionalities by providing all kinds of essential technical maintenance, data analysis, and program management services.
The web oriented database application used by BRAC PMO is based on Microsoft Transaction Server, ASP.NET, Classic ASP, Visual Basic (VB/MTS) COM Component for front-end, and Oracle 11g for back-end. The system developed by Tri-Force supports the realignment, closure, disposal; program and financial requirements for Department of the Navy installations. The BRAC Program Management Office is responsible for coordinating with the Department of Navy BRAC Support Offices, Commander Navy Installations Command, Headquarters Marine Corps, Naval Facilities Engineering Command, and Department of the Navy Assistant for Administration (DON/AA), and all echelon commands with BRAC implementation responsibilities. As per the requirements of the BRAC community, reports are generated and provided to higher echelons. The information required for BRAC actions is dynamic in nature which is often voluminous, requiring frequent data calls. The privileged users of the Department of Navy (DON) must have the ability to prepare rapid responses to requests made for information. The system takes care of this requirement, and is serving the demands of the DON ceaselessly since its installation.
BRACKMS consists of a data warehouse built on Oracle 11g and the presentation layer is built on Cognos8 Business Intelligence (BI) Suite. BRACKMS gets data from different source systems such as the Standardized Accounting & Reporting System - Field Level (STARS-FL), NORM and FIS. Tri-Force used Microsoft SQL Server Integration Services (SSIS) to Extract the data from flat files, Microsoft Access, Oracle and Other type of source systems, transformed it by applying different business rules and loaded it into the data warehouse. Its main data source system is BRACMIS where data is pulled twice a day to update the PM module of the data warehouse. The Tri-Force team used different techniques such as parallelism to improve the performance of the data integration operations in SSIS.
BRACKMS allows the BRAC PMO users to easily access information and enabling them to create List, Grouped List, Crosstab and Charts report quickly and easily. Reports that used to be generated manually are now automatically generated. Weekly and monthly standard reports are sent automatically to BRAC PMO managers through cognos8. Tri-Force team has done trainings to BRAC PMO users to help them get more familiarized with the cognos8 BI tools.
Tri-Force had four consultants working on BRACKMS and the consultants were working closely with BRAC PMO to assist them with their reporting needs. There was also a close coordination and collaboration between BRACMIS and BRACKMS in support of BRAC PMO data requirements
Our dedicated resources supported following tasks by adhering to standards:
- Assisted the Government in implementing approved system and network design changes, System upgrades or equipment replacement, over and above normal operations. Such support was planned to minimize disruption of day-to-day operations.
- Maintained user access to BRACMIS systems; sustain database availability and functionality.
- Maintained the BRACMIS database, including fields, tables, schemas, snapshots, updates, displays, reports, and extracts.
- Maintained user access to the BRACKMS system.
- Maintained the BRACKMS backend datawarehouse.
- Upgraded software, update tutorial, and research and define proposed modifications to system and NMCI documentation as needed.
- Supported the Government in data queries, data management, and design and execution of data calls.
- Conducted internal performance reviews and provided timely notification of items which require Government action.
- Delivered requested reports and products.
- Participated in meetings with the Government.
- Assured continuous quality improvement in service, technology, and program management; report on improvements in service and technology that could be implemented
- Provided help desk functions to assist system users to research and resolve BRACMIS problems.
- Maintenance of the BRACMIS database; Data Management Services and Support: database administration
- Maintenance and Enhancement support for Web application development; Client software application development
- Help Desk Support
- Technology Stack
Website re-design performed for City of Philadelphia Prison Systems
City of Philadelphia
Relevance: Tasks included website redesign, update, content development and re-development, and maintenance support. Abstract: Tri-Force has accomplished website update and maintenance of the Philadelphia Prison System (PPS), www.phila.gov/prisons. Our tasks included updating and redesigning the Prison’s website and to provide ongoing maintenance as requested.
Migration to COLLAGE (Content Management System):
Tri-Force moved the current Prison’s website to COLLAGE, the City of Philadelphia’s Content Management System. Tri-Force also worked with the Division of Technology to ensure that the Prisons website is fully compliant with security regulations. Tri-Force moved the site to COLLAGE, whereupon authorized users are able to quickly and easily manage the content on the website.
Tri-Force updated the current PPS website design in order to meet the latest guidelines in web development standards, such as the shift from 800x600 to 1024x768 resolutions.
Tri-Force Developed Inmate Locator functionality for Prison system, where people can find an Inmate on different criteria like Last Name, First Name, DOC etc. using ASP.NET web service and ORACLE RDB. Content Update: All the tasks concerned with content updates related to the Prison’s IT staff were performed by Tri-Force.
As part of a joint effort between Prisons and Tri-force’s staff, Tri-Force accomplished tasks to regularly update the website with current content (inclusive of text, photos and documents).
- Technology Stack
“Web Log” Development for Marine Gas Turbine Information System
Department of Navy
Tri-Force Consulting Services developed the web-based application named “Web Log” for the MGTIS (Marine Gas Turbine Information System) for the US Navy as a subcontractor to EDO Corp, Inc.
- A complete web-based application developed from the ground up.
- Test and Development Environment set-up.
- Bug-tracking system, document management system, and code repository systems created
Tri-Force Team’s Roles and Responsibilities
The Tri-Force team worked closely with program managers and technical leads at EDO to identify the functional specifications for the application and business processes. Senior Tri-Force developers designed use cases and detailed technical design documents for this project.
The Tri-Force team followed XP (Extreme Programming) methodologies for the entire software development life cycle and maintenance of the web application, database, and workflow processes. They implemented a bug tracking system to monitor and track maintenance and future enhancements on this project.
Tri-Force implemented “best practices” in User Interface standards during the web application development process.
Tri-Force was responsible for setting up the test and development environment using web servers, and Oracle, and SQL Server 2005 databases. The team set up the Windows 2003 servers, and document management system for this project. Tri-Force also maintains an inventory of all the hardware and software systems utilized on this project.
Our management team was responsible for submitting weekly and monthly project status reports for each team member as well as providing overall project status to the program manager.
- Technology Stack
Web application development for RGP (Rio Grande Project (EL PASO) – Phase VI)
Department of Interior
Relevance: Recent trends in web application development suggest that the web is turning dynamic, and soon static HTML content will get replaced by the dynamic web pages. A similar web development project under the U.S Department of the Interior has been awarded to Tri-Force Consulting Services, Inc.
The project is about water resource management, and several reports have to be prepared, the basis of which is data related to the water resources. Tri-Force Consulting Services, Inc. has been serving the needs to convert the static content of the reports into dynamic content so that recent updates are easily reflected, and the corresponding changes are easily made in the database.
As per the requirement of our government clients, Tri-Force Consulting Services, Inc. provided customized report generation and views in formats such as .pdf and Excel. The privileged user can modify the content through form based submission. Acknowledgement is provided on successful update in database or in case of errors (e.g. connection to database could not be established) if any.
Creating/Editing reports from the web browser, and saving the changes into the database.
Efficient Database access-multiple reports are generated by accessing a single database table.
Virtual Forms for efficient data entry and processing. Only a part of the form data gets processed without affecting the complete form data resulting in increased speed.
Providing acknowledgment messages about errors/modifications in the database.
Maintaining reports for longer duration-preventing data to be overwritten so that previous reports can also be retained for at least two years (as per the contract).
Extensive testing-navigation of pages, browser compatibility testing, performance testing for database access and query response time
- Technology Stack
City of Philadelphia Prison System’s Axiom Data Warehouse Support
City of Philadelphia
Tri-Force Consulting Services, Inc. supported the Philadelphia Prison System’s Axiom Data Warehouse. The Axiom Data Warehouse is a Business Intelligence tool that facilitates the reporting and analysis of Philadelphia Prison System data. Original functionality allowed staff members to perform basic assessments of the inmate population in support of initiatives to understand, manage, and reduce the population.
PPS has undertaken an initiative to create a data warehouse called Axiom that has already been demonstrated and applauded by PPS staff, Division of Social Services and the Managing Director’s office. Axiom is the foundation of an extremely powerful and adaptable business intelligence environment which will be expanding in content and scope over the next several months and has already been the vehicle for supplying key reports and analysis internally and externally. It will continue to provide the ability to:
Analyze the population from various demographic and judicial perspectives
Understand cause and effect of proposed and implemented initiatives
Assess and improve operations
Readily produce reports requested internally and externally based on PPS data
The Axiom data warehouse the source of the underlying data is Lock and Track Offender Management System. The data mart in PPS is the “Current Population” is a data mart providing information relevant to the current census – early release and special release procedures, initiatives, and results. There is a standard set of reports that are built into the business intelligence application that have been created and put into production on a routine basis. Currently, there are numerous reports generated through Axiom such as the “30-Day until Maximum Sentence” or the “Length of the stay” which has been developed, validated and produced on a periodic basis as specified by the users of the report. Ad hoc analysis is performed at PPS, such as group of inmates often must be selected for transfer to another facility – certain criteria must match to identify the candidates.
The Commissioner has requested various data that will be available through web portal at all times. It will contain various pieces of data, including current census, average intake time, average length of stay for the current population.
The Tri-Force team worked on the Axiom data warehouse project is providing a business intelligence tool that will help to augment current MIS effort and usurp a great deal of avoidable effort. The existing Axiom Data Warehouse was assessed by Tri-Force Consulting at project kick-off. The assessment uncovered the need for design changes to be made to the data model to allow business logic processing to occur at the proper level.
Software re-designs to transform the data model and the data dictionary to eliminate redundant business logic at the ETL level.
Managing the design and performance of the SQL Server database as well as enhancing and managing the nightly data loading (ETL) process.
Enhancement and management of the Cognos business intelligence framework for the data warehouse, which includes the library of reports, analytical cubes, archives, Meta data, and the user interface.
Integrating and expanding the scope of the data warehouse to add additional functionality encompassing all aspects of operations at the Prison System
- Technology Stack
SQL Server 2005, Oracle 9i, Data Modeling, ETL, Cognos 8
Programming support and maintenance for MIRA Spreadsheet / Database application
Environmental Protection Agency (EPA)
Primary idea behind this program initiative is to assist in improving the decision making process of the U.S Environmental Protection Agency (EPA) Region III by means of various Computer Aided Software Engineering (CASE) tools and technology.
Tri-Force Consulting Services, Inc. is seamlessly supporting the U.S Environmental Protection Agency (EPA) Region III for enhancing its decision analysis process. In order to improve the environmental decision making, EPA Region III is following an excellent modular approach which is termed as Multi-criteria Integrated Resource Assessment (MIRA), and Tri-Force Consulting Services, Inc. is performing the task of Microsoft Excel 2007 Programming for MIRA which includes development of a web-based front end, testing of system components and documentation of the source code.
Tri-Force Consulting Services, Inc. is committed to satisfy the demands and requests of the EPA staff, while closely focusing on the system design and the enhancements which are required in order to meet the program objectives. Tri-Force Consulting Services, Inc has been successfully converting the concepts and ideas into procedures and methods which are used for code generation. Tri-Force Consulting Services, Inc also takes care of the essential responsibility of providing technical overviews about programming to the analytical communities with the EPA.
Tri-Force Consulting Services, Inc. has been in close collaboration with the EPA Region III in order to modify the decision making hierarchy of the MIRA. Tri-Force has been working with the EPA Region III’s GIS Team in order to improve the logic for better analysis of the geospatial data.
Building User Interface (UI) and system components for easy and efficient web porting
Use of Computer Aided Software Engineering (CASE) tools for programming tasks
Implementation of real-time feedback feature in the software application
Automation of system functions and steps which are part of the MIRA
Converting Excel Visual Basic Architecture (VBA) into data base architecture
Documentation of source code as per IEEE standard and maintenance in Software Configuration Management tool (Microsoft Visual Source Safe).
Maintenance and support for system modules-both Excel based and PostgreSQL based versions of MIRA
Providing technical overviews and system training.
- Technology Stack
MS Excel Office 2007, T-SQL, .NET, VBA, PostgreSQL