bill gesora

I have over eight years of experience in business intelligence and analytics engineering, specializing in Power BI, advanced DAX, Power Query (M), T-SQL, and Microsoft BI Stack. I build intuitive dashboards and robust data models that translate complex business needs into actionable insights.

I design secure, scalable Power BI datasets with role-based security and performance-tuned DAX measures, and I have implemented RLS and optimized model size to improve report load times. My work has driven measurable improvements in reporting SLAs and operational visibility.

I build ELT workflows and semantic models using tools like dbt, Snowflake, Airflow, and Azure Synapse, and I collaborate closely with engineering teams to streamline pipelines and automate processes. I’ve reduced manual reporting time and decreased query runtimes through scalable dimensional modeling and automation.

I am pursuing an MSc in Computer Science and hold certifications including Microsoft Certified: Data Analyst Associate; I mentor junior analysts and focus on delivering reliable, maintainable analytics solutions that enable data-driven decisions and continuous technical growth.