SEARCH

EPIC report developer/ BI developer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
EPIC REPORT DEVELOPER/ BI DEVELOPER
Professional Summary
  • EPIC Certified Clarity Data Model -Cadence Reporting Analyst.
  • Involved in ongoing EPIC Implementation team at Henry Ford Allegiance Health system for W A Foote hospital.
  • Proficiency in EPIC reporting workbench and RADAR
  • Proficiency in EPIC STAR data model.
  • Expertise in Developing custom Reports, utilizing formulas, setting up parameters for some dynamic reporting, creating sub-Reports, incorporating the use of graphs using crystal reports.
  • Proficient in design and development of various dashboards, reports utilizing Tableau and crystal reporting tools.
  • Developed T-SQL queries, stored procedures, functions and triggers.
  • Involved in regulatory reporting like PCMH, UDS and Meaningful use reporting.
  • Excellent communication skills, strong decision making skills, organizational skills, ability to work in a team or individually and ability to pick up new skills quickly.
Skill Highlights
  • Core Competencies:
  • Epic EHR: Clarity Database Model - Cadence application (patient Scheduling), star/caboodle data warehouse
  • ETL & Data Modeling with SQL Server Integration Services (SSIS) 2008 & 2012.
  • Developing dashboards with RADAR and share point.
  • Reports Development with reporting workbench, Crystal 2013, Tableau Reports & BI launch pad
  • Technical Competencies
  • T-SQL queries, functions and stored procedures
  • T-SQL index performance tuning
  • SAS Base Progamming, RSTAT
  • SSMS – SQL Server Management Studio 2008 & 2012.
  • MS EXCEL, MS ACCESS, POWER PIVOT
  • SAP Business Objects

Certifications
  • Certified in Epic systems Clarity data model - Cadence
  • Certified in Base SAS programming
  • Certified in Bio-informatics - Manipal University
Professional Experience
EPIC report developer/ BI developer04/2016 to CurrentHenry Ford Health System - AllegianceJackson, MI

Responsibilities Include:

  • Responsible for Implementing the Cadence Module (scheduling) at Allegiance Health Hospital, used to manage the schedules for more than 400 doctors and more than 1,000 patients a day.
  • Working with a team of 6 to Adapt Henry Ford's customized population health reports using T-SQL and Crystal.
  • Creating new reports from scratch based on user requirements.       
  • Ad hoc reports and support for the transition to the new EHR. 
  • Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the reports.
  • Involved in cadence reporting based on clarity and star data models.
  • Involved in designing operational and adhoc reports using reporting workbench for patient scheduling and access, patient safety and experience
  • Involved in designing Reports and dashboards in radar and share point for population health analytics and health risk assessment teams.
  • Development of various metrics and measures for safety and infection control department. 
  • Involved in meaningful use and regulatory reporting like PCMH, UDS.
  • Proficient in using BI launch pad to distribute and scheduling of the reports for various departments.
  • Involved in testing and upgrading of reports to EPIC 2015 for Henry Ford Health System Detroit.
  • Created Database Objects like Tables, Stored Procedures, Views, Clustered and Non-Clustered indexes, Triggers, Rules, Defaults, User defined data types and functions using T-SQL.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Good in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Plan, analyze and develop Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping of sections, Cross-Tab, graphical, aging report etc. using crystal reports to support various user requirements.
  • Developed various charts and graphs like Bar chart (side by side, stacked), line graphs, pie charts etc by using chart expert utility of Crystal reports.
BI Developer06/2015 to 04/2016Allegiance HealthJackson, Michigan

Worked as BI intern in Allegiance Health system. The Data warehouse was designed to generate reports for the analyze the patient information for the improvement of patient safety and experience of various departments.

Responsibilities Include:

  • Interacted with business representatives for requirement analysis and to define business and functional specifications.
  • Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification using SSIS packages.
  • involved in developing master patient and provider tables extracting data from various legacy systems, nextgen and series.
  • Worked with various heterogeneous sources such as Oracle10g, XML and Flat Files to load the data into the target SQL server data warehouse.
  • Developed SQL queries for data analysis to build up reports and dashboards for end users. 
  • Worked in creating Crystal Reports (Ad-hoc Reports, Frequency Reports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, aging Reports).
  • Good knowledge in Developing custom Reports, utilizing formulas, setting up parameters for some dynamic reporting, creating sub- Reports, incorporating the use of graphs.
  • Created and maintained numerous Crystal Reports including analytical and operational Reports.
BI Intern02/2015 to 05/2015Acacia networkNew York City, NY

Worked in care management in behavioral health. Analyzed and reported on clinical data.

Responsibilities Include:

  • Sourced and analyzed data from a variety of sources like SAS data sets, MS Access, MS Excel, CSV, XML, SQL Server and flat files etc.
  • Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
  • Performed statistics on clinical data using SAS to understand the patterns in methadone clinics.
  • Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.
  • Cleaning of data using SAS Procedures like Proc Freq /Proc Univariate.
  • Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL.
  • Visualization of data of data after performing statistics was done using tableau for graphical presentations.
  • Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
  • Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Oracle, Ms-sql, SAS).
  • Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
Educational Background
Master of Science: pharmaceutical sciences2015St John's universityNew York City, NYGPA: 3.4/4
Bachelor of Science: Pharmaceutical sciences2011Manipal universityManipal, Karnataka, IndiaGPA: 3.8/4
Build Your Own Now

Resume Overview

Companies Worked For:

  • Henry Ford Health System - Allegiance
  • Allegiance Health
  • Acacia network

School Attended

  • St John's university
  • Manipal university

Job Titles Held:

  • EPIC report developer/ BI developer
  • BI Developer
  • BI Intern

Degrees

  • Master of Science : pharmaceutical sciences 2015
    Bachelor of Science : Pharmaceutical sciences 2011

Similar Resumes

View All
BI-Developer-resume-sample

BI Developer

Saxony Partners

Mckinney, Texas

Posted 811 days ago