-Prepare and analyze complex financial and operational information to management to provide deeper insights.-Lead annual budget process, including reforecast and proforma budgets.-Perform new acquisition analysis - looking at ways to maximize income, and reduce expenses in a realistic approach.-Conduct ad hoc analysis using advance MS Excel skills and Power BI to present data in a meaningful dashboard.

• Develop integrated operational and financial reporting tools by consolidating data from multiple databases.• Create and manage internal company dashboard to report key performance indicators and compare across portfolio using advance excel skills. • Develop a portfolio underwriting model to calculate portfolio returns for a recapitalization.• Underwrite new acquisition deals and assist in rent roll analysis and historical financial analysis. • Revise current portfolio valuation schedule to provide standardized reporting.• Create various ad hoc analysis to support smart decision making.• Create and edit custom MRI Report using SQL.