KELVIN RANCE

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

Lake Worth, Florida 33462

954-***-****

Email Address: aczcvn@r.postjobfree.com

Developer/Database Developer/Software Engineer/Database Administrator

SKILLS

10+ years of professional IT experience

Developing and Programming Various Software Programs

Implementation and Troubleshooting

Coding Under Various Software Platforms

Administration of Small and Medium Databases

Development of Backup, Recovery Plans

Effective verbal/written communication skills

TECHNICAL SUMMARY

Software:

Microsoft Office Suite, Microsoft Dot Net, Microsoft Powershell, T- SQL. C, C++, C#, Java, SSIS, Data Warehouse, SSAS, BIDS, BI, .Net Framework 2.0 – 4.5, IOT

Operating Systems:

Windows 7, Windows 8, Windows 10, Windows Vista, Windows XP, Windows 2000, Windows Server 2008, Windows Server 2003, Windows Server 2000

Microsoft Server Products:

SQL Server, Powershell, C, C++, C#, ADO.Net, Visual Studio Professional, Server Management Objects (SMO), WMIObjects, SSIS, SSRS, BI, Data Warehouse (DW)

EDUCATION

Southern University (1982), B.S. Electrical Engineering., Graduated MCSDBA, MCSD (Solutions .Net Developer)

EXPERIENCE

21st Century Computer Technology 11/2009 – Present

MS SQL Server 2008, C++ Developer, Java Developer, Powershell – Windows 7, IBM OS\2, Visual C/C++/ C#, SQL Server 2008, 2012 and 2016, SSIS, SSRS, BIDS, DW.

Developed and DBA supported several SQL Server databases on various projects.

Wrote visual C/C++ code with codeview debugger to support various projects.

Vistakon Jacksonville., Fl. 12/2004 – 10/2009

MS SQL Server 2005 and 2008, C++ Developer, Java Developer, Federal Express Management Server 7.2, Windows 2000 – Windows 7, IBM OS\2, Visual C/C++, SQL Server 2005, 2008

Worked on a Federal Express Management Server for report generation

Developed in Java and C/C++ language using Windows and OS2 operating systems.

The Federal Express Management Server was used for report generation, printing shipping labels and invoices.

South Florida Water Mgmt District, West Palm Bch., Fl. 11/2000 – 12/2004

ASP, MS SQL Server 7.0 /2000 Developer, SQL Stored Procedures, SQL Triggers, ETL Tools, BCP & DTS, VB, C/C++

Reengineered by design, and programming of OLECAS application using MS SQL Server T-SQL.

OLECAS is a acronym for Online Engineering Chemical Analysis System.

The OLECAS application would compare historical data with new data and determine if new data was statistically valid.

Statistically valid data was then formatted and put into a report for email distribution.

Used T-SQL JAVA, ASP, C/C++ and HTML

Sun International, Ft. Lauderdale, Fl. 10/99 – 10/2000

Microsoft SQL Server 7.0 DBA, Visual C/C++, T-SQL Developer, OLTP, Transaction Server

Contracted to perform database backup and recovery for 7.0 database.

Created and maintained “Maintenance Plan” for automated jobs such as backup and report generation.

Created databases, indexes and tables.

Created user accounts and assigned roles for those users.

Created and used BCP and DTS packages.

Performed conversion of several 6.5 version databases to 7.0.

Performed tuning both for the application and system tuning.

DMR, Atlanta, Georgia 5-99 – 10-99

Oracle 7.3.1 / 8i DBA, Microsoft SQL Server 7.0 DBA, HP 9000, O/S 10.20, C/C++, Crystal Reports

Contracted to create and perform backup and recovery plan for database.

Performed both full and incremental database backups using HP’s OmniBack utility.

Performed Exports and Imports for Oracle. Performed Oracle User administration and tuning.

Created and maintained C/C++ application programs.

Application programs where telecommunication based programs.

Application programs took in input from users, made a ODBC connection request, either inserted, deleted or queried the database, then displayed information.

Displayed information could be routed to browser via HTML or sent to Crystal Reports for printing.

Atlanta University, Atlanta, Georgia 1-99 – 5-99

Oracle 7.3.1 / 8.05 DBA, Microsoft SQL Server 7.0 DBA, HP Systems Administrator, HP 9000, O/S 10.20, SUN JAVA, C/C++, Crystal Reports

Contracted to create and perform backup and recovery plans for database and O/S (Operating System).

Performed both full and incremental O/S and database backups using HP’s OmniBack utility.

Performed basic system administration i.e.. User, device, tuning and patch administration.

Performed Exports and Imports for Oracle. Performed Oracle User administration and tuning.

Created and maintained C/C++ programs.

Motorola Atlanta, Georgia 8-98 – 11-98

Oracle 7.1.6 DBA, HP Systems Administrator, HP 9000, O/S 10.20, MS SQL Server 6.5, PL/SQL, JAVA

As a contractor I created backup and recovery plan for database and O/S (Operating System).

Performed both full and incremental O/S and database backups using HP’s fbackup utility.

Performed basic system administration using SAM. Performed Exports and Imports for Oracle.

Performed Oracle User administration. Performed Oracle Tuning.

Grizzard Marketing Atlanta, Georgia 12-97 – 8-98

