Senior Software Qa Tester

Bharathi Veeraragavan

**** ***** **, ****** ** **315

Phone: 612-***-**** v ********.************@*****.***

SENIOR SOFTWARE BUSINESS/DATA ANALYST-LEAD

Senior software QA tester with 15+ years of experience in Retail, Insurance and

Banking & Financial Services Industry.

Senior software QA tester with complete Software Development Lifecycle experience in Waterfall and Agile methodologies including designing, developing, and implementing test plans, test cases and test processes for significant cost savings and fault-free audits.

Worked as Software Quality Assurance Lead for 8+ years supporting business solution software and analyzing business operations. Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of your company.

Worked as Business system analyst/Data Analyst for 4+ years supporting business solution software and analyzing business operations. Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of your company.

Backed by strong credentials including an Information Technology degree, ETL Testing, SQL, Selenium-Java, Manual Testing, API webservice testing, User acceptance testing, Functional testing, Regression Testing, agile methodologies, and monitoring tools; and cross-platform skills in .net (Sliverlight).

Excellent analytical, communication, inter-personnel, team player and leadership skills

Ability to manage and lead multiple projects simultaneously with emphasis on high quality and system integrity

Skills Summary

SQA Testing & Methodologies

Test Plans, Cases & Processes

Business System Analyst

Excellent collaboration with stakeholders

Test Strategies & Scenarios

Test Data preparation

Regression & Negative Testing

Functional Testing

Data Interface & Migration Testing

User Acceptance testing

DataStage/ETL Testing

End to End Testing

UI & Compatibility Testing

SQL

Webservice Testing

Power BI

PEGA Tools

Developer Tools

Data Warehouse concepts

JIRA

HP ALM

.net, DataStage and ETL tools

Professional Experience

TATA CONSULTANCY SERVICES [Client-Ameriprise Financial] — Minneapolis, MN

Worked as a Test Lead/Business system analyst/Data analyst on Key business metrics/Practice Reporting/Practice Management.

in Ameriprise Financial – 01/21 to Present

Key business metrics is the package business capabilities (PBC) which is integrated in multiple tools inside Ameriprise. Key business metric is used to analyze the advisor’s goals, actuals, GDC, net flows, financial plan count etc. Agile methodology was used for this project.

Responsibilities:

Preparing Test Plan and reviewing with the stakeholders

Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests.

Testing the Power BI reports.

Analyzing the data coming from the source to the target system and making sure the power BI reports are accurate.

Participate ETL testing- validating source and target tables and corresponding reports.

Validating the reports generated against the ETL tables.

Testing front end and backend stories in Jira

Preparing test data/data load for ETL testing using SQL queries

Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects.

Participate in Sprint planning and estimates the stories.

Review the test results with BA’s and show demo to all stakeholders.

Observed all test and identified defects in HP ALM and JIRA

Webservice testing using postman.

Served as coordinator for all testing activities on the project.

Identifying the gaps in stories.

TATA CONSULTANCY SERVICES [Client-Ameriprise Financial] — Minneapolis, MN

Worked as a Test Lead/Business system analyst on Insurance eApplication Uplift and Legacy in Ameriprise Financial – 01/19 to 01/21

Insurance eApplication uplift project main goal is to uplift all non-mobile enabled tool to mobile enabled tool. All the insurance products will be mobile enabled for advisors so that advisor can create accounts from their mobile rather than using a computer. Agile methodology was used for this project. This application was developed using java.

Responsibilities:

Participate in UAT, End to End testing.

JIRA stories testing.

Preparing test data in Mainframe UI screens.

Preparing Test Plan and reviewing with the stakeholders

Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests.

Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects.

Participate in Sprint planning and estimates the stories.

Review the test results with BA’s and show demo to all stakeholders.

Observed all test and identified defects in HP ALM and JIRA

Webservice testing using postman.

Served as coordinator for all testing activities on the project.

Identifying the gaps in stories.

TATA CONSULTANCY SERVICES [Client-Ameriprise Financial] — Minneapolis, MN

