Delivering an Agile, Accurate and Interactive Workforce Analytics Solution to a Large European Bank

Challenges.

The client faced several challenges impacting their workforce management:

• Manual consolidation of data from multiple sources to produce reports and scorecards in excel. There was a lack of a centralized system for workforce analytics
  
• Static visualization of data with no possibility of deeper analytics and minimal presentation of meaningful information.
  
• This culminated to hampered business decision making with reduced efficiency.
  
• A solution was required to establish meaningful KPIs and scorecards for workforce management.

Solution.

With a focus on data management, simplification, agility and visualisation, Coforge worked jointly with client’s team over three weeks to develop an automated solution in MicroStrategy, which allowed users to drill-down, self-serve and build analysis in an interactive environment.

Key activities undertaken 

Solution highlights

Automated Data Integration: Centralized data from seven disparate systems into a single, integrated platform. The tool provides accurate information on client’s entire workforce. This includes their roles, skills, secondment details, working hours and which projects they are assigned to. It also provides supplier and vendor analysis to compare costs.

Interactive Dashboards: Clear and interactive dashboards/reports showing the current levels against target levels for contractors, suppliers, agencies, along with permanent members of staff, allows for effective decisions to be made centrally and eliminating two-week delays in ad-hoc queries.

Cost and Vendor Analysis: Enabled comparison of supplier and vendor costs, driving cost optimization.

The Impact.

• Clear and dynamic visualisation of specific spend categories enabling deeper understanding of the operational cost of the workforce
  
• Quicker decision making on to establish steps for cost reduction and productivity improvements through better analysis efficiency
  
• Single version of truth in an automated and integrated workforce analytics system eliminating manual consolidation of data from seven unmaintained source systems