Author Image

Hello, I am Cory

Cory Gargan

Data Analyst

Senior Analyst specializing in data governance, automation, and enterprise reporting in regulated environments. Designs scalable ETL workflows and validation frameworks that enhance data accuracy and operational efficiency. Trusted partner to senior leadership, delivering executive insights and leading cross-functional initiatives that strengthen compliance, reporting integrity, and strategic decision-making.

Problem-solving
Communication & Data Storytelling
Critical Thinking
Collaboration & Cross-Functional Teamwork
Adaptability & Continuous Learning
Attention to Detail

Experiences

1
CPower Energy

April 2023 - Present

Baltimore, MD (Remote)

CPower enables a flexible, clean energy future by optimizing customer DERs through monetization and Virtual Power Plants, delivering grid flexibility when and where it’s needed most.

Senior Analyst, Energy Data

January 2026 - Present

Analyst, Energy Data

April 2023 - January 2026

Responsibilities:
  • Led development of automated ETL and data ingestion workflows using Python and SQL, ensuring reliable integration of multi-source operational data.
  • Supported operational data workflows tied to demand response programs across capacity, economic, ancillary services, and emergency DR program types, working within data systems that interfaced with major ISO/RTO markets.
  • Automated co-worker tasks using Python, reducing manual workload by 20+ hours per month.
  • Designed and maintained centralized data pipelines, dashboards, and ad hoc reporting solutions supporting cross-departmental KPI monitoring.
  • Developed executive-facing metrics delivered to the VP of Customer Enablement, translating complex operational data into actionable insights.
  • Implemented structured data validation frameworks and anomaly detection checks, reducing validation backlog by 45% and improving reporting accuracy.
  • Served as data lead for cross-functional migration and modeling initiatives, ensuring alignment across source systems.
  • Created and led an annual compliance validation initiative covering 2,200+ customer accounts enrolled in demand response programs, ensuring required documentation and data traceability for regulatory adherence and audit readiness.
  • Documented data definitions, business rules, and Standard Operating Procedures to support team awareness and future system enhancements.
  • Investigated and resolved data integrity issues across systems, collaborating cross-functionally to improve database reliability and reporting accuracy.
  • Built automated Dynamics 365 activity tracking dashboards to increase operational transparency.
  • Led an AI research initiative for the SVP of Technology, evaluating emerging AI platforms for business integration and reporting findings to executive leadership.

Price Acoustics

December 2021 - April 2023

Bohemia, NY

Price Acoustics is a premier general contracting firm specializing in high-quality acoustical ceilings and drywall solutions, delivering exceptional craftsmanship and precision to every project.

Business Analyst

December 2021 - April 2023

Responsibilities:
  • Consolidated disparate data sources into centralized pipelines and Tableau dashboards, contributing to recovery of $100K+ in unrealized payments.
  • Improved audit readiness and reporting accuracy through Python-based data cleaning and validation processes.
  • Designed monthly procurement and inventory trend reports to reduce material waste and improve cost efficiency.
2

3
Nassau County Police Department

Oct 2015 - December 2021

Mineola, NY

County Police Department

Analyst, Arrest & Fingerprint Data

May 2019 - December 2021

Responsibilities:
  • Redesigned data entry processes, reducing misidentification and transmission errors by 75%.
  • Led a team of four analysts to ensure compliance with New York State and federal reporting regulations, maintaining data accuracy across criminal justice systems.
Police Officer

Oct 2015 - May 2019

Responsibilities:
  • Served in patrol and specialized units, maintaining public safety and operational readiness.

Skills

Projects

Predicting Customer Churn
Predicting Customer Churn
Creator 2025

Analysis of Consumer Telecom data. Uses XGBClassifier & RandomForestClassifier to predict customer churn. Includes data cleaning, feature engineering, visualization

Predicting Bicycle Rentals
Predicting Bicycle Rentals
Creator 2025

Analysis of Bicycle rental data. Uses XGBRegressor & LinearRegression to predict future Bicycle rentals. Includes data cleaning, feature engineering, visualization

Big Box Store - Sales Data Analysis
Big Box Store - Sales Data Analysis
Creator 2025

Analysis of sales data from a Big Box store. Includes data cleaning, feature engineering, visualization.

ETL Automation - Python 1
ETL Automation - Python 1
Creator 2024

Python script to automate the ETL process.

ETL Automation - Python 2
ETL Automation - Python 2
Creator 2024

Python script to automate the ETL process.

ETL Automation - Python 3
ETL Automation - Python 3
Creator 2024

Python script to automate the ETL process.

Covid SQL Project
Covid SQL Project
Creator 2022

In this project, MySQL was utilized in order to analyze global Covid-19 data.

Data Cleaning in MS SQL Server
Data Cleaning in MS SQL Server
Creator 2022

Transformed housing data with MS SQL Server to ensure a suitable format for analysis.

Website Voting Automation
Website Voting Automation
Creator 2022 (Updated 2025)

Automated the task of casting votes in order to nominate a Doctor in a local marketing campaign

GUI Version - Website Voting Automation
GUI Version - Website Voting Automation
Creator 2022 (Updated 2025)

GUI Version-Automated the task of casting votes in order to nominate a Doctor in a local marketing campaign

Data Cleaning
Data Cleaning
Creator 2022

Transformed housing data with R to ensure a suitable format for analysis.

MLB Spinrate Analysis
MLB Spinrate Analysis
Creator 2022

Analyzed MLB pitching data in attempt to determine if cheating had occured.

Covid Data Visualization
Covid Data Visualization
Creator 2022

Tableau Data visualization created utilizing views created from the Covid SQL Project.

Education

B.S. in Business Administration

Accomplishments

Google Data Analytics Professional Certificate

The Google Data Analytics Professional Certificate on Coursera is an industry-recognized program designed to equip learners with essential data analytics skills through hands-on training. Covering the full data lifecycle, the course teaches data cleaning, analysis, visualization, and storytelling using Excel, SQL, Tableau, and R. Learners gain expertise in statistical analysis, database management, and business problem-solving, culminating in a capstone project that applies real-world data scenarios. Upon completion, participants earn a Google-certified credential, preparing them for entry-level data analyst roles across various industries.