Sql Server Analyst

John P. Potesta

Summary

Highly motivated IT professional with proven experience in complex project lead

capacities. Strong acumen for solving coding-level problems of various applications.

Energized by challenges, steep learning curves, and high-pressure deadlines. Outstanding

analysis, reliable team player, and effective troubleshooting and debugging experience.

Strong work ethic coupled with flexibility to adapt to all technical environments.

• Experience in IBM Mainframes, AS/400, Client Server with VB 6 and MS Access.

• Experience in COBOL, PL/I, CICS, IMS DB/DC, RPG III, SDLC.

• Experience in Testing and supporting mainframe applications with File-AID

and Abend-AID

• Experience in client server using VB 6 with DB2, MS Access, SQL Server,

and CICS secure socket programs. Some VB .NET.

• Experience and Knowledge in major testing processes such as Structural(White

Box) and Behavioral(Black Box); Unit, Integration, Regression, System and UAT.

• Experience in preparing test plans, test cases and test strategies. Documentation

creation using SharePoint.

• Experience as a Sr. Systems Analyst, Sr. Programmer Analyst, DBA, Tech Lead,

Manager and Supervisor.

• Experience in Data Modeling, large mainframe conversions, vendor package

installations, support, Cost Benefit Analysis, liaisons with the user community.

• Strengths include ability in meeting deadlines and deliverables while achieving

excellence and quality of work.

•

Education

Bachelor of Science Degree - Information Systems, Minor in Accounting,

Madonna University 1986

Control Data Institute - 1978, Certificate in Programming

Wayne State University - 1974 to 1977

Lincoln Park High School, Lincoln Park, MI, Diploma 1974

Technical Skills

Hardware: IBM 3090, AS/400, PC, LAN.

Operating Systems: OS/MVS/ESA/390, IMS, Windows XP/NT/2000, Vista, OS/400.

Languages: Visual Basic 6, COBOL, RPG III, PL/I, JCL, CLIST, SQL

Familiar with VB .Net, Software AG's Natural.

Software: File-AID, Abend-AID, Endevor, Panvalet, IMS DB/DC, CICS,

VSAM, DB2, SQL Server, MS Access, EDA SQL, Visio, Word,

Excel, SourceSafe, PVCS, DB2 Connect, SharePoint, Dimensions,

ADABAS, Natural, EntireX.

Database: DB2, SQL Server, IMS DB, DL/I Total, MS Access, ADABAS.

Development & Testing:

TSO, ISPF, QMF, SPUFI, Xpediter, Endevor, Natural,

Panvalet, SQL Analyzer, File-AID, Abend-AID.

Professional Experience

American Community Mutual Insurance Company 01/2009 to

01/2010

Software Developer and Analyst

Livonia, MI

Contract to hire with Halo Group the first 6 months. Became an American Community

employee on 07/09. Analysis, design, coding, testing in COBOL, CICS, VSAM,

ADABAS, Natural and MS Access. Lead on installing McKesson ClaimCheck software

upgrade. Worked on the Medical and Dental Claims system involving knowledge of

HCPCS and CPT codes along with Medical Providers. Participated in 24/7 rotating prod-

uction support. Created a web service call from Cobol and Natural utilizing EntireX in

order to access SQL Server tables. Used SharePoint.

Environment: COBOL, CICS, EntireX, SQL Server, ADABAS, VSAM, File Aid,

Xpediter, MS Access, Natural, SharePoint, SourceSafe, File-AID, Abend-AID.

Chrysler Financial(CCI), Software Developer and Analyst 09/2007 to 12/2008

Farmington Hills, MI

Analysis, design, programming and testing of large-scale Electronic Fund Transfer

System and Dealer Accounting System using VB 6 as the front-end and CICS socket

programs as the back-end to retrieve DB2 tables on the mainframe. Worked on the

project to separate Daimler Financial and Chrysler Financial. Worked on a large scale

Sarbanes-Oxley project. Started a conversion of VB 6 to VB .NET project.

Environment: VB 6, COBOL, DB2, CICS, Word, Excel, VSAM, Xpediter, Dimensions,

File-AID, Abend-AID, Easytrieve, VB .NET.

Mastercard(Kforce), Software Developer and Analyst 02/2007 to 09/2007

Troy, MI

Design, coding, testing in COBOL, DB2 and CICS. Financial systems. Environment:

COBOL, DB2, CICS, Word, Excel, VSAM, Xpediter, Endevor, File-AID, Abend-AID.

Parishsoft, Software Developer and Analyst 09/2006 to 01/2007

Ann Arbor, MI

Analysis, design, programming and testing of the Parishsoft software package. Develop-

ment in Windows based VB 6, SQL Server 2005 and MS Access.

Environment: VB 6, SQL Server, Windows XP, MS Access.

Blue Cross Blue Shield of Michigan (Sirco), Software Developer 09/2005 to 09/2006

New Hudson, MI

Analysis, design, programming and testing of large-scale Customer Service System

called

IRIS. IRIS uses VB 6 as the front-end and CICS/COBOL as the back-end to retrieve

DB2 tables. Development in VB 6, Cobol, CICS. Used Rational Rose UML.

Worked on the Medicare Part D project in IRIS.

Environment: VB 6, COBOL, IMS DB-DC, DB2, CICS, VB 6.0, Rational Rose, Word,

