Edison Zhu, Azure BI Developer in Sydney, New South Wales, Australia
Edison Zhu

Azure BI Developer in Sydney, New South Wales, Australia

Member since July 7, 2021
Edison is an Azure BI developer, data engineer, and data architect with 16 years of BI experience in the financial, retail, health supplement, consulting, and IT services industries. Backed by an MCSE Azure Cloud Platform certification, Edison delivers high-quality BI solutions using SSIS, SSRS, SSAS, DAX/MDX, SQL Server, MS BI, and Power BI. Edison also excels at dimensional modeling, Azure Data Factory, performance turning large data warehouses, and .NET and Angular development.
Edison is now available for hire

Portfolio

  • Woolworths Group
    Azure Synapse, Azure Analysis Services, Microsoft Power BI...
  • Antares Solution
    Azure Data Factory, Databricks, Azure Analysis Services, Microsoft Power BI...
  • Woolworths Group
    Azure Data Factory, Azure Synapse, Microsoft Power BI...

Experience

Location

Sydney, New South Wales, Australia

Availability

Part-time

Preferred Environment

Azure PaaS, SQL Server BI, Windows 10, Visual Studio

The most amazing...

...enterprise projects that I've delivered from end to end help businesses make data-driven decisions and make business operations more efficient.

Employment

  • Senior Azure BI Developer

    2020 - PRESENT
    Woolworths Group
    • Designed and developed the shopper performance dashboard, including modeling, building the fact-and-dimension tables and dashboard using Azure Synapse, Data Factory, and Tableau.
    • Developed multiple Azure Data Factory pipelines to dynamically copy data into Azure Blob storage as per business request.
    • Built delivery subscription Power BI dashboards using Azure Synapse, Data Factory, Analysis service, and Power BI. The solution helps businesses to improve customer satisfaction, increase sales, and save on costs.
    • Migrated the seven existing fulfillment web reports of Woolworths' online sales to SSRS reports using Azure Synapse and SSRS.
    Technologies: Azure Synapse, Azure Analysis Services, Microsoft Power BI, Azure Data Factory, Tableau, Azure SQL Databases, Azure Logic Apps, Data Warehouse Design, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, SQL, Google BigQuery, DAX, Apache Airflow, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, APIs, Data Migration, API Connectors, ETL, XML, REST, ETL Tools, Business Intelligence (BI), Dashboards, Data Visualization, Pandas, Data Pipelines, Data Analytics, Data Lake Design, Data Lakes, Data, Cloud Platforms, Data Modeling, Data Analysis
  • Azure BI Consultant and Data Architect

    2018 - 2020
    Antares Solution
    • Designed and developed the ETL, data warehouse, cube, and reports of a digital email campaign for a leading health supplement company. This automation saved the client a substantial amount of time instead of having to manually generate the reports regularly.
    • Delivered a real-time big data analytics architecture including designing a big data, real-time, IoT, machine learning, and advanced analytics platform for a leading entertainment company.
    • Developed text classification for clients using Python, Keras, word embedding, NLP, Word2vec, GloVe, deep learning, and CNN.
    • Built a movie recommendation proof of concept (POC) using Azure Databricks, machine learning, collaborative filtering, real-time data ingestion, Azure Event Hubs, Spark MLlib, and Python.
    Technologies: Azure Data Factory, Databricks, Azure Analysis Services, Microsoft Power BI, SSRS Reports, SQL Server Integration Services (SSIS), Python, Azure Event Hubs, Azure Stream Analytics, Azure Logic Apps, GloVe, Natural Language Processing (NLP), Data Warehouse Design, Microsoft SQL Server, Data Architecture, SQL Server Analysis Services (SSAS), Data Engineering, SQL, DAX, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, Azure Machine Learning, APIs, Data Migration, API Connectors, ETL, XML, REST, ETL Tools, Business Intelligence (BI), Dashboards, Data Visualization, Pandas, Data Pipelines, Data Analytics, Marketing, PostgreSQL, Data Lake Design, Data Lakes, Data, Redshift, Cloud Platforms, Data Modeling, Data Analysis
  • Senior Azure BI Developer

    2017 - 2018
    Woolworths Group
    • Designed and built a dimensional modeling data warehouse, a tabular cube, and Power BI dashboard of online sales using Azure Data Warehouse, Azure Analysis Services cube, and Power BI.
    • Performance-tuned large volume data with table partition, cube partition, polybase, and hash distribution on Azure Data Warehouse.
    • Automated the cube process using Azure Automation account, runbooks, and webhooks.
    Technologies: Azure Data Factory, Azure Synapse, Microsoft Power BI, Azure Analysis Services, Azure Logic Apps, Data Warehouse Design, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, SQL, DAX, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, Data Migration, ETL, ETL Tools, Business Intelligence (BI), Dashboards, Tableau, Data Visualization, Data Pipelines, Data Analytics, Data Lake Design, Data Lakes, Data, Cloud Platforms, Data Modeling, Data Analysis
  • Senior SQL BI Consultant

    2016 - 2017
    Agile BI
    • Delivered high-quality BI solutions and projects for clients on BI visualization and reports, data warehousing, SSAS tabular model cube, DAX/MDX, SQL Server, Microsoft BI, and Power BI.
    • Modeled, designed, and developed independently a sales cube using a SSAS tabular model cube and DAX for a large wholesale/retail company.
    • Delivered an advanced benchmark BI system and advanced SSRS reports for a leading accounting firm using SSRS, MDX, SSAS, an OLAP cube, and SQL Server.
    Technologies: SQL Server Integration Services (SSIS), SSRS Reports, SQL Server BI, SSAS Tabular, DAX, Microsoft Power BI, MDX, Data Warehouse Design, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Engineering, SQL, Azure SQL, Database Design, Azure, Relational Databases, Databases, Data Warehousing, APIs, Data Migration, ETL, ETL Tools, Business Intelligence (BI), Dashboards, Data Visualization, Data Pipelines, Data Analytics, Microsoft Access, Data, Cloud Platforms, Data Modeling, Data Analysis
  • Senior SQL BI Developer

    2011 - 2016
    Aussie Home Loan
    • Designed and developed independently a new data warehouse, cube, ETL, and some reports for analyzing mortgage and non-mortgage sales data (including home loan, insurance other financial data).
    • Designed and developed a GL cube for the finance department.
    • Optimized and performance-tuned a large volume BI data warehouse.
    Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server BI
  • SQL BI Developer

    2010 - 2011
    Hyundai
    • Developed several reports using SSRS (Reporting Service 2008) for finance, marketing, and sales departments.
    • Oversaw and was in charge of ETL development and developed an SSIS package to extract data from an ERP system and transformed and processed the data using SQL Server 2008.
    • Worked with an analysis programmer and other developer to realize the system based on InfoPath, Microsoft Web Services, Workflow, and SQL Server 2008.
    Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server BI
  • Microsoft BI Developer

    2006 - 2010
    Pactera
    • Worked onsite at Microsoft and contributed to the development and support of five BI applications based on SQL Server, SSRS (reporting service), SSAS (cube), SSIS, ETL, data warehousing development, dimensional modeling design, and schema design.
    • Developed reports using SSRS and implemented ETL through programming store procedures and SSIS package.
    • Constructed the ETL with an SSIS package—slowly changing dimensions with store procedures, aggregation, a processing cube, and so on.
    Technologies: C#.NET, SQL Server BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Multidimensional Expressions (MDX)

