Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pete Hoffman

Toledo,OH

Summary

Seasoned database and software engineer with over 20 years of experience specializing in business intelligence, data integration, and ETL solutions across various sectors including healthcare, construction, real estate, retail, and manufacturing. Proficient in Microsoft data technologies such as SQL Server, Azure Data Factory, SSIS, and Power BI. Consistently delivers actionable insights from fragmented data for executive and operational decision-making. Skilled in performance tuning, dashboard design, and troubleshooting underperforming systems with a focus on user experience and visual clarity. Self-directed consultant excelling in fast-paced environments. Known for establishing long-term client trust through transparency, precision, and reliable delivery.

Overview

26
26
years of professional experience

Work History

Data Warehouse Architect

Zepf Center
01.2021 - Current
  • Designed and implemented a full-scale Data Warehouse and Data Mart system
  • Rolled out SSRS infrastructure and custom ETL pipelines
  • Maintained system uptime, performance tuning, and vendor data exchange

Database Administrator

myCOI
01.2021 - 01.2022
  • Optimized SQL Server infrastructure across multiple databases
  • Implemented indexing strategies and health monitoring systems

Senior Systems Engineer

Mobis of North America
01.2021 - 12.2021
  • Maintained internal DB performance and reliability
  • Delivered manufacturing system enhancements

Integrations Developer

ProviderTech
01.2019 - 01.2021
  • Led Azure Data Factory pipelines and SQL schema design
  • Built monitoring tools for mission-critical ETL processes

Business Intelligence Developer

UIS Inc.
01.2019 - 01.2021
  • Standardized 200+ SSRS reports
  • Performance-tuned SQL queries for analytics

Senior Development Consultant

Aktion Associates Inc.
01.2016 - 01.2021
  • Led software and database projects for real estate, manufacturing, and construction clients
  • Built ERP-integrated forecasting and inventory tools (ASP.NET MVC, C#, Dapper)
  • Mentored junior devs and implemented team-wide coding/VCS standards

Senior DBA/BI Consultant

Warnock, Tanner & Associates
01.2015 - 01.2016
  • Designed custom BI and database solutions for healthcare, retail, and energy clients
  • Built script automation systems for SQL performance diagnostics

Systems Development Manager

Kellermeyer Bergensons Services
01.2008 - 12.2015
  • Directed dev team building web/mobile apps and backend systems
  • Oversaw database environments across SQL Server, Oracle, and Progress

IT Specialist

FOCUS Inc.
01.2006 - 01.2008
  • Migrated Excel-based processes to MySQL
  • Created user-friendly data entry solutions and trained staff

Weapons & Logistics Specialist

Ohio Army National Guard
01.1999 - 12.2007
  • Deployed in support of OIF and OEF missions
  • Responsible for secure logistics and armory oversight

Education

Associate of Technical Study - Web Design & Business Administration

University of Toledo
Toledo, OH
01.2008

Skills

  • T/PL-SQL
  • MDX
  • DAX
  • Python
  • SQL Server
  • MySQL
  • Oracle
  • SSRS
  • SSAS
  • SSIS
  • Power BI
  • Azure Data Factory
  • Custom ETL Solutions
  • Visual Studio
  • SSMS
  • Azure
  • ETL development
  • Master data management
  • Requirements analysis
  • Data quality management
  • Business intelligence
  • Data warehousing
  • Data modeling

Timeline

Data Warehouse Architect

Zepf Center
01.2021 - Current

Database Administrator

myCOI
01.2021 - 01.2022

Senior Systems Engineer

Mobis of North America
01.2021 - 12.2021

Integrations Developer

ProviderTech
01.2019 - 01.2021

Business Intelligence Developer

UIS Inc.
01.2019 - 01.2021

Senior Development Consultant

Aktion Associates Inc.
01.2016 - 01.2021

Senior DBA/BI Consultant

Warnock, Tanner & Associates
01.2015 - 01.2016

Systems Development Manager

Kellermeyer Bergensons Services
01.2008 - 12.2015

IT Specialist

FOCUS Inc.
01.2006 - 01.2008

Weapons & Logistics Specialist

Ohio Army National Guard
01.1999 - 12.2007

Associate of Technical Study - Web Design & Business Administration

University of Toledo

Similar Profiles

CREATE PROFILE
Pete Hoffman