M.S in Applied Analytics student at Columbia University|Curiosity-driven |Self-motivated |Team Player| 2+ years' project experience in Data Analytics and Business Intelligence(Python, R, SQL, Tableau)
Firephoenox Strings
-
Marketing AnalystFirephoenox Strings Feb 2020 - PresentHuntington Beach, California, United States
-
Capstone Student AnalystS&P Global Sep 2019 - Dec 2019Greater New York City Area -
Analytical ProjectColumbia University In The City Of New York Jan 2019 - May 2019Greater New York City AreaMachine Learning Project on Diabetes Readmission• Selected GBM, Logistic, K-Nearest Neighbors, Lasso Regression, and Random Forest to calculate accuracy rates of variable, readmitted to help hospital predict readmission of diabetes patients• Separated data set into 5 subgroups according to the age variable and use many-model method to calculate their accuracy rates• Compared and analyze accuracy rates of one model and many-model methods R Project on Airbnb Rental Price… Show more Machine Learning Project on Diabetes Readmission• Selected GBM, Logistic, K-Nearest Neighbors, Lasso Regression, and Random Forest to calculate accuracy rates of variable, readmitted to help hospital predict readmission of diabetes patients• Separated data set into 5 subgroups according to the age variable and use many-model method to calculate their accuracy rates• Compared and analyze accuracy rates of one model and many-model methods R Project on Airbnb Rental Price • Developed models in R to analyze prices over 25,000 Airbnb’s rentals in New York City• Developed random forest and linear models to select the best predictors for the pricing model Python Project on Titanic Survival Statistics • Imported Pandas and NumPy to understand the demographics of Titanic survivors• Created visualizations to understand relationships of passenger class vs fare, and age vs fare SQL Project on Food Delivery Business for ToGoBox• Designed ER diagram, create normalizations and 15 tables under SQL environment, and prepare 10 critical business questions• Created visualizations with Metabase and Tableau to provide insights about critical business questions Show less -
Business Analyst InternYiyuankang Science & Technology Trade Co., Ltd Jul 2018 - Sep 2018Qingdao, Shandong, China• Analyzed data from local hospitals, helped to achieve $1,000,000+ sales of Boston Scientific and Pfizer medical equipment.• Analyzed information and resources from commercial banks to support a loan application of $2,000,000.• Conducted business researches to support executives decide whether to go public or merge with another medical group.
-
Business Analyst InternZhongyijinhong Trade Co., Ltd Apr 2018 - Jun 2018Beijing City, China• Conducted business analysis to write a report about heart stents and other cardiac products in the Chinese market.• Analyzed competitors’ business strategies and researches on potential expansions to new private hospitals in Tibet, and Jiangxi.• Predicted trends in Chinese medical equipment market and governmental policies, created three market analysis reports for the executive team.
-
Risk Management InternBank Of Communications Co.,Ltd. Aug 2017 - Sep 2017Greater New York City Area• Researched the trend of New York City apartments by analyzing housing prices, vacancy rate, and inventory data• Analyzed three models of mezzanine financing, investment patterns and real estate regulations to develop real estate investment trusts for Chinese investors. -
Risk Management InternChina Construction Bank New York Branch Jul 2016 - Aug 2016Greater New York City Area• Analyzed a New York-based mortgage company, dug into its real estate valuation models, discussed variables of each model with group members.• Conducted due diligence for credit checks of companies in construction and finance industries.• Participated in writing research reports on recent business performances of our business partners.
Bingjun(David) Xin Skills
Bingjun(David) Xin Education Details
-
Economics(Major) Accounting(Minor)
Frequently Asked Questions about Bingjun(David) Xin
What company does Bingjun(David) Xin work for?
Bingjun(David) Xin works for Firephoenox Strings
What is Bingjun(David) Xin's role at the current company?
Bingjun(David) Xin's current role is Marketing Analyst at FirePhoenox Strings.
What schools did Bingjun(David) Xin attend?
Bingjun(David) Xin attended Columbia University In The City Of New York, University Of California San Diego.
What skills is Bingjun(David) Xin known for?
Bingjun(David) Xin has skills like Management, Business Planning, History, Chinese Culture, Accounting, Marketing, Off Road, Strategy, Jeep, Microsoft Excel, Critical Thinking, Stata.
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial