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 to consume.• 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 tracks metadata, full data lineage, data mapping, code versioning, and provides training. • 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.• Supported 350 legacy applications and Mainframes including almost all RDBMS's and non-relational DBMS's tech stacks.• Managed an offshore team of software engineers, DBAs and application support staff.

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.• Created single version of truth for home services reporting processes, primarily focused on customer data and PII.• Created metadata and data governance processes for Home Services for visibility company-wide.• Managed a team of onshore and offshore DBAs & Architects for application development and support.

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 provider across platforms.• 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 level tracking and sales of permits along with adherence to local permitting codes.• 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 providers to have order visibility 11 minutes after sale. Also managed the ongoing relationship with the 3rd party vendors.• 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.• Created a mobile solution to survey customers and capture completion signatures in their home after a delivery event to provide national visibility to that event. Outlier responses captured and forwarded to a recovery team in less than a minute.• Managed Microsoft SQL database, Web, and other application servers. Managed several data migrations across platforms.• Directly managed a team of Process Analysts and System Support associates.

• 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 workload.• 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.• Designed and created online applications for project management for the Process Development Team.• Designed and built online tracking system for requests from internal and external management members.• Worked on Tech Manager Workbench Team that built an online workbench for Tech Managers. This workbench includes applications for checking inventory at local vendors, reporting in near real time on Technician activities, and applications for interfacing with the IBM mainframe databases.

• 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.• Increased retail sales 36% from June 2001 to June 2002.• Oversaw 1 million in inventory with $80,000 in sales weekly.• Oversaw 6 full time and 4 part time associates.