Arturo Rodrigo Michel Rojas BI | AI | Big Data | DASM | PMP | LSS Black Belt |

Commercial Project Manager

ALICORP

Dec 2024 - Current (1 year 11 months)

• Support the implementation of a new Route-to-Market model to support the strategic expansion of the sales force across key markets, reducing
the Cost-to-Serve but keeping the level of service.
• Build the business/commercial area data model and implement it as the foundation of the BI platform with Self-Service reporting.
• Led the migration of the commercial database from PostgreSQL to GCP, to enhance scalability and performance in a medallion architecture.

BI & Control Analyst

Nestlé

Jul 2023 - Dec 2024 (1 year 6 months)

• Creation of KRI reports by distributor for credit sales evaluation, reducing OVD (Overdue) to 5%
• Implementation of monthly quality controls for consumer sales, which allowed an 8% increase in repurchase rates and a reduction of DSO (Days Sales Outstanding) to 15 days, maintaining satisfied customers, good service levels, and a clean account receivable.
• Coordination of a team of 3 to follow up the OMP (Organizational Master Plan) with the implementation of the projects.
• Optimization of P&L and CCS (Customer Contribution Statement) reports increasing the contribution margin by an aproximate 7%.
• Development of a zero-based budgeting system for general expenses (rides, travels, office materials), integrating P

Trade Marketing Assistant

Nestlé

Jan 2023 - Jun 2023 (6 months)

• Development and implementation of market research process through an app (POS Inventory, OOS, Competitor prices and actions) with reports to measure campaign and tactical execution according to OKRs.
• Reduce Sales Peak by -17% with the creation of a sales analysis tool based on a forecast to reduce SCD.
• Create and maintain communication strategies for commercial tactics (Cards visuals and catalogues).
• Maintenance and tracking of KPIs for the internal E-commerce platform on shopify (Managing Promotions, Net-Promote Score and Discounts)

Commercial Excellence Trainee

Nestlé

Jul 2022 - Jan 2023 (7 months)

• Tailored implementation of a merchandising monitoring digital process at the national level for the calculation of variable payment with documentation and training for the entire team.
• Creation and monitoring of ETL processes in SQL and Python.
• Receive training courses on processes, techniques, business units and IT tools of Nestlé.

Arturo Rodrigo Michel Rojas

About

Detail

Timeline

Résumé

Arturo Rodrigo Michel Rojas

About

Detail

Behavioral traits