Yanglan Xu Email & Phone Number

Austin, Tx, Us

Herndon, Virginia, United States

• Engineered a tool to automate JSON file generation defining database metric objects for classifying remote health signals by converting and processing excel sheet data in Python.• Developed a script to aggregate and convert all JSON definition files into a Docker container image for database deployment.• Conducted end-to-end testing to verify successful database redeployment using the newly generated image and accurate metric definitions using GraphQL API.• Deployed to production for a new product line, ensuring maintainability and testability for future products.

Herndon, Virginia, United States

• Developed an automated ETL pipeline for populating an etcd for emergency data storage and software testing by extracting objects from the main database, transforming the data into a key-value pairs, translating object data into Kafka-readable JSON script, and loading into the etcd using Javascript.• Processes 30,000 object pull requests in approximately 23 minutes.• Engineered a solution to failing branch health reports by locating and restructuring test cases that reported false positives.• Fixed branch health reports by resolving failing test cases that reported false positives.• Setup and updated Helm’s Makefile to automatically generate Min.IO buckets that use AWS S3 API with mirror replication enabled upon namespace creation.

Charlottesville, Virginia, United States

Conducted a Capital One case study on potential partnerships with third-party service providers, potential cybersecurity vulnerabilities, as well as conducted a SWOT analysis, researched potential security solutions, and presented to a panel of Capital One executives and UVA professors.

Herndon, Virginia, United States

Developed an algorithmic trading bot in Python, conducted tests using 20,000 historical backtests, linked the bot to a live trading account on Interactive Brokers, and increased the starting account balance by 15% over 2 weeks.