We provide IT Staff Augmentation Services!

Programmer/analyst Resume

2.00/5 (Submit Your Rating)

Webster New, HampshirE

OBJECTIVE:
A position in your IT department which would utilize my programmer/analyst experience

HIGHLIGHTS OF QUALIFICATIONS:

  • 13 years SQL experience programming management reports on a DB2 relational database using Query Management Facility to extract data and create forms and oracle database.
  • Developed procedures of up to 20 queries, creating tables and indexing them for next query to achieve final table for report.
  • 12 years Cobol programming, embedding sql into the programs.
  • History of rapid promotions with substantial increases in responsibilities
  • Took 30 classes in 20 months while working full time.
  • Excellent organizational and problem solving skills
  • Detail oriented, thorough, responsible

COMPUTER SKILLS:

  • Languages: SQL, Cobol, JCL, Unix scripts, Exposure to Visual Basic, Visual Basic.net, C, Basic, Assembler
  • Hardware: IBM mainframe, IBM PC and compatibles; Exposure to Vax Mini
  • Software: DB2, MVS, QMF, Oracle, File-Aid Spufi, TSO, JCL, TRMS, LPROS, Xcom, CA7,Savers, Sar Express, Changeman, WindowsXP, Word, Excel, Access, MS-DOS, OS2

EXPERIENCE:

Confidential, Concord, NH 7/2011 - 4/2012
PROGRAMMER/ANALYST -
Developed and maintained unemployment system for state of New Hampshire using Cobol and embedded oracle sql.

Confidential, Concord, NH 9/2007 - 5/2010
PROGRAMMER/ANALYST -
Developed new unemployment system for state of New Hampshire.
Converted acucobol software with embedded DB2 sql to cobol software with embedded oracle sql.
Developed new acucobol software with embedded oracle sql.
Converted JCL into unix scripts.
Ran testing and production cycles for new unemployment system and solved abends.

Confidential, NH 9/2006 - 6/2007
MAINFRAME DEVELOPER -

  • Ran jcl jobstreams with Cobol programs to test client data, reporting results to management and clients, troubleshooting the error messages and analyzing incorrect and misleading error messages to produce correct recommendations.
  • Developed cobol software to help testing procedures and coordinated results with management and clients.
  • Solved db2 testing problems and trained staff in use of db2 interactive utilities.
  • Trained staff in use of sql.
  • Developed eztrieve software to help testing procedures.

Confidential, Concord, NH12/1996 - 8/2006
APPLICATIONS DEVELOPER 11/04 - 8/2006
PROGRAMMER II (12/97-11/04),
PROGRAMMER I (12/96-12/97)

  • Developed SQL in DB2 environment to provide adhoc reports and files, working with end users to develop requirements and testing procedures .
  • Developed db2 database to streamline process of mailing to several categories of insurance agents, saving time and money and making process more accurate and accountable.
  • Developed Cobol reading DB2 tables with embedded SQL, Sequential files, and VSAM files.
  • Developed FOCUS, JCL and IBM utilities.
  • On call for Agency Commissions System production problems, developed a library for solving on call problems
  • Changed and tested 163 programs to upgrade agency system to newest version of cobol and system 390, writing or modifying jcl to accomplish task.
  • Audited software to improve performance time.
  • Indexed tables to change response time of one cobol db2 program from 6 hours to 1 minute.
  • Wrote jobs using multiple db2 utilities and sql to eliminate millions of outdated records, improving response time on the onlines.
  • Documented programs , data, and processes as I encountered them, saving time and money for next maintenance.
  • Programmed Excel spreadsheets and Access.
  • Developed xcom jobs to transfer data to and from outside clients.

EDUCATION:

Bachelor of Science
Business Studies with Concentration in Computer Information Systems

REFERENCES AVAILABLE UPON REQUEST

We'd love your feedback!