Data Analyst Business Intelligence

THOMAS R WENZINGER

Littleton, CO ***** 720-***-**** ad5cx3@r.postjobfree.com www.linkedin.com/in/tomwenzinger

DATA ANALYST BUSINESS INTELLIGENCE ANALYST

Transforming Complex Datasets into Actionable Insights and Strategic Recommendations to Drive Business Growth and Efficiency.

Diligent and analytical professional with extensive experience in data analysis and business intelligence within the construction and building materials industry. In-depth understanding of data flow management from source to destination, maintaining accuracy, reliability, and accessibility of data. Skilled in developing and implementing advanced data marts, enhancing data utility for enterprise analytics tools and supply chain optimization. Knowledgeable in data and programming languages utilized for data extraction, manipulation, automation, and application of analytics to complex datasets. Proven ability to foster cross-functional collaboration and communicate complex data concepts to non-technical stakeholders to facilitate informed business decisions.

CORE PROFICIENCIES

Data Analysis & Visualization Analytical Analysis Data Modeling Data Mining & Cleansing Root Cause Analysis

Documentation & Reporting ETL Processes Problem-Solving Critical Thinking Process Improvement Project Management

Communication & Collaboration Attention-to-Detail Access Management Agile & Scrum Methodologies

PROFESSIONAL EXPERIENCE

Builders FirstSource (formerly ProBuild Holding, Inc.), Denver, CO 2010 to 2024

Data Analyst / Business Analytics Developer (2023 to 2024)

Served as lead for data incident investigations to pinpoint failures in the transmission of data from source to destination by utilizing advanced ETL & analytical tools and methodologies. Responded to internal audit data requests used to guarantee compliance with industry standards, organizational policies, and government regulations. Managed MicroStrategy user administrative tasks performed by contracted resources by establishing clear processes, documentation, communication channels, status reporting, and Service Level Agreements (SLA).

Oversaw Service-Now incidents from intake to resolution for user access changes, data & visualization defects, and enhancement requests by performing initial triage and analysis, Jira story creation and routing to resolution team(s), user acceptance testing, deployment process, resolution documentation, and incident close.

Developed and implemented tools to disable inactive users in MicroStrategy utilizing Power BI to query MicroStrategy’s Platform Analytics module, visualize results, and generate required Command Manger scripts.

Acted as key liaison to Change Approval Board (CAB) by presenting detailed analysis and impact assessments of proposed changes, ensuring seamless integration and minimal disruption to ongoing analytics operations.

Participated in MS SSRS to Active Batch conversion initiative by providing critical insights and testing support, enabling smooth transition, and driving uninterrupted data processing workflows.

Senior QA Data Engineer (2019 to 2023)

Identified and resolved data defects through proactive discovery and user-reported incidents while conducting thorough investigations and documenting findings, which facilitated swift and effective solutions. Led robust defect resolution processes to address data inconsistencies and errors by identifying root causes and proposing actionable solutions.

Championed data quality initiatives to boost accuracy and reliability of information from data source to data lake to data store to data mart by leading in-depth analysis and creating detailed documentation of data flows and business rules.

Fostered cross-functional collaboration by establishing clear communication channels and protocols between data acquisition, integration, analytics teams, and user groups.

Adressed incidents and requests related to data defects, data visualization issues, and enhancement requests from initial intake to resolution and closure, including all communications between user groups, data teams, and analytics team.

Senior Data Analyst (2018 to 2019)

Navigated data journey from ERP systems and various sources to data mart, enabling seamless integration and accessibility for analytics tools, analysts, auditors, and applications. Applied strategic ETL processes to enhance data utility and decision-making support. Instituted rigorous data control measures and introduced automated validations and checks at critical junctures to safeguard against process failures and data inaccuracies to reduce risk of data integrity issues. Performed defect analysis to pinpoint and rectify root causes of data discrepancies while facilitating effective communication and collaboration among resolution teams.

Advanced data acquisition process by collaborating with data acquisition team to refine extraction methods and frequency to ensure timely and accurate data availability in data lake.

Refined data transformation practices by collaborating with data integration team to apply precise business rules and calculations, ensuring that data store repository accurately reflects business operations and requirements.

Improved data loading mechanisms from data store to data mart where schema is optimized for analytical use, ensuring that data refreshes are both timely, accurate, and aligned with end-user Service Level Agreements (SLA).

Strengthened analytical foundation by validating data element values and implementing fail-safes to mitigate data flow interruptions, securing reliable data ecosystem that supports strategic business decisions and operational efficiency.

ProBuild Holding, Inc., Denver, CO 2010 to 2018

Senior Data Analyst (2013 to 2018)

Developed and launched specialized sub-data mart for Supply Chain division to tailor data structures and analytics specifically for commodities buyers, leading to more informed buying decisions and strategic purchases. Harmonized data integration and analytics processes by integrating new sub-data mart with enterprise-wide data strategies. Established advanced data validation and control protocols within Supply Chain sub-data mart to maximize data precision.

Facilitated interdepartmental cohesion by establishing clear communication framework between Supply Chain and Data Acquisition, Data Integration and Data Analytics teams.

Empowered business analysts and internal auditors with enriched data accessibility through sub-data mart, rendering deeper insights into supply chain operations and strategic purchases.

Supervised on-going enhancements of Supply Chain sub-data mart by gathering user feedback and analyzing usage patterns, increasing value and usability of data provided to commodities buyers.

Teamed with application developer to deploy custom business application leveraging new sub-data mart to provide Forest Products buyers with precise and actionable data, optimizing inventory management and strategic purchases.

ADDITIONAL EXPERIENCE

Senior Technical Business Analyst ProBuild Holding, Inc. (2010 to 2013)

Senior Business Intelligence Analyst Lafarge NA 1978 to 2010

Senior IT Business Analyst; Senior IT Systems Analyst Lafarge NA

IT Systems Analyst; IT Software Developer Lafarge NA (formerly Western Mobile Inc.)

IT Systems Analyst; IT Software Developer Lafarge NA (formerly Mobile Premix – Ready Mix and Aggregates)

EDUCATION & CREDENTIALS

M.S., Computer Information Systems, Regis University, Denver, CO

B.S., Electronic Engineering, University of Colorado at Denver, Denver, CO

TECHNICAL SKILLS

SQL (MS SQL Server, Oracle PL/SQL, IBM Informix, IBM DB2/400)

MicroStrategy (Data, Reports, Dossiers Support)

IBM Cognos (Metadata Architect, Report Development)

MS Power BI (Basics, Certification in Progress)

Contact this candidate