Christian Castillo | Supply Chain Analyst at Globe Telecom

Christian Castillo

Supply Chain Analyst at Globe Telecom

Based in Manila, Philippines

About

I graduated in Electronics Engineering at Universidad de Manila, with focus on Data Analytics. I am a dedicated data enthusiast passionate about leveraging insights to drive impactful decisions. Within this showcase, you’ll find a compilation of my diverse dashboard and data projects (Tableau, Looker, and Power BI), each meticulously crafted to distill complex information into clear, actionable visuals.

Skills

Projects

Covid Dashboard (Jan 2020 – April 2021 Data)

This is my first tableau project, using the COVID data from Our World in Data. Data used for this dashboard are processed using SQL. This tableau dashboard shows the key metrics and insights surrounding the COVID-19 pandemic. Note: Sample data extracted are until April of 2021.

Order and Sales Dashboard

This is a looker studio dashboard showing key metrics like no. of sales, orders, customers, trends for the orders and sales per month. Data used for the dashboard is stored in google sheets. Sample data is extracted from Kaggle.

Using SQL To Clean Data - Nashville Housing

Performed data cleanup using various SQL functions to: 1. Standardize date format. 2. Populate NULL values with correct data. 3. Breaking out address into individual columns. 4. Change values of a column for it to be uniformed. 5. Remove duplicates. 6. Remove unused columns.

Experience

2021-Present

Supply Chain Analyst

• Comprehensive management of warehouse data, from initial planning and purchase request (PR) creation to purchase order (PO) creation, manufacturing, delivery, and material issuance. • Uses Google Sheets and SQL to establish connections across various databases to automatically generate materials forecasts and ascertain build requirements, ensuring effective inventory management. • Developed insightful dashboards that facilitate the visualization and analysis of crucial data points, contributing to informed decision-making processes, via Looker Studio (former Google Data Studio). • Adhoc tasks as required by the role

Education

2011-2017

Electronics Engineering at Universidad de Manila

PRC Licensed Electronics Engineer