When a multinational banking and financial services corporation needed a team to work on an enterprise level data warehousing project, PSCI delivered.
Client: Multinational banking and financial services corporation
Engagement Type: Project-Based Team Deployment
Challenge
Our client needed a specialized IT team to develop an enterprise-level data warehousing solution for mortgage reporting metrics. Senior management wanted precise insight into how long it took each individual mortgage loan to move from application (“initiated”) to funding (“funded”) — a key metric for operational efficiency.
Solution
PSCI assembled a dedicated six-person IT team, funded under a single project budget:
-
2 ETL Developers
-
2 BI Front-End Developers
-
1 Business Analyst
-
1 Quality Assurance Tester
Working within an Agile framework, the team developed an end-to-end, web-based mortgage reporting platform. The project required cross-departmental collaboration to deliver:
-
Business and functional requirements
-
Database mapping (ETL) and SQL coding
-
Front-end BI reporting
Approach
The PSCI team was fully integrated into the client’s mortgage operations, gaining a deep understanding of the entire mortgage loan lifecycle — from Application to Underwriting Decisioning to Funding.
Using an Agile process, the team followed a 21-day sprint cycle that included:
-
Grooming Epics and Stories in VersionOne
-
Backlog prioritization
-
Sprint planning and commitment
-
Development and testing
-
End-of-sprint rollouts and client demos
Daily Scrum meetings and close collaboration ensured consistent communication and quick issue resolution.
Results
The team delivered the reporting platform and engine ahead of schedule, allowing our client to meet key executive deadlines.
The new BI reporting dashboard provided:
-
Complete visibility into loan lifecycles
-
Configurable filters and output preferences
-
On-demand querying and drill-down reporting
Outcome
PSCI’s solution enabled leadership to analyze and optimize every stage of the mortgage process, improving transparency, efficiency, and data-driven decision-making across the enterprise.
