Power Bi Business Intelligence

DG

DANIELE GUO

***********@*****.*** (***) -***- 4692 WWW: linkedin.com/in/daniguo2/ WWW: Bold Profile Results-driven IT management professional with strong productivity, efficiency, and great communication skills. Expertise in strategic planning, risk management, and stakeholder collaboration. Skilled in leadership, problem-solving, and adaptability, delivering successful project outcomes in dynamic environments. Indiana University, Kelley School of Business Bloomington, IN Bachelor of Science in Finance, Data Analytics

05/2024

Microsoft Excel (Advanced)

Financial Modeling & Forecasting

Python & SQL Programming

Business intelligence (Tableau, Power BI)

Comparative Analysis

Statistical Analysis (R)

Strategic Communication

Problem-Solving

Airbnb Sevierville, TN

Property Manager

01/2024 - Current

Managed rental property finances, including pricing, budgeting, and expense tracking, using financial modeling and forecasting to drive profitability Evaluated marketing KPIs alongside market trends using tools like Excel and Tableau for strategic decision optimization

Streamlined operations by prioritizing tasks, ensuring timely financial reporting, and maintaining accurate records using Quicklook

Utilize Microsoft Excel, SQL, and data visualization tools to analyze financial data, build predictive models, and create interactive dashboards that drive strategic decision-making and optimize business performance No. 1 Chinese Restaurant Sevierville, TN

Store Manager

01/2014 - 01/2024

Deployed 10+ advanced financial models in Excel to optimize inventory management, workforce scheduling, and cost-benefit analysis, reducing OPEX by 15% and enhancing resource efficiency

Leveraged multilingual communication to strengthen stakeholder engagement and client relations, directly contributing to a 9% revenue growth over a four-year period

Orchestrated the integration of third-party delivery platforms (e.g., GrubHub, DoorDash), enhancing digital order fulfillment processes and driving a 13% increase in gross merchandise value through improved sales channel efficiency Pro-Forma Financial Analysis and Firm Valuation Target Corporation Conducted financial forecasting and built pro-forma statements using Python (Pandas, NumPy), Excel, and DCF modeling, calculating WACC and terminal value to estimate firm valuation Performed sensitivity analysis in Excel and R, and visualized insights using Tableau/Power BI, leveraging SQL for data extraction and cleaning to support strategic decision-making Case Study: Financial and Marketing Analysis JJ's Food Executed Beta Estimation, Cost of Capital (WACC) calculation, and Cash Flow Analysis using statistical tools in Python and Excel to assess project feasibility and financial performance Analyzed market trends, consumer behavior, and competitive landscape, integrating findings with financial metrics through SQL and Power BI to develop data-driven marketing strategies aligned with profitability goals Chinese Students and Scholars Association (CSSA)

Summary

Education

Skills

Experience

Projects

Activities

Women in Accounting (WIA)

Asian American Association (AAA)

English:

Native/ Bilingual

Chinese (Mandarin):

Native/ Bilingual

Japanese:

Professional

Languages

Contact this candidate