Christopher Stephen Data Analytics Portfolio

Welcome to my page

Christopher Stephen

profile-pict

Hi, you can call me Stephen. I am a person who has great passion and interest in data field. I just started my career as a Data Analyst in mid of 2022. Looking forward for the opportunity to work with you !

Work Experiences

Data Analyst

PT Tata Metal Lestari

Aug 2022 - Jan 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.

Education

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

Skills

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