PROFESSIONAL SUMMARY:

• Over 8+years of strong IT Professional experience in Mainframe development, Mainframe support and Mainframe testing.
• Hands on experience on Mainframe development and support.
• Strong knowledge in CA - 7 scheduler using Mainframe.
• Hands on Experience on COBOL,JCL and DB2 Languages
• Hands on Experience on QMF and File Manager.
• Extensive experience on Mainframe tolls like ROSCOE, File Manager, Panvalet
• Expert proficiency in running Batch Jobs in Mainframe environment.
• Fixing the Mainframe Jobs that are in abended status.
• Tracking the Jobs in the spool using JHS (Job History subsystem), $U,ZEKE.
• Extensive experience in DB2 Queries.
• Extensive experience in Mainframe PLATINUM tool for tracking the online transactions.
• Expert proficiency in Manual testing using Mercury's Test Director/Quality Center.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming and stored procedures.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Abinitio
• Proficient in Testing in WINDOWS and UNIX environments.
• Extensive knowledge in regression testing and design documentation.
• Expert in Manual Testing using Mercury Interactive Tools such as: (Mercury Quality Center, Rational Clear Quest.)
• Team player with an excellent interpersonal, verbal and written communications skills, and ability to work well with a diverse team as well as ability to work independently and with minimal supervision.
• Excellent organizational, detail oriented, time management, and strong analytical and problem solving skills with consultative approach in defining solutions.
• High degree of initiative and ability to learn and adapt to new tools and technologies very quickly.

TECHNICAL SKILLS:

Operating System: MVS 390,Z/OS

Environment: Windows XP, Windows 2000

File Systems: VSAM File Management System, Text files

Languages: COBOL,JCL,DB2, and CICS, SQL,ORACLE,Informatica Power Center, UNIX,Oracle,Data Warehouse,SQL,XML,MQ, Map Reduce, Java

Tools: SPUFI,QMF,AQT,ESP,File Manager, File Aid, Endeavor, Change man, HPSC, QC,HP ALM Connect:Direct,FTP,SDSF, HPSC and CA7 scheduler tool, Agile/Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Mainframe QA Analyst

Responsibilities:

• Analysis of Client Requirement document, Functional requirement documents to formulate a test plan.
• Created Test Approach, Test Strategy and Test Plan documents.
• Developing Test Plans, Designing and Reviewing Test Cases for Functional and Regression Testing.
• Convert Test cases to Positive and Negative test cases and update them in detail in Quality Center.
• Responsible for Configuration Management of all the documents related to project.
• Participated in Walkthrough's and Technical Reviews all through the testing phase.
• Designed and Executed Regression Test Scripts using Quality Center.
• Performed Functional, System and Integration testing at every step of project development phase.
• Responsible for building Test environment to create the test data and keep them ready for test execution.
• Used HP Quality Center to enter functional requirements, create test cases, setup test lab for test case execution, analyze test results, and enter and manage defects. Wrote Detail Test Cases with Design steps, Prerequisites, Expected result, priority, procedures, test data etc. in Quality Centre.
• Conducted database testing by developing and executing SQL queries.
• Responsible for creating Test Summary reports, Learning documents and RCA report when required.
• Participate in implementation of projects.
• Developed solutions using agile methodologies.
• Reported daily status to Technical Delivery Managers and Management
• Conducting Peer reviews, interacting with the team to understand the system & plan for the same to match for time bound quality response.
• Participated daily and weekly project status meetings.

Environment: Quality center, QTP, Load Runner, SQL server, Windows XP, Black box, white box, UNIX

Confidential, Atlanta

QA Analyst/mainframe

Hardware/Software: Mainframe support using COBOL, JCL, DB2, VSAM, CA-7 Scheduler, ROSCOE, QMF, File Manager, Panvalet, Endevor, JHS, $U, ZEKE, HP QC (Quality Center), Manual testing, PLATINUM.

Responsibilities:

• Involved in the entire software development Life Cycle of the projects from Initiation to Implementation.
• Worked as Mainframe support and responsible for the requirements Analysis, Mainframe Testing and designing of the flow and the logic for the Data warehouse project.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Developed System Test Plans, Test Cases and Test Scripts based on requirements and business documents
• Developed unit test cases, configured environments, and prepared test data for testing.
• Extensively worked on delta load process, incremental load and history load
• As QA Analyst, involved in Testing, Debugging, and Bug Reporting & Documentation
• Documented test execution results, test reports, and gathered and evaluated test metrics for reporting.
• Performed in testing various complex reports in Micro strategy Reports Tools.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked on mainframe support by scheduling the Jobs using CA-7
• Running the scheduled mainframe Jobs in CA-7.
• Worked with Business analysis team to prepare a detailed Business Requirement document
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing. Performed database validation according to the business logic by comparing the source to the target.
• Performed in writing complex Join SQL queries for data validation for verifying the ETL Mapping Rules.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.
• Created test data and mock up data for testing purposes
• Test the data which loads Daily, Weekly and Monthly.
• Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Participate in daily status meeting with the management team and offshore team.
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Created Test Scenarios and Test Cases in Test lab module in the quality center and Run Test scenarios/cases in test lab module.
• Reported bugs and tracked defects using HP Quality Center
• Weekly status meetings for test planning and test preparation, daily defect status meetings for all open defects

Confidential, Framingham, MA

Mainframe QA Analyst

Responsibilities:

• Create Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.
• Provided test team status reports on weekly basis to the project manager.
• Involved in manual and automated testing.
• Worked on testing the interfaces between Web Application and IBM Mainframes
• Experience with working on background jobs and executing SQL queries on Mainframes
• Actively participated Agile and scrum meetings, review and developed test scenarios.
• Interface with client business analysts, users to define and to document the testing scope and functional requirements for the POS store applications.
• Followed Agile Methodology to emphasize on real time communication over written documentation.
• Performed Functionality testing during the various phases of the application and analyzed the results
• Conducted System Testing, Regression testing, GUI Testing and Cross Browser compatibility testing during the releases and interacted with the developers to resolve any technical issues
• Took responsibility for testing of point-of-sale system, including functional testing, bulk transaction diff testing and regression testing
• Created VB test scripts for functional and regression testing
• Experience with recovery scenario
• Regression and UAT testing in the Mainframe and AS/400 environment
• Performed Mainframe testing--TSO region and verifying the data on File Aid DB2
• Inserted Check Points to check the broken Links, Text, and standard properties of objects
• Performed data driven testing and parameterization
• Worked on various CICS screens to perform testing in the effective way
• Used AS400 to extract the file information and validate the test data
• Performed Regression Testing for all updates in AS400.
• Provided Data Driven Testing for AS400 inventory system
• Involved in creating output values using QTP.
• Tested SOA processes and methodologies used to deliver Customer order application, New Web Application and Finance application for quality standards interface to meet customer expectation.
• Involved in system & API testing for different modules
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database.
• Performed Database testing using SQL queries
• Experience in documentation using MS office tools (Word, Excel, Project, Power Point and Access).
• Created and executed scripts manually for Functionality testing
• Executed test cases through Quality Center and reported defects in QC.
• Conducted GUI, Backend, Data Driven and Security Testing.
• Conducted regression testing on new builds/versions.
• Developed and executed test cases test Scenarios and followed-up defects using Quality Center.
• Tracked defects using Quality Center.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Conducted Bug review meeting to discuss resolution of issues.

Environment: Windows, Quality Center, DB2, AS400/Mainframe, MS Access, CICS, DB2, SQL, QTP, XML, J2EE, 360 Commerce, MS Office Suite etc.

Confidential, Cincinnati, Ohio

Issuer Settlement Process: Analyst

Responsibilities:

• Interacting with product users and developers in understanding the requirements and in preparation of test plan documents
• Attending daily stand up calls with product owners and developers and train leads
• Distributing the tasks/user stories among offshore team members and helping them in Understanding the test requirements
• Preparation of test plan, execution goal plans and test case documents as per the BR and FR documents
• Preparing JCL builds for end to end testing, regression testing as per the given specifications
• Performing regression and end to end tests, functional tests
• Data validation on Mainframes using different mainframe utilities like IBM compare utilities
• Validating the loads for Dimension and Fact tables using SQL queries with QMF/SPUFI tools
• Reviewing Test cases and attending Requirements Review meetings, Team meetings
• Uploading test cases to TOSCA tool and validating against execution results
• Preparation of lesson learnt

Environment: Windows 10,Z/OS, Cobol,JCL/VSAM/Assembler, Tosca,HP ALM View,SAR,SDSF,FTP,Connect:Direct(NDM),JCL, DB2/Flat files Plus,SPUFI,QMF,Agile/Scrum