Robert Wilkerson Email & Phone Number

Columbus, Ohio Area

New Albany, Ohio

• Administration responsibilities include: SQL Server Configuration, Database Configuration, Integrity, Support, Security, Optimization, Monitoring, Tuning, Archiving, Maintenance, Capacity Planning, Replication, Security Patching and On Call Rotation. The production environment consists of 9 separate virtual SQL Server instances. All SQL Server instances utilize the 2008-R2 Enterprise Edition of SQL Server.• Refreshing of any databases onto any of the SQL Server instances within the development and Q/A environments as needed, via RedGate SQL Data Compare.• Creation of the various SSIS packages and SQL scripts associated with the back-end conversion of the Bill Audit Access application to SQL Server.

Columbus, Ohio Area

• Administration responsibilities include: SQL Server Configuration, Database Configuration, Integrity, Design, Modelling, Support, Security, Optimization, Monitoring, Tuning, Archiving, Maintenance, Capacity Planning, Change Control and Replication. The production environment consists of 4 separate SQL Server failover clusters and three separate stand alone SQL Servers. All SQL Server instances utilize the 2008-R2 Enterprise Edition of SQL Server.• Provide enterprise support for all our Reporting, Analytical and Integration services.• Provide support and guidance for our Software Solutions, Data Warehouse and SharePoint development teams.• Restoration of any databases onto any of the SQL Servers within the development and staging environments as needed.• Creation of various SSIS packages for: exporting database information in a flat file format, loading of flat file information into various database tables, application integration and database maintenance.• Architect and implement a series of scheduled jobs and procedures that are used to: standardize the database backup life cycle on all twenty SQL Server instances.• Architect and implement a series of scheduled jobs and procedures that are used to: find and process encrypted zip files on our network so that information may be made available to the business.• Architect and implement a series of scheduled jobs and procedures that are used to: make available to the business, critical information that resides on a SQL Server that’s outside of our network. • Migration of all production, staging and development SQL Server 2005 Server instances to SQL Server 2008-R2 Server instances.

Columbus, Ohio Area

• Provide hardware, software and phone support to 31 locations, (points), located throughout the United States.• Rewrote and optimized the daily “Caribou” process to properly handle any data or structural flat file errors. • Research, evaluate and make the necessary enhancements to the “Postbox” process that would enable it to be table driven.• Create a series of SQL queries to determine if our flat file “website data” had been properly loaded into our web designers’ M/S SQL Server database.

Columbus, Ohio Area

• Administration responsibilities include: SQL Server Configuration, Database Configuration, Integrity, Design, Modelling, Support, Security, Optimization, Monitoring, Tuning, Change Control and Replication.• Created a separate “development” 2005-SQL Server environment to be used as a development server reference for all current and future applications. All development, modifications and enhancements can now be made to any existing applications, without the worry of disturbing the integrity of the data that exists on the “production” server.• Research, evaluate and make the necessary enhancements to a series of user tables, user stored procedures, and DTS and SSIS packages, so that the amount of Practitioner information that is sent to the Medical Claims software package, ( Impact ), from Credentialing software package, ( Visual Cactus ), could be increased. During this time, all user stored procedures, DTS and SSIS packages used within this process, were optimized for efficiency and accuracy.• Replaced all redundant SQL code within all SSIS packages of the inbound “CareMark” pharmacy claims process, with calls to stored procedures within the RX_DATA database.• Research, evaluate and make the necessary enhancements to a series of user tables, user stored procedures, and SSIS packages, to accommodate the new columns of information being added to the inbound bi-weekly “CareMark” pharmacy claims process.• Replaced all redundant SQL code within all DTS packages associated with “Import Delegates” portion of the Audit Tracking System, with calls to stored procedures within the OHGAS_PROD database.• Research, evaluate and make the necessary enhancements to the MS Access Project code of the Audit Tracking System, so that the “Import Delegates” option would work correctly.

Columbus, Ohio Area

• Administration responsibilities include: SQL Server Configuration, Database Configuration, Integrity, Design, Modelling, Support, Security, Optimization, Monitoring, Tuning, Maintenance, Capacity Planning, and Change Control.• Analyze the proprietary flat files used within the OPTICare system and determine the files whose physical record length do not match their logical record length and make the appropriate enhancements to the file definition and XML document associated with each flat file.• Determine which flat files have multiple record redefinitions so that once converted, the data would be in some type of normalized order. In this case, one flat file would populate many tables.• Utilizing a proprietary data conversion utility, convert the data from the flat file formats to the OpticalData database in SQL Server 2005.• Create a series of SQL scripts that would create indexes and constraints for all tables within the OpticalData database.• Modify the appropriate NetCOBOL programs that have in them, those flat files that had multiple record redefinitions, to point to the appropriate tables in the OpticalData database.

Greater Detroit Area

• Administration responsibilities include: Database Configuration, Integrity, Design, Modelling, Support, Security, Optimization, Monitoring, Tuning, Maintenance, Capacity Planning and Change Control.• Develop a series of SQL procedures to:• Clean up existing data.• Add content to a series of existing tables.• Create a series of new tables.• Create indexes, constraints and triggers on new and existing tables.• Utilizing the Embarcadero tool, create a logical diagram of all database tables used with the Newspaper Information System. • Research, evaluate and make the necessary enhancements to all the database tables, triggers and stored procedures associated with the Marketing Optimization and Analytics project.• Developed a process in which all development, Q/A and production database enhancements are made by executing reusable scripts.