QA Analyst

VIJAY KUMAR K

******@*****.*** 708-***-****

 7 years of diversified experience in complete SDLC life cycle with analysis, design, testing and maintenance of business applications using Client Server Architecture.

 Extensive experience in testing Web / E-Commerce, Client / Server applications on different environments and Software Development Lifecycle, Software testing Life cycle.

 Experience in Software Quality Assurance and software testing with manual and automated testing of financial business software applications.

 Excellent logical skills for understanding and developing system workflows well suited for communicating with both Technical and Functional professionals.

 Extensive knowledge of QA methodology, standards and procedures such as creating Test Strategy, test plans, test cases, test script generation, regression and user acceptance testing.

 Experience in high level test design analysis and provide feedback on requirements, use cases and design specification.

 Specialized in analyzing the functional specifications and writing detailed Test Strategy, test plans, test cases, execution of test scenarios, analyzing the actual results against the expected results.

 Good experience in working with migration projects involving the migration of Novell Directory Services to Microsoft Active Directory.

 Experience in working with migration tools like Quest NDS Migrator and Quest NDS Reporter to migrate the Novell Directory Services Objects to Active Directory.

 Creation of test data and Automation of test cases for system and analyzing bug tracking reports.

 Strong Skills in using testing methodologies and Functionality Testing, Integration Testing, System Testing, Business Function Testing, Performance Testing, Stress testing and Configuration Testing.

 Extensive working knowledge of Front end GUI, End to End, Back-End and ETL testing.

 Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.

 Extensively involved in Back end Database testing using ORACLE, DB2, PL/SQL AND MS SQL.

 Extensive experience in Oracle Back-end (server-side) PL/SQL Packages, Stored Procedures, Indexes, Functions & Triggers using SQL Developer and Toad development tools.

 Design, development, implementation of automated functional testing strategy with HP suite (Quick Test Pro, Load Runner, Quality Center) , Rational Suite (Test Manager, Clear Quest, Clear Case)

 Comprehensive understanding of Quality Center Defect Module, which supports the entire defect lifecycle—from initial problem detection through fixing the defect and verifying the fix.

 Experienced in understanding PC Hardware, data modeling concepts, TOAD, SQL, creating XML data and working knowledge of XML.

 Extensive experience in UNIX, Windows95/98/NT/2000/XP. Bourne Shell, PERL, Korn, Shell Scripting.

 Experience in financial applications including Treasury Systems, Asset Allocation Systems, Risk Management Systems, Trading Systems, Credit and Market Risk Portal Applications.

 Good experience with Banking Center, Call Center and Retail Channel Marketing Systems including Card Solutions, ATM, Teller Score, Phone systems.

 Knowledge of testing POS systems using In-House Custom and Third Party Software Applications

 Highly experienced in testing on cross platforms e.g. HP Unix/Oracle, Windows, MS SQL, Java, UNIX, XML, Oracle and data modeling.

EDUCATION:

Masters in Computer Science Chicago, IL

Bachelors in Computer Science J N T University, INDIA

Technical Skills

Hardware IBM Compatible PCs and UNIX.

Methodologies SDLC, Waterfall, RUP, Agile Scrum, XP.

Operating system Windows 95/98/2000/NT/XP/VISTA, MS-DOS, UNIX, LINUX, Solaris.

Languages ORACLE 8i/9i/10g, C, C++, PL/SQL, Java, C#.Net

Databases Oracle DB, MS SQL SERVER, MS Access, DB2

MS Suite MS Word, MS Access, MS Outlook, PowerPoint, Excel.

Scripting Languages HTML, DHTML, XML, VB Script, JavaScript,TSL, Perl, KSH,CSH

Testing Tools Win Runner, Test Director/Mercury Quality Center, Quick Test Pro, Rational Clear Quest, Test Manager, Load Runner.

Testing Methods GUI, Black Box, Integration, Regression, Functional, Back End, UAT, System and Smoke Testing

PROFESSIONAL EXPERIENCE:

Capital One Finance, Richmond, VA Nov 2008 – Till Date

Sr. QA Analyst

