SUDHA JANARTHANAN

ac7d6n@r.postjobfree.com 425-***-****

SUMMARY

Over 9 years and 11 months of experience as a Software Quality Assurance Engineer.

Have experience on web-based, client/server and data warehousing applications.

Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Professional experience in ETL Testing, Web Service Testing, System Integration Testing, Functional Testing, System Testing, End-to-End Testing, Automation Testing, Database Testing, Black Box Testing, JAWS Testing and GUI Testing.

Experience in web based applications like online banking, call center, health domain and transaction applications.

Experience in writing complex SQL queries.

Involved in requirement gathering, process design and data analysis discussion with many clients.

Created ETL test data to validate the ETL mappings.

Sound knowledge in data warehouse concepts. Analysed source systems, staging area, and fact and dimension tables in target data warehouse.

Experience in creating Requirement Traceability Matrix (RTM) document.

Experience in preparing test strategy, developing test plan, detailed test cases, and writing test scripts by decomposing business requirements, and developing test scenarios to support quality deliverables.

Experience in using HP Quality Center and HP Application Lifecycle Management for Test Plan, Test Execution, Defect tracking, Defect reporting and Release Management.

Over 6 years of experience in leading the team in onshore – off shore model.

Experience in working with Software Development team in resolving defects, presenting the defect status reports, resolving requirement, and observed design inconsistencies.

Expertise in developing complex queries to test RDBMS such as Oracle, MS SQL Server using SQL for data integrity.

Strong working experience in Windows 7/8/10 and UNIX environments

Clear understanding of business procedures and ability to work as an individual and as a part of a team.

EDUCATION

Bachelor of Engineering in Computer Science and Engineering May 2008 GPA: 84%

Anna University

Chennai, India

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 7/8/10, UNIX.

LANGUAGES: Basics of C, C++, Core Java, SQL, HTML, XML and UNIX. SOFTWARES: HP Quality Center 10.0, HP Application Lifecycle Management 12.01, HP Unified Functional Testing 12.01, MS Office 2003/2007/2010, PL/SQL Developer, Microsoft SQL Server 2008/2012, TOAD, SoapUI, iTKO LISA, Fiddler, Putty, JAWS Screen Reader, FireEyes II and Autosys Management Console.

ETL TOOLS: SQL Server Integration Service (SSIS) and Ab initio Co-operating system

(2.14/2.15).

DATABASES: Oracle 9i/10g/11g, DB2 and Microsoft SQL Server 2008/2012. CERTIFICATIONS

Certified Tester Foundation Level by International Software Testing Qualifications Board

(ISTQB).

Sun Certified Java Programmer (SCJP).

AHM-250 (Foundation Level) by Academy for Healthcare Management (AHM). WORK EXPERIENCE

Citi Group - CitiDirect Card Management System (via Tata Consultancy Services) Jersey City, NJ & Chennai, India

QA Lead (Mar 2015 – June 2018)

Project Description

Commercial Cards offers traditional credit cards and online solutions to help organization manage its expenditures and financial processes more effectively. CitiDirect Card Management System (CCMS) currently provides reporting and accounting functions for both commercial and government customers. CCMS is the only system providing specialized U.S. government functionalities, including custom accounting functions for U.S. Navy. Responsibilities

Working with Business Analysts to define testing requirements and satisfy the business objectives.

Responsible for creating test plans, test cases, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analysing requirements and creating and executing test cases.

Performed System, System Integration, ETL, End-to-End testing and 508 compliance

(JAWS) testing.

Involved in Functional Testing and Automated Regression Testing.

Involved in writing complex SQL queries to verify data integrity between Source and Target.

Performed data validation testing by writing SQL queries.

Used HP Application Lifecycle Management tool for creating and documenting requirements, test cases and to register the expected results. Also, for storing, maintaining the test repository, defect tracking and reporting.

Environment: HP Application Lifecycle Management 12.01, HP Unified Functional Testing 12.01, Microsoft SQL Server 2008/2012, Windows Server, Microsoft Office Suite (Excel, Word, PowerPoint), Windows 7/8/10, Autosys Management Console, SoapUI, JAWS screen reader, FireEyes II, Beyond Compare, Fiddler.

Citi Group – Global Data Repository (via Tata Consultancy Services) Warren, NJ QA Lead (Apr 2014 – Feb 2015)

Project Description

Citi Global Data Repository is a Citi hosted data warehouse with data sources from TSYS, CTL, Banamex, Diners Club, ECS, ECS+, Orbital, credit card Association transaction addendum data, transaction enhanced data, and travel agency data. It is used to generate outbound files for Commercial Cards domestic and global clients' ERP and/or accounting systems. Citi GDR is also the database source for Citi CCRS - the ad hoc reporting application, and Citi CCAS - the analytic application.

Responsibilities

Responsible for creating test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analysing requirements and creating and executing test cases.

Studied and understood the functionalities of Ab initio graphs to validate the ETL process output as per the requirements.

Working with the Development team for process improvement and release planning.

Analysed application data using the SQL to verify the ETL processes.

Performing backend testing by writing PL/SQL queries to test the integrity of the application and Oracle databases.

Developed and modified SQL validation scripts, and written SQL scripts to validate the outbound file data.

Extensively worked on mapping variables, mapping parameters, workflow variables and session parameters to extract only the additional data added during a specific period.

Developed complex queries to verify the data integrity between source and target.

Verified the data transmission from one system to another, according to various business requirements and rules.

Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, System and End-to-End Testing

Performed database testing to verify backend database transactions. Environment: HP Quality Center 10.0, Ab Initio, DB2, Oracle 11g, SQL, SQL*Plus, UNIX, Microsoft Office Suite (Excel, Word, PowerPoint), Windows 7/8/10, Beyond Compare, PHPMyAdmin, Autosys Management Console, Putty, Tectia – SSH Client.

Kaiser Permanente - Merced ( via Tata Consultancy Services) Pasadena, CA & India QA Tester (Apr 2013 – Mar 2014)

Project Description

Merced is an application that allows the user to access Data Validation Reports of the members who are working at the Call Center at all levels (Agents, Team, Line of Business (LOB), Organisation etc.) of hierarchy. Data from multiple heterogeneous data sources like Genesys, HP CHATS, WFM, Aspect, Opstel and Knowlagent are extracted, transformed and loaded into the data warehouse using Infromatica ETL tool. Merced populates the data retrieved from the data warehouse. Responsibilities

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analysing requirements and creating and executing test cases.

Studied and understood informatica mappings to verify the ETL process according to the business requirements.

Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.

Worked with the Development team for process improvement and release planning.

Analysed application data using the SQL to verify the ETL processes.

Modifying and creating SQL Queries for quality assurance and analysis.

Performing backend testing by writing PL/SQL queries to test the integrity of the application and Oracle databases.

Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.

Developed complex queries to verify the date integrity between source and target.

Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.

Performing database testing to verify backend database transactions.

Involving in communication between UAT team members, business leaders and stake holders.

Environment: HP Application Lifecycle Management, Informatica, Oracle 11g, SQL, SQL*Plus, UNIX, Microsoft Office Suite (Excel, Word, PowerPoint), Windows NT/2000, Putty, Beyond Compare.

Kaiser Permanente - Contact Handling and Tracking System ( via Tata Consultancy Services) Pasadena, CA & India

QA Tester (Aug 2011 – Mar 2013)

Project Description

Contact Handling And Tracking System (CHATS) application is for NCAL, SCAL and all the ROC

(Region Outside California) regions .This application will help the Call Center agents to handle different caller types, so that they will be able to wrap up the case within the short time for a Member, Provider, Customer and Prospect.

Responsibilities

Developed test plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.

Manually performed Ad-Hoc testing, End-to-End testing, and System Integration testing.

Performed Web services testing.

Performed Black box, Integration, Regression, System, End-to-End and Backend Testing

Created, maintained and updated regression suites upon receiving new build.

Performed data validation testing by writing complex SQL queries.

Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.

For tracking the defects used the tool HP Quality Center. Environment: HP Quality Center 10.0, Oracle 11g, PL/SQL Developer, Microsoft Office Suite

(Excel, Word, PowerPoint), Windows NT/2000, IBM Mainframe, SoapUI, iTKO LISA, Putty. Kaiser Permanente – Sales Process Automation System ( via Tata Consultancy Services) Chennai, India

QA Tester (Nov 2008 – Jul 2011)

Project Description

Sales Process Automation System (SPAS) helps the Sales and Marketing users to capture the benefits or the plans that the potential customers (prospects) are interested. Sales and Marketing users raise request to Automated Rating for Kaiser (ARK) to create RQR and will be sent to National Pricing System (NPS) for pricing. SPAS will also provide users with the ability to determine which Rate Quotes have been accepted by the Purchaser and will be sent to the CSC for Contracts Processing by submitting the Purchaser Advise (PA).

Responsibilities

Involved in designing the test Cases using Functional Specifications

Conducted extensive manual Black Box testing to better understand the functionality of the Application.

Peer reviewed the test Cases and made recommendations.

Designed, Created and executed manual Test Cases.

Test Environment Setup and Performed the Functional and Regression Testing

Detecting bugs, classifying them based on the severity, and documenting them.

Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.

Created detailed periodic status reports for senior management to keep them posted on the progress of implementation.

Attended periodic meetings, teleconferences and led discussions on problem resolution.

Coordinated with Developers for Defect analysis and performed Regression Testing.

Developed Test Matrix to give a better view of testing effort. Environment: Java, XML, Java Script, HTML, Bugzilla, Oracle, Mainframe, UNIX, Shell scripting.

Contact this candidate