Daniel Shoemaker personal email
- Valid
Daniel Shoemaker phone numbers
A 𝐤𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐰𝐨𝐫𝐤𝐞𝐫 is one that can apply significant subject matter expertise alongside of technology and make a substantive impact. In two words or less…. that’s me.Computers and data technology have evolved to the point that there are countless ways to complete a data or workflow task. •In databases, this includes large platforms (SQL Server, Oracle, Access, SSIS, SSRS, etc). •In presentation, samples include Crystal Reports, Business Objects, Tableau, Power BI, DAX, MS Office, visual basic, and many others. •In data collaboration, sharing or storage….. there’s a cloud for that (Azure, AWS, Snowflake)All above are easily in reach for almost any industry, organization, or individual. There are a lot of fabulous “mouse traps” today. You can safely assume there is a software or technology available to aid in solving a business problem.A 𝐡𝐞𝐚𝐥𝐭𝐡𝐜𝐚𝐫𝐞 𝐤𝐧𝐨𝐰𝐥𝐞𝐝𝐠𝐞 𝐰𝐨𝐫𝐤𝐞𝐫 solves problems. Having an inert ability to see beyond what the “ask” is combined with the inner drive to be timely in delivering solutions that “helps keep lights on”. If you deliver a solution too late… did it do any good? Knowledge workers are motivated to solve problems and contribute to the success of all. They also listen twice as much as they talk.A 𝐌𝐚𝐬𝐭𝐞𝐫𝐬 𝐢𝐧 𝐇𝐞𝐚𝐥𝐭𝐡 𝐀𝐝𝐦𝐢𝐧𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 fast tracks you to think at a different level. Reimbursement, regulations, competition, Healthcare Analytics all are taken to a higher level. There are no shortcuts here.𝐂𝐥𝐢𝐧𝐢𝐜𝐚𝐥𝐥𝐲 𝐬𝐩𝐞𝐚𝐤𝐢𝐧𝐠…it’s all why we are here. •As a paramedic, I watched life start and stop all in one shift. •I spent several years working inside busy emergency rooms and hospital critical care units.Business Intelligence Engineers are motivated when they 𝐛𝐫𝐢𝐧𝐠 𝐢𝐭 𝐚𝐥𝐥 𝐭𝐨𝐠𝐞𝐭𝐡𝐞𝐫…. and it makes a difference.•Coming to work one day to discover you saved a health system over a 𝐦𝐢𝐥𝐥𝐢𝐨𝐧 𝐝𝐨𝐥𝐥𝐚𝐫𝐬. What a day.•Envisioning, designing, and building an automated data warehouse with over a 𝐁𝐈𝐋𝐋𝐈𝐎𝐍 𝐜𝐥𝐚𝐢𝐦 lines from 250 + hospitals that transformed operations and help recover enormous underpayments for struggling health systems. I would love to work with you. Medicare, DRG, Managed Care, Access, Epic Clarity & Caboodle, Crystal Reports, Data, Claims, Revenue Cycle, Practice Management, PSR, Revenue Recovery, Inpatient, Outpatient, DSH, Population Health, Hospital Billing, Professional Billing, Healthy Planet.
Health Data Partners, Inc.
-
PresidentHealth Data Partners, Inc. Sep 2014 - PresentCreated 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
-
Epic Bi Developer Population Health (Contract)Northwestern Medicine Feb 2024 - Aug 2024Chicago, 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. -
Epic Clarity Report Developer And Data Architect & Athena Health Report Developer (Contract)Amita Health Feb 2015 - Aug 2024Chicago, 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. -
Bi Developer (Contract)Catholic Health Services Jul 2022 - Dec 2023Lauderdale 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. -
Bi Developer – Clinical Risk Area -Aka Population Health (Contract)Kaiser Permanente Jul 2021 - Jun 2022Oakland, 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. -
Business Intelligence DeveloperIntegris Health Jul 2020 - Jul 2021Oklahoma 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 -
Epic Clarity Report DeveloperCarle Foundation Hospital Mar 2019 - Aug 2019Urbana, 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 -
Epic Clarity Report Developer - ContractKaiser Permanente Oct 2017 - Dec 2018Oakland, 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
-
Epic Clarity Report / Data Script Writer (Independent Contractor)The Advisory Board Nov 2016 - Apr 2018•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 -
Data Architect And Director Of I.S.Vhc, Inc. Apr 2014 - Feb 2017Oakbrook 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 -
Data ArchitectCatholic Health Initiatives Oct 2014 - Dec 2015Englewood, Co, UsProvided data architect related work for multiple data warehouses and data marts on a contract basisSpecialties: Microsoft Access, PDF, OCR, ETL Data Warehouse -
Epic ConsultantMayo Clinic Jul 2014 - Dec 2014Rochester, 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. -
Manager Of Financial Analysts And Data ArchitechtPresence Health Jan 2011 - Mar 2014Chicago, Illinois, UsManage 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 -
Senior Reimbursement AnalystPresence Health Feb 2008 - Dec 2011Chicago, Illinois, UsCalculated 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
-
Senior Programmer AnalystAccord Health Network Aug 1998 - Aug 1999•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.
-
Business AnalystMid America Health Partners Aug 1997 - Aug 1998•Designed, created, and supported extensive reporting tools and databases.
Daniel Shoemaker Skills
Daniel Shoemaker Education Details
-
Governors State UniversityHealth Administration -
Northern Illinois UniversityMarketing
-
Joliet Junior CollegeHim / Medical Records / Coding
-
South Suburban CollegeParamedic (Emt-P)
Frequently Asked Questions about Daniel Shoemaker
What company does Daniel Shoemaker work for?
Daniel Shoemaker works for Health Data Partners, Inc.
What is Daniel Shoemaker's role at the current company?
Daniel Shoemaker's current role is Business Intelligence Analytics Engineer| Epic Clarity, Athena Health and other Health Data SQL.
What is Daniel Shoemaker's email address?
Daniel Shoemaker's email address is ds****@****ail.com
What is Daniel Shoemaker's direct phone number?
Daniel Shoemaker's direct phone number is +195294*****
What schools did Daniel Shoemaker attend?
Daniel Shoemaker attended Governors State University, Northern Illinois University, Joliet Junior College, South Suburban College.
What skills is Daniel Shoemaker known for?
Daniel Shoemaker has skills like Data Warehousing, Peoplesoft, Epic Systems, Payments, U.s. Health Insurance Portability And Accountability Act, Medicare, Interfaces, Hipaa, Data Analysis, Healthcare, Software Documentation, Ehr.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial