Lincoln Hu, Developer in Auckland, New Zealand
Lincoln is available for hire
Hire Lincoln

Lincoln Hu

Verified Expert  in Engineering

Business Intelligence Developer

Location
Auckland, New Zealand
Toptal Member Since
March 1, 2021

Lincoln is a developer with over 15 years of experience developing and implementing business intelligence (BI) and data warehouse solutions, SAP ERP solutions, and software along with general web design and development. His expert skillset includes SQL, T-SQL, stored procedures, MS SQL Server & Oracle, data warehouse & ETL, MS SSIS, SSRS/SSAS, Power BI, Microsoft Azure SQL Database, Synapse Analytics, Data Factory, Databricks, Google BigQuery, AWS RDS and RedShift, and Python programming.

Portfolio

Toptal Clients
SQL, Microsoft Power BI, Azure SQL Databases, Data Warehousing...
OCS
Business Intelligence (BI), Microsoft Power BI...
IAG New Zealand
Business Intelligence (BI), SQL, Microsoft Power BI...

Experience

Availability

Part-time

Preferred Environment

SQL, ETL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power BI, Azure Data Factory, Google BigQuery, Python, Data Warehousing

The most amazing...

...thing was implementing full BI solutions including a data warehouse, ETL pipeline, and Power BI for companies in New Zealand, Australia, the US, UK, and APAC.

Work Experience

Business Intelligence | ETL Developer | Data Engineer

2020 - PRESENT
Toptal Clients
  • Worked for a US SaaS company as a data engineer and Power BI developer on a development team. It focused on the development of Azure SQL database and Power BI, including database views and stored procedures, dimension and fact tables, ETL, Power BI reports, etc.
  • Used Power BI to produce data analysis for the cybersecurity insurance profit, performance, insured clients, brokers, underwriters, etc. This was a Power BI dashboard project with a US cybersecurity insurance business client.
  • Worked on a data processing and dashboard construction project with a US call center business client. Used Zoho Analytics to build various dashboards, including call center concurrency, productivity, and billing.
  • Worked on a CRM and data analysis project with a US healthcare business client. Used Microsoft SQL Server and PowerApps, built the patient onboarding and CRM management system, used Power BI, and produced a patient and healthcare data analysis dashboard.
  • Worked on the project with Evolution Service Corporation (US). Used Python and Google Cloud, designed an end-to-end solution to extract data from Typeform via a RESTful API, loaded data in Google BigQuery, and provided data insights in Power BI.
Technologies: SQL, Microsoft Power BI, Azure SQL Databases, Data Warehousing, Microsoft SQL Server, Azure Data Factory, Analytics, Azure SQL Data Warehouse, Business Intelligence (BI), Microsoft Fabric, Data Lakehouse

Senior Reporting Architect

2018 - 2021
OCS
  • Built an Azure SQL database and Azure Data Factory solution to get data extracted from online systems including Salesforce, ServiceNow, and Microsoft Office 365 and load data into Azure SQL database for Power BI reporting.
  • Implemented a completed BI solution from scratch for OCS New Zealand and Australia, including a data warehouse solution in Microsoft SQL Server, ETL solution in WhereScape RED and SSIS, a reporting solution in SSRS and Power BI cloud platform.
  • Designed a data warehouse architecture and integrated data from SAP, Salesforce, concept evolution, quality management, and EnsureFlow systems into a data warehouse with a Kimball star schema model.
  • Built several finance dashboards, including revenue-and-gross margin dashboard, trends dashboard, a consolidated P&L report, GR/IR report, debtor report, UK MOR report, balance sheet report, overhead analysis report, and more.
  • Developed a range of operation dashboards: Salesforce pipeline dashboard, a customer dashboard (new and lost), concept evolution dashboards, a quality management dashboard, and an AU EnsureFlow dashboard.
  • Created Power BI dashboards that provided information, analysis, and reporting on a range of topics such as finance, employee, health, and safety, for Air New Zealand, New Zealand airports, New Zealand Police, The City Council, Coca-Cola, and others.
  • Developed HR and health-and-safety dashboards that analyzed employee retention, visa, gender, age, nationality, absence, and attendance, leave balance and liability, health and safety, TRIFR, and more.
  • Collaborated closely with the finance and operation leadership team and completed financial and operational data digital transformation project, which brought unprecedented transparency into business and turned business into a data-driven business.
  • Introduced a New Zealand and Australia business intelligence (BI) and data warehouse solution to group UK headquarter and other countries like Thailand.
  • Won the award as the best support person/team in OCS Australia and New Zealand in 2019.
