-Maintaining programs that produce files in the ANSI X12 837 format.-Maintaining, modifying, and creating processes using SQL Server 2008 and 2012, SSIS, PowerShell, C#, and ActiveBatch.

-Developing database tools that serve as the foundation of ongoing encounter operations. -Partnering with teammates to define data structures, create and executed a process to load historical data, and implemented stored procedures to support report automation.-Designed and built healthcare and compliance reports using Crystal Reports XI-Created and automated excel-based executive dashboards and scorecards-Provided ad hoc data extractions through the use of SQL Server Management Studio 2008 and MS Access-Maintained and created SQL stored procedures, functions, views, and data tables -Processed and distributed monthly encounter data and HIPAA files to clients-Troubleshot claim and encounter file rejections to meet required pass rates for each state-Coordinated report schedules and due dates for internal and external reports-Facilitated reporting requirements and planning meetings between IT and operations-Maintained Redix data transformation tool for HIPAA 837 files-Served as the main point of contact for encounter data for more than 30 health plan clients-Assisted in the continuous improvement of over 100 claim, provider, and member reports workflows-Assessed new ETL tools for integration with systems already on premises-Created automation jobs and scripts using PowerShell scripting in conjunction with Crystal Reports and ActiveBatch

Three teammates and I worked in conjunction with Gaston Painting and Remodeling to eliminate their paper based system by:1. Automating the scheduling system 2. Automating client and sub-contractor information

Serving as the publicity officer for AITP at East Carolina University. General responsibilities include letting the student population know about the associations meetings and operations, recruitment of new members, and marketing of society functions.

Worked in a team of four people (including myself) and our primary function was to automate the current paper based system. We most closely followed the Rational Unified Process to achieve this goal.