Mark D./ Computer Support

Mark D.
Jefferson, GA 30549
mdeitrick@mindspring.com

Hardware/Software Experience
Oracle 7.2, 7.3, 8i, 9.2; OpenIngres 2.0; Progress 8.3a,9.1E; SQLServer 7.0, 2000; DB2; Citrix MetaFrame 1.8; Presentation Server 4.0; Business Objects XI; Crystal Reports XI; ReportSmith; ERWin 3.5.2; SQL; ODBC; PVCS 6.8,8.1; SCO UNIX 5.0.5; SUSE Linux 9.2; AIX; VMWare 2.0; Windows 3.1, 9x, NT 4.0, 2000, XP, TSE, 2003, Vista; DOS 7.0; Kronos 5.0; NexTrak; ADP 3.0; infraEnterprise 7; HEAT 3 & 4; OS/2 3.0, 4.0; WARP Server; MS-Office 97, 2000, 2003, 2007.

Professional Experience
S1 Corporation January 2008 – May 2009
Technical Support Engineer

Ø Provide technical support to Sate Farm for their Mutual Funds, Credit Card, Consumer Loans, Banking and Insurance applications.
Ø Rotate on-call support with other L2 Support Engineers.
Ø Developing Crystal Reports to automate manual call tracking reports.
Ø Coordinate and prioritize tickets for offshore and remote Level 3 and development teams to provide timely solutions to our customers.
Ø Maintain client expectations and provide status updates to customers of their open tickets through weekly meetings.
Ø Harvest XML and log files from application and communication servers to assist in troubleshooting problems.
Ø Execute data repairs as need to correct customer profiles and transactions.
Ø Create weekly reports for all applications to ensure that service levels are being met and tracking all opened and closed cases.
Ø Provide daily reports for status of Bank application batch processes to State Farm.
Ø Monitor batch processes for all applications and troubleshoot and rerun as necessary.
Ø Train new Level 2 Support Engineers in the processes for supporting State Farm applications.

SUPERIOR ESSEX December 1999 – January 2008
Database Administrator

Ø Maintain 24x7 reliability for SQL Server 2000 and Progress databases for ERP, Payroll, MRP and in house developed applications for four plants.
Ø Maintain production, test, training and development environments for SQL Sever 2000 and Progress systems.
Ø Responsible for promoting all code to production and distributing updates to plants for in house developed Progress and Visual Basic applications.
Ø Develop data structures and maintain ER WIN data models to reflect all structure additions and modifications.
Ø Enhance, support and update ADP’s human resource application, running against a SQL Server 2000 database.
Ø Technical lead on converting 4 plants running Kronos version 2.x to version 5.0 and responsible for applying patches to application.
Ø Administer Citrix Server Farm consisting of three Windows 2000 and 4 Windows 2003 servers running Presentation Server 4.0.
Ø Apply Windows, Citrix and application patches to systems as they are released and coordinate limited downtime to minimize impact on 24x7 users.
Ø Migrated Citrix Metaframe 1.8 farm to Presentation Server 4.0 for foundation of new ERP solution.
Ø Test backups for all databases to ensure they are complete and reliable for Sarbanes-Oxley compliance.
Ø Provide application support for G/L and ERP software developed with Progress 4GL.
Ø Installed E*Trade Oracle 9.2 database and maintained updates to both the application and database.
Ø Wrote UNIX shell scripts for the monitoring of nightly routines and backing up of Progress databases.
Ø Responsible for security at the OS and application level for accounts to the ERP, MRP and Payroll applications.
Ø Provide detailed documentation in response to help desk tickets on how customer problems were resolved.
Ø Responsible for ensuring that nightly import files for data warehouse are generated.
Ø Responsible for running month end processes for Ingres Order Entry and Progress A/P & ERP systems.
Ø Implemented Business Objects XI Report Server for Crystal Reports.



Munich American Reassurance Company October 1996 - December 1999


Assistant Database Administrator January 1998 - December 1999

Ø Migrated 70 gigabyte Oracle 7.2 database from OS/2 WARP Server to Oracle 7.3 on Windows NT 4.0 SP-5 to provide snapshots of production data.
Ø Maintained two Oracle 7.2 databases, one for testing and one for production, running on OS/2 WARP Server SMP, including remote support.
Ø Assisted programmers, analyst and users in resolving problems with adhoc queries and ODBC connections.
Ø Monitored and maintained performance, availability and security of production databases and applications.
Ø Developed and administered central data structures and determine the most effective ways to organize, store and control data access.
Ø Responsible for maintaining software licenses, acquiring software upgrades for programmers and selecting training software for users.

CIS Support Specialist October 1996 - December 1997
Ø Worked with consulting Oracle DBAs to upgrade database from version 7.1 to 7.2.
Ø Assisted users in converting their Lotus 1-2-3 macros to Excel 97.
Ø Responsible for the administration of CompuServe and cc:Mail accounts.
Ø Configured and upgraded laptops for remote access to company’s network and commercial ISPs.
Ø Diagnosed and resolved hardware and software problems for programmers, analyst and users.

Atlanta Group Systems, Inc. July 1994 - October 1996
Consultant April 1996 - October 1996

Ø Provided users hardware and software support on a 100-node OS/2 LanServer token-ring network.
Ø Built x486 and Pentium computers and installed OS/2 3.0 and application software for use as nodes on company network.
Ø Responsible for loading client data into an Oracle database.

Placement Manager July 1994 - April 1996
Ø Responsible for recruiting Data Processing professionals for contract and permanent positions.
Ø In a team environment, fulfilled job orders for hospitals, utility companies, manufacturing companies and telecommunication companies.
Ø Interviewed and screened candidates for positions; as well as negotiated compensation and benefits for assignments.
Ø Identified potential candidates through adhoc queries on Omnis 7 database for specific required skill sets and coordinated interviews.
Ø Entered new resumes into database and datacoded potential consultants.



Education University Southern Mississippi, Hattiesburg, MS
BS Computer Science
Graduated May 1994