Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

With proven experience in SQL querying, VBA automation, and Tableau visualization, I have consistently turned large, complex datasets into clear, actionable insights across financial and technical projects. My analytical background from the University of Glasgow and hands-on experience at China Galaxy Securities and Aerospace Group enable me to bridge data analysis with strategic decision-making effectively.…With proven experience in SQL querying, VBA automation, and Tableau visualization, I have consistently turned large, complex datasets into clear, actionable insights across financial and technical projects. My analytical background from the University of Glasgow and hands-on experience at China Galaxy Securities and Aerospace Group enable me to bridge data analysis with strategic decision-making effectively.

Xiao Wang





With proven experience in SQL querying, VBA automation, and Tableau visualization, I have consistently turned large, complex datasets into clear, actionable insights across financial and technical projects. My analytical background from the University of Glasgow and hands-on experience at China Galaxy Securities and Aerospace Group enable me to bridge data analysis with strategic decision-making effectively.…With proven experience in SQL querying, VBA automation, and Tableau visualization, I have consistently turned large, complex datasets into clear, actionable insights across financial and technical projects. My analytical background from the University of Glasgow and hands-on experience at China Galaxy Securities and Aerospace Group enable me to bridge data analysis with strategic decision-making effectively.

Available to hire

With proven experience in SQL querying, VBA automation, and Tableau visualization, I have consistently turned large, complex datasets into clear, actionable insights across financial and technical projects. My analytical background from the University of Glasgow and hands-on experience at China Galaxy Securities and Aerospace Group enable me to bridge data analysis with strategic decision-making effectively.

Skills

Experience Level

Expert

Expert

Expert

Expert

Intermediate

Work Experience

Investment Research Intern at China Galaxy Securities Co. Beijing Office

November 1, 2024 - November 1, 2024

Portfolio Performance & Risk Analysis (Equity Focus): Analyzed the performance of selected equity assets within a sectoral portfolio using historical price trends, volatility metrics, and valuation ratios. Assessed risk exposure using beta, standard deviation, and sector correlation. Produced a 30+ page stock report featuring risk-adjusted return analysis and forward-looking performance projections. One recommendation (Ticker: 688017) realized a 133% return over five months, supporting strategic investment decisions.

Technical Project Analyst at China Aerospace Satellite Technology Group Co., Ltd.

July 1, 2024 - July 1, 2024

Cross-Departmental Reporting & Risk Coordination: Coordinated portfolio-level technical project reporting for satellite systems by coordinating data exchange and deliverables across engineering, data, and systems teams. Engaged with stakeholders to track progress and resolve interdependencies. Led documentation of project risks and mitigation strategies, enhancing traceability and audit-readiness for internal reviews. Team Coordination & Client Delivery: Supervised a small analyst team to manage institutional client communications and resolve performance-related issues. Assigned tasks, monitored progress, and ensured timely, high-quality responses to technical and reporting queries. Provided mentoring and feedback to junior analysts, enhancing team efficiency and client satisfaction through structured follow-ups and documentation. VBA Automation for Reporting Efficiency: Collaborated with the IT team to develop a VBA-based automation tool that streamlined satellite system data exchange

Sector Analytics Internship Project at Panasonic (China) Co., Ltd.

September 1, 2019 - September 1, 2019

Global Market Insights: Conducted market demand analysis for multi-region air conditioning product portfolios. Worked closely with cross-functional intern teams and coordinated with HQ and Japanese technical teams to align reporting standards and data expectations. Reporting Collaboration: Led the drafting and presentation of an 80+ page report, demonstrating strong analytical storytelling and cross-cultural communication skills. Presented key insights to executives, earning a recommendation letter (top 5% selection rate) and a 'Fast-Track Final Interview' invitation from the president of Panasonic (China).