Nicholas Marcus Email & Phone Number

Mountain View, CA, US

Mountain View, CA, US

Chicago, IL, US

• Head of analytics that oversees $75-100m of annual investment across a 90,000-unit multifamily real estate portfolio.
• Development of new metrics and tools in PowerBI to present findings to the senior leadership team across various departments (Pricing, Acquisitions, and Redevelopment) to assist in underwriting deals and ongoing.
• Responsible for projecting volume of projects, the related cash flows, and accretive rent roll growth for 150+ communities in a budgeting and reforecasting process.
• Leveraging automation techniques to scale internal and external reporting requirements that resulted in 0% department head count growth despite unit count growth being 50% during my tenure.
• Stepped in as a volunteer for other groups (External Reporting, FP&A, and Pricing) to assist in data modeling and automating to ease the burden of timely reporting requirements. Weekly labor burden reduced from hours a.
• Financial modeling of real estate profitability concepts related to interior unit upgrade programs and back testing with actual portfolio statistics to make better decisions moving forward.

Chicago, Illinois, US

• Manages the internal financial reporting package used by Great Wolf corporate and sixteen lodges that provides insight on performance
• Managed project focusing on the connectivity between data sources and BI vendor
• Subject matter expert for a data lake project to migrate all current data to AWS cloud environment by delivering financial data structure knowledge to IT and creating KPI metric calculations in Tableau
• Writes SQL and MDX queries for Great Wolf’s data architect to assist in the data migration process
• Writes VBA code to automate journal entry processes for accounting, the reduction in labor hours is projected at 20 hours a month
• Developed a more efficient and accurate budgeting and forecasting process by applying historical seasonal trends to current projections

Mclean, Virginia, US

• Update project databases for accuracy in order to prevent issues during enrollment transaction processing
• Research and resolve healthcare enrollment discrepancies between the federal and state level
• Identify origin of specific systematic errors among health care enrollment discrepancies to develop and implement ongoing prevention procedures
• Produce detail oriented deliverables on discrepancy procedures to provide to executive management
• Evaluate impact of system updates concerning enrollment workflow operations and communicate potential issues with system department management
• Monitor and perform quality control audits on all electronic file transfers between project and clients

Bachelor'S Degree, Economics

Bachelor’S Degree, Psychology