SUMMARY

• More than 6 years experience in Software Development Life Cycle (SDLC) and in all phases of Quality Assurance Life Cycle.
• Extensively worked in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Modelling,Data Warehouse/Data Mart Design/Database,Teradata, ETL, OLAP, Client applications.
• Expertise in using Utilities/Tools like Mainframe, TSO/ISPF, SDSF, XPEDITER, REXX, CHANGEMAN, ENDEVOR, PREDICT, SPUFI, QMF, File - aid and CA7
• Extensive testing ETL experience using Informatica 9.5.1/8.6/8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor) Ab Initio.
• Diverse work experience in Smoke, Integration, Functional, Regression, System Testing, Compatibility testing, GUI and UAT Testing of Client/Server, Data warehouse (ETL) and Web based (Java, J2EE) Applications using Black Box testing techniques.
• Extensively Worked in Quality Assurance using Testing methods for Manual tests with all phases of Software Test Life Cycle (STLC) in Requirements gathering, Analysis, Design, Development, Implementation, Testing, Production & Maintenance Methods using Waterfall and Agile Methodologies..
• Profound knowledge of web services testing using Service Oriented Architecture tools SOAP
• Performed manual and automated test procedures for functional testing of Web services using Soap
• Involved in developing Test Plans, Test Cases, Test Scripts, Traceability Matrix, Test Environments and analyzing Test Results.
• Logged defects and documented steps by step screen shots by using Snagit.
• Good knowledge on Join conditions, Single row functions, sub queries and familiar exporting data on to Excel.
• Experience in Testing Databases(DB2, Oracle, MS SQL Server and MS Access) .
• Extensively worked with Test Management Tools like Quality Center,ALM, Microsoft TestManager(MTM).
• Have good experience in performing Verification and Validation activities which includes preparation of test scripts, step-by-step execution, consolidation and reporting bugs & defects.
• Worked on BTEQ Script
• Worked with Developers and Business Analysts to resolve the Defects.
• Developed complex Ad-Hoc queries for various Data base validations.
• Extensively worked with SQL, TOAD, and SQL* Developer.
• Extensive Testing experience in various domains like Financial and Insurance.
• Enthusiastic and aggressive to work as a self starter with very minimal inputs as well as promising and good team player ability with highly organized efforts.

TECHNICAL SKILLS

Test Management Tool: Quality Center 9.x/10/11, Microsoft Test Manager, Bugzilla

Database Tools: Informatica 9.5.1/8.6/8.1 & TOAD, Erwin r7.1/7.2Mainframe COBOL, DB2, SQL, CICS, VSAM, JCL, TSO/ISPF, SPUFIQMF, and XPEDITER, TSO/ISPF, SDSF, XPEDITER, REXXCHANGEMAN, ENDEVOR, PREDICT, SPUFI, QMFDatabase Oracle 8/9i/10g/11g, DB2, MS Access 2000

Web technologies: HTML, DHTML, XML.

Configuration Management: Clear Case

Programming Languages: C, SQL & PL/SQL

Packages: MS Office Suite.

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari

Functional Areas: Windows platforms

Other Tools: Share point, VMware

PROFESSIONAL EXPERIENCE

Confidential, Detroit

ETL Mainframe Tester

Responsibilities:

• Coordinated with the Project Managers, Business Analysts and Developers and analyzed requirements to understand business requirement.
• Develop test plans, test strategy and execution schedule.
• Participated in the meetings for Documenting Test Plan/Test Cases as per Business requirements for each release of the build.
• Administered Testing Services Environment Support using, Mainframe, CICS, DB2, QMF, JCL, TSO, VSAM, IBM Utilities, File-Aid and Test Director.
• Performed testing in mainframe environment
• Resolved data quality issues for multiple feeds coming from Mainframe Flat Files.
• Submitted JCL job streams for night-time processing in a batch IBM MVS Mainframe
• Prepared test cases based on mapping document and validated existing mappings, Sessions and workflows. The test cases are created in HP- ALM.
• Developed SQL Queries to validate the Data in both source and target Databases.
• Developed SQL queries to test Data Integrity.
• Developed complex SQL Queries by joining multiple tables for validating the data (inner join, left outer join and Right outer join).
• Validated the data in DB2 and Oracle Databases.
• Tested the ETL Process using Informatica power center.
• Tested the Data Extraction, Transformations and Data Loading.
• Validated ETL Extracts and Business Objects reports.
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Tested functionality on Various Builds and Logged Defects using ALM.
• Prepared test summary reports for each test cycle.
• Generated daily/weekly reports using ALM.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Provided the Test status report to the Test managers on daily basis.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Backend and Database Testing: Oracle, MS SQL server databases.
• Worked in Agile and scrum environment and participated in by weekly sprint.

Environment: Informatica 9.5.1, Agile, Autosys, ALM, Quality Center, SQL, PL/SQL,HP-QTP UNIX, Oracle 11g, TOAD & DB2, Mainframe, Cognos,CICS, DB2, QMF, JCL, TSO, SOAP,VSAM, IBM Utilities, File-Aid COBOL II, MVS, IDMS

Confidential, San Diego, CA.

