Chad is currently unavailable
Chad Klopfenstein
Verified Expert in Engineering
Microsoft Azure Developer
Wheaton, IL, United States
Toptal member since November 15, 2021
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 (ADF)...
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 (ADF) - 1 year
Preferred Environment
Microsoft Azure, SQL, Azure Synapse, Microsoft Power BI, DAX, C#, SQL Server BI, SSAS Tabular, Azure Data Factory (ADF), 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 (ADF), 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 (ADF), 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.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
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