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 pricing strategies.• 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 week to minutes, freeing up 300+ hours per year for other responsibilities.• 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.• Clustering transactional lease data (+500k sample) to identify trends that were previously not available to the company.

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 • Serves as point of contact for Great Wolf with partnering BI vendor to align current data models to improve data quality and address company data needs • Key member in the capex budgeting process and responsible for restructuring the reporting package on capex, including the fixed asset roll forward • Consolidated requirements from treasury and built a financial reporting schedule for external lenders • Aggregates and summarizes general liability/worker's compensation data for legal team to highlight areas of risk around the organization • Provide ad-hoc support to executive management to identify key drivers of the business

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• Utilize MicroStrategy, Access, Excel, SQL, and other systems applications for report development, creation, and distribution• Analyze client web service log-in source, providers selected, and plans joined for fraudulent patterns to be reported to Health and Family Services of Illinois

Bachelor'S Degree, Economics

Bachelor’S Degree, Psychology