Hello, I'm
Louis
Data Analyst
Key Skills
Python
Numpy, pandas
Scikit-learn, TensorFlow
Matplotlib, seaborn
SQL
Joining tables
Window functions, Aggregation
Subqueries
Data Skills
Data Wrangling
Data Visualization
Exploratory Data Analysis (EDA)
Machine Learning (ML)
Linear and Logistic Regressions
Decision Tree, Random Forest, XGBoost
Cluster Analysis, K-Means, DBScan
PowerBI
DAX (Data Analysis Expressions)
Power Query
Data Modeling
Data Connectivity (SQL, Excel, Web APIs)
Microsoft 365 Tools
Excel - Pivot Tables, VLOOKUP / XLOOKUP, VBA
Powerpoint, Word
Outlook
About Me
1+ Years Technology Consultant/Data Analyst MSc with Distinction
Analyst and Consultant with experience spanning the export, legal, and technology sectors. At one of Vietnam’s top exporters, I developed statistical models to forecast regional and international market trends. In a recent side project, I contributed to Trellis, an AI-powered tool developed through the Scottish Government’s CivTech initiative to ease the administrative burden on Additional Support Needs (ASN) teachers. There, I helped develop AI/ML models that improved output accuracy from 50% to 83%. I currently work as a Business Technology Consultant at an American legal tech firm, delivering AI-driven and automation solutions that have reduced document processing time by 70% and increased client team productivity by 3.1x.
Portfolios
Machine Learning Project with Clustering Analysis (Python)
This project applies unsupervised learning using K-Means clustering to segment customers based on real-world marketing campaign data from Kaggle (2,240 records). The goal was to identify distinct customer groups using demographic and transactional attributes to support targeted marketing and resource optimization. The process included data cleaning, feature engineering (e.g., tenure, total spend, family size), encoding categorical variables, and standardizing numerical features. K-Means was then used to uncover patterns in customer behavior and define meaningful segments.
Brazilian E-Commerce Data Analysis (SQL & PowerBI)
A comprehensive analysis of 100,000+ orders from a leading Brazilian e-commerce platform (2016–2018) was conducted to uncover insights into customer behavior, delivery efficiency, product performance, and regional demand. The project involved end-to-end execution, from data preparation using MS SQL to developing an interactive Power BI dashboard which enabled data-driven decisions across marketing, operations, and sales teams.
Projects
Dissertation project with NHS (Score: 75/100)
An 8-week collaboration with NHS Lanarkshire focused on enhancing the efficiency and quality of Chronic Disease Monitoring (CDM) services in Community Treatment and Care (CTAC). Using Strategic Options Development and Analysis (SODA) and Cognitive Mapping, key pain points were identified through stakeholder interviews. A data-driven needs assessment highlighted three priority areas: IT systems, skill mix, and treatment room services. To align strategic goals, 48 KPIs were developed using the Balanced Scorecard framework, with an added innovation perspective to support long-term service improvement.
Certificates
Code In Place - Stanford University
Programming Skills: Python Programming, Problem Solving, Algorithmic Thinking
Course Details: Selected from over 66,000 applicants worldwide to complete Stanford’s CS106A: Programming Methodology, a 6-week intensive introduction to computer science.
The VR Superstore Company - Certificate of Completion for 3-month Data Analyst role
Data Skills: Web Scraping & Data Collection, Large Dataset Handling, Data Pipeline Development
Machine Learning: Linear and Logistic Regressions, Random Forest, Neural Network, Cluster Analysis
Strath Inspire - Top 10 start-ups entered the second round
Data Skills: Developing user-centric web/apps, Building pipelines for data acquisition, Analyzing market trends
Other Skills: Communicating data-driven insights to stakeholders
Hobbies
Hanging out with friends
Rowing
Traveling
Gmail: nguyensyhien011201@gmail.com
Mobile: 07853771075