Jiu Hong Mei

Providing data engineering/data architect consulting service on Microsoft Azure Modern Data Warehouse architect/data engineering design, implementation, performance tuning, ETL/ELT data pipelines developing, Machine Learning Engineering, Data visualization; Working with Microsoft Fabric, Azure Synapse, Azure Data Lake, Azure Delta Lake, Azure Databricks, Azure Function, Azure Data Factory, Event-Hub, Azure Key vault, Azure SQL Server, Snowflake Implement Infrastructure-as-code with Terraform, CI/CD with DevOps Working as Sr. Data Engineer to help design the architecture of the Enterprise data warehouse, Azure Modern Data Warehouse and Azure data lake house, build ETL/ELT framework and standards, develop data engineering pipelines and automation test implementation for data quality with best practice, lead the design for on premise data warehouse migration to Azure data lake house. • Build Azure data lakehouse with Azure Synapse, Azure data lake storage, Databricks, Azure SQL/Azure SQL MI/Dedicated SQL Pool (Azure DW) or Serverless SQL Pool, Polybase, Spark pool. • Develop data engineering pipelines with Azure Data Factory/Azure Synapse pipelines, dataflows and notebooks, utilizing PySpark pool for big data processing and integrating different data (structured/non-structured) into the data lake/lake house • Design Analytics Service (Tabular Semantic Model) with Microsoft Fabric, PowerBI to help customers easily making self-analytics with visualization tools, build PowerBI semantic models and Fabric deployment pipelines to publish dashboards, reports and semantic model to different environment • Build infrastructure-as-code with terraform into the DevOps release pipeline to support the CI/CD deployment to different environment • Migrating the existing SSIS solution to Azure Synapse, re-platform by lift-shift the SSIS package with Azure-SSIS service, re-factor the SSIS package with notebook to improve the ETL performances

Microsoft Business Intelligence Architect Microsoft Business Intelligence Consultant and developer(SSIS, SSAS, SSRS, PowerBI) SharePoint developer Qlikview Developer Web front-end developing with .Net, C#, XML,JavaScript,HTML,CSS, D3, TypeScript Windows Mobile application development Dassualt Enovia JPO developing for the integration with Crystal Report by java

SSAS Cube Developing Sharepoint UI/Web part development SSIS - ETL developing/testing/deployment SSRS/Dashboard developing/testing/deployment SQL Server Performance tuning

Project requirement analysis Data modeling SSAS Cube developing

Requirement Analysis SSIS ETL pipeline developing SSAS multi-dimensional cube developing SSAS Tabular model cube developing

Business Requirement Analysis Data Modeling ETL developing

Sharepoint UI/Web part/BDC developing ETL developing SSRS design Unit/QA/Production testing and deployment Requirement Analysis & Documentation