Azure BI Developer in Sydney, New South Wales, Australia

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.

• 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.

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

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.

• 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.

• 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.

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.

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.

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.