Danny Evans - *

DANNY EVANS

Phone: 618-***-****

ad27e5@r.postjobfree.com

*** ***** **** *****

Godfrey, IL 62035

EDUCATION

MS University of Florida, Pharmaceutical Chemistry Aug 2013 MBA Missouri Baptist University Jan 2009

BA Southern Illinois University Edwardsville, Biochemistry Aug 2006 AS Lewis & Clark Community College, Science May 2005 EXPERIENCE

Anderson Hospital, Maryville, IL October 2022 to current Interface Analyst

• Manages HL7 interfaces and responsible for data management of mission-critical applications

• Works to ensure all core data set elements are defined, collected, stored, and interfaced accurately

• Assists other analysts with data reporting, data acquisition, and other ELT functions

• Helps mentor other analysts

• SQL ad hoc queries

Charter, St. Louis, MO May 2022 to October 2022

Data Analyst IV

• Snowflake

• SQL ad hoc queries

• Regular updating and processing of incoming requests

• Other duties as assigned

Central FreightManagement, St. Louis, MO Nov 2021 to May 2022 IT Data Analyst / Programmer

• Power BI dashboard design and implementation

• SSRS Reports design and implementation

• SQL ad hoc queries

• Redesign of company invoices in Perl

• Other duties as assigned

Self-Insured Reporting, Greenville, SC Jan 2021 to Nov 2021 Data Analyst / Programmer

• Automated data loading for entire organization, saving countless man hours weekly o Perl, Javascript

• Processing weekly data via Excel template

o Also replaced this template taking hours to process with script taking seconds

Perl

Danny Evans - 2

• Provide point of contact support for vendors

• Data cleansing, manipulation, and alignment for upload to current database

• Ensuring data integrity and compliance with HIPPA

• Other ad hoc requests as assigned

Spectrum, Chesterfield, MO Sept 2020 to Dec 2020

Data Analyst

• Create and maintain queries impacting customer service, SQL

• Ensuring data integrity

• Provide point of contact support for internal customers

• Other ad hoc assignments as assigned

Bayer, Creve Coeur, MO Nov 2019 to June 2020

Data Steward

• Resident domain expert in data for one or more functional areas including regional data sources and business processes, and enterprise data assets and products. Mostly with Teradata or PostgreSQL

• Accountable for data quality, definition, production, and usage of Enterprise data assets and their compliance with cGMP, FDA regs

• Profile data to identify gaps/problems and recommend viable options to resolve. University of Missouri St. Louis, St. Louis, MO Jan 2017 to Nov 2019 Data Analyst/Systems Integration Specialist

• Create and run queries as necessary for project deliverables (SQL Server)

• Evaluate data pulled for accuracy and relation to data requests (MS Excel, Tableau.)

• Develop, update, and maintain current SQL queries, stored procedures, etc. (SQL Server)

• Generate reports, graphics, dashboards, etc. (Excel, Tableau)

• Integration of incoming data to existing claims data and other data. (SQL, Perl, Tableau, etc.)

• Web site design (DNN, PHP, Windows Server)

• Business Requirement Gathering

• Data Warehousing design

• Database development

• Data mining, mapping, integrity, and integration

• Business Intellegence Design

• Data cleansing

• Use of ICD-9 and ICD-10 diagnosis and procedure codes

• Developing queries to align claims with HEDIS definitions Sigma-Aldrich (n.k.a. Millipore-Sigma), St. Louis, MO Aug 2008 to Aug 2012 Bioinformatics Scientist

• Web site design

• Shell scripting utilizing

Danny Evans - 3

• Business Intelligence Website Design (Before Power BI)

• Market share analysis

• Overlay analysis

• Sales analysis

• Database Design, Analysis and Development

• Data Cleansing

• Creation of GUI

• Database development

• Data mining, mapping, integrity, and integration

• MySQL and SQL Database Administration

• Master Data Management for big data sets

• Data Reconciliation

• Help develop SOP’s for new/developing products (cGMP, FDA, USDA)

• Web Graphics Design

• Design of oligonucleotides (siRNA,DNA primers, etc.) for gene silencing PROFESSIONAL TRAINING

SQL Programming

University of Missouri St. Louis, West County

Description: 2 semesters worth of SQL programming training Advanced SQL Queries Level 1, 2, 3

University of Missouri St. Louis, West County

Description: Subqueries, Advanced joins, Table Aliases, String Functions, Running Totals, Metadata Queries, Self-Join, Common Table Expressions, Censoring/Truncations, String Manipulation, String Functions

LANGUAGES

English: Native Language

Spanish: Novice Listener, Novice Speaker

Pigeon Sign Language: Intermediate Receptive, Intermediate Signing COMPUTER SKILLS

Programming: Perl, Javascript, Java, Python, PHP, SQL, MySQL, Oracle, PostgreSQL Applications: Teradata, Jira, Tableau, DNN, Windows Server, MS Office, MS Word, MS Access, MS Publisher, MS Visio, MS Excel

Danny Evans - 4

Platforms: Linux, Unix, Windows, iOS

REFERENCES

Available upon request

Contact this candidate