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, ON04.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