Data Analyst Power Bi

David R. Anderl

804-***-**** ****.******@*******.***

SUMMARY

Data Analyst with 15+ years of experience in transforming complex data into actionable insights that drive efficiency, reduce costs, and guide executive level decision-making. Expert in SQL, Tableau, Python, and automation, with a proven record of delivering multi-million-dollar savings and streamlining reporting processes across finance, human resources, and customer service. Recognized for building scalable solutions and communicating findings clearly to both technical and non-technical stakeholders.

CORE SKILLS & TOOLS

Data Analysis: SQL (15 yrs) - Teradata, Redshift, Snowflake, PostgreSQL, Oracle; Python (2 yrs) Visualization: Tableau (9 yrs), SAP Business Objects (5 yrs), Power BI (1 yr) Automation & Cloud: AWS (1 yr), Automation Anywhere (2 yrs) Business Tools: Excel / Microsoft Office (15 yrs), GSuite (3 yrs) Other: Photography, Adobe Photoshop (10 yrs)

SELECTED ACHIEVEMENTS

At Civica RX, reduced Tableau dashboard recovery time by 93% by designing a data source refresh process in Python, eliminating a manual three-person task and ensuring a rapid recovery after ETL failures.

Built Capital One’s Total Rewards flagship Tableau product, which consolidated employee work history and compensation data into a single view, supporting various complex scenarios for associates’ employment and salaries.

Implemented Python + AWS Lambda ETL process to transfer stock market and FOREX data between Snowflake and Redshift, enabling the addition of both stock equity award data and multiple currency scenarios to HR compensation reports.

Developed retention bonus reporting that integrated performance, attrition, and talent data, which allowed compensation associates to target retention of high-performing associates and remain under budget by $4M.

Delivered RPA solution for credit card fraud case processing, which increased case accuracy, decreased case completion time, and generated $8M in contract savings.

Developed Tableau performance dashboards for call center managers, integrating the critical performance metrics for call center associates into a unified resource, providing comprehensive insights into associate performance.

Automated the monthly incentive process for Capital One’s 14 High Value Service departments, distributing $12M in payouts to over 1,500 agents with 99.3% accuracy, reducing processing time to under 4 minutes, and passing all audits with no findings.

PROFESSIONAL EXPERIENCE

Civica RX – Petersburg, VA / Lehi, UT (Remote)

Senior Data Analyst Jan 2023 – Aug 2023

Developed and managed Tableau dashboards to support the company's mission, collaborating with cross-functional teams to translate business requirements into actionable data visualizations.

Built and maintained Tableau dashboards to monitor fundraising activities, enterprise performance, and drug sales patterns for predicting potential medicine shortages.

Used open-source AI tools to accelerate code development and improve accuracy.

Engineered a Python-based process to auto-refresh Tableau dashboards after ETL process errors, reducing recovery steps from 90 minutes to 2 minutes.

PROFESSIONAL EXPERIENCE (cont.)

Capital One – Richmond, VA

Human Resources/Total Rewards Senior Data Analyst Aug 2019 – Dec 2022 — Capital One – Richmond, VA Tableau dashboard and report designer for HR Compensation Consultants, handling sensitive non-public associate data with high governance requirements.

Developed on-demand reporting process combining Python, SQL, and GitHub that identified retainable high-value associates and calculated appropriate retention bonuses, resulting in $4M compensation award budget savings.

Delivered and enhanced a single work-history and compensation dashboard leveraged by multiple HR groups; iterative releases added new features that aligned with evolving business needs and eliminated hours of manual consolidation.

Built pay equity dashboards that proactively addressed potential disparate impact risks for protected classes like age, race, and gender.

Engineered ETL process with Python/AWS to mirror market data between data platforms, which allowed HR compensation tools to include currency conversions and daily stock award pricing. Robotic Process Automation Developer Jan 2017 – Jul 2019 — Capital One – Richmond, VA Designed front-end automation solutions for processing credit card fraud cases, significantly improving case completion speed and accuracy.

Developed RPA bots for fraud case processing, and deployed bots daily across approximately 100 virtual desktop instances, leading to a daily 40%-50% reduction of fraud cases being completed manually.

Project was production-ready three months earlier than planned, significantly reduced repetitive tasks for Fraud Caseworkers, and facilitated $8 million in contract renegotiations with external workforce suppliers. Data Analyst, Card Data Services Telephony Support Apr 2014 – Dec 2016 — Capital One – Richmond, VA Responsible for Tableau report development, data defect remediation, and ad hoc data requests for call center operations.

Developed KPI dashboards for Call Center Unit Managers, improving employee performance management.

Automated multiple manually run reports, increasing consistency and efficiency for stakeholders. Earlier Roles 2001 – 2014

Held various coordinator, quality assurance, and customer service positions, including Loss Mitigation MIS Coordinator and High Value Service Data Coordinator. Responsibilities included monthly incentive distribution, report design and scheduling, quality assurance, and escalated call servicing. Wendell Powell Studio – Henrico, VA

Photographer / Printer / Album Designer May 1996 – Dec 2000

Photographed 35–40 events annually, delivering premium wedding and portrait photography.

Led transition from film to digital media, identifying cost savings and workflow improvements. EDUCATION

University of Richmond, SPCS – Information Systems Certification, May 2019 James Madison University – Bachelor of Arts, Human Communication (English Minor), May 1995 Business Process Management Certification – 2008; coached five successful candidates through certification

Contact this candidate