Kevin Hurt Email & Phone Number

Jefferson City, Missouri

Design physical database structures for the Department of Corrections re-architecture of their offender management system using an iterative agile approach.Designed and successfully implemented large relational OLTP database on DB2 for iSeries and DB2 for LUW.Successfully migrated a large set(200+) of iSeries tables to the DB2 for LUW environmentPerforms optimization of SQL, indexes and table structures to support online response time requirements on DB2 iSeries and DB2 for LUW.Design new relational data structures and create ERD Data Models for the development teams.Create DB2 database physical objects on the iSeries using SQL.Participate in user requirement gathering sessions.Provide technical guidance on the architecture of the application.Develop and estimate proposals for projects with our customers

Columbia Missouri

Evaluated information technology change requests for hardware and software needed Created architectural design documents to support changes requestedIdentified responsible technicians to implement changes to hardware and softwareCreated time estimates to implement changesLead architecture design meetings with the customer

Database Administrator at the Missouri Department of Corrections

Jefferson City, Missouri

Researched and architected the web services interface between the MMIS CICS application and the eMomed web application to facilitate the reuse of components between a real time claim adjudication project and a web application re-architecture project.Review, evaluate, and consult on the re-engineering effort of our eMomed web application to an IBM Websphere portal solution.Coordinate solutions between multiple concurrent MMIS reengineering projects to ensure all projects work together at implementation.Communicate with our customer gathering requirements and presenting solutions in a manner easily understood by end users and customer management. Researched and evaluated a solution to reface a CICS green screen application with a browser based interface using the IBM HATS software and continued with architectural oversight for all phases of the project to a highly successful implementation.Consult daily with multiple project teams providing creative solutions to issues and develop productivity improvements to ensure projects complete on time and in budget.Provide a QA review of all technical documents required by our customer to ensure contract requirement and service level agreements are met.

Jefferson City, Missouri

Evaluate, support and manage Missouri MMIS technology initiatives including leading a three-person team for the on-time migration of DB2 for z/OS from version 7.1 to version 8.1.Normalize, design and implement the DB2 database structures within the MMIS resulting in more accurate, flexible and available data in the recipient, TPL, psych prior authorization databases.Continually optimize the MMIS DB2 and CICS regions to far exceed service level agreements.Forecast MMIS mainframe usage for capacity planning to ensure the MMIS required service level agreements are met as workloads increase. Forecasting efforts have resulted in IHS exceeding the associated service level agreements for response times. Consult and advise with the technical staff providing solutions to software issues allowing them to be more productive. Recognized by peers for depth of knowledge of system interactions. Led a team of 3 in a one-year project to transition Missouri Medicaid mainframe processing; center resulting in no unscheduled downtime with no impact to the customer.Directed a 4-member team on the integration of Medstat's Decision Support System to the MMIS application on the Verizon data center resulting in a successful implementation that was delivered on-time.Developed the current interface between the eMomed internet application and the mainframe to support the real-time functions such as recipient eligibility inquiry.

Jefferson City, Missouri

Analyzed, designed, developed, and implemented changes to batch COBOL and CICS MMIS applications for State Task Requests as assigned.Forecast MMIS mainframe usage for capacity planning to ensure the MMIS required service level agreements are met as workloads increase. Forecasting efforts have resulted in IHS exceeding the associated service level agreements for response times. Consulted, advised, and provided problem resolution for the Missouri Medicaid programming staff supporting MMIS STRs.

Jefferson City, Missouri

Designed, programmed, and tested optimization of the MMIS resulting in a 15% reduction in CPU and a 33% reduction in DASD storage.

Jefferson City, Missouri

Led a team of 4 on the successful design, coding, and implementation of the capitation process of the Managed Care Enhancement section of the Missouri Medicaid Managed Care enhancement resulting in new functionality of the financial subsystem. Project was delivered on-time.

Jefferson City, Missouri

Managed two database administrators in the Database/Technical Support section performing DB2 and IDMS database administration responsible for delegating tasks ensuring customer satisfaction was met.Analyzed, designed, developed, and successfully implemented a worker's compensation system using the IEF tool, and DB2. Project was delivered on schedule.Installed and maintained an IBM LAN Server network in addition to maintaining personal computers running OS/2 and MS/DOS for the Systems and Programming Division of the Office of Administration.Utilized COBOL, CICS, ADS/O, Clists, JCL, and PSF programming skills to implement new functionality to the Office of Administration's application systems resulting in increased productivity of Office of Administration employees.Consulted, advised, and provided technical solutions for the Office of Administration development staff supporting both production support and new development.

St. Louis, Missouri

Developed a multi user version of the ProKit Workbench CASE tool that ran on a NOVELL network that accessed a shared database on a network server resulting in the first multi-user CASE software in the marketplace.Developed new enhancements and performed maintenance on the ProKit software using Realia COBOL in a MS DOS environment on IBM PCs running on a NOVELL network.Performed maintenance and enhancements on a mainframe COBOL and FORTRAN scheduling and cost control system.