Yuan Lu Email and Phone Number

▪ Responsible for advanced analytics, feature engineering, and data pipelines on clinical data, working closely with ML team and business consultants.▪ Involved in end-to-end of ML workflow using SQL server and Spark.▪ Lead the design and implementation of Patient-centric data warehouse for Machine Learning modeling.

Leading project teams delivering data management solutions on cloud.Selected Projects:Enterprise Analytics Re-architecture for CMC Materials - Re-architected the data analytics platform from on-premises to Microsoft Azure solutions and blueprinted phased migration.- Re-factored EDW data model and ETL process adapting to Azure services. Reduced overall data processing time by 70%.- Led the implementation of data and service migration to Azure platform.IIoT Platform for Molex - Our team delivered a highly scalable IIoT solution on AWS monitoring industrial assets, which created a multi-million dollars revenue stream.- Implemented scalable data ingestion process to ingest high-frequency sensor data from S3 into MongoDB to achieve real-time analytics using Spark streaming.- Implemented reliability models using Spark Scala.

Business Intelligence Acceleration Project for TTX- Led the data modeling practice for the enterprise analytics solution using Erwin.- Designed and implemented daily incremental transaction data integration processes of client’s analytical data warehouse in SQL Server using SSIS and SQL stored procedures.- Designed and implemented both multi-dimensional OLAP cubes and Tabular model to meet the analytics requirements at the enterprise level using SSAS.- Implemented the best practices for optimal performance of the cubes.Cost Analytics Project for GE Aviation- Designed data management architecture and roadmap with timeline for client’s data driven analytics and decision making.- Led the data model development and datamart implementation to support cost analytics solution.- Led ETL development of historical data transformation in Greenplum using PostgreSQL to feed the solution data model which supports the cost analytics and metrics.

Locomotive Statistics Automation Project for GE Transportation- Design, development and the implementation of custom solutions for the analytics and risk teams.- Created data quality monitoring tasks using data profiles, business rules and exception reports to periodically test and report overall data quality in datamart using SAS programing.- Designed and built the data quality reporting dashboard using SAS Information Maps and Web Reports.- Built incremental data integration processes using SAS programing and SAS Data Integration Studio.Service Contract Analytics Project for Eaton Corporation- Designed and developed the Contract margin analysis dashboard and performance metrics using SAS OLAP cube and SAS Web reports.- Built data mining and data integration process using SAS Data Integration Studio for analyzing the business data from multiple data sources.- Provided an analysis of the client’s Service Contract Attach Rate using SAS programming (SAS STAT and time series analysis).- Built process jobs for automatic update of data profile for data quality measures and pattern analysis.

Worked on projects on data warehousing solutions, data integration and business intelligence.