Yilian Chen
About Yilian Chen
Yilian Chen is an SQL Developer at Prometheus Real Estate Group in the San Francisco Bay Area, where he has worked since 2017. He holds a Master of Computer Science from the Illinois Institute of Technology and has experience in data migration, report development, and web development.
Work at Prometheus Real Estate Group
Yilian Chen has been employed as an SQL Developer at Prometheus Real Estate Group since 2017. In this role, Chen focuses on developing and managing SQL databases, contributing to data-driven decision-making processes within the organization. The position is based in the San Francisco Bay Area, where Chen has utilized SQL Server Reporting Services to create custom reports, including various report types such as drill-through and parameterized reports.
Previous Experience at First Tek, Inc.
Before joining Prometheus Real Estate Group, Yilian Chen worked at First Tek, Inc. as an SQL Programmer/Analyst from 2015 to 2017. During this time, Chen was responsible for analyzing data and developing SQL queries to support business operations. This role provided valuable experience in database management and programming within a corporate environment.
Education and Expertise
Yilian Chen holds a Master of Computer Science degree from the Illinois Institute of Technology, where studies were completed from 2012 to 2014. Prior to this, Chen earned a Bachelor's degree in Software Engineering from Sichuan University, studying from 2008 to 2012. Additionally, Chen served as a Teaching Assistant at the Illinois Institute of Technology for four months in 2014, gaining experience in academic support and instruction.
Technical Skills and Projects
Yilian Chen has developed a range of technical skills, particularly in SQL and data migration. Chen has created SSIS packages to migrate data from various sources to SQL Server, employing transformations such as data conversion and merge join. Chen has also simulated scenarios to convert data from mobile sensors into executable instructions using JAVA and implemented an Automatic Teller Machine system utilizing design patterns.
Web Development Experience
In addition to database management, Yilian Chen has experience in web development. Chen has built a personal banking internal management website, an online gallery, and a personal website using PHP, HTML5, and CSS3. This experience demonstrates proficiency in front-end and back-end development, contributing to a well-rounded skill set in technology.