Bank Object Migration: The Capital One is a diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada. This project involves four phases Discovery, Design, Development and Implementation. This project includes the Capital One Finance (COF) environment, as well as Auto Finance, Point Of Sale, Home Loans, Hibernia Bank (Bank South) and Norfolk Bank (Bank North). The scope of the project is to create a consolidated global Microsoft Active Directory infrastructure that provides Capital One employees simplified and unified access to computing resources. The Design phase includes consolidating the Capital One assets from the current LOB Forests into the ds.capitalone.com forest. The design phase includes migration of Bank South (Hibernia) and Bank North (Norfolk) Novell Directory Services (NDS) resources into the Capital One Finance (COF) Active Directory (AD), manually re-creating Printer Services and performing Application Remediation.

Responsibilities:

• Interacting with Users, Business Analysts and gathered business and technical requirements, reviewed business requirements, technical requirements and specifications.

• Responsible for handling complex projects and participating in the full SDLC Cycle.

• Involved in developing Test Methodologies, Test Strategy, Test Plans, Test cases, test scripts and developed the manual tests for various modules.

• Analyzing system requirements specifications and developing Test Strategy, Test plans, Test Cases, Test Data for testing the functionality, GUI, Compatibility, performance, Usability and User Acceptance of the application based on SRS.

• Used automation tools like QTP, Win Runner for Functional and Regression Testing.

• Created test cases for various phases of migration including the Object Migration, Object Synchronization, Workstation Migration, Printer Migration and Application remediation.

• Used migration tools like Quest NDS Migrator and Quest NDS Reporter to migrate the NDS Objects into the AD.

• Worked on Microsoft Windows Server 2003 during the migration of NDS objects including the Users, Groups, Organizational Units, Workstations and Printers.

• Enhanced and modified the scripts according to the test case scenarios.

• Used Mercury Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.

• Used Microsoft excel and Word 2003 to document the test status reports and the test data.

• Used QTP Automation tool for regression testing of applications by creating verification points e.g., objects data, object properties, window and image verification, database verifications for testing functional, acceptance and limit validations. Also inserting synchronization points.

• Performed extensive back end Database testing using complex SQL queries.

• Wrote complex SQL Joins, Unions and Nested Queries on various data tables for Data validation.

• Performed Database validation using PL/SQL Functions, Cursors, Packages, Stored procedures and Database triggers.

• Experience in working with SQL Server 2005 to query the NDS and AD databases during the migration process to verify the objects migrated into the COF AD.

• Used HTA scripts to verify the migration logs for the NDS to AD migration process.

• Created test data for validating scenarios based on functional requirements specifications.

• Created Test scripts and UAT test cases and coordinated with the UAT Team and Project manager and performed User Acceptance Testing with the Users.

• Conducted integration testing, identified application errors, resolved issues through bridge calls.

• Provided management with daily status reports.

• Worked closely with cross-functional teams including Users, development, marketing, validation, and technical writing.

• Coordinate with the administrator, CM, PM and testing lead for the precise scheduling of the test runs.

• Assisted external clients during the UAT. Conducted and created reports at the end of the UAT test.

• Participated in Defect Review meetings and Quality Assurance meetings

• Responsible for creating and maintaining Requirement Traceability Matrix (RTM) and traced the requirements to the corresponding test cases.

• Created Test data according to different scenarios to verify Reports.

• Created UNIX Shell scripts for sending email to alert users for erroneous records.

• Used PERL to handle a variety of system administrator functions and provides comprehensive string handling functions.

• Generated Change Requests for failed test cases and assigned them to responsible developers.

• Categorized bugs based on the severity and interfaced with developers to resolve them.

• Conduct Execution team meetings and Delivery team meetings on daily basis to acquire and update the status.

• Weekly Status meeting with Development and Management teams to discuss bugs and other issues.

Environment: Quality Center, MS Excel, MS Word 2003, HTML, Agile, Windows Server 2003, SQL Server 2005, TSL, Quest Tools, Win Runner, MS Outlook 2003, QTP, UNIX, Perl.

Washington Mutual Financial, Seattle, WA Nov 07 – Oct 08

Sr. QA Analyst

