The initial programme for the PCMS (probation case management system) was the transforming rehabilitation. The requirements for this was to design, develop and implement a reporting solution that the probation officers can use to identify the criminals and whether they may pose a risk.

This was an important solution to deliver as it ensured the safety of probation officers and therefore had to be accurate.

The initial 2 deliveries for this solution were delivered using the traditional (waterfall) approach, both the Tranforming Rehabilitation and the Transition Stage 2.

I was the Universe designer which is the semantic layer which separates the technical resource from the business user, I also designed and built reports within the front-end business intelligence solution.

There were multiple teams, including management, testing, development etc. At the time the team consisted of a DBA, 4 ETL developers and a BI developer. I was the BI developer within this team.

The second phase of the PCMS (probation case management system) was known as future enhancements. It was a further backlog of requirements from users to enhance the offender case management system and its reporting capabilities. 

This was a Scrum Agile delivery when it was a niche methodology that wasn't as widely adopted as it is today. This was before there were technologies to aid in following the principles.

Engaged in the full lifecycle as a Scrum Team member, including testing activities.

Served as the Scrum Master, overseeing the product backlog and facilitating daily stand-ups 

As this was a scrum delivery the team layout was very different, the team consisted of 8 members that were versatile in skillset and able to carry out both development and testing activities throughout a sprint/increment.

The third phase of the PCMS (probation case management system) was known as SPG Portal Changes. It was a further backlog of requirements from users to enhance the offender case management system and its reporting capabilities due to the introduction of an SPG Portal and therefore were able to exploit these items within the reporting layer to enrich analyses. 

This was also delivered using the Scrum Agile methodology

Led a Scrum agile delivery lifecycle for implementing SAP BI/Business Objects Universe and reporting changes on an Oracle database.

Universe designs with SAP Business Objects, creating a dimensional model (Kimball) for performant adhoc reporting.

Made ETL changes using SAP Data Services to exploit data items to the reporting layer.

Data was stored on an Oracle Database.