Yilian Chen's Email & Phone - Prometheus Real Estate Group

About Yilian Chen

SQL Developer @ Prometheus Real Estate Group San Francisco Bay AreaSQL Programmer/Analyst @ First Tek, Inc. Centralize 17 distributed databases and maintain the data integrity by creating various stored procedures, functions, monitor the database using SQL profiler and database engine tuning advisor.Work with other SQL Programmers to tune the stored procedures using Execution Plans to reduce the cost and increase the efficiency. Build various SSIS packages like data integrity packages, incremental loading process to extract, transform and load data from various sources into final destination like SQL Server databases, MySQL databases, XML ,flat files. Manage SQL Server transactional replication. Provide guidance to Data Analyst ensuring that programs are executed by the instructions. Support QA, Stage developments, release management and code migration process. Use SQL Profiler to analyze and capture the stored procedures under different GUIs. Analyze requirements and design solutions to meet business requirements. Provide design proposals following best practices considering data, business and service layers for all system changing.Communicate with all levels of staff including team members, administrators, business analysis, project manager and data analyst. Reports progress to Manager on a regular basis. Test and debug codes and solutions in various environments. From April 2015 to September 2017 (2 years 6 months) San Francisco Bay AreaSQL Programmer @ Mobosense LLC Created and maintained the database objects like stored procedures, functions, views and triggers.Troubleshoot the issues behind the database, improved the database by creating indexes.Monitor SSIS packages using logging, analyzed the logging by SQL profiler and Database tuning adviser.Created SSIS packages to extract and load data from various source into the SQL Server as destination.Maintained the data integrity, and provide other technical support. From May 2014 to December 2014 (8 months) Urbana-Champaign, Illinois AreaTeaching Assistant @ Illinois Institute of Technology From January 2014 to May 2014 (5 months) SQL Server Developer @ Bank of Chengdu  Configured development environment. Used SSRS to generate Ad-hoc reports for personal financial tools; Migrated and integrated data from different departments and different types using SSIS, and implemented and analyzed OLAP cubes to generate pivot table in excel. Used HTML5 and CSS3 code to make employee manager webpage more functional and customizable. Maintained the data integrity by creating triggers. Create various stored procedures like insert new came in data to corresponding table, update all customers’ score every month, and delete expired records, and for report generation. From October 2010 to May 2012 (1 year 8 months) Chengdu, Sichuan, ChinaWeb Developer(Intern) @ Huadi Company Wrote requirements analysis, configuration report, and design analysis; developed a concise and uniform web interface using CSS.; Designed test cases and wrote the test program in JAVA. From June 2010 to September 2010 (4 months) Chengdu, Sichuan, China

Yilian Chen’s Personal Email Address, Business Email, and Phone Number

are curated by ContactOut on this page.

Yilian Chen's Work Experience

Prometheus Real Estate Group

SQL Developer

San Francisco Bay Area

First Tek, Inc.

SQL Programmer/Analyst

April 2015 to September 2017

San Francisco Bay Area

Mobosense LLC

SQL Programmer

May 2014 to December 2014

Urbana-Champaign, Illinois Area

Yilian Chen's Education

Sichuan University

Bachelor's degree, Software engineering, 3.2 out of 4

2008 to 2012

Illinois Institute of Technology

Master of Computer Science, Computer Science, 3.5

2012 to 2014

About Yilian Chen's Current Company

Prometheus Real Estate Group

Frequently Asked Questions about Yilian Chen

What company does Yilian Chen work for?

Yilian Chen works for Prometheus Real Estate Group

What is Yilian Chen's role at Prometheus Real Estate Group?

Yilian Chen is SQL Developer

What is Yilian Chen's personal email address?

Yilian Chen's personal email address is y****[email protected]

What is Yilian Chen's business email address?

Yilian Chen's business email addresses are not available

What is Yilian Chen's Phone Number?

Yilian Chen's phone (213) ***-*153

What industry does Yilian Chen work in?

Yilian Chen works in the industry.

Who are Yilian Chen's colleagues?

Yilian Chen's colleagues are Marilisa Ninno, Saba Dasadawala, John Owrey, Dongqi Wen, Aaron Cook, Teo Inke, Denise Moriarty, Sneha Vilayur, Wilhelm Wimmreuter, and Rushabh Vedia

10x your recruitment & sales conversations

Contact over 200M professionals
instantly by email or phone. Reveal
personal & work email addresses, as
well as phone numbers accurately with
our ContactOut Chrome extension.