Data Analyst

To Whom IT May Concern,

Below is a list of most of my responsibilities as a Sr. Quality Assurance Analyst at my last position. The responsibilities shown below and the skills outlined in my resume will qualify me to be an experienced IT candidate for various IT positions. Please review my qualifications.

• Lead the test planning process for the project by participating in the software lifecycle from inception through implementation

• Conduct software verification planning and test case design

• Validate that the system meets functional specifications and requirements

• Validate that the system meets performance requirements

• Validate that the system meets deployment and upgrade requirements

• Execute regression tests

• Maintain scripts for the new enhancements and software updates.

• Finding, tracing, and thoroughly identifying defects; generating defect reports; working with developers and business analyst to resolve defects; and verifying corrective actions.

• Diagnose technical bottlenecks and potential software limitations.

• Identify quality metrics and tracking processes.

• Provide accurate status reports of current work progress.

• Manage the development and maintenance of automated test cases, tools, and scripts.

• Evaluates test results to accurately determine the status of product development.

• Work with other teams members effectively and with minimal supervision.

• Solid skills working with query tools (SQL), such as MS Access and spreadsheets such as MS Excel in data extracting and performing data analysis.

• Provide the team with data related to product quality.

• Track all bugs and communicates issues to ensure their resolution before product release.

Thanks for your time.

Tony Hudson

Tony Hudson

2141 West 83Rd Street 773-***-****

Chicago, IL 60620 **********@*******.***

Summary:

• Knowledgeable experience creating test plans, developing test data, retrieving production data, executing test cases, reviewing test results and writing various SQL queries for accuracy throughout the SDLC for Web-base and mainframe applications.

• Over fifteen years of IT Mainframe system experience in programming, analyzing, coding, designing, system testing and implementation.

• Professional experience in Cobol, PL/I, and Assembler using TSO, JCL, SQL, CICS, IMS/DB, and DB2, MS Windows 2000/XP, MS Excel and Access.

• Skilled in Data Analysis using MS Excel, MS Access and SAS in creating accurate detail reports.

• Team player and fast learner with excellent communication and interpersonal skills.

• Beginner’s knowledge of HTML, C++, JavaScript and Visual Basic.Net.

Skills/Tools:

Languages: COBOL-2, Assembler, PL/I, CICS, CLIST, JCL, SQL, SAS

(Beginners C++, Visual Basic.Net)

Editors: TSO-ISPF, TSO, Endeavor, File-Aid

QA Tools: TestPartner (Automation), QALoad, ClearQuest, VBA Scripts

Debugging Tool: Abend-AID, Intertest, Smart-Test

Databases: IMS (DB), DB2, MS Access

WEB: HTML, FrontPage98, Internet Explorer, Netscape

File Structure: VSAM, ISAM

Communications: CICS-Command

Operating System: MS-DOS, IBM-DOS, OS/MVS, PC-DOS,

Windows-NT, Windows-2000, Windows-XP, UNIX

Hardware: IBM 3690, IBM 370, IBM PC, IBM Laptop

Experience:

CME Group Inc.

Technology and Enterprise Computing Division

Regulatory and Administration Systems Department

Jan 2006 to April 2 2008

Quality Assurance Analyst

Responsibilities:

• Worked as a Quality Assurance Analyst to participate in the analysis of the existing mainframe system developed in JCL, DB2, and COBOL to help setup a new QA environment.

• Responsible in analyzing and testing received requests to justify all requirements worked as design.

• Update QA test database with all request information using SQL.

• Code and test JCL batch jobs to emulate the production environment for a new QA testing environment.

• Update, install and test QA JCLs and PROCs to emulate any changes the production batch jobs have.

• Develop test cases and test plans for Java Web-base and mainframe applications.

• Test Java Web-base applications manually and using TestPartner automated test scripts and in Visual Basic for Application (VBA).

• Deployed Java Web-base update builds from developer on UNIX operating system.

• Finding, tracing, and thoroughly identifying defects; generating defect reports; working with developers and business analyst to resolve defects; and verifying corrective actions.

• Data Analysis of large mainframe input data using COBOL programs, File-Aid, MS Access and MS Excel.

• Lead QA RAS team in the transition to the UC4 enterprise-wide job cross platform scheduler product for job scheduling for UNIX, Mainframe, and Windows operating systems.

Allstate Insurance Co. Northbrook, IL

Technical Shared Service/Field Support Division

1986 to June 2005

Policy Master File Support Unit

2002 - 2005

Senior Programmer-Analyst

Responsibilities:

• Participated in the analysis of the existed system developed in COBOL, JCL, IMS/DB, DB2, MS Access, and MS Excel.

• Responsible in researching and analyzing received requests to justify all requirements.

• Update MS Access database with all request information.

• Code and test Cobol modules to interrogate IMS customer database to find corrupted auto and property insurance policies base on requests from internal customers.

• Analyzed corrupted policies utilizing Smart-test, and File-Aid to report why policy was corrupted to the Data Inspection Team in a MS Excel spreadsheet.

• If requested, modified Cobol IMS modules to correct bad policies.

• Participated in team code walk-through and code design

