Blog No. - Total: 3538; 7days: 0; Today: 0
2019-03-17 - Redid HackerRank Java problems. It helps me learn things that I don't use often. Practice! Practice! Practice! Happy coding!
2019-03-10 - Redid CodingBat questions using both Java and Python. I can feel the improvement compared to last year. That is great!
2019-02-25 - Integrated an Angular 7 application with the Java Spring Boot application. The main benefit of the project is to develop the front and back ends separately.
2019-02-16 - Developed several C# applications for removing licensed software (TaskFactory) in the production.
2019-02-08 - Developed a C# application for accessing users' emails, calendars etc. using Microsoft Graph.
2019-01-16 - Developed a Java application for displaying data in replacement of Tableau Server (slow) using Spring Boot.
2018-12-23 - Added a solid state drive to my desktop at home. It is fast! But two ubuntu os cannot share swaps even two swaps on the different disks. Needs to remove the old ubuntu.
2018-11-02 - Developed programs for pasting and uploading images in Ckeditor without using CKfinder. It helps me to better understand Ckeditor.
2018-10-23 - Added full logging (such as usage, performance, error, diagnostic etc.) for my company’s website using Serilog.
2018-10-19 - Attend DeverDev Day at DTC. Just want to know the new technologies from Microsoft.
2018-10-11 - Successfully loading SharePoint data uisng C#.NET.
2018-09-20 - Migrated and upgraded our main server successfully.
2018-09-04 - Coups-NAV integration v2 went to production. There is no hard stop and failures will be logged to the error report.
2018-09-03 - I was promoted as Data Architect at my company!
2018-07-31 - Finished Python coding practice on Hackerrank. Happy coding!
2018-07-19 - Finished Python coding on codingbat. Happy coding!
2018-07-14 - Ubuntu 18.04 LTS was released! I just installed it on my desktop and laptop. It is awsome!
2018-07-09 - Coupa-NAV integration on transfering invoices, expense reports, vendors, payments, and chart of accounts for my company. The process can resume at the same failure point in order to avoiding mutiple transfers.
2018-05-26 - Finished Java and Sql problems on Hackerrank. Happy coding!
2018-05-16 - Finished all Java problems on CodingBat. Happy coding!
2018-05-08 - Created an Alexa App on Azure to show a few websites on a signle webpage. No need to refresh the webpage manually to see different websites.
2018-04-27 - Finished retaking the Machine Learning course on Coursera which I took three years ago. This time, I wrapped related methods to a class for better encapsulation using Python 3 + unittest (for better debugging).
2018-04-25 - Developed a ETL framework for easy maintenance, disaster prevention, email notification, warehouse statistics, parallel execution, automation, continuous integeration etc.
I want to build a Tao follows nature society. Please hire me.
I was born in Huadian city, Jilin province, China, a beautiful city in Northeastern China.
I got my PhD degree in Physical Chemistry from University of Tennessee in December 2012.
I am a Microsoft certified tech for database technology (MCSA, MCSE) and web development (MCSD).
I have a real passion for programming and database technology.
Current company (mainly C# and SQL Server):
Previous company:
• Created an intranet website using C#.NET and SQL Server. Set up everything on an IIS server. It is domain-driven, responsive, dynamic. The layout of the website is controlled by database tables for less effort on maintenance. It is for collecting data and displaying Tableau dashboards. There are several good features: upload and paste images in the text editor using user-defined methods without using comercial software, uplaod mutiple files from different directories and remove files, different people see different web contents, sending email with attachments, anonymous data collection etc.
• Created a data transfer & sync software for Coupa and Microsoft Dynamics NAV using C# and SQL Server. It mainly transfers invoices and expense reports between the two. It guarantees data flow and reports failure to accounting staffs. When they fixed the issues, the correct invoices or expense reports will be transferred to NAV from Coupa. The failure cannot affect the data flow.
• Created an Angular 7 + Java Spring Boot application for API, data collection and presentation. The original idea is just to prevent Tableau Server crash because one simple dashboard was read 10000 times a day. Since this web application displays the data directly, it frees up Tableau Server. I love this modern design alot, and add more and more features to the application such as angular integration, logging, security etc.
• Created an Alexa application for displaying Tableau dashboards using C#.NET and Azure SQL.
• Created a C# application for manipulating users' emails, calendars etc. using Microsoft Graph.
• PDF parsing and emailing system: it is a unique feature compared to other health centers in Denver.
• Developed ETLs for easy maintenance, disaster prevention, email notification, warehouse statistics, parallel execution, automation, continuous integeration etc.
• EDI (837, 835, 271 etc.) parsing: our vendor Netsmart cannot do it. I finished the projects on time.
• SQL Server and Tableau Server Migration: all are in production, and no mistakes, short downtime due to DNS lagging.
• Eliminated duplicates in several main stored procedures. One table has millions of rows.
• Set up a Hadoop system on distributed Linux servers.
Personal projects at my spare time:
• Developed several websites and applications using C#, PHP, Java, JavaScript, Node.js, Angular, React, SQL Server, MySQL, Mongodb etc. Please see demos from the Projects dropdown list.
• Rewrote Machine Learning codes using Python 2 and 3 + unittest from the Coursera course. I also added GUI for better interface for Linear Regression.
• Rewrote the Java source codes from the Algorithms I and II on the Coursera using C# + Unit Test.
• A lot of SQL and database administration practices for SQL Server, MySQL, Hadoop etc.
• Cloud development and administration on Azure and AWS.
• Learned Linux and Windows Servers by taking courses and practices.
• Took a lot of courses (including algorithms, web development, database technology, statistics etc.) on Pluralsight, Safari Books Online, Lynda, and Coursera.
