Yun He
Verified Expert in Engineering
BI Data Engineer and Developer
Pointe-Claire, QC, Canada
Toptal member since October 4, 2023
Yun is a senior developer with 20+ years of experience in business intelligence (BI) and data warehousing. She specializes in the implementation of business analytics and reporting solutions. This includes capturing business needs for data integration, data modeling, and report building. In addition, Yun has a strong background in enterprise Power BI tenant administration, ensuring best practices, enforcing security policies, optimizing cost and capacity utilization, and tuning performance.
Portfolio
Experience
- Transact-SQL (T-SQL) - 14 years
- Data Warehouse Design - 14 years
- DAX - 8 years
- Star Schema - 8 years
- Data Modeling - 8 years
- Microsoft Power BI - 8 years
- Azure Data Lake - 4 years
- Azure - 4 years
Preferred Environment
Microsoft Power BI, Fabric, DAX, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Azure Synapse, Azure Data Lake, Azure Data Factory (ADF), Transact-SQL (T-SQL)
The most amazing...
...project I've delivered involved optimizing a large enterprise Power BI dashboard, resulting in 10x faster performance and an 85% reduction in dataset size.
Work Experience
Senior BI Data Engineer | Data Modeler
Kruger
- Oversaw the design, development, and implementation of data warehousing, reporting, and analytics solutions that deliver information efficiently, aiming to make large or complex data more accessible, understandable, and usable.
- Worked with stakeholders to capture business needs, lead, and participate in designing, developing, and implementing Power BI analytics and reporting solutions that meet business objectives and facilitate decision-making.
- Architected and developed data models, ETL packages, SQL Server Integration Services cubes like OLAP and Tabular, and Power BI reports, applying best practices to the development lifecycle.
- Developed and implemented advanced visualization applications and executive-level interactive reports and dashboards using Power BI: service, Desktop, and Report Server. Ensured Power BI data model security design and performance tuning.
- Analyzed the existing BI system to identify areas for improvement and optimize data flows. Identified opportunities to add value to the client's organization through effective information management.
- Steered all the development in the company's BI environment. Coached and monitored users to implement best practices. Ensured BI solutions adhered to data governance processes and participated in data governance initiatives.
Senior Power BI Developer and Administrator
CAE
- Oversaw all the Power BI development in the enterprise environment. Coached and monitored users to ensure best practices in implementing datasets and dashboards and provided feedback to the business community when deviations occurred.
- Ensured Power BI data model security design and performance tuning, making large or complex data more accessible, understandable, and usable.
- Engaged with clients and analytics business partners to understand business needs and translate requirements into advanced visualization designs and sustainable tools.
- Designed, developed, and implemented advanced visualization applications and executive-level interactive reports and dashboards using Power BI Desktop and Power BI service.
- Monitored Power BI service and gateway performance and analyzed usage data and trends to derive appropriate courses of action, ensuring optimized system performance.
- Configured, updated, and managed Microsoft Power BI tenant-level service. Defined and enforced security policies and optimized Power BI cost and capacity utilization.
- Installed, upgraded, and maintained Power BI gateway servers and created and updated gateway connections.
BI Developer | Data Analyst | Data Modeler
McGill University
- Worked with stakeholders to capture business needs as the Power BI leader of the team. Headed the design, development, and implementation of analytics and reporting solutions to meet business objectives and facilitate decision-making.
- Captured, analyzed, and performed cleansing of business data to ensure quality data for reporting solutions. Developed on-premises and cloud ETL/ELT to integrate and aggregate data from multiple sources and provide business insights.
- Designed multidimensional and tabular data models for BI reporting solutions to achieve fast query performance against business data.
- Defined, configured, and implemented data security and management for Power BI reporting solutions.
- Monitored Power BI usage and performance and managed datasets, data models, and on-premises gateways as a Power BI tenant administrator. Established policies and guidelines to help users take proper action.
Experience
GDEU Government Reporting System
Electronic Factbook
Industrial Sales and Inventory
Education
Master's Degree in Computer Science
Concordia University - Montreal, Quebec, Canada
Bachelor's Degree in Software Engineering
Sun Yat-sen University (a.k.a. Zhongshan University) - Guangzhou, Haizhu District, China
Certifications
Microsoft Azure Fundamentals
Microsoft
Analyzing Data with Microsoft Power BI
Microsoft
Skills
Libraries/APIs
Fabric
Tools
Microsoft Power BI, On-premises Data Gateway, Toad, SQL Server BI
Languages
Transact-SQL (T-SQL), SQL, Power Query M
Paradigms
ETL, Agile Software Development
Platforms
Azure, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Azure Synapse, Oracle
Storage
Data Lakes, SSAS Tabular, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Oracle PL/SQL, Azure SQL Databases, Azure SQL
Other
DAX, Data Analytics, Star Schema, Data Visualization, Data Engineering, BI Reporting, Data Warehouse Design, Azure Data Lake, Azure Data Factory (ADF), Data Modeling, Data Warehousing, Software Engineering, Administration
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring