Building the Roadmap for a Construction & Infrastructure Company’s Analytics Needs
The Client
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.
Goal
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.
Smartbridge Implementation
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.
Key Highlights:
- 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.
- To achieve optimal performance, Informatica Load Balancing was implemented in production for distributing workloads across the nodes in the grid. This strategy balanced the workload and considerably decreased the execution times on huge volume data loads.
- Recovery and reprocessing Logic for Failures were also implemented with the help of High Availability
- Development was accomplished on time by utilizing a dedicated offshore team in India that was involved in testing/QA efforts.
Example of Historical Trend Reporting
Results
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.

“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”.
There’s more to explore at Smartbridge.com!
Sign up to be notified when we publish articles, news, videos and more!
Other ways to
follow us: