Sql Server System

Art Babcock

Contact:

N****

Rehms Road

eshti

go,

Wisc

onsin

5415

7

hone

:

(920)

883

8760

mail:

abab

coc

@gm

ail.co

m

Objective: To successfully design, program and support computer application systems.

Summary: Application Programmer/Analyst with over 10 years of experience with Client

Server and Mainframe Applications including interfaces between environments.

December 28, 2012 Page 1 of 3

Technical Experience

CLIENT SERVER: VB .Net, C, XML, MS Office Professional, MS Office Applications (Outlook, Word,

Excel, PowerPoint, Access, Visio), Beyond Compare, FTP, WebSphere MQ, MQ, MS SQL Server,

Crystal Reports, Business Objects, SQL Server Integration Services (SSIS), Data Transformation

Services (DTS), VSS, ODBC.

MAINFRAME: SAS, PL/1, Fortran, COBOL, EZTRIEV, Dylakor, CSP, AS (Application System), CA7,

ZEKE, JCL, CLIST/REXX/Dialog Manager, Panvalet, Endevor, VSAM, File Aid, TSO/ISPF, IOF, DB2,

DB2 Utilities, IMS, RACF, SPUFI.

Career Summary

Dreams Consulting Corporation of America, Peshtigo, Wisconsin 1/2010 Present

APPLICATION DEVELOPMENT PROGRAMMER/ANALYST, at Integrys Energy Group/Wisconsin Public

Service Corporation. (Transferred from Russell A. Brungraber Consulting, previous position, to Dreams

Consulting Corporation of America).

Please see following for details:

Russell A. Brungraber Consulting, Green Bay, Wisconsin 7/2000 – 12/2009

APPLICATION DEVELOPMENT PROGRAMMER/ANALYST, at Integrys Energy Group. Enhancement and

Support of Legacy, Client Server and Interface Systems.

Gas Services System. System tracks periodic gas service maintenance. Extensive use of MS SQL

server stored procs, Crystal Reports and CMC (BOXI Central Management Console).

Automated Transformer Load Management. System calculates transformer loads using Utility

Billing, Meter Records, Transformer Records and GIS Mapping. Fine tuned formulas which lead to

very high level of accuracy. Added real time access to parameter driven over loaded/under loaded

reporting utilizing features of Crystal Reports made available companywide through company web

portal. Enabled engineering to greatly reduce costs by more accurately matching transformer

capacity with actual loads.

Enhanced and Supported Legacy Gas Leak Management and Reporting. System interfaces with

two different Client Server systems, Order Processing and Outage Management utilizing MQ/XML.

This is a cross platform system with both legacy mainframe software and VB .net applications with

DB2 and MS SQL Server data bases. Improved accuracy and reliability to minimize manual

intervention and improve data integrity.

Resume for: Art Babcock (continued)

Supported Electric Pole Shared Facilities Legacy System. Electric Utility provides space on poles

for third party equipment, cable, phone, etc. This system maintains attachments for rental billing.

System also interfaces with PeopleSoft using FTP. Clist, PL/1, DB2, SAS.

Supported Transformer Records Legacy System. This system interfaces with PeopleSoft system

known as I9 using MQ/XML. System utilizes legacy AS software, VB .Net, MQ/XML, AS

(Application System).

Supported Meter Records Legacy System. Meter Records interfaces with Utility Billing with both

MQ/XML and mainframe batch systems primarily SAS, PL/1, DB2, AS (Application System).

Supported Cathodic Protection Legacy System (underground metal pipe). System maintained

inspection records. Clist, PL/1, DB2, SAS.

Supported interface between Utility Billing and Meter Records. Software included .NET, DB2, MS

Sql Server, SAS, PL/1.

Supported and maintained Distribution Overhead Visual Observation Process (DOVOP) VB .Net,

MS SQL Server and MS Access application to manage/maintain utility poles. MS access with

ODBC connections to MS SQL server.

APPLICATION DEVELOPMENT PROGRAMMER/ANALYST, at Wisconsin Public Service Corporation

Utility Billing Conversion, 7/2000 – 9/2005

Programmer/Analyst Utility Billing Conversion DB2 to SQL Server. Responsible for

programming and executing tests that converted billing financial data from legacy DB2 databases.

Russell A. Brungraber Consulting, Green Bay, Wisconsin 1997 – 6/2000

APPLICATION DEVELOPMENT PROGRAMMER/ANALYST, at Fort James Paper Corporation COSMOS

(Customer Order Servicing),

Programmer/Analyst Invoice Pricing and Merger Activities

BBA Information Systems, University of Wisconsin Madison School of Business, Madison Wisconsin

Community Activities

Community Band

Church Orchestra and Music

FIRST Volunteer (For Inspiration and Recognition of Science and Technology)

Volunteer North East Wisconsin Dance Organization – Nutcracker Ballet

Contact this candidate