Ywenlei2022 Lei

Motivated and solutions-focused Software Engineer II with a strong foundation in full-stack development and scalable system design. Experienced in writing clean, efficient code and collaborating across teams to deliver high-quality software. Committed to continuous learning and technical excellence.

Software Engineer II at Microsoft (2022-09 – 2026-03)

C+Ai, Azure Data, Messaging & Realtime Analytics - Designed, developed and tested APIs and backend services that improve Azure Stream Analytics service offering and integrate software into a larger system ensuring quality and maintainability. Engaged in code and design reviews and collaborated with related teams to achieve shared goals.

• Took end-to-end ownership of billing service in ASA team. Engineered and implemented new billing pipelines utilizing internal tools and migrated off old billing pipelines focusing on performance and reliability. Reduce billing error, incidents and revenue loss by 1%.
• Designed and implemented secure authentication mechanism for SQL databases, ensuring continuity of existing functionality as part of Secure Future Initiative.
• Participated in the on-call rotations to monitor service for degradation or interruptions and perform complex incident management and problem resolution for the service.

Senior Software Engineer at Siemens Industry (2021-01 – 2022-12)

Smart Infrastructure Division, Digital Grid, Grid Control R&D - Developed high quality, high performance reliable Power Grid software applications.

• Identified, analyzed and resolved software bugs during testing and production stages and reduced bugs through increasing test coverage.
• Maintained and tested complex software applications with domain specialists.
• Created features that work across multiple software applications, systems & portal.

Senior Software Engineer at Siemens Industry (2018-01 – 2020-12)

Energy Management Division, Digital Grid – Software Solutions - Designed schemas and extracted, transformed and loaded customer data. Worked as a full-stack engineer to design and develop validation rules for business processes and implemented user interface using Siemens Java WebSDK tool.

• XM Columbia Registration Fronteras Project - Tech stack: PL/SQL, Java, Oracle, Windows.
• CAISO EMMS to Energy Management System Integration Project - Designed and developed RDBMS schema and Oracle packages to track deployment statuses. Implemented deployment adapters for exchanging XML and WSDL data and procedure calls through SOA. Participated in testing of integration pattern which enables communication from JBoss with IBM MQ using Java Messaging API. Participated in debugging of issues with data in Cassandra on EMS side. Enhanced deployment process by designing and coding site refresh function for site status synchronization between EMMS and EMS sites and status monitoring. Tech stack: Perl, C++, PL/SQL, Linux, Java, Python, Cassandra, Kafka.

Software Engineer at Siemens Industry (2015-01 – 2018-12)

Siemens Test Reporting Tool on Customer Portal - Implemented and tested interface between Siemens test tool (Jama) and Siemens customer portal for data and file transfer utilizing Jama SOAP and REST API.

• Tech stack: PHP, JavaScript, PostgreSQL, Linux, SOAP/REST API

Senior Software Engineer at Siemens Industry (2015-01 – 2022-12)

Spectrum Power 7 Information Model Management Improvement Project - Worked in an Agile team to improve the maintainability and performance of base SP7 product by rearchitecting old IMM transfer framework to transfer data to ODB and removing database dependency using OCCI.

• Enhanced algorithm for world map segmentation and export to improve correctness of graphical objects and speed of export.
• Designed and implemented automated unit tests using C++ and module tests using Python for IMM components to improve test coverage to 80%.
• Tech stack: Python, C++, Qt, GitLab CI/CD.

Master of Science in Electrical and Computer Engineering – University of Wisconsin, Madison

Bachelor of Engineering in Electronic Engineering – City University of Hong Kong

Exchange Student in Electrical and Computer Engineering – University of Illinois at Urbana-Champaign