Hello, I'm Sean.
With over 9 years of extensive experience in software development, I excel in employing divergent thinking to address abstract client requirements and tackle various implementation challenges within systems.
I specialize in integrating diverse user contexts and crafting solutions based on available resources.
I enjoy analyzing the essence of things through multidimensional observation.
New Taipei City, Taiwan
(+886)979-055-000
2008/09 - 2012/06
2005/09 - 2008/06
2023/10 - 2024/01
Responsible for coordinating client communication, assisting the Project Manager in project control, planning adjustments to system architecture, and software development.
1. Engage in client communication to clarify actual user scenarios, analyze the logic and data structure of client ERP systems, and integrate them into the new App.
2. Refactor project code to maximize the advantages of the .NET Core framework, enhance reusability, readability, and logical consistency.
3. Maintain the original .NET Core MVC architecture of the project and introduce Web API mechanisms in the new development phase to achieve a separation of front-end and back-end development.
4. Continuously optimize the original database structure, migrate existing client data, and prevent database overgrowth.
2022/06 - 2023/05
Responsible for maintaining and developing platform functionalities to ensure continuous integration of the product department and third-party products into the platform.
1. Maintain and develop backend functionalities based on Silverlight technology.
2. Redevelop a new backend based on C# .NET Core, port relevant functionalities and data, and validate the correctness of the new system.
3. Due to customer adjustments in checkout and member bonus calculation formulas, recalculate existing database data. Roll-out updates in batches of 5000 records at a time without affecting online services.
4. Migrate a large number of static image CDN hosts by simplifying the process through architecture replacement.
5. Practice and explore system architecture design to enhance flexibility in programming.
6. Emergency troubleshooting of system anomalies, coordinate team manpower allocation and problem resolution during on-call duties.
2019/09 - 2021/11
Responsible for maintaining and developing integrated business processes including order acquisition, order status management, accounting settlement, risk monitoring, and customized backend for various international brands.
1. Real-time monitoring of order statuses across multiple international product lines. Due to high total order volumes from merchants and the need for real-time synchronization and monitoring, the system is designed to split business processes into various modules to ensure throughput capacity and accuracy. During peak times, QPS can exceed tens of thousands.
2. Maintenance and development of content within various modules and conducting unit tests.
3. Development and maintenance of modules for large-scale data aggregation and synchronization services.
4. Development of interfaces such as APIs and SPIs for third-party client integration.
5. Daily order summary settlement and report generation in the backend, as well as development of new reports.
6. Integration of Oracle DB data through MS SSIS services and export of customized output files.
2016/06 - 2019/05
Responsible for product maintenance of the beanfun! gaming platform, integrating new games, developing platform mobile apps for continuous integration, and providing additional services.
1. Development of API integration for the beanfun! App product.
2. Development of platform activity webpages.
3. Development of daily check-in feature for the beanfun! App.
4. Integration of new games and linkage with the platform.
5. Development of mobile-friendly beanfun! platform webpages.
2015/03 - 2016/06
Responsible for designing and developing a financial and accounting process integration system for Fos Automotive dealerships.
1. Directly communicate with clients to analyze requirements and develop software.
2. Design reusable components to automatically convert Model Classes into specific SQL query statements and execute queries.
3. Calculate asset cost amortization and depreciation for clients.
4. Design and generate customer billing statements and various reports.
2014/03 - 2015/03
Responsible for maintaining and developing features for various projects.
1. Communicate with clients, design software processes after confirming requirements.
2. Maintain existing projects.
3. Troubleshoot anomalies in customer telephone exchange systems.
beanfun! Mobile version official website
Due to the outdated technology and complexity of the login mechanism of the official website, and the company had no plans for a platform website renovation.
At that time, with the rapid development of smartphones and mobile devices, to provide users with a better experience when browsing the official website,
I independently developed the M version of the beanfun! website and migrated the original login mechanism and commonly used member functions into the website.
The main features include:
1. Member login function (can also log in through the mobile app)
2. Game point inquiry and purchase, online recharge system
3. Online customer service function, VIP service bell function
4. Member data maintenance
From conceptualization to actual development, testing, and completion, the total time for launch was approximately 12 working days.
Please use mobile device to open this web: https://m.beanfun.com
Design of beanfun! App Account Protection and Login Mechanism
In view of the frequent theft of player game accounts, a login mechanism has been designed to enable players to safeguard the security of their account information.
Situation
Users want to retain the option for direct input of username and password for login, while also ensuring the security of their accounts, rather than being restricted to either account/password input or QR code scanning login through the app, requiring continuous switching between the two.
Task
Based on the team's collaborative development, the beanfun! App binds devices to confirm the unique identity of users.
I independently conceived and developed a login mechanism that combines account passwords with real-time push notification verification.
Action
1. Injecting custom Protocols and independently encrypted Tokens on the user end to obtain information about the user's login device.
2. Sending requests carrying login device information to the mobile app through push notification scheduling.
3. Recording information about the login device, alerting the user if the device is abnormal, and storing it in the database for future reference.
4. Allowing users to review information such as device details, login times, and IP sources on the mobile app before deciding whether to proceed with the login.
Results
This mechanism and its functionalities were completed, tested, and accepted in September 2017, and have been in use ever since, up to the present (2024).
Qseries Voting System (Website Now Offline)
After the original website development company ceased maintenance of this project, a visual designer friend entrusted me to assist him in completing the backend logic of the website's redesign.
Situation
1. The website is now hosted on the War State Cloud, and aside from the static web pages modified by the designer, I do not have access to any backend source code.
2. The existing voting data is stored in an MS DB, but there are no SQL queries available for statistical analysis of the voting data.
3. The War State website management interface differs from the IIS Server, and there is no remote desktop tool provided for website maintenance. Only FTP file upload is available.
Task
1. Ensure that the new website can correctly display the total number of votes from the existing data.
2. Implement new voting rules allowing a maximum of three votes per account per day.
3. Verify the Table Schema relationships and data meanings within the current database.
Action
1. Use ashx files (generic handlers) to ensure that the cloud server can compile backend programs in real-time (server-side ↔ browser client).
2. Utilize Ajax to fetch user IDs, send requests to ashx for verification, and increment the vote count.
3. After confirming the data relationships between Table Schema, use SSMS tools to calculate the total number of votes and add voting records.
Results
From clarifying requirements, confirming the database structure with the previous developer, conducting interviews with the customer to understand actual needs, completing implementation, deploying and testing the functionality, the entire process took about 5 days. After the website went live, its functionality was normal with no reported issues. The customer gave positive affirmation.
*Several months later, the customer reported an anomaly in the total number of votes. After assessing and investigating, I determined that it was due to an abnormality with the cloud server rather than a programming error. Subsequent confirmation with the cloud hosting provider revealed that it was indeed a data loss caused by abnormalities in the hosted server.
Hello, I'm Sean.
With over 9 years of extensive experience in software development, I excel in employing divergent thinking to address abstract client requirements and tackle various implementation challenges within systems.
I specialize in integrating diverse user contexts and crafting solutions based on available resources.
I enjoy analyzing the essence of things through multidimensional observation.
New Taipei City, Taiwan
(+886)979-055-000
2008/09 - 2012/06
2005/09 - 2008/06
2023/10 - 2024/01
Responsible for coordinating client communication, assisting the Project Manager in project control, planning adjustments to system architecture, and software development.
1. Engage in client communication to clarify actual user scenarios, analyze the logic and data structure of client ERP systems, and integrate them into the new App.
2. Refactor project code to maximize the advantages of the .NET Core framework, enhance reusability, readability, and logical consistency.
3. Maintain the original .NET Core MVC architecture of the project and introduce Web API mechanisms in the new development phase to achieve a separation of front-end and back-end development.
4. Continuously optimize the original database structure, migrate existing client data, and prevent database overgrowth.
2022/06 - 2023/05
Responsible for maintaining and developing platform functionalities to ensure continuous integration of the product department and third-party products into the platform.
1. Maintain and develop backend functionalities based on Silverlight technology.
2. Redevelop a new backend based on C# .NET Core, port relevant functionalities and data, and validate the correctness of the new system.
3. Due to customer adjustments in checkout and member bonus calculation formulas, recalculate existing database data. Roll-out updates in batches of 5000 records at a time without affecting online services.
4. Migrate a large number of static image CDN hosts by simplifying the process through architecture replacement.
5. Practice and explore system architecture design to enhance flexibility in programming.
6. Emergency troubleshooting of system anomalies, coordinate team manpower allocation and problem resolution during on-call duties.
2019/09 - 2021/11
Responsible for maintaining and developing integrated business processes including order acquisition, order status management, accounting settlement, risk monitoring, and customized backend for various international brands.
1. Real-time monitoring of order statuses across multiple international product lines. Due to high total order volumes from merchants and the need for real-time synchronization and monitoring, the system is designed to split business processes into various modules to ensure throughput capacity and accuracy. During peak times, QPS can exceed tens of thousands.
2. Maintenance and development of content within various modules and conducting unit tests.
3. Development and maintenance of modules for large-scale data aggregation and synchronization services.
4. Development of interfaces such as APIs and SPIs for third-party client integration.
5. Daily order summary settlement and report generation in the backend, as well as development of new reports.
6. Integration of Oracle DB data through MS SSIS services and export of customized output files.
2016/06 - 2019/05
Responsible for product maintenance of the beanfun! gaming platform, integrating new games, developing platform mobile apps for continuous integration, and providing additional services.
1. Development of API integration for the beanfun! App product.
2. Development of platform activity webpages.
3. Development of daily check-in feature for the beanfun! App.
4. Integration of new games and linkage with the platform.
5. Development of mobile-friendly beanfun! platform webpages.
2015/03 - 2016/06
Responsible for designing and developing a financial and accounting process integration system for Fos Automotive dealerships.
1. Directly communicate with clients to analyze requirements and develop software.
2. Design reusable components to automatically convert Model Classes into specific SQL query statements and execute queries.
3. Calculate asset cost amortization and depreciation for clients.
4. Design and generate customer billing statements and various reports.
2014/03 - 2015/03
Responsible for maintaining and developing features for various projects.
1. Communicate with clients, design software processes after confirming requirements.
2. Maintain existing projects.
3. Troubleshoot anomalies in customer telephone exchange systems.
beanfun! Mobile version official website
Due to the outdated technology and complexity of the login mechanism of the official website, and the company had no plans for a platform website renovation.
At that time, with the rapid development of smartphones and mobile devices, to provide users with a better experience when browsing the official website,
I independently developed the M version of the beanfun! website and migrated the original login mechanism and commonly used member functions into the website.
The main features include:
1. Member login function (can also log in through the mobile app)
2. Game point inquiry and purchase, online recharge system
3. Online customer service function, VIP service bell function
4. Member data maintenance
From conceptualization to actual development, testing, and completion, the total time for launch was approximately 12 working days.
Please use mobile device to open this web: https://m.beanfun.com
Design of beanfun! App Account Protection and Login Mechanism
In view of the frequent theft of player game accounts, a login mechanism has been designed to enable players to safeguard the security of their account information.
Situation
Users want to retain the option for direct input of username and password for login, while also ensuring the security of their accounts, rather than being restricted to either account/password input or QR code scanning login through the app, requiring continuous switching between the two.
Task
Based on the team's collaborative development, the beanfun! App binds devices to confirm the unique identity of users.
I independently conceived and developed a login mechanism that combines account passwords with real-time push notification verification.
Action
1. Injecting custom Protocols and independently encrypted Tokens on the user end to obtain information about the user's login device.
2. Sending requests carrying login device information to the mobile app through push notification scheduling.
3. Recording information about the login device, alerting the user if the device is abnormal, and storing it in the database for future reference.
4. Allowing users to review information such as device details, login times, and IP sources on the mobile app before deciding whether to proceed with the login.
Results
This mechanism and its functionalities were completed, tested, and accepted in September 2017, and have been in use ever since, up to the present (2024).
Qseries Voting System (Website Now Offline)
After the original website development company ceased maintenance of this project, a visual designer friend entrusted me to assist him in completing the backend logic of the website's redesign.
Situation
1. The website is now hosted on the War State Cloud, and aside from the static web pages modified by the designer, I do not have access to any backend source code.
2. The existing voting data is stored in an MS DB, but there are no SQL queries available for statistical analysis of the voting data.
3. The War State website management interface differs from the IIS Server, and there is no remote desktop tool provided for website maintenance. Only FTP file upload is available.
Task
1. Ensure that the new website can correctly display the total number of votes from the existing data.
2. Implement new voting rules allowing a maximum of three votes per account per day.
3. Verify the Table Schema relationships and data meanings within the current database.
Action
1. Use ashx files (generic handlers) to ensure that the cloud server can compile backend programs in real-time (server-side ↔ browser client).
2. Utilize Ajax to fetch user IDs, send requests to ashx for verification, and increment the vote count.
3. After confirming the data relationships between Table Schema, use SSMS tools to calculate the total number of votes and add voting records.
Results
From clarifying requirements, confirming the database structure with the previous developer, conducting interviews with the customer to understand actual needs, completing implementation, deploying and testing the functionality, the entire process took about 5 days. After the website went live, its functionality was normal with no reported issues. The customer gave positive affirmation.
*Several months later, the customer reported an anomaly in the total number of votes. After assessing and investigating, I determined that it was due to an abnormality with the cloud server rather than a programming error. Subsequent confirmation with the cloud hosting provider revealed that it was indeed a data loss caused by abnormalities in the hosted server.