Client case for Sogecap
Datamarts Solvency 2
Location
Paris
Project's functional area
Modernization of the calculation engine and the evolution of data marts for Solvency II.
Technological environment
Unix, Informatica PowerCenter v9, Oracle 11g, Quality Center v9.2
Detailed description of the project
- Participation in user workshops
- Qualification of the specifications
- Writing of functional and technical specifications
- Modernization of Excel processing to provide input fils to the calculation engine
- Implementation of test and non-regression plans under Quality Center
- Tests, support and support for the recipe
- Scalable and corrective maintenance of the Datawarehouse
- Production monitoring in collaboration with the technical and functional teams (processing monitoring, incident corrections)
- Regulatory changes to be made on the Solvency 2 Datamart in the Datawarehouse area
- Perform unit and integration tests and keep domain documentation up to date
Drawbacks and key success
Objective: Modernize the calculation engine and optimize the data marts
Action: User workshop
Result: Datamart compliance to meet Solvency 2 regulatory constraints
Action: User workshop
Result: Datamart compliance to meet Solvency 2 regulatory constraints