Luna Wang
Digital Marketing/Strategic Analyst/ Business Analyst/ Product Manager/
Talent Acquisition Analyst
RESUME
Proven ability to drive data accuracy and integrity to communicate with both technical professionals and users in a Fortune 500 company. Lead teams of talented professionals to develop solutions to meet business objectives.
Professional
Experiences
Skills
Work
experience
General Motors
Software Verification Engineer
· Design and execute verification projects. Extract data within test scenarios, clean and transform into desired schema. Then validate the results with test script and find out the anomaly data for analysis
· Communicate with stakeholders and multiple departments according to business requirements, resolve tickets and coordinate with team members to actively tracking current issues
· Program testing pipeline with python scripts. Automated executive scripts to verify necessary components across multiple platforms
· Constantly monitoring critical logs, design and visualize core metrics in the dashboard with Excel and report daily within the team. Deliver progress report and meet with engineering team to ensure the project timeline
Photoshop
Final Cut Pro
SPSS
Hootusuite
Sun Chlorella USA
Sales and Marketing Campaign Representative
Torrance, CA
· Analyzed campaign performance and optimized ROI via Google Analytics
· Developed marketing campaigns from initiation to execution which included promotion copy, price lock, promo code creation, designed concept, and coordinated marketing activities for both online and offline channels
· Managed seasonal promotional calendar, and effectively communicated with different teams to ensure successful campaign execution
· Used strong selling and influencing skills to source new sales opportunities with specified natural, specialty, and grocery retail accounts through inbound lead follow-up and outbound cold calls and emails
· Conducted 60 calls each day to solicit new business, provided customer satisfaction and promoted the Auto-ship Program
· Participated the Natural Product EXPO West and promoted new launch products as well as compared the competitor’s price with us
GEC Academy
Supervisor of Foreign Market and User Growth
Beijing, CHN
· Analyzed the data for a business competition, used Vlookup to clean data and made pivot tables to visualize
· Solved parents’ questions about studying in the U.S. in 3 Wechat groups and observed potential parents to transfer to sales department.
· Connected with 4 former Ivy League admission officers through the U.S. education website and invited them to China to participate in the education fair and connected with international schools’ students.
Programming Languages
Python, R, SQL, Hive, NoSQL
Education
Columbia University, MS in Applied Analytics;
New York, NY
Relevant Coursework: Machine Learning, Data Visualization & Design, Solving Real World Problem, Python for Data Analysis, Modern Database architecture, Strategic Leadership, Storytelling with Data, Introduction to Finance, Applied Analytics Frameworks and Methods, Research Design, Analytics and Leading change, Applied Analytics in Organizational Context
University of California, Irvine
BA in Psychology and Social Behavior, Minor in Public Health,
Irvine, CA
Relevant Coursework: Life Span Development Psychology, Abnormal Psychology, Health Psychology, Social Psychology, Human Stress, Industrial-Organizational Psychology, Environmental Psychology, Principles of Public Health, Cases Studies in Public Health Practice, Public Health Administration, Public Health Communication, Social Epidemiology