Oracle 7.3 DBA / Development, Windows NT 4.0, UNIX system 5, DEC ALPHA O/S, Novell, Systems

Administration, HP Systems Administrator, HP 9000, PL/SQL

Contracted as sole DBA responsible for the UNIX production and NT development database servers.

Responsibilities include tuning, user administration, backup and recovery administration on both Unix and NT.

Contracted to write PL/SQL scripts to perform automation of routine database tasks (i.e. disk and memory utilization).

Internal Revenue Service (IRS) Atlanta, Georgia 5/97 – 12/97

Oracle 7.3 DBA / Developer, Windows NT 4.0, UNIX system 5 (DCOSX o/s), Systems Administrator, PL/SQL, PRO*C

Contractor responsible for the development, programming and testing of EFTPS (electronic fund transfer payment system).

Programmed in “C” language, while using Oracle’s PRO*C development package the application EFTPS.

Also coded some PL/SQL programs to be added to EFTPS.

Acted as backup DBA for the group. Backup duties included adding users, backups and recoveries, and database enhancements.

US Steel Birmingham, Al. 2/97 to 3/97

Oracle 7.3 DBA / Developer, Developer 2000, Sybase 11 DBA / Developer, Windows NT 4.0, Dec VAX/VMS Systems Administrator

Contractor responsible for the conversion of Sybase Transact SQL programs to Oracle 7.3 PL/SQL programs under Windows NT platform.

Performed both Oracle backups on the NT PC and Sybase backups on a VAX/VMS machine.

Performed DBA activities of creating and maintaining user accounts, creating and maintaining tables, procedures and views.

Performed system admin. duties on the VAX machine of backups and recoveries and maintenance of user accounts.

Digital City Ft. Lauderdale, Fl. 11/96 to 1/97

SQL Server Developer and DBA, Microsoft SQL Server 6.5, Windows NT 4.0, Windows 95, Client - Server Development

Contractor responsible for development of SQL server applications for the Ft. Lauderdale - Sun Sentinels Web page.

The web page advertised real estate, employment and local news.

Used SQL Servers - ISQL /W to create my applications.

Responsible for the maintenance and development of database and user accounts.

Created tables, set up user accounts and did the weekly backups / recovery of the database.

Northrop - Grumman, Melbourne, Fl. 6/96 to 11/96

Oracle DBA/Oracle Applications Developer, UNIX Sun Solaris, Operating System, Open Windows, X Windows / Motif, PL/SQL, PRO*C

Responsible for setting up Oracle 7.1 and 7.2 client server network.

Database duties included setting up user accounts, creating tables and other jr. DBA activities.

Contract applications developer which coded both Pro*C and PL/SQL code for the Joint Stars Program.

Both Oracle Pro*C and PL/SQL code was written using Sun’s Unix Solaris Operating System.

PAR MICROSYSTEMS, Atlanta, Ga. 1/96 to 5/96

Oracle DBA/Oracle Applications Developer, OS/2 Operating System

Windows NT, Visual Basic 4.0, OS\2 Warp, Oracle Pro*C

Developed an Oracle transaction processing for contract application program using OS/2 operating system.

This application took bar code information and allowed the user to access and retrieve the data.

Responsible for porting application to Windows NT platform.

Utilized both Windows NT, Visual Basic version 4.0 and OS/2 platforms

Responsible for setting up Oracle 7.1 and 7.2 client server network. Database Administration duties included: using Oracle’s Pro C API’s.

Also responsible for developing, maintaining and enhancing a bar code scanning device driver for OS/2 and Windows NT.

BEVERLY ENTERPRISE 2/95 to 12/95

Oracle DBA/Oracle Applications Developer, OS/2 Warp 3.0 Server, Oracle 7.1 & 7.2, Pro*C 2.1, Visual Age C/C

Contractor responsible for setting up Oracle 7.0 client server network.

Database Administration duties included: creating user accounts, tuning database, creating tables and performing all the classic Oracle database administrator functions for OS/2 Warp and Windows NT.

Team lead for a six-man group.

Contract application development was for the Business Office System (BOS).

Application allowed users to add, update and delete employee and patient information in the Oracle database.

Personally supervised and instructed five junior group members in writing this C, OS/2 Oracle Pro*C application.

RISK SCIENCES, Atlanta, GA 10/94 - 2/95

Application Developer, OS/2 2.1 Server, Oracle 7.0, Pro*C 1.5, Microsoft C 7.0, Novell Netware.

Contract “C” application developer, programmer

Contract Oracle Pro C programmer

IBM OS/2 operating system programmer/developer

Saudi Arabian Monetary Agency RIYADH, Saudi Arabia 2/94 - 9/94

OS/2 2.1, IBM C Set++ (IBM C SOM (System Object Module), Windows NT Server,

Application Developer, Sybase/Oracle Development

Contract “C” application programmer/developer

IBM OS/2 operating system programmer/developer

IBM, Boca Raton, FL 9/93 - 2/94

Application Developer OS/2 2.1, IBM C Set++ (IBM C SOM (System Object Module), Advanced Power Management Object,

Presentation Manager (PM), SCO UNIX.

Contract “C” application developer

Unix and OS/2 operating systems

Contact this candidate