SUMMARY:

Highly motivated and results - oriented information technology professional with exceptional leadership and communication skills and solid experience

TECHNICAL EXPERTISE:

• Microsoft Office Products Boston Workstation Crystal Reports 2008/SAP BOE 3.1
• Visio 4.5 Automate 5.5 Epic Reporting Workbench (ECI)
• Visual Basic 6 & .Net(limited) MS SQL Server Studio Manager Epic Clarity Data Model
• AWK, KERMIT & PGP utility Oracle PL/SQL EpicCare-Ambulatory
• HEAT (Problem tracking application) Allscripts Software EpicCare-Inpatient
• Confidential (5.65 and before) Iatrics ScriptMate Willow-Inpatient
• Resolute PB
• Cadence
• Epic ETL Administration
• Cache/KB SQL

PROFESSIONAL EXPERIENCE:

Confidential, Warrenville, Illinois

Senior Report Developer/Analyst

Responsibilities:

• Responsible for designing, developing, testing and managing reports against Epic Clarity database to meet organization information needs.
• This includes creating ECI templates for scheduling and distributing reports and appropriate HRX records to accommodate multiple versions of the same report.
• Designated person responsible for monitoring ETL executions, adding tables as requested (along with running Backfills) and BOE activities to assure successful run of executions and scheduled reports.
• Design and develop complex report along with authoring Specification Documents to outline general description and main business purpose of the report. This document also included technical specifications and unit testing validation.
• Report development include creating reports directly in Crystal Reports application or writing SQL query in SQL Server Management Studio to include as Command Object inside of Crystal. Other responsibilities include:
• Weekly monitoring of new report requests coming into the Reporting Team Department and documenting on teams Sharepoint for review and assignment
• Designated as part of weekly rotation for Data Courier of report items between multiple environments
• Work with end users and application analysts to resolve data issues found on report

Confidential, Darien, Illinois

Senior Programmer

Responsibilities:

• ETL Administrative activities including creating, scheduling and running ETL executions
• Rotating support for Daily and Weekly execution runs
• Solely responsible for System Update for the month of September 2013
• Involved updating Oracle and SQL Server Development, Stage and Production environments
• Rotating responsibility for processing UHC weekly reports; troubleshoot as needed
• Backup support for MU reporting; responsible for preparing for Stage 1 Year 2 reporting and Stage 2 Year 1 reporting. Responsible for testing new OMC reports and Epic-Crystal Integration process for these new reports.
• Develop new and modify existing reports as requested (approx. 10-15 reports in queue at a time);
• New requests and modification requests are received through Specifications Document developed by Analyst on team
• Reports are unit tested and validated upon development completion
• Reports developed in Crystal Reports and/or SQL Server Management Studio
• Publish and configure reports in Business Objects Enterprise for distribution
• Attend and report at Change Control meetings - rotational with other team members
• Project related tasks:
• Convert Oracle version of reports into SQL equivalent
• Convert Materialized Views from Oracle to SQL
• Worked with converted datamarts; adding SQL record to Compass in Hyperspace; testing and comparing stored procedure output; datamart structure and row count validation after DBA migrated data from Oracle to SQL
• Compare output of reports (compare tool used for this task to determine pass or fail)
• Correct any incompatibilities; change Oracle logic to SQL logic
• Peer review reports
• Work with Interns
• Led project meetings in absence of Project Manager

Confidential, Bolingbrook, IL

Clarity Report Writer/Application Analyst

Responsibilities:

• Developed multiple reports using Reporting Workbench
• Developed multiple Confidential reports for data extracts from existing Confidential System for analysis of data being uploaded to Epic System
• Continued production support of Confidential System
• Continued Confidential report development for Confidential System as requested

Application Analyst

Confidential

Responsibilities:

• Responsible for developing SQL queries and Confidential reports as requested by Senior Services or Confidential
• Responsible for running monthly Confidential interface for file submission to Confidential
• Responsible for developing and uploading weekly file to Upstairs Solution web application
• Continuous support of users throughout the system to modify existing or develop new reports from various applications within the system
• Allscripts Query (SQL queries against Database)
• Confidential SQL queries against Data Repository)
• Recent work includes the following;
• Developed Confidential reports to run weekly and monthly for accounts placed in Confidential
• Developed Confidential report and set up Confidential Scheduler to run for upload surgery equipment information
• Currently working on query for Confidential for Confidential data download
• Developed Boston Workstation scripts as requested including a script to upload data to all 6 Confidential for change in vendor name.

Confidential, Lisle, Illinois

Data Analyst

Responsibilities:

• Develop automation process for running Confidential reports needed for parallel database using various tools
• Created and updated wiki pages for documentation of certain Confidential and BAR processes.
• Involved in discussions with clients on best way to capture data needed for parallel database
• Subject matter expert for Confidential B/AR system.
• Gave knowledge transfer on basic functionality of Confidential Report Writer to other developer on team.