Mitch Huang | Backend Engineer/Data Analyst

📍 New Taipei, Taiwan

[email protected]

Work Experience

Business Analyst 

Titansoft PTE Ltd

📅 Jun 2023 - Feb 2024 🌍 Taipei, Taiwan

  • Utilize Google Analytics, SQL, Excel, and Tableau for 10+ analyses to enhance user registration, retention, and engagement rates. These analyses encompass daily mission events, website redesign performance, and system enhancement effectiveness.
  • Collaborate with the Product Owner to provide data driven support for expanding into Brazil, Korea, and Myanmar, covering 7 countries, resulting in 500+ new customer acquisitions and a remarkable 63% new market growth
  • Establish the data and reporting infrastructure, leveraging dashboard tools like QlikView and SQL to deliver real time insights into product performance, and key business KPIs
  • Conduct 4 A/B testing using Google Optimize to enhance product registration conversion rates, successfully integrating the findings into the product
  • Create an automated Python script for user quality checks, saving 15 minutes for lists with 3,000 users and 6 hours for those exceeding 100,000 users, benefiting a minimum of 10 team members

Software Engineer

ConVista Consulting PTE

📅 Nov 2021 - Dec 2022 🌍 Taipei, Taiwan

  • Collaborate with two senior software engineers from Taiwan and three from India on the development of the database and backend of the SAP ERP system
  • Reviewe code, conduct testing and creat test case scenarios for the FS CD module in the insurance industry, ensuring its 100% correct functionality
  • Document over 12 technical reports for software design and development, guaranteeing thorough and accurate records of project progress and results

Strengths


🧠 Problem Solving



🙌 Collaboration



💖 Self-adjustment


Development Projects

User Database Management API Development

📅 Mar 2024

  • Develop and deploy a Python-based user model with SQLAlchemy ORM, enabling streamlined CRUD operations for user management functionality.
  • Implement FastAPI in Python to manage user endpoints, adhering to RESTful API principles for efficient communication and interoperability
  • Deploy applications utilizing Nginx technology on AWS EC2 infrastructure within the cloud environment

MapleStory Auction Crawler

📅 Apr 2023 - May 2023

  • Employ Python to automatically fetch item prices from MapleStory's auction house, utilizing PyAutoGUI for screen localization and mouse control
  • Capture screenshots using PIL and apply Optical Character Recognition (OCR) for text identification
  • Implement Python-based solutions to rectify inaccuracies in OCR text recognition, ensuring data accuracy and reliability

Analytical Projects

Bellabeat

📅 Sep 2022 - Oct 2022 🚩 Google Data Analytics Capstone Project

  • Utilize Python and R programming to conduct data cleaning, processing and analysis to investigate the correlations between physical activity, sleep and caloric intake for Bellabeat smart device
  • Observe that study participants took an average of 7,638 steps per day, which is slightly less than the CDC's recommended daily target
  • Conclude that increasing physical activity and reducing sedentary time are crucial for improving health outcomes and reducing mortality risk

Machine Learning : English Language Learning

📅 Sep 2022 - Oct 2022 🚩 Kaggle 🏆 2318/2654

  • Develop models to evaluate the language proficiency of English Language Leaners (ELLs) in grades 8-12
  • Implement randomized decision tree using Python's sci kit Learn library to improve the predictive accuracy and control overfitting

Academic Paper : A Robust Omega Model With Wasserstein Metric

📅 Oct 2020 🚩 INFORMS Conference 

  • Collect and clean the data of the ETF and composite stocks of the S&P 500 during 2006 to 2020 using Python and VBA
  • Assist in designing an investment model by Lingo during COVID 19 economic pandemic, which result in a remarkable 485% outperformance of the S&P 500 index
  • Present research findings as a speaker at the INFORM conference, a leading venue for cutting edge research in the field at the 2020

Certification

Google Ads Search Certification

📅 Mar 2023 🚩 Google

Google Analytics Individual Qualification

📅 Mar 2023 🚩 Google

Google Data Analytics Specialization

📅 Oct 2022 🚩 Coursera

Awards

Graduate Representive

National Chi Nan University

📅 Jun 2020

Excellent Work, Capstone Project

National Chi Nan University

📅 Jun 2014

Education

Master of Information Management 

National Chi Nan University

📅 Sep 2018 - Jan 2021 🌍 Nantou, Taiwan

  • GPA : 3.97/4.00 
  • Thesis : The Portfolio Performance Comparisons under Return Uncertainty

Bachelor of Computer Science and Information Engineer 

National Chi Nan University

📅 Sep 2014 - Jun 2018 🌍 Nantou, Taiwan

  • GPA : 3.25/4.00 
  • Capstone Excellent work : Cost-aware Memory Subsystem Synthesis for MPSoCs with 3D-stacked SRAMs/DRAMs

Skills


🗄️ Backend Development

Python, C#, Java, ABAP

🛠️ DevOps

AWS, Linux


🛢️ Database

MySQL, PostgreSQL

💻 Automation

Python, VBA

📊 Data Analysis

Python, R, Lingo, Google Analytics


📈 Visualization

Qlikview, Tableau, Looker Studio

📓 Dev Methodology

Scrum, Agile

💬 Language

Mandarin, English


Others

A/B Test, Google Tag Manager, Google Optimize