René Lozano

Led OCPM-based Celonis backend architecture for an enterprise telecom use case, designing object-centric data models and resolving complex multi-system mapping issues (98% error reduction). Built automated Action Flows to monitor data job failures and notify stakeholders. Delivered client-facing CCPM Proofs of Concept and served as technical reference for backend transformation logic and data modeling.

Developed Python automation solutions optimizing three key business processes (77% time reduction). Built sales forecasting models achieving <10% MAPE on key SKUs using statistical and ML methods. Delivered executive-level Power BI dashboards enabling finance stakeholders to drive faster forecasting-based decisions.

Designed end-to-end ETL pipelines connecting Celonis to SAP using Python and SQL, delivering dynamic dashboards and the first logistics-cost tracking solution for 26 North American plants (35% accuracy improvement; reporting time cut from 40h to 3h). Built a global Celonis solution for expedited shipments across 150+ plants and integrated freight invoices via Dataiku APIs, reducing decision cycles by 75% and enabling an 11.5% cost reduction.

Developed logistics and global reporting dashboards using Celonis, Dataiku, Python, and SQL, reducing reporting time by up to 100% and improving data accuracy by 35%. Led projects across 150+ plants, streamlined decision-making processes, and contributed to cost reductions while training team members to ensure ongoing success.

Led the implementation of the Freight Bill Auditing Process using Celonis, Python, and SQL, reducing reporting time by 98%, from 40 hours to just 1 hour.

Redesigned a daily QA report using Excel VBA and SQL, increasing accuracy by 20% and reducing processing time by 75%.

Led IoT software development at Crailsheim Plant, optimizing communication during manufacturing malfunctions and delivering a prototype approved for global rollout.

Development of the digital transformation strategy of a Mexican retail company for a chatbot capable of supporting 24/7 customer inquiries (3.8 GPA).

Double degree graduate with a 90 (3.6 GPA) note.

- International Modality Degree with a score of 92 (3.7 GPA). - DHIK Graduate with thesis in IoT as a Tool for Automated Communication in Manufacturing Environments. (German Double Degree Program)