SUMMARY

• 10 years of experience in Software Testing and Quality Assurance
• Profound knowledge in Test Planning, Test Design, Test Execution, Documentation, and User Acceptance
• ISTQ Certified TesterProficient working in Agile/Sprint/Iteration, Scrum, V project methodology
• Used JIRA, HP ALM (Quality Center) and Clear Quest for Project Lifecycle and Test Management respectively
• Requirement Analysis, Author Test Cases, SQL Statements, Create Test Data, Set - up Test Environment, Execute test cases for Functional, System, Integration, Conversion/Migration, Automation and Regression Testing
• Automated end-to-end functional/regression test cases using HP QTP
• Tested applications that use ETL processes for extracting data from variety of sources, data transformation and loading data to a data warehouse
• Very good at troubleshooting and has knack for finding application issues at the earliest
• Excellent analytical, written, verbal, interpersonal and team communication skills
• Quick learner and excellent team player, ability to meet tight deadlines under work pressure
• QA Analyst, Onsite Coordinator, Test/QA Lead with all-onsite and large onsite-offshore work models in several assignments
• Set-up testing team, methodology and processes for a Data Warehouse team from the scratch
• Acted as SPOC for team in SQA activities - Reviews, SQA Validations, RCA, Project Metrics, and External Audits
• Lead testing teams with sizes ranging from 4 to 28
• Worked with web/browser, mainframe, database, ETL/data warehouse applications
• Won many Awards and Rewards for best performance throughout

TECHNICAL SKILLS

Test Management: HP ALM (Quality Center), Clear Quest, JIRA

Test Automation: QTP, HP Service Test, SOAP UI

Defect Management: HP ALM (Quality Center), Teamtrack, Bugzilla, Lotus Notes

Database: Oracle, SQL Server, DB2, MySQL

Database Tools: SQL Server Studio, SQL Developer, TOAD for IBM DB2

Web Technology: HTML, XML

BI: DataStage, Cognos

Configuration Management: CVS, VSS, Sharepoint

PROFESSIONAL EXPERIENCE

Test Lead/Senior

Confidential, AL

Responsibilities

• Train existing team members on Guidewire OOTB functionalities
• Review requirements and prepare estimations for Conversion, Configuration, Integration testing
• Create test plan detailing test cases, strategy, risks, assumptions and dependencies
• Discuss with BA and Development teams, schedule user stories for Test Planning and Execution for each Sprint
• Liaise with BA, development, onsite and offshore teams in creating high quality test cases and test execution
• Set up meetings with business and development teams to walkthru Test Plans for each Sprint
• Create JIRA dashboards, sprint burndown charts, velocity charts, track testing status, monitor issues and mitigate risks
• Prepare test cases using HP ALM, set-up test data and execute test cases
• Conduct defect triage meetings for PolicyCenter and Conversion teams
• Prepare for demo end of each sprint to showcase the functionalities that are tested in sprint
• Conduct internal retrospectives and report the top ranked issues and best practices to project retrospectives

Tools Used: Quality Center, SOAP UI, SQL Developer, Guidewire, JIRA

QA Analyst

Confidential, CA

Responsibilities

• Set-up a testing team, methodology and processes for a database testing team
• Review requirements and prepare estimations for Integration testing and User Acceptance testing support
• Create test plan detailing test cases, strategy, risks, assumptions and dependencies
• Worked closely with the architecture/development team to design and develop scenarios
• Extensively used SQL joins and other complex statements for validation and retrieving data executed SQL statements to check data integration, validity, consistency and redundancy.
• Create test data and execute white box/Unit test cases for Preferences, Reservations, Transaction History and Loyalty modules
• Participated in translating business requirements into ETL technical specifications
• Configure and test dispatchers for file transformation and extract data from different sources
• Testing and reviewing of ETL mappings and transformation specifications based on the business requirements from various teams and the business teams
• Run Cognos reports to verify desired output is generated
• Report issues related to design/development in each sprint in the daily scrum meetings
• Submit the completed work of each sprint in the Sprint Review Meeting
• Identify re-usable use case scenarios for various ETL end customer implementation

Tools Used: Quality Center, SOAP UI, SQL Developer, Datastage, Cognos, Oracle

Senior Analyst/Test Lead

Confidential

Responsibilities

