Blog No. - Total: 3538; 7days: 0; Today: 0
2024-10-09 - Modern biology is a deepfake. Molecular formula is a sign language which can only represent organic matter. People can only see matter but cannot see molecular formula because molecular formula is not a reality.
2024-10-09 - Quantum mechanics is a deepfake. People cannot directly see electron, neutron, quark etc. If there is no time, there is no momentum and energy. So, momentum and energy represent time. Matter represents space. Modern science has a huge space and time confusion. That is a huge mental health issue of modern scientists.
2024-10-09 - I want to build a Tao follows nature society. Please hire me.
2021-02-21 - One .NET is great! Keep learning.
2021-01-26 - Finished notes migration for a Windows Form application by following CRUD principle.
2020-11-03 - Fnished Call Qaulifying enhancement project.That is a Windows Form application (C#).
2020-09-28 - Added several new functions to a claim adjudicaiton applicaiton. It is my first time coding in VB6. That is a really old language. :)
2020-07-16 - Finished the paper claim enhancement project. That is a good opportunity to learn both coding and business.
2020-04-11 - Be careful with SQL transaction, which can cause a serious page lock if it is not closed properly.
2020-03-29 - It is right time to practice coding! Leetcode, here we come!
2020-02-26 - Dapper beats up Entity Framework! Wake up Microsoft!
2020-01-05 - My website has dynamic headers now!
2020-01-03 - Migrated my website to Interserver. It doesn’t fully work under PHP7. It’s time to learn some new things on PHP.
2019-09-23 - Joined Versant Health as a software engineer.
2019-07-29 - Leetcode 200! Happy coding! Practice! Practice! Practice!
2019-05-08 - Kotlin becomes a preferred language for Android according to Google I/O. It is time to make some Android apps again.
2019-05-03 - Integrated Active Directory authentication with the Spring Boot application. The official guide is misleading. I am glad that I figured it out.
2019-04-27 - I copied an angular 7 + .net core 2 api project from windows to ubuntu. It is working without changing any code. Now, .net core 2 or java?
2019-04-26 - Set up the customerized logging for a Java Spring Boot application using Log4j2.
2019-04-09 - Set up an anonymous review system for my company using C#.NET, JavaScript, and SQL Server. JavaScript is the King of the front end!
2019-04-09 - Redid HackerRank SQL problems. Practice! Practice! Practice! Happy coding!
2019-04-01 - Redid HackerRank Python problems. Practice! Practice! Practice! Happy coding!
2019-03-25 - Design a removable tag function using JavaScript. It is better than two commercial software we used: CA Agile Central, and ServiceDesk Plus.
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.