Washington Mutual conducts business through four primary business lines: Retail Banking & Financial Services, Home Loans, Commercial Banking, and Card Services. Washington Mutual's Retail Banking and Financial Services segment offers a comprehensive line of deposit and other retail banking products and services to consumers. The Retail Banking and Financial Services segment also provides products and services to small businesses and assists them with payroll, cash management, and retirement planning. WaMu Investments, Inc. is a full-service brokerage firm that specializes in helping individuals meets their financial goals. The segment offers a broad range of investment products, including individual retirement accounts (IRAs), fixed annuities, life insurance, stocks and bonds as well as retirement and estate planning.

Responsibilities:

• Involved in Requirements gathering for functional testing with the business analyst.

• Participated in full SDLC and handled complex projects involving the different phases of SDLC like requirements gathering, design, coding, testing and maintenance.

• Involved in developing Test Methodologies, Test Strategy, Test Plans and test cases, and developed the manual test scripts for various applications.

• Analyzed system requirements specifications, developed Test Strategy, Test plans, Test Cases, Test Data for testing the functionality, GUI, Compatibility, performance, usability and User Acceptance of the application.

• Involved in migrating the existing WAMU Active directory domains into a consolidated Active directory for simplified access to WAMU LOBs.

• Performed LDAP authentication, authorization, migration and validation of migrated domains.

• Used the automated tool Win Runner for Functional Testing and Regression Testing.

• Performed database testing by passing SQL queries to retrieve data records.

• Involved in creating Test plans, Test cases and test scripts for various modules in Banking Center, Call Center and Retail Channel Marketing Systems including Card Solutions, Teller Score.

• Involved in verifying accounts which are moved from one system to another and ensure end-to-end processes work fine in the new system.

• Involved in testing the transactions including the transfer via Teller, ATM, mail, or phone and verifying the accounts, general ledger information.

• Developed and executed the manual test cases and documented the bugs using Quality Center.

• Used Quality Center to store, schedule test cases and report bugs.

• Developed detail Load Test plan, Created VU scripts to simulate transactions.

• Performed load testing (HP - Load runner, Load generator, Load controller and Load Analysis tools) on the Bank application by initially evaluating the system, develop test assets (use cases, test cases and test scripts), executed scheduled tests and analyzed the test results.

• Executed the regression test cases manually before it was handed over to UAT.

• Performed Data Validation of the data flow from front-end to back-end using SQL queries.

• Created test data for various scenarios using SQL queries.

• Conducted Back end testing using DB2 and SQL queries.

• Creating back end interfaces using PL/SQL packages, stored procedures, functions, Collections.

• Created scripts using SQL queries/Stored Procedures/Triggers/Views and fine-tuning of the database indexes.

• Changed already existing Procedures, Functions, Views, and Packages to improve Performance, using PL/SQL.

• Wrote UNIX shell Scripts to automate load process and scheduling batch jobs.

• Involved in performance fine-tuning of the queries/report using PL/SQL and SQL Plus.

• Analyzing the test results and identifying potential bottlenecks.

• Maintenance of Test scripts & Test data.

• Participated throughout the testing life cycle, for requirements, test design and review, through the development and the testing process to customer implementation

• Executing Smoke test to validate the scripts, environment and data.

• Performed end to end functional testing, conducted Integration, System, Functional, Database Integrity, User-Acceptance (UAT) and Sanity testing.

• Performed GUI, Positive and Negative testing.

• Conducted integration testing, identified application errors, resolved issues through bridge calls.

• Provided management with daily status reports.

• Developed automation Test scripts using Quick Test Pro to enhance the power of the Scripts for handling complicated scenarios.

• Used PERL to write Web server programs for such tasks as automatically updating user accounts and newsgroup postings, processing removal requests, synchronizing databases and generating reports.

• Generated Change Requests for failed test cases and assigned them to responsible developers.

• Categorized bugs based on the severity and interfaced with developers to resolve them.

• Maintained Test Logs, Test Summary reports and participated in defect review meetings.

Environment: PL/SQL, Win Runner, Quality Center/Test Director, Clear Quest, Oracle 9i/10g, Agile, Windows Server 2003, UNIX, Perl, SQL Server, C, C++, QTP, Windows XP/Vista, TOAD

