The Fortune 500 company provides mechanical and electrical construction, industrial and energy infrastructure, and facilities services to a broad range of commercial, industrial, utility, and institutional customers. The company comprises over 75 operating companies and has approximately 170 locations.
The goal of the project was to put in place the foundation for a building services data warehouse that will support the client’s business reporting and analytics needs. It would also ease the burden for the operations group related to data preparation and manipulation and free them up for business analysis.
The scope of the implementation was focused on Work Order lifecycle management.
The Smartbridge team designed and developed the data warehouse. The project was a fixed contract project and the team consistently made sure to work to improve customer satisfaction.
As an Informatica partner
, Smartbridge not only helped the client select Informatica PowerCenter for Data Integration but also sold licenses along with the installation of the tool.
Example of Historical Trend Reporting
This build of the data warehouse was delivered successfully on time and on budget.
The results achieved in the current phase will expand the client’s reports and dashboards built from the data warehouse to their customers. It will also open up new levels of visibility into the business that currently do not exist or require more manual efforts.