Post Job Free
Sign in

Project Manager Data Analytics

Location:
Sunbury, OH
Posted:
June 08, 2025

Contact this candidate

Resume:

Kay Lynn Rice

email: **********@*****.***

Westerville, OH 43082

LinkedIn Profile: www.linkedin.com/in/kaylynnrice

1-614-***-****

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.



Contact this candidate