lionell carlo

paquit

Data Nerd | Developer | Analyst | Problem Solver

Projects

Cash Flow Tracker

Link to project

  • Created an application that tracks personal cash flow using React.
  • NodeJS and Express were used as a web server for the application.
  • Added MongoDB database and Nginx for the proxy server.
  • Used Docker to run the application in container and docker-compose to automate docker configurations.
  • Configured docker-compose file for development and production.

Test Data Generator for Health Information Exchange

Link to project

  • Enhanced the design and functionality of the test data generator to generate data based on business requirements.
  • Added test data generator features: generate multiple patient Id, configurable population demographics profile and encounters (type, problems, diagnosis, admit and discharge information.
  • Deploy solution in AWS via jump host using an internal tool called Graviton.
  • Test and document the design and implementation of the test data generator.

Text Mining User-generated Reviews Posted on Glassdoor

Link to project

  • Created a web scraper using R packages like rvest and purrr to collect text data from Glassdoor reviews.
  • Saved into CSV and loaded the data into PowerBI for data cleaning.
  • Visualised the data using charts and word cloud to aid and elevate data analysis.

Predicting Customer Propensity Using Classification Algorithm

Link to project

  • Created a research proposal paper for conducting text analysis using Facebook comments from a shared video documentary regarding New Zealand’s aerial 1080 policy.
  • Received the Clare Atkins Research award.

Text Analysis on Social Media in Aid of Legislation or Policy Processes

  • Created a research proposal paper for conducting text analysis using Facebook comments from a shared video documentary regarding New Zealand’s aerial 1080 policy.
  • Received the Clare Atkins Research award.

Twitter Data Analysis

Shinny Apps Project Link.

  • Used twitter API to collect tweets from entered keyword.
  • Pre-processed and cleaned data for analysis.
  • Used ggplot2, twitteR and shiny packages in R.
  • Visualised the frequency of words using bar chart and word cloud.
  • Integrate R project into web application.

FinanceDB Data Warehouse

Finance Data Warehouse uploaded on github.

  • Created a finance data warehouse complete with dimensions and facts
  • Built the DDL Schema
  • Designed and implemented ETL pipeline using SQL
  • Populate date dimension using lubridate package in R
  • Visualized data on PowerBI (see sample visualisation here)

Contact

Experience

Software Engineer (Analytics)
Orion Health

Nov 2019 - Feb 2020

Analysed, designed and enhanced test data generator to aid the team’s efficiency in CI/CD processes. The data generator was used to create dummy data during the product demonstration for the Abu Dhabi client. Good understanding in Software Development Lifecycle in Agile environment. Worked with agile workflow environment – Kanban and Scrum practices. Actively participated in team’s stand-up meetings, kanban board, sprint reviews, retrospectives and demo (including PR based reviews and workflows). Used Jira to document and complete work tickets and support requests. Good understanding of Healthcare domain and electronic health record exchange – FHIR and HL7 international standard. Deployed solutions to AWS using automated configuration management tools – Puppet, Ansible and internal configuration tools. Experience with Visual Studio IDE + Git on Bitbucket Cloud for source control, code reviews and DevOps pipeline. Collaborated with the team in conceptualising, designing and the creation of solutions that bring values to the company. Participated in Tableau training workshop.

Rates Data Co-ordinator
Auckland Council

Aug 2019 - Nov 2019

Supporting the Rates department of Auckland Council- main duties includes: processing and analysing more than 9000 Rates rebate applications. Making executive decisions like approving or rejecting rebates application based on the rates rebate scheme guidelines. Analysing documentsprovided by the ratepayers as well as investigating their past applications and information. Issuing out postponement enquiries to ratepayers and performs other ad hoc duties as required for rates, valuations and general administration.

Education

Graduate Diploma in IT

2018

Nelson Marlborough Institute of Technology, New Zealand

  • Clare Atkins Research Award

NC II in Computer System Servicing

2017

Jose Maria College, Philippines

BS in Computer Science

2016

University of the Philippines in Mindanao, Philippines

Skills

SQL 90%
R 70%
Python 75%
Html & CSS 85%
PHP 70%
Data Analysis 80%
R&D 90%

About Me

An active learner who always seeks for new challenges in life. I started to develop this love in data science during  undergraduate degree final paper. It opened my eyes to what data can and can’t do at the present, and what it’s potential in the future dealing with real world problem. Let’s see what trend sets my life data will lead me into with the career path I have chosen.

Cash Flow Tracker
Xero Reviews Dashboard (PowerBI)
Arnel's Filipino Restaurant
Auckland Wool New Zealand
Novatec IT Solutions
Hendriks Leather

Anne O’Hanlon

Product Director – Analytics
Orion Health
Auckland, New Zealand

Malvin Leong

Product Owner – Analytics
Orion Health
Auckland, New Zealand

Krystle Lim

Manager Rates Department
Auckland Council
Auckland, New Zealand

Nick Burns

Founder & Data Scientist
Lingo Search & AI
Nelson, New Zealand

Todd Cochrane

Senior Lecturer: Digital Technology
Nelson Marlborough Institute of Technology
Nelson, New Zealand

Kristian Sylvest Jørgensen

CEO
Stampworld.com
Swieqi, Malta

Kia Ora! Are you also a data nerd like me? Get in touch by leaving a message here.

Close Menu