Ye Wang
214-***-**** **@***.*** www.linkedin.com/in/yewangsmu
EDUCATION
Southern Methodist University, Cox School of Business Dallas, TX
Master of Science in Business Analytics (GPA: 3.6) May 2020
Southern Methodist University, Lyle School of Engineering Dallas, TX
Master of Science in Engineering Management, Information & Systems (GPA: 3.6) May 2019
Shijiazhuang Tiedao University Beijing, China
Bachelor of Science in Building Environment and Energy Application Engineering (GPA: 3.7) May 2016
TECHNICAL SKILLS
Programming Languages and Database Management: Python• R• AWS (Machine Learning) • SQL • Apache Spark •SAS• VBA
Visualization Tools and Frameworks: Tableau • Power BI • Alteryx • Google Analytics • Spotfire • KNIME • SIMIO • AutoCAD
PROFESSIONAL EXPERIENCE
China Power Conservation & Environment Protection Corporation Beijing, China
Business Analyst Apr 2016 - Aug 2017
Returned $5M in sale revenue with 12 winning bids within first year by assisting sales managers to complete bid projects by editing business documents and managing teams with Agile methodologies
Maximized efficiency/accuracy criteria by creating database that segmented customers based on technology needs
Delivered interactive marketing performance in efficiency and quality dashboard in Power BI for marketing team to make informed decisions about bidding planning for each quarter to meet the year-end target and to effectively use allocated budgets in bidding process
Presented top competition overview, and ranked competition based on their capabilities, bidding habits, executive leadership, and customer presence, enabling division management to make better-informed decisions
Organized 3 exhibition conferences for +10K attendees and directly interfaced with clients representing $1M of business, pitching new business opportunities and market change information
PROFESSIONAL ACADEMIC PROJECTS
DeGolyer and MacNaughton Petroleum Consulting Jan 2020 - Apr 2020
Developed strategic business plan for Asia-Pacific Latin America to build out data warehouse and to predict potential oil fields capacity using data-driven models, and recommended to implement Microsoft 2019 SQL Server
Built private server running docker containerized Hadoop data nodes to store all of world's oilfield data including production rates to the most granular level available
Containerized Anaconda with Spark/Python to ETL data sources and stored them on 8TB Hadoop system
Utilized Spotfire to create oil well geospatial pattern and oil/gas/water production visualizations, and predicted oil production decline curves of oilfields using Graphics Processing Unit
PSAV, Global Event Production Company Aug 2019 - Oct 2019
Led project to develop performance measurement reports for 300+ employees after defining 5 evaluation metrics
Extracted and blended employee historical data from sales and operation departments using Alteryx
Established user-interactive Tableau dashboards to visualize performance of employees, generated automated actionable insights, and recommendations and translated findings in a final presentation to large group of audience
Senior Design Project, Warehouse Picking Process Design Jan 2019 - May 2019
Developed and tested simulation model for designing and optimizing warehouse picking process in SIMIO
Performed network analysis to determine appropriate truck load capacity, real-time products scheduling, workers’ activities, and conveyor speed to support decision-making in the design of picking processes
LEADERSHIP AND ACTIVITIES INVOLVEMENT
Intercollegiate Athletics – SMU Men’s Volleyball Team Aug 2017 - May 2020
Southern Intercollegiate Volleyball Association (SIVA) Championship, Silver Bracket
Global Explorations in Entrepreneurship, SMU, Dallas, TX and Tel-Aviv, Israel Aug 2019 - Dec 2019
Collaborated with 3 MBA students to brainstorm startup ideas, conduct market validation and build prototypes
Established business model for high-end dog food and pitched to successful Israeli entrepreneurs