Yuyao Wang

Experience

• 

  Environmental Resources Management

  May 2022 - Sept 2022

  Strategic Analyst

  • SQL Programming: Constructed SQL databases from 20k+ carbon emission data points, and designed an evaluation matrix with 10 ESG indicators in order to uncover carbon intensity, renewable energy adoption, and environmental compliance in the Chinese power industry.• Report Compilation: Supported 5 business partners to develop a 5-year green development roadmap by conducting in-depth research and data mining on policy directions and industry dynamics.• Problem Solving: Applied Life Cycle Assessment tools to quantify waste, carbon emissions, and energy consumption for comprehensive reporting; conducted a case study of Midea on resource consumption and environmental impact to inform sustainable development decisions.• Strategy Development: Proposed tailored strategies to business partners for mitigating ESG risks, including optimizing production processes and adopting clean energy solutions, with the potential to increase operational efficiency by 15% and reduce carbon emissions by 20%, enhancing environmental performance and corporate sustainability. Show less

• 

  Surge Energy America

  May 2023 - Sept 2024

  • Communication Skills: Facilitated 10 training sessions, upskilling 30+ team members in data visualization using advanced Excel formulas (e.g., pivot tables, VLOOKUP); delivered data analysis insights and presented 5 recommendations to stakeholders across diverse teams on improving financial forecasting accuracy, resulting in a 10% increase in forecast reliability.• Collaborative Teamwork: Excel and SharePoint dashboards integrating real-time data and weekly updates, increasing team efficiency by 25%, and providing actionable insights into market trends and regulatory shifts, enabling informed decision-making by senior leadership and C-level executives.• Loss Prevention: Used RiskPoynt, Power BI, and Bloomberg Terminal to analyze 500,000+ data rows, reducing penalty fees by 18% and stabilizing revenue fluctuations from a ±10% to ±5% range, safeguarding corporate financial interests.• Risk Analytics: Performed 50+ risk evaluations of property assets with SQL and RiskPoynt based on 500,000+ data rows related to lease breaches, mineral rights, and market trends, and communicated critical operational risks (e.g., delayed production timelines, non-compliance with regulatory standards) to the leadership team, enabling proactive decision-making. Show less • Cross-functional Alignment: Integrated geographic information with financial risk assessment findings to align interdepartmental understanding regarding the operational and financial challenges of optimizing investment portfolios for institutional clients.Empowered staff at all levels to make informed decisions based on comprehensive analysis of market trends and financial risks, improving risk prevention strategies and enhancing operational efficiency across departments.• Process Optimization: Process Optimization: Streamlined land record management by implementing advanced verification and error-checking mechanisms, reducing record processing time by 30% and decreasing errors by 25%. This led to more stable data quality, reduced delays by 20%, and minimized operational inefficiencies, enhancing overall system efficiency.• Risk Management: Conducted comprehensive evaluations using RiskPoynt, proactively monitored exposures, and recommended actions to reduce the likelihood of significant financial losses by 12%.• Precision Data Management: Maintained and updated 1,000+ land records in LMS and Quorum, achieving 98% accuracy in property data, lease agreements, and contractual obligations.• Internal Controls: Utilized ArcGIS to develop and maintain detailed maps covering 500+ lease rights, 300+ mineral rights, and 15+ well locations, enhancing resource management and spatial decision-making through geospatial analysis, leading to more efficient planning and resource allocation. Show less

  • Risk Control Analyst

    Oct 2023 - Sept 2024

  • Risk Advisory Intern

    May 2023 - Sept 2023