Patrick Foley Email & Phone Number

Dallas, TX, US

Dallas, Texas, United States

Dallas, Texas, United States

• Led multiple initiatives to streamline data cleanup by leveraging Python and SQL to connect to our databases within Snowflake and match newly obtained data with previous records, significantly reducing the resources.
• Prepared presentations in PowerPoint and ThoughtSpot for Industrial REIT clients by analyzing market demographics, leasing trends, and sales data, to present new opportunities for investment or development based on the.
• Assisted Client Advisory Services Team by providing multifamily market demand forecasts for investment and development initiatives, using Python and SQL to analyze real estate market trends, economic indicators, and.
• Developed valuation models, including Discounted Cash Flows, for our national leader of golf and land practice to evaluate optimal strategies for client portfolios. Adapted financial models to determine present value.

Dallas, Texas, United States

• Developed and automated financial analysis models for tenant representative and sales brokers. Enabling brokers to input their criteria and receive detailed models for evaluating potential sale and lease terms, in turn.
• Wrote SQL Queries to manage and more easily access our expansive data sets as well as connect our data to third party sources. Example: Used SQL to aggregate leasing and property data grouped by markets and submarkets.
• Organized training sessions for our national data team regarding the basics of SQL and how to edit queries for everyday use, improving data management efficiency.
• Assembled Python scripts using Pandas to aggregate and clean property and lease data from Excel workbooks for further analysis and display on Avison Young’s market intelligence platform, AVANT.Learned

Greater Detroit Area

• Worked under a Vice President to research potential manufactured home and RV properties and their nearby demographics.
• Developed a streamlined template to convey housing market statistics within a set radius.
• Worked closely with the acquisitions team executives at Sun Communities (NYSE: SUI) and presented researched properties for potential development.
• Analyzed data from the US Census Bureau and stock market history for Sun Communities and Equity Lifestyle(NYSE: ELS) to build a presentation for a Real Estate Panel Luncheon regarding the financial opportunities in.

Greater Detroit Area

• Oversaw incoming and outgoing international shipments of steel for inventory control.
• Maintained quality inspections by measuring tubing to ensure tolerances were within specifications.
• Worked with purchasing and accounting to incorporate lean manufacturing, improving inventory turns.

Greater Detroit Area

• Developed spreadsheets in Excel to help company keep track of clients.
• Managed bank deposits and client files to ensure high levels of organization and efficiency.
• Led Event Planning for community outreach affairs.