Learn Data Skills
Beta
Nicholas Foo

Nicholas Foo

Senior Analyst

Easee

Technologies

My Portfolio Highlights

My New Project

Exploring NYC Public School Test Result Scores

My New Course

Introduction to Python

My New Project

Exploring NYC Public School Test Result Scores

Data painter, using visualization to bring insights to life.

My Work

Take a look at my latest work.

course

Data Manipulation with pandas

course

Introduction to Python

course

Intermediate Python

course

Data Manipulation with pandas

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Easee | Sep 2023 - Present

Senior Data Analyst

N/A

Easee | Sep 2022 - Sep 2023

Data Scientist

Data Scientist within the Data & Insights Team Primary Responsibilities: - -------------------------- 1. Developed the business case for Easee's participation within the Nordic Energy Flexibility Market. Performed the data aggregation (from the various power market data aggregators), cleansing and ingestion in order to: - a. Highlight the potential revenue (of the market as a whole, and for Easee) from market participation. This was visualised as simple numeric outputs and live-interactive Tableau dashboards b. Identify areas within the Nordics (and in turn, which companies) to begin engagement work with 2. Draw data insights from IoT data (generated by live in-production Easee products), to inform business decision. Specific insight specialisation: - a. charging pattern and behaviour (ie. when are vehicles charged, for how long, energy charging cycle, etc.) b. geospatial analysis (ie. geolocation and reverse geolocation of chargers, mapping visualisation) These insights relied on the deployment and maintenance of underlying data products (mature, intermediate and raw) on Databricks (via Notebooks or Dbt) 3. Support daily ad-hoc request (which range from commercial to IoT data enquiries). Based on the patterns of these request, implemented one of the following solutions (for ease of stakeholder usage and access): - a. Tableau dashboard (for common repeated requests) b. Scheduled Notebook/Queries with email notification (for request requiring weekly/scheduled data updates) c. Distributed Notebook/Queries (for 1-off requests, which can be rerun by members of my team or the stakeholder) Secondary Responsibilities: - ----------------------------- 1. Workplace mentorship of junior colleague undertaking Data Analytics apprenticeship 2. Development of proof-of-concept simulation work, to lay the groundwork for a new product feature. This specific project concerns the integration of an API endpoint and the development of a charging schedule algorithm.
Show More

Sojern | Apr 2021 - Sep 2022

Senior Data Analyst

Senior Data Analyst within the Travel Insights Team Responsibilities: - -------------------- 1) Designed and publish solution for automation of monthly travel reports 2) Inherited, maintained and improved on solution for generation of staging + production-level data models (using Airflow, hosted on Google Composer, as the orchestration tool), housed in Google BigQuery. Simplified the solution through the creation of custom functions, which required a simple JSON file to dictate the Airflow Job setup. 3) Supported internal stakeholders (sales, marketing & PR team) ad hoc requests through the generation of data narratives and custom visualizations. 4) Regular participants of travel webinars (utilizing data to illustrate current and projected travel trends)

EV Technology Limited | Aug 2019 - Apr 2021

Electric Vehicle Data Scientist

Principal data scientist and software developer. Data Science/Analytic Projects: - ------------------------------------ 1) Data visualisation of insightful electric vehicle telematic events for LinkedIn article posts 2) Custom fleet reports (heat maps, network analysis, safety & utilisation scoring) for customers 3) Development and deployment of electric vehicle range prediction model, using Machine Learning. Model has 95% prediction accuracy (60% improvement from previous range prediction models). Project involved the raw processing and cleansing of 200,000 miles of real-world data spanning 2 years. 4) Consultation recommendation report on the number and site choice for the installation of electric vehicle charging infrastructure (EVCI), using network analysis and location-allocation modelling. Model powered by real-world demographic and geographical data. 5) Automatic billing breakdown script for e-Mobility Service Providers (eMSP), to assist with reimbursements, pay-outs and cost-benefit analysis. Automate billing invoice process (that usually takes 1 week to produce) to a few seconds task (dependent on file size consumed). 6) Fleet and Charging Site Utilization Dashboard (new feature for web portal). Dynamically demonstrated utilization metrics (in graphical and table form) of a company's logistic assets. Built from scratch using PHP, Javascript, HTML, Bootstrap and Plotly. Software Development Projects: - ------------------------------------- 1) Charge Station Management Web-App 2) Cloud architecture design for deployed applications (on AWS) 3) Implementation of Open Charge Point Interface (OCPI) Protocol 4) Design, testing, deployment and maintenance of diagnostic tools for telematics dataset 5) Administration web portal (for interaction with a MySQL database, for non- technical users). 6) Deployment of SFTP Server with diagnostic support

