Yong Shi

Data Mart & Data Warehouse: Designed and built 10+ data marts and one data warehouse supporting enterprise-wide reporting, analytics and operational needs. These data marts empower Accounting, Marketing, Risk, and other departments to perform their own ad hoc analyses and reporting, and also feed data into technical systems such as the company's phone system, auto dialer, and automated email campaign platform.

ETL & Data Integration: Built, optimized, and maintained ETL packages using SSIS for the data marts and data warehouse.

SSRS Reporting & Analytics: Built 300+ SSRS reports and various ad hoc reports. Maintained 480+ active SSRS reports across financial, operational, and business areas such as loan origination, underwriting, collections, QA, marketing, risk, audit, title and sales. Managed the full SSRS lifecycle from designing to deployment, optimization, and maintenance.

Senior Business Intelligence Developer - Wheels Financial Group LLC - Van Nuys, CA

(2016-09 - 2025-10)

• Data Mart & Data Warehouse: Designed and built 10+ data marts and one data warehouse supporting enterprise-wide reporting, analytics and operational needs. These data marts empower Accounting, Marketing, Risk, and other departments to perform their own ad hoc analyses and reporting, and also feed data into technical systems such as the company's phone system, auto dialer, and automated email campaign platform.
• ETL & Data Integration: Built, optimized, and maintained ETL packages using SSIS for the data marts and data warehouse.
• SSRS Reporting & Analytics: Built 300+ SSRS reports and various ad hoc reports. Maintained 480+ active SSRS reports across financial, operational, and business areas such as loan origination, underwriting, collections, QA, marketing, risk, audit, title and sales. Managed the full SSRS lifecycle from designing to deployment, optimization, and maintenance.
• Power BI: Data cleansing and modeling; Dashboards and data analytics; Paginated report.
• System Administration: Administrated SSRS and SSIS servers, managing security roles, user groups, data sources, deployments, and scheduled jobs. Worked on SSRS migrations across versions, including server and report reconfiguration and validation.
• SQL Development & Optimization: Created SQL queries, stored procedures, and ETL logic to support the company's reporting and operational processes. SQL query tuning and performance optimization. Assisted various business teams, such as Risk, Marketing, and Accounting, to revise and optimize their working SQL codes to ensure data accuracy and query performance.
• JSON Data Modeling & Data Integration: Designed relational data model and database schemas to hold data parsed from JSON data. Build JSON parsing logic and scripts. Collaborated with software engineers to integrate them into automated data pipelines to load data into SQL Server database.

Business Intelligence Developer - Wheels Financial Group LLC - Van Nuys, CA

(2014-09 - 2016-09)

Associate Research Scientist - Air Force Research Lab - Albuquerque, NM

(2012-01 - 2014-06)

• Database administrator and data management for SAMBA magnetometer chain.
• Space Physics researches, analyzing satellite data of solar wind, Earth's magnetosphere, ionosphere and ground magnetometer data.

Assistant Researcher & Post Doctoral Researcher - UCLA - Los Angeles, CA

(2008-05 - 2011-12)

• Database administrator and data management for SAMBA magnetometer chain.
• Space Physics researches, analyzing satellite data of solar wind, Earth's magnetosphere, ionosphere and ground magnetometer data.

PhD - Space Physics - University of California, Los Angeles

B.S. - Atmospheric Physics - Nanjing University