Worked as a Test Lead on Commission based Brokerage Uplift in Ameriprise Financial – 01/17 to 12/18

Commission based brokerage uplift project main goal is to uplift all non-mobile enabled tool to mobile enabled tool. All the brokerage products tools will be mobile enabled for advisors so that advisor can create accounts from their mobile rather than using a computer. Agile methodology was used for this project.

Responsibilities:

Preparing Test Plan and reviewing with the stakeholders

Test data preparation

Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests.

Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects

Participate in Sprint planning and estimates the stories.

Review the test results with BA’s and show demo to all stakeholders.

Observed all test and identified defects in HP ALM and JIRA

Webservice testing using postman.

Automated the flow in selenium for regression testing.

Served as coordinator for all testing activities on the project.

Identifying the gaps in stories.

TATA CONSULTANCY SERVICES [Client-Ameriprise Financial] — Minneapolis, MN

Worked as a Business System Analyst on Third Party Retirement Tracking Account in Ameriprise Financial - 6/16 to 01/17

An Ameriprise Third Party Retirement Tracking Account is an account that is established on Ameriprise systems that allows the financial advisor a view into the client’s retirement assets held outside of Ameriprise in accounts where the client has already designated their advisor as the broker of record. This tracking account will enable the financial advisor to provide the client with the investment services and support they need in an ever-changing regulatory environment.

Responsibilities:

Converting the user requirements to system requirements.

Writing system requirement and designing.

Analyze business requirements and processes through document analysis, meetings, workshops, and workflow analysis.

Conduct 4+ levels of testing including functional, integration, regression, and user acceptance to verify the business needs are met.

Communicate business requirements by constructing easy-to-understand data and process models.

Provide input into developing and modifying systems to meet business needs and develop business specifications to support these modifications.

Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.

TATA CONSULTANCY SERVICES [Client-Ameriprise Financial] — Minneapolis, MN

Worked as a Senior Software QA Lead on multiple projects within the Service Delivery & Operations organization in Ameriprise Financial - 5/14 to 6/16

Business Process Transformation & enhancement of the existing Money Movement platform for

Brokerage & Managed Accounts to build a centralized & intuitive Payment Hub to support the Money Movement activities. Agile methodology was used for this project.

Responsibilities:

Business Process Transformation & Gap Analysis of the existing SD Business Processes

Understanding the existing business processes and services provided by SD organization

Understanding of Payment Processing concepts including end-to-end life cycle of Checks, ACH & Paper Payments, Fed Wire etc. in accordance with Industry standards.

Migration of manual business processes into a customized PEGA based BPM tool for automated service request management.

Developed and documented all test plans and specification for smooth integration into systems.

Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests.

Participate in Sprint planning and estimates the stories.

Review the test results with BA’s and show demo to all stakeholders.

Responsible for Test Strategy, Test plan, Test data, Test cases, onsite/offshore co-ordination, Defect tracking, following up and closing the defects

Observed all test and identified defects in HP ALM and JIRA

Served as coordinator for all testing activities on the project.

Resolved all complex problems in programs and ensured that quality was maintained in facility.

Collected project information and submitted all reports to project manager

Automated scripts using UFT

Automation framework

Identified defects in requirements which might have caused thousands of dollars’ loss.

TATA CONSULTANCY SERVICES [Client- Allianz Insurance of North America] — Golden Valley, MN

Worked as a Lead QA Tester - 01/14 to 05/14

Allianz Life Insurance Company of North America (Allianz) provides annuities, and life insurance policies in the

United States. Known for innovation, performance, and customer service, the company has become a leader

in the North American life insurance industry. Agent newly on boarded or if any new appointment/License is required, Allianz used to process through SIRCON. We have tested all the process which was done by SIRCON with our new vendor NIPR (Nation Insurance Producer Registry). Waterfall methodology was used.

Responsibilities:

Validating the web service calls using SOAP UI.

Writing SQL queries and checking the informatica ETL jobs.

Validating the source system and destination system

Validating the jobs schedules

