نبذة عني
Xiqian Wang has experience in investment research, data analysis, venture capital analysis, and business analytics. He has worked with Python, SQL, Excel, and PowerPoint across roles involving market mapping, data cleani…
Xiqian Wang has experience in investment research, data analysis, venture capital analysis, and business analytics. He has worked with Python, SQL, Excel, and PowerPoint across roles involving market mapping, data cleaning and visualization, predictive modeling, and investment due diligence support.
الخبرة
Investment Researcher & Data Analyst
Constructed a market map of the aesthetic industry and profiled potential investment targets
Developed SQL scripts to retrieve company data and utilized Excel formulas to evaluate key company metrics
Prepared a PowerPoint deck and applied data visualization techniques in Excel to present research summary
Investment Adviser
Performed marketing analysis near the University of California campuses for small business opportunities
Screened data and produced reports for further discussion with the entrepreneurship team
Made a budget for the $600,000 investment fund covering initial outlay, property rental, inventory management and recruitment expenses
Investment Researcher & Data Analyst
Constructed a market map of the aesthetic industry and profiled potential investment targets
Developed SQL scripts to retrieve company data and utilized Excel formulas to evaluate key company metrics
Prepared a PowerPoint deck and applied data visualization techniques in Excel to present research summary
Venture Capital Analyst
Screened a list of startups and identified their product differentiations, core competencies and strategies
Collected, cleaned, and visualized each individual startup’s data in Python in preparation for further investigation
Drafted a recommendation summary to propose investment due diligence on promising startups
Data Analyst
Accessed Alipay historical data through SQL and analyzed data in Python to explore ways of risk aversion
Honed Python skills in data analysis and wrangling, predictive modeling and packages utilization
Assisted in the planning and design of a multi-dimensional data mart for the decision-making purpose