David Guerrero

Bringing 7+ years of data analytics experience to insurance operations—where analytical thinking meets real-world impact. In this role, I analyze claims data to make informed adjudication decisions, identify process improvement opportunities, and resolve complex cases requiring cross-functional collaboration. Operating in a bilingual (EN/FR) environment, I manage client communications and documentation in both English and French — serving a diverse, multicultural client base across Canada. Impact I've Made: - Cross-functional Collaboration: Partnered with multiple departments to resolve escalated cases, ensuring timely and accurate outcomes. - Data Quality: Maintained comprehensive documentation and data accuracy across company systems, supporting accurate financial decisions and reliable reporting. - First-Contact Resolution: Applied analytical thinking to adjudicate claims efficiently, reducing back-and-forth communication. - Customer Experience and Bilingual Client Communications (EN/FR): Delivered clear, professional communications in both English and French that make complex claims decisions understandable. What I've Learned: - Applying analytical frameworks in fast-paced operational environments where decisions directly impact customers. - Managing competing priorities and making data-informed decisions under tight deadlines. - Translating complex policy and claims data into clear communications for diverse stakeholders. - Leveraging multiple data systems simultaneously to evaluate patterns and ensure accuracy.

- Data Integration & Insights: Transformed complex multi-source data requirements into actionable insights by successfully integrating 20 disparate data sources into a unified data solution that enhanced decision-making capabilities and provided comprehensive visibility across healthcare teams. - Process Automation & Pipeline Development: Achieved 80% reduction in manual data processing time as measured by operational efficiency metrics by designing and implementing automated ETL/ELT data pipelines using advanced SQL transformations, dimensional data modelling, and AWS QuickSight visualizations. - Platform Modernization & Migration Excellence: Improved system scalability by 150% and enhanced maintainability as measured by query performance benchmarks, data redundancy, and system reliability metrics by reengineering and modernizing 100+ datasets and a legacy data solution consisting of 7 dashboards through database migration and optimized data model architecture. - Stakeholder Management & Project Coordination: Enhanced project delivery efficiency and business goal alignment by collaborating with internal teams and external healthcare clients to document requirements, establish clear priorities, and implement strategic project planning processes. - Customer Success: Supported issue resolution time reduction by 50% as measured by ticket closure rates and customer satisfaction metrics by collaborating with Customer Success and technical teams to monitor ticket management systems, implement efficient categorization processes, and establish rapid escalation protocols.

- Healthcare Analytics & Performance Optimization: Improved healthcare operational efficiency as measured by patient wait time reduction and facility capacity optimization metrics by designing, developing, and deploying data solutions that analyzed key healthcare indicators and provided faster insights to clinical staff. - Project Leadership & Delivery Excellence: Achieved over 90% on-time project delivery rate as measured by stakeholder satisfaction scores and timeline adherence by leading cross-functional analytics initiatives that transformed raw healthcare data into actionable insights through effective teamwork and advanced data analysis. - Executive Reporting & Strategic Communication: Enhanced upper management decision-making effectiveness as measured by executive feedback scores and strategic initiative adoption rates by providing regular comprehensive reports and dashboards on project status, data platform performance, and user adoption metrics that informed strategic healthcare decisions. - Data Architecture & Integration: Improved data access speed by 75% and achieved 95% data consistency as measured by report generation times and data quality metrics by designing and maintaining an integrated data infrastructure that seamlessly connects multiple healthcare systems, EMR platforms, and data repositories. - Infrastructure Management & Platform Reliability: Maintained enterprise-grade analytics reliability with 99% uptime as measured by system availability monitoring, supporting 100+ healthcare professionals by administering an ecosystem of four cloud servers and implementing a robust Business Intelligence platform with comprehensive backup and recovery systems.

- High-Impact Data Solutions: Enhanced decision-making capabilities for stakeholders and managers across the organization by creating tailored data visualizations, dashboards, and reports that addressed specific business needs and operational requirements. - Platform Optimization & Process Reengineering: Improved data accessibility and reporting efficiency for stakeholders by reengineering existing dashboards, reports, and ETL processes to streamline information delivery and enhance user experience. - Stakeholder Management & Requirements Engineering: Enhanced project management and requirements documentation processes by collaborating with stakeholders across the organization to document needs, align expectations, and ensure solution delivery. - Cloud Migration & Infrastructure Management: Enhanced analytics reliability and accessibility for 25 users by migrating the on-premises BI environment to the cloud, administering two servers, and modernizing the Business Intelligence platform architecture. - Technical Leadership & Vendor Management: Resolved critical technical issues and enhanced system capabilities by collaborating with third-party providers to address platform problems, oversee licensing upgrades, and ensure optimal system performance.

- High-Impact Client Solutions: Delivered impactful BI solutions to high-profile clients, including Colombia's largest cancer research facility and leading food & beverage companies by developing tailored Qlik-based analytics tools, dashboards, and reports that addressed complex business requirements. - Requirements & Stakeholder Management: Enhanced strategic insights and operational efficiency for clients by collaborating with external stakeholders and internal technical teams to analyze business pain points, document requirements, and deliver comprehensive data solutions. - Technical Solution Development: Improved data reliability and scalability for diverse client operations by designing and implementing Qlik Sense dashboards, multidimensional data models, and robust ETL processes that streamlined decision-making across multiple industries. - Professional Certification: Achieved Qlik Sense Data Architecture certification (2018), demonstrating technical proficiency and commitment to advancing expertise in enterprise BI technologies.

- Process Improvement & Requirements: Collaborated with internal business clients to identify operational inefficiencies, document requirements, and manage process improvement projects that enhanced collaboration between business and technical teams. - Executive Data Analysis: Supported senior management decision-making by acquiring and analyzing business data, creating detailed Excel reports and PowerPoint presentations that informed strategic process improvement initiatives. - Cross-Functional Leadership: Collaborated with multi-disciplinary teams in developing process optimization strategies, including risk analysis projects for SMB financial products that improved operational efficiency and business outcomes.

- Sales Analytics & Executive Reporting: Enhanced sales decision-making by creating comprehensive sales, inventory, and supply chain reports using MS Excel for Sales Manager and supervisors. - Multi-Client Data Management & Process Optimization: Streamlined data management for 8 business partners (5 retail companies, 3 wholesale partners) through consistent, timely reporting that improved operational efficiency and accuracy. - Business Intelligence & Strategic Analytics: Analyzed business data to identify trends and KPIs, optimizing operational efficiency and supporting strategic decisions. - Database Development: Designed, implemented, and managed inventory and sales databases, ensuring data integrity and accuracy for business operations.

- Inventory Analytics & Operational Insights: Supported logistics and supply chain operations by analyzing inventory turnover and product loss data, conducting warehouse and store audits, and preparing detailed Excel reports that provided actionable insights to improve inventory accuracy and reduce product loss for management decision-making.

- Foundation Experience: Supported the Projects Office in operational improvement initiatives by gathering and analyzing operational data, monitoring key performance indicators, and creating detailed reports using MS Excel and PowerPoint to facilitate management decision-making and drive process optimization across transportation and logistics operations.

Business Intelligence, Data Analytics, Data Analysis, Business Analytics, Data Mining, Data Warehouse, Data Visualization, Data Governance, Data Quality