Mohamed KONATE

• IT Client Reporting – Coric Workflow analysis: Worked for 1 month on the analysis of Coric workflow to propose improvements for Candriam reporting system. – Collect needs from manager and business. – Coric workflow analysis. – Validated data workflow from BONE to Datamart analysis. – Incidents and azure ticket analysis. – Drafting of proposals for the Coric workflow improvements. • IT Business & Application Support - Data Performance & Reporting - IT Data & Analytics I Integrated IT Bas team (4 members), providing first line support on CEDRE (Cleansing, DWH, Datamarts databases and CUBE), coordinating source data (Infocentre, DOOM, BONE, CRD, CACEIS, FUSION...) integration, Power BI and CORIC reporting support. From October 2023, focused on IT Data, performance and Reporting (IT DPR) or IT Data & Analytics. • Data Quality Management and Business Analysis – Responsible for the proper execution of all CEDRE process/applications (daily, weekly and monthly). – Analysis and Relaunch of applications/jobs in case of errors. – Informatica process and workflow monitoring. – Informatica workflow error analysis in Informatica administrator. – Informatica services recycle (Data Integration Services...) in Informatica administrator. – Monitoring secure group and secure agent in Informatica cloud. – First point of contact (SPOC) between IT Bas and different stakeholders (Reporting team, Front office, Middle office and others IT teams). – Assist reporting officers in their investigations. – CEDRE database (Cleansing, DWH and DataMart (DM FO, DM CR)) management using SQL programming language in Microsoft SQL Server Management Studio (MSSM). – Analysis of data rejection during integration into CEDRE. – CEDRE Datamining. – CEDRE data lineage. – Financial data (Transactions, breakdowns, performances, positions, Nav...) analysis using B-ONE(FactSet) and databases. – Analyze/investigate on data qualities issues. – Analyze/investigate on issues and in case of changes, enhancement or evolution, asked developer to make necessary changes. – Analysis and resolution of intraday business problems. – Reading stored procedures in order to detect any issue on day to day activities. – Ensure the good data quality of financial and non-financial data before integration on cleansing, DWH and DataMart and also after reporting. – Financial and extra-financial data management in Microsoft SQL Server Management Studio. – Feed the developer with requirements from the business. • Support (BAU) on Simcorp CORIC reporting tool – Fund and Mandate analysis using Coric report via Production Control or Layout Builder. – Financial reports analysis (transactions, breakdowns, performances, positions...) using Production Control or Layout Builder or Data Mapper. – Financial reports analysis (transactions, breakdowns, performances, positions...) using store Procedure. – Coric Store procedures analysis in order to improve or resolve day to day reporting issue. • IT Client Reporting Since June 2024, I re-integrated IT Client Reporting team composed of 5 members composed of Project manager, Business Analysts and developers. The main objective of IT Client Reporting at Candriam is to produce reports (client reporting, factsheets and all others reports), be the first line of support on reportings subjects with Power BI and also CORIC reporting. We also were in charge to design and develop NEXTGEN architecture for CORIC reporting. So, I was in charge to : ----NextGen project : - Participate on new reporting architecture (NEXTGEN) definition - Specification of new tables. - Read existing Stored Procedures (SP) and specification of NextGen SPs based on new architecture. - Participate on workshops define needs. - Data quality testing and management - Bugs identifications and creation - Define test plan, test case and test scenario in order to test developments -----Support (BAU) and daily tasks : - Ensure data integration in reporting DataMart - Assist reporting officers in their investigations - Analysis and resolution of day to day business issues - Database (DataMart) management using SQL programming language in Microsoft SQL Server Management Studio (MSSM) - Coric report production - Coric reporting support - Datamining - Data lineage - Financial data (Transactions, breakdowns, performances, positions, Nav…) analysis using B-ONE(FactSet) and databases. - Analyze/investigate on data qualities issues - Analyze/investigate on issues and in case of changes, enhancement or evolution, asked developer to make necessary changes. - Reading stored procedures in order to detect any issue on day to day activities. - Feed the developer with requirements from the business. - Implementation of test plan, test scenarios and test cases. - Perform tests on developments carried out by developers and document the findings. - Locate and define new process improvement opportunities.

