CALEB BOUSMAN
Florence,AL
Summary
Snowflake Data Engineer with hands-on experience designing and optimizing enterprise-scale data pipelines across SAP ECC (R/3), S/4HANA, and Dynamics 365 environments. Self-taught and professionally developed through real-world implementation of complex data systems, including cross-system document flow modeling and performance-optimized transformations. Strong expertise in SQL, Snowflake architecture, and production-grade data pipeline design.
Overview
2
2
years of professional experience
2
2
years of post-secondary education
Work History
Data Engineer
Solventum
Florence, AL
07.2024 - Current
- Designed and built enterprise Snowflake data pipelines integrating SAP R/3, S/4HANA, and Dynamics 365 systems
- Modeled complex PO → SO → OBD → IBD relationships across multiple source systems
- Implemented advanced SQL transformations including deduplication using window functions and partitioning logic
- Optimized query performance by restructuring joins and eliminating inefficient patterns
- Built monitoring and validation frameworks to ensure pipeline reliability and data integrity
- Automated workflows using Snowflake Tasks and scheduling strategies
Education
Associate of Applied Science - Welding Technology
Aiken Technical College
Aiken, SC 08.2017 - 03.2019
Skills
- Data Platforms: Snowflake
- Languages: SQL (advanced), Python, JavaScript (Snowflake procedures)
- ERP Systems: SAP ECC (R/3), SAP S/4HANA, Dynamics 365
- Data Modeling: Document flow modeling, cross-system reconciliation
- ETL/ELT: Pipeline design, transformation logic, deduplication strategies
- Performance Optimization: Query tuning, window functions, join optimization
- Orchestration: Snowflake Tasks, scheduling (CRON)
- Monitoring: Data validation, pipeline alerting
- Tools: Git, VS Code
Project Highlights
- Unified document flow model across ERP systems
- Data quality control and validation frameworks
- Scalable transformation logic for complex scenarios
Professional Development
Self-taught data engineer specializing in Snowflake, SQL, and enterprise data systems
Timeline
Data Engineer
Solventum
07.2024 - Current
Associate of Applied Science - Welding Technology
Aiken Technical College
08.2017 - 03.2019