Mag. Jorge Alvarez Senior Supply Chain Analyst

Planning Analyst at Henkel Consumer Brands, combining Supply Planning, Reporting and Master Data. Former Supply Planner for Hand Dish Wash at Henkel's Vienna plant, managing production planning in SAP APO. Design and automate reporting solutions using Power BI, Power Query, Excel VBA and SAP APO/BOA. Develop data models, reports and Master Data monitoring solutions, driving process optimization and strategic decision-making across regional Supply Planning.

Senior Supply Chain Analyst GBS+ Reporting Henkel Consumer Brands - Developed 9 automation projects improvements resulting in 200 hours/year savings. - Implemented continuous improvements of Demand Planning, Potential Overstock (SAP, Excel, Power BI). - Data validation, implementation and support of BI systems to Henkel areas (SAP APO, MM, Masterdata). - Front end Power BI development of dashboards, implementation of DAX KPIs calculations and visualizations.

Supply Chain Analyst in Henkel GBS+ Reporting for Laundry & Home Care - Preparation, documentation, continuous improvement, and automation of logistics, supply planning and inventory reports with Excel, SAP APO, VBA, VBScript and SAP GUI scripting automations. - Developed 10 automations and process improvements resulting in 0.12 FTE savings (250 hours/year).

Supply Chain Analyst in CHEP Chentral Planning Operations. - Updated, analyzed purchases reports. Analyzed and monitored KPIs in inventories, S&OPs. - Designed, developed and updated inventories and S&OPs reports, working in Excel and VBA with macros, pivot tables, advanced formulas, and imported data from other databases: SAP, JDA, Qlikview. - Planned international transport routes, stocks and purchases. Designed reports with Power BI.

Project Developer for projects consisting of bulk storage silos and pneumatic and mechanical conveying systems. - Elaborated risk and feasibility analysis and performed conceptual engineering of projects. - Developed techno-economic proposals integrating automation and plant engineering, installation and assembly works, supply chain, purchases in ERP Syteline. Managed, monitored projects in CRM SalesForce.

Developed the detailed engineering for the EPC project "Amman Strategic Reserve Terminal for Petroleum Products". - Performed hydraulic calculations and process simulations. Component selection. - Developed the Process Design Basis and Process Description of the project. - Elaborated equipment datasheets, process flow diagrams, P&IDs, fluid list datasheet.

Business Development of international EPC projects for power generation plants - Elaborated market studies of power generation, including existing projects and future projects in Middle East, Eastern Europe, America. - Prepared proposals (RFPs), managed projects and budgets. Developed business and strategic plans. - Identified potential clients (contractors, IPPs, equipment manufacturers). Analyzed public and private tenders. Researched, analyzed and managed international business opportunities.

Operated and designed biological reactors: MBBR and SBR as well as UF membranes.