Ed Schmitt Email and Phone Number

Healthcare data expert.Project manager for current warehouse from RFP through vendor selection, design and development, ETL, validation, testing and production delivery.Responsible for billing claims data warehouse file load process to warehouse, ensuring ETL nightly routines to staging and production servers for over 80 hospitals in North Texas.Daily operational routines include data processing audits, statistical and trending analysis, problem identification, solution planning, data warehouse projects - new data resources management.In support of application development projects, reporting, measure methodologies, and process improvement, create SQL script for table builds, stored procedure development, and views. Responsible for all SQL script producing internal and external customers reporting routines, standard and ad hoc custom report requests, supporting research projects.Approve data releases, created data QA release packets and data dictionaries.Load data to BI tool Qlikview and ensure customer document and dashboard updates.Write database documentation including: data standards, procedures, methodologies and definitions, update data dictionaries for new algorithms and flags.SAS programming and output processes, program updates - version controls, audits, and output loads to warehouse. Responsible for development of CMS quality reports, reading technical specifications, measure methodology, and warehouse development, through to customer reports and dashboard updates. Implementation includes: http://www.qualityindicators.ahrq.gov/Modules/https://www.cms.gov/Medicare/Quality-Initiatives-Patient-Assessment-Instruments/HospitalQualityInits/Measure-Methodology.htmlResponsible for regional master patient index. Oversee processing from export load files to specification for index matching and of importing results to warehouse. All auditing, research requests, reporting routines, value adds, and ad hoc reporting is my responsibility.

Responsible for UT Decision Support - Hospital Initiative, as representative of HSP, facilitated the gathering of information, consolidation, maintenance, validation, user documentation of internal databases, data references, data dictionaries, data layouts, portal draft builds, interactive report designs, and regular team meetings.Planning and implementation on streamline of merging data and building processes and the management of the internal databases. This requirement was to bring clinics and physician data together with hospital data.Business strategic planning projects included the following service lines: Neurofibromatosis, Pulmonary Rehab, Psychiatry, OB/Gyn, and Cancer. This work included market and financial analysis, profitability, growth strategies, and presentations, as well, building internal relationships.

Under the general direction of Hospital Decision Support Services, responsible for the maintenance and updating of the Enterprise Wide Eclipsys Sunrise Decision Support Manager (TII) system. Maintain and verify accuracy of monthly posting to modules of Eclipsys SDSM (TII) assuring system reconciles to SMS source documents/systems.Ensure that information is accurate, timely and issued in a manner responsive to management needs.Set up and maintain required records, documents, reports, correspondence specifications and other data related to studies and analyses.Responsible for yearly budget activities related to updating of Departmental Cost Manager (DCM). Performed in-depth analyses of profitability, utilization, costing by service line, DRG, attending md, etc.Responsible for testing of new releases of Eclipsys Sunrise Decision Support Manager (TII) ensuring that all “bugs” are resolved before going live.Maintained up-to-date technical knowledge by attending Eclipsys sponsored webinars and conferences.Drafted ETL process, report designs, and data specifications and implemented workplan to utilize the hospital intranet for report query of KPI, Finacials, and Operations Statistics.Always continuous in efforts toward learning hospital budgeting, operations, and capital expenditures. I had strong focus toward customer needs with emphasis on hospital and center profitability though analysis of cost, productivity, and key performance indicators.This system was my responsibility to grow and ensure integrity. All hospital and customer reporting came through me. Most reports were based on qualification of certain ICD9 diagnosis or procedure or revenue or charge codes. Population qualification sets and required elements were downloaded to Excel and reported as summary including standard financials to easily highlight profitability and loss or production/volume. Records were also exported to Excel for easy pivot table construction and further analysis.

Committed to MPI cleanup goals for University hospitals St. Paul and Zale Lipshy and providing system information that is consistent, complete, and accurate. Developed and maintained patient MRN merge process. Created the MPI project Access database. Simplified merge documentation process through the creation and use of forms. Provided monthly statistics relating to merge activity and hospital registration totals and error rate.As HIM IR Support, responsibilities include: extracting and manipulating data, compilation, validation, and distribution of HIM census reports, physician delinquent reports, Agency and Contract Labor reports, MD transcription activity reports. Ad hoc report builds using HIM SoftMed application.As EMPI supervisor, managed daily workload and tasked duties relating to MRN merge productivity and link processing. Drafted policies and procedures for all processes currently in place relating to MRN management, processing in systems and subsystems, for maintaining the accuracy and integrity of the MPI system.