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.
Agency: CA Department of Justice
Summary: Criminal Justice Information System Redesign
PROBLEM: The California Department of Justice needed to modernize its existing database architecture from legacy systems to new a distributed systems environment. This required the migration of nine CJIS applications from the legacy Unisys/COBOL environment to the new CJIS Open System Environment of Oracle/Sun/Solaris.
SOLUTION: LCS provided the application design, development, conversion, documentation, and implementation for the migration of nine CJIS applications from the legacy Unisys/COBOL environment to the new CJIS Open System Environment of Oracle/Sun/Solaris. These applications are responsible for processing message-based requests from the law enforcement community in California (which are submitted through the CLETS telecommunications network) and returning the response from the DOJ CJIS database via the CJIS Control middleware.
RESULTS: Six applications have been successfully deployed to production: Firearms Eligibility (FEAF), California Restraining and Protective Orders (CARPOS), Automated Firearms (AFS), Supervised Release (SRF), Wanted Persons (WPS), Stolen Vehicles and Boats (SVS/ABS). LCS is currently developing three additional applications: Missing and Unidentified Persons (MUPS), Automated Property System (APS) and Mental Health Firearms Prohibition System (MHFPS). These are real-time, mission-critical message-based applications, used by over 50,000 law enforcement users to verify the identity and background of individuals (when, for example, making a traffic stop).
Agency: California Prison Health Care Services
Summary: Clinical Data Repository
PROBLEM: California Prison Health Care Services (CPHCS) needed to address a number of Information Technology (IT) projects to achieve the Receiver’s efforts in raising the level of health care of patient-inmates to constitutional standards. These projects included: Clinical Data Repository (CDR), Health Care Scheduling System (HCSS), Mental Health Tracking System (MHTS), and Central Fill Pharmacy.
SOLUTION: LCS is responsible for development and implementation of clinical forms within CPHCS’ Clinical Data Repository (CDR). CDR is a system that provides a core set of services and functionality that lay the foundation of an Electronic Medical Record (EMR). LCS consultants are assisting CPHCS program and IT staff with development of clinical forms using Adobe LiveCycle Enterprise Suite, Oracle 10g and 11g, Oracle Fusion Middleware Suite, and Oracle Healthcare Transaction Base (HTB). The solution incorporates Orion Portal, Initiate EMPI, Oracle HTB and Oracle Fusion Middleware technologies including Oracle Database 10g and 11g.
RESULTS: CDR was released to six institutions as a pilot. Improvements based on user feedback are currently being developed and performance enhancements are being made prior to full production release.
Summary: Major PeopleSoft Upgrade to Overhaul Existing CalPERS systems
PROBLEM: The California Public Employees’ Retirement System (CalPERS) needed to upgrade its existing PeopleSoft Human Resources Management System (HRMS) system (Version 8.9) to PeopleSoft Human Capital Management (HCM) 9.1.
SOLUTION: The contract calls for LCS to provide extensive consulting to CalPERS along with PeopleSoft HCM software, UPK – Time & Labor, and Application Solution Center (ASC) Services LCS’ upgrade efforts will also include project management, analysis, design, testing, training, change management, implementation, and closeout activities. The LCS-led team is working with both the agency’s business and technical teams; specifically the CalPERS Human Resources Services Division (HRSD) and the ITSB PeopleSoft Human Resources technical team.
RESULTS: The CalPERS Upgrade is scheduled to be delivered on time and on budget.
Summary: PeopleSoft Supplier Contract Management (SCM) v9.1
PROBLEM: CalPERS’ goals were to achieve a 50 percent reduction in cycle times with standardize contract processes, reduced time-to-contract, and drive contract compliance while leveraging its existing PeopleSoft Investment. CalPERS needed to implement a solution with a team who would work in partnership with CalPERS to plan and coordinate technical requirements, design, development, implementation and knowledge transfer.
SOLUTION: LCS served CalPERS as a “one stop shop” for all its Oracle needs to support this implementation including contract management and oversight. LCS was responsible for the sale of the SCM licenses and support, the hosting of the technology environment by Oracle, as well as the implementation of the Supplier Contract Management application for one of the largest investment funds in the world. Oracle products used included Oracle 11G, PeopleSoft SCM v9.1
RESULTS: The SCM module was successfully implemented for CalPERS.