At IKORP, I own two daily cloud data pipelines that process 40,000+ records, from ingestion and transformation through validation and downstream analytics. I build event-driven workflows with AWS services for near-real-time processing and automation.
I’ve developed layered data architecture across Landing, Staging, Reference, Fact and Dimension layers, delivering 30+ SQL scripts and 30+ database tables and views. My SQL, Python and DBT transformations include data validation and SCD Type 4 processing for historical records.
For workforce planning, I developed data models across five source domains and implemented business rules for Worked Hours and Productive Hours. I also supported the iCargo-Core upgrade and migration by mapping legacy and target structures and validating 30+ impacted reports.
I’ve consolidated 20 Power BI dashboards into three core reports and delivered Paginated Reports and Power BI Service deployments. I use GitHub Actions for CI/CD and hold DP-600 and DP-700 certifications.
