Marco Casagli

I play a key role in shaping and executing the BI strategy to drive data-driven decision-making across the organization. I also collaborate closely with the Controlling (CO) team. My technical expertise spans a variety of tools and platforms, including Analysis for Office (AFO), BO Central Management Console, SAP Analytics Cloud, BW4/HANA, Datasphere, and embedded analytics. I coordinate different intenationonal BI development teams. I bring a strong foundation in Python, R, SQL, and ABAP, which I developed through my academic training at the University of Milan and professional experience. I was part of the S/4 implementation team. I oversee the BW4/HANA Global Platform, ensuring its effective operation and supporting users worldwide. I work closely with business teams to design and build dashboards, data models, and reports that deliver actionable insights and drive business performance. Specialized in Supply Chain Analytics Expertise in analyzing and optimizing supply chain processes through the use of advanced Business Intelligence (BI) tools and data analytics techniques. Proficient in SAP BW/4HANA, SAP Analytics Cloud, and SAP S/4, focusing on areas such as inventory management, demand forecasting, order processing, and logistics optimization. Experience in designing and implementing data models, dashboards, and reports that provide actionable insights to drive operational efficiency and cost reduction across the supply chain. Strong background in end-to-end supply chain visibility, including procurement, production, and distribution, enabling better decision-making and improved supply chain performance. Skilled in working with large datasets, performing data analysis to identify trends, bottlenecks, and opportunities for improvement in supply chain operations. Collaborated closely with cross-functional teams, including procurement, logistics, and inventory management, to deliver BI solutions that streamline processes and enhance business outcomes.

I'm specialized in Business Warehouse from version 3.5 to 7.5 on HANA and CO module and the integration between the two modules e.g. COPA scenarios and BPC. I'm a BW system administrator of a global installation of an International Brand in Fashion, I manage tickets, realizations of new data flows in areas like inventory, COPA, finance, Sales and master data. Enhancement of datasources, realization of custom datasources even with function module. Modify and realization of bex queries. I've managed the migration of the server from the uk data center to the italian one. Realization of abap routines at start routine level, expert routines, end routines and infoobject routines. Integration with the BPC module in areas like COPA, General ledger and Assets. Realization of expert routine in order to transpose the data from rows to columns and realizazione of an ABAP procedure to extract data for the integration with Qlikview. Realization of a data flow in order to eliminate the last level of a hierarchy loaded from ad DSO. I worked with HANA Studio in order to create calculation views. Interviews, creation of the BBP, customization and post go live support. Good knowledge of the CO module: Co consultant in an international project consisting in two phases: the first the roll out of the international template to the italian subsidiary customizing it to the local requirements, training, go live and post go live assistance. The second phase was inherent the merge of the italian subsisdiary to an other company. See project section for details.

Project description Project Intesa San Paolo: (SAP BW Finance) Realization of data flows related to the passive cycle specifically related to purchasing and to the human resources area. I was a member of the implementation team in charge od analyzing the user requirements, formalize them in the BBP, data modelling, realization of the data flow, queries and post go live support activities. It was a complex project due to the presence of different IT players that had to be coordinated in order to guarantee the timing of the project. Project Intesa San Paolo (BW Human resources) Payroll analysis Organization Management Time event Management

Project: Merck Multinational pharmaceutical company (second in the world). More than 70000 employees Project PSR. The goal of the project consisted in determining the incentives and objectives of the sales reps network. Member of the EMEA Business Intelligence team in charge of the the support activities of 300 users and of the development of the new bi projects. Business Analyst. Interviews of the key users in order to retrieve the requirements of the solution. Coordination of the ABAP resources for the realization of complex routines on the Bw system. Implementation of medium complex routines for ETL data flows. Project documentation in English. Data modelling and creation of data flows with SAP R/3 as source system or flat files. Customizer: process chains, extractors, apd, bex security Realization of the interface with the CO PA module (Profitability Analysis)

Project :Datawarehouse and business intelligence for the finance company CNH (Case New Holland Fiat group) Finance Interviews with the key users in order to get the business actual requirements and future ones in order to guarantee the improvement of the processes. Analysis, definition and implementation of the BW solutions. Application maintenance: management of the evolution tickets and ordinary ones , analysis of the errors. Verification of the data in order to guarantee the standardization, the consistency and integration. User acceptance test in order to test the modifications made on the system. Realization of technical analysis, functional analysis and project documentation like analysis of the data flows, operational procedures, dimension matrix and analysis of the reports.

I have worked for AIVE, a Capgemini Company Project: Essere benessere, Artsana, Aquafill Worked as an SAP BW Consultant for the implementation of SAP BW integrated with SAP ECC, aimed at enhancing business reporting and decision-making processes. The project focused on designing and developing a robust data warehousing solution to consolidate data from various ECC modules, including FI, CO, SD, MM, and HR.

Project:: Pellini, Grandi Molini Italiani I worked as an SAP BW Consultant for the implementation of SAP BW. Collaborated with business stakeholders to gather reporting requirements and translated them into technical specifications. Designed and implemented data models including InfoObjects, DSOs (DataStore Objects), InfoCubes, and MultiProviders to support business reporting needs. Created analytical reports and dashboards using BEx Analyzer and SAP BO for various business functions.

Worked as a BI Consultant on a CRM Analytics project aimed at enhancing customer insights and sales performance analysis. The project involved designing and implementing a data warehouse solution integrated with SAP CRM to support advanced analytics and reporting for marketing, sales, and customer service functions.

Worked as a BI Consultant on a Logistics Analytics project for a leading manufacturing company. The project aimed to optimize supply chain visibility and operational efficiency by designing and implementing a data warehouse solution integrated with SAP ECC Logistics modules (MM, SD, and WM). The solution supported advanced analytics for inventory management, procurement, order fulfillment, and transportation logistics.

Project Cartiere Miliani Fabriano (Paper Industry): Served as a BI Consultant on a comprehensive analytics project focused on Sales, Production, and Purchasing data. The objective was to provide actionable insights and enhance decision-making through the design and implementation of a data warehouse solution integrated with SAP ECC modules (SD, MM, and PP).

Bi Project: Fedrigoni Cartiere (Paper Industry) Data Source: SAP R/3 Led the development and implementation of Business Intelligence solutions for the Sales, Orders Portfolio, and Human Resources areas within Fedrigoni Cartiere. Extracted, transformed, and loaded (ETL) data from SAP R/3 to create comprehensive reports and dashboards, enabling data-driven decision-making. Designed and implemented KPIs and performance metrics to track sales performance, order management, and HR operations. Worked closely with business stakeholders to define requirements and deliver actionable insights, improving operational efficiency. Enhanced data visualization and reporting capabilities for senior management, supporting strategic business decisions.