Post Job Free

Resume

Sign in

Sql Server System

Location:
Lexington, SC, 29072
Posted:
October 05, 2010

Contact this candidate

Resume:

Ron Williams

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

Lexington S.C, **072

Home Phone 803-***-****

Email abj5v2@r.postjobfree.com

ENVIRONMENTS

SQL Server, T-SQL, COBOLII, Assembler, SQL, Ezplus, OS JCL, Intertest, Xperditor, TMON, DataXpert, CICS command/Macro, Micro Focus COBOL,

Roscoe, TSO, Librarian, Panvelet, TELON, APS, ADAbase, VSAM, DB2,

IMS, BSAM, Platuim, Windows NT, Endevor, ChangeMan, MQ, FileAid, Omegamon,Spufi, QMF, Lnotes, MS Office, CA7, NDM, FTP, Erwin, Visio

WORK HISTORY

09/06 - 06/10

SOUTH CAROLINA DEPARTMENT OF EDUCATION

Data Base Administrator II

COLUMBIA S.C.

SQL Server 2005, DTS,COBOL, JCL, CICS, DB2, Clist, Rexx, Erwin, Visio

Development of SQL Server DST and T-SQL applications

Design of Data WareHouse

Responsible for DB2 DataBase and SQL Server DataBases

Develop and modify utility job for servicing

the databases including backups, reorgs and loads.

Provide support for Applicatons using DataBases

Development and maintenance of Cobol CICS DB2 programs

for all mainframe application

CICS and MVS tech Support

Systems Consultant

Keane Inc

01/02 - 09/06

SOUTH CAROLINA DEPARTMENT OF EDUCATION

COLUMBIA S.C.

COBOL, JCL, CICS, DB2, SQL Server, Clist, Rexx

Development of SNACS (School Lunch Claims Processing)

JAVA Front End to COBOL CICS Backend

Lead Analysis Responsible for Design, Coding, and Testing

of System that School Districts use to Track Food Services

Also development of Teacher Certification system

Create batch jobs for these applications.

DBA for Project - Create Tables,RI,Loads,Unloads,Reorgs,ect

Training of Team Members to Serving Application and DB2

Concepts.

Responsible for Setup and Maintaining of Test, QA, Production

Environments.

Development of SQL Server 2000 DTS and T-SQL applications for

Importing data sent from schools into data warehouse

Reported to: Gary West

BankofAmerica

12/00-01/02

Middleware group

COBOL/Batch/CICS JCL DB2/MQ

Team lead in the MME area (Move Money Engine)

Responsible for requirements/development of COBOL/batch/CICS DB2 system

used for formatting OAG messages into monetary transactions for

down stream applications.

Reported to: Mabutu Kromah 704-***-****

Tm floyd

05/99-11/00

Blue Cross Blue Shield

NSC group

CICS/Batch APS DB2/IMS JCL

Team member in the PIMS area (Provider information Management System)

Responsible for modification and development of CICS/batch APS system

Reported to: Tearsha Thompson

Team member of EMC EDI area

Responsible for modification and development of electronic

claims processing systems

dean information

01/98-03/99

Springs Industries

Y2K team

CICS/Batch COBOL DB2/IMS JCL

Team lead responsible for verifying/documenting that remedied

code functioned into the next millennium. This involved the setup

of infrastructure on an isolated lpar establishing a baseline execution

and then repeating that baseline with the system set at further dates.

Reported to: Don Broughton

keane

08/97-01/98

Mecklenburg County Government

Charlotte, N.C

Jail team

CICS/VSAM JCL

Responsible for rewrite of jail inmate booking system and

purchase of vendor software product for GUI front-end on

mainframe CICS/VSAM applications.

Reported to: Joe Palumbo

Registrey

08/96-08/97

South Carolina Electric & gas

Columbia, S.C

Production Support team

CICS/VSAM/DB2 Command level

CICS/VSAM Macro level assembler

Batch assembler

Responsible for support of the current production system

while system rewrite in process.

Reported to: Rena Wedding

keane

03/93-08/96

First Union National Bank

Charlotte, N.C

APS CICS/VSAM/DB2 JCL

Advance Technology group

Responsible for design, coding, and testing of CICS

transactions used as serving application to PC workstations

