Montse Carrillo Email & Phone Number

Spring, Tx, Us

Texas, United States

Spring, Texas, United States

Uxbridge, United Kingdom

- 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.

Uxbridge, United Kingdom

- 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.

Harrow, United Kingdom

- 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

Barcelona Y Alrededores, España

- 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

Barcelona Y Alrededores, España

- Implementation and development of the supplier reconciliations schedule, in coordination with the accountants owning the supplier information and relationship.- Design and development of the database and process to load and reconcile external and internal data.- Extracting and cleaning data from SAP FI to inject in the tailored database.- Develop and create KPI report on reconciliations status and issues.

Barcelona Y Alrededores, España

- Supervision and coordination to ensure accuracy and completeness of AP- Supervision of monthly payments.- Calculation and analysis of month and year end accruals.- Tax calculation and calculation and presentation of import and export declarations.