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