Haitao Feng

Microsoft Azure SQL teams are operating hundreds of thousands of servers, millions of databases across 40+ market regions worldwide on the cloud. To keep the health of all managed resources under SLA 24x7, teams have developed and deployed automated bots to analyze real time metrics and mitigate detected issues and/or generate alerts so that people on call can follow TSGs to resolve issues timely.

• I helped them design, develop, test and maintain 50+ of those bots hosted on Azure Service Fabric platform.
• I helped them improve or add common bot APIs that can potentially cut bot developers' coding time to half when writing new bots.
• I led knowledge training sessions to help other developers ramp up on writing new bots.
• I was one of the most active code reviewers helping teammates follow best practices where appropriate.

T3T is the back-end core part of a complex test automation platform, used by many Microsoft internal teams to help drive RI/FI processes of thousands of Windows OS code branches. As a core developer, I primarily owned three major services:

1. Test execution orchestration engine. Millions of test units are scheduled on a daily basis through this group of services, which are hosted on Azure Service Fabric.

2. WTT, which is both the test content data storage system and the test execution engine. It includes nearly 200 SQL databases, typically 200 ~ 800 GB each (more than half were Azure SQL DBs).

3. Machine Repository, which manages 30K+ test machines/devices.

Besides everyday feature design/development/deployment/maintenance, I enjoyed a lot in SQL performance related troubleshooting. E.g., SQL timeouts and deadlocks were very frequent when I joined the team, and I root caused and fixed all major issues. As a result, previously complaining customers were very impressed.

• Started owning the test execution scheduling engine of an internal test automation platform, which was the predecessor of T3T.

• As an SDET, I helped the client team find bugs in an internal test automation platform before production deployment.
• Though not required by the contract, I was actively reviewing dev team's code changes to better understand the design, which helped planing and implementing meaningful tests.

As a team lead, I manged teams of SDETs focusing on writing test automation code for the client, Microsoft Windows SBS and Microsoft IT teams. Especially for Windows SBS test automation project, it was a meaningful milestone for both Microsoft and ChinaSoft, because it was the first test automation project that Microsoft outsourced to an external partner in China.

I helped Panasonic Asia to maintain an internal e-Procurement system that enables EDI between 135 Panasonic’s manufacturing companies and all suppliers in the world. This was a continuation of what I did in the previous company, BeXcom.

I led a small dev team that was responsible for the customization of BeXcom's universal e-commerce platform for the client, Panasonic, as part of their ERP system. The main skills I learned from this project were C++, COM, ASP, ODBC/ADO, MSMQ and SQL Server.