Stephen Ramirez Email & Phone Number

Bothell, Wa, Us

Bellevue, Washington, United States

Bellevue, Wa

Primary responsibilities include project management of medium to complex projects, working with users to define and identify system and data requirements for various data requests and data marts. Design, code and maintain clinical and business ad-hoc reports for executives, directors and managers. Develop and maintain SSIS ETL packages and custom coded extract processes used to extract and integrate 3rd party information and systems with Overlake data repository. Recent projects include development of integrated Meditech and Epic Clarity data repository. Development of all financial, material management and payroll extracts used during the implementation of Kaufmann Hall - Budget and Capital Advisor Application Suite. Designed and developed new Finance website using ASP.NET MVC technology. Design and developed API Payroll & Laborworks Time and Attendance data marts. Implementation of Tableau Server and various Tableau Dashboards. Implemented and certified as Workday report writer.

Bellevue, Wa

EPIC Clarity Data Model certifications in ADT/Prelude, Cadence, Resolute Hospital Billing and Resolute Professional Billing (v2010, v2012, v2014 & v2015). Reporting Coordinator for team of four Clarity Report Writers. Reporting Workbench and Clarity report and extract development. Custom development of Crystal Reports. Integration and data mart development of legacy and EPIC information. Participated in Go-Live implementation for both ambulatory and inpatient hospital applications.

Based in the clinical setting, primary responsibilities include project management of medium to complex projects, facilitation between physicians, clinical staff and IT staff, implementation of new cardiology clinical systems, upgrades and system changes; i.e., Cardiac Cath Lab Witt System, Lumedx Apollo System and HL7 Interfaces, Medtronics Paceart System, EPMed Electrophysiology System and Kaiser HealthConnect Medical Record System (EPIC). Development of system request for proposal, project justification analysis and vendor comparison reviews. Working with physician and clinical staff to analyze, define and understand streamlining of clinical workflow processes. Facilitate and act as system liaison for National Kaiser Permanente Cardiology System Standardization Committee. Manage and coordinate implementation and follow through of disaster recovery procedures during troubleshooting, emergencies and system outages due to network outages and virus infections. Manage and supervise data entry staff and validation processes to assure data integrity of clinical data for ACC and STS national registry submissions and clinical reporting. Assure all systems, workflows and data meet HIPAA and Compliance regulations. Develop new integrated software programs and tools to streamline and automate various clinical and information processes; provide physician and staff training as appropriate. Participate as technical resource, system expert and team member for special regional IT projects. (i.e. Regional manage desktop implementation)

Honolulu, Hawaii

Primary responsibilities included the development of integrated software solutions (relational databases, reports/spreadsheet templates, extraction SQL queries, VBA/VB functions/modules) for various financial, hospital utilization and cost benefit analysis projects. Prepared annual hospital non-payroll budgets. Developed and operated SQL queries to extract and collected data from Kaiser’s HPMS, AS400 and RXIS mainframe systems. Trained end-users and prepared all software solution documentation. Performed PC hardware configuration troubleshooting and provided software technical support to numerous hospital and regional departments. Analyzed, formatted and validated data sets and final reports prepared for executive team. Developed new, integrated software tools to streamline and automate various office and information processes.

Honolulu, Hawaii

Primary responsibilities included the development of an integrated non-payroll budget software system. Developed migration tools to convert non-payroll budget from Lotus 123 to Excel 5.0. Developed financial and statistical report templates for Physician Prescribing Profile Reports & DRG Reports. Provided technical/computer support for Asst. Hospital Administrator in finalizing Emergency Preparedness Response Procedure Manual for hospital-wide distribution, JCAHO Survey preparation, statistical data presentation and database development for Quality Assurance and NCQA Survey (April 1995). Data analyst for Kaiser Hospital Activity Based Costing Project (ABC Project-1994).