Tiger Li, Developer in Honolulu, HI, United States
Tiger is available for hire
Hire Tiger

Tiger Li

Verified Expert  in Engineering

Bio

Tiger has 25 years of experience in database development and administration and IT project management. He has implemented large-scale system integrations and business intelligence (BI) projects in various industries, including retail, government, and education. His expertise spans SQL Server, MySQL, Oracle, Access, SSAS, SSRS, SSIS, Power Apps, Power BI, C#, VB.NET, Delphi, PHP, and Java. As the sole DBA at a retail company, Tiger helped boost sales from $5 million to $15 million in four years.

Portfolio

CoralMED
MySQL DBA, SQL, Microsoft Power BI...
Office of Hawaiian Affairs
SQL Server DBA, SQL Server BI, Microsoft Power BI, Apps, SharePoint...
Crazy Shirts
Enterprise Data Warehouse (EDW), SQL Server Integration Services (SSIS)...

Experience

  • SQL Server DBA - 20 years
  • SharePoint - 12 years
  • ETL - 10 years
  • IT Project Management - 10 years
  • Office 365 - 8 years
  • SQL Server Reporting Services (SSRS) - 8 years
  • SQL Server Analysis Services (SSAS) - 5 years
  • Apps - 4 years

Availability

Part-time

Preferred Environment

Windows, SQL Server DBA, Office 365

The most amazing...

...thing I've done is help a local retail company increase its sales from $5 million to $15 million in four years as the sole database administrator (DBA).

Work Experience

Database Manager

2024 - 2024
CoralMED
  • Developed a learning management system (LMS) for the company's medical training.
  • Managed IT projects and developed and maintained company databases.
  • Used Jira, MySQL, SQL Server, Google Cloud Platform, Microsoft Power BI and Microsoft Power App.
Technologies: MySQL DBA, SQL, Microsoft Power BI, Healthcare Effectiveness Data and Information Set (HEDIS), Dashboards, Microsoft Access

Information Systems & Records Management Manager

2013 - 2024
Office of Hawaiian Affairs
  • Administered SQL Servers, Microsoft Access, and SharePoint. Developed forms in SharePoint and BI solutions using SSIS, SSRS, and SSAS.
  • Implemented Power Apps and Power BI applications. Led initiatives such as Office 365 migration, MFA, Next Generation Networks (NGN) connection, Oracle Fusion, and cloud conversion projects.
  • Managed IT projects from planning and budgeting to design, implementation, debugging, documentation, training, and communication with stakeholders and 3rd-party vendors.
  • Led key projects such as Arctic Wolf Managed Detection and Response (MDR), networking infrastructure upgrade, Teams Voice implementation, and cloud migration for all OHA servers and the Portfol loan management platform.
  • Cleansed and upgraded the Native Hawaiian Registry Program, worked on the OHA Travel App, facilitated work-from-home software and hardware transitions during COVID-19, and established the State NGN connection to the OHA Office.
Technologies: SQL Server DBA, SQL Server BI, Microsoft Power BI, Apps, SharePoint, IT Project Management, ETL, C#.NET, PostgreSQL, SQL, Data Visualization, Google Cloud Platform (GCP), Python, Data Engineering, Data Reporting, Database Administration (DBA), Data Pipelines, Microsoft SQL Server, Query Optimization, Query Plan, Azure, Data Warehousing, Data Governance, Data Management, SPSS, R, Data Architecture, Data Monetization, Data Strategy, Salesforce, Snowflake, Amazon Web Services (AWS), Data Build Tool (dbt), Data Science, Data Analytics, SAP ERP, Testing, APIs, T-SQL (Transact-SQL), SSAS, User Experience (UX), User Interface (UI), Database Modeling, Database Partitioning, Azure SQL Databases, Cloud Migration, Databases, Reporting, Azure Data Factory, Data Migration, Excel VBA, Spreadsheets, Microsoft Excel, Excel 2016, Visual Basic for Applications (VBA), Excel Add-ins, Exploratory Data Analysis, Data Analysis, Data Deletion, CSV, Communication, Complex Data Analysis, Pattern Analysis, C#, Entity Framework, Healthcare Effectiveness Data and Information Set (HEDIS), Tableau, Dashboards, Microsoft Access, Excel Macros, Web Dashboards, SFTP, BigQuery, Excel 365

