Chad is available for hire

Chad Klopfenstein

Verified Expert in Engineering

Microsoft Azure Developer

Wheaton, IL, United States

Toptal member since November 15, 2021

Expertise

Data Engineering Data Science Data Visualization DAX SQL SQL Server ETL Database Business Intelligence Development

Bio

Chad has over 25 years of IT experience in diverse multinational business environments with extensive exposure to cross-cultural practices and international business protocols. His full-stack technical expertise primarily focuses on Microsoft tools and technologies, including the latest on-prem and Azure approaches to software and database development. Chad specializes in business-driven BI architecture and implementation.

Portfolio

BrightStar Care

Microsoft Power BI, Azure SQL Databases, ADF...

ZOLL Medical Corporation

Azure, Azure Synapse, Business Intelligence (BI), DAX, Azure Data Factory, SQL...

Randstad USA

Microsoft Azure, Microsoft Power BI, DAX, SQL, Business Intelligence (BI)...

Experience

SQL - 20 years
SQL Server Integration Services (SSIS) - 16 years
SQL Server Analysis Services (SSAS) - 15 years
Microsoft Azure - 10 years
Microsoft Power BI - 5 years
DAX - 5 years
Azure Synapse - 2 years
Azure Data Factory - 1 year

Availability

Part-time

Preferred Environment

Microsoft Azure, SQL, Azure Synapse, Microsoft Power BI, DAX, C#, SQL Server BI, SSAS Tabular, Azure Data Factory, SQL Server Integration Services (SSIS), Data Engineering, Data Architecture

The most amazing...

...thing I've written while working on a 4-person team is an FX risk analysis platform that is still in use at a major investment bank 18 years later.

Work Experience

Director of Business Intelligence

2022 - PRESENT

BrightStar Care

Created a three-year strategic plan for the digital transformation of all reporting, business intelligence, data analysis, and data quality for the entire organization of 350+ franchises.
Architected an Azure-based modern BI platform to replace the aging legacy system.
Redesigned end-to-end data collection, management, analysis, and reporting processes across the enterprise.
Led a team of 10 engineers and project managers maintaining the legacy system while migrating hundreds of reporting, data analysis, and data processing artifacts to a modern platform.
Established and managed annual departmental budget.

Technologies: Microsoft Power BI, Azure SQL Databases, ADF, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SSAS Tabular, Jira, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Excel 365, Dashboards, Data Pipelines, Data Analytics, Data Visualization

Business Intelligence Enterprise Architect

2022 - 2022

ZOLL Medical Corporation

Worked as a BI solution architect for Azure/Power BI-based enterprise-wide data management solution.
Delivered an enterprise design for data management, detail reporting, analysis and forecasting, and governance.
Addressed data access, duplication, and inaccuracy issues that users across all company levels commonly encountered.
Coded example end-to-end system with templates to follow for existing Zoll staff to mimic for the full implementation.

Technologies: Azure, Azure Synapse, Business Intelligence (BI), DAX, Azure Data Factory, SQL, SQL Stored Procedures, Microsoft Power BI, Architecture, Data Analysis, Synapse, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Excel 365, Dashboards, Data Pipelines, Data Analytics, Data Visualization

Senior BI Architect

2019 - 2021

Randstad USA

Modernized the internal BI reporting by owning all system architecture, design aspects, and coding all SQL, tabular model, DAX, and Power BI reporting assets.
Architected and developed the major client BI applications from project onset by owning all aspects of system data flow, technology, tools to be employed, and reporting strategies.
Designed and implemented the enterprise data warehouse and tabular model to support responsive reporting across approximately five billion transactions dimensionalized across hundreds of thousands of attribute members.

Technologies: Microsoft Azure, Microsoft Power BI, DAX, SQL, Business Intelligence (BI), Microsoft SQL Server, Microsoft Data Transformation Services (now SSIS), ETL, Architecture, Data Analysis, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Synapse, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Excel 365, Dashboards, Data Pipelines, Data Analytics, Data Visualization, Snowflake

BI Architect

2018 - 2019

CDW

Led the technical team on a high-visibility BI project that presented key profitability metrics to the senior management.
Inherited a multi-million-dollar project at high risk of failure and led it to successful deployment and adoption.
Collaborated closely with the C-suite-level business partners to drive, gather, and refine requirements.

Technologies: SQL Server 2016, SQL Server Analysis Services (SSAS), MDX, SSIS Custom Components, SQL Server Integration Services (SSIS), SQL, Business Intelligence (BI), Microsoft SQL Server, Microsoft Data Transformation Services (now SSIS), ETL, Architecture, Data Analysis, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Excel 365, Dashboards, Data Pipelines, Data Analytics, Data Visualization

BI Consultant

2015 - 2018

Ventas

Architected and developed a large-scale OLAP system that spanned business areas ranging from the leasing data over the foreign exchange normalization to the GL analysis.
Documented BI industry best practices and provided in-house education and guidance regarding the architecture, implementation, and requirements scoping.
Designed and configured a fully customizable and extensible framework that allowed MDX-based cubes to share vital data that went well beyond what the SSAS platform supports.

