Stefano Rossetti Email & Phone Number

Barcelona, Ct, Es

Barcelona, Catalonia, Spain

Role Designation:*Senior Procurement Analyst, Source to Pay Department (50%)*Data Analyst, Intelligent Automation Team (50%):- Migration of reports from SQL Server to Databricks, ensuring seamless data transition and optimized performance for data analysis.- Creation of dashboards and reports for stakeholders using Power BI and Tableau, providing clear visualizations for data-driven decision-making.- Execution of ETL processes using SQL and Python, processing and transforming data for backend operations to ensure accurate and timely reporting in dashboards.- Execution of workflows to automate data export into visualizations, ensuring timely availability of reports and dashboards for business use.- Adherence to team methodologies and documentation processes, ensuring compliance with internal standards and best practices.- Collaboration with stakeholders to deliver tailored reporting solutions that meet business requirements, effectively presenting ideas and aligning data insights with organizational goals.

Barcelona, Catalonia, Spain

- Global Contract Analysis: Conducted in-depth analysis of procurement contracts on a global scale, identifying patterns and root causes for compliance and performance issues to enhance contract management.- Supplier Data Insights: Performed comprehensive data analysis of supplier usage and performance metrics, providing actionable insights to improve supplier efficiency and management.- Process Improvement: Analyzed procurement processes to identify inefficiencies and recommended improvements, contributing to the development and refinement of global procurement strategies.- Purchase Order Automation: Led the analysis for Purchase Order (PO) automation, identifying opportunities to streamline and automate PO processes, resulting in increased efficiency and accuracy.- Data-Driven Reporting: Generated detailed, data-driven reports on procurement activities and presented insights to senior management to support strategic decision-making and process optimization.- User Experience Enhancement: Applied data-driven strategies to enhance the user experience for purchasers, streamlining processes and improving the ease of procurement system use.- Cross-Functional Collaboration: Collaborated with global teams to integrate data analysis findings into procurement processes, improving overall procurement efficiency and supplier relationships.

Barcelona, Cataluña, España

Client: F4E - Fusion For EnergyProject: Data analysis in support of the Engineering Unit of Fusion for Energy on transversal contracts related to engineering services.- Analysis of project information to support effective decision-making by developing business intelligence reports.- Use of BI tools as Spreadsheets and Power BI to analyse complex data sets, identify trends and extract key information for business decision making.- Contributed to the development and implementation of public contracts, with a focus on data analysis and financial aspects.- Managed financial and accounting documentation, ensuring accuracy and compliance with relevant regulations.- Supervise the commercial, financial and contractual aspects of projects, proactively identifying and addressing potential risks and opportunities.- Management of subcontractors and engineering service providers, using data analytics to track performance and identify areas for improvement.- Monitor the submission of supplier documentation, ensuring timely and accurate completion to support project timelines.- Preparation and presentation of progress, financial, and contractual reports to internal and external stakeholders, utilising data analysis to provide insights and recommendations.- Interaction with several internal and external stakeholders.

Barcelona, Catalonia, Spain

- Contribution to the collection and analysis of transactions and logistical procedures to generate press reports, using Excel to extract key information.- Support the formulation of corporate and sales strategies.- Support the management of a freight forwarders network dedicated to Wine and management of the company participation on general cargo networks.- Prepared reports based on data analysis to provide insights on network performance for decision-making.Organization of events (Online Conferences, Workshops, Cocktails, etc.).- Community management for Social networks and corporate image management.

Cordoba, Cordoba, Argentina

Management of international purchases of playgrounds and furniture from China and Vietnam, utilising data analysis to optimise procurement processes and ensure on-time delivery to Latin America and Canada.- Analysis of import-related data to identify savings opportunities and use of quantitative and qualitative data to prepare purchasing budgets.- Coordination with logistics suppliers and analysis of data to identify cost saving opportunities and optimise processes.- Management and control of international transport documentation. - Analysis of financial data, including billing and payment information, to prepare reports related to cash flow and payment schedules.- Invoicing and payment administration.- Order management, data entry into the system and tracking until arrival.- Management of import certificates and permits, ensuring compliance.- Administration of e-commerce platform for the commercialization of imported products, performing market analysis for product placement and carrying out pricing strategies.

Córdoba, Córdoba, Argentina

- Conducted market research and analysis of the Chilean cheese industry to identify trends and opportunities.- Participation in the International food industry meeting (EPIAL, Córdoba - 2015).- Processed documentation with sensitive data according to privacy policies and data protection standards.- International marketing analysis and arrangement of reporting conferences.- Extracted and processed quantitative and qualitative data, and used data visualisation tools to communicate insights and findings to stakeholders.

Córdoba, Córdoba, Argentina

- Transformation of physical documentation related to international transactions into digital format and upload to the data warehouse as part of the digital transformation process.- Reception of documentation and organisation.

Bachelor Degree On International Business, International Bussiness

Business Intelligence Con Excel: Power Bi, Business/Office Automation/Technology/Data Entry

Programación De Macros Excel Con Visual Basic, Business/Office Automation/Technology/Data Entry

Automatización De Tareas Repetitivas Mediante Grabación De Macros, Business/Office Automation/Technology/Data Entry

Business Intelligence, Business/Office Automation/Technology/Data Entry

Office 365: Excel Profesional, Business/Office Automation/Technology/Data Entry

Office 365: Access Intermedio, Business/Office Automation/Technology/Data Entry

Digital Marketing And Market Research University Course, Marketing And Market Research

International Trade Technician, International Business/Trade/Commerce