Summary
Overview
Work History
Education
Skills
Timeline
Generic

Muzammil Khan

Senior Business Intelligence Developer
Toronto

Summary

Professional with strong background in data analysis and business intelligence. Skilled in leveraging data to drive actionable insights, optimize processes, and support strategic decision-making. Known for team collaboration, adaptability, and delivering results. Strong expertise in SQL, data visualization tools, and statistical analysis.

Overview

14
14
years of professional experience

Work History

Senior BI Analyst

Zayo Group / Allstream Inc.
09.2021 - Current
  • Transform complex business problems into scalable data pipelines and visualizations to allow stakeholders to make decisions and provide insights into current processes and status. Responsible for developing and maintaining ETL processes via SQL and DBT data modelling for creation or enhancements of Tableau and Power BI dashboards. Work in an Agile environment and support Sales Operations, Customer Success and Churn teams to provide effective reporting by gathering requirements, develop solutions, and provide clear insights and recommendations for business opportunities.
  • Supported business in developing analysis and reporting for circuits that were not billed but charged by vendors for an expense savings of $5.6M annualized.
  • Maintained existing ETL and data pipelines in SQL, DBT and Snowflake processes which feed into reporting.
  • Optimized Tableau Dashboards and Dataflows to enhance performance of customer facing dashboards for Customer Success teams to support large enterprise customers by 80%.
  • Received executive recognition for Sales Operations Analysis, which helped identify root cause and provide analysis for order rejections, which laid the foundation for organizational changes in order processing.
  • Developed custom automated solutions via Power Apps, Power Automate, and Zapier. Notably, a BI team landing page to capture requests/concerns and feed JIRA board to support workload management.

Senior BI Analyst

TELUS
08.2016 - 07.2021
  • Simplify and unravel complex business problems through requirements gathering, data mining, manipulation and reporting to produce grade metrics and BI solutions to business stakeholders. Responsible for managing end to end product specific ETL procedures and dashboards for Operations and Product Managers. Also provided key technical support, root causing problems and process improvement for programs and processes.
  • Developed ETL and Tableau dashboards using billing systems with actionable findings on monthly revenue losses for products which helps mitigate $1.25M annualized of churn.
  • Executive recognition for developing a PRI Porting reporting process that recognized $2M in annualized revenue.
  • Produced call center dashboards to show call metrics and call queue metrics which showed actionable insights to help save $300k annualized savings in agent performance.
  • Managed 5 team members in both technical and project management for the team.
  • Facilitated learning and training sessions for 8 team members on technical skills such as Tableau, Python, SQL, and Lavastorm.

Senior Business Analyst

MTS Allstream
02.2012 - 07.2016
  • Accountable for customer and prospect analysis within MS Dynamics (CRM). Using prospect data to drive targeted prospect acquisition, customer up-sell/cross-sell and retention programs via ETL procedures. Developed automated reporting for finance and reporting teams to improve efficiency of the overall team.
  • Coded a MS Access in VBA application to ingest, analyze and return actionable reports to recapture expenses from partner carriers totaling $500k.
  • Coded an automated email tool in Python to automatically send hundreds of emails to internal sales reps and managers as part of marketing campaigns and renewal reminders.

Education

Bachelor of Commerce - IT Management, Applications Development, Finance

Ryerson University
Toronto, ON
04.2008

Skills

  • Tableau and Power BI data visualization
  • Snowflake expertise and DBT Development
  • SQL and Python programming
  • ETL development
  • Jira Agile framework
  • SSRS/SSIS development
  • Salesforce expertise
  • Data analytics and reporting

Timeline

Senior BI Analyst

Zayo Group / Allstream Inc.
09.2021 - Current

Senior BI Analyst

TELUS
08.2016 - 07.2021

Senior Business Analyst

MTS Allstream
02.2012 - 07.2016

Bachelor of Commerce - IT Management, Applications Development, Finance

Ryerson University
Muzammil KhanSenior Business Intelligence Developer