SUMMARY

• Techno - Functional experience of 8+ years of working as Software Tester/Big data Tester/ETL Tester/Quality Analyst/Lead in Information Technology.
• Extensive working exposure to different phases of Software Testing and Software Development Life Cycle ( SDLC ) methodologies including Agile Methodology and Waterfall .
• Experienced in Functional Testing, ETL Testing, Smoke Testing, Sanity Testing, Build Verification Testing, System Integration Testing, System Testing, Regression Testing, Backend Testing, Ad Hoc Testing, Positive and Negative Testing, UAT Testing, Data warehouse Testing, Mainframe Testing, GUI Testing, Big data Testing of Web Based and Client-Server applications.
• Result focused and customer oriented QA Lead with professional expertise in designing test strategy, test planning, estimation, leading test efforts for large/complex projects, led multiple projects.
• Worked side by side with development, business partners to determine optimal test coverage and ensure high quality software is delivered to our customers.
• Expertise in analyzing User Requirements, Functional Specifications ( FRS ), Business Design Document ( BDD ).
• Experienced working on Big Data technologies like Hadoop, Hive, Hbase, Phoenix using HQL, Pig scripting.
• Strong skill in Backend Testing/ Data Warehouse/ ETL/ Data Lake Testing using SQL queries on Oracle, DB2 and MS SQL Server.
• Experience with testing Full/Initial and Incremental ETL processes.
• Ability to understand complex Transformations/mappings and to prepare test scenarios and test cases
• Reviewed functional and technical requirements and design specifications to ensure quality and testability.
• Ability to lead a team amidst stringent deadlines by effectively mobilizing resources, setting clear goals, and offering constructive feedback.
• Worked as Test Lead managing the team of testers to deliver the E2E testing requirements.
• Assisted Scrum team in enabling testing of an application to ensure that business, technical, functional requirements are being met sprint over sprint.
• Experienced in creating and maintaining Requirement Traceability matrix ( RTM ).
• Experienced in testing in an Agile environment (Sprint and Kanban) with continuous development and improvement.
• Actively participate in all team ceremonies including planning, grooming, daily standup, reviews, demo and retrospectives.
• Experienced in writing Test Strategy & Test Plans, designing and executing Test Cases, interaction with developers in fixing the defects, Test metrics creation and maintenance.
• Worked with cross functional team for data needs and provide Adhoc data Support.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica/Datastage graphs.
• Tested the ETL Informatica / Datastage mappings and other ETL Processes.
• Involvement in Sprint pre-planning, Sprint planning and Retrospective meeting.
• Involvement in Test Estimations of testing efforts and Test strategy implementation.
• Expertise in running Test Scripts from HPALM and Microsoft Test Manager ( MTM ).
• Experienced in defect Tracking and Reporting using HP ALM, MTM, JIRA and VersionOne.
• Excellent understanding of all modules of Quality Center such as Requirements, Release, Test Plan, Test Lab, Defects and Analysis feature.
• Working knowledge of creating different types of test reports through Quality Center such as Test Execution Status/Summary, Defect Status/Summary etc.
• Demonstrated ability to build and maintain relationships with stakeholders, project and product managers, development & testing teams, and vendors
• Acquired knowledge, experience and understanding of domains like US Healthcare and Telecom.
• Experienced in working on virtual environments like Citrix server, VMware.
• Knowledge of Medicaid, Medicare, HIPAA guidelines and regulations.
• Effective Time Management Skills and consistent ability to meet client deadline.
• Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.
• Ability to multitask and take on new testing responsibilities in short notice.
• Organized and detail oriented thought process
• Ability to quickly grasp new technologies and react in a fast-changing environment.

TECHNICAL SKILLS

Skills: Bigdata Testing, Manual Testing, SQL, ETL Testing, Data warehouse, Backend Testing, UNIX, Mainframe Testing, UAT Testing, PIG scripting

Tools: ALM 11.0, JIRA, Quality Centre 9.2 & 10.0, Microsoft Test Manager, SharePoint, SQL Server Management Studio, SQL Developer, VMware, Citrix Server, Putty, Team Foundation Server, VersionOne, WinSQL Pro, AutoSys, IBM File Manager, JCL, Terada SQL Assistant, qTest

ETL Tools: Informatica, Data Stage

Operating Systems: Windows, HP-UX, RHEL, Solaris, IBM Mainframe OS/390

Databases: Oracle 9i/10g/11g, MS SQL Server 2007, DB2, Hbase, Apache Phoenix, Hive, Data Lake

Documentation tools: MS Office Suite, MS Project, MS Visio, MS Excel (Advanced)

Methodologies: Agile (Sprint, Kanban), SDLC, Waterfall

Scheduling Tools: Autosys, Zena

PROFESSIONAL EXPERIENCE

Confidential - Richardson, TX

Big data (Hadoop) Tester

Responsibilities:

• Analyzing Features, User Stories and Design Specifications for Test Plan, Test Scenario development and RTM preparations by utilizing the Agile test methodology (sprint/scrum).
• Create clear and understandable Test scenarios, Test cases and defects/bugs and defect tracking.
• Ability to map functional requirement with technical design and ensure the complete workflow is tested understanding the impact of dependent modules
• Requirement Clarification log for any questions/clarifications regarding requirements.
• Perform scheduled, ad hoc functional testing & regression testing, Sanity testing.
• Hands on knowledge of Hive HQL, Pig scripting
• Responsible for Daily stand-up meetings.
• Responsible for test data creation needed for ETL/UAT testing.
• Created complex SQL queries for testing.
• Test case preparation with PIG scripting based on technical design or mapping document.
• Responsible to generate the daily and weekly Status Reports and send out to all stakeholders.
• Maintained user stories, tasks, defect logging/tracking through Jira.
• Maintained test case creation and execution through qTest.
• Conducted defect triage meetings with the teams involved.
• Provided signoff for the release and Prepared test closure document.
• Co-ordinated with release manager to get the required details for user stories in the release from the testing side.

Confidential, Denver, CO

ETL Tester

Responsibilities:

• Analyzing Features, User Stories and Design Specifications for Test Plan, Test Scenario development and RTM preparations by utilizing the Agile test methodology (kanban).
• Coordinating team for daily scrum meetings and provided Fibonacci series estimates, for Agile.
• Maintained Requirement Clarification log for any questions/clarifications regarding requirements.
• Performed various types of testing such as Functional, Regression, UAT testing, ETL testing.
• Responsible for Daily stand-up meetings.
• Responsible for test data creation needed for ETL/UAT testing using IBM File Manager/WinSQL Pro.
• Created complex SQL queries for testing.
• Test case preparation with SQL queries based on technical design or mapping document.
• Running ETL jobs using AutoSys to generate the financial extracts.
• Batch testing of extracts by running mainframe jobs.
• Responsible to generate the daily and weekly Status Reports and send out to all stakeholders.
• Maintained user stories, tasks, defect logging/tracking through VersionOne.
• Maintained test case creation and execution through HP ALM.
• Conducted defect triage meetings with the teams involved.
• Provided signoff for the UAT testing and Prepared test closure document.

Confidential

Senior Software Test Engineer

Responsibilities:

• Analyzing Features, User Stories and Design Specifications for Test Plan, Test Case development and RTM preparations by utilizing the Agile test methodology.
• Extensive experience in reviewing and analyzing Business Requirements and writing detailed Test Plans, Test Scenarios, Test Cases.
• Provided test estimation and inputs for testing strategy.
• Prepare Risk Management plan.
• Performing Test Cases, Test Plan walkthrough for all stakeholders for all Agile Iterations for across the applications.
• Involved in Sprint pre-planning, planning, and retrospective meetings to derive the tasks for a specific Sprint, and perform peer reviews.
• Coordinating team for daily scrum meetings and provided t-shirt level estimates, for Agile.
• Maintained Requirement Clarification log for any questions/clarifications regarding requirements.
• Performed various types of testing such as Functional, Regression, System and Integration (SIT), Build Verification and Smoke/Sanity Testing, UI Testing, ETL Testing, UAT Testing.
• Responsible for Daily stand-up meetings.
• Responsible for test data creation and testing for UAT.
• Created SQL queries for validation of data from backend.
• Created and maintained Requirement Traceability Matrix (RTM).
• Performed testing/written SQL queries based on mapping document to test ETL code.
• Ensuring test environment set-up and test entry criteria has been achieved
• Responsible to generate the daily and weekly Status Reports and send out to all stakeholders and Tracking the execution from ALM for all Releases
• Responsible for lessons learnt and test closure report documentation.
• Conducting Defect Triage meeting with development team/Project managers/database teams.

Confidential

Senior Software Test Engineer

Responsibilities:

• Performed requirement analysis based on SRS and maintained Requirement Clarification log for any questions/clarifications regarding requirements.
• Written Test Strategy and Test Plan documents based on requirements and business design documents.
• Analysed and Reviewed requirements/Design documents to create Test Scenarios and Test Cases against technical/functional Requirements
• Creation and maintaining Traceability Matrix of test cases back to the Business requirements.
• Comprehensive experience with agile testing process. Conducted Agile Scrum meetings to discuss project progress and plan
• Performed various types of testing such as Functional, Regression, System and Integration (SIT), Build Verification and Smoke/Sanity Testing.
• Created Test Closure Report after completion of Test Execution phase. Generated various defect reports from QC for stakeholders.
• Exported Manual test cases into QC and maintained the same in the Test Lab module. Ensure that all the test cases are written and updated in QC.
• Provided linkage of all test cases to requirements in QC/ALM to establish 100% requirement coverage.
• Test data preparation activity for test execution phase.
• Executed test cases in QC during test execution phase. Monitored and tracked defects logged during execution of test cases. Performed defect management activity.
• Daily participation in defect call internal and External both for Update of defect and patches availability.
• Routine Conference calls for Progress, Updates and Issues with Superiors and On Site Managers
• Follow up with development team/defect fixing team to get the defect resolved as soon as possible.
• Allocated resources/work (test preparation and execution activity) according to skills.
• Generated and published various Daily and Weekly test status reports during the test preparation and execution phase.
• Reviewed test cases written by the peer groups.
• Mentored the new associates for the domain and application knowledge.
• Prepared documents related to application testing of the project.