I joined IT Reporting Solutions (ex IT Client and Regulatory Reporting) team of more than 13 members composed of Project managers, Business Analyst and developers as a Business Analyst. Within BNP Paribas Asset Management (BNPP AM), The IT Reporting Solutions department manages all IT developments on Reporting towards BNP Paribas AM's clients and regulators around the world, including the internal self-service BI solution: - Producing reporting data (transactions, positions, performance, etc.) - Institutional, private, regulatory and fund reports. - Data publication and diffusion. - Managing DataMart (DMIR) database and others IT Reporting Solutions is one of the central department within BNPP AM. As a Business Analyst, I am in charge of: • Data Management and Business Analysis – First point of contact (SPOC) between IT Reporting Solutions team and various business reporting teams globally (Belgium, France, UK, Luxembourg, Italy, Netherland, USA, India, Indonesia, Hong Kong), BNP PAM Middle Offices, BNPP AM Front Office, other IT departments and external partners (Simcorp, Blackrock...). – Reading stored procedures to detect issues or understand/explain them. – Modification or update ESG, Transaction, Position Stores Procedures (SP). – Reporting database (Datamart) management using SQL programming language in Interactive SQL and Aqua Data Studio tools. – Ensuring good data quality of financial and non-financial data before and after reporting. – Financial and extra-financial data management in Sybase (Interactive SQL) and Aqua Data Studio tools. – Financial reporting process and production knowledge and improvement. – Ensuring proper execution of daily and monthly process/applications. – Feeding developers with requirements from the business. – Implementation of test plan, test scenarios and test cases. – Performing tests of scripts developed by IT and documenting findings. – Performing tests of APIs developed by developers and analyzing results. – Locating and defining new process improvement opportunities. – Training colleagues. • Support on Power BI – Management of BNPP AM PBI reports. – Relaunching reports in case of errors. – Management of report subscriptions. – Scheduling reports. – Updating reports in Report Builder. – Following up automated sending reports - deblocking when needed. • Support on Simcorp CORIC reporting tool – Management of monthly reporting data parameters, schedule and scope in docwarehouse. – Uploading reporting data parameters, schedules and acquiring in workflow via Docwarehouse. – Management of the reporting team. – Fund and Mandate analysis using Coric report via Production Control or Layout Builder. – Financial reports analysis (transactions, breakdowns, performances, positions...) using Production Control or Layout Builder. – Financial data analysis using Production Control or Layout Builder and Databases. – Management of Coric drone in Coric Control Panel (CCP). – Maintenance in Production control. – Following up automated sending reports - deblock when needed. • Creation of dashboard to track team performance using Excel formula and VBA. - Collect needs from managers. - Needs analysis. - Work with managers to define information to appear on the report. - Creation of the Excel formula. - Writing Excel VBA script. - Retrieve of incident data of IT Reporting Solutions from BNPP AM incident management toll. - Implementation of test plan, test scenarios and test cases. - Perform tests and document the findings. - Perform a handover of the usage of the tool to colleagues.

