Yan Hao Email & Phone Number

Munich, By, De

Munich, Bavaria, Germany

- Designed and managed an interactive workforce and budget planning Excel tool for 34 locations across 18 countries. Provided training and collaborated with HRs and leaders on position planning, consolidating results and delivering important budget planning figures to the Finance department.- Implemented Power BI for reporting, significantly enhancing automation and visualization. These reports are utilized by higher-level decision-makers.- Conducted data auditing and position cleansing within the SAP SuccessFactors system, ensuring a clean and reliable workforce dataset.- Collaborated with various departments, including collecting monthly absence data for the Quality department, assisting the Legal department with GDPR surveys and analysis, supporting the Finance department with monthly holiday accruals using a custom Excel tool, and providing on-demand statistics to the Communication department for annual company reports and community calls.- Participated in the SAP SAC system implementation for workforce and budget planning. This involved providing requirements to consultants, testing the designed tool, proposing improvements, and contributing to the implementation and rollout to stakeholders, along with providing training.- Delivered monthly employee statistics, HR dashboards, and turnover reports with in-depth analysis using Power BI and Excel.- Created customized ad hoc reports using SAP SuccessFactors, assisting various stakeholders in making informed business decisions.

Munich, Bavaria, Germany

Hallbergmoos, Bavaria, Germany

- Design user-friendly guidelines and documentation, including HR user guides, SAP SuccessFactors reporting guides, and HR Glossary.- Support and maintenance of SAP SuccessFactors, processing employee data, generating HR-related reports, and maintaining data integrity.- Support on rolling out the SAP SuccessFactors story dashboard to the global HR community.

Berlin, Germany

• Data Collection:Collected data (more than 2,000 entries) from Chinese official websites, organized and coded data accordingly using Microsoft Excel.• Data Checking:Checked the correctness of primary dataset with around 60,000 entries, coordinated with a 5-person team. Coded data to different genres.

Nottingham, England, United Kingdom

• Research & Analysis:Researched and analyzed the market for the SWOT analysis, devised SEO and future marketing plan.• Communication:Liaised with the client via email to better understand the demand and updated weekly the working progress of my team.• Presentation & Team Working: Discussed and designed the marketing reports and presentation by Microsoft Word and PowerPoint with a team of 5.

Master'S Degree, Economics

Master Of Science - Ms, Economics

Bachelor'S Degree, Economics, Final Average Mark: 87.65%

Activities and Societies: Student Union- Graduated as an outstanding student in Economics - Received the first scholarship for three.