Yilin is highly analytical Data Engineer with experience in financial analysis and full-stack software development; working on data programming, design, software and financial modelling. She comes on board with a strong qualitative and quantitative analytical expertise; acting as a technical point for the business intelligence needs of clients - analyzing trends to make better decisions, and building analytical tools and solutions.
Delivers data warehouse and ETL solutions as part of an agile team using advanced machine learning techniques to improve performance and processes.
Helps build and improve infrastructure, application and performance development and ensures tight security including data encryption, security groups, and environment scanning.
Ensures high-quality deliverables and implements DevOps and security best practices in fast-paced environments
Worked on setting up and installing AWS RDS on PostgreSQL and an AWS EC2 environment, in order to connect the database. The configuration involved adding new users to the SQL database, configuring users to access remote desktops, and granting access to various user groups.
Managed to design and implement a relational SQL database to store data, also creating 14 tables to store data from ETL and three views for Tableau dashboard views.
Used Python to create a script for automatically downloading emails' attachments and saving them to a folder for later use in the ETL process.
Using SSIS, Python, and C#, I designed and implemented an ETL process to import numerous data sources in various forms, including XLSX, CSV, XML, JSON, and EBCDIC.
Performed data analysis on the current database in order to improve data accuracy. Collaborated with the sales team to manage data requests from customers.
Used Power BI to create vital data reports for tracking the tasks and jobs in the database.
Designed and implemented UI solutions for TD Bank, and automated the workflow and reporting system on the project using Excel VBA and Microsoft Access database VBA for the business team.
Produced TD Bank's CVar, Asset depletion, and portfolio risk score on its finance models, maintained existing solutions and developed new ones to help TD Bank make strategic decisions.
Designed SSIS packages and SQL stored procedures for ETL pipelines and dataflow, worked on a WinForms solution to manage real-time market movements and risk metrics calculation and maintained documentation for internal apps.
Worked on a solution that seeks to help taxi drivers earn more revenue daily using big data. It takes advantage of the 2016 New York Green Taxi trip data from NYC'S open data source in building the algorithm. Random forest, an innovative machine learning technique is used for predicting factors that can affect total revenue on the solution.
Rebuilt the CVaR model on the project, improving the logic needs on the solution, adding new features to help simulate other different kinds of portfolios. The solution had a centralized database - working to streamline and document all SSIS packages, SQL queries, stored procedures and C scripts. Redefined the CVaR database and table structures, redesigned the logic, filtered market data - to minimize the impact of missing data on the module, with easy modifications for debugging. Implemented new functions and configuration files on the solution.
Worked on the implementation of a relational database that helps users manage the collection of various types of taxes by a State Agency. The solution was accessible to both individuals and companies, read-replica features, backup function every 2 hours and SQL scripts and stored procedures implementation for writing relevant information on the database.
Education
MSc. Data Science and Analytics
Ryerson University
2016 - 2017 (1 year)
Charted Financial Analyst (CFA) Level 1
CFA Institute
2016 - Present (8 years)
Bachelor of Mathematics, Financial Analysis & Risk Management
