A
Aaron Colcord

Senior Director, Data Analytics Engineering at Northwestern Mutual

Milwaukee, WI

1

Office Hours

How does this work?
About

I am passionate about data and the latest data revolution. The technologies and the way we use them are exploding everyday and I am positioned as an experienced leader in developing these technologies successfully. A tactful, principled approach to technology is tent-pole. Specialties: Business Intelligence, Data Warehousing, Data Modeling, Data Life Cycle.

Ask me about
Privacera
Satori Cyber
Immuta
Customer
Okera
Satori
Work experience
logo

Sep 2020 - Present

Northwestern Mutual

Senior Director, Data Analytics Engineering

logo

Sep 2018 - Sep 2020

FIS

Sr. Director of Analytics, Ethos

Sep 2016 - Sep 2018

Director of Engineering, Data and Analytics

 Designed Highly Scalable, Real-Time, Cloud Based Data Warehouses that delivered high accuracy and detail. Played vital role in understanding the change dynamic of managing a Cloud based environment from a compliance and security aspect. • Built a Compliance-Acceptable Data Infrastructure on AWS that exceeded all known security requirements. • Incubated and refined an Agile methodology around Data Warehousing methods to bring out the earliest value in the project, highest quality while maintaining cost efficiency. • Collaborated, Cared, and Inspired my Colleagues both Junior and Senior to reach stretch goals. • Lead the Big Data vision to support Mobile Data Volume by implementing a comprehensive technical vision. • Implemented a Data Governance spirit to enable solutions around data variety problems. • Prepared Budgets, Resourcing Plans, Technology Presentations. Interfaced with the Business providing higher level understanding of deliverable while providing technical team members with actionable plans. • Worked with product teams to enable Product road maps with actionable next generation technology. • Built out a collaborative design process with the Mobile Application team to enable higher data integrity and quality. • Expanded the team to use blended labor across multi-geographic regions • Provided Industry Thought Leadership through membership of the Spark Advisory Technology Council and several industry presentations

Apr 2014 - Sep 2016

Data Warehouse Technical Lead

Jun 2013 - Jan 2014

Corvisa Services

Enterprise Data Warehouse Architect

- Provided Technical Leadership to the Application Development teams in helping improve software practices and reduce technical debt. Implement best practices from Continuous Integration to Continuous Improvement.

logo

Apr 2012 - Jun 2013

Direct Supply

Database Engineer III

- Acted as a Technical Leader for the Database Engineering group in helping set vision and technical direction for projects. - Provided input to Architectural Analysis and solutions to the Enterprise Team. Help develop vision and plans for the enterprise data architecture. - Started development of an Enterprise Data Model(EDM) and proper alignment of Master Data, Transactional and Analytical Data. Helped refine the business taxonomies and build alignment to Zachman framework. - Created a T-SQL Code Analysis Tool to automate review of code to conform to standards. - Wrote and implemented database conventions for the enterprise laying out the naming standards and architectural principles. Documented the logical standards and principles. - Act as the Primary Data Architect/Data Modeler for the DSSI Enterprise Team on an Agile Scrum Team. - Created an ETL Framework standard using SSIS to standardize and replace the heavy use of replication in Direct Supply. - Started development of an Enterprise Data Model(EDM) and proper alignment of Master Data, Transactional and Analytical. - Implemented Database Development using Agile techniques. - Optimize database performance via writing or reviewing stored procedurs, views, and other stored code. - Creation of documentation that details the flow of data and the ETL Designs. - Designed and implemented a roadmap to move transactional system to Data Warehouse pattern. - Influence and drive the direction of business intelligence development, platforms, versions, and toolsets.

logo

Apr 2011 - Apr 2012

APS Healthcare

Enterprise Data Warehouse Solutions Architect

-Design & oversee the architecture and development of the data warehouse, Enterprise ODS, BIDW, focused data marts, and ETL processes -Translate business requirements into technical specifications, adding technical detail and global structure to the design and specifications -Coordinate with data architects to maintain standards pursuant to data structures and models -Work with business leadership, QA analysts, project managers, and business analysts, to understand business data and ETL processes, and to ensure accuracy of the data warehouse - Design and apply best-of-breed, enterprise system, application and ESB solutions to meet business objectives on large-scale technology projects; evaluating impacts on integration, reliability, performance, scalability, flexibility and maintainability - Guided Developers both on-shore and off-shore in implementing ETL processes for the Enterprise Data Warehouse using Informatica for ETL. - Redesigned EDW reporting process to meet standard BI practices and optimize performance - Analyzed and implemented new data structures to correct existing problems with incorrectly linked data to correctly meet business requirements. - Made recommendations to data structures to optimize existing data processing speed. - Rewrote several T-SQL statements to meet business requirements and identify the requirements inside the code. - Managed the first use of BI analytics data for APS to deliver to a customer level through the patient health registry project. - Designed and documented the data flow (DFD) through the system and the BPMN models to visualize cross-system interaction. - Act as the Senior Technical lead in a project(s). - Applied Systems approach to providing technical project support on enterprise-scope projects. - Acted as consultant to the Database team in implementing new SQL 2008 features and designing data access layers.

logo

Feb 2009 - Apr 2011

IMS Health

App Database Administrator/Data Architect/Team Lead

