QA Lead

SUNDEEP KIKLAWALA Email ID: *******.*********@*****.***

Cell #: 647-***-****

TITLE:

Software Quality Assurance Team Lead Resume

Desired Industry : Information Technology Desired Job Location : Canada

Type of Position : Contract – Full Time Availability : Immediate

Job Level : Sr. QA Analyst / QA Lead Willing to Relocate : Yes

OBJECTIVE:

Seeking a Software Sr. Quality Assurance Analyst / Quality Assurance Lead / Management position.

PROFESSIONAL AND TECHNICAL EXPERTISE:

o 8 years of experience as a Senior Technical Specialist, Software Test Analyst, Quality Assurance Lead and managerial expertise in Software Quality Assurance (process & Principles) and Software Testing : QA process analysis and implementation; requirements gathering, definition and analysis; test process analysis, improvement, and implementation; test planning and strategy; test case creation and execution; as well as many other Information Technology for business automation using MS Windows, Unix and mainframe based OS.

o Excellent functional experience in Finance, Insurance, Capital Market, Investment, Wealth Management, Loans & Mortgages and Banking industries. Also experienced of working on Electronic Trading and Equity Trading Applications and Financial Information Exchange protocol (FIX), cross-functional teams in a deadline-driven, project-oriented environment in e-Treasury system, Risk Management, ETL Testing, Billing System and e-commerce system. Good understanding of Banking and Financial institutes SWIFT standards for reliable and secure financial transaction implementation.

o Expertise to conduct detailed analysis of software development requirements to determine testability, business process engineering and software development life cycle, including analysis, design, development, Test Strategy , Environmental setup, testing and implementation of software applications.

o Strong working experience of software development methodologies like Waterfall, RUP, Agile and iterative development approaches.

o Expertise and experience in Manual and Automation Testing and worked on different kinds of testing like Smoke, Black Box, White Box, Grey Box, GUI, Benchmarking-formal, Functionality, Integration, Regression, Usability, Compatibility, Installation, System, Performance, End to End, Usability, Data Load, Stress, User Acceptance (UAT) and other Custom based Test of web and client/server applications.

o Strong Ability to work with Business Analysts, Developers, Test Manager, QA Analyst/Testers and other team members and played key role in the creation of a proficient and efficient system for ensuring the quality of product.

o Proven ability to plan, coordinate, and implement Full Life Cycle Software Development and Maintenance Projects. Also Strong Experience in QA Methodologies like Keyword Driven Testing, Functional Decomposition, Risk based methodology, Model driven methodology, Test case driven methodology and Standards like CMMI, ISO Standards and Six Sigma

o Performed detailed testing and write/execute/documented test plans, Performance plan; developed and executed Requirement Traceability Matrix (RTM), Test cases, Test Conditions, Test Strategy, Test Scenarios, Test procedure, Test Scripts and data sets, Test Report and Verifying Test Results and Defects Log on the basis of product release features, client requirements and technical documents and generated defect report, and periodic progress report for black box, white box and regression testing for SIT, DIT, UAT in both Unix and Internet based environments.

o Expertise in testing of complex Web and Client/Server, leading data reconciliation, System Integration Testing (SIT), User Acceptance Testing(UAT), and a wide variety of Integrated Development Environments and ability to manage resources in mission-critical and tight timeline in a fast-paced software development environment

o Very Good Experience with Automated testing with Automation Interactive tools such as Quick Test Pro (QTP), Rational Tool, WinRunner, LoadRunner, Defect Management, Version Control and Configuration and Change Management using tools like Quality Center/Test Director, Rational Test Manager, Rational Clear Quest, Bugzilla, JIRA, Test Tracking ,Visual Source Safe(VSS), Kofax, Sharepoint in real time.

o Experience in creation, modification and enhancement of the Automation Test scripts from manual test cases and Performed the Regression Testing and executed automated Scripts in all the environment when the application attained a stable state

o Analyzed, troubleshoot and documented test results describe the problems and issues found, compiling test result, monitoring all fixes, and proofreading documentation during the STLC and administrated testing artifacts in Test Director and Quality Center and produced coverage reports.

o Involved in implementing SQA and SCM/DM programs, improving Test Methodologies, and performing related SQA / SCM/DM duties

