Daniel Shoemaker Email & Phone Number

Created Health Data Partners, Inc in order to work corp to corp on projects. Selected projects have included: --Epic Cogito SQL conversion from Crystal Reports--Epic Clarity, Caboodle, and Slicer Dicer. Revenue Data Model, Tapestry, and Access Data Model--Athena Health Dataview Reporting using snowflake--Nextgen report development--Data warehouse design and build. Also including ETL and SSIS package creation and automation.--340b extracts--Medicare Advantage (Part C) data builds and reporting including Tapestry--Population Health - Healthy Planet (Pop Health)--Tableau and Power BI dashboard design and management. Skilled in DAX logic.--Physician productivity RVU model creation and management--Azure Dev Ops

Chicago, Illinois, Us

--Developed reporting and extracts for VBPM, HEDIS, and Quality Measures to support analysis.--Created reports for Risk Adjustment (RAF) as well as Hierarchical Condition Category coding (HCC) activities.--Refined models for Population health attribution--Developed Tableau and Power BI reporting solutions.

Chicago, Illinois, Us

--Principle architect of extensive PB data warehouse. Also provide extensive Business Intelligence Developer services.--Extensive SQL Server SSMS, SSIS, MS Access, Crystal Reports, Tableau, Power BI and other related BI Tools--Extensive Epic Clarity, IDX, Athena Health Dataview, Nextgen and several other platforms. --Generated population health reports from Epic (Healthy Planet) as well as Athena (Athenanet). --Utilize snowflake extensively for data warehouse ETL and reporting in support of Athena Health Data View product.--This position has evolved to provide “just in case” support. Capped at 5 hours weekly.

Lauderdale Lakes, Fl, Us

--Created Epic clarity reports / SQL for large and small projects.--Converted very large number of legacy crystal reports to either reporting work bench (via cogito sql) or slicer dicer. --Azure Dev Ops--Generated or troubleshooted other reporting workbench reports in hyperspace. Utilized most every clarity data model.--Extensive Epic Caboodle report generation.--Generated Healthy Planet / Population Health Reports.--Mentored junior team members by troubleshooting or creating cogito sql.

Oakland, California, Us

--Supported the Clinical Risk department and patient populations by developing complex data models and queries. AKA Population Health.--Created tableau dashboards summarizing complex data.--Extensive Epic Clarity usage clinical and financial.--Client’s claims database was on Teradata. I developed a cross platform data store combining clarity (sql server) and teradata which greatly improved efficiency and accuracy. This required strong subject level expertise of medical claims and billing.

Oklahoma City, Oklahoma, Us

•Create Epic clarity SQL for large and small projects and port it into an azure databricks environment for subsequent use in Power BI•Generate or troubleshoot reporting workbench reports in hyperspace•Mentor junior team members by troubleshooting or creating Crystal reports side by side with Epic clarity data•COGITO SQL•Caboodle•Slicer Dicer•Power BI and DAX

Urbana, Il, Us

•Remediated 1,000 + reports for use across different service areas using any combination of Crystal Reports, Cogito (BOE or ECI) Client was opening additional service areas. •Required above average SQL and Clarity skillsets. •Functional areas included all areas of the clarity data model.Specialties: Pharmacy, Access, Business analytics, Claims, CPT,Crystal Reports, Data, Database Administration, Database, DRG, Epic Clarity, ETL, HCPCS, Hospital Billing, ICD-10, ICD-9, Microsoft Access, Pharmacy, Practice Management, Professional Billing, Revenue Cycle, Revenue Recovery, Reverse Engineer, SQL, SSIS, SSRS, Tableau

Oakland, California, Us

•Initially contracted to design HB and PB financial extracts from Epic Clarity for a third party vendor •Additional assignments were completed as assigned (all Epic Clarity related). These assignments were diverse and included multiple diverse modules (Hospital Billing, Professional Billing, Pharmacy, Cost Accounting, Ambulatory, Inpatient Data Models and others). •Client’s database platform was Teradata. I also converted queries between platforms and became proficient in TeradataSpecialties: 340b Pharmacy, Ambulatory Surgery Center (ASC), Business analytics, Claims, CPT, Crystal Reports, Data, Database Administration,Database, DRG, Epic Clarity, ETL, HCPCS, HIPAA, Hospital Billing, ICD-10, ICD-9, Managed Care, Microsoft Access, Oracle, Teradata, Pharmacy, Professional Billing, Revenue Cycle, SQL

•Created EPIC Clarity extracts from multiple health systems across the country for eventual load into Advisory Board products. •Functional areas included Professional Billing, Tapestry / Managed Care, Claims, Pharmacy, Ambulatory and Inpatient Data ModelsSpecialties: Ambulatory Surgery Center (ASC), HEDIS NCQA, Business analytics, Claims,CPT, Data, Database, DRG, Epic Clarity, ETL, HCPCS, Hospital Billing, ICD-10, ICD-9, Managed Care, Medicare, Oracle, Pharmacy, Practice Management, Professional Billing, Reverse Engineer, SQL

