Shuocun Yang
BI Reporting Engineer
Aurora,CO
Summary
A committed performance-driven Business Intelligence Engineer professional with over 3+ years of experience in implementing end-to-end BI solutions using Hadoop environment, Tableau, and Power BI. Focused on bringing value to organizations through a blend of technical leadership, business knowledge, and team focus. Competent Reporting Engineering professional offering foundation in engineering project management and design. Detail-oriented with strong knowledge of business analytics and Python.
Overview
4
4
Certifications
9
9
years of post-secondary education
5
5
years of professional experience
Work History
BI Reporting Engineer II
Arrow Electronics, INC
Centennial, CO
03.2019 - Current
- Led strategic business intelligence initiative and developed BI ecosystem for Arrow.com and subsidiaries.
- Developed BI reports and data sources that provided executives in multiple regions with access to live Marketing, Finance, and Web Traffic data.
- Developed various ETL processes and optimized data structures for connections between big data environments and BI tools.
- Constructed data lakes and models in Hadoop and Google BigQuery to integrate various unstructured and disjointed data sources.
- Performed advanced analysis including Customer Classification analysis using Python’s machine learning capability that provided Marketing team with campaign suggestions, which led to 8% revenue growth year over year.
Marketing Analytics Intern
Arrow Electronics, INC.
Centennial, CO
06.2018 - 03.2019
- Created statistical models that segment customers and forecast revenue based on campaign spending.
- Optimized forecasting and budgeting analysis based on historical data that helped SEM team saved 25% budget from overspending on specific channel.
- Collaborate between Marketing and Data Engineering teams on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
Research Assistant
University Of Denver
Denver CO, CO
06.2016 - 03.2018
- Topic: Global Pharmaceutical Consortium Engagement. Design and implement database setup, load, and administration.
- Apply Tableau, SQL, PowerBI, and SSPS tools to model and visualize consortium and company details: data mining, map, and cluster analysis. Data referenced by research papers submitted to multiple international conferences.
Assistant Store Manager
Toys"R"Us
Zhengzhou, China
12.2015 - 06.2016
- Measured daily sales using ERP and Excel tool packages, reported weekly and monthly store performance to district manager to help adjust sales forecast and budget.
- Monitored variances and loss, managed inventories using inventory management software.
Education
Master of Science - Business Analytics
University Of Denver
Denver 08.2016 - 03.2019
MBA - Business Analytics
University Of Denver
Denver 08.2016 - 03.2019
BBA - Business Administration
Fort Hays State University
Hays, KS 08.2010 - 06.2014
Skills
Programing: Python, Bash, SQL, HiveSQL
Google Cloud Platform (BigQuery, ML, and Repository)
Hadoop Cluster
Alteryx
Business Intelligence Roadmap Design
Business Intelligence Tools (Power BI, Tableau)
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
Alteryx Core Certification
Quote
Every problem is a gift—without problems we would not grow.
Tony Robbins
Timeline
BI Reporting Engineer II
Arrow Electronics, INC
03.2019 - Current
Marketing Analytics Intern
Arrow Electronics, INC.
06.2018 - 03.2019
Master of Science - Business Analytics
University Of Denver
08.2016 - 03.2019
MBA - Business Analytics
University Of Denver
08.2016 - 03.2019
Research Assistant
University Of Denver
06.2016 - 03.2018
Assistant Store Manager
Toys"R"Us
12.2015 - 06.2016
BBA - Business Administration
Fort Hays State University
08.2010 - 06.2014