Oscar Vicente Guerrero Machado

Oscar Vicente Guerrero Machado

About

Detail

Cajicá, Cundinamarca, Colombia
Contact Oscar regarding: 
work
Full-time jobs
Starting at COP7.5M/month ~USD2.43k/month
Flexible work

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • A
    Wfm & Bi Country Manager
    Allianz Partners Colombia
    Oct 2025 - Current (11 months)
    • Lead the Business Intelligence and Workforce Management functions for the Colombia and Spain operations, turning operational data into decisions for leadership. • Own the KPI framework governing SLA, abandonment and average cost — three consecutive years meeting all three simultaneously. • Lead a team of 5 senior analysts across forecasting, capacity, BI and performance reporting. • Drove +40% YoY productivity (cases per agent) through data-led resource optimization and process redesign. • Directed 24/7 assistance operations with rotating shifts, weekends and public holidays — scheduling, real-time control and dispatch coordination of 150,000+ services per year through a network of 250+ providers. • Ran daily operational coordination with
  • A
    Wfm Coordinator
    Allianz Partners Colombia
    Jan 2023 - Oct 2025 (2 years 10 months)
    • Designed and implemented the end-to-end BI ecosystem (Power BI, SQL, DAX, Power Automate): 100+ indicators, reporting automated to ~95%. • Built and scaled the Workforce Management function from scratch, supporting local operations and global service delivery. • Led root-cause analysis and remediation of the Mexico BU: stabilized the workforce structure and improved stakeholder alignment. • Managed end-to-end field service operations including work order creation, provider routing, status tracking, service evidence capture, and data integration for billing and cost control.
  • A
    Performance Management Analyst
    Allianz Partners Colombia
    Apr 2022 - Dec 2022 (9 months)
    • Operational performance analysis, KPI definition and reporting to support data-driven decision-making. • Managed end-to-end field service operations including work order creation, provider routing, status tracking, service evidence capture, and data integration for billing and cost control.
  • A
    Technical Professional – Contract Financial Analytics & Budgeting
    Andiasistencia – MAWDY (Mapfre Assistance Group)
    Feb 2018 - Mar 2022 (4 years 2 months)
    • Financial analytics of the company's contracts (services and reinsurance); P&L reading and profitability alignment. • Built and consolidated the corporate scenario budget alongside Financial Controlling. • Implemented Power BI across the company (indicator dashboards), alongside the corporate Qlik Sense standard. • Analytical support for pricing, contract renegotiation and operational efficiency. • Utilized SQL and dimensional modeling to perform complex data analysis and rigorous data validation, ensuring the accuracy of financial reporting. • Spearheaded the initial implementation of Tableau within the Business Unit, managing its deployment for one year before successfully transitioning the organization to Power BI and Qlik Sense to opt
  • A
    Provider Analyst – South Zone
    Andiasistencia – MAWDY (Mapfre Assistance Group)
    Jun 2016 - Feb 2018 (1 year 9 months)
    • Managed the South-Zone provider network (250+ partners, 150,000+ services/year), governing SLA and cost performance through scorecards. • 8% average-cost reduction through tariff renegotiation and contract redesign. • Standardized the provider Balance Scorecard and performance model, later replicated across zones; optimized working capital by accelerating billing and settlement. • Managed end-to-end field service operations including work order creation, provider routing, status tracking, service evidence capture, and data integration for billing and cost control.
  • A
    Call-Center Agent to Supervision
    Andiasistencia (Mapfre Assistance Group)
    Jan 2012 - Dec 2016 (5 years)
    • Progressed through the full operational value chain: call-center agent → Quality Analyst → Planning Center (operation scheduling — the root of my WFM experience) → Supervision (supported a 40-agent group). • Coordinated real-time dispatch of roadside and home assistance jobs shift by shift — first from the floor as an agent, later as a supervisor — assigning services to field providers, managing urgent escalations and covering demand peaks. • Managed end-to-end field service operations including work order creation, provider routing, status tracking, service evidence capture, and data integration for billing and cost control.
Education verified_user 0% verified
  • Microsoft
    Microsoft Power BI Data Analyst Associate (PL-300)
    Microsoft
    May 2026 - Jun 2026 (2 months)
  • Microsoft
    Microsoft Azure Fundamentals (AZ-900)
    Microsoft
    May 2026
  • LinkedIn Learning
    SQL Essential Training
    LinkedIn Learning
    May 2026
  • LinkedIn Learning
    Root Cause Analysis: Getting to the Root of Business Problems
    LinkedIn Learning
    May 2026
  • Inalde Business School
    Executive Management Program
    Inalde Business School
    Jan 2026
  • Franklin Covey
    The 7 Habits of Highly Effective People
    Franklin Covey
    Jan 2024
  • Q
    Qlik Sense Developer & Designer
    Jan 2018
  • Universidad Central
    Environmental Engineer
    Universidad Central
    Jan 2012 - Jan 2017 (5 years 1 month)