Citi Financial Inc, Chicago, IL Sep 06 – Oct 07

QA Tester

Maestro is a Lending Application developed for CitiFinancial for catering the Retail Banking. CitiFinancial is a member of Citigroup, the world's largest financial services provider. Each branch manager runs their CitiFinancial office as if it is their own business, so loan decisions are made locally. The application allows to process home improvement loans, bill consolidation loans, money for tuition, vacation getaways and unexpected expenses. It offers a solution that helps the client of CitiFinancial afford what he/she wants or need most in life.

Responsibilities:

• Analyzed system requirements specifications, developed Test plans, Test Cases, Test Data for testing the functionality, GUI, Compatibility, performance, usability and User Acceptance testing of the application

• Prepared detailed Test Strategy, Test Plans – Test Conditions, Cases and Scripts.

• Conducted System and Functional, User-Acceptance (UAT) and Sanity testing.

• Maintained Test Logs, Test Summary reports and participated in defect review meetings.

• Involved in the Manual/Automated Testing.

• Interacted with developers and Business owners for analysis of the application

• Executing the Functional and Regression Test Cases with Win runner.

• Construction and execution of comprehensive Regression Pack using Regression tool - Win runner.

• Executed the regression test cases manually before it was handed over to UAT.

• Performed Data Validation of the data flow from front-end to back-end using SQL queries.

• Participated throughout the testing life cycle, for requirements, test design and review, through the development and the testing process to customer implementation.

• Wrote complex SQL Joins, Unions and Nested Queries on various data tables for Data validation using DB2.

• Performed Database validation using PL/SQL Functions, Cursors, Packages, Stored procedures and Database triggers.

• Involve in Tuning, Performance and Optimization of queries and standardization of the code.

• Recording and Play back of scripts using QTP.

• Performed Data Driven Testing using Mercury’s Quick Test pro.

• Parameterized the scripts and enhanced them according to the test case.

• Used Quality Center to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.

• Used Mercury Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.

• Extensively used Clear Quest for tracking and reporting bugs.

• Used NT Performance Monitor to analyze the System Bottlenecks like Memory Leaks, CPU Utilization etc and also Network Bottlenecks

• Maintaining the testing artifacts in Test Director and preparing the Requirements Traceability Matrix.

• Created UNIX Shell script for sending email to alert users for erroneous records.

• Used PERL to handle a variety of system administrator functions and provides comprehensive string handling functions.

• Preparing the final test report and reviewed with the Lead and managers.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, Clear Quest, C, C++, QTP, HTML, Win Runner, Quality Center/Test Director, TOAD, Perl, UNIX, Windows XP, Windows Server 2003.

GMAC Financial Services, New York, NY Jan 05 – Aug 06

QA Tester

GMAC Financial Services is a diversified, global financial services company that operates in approximately 40 countries in automotive finance, real estate finance, and insurance and commercial finance businesses. A wholly owned subsidiary of General Motors Corp., GMAC was established to provide GM dealers with the financing necessary to acquire and maintain vehicle inventories and to provide customers a means by which to finance vehicle purchases. The company's products and services have since been expanded and now include three primary lines of business: automotive financing, real estate financing and insurance.

Responsibilities:

• Performed system tests of new products, functionality tests of specific enhancements, usability testing to satisfy all the requirements of the users

• Analyzed systems design specifications, requirements and detailed design and formulated Test Strategy, test plan for the functional testing of the application

• Developed test plans and test cases to cover overall quality assurance testing using Quality Center.

• Created test data for QA Database environments based on Functional Requirements Specification.

• Performed Back end Database testing using complex PL/SQL Joins and validated the database.

• Created back end interfaces using PL/SQL packages, stored procedures, functions, Collections.

• Created Server side PL/SQL (Stored Procedures, Functions & Packages) for implementing complex business logic.

• Wrote reusable functions in VBScript and created a Library of Compiled Modules in QTP to test the online quotes, margins and cross rates

• Execution of test scenarios, analyzing the actual results against the expected results and creation of test data

• Verification of test results with the requirement specification & report mismatches to developers