Technologies: SQL, SSAS, MDX, Business Intelligence (BI), Microsoft SQL Server, Microsoft Data Transformation Services (now SSIS), ETL, Data Analysis, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Excel 365, Dashboards, Data Pipelines, Data Analytics, Data Visualization

BI Architect

2013 - 2015

Fermilab

Architected a large-scale, lab-wide BI system mandated by the US Department of Energy that reported experiment progress and adherence to government standards to the auditors and Department of Energy personnel.
Integrated dozens of existing and disparate data sources, reports, and business processes into a coherent structure.
Chaired meetings with Fermilab's employees, including the CIO, CFO, COO, business users, and particle physicists.

Technologies: SQL Server 2016, SSAS, SQL Server Integration Services (SSIS), SSIS Custom Components, SQL Server Reporting Services (SSRS), MDX, SQL, Business Intelligence (BI), Microsoft SQL Server, Microsoft Data Transformation Services (now SSIS), ETL, Architecture, Data Analysis, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Excel 365, Dashboards, Data Pipelines, Data Analytics, Data Visualization

Principle Consultant

2008 - 2013

SWC Technology Partners

Acted as the lead consultant and team coordinator, managing multiple simultaneous projects with cross-functional teams specializing in business intelligence and cloud computing.
Provided extensive business analysis and project management consultancy for large-scale, multi-year contracts.
Designed and developed the go-to-market campaigns for predictive analytics and cloud computing.
Presented the technology seminars for large groups of prospective customers.

Technologies: SQL Server BI, SSAS, MDX, C#, SQL Server Integration Services (SSIS), SSIS Custom Components, SharePoint, SQL, Microsoft SQL Server, ETL, Architecture, Data Analysis, Data Management, Data Engineering, Data Architecture, Data Structures, Data Integration, Dashboards, Data Pipelines, Data Analytics, Data Visualization

Senior Software Analyst

2006 - 2008

Bank of America

Led teams of up to six professionals in coding and designing a full array of business analysis and software design tools related to the loan derivatives.
Created and implemented many repeatable processes to streamline development functions and improve quality. Oversaw coding through Java, .NET, SQL Server, and Sybase in a timely and accurate manner.
Developed the processes and applications to support a total return swap activity with the foreign exchange derivatives.
Contributed to the training and orienting of new staff in all operating policies and procedures.

Technologies: Java, C#, SQL Server Integration Services (SSIS), IIS SQL Server, SQL, ETL, Data Analysis, Data Engineering, Data Architecture, Data Pipelines, Data Analytics

Software Engineer

1998 - 2006

UBS

Architected and developed the client-side applications for the real-time foreign exchange cash and derivatives portfolio valuation systems.
Spearheaded personally the launch of almost 100 successful production releases of five different applications.
Served as the global technical product owner for Borland Java products; identified and tracked all project requirements and feedbacks with the Borland development teams.

Technologies: Java, Delphi, C++, CORBA, DCOM, SunOS, Linux, SQL, Data Analysis, Data Engineering, Data Architecture, Data Analytics

Software Analyst

1997 - 1998

First Chicago NBD Corporation

Developed a cash management reporting system in Delphi to support the external corporate clients allowing them to view and track complex financial documentation.
Interfaced and liaised with the top financial and IT executives at the Sara Lee Corporation; gathered and evaluated the project requirements while creating unique system solutions.
Increased client retention by hosting well-received design review sessions with the clients.

Technologies: Delphi, SQL, Data Engineering, Data Architecture

Computer Operations Supervisor

1992 - 1997

Wheaton College

Oversaw all aspects of network administration, systems analysis, and software implementation as the sole technician for the Library and Media Resources Department.
Created and operated the first electronic research lab in the history of the institution.
Assisted in large-scale migration from the paper-based card catalog system to the modern computer catalog.

Technologies: Delphi, Visual Basic, SQL

Experience

Federal Pharmaceuticals Pricing Analysis Platform

This pricing analysis platform is an Azure-based platform that ingests data from multiple internal and external sources and processes billions of transactional data rows. It also presents third-party clients such as hospitals and pharmacies with the Power BI reports that combine data and logic previously not available in the industry.

Skills

Tools

Microsoft Power BI, SQL Server BI, SSAS, Synapse, Power Query, SunOS, Jira

Languages

SQL, MDX, C#, Java, Delphi, C++, Visual Basic, Snowflake

Paradigms

Business Intelligence (BI), ETL

Platforms

Azure Synapse, Azure, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), SharePoint, Linux

Storage

SQL Server 2016, SSAS Tabular, SQL Server Analysis Services (SSAS), Microsoft SQL Server, Data Integration, Data Pipelines, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), IIS SQL Server, SQL Stored Procedures, Azure SQL Databases

Frameworks

ADF

Other

Microsoft Azure, DAX, Microsoft Data Transformation Services (now SSIS), Architecture, Data Management, Data Engineering, Data Architecture, Data Structures, Excel 365, Dashboards, Data Analytics, Data Visualization, SSIS Custom Components, Azure Data Factory, Data Analysis, CORBA, DCOM

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring