Summary
Overview
Work History
Education
Skills
Work Availability
Certification
Quote
Timeline
SoftwareDeveloper
Shuocun Yang

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

undefined

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

Similar Profiles

CREATE PROFILE
Shuocun YangBI Reporting Engineer