Blake Holsclaw - Data Analyst - Indiana University Health

Summary

Data Analyst with 4+ years delivering end-to-end data integration, automation, and analytics solutions. Skilled in Microsoft Fabric, Power Platform, and SQL, with strong experience in building scalable data pipelines and dashboards. Proven ability to collaborate cross-functionally to solve complex problems and optimize operational workflows. Eager to apply technical expertise and problem-solving skills to develop transformative AI solutions and intelligent agents on platforms like Salesforce and Agentforce.

Overview

5

years of professional experience

Work History

Intermediate IS Data Analyst

Indiana University Health

11.2021 - Current

Developed 80+ SSIS-based ETL pipelines integrating data across Oracle, GHX, and PIM systems; embedded full error handling, validation, and audit trails to support risk visibility.
Engineered proactive data-monitoring pipelines (e.g. Wavemark SFTP), reducing incident detection time by 60%.
Created semantic Power BI models enabling analysis of over 1,100 preference cards, enabling supply chain optimization opportunities.
Automated high-risk manual workflows using Python and Power Automate, improving data quality and reducing latency in business reporting.
Built and maintained critical dashboards for vendor performance, item conversions, and contract expiration risk.
Created audit-ready dashboards with embedded validation logic, increasing data trust and accelerating approvals.
Partnered with compliance, supply chain, and business systems teams to prioritize data issues and deliver high-value insights.
Implemented SQL triggers for automated auditing; supported HIPAA-compliant recordkeeping.
Supported privileged access security via Active Directory and CyberArk integration for sensitive data environments.
Helped build cloud data models and infrastructure in Microsoft Azure for future-ready risk intelligence development.
Indianapolis

Education

Assoc - Cyber Security & Information Assurance

Ivy Tech Community College

Indianapolis

Skills

Data Integration & Modeling: Synapse, Data Factory
Power Platform Automation: Power Automate, PowerApps
SQL & ETL Development: Advanced SQL
Data Visualization: Power BI, DAX
Risk & Compliance Analytics: Governance, Reporting
Integration Tools: ServiceNow GRC, SAP

Websites

blake-holsclaw-ab08371b8

Accomplishments

Turning around a request for an experimental app within 2 hours is remarkable... demonstrates the capabilities of the tool to meet the rapidly changing dynamic needs of healthcare operations. — Troy Tinsley, Director – Supply Chain
Blake, I wanted to take a moment to recognize and thank you for your instrumental role in our team’s success... — Bryan Buggs, Director – Information Services

Timeline

Intermediate IS Data Analyst

Indiana University Health

11.2021 - Current

Assoc - Cyber Security & Information Assurance

Ivy Tech Community College