Allan Smith

I’m a senior-level Business Intelligence and Automation Engineer who builds high-impact data systems that turn raw enterprise data into real-time, decision-ready intelligence. I specialize in designing and scaling SQL Server, SSIS, SSAS, and Power BI ecosystems that automate ETL, power executive KPIs, and drive measurable improvements in accuracy, efficiency, and profitability.

I’m focused on making analytics fast, reliable, and operational. With expertise in SQL performance tuning, advanced data modeling, and DAX-driven analytics, I deliver reporting that works across complex OLTP and OLAP environments—backed by strong stakeholder collaboration, requirements gathering, and executive-level presentation.

In my current role, I engineered enterprise-grade Power BI and SSRS reporting ecosystems with DAX-driven KPIs and executive dashboards, designed scalable SQL Server data models and ETL pipelines, and built AI-powered grading and validation automation using Python and SQL Server. I also implement end-to-end automated workflows (including structured business rules, error handling, and Mandrill email delivery) to reduce risk, eliminate manual work, and create consistent business results.