Test Cases Data

Location:

Ashburn, VA

Posted:

July 13, 2017

Contact this candidate

Resume:

srividya Kati

Email: ********.****@*****.***

Ph#: 703-***-****

Professional Summary:

Over 10+ Years of experience in Software Testing and Development.

Currently working as a Senior SQA Test engineer for Hexaware Technologies Ltd for the project Enterprise Data Infrstructure - Enterprise DataWarehouse for the Client: Fannie mae.

Analysis of Business Requirement, Use case, functional Specification and Design Document.

Experience in Manual and Test Automation using QTP on Web Based Applications.

Experience on preparation of automation framework using Cucumber and Rubymine for functional testing and GUI testing using HP tools like HP ALM, Jenkins, Maven, TestNG and configured Jenkins for parallel job execution.

Experience in Setting-up QA and Integration environments, build deployments and smoke tests by Enabling Continuous Integration Tests using Jenkins.

Hands on experience with analysis of business, technical and functional requirements.

Developed, Executed & Tested the test plans test cases and test.

Extensive experience on preparation of TEST PLAN, manual and automation TEST CASES, report DEFECTS and execution of test cases through test management mercury tool like TEST DIRECTOR and QUALITY CENTER.

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.

Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.

Expertise in executing informatica developed scripts using Autosys box.

Involved in creating automation test scripts using cucumber built on Eclipse IDE and preparing Cucumber report in Ruby Mine.

Strong experience in Ad-Hoc Testing, GUI testing, Functional testing, Regression testing, Integration testing, Compatibility testing, and User Acceptance Testing.

Experience in providing required input data to request XML & get the required data from response XML & use the response data from other request XML using SOAPUI. Strong experience with SOA architecture which include Soap Web Service and Restful Web Service Testing.

Extensive experience in all MS Office, MS Windows Operating Systems, designing and implementing web-enabled and enterprise Client/Server applications with various software tools in various architectures.

Expertise in back ends testing and writing SQL queries, Joins, procedures using Oracle and MySQL.

Expert in retrieving database information writing SQL Queries in Oracle and transforming data to information as needed.

Created and executed SQL scripts in database to test, verify and validate data transactions, data loads and data operations.

Have good knowledge of WINSQL.

Used Clear quest for repository, reporting bugs, tracking bugs and updates on resolved bugs.

Used Clear case, SVN and Serena for Version Control. Each version of the application is stored and necessary modifications, updates and analysis had been done.

Imported and Exported tools for importing data into tables, or exporting data from single tables or all tables in a database using Netezza in Aginity Workbench.

Expertise in developing Test data, Test Scenarios, Test Cases and Test Script

Preparation of Business Components and Business Process Tests in Quality Center.

Strong experience in testing applications for Windows and Linux platforms.

Experience in integration testing, unit testing, GUI testing, functional testing, system testing, end to end testing and cross browser testing.

Worked intensively in agile methodology. We have used scrum based approach.

Very good experience on writing SQL queries and Linux Shell scripting.

Strong teamwork skills and the ability to communicate with all management levels.

Good interaction with developers, managers and team members to coordinate job tasks.

Technical Skills:

Languages

Java, C, C++, PL/SQL, Dot Net, VB, COBOL.

Internet Skills

JSP, ASP, HTML, DHTML, XML, VBScript, JavaScript.

Databases

MS Access, DB2 7.0, Oracle 9.i/8.i, Developer 2000, WINSQL, Teradata

Windows NT/95/98/2000, UNIX (Solaris, Linux, AIX), MS DOS.

Servers

IBM Web sphere 3.5.2/2.0, Web logic 5.1/4.5, Java Web Server, Apache web server, IIS, J2EE

Other Tools

Clear case, Clear Quest, Exceed, Rational Rose, UML, Visio, OODA,CMVC, Cucumber, RubyMine 8.0.3,DOORS, XML SPY, Informatica Power center, Rally, Jira, TestNG, Maven, Jenkins

Testing Tools

Win Runner, Quick Test Pro, Test Director, QC, HP ALM

Professional Experience:

Hexaware Technologies Ltd. (Client: Fannie mae). Nov 2014 – Till Date

Project: Enterprise Data Infrastructure: Enterprise Data Warehouse

Applications: Loan Position, Loan Retirement, Post Purchase Adjustment

Description: As the leading source of residential mortgage credit in the U.S. secondary market, Fannie Mae is supporting today's economic recovery and helping to build a sustainable housing finance system. Organization provide reliable, large-scale access to affordable mortgage credit in all communities across the country at all times so people can buy, refinance, or rent homes.

