Lincoln is available for hire
Hire LincolnLincoln 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, SQL Server Integration Services (SSIS)...
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
- Used Power BI and produced data analysis from various perspectives to analyze the Cyber Security 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.
- Contributed to 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 patient and healthcare data analysis dashboard.
- Worked on a report project with Evolution service corporation (US). Used Python and Google Cloud Platform, designed an end-to-end solution to extract data from Typeform via a RESTful API, transform and load data in Google BigQuery, and provide data insights in Power BI.
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), 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
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, Excel VBA, C#.NET, VB.NET, ABAP, Java, JavaScript, Python, Snowflake
Tools
Microsoft Power BI, Microsoft Excel, WhereScape RED, BigQuery, Microsoft Power Apps, Microsoft Access
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, Database Administration (DBA)
Other
Data Warehousing, SQL Server 2019, Data Engineering, Data, Architecture, Business Intelligence (BI) Platforms, DAX, Data Analysis, Data Visualization, Analytics, Excel Macros, Azure Data Factory, Azure Data Lake, SAP, Google BigQuery, Google Data Studio, Machine Learning, ServiceNow, Customer Success
Platforms
Oracle, Azure SQL Data Warehouse, Microsoft Power Automate, Dedicated SQL Pool (formerly SQL DW), Oracle Autonomous Data Warehouse, Salesforce
Libraries/APIs
ServiceNow REST API
Education
2001 - 2005
Bachelor's Degree in Information Engineering
Central South University - Changsha, China
Certifications
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
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