Sunday Ayobami

Business Intelligence Engineer (Data Enablement Analytics) @Dexian

VA, US

Automated 15+ ETL pipelines using Python and Azure Data Factory, reducing manual intervention and improving data refresh cycle time by 40%, leading to faster analytics delivery.• Designed and deployed 10+ enterprise Power BI dashboards, reducing reporting turnaround time by 30% and enhancing deployment pipeline visibility for over 50 users across PGI Retail Distribution.• Created and managed 20+ enterprise-grade Power BI dataflows, increasing data model reusability by 35% and ensuring accurate, scalable reporting across departments.• Built dynamic dashboards integrating metadata from 100+ deployment pipelines, driving a 25% increase in operational transparency and accelerating stakeholder decision-making.• Collaborated with 5+ cross-functional teams (engineering, DevOps, analytics, compliance) to uphold data integrity and align Power BI reporting with enterprise governance standards.• Utilized advanced Power Query (M) and DAX to develop insights on user behavior, supporting strategic decisions and improving platform adoption by 20% through usage pattern analytics.• Implemented performance tuning techniques (e.g, DAX optimization, data reduction strategies), boosting Power BI report load speeds by up to 60% and enhancing scalability for 200+ concurrent users.• Developed and executed ETL jobs for 10+ critical data sources, standardizing and transforming data in line with evolving business requirements, supporting weekly and monthly KPIs.• Led data validation and testing processes, achieving 99.9% data accuracy across reports and reducing downstream reporting errors by 35%.• Optimized complex SQL queries, reducing query runtime by 10–20%, thereby improving overall data processing performance and enabling near real-time insights.

Indiana University of Pennsylvania

Master's degree

Federal University of Technology Minna

Bachelor's degree