Zhi Helena

Background

About Zhi Helena

Experienced Business Intelligence Analyst with a demonstrated history of working in the information technology and services industry. Skilled in Microsoft Word, Databases, Business Intelligence, Microsoft Office, and Microsoft Excel. Strong research professional with a Bachelor of Engineering focused in Computer Science and Technology from China University of Geosciences (Wuhan). •Solid experience in T-SQL script skills including Join, Dynamic Queries, Ad-hoc queries, Linked-Server, views, functions and stored procedures in MS SQL Server. •1 year’s Business Intelligence (BI) analysis experience with BI stack developing tools (SSIS, SSRS, SSAS) to build and manage BI solutions. •Solid Hands-on experience in (1)Developing ETL process solution with SSIS package and T-SQL Query for extracting data from multiple data sources.(2)Designing data model and building Data Warehouse.(3)Building, deploying and processing SSAS Cubes. •Proven hands-on experience in reporting development process, analyzing business requirements by key performance variables, generation reports from various data sources, designing and deploying reports into premises and the online environment by using SSRS and Power BI. •Hands on skills to use Access & VBA, Excel & VBA (V-lookup, index, match, pivot table, countif, sumif, array, string operations) •Knowledge of Power BI, Power Query M and DAX, MDX Query, Python. •Proven self-motivated, quick learner with high logic and analytical ability, capable of working under pressure. •Spirit of collaboration, highly organized with superior problem-solving abilities. •Proficient computer knowledge including various software and hardware. •English with both written and oral, functional French.