Professional Profile
Technology engineer with 25 years of experience spanning software development, database administration, system architecture, production support, and cloud modernization across Mainframe, Linux, and AWS (Amazon Web Services).
Led initiatives across application design, team leadership, and large-scale data migration. I focus on aligning technical decisions with business outcomes, keeping mission-critical systems reliable, and helping engineers grow.
State Farm
Senior Technology Engineer
Bloomington, Illinois, United States
2024 - Present
- Served as a core team member on enterprise claim system modernization, advising across interdisciplinary work streams spanning application development, data architecture, infrastructure, and leadership.
- Co-led data modernization initiatives for the largest Property and Casualty (P&C) claim system in the world, determining data strategy for our migration while reducing risk and aligning updates to our core systems with business outcomes.
- Worked with teams across the production claim system to improve high availability, performance, and operational readiness.
- Pushed for consistent software engineering and data management practices across multiple teams, focusing on design quality and operational discipline.
- Evaluated new products and drove proof-of-concepts, helping reduce risk in technical choices.
- Resolved major production outages by coordinating rapid, multi-team troubleshooting efforts, minimizing downtime.
- Explained technical tradeoffs and project progress to senior leadership so they could make informed decisions.
- Mentored junior engineers and helped build a team culture where people learned from each other.
Prior Experience
State Farm
Lead Data Engineer
2022 - 2024
Core Team Member on Enterprise Systems Modernization Efforts
- Automated Db2 to Postgres migration: Developed a Python program to convert the DDL for 24,000 Db2 tables to Postgres. Collaborated with enterprise data enablement teams to evaluate vendor tools for schema migration.
- Migrated billions of rows with zero downtime: Replicated legacy data from z/OS Db2 to Aurora Postgres using Qlik Replicate, giving the team an early environment to experiment with Aurora Postgres.
- Streamlined deployment with automation: Implemented GitLab CI pipelines and Flyway to automate DDL deployment for Aurora Postgres, boosting efficiency and consistency.
- Served as a key resource for diagnosing complex production issues spanning application, data, and infrastructure boundaries.
- Mentored other engineers and led technical discussions across the team.
- Presented at area, guild, and cloud summit meetings to share knowledge and best practices.
Data Analyst - Database Administrator
2016 - 2022
Db2 and Postgres Database Administrator specializing in automation, performance tuning, and data migration
- Worked closely with application developers and Db2 performance teams to implement database changes, tune query performance, and resolve performance issues.
- Managed a complex data landscape: the Db2 production environment had over 24,000 tables across 30 Db2 subsystems, including High Availability Parallel Sysplex Db2 Data Sharing Groups.
- Developed and executed data migration jobs during a hardware sunset project, successfully reducing the production hardware footprint for High Availability Sysplex systems by 33% for claims data.
- Postgres support: Assisted team members with database changes and debugging application issues in test and production environments.
Software Developer
2010 - 2016
Team Lead for Enterprise Claim System (ECS) Print/Fax Application | Server Type Owner for ECS File Share Server
- Supported a J2EE application that managed the printing, bundling, and delivery of prints and faxes for the world’s largest P&C claim system.
- Developed a software solution to streamline the claims file delivery process for the legal department, improving efficiency and accuracy.
- Worked on an enterprise print consolidation effort that enabled the use of enterprise printers by the ECS application to increase security and cost efficiency.
Enterprise Claim System (ECS) Program
- Led efforts to bring over 200 data flows to rest before conversion by driving discussions across multiple application teams to create a system-wide plan.
- Contributed to the ECS Data Conversion Project by writing data extract jobs, identifying data quality issues, and proactively cleaning up data quality issues before migration.
- Enhanced the legacy Claim Service Record (CSR) architecture to allow a read-only mode for safe access to pre-conversion data without training.
System Analyst
2000 - 2010
Architecture Design Team
- Served on the architecture design team for nearly a decade, functioning as architect and consultant for requirements, design, and code reviews across all CSR projects from 2004 onward.
Team Lead for Claims Service Record (CSR)
- Led and owned maintenance of critical CSR applications across transaction management, architecture, security, data movement, organizational data, and automation tools.
- Streamlined system audits, security reviews, and performance troubleshooting as a central point of contact.
- Championed architecture, design, and code reviews to ensure high quality and consistency across the CSR application suite.
- Provided quality control and oversight as a State Farm contact and team lead for external associates in a support structure with only 10 State Farm internal employees for legacy CSR.
CSR Project Highlights
- Core team member on the HP CSR port project to re-platform to HP-UX.
- Worked on HP server clustering effort to reduce server footprint by 40%.
- Contributed to the expansion of catastrophe services capacity by building a second centralized cluster.
Internal Tooling
- Developed and implemented a JDBC-based distributed query tool, enabling ad-hoc reports on 300 nightly backup databases with no production impact while allowing reports for business to run during the day.
- Enhanced distributed command-line utilities for parallel execution and variable substitution across 300+ servers by server type, boosting operational efficiency.
Education
The American College, Bryn Mawr, Pennsylvania
2010
- Chartered Financial Consultant (ChFC)
Indiana State University, Terre Haute, Indiana
2000
- B.S. Management Information Systems, minor Computer Science
- Graduated Magna Cum Laude