Seng SOUKANHGNA

Project: Strategic Studies over transformations in the Corporate & Finance Domain ● Proposal for Target Architectures around a Data Lakehouse: o Development of target scenarios for Analytics including financial reporting and data (Power BI Service / Tableau Software) from on-premises data (hybrid). o Design of target scenarios for Digital Marketing. o Choice Vendor: Salesforce / CRM Dynamics. o Design of target scenarios for the reengineering of the Human Resources solution via LDAP and cloud solutions. o Construction of target scenarios for Finance (Fees Management). ● Support for the Data Vision Towards a MESH Architecture with Integration via Medallion Layers. ● Implementation of Data Governance (RACI governance & data quality & security) for the on-premises & cloud Lakehouse. Environment: Data architecture, data Lakehouse, AWS S3, Azure Fabric, Power BI Service, Tableau, Salesforce, CRM Dynamics, Trino, S3 Delta Lakehouse, API-ization.

Project: Enterprise data model, data modelling (EDM), MDM sourcing • Scoping business objects across enterprise domains such as procurement, customers, risk security, HR, accounting …(organisation & cardinality) • Study of inter-domain processes and business rules (governance & responsibilities) • Providing stabilized data model and consistent concept dictionary (business objects) • Considering ESG, AI ACT, GDPR, operational risks compliancy requirements • Aligning knowledge and approach with architecture group committee (model archimat) Environment: EDM, data architecture, uml, archimat, visio, anaplan, excel.

Context : German Titan Program, change of ownership (CoC), HTDE (HSBC Trinkaus & Burkhardt GmbH) new branch under HBCE (EU head office) supervision Project: Tactical solution to report in response to BCE credit risk obligation (Calculation of past due days on material credit obligations / Regulation (EU) No 575/2013 (CRR)) ● Impact assessment linked to Titan Program (due to German data centralisation phase pushed back) ● HUB and Complementary sources identification, data mapping, data calculation (SQL) ● Definition of IT processes ( from SAS to Datastage) to create new risk report including HTDE German data branch ● Design of solution to report Days past dues (dpd counter) with consolidated data at HBCE (HSBC Continental Europe) group level

Project: Cloud strategies for financial and liquidity risks. ● Data modeling for the redesign of the refinancing domain (funding + securitizations) ● Coordination of the application/business data dictionary project (DQLink / ABinitio) on TSR side (Treasury) ● Participation in architecture committees (DA & ARB), hybrid on premise/cloud Aws and Azure strategy ● Group valuation, assessment of assets and risks at group level, EBA compliance ● Participation in data questionnaire for projects