Oakbrook Terrace, Il, Us

•Data Architect and IS Director for healthcare revenue recovery company serving 350+ hospitals nationwide. This included managing a staff of five •Designed and implemented data warehouse containing over one BILLION healthcare claims. •Implemented Tableau and Tableau Online across 10 users. This included ETL management, dashboard creation, and publishing all via automated routines. •Envisioned, designed, and managed several automated workflow solutions that programmatically calculated expected reimbursement for medicare and select commercial payers as well as denials management for select clients. •Automated AR valuation process for the company’s inventory whereby eliminating the need for hours of manual work weekly •Extensive SQL server usage as well as SQL Server Integration Services (SSIS).Specialties: Access, Ambulatory Surgery Center (ASC), Business analytics, Charge Capture, Claims, CPT, Data, Database Administration,Database, DRG Calculation, Epic Clarity, ETL, HCPCS, HIPAA Suite, Hospital Billing, ICD-10, ICD-9, Managed Care, Medicare, Microsoft Access, Monarch, Oracle, Professional Billing, Provider Statistical & Reimbursement Report (P S & R), PSR, Revenue Recovery, Reverse Engineer, SQL, SSIS, Tableau

Englewood, Co, Us

Provided data architect related work for multiple data warehouses and data marts on a contract basisSpecialties: Microsoft Access, PDF, OCR, ETL Data Warehouse

Rochester, Minnesota, Us

•Extracted and migrate Epic Clarity database data from a large multi hospital system (using Oracle) to the Mayo Clinic's Enterprise Data using Trust (using DB2) as part of an acquisition by Mayo Clinic. •Created, manage, and utilize thousands of extensive SQL scripts covering the entire ETL spectrum. •Creating and re-creating multiple reports from newly transferred data to a dashboard based reporting tool.

Chicago, Illinois, Us

Manage financial analysts in support of the medical groups financial reporting objectivesData Warehouse Architect •Using SQL Server, designed and maximize use of professional billing data warehouse combing 48+ disparate data sources •Over 350 physicians and 35 million in monthly revenue •Designed and manage nine “data marts” and all associated ETL routines in support of this •Streamlined month end reporting and physician satisfaction exponentially buy utilizing data warehouse •Also interfaced hospital systems with this data warehouse for downstream revenue analysis •Certified by EPIC in both Clarity Resolute Hospital and Resolute Professional Billing and report writing •Significant ability to reverse engineer existing systems for inclusion into warehouse or other uses.Small Database Architect --Created multiple mission critical standalone databases applications primarily with Microsoft Access (2003 /2007 / 2010) •Created and manage multiple 340b pharmacy programsAct as a resource for multiple departments across the health system (physician and hospital)Provide around the clock availability in order to maximize system up timeSystem manager for Sure Decisions managed care /expected payment system (for six hospitals) •Maintain Sure Decisions managed care product (programming contracts for expected reimbursement & system maintenance) •Created extensive reporting utilities and tools in support of this •Support and enhance an “inherited” contract management database using MS Access and SQL Server

Chicago, Illinois, Us

Calculated and monitored general ledger contractual amounts for Medicare, Medicaid, and commercial payers ($180 million monthly).Monitored payer payment patterns by analyzing trends and utilizing payer contract / managed care system with extensive programming.Programed automation routines between multiple systems to allow for complex data analysis. Created extensive documentation.Extensive data manipulation, report writing, automation, and analysis with MS Access, SQL Server, Crystal Reports, Exselsius, Boston Workstation, Monarch, and Meditech. Created and presently manage extensive Blue Cross database & business intelligence system (for twelve hospitals) providing business intelligence never before available. This was responsible for recouping several million dollars in lost reimbursement.Wrote interfaces with complex specifications to both internal and external systemsCreated program for and managed transfer DRG revenue recovery for six hospitals. Utilized “Florida Shared” (medicare common working file) system. Created automated screen scraping interface in support of this.Created several automated routines that verify and / or enhance Meditech proration rules. Participated extensively in month end financial close process. Streamlined month end process from three days with multiple people to 30 minutes with one person.Extensive use of system data warehouses (writing reports as well as designing extensive data validation routines).Envisioned, designed, and created extensive staff ATB and work flow management system that presently manages over $450 million across 45 users (hospital billers) weeklyEnvisioned, designed, and created innovative dashboard management reporting systems integrating several disparate data sourcesTaught multiple classes to staff and act as a resource for high level and / or difficult projects

•Designed, created, and supported extensive reporting tools and databases. •Heavy emphasis placed on databases, ODBC, and a firm understanding of the business aspect of HMOs and capitation. •Designed unattended enterprise reporting system that combined IPA and HMO data from multiple platforms.

•Designed, created, and supported extensive reporting tools and databases.

Masters, Health Administration

B.S., Marketing

Him / Medical Records / Coding

Paramedic, Paramedic (Emt-P)