ROBERT J. GILLESPIE
RJGillespie24@yahoo.com
6390 Waldon Woods Drive Residence: [Send email to request phone number] 25.0248
Clarkston, Michigan 48346 Cell: [Send email to request phone number] 97.5421
SUMMARY OF QUALIFICATIONS
Programmer/Analyst/DBA with successful experience in project management,
technical leadership and implementing new technologies. Special expertise in
resolving customers issues through problem analysis skills. Developed customer
requirements, designed technical specifications and user test cases. Well
developed interpersonal and communication skills.
KNOWLEDGE AND EXPERIENCE
Visual Basic 6.0 Business Objects Microsoft SQL
Server NetBackup
PL I Crystal Reports VmWare COBOL II
MS Project DB2 / SQL Visual Basic for Applications
VSAM
TSO / ISPF SQR 3
Access 97 2000 Windows Shell Script
Spread 6 ASP MVS Unix Shell Script
MySQL RPG InstallShield
ChartFX 98
CAREER HISTORY
Releiance-One, Troy MI 20011 – 6/2011
SQL/DBA, Hurley Hospital
I supported the backup process and Microsoft SQL for all Hurley servers.
• Updated Netback to 7.0 versions for all 150 servers.
• Reviewed all Microsoft SQL servers and corrected any issues.
CDI IT Solutions, Troy, MI 2007-2009
Database / Programmer Analyst, Chrysler FIS Powertrain Plus
I developed Plant Overview application in Visual Basic to graphically display
real time and historical data to the users identifying bottlenecks.
• Created custom ActiveX controls that utilized ChartFX and Spread 6.
• Design/Modified FIS reports developed in Visual Basic and Crystal reports.
• DBA Sybase database, created/updated stored procedures utilized by FIS
applications.
PINNACLE TECHNICAL RESOURCE INC., Dallas, TX 2006-2007
Information Analyst, EDS Paint Deployment
Installed Web reporting for GM paint departments. Configured Web server,
created new tables, stored procedures and set up jobs to replicate data using SQL
Enterprise Manager. Worked directly with users to customize reports to their
plant specifications.
• Created 21 custom reports for Wentzville paint department in less than three
months.
• Performed gap analysis for Lake Orion Plant paint department reports.
AUTOMATIC DATA PROCESSING, INC., Troy, MI 2004-2006
Software Developer / Technical Engineer, Automotive Retail Group
Project leader for creation of PC installation wizard packages using
InstallShield. Packages currently used to install third party vendor’s
applications on multiple window platforms. Responsible for trouble shooting and
developing solutions to problems encountered with all supported Visual Basic
applications using Visual Studio 6.0 programming environment.
• Designed and implemented two wizard installation packages.
• Redesigned and implemented a new Visual Basic communication program to reduce
CPU usage for dealers on AS/400 systems.
ELECTRONIC DATA SYSTEMS, ( an HP Company ), Troy, MI 1985-2004
Information Analyst, Automotive Retail Group 2001-2004
Responsible for trouble shooting and developing solutions for Visual Basic
applications that supported our GM dealers. Team developer of the ASP Saturn
solution, designed and implemented RPG programs to backup all Saturn dealer’s
data.
Information Analyst, Southeast Michigan Solution Center 1996-2001
• Supported American Axle’s Microsoft Access applications. Re-indexed AAM’s
database to improve performance of their application from locking up the
database.
• Enhanced Detroit Diesel billing application to increase its functionality,
developed in Visual Basic 6.0 using Microsoft Access 2000 database.
• Project System Manager and Technical team leader of the successful
implementation of the Penske / Kmart cash register interface project, using
PL/SQL and Oracle database.
• Project Leader for the successful X2 Conversion implementation.
• Technical lead for Renascence Enterprise Management Ad-Hoc reporting projects.
Learned Business Objects and directed a team of four Information Analysts to
create REM reporting environment.
• Contributed to the development of the Sequoia help desk application, using
Vantive
• Produced multiple reports in one program using SQR3 workbench writing
reporting tool, interactive SQL, and UNIX, to reduce daily processing time.
Information Analyst, General Motors, Milford Proving Grounds 1993-1996
Project leader for the Occurrence Duration Data, Corrosion Vehicle Accounting,
and Local Metrics Analysis Repository systems. Self taught ISPF Dialog
Management.
Information Analyst, Saturn Development Team 1989-1993
Designed and developed the on-line applications for Saturn systems. On-line
applications were developed in Cobol II, with a DB2 database.
Information Analyst, Executive Office Development 1985-1989
Team leader/developer supported the Repossession and Loss Systems.
• Designed and developed News and View on-line application, so that information
was retrieved quickly for Executive Office request.
• Trained software developers on M204 relational database language.
CITICORP, Southfield, MI 1984-1985
Installation Software Analyst
Team leader create programs to convert Credit Unions from existing systems to
Citicorp system.
WORLD COMPUTER CORPORATION, Birmingham, MI 1981-1984
Online Programmer
Conversion programmer converted Credit Unions from competitor database to
World’s database. Designed and implemented Universal Fix Program to modify
anything in their existing database.
EDUCATION
BS, Math / Computer Science, Western Michigan University
ADDITIONAL EDUCATION AND TRAINING
Microsoft Certified Professional MCSD Program, Walsh College 1999
|
