Andres Camilo Viloria Garcia

Data Scientist | Data Analyst

Projects

External Projects: This showcases projects I’ve completed in collaboration with companies. Personal Projects: Personal projects I’ve undertaken independently.

Automated Report Generation

In this project, our team developed an automated report generation system using Python and Django, which extracts data from the OLAP datastore Apache Pinot. The goal was to create a user-friendly web application that streamlines the reporting process, providing real-time insights and analytics.

Dashboard in Power Apps

In this project, our team developed a Power BI app for data management of a Healthcare company aimed to serve as a reliable resource for sustem administration and technical support staff, enabling them to understand, manage, and resolve issues related to the system efficiently.

Captone Project IBM (SpaceX dataset)

As a Data Scientist, I will be employed by a startup with the goal of competing with SpaceX, and in the process, the Data Science methodology will be followed, which includes data collection, data wrangling, exploratory data analysis, data visualization, model development, model evaluation, and reporting of results to stakeholders.

COVID-19 Open Research Dataset Challenge (CORD-19)

The analysis aims to understand the CORD-19 dataset, extract insights using text mining (NLP and Topic modeling), evaluate risk factors, and present findings for COVID-19 research.

Exploratory Data Analysis (EDA) with R

Exploratory data analysis of two datasets Car Evaluation and Hollywood Movies (using R) .

Detection of illicit activities

It was used machine learning and Data transformation to detect ilicit activities in a marketing, transportation and selling of certain kind of products.

London Energy Consumption (SmartEnerx Dashboard)

An entire Data Science project was developed, generating a visualization dashboard built with Dash-Python for the forecast of energy in London for the coming months.

Data Visualization in Power BI

Data source- Server Analysis Services (SSAS)

Shortage of a product

Identify through statistical methods whether next period of time there will be any shortage of a product

Extraction, Transformation and Load (ETL) project

Using SSIS to transform data into business context reference.

Web Development

Using Java,CSS,JavaScript,html and SQL

Accomplishments

Convocation Speecher

Langara College Jun 2024 – Jun 2024

Delivered the convocation speech for our convocation representing the DataAnalytics program and Faculty of Science.

Dean’s Honour Roll

Langara College Sep 2023 – Dec 2023

Langara College Faculty of Science is proud to present this certificate for outstanding academic achievement in Data Analytics.

See certificate

IBM Data Science Professional Certificate, 8-12 months

Coursera Sep 2023

ACE ID:IBM-001 The program consists of 10 online courses that provides with the latest job-ready tools and skills, including open source tools and libraries, Python, databases, SQL, data visualization, data analysis, statistical analysis, predictive modeling, and machine learning algorithms. It was used data science through hands-on practice in the IBM Cloud using real data science tools and real-world data sets.

See certificate

Data Science for All (375 hours)

Correlation One Apr 2022 – Jul 2022

The certificate earner has graduated from the Data Science For All (DS4A). They are ready for a career in data science and have learned how to work with Jupyter notebooks, use Python libraries to generate data visualizations, perform exploratory data analysis, and analyze data using Pandas. They also learned the use of different Data Science and AI techniques, such as Decision Trees and the use of kNNs, CNNs, NLP, along with how to practically utilize them.

See certificate

Badges

10 Digital credencials

These credentials earned demonstrates hands-on proficiency in applying Data Science concepts to a real world inspired challenge. The earner can follow the data science methodology involving problem definition, data collection, data wrangling, exploratory data analysis, data visualization, model development, and model evaluation. The individual has also demonstrated proficiency in documenting their work and preparing a full formal data science project report.