Andrew Marken Email & Phone Number

Built the first Microsoft Excel and Access based models utilizing SQL and VBA for the Agency to catalog owned, leased, licensed property as well as tracking all facility projects and contracts throughout the state.• Manage all Dept. Mental Health (DMH) space leases statewide, providing technical guidance and direction to stakeholders, co-agencies and landlords. • Procured 39 vehicles for agency use. • Coordinate with required entities (DMH Central Office, Area and Site Directors, Executive Office of Health and Human Services (EHS), Office of Lease and State Office Planning (OLSOP), Division of Capital Asset Management and Maintenance (DCAMM), and Landlords) to ensure that the proposed space meets the department's programmatic and staffing needs• Develop, manage and analyze data and data systems for the Areas to insure information is readily available for program staff, DCAMM, OLSOP and landlords for review and analysis to identify needs to insure program meets all requirements as specified in leases, security plans and any other negotiated agreements. • Develop physical space plans; coordinate IT installs. Prepare Lease and License Documents. Monitor paperwork flow from initiation to EHS to DCAMM and finally through DMH Fiscal.• Maintain and provide guidance regarding DMH site evacuation plans. • Graduated from the competitive CMCP and MasSP State of Massachusetts management training programs.• Maintain detailed database for all DMH properties, as well as databases or reporting tools for all assigned activities. • Manage the procurement and administration of Construction Contracts in accordance with legal and procedural requirements that apply to public construction contracts under (MGL. Ch.149, Ch.30§39M).• Obtained the MCPPO designation in 2021

Bad Homburg, Frankfurt, De

Successfully negotiated over 500 lease transactions saving over $15 million in rent reductions, tenant improvement allowances, and other key lease concessions. Manage two outsource teams working on 250 projects at a given time in support of a portfolio consisting of 1200+ properties. Led project management teams identifying, guiding, and coordinating development issues bringing to market the clinic while keeping overall construction costs in line for the various construction projects.Secured coveted retail storefront space in Washington, D.C. market for operational expansion, winning the space over 5 retailers competing for the same location.Worked with Operations and Legal departments to fast track amendment within 2 business days to prevent landlord from locking doors to a critical clinic.Create NPV, IRR, and ROI analysis and use existing company financial models based on 1 to 15 year deals.Worked with Operations and legal departments to fast tack amendment within 2 business days to prevent landlord from locking doors to a critical clinic.Rewrote policy and process for fair market value reports; national implementation saved time and money with each transaction.Develop and create forms and processes for department use saving money by minimizing time spent, eliminating errors, and standardizing the processes.

Represented Finard and Co. throughout New England as a Leasing Representative. Developed successful comprehensive leasing strategies to lease out various retail spaces for company owned and third party clients in secondary markets resulting in space being leased or prospective tenants offering to lease space in very challenging markets and spaces. Additionally, I was fortunate where the company rotated me around to Research and Investment Sales to gain a more complete understanding of operations. Managed the research department which tracked about 20,000 retail spaces throughout New England. Analyzed the database and performed analysis to determine market trends and dynamics in each of the various submarkets throughout New England. Generated and analyzed Argus report runs to value various commercial properties for the investment sales team that were being brought to market.

Traveled throughout the country representing TJX Corp negotiating for lease related overcharges. Covered 30 states and approximately 200 cities performing my work. Top producer for savings and collections. Trained and mentored coworkers in their job responsibilities.Identified and collected over $200k from a landlord on a real estate tax parcel billing error. The landlord had incorrectly determined which tax parcels should be included in our pro-rata share of taxes.Researched and identified a real estate abatement that a landlord did not pass through to TJX, and collected $90k as a result.Trained and coached all department employees in the processes and procedures involved in completing a successful audit, including lease and financial analysis.Earned employee of the Quarter award for exemplary performance as a member of the 300-person Finance Division.Lectured at the NRTA industry conference in Palm Springs, CA about CAM audit negotiations and strategies.

Mba, Commercial Real Estate

Bachelor Of Science (B.S.), Finance And Communications