Developing Web Intelligence Reports and Tableau Dashboards using Microsoft SQL server with data from Epic Clarity and Caboodle databases.

Perform user experience design and user interface design to develop Tableau dashboards, Web Intelligence, and Epic Cogito SQL reports for Cardiology Departments.

Develop SSIS extract packages for extracting, transforming, and loading of banking data.Experience with Home Mortgage Disclosure Act

Primary Project: Epic Clarity to AllScripts EPSi ExtractLead the validation and Oracle SQL development of AllScripts EPSi Extract to decision support. Qlik view and MS Access reports were created to analyze the data. An Excel document shared on MS SharePoint was created to consolidate communication to one central location.

Primary Project: Press Ganey Survey ExtractCreated SSIS packages to extract data to external vendors through go-live of Epic financial modules.- Extract to Press Ganey and accompanying BI Web Intelligence report. High impact to medicare reimbursements- Extract to Med-Metrix (Pharmatek)- Extract to Children's health Network to report on pediatric inpatient stays- Extract to AllScripts - Extract to MDAudit- Extract to Horizon Home Health- Extract to NJ Cancer Registry- Extract of financial work queues to McKesson

Primary Project: Epic Clarity to Med Metrics extractCreated Oracle stored procedures used by automated Informatic jobs to send data to internal departments and external vendors. - Extract to Med Metrics to reduce costs- Extract to Accounting department for home health visit reimbursments- Extract to BuenopaneCreated Crystal Reports reporting on Epic Clarity financial and clinical data.- Visits report of Ambulatory Surgery, Inpatient stays, and ED Visits

Primary Roles:Requirements Gathering•Meet with Executives and Department Heads to Gather Organization Metrics, Report Requirements, and Extract Requirements •Collaborate with external vendors to understand required file formats and setup secure file delivery.Development•Develop Business Objects Crystal Reports and submit for Data Courier to Production•Develop Ad-Hoc Paramertized Reports using WebFocus •Setup up and Maintain SQL Server SSIS Packages, Jobs, Stored Procedures, & Views•Setup data marts to efficiently retrieve data from the Epic Clarity data warehouse•Develop reports & extracts that pull data from the following Epic Data Modules:Rev Cycle: *HB, PB, SBOClinical: EpicCare Ambulatory, EpicCare Inpatient, Radiology (Radiant), Oncology (Beacon), ADT (Grand Central/Prelude), HIM, ED (ASAP), Maternity (Stork)Documentation•Document source data and code logic in SQL coding comments and data dictionary•Train reporting team members with clinical backgrounds on SQL development and Ad-Hoc Parameterized Report developmentAccomplishments:Project Management-Lead ICD 10 conversion project of Epic Clarity based reports & extracts.-Lead setup of WebFocus Test EnvironmentAdaptable to Changing Environment-Attained HB Epic Certification within six months of working at Reading.-Developed first report within two weeks of starting at Reading-Developed daily financial extracts within four months of starting at Reading -Learned new skills within six months that included: Developing Crystal Reports, understanding the Epic Clarity Data Model, and developing WebFocus Reports-Assisted with upgrading from Epic 2010 to 2012, 2012 to 2014 and 2014 to 2015Team Player-Taught 10 other team members how to develop Ad-Hoc reports in WebFocus-Cross-trained clinical based team members SQL and Ad-hoc reporting skills in exchange for their clinical knowledge to fulfill report requests. -Created Templates, standards, data dictionary, & data structure.

Primary Role: Application Support for MS SQL Server, Access, and VB ApplicationsAdditional Role: Develop SharePoint site for the application support team.

Primary Role: Develop SQL Server import stored procedures used to import marketing and risk data into D&B's proprietary Market Spectrum Web BI application that combined customer data with D&B data used for marketing and risk analysis by over 100 customers that included Fortune 500 companies. Additional Responsibilities: Web application design and database reporting using ASP, ASP.NET, Visual Studio, Visual Basic, HTML5, CSS, XML, IIS, TSQL. SQL data import projects using SSIS packages, DTS Packages, Stored Procedures, and views.

Role: Application Support and Database DevelopmentSetup and maintained marketing research systems using SQL Server 2000 based on Technical Analysts specifications.

Technical Consultant at Dun and Bradstreet Role: Application SupportSetup and maintained marketing research systems using SQL Server 2000 based on Technical Analysts specifications.

Designed ASIC integrated circuits using Cadence Design tools.