• Understand the SRS, requirements and prepare the Effort estimations for System testing and E2E testing (when necessary)
• Justify estimations and create detailed Test Plan with Milestones/WBS, Test Strategy, Risks, Assumptions and Dependencies
• Mapping the source and target databases by studying the specifications and analyzing the required transforms.
• Participate in Walkthroughs, Status meetings to track, report status and resolve issues
• Designed and developed the Automation framework using Quality Center and Business Process testing (BPT).
• Identify risks/issues ahead in the project and mitigate those with the Onsite team
• Create independent SQL scripts to test hash files, transformers, target files and databases
• Create Work Breakdown Structure, Work Allocation sheet, plan and assign team member for each module
• Review the High level test scenarios, Test case document and Test Results prepared by team members
• Track daily testing status, document issues, and report to leadership and client teams
• Review, approve findings and assign relevant development team in Quality Center
• Validated Web Services current states and made logical assertions for WSDL and SOAP objects
• Responsible for three sprints in Metadata Management Tool
• Support UAT teams, create test scenarios, test data and results
• Good experience in SQL extensively by using Joins, Sub Queries, Set Operations, functions and advanced OLAP functions.
• Used various UNIX commands and having basic knowledge on shell scripting
• Worked in Parallel Jobs environment using following stages - Transformer, Joins, Merge, Lookup, Remove Duplicate, Filter, Sort, Copy, Funnel, Aggregator, Surrogate Key generator, Switch, Sequential file and Dataset stage
• Report issues related to design/development in each sprint in the daily scrum meetings
• Submit reports of each sprint to the scrum team in the Sprint Review Meeting

Tools Used: Quality Center/ALM, SOAP UI, SQL Developer, QuerySurge, IBM Websphere, Cognos, Datastage

QA Analyst

Confidential, NY

Responsibilities

• Propose, plan and submit approval requests for all test activities in the project
• Analyze and understand functional requirements
• Author Test Cases for the GUI front-end and provide test coverage matrix
• Create SQL scripts for testing OES Data Model, Business Propagation Rules, RC Restriction, FMS Available Balance functionalities
• Test Role-based and Privilege-based functionalities for each user role using SQL scripts
• Plan and run SQL scripts from the backend using SQL Server 2005
• Design test scenarios for OES-ConTrak integration testing using the data model
• Create SQL scripts, XML input, XML output files for the OES-ConTrak integration testing
• Log defects in Quality Center and report them to Business Analyst and Project Manager
• Involve in testing the new functionalities based on Test cases and coordinate with development teams in fixing the issues
• Create Test Case Repository in Test Plan module of Quality Center
• Plan and Run Test Cases in Test Lab module of Quality Center
• Participated in manual performance testing

Tools Used: QTP, Quality Center, SQL Developer, SOAP

Technologies: Web (Java), Client Server, SOA (Web / MQ), Database, .NET, V Model/Iterative

Confidential

Responsibilities

• Handled multiple roles from 2006 to till 2011 (Test Lead, Onsite Coordinator, Subject Matter Expert, Module Lead, and Tester)
• Attended business walkthroughs and designed high level test scenarios for Policy Management applications
• Analyze requirements, Author Test Cases,, Create/Set-up Test Data, and Execute test cases
• Participated in Web application testing, used various browsers to identify compatibility issues of the application
• Created scenarios for Language based testing for Call Center/IVR and Policy Quote applications
• Developed Requirements Traceability Matrix (RTM) to track requirements and prove test coverage
• Created Defect Summary, Test Summary, and Escape Cause Analysis (for post-production defects) reports
• Part of the Core-team members responsible for estimations, risk analysis, and escape cause analysis
• Test planning, work estimation and resource management for functional test teams
• Performed Requirement Gap Analysis and provided test cases using BPT approach
• Acted as Single Point of Contact for Policy (Backend) and Management, Policy-Claims Interactions, Rating applications
• Key projects include Legacy Modernization (Policy Sales & Service), Coverages Automation, Application Managed Services, Legacy Claims Modernization, Ratabase Testing, Go Green Discounts
• Managed offshore testing teams of varied size (5 - 24 team members) depending on the assignment
• Coordinate offshore team for deliverables on functional and automation testing
• Work with functional testing team (manual) in understanding their pain areas and seek automated solutions such as QTP scripts, home grown tools that automate specific tasks, script to create test data
• Created Datasheet for data driven testing and passed the path (location) of the file for parameterization in QTP
• Collaborated & acquired a successful Knowledge Transition from the client teams
• Participated in team transition activities, created artifacts to showcase attained knowledge, and successfully shared it with relevant Onshore and Offshore teams
• Volunteered for testing mobile application in the Prototype Software Development Lifecycle Phase
• Create daily reports with detailed status on Analysis, Test case authoring, Reviews, Test execution
• Create Weekly Status reports with status from all the Testing and Development teams in the project
• Review of functional specifications
• Provide inputs for ‘SQL window’ screens in creating the Test Plan
• Preparation of Test Scenario, Test Matrix and Test Report
• Design, Self-review and Execution of Test Cases in Test Director
• Report test status and issues to Team Lead on a daily basis

Tools used/Environment: Test Director, My SQL, Apache Tomcat Server, Linux, PHP, V Model