Lincoln Hu, Business Intelligence Developer in Auckland, New Zealand
Lincoln Hu

Business Intelligence Developer in Auckland, New Zealand

Member since February 12, 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.
Lincoln is now available for hire

Portfolio

  • Toptal Clients
    SQL, Microsoft Power BI, SQL Server Integration Services (SSIS)...
  • OCS
    Business Intelligence (BI), Data Warehouse Design, Microsoft Power BI...
  • IAG New Zealand
    Business Intelligence (BI), Data Warehouse Design, SQL, Microsoft Power BI...

Experience

Location

Auckland, New Zealand

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.

Employment

  • Business Intelligence | ETL Developer | Data Engineer

    2020 - PRESENT
    Toptal Clients
    • Worked on a report improvement project with Evolution Service Corporation. Used Python and Google Cloud functions to extract data from Typeform via RESTful API, then normalize, transform, and load data in Google BigQuery and create a Power BI report.
    • Handled a data processing and dashboard construction project with Contractor in Charge LLC. Used Zoho Analytics to build various dashboards, including call center concurrency, productivity, and billing.
    • Worked on the CRM and data analysis project with GrayHawk Home Care, using Microsoft SQL Server and .NET to build the CRM application, produce reports in Power BI, and provide data analysis.
    Technologies: SQL, Microsoft Power BI, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Azure SQL Databases, BigQuery, Data Warehousing, Python, Microsoft SQL Server, Google Data Studio
  • 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), Data Warehouse Design, 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), Data Warehouse Design, 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), Data Warehouse Design, 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, Data Warehouse Design
  • 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), Data Warehouse Design, WhereScape RED, SQL Server Reporting Services (SSRS), SAP BusinessObjects (BO), 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), Data Warehouse Design, 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: VB, Microsoft SQL Server, SQL Server DTS, SQL

Experience

  • 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

    Led and coordinated with team members to get data extracted from Salesforce and ServiceNow online platform into Azure SQL database with Azure Data Factory tool, using Power BI to connect to Azure SQL database and create reports to present Salesforce pipeline, new business win, contract analysis, ServiceNow incident, and SLA analysis.

  • Customer Dashboard Project

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

Skills

  • Languages

    SQL, Stored Procedure, C#.NET, VB.NET, ABAP, Java, JavaScript, Python
  • Tools

    Microsoft Power BI, Microsoft Excel, WhereScape RED, BigQuery
  • 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, Azure SQL Databases, PostgreSQL
  • Other

    Data Warehousing, SQL Server 2019, Data Engineering, Data, Architecture, Business Intelligence (BI) Platforms, Azure Data Factory, Azure Data Lake, SAP, Google BigQuery, Google Data Studio, Machine Learning, Oracle Autonomous Database Cloud, ServiceNow, Customer Success
  • Platforms

    Oracle, Salesforce
  • Libraries/APIs

    ServiceNow REST API

Education

  • Bachelor's Degree in Information Engineering
    2001 - 2005
    Central South University - Changsha, China

Certifications

  • Microsoft Certified: Azure Fundamentals
    NOVEMBER 2020 - PRESENT
    Microsoft
  • Machine Learning
    AUGUST 2020 - PRESENT
    Coursera
  • Oracle Autonomous Database Cloud 2019 Certified Specialist
    APRIL 2020 - PRESENT
    Oracle
  • Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
    NOVEMBER 2014 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others