The Challenge

The Las Vegas Metropolitan Police Department (LVMPD) needed its prison booking system to work with the systems around it: a Lotus Notes environment, other antiquated third-party software, and the national database of wanted persons. Booking data is sensitive criminal-justice data, so every integration had to respect access control and leave an audit trail. I joined through Robert Half Technology to help define, develop, and integrate the system.

Key Pain Points:

  • Legacy Lotus Notes and third-party systems with no modern integration path
  • A required connection to the national wanted-persons database
  • Strict access control and auditability requirements for criminal-justice data
  • Booking workflows that could not stop while the integration was built

My Solution

1. Requirements Definition

Worked with department stakeholders to define what the booking system had to exchange, with whom, and under what controls.

2. ASP.NET 1.1 Front End

Developed the newer ASP.NET 1.1 front end that sat in front of the legacy pieces, with role-appropriate access and logging of system interactions.

3. Legacy and National Database Integration

  • Integrated Lotus Notes and other antiquated third-party systems with the new front end
  • Connected the booking system to the national wanted-persons database
  • SQL Server data access with stored procedures for the booking workflow

Technical Implementation

Key Technologies

Application

ASP.NET 1.1 C# / VB.NET

Database

SQL Server T-SQL / Stored Procedures

Integration

Lotus Notes National wanted-persons database XML

Security

Windows Authentication Audit Logging

Results & Impact

  • Booking system integrated with Lotus Notes and other legacy systems through a modern front end
  • Connection to the national wanted-persons database established as part of the booking flow
  • One of several concurrent Robert Half contracts that year; named Consultant of the Month in November 2005

What This Means for AI Implementation

The LVMPD work taught me how to:

  • Design systems that handle sensitive data with access control and audit trails from day one
  • Integrate modern solutions with legacy infrastructure nobody wants to touch
  • Navigate government requirements without slowing the people doing the work

Those habits carry directly into private AI deployments for government and enterprise clients, where security, compliance, and integration with existing systems are the first questions asked.