Christopher Stephen Data Analytics Portfolio

Data Analyst

PT Global Yimi Cargo

April 2024 - Mar 2026

• Responsible and monitored logistics daily performance KPIs of on-time pickup, packages transit, distribution and delivery across multiple regions.
• Developed Python-based ETL pipelines in Jupyter Notebook and Pentaho to streamline the process of the cleaning, validation, and transformation works of multiple Excel-based datasets, and load structured data into databases for downstream analytics and reporting.
• Built interactive dashboards in Excel, Power BI, and Tableau, enabling real-time visibility into performance, breaches, and bottlenecks.
• Provided ad hoc analytical support for management requests.
• Worked together with Operations, Marketing team to investigate SLA breaches, coordinate corrective and preventive actions, and ensure timely resolution of service failures.
• Delivered training and ongoing support to area on KPI monitoring report logic, dashboard navigation, and data best practices.

Data Analyst

PT Tata Metal Lestari

Aug 2022 - Aug 2023

• Created and monitored the dashboards for Delivery and Sales department by using visualization tools (Tableau, Metabase).
• Performed the query in company's database by using relation database management software (PostgreSQL).
• Used Openbravo (ERP software) to see the raw data and performed data extraction for further understanding of its insight by using Excel.
• Used VBA to automate daily monitoring of inventory stocks.

Data Analyst Associate (Intern)

PT Revolusi Cita Edukasi

Jun 2022 - Aug 2022

• Performed query to the raw data in Google Cloud Platform for gaining initial insights and extraction for data cleaning process.
• Performed data cleaning and data analysis by using Pandas and Numpy.
• Used Tableau, Matplotlib and Seaborn library for data visualization.
• Made a presentation of the final report in front of stakeholders.

Project Coordinator

PT Mayora Indah Tbk

July 2019 - May 2022

• Made timetable for each projects and controlling the time needed for each process.
• Handled various internal administration works of products that currently in development process, e.g: create new products code, apply new barcodes, make workflow approval / review of products that will be developed etc.
• Conducted communication with Chinese staffs about the design and text of products that currently in development and to make sure it complies to China regulations.
• Checked and verified the color aspect of supplier proof-print.
• Conducted communication with suppliers about samples for trial, proof-print, delivery time of packaging materials.
• Supervised the trial progress of packaging samples on the factory.
• Made weekly reports progress to head supervisor.
• Set the first production timeline of product to factory and make sure all the needed packaging materials are already available in factory for production.
• Handled consumers complaints.

Assistant Operations Manager

Ding Chang Group

Sep 2018 - Jul 2019

• Carry through interviews, filtering and do recruitment works of heavy machine operator.
• Managed allocation work sites for operator.
• Organized the carriage of heavy machines from site to site.
• Coordinated worker transportation, accommodation from headquarter to site.
• Made a monthly visit to various site, to understand better the actual situations, problems on the site.
• Made a weekly report to supervisor.
• Managed and controlled workers food allowances.
• Organized workers on off working times.
• Conducted verbal translations in meeting with Chinese staff and local employee or customer.

Nanjing University of Aeronautics and Astronautics

Bachelor Degree in Aeronautical Engineering (Aircraft Design and Engineering)

Sep 2012 - Jun 2016

Guangdong University of Foreign Studies

Chinese Languange and Literature

Sep 2016 - June 2017

RevoU

Full Stack Data Analytics Program

Jan 2022 - April 2022

Orbit Future Academy

AWS re/Start Cloud Computing

Sep 2022 - Dec 2022

• SQL (MySQL, PostgreSQL, BigQuery)
• Python (Pandas, Numpy, Matplotlib, Seaborn, Scipy)
• Tableau, Power BI, Metabase
• Excel / Google Spreadsheet