Société Générale Corporate and Investment Banking
How did a large French Financial Services & Investment Banking firm get security into their highly confidential human resource data?
SG Corporate & Investment Banking
SG CIB is the Corporate and Investment Banking arm of the Société Générale Group. Present in over 45 countries across Europe, the Americas and Asia, SG CIB is a bank of reference in:
- Euro Capital Markets: A top ten player in debt and equity segments (bonds, securitisations, syndicated loans, equity-linked and equity issues).
- Derivatives: Among the world leaders in equity derivatives and in many interest rate, credit, foreign exchange and commodities derivatives.
- Structured Finance: A worldwide leader in export, project and structured commodity finance.
- Combining innovation and quality of execution, SG CIB provides corporates, financial institutions and investors with value-added integrated financial solutions.
Background – The Risk
They considered the risk of having personal confidential information in the wrong hands. What would happen if an unauthorized employee got their hands on confidential data?
The confidential nature of SGCIB’s human resource data and the highly distributed nature of their organization required a sophisticated security implementation that was highly reliable and accurate.
SGCIB has hundreds Cognos users who required access to eight Human Resource cubes and a family of drillthrough reports.
The Challenge
The business situation required that FirstQuarter address the following business and technical issues.
Business Issues
- Addressing SGCIB’s multi-project concerns was critical to this initiative. Their Cognos implementation would grow significantly after the initial deployment phase. Each project would require a flexible means for implementing complex security.
- Omitting key dimensions/measures based upon whether a user was in a confidential or non-confidential role.
- Building a flexible means to create security groups for a highly matrixed organization.
- Incorporating multi-level organization and geographic hierarchies into a single security scheme.
Technical Issues
-
Generating all security needs from one security application.
Streamlining the process for creating memberships
Coordinating and refreshing security nightly in the cubes, database, and access manager
Providing seamless drillthrough to impromptu web reports
Securing both primary and alternate drilldowns
The Solution
SG Corporate & Investment Banking purchased ProTools to address their security needs. They chose ProTools because the utility provided a rich feature set that addressed complex security challenges that would grow through time.
FirstQuarter addressed each of the project challenges using a combination of software and consulting services. The project was completed successfully with several weeks of consulting.
FirstQuarter used a combination of on-site and off-site resources to complete the engagement’s ongoing support FirstQuarter continues supporting SGCIB implementation as it expands beyond the initial phase. All support is provided remotely and has worked well using teleconference and web technologies.
The Impact
SG Corporate & Investment Banking now has an industrial strength solution that provides authorized access to highly confidential human resource information. With ProTools they have a scalable and repeatable solution that was achieved with ProTools plus a few weeks of consulting. By purchasing ProTools SGCIB was able to resolve the data security risk and direct their energies to other more pressing concerns.