Mark Gschwind Email & Phone Number

San Francsico Bay Area

2Five1 Consulting is a Yardi Consulting Partner that implements solutions tailored to the real estate industry with expertise in all things Yardi, IT strategy, data warehousing, and business intelligence. Our mission is to address the strategic and tactical needs of real estate organizations through our deep industry knowledge and customized solutions regardless of their size or complexity. We believe technology alone will not solve challenges, instead it is People | Process | Technology.As the Practice Lead for Business Intelligence at 2Five1 Consulting, I oversee the design and implementation of custom solutions for data warehousing, business intelligence, data conversions, data integrations and custom reporting that enhances our clients' decision-making capabilities. I also provide strategic guidance on creating a data infrastructure that provides a foundation for advanced data analytics. Key Past Performances and Projects: - Yardi Data Conversion: Mapped and migrated Sage data to a new Yardi ERP for a major affordable housing developer/operator and created an ongoing process to integrate third-party financial data.- Yardi Data Conversion: Completed MRI to Yardi data conversion for a small, privately held commercial real estate owner/operator.- YSR (Yardi) Report Development: Developed over 100 custom YSR reports for diverse real estate clients, covering various sectors (Commercial, Residential, Industrial, Affordable) and purposes (GL Reporting, Budgeting/Forecasting, Operational Management, Investment Accounting).- Data Warehouse for Residential Real Estate Company: This client relied on Excel reports led to inconsistent and siloed information. We improved analytics for a large residential developer by creating a comprehensive data warehouse, integrating multiple sources, and developing a Power BI report deck with 16 reports, delivering a single source of truth for next-level analytics and insights.

San Francisco, Ca

DesignMind, a Microsoft Gold Partner and data analytics consulting firm, specializes in developing business intelligence, cloud, and data analytic solutions to help organizations optimize and understand their data.I led a team that built enterprise data solutions to enhance client productivity and decision-making capabilities. I specialized in data warehousing, reporting systems, cubes, and data mining. I led efforts to design and implement robust business intelligence frameworks.Key Past Performances and Projects:- For a medical client, my team and I built and deployed a Medical Data Warehouse and reporting system using Amazon EC2 servers with SQL Server 2012 and Tableau Server. I implemented dimensional modeling, ETL processes, and master data services while ensuring HIPAA compliance through data encryption and AWS security best practices.

San Francisco Bay Area

Prologis, the largest REIT in the world, develops modern, high-quality industrial properties that set the standard for innovative building design and sustainability.As the VP of Business Information Architecture, I led major data architecture and business intelligence initiatives, improving data quality and data management. These efforts significantly boosted productivity for over 200 users and advanced our organizational analytics capabilities. I also developed and implemented strategies to streamline data workflows and enhanced overall system efficiencies.

San Francisco Bay Area

Cube Consulting Group advanced its clients’ business intelligence capabilities to the next level. A key to its success was working with clients to understand its people, its data, and its reporting needs.I led the company by hiring and training consultants, building strong relationships with vendors and clients, creating a highly respected and profitable business intelligence consulting practice. Throughout this twelve-year timeframe, I maintained a steady growth glidepath and remained profitable.

San Francisco Bay Area

A3 Solutions transform finance teams by turning Excel into a scalable, secure, and collaborative enterprise-grade FP&A tool with A3 Modeling.I managed financial analysis systems using Essbase (Oracle/Hyperion) OLAP database software, hired and trained consultants, and led multiple projects, driving the growth and profitability of a 20-person consulting organization.

Mba, Finance

Bachelor Of Business Administration - Bba