Data Analyst Sql Server

DANA CARL McKERN

****.******@*****.*** • (***) **6 - 9882

www.linkedin.com/in/DanaMcKern

Experienced Data Analyst who loves to solve puzzles and is committed to continual learning with proven skills in communicating technical concepts to non-technical audiences

AREAS OF EXPERTISE

Financial Reporting

SQL Programming

Relational Databases

Report Automation & Design

Informational Story Telling

Data Analysis

KPI and SLA Monitoring

Dashboard Creation

Data Visualization

High Level Internal / External Communications

EXPERIENCE

Sole Support for Dying Wife

Caregiver 2018 – 2024

Scheduling

Transportation

Emotional and Physical Support

Household Maintenance

Amazon Sorting Center RBD5 (Dallas Fort Worth Area)

Team Member 2023 – 2024

Inbound

Outbound

Non-Con

Shoe Sorting

Provista – Program Analytics (InSource Consulting)

SQL Server Analyst • 100% Work from Home - Irving, TX 2020 – 2021

Analyzed vast amounts of raw data to find patterns that helped improve customers’ experience, streamline processes, and mitigate risks

Manually authored data pulls from SQL Server Management Studio, for sales teams and managers, for monthly and year-end reporting

Learned many of the quirks of 100+ TB series of complex databases and tables

Reconciled reports against in house Tableau and SalesForce reporting

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 complicated 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 application, reviewed credit, income, and other personal 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 per year

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

Dean’s List (GPA 3.64)

San Joaquin Delta College

Associate of Arts, Social and Behavioral Sciences

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

Contact this candidate