I worked on Athora Investment Office department. The mission consisted to improve and automate the reporting workflow (11/2019 – 01/2020), to create a tool (dashboard) which allowed reporting on Athora funds by using EXCEL, VBA and BLOOMBERG terminal (02/2020 – 03/2020). From 03/2020 to 05/2020, I worked as Business analyst and test coordinator with the team in charge of migrating SAS servers (application used by Risk, Non-life and Life teams) to the cloud. • Project 1: Reporting Process Automatization (11/2019 - 02/2020) – Work with management to prioritize business and information needs. – Locate and define new process improvement opportunities. – Acted as point of contact between investment office and IT department. – Supported report production (Regulus and QRT report). – Found, managed and used appropriate data sources to model and design reports. – Retrieved financial data using the Bloomberg terminal. – Performed financial data analysis. – Monitored daily processes. – Fed developers with business requirements. – Performed and documented tests of scripts developed by IT. – Implemented test plan, test scenarios and test cases. – Documented each step of development and performed handover of usage to business users. • Project 2: Creation of a dashboard to follow the evolution of the ATHORA fund and benchmark (03/2020 – 03/2020) – Collected business requirements. – Performed business requirements analysis. – Collaborated with business to define/set information (Performance, valuation, position, AUM...) for reports. – Created Excel formulas and formula. – Wrote Excel VBA scripts. – Retrieved financial data using the Bloomberg terminal. – Analyzed, created, and improved dashboard tool using VBA. – Performed financial data and information analysis using Bloomberg terminal. – Monitored daily processes. – Implemented test plan, test scenarios and test cases. – Performed and documented tests. – Performed handover of the usage of the tool to business users. – Drafted detailed user guide. • Project 3: Migration of SAS physical servers to the cloud (03/2020 – 05/2020) – Collected business requirements. – Performed business requirements analysis. – Collaborated with Life, Non-life and Risk department to define main testing areas. – Implemented test plan. – Implemented test scenarios and test cases. – Assisted business departments (Life, Non-life and Risk) in test execution. – Managed faults/bugs with external service provider during migration. – Coordinated tests with business teams (Risk, Life and Non-Life). – Performed handover of cloud server usage to business users.

I started this mission with a final internship which then turned into an open-ended contract. During this mission I was able to deepen my knowledge of the financial market, in IT and i discovered the sector of asset management in all its facets. I worked with 2 different teams as Business Analyst / Investment Portfolio and Performance Analyst: - IT Data Management & Client Reporting (located at Brussels) - IT Instrument Referential & Market Data (located at Paris) • Investment Portfolio and Performance Analyst: – Analyzed Private and Institutional Portfolios using PMS Triple'A. – Performed financial reports analysis (transactions, performances, positions...) using PMS Triple'A (AAA). – Performed financial data analysis using PMS Triple'A (AAA) and Databases. – Managed Mass Reporting Production, monitoring, analysis (transaction, performance, position...) and support. – Covered various report types: Money Market, Institutional, Private (CANDRIAM clients and BELFIUS clients), Belfius closure, Factsheet, Private Banking Web Site (PBWS), GIPS. • Data Quality Management and Business Analysis – Ensured good data quality (transactions, positions, valuations, market, referential data...) before and after reporting. – Managed financial and extra-financial data in Oracle for TOAD database, Sybase and SQL Developer. – Managed reporting databases using SQL programming language. – Improved financial reporting processes and production knowledge. – Ensured proper execution of daily process/applications for both departments (IT Data Management & Client Reporting (Brussels) and IT Instrument Referential & Market Data (Paris)). – Managed Master Price, Master Index, Sec Master, Money market, Private Banking Web Site (PBWS), Reporting portal, App Belfius, daily checks. – Acted as point of contact (SPOC) between IT Data Management & Client Reporting team and Business (reporting and performance attribution), CANDRIAM Middle Office, CANDRIAM Front Office, other IT departments and external partners (Belfius, IBM, IS4F...). – Fed developers with business requirements. – Modeled databases for migration from "Oracle for toad" to "sql developer". – Created schemas, tables, triggers during database migration. – Performed and documented tests of scripts developed by IT. – Implemented test plan, test scenarios and test cases. – Located and defined new process improvement opportunities. – Trained colleagues.

– Supported the manager in company management. – Performed analysis of economic and financial data. – Supported the manager in strategic decisions (with financial and economic data). – Managed data. – Managed administrative procedures. – Acted as SPOC. – Performed system maintenance.

– Performed customer management. – Managed client database. – Performed computer maintenance (installation of operating system, software ...). – Handled wiring. – Performed crimping. – Managed existing network.