Technologies: Business Intelligence (BI), Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), WhereScape RED, SQL Server 2017, Azure SQL Databases, Azure Data Factory

Business Intelligence Developer

2017 - 2018
IAG New Zealand
  • Designed a new Power BI customer experience dashboard which included automating the ETL data to an SQL Server data warehouse and producing dashboards in Power BI to report on customer summaries, growth, and retention.
  • Migrated an employee leave-and-performance Access database into an SQL Server data warehouse as well as Excel reports into Power BI dashboards and made users switch from Excel to a new Power BI platform seamlessly.
  • Provided efficient data support for the delivery team and helped them solve the eDoc issue and minimize the impact on customers.
  • Rewarded with the quarterly TOA in IAG for outstanding work contributed to customer experience Power BI dashboard and received multiple instant TOAs from team members and stakeholders due to continuous and excellent support and collaboration.
  • Introduced Agile project management into the team, set up a Kanban board, and implemented the BI and analytics software development lifecycle (SDLC) process and source code control.
Technologies: Business Intelligence (BI), SQL, Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Business Intelligence Developer

2017 - 2017
Orion Health New Zealand
  • Migrated and designed the conforming dimensions of the business unit, cost center, employee (Type 2 SCD), which became “the source of truth” for BU, CC, and every employee in the entire company.
  • Built a CX self-service BI solution from scratch which provided insights for the marketing team and business improvement team to analyze the customer's experience (CX) including customer feedback as well as net promoter score.
  • Automated “Blue Sheet” in a CRM which provided convenience for the sales team to print an integrated “Blue Sheet” from the CRM directly, improved efficiency and accuracy, and reduced manual errors.
  • Developed SSRS reports including personal development plan report, department moves report (a data-driven subscription), product license maintenance report, Oracle prepayment and interface exception report, and CRM usage report.
Technologies: Business Intelligence (BI), SQL, Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Business Analyst | Report Writer

2015 - 2017
SAECOWilson
  • Implemented Microsoft BI platforms for the organization which made reporting much more flexible and powerful by integrating and combining SAP and CRM data into a data warehouse; we reduced reporting costs by switching from SAP to Microsoft.
  • Delivered a turn-earn index report and provided insights to the management team about turnover, costs, and profit; it also highlighted situations where high margins compensate for low inventory turns.
  • Automated a range of sales reports (daily, monthly, quarterly, years) and provided real-time and accurate sales figures to management team as well as reducing manual work.
  • Developed a wheel kit web interface and reports and enabled branch users to easily search for wheel kits faster; it also protected wheel kit data to be viewed securely with download, export and print functionalities were disabled.
  • Integrated customer and address data between the CRM and SAP which ensured data consistency and accuracy.
  • Delivered CRM offline functionality which enabled sales reps to enter data offline to the CRM system when they visited customers on-site and had poor network connection.
Technologies: Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#.NET, VB.NET, SQL

Business Intelligence Consultant

2014 - 2015
Fulcrum Decision
  • Delivered the SKYCITY Australia Darwin and Adelaide labor reports project which included extracting data (WhereScape RED) from PeopleSoft and MicroStar Workforce to an Oracle data warehouse and produced reports in SAP Business Objects.
  • Won a contract extension for Fulcrum Decision due to my outstanding consulting work in SKYCITY.
  • Consulted on BI for Carter Holt Harvey and provided support, maintenance, and enhancement to an existing data warehouse, ETL processes, and reports. Received high satisfaction from customers.
Technologies: Business Intelligence (BI), WhereScape RED, SQL Server Reporting Services (SSRS), SQL

Senior ERP System and BI Developer

