Data Analyst - SQL & Power BI Expert in Healthcare Data
Resume:
Danny Evans
Godfrey, IL *****
*****.*****@***.*****
Experienced Data Analyst with expertise in SQL programming, data management, and interface analysis Proficient in Power BI, SSRS, and
Perl with a strong background in pharmaceutical and biochemistry industries Skilled in database design, data cleansing, and compliance with regulatory standards like HIPAA and FDA Strong track record of completing ad hoc queries, automating data loading, and ensuring data integrity for impactful data- driven solutions
Work Experience
Interface Analyst
Anderson Hospital-Maryville, IL
October 2022 to Present
Managed HL7 interfaces and ensured accurate data management of mission-critical applications Defined, collected, stored, and interfaced core data set elements Assisted analysts with data reporting, acquisition, and ELT functions Mentored other analysts
Executed SQL ad hoc queries
Data Analyst IV
Spectrum-St. Louis, MO
May 2022 to October 2022
Utilized Snowflake for data analysis
Conducted SQL ad hoc queries
Updated and processed incoming requests regularly Completed other assigned duties Data Analyst/Programmer
Central FreightManagement-St. Louis, MO
November 2021 to May 2022
Designed and implemented Power BI dashboards
Developed and implemented SSRS Reports
Executed SQL ad hoc queries
Redesigned company invoices in Perl
Completed other assigned duties
Data Analyst/Programmer
Self Insured Reporting-Greenville, SC
January 2021 to November 2021
Automated data loading, saving hours weekly using Perl and Javascript Processed weekly data efficiently with Perl scripts Provided vendor support
Cleansed, manipulated, and aligned data for database upload Ensured data integrity and HIPPA compliance
Data Analyst
Spectrum-Chesterfield, MO
September 2020 to December 2020
Created and maintained SQL queries impacting customer service Ensured data integrity
Provided internal customer support
Completed ad hoc assignments
DataSteward
Bayer-Creve Coeur, MO
November 2019 to June 2020
Acted as resident domain expert in data for functional areas Accountable for data quality and compliance with regulations Profiled data to identify gaps and recommend solutions Ensured data assets' compliance with cGMP, FDA regulations DataAnalyst/Systems Integration Specialist
University of Missouri St.Louis-St. Louis, MO
January 2017 to November 2019
Ran necessary queries for project deliverables using SQL Server Evaluated data for accuracy and relation to requests Developed and maintained SQL queries and stored procedures Generated reports, graphics, and dashboards
Integrated incoming data with existing data using SQL, Perl, Tableau, etc. Bioinformatics Scientist
Sigma Aldrich Chemical Company-St. Louis, MO
August 2012 to December 2016
• Web site design
• Shell scripting utilizing
• 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 Education
Master's degree in Pharmaceutical Chemistry
University of Florida - Gainesville, FL
August 2010 to August 2013
Master's degree in Business Administration
Missouri Baptist University - St. Louis, MO
October 2007 to January 2009
Bachelor's degree in Biochemistry
Southern Illinois University Edwardsville - Edwardsville, IL January 2005 to August 2006
Associate's degree in Chemistry
Lewis and Clark Community College - Godfrey, IL
2005 to 2006
Skills
• Pivot tables
• Communication skills
• Data analytics
• PL/SQL
• Microsoft Word
• Python
• Data governance
• Computer skills
• Redshift
• Data Acquisition SQL Queries
Power BIDashboard Design SSRS Reports Design Data Loading Automation Data Cleansing HIPAA Compliance Data Integrity Management Database Development
• Java
• Project management
• Shell Scripting
• SQL
• System design
• Project leadership
• Training & development
• ETL
• Intelligence experience
• Power Pivot
• Analytics
• Microsoft SQL Server
• Math
• Unity
• Computer networking
• Continuous improvement
• AWS
• ICD coding
• MySQL
• Relational databases
• Data warehouse
• Apache
• Server management
• Revenue cycle management
• Database Design
• Scripting
• SSRS
• Mentoring
• VPN
• Business requirements
• SSIS
• Jira
• JSON
• SQL Server Management Studio
• Database design
• Data science
• Requirements Gathering
• PostgreSQL
• Business intelligence
• Organizational skills
• SQL
• Financial report writing
• PHP
• Database administration
• Pricing
• Statistical analysis
• Microsoft Excel
• Intelligence analysis
• SEO
• PowerShell
• Team management
• Software development
• Systems analysis
• Metadata
• Ubuntu
• Digital marketing
• Data collection
• Leadership
• Oracle
• JavaScript
• Bash
• Microsoft Office
• Informatica
• Data analysis skills
• REST
• Application development
• Perl
• Time management
• QlikView
• Web development
• Management
• Windows
• Visio
• HTML5
• Forecasting
• HIPAA
• Azure
• Visual Basic
• Root cause analysis
• Data Warehouse
• Data structures
• Hospital experience
• Configuration management
• Product management
• Data manipulation
• DevOps
• R
• Regression analysis
• E-commerce
• Sales
• Product development
• Active Directory
• Business analysis
• SDLC
• Database development
• Data modeling
• Software testing
• Microsoft Powerpoint
• SharePoint
• Computer science
• C#
• SAS
• Tableau
• Marketing
• ETL
• Salesforce
• EMR systems
• Linux
• Microsoft Access
• Software troubleshooting
• Business development
• XML
• Customer service
• C++
• Data mining
• Financial analysis
• Database management
• Test automation
• Power BI
• T-SQL
• Data management
• Teradata
• Meditech
• Data visualization
• Adobe Analytics
• Big data
• Research
• Analysis skills
• APIs
• Databases
• Clinical trials
• Statistics
• Python
• Clinical research
• NoSQL
• IT
• UI design
• C/C++
• Test Cases
• Data warehouse
• Java
• Spark
• Machine learning
• PyTorch
• Data science
Certifications and Licenses
Driver's License
February 2022 to February 2026
Contact this candidate