using lu6.2 communications.

Reported to: Stuart McGuire

Commercial Business Solutions group

Team lead responsible for design, coding, and testing of CICS

transactions used as serving application to PC workstations using lu6.2

communications.

Reported to: Marian Daviron

First Union (continued)

Account Analyst group

Team lead responsible for design, coding, and testing of CICS

transactions used as serving application to PC workstations using

lu6.2 communications. Also wrote numerous CICS transaction

for existing system.

Reported to: Mark Rice, Lynn Watson

08/91-03/93

NationsBank

Charlotte, N.C.

COBOL CICS/VSAM/DB2/batch

Commercial Banking group

Responsible for design, coding, and testing of CICS transactions used

to post inter-state account balances.

Reported to: Cathy Weaver

DISC_IRS, Savings, CD group

Responsible for design, coding, and testing of Interfaces for GL

conversion of DISC-IRS system on transition project of

CVN and NCNB to NationsBank for North and South Carolina,

Georgia and Florida.

Reported to: Carolyn Cline, Russ Vaughn, Drew Lockhart

TSI

02/91-06/91

Federal Land Bank

Columbia, S.C.

COBOL CICS/VSAM/batch

Responsible for design, coding, and testing of file

conversion programs for major system reform per federal requirements.

New CICS transactions written and modifications to many existing

transactions.

Reported to: Jim Jackson

TSI

10/90-02/91

University Hospital

Augusta Ga.

COBOL CICS/VSAM/batch

Responsible for design, coding, and testing of CICS transactions

used for state reporting, Security audits of on-line system,

Physician billing of hospital services.

Reported to: Frank Talbert

AGSI

06/90-10/90

Total Systems

Columbus, Ga.

COBOL CICS/VSAM/DB2

Assembler

New Systems Development group

Responsible for design, coding, and testing of CICS

transactions used for processing credit card transactions.

Reported to: Annette Patton

TmFloyd

06/89-02/90

Department of Social Services

Columbia, S.C.

Natural/ADAbase

IBM Display 370

Child Support Enforcement group Responsible for design, coding, and testing

of

management and federal reporting programs.

Reported to: Sue Reed - Systems House Inc.

TmFloyd

05/88-06/89

South Carolina Electric & Gas

Columbia, S.C.

CICS Assembler Macro/VSAM

CICS Cobol Command/DB2

Batch COBOL/Assembler

ISD group

Responsible for design, coding, and testing of Major systems

enhancements, new customer credit application.

Reported to: Steve Bozard

TmFloyed

1987/1988

Department of Social Services

Columbia, S.C.

COBOL CICS/ADAbase

Food Stamp/Welfare System

Responsible for modifications of the CHIPS system to meet

South Carolina requirements and performance considerations.

Reported to: Sue Reed - Systems House Inc.

Employee

1986/1987

Royal Insurance

Charlotte, N.C.

COBOL CICS/VSAM TELON

Sr. Programmer

New Systems Development group

Responsible for coding, and testing of CICS transactions used for

processing

Property/Casualty commercial lines. Adtec software. Development of TELON

claims

processing system.

1984/1986

Blue Cross Blue Shield of South Carolina

Columbia, S.C.

COBOL Batch VSAM/IMS

Insurance Systems Engineer

AMMS group

Responsible for modifications/support of major medical claims processing

system.

1983/1984

Policy Management Systems Inc.

Columbia, S.C.

COBOL/CICS Marco Assembler

Programmer/analyst

Version Migration

Responsible for version migration of on-line system, applying customer

modifications to new release of on-line system and installing at customer

site.

1982/1983

American Bankers Insurance Group

Miami, Fla.

COBOL Batch Assembler

Sr. Programmer

Conversion Group

Responsible for team on DOS to MVS conversion of the PMS systems. Program

modifications

development of JCL, scheduling requirements, ISAM to VSAM conversion.

Training of in-house personnel to MVS and production support.

1979/1982

Policy Management Systems Inc.

Columbia, S.C.

COBOL/CICS Marco Assembler

Programmer/analyst

Existing Program Development

Responsible for verifying customer reported problems, applying corrections

and

forwarding correction to customer.

EDUCATION

1977-1979 Midlands Technical College

REFERENCES

Available on request



Contact this candidate