California Department of Justice
Problem: DOJ’s mission critical (police officer safety/lives at stake) Criminal Justice Information Systems (CJIS) were initially developed over 30 years ago and continued to run on an antiquated platform. They became difficult, if not impossible, to maintain and increasingly expensive to operate. DOJ needed to modernize these applications without disrupting strict service levels to over 60,000 law enforcement agencies throughout California.
Solution: LCS was responsible for the design, application integration, and implementation of these applications from the legacy Unisys/COBOL environment to the new Oracle/Sun CJIS Open Systems Environment. These applications are responsible for processing message-based requests from the law enforcement community in California that are submitted through the CLETS telecommunications network and returning the response based on information stored in the CJIS database. The six applications LCS redesigned are Firearms Eligibility (FEAF), California Restraining and Protective Orders (CARPOS), Automated Firearms (AFS), Supervised Release (SRF), Wanted Persons (WPS), and Stolen Vehicles and Boats (SVS/ABS).
Results and Benefits: DOJ chose to redesign/redevelop these applications using Oracle technology. DOJ chose LCS because of the specialized skills of its elite technical team and our speed and response time in completing the mission critical elements of the project. In partnership with the IT staff at DOJ, LCS was able to complete the redesign and redeployment of these highly complex systems and provided DOJ with a new knowledge base for internal staff training and development on the new systems.
“LCS has the ability to go beyond the database migration and look at the challenges of the architecture itself. Stephane did one of the best jobs I’ve seen at understanding the problem. Their team had the skills sets we needed,” Jim Brown, Bureau Chief, State of California, Department of Justice.
Fortune 500 Company
Problem: This Fortune 500 company’s enterprise operations center needed to rebuild its internal database team after an outsourcing decision proved inefficient in handling the upgrade, maintenance and scaling issues associated with the company’s new inventory system. This company needed senior-level expertise and enterprise performance tuning expertise to maximize throughput for batch and interface jobs. It needed experienced database professionals to analyze performance in production and pre-production environments and develop strategies for improvement.
Solution: The company chose LCS to fill the void in its programming and enterprise database management teams because of the experience and skill set of its elite technical team. LCS was able to provide our client the solution for performance tuning and scaling new Inventory System deployed for the company, including transactions consuming billions of records on multi-terabyte databases.
LCS assisted in the design and development of the infrastructure to ensure maximum throughput for batch and interface jobs, including physical database layout and server configuration, and including but not limited to, SAN, Unix and Database layout. The LCS team was able to review
the application and interface (SQL and PL/SQL) code for tuning opportunities. LCS also analyzed performance in production and pre-production environments in order to develop strategies for maximizing the Oracle infrastructure.
Results and Benefits: Our client’s IT management team commended LCS on its expertise and ability to provide the right solution. We thoroughly investigated their business and technical problems, provided an effective holistic solution and the right documentation to ensure that the client’s ongoing performance tuning and maintenance could be handled quickly and easily. LCS also exceeded our client’s expectations through our timely and relevant communication throughout the project.
