Steven Wang Email & Phone Number

Toronto, Ontario, Canada

Python/Pandas/Airflow, PostgreSQL, Elasticsearch, Nifi, Docker.Implementing and maintaining the internal service that calculates the trading book's risk position in the market.Using Python/Pandas, PostgreSQL, and Apache Airflow running on Linux, we are maintaining a system thatprocesses very large-scale customer and market data. These are some of the importantissues/concerns that lasted for years, and I help resolved:● By developing a Python tool to analyze very large logging files that multi-thread information mixedtogether, I helped to locate the pain point of a very long data processing that sometimes runs over13 hours, and developed a brand new thread job dispatcher to reduce the processing time to about 3hours● By refactoring very large Python modules/functions, I help to remove cross dependencies of dataprocessing code, and re-organizing them into small functions with clear interfaces to act each other.This helped the team to add more functions to the module.● Help refactor many modules to make the code base more clean and organized.● With my good understanding of how database runs, I helped to fine-tune the performance of thedatabase operation making quite some of them hundreds of times faster.

Kitchener, Ontario, Canada

Java/Play framework/Springboot, MySQL, Elasticsearch/Kibana, AWS, Docker.Insticator offers a new way to increase ad revenue and boost engagement by serving your audience more of the content they love.We develop/maintain the Java Play/Scala servers to support our business. As a senior developer, I ● Developed revenue calculation algorithms, and managed revenue verification using both test cases covering core algorithms, and Excel charts and pivot tables to verify data.● Re-developed overall test strategy to make the investment in testing more cost-effective.● Lead the refactoring of the codebase to make the whole source code more sustainable, and as a result, reduce the codebase while keeping high reusability and stability.● Optimized core implementation of business logic to improve performance and error tolerance. Optimized MySQL query performance for very large data tables by redesigning table structures, query statements, and indexes.● Mentored junior engineers and co-ops to help them grow faster, and help grow the talent base by interviewing co-ops.● Writing bash shell script to backup portion of the database from the cloud for local development.

Waterloo, Ontario, Canada

C/C++, C#, Java, SQL, Jenkins.• Developed a declaration-based client-side application, especially focusing on the WPF platform to develop and maintain dynamic data presentation with complicated user controls and data binding.• Architected Agentry Cordova/HTML5 client on Windows Phone, designed the communication convention between Javascript and native library, created stubs for important components and sample data to parallel tasks among developers as much as possible to speed up progress. • Implemented message dispatch between single-threaded JavaScript and multi-thread C++ core library so the HTML 5 component could respond to their corresponding native data components correctly. And a high-performance universal JSON encoder/decoder to serialize communication between JavaScript and C++.• Working on customer issues especially to locate hot spots of applications in both customer code or our library, client code, or database query plan, and work out solutions to improve key performance.• Sustaining of SAP Agentry mobile application framework to respond to customer issues timely. My work was recognized by high-level management that significantly helped customers exit the escalation state;• Sustaining SAP OData framework for offline applications, participating in the development of SCP (SAP Cloud Platform) SDK for iOS and Android using Swift and Android. • Managing Jenkins continuous integration testing, and improved usability by adding labels to different test tasks in Jenkins build history.

Waterloo, Ontario, Canada

• Redesigned object storage in file system, which freed new IDE from legacy technologies including dependency of old compiled byte code and version control.• Architected the brand new PowerScript language dynamic metadata management to support script editing in VisualStudio isolated shell;• Architected the brand new script file storage to replace the outdated storage, which leveraged the integration with 3rd party source code control, and imporved readability of script files;• Using ANTLR framework to re-write the grammar definition of PowerBuilder which was previously in lex/yacc format, focusing on designing and implementing the dynamic language metadata management while users type in scripts, and IntelliSense to help speed up application development. With the optimized class metadata loading algorithm, we could load metadata of hundreds class objects to support real-time intellisense in VisualStudio shell environment. And with dynamic metadata management, it could do cross reference validation while users are continuously changing their script in editing;• Initially designed script editor UI within VisualStudio shell.