Role: SQA Test Engineer (Consultant)

Responsibilities:

Understanding the client requirements by studying functional document.

Understanding the design and implementing it in the development phase.

Working for unit system functional software test automation.

Involved in creation of the feature files, Java scripts, Integration of HPALM.

Update the test results in HP ALM, Attaching the logs if required at the end of each test case using automation.

Have a defect call daily to update.

Upload them into ALM.

Involved in ETL process testing using Informatica ETL tool.

Analyzed application data using the SQL to identify the ETL processes.

Created ETL test data for all ETL mapping rules to test the functionality and test scenarios as per the use cases.

Execute Data Warehouse jobs and tests that will uncover any data integrity issues within the Data Warehouse.

Validate the accuracy of the data in the Data Warehouse.

Involved in creating automation test scripts using cucumber built on Eclipse IDE.

Worked on agile scrum based methods for BDD.

Working for unit system functional software test automation.

Supported SIT, IUAT and S2S testings.

Involved in designing the framework to integrate HP ALM to cucumber using the newly released version of HP ALM Rest API.

Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.

Designed developed and implemented user acceptance testing as the final phase of applications development.

Assigned pass or fail status and managed UAT testing results.

Created table tool that generates Netezza specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, and default values.

Have used Use joins over sub queries using Netezza.

Using Netezza I have created materialized views for vertically partitioning small sets of columns that are often used in queries.

Knowledge Transfer sessions to team members on application functionality. Involved in the preparation of test data.

Identified test requirement and checked if the test cases were complete to test the business functionality.

Created new jobs and branches through Jenkins Worked on distributed test automation execution on different environment as part of Continuous Integration Process Jenkins.

Configured GIT with Jenkins and schedule jobs using Created Test cases, Test suites using Cucumber. Prepared and generated Cucumber report in Ruby Mine.

Created ECF (Enterprise Common Format) the source files in XML using XML SPY.

Executing informatica developed scripts using Autosys box.

Validated the data movement and verified transformations are done correctly for MISMO.

Giving DEMO on the user stories for acceptance.

Developed detailed test cases for Interactive Application. Responsible for writing test plans for interactive application.

Managed and conducted System testing, Integration testing and Functional testing.

Developed and communicated project/task estimates and project plans.

Attending Scrum Meetings and daily stand-up meetings.

Executing the scripts and reporting the bugs through defect tracking tool.

Interacted with various teams to build relationships and communicate system changes and gather additional information that will be helpful to advance my knowledge in the system and also learn new tools.

Executed many applications using shell scripts through UNIX.

Used SQL Queries were to retrieve data from tables and to perform Back-End.

Extensively involved in team meeting and walkthroughs with team members and programmers to resolve technical issues.

Interacted with Business Analysts, Developers for the walkthrough's and problems those are encountered during testing.

Responsible for testing front-end (including web) and back-end applications (databases).

Reporting to the onsite coordinator about the status of the test activities on a daily basis.

Interacting with the onsite people and resolving the offshore issues.

Attended weekly status meetings and provide detailed status report to the client.

Environment: Cucumber, RubyMine 8.0.3,HP QC ALM, TOAD Clear case, Unix, XML, JAVA,J2EE, My SQL, Windows 2010/XP, RDBMS, SQL, TOAD, Netezza, Aginity Workbench. UNIX, Informatica Powercenter CLIENT, SVN, TestNG, Maven, Jenkins.

Five9Group, Inc. (Client: United States Census Bureau). Mar 13 – Nov 14

Project: Geographical Division

Branch: Independent Testing and Validation Branch (ITVB)

Description: The Census Bureau serves as the leading source of quality data about the nation's people and economy. Honors privacy, protect confidentiality, share the census expertise globally, and conduct work openly. The United States Census Bureau operates under Title 13 and Title 26, of the U.S. Code. The goal of Census Bureau is to provide the best mix of timeliness, relevancy, quality, and cost for the data collected and services provided.

The data Census Bureau Collects & When:

●Population & Housing Census - every 10 years

●Economic Census - every 5 years

●Census of Governments - every 5 years

●American Community Survey - annually

●Many surveys -- both Demographic & Economic

●Economic Indicators - each indicator is released on a specific schedule.

Role: Senior Software Tester (Consultant)

Responsibilities:

Responsible for testing more than 50 applications including reviewing SRS documents, build test cases, verify, execute and document the results.

Responsible for executing and compiling the results for all test cases for SFU-Spatial (Linear) Feature Updated Test Status Report based on the updated 'GEO Software Development Activity ID Code Assignments for CRD/SRS/SADS Documents' posted in portal and the updated SRS documents.

