- Greystar has many existing enterprise systems, and HingePoint had to come up with a road map that will leverage existing infrastructure or develop custom systems where no Out of the Box (OOTB) tool fits the Greystar business.
- Many systems were not talking so integration and sharing of data and tools needed to be scaled out for North America as well as the growing portfolio of real estate in Europe, Asia, and South America.
- The business lacked standards on the business processes running on Excel for real estate pipeline modeling, deal flow, committee approval, financial proformas, and asset management and asset forecasting.
- Even where a system was enterprise-grade, such as Yardi Financials, there were 3 different versions of Yardi, for different regions, and they all needed to be integrated. And 2 regions used Oracle Financials.
The Solutions
Construction Financials Automation - Procore - Yardi - Oracle
Construction management is performed in Procore for 100’s of projects. 8 instances of Procore are used globally, 1 each for a different currency. 3 versions of Yardi financials are used, for 3 regions. 2 versions of Oracle financials are used globally. Dell Boomi is the integration tool of choice at Greystar.In order to keep Procore financials updated we had to create 3 Integration Processes in Boomi:
- Create Budget – this imported and updated project budgets, contracts, and cost codes from estimating software
- Modify Budgets – as projects progress, budgets are modified with change orders, contract, and subcontract amendments. We had to automatically unlock, modify, and update the budgets across all projects and Procore systems monthly
- Update Costs – to get actual costs into Procore from Yardi and Oracle, we had to automatically update direct and subcontract costs
Development Pipeline – Napkin to Sale System
This system has data on all assets from the initial idea sketched on the back of a napkin, through development, construction, turn over, lease-up, and eventual sale of a fully profitable asset. Much of this data was stored and maintained on Excel spreadsheets, including the inventory of deals, budgets, committee approvals, proformas, and financial forecasts. All this information is now part of GoData. GoData is a custom application because, after years of research, no off the shelf product could accommodate the Greystar process. So HingePoint created cutting edge modern application based on custom app services, SQL as a Service (SaaS) APIs that integrated with Azure functions to process Excel data from 100’s of models. Over 25 reports and dashboards are integrated through Power BI APIs. Data flows and is shared across the enterprise data warehouse (EDW). Property Photography is in Azure Blob storage. Security is handled with Greystar Single Sign-On (SSO) and Azure Active Directory for roles-based security. An agile development process is leveraging DevOps and continuous improvement and continuous integration (CICD) for push-button deployments from Dev, Test, Staging, and Production. We can deploy code in minutes and release features in hours and days, not weeks and months. Weekly sprints are used to bring value to the business every single week.Map App Mobile for iPhone, Android, and iPads
Developers are very mobile and working from the road and home, so they use mobile devices and tablets. So GoData needed to work well on mobile. While it is responsive, we needed to use maps to show properties in a city, state, or region. HingePoint helped develop mobile apps:- Leveraging over 75% of code reuse from GoData
- Map App is the first mobile app released at Greystar and it leverages the Zamrin mobile framework
- Single Sign-On (SSO) for mobile via Apple and Android
- Reuse of the same CICD pipeline
- Bing Maps APIs is used to bring custom designed maps of properties in the pipeline.
- Apple Enterprise deployment tools are used to get the Apps to the Users.
SharePoint Brand Standards
As Greystar expands globally the need for regional standards would help bring best practices for development, asset management, construction, and operations of assets. Leveraging enterprise SharePoint for document management, HingePoint helped with customizing SharePoint to build a GoPortal to access brand documents. To improve custom document search and metadata taxonomy we created custom Web Parts and custom Search Results to make it very easy for users to find documents in 4 simple approaches:- Search
- Navigation
- A filtered document by metadata configurations
- Training videos in Stream
Salesforce – Integration and Migration
In 2020 Greystar acquired another company with over 750 properties under management. Many of the processes to market, sell, and transition properties to Greystar are executed on Salesforce tools. Greystar needed to merge all the salesforce data from the Alliance company to Greystar and HingePoint helped with the following migrations:- Benchmark and define all 4 custom modules at Alliance Salesforce
- Benchmark all Greystar salesforce data objects and workflows
- Map data from Alliance to Greystar
- Develop over 500 custom objects, with screens and flows
- Migrate data from Alliance to Greystar
- Transition users from one system to another
- Develop reporting for 100’s of end-users across 5 Divisions – Marketing, Operations, Transitions, and Business Development and Compliance
Ongoing Benefits:
- Reduced development costs by using agile teams that are highly efficient, blending experts from Greystar and HingePoint and other partners
- The first use of CICD and enterprise SSO for push-button deployment
- Established the enterprise standard for DevOps
- Fist Mobile application and mobile framework that will deploy many mobile apps in the future
- Reduced use of Excel and standardized data formats across all phases of development
- The first use of modern Service Oriented Architecture
- First expansive use of Power BI APIs for custom reporting and dashboards
- data redundancy by 100%, while managing 100% of document security.
- Enterprise IT got the technical expertise they needed to do the development and integration of many systems and tools required to empower Greystar
- Greystar is now the largest multi-family develop with over 2600 assets
- Integrated global financials to Procore using Dell Boomi
Who Was Helped:
IT, Design, Engineering, Construction Management, and Asset Management teams.
- Platform Investment Committee (PIC) was responsible for initiatives that would help Greystar scale into their global leadership status.
- Newly created enterprise systems team – VP, Sr. Director
- VP of Development
- VP of International Development
- VP of Asset Finance
- Director of Property Transitions
- VP of Compliance and Risk
- Mergers and Acquisitions
- Construction Management
- CapEx Development for Owned Assets
- Renovation of existing assets
Systems Integrated:
- Enterprise Data Warehouse (EDW)
- Custom Web App Development
- Bing Map Services
- Custom Mobile App Development
- Power BI Reports and Dashboards
- Single Sign-On (SSO) and Azure Active Directory (AD) Security
- Azure Functions
- Azure SQL as a Service (SaaS)
- Custom API Development
- DevOps – CICD (continuous integration continuous deployments)
- Dell Boomi – coordinate 3 major financial process across 8 Procore, 3 Yardi, and 2 Oracle
- Yardi integration with Procore
- Oracle financial integration
- Procore API integration
- Salesforce Merge and Migrate
- SharePoint Document Management, Custom Web Parts
Summary:
HingePoint helped a global chicken restaurant renovate over 4,000 stores nationwide. Working with the Chief Innovation Officer and the IT Director, HingePoint integrated 3 corporate systems to work seamlessly together.The Challenge:
3 key teams were working on the renovation portfolio and all needed access to the same documents and projects. But, they all used different systems on the job. Asset managers used a real estate asset management tool to plan and manage the renovation. Design and Engineering used their system to create all the CAD documents and specifications. And the construction management teams used SharePoint out in the field to manage the projects with their subcontractors. If they all used 3 systems, it would be redundant and disorganized.The Solution:
[caption id="attachment_15024" align="alignright" width="200"]
Click here to see how SharePoint for Document Management can help your business...[/caption]
- Integrate the workflow that started from the real estate asset management system to initiate renovation projects.
- Create a custom SharePoint document management integration with all 3 systems so they could share documents in real-time.
- Spawn a project in SharePoint from the asset management system to be used for construction management.
- Create a single sign-on (SSO) so users were automatically secured and logged in across all tools needed in the end-to-end process.
Ongoing Benefits:
- Reduced data redundancy by 100%, while managing 100% of document security.
- IT got the technical expertise they needed to do the integration and the Chief Innovation Officer accomplished a major initiative for the business.
- This is now one of the fastest-growing chicken restaurants nationwide.
Who Was Helped:
IT, Design, Engineering, Construction Management, and Asset Management teams.Systems Integrated:
SharePoint, SharePoint for Document Management, Real Estate Asset Management, Construction Management « Back to SharePoint for Document Management [post_title] => SharePoint for Document Management and Construction Management of 4,000 Chicken Restaurants [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => sharepoint-for-document-management-and-construction-management-of-4000-chicken-restaurants [to_ping] => [pinged] => [post_modified] => 2020-02-12 13:42:41 [post_modified_gmt] => 2020-02-12 19:42:41 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=case-studies&p=15009 [menu_order] => 0 [post_type] => case-studies [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 14036 [post_author] => 16 [post_date] => 2018-02-12 05:06:17 [post_date_gmt] => 2018-02-12 11:06:17 [post_content] =>Summary:
HingePoint helped build over 10,000 franchise brand construction projects with a customized website where headquarters can collaborate with franchisees, construction, and design professionals to build out a portfolio of real estate assets that are exactly built to design standards and specifications.
Working with the Architect of Record and brand design groups, we helped with IT solutions for hotels/hospitality, restaurants, retail and more for brands ranging from Chick-fil-A, Under Armor, ALDI, Footlocker, JLL, and AMEX.
The Challenge:
Global brands want a consistent user and brand experience for customers worldwide. It is difficult to coordinate with design and construction teams across the country or the globe to share brand standards, design guide drawings, and specifications. Internal IT teams are trying to protect corporate security yet the design and construction divisions must work with 100’s and 1000’s of external professionals that need download and exchange construction documents.
Solution:
- Develop a custom branded website that has all the information needed to design and construct the branded real estate asset
- Secure the site with enterprise single sign-on and other corporate security compliant access
- Provide critical documents to external partners including
- Prototypical floor plans and CAD drawings
- Specifications for Furniture, Fixtures, and Equipment (FF&E)
- Operating Methods and procedures for staff
- Marketing and Advertising specifications for signage and promotions
- Onboarding, training, and brand overview educational materials
Ongoing Benefit:
- Created a one-stop-shop location where design and construction professions can get all the information, they need, to build a perfect brand asset
- Secure corporate IP and brand standards that satisfy the strictest global security standards
- Make it easy to access information from any device and any location globally
- Create a branded experience, that looks exactly the company's creative style. No ugly or clunky tools users don’t like
Who Was Helped:
Corporate design, Corporate marketing, architects, engineers, general contractors, installers, construction sub-contractors, IT managers
Systems Integrated:
Wordpress, SharePoint Document Management, Cloud Hosting, Mobile Applications, Single Sign On (SSO)
[post_title] => Brand Asset Management Solution for Big Brand Commercial Real Estate Developers [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => brand-standard-prototypes-construction-documents [to_ping] => [pinged] => [post_modified] => 2020-02-12 13:43:55 [post_modified_gmt] => 2020-02-12 19:43:55 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/case-studies/custom-tririga-wms-with-buzzsaw-and-revit-api-copy/ [menu_order] => 0 [post_type] => case-studies [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 13931 [post_author] => 16 [post_date] => 2018-02-12 03:30:20 [post_date_gmt] => 2018-02-12 09:30:20 [post_content] =>Summary:
HingePoint helped the top global hotel brand with over 7,500 franchise properties put all their hotel owners and all their construction and renovation projects in one system of record. So you could see the full history of all properties in the entire global portfolio.
The challenge:
An outdated database was difficult to upgrade, with slow performance and hard to access. This global brand could not track the history of an asset or the renovations and upgrades that were done to it. A mission-critical system was needed to track and manage all projects that built and enhanced the assets over the long history.
The Solution:
- HingePoint created a cloud-based asset management and construction management system for the entire portfolio.
- Project standardization for new build and renovations data
- Project schedule and timelines were standardized
- Analytics of roll up and drill down by asset and owners
Ongoing Benefits:
- Track the history of all project on an asset and drill down into the milestones and data associated with each new build, renovation or upgrade to the property.
- Marketing and resale of properties because of excellent history and record-keeping
- Create a global standard for asset management and property improvements
Who Was Helped:
Franchise operation, brand design, and construction, real estate investors, asset managers, franchisees, general contractors, construction firms
System Integrated:
Custom systems built on Oracle enterprise.
[post_title] => Cloud-based Asset & Project Management Solution for Construction & Renovation Projects [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => construction-project-management-asset-development [to_ping] => [pinged] => [post_modified] => 2020-02-12 13:43:44 [post_modified_gmt] => 2020-02-12 19:43:44 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=case-studies&p=13931 [menu_order] => 0 [post_type] => case-studies [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 13750 [post_author] => 13 [post_date] => 2018-01-31 01:23:45 [post_date_gmt] => 2018-01-31 07:23:45 [post_content] => Before working with HingePoint, we were just another commercial real estate company trying to get deals done. Now, we’re one of the most innovative firms in the industry. HingePoint’s knowledge, insight and guidance has allowed us to manage risk systematically better, affording us the opportunity to scale efficiently while also generating increased profits at both the property and company level [post_title] => Victor R. Mendiola, Jr., Promesa Investments [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => victor-r-mendiola-jr-promesa-investments [to_ping] => [pinged] => [post_modified] => 2020-02-12 13:50:18 [post_modified_gmt] => 2020-02-12 19:50:18 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=testimonials&p=13750 [menu_order] => 0 [post_type] => testimonials [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 13715 [post_author] => 13 [post_date] => 2018-01-30 06:46:13 [post_date_gmt] => 2018-01-30 12:46:13 [post_content] => No more confusion between Revit design documents and our Bill of Materials. Finally they are in sync! [post_title] => Director of Procurement [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => director-of-procurement [to_ping] => [pinged] => [post_modified] => 2020-02-12 15:33:47 [post_modified_gmt] => 2020-02-12 21:33:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=testimonials&p=13715 [menu_order] => 0 [post_type] => testimonials [post_mime_type] => [comment_count] => 0 [filter] => raw ) [6] => WP_Post Object ( [ID] => 13714 [post_author] => 13 [post_date] => 2018-01-30 06:45:37 [post_date_gmt] => 2018-01-30 12:45:37 [post_content] => Automating user enrollment has been a life saver and taken a ton of work off my plate. [post_title] => Buzzsaw Systems Administrator [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => buzzsaw-systems-administrator [to_ping] => [pinged] => [post_modified] => 2020-02-12 15:33:47 [post_modified_gmt] => 2020-02-12 21:33:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=testimonials&p=13714 [menu_order] => 0 [post_type] => testimonials [post_mime_type] => [comment_count] => 0 [filter] => raw ) [7] => WP_Post Object ( [ID] => 13713 [post_author] => 13 [post_date] => 2018-01-30 06:43:18 [post_date_gmt] => 2018-01-30 12:43:18 [post_content] => I didn’t know we could brand and customize Buzzsaw. We just love how it looks now and it is so much easier to use. [post_title] => Director of Business Systems [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => director-business-systems [to_ping] => [pinged] => [post_modified] => 2020-02-12 15:33:47 [post_modified_gmt] => 2020-02-12 21:33:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=testimonials&p=13713 [menu_order] => 0 [post_type] => testimonials [post_mime_type] => [comment_count] => 0 [filter] => raw ) [8] => WP_Post Object ( [ID] => 13699 [post_author] => 13 [post_date] => 2018-01-29 05:26:28 [post_date_gmt] => 2018-01-29 11:26:28 [post_content] => These consultants found ways to weave data from many of our tools into one perfectly simple solution we all use every day. [post_title] => Construction Manager [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => construction-manager [to_ping] => [pinged] => [post_modified] => 2020-02-12 15:33:47 [post_modified_gmt] => 2020-02-12 21:33:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=testimonials&p=13699 [menu_order] => 0 [post_type] => testimonials [post_mime_type] => [comment_count] => 0 [filter] => raw ) [9] => WP_Post Object ( [ID] => 13698 [post_author] => 13 [post_date] => 2018-01-29 05:26:06 [post_date_gmt] => 2018-01-29 11:26:06 [post_content] => The Idea Lab was the first time we’ve ever had the chance to imagine exactly how we wanted our systems to work, and someone deliver exactly that for us! [post_title] => Director of Interior Design [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => director-interior-design [to_ping] => [pinged] => [post_modified] => 2020-02-12 15:33:47 [post_modified_gmt] => 2020-02-12 21:33:47 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?post_type=testimonials&p=13698 [menu_order] => 0 [post_type] => testimonials [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 10 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 15292 [post_author] => 8 [post_date] => 2020-10-27 10:15:28 [post_date_gmt] => 2020-10-27 15:15:28 [post_content] =>Summary:
Greystar, a global real estate developer and operator, was seeking a software development partner to support their new Enterprise Systems team. HingePoint was selected to develop an Enterprise Architecture Plan to automate and integrate entire business segments that had no enterprise tools, and we stuck working on spreadsheets and email to manage a huge global development platform worth over $20B.The Challenge
- Greystar has many existing enterprise systems, and HingePoint had to come up with a road map that will leverage existing infrastructure or develop custom systems where no Out of the Box (OOTB) tool fits the Greystar business.
- Many systems were not talking so integration and sharing of data and tools needed to be scaled out for North America as well as the growing portfolio of real estate in Europe, Asia, and South America.
- The business lacked standards on the business processes running on Excel for real estate pipeline modeling, deal flow, committee approval, financial proformas, and asset management and asset forecasting.
- Even where a system was enterprise-grade, such as Yardi Financials, there were 3 different versions of Yardi, for different regions, and they all needed to be integrated. And 2 regions used Oracle Financials.
The Solutions
Construction Financials Automation - Procore - Yardi - Oracle
Construction management is performed in Procore for 100’s of projects. 8 instances of Procore are used globally, 1 each for a different currency. 3 versions of Yardi financials are used, for 3 regions. 2 versions of Oracle financials are used globally. Dell Boomi is the integration tool of choice at Greystar.In order to keep Procore financials updated we had to create 3 Integration Processes in Boomi:
- Create Budget – this imported and updated project budgets, contracts, and cost codes from estimating software
- Modify Budgets – as projects progress, budgets are modified with change orders, contract, and subcontract amendments. We had to automatically unlock, modify, and update the budgets across all projects and Procore systems monthly
- Update Costs – to get actual costs into Procore from Yardi and Oracle, we had to automatically update direct and subcontract costs
Development Pipeline – Napkin to Sale System
This system has data on all assets from the initial idea sketched on the back of a napkin, through development, construction, turn over, lease-up, and eventual sale of a fully profitable asset. Much of this data was stored and maintained on Excel spreadsheets, including the inventory of deals, budgets, committee approvals, proformas, and financial forecasts. All this information is now part of GoData. GoData is a custom application because, after years of research, no off the shelf product could accommodate the Greystar process. So HingePoint created cutting edge modern application based on custom app services, SQL as a Service (SaaS) APIs that integrated with Azure functions to process Excel data from 100’s of models. Over 25 reports and dashboards are integrated through Power BI APIs. Data flows and is shared across the enterprise data warehouse (EDW). Property Photography is in Azure Blob storage. Security is handled with Greystar Single Sign-On (SSO) and Azure Active Directory for roles-based security. An agile development process is leveraging DevOps and continuous improvement and continuous integration (CICD) for push-button deployments from Dev, Test, Staging, and Production. We can deploy code in minutes and release features in hours and days, not weeks and months. Weekly sprints are used to bring value to the business every single week.Map App Mobile for iPhone, Android, and iPads
Developers are very mobile and working from the road and home, so they use mobile devices and tablets. So GoData needed to work well on mobile. While it is responsive, we needed to use maps to show properties in a city, state, or region. HingePoint helped develop mobile apps:- Leveraging over 75% of code reuse from GoData
- Map App is the first mobile app released at Greystar and it leverages the Zamrin mobile framework
- Single Sign-On (SSO) for mobile via Apple and Android
- Reuse of the same CICD pipeline
- Bing Maps APIs is used to bring custom designed maps of properties in the pipeline.
- Apple Enterprise deployment tools are used to get the Apps to the Users.
SharePoint Brand Standards
As Greystar expands globally the need for regional standards would help bring best practices for development, asset management, construction, and operations of assets. Leveraging enterprise SharePoint for document management, HingePoint helped with customizing SharePoint to build a GoPortal to access brand documents. To improve custom document search and metadata taxonomy we created custom Web Parts and custom Search Results to make it very easy for users to find documents in 4 simple approaches:- Search
- Navigation
- A filtered document by metadata configurations
- Training videos in Stream
Salesforce – Integration and Migration
In 2020 Greystar acquired another company with over 750 properties under management. Many of the processes to market, sell, and transition properties to Greystar are executed on Salesforce tools. Greystar needed to merge all the salesforce data from the Alliance company to Greystar and HingePoint helped with the following migrations:- Benchmark and define all 4 custom modules at Alliance Salesforce
- Benchmark all Greystar salesforce data objects and workflows
- Map data from Alliance to Greystar
- Develop over 500 custom objects, with screens and flows
- Migrate data from Alliance to Greystar
- Transition users from one system to another
- Develop reporting for 100’s of end-users across 5 Divisions – Marketing, Operations, Transitions, and Business Development and Compliance
Ongoing Benefits:
- Reduced development costs by using agile teams that are highly efficient, blending experts from Greystar and HingePoint and other partners
- The first use of CICD and enterprise SSO for push-button deployment
- Established the enterprise standard for DevOps
- Fist Mobile application and mobile framework that will deploy many mobile apps in the future
- Reduced use of Excel and standardized data formats across all phases of development
- The first use of modern Service Oriented Architecture
- First expansive use of Power BI APIs for custom reporting and dashboards
- data redundancy by 100%, while managing 100% of document security.
- Enterprise IT got the technical expertise they needed to do the development and integration of many systems and tools required to empower Greystar
- Greystar is now the largest multi-family develop with over 2600 assets
- Integrated global financials to Procore using Dell Boomi
Who Was Helped:
IT, Design, Engineering, Construction Management, and Asset Management teams.
- Platform Investment Committee (PIC) was responsible for initiatives that would help Greystar scale into their global leadership status.
- Newly created enterprise systems team – VP, Sr. Director
- VP of Development
- VP of International Development
- VP of Asset Finance
- Director of Property Transitions
- VP of Compliance and Risk
- Mergers and Acquisitions
- Construction Management
- CapEx Development for Owned Assets
- Renovation of existing assets
Systems Integrated:
- Enterprise Data Warehouse (EDW)
- Custom Web App Development
- Bing Map Services
- Custom Mobile App Development
- Power BI Reports and Dashboards
- Single Sign-On (SSO) and Azure Active Directory (AD) Security
- Azure Functions
- Azure SQL as a Service (SaaS)
- Custom API Development
- DevOps – CICD (continuous integration continuous deployments)
- Dell Boomi – coordinate 3 major financial process across 8 Procore, 3 Yardi, and 2 Oracle
- Yardi integration with Procore
- Oracle financial integration
- Procore API integration
- Salesforce Merge and Migrate
- SharePoint Document Management, Custom Web Parts