Looking for a job

juan carlos rozo montoya

@juancarlosrozomontoy

Message

I automate business processes and turn operational data into measurable results.

Colombia

Message

What I'm looking for

I'm looking for opportunities in business intelligence, data analytics, and process automation where I can improve operational efficiency, integrate systems, and deliver measurable business results, remotely or through relocation.

I've delivered process automation and business intelligence solutions for Concremóvil, Invertek, and public-sector institutions, improving operational control and recovering previously unbilled revenue.

At Concremóvil, I integrated plant batching systems with the ERP using Excel and VBA, recovering nearly COP 300 million in unbilled shipments. I also led specialized concrete billing software implementation, improving productivity and operational control by 60%.

At Invertek, I coordinated the migration from Siigo to SAP Business One within schedule and budget, increasing operational efficiency by 60% and centralizing information. I've also developed tailored reporting tools, commercial-management dashboards, and an Excel application for collection-commission calculations.

I currently teach data analytics at Universidad Autónoma de Bucaramanga, updating curricula with current tools and real business cases. I bring more than 12 years across industrial, commercial, institutional, and public sectors, with advanced Excel, VBA, Power Query, and Power BI capabilities.

Experience

Work history, roles, and key accomplishments

Current

Docente Universitario (Hora Cátedra)

Current

Universidad Autónoma de Bucaramanga (UNAB)

Feb 2024 - Present (2 years 7 months)

Updated data analysis curricula with current tools and methodologies. Implemented teaching methods based on real business cases to improve practical applicability.

Data Analysis Curriculum Development Teaching Case Based Learning

Contratista - Asesor Profesional

Gobernación de Santander

Jan 2026 - Jul 2026 (6 months)

Provided technical assistance and advisory services for institutional strengthening. Supported the Regional and Territorial Development Directorate, achieving full contract execution.

Technical assistance Institutional Strengthening Project Management

Consultor en Tecnología de Información

Concremóvil

Feb 2016 - Jun 2025 (9 years 4 months)

Developed Excel and VBA integrations with ERP systems, recovering $300 million in unbilled dispatches. Led implementation of specialized billing software, improving operational control by 60%.

Excel VBA ERP Integration Process Automation Macros Access

Servicio Técnico Especializado

Cooperativa de Tecnólogos e Ingenieros de la Industria del P

Jun 2024 - Dec 2024 (6 months)

Achieved 100% acceptance of methodology for data capture and reporting. Obtained full approval of developed office tool phases evaluated by Ecopetrol officials.

Data Collection Reporting Office Tools Methodology Development

Consultor en Tecnología de Información

Invertek

Feb 2018 - Dec 2023 (5 years 10 months)

Coordinated successful ERP migration from Siigo to SAP Business One, improving operational efficiency by 60%. Designed custom tools to meet contractual information delivery commitments.

ERP Migration SAP Business One SIIGO Project Management Tool Development