Post Job Free

Resume

Sign in

Customer Sql

Location:
New Port Richey, FL, 34655
Posted:
February 14, 2011

Contact this candidate

Resume:

Arthur Allen

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

Trinity, Florida 34655-5353

727-***-****

Programmer Analyst/Software Developer taking advantage of my 19+ years of

abhtdl@r.postjobfree.com

experience.

Work Experience

7/2010 – 11/2010

07/2010 - 11/2010

Migration Specialist

T3 Technologies T3 Technologies, Tampa, FL.

Tampa, FL Coding & Unit Testing (Micro Focus COBOL product suite, Embedded SQL,

ISAM(VSAM), MSSQL Server, VMware Player, Microsoft Batch Scripting, JCL – DOS –

z/OS).

5/2006 – 12/2009

Migration of ANS COBOL, COBOL 1974, COBOL 1985 to Micro Focus COBOL

Utility Consultant

product suite. Migration of EBCIDIC data files (VSAM variable & fixed length records,

Blue Heron Consulting, DB2 to MSSQL) to ASCII data for use on Micro Focus Main Frame Servers. Migration of

Rochester, NY DOS/VSE, MVS Job Control Modules for use on Micro Focus Main Frame Servers. Unit

Testing of migrated COBOL modules, JCL members & data files on the for use on Micro

Focus Main Frame Servers.

01/2009 - 12/2009

Contract at City of Raleigh, NC, Coding (Micro focus COBOL, VSAM, Oracle 10g /

11g, SQL, SQL*Loader, Linux scripting) & Unit Testing (execution of Gladstone Micro

focus COBOL modules) for the migration of CIS customers from SCT Banner application

to Oracle SPL's CC&B (Customer Care & Billing) application.

09/2008 – 12/2008

Contract at City of Raleigh, NC, Data Mapping, Data Integrity Reporting (Modifying &

execution of Gladstone Micro focus COBOL modules), MS Office, MS Word, MS Excel,

MS Visio) for the migration of CIS customers from SCT Banner application to Oracle

SPL's CC&B (Customer Care & Billing) application.

01/2007 - 08/2008

Contract at Kansas City Power & Light, (Natural/Oracle – Batch, Online, Structured &

Report mode, Embedded SQL, Syncsort) coding and unit testing of modules for Credit &

Collection, Bill calculation, Meter Management, Payment processing, Meter Reading

activities (Unix scripting) during merger of accounts acquired from Aqulia.

06/2007

Contract with Grant County PUD, Coding (Micro focus COBOL,

Embedded SQL) and unit testing of Meter Reading ERT upgrades.

Contract with Benton County PUD, Kennewick, WA for Coding (Micro

focus COBOL, Embedded SQL) and unit testing of Bill Print Extract updates.

08/2006 – 12/2006

Contract at Kansas City Power & Light, (Natural/Oracle – Batch, Online, Structured &

01/2006 – 05/2006

Report mode, Embedded SQL, Syncsort) coding and unit testing of Mobile Data

Utility Consultant

modules (Unix scripting) for Credit & Collection activities.

Accenture Tech.

Solutions, 05/2006

Tampa, FL

Contract at Conversant, Inc. (Joplin MO) for data mapping (MS Office, MS Word, MS

Excel, MS Visio) of Legacy CISPlus data fields for conversion to Customer Watch

06/2004 - 12/2005 customer information system.

Utility Consultant

Blue Heron Consulting,

Rochester, NY 01/2006 – 05/2006

Accenture, Tampa FL

Technical Support (SQL, DB2/QMF,TSO,ISPF,SPUFI) – Customer 1 CIS

Application.

Customer Billing, Customer Data, Meter Reading.

06/2005 – 12/2005

Contract at Rochester Gas & Electric for (Natural/Adabas – Batch, Online, Structured

& Report mode, Syncsort, SQL, Embedded SQL, N2O Natural software version

control) coding, unit/system testing and implementation of new Bill Print process for 2nd

02/2004 - 03/2004 year of the Voice Your Choice program (Utility Alternative Suppliers) deciding between a

Programmer Consultant fixed or variable price for electricity supply. Voice Your Choice post production support

(OS390/MVS, TSO/ISPF/SPUFI, JCL).

Systems West, Salt

Lake City, UT 02/2005 – 06/2005

Contract at California Water performing coding (Micro focus COBOL/Oracle, SQRs,

06/2001 - 12/2003 Embedded SQL), unit testing and implementation of PeopleSoft CIS enhancements

Utility Consultant including payment interfaces, bill print extracts (Unix scripting) and preparation for the

upgrade implementation of PeopleSoft 7.6 to 8.95.

Blue Heron Consulting,

Rochester, NY

06/2004 - 02/2005

Contract at Rochester Gas & Electric for (Natural/Adabas – Batch, Online, Structured

& Report mode, Syncsort, SQL, Embedded SQL, N2O Natural software version

control) coding, unit/system testing and implementation of new Bill Print process for

