myvisajobs.com
Browse Employers or  


Search Candidates
Skills:
Job Title:
Occupation:
Career Level:
Degree:
Residence
Work Authorization:




Browse Candidates by Occupation
Browse Candidates by Job Title
Browse Candidates by Country
Browse Candidates by Degree
Browse Candidates by Career Level
Browse Candidates by Gender

Xin Ni

Contact Xin Ni
Email: verified employer only
From: member or employer only
Languages Spoken: member or employer only

Career Profile

Degree: Master's Degree
Career Level: Experienced
Occupation: Business and Finance
Career Title: Market Research Analysts and Marketing Specialists, Management Analysts, Financial Analysts
Target Title: Data Analyst, Business Analyst
Skills: SQL;Tableau;Excel;Access;R;python;PowerPoint;
Xin Ni is Data Analyst, Business Analyst(Business and Finance) from Hartford,CT United States.

Experience


Lion ReSources a.k.a. Publicis Groupe Beijing, China
Industry: Advertising and Media
05/2016 - 08/2016
Data Analyst Intern
I managed four key clients simultaneously, built models and delivered KPIs report.
• Managed four key clients simultaneously, including Max factor (P&G Group), AB InBev, Coca-Cola Group, and China Communication Bank, updated Infosys, AQX database daily Enhanced communication within team and with data vendors to collect data • Interpreted 5 waves survey data in an intuitive KPI report which used funnel charts to describe the convert rate from Brand Awareness to Usage, from Usage to Consideration, and Purchase Intention and Brand Used Most Often (BUMO) • Extracted online survey data, transformed it to binary dataset (dummy variables) in R, built Logistic Regression models (glm package in R) to explain factors that influence Brand Images and then Purchase Intention in four key markets (Shanghai, Chongqing, Zhengzhou, Taiyuan), and delivered the findings using Tableau dashboard to senior manager • Designed, developed User Acceptance Testing (UAT), evaluated and applied questionnaires on Halloween’s impression in China as the supporting data for Preliminary Research for Promotion Campaign • Conducted Text Mining Analysis and word frequency analysis, and displayed results in a Wordcloud chart • Analyzed advertising investment effect based on Adstock theory, assisted clients to improve ROI and reduce churn rate • Wrote feasibility analysis reports periodically on various new technologies such as VR, AR and MR using Infosys and Nielsen database, and gave recommendations to better engage young customers
CJRoc.LLC Detroit, MI United States
Industry: E-commerce
05/2015 - 05/2016
Data Analyst (Remote)
I gathered data from online stores, analyzed data, and gave some practical recommendation.
• Gathered sales data from online stores using Python HTML Scripting (Scrapy and BeautifulSoup) and loaded to SQL database, analyzed it using multiple methodologies in R, such as A/B testing (pwr package), Hypothesis Testing(pwr package), Lift Analysis(rocr package), and Correlation Analysis(cor function) • Gave practical recommendations based on statistical analysis, such as putting links between certain pages, changing page layout, fonts, image selection, and delivered reports to senior leadership on the weekly basis • Conducted Search Engine Optimization(SEO) to make website search engine friendly, participated in keyword selection in department directory and item description, to increase accessibility • Optimized prompting strategies based on the fluctuation of UV and PV, resulting in an increase of 10% traffic Coordinated with Sales team, procurement team and IT department in both U.S. and China
Sealand Securities Company Beijing, China
Industry: Finance
05/2014 - 05/2015
Financial Analyst / Investment Banking Assistant
I gave data-based recommendations based on financial analysis to support decision-making.
• Collected supporting data for Due Diligence investigation using Pivot Table and VLOOKUP to aid decision-making • Extracted, transformed and loaded (ETL) data from clients’ financial reports, gathered first-hand sales data through on-site investigation, and provided in-depth research reports for a 350-page Initial Public Offering (IPO) report • Offered weekly Fundamental Analysis, Risk Analysis, and Technical Analysis report, based on Elliott Wave Theory, to forecast stock price in Telecommunication, Media, and Technology (TMT) industry • Corporated with colleagues, lawyers, and accountants, and assisted clients complete IPO, continuous supervision, and Non-public Offering successfully
People’s Insurance Company of China Beijing, China
Industry: Insurance
05/2013 - 07/2013
Business Intelligence Analyst Intern
I analyzed user profile data and feedback to give recommendations in the marketing process.
• Collected supporting data for Due Diligence investigation using Pivot Table and VLOOKUP to aid decision-making • Extracted, transformed and loaded (ETL) data from clients’ financial reports, gathered first-hand sales data through on-site investigation, and provided in-depth research reports for a 350-page Initial Public Offering (IPO) report • Offered weekly Fundamental Analysis, Risk Analysis, and Technical Analysis report, based on Elliott Wave Theory, to forecast stock price in Telecommunication, Media, and Technology (TMT) industry • Corporated with colleagues, lawyers, and accountants, and assisted clients complete IPO, continuous supervision, and Non-public Offering successfully

Education


University of International Business and Economics Beijing, , China
08/2010 - 06/2014
Degree: Bachelor's Degree
Major:Economics
Minor:Business English
I got double bachelor degree there and learned economics, finance and international trade theories at that time, which gave me a strong business sense.
University of Connecticut Hartford, CT, United States
08/2015 - 12/2016
Degree: Master's Degree
Major:Business Analytics and Project Management
In his program, I learned both data analysis skills and project management theories. I participated in projects in Data Modeling, Data Visualization, Statistical Analysis, and Business Process Management.

Resume(verified employer only)

Amy_ni_Resume

New Jobs | Green Card | H1B Visa | Student Visa | Work Visa | Immigration Attorney | About Us | Contact Us | FAQ | Visa Reports

Copyright © 2006 - 2017