Dave Elderkin

Dave Elderkin Email and Phone Number

Director Software Engineering at Transformco @ Transformco
hoffman estates, illinois, united states
Dave Elderkin's Location
West Chicago, Illinois, United States, United States
Dave Elderkin's Contact Details

Dave Elderkin personal email

n/a

Dave Elderkin phone numbers

About Dave Elderkin

I am a professional manager of people, processes and systems with over 20 years of experience in making disparate entities operate in harmony. I believe that by talking to people that do a task day-in-day-out and validating with robust data management, any business can be vastly improved. I love using data driven insight to bridge the gap between where a business is and what it can become.Specialties: Associate Development, Software Development, Process Design, Process Implementation, Project Management, Training, DTS, FTP, Data Analysis, Telephony, T-SQL, Database Design, JavaScript, Visual Basic, VBScript, Outlook Scripting, Microsoft SQL Server, Teradata, Attachmate Session Manager, Microsoft Office, Web Programming, Mobile Programming, Cryptology, Information Security, Server Hardware & Software.I am proficient in all of the standard office, database, and programming software suites. Diversified skill sets covering people management, software design, development, training, executive communication, client relations, account management, project management, programming, reporting, and analytics.

Dave Elderkin's Current Company Details
Transformco

Transformco

View
Director Software Engineering at Transformco
hoffman estates, illinois, united states
Website:
transformco.com
Employees:
458
Dave Elderkin Work Experience Details
  • Transformco
    Director, Software Engineering
    Transformco Sep 2017 - Present
    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.
  • Sears
    Manager, Database
    Sears Jun 2014 - Sep 2017
    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.
  • Innovel Solutions
    System Integration Manager
    Innovel Solutions Feb 2010 - Jun 2014
    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.
  • Sears Holdings Corporation
    Business Integration Manager - Home Services
    Sears Holdings Corporation Jul 2006 - Feb 2010
    • 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.
  • Sears Holdings Corporation
    Process Analyst - National Parts Sourcing Center
    Sears Holdings Corporation Feb 2002 - Jul 2006
    • 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.
  • The Home Depot
    Millwork Deartment Lead
    The Home Depot Jan 1999 - Jan 2002
    • 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.

Dave Elderkin Skills

Analytics Access Project Management Process Improvement Database Design Data Analysis Management Microsoft Sql Server Training Customer Satisfaction P&l Management Inventory Management Visual Basic Multi Channel Retail Visio Javascript Teradata Microsoft Office Html Six Sigma E Commerce Web Development Operations Management Vbscript Css Retail Process Design Process Implementation Xml Dts Ftp Telephony Voip Microsoft Access T Sql Computer Hardware Attachmate Session Manager Web Programming Asp Xslt Cryptology 3rd Party Management Business Relationship Management Financial Reporting Executive Reporting Android Development Finance Strategic Development Business Planning Business Continuity Planning

Dave Elderkin Education Details

Frequently Asked Questions about Dave Elderkin

What company does Dave Elderkin work for?

Dave Elderkin works for Transformco

What is Dave Elderkin's role at the current company?

Dave Elderkin's current role is Director Software Engineering at Transformco.

What is Dave Elderkin's email address?

Dave Elderkin's email address is de****@****shc.com

What is Dave Elderkin's direct phone number?

Dave Elderkin's direct phone number is +184728*****

What schools did Dave Elderkin attend?

Dave Elderkin attended Illinois State University.

What skills is Dave Elderkin known for?

Dave Elderkin has skills like Analytics, Access, Project Management, Process Improvement, Database Design, Data Analysis, Management, Microsoft Sql Server, Training, Customer Satisfaction, P&l Management, Inventory Management.

Who are Dave Elderkin's colleagues?

Dave Elderkin's colleagues are S Vivekananda, Phyllis Thomas, Tamara Abesada, Nicholas Frey, Ken Swager, Novair Akhter, Zach Straebel, Cfa.

Not the Dave Elderkin you were looking for?

  • David Elderkin

    Plsql Software Developer At The Beacon Mutual Insurance Company Retired
    Plymouth County, Ma
    1
    beaconmutual.com
  • Dave Elderkin

    Wynnewood, Pa
    6
    smsmusic.org, gmail.com, gmail.com, philamuseum.org, philamuseum.org, cultureworksphila.org
  • David Elderkin

    Product Developer At Prism Universal Playing Cards.
    Wayland, Ny
  • Dave Elderkin

    Senior It Specialist At Ibm Global Services
    Bartlett, Il

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.