Dylan Huang
Location
New York City, NY
San Jose, CA
Education
C
Columbia University in the City of New York
August 2024 - January 2025
degree
Master's
major
Risk Management
U
University College London UCL
Work Experience
E
Ernst AND Young
Restructuring Strategy Intern
Hong Kong, HK
July 2024 - August 2024
company
Ernst AND Young
title
Restructuring Strategy Intern
overview
- China
- Collected, organized, and analyzed financial data (income statements, balance sheets, cash flow statements, debt obligations
- Developed detailed cash flow forecasting models for the next five years in Excel, utilizing functions and formulas to project
- Calculated key financial metrics, including net cash flow, current ratio, quick ratio, and debt coverage ratio, using Excel-based
- Supported scenario analysis by analyzing cash flow scenarios to assist management in choosing optimal strategies, further
B
Bank of Communications
Investment Associate Intern
Hong Kong, HK
August 2023 - September 2023
Skills
Languages
ChineseEnglish
Skills
AccountingAccounts PayableArtificial IntelligenceAsset AllocationAsset ManagementBalance SheetsBenchmarking SkillsBusiness EconomicsCash Flow StatementsCash ManagementCommunication SkillsConsultingCoordination SkillsCustomer Relationship ManagementData AnalysisData MiningDecision Making SkillsDecision TheoriesEconomyElectronicsESG CriteriaFinancial AnalysisFinancial Data AnalysisFinancial DerivativesFinancial ModelingForecasting SkillsIMovieIncome StatementsInvestment DecisionsInvestment StrategiesKnowledge of FinanceKnowledge of StatisticsMacroeconomicsManagement TrainingMarket DataMarketingMarket LiquidityMarket ResearchMarket TrendsMathematicaMicrosoft ExcelMicrosoft OfficeMicrosoft OutlookMoney InvestmentsOperations ResearchPortfolio ManagementPower BIProbability TheoriesPython (Programming Language)Qualitative AnalysisRestructuringRisk AnalysisRisk ManagementR (Programming Language)Scenario AnalysisSPSS (Software)Strategic ManagementStrategic ThinkingTrend Analysis