Data Analyst Senior
Resume:
Steven Ashley
Senior Data Analyst
A proven Senior Data Analyst with over 12 years of Healthcare (EHR) Data Experience.
Lee’s Summit MO. 64086
******.******@*****.***
www.linkedin.com/in/stevenashley
EXPERIENCE
Apex Systems / Instacart, KCMO - Brand Ambassador
5/2024 – PRESENT
Ensure a smooth and engaging implementation and introduction to AI shopping technology to clients and their customers. Implementation included mapping and weighing store items for the AI cart database as well as training store personnel.
ALKU / Oracle Cerner, Remote - Senior Data Analyst
2/2019 – 4/2023
Design/Implement/Troubleshoot/Schedule Reports & Extracts for Cerner clients allowing for increased client satisfaction and productivity. (examples - LHIN, Press Gainey, Reach, Medicaid, Medicare, 340b, Axiom, CPOE).
On Veterans Administration (VA) Project, mentored VA staff on creation of efficient and accurate CCL/SQL Extracts for input into their reporting data warehouse and dashboards from the Cerner Millennium database consisting of hundreds of tables and thousands of fields.
MedSys Group / McLeod, Florence, SC. - Cerner Consultant
2/2018 – 2/2019
Taught McLeod Systems staff the creation and scheduling of efficient and accurate CCL and DA2 Extracts and Reports using the Cerner Millennium database which enabled them to successfully complete their Cerner Go Live and maintain established 3rd party revenue cycle apps.
ALKU / Cerner, Remote - Senior Data Analyst
9/2016 – 2/2018
Design/Implement/Troubleshoot/Schedule custom reports, extracts and Mpages not provided in standard reporting for Cerner clients allowing for increased client satisfaction and productivity. Altered claims queue processes to meet client desired claim assignment criteria with a custom CCL token. Clients included Fort Health, and Penn State Health.
Convergenz / Heights Finance, KCMO -Web Architect
9/2015 – 12/2020
Migrated custom CMS website from ASP Classic to ASP .Net, from MS Access backend to MS SQL Server and from locally hosted VM’s to AWS hosted VM’s utilized ASP.NET, JavaScript, HTML, CSS, jQuery, C#.NET, Python and IIS 6.0 Modernization efforts made business much more attractive prior to eventual sale.
Cerner, KCMO - Senior Software Architect
7/2012 – 6/2015
Developed custom reports and extracts for Cerner clients in Revenue Cycle and custom CCL groups in order to fill needs gaps in standard reporting. Used trouble shooting skills to identify and correct 3rd party interface with MedAssets resulting in a 30% percent reduction in discrepancies in the interface. Errors were identified in supporting build, rules and code. Oversaw a 50% increase in installed client interfaces to MedAssets requiring code install, build updates and process scheduling. Additional custom reports were created for State mandated reporting as well as Medicare and Medicaid.
Education & Certifications
Google Data Analytics Certificate - 12/2024
Prepared, processed, and analyzed data to inform business decisions. Worked effectively to create visualizations to share findings with stakeholders and provide recommendations driven by data. This certificate covered the seven grounds of data science, worked with Python, translated data into insights, worked on the power of statistics, simplified complex data relationships, and studied the nuts and bolts of machine learning.
Public Trust Government Security Clearance -2/2019 & 7/2010
Security+ Certification -2010 - ID: COMP001020184944
ITIL Foundation v3 Certification 6/2008
CARS (Compuware Quality Assurance Testing Certification 2005)
Oracle Master Certification (1996)
University Of Missouri - Kansas City
BA degrees in Psychology & Sociology
Additional Experience and Training Details are available at:
https://www.linkedin.com/in/stevenashley
SKILLS
Cerner EHR
Data Warehousing
Data Mining
Patient Accounting
Charge Services
CCL programming
DA2 programming
DA2 scheduling
R programming
MS SQL/MS Access/MS Excel
Oracle SQL / PLSQL
Python
Tableau
A/B testing
Machine learning
Predictive modeling
Statistical analysis
Data Security
ETL
FHIR
HL7
ASP.NET
JavaScript
HTML
XML
CSS
jQuery
C#
API calls
SFTP
PROJECT
Louisiana Health Information Network (LHIN)
The purpose of the extract is to allow more efficient transfers of care, reduced readmissions, and better outcomes for high-risk populations throughout the state.
By providing in to the extract to the Network it also enables providers to receive alerts for patients who have been admitted or discharged in near real-time.
This extract, is installed in multiple Cerner hospital clients though out Louisiana. Each record in the extract is formatted into a fixed width record some 5200 characters in length and describes over 260 different aspects of the hospital encounter (visit).
These 260+ fields are drawn from a database (Cerner Millennium) that has hundreds of tables and thousands of fields. Finding the expected data efficiently requires a high level of knowledge of the database, a great deal of data mining as well as testing to pick the correct data and finally a great deal of (ETL) knowhow to get it formatted in an acceptable record(s) for the extract.
Finally, the extract has to be scheduled and transferred to the Network for addition to the LHIN data warehouse
Contact this candidate