• Executed functional test cases, compatibility testing and evaluated the results.

• Conducted automation regression analysis of the above-mentioned module for several internal releases using QTP.

• Worked closely with developers to resolve identified problems in new and existing applications.

• Used Clear Quest to log defects, make defects reproducible and verify bug fixes.

Environment: Quality Center/Test Director, QTP, Windows NT and 2000, UNIX, Oracle 9i/10g, PL/SQL, Rational Clear Quest, DB2, MAC OS.

Prudential Financial, Shelton, CT Apr 03 – Dec 04

QA Tester

Prudential Financial companies serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the U.S. These companies offer a variety of products and services, including mutual funds, annuities, real estate brokerage franchises, relocation services, and more.

Responsibilities:

• Functional testing of individual modules called transactions. Some of the modules included policy Withdrawals, New Policy issuance and Underwriting.

• Created the Automation Test Scripts, enhanced and executing using Quick Test Professional (QTP) tool.

• Generating/Enhancing scripts, executing the test scripts, analyzing test results.

• Performing the Acceptance, Functional, Regression, Usability and Smoke testing of various modules (Cyber Life transactions).

• Conducted Functionality and Database testing using DB2, Oracle.

• Developed complex SQL scripts/queries for data verification to compare the expected results with database and analyzed the data and the calculations in the mapping for its correctness.

• Responsible for tuning of SQL queries written in procedures/functions at the back end which are called from the front end forms.

• Created UNIX Shell script for sending email to alert users for erroneous records.

• Created ad-hoc queries and stored procedures for scheduling various jobs.

• Recording test results using Test Director (Quality Center).

• Adding new requirements in the QC and linking them with corresponding test cases.

• Co-ordination with Quest developers on reporting and resolution of defects using the Test Director work flow system

• Involved in the Defect Tracking process using Clear Quest.

• Coordinating with Developers in fixing Defects and ensuring QA processes.

Environment: Internet Explorer, Oracle, Test Director, QTP, Java, Clear Quest, UNIX, HTML, Windows, LINUX, IIS, Oracle 9i/10g, PL/SQL, DB2.

ICICI Bank, Hyderabad, INDIA Jan 02 – Dec 02

QA Tester

ICICI Bank is India's second-largest bank with total assets of Rs. 3,793.01 billion (US$ 75 billion) at March 31, 2009 and profit after tax Rs. 37.58 billion for the year ended March 31, 2009. The Bank has a network of 1,451 branches and about 4,721 ATMs in India and presence in 18 countries. ICICI Bank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries and affiliates in the areas of investment banking, life and non-life insurance, venture capital and asset management

Responsibilities:

• Analyzed system requirements specifications, developed Test plans, Test Cases, Test Data for testing the functionality, GUI, Compatibility, performance, usability and User Acceptance of the application.

• Prepared Test Cases based on Use Cases and SRS.

• Analyzing the Use Cases, preparation/review and execution of Test Case Documents (TCD’s).

• Generating/Enhancing test scripts, executing the test scripts, analyzing test results using Quality Center/Test Director.

• Involved in GUI, Functional, Regression Testing.

• Detecting, Classifying and reporting bugs through Defect Tracking System.

• Reporting bugs through Clear Quest.

• Creating test data for validating the Back end Database using SQL queries.

• Performed Regression testing, back end database validation.

• Created and modified database procedures, functions, triggers, packages to enhance and improve functionality using PL/SQL

• Developed UNIX shell scripts to automate backend jobs, loading data into the Database using SQL* Loader.

• Created tables, table spaces, schemas, materialized views, packages, stored procedures, triggers, functions etc using TOAD tool.

• Executing Test Cases and Analyzing the Test Results.

• Maintaining defect reporting and defect tracking log.xls files.

• Conducting Regression testing and maintain regression test scripts using Win Runner.

• Conducting Re-testing based on the application.

• Active interaction with team members, developers in review meetings to evaluate the process and performance of the application.

Environment: Windows XP, VB. Net, C#, Oracle PL/SQL, SQL Server, Win Runner, Test Director, Oracle, DB2, HTML, UNIX.

Contact this candidate