Daniel Shoemaker Mha's Email Addresses & Phone Numbers

President @ Health Data Partners, Inc. Formed Health Data Partners, Inc as a legal entity to use with clients desiring to work on a "corp to corp" basis.Specialties: 340b Pharmacy, Access, Ambulatory Surgery Center (ASC) Business analytics, Claims,CPT Crystal Reports,Data,Database Administration,Database,DRG,Epic Clarity,ETL,HCPCS, HIPAA Suite, Hospital Billing, ICD-10, ICD-9, Managed Care, Medicare, Microsoft Access, Monarch, Oracle, Pharmacy, Practice...

President @ Health Data Partners, Inc. Formed Health Data Partners, Inc as a legal entity to use with clients desiring to work on a "corp to corp" basis.Specialties: 340b Pharmacy, Access, Ambulatory Surgery Center (ASC) Business analytics, Claims,CPT Crystal Reports,Data,Database Administration,Database,DRG,Epic Clarity,ETL,HCPCS, HIPAA Suite, Hospital Billing, ICD-10, ICD-9, Managed Care, Medicare, Microsoft Access, Monarch, Oracle, Pharmacy, Practice Management, Professional Billing, Provider Statistical & Reimbursement Report (P S & R), PSR, Qlik, Revenue Cycle, Revenue Recovery, Reverse Engineer, SQL, SSIS, SSRS, Tableau USAEpic Clarity Report Developer - contract @ Kaiser Permanente •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 From October 2017 to December 2018 (1 year 3 months) Portland, Oregon Metropolitan AreaEpic Clarity Report / Data Script Writer (independent contractor) @ The Advisory Board •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 From November 2016 to April 2018 (1 year 6 months) United StatesData Architect and Director of I.S. @ VHC, Inc. •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 From April 2014 to February 2017 (2 years 11 months) Oakbrook Terrace, Illinois, United StatesData Architect @ Catholic Health Initiatives Provided data architect related work for multiple data warehouses and data marts on a contract basisSpecialties: Microsoft Access, PDF, OCR, ETL Data Warehouse From October 2014 to December 2015 (1 year 3 months) Chattanooga, Tennessee, United StatesManager of Financial Analysts and Data Architecht @ Presence Health 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 From January 2011 to March 2014 (3 years 3 months) Frankfort, ILSenior Reimbursement Analyst @ Presence Health 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 From February 2008 to December 2011 (3 years 11 months) Frankfort, ILBusiness Intelligence Developer: Epic Clarity / Cogito and Qlik Sense @ Bayhealth •Write crystal reports, SQL Stored procedures, and data extracts from Epic Clarity as well as internal data sources. •Required above average SQL and Clarity skillsets. Created and published multiple reports to hyperspace. •Create and publish QLIK Sense apps for a diverse clinical and executive audience. From March 2020 to June 2020 (4 months) Delaware, United States (worked remote)Epic Clarity Report Developer and Data Architect (contract) @ AMITA Health •Provide data architect related work for multiple data warehouses and data marts on a contract basis •Utilize and program SQL Server SSMS, MS Access, Crystal Reports, and other related BI Tools •Extensive Epic Clarity, IDX (GE Centricity), Athena Health and several other platforms •COVID 19 Dashboards and reporting. •Population Health Reporting and dashboardsSpecialties: Access, Business analytics, Claims, CPT, Advanced Crystal Reports, Data, Database Administration, Database, DRG, Epic Clarity, ETL, HCPCS, Hospital Billing, ICD-10, ICD-9, Managed Care, Medicare, Microsoft Access, Monarch, Oracle, Pharmacy, Practice Management, Professional Billing, Revenue Cycle, Revenue Recovery, Reverse Engineer, SQL, SSIS, SSRS, Advanced Tableau, Advanced Qlik Sense From February 2015 to February 2020 (5 years 1 month) Bolingbrook, Illinois, United StatesEpic Clarity Report Developer @ Carle Foundation Hospital •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 From March 2019 to August 2019 (6 months) Champaign, Illinois, United StatesBusiness Intelligence Developer @ Acumen Physician Solutions, LLC •Provided Business Intelligence Developer services on a contract basis •Primary data sources were Epic Clarity and multiple external data feeds. •Functional areas included Professional Billing and Data Extracts, and general Epic Cogito for publishing ECI reports. •Technical areas included automation, Crystal Reports, Tableau, SQL Server, SSIS, Slicer Dicer, CaboodleSpecialties: Microsoft Access, Business analytics, Claims, CPT, Crystal Reports,Data,Database Administration,Database, DRG, Epic Clarity, ETL, HCPCS, ICD-10, ICD-9, Managed Care, Medicare, Monarch, Oracle, Pharmacy, Practice Management, Professional Billing, Revenue Cycle, Reverse Engineer, SQL, SSIS From August 2018 to December 2018 (5 months) Raleigh-Durham-Chapel Hill AreaEpic Consultant @ Mayo Clinic •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. From July 2014 to December 2014 (6 months) Epic Clarity Report Developer @ Cedars-Sinai Medical Center •Provide report development and support for the Cedars-Sinai Heart Institute and other functional areas as needed. •Utilize and program Oracle, SQL Server using Toad, SSMS, MS Access, Crystal Reports, and other related BI Tools •Merge disparate data sources into actionable reports by using advanced BI and data techniques From March 2014 to August 2014 (6 months) Greater Los Angeles AreaSenior Database and Business Analyst @ Change Healthcare (formerly MED3000) •Significant exposure to business functions in managed care, physician groups, and hospital •Interacted with high level executives while assessing both business and technical environments. •Created and managed ongoing general ledger processes and interfaces ($20 million monthly) •Created and managed data warehouse ETL routines ($60 million monthly) •Created and managed extensive payment compliance mechanisms to proactively manage payer payment patterns. •Expert in data manipulation and automation. •Knowledge of and formal training in HL7 interfacing standards •Significant exposure to many scripting and database languages. •Significant experience with SQL Server, Informix, and Oracle RDBMS From August 1999 to January 2008 (8 years 6 months) Tinley Park, ILSenior Programmer Analyst @ Accord Health Network •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. From August 1998 to August 1999 (1 year 1 month) Westmont, ILBusiness Analyst @ Mid America Health Partners •Designed, created, and supported extensive reporting tools and databases. From August 1997 to August 1998 (1 year 1 month) Oak Brook, ILInformation Systems Specialist @ Saint Joseph Medical Center •Coordinated physician office installs of practice management system(s). •Created extensive custom reports and automation routines. From March 1997 to August 1997 (6 months) Joliet, ILBusiness Admin Analyst @ Ingalls Memorial Hospital •System manager for Executive Information System and Managed Care RDBMS. •Coordinated interfaces from hospital financial system to Ascent and Ascent Plus. •Created innovative enterprise reporting system from 6 different data sources, offering reporting across the health system. •Acted as internal consultant for Medical records department and completed extensive review and report which resulted in the purchase of a major medical records information system. •Initially worked in cardiac stage 2 and emergency room while attending graduate school. From November 1992 to February 1997 (4 years 4 months) Harvey, IL