Yu Chen Email & Phone Number

New York, Ny, Us

Nashville, Tn, Us

Nashville, Tn, Us

- Responsible for maintenance and support of application life cycle within our Risk systems- Work on a small team of 2 developers reporting to the Chief Risk Officer. Responsible for all Risk application systems including data and reporting within Arya. - Responsible for maintenance and monitoring of the application system’s lifecycle. Using a variety of tools such as PCS, MIK, PowerShell, Python, C#, and MS SQL Server.- Load data from Barra and Risk Metrics into Risk Systems using SQL/C#/PowerShell. - Build and automate dashboards for management/investor relations/operations in SSRS/Excel using T-SQL/C#/Python. Dashboards revolve around the Funds and each Portfolio Manager’s performance (Pnl, Exposure). - In charge of all database issues with SQL Server. Rewrote store procedures, functions, and ad hoc queries for performance. Creating/fixing new indexes on tables. Troubleshoot and resolve issues with locks, read, and random job errors within the existing system. Review/fix existing data pipeline issues.

New York, New York, Us

- Reported to the Senior Director of Data Engineering. The data engineering team consisted of 15 developers and 3 managers. I was one of the 3 managers and managed a team of 3 developers and 1 analyst. - Lead the migration of data from MS SQL Server to Google Cloud BigQuery using a mix of T-SQL, SSIS, GSUtil, and Ascend. IO. Query job times went from 10 hours to 10 seconds.- Part of the product evaluation team to onboard cloud base products like SnowFlake, Azure, AWS, and GCP.- Work with Microsoft to assess our databases in the cloud. Tested the feasibility of integrating Azure products into our systems. - Lead the implementation of the Financial ETL base system. Automating manual work that was done by 4 people every month. Free up about 50% of their time each month. - Responsible for 45% of all reporting data within Harpercollins. Built and maintain data/reports for Sales, Marketing, Data Science, and Finance. - Budget and negotiate salaries within the team. Do regular yearly performance reviews with team members. - Mentor team members and help them along with their careers.

New York, New York, Us

- Rewrote the digital analytics vendor point of sale database. Load performance went from 1:30hrs to 15 minutes. Improve stored procedure call performance from minutes to seconds. - Redesign and built a new scraping database. Untangled data using SQL to improve performance and efficiency. Load times and query times went from 2 hours to 30 minutes. - Supporting the backend of HarperCollins’ proprietary TitleView platform. TitleView platform is the presentation layer of our scrape and point-of-sale data. - Manage and maintain existing legacy SSRS 2008 R2 reports. Responsibilities include updating, fixing, and troubleshooting reporting issues. Optimize poor-performing reports. Help end users troubleshoot data reporting issues.- Manage in-house-built VBA applications with about 1200 users. Responsible for level 2 support for issues related to the application. Manage consultants to improve and add new features to the application. - Responsible for developing, deploying, and scheduling SSIS packages. Managing 150+ SSIS jobs in SQL Server Agent/Cisco’s Tidal. - Designed and built the data assets for the data science team. Allow the data science team to run algorithms to identify high-value products for sale.

New York, Ny, Us

- Develop and design new procedures for the existing C# Windows form application. Load times went from 30 minutes to 2 minutes—fixed time-out errors related to the database within the application.- Wrote and maintained SQL server functions for loading and calculations. Calculations were used in things like form PF, Opera, and 13F.- Design, build, and release Advise's custom rule base system turning generic terms into regulatory form-specific terms. Allow for one source of entry for multiple regulatory form filings. - On-call production support for client databases. Responsible for being the technical database resource with client regulatory form filings.

New York, Ny, Us

- Extract, Transform, and Load (ETL) upwards of 20 million rows daily from production data sources (MySQL/MariaDB/Postgres) to SQL Server using SSIS with ActiveBatch.- Built ad-hoc reports for any department upon request. Reports are used to help generate leads and revenue. One 15-minute report helped add 100K in revenue each month.- Built SSAS cubes for marketing ad campaigns. Marketing managers could allocate ad dollars to various campaigns based on performance.