Back to the listing
Imad T.

Business Analyst

830 dollar
Freelancer
11 years
Paris, FRANCE
Agile Business Analysis Data analysis SQL VBA

My experience

More

ING FRANCEJanuary 2020 - Present

Project: Standardization, pooling and homogenization of local data towards the new Group architecture (Project common to all ING entities) supported by the various local and regulatory initiatives.

FIELD OF INTERVENTION: Responsible for mappings of Credit data to the new model of the Group and support to DS for putting them under governance.

 Identification of business needs, Golden Sources and Gap Analysis

 Data Cooker monitoring of Data mapping with Data Steward and other stakeholders

 Writing of functional specifications

 Refinement of functional specifications with developers

 Data ingestion

 Data quality & remediation plan

 Support for IT teams (monitoring of developments and integration, data transfer, etc.)

 Testing

 Data governance.

Technical environment: IBM Esperanto, Oracle SQL, SAB, Informatica PC, Datastage, JIRA

Functional environment: Crédit Conso / Immo, KYC (FCRM), Assessment (FATCA, CRS, PEP, CDD), DGS (Deutch Deposit Guarantee Scheme)

More

AXA BANQUEMay 2018 - December 2019

Project: Implementation of a Financial DataWareHouse in order to generate regulatory and financial reports.


FIELD OF INTERVENTION: Creation of regulatory reporting ANACREDIT is SURFI for the Banque de France and the ECB.

 Scoping study: Identification of the scope of clients and subject instruments

 Construction of a data dictionary

 Determination of the different data sources and feed flows for the financial calculation and reporting tools.

 Data Quality: Adjustment of the PMO repository and reliability of entries

 CRT analysis and anomalies resolution

 Change management: new process for entering into customer relations to meet regulatory needs and drafting of related procedures.

Technical environment: SAB, Oracle SQL, Informatica PC, Moody's Risk Authority, JIRA, Collibra

Functional environment: ANACREDIT, SURFI

More

DEXIA CREDIT LOCALJuly 2014 - April 2018

Project: Creation of a group Data Office in response to BCBS239 regulation.

AREA OF INTERVENTION: Increase the reliability and production capacity of the bank's reports allowing better management of activities and thus facilitating top management decision-making.

 Framing and study of business needs

 Data mapping and creation of a data dictionary

 Data Governance

 Validation of functional specifications

 Test and recipe.

Project: Upgrades of Front to Back applications.

AREA OF INTERVENTION: Upgrade from SAB Corebanking to SAB-AT and mapping of new data meeting EMIR, MIFID, DFA banking regulations. (Collaboration with the various business teams, MOA, IT).

 Mapping of existing data and gap analysis

 Creation of new dedicated fields in the IS

 Tests and recipes

 Declaration of defects and follow-up until remedies

 Data Quality on Customer / Third Party databases: Implementation of a data control process: SIREN, SWIFT, LEI, addresses, EMIR-DFA classification, country risk.

 Training in new processes.

CUSTOMER & FINANCE DATA: Guarantee the quality of the data entered in the IS dedicated to financial communication and current activity.

 Static data:
 Repository: Weekly update of Government Bonds, Futures, CDS, monthly update of rates indexed to inflation (FR, GB, IT), spreads, financial calendars.
Basis of Regulations: Management of payment details (Swift / non-Swift, local or foreign, intermediated or not) on Derivatives, Collateral, Securities and FXMM scope.


 Dynamic data:
Market Data: use of flows from different providers (Reuters, Bloomberg) in order to carry out a certain number of checks making it possible to make the accuracy of the rates more reliable before dissemination to all the group's ISs.

Technical environment: Bloomberg, Reuters, BO, Access, SAB-AT, Openlink, Oracle, Smartco.

More

DEXIA CREDIT LOCALMarch 2013 - June 2014

Mission: Ensure the follow-up of OTC transactions initiated by the FO as well as the holding of positions on listed derivatives
AREA OF INTERVENTION: SWAP, FUTURES, 0PTIONS, FRA

 Control and validation of the booking of new operations and settlement (validation of STP and non-STP flows, ISS management, operational risk management (Cut off currencies)

 Position-keeping and reconciliation: Analysis, management and follow-up to resolve discrepancies between FO and BO,

 Monthly incident reporting

 Daily use of English.

Technical environment: Openlink, Bloomberg, Reuters, Intellimatch, Swift Alliance.

More

GROUPAMA ASSET MANAGEMENTDecember 2011 - February 2013

Project: Implementation of a securities and cash reconciliation software in order to secure official documents (accounting closings)

AREA OF INTERVENTION :

 Writing of expressions of need

 Participation in project committees

 Report writing

 Drafting of test plans, execution and validation of recipes

 Recipe VP

 Change management.

Business Support

 Configuration of the accounting tool, verification and monitoring of gateways,

 Position control,

 Monthly declaration of assets held in portfolios at the Banque de France

 Support for the migration of Groupama AM funds from Omega FA software to GP3: 3,000 funds.

Technical environment: Omega FA, Stematch, Excel, VBA, GP3.

More

SGCIB – SOCIETE GENERALEJanuary 2011 - October 2011

Mission: Control of the concordance of counterparty confirmations Vs Internal Booking on Swap, Options, Futures, FRA

AREA OF INTERVENTION:

 Pairing / Matching: control of the compliance of counterparty confirmations (average of 60 confirmations / day)

 Chasing: Discrepancies escalation, Counterparty reminder

 Training of new employees & improvement of operational processes.

 Daily use of English.

Technical environment: X-One, Scirocco.

More

HSBC GLOBAL ASSET MANAGEMENTJune 2010 - December 2010

FIELD OF INTERVENTION: MONITORING OF STOCK EXCHANGE OPERATIONS.

 Help with the validation of net asset values (NAV) by fund managers

 Analysis of valuation differences, placement of residual cash in the planned cut-offs.

 Monitoring and analysis of stock market transactions on the Money and Bond markets

 Validations of operations initiated by the OF,

 Settlements & Matching of positions

 Transmission of instructions to custodians and valuers

 Management of Settlement-Delivery Instructions (IRL-SSI)

 Regularization of suspense,

 Communication with the various internal interlocutors (managers, negotiators ...) and external (counterparties, brokers, accountants, custodians)

Technical environment: Markit Wire, DTCC

My stack

Databases

MS Access

Analysis methods and tools

JIRA, Agile

Languages

VBA, SQL, Swift

Other

Oracle SQL, SAB, EXCEL

Business Intelligence

Informatica, DataStage

Others

Bloomberg Open API, Business Analysis, V-Cycle, Data analysis

My education and trainings

MBA Finance Engineering Finance - ISC Paris2010 - 2010

Master in English Economics and Management - Sorbonne Nouvelle Paris III2009 - 2009

Economic and Social Sciences - Lycée Léonard de Vinci, Sai2003 - 2003