Results-driven Business Intelligence Analyst with expertise in SQL, Power BI, and Python. Successfully developed automated data solutions, enhancing reporting accuracy and decision-making efficiency. Proven ability to collaborate with cross-functional teams, leading to significant project success and empowering users through training on data best practices.
Overview
3
3
years of professional experience
Work History
Analyst, Business Intelligence and Reporting
Healthcare of Ontario Pension Plan
Toronto, Canada
05.2022 - Current
Led the design, development, and implementation of BI solutions using Power BI, SQL, and Power Platform to enhance data-driven decision-making across the organization. Result: Improved reporting accuracy by 40% and actionable insights by 30% for 50+ healthcare projects.
Architected and optimized data models and reporting solutions, performing data cleansing, transformation, and enrichment tasks with advanced SQL queries and Power Query. Result: Reduced data errors by 25%, increased reporting efficiency, and supported projects involving 50M+ rows of data.
Automated and streamlined workflows using PowerApps, boosting operational efficiency and reducing manual data entry by 50%. Result: Significantly improved productivity across cross-functional teams and led to faster decision-making.
Utilized Python and PySpark for data alignment and enhanced data matching, improving data completeness by 20% for health data projects. Result: Delivered more accurate and reliable data insights for over 15 healthcare initiatives.
Led the development of interactive reports, leveraging Power BI and Python to provide critical business insights that supported 12+ strategic healthcare initiatives. Result: Enhanced decision-making efficiency by 30% across multiple teams.
Authored technical documentation and conducted training on DAX and Power BI Service, increasing team self-sufficiency in dashboard creation by 40%. Result: Empowered users and improved organizational data analytics capabilities.
Managed and delivered 35+ data projects on time, collaborating with stakeholders and building strong relationships to ensure the successful implementation of BI solutions. Result: Contributed to a 25% increase in project success rates and improved team collaboration.
Conducted extensive member research, utilizing StatsCan and HOOPP data for targeted communication efforts. Result: Enabled the Communications team to effectively engage with the right audiences through tailored outreach strategies.
Education
Master of Engineering - Electrical and computer engineering
University of Waterloo
Waterloo, ON
04.2022
Bachelor of Technology - Electronics and communications
Gujarat Technological University
Gujarat, India
06.2019
Skills
BI Tools & Platforms: Power BI, Power Platform (PowerApps, Power Automate), Microsoft Fabric
Programming & Data Engineering: SQL, DAX, Python, PySpark, Power Query
Data Management: Master Data Management (MDM), Data Orchestration, ETL/ELT Processes
Cloud & Data Storage: Microsoft Azure, Cloud Infrastructure, Data Pipelines