Menu

Juan ANDRES

LOVERVAL

En résumé

J'ai toujours travaillé avec des chiffres. Que ce soit en finance ou en marketing, analyser les chiffres les présenter et proposer des lignes d'actions ont été mes axes professionnel.
Ces analyses n'ont d'intérêt que dans la mesure ou elles conduisent à des décisions et à des résultats concrets.

Mes compétences :
Art
Art martiaux
Finance

Entreprises

  • QAT Investments SA - Analyste financier

    maintenant

  • QAT Investments - Analyste Financier

    2006 - maintenant Reporting to the CFO
    Design and update of financial reporting in the invested companies
    Design and update of KPI adapted to each company
    Automation of the existing reporting
    Cash Flow analysis
    Design of a Deal Flow Management database
    Design and update of an Investment database keeping track of each investment participation, contracts documentation, payments, history
    Financial controlling of some of the companies
    Ad Hoc analysis

  • GBC (ACCO group) - Controlleur de coûts Européen

    2002 - 2006 Reporting to the Finance Controller Europe Group.
    Assess dangers of the current calculation system and procedures related to costing
    Design new costing calculation model based on ABC costing
    Re-engineering of the purchasing control procedure (purchase order procedure)
    In cooperation with supply chain mgr assess supplier’s “value” leading to cost saving decision
    New product costing
    Implementation in the current system (AS400 Movex ERP program) of the new costing method
    Design of a simulation model aiming at the harmonization of the pricing strategy across Europe
    Ad-hoc analysis supporting sales dpt such as: price elasticity, price discount evolution, upgrade sales
    Control information quality from the suppliers (price wise)
    Currency exposure forecast supporting the hedging strategy
    Provide as an input the expected standard cost (per product) for next year plan

  • Eurofiber - Manager financier

    2000 - 2001 Reporting to the Managing Director of Fibercorp Connectivity Europe, and to the C.F.O.
    Finance: Elaboration of the budget (Capex, Opex) for each countries
    Reforecast of Capex throughout the year
    Business plan for investment in new cities
    Design and implementation of analytical costing (geographically based)
    Budget control (purchase control, approvals related to the capex)
    New pricing scheme (see pricing) ensuring financial return
    Pricing: Market Analysis of USA dark fiber pricing practices
    Design of new pricing schemes, innovating new payments possibilities
    Site connection / Operation & Maintenance pricing, design of a cost model
    Comparative pricing analysis dark fiber + Gigabit Ethernet vs Leased Lines
    Marketing: Based on POI (Points Of Interest) development of a demand model for dark fiber used for new cities
    This model identifies new business opportunities (new segments). It shows also the underlying players, resulting in a prospect list with the appropriate dark fiber solution ready to be proposed to each of them
    As it is based on the POI the results of this model are loops for particular segments (ready to sale documentation like maps) that can be customized fitting the targeted prospect
    Qualitative market analysis of the USA dark fiber market (see pricing)

  • GTS - Senior Business Analyst

    1999 - 2000 Working in the Business Strategy and Plans dpt, reporting to the Vice President.
    Being responsible of the Quarterly Sales Trend Analysis (in depth analysis of the sales per product, zones, cities, measuring revenues, volume, price erosion, customer churn, price elasticity)
    Working in the Business Strategy and Plans dpt, reporting to the Vice President.
    Being responsible of the Quarterly Sales Trend Analysis (in depth analysis of the sales per product, zones, cities, measuring revenues, volume, price erosion, customer churn, price elasticity)
    Developing and implementing Customer segmentation analysis, migration between segments. Backlog volume, revenue analysis and tying up with finance analysis
    Regularly updating the Historical evolution feeding forecasting model
    Design of a forecasting scenario generating model
    Geographical analysis leading to the implementation of local access city ring
    Profitability analysis, revenue opportunity analysis
    Repricing analysis, new product tracking, business case of new services launch, opportunity analysis (owning network versus peering it)
    Assessment , and design of the improvement process of the quality of the data in the database
    Design, and elaborate Market Intelligence databases (4 databases)
    Develop intranet search tools to query those databases on line
    Improve the current database (in mainframe). Link those database with other information sources . Streamline the process. Training user

  • FEDEX - Analyste Financier

    GENNEVILLIERS 1996 - 1999 Working in the Finance, Planning and Analysis Dpt; Team: Business Development
    Reporting to the Business Development Manager
    Being in charge of the daily profitability analysis per product, service or projects along with market and sales dimensions. Those analyses are leading to strategic decisions for the company concerning the whole European region.
    Creating an application designated to automate those analysis (Excel).
    Implementing the application and training the sales force in Europe and upgrading the application for the Middle East region.
    Implementing this new approach resulting in the creation of new combination of pricing.
    Re-engineering the database for the Profit and Loss analysis on line.
    Assisting in the Budget establishment
    Setting up new costs drivers for the ABC (Activity Based Costing)

Formations

  • Université Catholique De Louvain (Louvain La Neuve)

    Louvain La Neuve 1992 - 1996 Sciences économique apppliquées (marketing, finance)

Réseau

Annuaire des membres :