Report Writer with over sixteen years experience in all phases of Data Analysis, Business Systems Analysis, Reporting Analysis and Reports Development working exclusively with Crystal Reports, SQL, Business Objects XI, BOE scheduling, ACCESS and EXCEL. Certification in Epic Clarity Data Model Ambulatory with over 7 yrs experience with module. Recognized talent for determining customer needs and effectively translating those needs into software solutions. Expertise knowledge of Chronicles, Clarity, EpicCare Ambulatory, Clarity Compass and other Epic Reporting tools. Technical ability in SQL, PL/SQL, stored procedures, views and packages. High-energy achiever thrives in challenging situations, self-motivated, detailed-oriented with effective communications skills.

Technical Skills:

Certifications: Epic Clarity Data Model – EpicCare Ambulatory (Version: 2015)

Clarity Data Model – EpicCare Ambulatory Epic 2015 NVT (Epic 2017)

Clarity Data Model – General Epic 2017 NVT (EpicCare)

Languages: SQL, Java, JSP, Servlets, HTML, JavaScript, COBOL, COBOL II, JCL

Database: SQL Server 2005, DB2, Business Objects XI, Access, Oracle, DB/DC, VSAM, IDCAMS

Tools: Crystal Reports XI /9.0, SSRS – SQL Server Reporting Services (Management Studio express), Infoview, Visio, Microsoft Project, PowerPoint, Word, Excel, TOAD, TSO/ISPF, Panvalet, Expediter

Professional Experience:

Scripps Health (Report Writer Consultant) 10/2017 – present

Responsible for developing PACO Quality Metrics extracts, including writing SQL queries against a Caboodle data warehouse, for Epic and Non-Epic data.

Produced both Healthy Planet and Ambulatory, using reporting tools such as Reporting Workbench, Crystal Reports.

Worked on Community Connect Project using Organization Filtering to determine which organizations

should have access to the data and assisted with the Affiliate’s reporting needs. Duties including modifying Crystal and Reporting Work Bench Reports.

Created new and modified existing reports and extracts using Clarity, Caboodle and Epic-Business Intelligence (Webi, Universes).

St Luke’s University Health Network (Report Writer Consultant) 10/2016 – 10/2017

Responsible for developing and modifying existing Epic reports. Tools used included SQL, Crystal and Business Objects.

Duties include complete setup of Epic-Crystal integration processes including server processes, BOE scheduling, Hyperspace template configuration, and report creation.

Served as liaison between leadership and project team regarding reporting matters.

• Assist reporting team with Reporting Workbench Reports and Radar Dashboard creation, issues, and questions.

• Responsible for Ambulatory, Cadence and Healthy Planet reporting.

Responsible for producing Ambulatory Reports related to Lab Orders and results. This included both new clarity reports and extracts. Also, made modifications to existing Epic clarity foundation reports and Reporting Workbench reports.

I produced Crystal Reports, including using SQL. I made modifications to Reporting Workbench Report and Radar Dashboards.

University Of San Diego Hospital (Report Writer Consultant) 4/2016 – 11/2016

Responsible for Community Connect Affiliate’s reporting needs. Duties include meeting with affiliates and determining reporting needs. Gathered report specifications for dashboard, reporting workbench and crystal reports. Applications worked on included Professional Billing, Cadence and Ambulatory.

I created new reports, adhoc reports and data extracts.

Developed new and modified existing Epic reports. Tools used included SQL, Crystal and Business Objects.

Duties included being responsible for reporting on Inpatient and Outpatient, Pharmacy Medication Orders Dispensed. I made modifications to Epic Clarity Foundation Reports and created new crystal reports and extracts. Also, modified Reporting Workbench Reports. Additional tools used were recordview, hyperspace, SQL, Crystal and excel.

Mayo Clinic (Report Writer Consultant) 12/2015 – 4/2016

Responsibilities include meeting with Subject Matter Expert to determine Reporting needs including Reporting Work Bench, Dashboard and Clarity Reports. Duties include writing up report specifications.

Responsible for developing Clarity Reports for Optime, Anesthesia, Radiant and Cupid. Tools used included SQL, Crystal and Business Objects.

University of Wisconsin Hospital & Clinics (Report Writer Consultant) 6/2015 – 12/2015

Provide Epic Resolute HB report writing, data extraction, and support for system conversion. Modify existing reports and create new Epic Resolute HB reports. Wrote Crystal reports and oracle SQL queries.

