Yuhan Chen
Pittsburgh,PA
Overview
3
3
years of professional experience
Work History
Data Scientist
Emerson Electric.co
01.2023 - 05.2023
- Developed an automatic energy efficiency analytics platform to ensure both energy-saving marketing campaigns and government-backed energy-saving policies are in place and effective
- Delivered interactive dashboards using Power BI to monitor key indexes such as Energy Efficiency Rate and Renewable Energy Usage for the emission reduction project
- Selected and created new calculations with DAX, generated monthly reports, and facilitated prompt detection and intervention in abnormal emission changes, resulting in a 67% reduction in the project life cycle
- Designed and implemented a Snowflake schema model and a robust database by using Power BI and SQL Server and successfully enhanced the data accuracy by 22%
- Supported the development of the Apache Hadoop-based big data platform for energy usage and pricing analytics purposes and developed extensions for analytics optimization and improved the overall analytics scale by 40%
- Managed the implementation and deployment of an AWS-based cloud platform and deployed 3 machine learning-based extensions and successfully increased the overall analytics efficiency by 20%.
Business Insight/Data Analyst Intern
IQVIA
07.2021 - 10.2021
- Developed a Salesforce-based marketing/sales/business/cost measurement and optimization platform for business performance monitoring and insight analytics purposes and supported the management team to develop a business reporting dashboard to improve transparency and efficiency
- Developed a machine learning-based marketing analytics and sales forecasting platform by utilizing transformer-based forecasting/ensemble methods/wavelet-based method/dynamic factor model to create customer segmentation report/churn analysis/marketing campaign performance reporting/product performance reporting/budget and cost analysis and increased the reporting efficiency by 35% and increased overall analytics accuracy rate by 43%
- Developed a snowflake-based big data platform and deployed the data used across covered products to the platform and successfully increased the project execution efficiency by 45%
- Managed the development of analytics extension (e.g., machine learning-based analytics
- Advanced modeling-based analytics) and successfully passed the tool validation tests without critical issues
- Designed a data ETL workflow using SSIS for covered projects and integrated stakeholders from business, data science, and engineering teams into the newly developed workflow.
Business Data Analyst Intern
McKinsey & Company
11.2020 - 04.2021
- Developed and optimized a CRM-based customer insight analytics tool and implemented an insight research add-on suite for analytics optimization purposes
- Designed and developed an end-to-end marketing strategy measurement and optimization framework by including Market Research and Analysis/Customer Segmentation/Product Messaging and Positioning/ Product Launch Strategy/Pricing Strategy/ Continuous Measurement into the daily monitoring scope and increased the monthly sales productivity by 15% and improved the overall transparency by 18%
- Executed the statistical methodology-based marketing research analysis including Factor Analysis/Regression Analysis/ A/B testing/ Hypothesis Analysis using Python and generate insights for the client’s sales and marketing team.
Business Insight Analytics Intern
Ernst & Young
06.2020 - 10.2020
- Utilized sales and external data to research key trends of market/product/customer and developed a product monitoring system by using Excel, Salesforce, and Tableau
- Designed and developed an automatic business performance measurement platform by including market segmentation analysis/cluster analysis/churn analysis/lifetime value analysis/behavioral segmentation into the daily reporting and analysis procedure and provided recommendations to business stakeholders
- Created a business operations measurement plan for all procedures in the sales and marketing process and successfully increased transparency by 28% and decreased the incident rate by 35%.
Education
Master of Science - Business Analytics
Carnegie Mellon University - Tepper School of Business
Pi05.2023
Bachelor of Science - Labor and Social Security
Xi’an Jiaotong University
07.2022
Skills
- Business Skills: Digital Transformation, Database Management, ETL process development and management, Big Data Deployment, Data Warehouse, Data Modelling, Data Governance, Cloud Platform Research and Development, Data Security and Compliance
- Technical Skills: SQL, Python, SAS, R, STATA, C, C, Snowflake, Oracle Database, Python, Tableau, Google Analytics, Power BI, Jira, Confluence, VBA, DAX, HiveQL
Timeline
Data Scientist
Emerson Electric.co
01.2023 - 05.2023
Business Insight/Data Analyst Intern
IQVIA
07.2021 - 10.2021
Business Data Analyst Intern
McKinsey & Company
11.2020 - 04.2021
Business Insight Analytics Intern
Ernst & Young
06.2020 - 10.2020
Master of Science - Business Analytics
Carnegie Mellon University - Tepper School of Business
Bachelor of Science - Labor and Social Security
Xi’an Jiaotong University
Similar Profiles
Maropene Sarah SeyakamelaMaropene Sarah Seyakamela
Acting Quality Inspector at Eaton Electric.coActing Quality Inspector at Eaton Electric.co
Stella Mariz MarcelinoStella Mariz Marcelino
Technical Support Engineer at Emerson Electric Asia (Emerson)Technical Support Engineer at Emerson Electric Asia (Emerson)
Allison BeckleyAllison Beckley
General Music Teacher, Choir Director at Emerson School DistrictGeneral Music Teacher, Choir Director at Emerson School District
Robert HamptonRobert Hampton
Warehouse Worker at Monogram FoodsWarehouse Worker at Monogram Foods
Mary Ann HammillMary Ann Hammill
Staff Accountant at Bruns Gelles & CompanyStaff Accountant at Bruns Gelles & Company