Kay Lynn Rice
email: **********@*****.***
Westerville, OH 43082
LinkedIn Profile: www.linkedin.com/in/kaylynnrice
Summary
A seasoned technology professional with expertise in Custom Epic SlicerDicer development, data analytics, reporting, metric analysis, and code development. Highly proficient in Epic Chronicles, Clarity, Caboodle, SlicerDicer RWSQL, and Radar Development. Possesses strong skills in SQL, GE Centricity, Tableau, Splunk, Power BI, JIRA, and ServiceNow.
Active Epic Certifications
Clarity Data Model
Caboodle Data Model
Cogito
Cogito SlicerDicer Custom Build Badge
SQL Metrics Build Badge (In Progress)
Cogito Tools Administration (Accredited)
Cogito Project Manager
Experience
Epic Reporting Advisor
Prominence Advisors, Remote, United States
February 2025 - Present
Epic SlicerDicer Refuel Consultant. Collaborated with client developers to release Epic Models for their organization. Provided advisement on custom FDS filters, troubleshooting, and build management.
Clients: UCSF
Senior Epic BI Developer
Medasource
May 2022 – July 2024
Developed SlicerDicer FDS, FDM, and Actions, including customization and modification of Epic items.
Created Audit SQL scripting for Metadata Analytic Catalog Updates.
Developed SlicerDicer and RWSQL Components for Dashboards.
Designed and implemented Dashboards, RWSQL Templates, and Reports.
Conducted Metadata Cleanup and Research & Development for Upgrades, Nova Notes, and conversion from EDW to Caboodle.
Tested new custom Caboodle tables and fields.
Worked with Epic Cogito TS and Client Manager.
Acted as an Epic Knowledge Resource for new hires and current employees.
Certifications Acquired/Re-certified: Clarity Data Model, Caboodle Data Model, Cogito, Cogito SlicerDicer Custom Build Badge, SQL Metrics Build Badge (In Progress).
Skills: RWSQL, SlicerDicer Development, QlikView, SQL, Business Intelligence, Cogito, Caboodle, Clarity, Chronicles.
Business Intelligence Developer
Pinnacle Group, Inc.
February 2022 – May 2022
Contractor at JPMCHASE Fraud.
Developed Advanced Tableau / Teradata Dashboards.
Conducted Ad-hoc SQL data research, reporting, and delivery.
Manager Consultant Area: Business Insights and Data Analytics
Sogeti
April 2018 - January 2022
Specialized in Business Insights and Data Analytics.
Courses: Splunk> Core User, ERwin for Data Modeling, Tableau, PowerBI, ETL using SSIS, Quantitative Analytics / Data Science, SAFe Agile methodology, Agility AMP / Netezza.
Projects: BMW Financial Services - Agile Senior Business Analyst: Originations Team / DFE Project Team / Continuing Maintenance Team, A&F - SWIFT (JustEnough) SizeTheBuy SQL Applications Developer, Kroger Print Services - BA / Data Analysis & Visualization / Reporting Subject Expert.
Database Conversion Project: State of Ohio - Conversion of MS Access Database(s) to SQL Server Data Warehouse.
Business Intelligence Developer/Cogito Project Manager
OhioHealth
June 2013 - April 2018
Developed Epic Custom Reports and data mining initiatives for OhioHealth entities.
Led the Epic Slicer Dicer initiative, increasing use and knowledge.
Reviewed and provided comments on document adequacy and corrected deficiencies.
Fulfilled Reporting Workbench Administration duties for template configuration.
Provided Data Courier services to the Enterprise Analytics Team.
Created ServiceNow Dashboards for the Enterprise Analytics Team to monitor data and report requests.
Led initiatives for better communication with the Epic Model Build Team Application Report Liaisons.
Gathered specification requirements for report and data requests.
Prior Epic Go-Live: SQL Server, GE Centricity, SSRS, Crystal, SSIS, MS Excel Macros.
Created Report Status Documentation and knowledge base documents.
Created security documentation for external report folder setup and permissions.
Conducted data research with quick, accurate results.
SSIS Projects: Created processes for data extraction and delivery for audit control and data mining for cleanup.
Led reporting for Delaware Grady Mem. Hosp. using Crystal Reports & Excel.
Led and installed the 2013 Meaningful Use GE Centricity Reporting for Ohio Primary Care Group and Healthworks.
Modified and developed internal reports for GE Centricity EMR using Crystal Reports X.
Researched and fixed job errors produced through GE Centricity EMR using Oracle SQL Developer.
Outlined the Service Provider / Business table process for Referral Tracking Reporting.
Created ETL File creation and process documentation for Centricity to EPIC project for OPG and Healthworks Data.
Developed advanced MS Excel formulas and macros for Healthworks Meaningful Use and Goal Deployment reporting.
Created Data Report for CareConnect/Epic Preload Go Live for Primary Care Location patient data from the Centricity Database.
Senior Systems Programmer
Robert Half Technology
March 2012 - June 2013
OhioHealth Corporation: Senior Systems Analyst.
SQL Server, GE Centricity, SSRS, Crystal, SSIS, MS Excel Macros.
Sustained and maintained reporting needs for the EMR organization at OhioHealth.
Created, maintained, and scheduled Materialized Views through Oracle.
Created and used SQL Server Stored Procedures and Queries.
Created and maintained reports with SSRS, scheduled and managed user security for reports.
Hired as a Full-Time Employee at OhioHealth at the end of the contract.
Ohio Farm Bureau: Senior Systems Analyst iMIS System, SQL Server, SSRS, MS Excel Macros.
Maintained and updated the database, conducted ad-hoc data, reporting, and analytic requests.
Attended AFBF and OFBF Conferences, taught Excel at regional training conferences.
Senior Database Operations Analyst
Enterprise Customer Data Management, L Brands
August 2008 - November 2011
SAS, Excel Macros, Oracle Database.
Fulfilled requests from the Customer Marketing team for reporting and data pull needs.
Refined procedures and processes for cleaner, more accurate, and efficient operations.
Led initiatives to optimize SAS code for various projects, reducing processing time and errors.
Created file load jobs for ad-hoc and recurring third-party vendor files for social media data.
Senior Systems Programmer
Consulting
March 2000 - August 2008
Worked with multiple recruiting companies.
Apex Consulting: Lead Crystal Reporting Programmer and Lead Consultant at The Columbus Dispatch.
Information Control Corporation: Reporting & MS Access Specialist at Cardinal Health e Business Team, Quality Assurance/Testing/Hyperion Essbase development at Wendy’s International Headquarters.
Nationwide Securities: IT Lead / Report Writer Business Analyst.
Tosoh, SMD: Lead Crystal Reports Writer.
Ohio Public Employee Retirement Services: VB/Microsoft Developer.
Bank One: Microsoft Access Specialist.
QWest Communications: Database Technology Specialist.
Nationwide Insurance: Cobol Main Frame Programmer.
Commodity Futures and Trading Commission, Washington DC: Software Engineer.
Education
DeVry Institute of Technology
Bachelor of Applied Science (B.A.Sc.), Computer Information Sciences
1998 - 2001
Bachelor of Science in Computer Information Sciences.
Faculty Assistant in several programming classes.