You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Miguel Angel Montero CamachoMA

Miguel Angel Montero Camacho

Supply Chain Excel and Power BI

€100/day
Heróica Puebla de Zaragoza, MX
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Miguel Angel

Do you feel like your data is scattered or that you spend too much time generating reports manually? My goal is to transform your information into a real competitive advantage. I help companies and entrepreneurs optimize demand planning, automate critical processes, and gain full visibility of their key performance indicators (KPIs) through customized and scalable data analysis solutions.

What sets me apart?

What I bring is not just technical mastery of tools, but a vision oriented towards concrete business results. My approach combines technical precision with practicality:

Intelligent Automation: I drastically reduce report preparation times and the margin of human error through macros and automated processes.

Visual Clarity: I design intuitive dashboards that turn complex metrics into actionable insights for decision-making.

Proven Industry Experience: My background ranges from managing complex inventories in SAP ERP to sales optimization, allowing me to understand operational challenges from the inside.

What projects can I support you with?

I manage deliverables designed to directly impact your profitability:

Dynamic Dashboards in Power BI and Excel: Automated dashboards for real-time tracking of inventory, sales, and KPIs.

Process Automation (VBA/Power Query): Development of macros and workflows that eliminate repetitive tasks and streamline data processing.

Data Cleaning and Normalization: Audit and structuring of databases to ensure your reports are always based on reliable and error-free information.

Demand Planning Optimization: Analysis models that adjust your response times and improve stock control.

Would you like to chat about how we can automate your reports or improve the visibility of your key metrics?
  • Spanish

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • Capgemini México,
    Demand Planning Consultant
    LOGISTICS AND SUPPLY CHAIN
    July 2026 - Today
    Aguascalientes, Mexico
    • • Detailed analysis of sales data using Power BI, Power Query, and Excel, generating weekly reports that optimize forecast accuracy.
    • • Data management in SAP ERP to improve inventory visibility and control, helping to reduce stock discrepancies.
    • • Optimization of demand planning and inventory management using Kinaxis RapidResponse, adjusting response times for inventory changes.
    Microsoft Power BI Data Analysis Advanced Microsoft Excel Supply Chain SAP ERP
  • Farmadroguería Medina,
    Data Analyst
    PHARMACEUTICALS INDUSTRY
    February 2019 - April 2023 (4 years and 2 months)
    Heróica Puebla de Zaragoza, Mexico
    • • Automation and improvement in data analysis using PowerQuery and PowerPivot, reducing report preparation time.
    • • Leadership in data analysis automation projects, generating automatic reports that streamline decision-making and reduce errors.
    • • Validation and verification of data in the ERP system, ensuring data reliability for key reports.
    • • Design of KPI reports and trend analysis, providing insights to increase process efficiency.
    • • Implementation of data cleaning procedures, detecting and correcting corrupt records to improve data accuracy.
    Microsoft Power BI SAP ERP Excel VBA Macros Project Management Data Analysis
  • Freelance,
    Data Analyst in Online Platforms
    LOGISTICS AND SUPPLY CHAIN
    July 2021 - October 2022 (1 year and 3 months)
    Heróica Puebla de Zaragoza, Mexico
    Development of customized data analysis solutions that increased clients' process efficiency and improved satisfaction.
    • • Design of dashboards in Power BI and Excel for better inventory and sales tracking, allowing clients instant visibility of their key metrics.
    • • Programming of advanced macros and automations in VBA and VB.net, increasing report productivity and streamlining processing times.
    • • Automation of KPI tracking, optimizing report performance and improving response times in metric analysis.
    Microsoft Power BI Excel VBA Macros Data Analysis Advanced Microsoft Excel Project Management

Recommendations

Be the first to recommend Miguel Angel

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Technician in Electronic Systems Maintenance
    Colegio Nacional de Educación Profesional Técnica
    2016
    Técnico en Mantenimiento de Sistemas Electrónicos
  • Microsoft Office Certification
    Microsoft
    2015
    Certificación Microsoft Office

Skill set

Categories