Experience

  • Supermarket Ecommerce Data Warehouse and Dashboard

    I designed and developed the online sale and eCommerce store operations data warehouse and dashboard using Azure Data Warehouse, Azure Data Factory, Azure Analysis Services cube, and Power BI technologies. The solution essentially enabled businesses to navigate business operations better, which helps businesses improve customer satisfaction, increase online sales, and save costs.

  • Digital Email Campaigns - Analytics

    • Designed and developed ETL, data warehouse, cube, and reports for digital email campaigns using Azure Data Factory, logic apps, SharePoint, REST APIs, Azure Analytics Service, and Power BI.
    • Automation saved the client lots of time to manually generation of reports.

  • Retail Inventory ETL and Dashboard

    Developed Azure Function and Data Factory to extract inventory data from REX system (Soap API) to Azure SQL Database. Created and designed the retail inventory dashboard and model using Power BI. Supported their DW and Power BI report. This solution provided instant insights, including stock turnover, stock value, and other inventory metrics, to store owners and head office

  • Tourism Data Warehouse and Dashboard

    Developed the ETL pipelines to automate 5+ data sources’ extraction, including bookings, searches, flights, and visitor surveys, and orchestrated data-processing from source to data warehouse.

    Designed the Power BI data model and delivered several Power BI reports.

    The solution provides instant insights to a range of staff, from analysts to C-Suite executives, and eliminates the immense amount of resources and time spent on manual reporting and data extraction.

  • Text Analytics Dashboard

    • Developed a text analytics dashboard of employees’ survey to show the sentiment of the answers and quickly identify the answers about different domains with MS cognitive text analytics API, Python, NLP, GloVe, Machine Learning, and Power BI.
    • Objective: quickly identify important answers from a large number of survey answers every year to uncover the issues in the business and identify opportunities to improve services.

  • Real Time Big Data Architecture

    • Delivered a real-time big data architecture, including designing big data, real-time, IoT, machine learning, and advanced analytics platform.

    • Objective: Building this platform was to support next-generation analytics, including processing structure and unstructured data, real-time data ingestion, analytics, and machine learning.

  • Motor Industry Benchmark Bi System

    Designed and developed a motor industry benchmark BI system and several BI reports and dashboards for the eProfit system using MS reporting service, MDX, SSIS, and SQL Server. Moreover, I tackled the tough performance issue caused by previous design by reverse engineering and reinventing the “engine.” The solution enabled extensive reports to be rolled out to the end users and has been recognized and applauded by the CIO and partners.

  • Mortgage Sales Data Warehouse and Reports

    Independently designed and developed the new data warehouse, cube, ETL, and some reports for the mortgage sales from scratch based on SQL Server, dimensional modeling, SSRS, SSAS, SSIS, MDX, and T-SQL. The reports were being used by sales managers and executives daily. In addition, I have enhanced the cube to enable users to do self-servicing reports using Excel.

  • SaaS Ecommerce Web Platform

    Independently designed and developed a SaaS eCommerce web platform using Angular 8+, .Net Core, REST API, and Azure SQL Database. Users can register a store on this platform and the store has all the eCommerce features.

