Blog No. - Total: 3538; 7days: 0; Today: 0
2018-04-18 - Set up unit test for Python (unittest and pytest) and Javascript (mocha and chai) for LeetCode practice. Have fun with coding!
2018-04-12 - Finished solving the LeetCode problems using Java, C++, C# + Unit Test. It is a good learning process, especially for C++.
2018-04-07 - Congratulations! My blog reaches 2000! Keep working hard!
2018-03-21 - Set up an IIS server and developed an internal website for my company. It is domain-driven, responsive, dynamic, and mainly single-paged.
2018-02-22 - Successfull parsing 837, 835 EDI files, and load data to data warehouse using C#, SSIS, SQL Server. (5000 lines of codes!)
2018-02-03 - Started solving the LeetCode problems using Java, C++, C# + Unit Test. Have fun with coding!
2017-12-28 - Finished rewriting Algorithms I and II source codes using C# + Unit Test. It is a good learning process on C# programming.
2017-10-31 - Started rewriting the Java source codes learned from Algorithms I and II on the Coursera using C# and add Unit Tests for debugging.
2017-10-23 - Congratulations! I've successfully completed Algorithms, Part II on Coursera!!!
2017-10-20 - Successfully restore on-premises database to Azure SQL daily with a scheduled job using PowerShell, C#, SQL Server.
2017-10-19 - Added statistics for my blogs: total, each category, and activities. Also added “Projects” dropdown list to show parts of my hobby projects. Cannot link java and node.js projects because Godaddy cannot host them. Alexa (C#) doesn’t work due to shared hosting (no ssl).
2017-10-18 - Successfully parse 834 files without full manual as a guide.
2017-10-08 - Congratulations! My blog reaches 1000! Keep Working hard!
2017-10-01 - I successfully migrated two sql servers (2008 and 2016) (using powershell for automation) and Tableau Server to the virtual machines for my company. Also set up everything such as backups, ETLs, ODBCs etc.
2017-09-16 - Attended my first SQL Saturday at University of Denver.
2017-09-08 - I successfully did the SQL Server (everything) migration test using PowerShell and T-SQL.
2017-07-06 - I went back to China to see my parents in Shenzhen for two and half weeks. We also visited beatiful Zhangjiajie in Hunan Province for five days.
2017-05-18 - I successfully parsed EDI (271) files using C#, SQL Server, and SSIS.
2017-05-05 - Fully controlled an Amazon Echo Dot using C# by talking to Alexa API.
2017-05-02 - Attended mental health center of denver 2017 all staff meeting.
2017-04-18 - Attended Tableau Hands-on Workshop Traning @ EKS&H
2017-04-09 - Redeveloped my web using Spring MVC. It can only run on the local server since my hosting doesn’t support Java yet.
2017-03-18 - Modify my web layout to include more contents for furture learning.
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.
