Data Analyst Social Media

Sean Sun

469-***-**** ********@***.*** Linkedin.com/in/seansun2020 Open to Relocation

Work Portfolio: https://drive.google.com/drive/folders/1RGguj2aDEpgtV3TAsA1rkO6smkCGQLts?usp=sharing EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics May 2020

GPA: 3.9

Coursework: Predictive Analytics, Data Mining, Data Visualization, Business Intelligence, Forecasting, Database Design, Decision Models, Probability Models, Big Data Platforms, Web & Social Media Predicative Analysis, Big Data Platforms, Project Management State University of New York - Stony Brook Stony Brook, NY Bachelor of Science in Applied Mathematics & Statistics May 2017 GPA: 3.2

Highlights: Accelerated a four-year degree to three years. GRE: Verbal 167/170 (98th Percentile), Quant 167/170 (92th Percentile) TECHNICAL SKILLS

Shiny/R • Python • Advanced Excel/VBA • Tableau • Alteryx • MS SQL Server • Power BI • MATLAB • KNIME • Zoho/DELUGE • ETL • Data Warehouse • Spark • NoSQL • Machine Learning/Statistical Algorithms • Azure • Java • CSV/XML/JSON Datatypes PROFESSIONAL EXPERIENCE

Wallace Finance Dallas, TX

Data Analyst May 2020 – Present

• Created and maintained database queries, stored procedures within SQL Server; reviewed data and classified the tables/measures functions by using multiple queries, views, and procedures

• Identified business needs with end-users to assist data migration effort to new MongoDB centralized data warehouse; developed report-level migration field mappings

• Built Power BI visualization reports showcasing insights supporting operational, financial and executive teams in identifying business trends and making informed decisions; simplified manual procedures, improving efficiency by 80% Cross Financial Strategies Dallas, TX

Business Analyst Intern Jan 2020 – Apr 2020

• Configured the enterprise structure and organizational units for the in-house business analytics process, increasing managerial efficiency by 70% and client satisfaction by 20%

• Developed interactive and informative dashboards with Zoho Analytics, visualizing key customer demographic and transactional information, empowering manager to identify business issues and trends efficiently Gao Feng Advisory Company Beijing, China

Research Analyst Sep 2018 - Dec 2018

• Evaluated market entry strategies for Nissan Japan Headquarter on Electric Vehicles and Ride-hailing services in China, collaborating effectively with cross-functional team members and clients from the US, Japan, and Hong Kong

• Constructed comprehensive PowerPoint slides contributing 15% of the final deliverable with high client satisfaction DRL Sports Ltd Beijing, China

Product Data Analyst Intern Aug 2018 - Sep 2018

• Improved performance of weekly sales reporting from 50 hours to 2 hours, over 300% improvement in code efficiency by incorporating Python into the current workflow, automating the reporting process; reduced error rate by 85%

• Analyzed sales data for director review with Excel: pivot-table, v-lookup, string manipulation and functions SELECTED ACADEMIC AND FIELD PROJECTS

iHeartMedia Case Competition - Runner-up Team – Machine Learning (Clustering) Jan 2020

• Led a team of three and presented optimal methods to allocate research funds for iHeartMedia CIO & top executives; won 2nd-place out of 22 participating teams

• Created groupings of similar radio stations with machine learning technique of hierarchical clustering using R, automatically generating radio station groupings of similar attributes with timely-updated data Flagship Credit - Data Visualization Sep 2019

• Led a team of five to work with Flagship's in-house analytics team; analyzed 70k+ loan application records

• Cleaned and analyzed data using Alteryx to identify key columns correlated to target variables

• Presented interactive dashboards with Tableau to meet customers' needs of accurate Early Payer Default identification Combined Course Projects - Predication /Clustering/Database Design/R-Shiny/Time-series Analysis Aug 2019 – Dec 2019

• Predicted essential business metrics under a variety of business cases by incorporating Linear/Logistic Regressions, Market Basket Analysis, kNN & k-means clustering, Neural Networks and Text Mining

• Created interactive R-Shiny website allowing user input, accessing MS SQL Server database and returning appropriate output

• Modeled various business optimization situations with advanced Excel/VBA, allowing user input and interactivity

• Performed time-series analysis and predicted EPS (Earning Per Share) for Dicks Sporting Goods with Excel and JMP

Contact this candidate