Summary
Overview
Work History
Education
Skills
Timeline
Generic

ANTHONY COPPOLA

Richmond,VA

Summary

Results-driven Data Professional with a strong background in advanced SQL development and analytics. Skilled at extracting, transforming, and analyzing complex datasets from diverse sources to drive actionable business insights. Proficient in designing and optimizing queries, building efficient data pipelines, and delivering high-impact dashboards and reports. Proven track record of collaborating with cross-functional teams to enhance business operations, automate reporting processes, and support data-driven decision-making. Experienced in utilizing tools such as Quicksight, Power BI, Excel, and Python to visualize data and effectively communicate findings to stakeholders.

Overview

5
5
years of professional experience

Work History

Reporting/Data Analyst

Richmond National Insurance
09.2023 - Current
  • Developed complex dashboards and reporting processes to track business performance metrics, support financial reporting, and drive operational decision-making.
  • Created standardized, scalable SQL queries to enable efficient delivery of both regular and ad hoc reports using a variety of internal and external data sources.
  • Leveraged multiple tools—including AWS services (QuickSight, Athena, S3, CloudWatch), PivotTables/VBA, and Python—to automate the creation and delivery of reports and analyses.
  • Refactored legacy dataset queries by replacing nested subqueries with optimized CTEs, significantly improving performance and accuracy.
  • Collaborated directly with business stakeholders to understand processes and develop metrics and dashboards that deliver relevant and actionable insights.
  • Delivered weekly and monthly presentations to business units to analyze report data and support data-driven decision-making.

Sr Data Analyst

Retail Data LLC/Intrics
05.2022 - 09.2023
  • Created queries and data architecture that built and maintained all backend tables utilized by a client facing application.
  • Developed data quality and validation processes through SQL procedures and checks.
  • Built various internal monitoring dashboards in PowerBI used by management in operations and business analytics teams.
  • Led several projects to redesign data warehouse and build functional fact tables used across the organization

Data Solutions Architect

Daybreak IT Solutions/VDOT (Contractor)
01.2021 - 05.2022
  • Utilizing Power Automate and BI built Data analytics, reporting and dashboards. Created Apps for internal use to improve business and data collection processes.
  • Developed database objects, including tables, views and materialized views using SQL and transformed project data requirements into project data models
  • Created various “Dashboard” that gave management the ability to monitor operational and financial performances/KPIS. The increased transparency led to a decrease in customer escalations and project budget overages.
  • Led end to end proposal, design, and implementation of a new SQL database as centralized data bank and documented tables, query data and structures.

Data and Analytics Analyst

Atlantic Union Bank
02.2020 - 02.2021
  • Oversaw development of Analytics department tasked with identifying key data/information to create data backed analysis used by executive management to drive business decisions
  • Automated and scheduled distributions by importing data from multiple sources using Advanced Microsoft Visual Studio knowledge.
  • Designed informative report visuals to allow dynamic oversight form different levels featuring Advanced PowerBI Dashboards and Paginated Report Distributions.
  • Analyzed and transformed data; leveraging tools such as SQL Server, Excel and develop and execute SQL scripts to create data extracts and reports.

Education

Bachelor of Science - Finance

George Mason University
05-2013

Skills

  • Data Visualization (Quicksight/Power BI)
  • Identifying key business goals, understanding the data available, and then analyzing it to extract meaningful insights that can be used to drive decision-making and achieve those goals
  • Data interpretation/Delivery
  • Dashboard Design/Improvements
  • Advanced SQL Queries
  • Ability to communicate complex data/analysis with non-technical business users

Timeline

Reporting/Data Analyst

Richmond National Insurance
09.2023 - Current

Sr Data Analyst

Retail Data LLC/Intrics
05.2022 - 09.2023

Data Solutions Architect

Daybreak IT Solutions/VDOT (Contractor)
01.2021 - 05.2022

Data and Analytics Analyst

Atlantic Union Bank
02.2020 - 02.2021

Bachelor of Science - Finance

George Mason University

Similar Profiles

CREATE PROFILE
ANTHONY COPPOLA