Led and mentored team of Clarity report writers and Reporting Application Coordinators.

University Of San Diego Hospital (Report Writer Consultant) 7/2014 – 6/2015

Responsible for producing Epic Clarity extracts related to the High Value Healthcare Collaborative.

It consisted of a consortium of 18 healthcare delivery systems. Duties included data extraction, mapping/build,

trial submission and data validation. The tools used are SQL Server, Crystal and Business Objects, including

SQL stored procedures, views and data marts.

Responsible for PQRS Reporting. Duties included making modifications to Epic Foundation Reports and creating new reports. PQRS reporting reflected information on the quality of care to Medicare patients. It included data that covered Physician Quality Reporting.

Cedar Sinai (Report Writer Consultant) 10/2013 – 7/2014

Responsible for the creation of Clarity Reports and Data Extracts using Crystal Reports XI and SQL.

Duties included utilizing knowledge of Epic utilities for report creation, maintenance including ability to determine source data and ETL process.

Experience in designing, developing, and delivering reports to end users

Proficiency in healthcare data

Responsible for producing Hospital reports reflecting inpatient visits, quality of care, efficiency and re-admissions.

Duties include producing Inpatient Reports utilizing smart-data elements and flowsheet rows from nursing documentation.

Duties include formulating business reporting solutions, creating reports and extracts to meet the customer’s needs

Produced reports extracting OpTime, Willow, Clinical Documentation, Clinical Orders, eMar data.

Produced extracts such as Inpatient Core Measures, Epidemiology Extracts, Billing and many more.

University Of Michigan Health Systems (Report Writer Consultant) 4/2011 – 10/2013

Responsible for the creation of Clarity Reports and Data Extracts using Crystal Reports XI and SQL.

Duties include analyzing work flows and understanding policies procedures and constraints of the clinical or business operations related to reporting requirements.

Consults and makes recommendations to business and technical groups at all levels to define requirements, evaluate data technology needs and formulate solutions.

Duties included utilizing knowledge of Epic utilities for report creation, maintenance including ability to determine source data and ETL process.

Developed Cadence, ADT, HB, OpTime and PB reports.

Validated system build with key stakeholders.

University Of Kansas Medical Center (Report Writer Consultant) 2/2010 – 4/2011

Responsible for the creation of Crystal Reports/SQL including the design, documentation, development, testing, implementation and ongoing support.

Primary contact to troubleshoot problems and questions from end-users regarding Epic reports and reporting functions.

Developed test plans and executed test scenarios to validate data on the reports.

Assisted in creating a Diabetes Registry Data Mart and for producing reports from it.

Produced Ambulatory Reports and Meaningful Use Reports.

Cornerstones of Care (Consultant) 1/2009 – 2/2010

Developed and created reports in Crystal Reports XI and SSRS – SQL Server Reporting Services in support of the healthcare provider system which profiles the healthcare system that tracks the client/ patient information, creating views in stored procedures.

Duties included using T-SQL to create stored procedures, table joins, views, select queries and aggregate functions.

Extracted data and performed data analysis of their SQL Server Database procedures and Crystal Reports that the end users work with performed updates to the system of information that has been out on the database, and permitted access to data that is currently being reviewed for analysis for Foster Care reporting, extracting information regarding the client profiles and notes on the clients, patient info and insurance info

Developed reports in Crystal Reports XI from data extracted from the SQL Server Database that determine clinical professional follow through regarding the performance of accurate follow up and that the information is in the database, to include reporting information regarding discharge, assessment and follow up documentation to guarantee that the clients are receiving the proper care, and in so extracting this data, making sure that the patients are receiving the correct care

Developed reports in Crystal XI that determine patient clarification and reporting discrepancies in the SQL Server database for follow up and investigation.

St Luke’s Hospital (Consultant) 2/2008 – 1/2009

Responsibilities for supporting the Star application. Automated manual processes, which improved the workflow processes and the quality of service. In addition, duties included call center computer support for medical clinics.

Responsibilities include analysis, testing and implementing system solutions to achieve corporate goals and standards. Produced billing financial reports using SQL, Business Objects, Access and Excel.

Tasks include supporting a Manhattan application. Produces weekly, monthly and quarterly financial reports. Responsible for database queries and making recommendations for process improvements.

Business Systems Analyst (Consultant) 3/2007 – 1/2008