Performed TAB10 Benchmark End to End testing for PUMA, UA, CD, SLD and TAB10, ACS12, ACS13, GUPCP, FALL13 and ACS14 including Products.

Experience testing on XML documents.

Responsible for implementing Change Request (CR) forms with respect to different applications.

Diligently tracked the GEO Portal for New/Updated SRS Documents to make sure the test cases match the latest and greatest requirements.

Manage Create and Execute Test Plans and Test Cases for different functionalities.

Prepared status summary reports with details of executed, passed and failed test cases

Interacted with developers, Business & Management Teams and End Users.

Participated in regular project status meetings related to testing.

Executed many applications using shell scripts through UNIX.

Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.

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

Used SQL Queries were to retrieve data from tables and to perform Back-End testing in (TOAD etc).

Responsible for testing front-end (including web) and back-end applications (databases).

Responsible for Configuration Management acceptance process which is critical for launching applications into production.

Responsible for document test cases and adding it to the knowledge base of the base application.

Deliverables include documentation of test cases and results, analysis and deliver prototypes.

Delivered test results for Title 13 Applications which are critical and contain secure data.

Involved in developing the Designing and test cases for TRS UAT Applications.

Delivered test results for database specific applications and responsible for handling tool related issues (TOAD etc).

Gathered SRS documents, latest releases and change requests from Serena Business Manager (SBM).

Developed various object repositories to develop effective scripts and designed master Scripts so as to invoke sub scripts.

Extensively worked on QTP scripts in analyzing the business processes and created automation scripts.

Enhanced the QTP Scripts in expert mode in order to implement efficient test scenarios.

Performed data driven testing, designed Input/output check points to validate the data and develop effective automated QT Pro Scripts.

Performed extensive VB scripting using QTP.

Created user defined functions using QTP.

Experience testing on XML documents.

Updated SBM when requested to accept Change request for the Branch.

Regression Testing is performed and the additional scripts are generated for each version.

Interacted with the developers in performing the Software testing’s in production environment.

Created IT Security Change Requests and worked on Configuration Management Control System (CMCS) requirement generations.

Developed Test Cases for Performance & Usability Test Types of Batch applications for SFU activity. Updates, AU-Address Update, AEP-Address Extracts & Products, PW-Production & Workflow and Spatial Extracts & Products.

Build Test cases based on SRS Document. Converted SRS to Quality Control Requirements Template.

Developed detailed test cases for Interactive Application. Responsible for writing test plans for interactive applications.

Managed and conducted System testing, Integration testing and Functional testing.

Updated the QC Requirement Templates by reviewing SRS from Portal for all Activities.

Wrote Test Scenarios, Test cases in excel sheet and imported them to Test Director/Quality Center.

Logged defects in Test Directors/Quality Center, re-tested defects, analyzed defect with Users and Developers.

Coordinated migrations to QA and Production following Production Control processes.

Worked with the User Group to document the requirements after analyzing and finding gaps in them.

Mapped Test Cases to Requirements (traceability Metrics).

Communicated with offshore Development team.

While writing Test Cases, analyzed FSD, and Use Cases, CR (change request).

Worked closely with User group and Developers.

Assured customer satisfaction with proper documentation and reports.

Developed and communicate project/task estimates and project plans.

Generated reports from TD/QC for Users group, Managers, co-worker and Developers.

Environment: SQL, Linux, WinSCP, Serena Business Manager, Windows NT, Java, Html, Quality center, HP ALM, QTP, Ms-Excel, Ms- Word.

Sabre Systems, Inc (Client: United States Census Bureau). Dec 09 – Mar 13

Project: Geographical Division

Branch: Independent Testing and Validation Branch (ITVB)

The data Census Bureau Collects & When:

●Population & Housing Census - every 10 years

●Economic Census - every 5 years

●Census of Governments - every 5 years

●American Community Survey - annually

●Many surveys -- both Demographic & Economic

●Economic Indicators - each indicator is released on a specific schedule.

Role: Software Tester Engineer (Consultant)

Responsibilities:

Responsible for testing more than 50 applications including reviewing SRS documents, build test cases, verify, execute and document the results.

Developed, Executed & Tested the test plans, test cases and test strategies for the 2010 Decennial Census.

Responsible for executing and compiling the results for all test cases for SFU-Spatial (Linear) Feature Updates, AU-Address Update, AEP-Address Extracts & Products, PW-Production & Workflow and Spatial Extracts & Products.

