Hi, I’m Austin!
I am a personable, data-driven individual with a strong belief in utilizing data in the healthcare industry or biomedical informatics. With proven 1-year internship experiences in data analytics, I am well-versed in the applications of data in business settings through use of R , Tableau, Structured Query Language (SQL), Microsoft Excel and Python.
Presently, I am a healthcare data analyst, working part-time on operations data for BI at a healthtech firm alongside my college studies in the final-year of my Biological Sciences major studies in Nanyang Technological University.
Apart from work and studies, I also actively take on key student leadership roles. I am an avid self-learner and I enjoy exploring new skills. I also enjoy writing and have founded a data science & analytics skills blog - Anyinstructor.com. Through the several skills gained, I completed some personal projects in data science.
If any of my experiences and goals align with yours, feel free to contact me through email or through the buttons on the left.
Currently Seeking: Full-time Data Analytics/Data Science positions (Jun 2021 Onwards)
Download my resumé.
- Data Analytics
- Healthcare
- Business Intelligence
- Digital Marketing
Bsc in Biological Sciences, 2021
Nanyang Technological University
Diploma in Biomedical Science, 2015
Temasek Polytechnic
Skills
Experience
Achievements:
Automated data extraction from digital marketing and clinic data sources to Google Sheets, saving 10+ hours/week
Built 9 integrated Tableau dashboards from muilti-source data - app and clinic
Coded in Python & SQL to produce 5 monthly reports from MySQL database, reducing 200% in process time
Queried and processed NoSQL (MongoDB) app data for operations optimization
Monitor reporting of app-related metrics and KPIs on Google Sheets
Compiled ad-hoc reports from web-scraped data, app performance and HCW optimization
Tools used:
- Tableau, SQL, Excel, Python, MySQL, MongoDB, Google Sheets, Google Apps Script,
AnyInstructor.com - a self-started resource blog on data science & analytics
- Researched and wrote 30 data analytics-focused content articles to-date using Wordpress
- Drove >200 pageviews of website SEO organic traffic within 3 months
- Monitored and analyzed 13 weekly site performance reports using Google Analytics
- Worked on webpage design for landing pages
- Created 14 image/video content pieces on Instagram, Facebook and YouTube
- Tracked social media analytics for page growth
Tools Used:
- Wordpress, Google Analytics, Ezoic Ads, YouTube, Instagram, Facebook
Achievements:
- Initiated 6 interactive dashboards for clinic operations optimization and insight
- Built data pipelines to extract multi-source data for daily KPI metric dashboards using MySQL and Tableau
- Processed digital marketing data using Excel Pivot Tables and create digital marketing funnel reports
- Monitored ad campaign spend (SEM) data using Google Ads, Facebook Ads and UTM code tracking
- Conducted ad-hoc data analysis for cross-functional teams in operations, marketing and clinical
Tools used:
- Tableau, Excel, SQL, MySQL Workbench, Google Sheets, Power Query, Google Analytics, Sketch, Firebase Analytics, Google Ads, Facebook Ads and App Annie
Achievements:
- Built an automated medical inventory tracking system for >2000 PPE stock on Google Sheets
- Created a dashboard report using Pivot Tables and Vlookup for monitoring PPE inventory
- Operated clinic for health service delivery to 90-100 patients each week
- Ensured timely data collection for reporting over 6 weeks
- Collaborated with a 4-man team to draft 5 clinic quality improvements for the initial COVID-19 response
- Guided 15-20 volunteer healthcare workers on clinic processes
Tools Used:
- Google Sheets, Global Health Byte Clinic Management System
Research under Dr Wilson Goh’s Bio-Data Science and Education Laboratory [Meta-analysis of Schizophrenia Bio-data Using Data Science Approaches]
- Extracted 3 transcriptomic RNAseq expression datasets (9000+ rows each) using Bioconductor in R
- Preprocessed, cleaned and prepared microarray data in R
- Conducted statistical bootstrapping of 1000 T-test iterations for significance analysis
- Evaluated model using a Confusion Matrix and F score and presented data analysis findings using R Markdown
- Collaborated with a team of 8 bio-data scientist researchers
Tools Used:
- R, RStudio, RMarkdown, Bioconductor