Researched, collected, compiled and synthesized demographic, caseload, program, service, and expenditure data into management reports at both the state and county levels for use by the Colorado Division of Child Welfare Services in decision-making and program management. Provided complex non-routine technical research, data and statistical analysis and evaluation using database programming, development, and reporting expertise combined with data and statistical analysis skills and an extensive knowledge of source data, transformations, and business usage. Designed and maintained analysis and reporting databases incorporating data extracted from both Trails, the statewide child welfare information system (SACWIS), and outside sources such as the Colorado Medicaid Decision Support System and the County Financial Management System (CFMS). Hired, trained and supervised two data analysts and an administrative support staff. Constructed a business plan with objectives for each of these positions.Met with staff and unit supervisors to problem solve data and analysis issues, discuss progress, and ensured program policy development objectives were planned and met.Represented the Division in research projects directed internally and/or externally. Planned and developed strategies for new models of information interchange and automation in child welfare. Researched and identified alternatives and impact of changes to Trails, the statewide child welfare information system, and other related state information systems and ensured child welfare business needs were defined in the detail designs, proper quality control measures were implemented, and all business requirements were included in Trails.Trained staff in data collection and analysis, software applications and information system use.Maintained and enhanced existing reporting databases and programs.

Provided complex non-routine technical research, data and statistical analysis and evaluation using database programming, development, and reporting expertise combined with data and statistical analysis skills and an extensive knowledge of source data, transformations, and business usage.Extracted, standardized and matched data values and relationships across disparate systems to ensure information accessibility, accuracy and completeness.Structured, validated and transformed existing Child Welfare transactional and operational data into high quality information for querying, analysis and reporting.Advised management in the design, implementation and management of Child Welfare decision support and database systems.Evaluated, recommended, developed, tested, and customized data access and evaluation tools and designs

Analyzed and developed technical requirements for computer databases and information systems used by the Colorado Division of Child Welfare Services. Interviewed subject matter experts and users to ascertain data and system requirements. Used structured design methods and computer aided software engineering tools and techniques to design and document proposed data structures, program module functions and requirements, management report layouts and on-line computer screens. Reviewed specifications with other analysts. Developed and scheduled specific documentation, programming, testing, and system implementation tasks to build project plan for assigned projects. Estimated time frames for design and implementation of new products. Interviewed, evaluated and recommended contract technical staff to team leader.Wrote technical computer program specifications, detailing data inputs, database interaction, processing logic, report layouts or on-line interactive screen designs and necessary data outputs for programmers to follow when coding and testing computer programs. Wrote and tested computer program modules to insure that specified processing logic was followed and correct data was produced both at unit and integrated test levels. Documented programs and produced listings of program code.

Researched, designed and documented new database products. Documented changes to data collection procedures, data item definitions and computer use for Industrial Databank. Investigated and resolved programming problems of on-line data collection computer system. Assisted in development, testing and documentation of new programs for data collection computer system Resolved subscriber problems concerning data validity, correct interpretation and use of database information, contracts, and product delivery. Researched and developed prototype for new database product.Edited user documentation for database productInsured accuracy of statistical data collection. Trained statisticians in new data collection procedures and data definitions. Analyzed and solved data collection problems. Wrote data collection procedures for airline statistics and industry specific data definitionsAnalyzed and collected financial and statistical data using annual reports and similar information sources