Chang Han Yuan

+886 955599372 | [email protected] 

Work Experience


Software Engineer (Backend)

Systemweb Technologies Co., Ltd.

Sep 2018 - Present
Taipei, Taiwan

  • 1.Providing the Investment Management System to the Invest Company.

    • Successful go live in 6 months.

    • Technical support for a responsible project for at least 1 year.

  • 2.Building new modules for 4 major investment processes.

    • Established fund loss-audit process.

    • Modify old foreign exchange investment form with better UX.

    • Repair unusable leave system.

  • 3.Refactored inefficient legacy code.

    • Refactoring module for further extension.

    • SQL performance tuning

    • Improved waiting time from 12 second to 1 second.

  • 4.Established complicated business logic of cash-flow into an easy to understand excel report. 
    • Using MSSQL function and stored procedure to achieve.
  • 5.Teaching new colleague.
  • 6.Data transferring by using our own developed ETL tool.
  • 7.Write SQL SP to run the daily accounting process.
  • 8.Solving weakness scan issue.


Research Assistant

National Central University

Graduate Institute of Astronomy

Sep 2016 - Sep 2017
Taoyuan, Taiwan

  • 1.Established a pipeline to analyze data from space telescope databases.
  • 2.Using running median method to fitting the light curve activities from solar-like star and smaller stellar.
  • 3.Substract the raw light curve and fitted light curve to get pure solar flare events.
  • 4.Summaris and comparing different physics of stellar and using the power law to compare with our sun.
  • 5.Published a journal paper.

Administrative Assistant

Environmental Protection Administration 

International Cooperation Group

Jul 2012 - Jun 2013
Taipei, Taiwan

  • 1.Reception of foreign guests, Meeting minutes. 
  • 2.Assist photographer.

Education



National Central University                                                                              Taoyuan, Taiwan 

Master of Science in Astronomy

  • GPA: 3.79 / 4.0 ; Class rank: 2/10
  • Relevant Coursework: Data analysis, Stellar physics, Galaxy physics, Planetary Science 
  • Honor: Excellent work of PSROC in astronomy

Sep 2013 - June 2016

National Taiwan Ocean University                                                                   Keelung, Taiwan 

Bachelor of Science in Marine Environmental Informatics

  • GPA: 3.63 / 4.0 ; Class rank: 4/54
  • Relevant Coursework: C++, PHP, Matlab, Marine Science, Statistics, Japanese

Sep 2008 - Jan 2012

Publication

  • Chang et al. 2017. LAMOST Observations of Flaring M Dwarfs in the Kepler Field. The Astrophysical Journal, Volume 834, Issue 1, article id. 92, 7 pp. (2017). 

Programming Skill

  • C#
    • Basic Knowledge of OOP concept
    • Winform CRUD
    • Refactoring legacy code
    • Improving performance
  • MS SQL
    • Basic knowledge of SQL
    • Refactoring legacy SQL function and stored procedure
    • SQL performance tuning, by reduce unnecessary sub-query and add index 
    • Customer service, provide readable SQL queries for solving on-line problems
  • Git 
    • Basic knowledge of git operation 
    • Responsible for finalize the release branch (solve conflict)
    • Cherry-picking the commit from different project
  • Python
    • Established a pipeline to analyze data from space telescope databases.
    • Using the running median method to fit things.
  • Matlab, PHP, C++
    • Learned in University.

Language

  • Chinese (native)
  • English (intermediate, TOFEL 87/ 120)
  • Japanese (conversational, JLPT N2)
Powered by CakeResumePowered by CakeResume