o Determined and discuss key performance indicators (KPI's) for QA and testing with higher authority.

o Proven organizational skills with the ability to multi-task with rapidly changing responsibilities and requirements in environment

o Solid Back-end testing and Integration Testing experience in writing and executing SQL Queries and advanced SQL / UNIX test scripts including File Validation, Clean Data, Pass Through, Generate signal file and FTP for different types of monthly and daily data files. Expertise DBMS and in high-end Relational Database (RDBMS) applications as Oracle, DB2, SQL Server, MySQL using TOAD and PL/SQL Developer, Database application management tools.

o Understanding of different domains and networking terms & principals

o Hands on experience on Migration. Migrated the database, application, web and WAP servers in production

o Understanding of Active Directory, IIS and Apache configuration

o Experienced at testing ETL's and flat file data transfers without relying on a GUI layer

o Hands on experience on Extraction, Transformation and Loading (ETL) processes & functionality using Informatica power Center, Ab-Initio, analyze and identify test requirements, technical and functional specification, coverage and testing of various Data Warehousing applications with the size in Tera data, validation using graphs and writing complex SQL queries

o Able to provide expert QA and testing knowledge for product, project, or process improvement and execution as well as apply extensive practical experiences in varied development methodologies in commercial application, whether working solo or as part of a team.

o Thorough understanding of Entry and Exit criteria of testing cycle.

o Over 5 years of experience of Web application with good understanding of web terminology like HTML, XML, XSD, HTTP, HTTPS, SOAP, FTP, WSDL, CSS etc..

o Outstanding analytical, decision-making, problem solving, leadership, teamwork, initiative skills communication and interpersonal skills and management skills with the ability to support multiple projects under tight deadlines with complexities and organize activities in fast speedy team environment.

o Knowledge & Experience of defining and support of User Acceptance Testing.

o Core expertise in leadership, coordinating multiple teams, Motivation, Mentoring and Direction to achieve goal to staff members.

o Worked with senior management by updating daily and weekly status, worked with SME, BSA and PM for updates and required solution, providing staff training and input for performance assessments, co-ordination with configuration management team to setup test environment and extending post implementation support to business sponsors.

o Strong verbal and written communication skill for organizational as well as customer coordination / service purpose.

SKILLS INVENTORY AND KNOWLEDGE AREAS

Application Walk-through; Automated Testing; Client-Server Testing; Code Review; Cross-cultural Communication; Design Analysis; Design Review; Documentation; End-to-End Testing; Functionality Testing; Graphical User Interface (GUI) Testing; Independent Validation & Verification (IV&V) ; Integration Testing; Interface Testing; Meeting Management; Oral Presentation; Problem-Bug-Enhancement Reporting; Problem Solving; Project Planning, Estimating, and Tracking; Proposal Writing, Quality Assurance QA of software test efforts; Rational Unified Process RUP, Regression Testing; Requirements Analysis; Requirements Definition; Requirements Traceability; Resume Review and Candidate Interviews; Risk Assessment; Software Test Design plans, cases, procedures, scripts, scenarios, matrices, etc.; Structured Inspections; Systems Analysis; System Testing; Team Building; Test Status Reporting; Tester Training; Unified Modeling Language UML, User Acceptance Testing; Black-Box, White-Box Testing

PROFESSIONAL EXPERIENCE

Manulife Bank of Canada, Toronto - Lead QA Analyst [Since Jan 2010]

Manulife Bank of Canada, a subsidiary of Manulife Financial has initiated an e-treasury system which manages accounts history, transaction feed, accounts payables, accounts receivables. The e-treasury system is a migrated version of an existing legacy mainframes treasury system

Responsibilities:

Performing GAP analysis of business rules, business and system process flows, user administration, and requirements.

Review Documents to understand System and Test requirements, Responsible for creating, updating and executing Test Strategy, Test plan, Test Calendar, Traceability Matrix and release test plan, Test environment/data setup specs and reviewing the Test Cases, Test conditions and Test Scenario associated with test data as per application monthly requirements and enhancements for Smoke, Regression, System(SIT) and User Acceptance Testing(UAT) and also responsible generating test data and test coverage analysis

Responsible for Performing Sanity testing on the builds after accepting the new builds into test environment.

Created and Customized reusable actions and shared object repository for end-to-end testing and Test cases design steps and Regression test suite with Automated Scripts and Manual Design Steps for Critical, High, Medium and Low Severity Defects using Quick Test Pro(QTP)

Responsible to create Risk Assessment matrix document, defect matrix based on defects identified and ensuring the bugs are fixed and are under gone with completion testing and regression testing & analyze and report on quality (defects), coverage (execution), and schedules (plans) using Quality Center(QC)

Worked on defect tracking and version control tools and ensuring content and structure of all the testing artifacts documented in SharePoint.

Helping and coordinating with other team members in order to prevent, report and resolve unusual and complicated defects related to new development, production support and testing.

Imported and exported templates and reports from HP Quality Centre.

Conducted and Participated in Daily conference calls and attended walkthroughs and review meetings.

Active Team member of process improvement team for post implementation review and process.

Participate in identifying SCM requirements for projects by participating in the review of contractual documentation related to SCM (e.g. technical descriptions, contracts, CDRLs, etc.)

Define Entry and Exit criteria of test cycle.

Create and maintain projects within SCM tools.

Responsible for Monitoring and reporting on overall team results and consolidates monthly team metrics

Provide Guidance and mentored team members with industry best practices, SDLC methodologies and Defect life cycle

Environment:

HP Quality Center v10, Test Manager, Java, JSP, J2EE, Servlets, Swings, QTP, XML, Oracle8i / 9i, IBM Web Sphere, Web Services, UNIX, Win 2000, VB 6.0, ASP.Net, C#, Toad, SharePoint

Barclays Capital, Toronto – Sr. QA [Feb 2008 to Dec 2009]

Barclays capital, a leading investment bank providing financing and risk management services to large companies, institutions and government clients. Involved in testing a Monte Carlo simulation and Stochastic modeling modules of risk management application.

Responsibilities:

Worked closely with Project Managers, Development leads and Business Analysts to formulate Test strategies and Master test plans.

Responsible for preparing, documenting, executing UAT strategies, plans, UAT functions/cases and UAT completion report also managing problem logs.

Perform database, Back-end testing by executing SQL Queries

Created test strategy, test plan, test execution schedule and risk analysis reports in Agile Development method for both web and data-feed test items.

Understand and tested FIX protocol for secure financial information exchange process of transaction.

Tested the data extraction procedures designed to extract data into flat feed files.

Coordinated the Onsite and Offshore teams to resolve issues

Created maintained and executed test cases based on technical design documents, business requirements, Test Plan and UML diagrams in Quality Center. Hands on work experience in feature driven development environment and testing of monthly release of software features and executed the regression test cases along with testing new enhancements by using QTP and analyzed results.

Understand SOAP structure and tested it using QTP for authentication process.

Performed System Testing, Integration System test (IST), End to End (E2E), D2D Test, Environment Shakeout test, Implementation Shakeout test, regression testing, UAT test and Production test per the needs of the application and record Issues / Defects and track in Quality Center.

Performed Unit testing, Production Acceptance Testing (PAT), User Acceptance Testing (UAT)

Participated in daily SCRUM meetings with project managers, developers for daily project and test status reviews, testing scope analysis and gap analysis.

Looking to achieve project goal, Worked effectively as a enthusiastic team player, supported other team members and provided client services

Supporting a positive work environment that promotes quality customer service, innovation, teamwork and knowledge sharing

Timely report to higher authority as well as team members

Environment:

Oracle 10g, .NET, JAVA, Web Services, QTP, HP Quality Center 9.2, PL/SQL, Unix, TOAD, SQL Navigator, Apache Tomcat

Transamerica Life Canada, Toronto - Test Analyst [Dec 2006 to Jan 2008]

The project was scoped to facilitate ETL project effort on Data from various online transaction processing (OLTP) applications and other sources is selectively extracted, transformed and loaded into the Oracle data warehouse using PL/SQL. Then the transformed data from data warehouse is loaded into Hyperion Ess-base OLAP server to provide Business Intelligence Analysis Services. The end users can drill through the information using Hyperion Analyzer technology and Excel Add-in over intranet/internet.

Responsibilities:

Reviewed requirements, use cases and technical specifications for Online Mortgage application, suggested required changes to the requirements during walkthrough meetings as needed.

Worked with Database administrators to mock the production data for Regression, Production Acceptance Test and UAT

Responsible Working with Environment specialist to set up test environments for various releases.

For better result played a team player role of a team to convert and cleansing data from OLTP to warehouse.

Responsible for testing all new and existing ETL data warehouse components

Extracted data from Server into flat file and imported to Oracle DB., using SQL loader load data

Validated flat files coming from downstream systems and mocked up feed files

Used SQL navigator and TOAD to write SQL queries and SQL Scripts; verify and validate table, data and business rules

Performed SQL Joins to join two tables and compare data for table to table validation during data migration and data load process.

Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.

Preparing the SQL script to verify data and validating data from source and target Through Toad 9.0.1

Used Business Intelligent (BI) Reporting tools for testing different reports based on BI.

Executed the UNIX shell scripts that invoked SQL loader to load data into tables.

Involved in System Testing, Regression Testing and Integration Testing.

Establish and maintain software baselines and ensure that all artifacts are properly placed under Configuration Management

Charged with maintenance of build servers, and SCM, utilizing Visual Source Safe.

Used Rational Clear Quest for bug tracking and followed up with development team to verify bug fixes, and update bug status for third party application

Establish and manage traceability of the project using Rational Test Manager

Constructs log of each test runs and generated graphic based and text based reports for better understanding using Rational test Manager.

Conducting analysis on the current automation framework and the test data utilized for automation testing and came up with solutions to overcome the existing restrictions and establishing the process.

Providing support to the automation team both in the functional understanding and the business impact.

Open, monitor, communicate, retest and close defects.

Environment:

Siebel (CRM), ETL, JAVA, J2EE, Oracle, QTP, Load Runner 8.X/9.X, Rational Test Manager, HTML/XHTML, CSS, XML, Business Objects, HRM module, MS Windows, Apache Tomcat

Bridgewater Bank, Calgary - QA Test Analyst [Apr 2005 to Nov 2006]

The project is a web based application which involved in incorporating a new billing system, Renaissance Billing System by identifying gaps between existing application and the existing billing system. It included designing an automated streamlined process for Quoting, Document Management, Presentation, Sales, Underwriting, Group Set-Up, Mortgage, Life, Enrolment and payment processing for Group business. It also included a redesign of the Policy Administrative System (PAS).

Responsibilities:

Generating and implementing templates for Test Plan, Test Cases, Test Scripts, Business Analysis, Test Defect Log, Test Case Checklists

Specified and constructed the use case diagrams for the software system using Visio 2000

Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage Developed and Executed the Test Cases for various scenarios based on requirements

Inserted various checkpoints to perform validation on data, images, pages and functional objects of the IMS application using Rational Functional Tester.

Responsible for identifying the functional test cases for Regression testing, data driven testing and automated these scripts using Rational Robot.

Performed debugging by running scripts in debug mode for stock management functionalities in IMS using Rational Robot.

Attended application walk-through and reviewed Requirements to understand the scope of the project and Attended project meetings as needed and Coordinated with the Developers to resolve the issues/defects.

Performed operations on the front end and check all the tables involved whether they are updated correctly as per the specifications. Verified Data with the Toad Interface tool running SQL queries in the Data Base

Performed Back-end testing, data mapping and data validation on oracle, MS SQL Server using TOAD

Used Joins and complex nested queries to test data from multiple tables and views for validating data related requirements.

Viewed errors in App server Log files using Exceed (Hummingbird) and discussed with the appropriate persons.

Front-end testing includes Functionality, navigation, Alignments, links validation, Session management, cookies, Authentication, company specific colors, privacy policy using different web browsers for eight different web sites

Performed fail over testing to validate the error messages in the web by stopping Web Servers, Application Servers, Tux servers and Database connectivity's used Exceed (Hummingbird).

Tested email sending application by understand MIME format. Understand and checked SMTP and IMAP configuration of email.

Used Putty to check the Logs and Job status while performing critical pricing related testing.

Participated in Functional, Integration, Regression, System testing and end -to-end testing.

Used Test Director for test documentation, management

Involved in performance testing using Load Runner

Executed different types of shell scripts and JCL batch jobs including File Validation, Clean Data, Pass Through, Generate signal file and FTP for different types of monthly and daily data files.

Keep up to date with assigned project’s testing records (TestLink), logs and Jira defect reports for clear and prompt reference and resolution.

Environment:

WinRunner, Visual Basic, Load Runner, Oracle, AS/400, Rational Functional Tester, UNIX, SQL Server, MS Outlook, ASP, Jira, Test Director, .Net, MS-Access, TOAD, WebSphere 6.X, Weblogic, Hummingbird, Verisign

Hudson’s Bay Company , Toronto - QA Tester [Sept 2002 to Dec 2004]

Tested inventory management and e-commerce applications of HBC, a leading retail chain in Canada.

Responsibilities:

Participated in the whole SDLC of the application and performed testing in different phases compatibility testing.

Understood different types of payments systems existing in Canada like Credit Card, Debit Card, Gift Coupon, etc..

Created Test cases and Test procedures based on requirements for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions. Executed test cases from Quality Center. Responsible performing Functional, Integration, Regression, GUI and Data Driven Testing using automation tool

Responsible for End to End testing flowing orders from Order entry to Billing

Checked the functionalities of different types of bill pay modes in Bill payment module

Verified the frequency functionality and payment history functionality

Wrote SQL queries to verify the database tables for the data inserted from the GUI

Worked closely with the Business, DBA and Development teams to identify Load and Performance criteria and also identify peak load and critical high volumes that need to incorporate for test

Performed Input-domain testing on different fields in the payment process

Performed system/functional testing of the application by creating and executing the Visual Basic test scripts in Rational Robot tool

Created Regression Suite by including the test cases that covers major functionality of the application and handed over to the Regression Team and performed the Regression Testing and executed the Automated Scripts in all the environment when the application attained a stable state

Conducted usability testing to test for broken links, font, colors, and manual support information.

Set up test environment which entailed initializing hardware and installing the software under test.

Used Test Director for test management and defect management

Environments:

Rational Robot, Test Director, Oracle 8i, TOAD, Java, EJB

EDUCATION

Masters in Computer Application [MCA]

Post Graduate Diploma in Computer Application [PGDCA]

Bachelors of Commerce [B.Com.]

Contact this candidate