Learn Data Skills
Beta
Andrew Defanto

Andrew Defanto

Consultant

University of Warwick | United Kingdom

Technologies

My Portfolio Highlights

My New Project

Introduction to Notebook Projects

My New Course

Introduction to SQL

Unleashing the magic of data, one algorithm at a time.

My Work

Take a look at my latest work.

DataLab

Project: Analyzing Students' Mental Health

project

Introduction to Notebook Projects

course

Introduction to SQL

course

Intermediate SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Blackmont Consulting | Aug 2024 - Present

Business Consultant

• Conducting extensive research to identify a broader range of tech-related roles, including Low Code, No Code, Data Support, and IT Support positions. Analyzing industry trends to ensure the identified roles were in demand and offered stable career paths. • Developing and implementing strategic initiatives that significantly improved the alignment between training programs and market demands, enhancing overall program effectiveness. • Creating a final presentation and comprehensive documentation summarizing findings, recommendations, and an actionable implementation plan for the client.
Show More

Segari | Jul 2022 - Jul 2023

Facility Management

• Managing company asset labelling, asset location and asset movement. Successfully updated the company asset list and created a new system, reducing unknown asset ownership to 5%. • Create and develop an automatic maintenance schedule and ticketing system using Microsoft Excell (Board, Query, VlookUp) and mail merge it automatically to every technician commander. • Handling a special project, developing the warehouse EHS layout to separate workers and heavy equipment movement. • Collaborate on making the concept of Lean processes by creating a roller system in the warehouse. Successfully reduced time and energy needed to transport goods from sorting to delivery.

Segari | Nov 2022 - Feb 2023

Production Planning and Inventory Control

• Leveraged Google Colab, SQL, Microsoft Excel, and Power BI to analyze stock data, forecast demand, and create automated dashboards, improving inventory accuracy and reducing manual errors by 10%. • Collaborated with cross-functional teams, including production and supply chain, to align inventory levels with production schedules, reducing stockouts and overstock situations by 5%. • Developed data-driven inventory control strategies, leading to a 3% improvement in stock turnover rates and enhancing overall supply chain efficiency through continuous process optimization.

Universitas Indonesia (UI) | Jan 2021 - Aug 2021

Undergraduate Teaching Assistant of Mechanical Modelling and Visualization

• Grading student assignments and recapping the grades. • Helping lecturer throughout the lecture. • Give extra lectures outside the lecture hours.

Society of Renewable Energy Universitas Indonesia | Jul 2020 - Aug 2021

Staff of Training and Development

• Managing 3 Webinars Series of Careers Talks about Green Jobs in Indonesia with variative speakers ranging from Development Directors of NREEC ESDM, Project Manager at GE, and M.Sc. student at TU Delft with around 500 registered participants. • Learning and applying Slovin Formula, Customer Satisfaction Index, Importance Performance Analysis, and Six Sigma as Quality Control Method to measure the organization program. • Trained on Intermediate Microsoft Excel Workshop and Critical Thinking in Renewable Energy Internal Workshops.

Badan Pengkajian dan Penerapan Teknologi | Sep 2020 - Apr 2021

Research Assistant

• Collaborate with the agency stakeholders to assess and evaluate the Jakarta LRT project. Successfully identify the critical aerodynamics factor that affects the LRT. • Analyze and identify the effect of a crosswind from a certain angle (yaw angle) into the high-speed train safeties through the computer fluid dynamics approach. Compare and contrast the data from the analysis of computer fluid dynamics to the data from wind tunnel testing. • Present the results to stakeholders regarding the identification, comparison and critical analysis of the critical factors of crosswind affecting the LRT.

Universitas Indonesia MotorSport | Nov 2019 - Jan 2021

Technical Consultant

• Advising team on development steps, quality control, logistics, testing and strategy in order to reach the teams target in the 2019 seasons. • Seeking solution with team principal and the head of technical division in order to solve long term and short term problem regarding the organization and the championship. • Assist the team principal and team head of division on conducting meeting with University top principle and sponsor companies regarding the development of the organization. • Responsible for the organization administrative and meeting schedule with the University administration branch.

My Education

Take a look at my formal education

Master of Science - MS, Engineering Business Management  · (2023 - OctoberUniversity of Warwick | 2024
Bachelor of Engineering - BE, Mechanical Engineering  · (2017 - FebruaryUniversity of Indonesia | 2022
Bachelor of Engineering - BE, Mechanical Engineering  · (OctoberTokyo Institute of Technology | 2021

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free