My name is Poon Athit, a Data Analyst with a comprehensive background in Business analytics, B2B Sales & Marketing, and Consulting. Expert in data-driven solutions, dashboarding, machine learning, compliance, etc. Committed to transforming data into strategic insights that fuel business success and performance.

Database & BI:

• Tableau (Advanced Dashboarding, Complex Calculations & Parameters)
• SQL (Advanced Data Queries)
• Snowflake (Complex Views, Automations, Snowpark, API Extractions)
• FiveTran (Diverse Data Extractions, DBT Data Transformations)

Data Analytics & ML:

• Python & R:
  • Machine Learning (sklearn, xgboost, tidymodels, Hyperparameter Tuning Optimisation, Interpretability Analyses)
  • Data manipulation (pandas, dplyr, Parallel Programming, Feature Engineering, Pre-Process)
  • API (Advanced API Packaging, Asynchronous, Loggings)
  • Optimisation (scipy Optimize)
  • Unit Test (unittest Framework)

Software Development:

• Jira (Software Development Lifecycle Management)
• GitLab (Version Controls, Package Developments, QA Frameworks)

CRM & Marketing Automation & Marketing Tools & Channels:

• Salesforce, Microsoft Dynamics 365, Adobe Marketo, Pardot
• Google Analytics 4, Google Ads, Instagram, Email Marketing, LinkedIn, Facebook, Pardot Landing Page, etc.

	Marketing Technology Consulting Projects [Python, SQL, Tableau, FiveTran, Automations, MarTech] Project Date: 2023/2024 This repository showcases various projects completed during my tenure with a leading marketing technology consulting firm. These projects encompass dashboarding, data auditing, data remediation, and consulting efforts to optimize marketing strategies and platform.
	Opportunity Prediction [Python, Machine Learning, Data Manipulation] Project Date: 2022 Develop 3 machine learning models focused on predicting business opportunities, enhancing the firm's revenue forecasting capabilities.This project was conducted in collaboration with a leading marketing technology consulting firm.
	Mountain Project - Climbing Community Website Analysis [SQL Server, Tableau] Project Date: 2022 Analysis of "Mountain Project" which is one of the largest climbing-related websites in the world, by using SQL for data manipulation and Tableau dashboard for presenting insights.
	Automatic cross validation forecasting model [R, cross-validation, Error measures, forecast] Project Date: 2021 Automatic model for batch forecasting (forecast large amount of time series), using Cross validation algorithm as a model selection strategy.
	Departure Delay Analysis on NYC flight in 2013 [R, Tableau, tidyverse] Project Date: 2021 Data analysis on New York flights in 2013 to find the relationship between the departure delays and other factors, by using R to produce the analytics part and Tableau for the dashboard.
	Heuristic competition for modified CVRP [VBA, constructive heuristics, local search algorithms, meta-heuristics] Project Date: 2022 A competition among MSc Business Analytics cohorts to build the best 3 heuristic models to solve modified Capacitated Vehicle Routing Problem (CVRP) in VBA.
	Railway decision support system [VBA, User forms, Excel-Macros] Project Date: 2021 The decision support system for calculating railway maximum flows when there is an event or incident that requires a large number of trains to be transferred from one origin to one destination.