EV Technology Limited | Sep 2018 - Jul 2019

Data Analyst Intern

- Primary responsibility:- 1. Data pre-processing (filtering, integration, formatting) and data storage 2. Data Visualization (multiple graphs formats, plotting on map images) 3. Machine Learning (developing model algorithm for predicting vehicle charge usage) 4. Deployment of Machine learning model as API on AWS Lambda 5. Network Analysis & Optimization using Numerical Methods - Current Achievements:- 1. Successful production of automated scripts for data processing, exportation and storage 2. Clear visualization of patterns in dataset, pulling out interesting case studies for business application & machine learning model development 3. Parameter identification for machine learning model development (using Principal Component Analysis & Correlation Matrix) 4. Successful deployment of machine learning model for predicting end battery level on AWS Lambda 5. Optimization of Charging Infrastructure usage through identification of best installation sites through Network Analysis - Active tools in work environment:- 1. Python (pandas, numpy, scipy, matplotlib, glob, math, folium, flask, scikit- learn) 2. MySQL Workbench 3. HTML 4. AWS Lambda 5. Microsoft Powerpoint 6. Microsoft Excel 7. Microsoft Word

UCL | Sep 2017 - Jun 2019

Masters Student

Completed Modules:- 1. Analytical & Numerical Methods 2. Environmental Modelling (produced simple global temperature model) 3. Global Environmental Change (developed environmental blog) 4. Masters Dissertation Current Modules Undertaking:- 1. Scientific Computing - includes web scrubbing for data to download 2. Environmental GIS 3. Climate Modelling 4. Surface Water Modelling 5. Terrestrial Carbon: Modelling and Monitoring

EcoKnights | Jun 2017 - Sep 2017

Volunteer

Volunteer for Klang Learning, Engagement & Action for Rivers (KLEAR) Group. Achievement includes:- • Pioneered usage of computer conceptual models for education outreach program • Initiated & lead river modelling project, producing a 3D river system model for education outreach program

University of Glasgow | Oct 2015 - Mar 2016

Master Dissertation Researcher

During my Life Science Investigative MSci Project, I conducted independent research on:- How food microflora on fresh salmon products change over the course of a week past the expiration date under refrigerated storage How different packaging conditions have an effect on the type of microflora found on expired salmon products Used combination of classical microbial and modern molecular techniques to identify microflora present

University of Stirling | Jun 2014 - Oct 2015

External Research Staff & Lab Technician

The third author of the journal article: Albalat, A., Nadler, L.E., Foo, N., Dick, J.R., Watts, A.J.R., Philps, H., Neil, D.M., & Monroig, O., 2016. Lipid Composition of Oil Extracted from Wasted Norway Lobster (Nephrops norvegicus) Heads and Comparison with Oil Extracted from Antarctic Krill (Euphasia superba). Marine Drugs. 14(12): 219. DOI: 10.3390/md14120219. Conducted independent research on:- Seasonal change in fatty acid profile in the head waste material of Nephrops norvegicus Rate of oxidation of Nephrops head waste under different storage conditions Incorporation of fatty acids from Krill and Nephrops oil into human muscle cells, & how it protects against muscle wasting (induced by dexamethasome) Lipid and fatty acid analysis on commercial samples Produced a literature review on Omega-3 research on Nephrops & Detailed Research Report Outlining Findings of Research.

My Education

Take a look at my formal education

Data Science(DS) Professional Certificate Program, Data ModelingHarvard University | 2021
Master in Science, Environmental Modelling UCL | 2019
Codecadmy Pro , Data analysisCodeAcademy Pro | 2019
Master in Science, Marine and Freshwater Biology The University of Glasgow | 2016

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free