Excel, VSAM, Xpediter, Endevor, PVCS, File-AID, Abend-AID.

Federal-Mogul Corporation, Sr. Systems Analyst 08/2002 to 09/2005

Southfield, MI

Analysis, design, programming and testing of conversions of large-scale systems and new

development in COBOL, CICS and IMS DB/DC on the mainframe. Worked on a large

scale migration of a COBOL, DB2, VSAM and CICS system from one mainframe to an-

other. I was in charge of this and had 1 dedicated person working for me on this and up to

3 others at other times. This involved data mapping, analysis, running meetings, user in-

volvement, project management, some travel to warehouses, coding and debugging. Used

Sarbanes-Oxley.

Environment: COBOL, IMS DB-DC, DB2, DB2 Connect, CICS, VB 6, EDA SQL,

Word, Excel, MS Access, JCL, VSAM, Xpediter, Endevor, Panvalet, File-AID,

Abend-AID.

Nexus Information Technology, Inc. 10/1997 to 08/2002

President and Owner, Sr. Business and Technical Consultant

Canton, MI

Coordinated and participated in Y2K project on the mainframe and client server. Pro-

vided leadership in ensuring all IMS, DB2 databases, VSAM and sequential files were

Y2K compliant in the Sales and Finance group. Participated in testing the systems using

Data Ager and File-AID. Supervised several programmer Analysts and contractors on

this project. Converted the Option Pricing System which is a Visual Basic client server

system using EDA-SQL and DB2 to be Y2K compliant. This involved going from VB

3 to VB 6 along with modifying code and upgrading third party VB software, user inter-

actions, application interfacing, DBA interfacing. Environment: COBOL, IMS DB-DC,

DB2, DB2 Connect, CICS, VB 6.0, EDA SQL, Word, MS Access, JCL, VSAM,

Xpediter, Endevor, Panvalet, MS Access, File-AID, Abend-AID.

Compuware Corporation, Programmer Analyst 01/1997 to

09/1997

Farmington Hills, MI

Worked on installation of Skip Trace mainframe software at Chrysler Financial.

Environment: COBOL, JCL, Xpediter, File-AID, Abend-AID, Word, Excel.

Renkim Corporation, Systems Analyst 02/1995 to 12/1996

Southgate, MI

Supervised and programmed new direct marketing systems in RPG III on an AS/400.

Environment: AS/400, RPG III, DB2, Word, Excel, MS-Access.

Federal Mogul Corporation, Systems Analyst 08/1994 to 02/1995

Southfield, MI

Lead in design and start up of an inventory control system. Successfully placed into

production. Environment: IBM 3090, IBM PC, OS/MVS, IMS DB-DC, DB2, COBOL,

VSAM, FOCUS, Word, Excel, Visual Basic 3.0, MS Access, File-AID, Abend-AID.

Ford Credit Co. (Computer Horizons, Inc), Sr. Programmer Analyst

Dearborn MI 06/1993 to 08/1994

Coordinated and participated in the production support and new development on the

Dealer System. Field Manager for Computer Horizons staff at Ford Credit which totaled

12 people.

Environment: IBM 3090, IBM PC, OS/MVS, IMS DB-DC, COBOL, VSAM, FOCUS,

Dataplex, SDLC, File-AID, Abend-AID.

Comerica, Senior Systems Analyst 03/1988 to 06/1993

Auburn Hills, MI

Project Leader on the vendor package Student Loan software. Provided leadership in the

installation of the package and the conversion of the data from the old PL/I, IMS system

into a COBOL, CICS, VSAM system. Duties included supervision, management

interactions. Started as a PA on Mortgage system. PL/I, IMS, RAMIS.

Environment: IBM 3090, IBM PC, OS/MVS, IMS DB-DC, CICS, COBOL, VSAM,

PL/I, Panvalet, Endevor, RAMIS, File-AID, Abend-AID, SDLC.

Kelsey-Hayes, Database Analyst 04/1984 to 03/1988

Romulus, MI

I was responsible for IMS and TOTAL databases and DASD management. This included

creating DBD’s and PSB’s for IMS along with designing and interacting with customers

and application support areas on new development and enhancements both in-house and

vendor package software. Started as a Programmer Analyst. Project Leader on large

manufacturing project that involved coordinating the work of up to 4 programmer

analysts and interacting with users.

Environment: IBM 4361, IBM PC, DOS/VSE and OS/MVS, IMS, CICS, TOTAL,

COBOL, VSAM.

Complete Auto Transit, Inc., Programmer Analyst 07/1983 to 04/1984

Bloomfield Hills, MI

Worked on RPG II and COBOL Inventory systems. Analysis, programming and design.

Environment: IBM 4361, COBOL, RPG II, VSAM, DOS/VSE.

Visual Services, Inc., Systems Analyst 09/1979 to 07/1983

Bloomfield Hills, MI

A Systems Analyst responsible for developing new systems and maintaining legacy

systems for this advertising and marketing company. I was an Operations Manager

for 1 year and I started this company as a programmer.

Environment: IBM 4341, COBOL, RPG II, VSAM, DOS/VS.

Data Sense, Inc., Programmer 07/1978 to 09/1979

Livonia, MI - Programmed CICS, COBOL programs for billing systems and patient

information systems for medical clients such as pharmacies, labs and doctors.

Environment: IBM 360, COBOL, CICS, ISAM, DOS/VS.

Contact this candidate