Dave Elderkin Email & Phone Number

Hoffman Estates, IL

• Creating TransformCo's single version of truth of for company-wide metrics and reporting, primarily based on the industry standard ARTS model. This includes building reporting and training for the rest of the company.
• Modeling, mapping and converting TransformCo's reporting systems to BigQuery including a 5.2 PB, 198 node, 720 Tcore Terdata environment.
• Assisting with moving operational processes off on-premise Teradata solution to Teradata Vantage.
• Built a custom requirements and metadata tracking application to map existing processes to the new environment, primarily to fill the gaps in commercial data modeling and master data management tools. This application.
• Negotiated or renegotiated contracts with data providers when SHC declared bankruptcy, allowing critical cash generating processes to continue though bankruptcy without interruption.
• Manage an onshore team of senior data architects, system engineers, data analysts and technical trainers.

Hoffman Estates, IL

• Owned and managed all Home Services database systems and support including structured and unstructured database systems.
• Converted routing solution from ServicePower to Click for routing about 5600 product repair technicians nation-wide.
• Converted operational customer facing systems from IBM Mainframe to AWS tech stacks.
• Reduced Home Services spend on databases by over 80% by optimizing database structure and processing.
• Built custom applications for keeping disparate RDMBS technology in sync without manual intervention.
• Built custom reporting solutions to fill gaps in commercial software, specifically around ease of support, allowing for substantially smaller support teams.

Hoffman Estates, IL

• Managed systems and support integration for Innovel, primarily Installation and Delivery.Integrated Innovel systems with dispatch platforms ServiceBench and ServiceLive, which dispatched work to the lowest cost.
• Created route management, customer survey, signature capture, & model/serial capture application for Android phones for use by Innovel driver teams.
• Created online reporting application that tracked about 1400 metrics across all innovel businesses.
• Created Plumbing, Electrical and Construction permit database application, which tracked more than a million permitting requirements across the United States to the municipality and product level. This allowed job.
• Managed an onshore team of application developers.

• Lead a multi-business project with more than 100 members to convert the 160M/Yr Installation business from fax based to an electronic dispatch system. This resulted in a savings of 4M EBITDA/Yr and allowed for.
• Lead a project to survey 100% of Installation customers via a 3rd party, and managed the relationships once implemented.
• Lead a project to allow Installation to be sold on Sears.com and ManageMyHome.com which added 8M/yr in incremental sales.
• Created automated dashboards and reporting on more than 1,300 metrics for all facets of the business.
• Created a permit system that tracks electrical, building and plumbing permits nationwide.
• Created an online project management application suite to manage cross-business projects.

• Designed and built custom application for call taking that increased productivity of the team by reducing the time to perform most actions by 90% or more. Reduced headcount from 225 to 8 over 20 months for the same.
• Automated report retrieval and import into different database systems.
• Designed Microsoft SQL Database driven application for working Service Order Inquires in a First In First Out architecture; thus lowering response time and increasing productivity though eliminating duplicate work.
• Created interface to Attachmate Mainframe Sessions leveraging Visual Basic and Microsoft Access.
• Designed and created the NPSC Web Site using dynamic Active Server Web Pages (ASP) driven by data in Microsoft SQL, Teradata, DB2, MySQL, DB2 and MS Access Database data sources.
• Designed and created searchable and customizable online reports using ASP for displaying historical and real time data from the aforementioned data sources.

• Recommended and designed custom windows, doors and trim-work based on customer needs.
• Resolved escalated customer issues and complaints.
• Verified external contractors installation work and repaired or reinstalled merchandise as required.
• Worked with vendors to resolve customer issues and pricing concerns.
• Designed and built product displays for new and existing products.
• Taught classes on propane and electric forklifts for material handling.