In this position I worked from a home office, self-motivated in which I performed the following duties:Analyzed member data and made modifications as directed by the CMS sync files. Used Oracle/Access databases to identify issues with the member information as related to the CMS dataAnalyzed Part D Pharmacy files and reports for CMS requirements and helped create software to identify issues with the files and reportsIdentified issues with the MMC Oracle application and make modifications to the Oracle SQL packages to fix issuesCreated Oracle databases with data for the testersSupported clients with issues related to the MMC applicationCreated encryption scripts for protected health information(PHI) in software developmentInsured that no PHI was used for testingAnalyzed and created import scripts for EDI837 encounter data.

Managed database operations by supervising two senior and two junior DBA's who overseen 300 Facets Healthcare database servers. In this position I also performed the following using SQL scripts and other tools:Analyzed member data and made modifications as directed by the CMS sync files.Analyzed delinquency billing and helped implement automatic process for lettersFound and corrected errors in receipts processingHelp implement automatic claims payment processWorked on utilization and case management processes which included health risk assessmentsSetup batch jobs and helped schedule them on the schedulerMonitored performance on SQL servers with SQL scripts, stored procedures, functions, and triggersHelped setup security for new clients in both SQL and FacetsFixed data with SQL and C# .net code

Managed a team of soldiers in a combat environment. After returning from active duty, I retired from the Pennsylvania Army National Guards in December 2005 with 20+ years of service.

Supervisor over the day and night time technology staff of about 15 employees. This position included being in charge of a one million dollar budget. Some of my duties included:Setup the infrastructure for the companyCreated the business continuity policies and procedures; took action to implement themSetup Facets database environment(SAN, WAN, servers, hardware, software)

Supervisor over all of the information technology staff about 30 staff members(24X7 operations). This position included being in charge of a 3.5 million dollar budget. Negotiated contracts with several hardware and software corporations. I also was acting Chief Information Officer for period of time. During this time period the hospital changed out all of the software and most of the hardware for Y2K. This was completed on time and within budget with me being the lead for the information systems area conversion. I was awarded, employee of the month.