• TOC {:toc}

• Married, 2 daughters
• Interests: analytics, open source software, alternative operating systems, reading (action, thriller, personal development)
• Hobbies: playing baseball and basketball, hunting, fishing, live music, attending sporting events, sorting and organizing
• Places lived:
  • St. Cloud, WI
  • Eau Claire, WI
  • Minneapolis, MN
  • Eagan, MN
  • Rochester, MN
  • Prescott, WI
• Born: 1989

• Email: [email protected]
• LinkedIn: https://www.linkedin.com/in/klotzmichael/

• Dedicated data engineering professional with ten years' experience designing and maintaining data-driven solutions to complex business problems
• Creator of automated, test-driven processes using the right tools and intuitive architecture decisions
• Confident leader who brings exceptional interpersonal skills, a positive attitude, and the drive to advance business goals

| Employer| Travelers Insurance | | Job Function | Cloud Data Engineering, Technical Lead | | Unit | Data Foundations, Data Lakers | | Location | St. Paul, MN | | Dates | Sep 2020 – Present |

• Migrated data pipelines from on-premises Hadoop to AWS Cloud
• Rewrote and refactored workflows using AWS Step Function, Lambda, and Elastic Map Reduce (EMR)
• Built and supported Databricks data pipelines
• Built terraform IAC modules and shared components
• Architected custom job orchestration framework to checkpoint and restart workflows efficiently
• Configured and maintained AWS IAM roles and policies
• Created data models and corresponding parsing scripts to translate raw data into SQL and parquet formats
• Built database schemas and processes to transfer data between AWS Glue and Snowflake
• Built production support dashboards in DataDog, MongoDB Atlas, and Kibana
• Led agile team by conducting meetings (standup, refinement), creating documentation, and training new team members

| Employer| Mayo Clinic | | Job Function | Enterprise Data Warehousing & Database Administration | | Unit | Operational Data Services, Unified Data Platform | | Location| Rochester, MN | | Dates | Nov 2016 – Sep 2020 |

• Built, administered, and developed custom solutions for multi-terabyte Administrative Data Warehouse using the Microsoft BI/DW stack
• Led project to implement standardization and best practices in 200+ data integration processes across multiple ETL tools (Microsoft SSIS, IBM DataStage, and SAP Business Objects)
• Established test-driven development practices in the data warehouse via dynamic BIML, PowerShell, and T-SQL solutions to ensure consistency and accuracy
• Worked with colleagues from Data Modeling, Enterprise Analytics, HR, and Finance departments to satisfy new requirements during EMR conversion project (Epic)
• Provided SSIS packages and Analysis Services processes for heavily custom OLAP solutions
• Performed server maintenance, backup and restore services, and disaster recovery activities
• Audited database permissions and tuned performance of databases across environments
• Created team knowledgebase and contributed documentation for on-call support and development
• Developed ETL using SAP Business Objects
• Built and installed SQL Server database instances for data warehouse
• Audited database permissions and curated optimal database settings across environments

| Employer| Mayo Clinic | | Job Function | Business Intelligence | | Unit | Global Business Solutions| | Location| Rochester, MN | | Dates | Nov 2014 – Nov 2016 |

• Provided end-to-end solutions from data discovery to logical data mapping to dimensional modeling and data visualization
• Developed custom data extraction scripts to pull data from non-traditional data sources (web services, SharePoint, Active Directory)
• Built customer-facing "Ask Mayo Clinic" dashboards and reports using PowerBI
• Transformed source data into DataMart structure (Fact/Dimension) for simplified reporting
• Consumed data from a variety of sources (Oracle, Active Directory, SQL Server, SharePoint)
• Performed in-depth database index analysis and adjusted indexes for better performance
• Wrote dynamic, parameterized T-SQL MERGE procedure and other dynamic procedures to reduce code redundancy
• Worked with DataMart stakeholders to ensure reports met requirements
• Implemented delta/incremental load using Change Data Capture (CDC) and Change Tracking
• Developed advanced PowerShell scripts for stored procedure unit testing
• Improved logging and auditing of SQL Agent jobs
• Created and managed stories, tasks, and estimates for agile project based on end user requirements
• Supported data warehouse by writing documentation and participating in 24x7 on-call rotation
• Improved logging and auditing of automated processes and SQL Agent jobs

| Employer| City of Rochester, MN | | Location| Rochester, MN | | Dates | May 2014 – Nov 2014 |

• Reverse-engineered flat files into a nightly-updating relational database to house property information
• Wrote C# application to parse, encrypt, and email pay stubs
• Vetted and advised selection of 3rd party document management and asset management systems
• Designed a data warehouse (Microsoft SQL Server & SSIS) for collection property info
• Supported JD Edwards Entreprise Resource Planning (ERP) software

| Employer| Thomson Reuters | | Location| Eagan, MN | | Dates | June 2012- May 2014 |

• Built data-access layer for enterprise "Artifiact Service" platform
• Developed and unit tested features and web services for multi-tiered J2EE applications
• Executed transition, redesign, and delivery of a Java-based Hierarchy Management application based on Resource Description Framework (RDF)
• Created and managed tasks and estimates for user stories and defects during two-week iterations using agile project management software (Version One)
• Delivered tech-talks on implementing Git, MongoDB, Gradle, and Sonar
• Led migration efforts from TFS version control to Git
• Design and deliver new functionality that adheres to platform and architectural guidelines
• Participate in planning sessions and provide estimates for stories and tasks
• Work with business users to define acceptance criteria
• Communicate timely and accurate status information to project leaders

