Jia Wen Lee

Work

FINRA,
Software Development in Test:

Jan 2021 - Present:
-Design test scenarios and create Python and SQL programs for automated testing to ensure data integrity of financial data received from exchanges, and data integrity of automatically generated reports for regulators base on detailed business requirements.
-Write programs in python to extract, transform and load (ETL) data from xml, excel, text and json files into SQL databases and excel reports.
-Design and execute integration testing for AWS system.
-Maintain Jenkins CI/CD pipelines and create regression tests using Selenium and Python to ensure code still works after each deployment.
-Work with Jenkins pipelines; AWS: EC2 cluster, S3 buckets, lambda, redshift db
-Present on block chain technology for an internal learning group.

Collins Aerospace,
Software Engineer:

June 2020 - Jan 2021:
-Develop, debug, maintain and test software used to run the flight interface and flight managements systems in commercial aircraft in ADA and Python adhering to strict regulatory, safety and testing standards.
-Trained in DO178 B-C

BioCentury Research Farm,
Research Development Software Engineer:

May 2018 - May 2020:
-Research and develop automation solutions for agriculture tillage.
-Log, process, clean and merge LiDAR data with GPS data and perform post processing data analysis to assess the viability of sensor for client needs.
-Create a GUI using Python QT4 with a back end C++ multi-threaded TCPIP, CANBus and UDP sockets to chart live LiDAR data.

Ag. Leader Tecnology,
Engineering Co-op:

May 2017 - Dec 2017:
-Optimized existing MATLAB programs used for data processing resulting in a reduction of program run time by a factor of 270. Benchmark time was 9 hours, new program is 2 minutes.
-Create new MATLAB programs and GUI to speed up data processing and data analysis.