2006 - 2014
Asia Pulp & Paper
  • Worked in Japan and Hong Kong and implemented the SAP Business One ERP system for the Japan and Hong Kong branches including master data, sales and purchase and finance modules, as well as customized functionalities.
  • Implemented BI solutions in the Japan and Hong Kong branches including a data warehouse and SQL ETL to integrate data from SAP Business One to a data warehouse and SSRS reporting automation.
  • Delivered more than 200 BI dashboards and reports to Japan and Hong Kong branches as well as heaps of customizations and enhancements.
  • Automated selling expense allocation and provided insights for the finance and management team to view revenue vs. cost and margin on each customer and sales order and knew customer profitability.
  • Completed an EDI integration between SAP Business One and various customer systems; also created customer sales analysis and forecast reports based on customer data from EDI.
  • Installed, maintained, and administered the Microsoft SQL Server database and reporting services for the Japan and Hong Kong branches.
Technologies: SAP, ABAP, C#.NET, SQL, Stored Procedure, Oracle, Java, JavaScript, SQL Server Reporting Services (SSRS), ETL

Software Engineer

2005 - 2006
BenQ
  • Contributed to the development of MES systems for BenQ manufacturing factories.
  • Helped to develop the MES summary data system which collected and summarized manufacturing data from Mexico and Czech factories into China headquarters.
  • Participated in BenQ and SIEMENS EDI data integration project.
  • Developed a schema manager tool and won first prize in competition; this tool could automate the script generation of multiple databases by designing visualized schemas in Excel.
Technologies: Microsoft SQL Server, SQL

Australia and New Zealand SAP Finance Reporting Project

Lead the project as the main developer and built ETL process to extract finance data from SAP and load it into Microsoft SQL Server data warehouse with Kimball star schema modeling. Designed multiple Power BI reports to present key financial information, including profit and loss, revenue and gross margin, customer site profitability and new loss analysis, debtor and creditor analysis, finance overhead cost analysis, and more.

Global Salesforce and ServiceNow Cloud Data Warehouse and Reporting Project

I led and coordinated with team members to extract data from a Salesforce and ServiceNow online platform into an Azure SQL database with the Azure Data Factory tool. I used Power BI to connect to the Azure SQL database and create reports to present the Salesforce pipeline, new business win, contract analysis, ServiceNow incident, and SLA analysis.

Customer Dashboard Project

I led and collaborated with team members to create a standardized customer dashboard with customer-related finance, human resources, quality management, employee training, health and safety, compliance, and sustainability info and figures. I made a Power BI dashboard as a product and provided and delivered it to customers, allowing them to view their info from a Power BI dashboard and improving their experience and satisfaction.
2001 - 2005

Bachelor's Degree in Information Engineering

Central South University - Changsha, China

NOVEMBER 2020 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

AUGUST 2020 - PRESENT

Machine Learning

Coursera

APRIL 2020 - PRESENT

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle

NOVEMBER 2014 - PRESENT

Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Microsoft

Libraries/APIs

ServiceNow REST API

Tools

Microsoft Power BI, Microsoft Excel, WhereScape RED, BigQuery, Microsoft Power Apps, Microsoft Access, Git, GitLab, Jira, Tableau

Languages

SQL, Stored Procedure, Excel VBA, C#.NET, VB.NET, ABAP, Java, JavaScript, Python, Snowflake

Platforms

Microsoft Fabric, Oracle, Azure SQL Data Warehouse, Microsoft Power Automate, Dedicated SQL Pool (formerly SQL DW), Azure, Oracle Autonomous Data Warehouse, Salesforce, Databricks, Jupyter Notebook

Paradigms

Kimball Methodology, Business Intelligence (BI), ETL, Data Science

Storage

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server 2017, Microsoft SQL Server, Databases, SQL Server 2019, Azure SQL Databases, PostgreSQL, Database Administration (DBA), Data Lakes

Frameworks

Data Lakehouse

Other

Data Warehousing, Data Engineering, Data, Architecture, Business Intelligence (BI) Platforms, DAX, Data Analysis, Data Visualization, Analytics, Excel Macros, APIs, RESTful Web Services, Azure Data Factory, Azure Data Lake, SAP, Google BigQuery, Google Data Studio, Machine Learning, ServiceNow, Customer Success

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring