SUMMARY

• Over 10+ years of experience in software industry in various types of testing including ETL, Mainframe systems.
• Identifying business and functional requirements and preparing & mapping the Requirements against the Test Scripts/Test Cases.
• Developed mainframe applications using COBOL, DB2, VSAM and JCL.
• Experience in Data Warehousing/ ETL Testing within the environment of DB2, Oracle, SQL Server and Informatica Power Center 9.1.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Experience includes testing of applications which use integrated databases like SQL server, Oracle, IMSDB and DB2.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into technical specifications.
• Tested UNIX shell scripts and SSIS Packages written for ETL Processes.
• Excellent Functional knowledge on various domains like Healthcare, Finance/Banking, Mortgage Industries, ETL/Database management, Telecommunications.
• Experience in designing strategy documents, documenting, and executing test plans, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Well versed with writing detailed test cases for functional requirements.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Expert in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End - to-End Testing, Regression testing & User Acceptance testing (UAT)
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Expertise in use of Quality Center for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Expertise in validating end user reports with tools IBM DB2, SQL server management tool, and TOAD and SQL developer.
• Excellent knowledge on vision plus 8.17 credit card processing flow.
• Experienced in working in Test Management tools - HP Quality Center, SQUIDS, TFS
• Experience in Test Design, Test Execution and Defect Management.
• Expertise in designing and developing QA test estimation, test plan, test cases review and generating test reports, defect reports and product quality assurance documentation.
• Team player with good communication and inter-personal skills.
• Proficient in QA Quality Assurance and have hands on experience in manual testing.
• Client coordination and working closely with the project team (DEV, QA, UAT and PM)
• Ability to handle multiple priorities and manage within deadlines
• Expertise in Software Development/Test Life Cycle and Agile Test Methodologies
• Experience in working with ‘Agile’ methodology and its various stages including sprints, scrums.
• Working as Module Lead for more than 4 people working at an onsite/offshore model.
• Involved in requirement gathering with customer for new testing region.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS

Operating System: OS/390, MVS, WINDOWS, IBM

Testing Tools: Encompass, AQT

Programming Languages: PL/SQL, JCL, COBOL

Mainframe Scheduler Tools: OPC, CA7

Mainframe Tools: TSO/ISPF, File-Aid, NDM, Change Man, File manager, CCF, B92, CICS

Data Bases: DB2, Oracle, IMSDB and SQL Server

Data Base Validation tool: TOAD, IBM DB2, SQL Server Management

ETL Tools: Uni Viewer Console, SSIS Packages, Informatica

Defect Tracking Tools: HPALM Quality Center 12.01, SQUIDS, TFS

PROFESSIONAL EXPERIENCE

Mainframe QA Lead

Confidential

Responsibilities:

• Run the Truck, Engineering and vendor related Batch Jobs using JCL’s for System & Integration testing.
• Worked on promoting JCL, COBOL/DB2/IMSDB code into test regions for SIT testing.
• Modified JCL’s in test regions to point test environment.
• Coordinating with upstream and downstream systems’ teams, to plan and execute data integration scenarios for Confidential .
• Addressing data requirements for downstream systems in a timely manner.
• Used SQL queries for validating data in database.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Executed and managed test cases and reported bugs in TFS.
• Participated in User Acceptance testing (UAT) and involved in UAT test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Published Weekly status report to the management.

Mainframe QA Lead

Confidential, VA

Responsibilities:

• Applied Business rules to sync Fannie mac features.
• Coordinating with upstream and downstream systems’ teams, to plan and execute data integration scenarios for SAP.
• Understanding transaction flows from Business teams.
• The scenarios include generating data in upstream systems and validating transformations in SAP.
• Addressing data requirements for downstream systems in a timely manner.
• Developed new test regions (Set up test JCL, COBOL programs) for integration testing with upstream and downstream systems. Worked on promoting COBOL/DB2 and COBOL/IMD DB code into new test regions for integration testing.
• Used SQL queries for validating data in database.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Mentoring the offsite team and reviewing their work.
• Executed and managed test cases and reported bugs in HPALM 12.01 Quality Center
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Mainframe QA Lead

Confidential

Responsibilities:

• Run the RTV/CRC Batch Jobs using JCL’s for System & Integration testing.
• Involved in Creating and closing RTV orders from CICS screens through interacting with multiple teams (WMS, CEB).
• Worked on promoting JCL, COBOL/DB2 code into test regions for SIT testing.
• Modified JCL’s in test regions to point test environment.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Validated data in between source and target after running UNIX Shell scripts.
• Used TOAD to write SQL queries for validating data in backend ORACLE database.
• Mentoring the offshore team and reviewing their work.
• Executed and managed test cases and reported bugs in HPALM 12.01 Quality Center
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines
• Prepared Test summary report after SIT and providing support to UAT.