- Conducted 3 benchmark analyses to compare KPIs of client's financial statements with competitors, presented to client with data visualization using Power BI and Python, improving client's strategies on asset quality management
- Coordinated with 20 subsidiaries of client to acquire audit requests using monetary unit sampling method, analyzed and merged data using SQL, compiling a statistically valid assessment of client's financial data accuracy
- Communicated with various client's departments to collect 30+ PBC (Provided by Clients) documents, discerned
T
The Hershey Company
Business Analyst Intern
Hershey, PA, US
May 2021 - August 2021
B
Bank of China
Financial Analyst Intern
May 2020 - December 2020
P
Penn State Investment
September 2019 - March 2020
Skills
Languages
ChineseEnglish
Skills
A/B TestingAccountingAccounts PayableAccounts ReceivableAlgorithmsAuditing SkillsBusiness AnalysisCoordination SkillsCorporate FinanceCultural ActivitiesCustomer Relationship ManagementData QualityData VisualizationDecision Making SkillsDerivatives MarketsDiscounted Cash FlowFinancial Data AnalysisForecasting SkillsIncome StatementsInterpersonal CommunicationsIntranetInvestment DecisionsKnowledge of FinanceKnowledge of StatisticsLeadershipMachine LearningManufacturingMarketingMATLABMicrosoft ExcelMoney InvestmentsPortfolio ManagementPower BIPredictive Data AnalysisPredictive ModellingPresentationsProbability TheoriesProfitability AnalysisPython (Programming Language)Quality ManagementQuantitative InvestingRetail DistributionRisk AnalysisR (Programming Language)SalesSales ReportsSAS (Software)SnowboardSQL DatabasesStrategic ThinkingStrategies of PricingStreamlineSupply Chain ManagementTableau (Software)Testing SkillsText AnalysisTime SeriesValuation Using MultiplesVisualization