Data Analyst Customer Service

DANA CARL McKERN (he/him)

****.******@*****.*** • (925) 286 - 9882

www.linkedin.com/in/DanaMcKern

Data Analyst • Problem Solver • Spreadsheet Whisperer

Curious data storyteller with a passion for turning messy datasets into beautiful, bite-sized insights. Whether it’s wrangling Excel formulas into submission or building dashboards that even your grandma could understand. I’m ready to bring a pinch of nerdy joy to your team—and a whole lot of data skill.

Most Recent Accomplishment

Earned a Certificate in Google AI Prompting Essentials (Coursera), demonstrating core skills in crafting effective prompts for generative AI tools. May 2025

AREAS OF EXPERTISE

Financial Reporting

AI Prompt Generation

Data Visualization

Excellent Customer Service

Informational Story Telling

Excel, VBA, Access, SQL

ChatGPT / Gemini

Strong Time Management

Dashboard Creation

High Level Internal / External Communications

EXPERIENCE

Amazon Sorting Center

Team Member • Dallas, TX 2023 – 2024

Enjoyed the physically demanding nature of loading and unloading massive product shipments.

Excelled in an environment where safety for self and others was paramount.

Grew physically and personally in a setting focused on getting undamaged products to happy customers.

DirecTV Latin America (Strive Consulting)

Reporting Analyst • Dallas, TX 2019 – 2020

Compiled and analyzed data trends, created reports, and presented a clear and succinct vision through visual information design and interactive visualization development

Identified and tracked Service Level Agreements – SLAs / Key Performance Indicators – KPIs

Designed high-level Excel workbooks, based on heterogeneous data from MS Excel, Google Docs, CSV, Text, and Flat files to generate a multi-page report with INDEX(MATCH) / (VLOOKUP) formulas, VBA macros, pivot tables, logical and nested formulas, and graphs

Vizient (Kaiser Permanente Account) fka MedAssets

Senior Data Analyst • Irving, TX 2013 - 2018

Unified, reconciled, audited, and aggregated complex financial data sets in inconsistent and unpredictable formats for executive-level presentations and strategic insights

Presented pricing and savings results to all levels of internal and external customers through dashboards, Excel reports, and PowerPoint presentations for goods and services with values in the tens of millions of dollars

Simplified complex multilevel analysis with the use of color, heatmaps, and complex conditional formatting

Irwin Home Equity - Mortgages

Senior MIS Analyst • San Ramon, CA 2000 - 2008

Underwrote Mortgage applications, reviewed credit, income, and other confidential information to make loan decisions

Created multiple MS Access databases with complex data structures, joins, forms, reports, macros, and VBA

oInteractive index pages

oPop-up prompts and clear error messages

oForms with sub-forms

oReports with multilevel drill-down capabilities and parent/child relationships

oNested If statements

oExtensive Visual Basic for Applications customization

Mastered a variety of reporting tools including Cognos, Business Objects, and Crystal Reports

Exposed 36 cases of theft where salespeople were intentionally sacrificing loan profitability for personal gain: saved the company $1.3 million annually

Rebuilt entire 72 report library to adapt to changing business environment

Modernized reports for paperless delivery saving hundreds of thousands of dollars in printing costs

Streamlined report generation process, freeing up an entire FTE from a team of four

EDUCATION

California State University Stanislaus

Bachelor of Arts, Communication Studies

Minor: Computer Science

Graduated May 2013 Dean’s List (GPA 3.64)

Coursework in statistics, data visualization, and computer science fundamentals.

San Joaquin Delta College

Associate of Arts, Social and Behavioral Sciences

Dean’s List; graduated 2010 with High Honors (GPA 3.76)

Contact this candidate