New York City Metropolitan Area
P R O F E S S I O N A L B A C K G R O U N D - Health Care Information Technology professional with diverse skill-set in business intelligence, data analysis, database report writing, SQL programming, and other object-oriented programming languages and DBMS. - Expertise including database design and building, training, system testing, application support, workflow analysis and working experience in developing Web Intelligence reports and universe. - Knowledge of Epic Systems, Crystal Reports, Visual Studio, Remedy, Business Objects, Epic/Crystal Integration, Reporting Workbench & Radar, Epic Clarity Console, SAP Business Objects, Tableau 2020.1, TOAD, MS SQL Server Management Studio, Microsoft Access, Visual Basic for Applications, Turbo C, Assembly Language, Turbo Pascal, COBOL, Clipper 87, and FoxPro. - 2019 EPIC Certified Clarity Data Model (EpicCare Ambulatory, Beacon, Cadence, Radiant & Cupid) - Customized, Designed and Developed Crystal Reports, Reporting Work Bench, and Radar dashboards. E D U C A T I O N BACHELOR OF SCIENCE IN COMPUTER SCIENCE, 1987-1991 AMA Computer College, Manila, Philippines. Completed all course requirements for B.S. in Computer Science. BACHELOR OF SCIENCE IN CIVIL ENGINEERING, 1984-1986 University of the East, Manila, Philippines. Completed two years course requirements for B.S. in Civil Engineering. Epic Clarity Data Model Certifications: - Radiant and Cupid (Radiology & Cardiology) - NVT 2019 - Beacon (Oncology) - NVT 2019 - Cadence (Scheduling) - NVT 2019 - Epic Care Ambulatory (Proficient) - NVT 2019
-Provide broad technical, analysis and support to departments and managers to determine needs and adapt workflows to meet the demands of the business. -Work closely with employees to design, develop, implement, and maintain clarity, reporting workbench and webi reports.
- Validated & modified model system reports and identified advanced reporting needs with report consumers (SMEs & MD Champions); collaborated with the SMEs & Business Application teams to gather specifications and develop Clarity and Reporting Workbench reports for Radiant, Cupid, Beacon, Cadence, Ambulatory, Inpatient Orders, Infection Control, etc... - Developed ad hoc clarity reports for New York State DOH PCI Registry and PCMH program. - Developed numerous custom Reporting Workbench reports for different applications (e.g. Percentage of patients that have received a TDAP for a month Report, EMTALA for OB Triage, Rapid Response, Transfusions for OB, Rapid Response, Readmission 30 days, Length of Stay, Pneumococcal/Influenza Vaccine – Administered & Deficiency, RX Search Medications (Daily/Weekly), Medication Administration without verification, 340b (for Clinical only), E-Prescribed Med Orders Report, Medication not given, Newborns Delivery Report, Skin to Skin (Start/End) Report, TB Keyword Search, etc…) - Developed dynamic crystal reports (KPIs, Go-live critical, Optimization, & as needed) to define numerous parameters that allow users to filter and aggregate as required. Also created custom reports according to corporate standards. - Developed sets of standardize reporting templates to generate corporate standard Epic crystal reports (for Go-live critical, Optimization, & Standard) in all HHC facilities. - Installed Clarity Special Updates (SU's) almost every two months to maintain current environment integrity; run Compass Upgrade and install Hyperspace patches/new version, Reporting content, and Analytics. - Upgrade and maintain Clarity Compass, Console, and Hyperspace. - Ensure successful Clarity ETL nightly processes and troubleshoot any errors that may occur. - Reviewing and testing NOVA notes in regards to Epic SU Upgrades. - Working with report developers to identify and resolve possible discrepancies between Caché and Clarity.
Created custom MS Access Split (Multiuser) databases for Medicine & Administration department: - PCP Endorsement Database (DB system that acts as an electronic message board using SBAR for all physicians endorsing their patients to the on-call physicians for Coler & Goldwater Hospital. It also monitors Trach changes, IV, NGT/GT, Central line, ET Intubation, Extubation, blood culture panic values, advance directives, falls, occurrences such as medical errors, suicide attempts, altercations, etc..) - Medical Consults Database – (DB system that monitors attending & consultant MD’s daily/monthly consults compliance) - Antibiotic Stewardship Database – (DB system that acts as monitoring system for ID MDs if patient needs ID intervention, change antibiotics due to de-escalation, and diagnosis) - Executive Patient Safety Walk Rounds (Access database that acts as a PI/Safety that capture unit/ward & department issues) - Psychiatry Database – (DB system that monitor patient’s psychiatric history, mental status exams, Nonpharmacological treatments, & Consults/Assessments/Recommendations) - Also created Invasive Procedure DB, CPR DB, Mortality Case DB, Diabetes Mellitus DB, Acute Care Discharges/GI Bleed DB, Late Admissions DB, Panic Value (Chem/Hema/Infectious Disease) DB, DVT/PE DB, and Palliative Care DB.
- Troubleshoot HDS interfaced procedure, Abbott QC manager (Glucometer system) and workstations in the laboratory. - Responsible for daily, weekly and monthly turnaround time report, statistics & proficiency reports, annual antibiogram report using Misys CPR. - Created a database system to monitor laboratory reagents supplies and other office equipment.
- Utilized current technologies to benefit handicap patients. - Trained patients basic computer operation, hardware (how to build desktop computer from scratch) and Microsoft Office (i.e. Word, Excel, PowerPoint, Access) and other (Adobe) softwares.
- Installed and supported LANs and network segments - Installed and maintained network hardware and software. - Analyzed and isolate issues. - Monitored networks to ensure security and availability to specific users. - Evaluated and modified system's performance. - Identified user needs. - Determine network and system requirements. - Maintained network facilities in individual machines, such as drivers and settings of personal computers as well as printers. - Administered servers, desktop computers, printers, routers, switches, software deployment, security updates and patches.
- Installed and Configured CAT 5 Network Cables, Network Switches/Hubs, Workstations and Network/Local Printers on all 9 floors. - Troubleshoot network problems, AHMAC Updates, Run Remittance Advice Report for Ambulatory and Institutional, Monthly Remittance and Enrollment files, Extract Medicaid and DEA text files and send files to Block Vision and Express Scripts. - Performed hands-on fixes at the desktop level, including installing and upgrading software, implementing file backups, and configuring systems and applications. - Maintained record of daily transactions, problems and remedial action taken, and installation activities.