Social Media Data

Yiming Guo

******@***.*** 520-***-**** **** S Lakeshore Dr, Tempe, AZ 85282

EDUCATION

• Arizona State University, W. P. Carey School of Business Tempe, AZ

• Bachelor of Science, Computer Information Systems GPA: 3.58/4.0 Bachelor of Science, Business Data Analytics Jan 2016 – Aug 2019

• Honors: Dean’s List

PROFESSIONAL SKILLS

• Development/Programming: Php, JavaScript, HTML, CSS, Python, C#, Java, R, T-SQL, Deluge

• Data analytics: Data Analysis, Data Visualization, Data Science, RDBMS, Data Warehousing, ETL, Data Mining, Data Modeling, Data Reporting, Business Intelligence, Hadoop, Machine Learning

• Tools/Platforms: Microsoft SQL Server (SSMS, SSIS, SSRS), MySQL, WordPress, Intellij IDEA, Zoho One, Postman, Access, Tableau, Power BI, Orange, Excel, Enterprise SAS Miner, Visual Studio, Anaconda, NetSuite, Amazon Workspace, GitHub

• Additional Knowledge/Experience: Agile/Waterfall, SDLC, Leadership, Teamwork, Critical Thinking, Problem Solving, Customer Service, Cyber Security, Accounting/Finance, Supply Chain, Marketing Analysis, E-Commerce, Account Management, Mandarin WORK EXPERIENCE

Intern E-commerce sales Xingcheng, CN

Tianlang (Group) Manufacturing Garment Co., Ltd May 2016 – Aug 2016

• Updated and tracked swimwear sales using Excel through Aliexpress.com and ensured the business process ran smoothly.

• Managed the shipment of products from warehouse to consumers on time resulting in at least 4 stars customer satisfaction.

• Networked with e-commerce companies and manufacturers through LinkedIn and other social media platforms to increase business opportunities and drive sales.

Business Systems Analyst Phoenix, AZ

LTMD HEALTH LLC Jan 2020 – Oct 2020

• Created ERD and Data Mapping for Zoho CRM based on the business needs and ideal business process.

• Worked both individually and in a team environment in a timely manner using Agile methodology.

• Advised CEO, VP, and consultant on designing business operating processes, workflows, and approval methods for Zoho CRM.

• Administrated Zoho One to enhance employee users and apps for on-boarding, training, off-boarding, and support.

• Used Deluge scripts to create automation and API requests for Zoho CRM and other related apps.

• Worked with UI developer to create company job listing pages front-end using HTML, JavaScript, and CSS and back-end using Php, Postman, JSON, and API request to integrate Zoho CRM data with the webpage in WordPress. School PROJECT EXPERIENCE

Tempe, AZ

Follow Through, Eye on U Jan 2018 – May 2018

• Drew ERD for a property management company client named Eye On U.

• Collaborated with a team to develop the metadata and database for the company.

• Applied trigger/procedure into the database and applied index/query plan to enhance the performance by SQL coding.

• Used Tableau to visualize our report of this project. Developer Team, Recipist Jan 2019 – February 2019

• Developed a web page for users to post recipes using Scrum development methodology.

• Worked on a separate page using HTML, CSS, JavaScript, jQuery, then altogether pushed to GitHub.

• Connected database with C# code to store user account table attribute and recipe table attributes. Team Leader, Find Your Clothes April 2019 – May 2019

• Provided a business problem solution that helped users navigate their clothing stores to have their ideal products and delivered a mobile application.

• Assigned each group member’s work in spirit time and manage meetings.

• Designed the front-end of the mobile application using HTML, JavaScript, C#, and Adobe mobile SDK. Team Member, Hospital Compare Data Project July 2019 – Aug 2019

• Compared hospital datasets and chose the right datasets to analyze hospitals’ performance.

• Used SAS to run the decision tree to demonstrate relevant variables and used R to run regressions for its performance.

• Wrote a group conclusion paper to report our analysis. Heart Disease UCI July 2019 – Aug 2019

• Used Python to overview UCI dataset and run visualizations to find out the possible factors which could cause Heart Disease.

• Used Python, SAS Miner, and Orange to run different data models and compared the score of regression from each data model.

• Chose the best model to define the factors that are most likely to cause Heart Disease and composed a research report. ENROLLMENT & VOLUNTEER EXPERIENCE

IT Committee member Tempe, AZ

Department of Information Systems Club (DISC) Aug 2018 – Aug 2019

• Networked with the firm’s IT department.

• Visited firm’s IT department to learn more information about the company environment.

• Aided people with computer literacy by volunteering at Tempe public library.

• Volunteered with Feed My Starving Children and packaged more than 2,000 meals.

Contact this candidate