Claire Scanlon

Claire Scanlon

Data Analyst · Data Scanalytics

United States, CT

In My Own Words

Vertically Integrated Financial Data Architect.

Data professional with 9+ years in financial services delivering $1.5M+ impact. Expert in fraud detection (92% accuracy, $5M prevented), AWS serverless pipelines, and analytics that cut reporting 50% and accelerate decisions 40%. Architected systems handling $1.2B+ in assets. AWS Certified.

$5M fraud prevented ✅
$1.5M annually saved ✅
99% accuracy maintained ✅
3+ years without breaking ✅
Data systems that scale ✅

- SQL (advanced): complex joins, optimization, relational schema design, upsert logic, reconciliation queries, fraud/exception detection.
- Python (advanced): ETL pipelines, CSV/JSON processing, error handling, orchestration, statistical modeling, ML for fraud detection, NLP workflows.[Attachment +2]
- VBA and Google Apps Script: automation of data workflows and daily ingestion/reporting.

Work Experience

Data Analyst

Data Scanalytics

2024 – Present

Wealth Management Analyst

GSB Wealth Management

2020 – 2022

Implemented outlier detection algorithms to flag unusual patterns in financial data Developed and maintained databases to support wealth management operations Ensured data quality and accuracy within CRM and customer databases Conducted regular data audits and implemented data quality procedures to maintain high data integrity standards Developed anomaly detection models to identify fraudulent financial transactions

Business Data Analyst

District Athletic Club

2019 – 2020

Leveraged SQL and statistical analysis to track key performance indicators (KPIs), identifying trends and providing data-driven insights to optimize business operations. Developed interactive dashboards and reports using Tableau to visualize membership trends, class attendance, and revenue data, empowering stakeholders with actionable insights. Led cross-functional projects, collaborating with marketing, sales, and operations teams to gather requirements, define project scope, and deliver data-driven solutions that met business objectives.

National Marketing and Communications Director

VNUE Inc.

2016 – 2019

Assistant Marketing Director

VNUE Inc.

2015 – 2016

Education

Master of Science in Computer Science

University of Colorado

2024 – 2026

Programming Languages, Data Structures and Algorithms, Database Management, Statistical Analysis, Machine Learning, Data Visualization, Software Engineering Principles, System Design and Architecture, Cloud Computing, Human-Computer Interaction

Bachelor of Science (B.S.)

Rochester Institute of Technology - Saunders College of Business

2007 – 2012

Data-Driven Decision Making, Data Analysis, Market Research, Financial Analysis, Business Acumen, Marketing Strategy, Business Operations, Data Storytelling, Visual Communication, Public Speaking, Presentations, Statistics

Skills

Problem SolvingBusiness RequirementsMarketing AnalyticsRelationship BuildingVBA ExcelTechnical ProficiencyExploratory Data Analysis (EDA)Statistical AnalysisTime Series Analysis AlgorithmsPythonpandasAlgorithmsData StructuresAnomaly DetectionData IntegrationExtract, Transform, Load (ETL)Oracle Data WarehousePrompt EngineeringStatistical Data AnalysisWealth Management ServicesStrategic PlanningStatistical Programming LanguagesDocumentationBusiness process reengineering (BPR)Agile MethodologiesJavaMachine LearningMicrosoft AzureData StorytellingAnalytical SkillsReporting & AnalysisData Storytelling and VisualizationBusiness Process AnalysisMicrosoft OfficeCustomer Relationship Management (CRM)Business Process AnalyticsMicrosoft ExcelStrategyCross-functional CoordinationAnalyticsR (Programming Language)Data WarehousingProgramming LanguagesData ScienceBig DataData Structures and AlgorithmsData AnalyticsPresentationsClient ServicesData ManagementCompetitive IntelligenceData-driven Decision MakingStrategic PartnershipsMarket ResearchCompetitive AnalysisPython (Programming Language)Business Intelligence (BI)TableauSQLData TransformationPredictive AnalyticsLeadershipMarket Research & AnalysisData VisualizationStakeholder EngagementChange ManagementProject ManagementDigital MarketingProcess OptimizationBusiness StrategyData Analysis