Renaud Pirson Email and Phone Number

(Contractor via Alten Canada)Complete analysis, data engineering, creation, documentation and maintenance of stored procedures, reports and dashboards to support the different departments of the company with a focus on supply chain using SQL (SSML, SSIS, SQL Agent) and Power BI. Automation and performance reviewing of the database and datamart

On mission at Pratt & Whitney in the Global Data Analytics Team in Supply Chain Management

• Creation, implementation and maintenance of several KPI's for the Supply chain department. Reports were set up by using Power BI and the Azure SQL server, used code: DAX, M, SQL statements • Development of Python programs for database queries and use of google API (geo coding and distance matrix)• Follow-up on the creation of a SQL server for SCM department (data loading, SQL statement, documentation and data governance)

• Roll-out of SAP in AGC plant in Klin (Russia) and Seingbouse (France) for planning and sales department• Roll-out of the CTM planning tool in North West plants + in charge of the planning master data in SAP APO• Improvement of the distribution flows across AGC plants in Europe via the ORVAL project via data analysis and reporting using Power BI• Creation and follow up of a data cube on Cognos for the central planning team• Planning Master Data maintenance

- Spent one year working and travelling across Australia and South Asia.- Worked in different areas, mostly in hospitality in Melbourne and a farm work in Queenstown.

- Focusing on improving the process to define and manage safety stock for end-products and components.- Analysis of new methods to improve the productivity (Lean, QRM...)