MyTurn LLCReal Estate Analyst Intern
Aug. 2023Washington DC-Baltimore AreaDeveloped Comprehensive Rental Portfolio Performance Dashboards: Utilized Power BI to craft dynamic dashboards that provide a unified view of portfolio performance, financial metrics, and occupancy trends across 30+ rental units, enhancing visibility and accountability while supporting strategic initiatives aimed at achieving a 10% occupancy increase over the fiscal year.
Created a scalable ETL pipeline: Designed and implemented an ETL pipeline using Power Query, SQL Server, and DAX, along with advanced SQL queries, to derive complex metrics such as NOI, ROI, and occupancy rates. Optimized data processing for over each property, enhancing data accuracy by 25% and reducing report generation time by 40%.
Enhanced Financial and Operational Reporting: Automated monthly and yearly financial reports to detail rental income, expenses, and net operating income, thereby enhancing financial visibility and accuracy. Developed interactive reports that track maintenance costs, work orders, and tenant demographics, significantly improving operational efficiency and resource allocation.