Grover S. Hickman, Jr.

**** **** ******* ****

Gray, TN 3615

Email: acfiwf@r.postjobfree.com

423-***-****

TECHNICAL SKILLS:

PC:

IBM or IBM compatibles; Visual Basic 3.0, 4.0, 5.0 and 6.0; Oracle 7.3, 8,

10 Series; Sequel Server 6.5, 7.0, 2000, DTS (Data Transformation Service),

2005; Microsoft OLAP; Hyperion Essbase 6.1 OLAP (Multi-Dimensional

DataBase); Visual Interdev; Crystal Reports 4 - 11 Series; Active X; OLE,

DCOM; C/C++; Visual C++; MFC; QBasic; Pascal; MS-DOS; Windows 3.1, Windows

95, 98, 2000 and NT, ME, XP, 2007; Lotus 1-2-3; WordPerfect; Microsoft

Word 2007; Microsoft Access; Microsoft Office (Excel, Powerpoint, Outlook).

Visual Studio 2005, 2008 & 2012; C#; DHTML; HTML; CSS; JQuery; JavaScript;

MS Sequel Server 2005, 2008r2; ASP.NET 2.0 - 3.5,4.0; ADO.NET; Reporting

Services SSRS, SSIS; .NET 1.X & 2.0, 3.5,4.0 XML; Oracle 8, 9, 10 & 11

series, Windows Entity Framework, Team Foundation Server 2012, Telerik

third party controls and JavaScript.

Mainframe:

ESA-9000/390 Mainframe systems (DOS, OS, MVS, JCL, CICS, MVS, VSE/ESA),

Xerox XBMS (Xerox Business Management Systems) Basic, Fortran, PL/1,

Assembler, ADA.DEC VAX-VMS, IBM AS400, RPG programming.

EXPERIENCE:

6/2010-08/2013

East Tennessee State University, Johnson City, TN (BS, August 2011)

East Tennessee State University, Johnson City, TN (MS, May 2014)

Presently attending East Tennessee State University Graduate program (3.4

GPA)

Master of Science in Engineering Technology

08/2013-01/17/2014 IngramMicro Johnson City, TN

TEKsystems/Contract Software Developer

Develop Web Based Application.

Utilizing Visual Studio 2012, Team Foundation Server, Linq, Windows Entity

Framework, MVC, Telerik controls, JavaScript and C# to build modules for a

front end development phone application. Sql Server 2008 R2 to create

stored procedures, views, and tables for the backend database.

08/2008-6/2010 Bell/Textron Helicopter Edwards Plant, Piney

Flats, TN

TEKsystems/Contract Software Developer

Develop Web Based Application.

Conduct test sessions with users to validate systems.

Database Design and implementation.

Absence Web Program

Designed and developed front and back end web application for maintaining

data related to employee time off. This application was written using C#,

ASP.NET 3.5 for the front end web application and SQL Server 2005 was used

for the database. Visual Studio 2008 and C#, MVC were used for

development. Reporting Services was used for creating eight custom reports

for the Human Resources department to track time off. This application was

a VB6 conversion to C# web application.

Parts Pricing Web Program

Designed and developed web application to upload new pricing for parts

into the data warehouses. Prices get uploaded for each of the five plants

at the beginning of each year. Converts a manual process into C# web

application that creates an excel object and copy the data from the

spreadsheet into each of the databases.

Conversion of application and reports

First year was spent converting legacy VB6 applications into C# web

applications; converting Crystal reports into report services reports;

writing sequel commands for movement of data from one database to another

or moving data from one table into another table upon request.

11/2007-01/01/08 Regal Cinemas Knoxville, TN

TEKsystems/Contract Software Developer

Develop Web Service

Develop Web Based Application.

Conduct test sessions with users to validate systems.

Database Design and implementation.

Movie Pass Application/Web Service

Designed and developed a back end web application for maintaining data

related to movie pass cards. This application uses Active Directory and a

custom .NET 2.0 membership provider for authentication, and uses the .NET

2.0 role provider for authorization to different functional areas within

the application. SQL Server 2000 was used for the database. Visual Studio

2005 and C# were used for development. Designed and developed a Web Service

