David Wilbur Email and Phone Number

Scrum/Agile software development manager leading a team of 6 to 10 developers and business analysts supporting State of South Dakota Departments of Education and Social Services.

• Developed complex reports and views for large financial services client for their implementation of IBM Interact and Campaign.• Developed and modified Cognos frameworks. • Gathered reporting requirements from clients. • Modified IBM Interact out of the box reports and views

• ETL engineer for data conversion from legacy claim system to Guidewire claim system. • Created mapping documents for complex data transformations. • Developed and unit-tested several SSIS packages. • Routinely met with business side subject matter experts to gather business requirements.

• Data Quality Assurance Lead on a large data warehousing project for the research and development department of a large, international seed company.• Data profiling and modeling• Developed source to target mappings• Wrote and developed text cases and test scripts to validate ETL workflows• Worked with SME’s to ensure that data models and data flows properly represented business rules.

• Managed a team of 23 consultants tasked with a large scale Drupal migration for the State of Arizona. • Trained over 5 new hire classes (50+ consultants) in SQL and relational database and data warehouse technologies.

Designed integrated data solutions for online magazine subscriptions using the following tools:• Datawarehouse Design• Data Modeling• ETL analysis• ETL design• Pentaho Kettle• MySQL

• Developed curricula and led classroom training for eight classes totaling 100 new consultants in SQL, database and data warehouse fundamentals, Crystal Reports, Business Objects, fundamentals of consulting, health insurance industry, and ICD-9 to ICD-10 conversion. • Evaluated trainees and worked with operations managers and human resources to determine retention, placement, and salary offers upon completion of training. • Managed a team of business analysts in an effort to establish scope and level of effort for migrating 1800+ reports to a new data warehouse environment for a financial services company. Created the time-table and risk analysis for the project.• Managed a team of developers in recreating reports originally built in Access and DB2 to Business Objects and Teradata for a health insurance underwriting department, allowing them to consolidate several state reports.• Managed a team of testers on a Business Objects project for a health insurance claims department, ensuring all the reports met the technical and business specifications. • Technical lead on a large report building team charged with building the most complex Crystal Reports in a Business Objects and Teradata environment for a health insurance claims department. • Researched, developed, and delivered presentation to senior executives, including the CEO, on Big Data and the company’s opportunities for entering that technology space.• Collaborated with sales executive to create marketing materials for Big Data opportunities.• Delivered technical briefing to sales staff on business intelligence for client presentation.• Revised and updated consultant career paths working closely with the head of HR.

• Developed Crystal Reports for an insurance company for operations and financial analysis.• Developed MS Access client application with an SAP back-end for a manufacturing company for inventory control and scheduling. • Developed an inventory management system in MS Access, tied into a QuickBooks accounting system for a livestock breeding company, allowing for more accurate billing.

• Developed quantitative models for process improvement and quality control. • Developed Lean Six Sigma programs that resulted in fewer defects and higher throughput. • Developed dashboard reports and key performance indicators that allowed operations managers to judge systematically and quickly the health of their operations.• Developed tracking database and reports for quality assurance analysts.

• Administered SQL Server 2000 database in support of an electronic lab information management system (ELIMS). Duties included security, replication, performance tuning, backup and restoration.• Enhanced ELIMS as necessary using Visual Basic and Crystal Reports.

• Created statistical models for vendor selection process, allowing department management to choose the vendor that would deliver the most cost effective performance. • Created a new quality assurance database and reports for quality checks of department processes. • Created and delivered a presentation on using statistics for quality assurance and process improvement to senior department managers. Many of the recommendations were adopted. • Developed a tax inventory data mart and reports, reducing tax penalties paid.• Developed and delivered SQL training to junior analysts, resulting in a query turnaround time improvement from over 100 hours to fewer than 48 hours. • Developed SQL Server 2000 data warehouse – with DTS and reporting functionality – for tracking parcel number cleanup for the entire mortgage portfolio – over 5 million mortgages.• Managed a team of developers in creating reports for department tasks database built in Oracle.

• Analyzed web site traffic for all company websites using Accrue analytics platform. Analysis allowed website engineers to troubleshoot design, editors to see which content received the most positive feedback, and marketing managers to see which advertisements were the most effective.• Managed relationship with analytics software vendors. Developed financial forecasting models to price multi-year vendor contracts.• Analyzed email campaigns. • Analyzed demographic data of websites using Net Nielson reports, working with marketing managers to conduct SWOT analysis on competing websites.

• Developed and wrote operating procedures for auditing flight operations paperwork in compliance with federal aviation regulations. • Created the flight operations auditing department. Hired, trained, and managed a staff of auditors. • Created and delivered presentation to senior management on revenue maximization using yield management methods and techniques. • Created airline inventory simulator using MS Excel and Visual Basic, allowing the pricing and inventory managers to make more profitable decisions.