Sql Server Developer
Resume:
Grover S. Hickman, Jr.
Gray, TN 3615
Email: ************@*****.***
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