QA Mainframe Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM)
• Performed analysis, functional, regression, integration, and system testing, data verification and validation in a batch and interactive IBM MVS Mainframe environment (TSO/ISPF, JCL, COBOL, CICS, DB2, VSAM, File-Aid, SQL, SPUFI, and QMF).
• Performed Data Mapping by moving the data from the Subscriber member database to Bus layout on the mainframe.
• Closely went through and worked on all the stages of STLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser
• Compatibility, Backend (Database) Testing.
• Proficient in writing test plans & test cases for both Mainframe & Client/Server environment
• Reviewed Informatica mappings and test cases before delivering to Client.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted data from the mainframe and sending it to the Client Server system
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested the ETL Informatica mappings and other ETL Processes.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions
• Written Test Cases for ETL to compare Source and Target database systems
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Wrote complex SQL queries using Case Logic, Intersect, Minus, Sub Queries and Union in Oracle.
• Running record count checks as well as reconciling records with source data to confirm the quality and validity of the data.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• Tested the ETL Informatica mappings and other ETL Processes. .
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Validating the reporting objects in the reporter against the design specification document.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions
• Experienced using database query tools for Oracle, SQL
• Responsible for monitoring data for porting to current versions.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Validating the reporting objects in the reporter against the design specification document
• Used HP Quality Center as test management and defect management tool.
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• Participate in daily and weekly scrum meetings

Environment: Java/Oracle9i/10g, SQL, SQL Plus, Windows NT, Share point, Ab Initio (Power Center Designer, workflow manager, workflow monitor), IBM MVS Mainframe environment (TSO/ISPF, JCL, COBOL, CICS, DB2, VSAM, File-Aid, SQL, SPUFI, and QMF).Agile,Unix,DB2,Autosys,Toad, HP Quality Center,SOAP, Windows NT, Share point, Agile, Outlook, flat Files, Traceability Matrix

Confidential, San Diego, CA

QA Mainframe Analyst

Responsibilities:

• Analyzed Business Requirement Document and involved in developing the test plan.
• Reviewed Functional Requirement Specifications and created test cases based on test scenarios based on functional requirements using MTM.
• Performed functional, integration, system, data integrity testing.
• Performed manual testing on the developed test cases.
• Reported defects using MTM and interacted with developers to resolve any defects/issues.
• Imported data from mainframe flat files and relational database (Oracle) files into SAS files per detailed specifications
• Strong experience as Mainframe Consultant working with MVS, FOCUS, COBOL, DB2, JCL, VSAM, FILE-AID, ENDEVOR, Easytrieve and related utilities on various operating systems like OS/390, AS400, MVS ESA, UNIX, and Windows 2000.
• Validated the data on Mainframes in all the CICS Screens.
• Tested Confidential Insurance new enhancements.
• Coordinated User Acceptance Test (UAT) processes and documented and addressed all the issues during the process.
• Tested Confidential Home Insurance Quote application.
• Tested the Customer Login, Register Now and Forgot username or Password Functionality.
• Reviewed BRD’s for Financial Planning application and prepared Test cases.
• Executed Test cases on Quality Center and linked defects to Test cases.
• Steps to reproduce information entered onto MTM with step by step screen shots.
• Written Test Plans and Test Cases on MTM
• Backend and Database Testing using Oracle and DB2 databases.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries
• Involved in Smoke, Functional, Integration testing, Backend testing and Regression.
• Used Pixel Ruler to test the spacing, Button sizes and Tab widths.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Tested the application by writing SQL Queries to perform back-end testing.

Environment: MTM, TFS, Water fall, MS-Office, Oracle, SQL, PL/SQL, TOAD and SQL Server 2000, Informatica, IBM Mainframes using COBOL, DB2, SQL, CICS, VSAM, JCL, TSO/ISPF, SPUFI, QMF, and XPEDITER

Confidential, Austin TX

QA Analyst

Responsibilities:

• Responsible for gatheringBusiness Requirements,Functional RequirementsandDesign Documents by coordinating with Project Managers, Business Analysts, Developers and Test Team lead to analyze and to understand the requirement.
• Participated in the meetings for Documenting Test Plan/Test Cases as per Business requirements for each release of the build.
• Review web-based application and identify critical functionalities
• Gathering, Understanding and Documenting Requirements
• Develop and execute Test Plans and Test Cases from requirements and specifications documents
• Execute manual testing for all cases
• Create test plans to detail the testing scope, requirements (high level), strategies and all needed required resources
• Perform Functional Testing, Regression Testing, System Integration testing, (UAT ) User Acceptance Testing, and End to End Testing
• Document and report all found defect in Quality Center
• Performed Backend Testing using SQL queries to validate the data in the Oracle database
• Provide all data validation through SQL queries
• Manually tested Customize and Add to cart orders for Confidential products.
• Manually tested Confidential website new features and updates.
• Involved in Regression testing for Monthly releases to make sure the application is working fine without any errors.
• Preparing Test Scenarios & Test Cases and performing Manual Testing of the application
• Performed GUI, System and Regression Testing of the application
• Reporting Bugs using Bugzilla
• Provided the Test status report to the Test lead on daily basis.

Environment: Oracle, Windows, HTML, Quality Center 10, Bugzilla, Test director, SQL Server, TOAD.