Steve Huls Email and Phone Number

Responsible for evaluating data quality reports for files that were stopped by the system due to detected issues. Determine action for files in this state (contact the data supplier, reject the file for further analysis, etc.Developed idea for a new Source Data Analysis team at Polk. The team is responsible for analyzing source data and data issues to increase Polk’s understanding of the data received. Business requirements are documented in a standard format for all suppliers that allow ETL development to occur more rapidly. The team is also responsible for developing test cases and test plans to validate the ETL mappings.Designed and implemented procedures to handle data files and data fixes which cannot be processed automatically.Developed UAT procedures and test plans for both source specific Informatica mapping changes and system level PL\SQL changes. Investigate and resolve data issues identified by clients and client support teams. Typical resolutions involved identifying issues in the source file to be fixed by the file provider, identifying and implementing logic changes to the enhancement process, and helping the business understand the data when there are no data nor processing issues.Developed comparison process to regression test production interface file produced by new system against the production interface file produced by the legacy system. The interface file is the only link between Polk’s data store and the product databases.

Contract employee at R.L. Polk & Company on the Source Data Team in Data operations. The team is responsible for data receipt and source specific data transformation.

1993 -1995 Project Manager for systems projects. Manage Interactive Voice Response (IVR) systems for existing clients and manage delivery of systems to new clients. Responsibilities include: presentation of system to prospective clients, meet with new clients to develop system specifications, design system and develop script, work with programmers to develop system, test completed system before delivery. Includes programming in VAL, Clipper and SQLWindows. Develop and monitor process which allows data to flow between IVR, 401(k) recordkeeping system and client’s payroll system. Manage delivery of support and requested changes to COBRA accounting system to clients. System written in Clipper. Provide support for 401(k) recordkeeping system including bug fixes and client specific modules. Write specifications for programs to convert new clients to 401(k) accounting system. 1991 - 1993 Systems Analyst / Programmer. 1987 - 1991 401(k) Plan Administrator / Programmer

1993 -1995 Project Manager for systems projects. Manage Interactive Voice Response (IVR) systems for existing clients and manage delivery of systems to new clients. Responsibilities include: presentation of system to prospective clients, meet with new clients to develop system specifications, design system and develop script, work with programmers to develop system, test completed system before delivery. Includes programming in VAL, Clipper and SQLWindows. Develop and monitor process which allows data to flow between IVR, 401(k) recordkeeping system and client’s payroll system. Manage delivery of support and requested changes to COBRA accounting system to clients. System written in Clipper. Provide support for 401(k) recordkeeping system including bug fixes and client specific modules. Write specifications for programs to convert new clients to 401(k) accounting system.1991 - 1993 Systems Analyst / Programmer.1987 - 1991 401(k) Plan Administrator / Programmer

Contract employee at Ford Credit on the Enterprise Data Warehouse (EDW) Extract-Tranform Load (ETL) team. The team is responsible for the processes loading external and internal data sources into the EDW.Led project to add Commercial Lending data to the EDW requiring the addition of four new sources and modification to 3 existing sources. Conducted source data analysis to conform data to existing warehouse standards. Collaborated with the project manager to determine resource requirements and project timelines. The project required 50 new processes and modifications to 50 existing processes. Designed and implemented a datamart which links credit analysis data to the receivables contract data.Led project to modify Data Warehouse processes when Ford Credit changed account receivable systems. The project involved removal of two legacy systems and incorporation of new receivables system as data sources for the warehouse. Completed an impact analysis and project plan for modifications to 100 individual processes. Coordinated Quality Assurance testing with business end users as test data became available. Co-authored System Development Life Cycle (SDLC) document with another member of the team. The SDLC devoted a section to each major task required to make changes to ETL processes. Each section identified resource requirements, prerequisite steps and deliverables for a major task. Co-authored first project plan based on the SLDC. The project plan format was eventually expanded to include tasks both preceding and following the ETL team's tasks.Developed team's first formal test plan for changed or new processes. Format was eventually integrated into the SDLC. Developed first project migration plan which eventually became part of the SDLC. The migration plan is checklist to track JCL and source code members from the time they are checked out for modification to the time they are checked back in after testing.

Responsible for designing and building infrastructure to load data into proprietary database:Develop specifications for various pieces of the production processing environment such as Data Transformation Software, Data Conversion Scheduling Software, Client Rawdata File Cataloguing, etc.Locate software vendors and evaluating their products with respect to functional requirements of the data processing environment. Select the vendor when multiple vendors meet the requirements.Implement ETI Extract for data transformation. Includes developing list of required customizations, writing specifications for customizations, and implementing the customizations.Write functional specifications for required software when there is no external product available meeting process criteria.Prepare schedule and determine milestones for releases of production software.Prepare hardware and software cost estimates supporting company’s growth projections.Determine staffing levels required to meet development milestones. Prepare job descriptions and skill requirements for planned hires.

1998 - 1999 Database Operations Manager Manage team responsible for completing annual research database build. Allocate computer resources (HP9000 and NT Server) for the entire division, coordinating disk space for product development projects, client support projects and operations projects. 1995 -1998 Sr. Consultant / Team Leader. Led a team of three responsible for designing, building and updating databases housing medical claims, short term disability and long term disability data. Monitor resource allocation and seek help from outside team when work load exceeds available resources. Worked with client managers and clients to define scope of new projects and provide cost estimates and negotiate expected completion dates. Developed and led training to teach internal staff proprietary, PC-based database application.