Procore - NetSuite
I am the lead developer for Calance’s Procore NetSuite ERP integrations. I expanded the functionality by adding several new C# / .NET integrations to send financial data between Procore and NetSuite, including subcontractor invoices and payments, owner invoices and payments, commitments, and commitment change orders. I improved an existing integration to sync direct costs by making it 2x faster and added a feature to automatically look for necessary vendors in Procore’s ERP staging table rather than requiring the user to manually add vendors.
Major Metroplitan City
I helped the parks and recreation department of a major metropolitan city automate their subcontractor invoice process. This involves listening for webhooks from Procore and programatically generating an Excel spreadsheet from data within Procore and then converting it to a .pdf called a pay estimate form. I also set up webhook handling and integrations to update project custom fields in Procore with certain calculated data from the pay estimate form.
The next phase of planned work will be to create a full stack web app with React, TypeScript, and C# / .NET Core that will run as an iFrame embedded within the Procore website. This app will allow the city’s subcontractors to fill out and sign various forms. The data will be stored in Amazon Web Services DynamoDB, and later read and added to the pay estimate form.