SUMMARY

IT professional with industry experience in finance, healthcare, and insurance. H eld positions as a QA/Developer/Analyst. Proven track record of designing and implementing successful projects. Ability to adapt to new environments. Dedicated, enthusiastic, and goal - oriented.

TECHNICAL SKILLS

• IBM Utilities
• SQL
• Oracle
• MS Office Suite
• Visio
• Endeavor
• VBA
• Cobol
• SAS
• Focus
• Ezytrieve
• BAL
• Access
• DB2
• IMS
• Datacom
• PL/SQL
• SPUFI
• QMF
• CICS
• VSAM
• IBM PC
• IBM Mainframe
• Windows
• DOS
• TSO/ISPF
• Fileaid
• Insync
• IBM Utilities
• JCL
• FTP
• NDM
• SDLC
• SVP (Store Vision Platform)
• SOAP
• HOGAN
• Quality Assurance
• Test Director
• QA
• CDTS (ClearQuest Defect Tracking System)

PROFESSIONAL EXPERIENCE

Confidential

Analyst and QA Tester

Environment: Banking, IBM Mainframe, IBM PC, Z/OS, Windows TSO/ISPF, Cobol, Eztrieve, DB2, CICS, SPUFI, QMF, BMC, CA Fileaid, INSYNC, JCL, EDI, FTP, Endevor, MS Office Suite, SOAP, Access, Quality Center, HOGAN

Responsibilities:

• Provided QA systems interface testing tasks for new business.
• Regression testing performed to insure no new faults have emerged into the system.
• Also did testing to validate fixes entered into the production system.
• Used the IBM Rational ClearQuest management tool to log and track bugs throughout the development and testing process.
• Analyzed and monitored defect progress by executing queries.
• Created data on HOGAN and mainframe databases to produce the technical environment for validation of new business functionality as well as to insure no impact on existing functionality.
• Extracted data from mainframe relational database tables using SQL tools, moved data to PC and/or server platforms creating text files that could be loaded to spreadsheets and Access databases for analysis and reporting.
• Transferred data from server files to mainframe sequential files and loaded into mainframe relational database tables.
• Testing strategies included, but not limited to, black box testing, white box testing, unit testing, functional testing, regression testing and system testing.
• Utilized HP Quality Center to organize and manage test plans for testing the various types of cards and activity involved in the Plastic Issuance system such a debit or atm card.

Confidential

Programmer Analyst / Developer

Environment: Banking, IBM Mainframe, IBM PC, Z/OS, Windows TSO/ISPF, Cobol, Eztrieve, DB2, CICS, SPUFI, QMF, BMC, Fileaid, INSYNC, JCL, EDI, FTP,Endevor, MS Office Suite, Access, HOGAN

Responsibilities:

• Analyzed architectural documents to produce technical specifications for coding new programs.
• Coded, tested and implemented new COBOL DB2 online and batch programs to meet the requirements of new business requests.
• Prepared test environments to unit test new programs and/or changes to fix production problems.
• Worked on requests requiring table changes in DB2 tables.
• Setup test environments for QA’s and coordinated with the testing.
• Responsible for moving code and components from deployment area to the enterprise system environment.
• Participated in project discussions and weekly status meeting of the projects with the team.
• Identified defects and reported them using IBM ClearQuest.

Confidential

Programmer Analyst and QA Tester

Environment: Services, IBM Mainframe, IBM PC, Z/OS, Windows, TSO/ISPF, Cobol, DB2, CICS, SPUFI, QMF, Fileaid, JCL, FTP, Agile methodology, Quality Center, MS Office Suite, VBA

Responsibilities:

• Used HP Quality Center to organize and manage testing efforts including writing manual test cases and test scripts, logging and tracking defects and doing requirements management.
• Built test scenarios and test cases (negative / positive) to validate expected results.
• End-to-end testing migrating data from mainframe doing ETL to a server Data Warehouse then a reformat of data into relational databases and then validation of data via web based applications.
• Tested and insured that legacy data mapped and conformed into the new system architecture.
• Black box ETL validation using all available resources.
• Validated data using various tools including PL/SQL, Excel, VBA, and Access and mainframe resources.
• Identified defects and reported them using Quality Center.
• Constantly worked at improving and simplifying procedures and processes to speed up and validate data.

Confidential

Programmer Analyst

Responsibilities:

• Wrote several Focus programs for evaluating warehouse and legacy data.
• Analyzed requirements in order to produce solutions for programming, testing and implementing the technical functionality needed by the Hogan support team.
• Responsible for project design, providing technical documentation, test plans, and test results in a timely fashion.

Confidential

Programmer Analyst and QA Tester

Environment: Investments, IBM Mainframe, IBM PC, Z/OS, Windows, TSO/ISPF, Cobol, DB2, CICS, SPUFI, QMF, Fileaid, JCL, FTP, Endevor, MS Office Suite

• Participated in all phases of system development including requirements gathering and analysis through project design, development, testing, implementation, deployment, maintenance and enhancement.
• Executed unit and system testing for batch and online development, enhancements, and production support; validated and documented the results
• Provided system architects with information on current system functionality in order to enhance and improve performance in the daily batch cycle.

Confidential, MN

Programmer Analyst/Developer

Environment: Investments, IBM Mainframe, IBM PC, Windows, TSO/ISPF, Cobol, DB2, IMS, CICS, JCL, EDI, MS Office Suite

Responsibilities:

• Tested, developed, and implemented solutions according to company procedures, standards, and processes.
• Enhanced and developed batch and online modules with IMS and DB2 database interfaces.
• Inserted HIPAA requirements into new and existing programs.
• Analyzed functional specifications and use case documentation to produce technical specifications for modifying existing programs or developing new programs.

Confidential

Programmer Analyst

Responsibilities:

• Developed test cases based on standard SDLC documentation (requirements / design).
• Provided analysis, design and programming to support the implementation of new business requirements.
• Wrote several SAS programs to reformat data to produce reports and/or load into DB2 tables for used by mainframe applications.

Confidential

Analyst/Tester

Responsibilities:

• Identified and documented test cases and test scenarios from business requirements, application design documents and system architecture documents.
• Ensured all test cases are traceable to requirements and all requirements are traceable to test cases.
• Verify data integrity utilizing SQL.
• Recorded all test defects in Test Director for follow up.

Confidential

Programmer Analyst/Developer

Responsibilities:

• Investigated and fixed problems of abended jobs in different systems and restart/rerun the jobs.
• Developed and implemented a project plan for NDM delivery of a host of files modified for Y2K enhancements.
• Created and modified JCL scripts while setting up test environments.
• Helped with conversion of Piper Jaffray IBM DOS VSAM assembler programs to MVS COBOL CICS/DB2 programs in the merge between Piper Jaffray and Confidential .