You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Yapi Henri Joël OhoueuYH

Yapi Henri Joël Ohoueu

Statistician - VBA Developer

€700/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Yapi Henri Joël

With experience in data processing, analysis, and management, I assist companies, startups, freelancers, and individuals with their data collection, structuring, and utilization needs.
My goal: to transform your raw data into clear, reliable, and actionable information to facilitate your decision-making.

Rigorous and responsive, I also undertake tasks requiring good physical condition, such as inventories, surveys, or logistics operations related to field data management.

🧠 Key Skills:
• Design and automation of Excel reporting (formulas, macros, VBA)
• Creation and management of pivot tables
• Calculation and monitoring of Key Performance Indicators (KPIs)
• Descriptive statistical analysis and clear presentation of results
• Data analysis
• Data cleaning
• Data preparation
• Data transformation
• Data automation
• Reporting / Dashboards
• Data collection
• Data management
• Database management
• Data visualization
• Data modeling
• Physical inventory and data collection

📊 Tools Mastered:
Excel, VBA, Google Sheets, Formulas, Power BI (basic), statistical tools, databases (SQL basics).

🎯 What I Offer:
• Precise, reliable, and understandable deliverables
• A results-oriented and efficient approach
• Smooth collaboration, with clear communication and met deadlines
• High adaptability, both in the field and remotely
• Process optimization
• Data quality improvement
• Decision support
• Automated reporting
• Performance analysis
• Forecasting / Prediction
• Data-driven decision making

💬 My Work Philosophy:
Combining professionalism, rigor, and friendliness.
Every assignment is primarily a human collaboration — I invest myself fully.
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • Morgan Stanley
    Middle Office Multi Asset - Associate
    BANKING AND INSURANCE
    January 2024 - Today (2 years and 5 months)
    Paris, France
    Four main responsibilities are shaping the role exposed to a broad range of investment solutions, assets and stakeholders:
    1. Management of the Middle tasks of the Asset Management Company by interacting:
    - internally with Head of the Middle Office, Portfolio managers, Risk Manager and Legal Officer of the Company
    - externally with Administrators, Valuation Agents, Trustees, Transfert Agents, Counterparties and Custodians
    2. Trades activity:
    - reconciliation and validation of the trades booked by the Front Office (OTC/market). Trades are composed of multi asset (Equities, Fixed Income, Forex, Commodities) and derivatives (from vanilla option/swap to complex derivatives)
    - Instruction of the trades to the custodians (back office)
    - Monitoring trades settlement
    - Reconciliation of the funds positions booked in the Front Office Tool of the Company and the position booked within the custodian.
    - Accounting reconciliation between the Fund Net Asset Value computed by the Administrator and the Front Office Tool
    - Collateral Management
    3. Reporting activity:
    - Reporting of the Asset Management Company activity (Asset under Management, monitoring of the subscription/redemption, management and administrative fees) with VBA
    - Reporting production/validation (performance factsheet or bespoke reporting) with VBA
    4. Development and streamline of the middle office framework:
    - process definition and review
    - IT infrastructure (design assistance/testing/implementation).
    VBA Reporting Microsoft Excel Big Data
  • La Française Asset management
    Middle office Rates
    BANKING AND INSURANCE
    July 2021 - January 2024 (2 years and 6 months)
    Paris, France
    - Control of Net Asset Values (NAV) for funds and mandates: reconciliation of positions, consistency check of performance, fee control. Validation or rejection of NAV for each fund calculated by accountants.

    - Transaction accounting,
    - Reconciliation of securities and cash transactions in portfolios
    - Reconciliation of securities positions and cash balance of portfolios
    - Suspense management
    - Processing of margin calls related to positions held with counterparties
    - Processing of initial margin and variation margin with the clearing house.

    Cash management of a portfolio by buying/selling units of money market funds to cover the portfolio against an overdraft and against excess ratios of money market funds.

    - Management of foreign exchange operations on the assets and liabilities of portfolios: currency hedging for funds and mandates.

    - Processing of securities operations (sending instructions).

    - EMIR control on over-the-counter transactions.

    - Management of VBA requests for reporting models.

    - Automation of report processing and models used for sending fax instructions with VBA Excel.

    - Regular communication with front office, back office, custodians, data management team, internal control, counterparties, and accountants.
    VBA Reporting Data Analysis
  • Amundi
    Middle office Securities Operations Analyst
    BANKING AND INSURANCE
    January 2021 - July 2021 (6 months)
    Pantin, France
    - Processing of reconciliation operations for notifications sent by custodians and Reuters.

    - Reconciliation of securities and cash positions with those of the custodian and management.

    - Management of early and partial redemptions with or without nominal value reduction of bonds - Management of accounting movements (cash and securities) related to portfolios.

    - Payment of coupons (dividends / interest).

    - Analysis of market transactions initiated by the front office.

    - Reconciliation of securities and cash transactions on portfolios, management of suspense items via Excel VBA macros.

    - Establishment of an analysis and summary of operations for the relevant managers.

Recommendations

Be the first to recommend Yapi Henri Joël

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master in Money, Banking, Finance, and Insurance
    Paris 1 Panthéon Sorbonne University
    2020
    Master thesis: Explanation of assets return on the Ivorian Stock market: Empirical analysis with factorial model • Econometrics / Market finance / Corporate finance / Pricing option / Excel VBA / Financial analysis
  • Bachelor's Degree in Law, Economics, and Management
    Microeconomics / Macroeconomics / Statistics / International Trade /
    2017

Skill set

Categories