Voice Your Choice program (Utility Alternative Suppliers) to decide a fixed or variable

price for electricity supply. Voice Your Choice post production support (OS390/MVS,

TSO/ISPF/SPUFI, JCL).

10/1999 - 2/2001

02/2004 - 03/2004

Senior Specialist R&D

Texas Utilities, (Micro focus COBOL) coding and Unit testing for EDI upgrade.

SAGA Software, INC,

Reston, VA 06/2003 - 12/2003

Contract at Rochester Gas & Electric for (Natural/Adabas – Batch, Online, Structured

& Report mode, Syncsort, SQL, Embedded SQL, N2O Natural software version control)

coding, unit/system testing and implementation of new Bill Print process for

Consolidation of EDI accounts. Bill Print process post production support (OS390/MVS,

TSO/ISPF/SPUFI, JCL).

06/1998 – 08/1999

Consultant 06/2001 – 12/2002

Maxim Group, Pittsford, Contract at Pacific Gas & Electric included business analysis, technical analysis,

New York technical design(MS Office, MS Word, MS Excel, MS Visio), coding (Cobol, DB2/QMF,

VSAM, SQL, Embedded SQL), unit/system testing and implementation of Financial &

Statistical Audit Control processes in the data migration/conversion of 6.5 million Pacific

Gas & Electric customers to a new Customer Information System application

10/1982 – 06/1998 (OS390/MVS, TSO/ISPF/SPUFI, JCL, SPL's DB2 CorDaptix).

Rochester Gas and

Electric Corporation 10/1999 - 2/2001 SAGA Software, Inc

Rochester, New York Business analysis, technical analysis, technical design, coding, unit testing and

implementation of middleware between Windows NT and many different platforms.

Business and technical analysis, design, coding, unit testing and implementation of

Native CICS Adapter(s) (JAVA middleware) with Saga Software's Sagavista and Saga

Software's mainframe CICS communication software. Support for the Senior Specialist

developing mainframe (OS390/MVS, Z/OS, TSO/ISPF/SPUFI,VSE and IMS)

communication software between CICS and Windows NT (JAVA applications).

06/1998 – 08/1999

Business analysis, technical analysis, technical design (MS Office, MS Word,

MS Excel, MS Visio), ( OS390/MVS, TSO/ISPF/SPUFI, Natural/Adabas – Batch,

Online, Structured & Report mode, SQL) coding, unit testing and implementation

of Year 2000 remediation for multiple applications.

Rochester Institute of Technology June 1998 – November 1998

University of Rochester December 1999 – June 1999

Senior Analyst 1992-1998: Production Support, Business analysis, technical

analysis, technical design (MS Office, MS Word, MS Excel, MS Visio),

Natural/Adabas, Syncsort, Cobol, Cobol II (OS390/MVS, Z/OS, Panvalet

version control, VSAM, CICS) coding, unit testing and implementation of

corporate projects to enhance the Customer Information System.

Analyst 1989-1992: Production Support, Analysis, design, (MS Office, MS

Word, MS Excel, MS Visio), Cobol, Cobol II (OS390/MVS, Z/OS,

TSO/ISPF/SPUFI, Panvalet version control, VSAM, CICS) programming and

unit testing with the Customer Support Group in support of the Company’s

Customer Support System.

Associate Analyst 1988-1989: Production Support, Analysis, design (MS

Office, MS Word, MS Excel, MS Visio), Cobol, Cobol II (OS390/VSE,

TSO/ISPF/SPUFI, Panvalet version control, VSAM, CICS) programming and

unit testing with the Customer Support Group in support of the Company’s

Customer Support System.

Computer Operator 1982-1987

Education

5/1985 Saint John Fisher College, Rochester, New York

Bachelor's Degree (B.S. Management)

5/1974 State University of New York @ Morrisville, Morrisville, NY

Associate Degree (Data Processing)

Skills

Skill Name Skill Level Last Used/Experience

• CC&B (Customer Care & Billing – Oracle/SPL CIS applications) Currently used/2

Cordaptix 8 years ago/2

CISPlus 1 year ago/10

• Gladstone Conversion Application Currently used/1 1/2

• Linux/Unix shell scripts Intermediate Currently used/2

• Adabas SQL Expert 2 years ago/7

• Assembler Intermediate +4 years ago/7

• COBOL (COBOL II) Programmer Expert Currently used/17

• DB2 SQL – Query Management Facility Intermediate Currently used/2

• VSAM Intermediate +4 years ago/7

• SQR Intermediate 2 years ago/1

• JCL - Job Control Language Expert Currently used/10

• Proc(s) – Stored JCL procedures Expert Currently used/10

• Micro focus COBOL Intermediate Currently used/3

• Natural Programmer Expert Currently used/10

ADABAS/Oracle

• N2O (Software Version Control) Intermediate +4 years ago/7

• Syncsort Expert Currently used/10

• TSO (ISPF)(SPUFI) Expert Currently used/15

• Java Beginner +4 years ago/1

• CICS Beginner +4 years ago/1



Contact this candidate