Business Intelligence Analyst
Current• Business Intelligence Analyst Lead that established and oversaw organizational digital transformation initiatives. • Led end-to-end metric development projects from requirements gathering to production implementation and sustainment.• Developed ETL workflows using Python, Alteryx and SSIS to merge and normalize data across disparate data sources.• Designed and programmed data pipelines with API integrations to capture vendor data used for operational reporting.• Collaborated with teams across the organization to identify manual data analysis processes suitable for automation. • Automated the collection & transformation of supplier and transportation data for logistical reporting across the enterprise.• Designed conceptual, logical, and physical data models for business unit objectives to obtain key performance indicators.• Created automated Tableau and Power BI dashboards for operational teams to track task flows, capacity, shipments, and performance.• Produced analytics to support carrier contracts, supplier recovery, network planning, freight cost, & root cause analysis.• Provided consultation to internal business partners on data architecture within our transportation systems.
