DATA ARCHITECT / SQL SERVER ADMINISTRATOR / PROJECT IMPLEMENTATIONSQL Server database administration, project implementation and support.• SQL Server database administration involving SQL Server versions 2005 – 2016.• Project implementation in relation to ongoing five-year rollout of large-scale Infor ERP system.• Provision of 24/7 database server and application support.• Planning, development, and implementation of procedures for application upgrades and migrations.• Enhanced SQL Server monitoring via automated daily collection of SQL Server tracking data to a central repository.

SYSTEMS MANAGER / SQL SERVER ADMINISTRATOR / APPLICATION DEVELOPERSQL Server database administration, application development and support.• Development/Implementation of centralized approach for corporate level SQL Server monitoring.• Provided 24/7 database and application support.• Design, implementation, and production support of SQL Server Replication and Database Mirroring for Adage ERP system using Central Publisher / Remote Distributor replication model.• Planning, testing, implementation of SQL Server migrations from SQL Server 2000 to SQL Server 2005 (in 2010) and from SQL Server 2005 to SQL Server 2008 R2 (in 2013) for Adage ERP system.• Production support and continued development for RFID System running Oracle OLAP Express. • Design/development for migration of RFID System to Progress OpenEdge.

SYSTEMS ANALYST / APPLICATION DEVELOPERApplication design, development, and support for Warehousing and Transportation applications.• Design/Development of Korn Shell, Perl, T-Sql, C language solutions in addition to production support for Warehousing and Transportation applications on Windows / IBM AIX Unix platforms.• Project Lead, IS Logistics Team, responsible for implementation of application upgrades for Logistics systems (Cadec Mobius TTS, Manugistics Transport).• Production support for BioCool project data warehouse application running IBM Websphere.

DATABASE ADMINISTRATOR / DEVELOPERDatabase analysis, design, and programming for applications running on SQL Server 7.0 and SQL Server 2000 on an independent contract basis.• T-SQL stored procedure and trigger development for Dial-Up Host payment system.• Database design and stored procedure development for data extracts and reporting tools to track Customer Counts, Advertising Budget analysis, Duplicate Payment reporting as well as T-SQL/XML solutions for Billing Invoice reporting and automated DTS (Data Transformation Services) jobs.• Development of C language utility program to automate FTP file transfers.

DATABASE ADMINISTRATOR / DEVELOPER Database Administration, Application Programming, and Systems Programming for corporate-wide applications running on both IBM AIX and NT platforms for Randalls and Safeway using Informix Online, Microsoft SQL Server, and NCR Teradata databases.• Reorganized Randalls Store Reporting System Informix Online database to redistribute tables and optimize performance. Developed C language utility programs to implement proactive monitoring.• Designed, developed, implemented C language, 4GL, and Korn Shell solutions to manage runaway Unix user processes on Store Reporting System, improving system performance and stability.• Created C filter program solutions to reformat report output files to conform to formatting/indexing requirements of COLD system, eliminating need for massive rewriting of report programs, significantly reducing project timeline, preventing cancellation of project.• Performed NT-to-UNIX conversion of Safeway’s Real Time Promotion Management system on IBM AIX RS/6000 platform. Automated history table maintenance and database space usage monitoring.

SYSTEMS ANALYSTUnix Systems Administration, Systems Programming, Application Programming, and Database Administration in centralized operations host site for regionally and nationally centralized applications.• Served as primary Unix System Administrator for two nationally centralized applications with user populations of 500 users. Designed, developed Unix Shell and C Language utilities to automate mass creation of all user account, streamlining migration to new systems.• Created C language and Unix Shell utility applications selected as IRS Regional and National Standards Applications including login utility programs, Security Audit Trail Self-Maintenance System, printer interface application, report viewer program, and file transfer utilities.• Designed/implemented standards for establishing Informix Online databases on all systems at this site, streamlining support and facilitating standardization of database archival/monitoring routines.

COMPUTER PROGRAMMER/ANALYST Application design, development, and documentation of C Language and Informix database applications.• Performed conversion of Form 809 Control System (Cash Receipt Tracking System) from Dbase to Informix/C resulting in improved support and user accessibility to system.• Designed, developed, documented, and implemented Employee Locator system enabling the timely tracking of phone numbers and office locations of IRS Houston District employees.