Creating Test Plan, Test case and Test data

Leading the team and managing offshore

Coordinating with clients and Performing Test result review with business

Preparing the daily execution status report.

Defect Logging, Reporting & Tracking using Test Management (HP ALM Quality Centre 11).

Coordinating the defect triage call in resolving all defect related issues/concerns on a weekly basis.

Arrange weekly meetings with the stakeholders and sharing the metrics with the business.

Performing End to End testing. Validating the downstream and upstream data flow without any issues.

Preparing Test Summary Report and Test Closure report.

TATA CONSULTANCY SERVICES [Client- Target corporation] — Chennai, Tamil Nadu, India

Worked as a Lead QA Tester - 07/10 to 12/13

Worked as QA Lead in Migration Testing which involved migrating from Data Stage 7.5 to Data Stage 8.5.

All Target Data Stage application is migrated from DS7.5 to DS8.5. Waterfall methodology was used.

Responsibilities:

Analyze and understand testing requirements from business requirement document, technical requirement specs

Analyze and review Datastage (ETL) mappings to understand the technical implementation of business rules

Collaborated with back end and database testers

Identified data streams and reviewed data models for testing strategies.

Conducted source to target data mapping.

Identified defects and errors in data prior to data processing.

Mitigated existing issues and provided solutions.

Design and document Data warehouse (EDW) testing strategy covering the test cases for validating the data completeness and correctness, system performances of the ETL processes etc.

Trained more than 10 people in learning ETL testing.

Wrote many SQL query to test the end-to-end testing

Have minimal knowledge in crystal reporting and SSRS reporting.

Manage end to end testing work for the Corporate portfolio and lead the project team of

15 members to assign module/activity/tasks/deliverables

Prepare test plan and work breakdown estimate

Prepare the test cases for Summary/Detail testing, functional testing, regression testing, Stress, and End to End testing

Construct test queries with multiple joins, indexes, temporary tables, analytical functions, and sub queries linking by unions, intersection, and minus operators etc.

Schedule and monitor the test cases execution

Scheduling triage meetings to keep track and level of severity defects and communicating it

Project Managers with Execution Score Card with defect Status

Preparing Test Summary Report and Test Closure report.

TATA CONSULTANCY SERVICES [Client- Target corporation] — Chennai, Tamil Nadu, India

Web Developer/Tester – 03/09 to 06/10

Promotional Signing applications is an upgrade to existing signing application for providing GUI access to building in-store promotion labels for different items based on the Promotional codes. Iterative methodology was used.

Responsibilities:

Designing and developing websites on Silverlight framework through iterative development methodology

Providing purchase specifications regarding different hardware

Designing and implementing user interface (UI)

Devising and implementing user defined web services for web portals

Testing websites for cross browser compatibility and fixing bugs and errors

Consuming and Developing Windows Communication Foundation services (WCF).

Creating WCF applications requiring Instance and concurrency management.

SQL Development, ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, indexes, constraints).

Debugging code and performance tuning.

Testing the Web Services, Application.

Developing web parts using C#, Silverlight

Source control tools such as Microsoft TFS

Education & Certifications

RAJALAKSHMI ENGINEERING COLLEGE, ANNA UNIVERSITY — Chennai, Tamil Nadu, India

Bachelor of Technology in Information Technology, 2004-2008

International Software Testing Qualifications Board- Foundation level certification, 2012

Microsoft .NET Framework - Application Development Foundation, 2010

Trained in Selenium-Java, Test NG, 2018

Scrum Master Certified on 11th March 2018

Recognitions

Received Great Team Card Award from Target Corporation

Received “Well Done” Card from Service Delivery head

Received Appreciation Certification from Vice president for “Third Party Retirement Tracking System”

Technical Skills

HP ALM, JIRA, Rational Clear Quest, Datastage, Oracle, Agile, SoapUI, REST, C#, VBScript, SQL, .Net, HP-Unified Functional Testing, Windows, UNIX, Microsoft Office, Postman.

Contact this candidate