| Employer| Menard, Inc. | | Location| Eau Claire, WI | | Dates | May 2011 - May 2012 |

• Worked closely with DBA team to maintain and support several database platforms including SQL Server (MSSQL), MySQL, Oracle, and Progress (OpenEdge RDBMS)
• Created ETL processes using SQL Server’s Integration Services (SSIS) and PowerShell to gather database usage and performance metrics from 6 different database platforms
• Created dynamic SQL Server Reporting Services (SSRS) reports to display metrics
• Designed a MySQL database and wrote an application for the centralized logging and reporting of database tasks
• Used SQL Server’s Integration Services to run ETL processes that update a Central Reporting Server between 6 different database platforms
• Wrote SSRS reports and integrated them into PHP database logging application
• Used ER-Win to model changes and additions to database structure
• Wrote PowerShell scripts to connect to MySQL, SQL Server, and Oracle databases
• Wrote scripts and queries to gather relevant data from system tables
• Designed website to interface the central database using HTML, CSS, JavaScript, and PHP

| Employer| Citizens Community Federal | | Location| Altoona, WI | | Dates | Sept 2010 - May 2011 |

• Sustained and organized company-wide user maintenance requests in over 20 pieces of software (including Active Directory and security rights for all programs)
• Worked with software suppliers to troubleshoot configuration and core processing issues
• Created documentation and reference material for computer operating procedures and software maintenance routines for AS/400 mainframe
• Managing security and access for over 200 users in over 15 pieces of software
• Worked with Fiserv representatives to fix errors in daily processing procedures
• Scheduled colleagues for nightly computer operators
• Performed, organized, and maintained daily data backups
• Reformatted old computers with fresh disk images (using Acronis True Image)
• Ran daily core processing tasks on AS/400 mainframe
• Wrote documentation for user intake and departure processes
• Set up, maintained, and organized company's internal information on SharePoint site
• Applied updates and maintenance patches to data servers
• Provided on-call support to bankers and tellers in 26 bank branches
• Participated in 24x7 pager rotation to assist computer operators

| Employer| Citizens Community Federal | | Location| Altoona, WI | | Dates | Nov 2009 - Sept 2010 |

• Learned to run an AS/400 program with minimum prior experience
• Utilized Microsoft Server 2007 to operate server tasks
• Learned tech support to help people with computer problems over the phone
• Helped tellers solve computer-related problems remotely using Symantec PC Anywhere as an aid
• Gained financial knowledge and skills in crunching numbers
• Learned how to troubleshoot by contacting the software supplier (ITI) and following their instructions to solve problems on our end of the system

| Institution | University of Wisconsin - Eau Claire | | Degree | Master of Science in Data Science (MS) | | Dates | Jan 2017 – May 2022 | | Area Focus | Data Science | | GPA | 4.0 |

Summary

• Ran data projects with Hortonworks Docker Sandbox (HDP) on Azure Cloud
• Engineered data projects using Amazon Web Services using EC2, S3, and Ubuntu
• Created MapReduce solutions in Java and Python
• Developed data pipeline solutions using Pig, Hive, Zeppelin, and Spark
• Implemented common machine learning and optimization models
• Built recommender systems in Python

Links

• UWEX Data Science Official Site
• UWEX Data Science Courses
• Data-Driven Solutions for Single-Stream Recyling Optimization Case Study (Capstone Paper)

| Institution | University of Wisconsin - Eau Claire | | Degree | Bachelor of Business Administration (BA) | | Dates | Aug 2007 – May 2012 | | | Major | Information Systems (Comprehensive) | | Emphasis | Systems Development | | Minor| Web Development | | GPA | 3.73 |

Summary

• Programmed detailed applications in Java Runtime Environment as a former computer science major
• Used commands to manipulate information from Oracle databases
• Designed and reconstructed databases
• Learned about various applications of information technology as a member of the Association of Information Technology Professionals
• Experienced in writing agendas and meeting minutes
• Learned to diffuse arguments and help co-workers at Peer Helper Workshop

Links

• UWEC Information Systems Home
• UWEC Information Systems Comprehensive Major Detail

• Microsoft Certified Solutions Expert: Data Management and Analytics | 2017
  • Demonstrated broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data – both on-premises and in cloud environments.

• Minnesota High Tech Association ACE Leadership Program | 2020
  • ACE leaders are paired with a mentor, a senior leader in technology, to help guide their leadership journey throughout the 8 month course.
  • Coursework focuses on recognizing one’s leadership style, driving innovation, building a strong leadership brand, public speaking, negotiation, developing tech talent, inclusion in tech, and more.
  • Leaders work on small group strategy based project (supporting local non-profits through their work), which culminates with a presentation to MnTech’s Board of Directors.
• Intertech Complete Spring 3.0 Framework | 2012
  • "Learn to build enterprise applications that are scalable, mobile, secure and robust in a Spring Framework. Our Spring Framework training empowers software developers to solve concrete business problems by mapping application-level issues to Spring-centric solutions. Find continued training description below our Course Finder lower on this page."

• 3M Foundation Information Systems Scholarship | 2011
• Travelers Scholarship Information Systems Scholarship | 2011

• Outstanding Senior Award | 2011
• Who's Who Among Students in American Universities and Colleges | 2011

• **Technical Competencies are listed with the year I last used them in my day-to-day work...