- Worked extensively in Analysis, Design and Development of various applications using SQL Server and having Extensive knowledge of Relational Database Management Systems and Business Intelligence Database design. - Maintained over 300 databases on virtualized SQL Servers with virtualized File system. Typical DB size was 2TB – 4TB. - Designed and implemented different DB Logical & Physcial model designs using ERwin from EDW, MDM, and ODS to standard OLTP. - Developed and maintained the Database Standards documentation that detailed the naming standards and coding standards for SQL objects. - Developed and implemented a MetaData Management system to keep Data models synced with production copies - Designed, Architected, and implemented many BI solutions for our customers based on the Kimball Dimensional modeling. - Responsible for the SQL Server configuration, capacity reporting and monitoring across SQL Server versions 2005/2008/2008R2. - Derived the change management processes, deployment processes, for Schema changes. - Wrote and maintained many database scripts to include a fully automated Archive script that dynamically built out the archive commands based on metadata. - Wrote Erwin Macros to automate a majority of standard SQL code and design we adopted into the design. - Provided Expert Query tuning. Refactored T-SQL Code improving system performance and data quality. - Developed with SSIS and SSRS a system for reading out the SQL Server statistics and identify slow-running queries for optimization. - Assisted the SSIS ETL Developers in optimizing SSIS packages and resolving issues with design patterns. - Provided deep troubleshooting of issues to include identifying defects within the software. - Wrote, reviewed stored code such as Stored Procedures, Functions, and views in compliance with documented standards. - Worked with/and as a Data Architect(s) to improve data structures and understand the data needs of the infrastructure.

Sep 2002 - Feb 2009

Robert W Baird

Web/Database Administrator

-Worked extensively in Analysis, Design and Development of various applications using SQL Server and having Extensive knowledge of Relational Database Management Systems. -Administrated SQL Server Analysis Services. -Provided optimization techniques for the physical server implementation to complement the coding optimizations such as indexes. -Designed and Developed SSIS/DTS packages to integrate data from different systems to many disparate destinations. -Maintained over 96 SQL Server 2000/2005/2008 Installations with over 400 databases. Our largest database exceeding 2TB in size. -Extensive experience in installation and configuration & Maintenance of MS SQL Server 2008/2005/2000/7.0/6.5 versions. -Expertise in planning and implementing MS SQL server security and Database permissions. -Expert in Database Backup, Recovery and Disaster Recovery procedures. -Expertise in Performance Tuning, Query Optimization, and Database Consistency checks using DBCC Utilities. -Used different debugging methods such as a database trace(Profiler), Dynamic Management Views, and Extended events. -Implemented a system for capturing changes within the SQL Server so that metadata changes could be reported. -Installed and Configured multiple database instances across variety of configuration from clustered, single instance, to virtual instance. -Participated within a team to help developed Database Procedures that documented changes to the system. -Experience in setting up Failover technologies like Log Shipping, Database Mirroring, and SQL Server Clustering -Extensive experience in trouble shooting database issues ranging from slow performing code to Server issues affecting. -Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the company databases. -Defined and administered database standards, controls, procedures and documented the same.

2000 - 2002

Affinity Internet

System Administrator

-Hosted over 500,000 Domains with customers in over 100 different nations as the third largest provider of managed web and application hosting solutions. -Led the migration of NT4 to Windows 2000. Moved 42 NT 4.0 Servers to 8 Windows 2000 with Site-Based Active Directory Structure. Wrote custom VBScript scripts to ease migration. -Wrote Web Statistics package, backend scripts, and Web-Based Control panel for Winsave.com. -Designed Schemas, Stored Procedures, Triggers and Constraints for Winsave.com Database & DNS System. -Administrated & Monitored the Mission Critical SQL 2000 Server, which hosted the Prism Billing system, and the Database that controlled all central services such as DNS and email. -Helped design, support, and enhance a dynamic SQL Based DNS Server and Email System. -Wrote support utility tools based in Visual Basic 6.0(Win32 API based) or Windows Script Host. -Managed several projects from inception, design, and implementation such as Coldfusion Offering, Winsave.com launch, Active Directory Re-design, and Proactive Security Management.. -Maintained the Mission Critical Customer Relationship Management (CRM) System Egain Mail 3.0. -Administrated the Backend SQL7.0 Server for EgainMail 3.0. -Used Data Transformation Services (DTS) to migrate Oracle Based Database to MS SQL 2000. -Administered and Supported over 400 Customer Databases on Microsoft SQL Server 7.0 and MySQL to both external and internal customers. -Maintained 99.99% Uptime on IIS5.0 Servers with Compaq Proliant Servers. -Administrated the Server Farms with Citrix , Windows 2000 Terminal Services, and PcAnywhere. -Supported the team as the central contact for all Patch Management issues, Hardware Issues, Vendor relationships, and Security Issues.

logo

Jul 1997 - Jun 2001

United States Army Reserve

Personal Sergeant

logo

Jul 1993 - Jun 1997

US Army

Personal Sergeant

Education

2007 - 2011

University of Wisconsin-Milwaukee - School of Business Administration

MS, Management of Information Systems

1997 - 1999

BS, Information Systems Technologies, Computer Science

1995 - 1996

AS, General Studies

Talk to Aaron

@ Copyright 2020 OfficeHours Technologies Co.