Taipei City, Taiwan
Apr 2021 - Present
Taipei, Taiwan
1.Implement Gitlab for version control.
Solving the conflict with two different developing line from Shenzhen and Taiwan.
2.Migration from a 16 years live web based Loan Management System (LMS) to an 8 years live winform based LMS.
Writing T-SQL to do the migration. Total migration downtime is around 40 mins.
3.The 16 years LMS is mainly for the mortgage loan, 8 years LMS is mainly for the personal loan.
Plantext key-in resolve. Data sorting and classification.
Dirty storage data cleaning.
Solving duplicate data in both live system.
Solving architecture differently. There are completely different repayment calculation work-flow.
NO Normalization - UNF level & 1NF level.
Parameter mapping.
Sep 2018 - Apr 2021
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.
Graduate Institute of Astronomy
Sep 2016 - Sep 2017
Taoyuan, Taiwan
International Cooperation Group
Jul 2012 - Jun 2013
Taipei, Taiwan
Sep 2013 - June 2016
Sep 2008 - Jan 2012
Taipei City, Taiwan
Apr 2021 - Present
Taipei, Taiwan
1.Implement Gitlab for version control.
Solving the conflict with two different developing line from Shenzhen and Taiwan.
2.Migration from a 16 years live web based Loan Management System (LMS) to an 8 years live winform based LMS.
Writing T-SQL to do the migration. Total migration downtime is around 40 mins.
3.The 16 years LMS is mainly for the mortgage loan, 8 years LMS is mainly for the personal loan.
Plantext key-in resolve. Data sorting and classification.
Dirty storage data cleaning.
Solving duplicate data in both live system.
Solving architecture differently. There are completely different repayment calculation work-flow.
NO Normalization - UNF level & 1NF level.
Parameter mapping.
Sep 2018 - Apr 2021
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.
Graduate Institute of Astronomy
Sep 2016 - Sep 2017
Taoyuan, Taiwan
International Cooperation Group
Jul 2012 - Jun 2013
Taipei, Taiwan
Sep 2013 - June 2016
Sep 2008 - Jan 2012