Data Warehouse

City of Phoenix - Public Works (Refuse Collection and Billing) Business Analytics

LCS coordinated, led, and delivered a fixed price Business Analytics project for the City of Phoenix, the seventh largest city in the US.

LCS provided the experience to plan, design, build/test and deploy a complete enterprise business intelligence solution to be leveraged by not only the Public Works Department, but capable of supporting the entire City of Phoenix business intelligence needs.

Just 5 months after the project start, the project went live with the first phase of the Field Management Operational and Executive Dashboards pulling Public Works data from four source systems. This led to more timely and accurate information for management and operational divisions to make informed business decisions improving operational efficiency.

LCS continues to add functionality and data to this Analytic application used by Phoenix to continually improve its waste management operation.

Given this overwhelming success, the American Public Works Association invited the City of Phoenix to contribute to their March 2014, publication by writing an article relative to the BAU project. LCS' COO, Chris Wilson, co-authored this article in the American Public Works Association Reporter with John Trujillo, Assistant Public Works Director for the City of Phoenix. 

Back to the top.

Custom Development

California Department of Justice (DOJ) - Criminal Justice Information System (CJIS)

This project was a five-year effort to migrate DOJ’s CJIS off the legacy Unisys/COBOL environment to the new Oracle environment.  The project was a complete redesign and rewrite of eleven systems/databases, sometimes referred to as “hot files”.  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 (for example, when making a traffic stop, to determine whether the car may be reported stolen or the registered owner may be wanted for a felony).  Officers’ lives depend on these applications working flawlessly 24/7/365.

In addition to the CJIS application, LCS has performed extensive work on DOJ transactional applications such as Sex and Arson Registry (CSAR) as well as Firearms applications such as Dealer Record of Sale (DROS).

Back to the top.

ERP - Enterprise Resource Planning

California Public Employees Retirement System (CalPERS) - PeopleSoft HCM 8.9 to 9.1 Upgrade Plus Time and Labor Implementation

In addition to managing benefits for public sector employees and retirees in California, CalPERS is one of the world’s largest investment funds.

This project upgraded CalPERS PeopleSoft Human Resources Management System (HRMS) system (Version 8.9) to PeopleSoft Human Capital Management (HCM) 9.1 and included upgrading/implementing the Time and Labor module.  It included assisting CalPERS with the procurement of the required PeopleSoft HCM software including, but not limited to, UPK – Time & Labor, and Application Solution Center (ASC) Service Cost. 

This upgrade effort included project management, analysis, design, testing, training, change management, implementation, and closeout activities.  LCS worked with both business and technical teams to successfully accomplish this upgrade. 

County of Kings - PeopleSoft HCM 9.0 to 9.2 Upgrade Plus Time and Labor, ePay, eProfile and FMLA Implementation

LCS performed an assessment of County of Kings current version HCM 9.0 PeopleSoft System. LCS focused on the existing PeopleSoft 9.0 system as well as, the new implementation of ePay, eProfile, ePerformance (eApps), FMLA and Time & Labor Application Modules.  The goal of the assessment was to provide the County with a strategy to bring its eApps, Time & Labor, and FMLA Application Modules to production. The assessment provided County of Kings a recommended upgrade approach, benefits, roles, timeline, level of effort and costs to successfully support the County.

As a result of this assessment, LCS was selected to provide consulting services to County of Kings for its PeopleSoft HCM 9.0 to 9.2 Upgrade, 9.2 Time & Labor, ePay, eProfile, and FMLA implementation. This engagement included project management, project discovery and requirements gathering, fit gap analysis, design of customizations and development, testing, documentation and user training.  

California Commission on Teacher Credentialing (CTC) – Seibel CRM Implementation

The Commission on Teacher Credentialing (CTC) is an agency in the Executive Branch of California state government responsible for issuing       credentials, certificates and permits for service in California’s public schools.

LCS was selected to assist CTC to retire the existing contracted custom means of performing self-servicing credentialing activity via the web; provide all functionality the existing vendor is currently providing; provide public and stakeholders’ availability to current up-to-the-minute credential data in real time with a user-friendly web interface that is fully integrated into CTC’s existing enterprise-wide credentialing automation system; and allow direct control over changes, updates, enhancements, and security by CTC. 

The goal of the project, which was successfully achieved, was to implement a credentialing web interface solution to be hosted in-house by CTC, via a customer facing application; consistent with the Commission’s credentialing automation system environment and strategic direction, including data sharing and reuse of current Credentialing Automation System Enterprise (CASE) business logic, with web user views based on existing views. The Commission’s licensing and credentialing functions operate via a Siebel Customer Relationship Management application. 

LCS provided quality control, planning, project management, requirements analysis, design, coding, testing, training, change management, and implementation on this project. We were responsible for overall coordination of numerous LCS, State, and contract resources. LCS was responsible for managing contracts, scope, change control and staffing. We utilized a 'train the trainer' approach for application users in which we trained key central office staff, who then trained CTC users.  We also trained CTC IT staff to assume maintenance of the application.

Back to the top.

Managed Services

LCS is providing remote managed services for customers in this new and growing market segment. Learn more about how Managed Services can complement your business needs: click here.

Back to the top.