Yiran (Esa) Sun

347-***-**** adb3wn@r.postjobfree.com www.linkedin.com/in/yiran-sun

SUMMARY

An MSBA candidate passionate about storytelling through data and solving complex business problems through strategic thinking, seeking an opportunity in the technology industry to take challenges, responsibilities, and accomplish goals. Experienced in projects and team-based fields which cultivated my analytical, self-motivated, and collaborative mind.

EDUCATION

William and Mary, Raymond A. Mason School of Business

Master of Science, Business Analytics Expected May, 2020

Relevant Coursework: GPA: 3.68/4.00

- Machine Learning - Database Management - Optimization - Big Data

- Artificial Intelligence - Data Visualization - Heuristic Algorithms - Statistics for Management

The Pennsylvania State University, Smeal College of Business May, 2018

Bachelor of Science, Supply Chain & Information Systems / Minor in International Business GPA: 3.50/4.00

TECHNICAL SKILLS

Optimizations using Python or Excel, statistical computations using R, database management in SQL and Alteryx, and visualizations in Tableau. Highly proficient in Excel: data cleaning, data modeling, pivot tables, lookups, solver& goal seek

Project:

-Leveraged data analytics to provide buyers and sellers with market knowledge on neighborhood, demographics, and real estate pricing trends, and evaluated potential growth and risks for home values with teammates

-Designed data warehouse, created and implemented ETL plans for extracting, transforming, and loading data into the data warehouse by utilizing Alteryx and MySQL

-Created visualization reports through Tableau, and provided professional business and analytical insights

WORK EXPERIENCE

AIREA Real Estate, New York, NY November 2018 – June 2019

Real Estate Analyst

·Conducted market research of real estate properties, negotiated with landlords for current and future collaboration, and built trustworthy client relationships to increase agency’s acquisition rate and foster company growth

·Analyzed timely real estate rental and sales data by utilizing data and pivot tables in Excel and predictive analysis in R, and determined competitive market strategies to facilitate business deals and generate revenues

·Increased efficiency by 40% through cultivating relationships with banks, mortgage lenders, brokers and attorneys

Fresh Digital Group, New York, NY September 2018 – November 2018

Strategy Analyst Intern

·Forecasted growth rates and sales trends, and performed ROI analysis through conducting market research on key competitors, client demographics, and usage patterns of voice application in North America

·Designed voice application skills for clients and made pitch proposals and presentations, customized application scenarios based on clients’ specific requirements

·Improved innovative products by testing and modifying design plan, recorded usage scenarios and evaluated success rates using Excel, and created data visualization graphs and dashboards in Tableau

·Programmed specific strategies for voice conversations through Pull-String and R programming

China-Israel Innovation Center, Yunnan, China May 2016 - August 2016

International Business Consulting Intern

·Evaluated new technologies developed by Chinese and Israeli firms in intelligent hardware, medical treatment, and high-end manufacturing to promote collaboration in innovation and entrepreneurship

·Utilized Tableau and Excel to compile financial and productivity data reports and performed strategic sourcing, matching Chinese and Israeli firms and later assisted in contract negotiations for investments into specific projects

ADDITIONAL INFORMATION

Leadership: Chinese Student & Scholar Association (PSU) - Sports & Recreation Department Chair 2014 – 2018

·Coordinated the execution of all sports and recreation activities hold by CSSA; established Basketball Tournaments

Volunteer: Community Service Volunteer & English Teacher at rural elementary schools in China

Languages: Bilingual in English and Mandarin Chinese Fun Fact: Fresh YouTuber who makes travel vlogs on channel

Contact this candidate