Skills

  • Languages

    SQL, C#.NET, XML, Python 3, Python
  • Tools

    SQL Server BI, Microsoft Power BI, Microsoft Access, Azure Logic Apps, Tableau, Apache Airflow, Azure Machine Learning, SSRS
  • Paradigms

    Dimensional Modeling, Business Intelligence (BI), Database Design, ETL, REST
  • Storage

    SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure SQL, Microsoft SQL Server, SQL Server Analysis Services (SSAS), Relational Databases, Databases, Data Pipelines, Azure Blobs, Azure SQL Databases, Data Lake Design, Data Lakes, SQL Server 2016, PostgreSQL, Redshift
  • Other

    Azure Data Factory, Data Modeling, Data Warehouse Design, Data Engineering, Data Warehousing, Data Migration, API Connectors, ETL Tools, Data Analytics, Data, Cloud Platforms, Azure Synapse, Azure Analysis Services, APIs, Dashboards, DAX, Data Visualization, Azure Batch, Data Analysis, Azure Stream Analytics, GloVe, Natural Language Processing (NLP), Data Architecture, Google BigQuery, Machine Learning, Azure Data Lake
  • Frameworks

    Angular, .NET Core, Angular Material
  • Platforms

    Azure, Databricks, Azure Event Hubs, Azure Functions
  • Libraries/APIs

    Pandas, Azure Cognitive Services
  • Industry Expertise

    Marketing

Education

  • Bachelor's Degree in Computer Science
    1999 - 2003
    Shijiazhuang Tiedao University - Hebei, China

Certifications

  • Neural Networks and Deep Learning
    APRIL 2018 - PRESENT
    Coursera
  • MCSE: Cloud Platform and Infrastructure — Certified 2017
    JUNE 2017 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others