Senior Database Administrator

2009 - 2013
Crazy Shirts
  • Supported and maintained eCommerce production SQL Server and Oracle databases. Developed and maintained custom intranet reports with SSRS for all departments and executives, including OLAP cubes with SSAS.
  • Planned, designed, and implemented the ETL process with T-SQL and PL/SQL and coordinated and implemented the Raymark Point of Sale (POS) integration.
  • Managed projects and integrated data with offshore vendors such as Google, ChannelAdvisor, Experian, MarketLive, and USA800. Supported networking, servers, client PCs, and POS systems.
Technologies: Enterprise Data Warehouse (EDW), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL, SQL, Data Visualization, Data Modeling, Data Engineering, Data Reporting, Database Administration (DBA), Data Pipelines, Microsoft SQL Server, Query Optimization, Query Plan, Data Warehousing, Data Governance, Data Management, Data Architecture, Data Monetization, Data Strategy, Big Data Architecture, Data Build Tool (dbt), Data Science, Data Analytics, Testing, T-SQL (Transact-SQL), SSAS, SSIS Custom Components, User Experience (UX), User Interface (UI), Database Modeling, Database Partitioning, Oracle, Databases, Reporting, Data Migration, Excel VBA, Spreadsheets, Microsoft Excel, Excel 2016, Visual Basic for Applications (VBA), Excel Add-ins, Data Analysis, Data Deletion, CSV, Communication, Complex Data Analysis, Pattern Analysis, Dashboards, Microsoft Access, Web Dashboards, SFTP

Database Administrator – IT Specialist V

2007 - 2009
Office of Enterprise Technology Services State of Hawaii
  • Administered MS SQL server, Oracle, MySQL, and PostgreSQL databases.
  • Developed and maintained Hawaii's statewide request system and service-oriented architecture experimental project.
  • Handled system administration on Linux and Windows servers, MVS, and VMware and developed and maintained departmental Wiki sites using Drupal and WordPress.
Technologies: SQL Server DBA, MySQL DBA, Servers, SQL, Data Visualization, PHP, Data Reporting, Database Administration (DBA), Data Pipelines, Microsoft SQL Server, Query Optimization, Query Plan, Data Warehousing, Data Management, Data Architecture, Data Strategy, Data Science, Data Analytics, Testing, T-SQL (Transact-SQL), Linux, SSAS, SSIS Custom Components, User Experience (UX), User Interface (UI), Database Modeling, Database Partitioning, Databases, Reporting, Data Migration, Excel VBA, Spreadsheets, Microsoft Excel, Excel 2016, Visual Basic for Applications (VBA), Excel Add-ins, Exploratory Data Analysis, Data Analysis, CSV, Communication, Complex Data Analysis, Pattern Analysis, C#, Entity Framework, Dashboards, Microsoft Access, Excel Macros, Visual Basic, Web Dashboards

IT Specialist

2005 - 2007
Hawaiʻi State Legislature
  • Developed applications on legislative automation systems using the .NET package.
  • Supported LAN, WAN, and wireless networks, including computer software and peripherals.
  • Created and conducted IT training courses and sessions. Designed and maintained accounting databases using Access and SQL Server for the House of Representatives.
Technologies: C#.NET, AccessData, SQL, Database Administration (DBA), Microsoft SQL Server, Data Management, Data Analytics, Testing, T-SQL (Transact-SQL), Linux, User Interface (UI), Databases, Reporting, Excel VBA, Spreadsheets, Microsoft Excel, Visual Basic for Applications (VBA), Excel Add-ins, Exploratory Data Analysis, Data Analysis, CSV, Communication, Complex Data Analysis, Pattern Analysis, C#, Entity Framework, Microsoft Access, Excel Macros, Visual Basic, Web Dashboards

Software Engineer

