Haoran Yu Email & Phone Number

Cleveland, Oh, Us

Cleveland, Ohio, United States

Containerizing the SearchOwl application. The container should be compatible with other AWS products, set up S3 and used Athena, and our React Frontend. The system should also be designed to scale to 100k monthly active users (MAU).Assist in the development and maintenance of software applicationsCollaborate with the development team to understand requirements and translate them into functional codeParticipate in code reviews and testing processesGain hands-on experience in software development methodologies and best practices

Guangdong, China

Data crawling and analysis of new media e-commerce operations, such as Amap and Meituan. Then extract specific information from insurance policies and delt with policies tables.• Developed Python scripts using the Playwright library to simulate interactions with Amap and Meituan websites, including mouse movements, clicks, input handling, and slider validation. Successfully obtained search results and extracted relevant information.• Implemented the jieba library to perform string segmentation and utilized word2vec for string vectorization. Utilized Levenshtein ratio to compare the search results from Amap with the shop names from Meituan, enabling the selection of the most appropriate match.• Utilized pandas to transform the extracted data into a structured table format and exported the final result using the to_csv() function.• Leveraged the pdfplumber library to load and search for keywords within insurance policy documents in PDF format. Developed regular expression patterns and utilized re.findall() to extract time-related information. Transformed the extracted information into JSON format using the json.dumps() function.• Utilized Pandas and Numpy to manipulate insurance policy tables, including the deletion of rows containing specific elements, conversion of string elements for all columns, and merging of tables as required.-----⚫ Used Playwright to simulate 5 kinds of interactions with Amap and Meituan websites, extracting search results and information⚫ Implemented jieba for string segmentation, word2vec for vectorization, and Levenshtein ratio to compare Amap and Meituan results, then structured and exported data using pandas⚫ Employed pdfplumber to search for keywords in insurance policy PDFs, extracted time-related info using regex, and transformed it into JSON for API interface, develop it to be a small interface can be linked by Socket

Minneapolis, Mn

This project is to collect data about the borrowing and collateral situation of many accounts, then detect whether these accounts should be liquidated or not, and then persist data in the database and display it on the website.• Utilized Python Jupyter to fetch data about account and their cryptocurrency information, e.g. account address,token address, collateral, borrow, and health of the account• Fetched data from multiple various companies’ APIs by using requests and decoding by JSON library• Crawled data from various resources with BeautifulSoup library and then verified the data with original• Deployed the code to AWS, and wrote a cron table file to auto-run the code on Ec2 AWS• Integrated Testflight with the company’s latest version of the app and wrote various test cases• Designed test cases for the Definer app in IOS, such as importing or creating wallets, showing money, plot and APR of each token daily, and its invitation and reward system, etc.---⚫ Used Python in Jupyter to retrieve account and cryptocurrency data from multiple companies' APIs and various sources, verifying it against the original, deploying the code on AWS, and setting up a cron table for automatic runs on EC2⚫ Designed about 50 test cases for the IOS Definer app, covering actions like importing wallets, displaying token details, daily plots, APR, and testing its invitation and reward system manually

Master Of Science - Ms, Computer Science, 3.7/4.0

Bachelor Of Science - Bs, Computer Science, 2.68