Zbigniew Szczerba
Warsaw,Poland
Summary
Real estate professional with 4+ years of industry experience, offering advanced analytical skills and Excel proficiency. Recently completed a Master of Science in Real Estate and eager to apply expertise in a real estate analyst role in Warsaw.
Overview
5
5
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Acquisitions Analyst Intern
Camber Property Group
New York, NY, United States of America
05.2024 - 12.2024
- Underwrote 40 prospective affordable housing and mixed-use deals across the Eastern United States, with 8 advancing to submitted Letters of Intent (LOIs) totalling nearly $500 million in total capitalization
- Played a key role in securing 2 awarded opportunities (Dobbs Crossing and Bethune Tower) valued at $50 million in total project costs
- Prepared investment memos, internal summaries, and teaser presentations for equity partners, effectively communicating key metrics and opportunities across multiple projects
- Contributed to the successful $25 million refinance of South Heights by preparing key documentation for the senior lender and preferred equity provider
- Supported the $190 million Triboro Portfolio refinance by conducting arrears analysis, showcasing declining trends
- Executed due diligence on 5 active acquisitions, including abstracting purchase agreements, master leases, and long-term city contracts, ensuring comprehensive transaction support
Asset Management Analyst
LeFrak
New York, NY, United States of America
01.2023 - 10.2023
- Oversaw a multifamily portfolio consisting of 101 buildings, numbering 18,000 apartments, in major markets within New York, New Jersey, Florida, and California
- Coordinated 2024 budget creation for 3 sub-portfolios, achieving 2023 cost savings of 3.3% in operating expenses and 15.2% in turnover costs through cross-departmental data integration and monthly variance analysis
- Streamlined decision-making with in-depth vacancy and rent performance reporting; initiated a KPI analysis for the Florida submarket to refine the region’s strategies
Residential Property Administrator
LeFrak
New York, NY, United States of America
09.2021 - 12.2022
- Managed two multifamily portfolios: South 2 (15 buildings, 1,095 units in Brooklyn) and North 1 (7 buildings, 1,341 units in Manhattan and Queens), enhancing compliance and reducing South 2 violations by 20%
- Achieved a 4.5% reduction in turnover costs and shortened unit prep time to 14 days in the North 1 portfolio through strategic vendor selection and efficient labor allocation, despite inflationary pressures
Assistant Property Manager Intern
Big Management
Brooklyn, NY, United States of America
09.2020 - 03.2021
- Managed leasing, accounting, and tenant relations for a 79-unit portfolio, ensuring accurate financials and reporting
Residential Real Estate Salesperson
Capri Jet Realty
Brooklyn, NY, United States of America
07.2019 - 08.2020
- Successfully sold a three-family building for $1.18M and leased 5 units, generating $10K in gross commissions
Education
Master of Science - Real Estate
Baruch College
New York, NY 08.2023 - 12.2024
Bachelor of Business Administration - Real Estate
Baruch College
New York, NY 08.2017 - 06.2021
Skills
- Microsoft Office Suite
- Excel (Macros, Pivot Tables, VBA)
- Financial Modelling (Pro Formas, Equity Waterfalls, Sensitivity Analysis)
- PowerPoint
- ARGUS Enterprise
- Yardi Voyager
- SAP
- Tableau
- Microsoft Power BI
Certification
- REFM Certification in Excel for Real Estate- Levels 1, 2, and 3
- The Real Estate Pro Forma Modeling Master Class
- The Commercial Real Estate Lease Modeling Master Class
Languages
English
Native
Polish
Native
Spanish
Intermediate (B1)
References
References available upon request.
Projects
A Tale of Two Properties Investment Memo May 2024
Recommended refinancing for two commercial properties, maximizing equity cash-out to $4.24M.
Wildcat Investment Memo April 2024
Analyzed the Financial Commons office acquisition, achieving 25% levered IRR with strategic recommendations.
Timeline
Acquisitions Analyst Intern
Camber Property Group
05.2024 - 12.2024
Master of Science - Real Estate
Baruch College
08.2023 - 12.2024
Asset Management Analyst
LeFrak
01.2023 - 10.2023
Residential Property Administrator
LeFrak
09.2021 - 12.2022
Assistant Property Manager Intern
Big Management
09.2020 - 03.2021
Residential Real Estate Salesperson
Capri Jet Realty
07.2019 - 08.2020
Bachelor of Business Administration - Real Estate
Baruch College
08.2017 - 06.2021
- REFM Certification in Excel for Real Estate- Levels 1, 2, and 3
- The Real Estate Pro Forma Modeling Master Class
- The Commercial Real Estate Lease Modeling Master Class
Similar Profiles
Clayton GarrisonClayton Garrison
Portfolio Manager at Camber Property Management and LeasingPortfolio Manager at Camber Property Management and Leasing
Kylee ScottKylee Scott
BHT at Camber Mental Health HospitalBHT at Camber Mental Health Hospital
EMARIE SCHOENTHALEREMARIE SCHOENTHALER
Admissions Coordinator at Camber Children's Mental HealthAdmissions Coordinator at Camber Children's Mental Health