Qing Deng Email & Phone Number

Pittsburgh, Pennsylvania, United States

Beijing, China

1. Deployed fully automated database streaming from the local data center to Amazon AWS cloud, which includes an initial load of 117+ tables from ODS to ADS layer and ongoing regular updates from local Oracle database, SFTP server and custom API. The cloud is now available to all BMW business analysts and engineers to download and upload data sets freely.2. Integrated local existing 4950+ lines of SQL statements and 17300+ lines of Java code into multiple AWS Lambda python functions with… Show more 1. Deployed fully automated database streaming from the local data center to Amazon AWS cloud, which includes an initial load of 117+ tables from ODS to ADS layer and ongoing regular updates from local Oracle database, SFTP server and custom API. The cloud is now available to all BMW business analysts and engineers to download and upload data sets freely.2. Integrated local existing 4950+ lines of SQL statements and 17300+ lines of Java code into multiple AWS Lambda python functions with the minimum manual effort to achieve the same data and file manipulation.3. Maintained multiple easily managed and updated cloud infrastructures by utilizing IaC(Infrastructure as Code) tool, terraform.4. Safeguarded the resources on the cloud. For example, by encrypting the data transferred through the network, controlling access list to the cloud by clear-mapped networks boundaries to resources. Show less

Beijing, China

1. Conducted testing on BMW website which is heavily used by 620+ national-wide dealers to document their selling and pipeline performance.2. Developed an automated testing program based on Selenium that is good at extracting statistical error between the oracle and the actual presentation.3. Collaborated with front- and back-end developers to resolve slow web page responding in order to ensure better user experience.

Shanghai, China

1. Contributed to the development of an event-driven, integrated stock trading application.2. Built an algorithmic trading module with 1) automated update of technical indicators for stock trading, covering RSI, MACD, AR, CMO, and SAR, etc., 2) algorithmic trading based on calculated technical indicators, covering grid trading, pairs trading, cross-market trading, and trend tracking arbitrage, and 3) back-testing of the strategies using historical data retrieved from brokers.3… Show more 1. Contributed to the development of an event-driven, integrated stock trading application.2. Built an algorithmic trading module with 1) automated update of technical indicators for stock trading, covering RSI, MACD, AR, CMO, and SAR, etc., 2) algorithmic trading based on calculated technical indicators, covering grid trading, pairs trading, cross-market trading, and trend tracking arbitrage, and 3) back-testing of the strategies using historical data retrieved from brokers.3. Developed a streamlined workflow for traders with limited programming experience to update trading strategies independently; optimized the API design to facilitate the robust code change, and prepared training materials for traders. Show less

中国 上海

1. Led a team to build a deep learning model for predicting the traffic flow in the downtown area of a city based on historical spatial traffic data.2. Performed systematic data cleansing to enhance validity, accuracy, completeness, consistency and uniformity of the dataset; leveraged Pandas and Matplotlib for data manipulation and visualization to facilitate pattern extraction.3. Applied various feature engineering principles and the Minimum Redundancy Maximum Relevance Feature… Show more 1. Led a team to build a deep learning model for predicting the traffic flow in the downtown area of a city based on historical spatial traffic data.2. Performed systematic data cleansing to enhance validity, accuracy, completeness, consistency and uniformity of the dataset; leveraged Pandas and Matplotlib for data manipulation and visualization to facilitate pattern extraction.3. Applied various feature engineering principles and the Minimum Redundancy Maximum Relevance Feature Selection (mRMR) algorithm to enhance feature selection.4. Built, trained, validated and tested LSTM and RNN models in PyTorch for prediction; performed hyper-parameter optimization based on cross-validation and Bayesian optimization, attaining an overall accuracy of 91%. Show less

中国 上海

1. Providing Computer Science academic support to NYU Shanghai students in and out of the classroom to help them understand course materials better.2. Working closely with faculty and staff to improve the lecture and promote students independent and active learning.

中国 上海

1. Worked with classmates to develop, design, and program a Python chat system with basic and distinctive function, such as playing the live game with another idle user, sending poems to sole users from the server.2. Applied and adapted the code to make interface user-friendly.

Master Of Science - Ms, Information Technology

学士, Computer Science