Summary
Overview
Work History
Education
Skills
Affiliations
Work Availability
Timeline
Generic

Kate Quillian

Sandy Springs,GA

Summary

Accomplished Data Analyst Consultant with a background in interpreting and analyzing data to drive growth for large scale businesses. Strong ability to utilize statistical, database, and presentation software to present complex information in an understandable manner. Notable success in significantly improving business processes, enhancing productivity, and implementing strategic solutions for achieving business objectives. Proven track record of leveraging deep data analysis skills to inform strategic business decision making. leading to increased efficiency and productivity.

Overview

31
31
years of professional experience

Work History

Data Analyst Consultant

Self Employed Services
Cumming, GA
06.2023 - Current
  • Collected and analyzed environmental data and presented results indicating areas at risk for contamination.
  • Consolidated internal and public data for analysis provided recommendations to prioritize conservation efforts within budgetary consideration.
  • Leveraged data-driven modeling techniques to detect potential monetary gains and setbacks for major financial organization.

Principal Data Architect and Analyst

CRAWFORD & COMPANY (CANADA) INC
Atlanta, GA
12.1998 - 05.2022
  • Collaborated with stakeholders to gather requirements, manage data, and incorporate data virtualization and visualization to create dashboards for internal and client reporting needs using on-premises and cloud data sources.
  • Worked closely with software engineers in order to design efficient, optimized database schemas, queries and ETL processes.
  • Led and collaborated with teams to create innovative, sustainable business applications. This included project management, business requirement and technical design definition, database and software development, QA testing, deployment and ongoing support and enhancements. Worked closely with business stakeholders throughout entire process.
  • Championed and supported data governance implementation including data discovery, policies, business glossary, identification and protection of sensitive data and automation of access to data sets upon data steward approval.
  • Combined, transformed and analyzed data from multiple medical, pharmaceutical and insurance claim sources to identify opiate use and potential risks for the State of CO. Presented findings to the state attorney general and team.
  • Developed and ssupported application to reconcile several thousand client escrow accounts by combining claim, payment and banking data sources using advanced ETL and SQL queries. Led team to develop user interface and reports for business clients.
  • Led development of application to ensure proper licensing for insurance adjusters handling claims using APIs for real time verification with the claim systems.
  • Directed and worked with team to develop human resource onboarding application in Appian Interfacing with external hiring vendor and internal HR system.

Data Analyst

Centers for Disease Control and Prevention, CDC
Atlanta
01.1994 - 12.1998
  • Conducted SAS Data analysis for blinded and non- blinded health surveys to determine sources of infectious diseases
  • Delivered in-person and virtual assistance, advice, and instruction to health departments at state and territorial levels.
  • Delivered findings to legislative panels in Washington, DC.

Education

Industrial Engineering, Applied Statistics

Georgia Institute of Technology
Atlanta, GA

Skills

  • Data cleaning, transformation, optimization strategies
  • Statistical Analysis
  • Data Virtualization
  • Data Visualization
  • Predictive modeling
  • Data Governance
  • Dashboard creation
  • ETL development
  • SQL server, SSIS, SSRS, Oracle, PowerBI, Denodo
  • AWS Redshift, Athena, S3, Glue
  • Athena development with Lambda and DynamoDB
  • Python, Jupyter, R
  • Appian
  • Visual Studio, JavaScript, React, Eclipse

Affiliations

  • Active in conservation efforts emphasizing water quality and land management. Working to become a state naturalist.
  • Avid hiker and participant in community events.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst Consultant

Self Employed Services
06.2023 - Current

Principal Data Architect and Analyst

CRAWFORD & COMPANY (CANADA) INC
12.1998 - 05.2022

Data Analyst

Centers for Disease Control and Prevention, CDC
01.1994 - 12.1998

Industrial Engineering, Applied Statistics

Georgia Institute of Technology
Kate Quillian