About Me
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.
Experience
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
<p>Performed marketing analysis near the University of California campuses for small business opportunities<br>
Screened data and produced reports for further discussion with the entrepreneurship team<br>
Made a budget for the $600,000 investment fund covering initial outlay, property rental, inventory management and recruitment expenses</p>
Investment Researcher & Data Analyst
<p>Constructed a market map of the aesthetic industry and profiled potential investment targets<br>
Developed SQL scripts to retrieve company data and utilized Excel formulas to evaluate key company metrics<br>
Prepared a PowerPoint deck and applied data visualization techniques in Excel to present research summary</p>
Venture Capital Analyst
<p>Screened a list of startups and identified their product differentiations, core competencies and strategies<br>
Collected, cleaned, and visualized each individual startup’s data in Python in preparation for further investigation<br>
Drafted a recommendation summary to propose investment due diligence on promising startups</p>
Data Analyst
<p>Accessed Alipay historical data through SQL and analyzed data in Python to explore ways of risk aversion<br>
Honed Python skills in data analysis and wrangling, predictive modeling and packages utilization<br>
Assisted in the planning and design of a multi-dimensional data mart for the decision-making purpose</p>