Redesigned team reporting workflows by developing Excel VBA and Python-based automation solutions, implementing automated reporting pipelines, and enhancing executive dashboards.
Due diligence on 20+ potential acquisition targets, performing financial statement reviews, market research, benchmarking, Analyzed client financial performance through cash flow modeling, scenario analysis. and risk assessments to support M&A decision-making.
Supported 10+ client (pharmaceutical and biotechnology sectors) engagements with financial data analytics.
Strategy Consultant
Deloitte
Beijing
08.2020 - 04.2021
Developed management dashboards and data visualizations in Tableau and Power BI.
Supported digitial transformation projects for Mercedes and 3+ German Tier-2 automotive suppliers, conducting market and competitive analyses across 30+ automotive and mobility companies into digitalization track.
Built and maintained financial models, including 12-month cash flow forecasts, profitability analyses, and upporting client planning and decision-making processes.
Processed and analyzed 300+ survey responses and operational data records using Python, SQL, and Excel, improving the efficiency and accuracy of consulting analyses.