Success Stories
Web–Based Application: Financial Services
A start–up company patented an idea for a financial service that it would provide to client firms. A client firm would arrange with each of its regular customers to deposit into separate retirement investment accounts the rebates, sales discounts, and other monetary promotions that usually go directly to the customers. For the start–up company, the [...]
Software Integration: Municipal Government
On this project, two commercial off–the–shelf software products (KnowledgeLake Capture and Microsoft SharePoint) were modified and integrated with legacy custom software (previously developed in–house by the City of Pittsburgh) and new custom software (developed by B–Three). Objectives and Requirements The objective of the project was to construct, for the City of Pittsburgh, a new image [...]
Report Conversion: Healthcare
A nonprofit company in the healthcare field, with a significant presence and high visibility in two major metropolitan areas, contracted with B–Three Solutions for a project to upgrade its internal decision-support reporting. The client firm had a large number of internal reports — some created in Impromptu and others using Crystal Reports — running against [...]
Mobile Workforce Solutions: Law Enforcement
This was a multi–phase systems development project which brought about a major transformation in the law enforcement systems of the City of Pittsburgh. B–Three produced an integrated hardware/software solution, utilizing .NET forms for the user interface, with an Oracle database on the back end. This breakdown summarizes the work managed by B–Three Solutions: • Computerizing the [...]
Mobile Workforce Solutions: Building Inspection
Built for the City of Pittsburgh’s Bureau of Building Inspection (BBI) by B–Three Solutions, the Automated Code Enforcement application enables a building inspector in the field to receive an enforcement assignment (often based on a citizen complaint telephoned to a municipal services call center just a few minutes before), and then file a report — [...]
Hardware/Software Integration: Law Enforcement
Background: The City of Pittsburgh’s court scheduling system, referred to as “PayCops”, is an Oracle application that enables the City to efficiently schedule its police officers for court dates. The system takes into account the pass days of the individual officers, the scheduling requirements of the court system, and the terms of the collective bargaining agreement. It [...]
Hardware/Software Integration: G–20 Time Tracking System
In late September 2009, Pittsburgh hosted the G–20 economic summit meeting. To meet security requirements for this important event, the City arranged for approximately 3,000 out–of–town officers to supplement its own 900-officer police force. In advance of the event, the City asked B–Three Solutions to develop a system that could track the work of non–Pittsburgh law enforcement [...]
Forms and Reports: Bridge Inspection
B–Three Solutions was contacted by a firm which markets software for entry and reporting of bridge inspection data. This client asked B–Three to develop all the input forms, detail reports, and summary reports required for inspection of a set of bridges for a government agency. The first requirement of the project was for B–Three developers to [...]
Extension of Software Life: Crime Mapping System
The Pittsburgh Bureau of Police uses the MapStats crime plotting system to analyze trends in criminal activity and deploy its resources effectively. MapStats utilizes the ArcSDE component of ESRI’s ArcIMS GIS environment. Crime data comes from the Oracle database of the Automated Police Reporting System (APRS). Most of the City’s police activities are organized and [...]
Document Repository: Insurance
For an insurance agency, B–Three created a SharePoint Image Repository system to enable the firm to manage insurance records for approximately 16,000 customers. The solution incorporates hardware, commercially available software (Microsoft SharePoint), and custom software, in order to integrate document management with enterprise operations. Pre-Development Steps The first stage in every system development project undertaken [...]
Data Warehouse: Medical Information
A firm providing professional healthcare services to a large number of community hospitals asked B–Three to propose a solution for efficiently generating its internal reports. Pre–Proposal Analysis The client firm receives a substantial volume of medical data each day. Initially received in XML format, the information is translated into fields and records and stored in a [...]
Data Management and Analysis: Electronic Medical Records
A firm providing professional healthcare services to a large number of community hospitals asked B–Three to propose a solution for efficiently generating its internal reports. Pre–Proposal Analysis The client firm receives a substantial volume of medical data each day. Initially received in XML format, the information is translated into fields and records and stored in a [...]
Data Management and Analysis: Electronic Medical Records
A major university conducting important studies on diabetes engaged B–Three Solutions to meet its data management requirements. B–Three designed and constructed a data mart and created the processes to populate it with Electronic Medical Record (EMR) data. Diabetes — A Major Healthcare Problem Diabetes is a major burden on the healthcare system, diminishing the quality of [...]
Commercial Software Package: Voice–Powered Inventory System
Background: Client Facing Deadline A local software firm faced an approaching public release date for a major upgrade of their chief software product, a voice–powered inventory system that enables its users to make inventory decisions and enter inventory data by means of voice commands. Three Key Components With in–house resources and time at a premium, the [...]
Compliance Monitoring: Federal Contracts
B–Three Solutions has managed a number of projects for a large firm that is under contract with the Federal Government to perform background investigations and other security services. Because they engage in federal contracts larger than $2500, the client firm is mandated to follow specific pay practices. Our developers have created systems that monitor the client’s pay [...]
Commercial Software Package: Inventory Planning
A Pittsburgh–based company developed, and now markets, a software product that optimizes the inventory planning process. The product’s user interface is managed through web pages and custom AJAX controls. The application is written in Java Enterprise code, with an Oracle back end and a Model View Controller (MVC) architecture. The company engaged B–Three Solutions to design and [...]
Commercial Software Package: Auto Inspection
A company with 30 years of experience in the field of Quality Assurance developed the concept for a commercial software product to be sold to automobile dealerships and auto service businesses. The software product will enable the auto service client location to offer a free inspection to each customer, record the inspection results efficiently, and [...]
Case Management: Internal Investigations
Background The responsibility of the City of Pittsburgh’s Office of Municipal Investigations (OMI) is to follow up on allegations of misconduct by City employees. Most, but not all, of the citizen complaints investigated by OMI involve the actions of police officers. By City policy, each complaint that comes into OMI will be logged, investigated, and acted [...]
