EPIC report developer/ BI developer Resume Example

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.

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.