Syafrie Dwi Faisal

Data & Analytics

+6285730622350 | [email protected] | Surabaya, Indonesia

   linkedin.com/in/syafriedf    intip.in/PortfolioSyafrie github.com/syafriedf

Work Experiences


Senior Data Analyst  •  Bunker Technologies 

April 2022 - Present  |  Singapore

  • Developed an initial prototype dashboard using PowerBI and VBA, leading to the acquisition of 5 initial
    customers with a 92% retention rate.
  • Automated reporting processes with VBA and Python, reducing manual work from 2 hours to just 5 minutes,
    converting them into actionable dashboards to support the sister company of bunker.
  • Utilized pandas for data validation automation, achieving 100% data accuracy for every process.
  • Led the ETL process, automating data extraction from accounting software without API support, reducing
    processing time from 1 hour to 5 minutes using Python.
  • Developed web scraping solutions to retrieve data from non-API-enabled accounting software, reducing
    manual Excel downloads from 1 hour to 10 minutes.
  • Architected a real-time reporting framework within Google Sheets using App Script, establishing daily
    automated triggers to ensure that leadership and operations teams have access to up-to-date metrics.
  • Implemented 3 significant product improvements by brainstorming and optimizing data processes with all data team members.

Lead Data Analyst  •  Albéa Group

January 2021 - April 2022  |  Surabaya, Indonesia

  • Led a team of 3 data analysts across 3 factory locations in Semarang, Surabaya, and Mojokerto, overseeing the implementation and optimization of data solutions to improve operational performance.
  • Managed SQL Server as a super admin, overseeing and controlling all data inflows and outflows across the company, ensuring data integrity, security, and efficient processing.
  • Managed a comprehensive dashboard using PowerBI, VBA, and SQL Server, allowing all departments to monitor factory performance from a single source.
  • Developed a VBA-based application that streamlined import/export tracking, reducing processing time to just 3 minutes.
  • Created & managed a machine performance monitoring dashboard using PowerBI, Raspberry Pi, and SQL Server, cutting production manager reporting time from 1 hour to 10 minutes.
  • Developed & managed a simplified order management app for the moldshop department, achieving paperless operations and reducing monthly costs by up to IDR 50 million.

Project Manager Lead  •  Kreaktif Indonesia

December 2018 - July 2020  |  Surabaya, Indonesia 

  • Acquired and coordinated over 20 clients, maintaining a 95% client retention rate.
  • Collaborated all of project manager as well as with front-end and back-end engineering teams to streamline project workflows and deliver data-driven insights and recommendations to clients.
  • Established SOP guidelines for project managers, improving task efficiency from an average of 5 minutes to 2 minutes
  • Oversaw the successful execution of 8 projects, including websites and mobile applications, leveraging Trello and Slack for efficient communication and task management

Data Scientist  •  Dinas Komunikasi dan Informatika

June 2019 - August 2019  |  Surabaya, Indonesia 

  • Built and deployed a face recognition model using Python and the Haarcascade library for employee
    attendance.
  • Developed a web-based system using CodeIgniter to create admin dashboards for employee management.
  • Collaborated with team members to ensure the model and system met project requirements.
  • Streamlined the attendance tracking process, reducing administrative overhead and increasing
    accuracy in employee monitoring, the error rate attendance reduce fro 15% to 7%.

Education


2020 - 2022

Institut Teknologi Sepuluh Nopember (ITS)

Master of Business Analytics 

2016 - 2020

Institut Teknologi Sepuluh Nopember (ITS)

Undergraduate Information Systems

Project


Monitoring Dashboard using Surabaya Muslim Retail Data Scrapping - 2020

Document: https://bit.ly/36ayc4B, Dashboard: https://bit.ly/2SHOsHd

Telkomsel, Machine Learning Prediction - 2019

Document: https://bit.ly/3xfhsow, Code: https://bit.ly/3Alnben

International Dashboard using 1.2 Million Used Car Listings TrueCar.com - 2019

Document: https://bit.ly/3hoLbol, Dashboard: https://bit.ly/2UZN17N

Predicting Comodity Prices using Jakarta Comodity Dataset - 2018

Document: https://bit.ly/3h8voen, Code: https://bit.ly/2Ul9bAP

Achievement


1ST Favorite Winner iFest Data Analysis - 2019

1ST Winner Compfest Data Scientist - 2019

Indonesian Delegate of ASEAN Young Leaders Programme at Singapore - 2018

Skills

Tools

  • Power BI
  • Metabase
  • Microsoft Excel
  • Postgres
  • SQL Server
  • AWS S3
  • Power Automate
  • App Script
  • Google Sheets

Programming

  • Python
  • VBA
  • SQL