Assigned to Halls Department store responsible for assisting their team implementing a new Retail Inventory Sales Application and for creating SQL and Access Reports.

Consulted with users to identify current operating procedures and clarified program objectives.

Tasks included application testing and analysis. Responsible for creating, maintaining, and updating procedures.

Performed quality audits and various types of testing including unit, system, and user acceptance testing.

Mosaic Business Systems Analyst (Consultant) 2/2006 – 3/2007

Developed applications to streamline management tasks, reporting functions, scheduling and coordinating efforts to achieve project goals.

Analyzed financial data and produced financial reports.

Responsible for developing reports using Crystal Reports, Access, SQL and Excel.

Developed the design and architecture for an Oracle database.

Clark County Regional Justice Center BSA 2/2005 – 2/2006

Responsible for the analysis of a new Marriage Bureau Licensing system.

Worked with vendors gathering requirements, user needs and training requirements.

Responsible for a SQL database and reporting needs.

Developed applications using SQL, HTML, Oracle and Crystal Reports.

Did maintenance to COBOL programs.

Las Vegas College Adjunct Computer Instructor 3/2004 – 1/2005

Taught various computer courses in the undergraduate program.

Managed and supervised the classroom.

V3Media Programmer / Analyst 5/2001 – 3/2004

Planned, organized and coordinated activities related to the implementation of a "Video on Demand" kiosk and consumer web-based application.

Functioned as a team member assisting in the analysis, design, development and implementation of the Kiosk application and other web-based applications.

Developed design and architecture for Oracle databases used in the applications.

Responsible for developing applications using COBOL and DB2.

Produced inventory and sales reports using Crystal Reports.

Major Projects included:

oPerformance Appraisal Application

oSole developer of an application that allowed managers access to an intranet based employee evaluation and appraisal system.

oMet with managers and other stakeholders to gather information, propose and get approval to start development.

oWrote all code including system and performance testing, database hooks, GUI and business logic

oInventory Control System (Inventory / Sales / Order Entry tracking)

oWorked in a team environment on an application that tracked and fulfilled customer orders from the Video on Demand kiosks.

oParticipated in the complete development lifecycle from requirements to deployment.

oDeveloped web-based applications using Java and related tools.

Environment: Java, JSP, JavaScript, PL/SQL stored procedures, Oracle, HTML, CSS

MPower Communication Project Leader / Application Developer 3/2000 – 5/2001

Responsible for leading analysis, design, coding, testing and implementation of applications. Daily role included:

Responsible for new development and maintenance to Internet and Intranet sites.

Maintained an Oracle database.

Projects included:

oWorked on a team designing and developing a Customer Service Application used by the customer service department to put in orders for customers telephone service, repairs and requests.

oSolely responsible for design, development and deployment of an intranet based Service Request Application used by various departments which allows them to put in work requests to the IT department.

oConsulted with clients to identify current operating procedures and clarified program objectives.

oDeveloped project plans and submitted plans to Client for approval.

Environment: JSP, HTML, JavaScript, Oracle, Tomcat / Apache, UNIX

UMB Bank Senior Programmer Analyst 4/1999 – 3/2000

Responsible for technology planning and implementation of an Investor Cash Management Application which allowed investors to be able see the status of their investments online on the web.

Served as the primary support contact person for this application converting this existing legacy mainframe system to a web based application.

Converted COBOL/CICS/DB2 programs to web based front end creating several HTML pages using Java Servlets for page functionality & Transfuse as the middleware between the MF and web components.

Troubleshoot and resolved operating system, database and network problems.

Environment: Java Servlets, HTML, CICS, Transfuse, DB2.

H.L.W. Associates Consultant 7/1992 – 4/1999

Worked as a consultant developing computer applications to assist corporations including Sprint, Yellow Technology Services, Clark County School District, State of Nevada, Citibank, J.B. Hunt, Logistics Division, National Association of Insurance Commissioners, Kemper Insurance and Abbott Laboratories. Duties included the following:

Developed applications using COBOL, DB2, JCL and IMS DB/DC.

Responsible for the development and maintenance to a Credit Card application.

Responsible for new development and maintenance to many COBOL mainframe applications.

Researched most viable options for software applications to ensure goal achievement.

Presented a clear choice of business solutions to clients for evaluation.

Responsible for Y2K enhancements and testing.

Education:

MBA - Keller Graduate School of Management

Bachelor of Arts: Business - Barat College, Chicago, Illinois

Contact this candidate