Build Test cases based on SRS Document. Converted SRS to Quality Control Requirements Template.

Developed detailed test cases for Interactive Application. Responsible for writing test plans for interactive applications

Updated the QC Requirement Templates by reviewing SRS from Portal for all Activities.

Updated Test Status Report based on the updated 'GEO Software Development Activity ID Code Assignments for CRD/SRS/SADS Documents' posted in portal and the updated SRS documents.

Performed TAB10 Benchmark End to End testing for PUMA, UA, CD, SLD and TAB10 Products.

Responsible for implementing Change Request (CR) forms with respect to different applications.

Diligently tracked the GEO Portal for New/Updated SRS Documents to make sure the test cases match the latest and greatest requirements.

Executed many applications using shell scripts through Unix.

Used SQL Queries were to retrieve data from tables and to perform Back-End testing in (TOAD etc).

Responsible for testing front-end (including web) and back-end applications (databases).

Responsible for Configuration Management acceptance process which is critical for launching applications into production.

Delivered test results for Title 13 Applications which are critical and contain secure data.

Involved in developing the Designing and test cases for TRS UAT Applications.

Delivered test results for database specific applications and responsible for handling tool related issues (TOAD etc).

Regression Testing is performed and the additional scripts are generated for each version..

Interacted with the developers in performing the Software testing’s in production environment.

Created IT Security Change Requests and worked on Configuration Management Control System (CMCS) requirement generations.

Developed Test Cases for Performance & Usability Test Types of Batch applications for SFU activity.

Developed Test cases for Login Screen, Account set up, Introduction module, User Account Privileges and NPC Keying Module using Count Question Resolution Production Control System.

Performed testing on the User Account Privileges using Count Question Resolution Production Control System.

Worked on Interactive test cases for Geographic Disk Production and Control System Software Requirements Specification (GDSKPCS).

Responsible for attending meetings related to Requirements gathering and disseminate the same to the team.

Environment: SQL, Linux, WinSCP, Serena Business Manager, Windows NT, Java, Html, Quality center, HP ALM, Ms-Excel, Ms- Word.

Network Services INC, MD. Dec 07 - Jun 09

Project: Washington MMIS

Datawarehouse Testing

Description: WA MMIS – Washington State Medicaid Management Information System which is being done at CNSI for which the State of Washington is the client It is a web based Medicaid system for the Department of Social and Health Services (DSHS) of the State of Washington. It is a claims processing web application that has complex numerous subsystems that are interfaced together to work coherently. For example the WA MMIS system has a whole has Provider, Claims, Financials, Payroll, Drug Rebate, Reference, Prior Authorization, etc subsystems. I worked for Claims, Provider PA Client and Managed Care Subsystems in DATAWAREHOUSE ENVIRONMENT, where it is for different types of Providers to enroll themselves and DSHS worker will have access to them to verify and approve the records.

Role: Senior Quality Analyst /Automation Engineer

Responsibilities:

Analyzed the business requirements and the site specifications.

Developed detailed Testing Strategy for the entire application and developed various test cases.

Initiated, implemented the QA Process and Methodologies.

Used SQL Queries were to retrieve data from tables and to perform Back-End testing in ETL.

Write SQL Query to extract data from various database tables for testing purpose in TOAD.

Inserted various check points like bitmap check points, text checkpoints and database check points to check the functionality of the application.

Created Test Plans, Test Cases and Test Specification Document for the application under test (AUT). Created test data for testing specific billing functionalities.

Configure test environment for specific test cases, create test data and execute automated or manual tests, document results and update defect tracking systems.

Used Clear quest for repository, reporting bugs, tracking bugs and updates on resolved bugs.

Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.

Created Test Cases and developed Tractability Matrix and Test Coverage reports.

Managed and conducted System testing, Integration testing and Functional testing.

Extensively used the AutoSys jobs for the entire project.

Worked on SQL scripts to load data in the tables.

Used the DATA STAGE Director and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.

Tracked the defects using Clear Quest tool and generated defect summary reports.

Worked on Mainframe files. Used Mainframes for the daily data from the production to Target environments.

Experience working with Rational ClearCase for Version controlling and ClearQuest for defect tracking tool.

Validated the data movement and transformations are done correctly for MISMO.

Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality.

Used Clear case for Version Control. Each version of the application is stored in Clear case and necessary modifications, updates and analysis had been done.

Extensively called Test scripts from Driver script, Data driven scripts into main scripts.

Text checks and Image checks were written for correct responses. Created Data Driven tests by using CSV Indexed files. Generated Data Driven scripts that access the backend database.

