Wayne Wang
Los Angeles,CA
Summary
Dynamic Performance Reporting Manager at Mozaic LLC with expertise in Python and SQL, driving efficiency through innovative reporting solutions. Proven track record in financial modeling and analytical reporting, enhancing executive decision-making. Strong communicator adept at cross-department collaboration, achieving significant budget reductions and optimizing asset performance.
Overview
13
13
years of professional experience
2
2
Certifications
Work History
Performance Reporting Manager
Mozaic llc
Los Angeles, California
04.2024 - Current
- Created new reports as needed to meet business requirements.
- Supported executive decision-making by preparing detailed analytical reports and presentations.
- Streamlined reporting procedures to enhance efficiency and reduce turnaround time.
Asset Management Senior Associate
CORE (USA) Investment
Los Angeles, USA
10.2023 - 01.2024
- Built from scratch financial models for IRRs calculation, historical and forecasting data analysis, loan financing, budgeting, and investor waterfall returns for a mixed-use property (total investment ~ $1.1 billion in DTLA) with components of luxury hotel, high-end apartments and retail
- Led fund due diligence (cash position, financial statements & operation) and negotiation preparations for new capital contribution, resulting in a final ~ $15 million budget reduction for investor members (LPs)
Asset Management Analyst
H5 Data Centers, Capodagali Property Company
Beverly Hills, USA
07.2021 - 10.2023
- Built and maintained visualization charts and financial models of budgeting, cash flow, and investor return analysis for properties up to ~ $2 billion market value (including data centers, office, and retail buildings)
- Managed +2,000 units of multi-family apartments and provided near real-time asset performance reports by managing financial and operational data, building a market insight system with Python Django framework, and creating Tableau dashboards
- Managed full spectrum of operations to facilitate cross-department business processes and complex data flows, including lease/agreement term interpretation, system configuration and management, revenue and cost drivers analysis, reimbursement revenue calculation, and lease negotiations and underwriting supports
- Conducted investment due diligence to close a 225,000 SF data center acquisition by researching capital market and historical transactions, and abstracting purchase agreement, property condition, and valuation reports; prepared refinancing underwriting documents and regularly monitored portfolio's compliance to lender agreements
IT Consultant
PriceWaterhouseCoopers (PwC), Takeda Pharmaceuticals
Shanghai, China
12.2015 - 05.2019
- Conducted due diligence on accounting and operational data to validate and analyze target companies' financial earning quality and business risks
- Utilized Python and Power BI to develop a financial data analysis system prototype and supervised tech team to implement functional requirements of ~ ¥1.5 million RMB project to reduce resource by more than 30% per advisory project
- Led efforts to bring online a sales incentive calculation system for a multinational pharmaceutical company, including business requirements gathering, business process analysis, functionality documentation and IT implementation
System and Data Engineer
Bridge Corporation
Fort Lee, USA
04.2013 - 09.2015
- Designed and implemented a real-time digital ads bidding system, which supports big data processing and campaign performance reporting and analysis
Education
Master of Business Administration - Finance & General Management
Georgetown University - McDonough School of Business
Washington, DC05.2021
Master of Engineering - Electrical and Computer Engineering
Syracuse University
Syracuse, NY03.2013
Bachelor of Engineering - Electrical Engineering
YanShan University
Hebei, China06.2011
Skills
- Python and C
- SQL and NoSql
- Bloomerberg
Summary
Leveraging technology and data, I provided data-driven analysis and improved operation efficiency, CFA Level 3 Candidate, Yardi/AppFolio, MRI, Tableau, Power BI, Argus, Python, Java, SQL, NoSql, Restful APIs, Salesforce CRM
Certification
CFA level 3 candidate
Timeline
Performance Reporting Manager
Mozaic llc
04.2024 - Current
Asset Management Senior Associate
CORE (USA) Investment
10.2023 - 01.2024
Asset Management Analyst
H5 Data Centers, Capodagali Property Company
07.2021 - 10.2023
IT Consultant
PriceWaterhouseCoopers (PwC), Takeda Pharmaceuticals
12.2015 - 05.2019
System and Data Engineer
Bridge Corporation
04.2013 - 09.2015
Master of Business Administration - Finance & General Management
Georgetown University - McDonough School of Business
Master of Engineering - Electrical and Computer Engineering
Syracuse University
Bachelor of Engineering - Electrical Engineering
YanShan University