When a multinational banking and financial services corporation needed a team to work on an enterprise level data warehousing project, PSCI delivered.
A multinational banking and financial services corporation enlisted the services of PSCI to put together a team of six IT professionals, funded out of one project budget, to work on an Enterprise Level Data Warehousing project.
The team consisted of 2 ETL Developers, 2 BI Front-End Developers, 1 Business Analyst, and 1 Quality Assurance Tester.
The team was tasked with developing an end-to-end web-based mortgage reporting metrics platform within an Agile framework.
The project’s Senior Management wanted to know “exactly” how long it was taking each individual mortgage loan from being “initiated”, i.e., application process, to being “funded”.
The project was cross departmental and involved the development of Business and Functional Requirements, Database Mapping (ETL), SQL coding and Front-End BI Reports via an Agile Team.
The team was fully integrated into mortgage operations by the product owners and learned the entire cycle of a mortgage loan including key milestones (Application, Underwriting Decisioning, and Funding). The team practiced the following Agile process on a regular basis: Grooming Epics/Stories in Version 1 > Backlog Prioritization > Sprint Planning > Commitment of Work in a defined Sprint > 21-Day Development Cycle (coding and testing) > End of Sprint Rollout > Demo for the clients. Also, within the Agile process, the team met daily for a Scrum Meeting, sat together, and escalated any issues when needed.
The team was able to deliver the reporting platform and engine ahead of schedule, which allowed the organization to meet key deliverables established by senior management.
The team was successfully able to show, via a BI Reporting Dashboard, the journey of individual loans or groupings of them, while also supplying reporting filters, output preferences, and sub-results querying.