Installed test environment and test bed.

Participate in the technical review of test automation project deliverables.

Regression Testing is performed and the additional scripts are generated for each version. Generated Test Scripts using EMPRIX Regression testing.

Regular meetings and updates were made to the Management team of the ongoing QA process.

Extracted Files from Mainframes (flat files) using Shell script in Unix Server (Putty), and was also involved in FTP process.

Analyzing data mapping documents for data coming from different database. Tested interfaces for data loading from source systems.

Executed jobs in Ascential DataStage Director for the Target Tables.

Performed Smoke Test for validation of results in Target Tables.

Created actions re-usable actions external actions in Quick Test pro.

Tested the application by inserting checkpoints using EMPRIX.

Generated Test Scripts using EMPRIX Regression testing.

Extensively worked on EMPRIX scripts in analyzing the business processes and created automation scripts. Like Claim Processing and Void Claims, Resurrect and Resolve claims.

Enhanced the EMPRIX Scripts in expert mode in order to implement efficient test scenarios.

Performed data driven testing, designed Input/output check points to validate the data and develop effective automated QT Pro Scripts.

Used DOORS to increase efficiency and improve quality by enabling you to optimize requirements communication, collaboration and verification throughout your organization and across your supply chain.

Involved in Data preparation and Data loading to ETL for Incremental Load.

Regression Testing is performed and the additional scripts are generated for each version.

Regular meetings and updates were made to the Management team of the ongoing QA process.

Environment:, Rational ClearCase, Rational Clear Quest, XML, IBM CDC, Unix Shell scripting, UNIX AIX 5.3, Autosys 4.0, Rapid SQL Navigator, Windows XP, DataStage 7.5.3, Mainframes OS, Emprix, WINSCP, TOAD, DOORS. Ms-Excel, Ms- Word.

Munich ReAmerican Insurance, NJ. Oct 06 - Nov 07

Project: GLORIA – Global Reinsurance Application

Description: Munich Reinsurance America offers a full range of property and casualty coverage’s through multiple distribution channels. They provide a variety of traditional treaty and facultative reinsurance products and services, as well as alternative risk transfer, risk sharing and risk management solutions to nontraditional insurance entities. In addition, Munich Re America HealthCare provides a broad range of risk management services and innovative solutions to the healthcare industry.

The project Gloria mainly undergoes Scenario testing for Conversion AmRe, The objective of conversion testing is to validate all ‘in scope’ AmRe business data has been successfully converted and loaded into the new processing environment, SAP FS-RI. Proceeding “Go Live”, the conversion and validation will ensure a stable data platform for Basic System Integration Testing.

Testing will focus on three points within the conversion process

IDB1 – All legacy data within scope has been loaded

IDB2 – All data has been converted accurately

SAP – All data has been converted and loaded into SAP accurately

The ultimate goal of conversion testing is to validate the AmRe business data in the future SAP FS-RI database.

Role: Automation Quality Analyst

Responsibilities:

Set the QA environment for manual testing as well as for automation.

Worked with the SQL statements to extract data from oracle tables in MS-Access and verify the output data of the reports on the browser page.

Prepared SQL Queries according to the requirements by using Joins.

Executed SQL Queries in Toad.

Attended requirements and design meetings, review and analysis of requirements and design documentation.

Created project, requirements, test plans and tests in quality center.

Written test cases to test the application manually in quality center and automated using Quick Test Pro.

Regression testing is performed and the additional scripts are generated for each version.

Tracked the bugs by using Quality Center, used Quality Center as a repository for all of the testing efforts.

Involved in design and development of test plans based on high-level and detailed designs. Analyzed the user/business requirements and functional specs documents.

Developed automated test scripts from manual test cases for regression testing based on the requirement documents using Quick Test Pro.

Created actions re-usable actions external actions in Quick Test pro.

Tested the application by inserting checkpoints using QTP.

Involved in developing test plan, test cases in Test Director and Excel.

Executed test cases using Test Director and Quality Center.

Prepared/reviewed the Unit/Functional test plans.

Prepared test data for positive and negative test scenarios as per application specifications and application requirements and wrote test plans.

Environment: Oracle, Ms-Access, VB Script, Toad, QuickTestProfessional (8.0, 9.0), Quality Center9.0, Test Director8.0., Windows, Ms office.

Education:

(DECE) Diploma in Electronics and Communication Engineering, JNTU University, Hyderabad, INDIA.

BCA (Bachelor of Computer Application) Osmania University, Hyderabad, India.

References: Will be provided upon request.

Contact this candidate