Xiaoyu Wang Email & Phone Number

美国 马里兰州 巴尔的摩

• Analyzed healthcare cost structure of Maryland State in 2019 and 2020 with SQL and Tableau based on the diagnosis-related group, integrating healthcare resources distribution and improving Medicaid efficiency• Applied statistical analysis to the distribution of patients demand in Maryland State over the past three years and initiated mobile clinic service, optimizing healthcare provider network

Baltimore, Maryland, United States

• Assessed the business market overview in Baltimore under COVID-19, engaged with entrepreneurs to identify urgent needs, composed analytical report, and provided effective solution to help business owners navigating the pandemic• Evaluated key initiatives and introduced data visualization to strategize Johns Hopkins University and Health System response to COVID-19 preparedness and interventions

Lima, Peru

• Assisted non-profit educational institution to achieve sustainable growth by reforming the operational workflow and improving resources efficiency• Extracted cost and revenue drivers for typical curriculum programs, built KPI framework, adopted activity-based cost analysis to evaluate financial performance, and raised constructive proposal• Collaborated with program managers to propose financial improvement solution and to expedite landing practice through multiple strategies

中国 北京市

• Rotated around multiple positions in finance department, including financial analysis, tax management, budget management and statement preparation• Analyzed flow of funds, performed monthly cost-benefit evaluations and annual budgeting, and optimized accounting process by removing overlapping functions• Led a cross-functional 10-member team to conduct demand analysis, modular testing, operational monitoring and to implement a system for aircraft materials management in Oracle, integrating business and financial affairs to optimize internal supply chain• Spearheaded aircraft materials-sharing cooperative model based on historical data analysis and calculations, reducing annual aircraft materials maintenance cost and training cost by 15%• Assessed risk points of current operation process; optimized aviation training purchasing system and competitive negotiation mechanism, saving 10% in annual purchasing cost• Coached financial staff in 8 nationwide company branches to clarify new policies and financial process, steadily promoting tax reformation transit

Global Master Of Business Administration

Bachelor Of Administration, Accounting