SAIRAJ GUPTA

acsaz5@r.postjobfree.com

508-***-****

PROFESSIONAL SUMMARY

Experience with with both Clinical and Revenue Cycle Reporting Data Models (EpicCare Inpatient, EpicCare Ambulatory, Optime, Anesthesia, Cadence, HB, PB ADT, Prelude etc)

Experience in configuring and running reports for Meaningful Use Stage1 and Stage 2.

Experience in using Epic Hyperspace and Understanding of Chronicles.

Expertise in working with Crystal Report XIR2/2008 for creating complicated Analytical reports.

Experience in designing and implementing operational reports in Epic Reporting Workbench - report creation, template modification through template manager.

Clear understanding of clarity data structures and expert in using various epic tools – record viewer, clarity data dictionary, table search, column search.

Worked with the Clarity data distribution mechanisms such as EPIC-Crystal Integration and MyEpic.

Involved in Migrating Reports from one Environment to another like POC/TEST/PROD.

Experience in Publishing, Scheduling reports on Infoview and Central Management Console.

Good knowledge and experience in using Oracle 10g/9i, MS SQL Server 2008/2005.

Performed Unit Testing, System Testing for new and existing applications. Involved in Integration Testing, User Acceptance Testing and provide defect reporting and tracking.

EDUCATION

MBA /MASTERS IN INFORMATION SYSTEMS– University Of Massachusetts – Dartmouth, North Dartmouth, MA

Bachelors of Science, Osmania University, Hyderabad, India

PROFESSIONAL EXPERIENCE:

UNIVERSITY OF MINNESOTA PHYSICIANS, MN May 2015 to Oct 2015

Epic Clarity Reporting Analyst

Developed complex reports for Neurology and Renal Departments like eGFR patients and Hep-c Patients using crystal reporting service and delivered through ERV.

Created complex analytical reports in Inpatient and Ambulatory modules like Identifying Diabetic Patients, Order set utilization By Providers, Ordered labs and procedures.

Created Family Med-Chronic Pain Panel report for capturing patients with PHQ9 score and published using SQL parameters

Created Crystal reports implementing operations of totals, subtotals and cross tabs for displaying aggregate data.

Created many reports for Willow for tracking orders, Outreach Dispenses and MAR Bar code compliance by Providers

Designed various reports based on Database - tables, SQL commands, views, stored procedures, Business Objects Universes for data analysis.

Created custom professional billing reports for single billing offices such as Denial reports, Work queue reports, Medicare and commercial payor reports.

Updated the reports for the transition from ICD9 to ICD10.

Created custom hospital billing clarity reports for post go live requirements such as claims summary, Average revenue reports, denial reports etc.

Built reports on Flowsheets Summary, Office visit with a printed AVS, Encounters with Medication list, Procedure orders by provider, Medication orders by provider, Order turnaround time, Smart phrases, etc.

Developed Epic standard meaningful use reports and also involved in building custom meaningful use reports mainly for problem list and smoking status data.

Responsible for running the batch jobs to populate the meaningful use tables from the text side for the quality measure reports.

Developed inpatient related reporting workbench reports and modified clinical epic released templates.

Created various temp tables as per the design for the reports that depend on the diagnosis codes

Provided classroom demonstrations to analysts, report writers, physicians and end users on dual coding reporting and workflow

Developed crystal reports involving stored procedures. Followed all the standards of the Enterprise for creating, publishing the packages and reports.

Developed Enterprise level crystal reports which can be run for multiple physicians and locations to track Physicians Activities and Performance

Used Info view and Central Management Console to view, schedule, and keep track of published reports.

Published the reports in the Info view portal and scheduled for users at Enterprise level, trained the users on running the reports ad hoc and exporting the results.

Trained the users in creating RWB reports for their routine use.

Mercy Medical Center, MD Aug 2014 to Apr 2015

Epic Reporting Analyst

Worked with the Revenue Cycle Reporting team to develop various reports on Claims, Transactions, Workqueues, Hospital coverages, Denials.

Worked with HB reports include GL AR Summary, Users forcing claims, No GL string report, Quarterly Medicaid paid claims.

Part of the team for EPIC 2012 upgrade. Validated reports after the upgrade.

Updated over 50 reports to remove depreciated fields and substituted with new logic.

Created various reports for Epic Care Ambulatory, Inpatient, ASAP and ADT, Prelude and Cadence modules.

Responsible for analyzing, configuring, documenting and testing Epic Clarity and Chronicles reports.

Developed operational reports by using Report Workbench templates and also modified Report Workbench templates to meet the requirements.

Created Crystal reports implementing operations of totals, subtotals and also other fields like maximum, minimum, average etc.

Worked on Several ADT and Cadence Reports like Daily Census, Late Admissions and Encounters by location and department.

Created several reports on Order, Order results, specimens, patient FYI flags, tests, turnaround times, component results, microbiology and quality control.

Gathered report requirements from users, developed report specification documents, created and validated reports and published them in infoview.

Provided relevant information access for physicians, nurses, therapists or any other provider in the hospital setting.

SUTTER HEALTH, CA Feb 2013-May 2014

Reporting Analyst (Crystal Reports, Epic Clarity)

Participated in Requirement analysis, design and comprehensive build of Crystal Reports against the Clarity database for various reports which included ADT Tables, Flow sheet Groups and Data tables, Patient Information, Hospital Account Information, HIM, ROI tables, Claims related tables and many more.

Using various analytical and reporting tools, participated in database development, Query languages & Database and spreadsheet tools.

Analyzed and implemented the functionality and operations of various systems to determine standard and ad hoc reporting capabilities per organizational needs.

Prepared detailed technical and user documentation from which reports, downloads, and extracts will be written.

Involved in designing and maintaining databases to ensure the optimum performance of ambulatory systems.

Provided expert knowledge of the SQL tables as they relate to the hospital accounting and clinical applications.

Had regular meetings with IT clinical analyst and requester to understand the exact requirements for the report.

Built the reports using the tools like Crystal reports XI R2 & SQL Server.

Designed, programmed and troubleshoot of Epic enterprise scheduling software's and ambulatory services.

Developed queries in SQL Server RDBMS rather deal with crystal reports directly.

Submitting the collected sample query data from SQL Server for Validation Purpose.

Had very good acquaintance in using and understanding Record Viewer, Clarity Dictionary, INI Search, SQL Server, EPIC Hyperspace & Crystal Reports.

Responsible for efficient and effective reporting, and ongoing modification of reports and reporting projects for process improvement.

Contact this candidate