Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

COLIN O’NEILL

Chicago,IL

Summary

Dynamic data and analytics engineer with over 8 years of experience in building predictive analytics pipelines, developing customer journey frameworks, and designing automated data solutions that empower advanced modeling. Expertise in applying AI to enhance analytical processes and reveal strategic insights that drive business success. Proven track record in executing technical projects and delivering business-facing analytics, including large-scale data migrations and customer value assessments. Committed to leveraging analytical skills within the food and beverage industry to promote healthy eating initiatives and foster data-driven growth.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Principal Consultant

Lovelytics
09.2021 - Current
  • Developed customer lifetime value (LTV) and RFM (recency, frequency, monetary) segmentation models to measure customer value and engagement. Developed an analytical framework for defining and subsetting the client’s customer base.
  • Led end-to-end project from solution design, vendor selection, analysis to identify in-scope data objects, engineering build of automated data retrieval pipeline that leverages Databricks, a modern cloud data warehouse to 100% autonomously respond to consumer data requests. leveraged Artificial Intelligence to improve efficiency of identification of customer data by 300%.
  • Partnered with data governance office to build a data quality utility that identifies quality concerns of data at the source. The utility allows for configurable parameters such that the context and use of the data can be considered when flagging data quality concerns - a major issue for my client’s modeling teams. The utility improved completeness of business data by 75%, timeliness by 100%, and accuracy 50%.
  • Activated business use cases in forecasting, electrical system modeling, and critical reporting through onboarding users to a modern cloud data & analytics platform. Through dedicated partnership with entity forecasters to understand their data & analytics needs, improved ability to generate forecasts from 1-2 times per year to 1-2 times per quarter (300% efficiency increase).
  • Leveraged PySpark Pandas to combine data from 3 disparate sources to create a unified view of data environment connections. Generated this inventory in 4 weeks, using programmatic tools to accelerate generation. The consolidated inventory improved team’s ability to create object connections across the data environment by 85%.
  • Utilized an artificial intelligence workflow to perform fuzzy matching between system data objects to provide a gap analysis for a large-scale data migration. This AI-driven approach resulted in a 75% efficiency gain in time to perform the gap analysis.

Senior Associate

Deloitte
09.2019 - 11.2020
  • - Led a revenue forecasting analysis by integrating historical financial data with current production metrics, applying linear regression to predict annual revenue—shortening the audit timeline by 2 weeks and reducing client workload.
  • - Conducted deep-dive analytics on revenue and expense trends, producing Excel-based visualizations that informed audit scope, risk assessment, and executive decision-making.
  • - Translated complex financial data into clear visual stories to support PCAOB audit inspections and compliance reviews.
  • - Partnered with cross-functional client teams to align on financial controls testing, delivering data-backed recommendations for process improvement.

Education

Data Science Certificate -

Northwestern University
Evanston, IL
06.2021

Bachelor of Accountancy - undefined

University of Notre Dame
South Bend, IN
05.2017

Skills

  • Analytics & Programming: SQL, Python (PySpark, Pandas, NumPy)
  • Visualization & BI: Microsoft Fabric, PowerBI, Tableau, Excel
  • Databases & Big Data: Databricks, Snowflake
  • Certifications: Databricks Professional Data Engineer, Microsoft Fabric Professional Analytics Engineer, Certified Public Accountant (CPA)
  • Methodologies: Data Wrangling, ETL, Machine Learning, A/B Testing, Statistical Analysis, Regression Modeling

Websites

Certification

Certified Public Accountant (CPA)

Timeline

Principal Consultant

Lovelytics
09.2021 - Current

Senior Associate

Deloitte
09.2019 - 11.2020

Bachelor of Accountancy - undefined

University of Notre Dame

Data Science Certificate -

Northwestern University

Similar Profiles

CREATE PROFILE