• Create test data for testing of Cobol modules, and prepared unit test plans to cover all test cases to ensure program changes was working correctly.

• Involved in system test and model regression test to prepare code changes for production.

• Moves production-ready files and program changes to staging area with Endeavor migration systems tools.

• Resolve application maintenance inquires within established timeframes based on priority.

• Used SPUFI to execute SQL commands to verify policy information from DB2 subsystem

• Generated formatted reports using basic SAS from DB2 table fields.

Nova/Propagator Unit

1997 - 2001

Staff Programmer

Responsibilities:

• Extensively involved in the Coding of new COBOL/IMS-DB Programs Policy Scheduled Activities function for the new Propagator systems.

• Used analytical and testing skills to help Deliver the rollout of the new Nova/Propagator Cobol/IMS-DB/DB2 system on time and with in budget.

• Responsible for developing technical design for the Nova/Propagator system based on user requirements.

• Proactive in discovering potential issues and all issues resolved and communicated to the Client’s expectations.

• Assist Quality Control (QC) personnel with functional tests to tracks and resolves moderate to complex defects

• Used SPUFI to execute SQL commands, to extract data from DB2 table fields.

• Utilized SQL queries, for system string/model tests to prepared quality test data and test plans,

• Suggest quality improvements in systems processing with participation in the technical design process and involvement in test and Code inspections meeting.

• Resolve all system inquiries within established severity guidelines.

Premium Technical Support Unit

1994 - 1996

Senior Programmer

Responsibilities:

• Responsible for support and major maintenance enhancement to Alert/IBM-Assembler auto and property insurance system.

• Deliver the Quarter-end delinquency account audit reports coded in IBM-Assembler to each Regional Office Center on time with-in budget.

• Supported and deliver updated code on Policy Audit system for Fasar policy audits to access the most demanded Alert VLS file sections.

• Assist when needed to help deliver the new Regional Office Center realignment

• Gave Regional Office Center support on night calls for the Premium Technical Support unit in helping resolve system and user abends.

• Identify and participate in effective cross-training, either internal or external

• Provide user support in maintenance code for the Alert Data Entry (ADE) and Mech-Man Mechanize (MK/XX ) subsystems

• Resolve all system inquiries within established severity guidelines.

• Involved in system test and model regression test to prepare code changes for production.

• Moves production-ready files and program changes to staging area with Endeavor migration systems tools.

• Delivered all task needed from the Premium Technical Support unit's involvement to the new NOVA system implementation to convert from the Alert/IBM-Assembler

Polaris-Plus Unit

1992 - 1994

Sr. Programmer

Responsibilities:

• Responsible for support and major maintenance enhancement to Polaris-Plus/IMS-DB/PLI underwriters system.

• Involved in the Coding of new PLI/IMS-DB Programs to interrogate the IMS Customer database to produce reports for the Regional Office insurance underwriters.

• Update production JCLs and PROCs to implement new PLI/IMS-DB Programs enhancements for the Regional Office insurance underwriters.

• Moves production-ready files and program changes to staging area with Endeavor migration systems tools.

• Create test plans and test data for testing of maintenance program changes in Polaris-Plus/IMS-DB batch programs.

• Responsible for debugging program code changes with Inter-test and TSO-Test within unit test environment.

• Assist Quality Control (QC), System Analyst and insurance underwriter’s personnel in system testing to produce error free quality maintenance projects.

Polaris-Input Unit

1990 - 1992

Sr. Programmer

Responsibilities:

• Responsible for support and maintenance enhancement to Polaris-Input/IMS-DB/CICS/PLI data-entry processing system.

• Update PLI programs to modified existing data entry screens using CICS to produce an MVS-VSAM policy record file.

• Create test plans and test data for testing of maintenance program changes in Polaris-Plus/IMS-DB batch programs.

• Responsible for debugging program code changes with Inter-test within unit test environment.

• Production-ready files and program code change are move to all staging area using Endeavor migration systems tools.

• Assist Quality Control (QC), System Analyst personnel in system testing to produce error free quality maintenance projects.

• Participated in team code walk-through and code design.

Alert/Auto Rating Unit

1886 - 1990

Programmer

Responsibilities:

• Wrote maintenance code in IBM-Assembler to maintain the Alert Rating system for auto insurance policies.

• Assist company’s Actuaries in implement countrywide insurance policy rate changes within state regulations and timelines.

• Involved in the Coding of new IBM-Assembler batch programs for the Independent Agent Compensation Sub-System within the Alert Policy system under MVS with non-VSAM files.

• Interact with system analyst and Independent Insurance Agents to produce Independent Agent Compensation Sub-System within technical design specifications.

• Create test plans and test data for testing maintenance program rate changes modifications for the Alert/Auto IBM-Assembler Rating system.

• Interact with Quality Control (QC), to review test data and all possible test cases are producing the expected results base on project definition specifications.

• Wrote CLIST to produce and edited a MVS non-VSAM flat file use for background testing.

• Involved in helping resolve system and user abends.

Education:

• BS in School of Technical Careers 1985 at Southern Illinois University, Carbondale Illinois

• Primary Concentration: Data Processing and Computer Science

• Secondary Concentration: Electronic Technology

Contact this candidate