for processing requests from hundreds of theatres located throughout the

United States using C# and .Net 2.0.

01/2006 - 9/2007

Shannon Solutions, LLC Toyota Motor Manufacturing, Lexington, KY

ECI (Electronic Change Interface) - Developed 40 web page program to track

part change requirements for vehicles moving down both automated lines.

This web program was written in C# & Java Script using SQL Server as the

back end and 15 reports written using Reporting Services.

Battery Tracking System - Developed an application and service in both VB6

and C# to track and store voltage data (analog to digital using IOTECH

cards for PC) from the batteries in the cars.

GALC (Global Automated Line Control) - One of three persons on call for

both plants automated line control and many sub systems.

07/2003- 12/05

TEKsystems Toyota Motor Manufacturing Kentucky Lexington, KY

GALC (Global Automated Line Control) - One of three persons on call for

both plants automated line control and many sub systems.

Worked on various projects moving projects from VB6 to C# web applications.

07/2002 TEKsystems King Pharmaceuticals, Inc., Bristol, TN

This was a short term contract to provide an upgrade to an existing

application using VB6 and Oracle.

10/2001 - 2002

TEKsystems SHPS, Louisville, KY

Developer - Developed RockTenn, Dimension, Cigna, UHC, and Amvescap

outbound feeds. Developed Batch Termination program and have overseen

development of many other daily processes. All programs developed utilized

Visual Basic 6.0, Sequel Server 7.0, Sequel Server 2000 and Crystal

Reports 8.* version. The programs used temporary stored procedure in the

Visual Basic Code. Also, permanent stored procedure located on the Sequel

Server machines. These programs were the weekly feeds for third party

clients. Batch Termination Program is a menu program that drives eight

different programs (exe) for terminations of benefits. Each of the eight

programs uses a single thread to run each program. All Sequel commands

written into stored procedure and located on the Sequel Server.

10/2000 - 10/2001

TEKsystems Ruby Tuesday, Knoxville, TN

DBA/Developer - Evaluated WOW reporting database and OPS_DB (operational

database) architecture and data warehouse design. The design was previously

developed by a Lotus Development Team engaged to change the daily, weekly,

and monthly aggregation and reporting process. The hierarchy management

structure was identified as one of the problem areas of the design. Another

problem area was the report engine developed by the Lotus Development Team.

Suggestions were made to scrap the report engine and redesign the

architecture to better fit the needs of the customer. The following

suggestions included upgrading to Microsoft Sequel Server 7 or Microsoft

Sequel Server 2000, Microsoft OLAP, and DTS for the data pump or Hyperion

Essbase OLAP database. These choices were suggested to calculate the daily,

weekly, and monthly aggregation within a relatively minimal time frame. The

second suggestion was to evaluate Crystal Reports as a possible candidate

for a replacement of the Report Engine. Assigned second project to design

and develop the Labor Norm Project, which consisted of parsing multiple

flat files, sent from each store daily. After the files were parsed they

were merged into five separate flat files. These files were uploaded

through a DTS (Data Transformation package) to Sequel Server tables. The

tables had stored procedures wrapped up in DTS Sub packages to calculate

each employee's hourly labor dollars per hour for each store and hourly

sales for each store.

Additional sub packages consisted of stored procedures to calculate the

totals and averages for each employee job code number. Once calculations

were completed, the data could be compared to a static norm table.

10/99 - 10/2000

Ernst & Young, Woodstock, Ga.

Team leader For AWS (Auditors Workstation) Development Group

Conversion from Windows 95, Window NT, to Windows 2000 for Front end and

upgraded from Sequel Server 6.5 to 7.0. Upgraded AWS windows 2000 version

1.4.2 to 1.5.

07/98 - 10/99

State of South Dakota, Bureau of Information and Telecommunication, Pierre,

SD

Converted 16 bit Visual Basic 4.0 juvenile offender database program

utilizing Windows 3.1 users to Windows 95 and Windows NT 4.0 users in

Visual Basic 4.0 and 6.0. Developed juvenile offender online tracking

system using a front-end in Visual Basic 4.0 and 6.0 and a back end in

