IT and Database Administrator Resume Pittsburgh, PA - Hire IT People

TECHNICAL SKILLS

Applications: Banking, Health Care, Non - Profits.

Database Systems: DB2

Languages, Software, and Utilities: ClearQuest, Cobol, Dump Master, Endevor, ESP, File Manager, HTML, JCL, MS Office, SQL, Syncsort, Trace Master.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

IT and Database Administrator

Responsibilities:

Retrieve Confidential information from the Confidential Pro database for reports
Submit purchase orders
Reconcile donations with accounting information
Assist with IT issues.
Set up new employees on the Office 365 platform.
Work with various vendors regarding the Confidential mailings.
Work with the IT consulting firms regarding networking/IT issues and resolutions.
Assist the front desk with taking phone calls and assisting walk in requests

Confidential, Pittsburgh, PA

Senior Application Developer

Responsibilities:

Worked on the Membership Systems team in the healthcare system.
Created and maintained various programs for clients for open enrollment, member mailings, and downstream vendors.
Worked on the SOX Audit project. Created a program that was placed in the proc used by all the Confidential Systems jobs to audit the inbound records received from clients.
Worked on a project to create a message in XML format on the mainframe to write to an MQ Series message queue.
Developed technical designs for other developers that adhere to Service Oriented Architecture (SOA) standards.
Worked as the technical lead on smaller projects. This involves meeting with the business team, analysis, design, assisting the developers, and performing code and unit test reviews.
Assisted in the design and development of a new DB2 table for a new process.
Participated in the Agile process on one project.

Confidential, Pittsburgh, PA

Programmer Analyst

Responsibilities:

Creating the design of the DB2 tables, working with the DBAs to normalize and partition the tables.
Modifying the code to access DB2 databases instead of gdg and vsam files
Working to bring the system up in production
Performance tuning and maintaining the system
Training coworkers on the updated Compare system
Set up the processing for handling Visa Extras and MasterCard Rewards transactions.
Set up the processing for the monthly accumulation and processing of Visa Vital and Nova Network transactions (payment card processing networks).
Created and maintained Cobol programs, JCLS, PROCS, Clists, and panels for a number of projects.
Researched and performed data mapping for new programs.
Created design documents, test plans, implementation plans, and post-implementation plans.
Performed integration testing with the business clients and the Tandem system.
Handled abend situations during work hours and on an rotational schedule during off hours.
Created the initial manuals for and participated in the disaster recovery tests.

Confidential, Pittsburgh, PA

Programming Consultant

Responsibilities:

Created programs containing DB2. These programs involved analyzing and updating databases.
Created batch programs to receive information from tables, print reports, and update the tables automatically.
Created Cobol subroutines that receive information passed from a main program.
Created SQL copybooks for use by multiple programs.
Created test plans and modified specifications for programs.

Confidential, Louisville, KY

Programming Consultant

Responsibilities:

Prepared code for year 2000 compliance using Cobol.
Performed Logic Correction Renovation and Renovation Quality Evaluations on Cobol code containing DB2 and some IMS using Peritus Software Systems internal software.
This project involved performing the identification of date sensitive variables and either performing the logic corrections or creating a report to assist the clients with performing their own renovations.

We provide IT Staff Augmentation Services!

It And Database Administrator Resume

Pittsburgh, PA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship