Completed all the necessary training classes and passed exams for Epic certification in Resolute Professional and Resolute Hospital Billing with an average of 90%. Leading effort to revise SQL code on slow-running reports and allow for more concise reporting through Crystal Reports, automated report delivery mechanism, and adhoc reporting. Took lead with Caboodle data warehouse development and working with vendors on file transfers.

Developed and maintained Oracle Application Express (APEX) reporting environment. Managed nightly ETL processes within small data warehouse. Excel and Access proficient. Together with Business Analysts, worked to understand data and needs to deliver useful and timely information.

With guidance from management and senior associates, developed numerous dashboards in Tableau that assist senior-level executives to understand financial performance of service units and colleges / departments. Created new and updated existing financial reports for a University-wide audience using Crystal Reports. Worked on process improvement projects to introduce automation to eliminate manual processes. Assisted DBA with performance tuning to reduce nightly batch job timing.

Used Oracle APEX to develop and deliver web-based applications to Humana Cares users. APEX is a SQL-based application for rapid web application development. Managed the help desk for Humana Cares which supported roughly 2,500 users. Helped write and maintain Oracle packages, procedures, functions and sequences in accordance with business requests. Performed Triage duties in order to determine where code flaws originated and either fix or provide developers with guidance on bugs.

Served as SME on Clinical Profile data warehouse; lead project teams to increase data value. Created and maintained Oracle Discoverer reporting package utilizing database linking from SQL Server to Oracle. Created and administered a Resource Tracking application to ensure all resources were utilized appropriately. Completed time sensitive ad Hoc reports to enable management to make informed decisions. Assisted other clinical areas with technical assistance to complete projects within acceptable time frames.

Documented data update processes to assist with training needs. Identified data sources and employed VBA solutions to automate data manipulation. Assisted with General Ledger to Oracle GL conversion project.

Created Microsoft Access databases and maintained existing departmental databases for data integrity. Produced Entity Relationship Diagrams for departmental databases. Identified, documented and implemented policy and procedure documents to decrease complexity and time required to complete certain security tasks.

Performed quality assurance audits on enrollment associates. Assisted with creation and modification of evaluation forms to complement business needs. Worked with Analysis Team to develop reports, implement databases and automate tasks to increase overall group efficiency. Implemented Claims Testing Automation WinBatch script to eliminate waste and increase production throughput. (Annual savings estimated at more than $80,000 per year)

Managed ten full-time order entry personnel. Staffed functional areas according to volume and business requirements. Worked with associates to create an inclusive work environment.

Managed eleven permanent employees and a temporary flex force of up to 30. Handled personnel and production placement issues. Received Gold Award for Tell Dell (associate survey) responses from associates. Streamlined numerous daily tasks to optimize time on the production floor.