Lead Full Stack Consultant
Alameda County, Oakland
• Created new ASP.Net Razor UI screens using Visual Studio 2017 for Pre-Trail defendents using SQL Server 2014 for court preceedings • Implemented a Redis queue for Probation Department to post JSON objects for parolee’s that were consumed by a 3rd party court application• Modified legacy COBOL programs and CICS screens to Java class and JSP modules as part of the modernization project.• Modified Alameda Sheriff’s REST webservices by creating new end-points to provide arrest information for plaintiffs from DB2 databases.• Created java modules to populate RabitMQ queues for Pre-trail information from Sheriff’s SQL Server Databases for Tyler Software visibility• Utilized Asynchronous message queues features in Rabbit MQ to poll jail message for suspect bookings and updated MS Sql database• Converted approximately 30 DB2 stored procedures to T-SQL as part of a project to migrate from DB2 to SQL Server 2014.• Created new Java programs to process XML data from Mule and populate SQL Server tables for the CRIMS database• Created new Jenkins jobs for code deployment to CRIMS test servers as part of the JBOSS migration from IBM WebSphere• Created Spring Batch Java modules for ETL from DB2 to SQL Server and provided run-time analysis of the Spring Batch Job Repository for IT Operations• Created a Spring Batch process to populate MongoDB with Warrant Arrest information for later governmental reporting to the State of California Justice Department.• Created and deployed AWS Lamdba code for processing Bail data and posting to the Tyler Court System Technologies used: Splunk, Postman, DB2, SQL Server 2014, JDK 1.8, Grunt, Git, SpringBoot 2.0, RabitMQ, Jenkins, WebSphere, JBoss, Spring Batch, DB2, SQL Server 2014, TSO, SPUIF