Hi, I’m
You Wang
Fargo,ND
Summary
Engaged in ongoing learning and skill development with a focus on Azure Synapse Notebook, Azure Data Lake Storage (Gen2), and Power Automate. Holds six years of hands-on experience in R programming. SAP S/4 HANA and SQL language, as well as four years in econometrics modeling, specializing in trend analysis and business cycle forecasting using the ARIMA model. Proficient in data visualization tools such as Tableau, PowerBI, Excel Power-view, Excel 3D map, Excel Analysis, SAP WebBI and SAP Lumira. Excels in storytelling through data, with strong skills in interpreting and visualizing information, as well as proficiency in clustering, classification, and leveraging statistical tools for modeling, analysis, and reporting.
Overview
8
years of professional experience
5
Certification
Work History
Border States Electric
Analytics Developer
04.2019 - Current
Job overview
- Drives the data and analytics strategy, design, and implementation of solutions that enhance descriptive reporting, predictive forecasting, prescriptive analysis, planning, optimization process, and business insights
- Analyzed code and corrected errors to optimize output: R Studio, SAP HANA Studio, SQL, PowerBI, Power Query, SAP Webi)
- Completed continuous project and team reviews to maintain optimal productivity and quality of work.: Macroeconomic/Business cycle analysis (2) Annual sales forecasting
- Owns the design, development, and maintenance of dashboards and their underlying data sets/ internal & external data size :10GB+ data domain: Geo, time series, and stationary (1) Market Share project (2) Share of the Wallet Project
- Developed and maintained ETL processes for data extraction, transformation, and loading from multiple sources (APIs, Raw files etc) into the data warehouse.
- Conducted training sessions for internal staff members on how to use newly developed BI solutions effectively and efficiently.
Blue Cross Blue Shield of North Dakota
Healthcare intelligence Analyst
08.2018 - 04.2019
Job overview
- Responsible for analyzing and reporting a variety of statistical and clinical data (1)Logistic Regression: analyzing the statistical associations (correlations) between risk factors and the outcome
- Complete special projects as assigned using Tableau, ensuring that all information meets the highest data integrity. (1) Data visualization, (2)Statistical analysis
Border States Electric
Data and Segment Analyst
11.2016 - 08.2018
Job overview
- Responsible for Raw Consumer Data Cleaning: SAP Customer Master (KNA1, KNKK, KNVV etc) using R studio, Hoover data and Excel (Pivot Table Power Query)
- Conduct market research: Competitive landscape, Customer Analysis and Potential Market size
- Assisting Senior Market Intelligence Analyst for Data Visualization
- Optimized data gathering processes, analysis procedures, and visualization strategies.
- Working with Senior Market Intelligence Analyst to provide insights for survey data by using statistical analysis and data visualization
- Upon on requests, responsible for creating SAP reports, using SAP webi/Lumira/design studio SAP Hana Studio (with PAL/BFL library) and Excel Analysis
Berkley Net Underwriters LLC
Data Analyst
03.2016 - 09.2016
Job overview
- Working with IT Technical Lead, Captured the batch time running issue by using data visualization/Tableau
- Developed Excel templates with the team leader for data testing
- Successfully reduced 2 months’ labor for 5 people to a mere 3 days’ worth of work for 1 person
- Developed SAS code for financial& BI project for data comparison
- Significantly reduced labor hours
- Using SQL, Excel and Tableau extensively to perform SQL query testing, data comparison, and data visualization
Education
Carl H. Lindner College of Business, University of CincinnatiCincinnati, OH
Master of Arts from Applied Economics
12.2015
University Overview
- Econometrics, Time Series Econometrics; VAR , ARIMA and Dynamic Model, Bayesian Econometrics, Data Visualization
- GPA: 3.8/4.0
- The Graduate Incentive Award
Minnesota State University Moorhead (MSUM)Moorhead,MN
Bachelor of Arts from Economics
05.2014
University Overview
- Honors: Magna cum laude
- GPA: 3.74/4.0
- Dean's List : 2011-2013
- Upper Class Scholarship recipient, 2013-2014
Skills
- Big Data Technologies/Machine Learning : R Studio, Azure Synapse Analytics (Spark Notebook)
- Data Warehousing : SAP S/4 , SAP Hana Studio, SQL server, Azure SQL
- Report Generation/Data Visualization: PowerBI (Dax code), Tableau , SAP webBI
- Experience with SPSS, Stata, Maple, GeoDa
- Proficient in Word, Advanced Excel (Pivot Table, Power View, Power Query) and PowerPoint
- Market Analysis
- Trend Monitoring
Certification
- SAS Statistical Business Analysis Using SAS 9: Regression and Modeling
- Google Analytics certification
- 5 Certifications from DataCamp : Intermediate R/ Writing Functions in R/ Cleaning Data in R/ Machine Learning Toolbox/Exploratory Data Analysis
publications
An Economic Analysis of Housing Market Instability and Affordability in China., Undergraduate Economic Review, Vol. 11, Iss. 1, Article 5, 2014, In EViews, processed and cleaned economic indicators and housing data across 72 cities Applying an intertemporal optimization model proposed by Aizenman and Marion (1991), quantified instability in the Chinese housing market. Visualized housing affordability using Excel Identified macroeconomic factors as significant explanatory variables to the instability of housing prices. Invited to present at the 2014 Minnesota Undergraduate Research Conference
Languages
Chinese (Mandarin)
Native or Bilingual
English
Full Professional
Timeline
Analytics Developer
Border States Electric
04.2019 - Current
Healthcare intelligence Analyst
Blue Cross Blue Shield of North Dakota
08.2018 - 04.2019
Data and Segment Analyst
Border States Electric
11.2016 - 08.2018
Data Analyst
Berkley Net Underwriters LLC
03.2016 - 09.2016
Carl H. Lindner College of Business, University of Cincinnati
Master of Arts from Applied Economics
Minnesota State University Moorhead (MSUM)
Bachelor of Arts from Economics
- SAS Statistical Business Analysis Using SAS 9: Regression and Modeling
- Google Analytics certification
- 5 Certifications from DataCamp : Intermediate R/ Writing Functions in R/ Cleaning Data in R/ Machine Learning Toolbox/Exploratory Data Analysis
Similar Profiles
Wilmot JohnsonWilmot Johnson
Forklift Operator/ Material Handler at Border States ElectricForklift Operator/ Material Handler at Border States Electric
Calvin NelsonCalvin Nelson
Account Manager at Border States ElectricAccount Manager at Border States Electric
Casey Le FevreCasey Le Fevre
Receiving Associate at Border States ElectricReceiving Associate at Border States Electric