Justin Tan

About Justin Tan

25 years of comprehensive IT experience in data modeling, data warehousing, database design, development, implementation, reporting, automation, support, and business intelligence. Proficient in writing complex T-SQL queries, custom stored procedures, and functions to implement back-end business logic and processes for data extraction, reporting, and client interfaces. Experienced in developing ETL pipelines using dynamic SQL, CTEs, complex joins, window functions, temporary tables, and cursors. Proficient in using Python to build scheduled ETL processes from multiple data sources, including flat files, ElasticSearch, APIs, and various databases. Able to transform customer data into highly detailed visualizations, dashboards, and reports for decision-making. Proficient in performance tuning using execution plans, SQL Profiler, and Database Engine Tuning Advisor. Proficient in developing and maintaining SSIS packages for importing and transforming data between external data sources and databases. Experienced in supporting Microsoft Azure systems, including SQL Server and Azure SQL Database hosted on Azure Virtual Machines. Proficient in deploying, maintaining, and troubleshooting applications on Azure cloud infrastructure. In-depth understanding of the Software Development Lifecycle (SDLC). AI and Machine Learning Experience: Applied machine learning techniques (e.g, regression, classification, clustering, and anomaly detection) for predictive analytics and data-driven insights. Developed AI-driven data processing workflows to automate anomaly detection and trend prediction in large datasets. Integrated natural language processing (NLP) for unstructured data analysis, including sentiment analysis and text classification. Leveraged Python-based AI frameworks (TensorFlow, PyTorch, Scikit-learn) to build and deploy proof-of-concept models. Implemented AI-driven recommendation systems and predictive models to enhance business intelligence reporting. Researched and tested Large Language Model (LLM) APIs and generative AI tools for data ingestion, aggregation, and reporting automation.

Experience

1. Lead Data Scientist

   Tableau

   Aug 2020 — Present

Education

• Nanyang Technological University Singapore

  Master's degree

  1996 — 1999