Keith Hilgeman Email and Phone Number

Manage the team members responsible for efforts associated with systems analyst, requirements, design, development and maintenance, and deployment into a production environment:Managing execution of a Waterfall Method in a Mainframe environment, including managing priorities and tracking progress.Managing execution of Agile Method in Windows/Java environment, including managing scrum meetings, managing priorities and tracking burndown.Reviews work for technical accuracy and compliance with organizational standards and policies.Perform strategic planning, conducts in-depth studies, analyst of processes, and provides status reporting to senior leadership.Ensure Cyber Security guidelines are followed related to assigned work efforts and appropriate documentation is maintained and supported. Review of HP Fortify scans for vulnerabilities.Establish and maintain professional relationships with customers, functional owners and partner organizations concerning many program level issues requiring diplomatic tact.Support the management and mitigation of risk.Developed, sustained and enforced configuration management, change management, release management and quality assurance for Software Development Life Cycle (SDLC) model.Applied project management practices including developing plans and schedules, estimating resource requirements and monitoring activities, coordinating policy dissemination, managing policy maintenanceDeveloping mechanisms to measure policy effectiveness and compliance through creation of a Dashboard to monitor documentation compliance.

Member on the Service Orientated Architecture/Reports, Interfaces, Conversations and Extension (SOA-RICE) team on the Air Force Logistics and Materials effort Expeditionary Combat Support System (ECSS) to utilize Oracle Business Applications. Reviewed functional requirements for completeness and accuracy; created technical specifications (MD 070) from functional requirements, facilitated stakeholder meetings, prepared guidelines of software development for Sales Orders module within Oracle eBusiness Suite.Gained familiarity with Business Process Execution Language (BPEL), work flows and concurrent processes.Skills Utilized: SQL*PLUS 10, PL/SQL, Oracle Metalink, ClearQuest, ClearCase.Major Accomplishments and InnovationsAnalyzed and created technical method of ordering parts for Air Force Systems in Oracle eBusiness Suite.

Provided input to 2 employee performance evaluationsLed IT efforts for SunGard GetPaid (third party collection application) installation Locally hosted with 4 schema, Maintained SUN Solaris ksh scripts used to import and update from legacy Accounts Receivables (AR) systemApply data fixes and day to day system operations.Required modification/development of Oracle PL/SQL scripts, researched or resolving issues utilizing Oracle SQL statements daily. Responsible for Roadway Reverse Logistics application R2Returns. Included interfacing with internal and external customers and day to day system operations. Responsible for all aspects of application enhancements. Researched Facility Manager questions requiring use of Oracle Database SQL queries. Maintain/develop reports and maintenance modules using Oracle PL/SQL.Responsible to facilitating IT problem resolution with internal and external customers.Developer on Microsoft Project to Clarity conversion using T-SQL. Required to write T-SQL statements to pull data from Microsoft Project Database. Assisted Project lead in insuring data quality.Skills Utilized: UNIX shell scripts (ksh) RedHat, Sun Solaris V.10, Oracle FORMS (6i) and Oracle REPORTS (6i), SQL*PLUS 9, PL/SQL. Pro*C, T-SQLMajor Accomplishments and InnovationsRealized need, designed and programmed major modifications to invoicing module to allow for more dynamic capabilities for the Roadway Reverse Logistics System.Maintained and kept operational Roadway Reverse Logistics System at 99.999% up time.Kept $1B collection system running and up to date at 99.999% up time.

Led, Analyzed, programmed and supported the Carrier and Client Data Interfaces for Gates McDonald’s National Workers Compensation System and Liability System that transmits claim information to 85% of customer base. Analyzed and programmed 5 specific carrier file formats with 100% customer acceptance. Created and managed detailed project plans for each new interface.Led, Analyzed, facilitated stakeholder meetings, designed and programmed a process to dynamically create claim Diaries (future events) and have them relate to specific Case notes (past events). Components of this process required modifications to the online system as well as a creating batch processes. A table driven reporting system for Diary/Case notes was also developed. The results exceeded expectations from the claims staff. They found the solution very flexable.Developed an excellent knowledge of the Workers Compensation business to include National Council on Compensation Insurance (NCCI) and Detailed Claim Information Reporter DCI requirements. Was considered a problem solver.Skills Utilized: HP COBOL/3000 using KSAM and Image/3000 databases on an HP 3000 utilizing MPE and MPEX, Cognos Quiz and QTP, Suprtool, Powerhouse, FTPMajor Accomplishments and InnovationsRealized need for, designed and programmed a table driven audit program to audit claims in the database. The audit program was used in 5 processes to ensure accurate data in the system. (Policy, Negative Reserves, Claim Status, Claim Intake, weekly claim audits).Created Data Warehouse process for all monthly reporting and interface feeds. This increased reporting to 100% accuracy and reduced processing time by 32%Revamped Insurance Carrier and Client Claim interface reducing processing time by 65%.Discovered gap in business process which could have resulted in over $1B in erroneously worker’s compensation claims payments. Re-engineered business process and provided control reports to support the new process.