Kristopher Lopez
Head of Data and Analytics at PetSure (Australia)- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
PetSure (Australia)
-
Australia
-
Insurance
-
200 - 300 Employee
-
Head of Data and Analytics
-
Jul 2021 - Present
● Working closely with all departments to prepare the business for a seamless transition to integrate new LLM technologies and applications by transforming processes and systems across the organisation.● Led significant Data Science & Automation projects, introducing OCR as a capability and deploying deep learning models, for cost savings of $2M per year● Fostered a data driven culture at PetSure by emphasising self service analytics, establishing knowledge hubs, and promoting active learning and development for citizen data analysts.● Developed a high performing team of BI Developers, Data Analysts and Data Scientists, focusing on mentoring, professional development and knowledge sharing. Expanded the Data & Analytics team from 5 to 15 employees across Australia and South Africa● Received the Employee of the Year award 2021. From 2020 to 2023, 5 team members earned Employee of the Quarter awards under my leadership Show less
-
-
Senior Manager of Data and Analytics
-
Mar 2020 - Jul 2021
● Developed the strategic roadmap for Data & Analytics at PetSure Australia● Built strong relationships with executive leadership team and ‘head ofs’, enabling the formation of an executive steering committee for the Data & Analytics function, and the centralisation of Data & Analytics resources● Implemented and facilitated adoption of other Data Governance practices such as improved metadata collection, version control of key assets on SQL Server, data retention policies, data lineage, tightening of approval processes, and performance reporting● Conducted a review of legacy data applications and introduced best practice coding standards. This led to 150+ query improvements and a 30% cost reduction on DWH Server.● Over 12 months, increased the unique users of Data & Analytics applications by 20% due to heightened focus on business partnership and working through aged tasks for key stakeholders across departments● Introduced robotic process automation (RPA) capabilities with bots created in Python Show less
-
-
-
Chubb Fire & Security Group
-
United Kingdom
-
Security and Investigations
-
700 & Above Employee
-
Data Science Manager
-
Jun 2018 - Mar 2020
● Established the first-of-its-kind team for Chubb worldwide, focused on driving key business outcomes through data analytics, visualisation, and reporting in a near greenfield environment.● Developed the strategic roadmap for Data & Analytics at Chubb Australasia● Fostered strong relationships with the executive leadership team and line managers, enabling effective change management and improved adoption of data applications.● Implemented key data governance initiatives, including improved unit-testing, data quality, metadata collection, and the establishment of an executive leadership team steering committee.● Transformed the business from data-averse to data-curious by creating a comprehensive analytics platform using Power BI Service, Report Server, and Mobile. The platform generated $1.4 million in additional revenue, saved $1 million in costs, and identified over 300 instances of employee fraud.● Accelerated the adoption of self-serve analytics by developing comprehensive and intuitive analytics platforms and tools, such as usage tracking, interactive commenting for dashboards, and KPI-driven automatic notifications.● Enhanced predictive analytics capabilities with projects involving location-based work clustering, route optimization, customer churn modeling, and financial forecasting using time series modeling.● Introduced robotic process automation capability using UIPath bots. Show less
-
-
Senior Business Intelligence Developer
-
May 2015 - Jun 2018
● Architected and developed a Kimball data warehouse, storing data from multiple sources, concatenating data into conformed dimensions, and re-indexing for high performance and throughput.● Designed and implemented ETL processes using SSIS, leveraging incremental load, slow changing dimension, and truncate-load patterns for optimal daily load while collecting metadata about the health of the server, database, and daily load.● Redesigned and consolidated legacy SSRS reporting suite into a concise set of high-value reports, including a customer reporting pack for non-technical audiences.● Developed Power BI dashboards to replace manually maintained Excel-driven dashboards and reports, resulting in administrative cost savings of $10,000 per month.● Led the Business Intelligence transitions to new field management, human resource, and payroll systems (Dynamics CRM Field Service, Workday, and Globalview).● Functioned as an interdepartmental business partner, collaborating closely with field and office staff in both consulting and development roles. Show less
-
-
Business Intelligence Developer
-
Jan 2012 - May 2015
● Built a second quoting application using Excel VBA and a normalised MSSQL backend, reducing quote preparation time from 30 minutes to 5 minutes, and introducing features such as user access control, version control, centralized version update, activity tracking, interaction events, dynamic document generation, and flexible user layouts. As of 2019, the application had over 50 active users, generated over 100,000 quotes, and contributed to the estimating division's growth from $20M to $25M per year.● Developed operational dashboards that integrated data from field service management software, ERP, CRM, and customer surveys.● Provided support and training for dashboards, collaborating closely with teams nationwide and building strong relationships with stakeholders across multiple departments.● Created a range of new SSRS reports using SQL stored procedures and dynamic queries. Show less
-
-
Data Analyst
-
Nov 2010 - Jan 2012
● Scenario modelling and route clustering, leading to a 10% increase in productivity● Using Excel VBA, automated several processes, one of which reduced time to prepare a quote from 20 minutes down to 5 minutes and subsequently led to a 15% increase in conversion.● Developed dashboards which combined KPIs from multiple aspects of the business, allowing for more effective planning and performance management
-
-
Education
-
University of Sydney
Masters of Data Science, High Distinction -
UNSW Australia
Bachelor of Commerce (B.Com.), Accounting and Finance