Sequel Server 6.5 and 7.0 and Crystal Reports. The database consisted of

stored procedures, triggers, and Sequel tables.

Environment: Visual Basic 6.0, Sequel Server 6.5, 7.0, Visual Interdev,

Windows NT 4.0, Crystal Reports 6.0, Visual C++, C, Active X, COM, DCOM,

OLE, MFC

01/98- 07/98

Solectron Technologies, Inc., Charlotte, NC

Developed tables and stored procedures for inventory control program for

the nighttime batch run. Converted this program from Clipper to Visual

Basic 5.0 with MS SQL Server running on Windows 3.1, 95 and NT.

Environment: Visual Basic 5.0 SQL Server 6.5 Clipper, Crystal Reports 5.0,

Visual C++, C, Active X, COM, DCOM, OLE, MFC

10/95- 01/98

Eastman Chemical Co., E & C Division

Developed, initialized and completed Process Safety Information database at

Eastman Chemical Company, Plant Engineering, Kingsport, Tennessee,

programmed in Visual Basic 5.0, for the front-end attachment to Access '97

database. Developed reports for this program in Crystal Reports 5.0. In

addition, created an OLE (object, linking & embedding) attachment to Excel

'97 as an additional export. This is a tracking and reporting program

utilized to maintain safety information required by OSHA. This program

utilizes multi-user interface for the purpose of querying information at

the user's request. Also developed multiple security levels for the users

of this program at log-on.

Development and modifications of relief device calculation program for use

by chemical engineers developed in Visual Basic 5.0 and Excel '97. This

front-end imports and exports from Word documents through OLE to load

Access '97 database. The Access '97 database consists of multiple tables

for the user to run queries to perform calculations on relief devices.

These relief devices consist of linear regressions to calculate the relief

of a device. Maintained and upgraded this system and converted database

from Access '97 to SQL Server 6.5 and further to Oracle 7.3.

Developed, initialized and completed Archived Aperture Card Index System at

Eastman Chemical Company, E&C Division, Kingsport, Tennessee, in Visual

Basic 5.0. This program is a front-end to an Access '97 database which

consists of multiple tables for use by a multi-user query environment.

This is an archive tracking system developed to track the microfiche cards

of P&ID drawings.

Responsible for maintaining and upgrading Cost Savings Information System

at Eastman Chemical Company, E&C Division, Kingsport, Tennessee, written in

Visual Basic 3.0. This program also utilizes Oracle database and Access

2.0. In addition, it uses Crystal Reports 4.0.

All of the above systems were maintained and operated under Oracle

database, NT Server and Sequel Server environments.

10/94- 10/95

Plus Mark (A Division of American Greetings), Greeneville, TN

Computer Operations duties included all aspects of computer operations,

including daily and nightly operations, EDI transmissions, back-ups,

printing reports, labels, bar codes, checks and special reports.

Operations conducted on IBM ESA-9000/390 system in conjunction with Xerox

(XBMS) software, Xerox laser printers, line printers, paper bursters and

four-copy collator.

01/93- 07/94

East Tennessee Electric, Johnson City, TN

Journeyman Electrician

Duties included all aspects of journeyman electrician, residential,

commercial and industrial (running conduit, trouble shooting, wiring

raceways, cable trays, etc.). Duties also included installation and/or

relocation of Token Ring network system for additional computer terminal

installations; phone line installations.

03/92- 09/92

Smiles Communications, Johnson City, TN

Communications Technician

Duties included installation, maintenance and repair of various systems for

multi-line and multi-extension telephone systems. Duties also included

installing hard wire, trouble shooting and systems programming.

01/92- 03/92

Miles Corporation, Mobay Plant, Charleston, SC

Journeyman Electrician

MILITARY RECORD:

Completed four years U.S. Army (Honorably Discharged)

Clearance: Top Secret Special Background Investigation

EDUCATION:

Northeast State Community College, Johnson City, TN (AAS, December 2011)

East Tennessee State University, Johnson City, TN (BS, August 2011)

East Tennessee State University, Johnson City, TN (MS, May 2014)

Military School

Completed training in Logistics

Contact this candidate