Montse Carrillo

Experience

• 

  MediaMarktSaturn

  Jan 2003 - Jan 2012

  - Calculation, analysis and control of supplier funding and special campaigns- Profitability analysis and reporting by product range, geographical area and supplier- Data extraction and manipulation from different sources (SAP, Business Objects, Access, Excel) - Calculation and analysis of income accruals- Calculation of income and payment forecast- P&L analysis- Monitoring and control on debit balance suppliers- Ad hoc reports created for the Financial Management- Liaison with internal and external auditors Λιγότερα

  • Purchase Controller and Data Analyst

    Jan 2007 - Jan 2012

  • Supplier Reconciliations Manager

    Jan 2006 - Jan 2007

  • Accountant

    Jan 2003 - Jan 2006
• 

  JATO Dynamics

  Jan 2013 - Jan 2019

  - Direct management of 7 FTEs based in 4 countries, which includes recruiting, induction, training and coaching, being responsible of the research process and data integrity.- Workflow planning, allocating the team resources as needed to deliver the data according to the plan and SLA.- Data pipeline management, being the team representative with internal suppliers (Data Acquisition and Extraction Team) and internal customers to forecast the new incoming feeds and outgoing needs.- Acting as SME (Subject Matter Expert); being the representative of the Dealer Data Research area; providing support to other internal and external customers.- Assessment, validation and integration of new raw data feeds in the database (SSMS).- Database development and maintenance (T-SQL), writing the procedures to load, cleanand translate data, increasing the automation and reducing the manual research.- Ensure the completeness of the data resulting of the research process, monitoring thealignment with the KPIs.- QA, development and implementation of the quality process, creating queries andautomated reports to ensure the data accuracy.- Development and implementation of report dashboards and metrics; creating weekly andbespoke report for the senior management. Λιγότερα - Design, develop, maintain and improve the DB to ensure it supports the needs while being reliable and efficient to process large amounts of data.- Write complex stored procedures to load, clean and transform the raw data, using algorithms to match and translate instances with minimal human intervention.- Provide SQL support to the researchers, with emphasis in finding new ways to improve automation.- Review and understand the team requirements and assess them from a technical perspective to decide viability and development priority.- Workflow planning and backlog coordination.- Provide technical oversight and support to the Research team to ensure consistent qualitydelivery.- Provide scheduled and bespoke management reporting. Λιγότερα - Research and analysis of incentives for cars and light commercial vehicles- Analysis of take up rates at model level and incentive type- Quality control of the data produced- Analysis and reporting of completeness data and performance reports for other teams- Ad hoc reports to line managers as required- Regular attendance to customer meetings, providing analysis results presentations tailored to customer requirements- Market insight reporting – market general trends and outlook Λιγότερα

  • Data Research Manager

    Jan 2018 - Jan 2019

  • Data Developer (SQL)

    Jan 2015 - Jan 2018

  • Marketing Research Analyst

    Jan 2013 - Jan 2015
• 

  JATO Dynamics-North America

  Jan 2020 - Jan 2023

  Data Project Lead
• 

  JATO Dynamics

  Jan 2023 - now

  • Global Process Owner Finance Data

    Jan 2024 - now

  • Process Specialist

    Jan 2023 - Jan 2024