Tiger Li
Verified Expert in Engineering
Database Developer
Honolulu, HI, United States
Toptal member since August 8, 2024
Tiger has 25 years of experience in database development, SharePoint administration, and IT project management. He's implemented large-scale system integrations and 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
Experience
- SQL Server DBA - 20 years
- Governance - 12 years
- SharePoint - 12 years
- SharePoint OOTB - 12 years
- ETL - 10 years
- SharePoint Online - 9 years
- SQL Server Reporting Services (SSRS) - 8 years
- Office 365 - 8 years
Work Experience
IT Manager
State of Hawaii Department of Health
- Directed all IT operations across the division, including infrastructure management, cybersecurity, hardware, and software.
- Maintained and optimized AMHD SharePoint sites and managed SQL Server databases, including the Electronic Health Record (EHR) data warehouse. Led the development and delivery of clinical and operational reporting via Power BI and SSRS.
- Managed enterprise-level IT initiatives aligned with agency objectives and HIPAA regulatory standards., Supervised and mentored cross-functional teams across project development and technical operations.
IT Manager
Hawaii Employers Council
- Implemented inter-departmental workflows, including series approvals.
- Generated financial reports and CRM reports with Apprisoft, a popular CRM system for nonprofit organizations.
- Developed an IT ticketing system with Microsoft Power Automate and Planner app.
Database Manager
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.
Information Systems & Records Management Manager
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.
Senior Database Administrator
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.
Database Administrator – IT Specialist V
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.
IT Specialist
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.
Software Engineer
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.
Project History
Crazy Shirts Raymark System Integration
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)
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
Education
Master's Degree in Information and Computer Science
University of Hawaii at Manoa - Honolulu, HI, USA
Certifications
HIPAA Compliance Certificate
DOH
Artificial Intelligence: Implications for Business Strategy
MIT Sloan School of Management
Implementing a Data Warehouse with Microsoft SQL Server
Microsoft
Microsoft Certified Professional
Microsoft
Skills
Libraries/APIs
Entity Framework, Complex SQL Queries
Tools
SQL Server BI, Microsoft Power BI, SSAS, Spreadsheets, Microsoft Excel, Excel 2016, Microsoft Access, Smartsheet, Query Plan, Microsoft Power Apps, Tableau, BigQuery, SPSS, Visio
Languages
Delphi, SQL, Python, Transact-SQL (T-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, HIPAA Compliance, Fast Healthcare Interoperability Resources (FHIR)
Platforms
SharePoint, Azure, Salesforce, SharePoint 365, Oracle, SharePoint OOTB, Windows, Amazon Web Services (AWS), Linux, Microsoft Power Platform, AccessData, Google Cloud Platform (GCP), Azure PaaS
Storage
SQL Server DBA, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Database Administration (DBA), Data Pipelines, Microsoft SQL Server, Databases, SQL Stored Procedures, SQL Server Analysis Services (SSAS), Database Modeling, Azure SQL Databases, Database Caching, PostgreSQL, MongoDB, NoSQL
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 (ADF), Data Migration, Excel Add-ins, Exploratory Data Analysis, Data Analysis, Data Deletion, CSV, Communication, Complex Data Analysis, Dashboards, Excel Macros, Web Dashboards, SFTP, Excel 365, Microsoft OneDrive, SharePoint Administration, SharePoint Online, Governance, Government, Microsoft 365, Database Optimization, Agile Project Management, Software Implementation, Scrum Master, 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, EMR, CTO, Fractional CTO, Quality Management Systems (QMS), SAP, Electronic Health Records (EHR), Behavioral Health, Artificial Intelligence (AI), MySQL DBA, Servers, Big Data Architecture, SAP ERP, Healthcare Effectiveness Data and Information Set (HEDIS), Customer Relationship Management (CRM), Electronic Health Records (EHR), HIPAA Electronic Data Interchange (EDI)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring