Sofiene Mechken

Sofiene Mechken

Trainee

Followers of Sofiene Mechken3000 followers
location of Sofiene MechkenTunis, Tunisia

Connect with Sofiene Mechken to Send Message

Connect

Connect with Sofiene Mechken to Send Message

Connect
  • Timeline

  • About me

    Business Expert 📊 Power BI Data Analyst 📉 Groups Business Manager 📈 Corporate Credit Risk Analyst

  • Education

    • Higher Institute of Management of Tunis

      2013 - 2016
      Professional Master in Finance and Insurance Ingénierie Financière
    • Higher Institute of Management of Tunis

      2010 - 2013
      Three-year university degree in Currency, Finance and Banking
  • Experience

    • Banque Nationale Agricole (BNA)

      Jul 2011 - Jul 2011
      Trainee

      Front Office operations

    • Banque Internationale Arabe de Tunisie (BIAT)

      Aug 2012 - Aug 2012
      Trainee

      Front Office operations

    • Banque Nationale Agricole (BNA)

      Feb 2013 - Apr 2013
      Trainee

      Front Office and Back Office operations

    • BM Etude & Consulting

      May 2013 - May 2013
      Training in Data Analysis "SPSS Statistics Software"

      Data analysisDescriptive analysisBivariate and multivariate analysisLinear and non-linear regression

    • Capitol Academy

      Sept 2013 - Sept 2013
      Training in Technical Analysis and Chartism "Trading the stock exchange like a pro"

      Candle SticksTrendsMoving AverageBollinger BandsPatternsFinancial Ratios

    • Attijari Bank

      Feb 2015 - May 2015
      Trainee

      Department : Global Risk Management.Analysis of credit granting processes.Credit risk assessment.Development of a scoring model for credit risk management granted by Attijari Bank to very small companies.

    • Attijari Bank

      Feb 2016 - Apr 2016
      Trainee

      Department : Back Office Trading Room.Development of an option pricing model for exchange risk management at Attijari Bank.

    • BANQUE DE TUNISIE

      Jul 2016 - Aug 2023

      Business Market DepartmentMiddle Office - Groups Groups & Large Corporates

      • Groups Business Manager

        Apr 2023 - Aug 2023
      • Corporate Credit Risk Analyst

        Jul 2016 - Mar 2023
    • GIZ

      Dec 2018 - Feb 2019
      Training on The Financing of Renewable Energy Projects in Tunisia

      Training conducted by GIZ Tunisia in partnership with ANME and APTBEF which includes :- Overview of the Tunisian renewable energy market and the financial resources available for RE projects.- Control of the financial and legal structuring of RE projects and analysis of the contractual, administrative and technical risks of these projects.- Analysis of the different risk groups for the financing of RE projects and their coverages.- Control of the main financial parameters and ratios of the financing of RE projects as well as the stages of development and the main actors and contracts of these projects.- Economic and financial modeling of RE projects : photovoltaic self-consumption, non-recourse photovoltaic and non-recourse wind energy. Show less

    • Compétences Plus

      Sept 2020 - Sept 2020
      Advanced Excel Cycle Training : From Basic Functions to Pivot Tables

      - Formatting tables.- Styles.- Plan levels.- Use of models.- Lists (Databases).- Pivot Tables.- Use of functions.- Double entry tables.- Target values and scenarios.- Optimization tool: Solver.- Macro-commands.

    • Institut de Formation de la Bourse de Tunis

      May 2021 - Jul 2021
      Corporate Finance Training

      - Quantitative methods applied to corporate finance.- Financial statements analysis.- Capital structure.- Firm valuation.- Corporate transactions.- Tunisian stock market and financial regulations.► This training offers preparation for the exam of the international certification "Certificate in Corporate Finance" awarded by the CHARTERED INSTITUTE FOR SECURITIES & INVESTMENT "CISI".

    • GOMYCODE

      Mar 2022 - Jun 2022
      Business Intelligence « BI » Training

      - Describe a decision-making process.- Define Business Intelligence « BI ».- Define a data warehouse.- Differentiate between a data warehouse and a production database.- List the different conceptual models of a data warehouse.- Identify Key Performance Indicators « KPI »- Design, implement and model a data warehouse.- Learn about SQL Server tools for BI (SSIS SSAS SSRS).- Master SQL On-Line Analytical Processing « OLAP » queries.- Analyze and visualize data.- Become a Junior Business Intelligence Consultant. Show less

    • Orange Digital Center

      Jul 2022 - Jul 2022
      Power BI Training

      - Overall presentation and getting started with Power BI Desktop.- Data extraction and transformation.- Data modeling.- Data enrichment with the DAX language.- Data visualization.- Creation of reports and dashboards.- Publish and share reports with Power BI Service.

    • TUNISIA SKILLS TRAINING INSTITUTE

      Sept 2022 - Sept 2022
      Power BI Data Analyst Training

      - Identify and retrieve data from data sources and understand different connection methods.- Optimize query performance.- Profile and examine data and apply data shape transformations.- Develop a scalable and efficient data model.- Enhance the data model with DAX using measures, calculated columns, and tables.- Design and create reports and dashboards.- Select and add the appropriate visualizations.- Perform advanced analytics.- Create and manage workspaces.- Manage datasets and updating datasets.- Enforce row-level security. Show less

    • TUNISIA SKILLS TRAINING INSTITUTE 🇹🇳

      Mar 2023 - Mar 2023
      Artificial Intelligence and Programming with Python Training

      - Introduction to the basics of programming and algorithms with Python.- Learn data and control structures, exceptions, functions and files as well as modules and packages.- Creation of programs and projects with Python.- Using strings, lists, dictionaries and tuples.- Preparation for the PCEP certification: Certified Entry-Level Python Programmer.- Exploration of the different learning algorithms applied to data with Python for the creation of Big Data and Artificial Intelligence solutions.- Understand the key concepts of Machine Learning, its different areas of specialization and the various issues using Python.- Construction of predictive models, production and performance evaluation of these models. Show less

    • TUNAPS

      Mar 2023 - Apr 2023
      SAP FI Training

      - SAP.- FI-GL General Ledger.- FI-AP Accounts Payable.- FI-AR Accounts Receivable.- FI-AA Asset Accounting.- FI-BL Bank Accounting.- Closing in Financial Accounting FI.

    • BFI Groupe

      Sept 2023 - now
      Business Expert
  • Licenses & Certifications

    • Maîtriser l'Analyse de Données avec Power BI

      LinkedIn
      Jan 2023
      View certificate certificate
    • Se préparer au Métier d’Analyste de Données par Microsoft et LinkedIn

      Microsoft
      Feb 2023
      View certificate certificate
    • Se préparer au métier de business analyst par Microsoft et LinkedIn

      Microsoft
      Aug 2023
      View certificate certificate