KOUYU YANG
Richmond Central,BC
Summary
- Results-driven Revenue Reporting Analyst with five years of extensive experience in data analysis, revenue management, and project management.
- Proven expertise in developing and maintaining data capturing tools, driving data integrity, and delivering strategic reporting solutions.
- Adept at collaborating across departments to support portfolio decision-making and project prioritization.
- Possess strong technical proficiency in Microsoft Excel, project scheduling, and various reporting systems.
- Committed to contributing to the success of the Project Investments team by providing valuable data-driven insights and ensuring effective project delivery.
Overview
8
8
years of professional experience
Work History
Revenue Reporting Analyst
Tianbao Hotel
08.2018 - 08.2023
- Analyzed revenue-related data using Excel, SQL, and Python to identify trends and prepared reports and forecasts on key performance indicators (KPIs) to give data-driven insights
- Created visually appealing dashboards and data visualizations using tools Power BI to effective communication of financial insights.
- Automated report and dashboards generation, cutting manual effort by 30% and enhancing data delivery efficiency.
- Collaborated cross-functionally, translating project requirements into actionable insights for decision-making.
- Developed and maintained a robust project database that facilitated the seamless exchange of information between business cases, project status updates, and corporate financial systems.
- Ensured data accuracy and consistency by conducting rigorous data validation checks and reconciling any discrepancies within the project database.
- Worked closely with project managers to maintain timely and accurate project status updates, including financial performance metrics.
BUSINESS SYSTEM ANALYST
Caterpillar
05.2015 - 08.2016
- Reviewed proposals for APQP compliance, ensuring consistency and high standards.
- Developed and documented processes, policies, and reference materials, enhancing project services efficiency.
- Bridged communication between product owners, developers, and users, managing requirements and maintaining documents.
- Analyzed, prioritized, and prototyped requirements for better project understanding.
- Contributed to MGPP creation, performed gap analysis, and facilitated process flow assessments.
- Prepared for meetings, led JAD sessions, and engaged in daily stand-ups for effective teamwork.
- Regularly updated and maintained project documentation, ensuring accurate and up-to-date records of project progress, risks, and outcomes.
Education
MASTER OF SCIENCE - Management of Information System
The Harrisburg University OfScience And Technology
Harrisburg, PA02.2018
MASTER OF SCIENCE - Hospitality And Tourism Management
Purdue University
West Lafayette, IN05.2014
BACHELOR OF ARTS - Financial Management
Sichuan Univeristy
China05.2012
Skills
Revenue and Financial Analysis
- Financial Modeling
- Pricing Optimization
- Forecasting and Budgeting
- Data Analysis & Reporting
- Data Integrity & Controls
Project Management:
- Project Scheduling
- Project Management
Programming and Tools:
- Microsoft Excel (Advanced)
- SQL
- Python
- Oracle
- Power BI
- VBA
Languages
Chinese (Mandarin)
Native or Bilingual
English
Full Professional
Timeline
Revenue Reporting Analyst
Tianbao Hotel
08.2018 - 08.2023
BUSINESS SYSTEM ANALYST
Caterpillar
05.2015 - 08.2016
MASTER OF SCIENCE - Management of Information System
The Harrisburg University OfScience And Technology
MASTER OF SCIENCE - Hospitality And Tourism Management
Purdue University
BACHELOR OF ARTS - Financial Management
Sichuan Univeristy
Similar Profiles
Naiqian WangNaiqian Wang
Marketing Assistant at Tianbao TravelMarketing Assistant at Tianbao Travel
MURTAJA ALTAMEEMIMURTAJA ALTAMEEMI
Front office ( Receptionist ) & supervisor at OZO Hotel / Cordial hotel / Joy hotel / Diamond capsule hotel / The muse hotel / House 377 hotel / NL hotel / Max hotel / Downtown hotelFront office ( Receptionist ) & supervisor at OZO Hotel / Cordial hotel / Joy hotel / Diamond capsule hotel / The muse hotel / House 377 hotel / NL hotel / Max hotel / Downtown hotel
JUAN SAMAYOAJUAN SAMAYOA
Housekeeper / Receptionist / Construction at Hotel Appelviken, Hotel Rival, Clarion, Grand Hotel, SkanskaHousekeeper / Receptionist / Construction at Hotel Appelviken, Hotel Rival, Clarion, Grand Hotel, Skanska
Tyler PaquetteTyler Paquette
Delivery Expert at Domino's PizzaDelivery Expert at Domino's Pizza
Abhishek BhardwajAbhishek Bhardwaj
Mobile Sales Specialist at Osl RetailMobile Sales Specialist at Osl Retail