Chad Klopfenstein, Microsoft Azure Developer in Wheaton, IL, United States
Chad Klopfenstein

Microsoft Azure Developer in Wheaton, IL, United States

Member since November 12, 2021
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.
Chad is now available for hire

Portfolio

  • ZOLL Medical Corporation
    Azure, Azure Synapse, Business Intelligence (BI), DAX, Azure Data Factory...
  • Randstad USA
    Microsoft Azure, Microsoft Power BI, DAX, SQL, Business Intelligence (BI)...
  • CDW
    SQL Server 2016, SQL Server Analysis Services (SSAS), MDX...

Experience

Location

Wheaton, IL, United States

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)

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.

Employment

  • Business Intelligence Enterprise Architect

    2022 - PRESENT
    ZOLL Medical Corporation
    • 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 issues of data access, duplication, and inaccuracy that were commonly encountered by users across all levels of the company.
    • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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, EFT, SQL
  • 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

  • Languages

    SQL, MDX, C#, Java, Delphi, C++, Visual Basic
  • Tools

    Microsoft Power BI, SQL Server BI, SSAS, Power Query, SunOS
  • Paradigms

    Business Intelligence (BI), ETL
  • Storage

    SQL Server 2016, SSAS Tabular, SQL Server Analysis Services (SSAS), Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), IIS SQL Server, SQL Stored Procedures
  • Other

    Microsoft Azure, Azure Synapse, DAX, Microsoft Data Transformation Services (now SSIS), Architecture, SSIS Custom Components, Azure Data Factory, Data Analysis, CORBA, DCOM, EFT
  • Platforms

    Azure, SharePoint, Linux

To view more profiles

Join Toptal
Share it with others