Oscar Vicente Guerrero Machado
About
Detail
Cajicá, Cundinamarca, Colombia
Contact Oscar regarding:
work
Full-time jobs
Starting at
COP7.5M/month ~USD2.17k/month
Flexible work
Résumé
Jobs
verified_user
0% verified
- AWfm & Bi Country ManagerAllianz Partners ColombiaOct 2025 - Current (9 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.
- AWfm CoordinatorAllianz Partners ColombiaJan 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.
- APerformance Management AnalystAllianz Partners ColombiaApr 2022 - Dec 2022 (9 months)• Operational performance analysis, KPI definition and reporting to support data-driven decision-making.
- ATechnical Professional – Contract Financial Analytics & BudgetingAndiasistencia – 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
- AProvider Analyst – South ZoneAndiasistencia – 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.
- ACall-Center Agent to SupervisionAndiasistencia (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).
Education
verified_user
0% verified
Microsoft Power BI Data Analyst Associate (PL-300)MicrosoftMay 2026 - Jun 2026 (2 months)- Microsoft Azure Fundamentals (AZ-900)MicrosoftMay 2026
- SQL Essential TrainingLinkedIn LearningMay 2026
- Root Cause Analysis: Getting to the Root of Business ProblemsLinkedIn LearningMay 2026
- Executive Management ProgramInalde Business SchoolJan 2026
- The 7 Habits of Highly Effective PeopleFranklin CoveyJan 2024
- QQlik Sense Developer & DesignerJan 2018
- Environmental EngineerUniversidad CentralJan 2012 - Jan 2017 (5 years 1 month)