Project: IFRS17 project, implementation of reporting solution, flows and data, RISK INTEGRITY. ● Conception of functional and technical flows (transformation to shared ETL) + API call to Azure ● Coordination and implementation of the technical flow infrastructure (hub transit for 60 countries/entities) ● Study of the integration and middleware towards Risk Integrity (Moody's SAS + Azure storage) ● Design of flows, actuarial models BBA/VFA/PAA, supporting files, referential data, nomenclature ● Very good command of written and spoken English

Project: Study of new business needs and integration of new customers. ● Drafting of detailed functional specifications, establishment of pivot file ● Data sourcing, analysis of data to be integrate, Mastery of SQL and PL/SQL ● Coordination of developments by the team in Bucharest (agile kanban) ● Live Production support : functional support, data extraction, ticket analysis, configuration ● Very good command of written and spoken English

Project: launch anacredit reporting on due time by 31th of October Writing of delivery validation report, using Excel for validating data from audit trail and DB sources Design the workflows processing and business data mapping in cooperation with Key users functions Qualification of the TRT Moody’s solution for declaring to OneGate (ACPR platform) Conduct tests in Jira KANBAN on daily meeting and provide reports on progress Re-writing specifications to be aligned with the BCE regulatory requirements Analyse sources and referential from multiple back offices and audit trails Compares results and checks controls from (submissions/feedbacks BDF) Check process in and out from TRT to OneGate Banking platform Environment: TRT Moody's, excel, Jira, SQL, Cloud SAS, Retails, credit risks and counterparts, scoring and defaulting, Staging, RWA…

Context: Context multi-regional with branches and subsidiaries in Europe and the global IT modernisation of the core banking system SAB and Ring Fencing rules (Earth and Moon project) BREXIT: Scope of functional and operational risk impacts on operating systems in Wholesale Credit Risk (WCR) Anticipating regional solutions related to BREXIT based upon business gap analysis between UK core banking financial services and products to be migrated into HBFR systems ANACREDIT: Analysing data sourcing and data quality improvement regards to the ANACREDIT credit risk framework Making a clear choice vendor, designing architecture solution plan (DAR) from regional sources Conduct business analysis in consistence with the Brexit gap analysis Coordination: Leading workshop and reporting to the Group in English, road map and planning proposal Follow-up meeting and minute report for HBFR committee, Adjust with interlockings and inter-dependencies on discussion with architecture department Cloud capacity planning, security assessment and infrastructure standards Environment: Erwin, AXIOM SL v10, ORACLE 11,12G, CLARITY, Datastage, PL-SQL, JIRA, RHEL, Tomcat, shell, java, AxiomSL anacredit, workbench project/Gantt, cloud capacity planning

Project : Migration of lease management solution (commissioner or contributor as bespoke solution) Functional and technical coordination. (Cap Gemini and Cassiopae) Provide main coordination with the function’s requirements Responsible for delivering and supervising software quality (CASSIOPAE ERP) Functional validation: sql review, specifications review, batches testing, settings up parameters, actors and contracts synchronizing, test case and non-regression test Ensure delivering in agile process mode and good quality Driving technical and homologation committee, test and integration Ensure of the package’s deployment, implementing roadmaps to production team Coordination of infrastructure changes, front/back office preparation tasks Writing procedures and guidelines to live production, steering committee reports Environment : CASSIOPAE v4.5, ORACLE 11,12G, CLARITY, EXADATA, Linux, Jboss v6.4, Tomcat,App-Dynamics, HP-ALM, CONTROLM v8, shell, PowerShell, java, python, PL-SQL ,VisualVM, Jira, jenkins,git,svn,xldeploy,etc.

Context: MarkitWire Third level user’s assistance (UK-NY-HK-JP) for CACIB account within the derivative rates activity perimeter Project: Migration of front/middle office activities from Summit FT to Orchestrade platform. Functional support for middle front office activities in market rates and derivatives Production support in market data provisioning and grid calculation, flows Production support for risk management (users help, sensitives, PNL, Var) Production 3rd level support for overnight batching (controlM, log analysis, and recovery Scripting for daily reports in PowerShell and sql filtering Environment: Summit FT 5.4, Orchestrade, ControlM 8, CFT, Windows 2008, Unix Solaris, Sybase 15, citrix, shell, PowerShell, excel, etc

Sepa knowledge, Summit FT, Risk Authority, Fermat ALM Context: Emir prudential regulation rules application Migration to FERMAT ALM SEPA normalisation for payment exchange Project team portfolio: Migration Fermat 9 to Risk Authority (Misys Moody’s Software) MOA support, BALE II compliance, authority reporting COREP, FINREP, LCR, NSFR Stress testing (imputation via Datastage ETL, data quality check, ratios producing, XBRL report) Migration of Summit FTv5.3 to v5.6 (upgrade core + sparse + DB) Migration from SAP ALM to Fermat ALM 10.12 (Risk Confidence) Daily tasks SEPA French normalisation of transactions, SepaFActory (CSC), Payment Factory and MandatWay Coordination between Business and Operations, checkpoints reviews Support testing and data qualification (stress testing, audit log…) Integration of Risk Authority (Task servers implementing, EAI web services and FAS security connection Integrating ETL flows, batches and data consolidation (accounting back office) Sepa bulk checking (SCT, SDD) inter banking validation Environment: Payment Factory et MandatWay( Sepa Factory / CSC ), Risk Authority, Fermat 9-10, ALM Fermat 10.12,SUMMIT v5.6, Windows 7, HP (Mercury) (Quality Centre), access, excel, oracle9-10-11G, Sybase 15, datastage, 8.1/8.7, QlickView, Apache , Tomcat 7, WebSphere 8-7 , ControlM 7,VMWare SQL, PERT,GRANTT