| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateDanny EvansData Analyst IVGodfrey, Illinois, United StatesPHONE NUMBER AVAILABLEEMAIL AVAILABLESUMMARYExperienced 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 EXPERIENCEMay 2022-October 2022Data Analyst IVCharterSt Louis, Missouri, United States Snowflake SQL ad hoc queries Regular updating and processing of incoming requests Other duties as assignedNovember 2021-May 2022IT Data Analyst / ProgrammerCentral FreightManagementSt Louis, Missouri, United States Power BI dashboard design and implementation SSRS Reports design and implementation SQL ad hoc queries MSSQL Server 2016 Redesign of company invoices in Perl Other duties as assignedJanuary 2021-November 2021Data Analyst / ProgrammerSelf-Insured ReportingGreenville, South Carolina, United States Automated data loading for entire organization, saving countless man hours weekly Perl, Javascript Processing weekly data via Excel templateAlso replaced this template taking hours to process with script taking seconds* Perl 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 assignedSeptember 2020-December 2020Data AnalystSpectrumChesterfield, Missouri, United States Create and maintain queries impacting customer service, SQL Ensuring data integrity Provide point of contact support for internal customers Other ad hoc assignments as assignedNovember 2019-June 2020Data StewardBayerCreve Coeur, Missouri, United States 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. January 2017-November 2019Data Analyst/Systems Integration SpecialistUniversity of Missouri St. LouisSt Louis, Missouri, United States Create and run queries as necessary for project deliverables (MSSQL Server 2012) 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 August 2008-August 2012Bioinformatics Scientistn.k.a. Millipore-SigmaSt Louis, Missouri, United States 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 2008 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-2013MSUniversity of FloridaUnited StatesMSUniversity of Florida, Pharmaceutical ChemistryAug 2013 Pharmaceutical Chemistry-2009MBAMissouri Baptist UniversityUnited StatesMBAMissouri Baptist UniversityJan 2009-2006BASouthern Illinois University EdwardsvilleUnited StatesBASouthern Illinois University Edwardsville, BiochemistryAug 2006 Biochemistry-2005ASLewis & Clark Community CollegeUnited StatesASLewis & Clark Community College, ScienceMay 2005 SKILLSData Integrity Database Database Administration Database Modeling Database Design Microsoft Access MS Access MS SQL Server SQL Server Mysql Oracle Postgresql SQL SQL Queries Stored Procedures WEB Database Database Development GUI Javascript Metadata PERL PHP Python Shell Scripting Systems Integration Big Data Data Cleansing Data Mining Data Sources Master Data Management Power Bi Teradata Microsoft SSRS SSRS Tableau Software Tableau Data Warehousing Hedis Hippa Requirement Gathering Data Quality Linux UNIX JIRA JAVA IOS WEB Graphics WEB Graphics Design MS Office Graphical User Interface TOPO Mapping Civil Site Site Design CGMP Chemistry FDA ICD-9 Claims Customer Service Oriented Customer Service ICD Invoices Sign Language Biochemistry Bioinformatics DNA Market Share Product Sales Sales Analysis Business Intelligence Reconciliation Retail Sales USDA Excel MS Excel Microsoft Office Microsoft Word MS Word Publisher MS Publisher Visio MS Visio Data Analysis SQL (Structured Query Language) Information Technology & Information Systems Computer Programming Reporting Dashboards Microsoft SQL Server Perl Programming Language SQL Server Reporting Services (SSRS) Data Processing HIPAA (Health Insurance Portability and Accountability Act) Scripting (Scripting Languages) Business Processes FDA Requirements Identify Issues Current Good Manufacturing Practice (cGMP) NCR Teradata System Integration (SI) ICD-10 Web Design Database Programming Reporting Skills Requirements Management Microsoft Excel Microsoft Windows Server Data Mapping Data Collection Graphics Healthcare Effectiveness Data and Information Set (HEDIS) PHP Scripting Language (PHP Hypertext Preprocessor) Master Data Management (MDM) Data Management SQL Databases Product Development Data Sets Graphic Design Unix Shell Programming Market Analysis Database Analysis United States Department of Agriculture (USDA) Graphical User Interface (GUI) Standard Operating Procedures (SOP) Analysis Skills FDA (Food and Drug Administration)LANGUAGESEnglish - Intermediate Spanish - IntermediateWORK AUTHORIZATIONI am authorized to work in the following countries: United States |