2001 - 2005
University of Hawaii at Manoa
  • Analyzed client requirements, synthesized experimental data, and designed computing algorithms.
  • Implemented algorithms in Delphi, VB.NET, C#, Java, ASP on Windows, Palm, and web-based applications.
  • Managed the departmental computer lab and supported the networking and video conference service.
Technologies: SQL Server DBA, Delphi, Java, SAS, SQL, Microsoft SQL Server, Data Management, T-SQL (Transact-SQL), Linux, User Interface (UI), Databases, Spreadsheets, Microsoft Excel, Visual Basic for Applications (VBA), CSV, Pattern Analysis, C#, Microsoft Access, Excel Macros, Visual Basic

Crazy Shirts Raymark System Integration

http://www.crazyshirts.com/
A system integration project with Raymark Point of Sale. The project includes order fulfillment, payment processing, loyalty, CRM, merchandising, warehousing, and planning modules, which I implemented with SQL Server 2008, SharePoint 2010, XML, SSIS, SSRS, and SSAS.

It was used by Crazy Shirts' cashiers, company managers, and executives in physical and online stores. The implementation helped online and in-store sales grow consistently by double digits.

Nutrient Management Support System (NuMaSS)

https://pdf.usaid.gov/pdf_docs/pnada473.pdf
A system that provides decision aids on soil constraints diagnostics and management practices based on localized agronomic and environmental conditions.

Technologies used include Delphi, C, Java, SuperWaba, and Multilingual Engine. The software supports languages like English, French, and Portuguese and is still in use and downloadable at the USDA portal.

OHA Travel App

Worked on different aspects of an app, including travel profile registration, booking, post-travel invoicing and reporting, and an approval workflow. This app can be run in browsers and on mobile devices. It is widely used by all employees and external guests. It is 100% paper-free and has an automatic approval routing workflow and built-in reporting.
1998 - 2002

Master's Degree in Information and Computer Science

University of Hawaii at Manoa - Honolulu, HI, USA

APRIL 2023 - PRESENT

Artificial Intelligence: Implications for Business Strategy

MIT Sloan School of Management

SEPTEMBER 2015 - PRESENT

Implementing a Data Warehouse with Microsoft SQL Server

Microsoft

OCTOBER 2008 - PRESENT

Microsoft Certified Professional

Microsoft

Libraries/APIs

Entity Framework

Tools

SQL Server BI, Microsoft Power BI, SSAS, Spreadsheets, Microsoft Excel, Excel 2016, Microsoft Access, Query Plan, Tableau, BigQuery, SPSS, Microsoft Power Apps, Visio

Languages

Delphi, SQL, Python, T-SQL (Transact-SQL), Excel VBA, Visual Basic for Applications (VBA), C#, Visual Basic, Java, C#.NET, PHP, Snowflake, SAS, JavaScript, R

Paradigms

ETL, Testing, Agile Software Development

Platforms

SharePoint, Azure, Salesforce, Oracle, Windows, Amazon Web Services (AWS), Linux, AccessData, Google Cloud Platform (GCP), SharePoint 365

Storage

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

Other

Relational Database Design, Data Visualization, Data Modeling, Data Engineering, Data Reporting, Query Optimization, Data Warehousing, Data Strategy, Data Science, Data Analytics, APIs, User Experience (UX), User Interface (UI), Reporting, Azure Data Factory, Data Migration, Excel Add-ins, Exploratory Data Analysis, Data Analysis, Data Deletion, CSV, Communication, Complex Data Analysis, Pattern Analysis, Dashboards, Excel Macros, Web Dashboards, SFTP, Excel 365, Office 365, Apps, IT Project Management, Enterprise Data Warehouse (EDW), Data Warehouse Design, Data Governance, Data Management, Data Architecture, Data Monetization, Data Build Tool (dbt), SSIS Custom Components, Database Partitioning, Cloud Migration, Artificial Intelligence (AI), MySQL DBA, Servers, Big Data Architecture, SAP ERP, Healthcare Effectiveness Data and Information Set (HEDIS)

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