JUJJURU

Mob: 847-***-****

Mail ID: ac2d5p@r.postjobfree.com

PROFESSIONAL SUMMARY

Software Quality Tester with over 13 years of experience in various domains like Financial Services (Fannie Mae & Freddie Mac), Public Sector, Telecom, Healthcare and Retail. With emphasis on GUI Testing Data warehouse including ETL and Report testing, SOA Testing, Manual Testing, Black Box Testing, Backend Testing of Client/Server and Web based applications.

SUMMARY

Experienced in all phases of Web based testing in Java and which include UAT Testing, functional Testing, Interface Testing, Compatibility Testing, Performance testing, Security testing by establishing and maintaining consistent tests.

Complete software development lifecycle (SDLC) experience from business analysis to development, testing, deployment, documenting, maintaining and user training

Extensively involved testing using SDLC, V-model Waterfall and Agile methodology.

Experienced in Back-end testing, coding and executing SQL Queries on Oracle and

DB2, Web services application testing on XML using SOAP UI, UML, log files.

Comprehensive knowledge of service oriented architecture(SOA) system testing practices and methodologies

Worked closely with business analysts, programmers, and end users in a cross functional team

Experience in co-ordinating efforts between development teams and offshore enterprise test team

Expertise in black box, white box, functional, regression, integration, operational, stress testing, Ad-hoc Testing, User Acceptance Testing .

Expertise in Web Based Testing.

Experience in Test Automation using QTP for functional and Regression Testing

Experience in Preparation of Test Plans, Test Scenarios, Test Cases and Test Data from requirements and Use Cases.

Experienced in software analysis, Requirements Management, Quality Assurance, Configuration Management and Change Management.

Proficiency in HP ALM, Defect Management and preparing RTM

Experience Microsoft Office products Word,Excel and Outlook

Worked with Agile Scrum/Waterfall methodology

Experienced in developing and documenting defect logs with test cases, results, conduct defect call meetings and defect resolutions by working with development, business teams and Subject Matter Experts (SME) and vendors involved in accordance with the results and tolerances defined in the Test Plans.

Perform responsibilities of developing test scripts by using SOA test tools

Expertise in Tool SOAPUI for SOA Testing

Hands on experience in Requirement Traceability Matrix & Test Coverage Matrix.

Hands on experience with DW- ETL Testing, BI Reporting tools Business Objects and Cognos

Expertise in Testing ETL application using tools Informatica,Data stage and Abinitio

Database experience includes Oracle & SQL Server.

Experience in writing SQL Queries

Experience in Test Management Tools ALM,QC,Bugzilla and Jira

Knowledge in Automation Tools QTP

Good experience UNIX and Windows platform

Experience in Test Automation using QTP for functional and Regression Testing

Ability to rapidly learn new concepts together with excellent verbal, written and interpersonal skills.

In-depth knowledge of Data warehousing concepts like Data Mart and Enterprises Data warehouse(EDW)

Expertise in Testing ETL application using tools Informatica,Data stage and Abinitio

Experience of ETL testing process including Type1 and Type2 and Type 3 changes

EDUCATIONAL BACKGROUND:

Master’s Degree in Computer Applications from Madurai Kamraj University, India

TECHNICAL SKILLS

Testing Tools: HP Quality Center (QC), TFS, Test Director, QTP,Jira,

Databases: Oracle 8i/9i, 10g, SQL Server,Lotus Notes

ETL Tools: Informatica, Data stage, Abinitio

Reporting Tools: Cognos, Business Objects and Microstrategy

Scripting Languages: Java Script, Shell Script, Perl Script

Languages: C, C++, Java,.Net, VB

GUI Tools: Erwin, TOAD, Teradata SQL Assistant

Operation Systems: Windows, UNIX, Linux, Solaris.

Browser: IE, Fire fox, Chrome

CERTIFICATIONS

Scrum Master Accredited Certification

EXPERIENCE

Freddie Mac Mclean,VA Aug 2015 - Current

QA Test Lead

Roles and Responsibilities:

Understanding Functional Requirement Specifications and System Requirement Specifications

Preparation of Test Scenarios, Test Cases and Test Data

Provide review comments on Test Scenarios and Test Cases

Created Test Plan Document based on Test Strategy Document

Design and Execution of Test Cases and Test Scripts

Preparation of Requirement Traceability Matrix,Test Metrics

Performed Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Performed system testing to ensure the validity of the requirements

Performed User Acceptance Testing with UAT test scenarios.

Extensively used SQL queries for data validation and backend testing.

Wrote Complex SQL queries to verify report data with the source and target system

Functionality, Integration,Interface, and Regression testing

Involved in test planning, writing test cases/scripts, for automation and test execution.

Find and report defects and subsequently validating the fix, repeating the process until done.

Managed defects using Quality Center

Coordinate efforts between development teams and offshore enterprise test team

Monitoring Testing Activities within the team and reporting regular progress to the Test Manager

Conducted Project Domain and Internal Project Functionality Training Sessions

Work closely with the software engineers to ensure successful, high quality releases.

Execution of Generating and validating the Cognos reports based on functionality

Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.

Validating the data against staging tables and warehouse

Generated Tests (Test Script) using QTP (Automation Tool).

Installing and configuring QTP testing tools

Identifying test case for automation and developing automation test plans

Identified scripts using QTP for regression testing

Extracted Loan level data from mainframe system and generated Loan level file

Validated around 10 Million Loans and provided to CSS via Gateway

Extracted data from multiple data bases and generated XML files (1.13.1C and 1.13.2C)

Validated PC’s and SCR’s and provided to CSS via Gateway

Generated Ad-hoc requests and provided data to CSS

Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing activities

Executed the Autosys jobs to generate XML files

Experienced in retest the existing test cases with the different kind of source systems for different periods of data

Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.

Worked with EUC, and CSV files as part of source data

Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Extensively use SQL queries for data validation and back end testing.

Working with Database Testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.

Environment: Java,JSP, EJB,SQL Server,HP-ALM,Lotus Notes 8.5,Informatica,DB2,Autosys,Unix,DB

Visualizer 6.5.12,Putty, XML,Flat Files, BMC Remedy, QTP.TIBCO, Clear Quest,Doors

Web Services, Rapid SQL, BMC, Remedy

Fannie Mae (SAM) Reston,VA Nov-2013 – July-2015

ETL Tester

Roles and Responsibilities:

Closely working with Business Analysts to define testing requirements to satisfy the business objectives.

Written complex SQL queries to verify data from Source system to Target system

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

Analyzed application data using the SQL to identify the ETL processes

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

Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Abinitio

Good Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W

Execute the ETL jobs by using Autosys command for loading the data from Source to Target system

Experienced in retest the existing test cases with the different kind of source systems for different periods of data

Working with different kind of sources like Oracle, Sybase, EUC Files and CSV files

Using HP Quality Center and ALM for storing, maintaining the test repository, bug tracking and reporting

Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.

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

Worked with EUC, and CSV files as part of source data

Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Extensively use SQL queries for data validation and back end testing.

Working with Database Testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.

Environment: Abinitio, Oracle 11g,Sybase, Autosys, Unix, ALM,SCD, Toad,DbVISUalizer 6.5.12, Putty, XML, Flat Files, BMC Remedy,TIBCO, Clear Quest, Quality Center

Department of Health and Social Services, Columbia, SC May 2013 – Oct 2013

Backend Tester

Roles and Responsibilities:

Understanding of Functional Requirement Specifications and System Requirement Specifications.

Gathering the requirements and preparing the case generation.

Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.

Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.

Preparation of Requirement Traceability Matrix,Test Metrics and Deployment manual

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Verifying the Business Objects Report functionality and Layout specifications based on report requirement document

Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)

Closely worked with Clients during User Acceptance Testing to validate their findings, and report defects for resolution

Perform User Acceptance Testing with UAT test scenarios.

Extensively use SQL queries for data validation and back end testing.

Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.

Find and report defects and subsequently validating the fix, repeating the process until done.

Track Sheet Maintenance and map the use case to requirement.

Build deployment activities and participate in design (spec) reviews with the Core team.

Evaluate and suggest improvements to the software development process.

Monitor Testing Activities within the team and report regular progress to the Test Manager.

Conduct Project Domain and Internal Project Functionality Training Sessions.

Work closely with the software engineers to ensure successful, high quality releases.

Understand Business Requirement Specifications and System Requirement Specifications.

Extract data from different source systems using Data Services tools.

Create the universe based on the Reporting specification document.

Prepare the SQL Server 2008 queries to fetch the data from databases. Functionality, Interface, and Regression testing

Preparation of Test Scenarios and Test Cases on Functional Specification Document

Performed Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Performed User Acceptance Testing with UAT test scenarios.

Extensively used SQL queries for data validation and backend testing.

Find and report defects and subsequently validating the fix, repeating the process until done.

Work closely with the software engineers to ensure successful, high quality releases.

Environment: .Net 4.0, ASP.net 4.0, SQL Server 2008, Web Methods and Web services, Quality Center, File Zilla, Gecs, SQL Server Management Studio

Fannie Mae Herndon,VA Oct 2012 to May 2013

ETL Tester

Roles and Responsibilities:

Understanding of Functional Requirement Specifications and System Requirement Specifications.

Responsible for creating Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the graphs

Wrote Complex SQL queries to verify report data with the source and target system (data warehouse)

Preparing the SQL queries to fetch the data from databases.

Involved in BA walkthroughs and ETL Specification Document.

Working with Fact and Dimension tables and Surrogate keys and version numbers

Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)

Effectively learnt all modules and trained new resources.

Worked with Agile and Scrum methodology

Preparation of test scenario’s and test cases based on Mapping documents

Worked with DDL, DML and DCL commands for creating and updating data into database

Validated the Summary and detail reports with drill down options

Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.

Validating the data against staging tables and warehouse

Find report defects and subsequently validating the fix, repeating the process until done.

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.

Working with Clear Quest and Quality center for logging the defects, tracking the defects and resolving the defects

Performed Interface and Integration(SIT) Testing

Extensively use SQL queries for data validation and back end testing.

Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.

Track Sheet Maintenance and map the use case to requirement.

Monitor Testing Activities within the team and report regular progress to the Test Manager.

Work closely with the software engineers to ensure successful, high quality releases.

Preparing the SQL queries to fetch the data from databases.

Environment : AB Initio, JAVA, Auto sys, Oracle, Doors, Share point, Quality Center, Clear Quest, Unix

State Government of Ohio (State Tax and Revenue System) Nov 2011 – Sep 2012

Reporting Tester

Roles and Responsibilities:

Understanding of Functional Requirement Specifications and System Requirement Specifications.

Worked with Enterprise Tax Management (ETM) V2.2

Involved in leading and participating in the full software life cycle for testing activities

Responsible for creating Test Plans, Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the Cognos reports

Generated reports from Cognos data warehouse system and used HP Quality Center for test cases execution and defect tracking.

Work closely with the software engineers to ensure successful, high quality releases.

Responsible for ETL batch jobs execution using IBM Tivoli application to load data from core database ( ETM database) to Staging and Data mart tables.

Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data.

Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)

Effectively learnt all modules and trained new resources.

Worked with Agile methodology

Preparation of test scenario’s and test cases based on FD and TD documents

Execution of Generating and validating the Cognos reports based on functionality

Validated the Cognos Reports against Data warehouse

Worked with DDL, DML and DCL commands for creating and updating data into database

Verifying the Cognos Report functionality and Layout specifications based on report requirement document

Validated the Summary and detail reports with drill down options

Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.

Validating the data against staging tables and warehouse

Find report defects and subsequently validating the fix, repeating the process until done.

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.

Performed Interface and Integration(SIT) Testing

Extensively use SQL queries for data validation and back end testing.

Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.

Track Sheet Maintenance and map the use case to requirement.

Monitor Testing Activities within the team and report regular progress to the Test Manager.

Work closely with the software engineers to ensure successful, high quality releases.

Preparing the SQL queries to fetch the data from databases.

Environment: ETM, Cognos, Data Stage, JAVA, Tivoli, Oracle

Cabinet for Health and Family Services (CHFS) Frankfort, KY Jan 2011 – Nov 2011

Quality Analyst

Roles and Responsibilities:

Understanding of Functional Requirement Specifications and System Requirement Specifications.

Gathering the requirements and preparing the case generation.

Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.

Knowledge on Data validation, Data merging, Data cleansing and Data aggregation activities

Execute the ETL jobs sessions and workflows

Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.

Preparation of Requirement Traceability Matrix,Test Metrics and Deployment manual

Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Perform system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Experience with Data profiling, Data Validation and Data Integrity and Data Cleansing and ETL processes using Informatica

Validated the Business Objects Reports against Data warehouse

Verifying the Business Objects Report functionality and Layout specifications based on report requirement document

Validated the Summary and detail reports with drill down options

Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)

Closely worked with Clients during User Acceptance Testing to validate their findings, and report defects for resolution

Perform User Acceptance Testing with UAT test scenarios.

Extensively use SQL queries for data validation and back end testing.

Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.

Find and report defects and subsequently validating the fix, repeating the process until done.

Track Sheet Maintenance and map the use case to requirement.

Understanding Functional Requirement Specifications and System Requirement Specifications

Functionality, Interface, and Regression testing

Preparation of Test Scenarios and Test Cases on Functional Specification Document

Performed Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Performed User Acceptance Testing with UAT test scenarios.

Extensively used SQL queries for data validation and backend testing.

Find and report defects and subsequently validating the fix, repeating the process until done.

Work closely with the software engineers to ensure successful, high quality releases.

Environment : Business Objects, Data Integrator, .Net 4.0, ASP.net 4.0, SQL Server 2008, Web Methods

and Web services, TFS, Unix

Walgreens Deerfield, IL Oct 2010 – Dec 2010

Tester

Roles and Responsibilities:

Preparation of Test Cases and Test Scenarios based on Functional Specification Document, Use Cases, Low Level Design document

Performed system testing to ensure the validity of the requirements and mitigation of risks prior to formal acceptance.

Find and report defects and subsequently validating the fix, repeating the process until done.

Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.

Validating the data against staging tables and warehouse

Performed User Acceptance Testing with UAT test scenarios.

Extensively used SQL queries for data validation and backend testing.

Functionality, Interface, and Regression testing

Environment: Informatica, Oracle 10g, Unix, Java, J2EE, EJB, WebSphere6.0,Quality Center 9.2(QC)

U.S. Cellular Bensenville, IL May 2010 – Sep 2010

QA ANALYST

Roles and Responsibilities:

Understanding of Business Requirement Specifications and System Requirement Specifications.

Prepared Test Cases based on Functional Requirement Specification Document, Use Cases, and Low Level Design document.

Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.

Performed data migration activities in informatica one version to another version

Performed System, Functional, Interface and Integration Testing.

Performed Regression and Retesting

Validated the data Source (CARES system) to Target (EDH system).

Source to target data validation Field to Field verification.

Performed end to end ETL testing using Informatica ETL tool.

Involved in BA walkthroughs and ETL Specification Document.

Created SQL queries to fetch and verify the data from Source and Target (Teradata).

Conducted on the ODS data testing and Knowledge on XML.

Validated the Business Objects Reports against Data warehouse

Verifying the Business Objects Report functionality and Layout specifications based on report requirement document

Validated the Summary and detail reports with drill down options

Involved in Build deployment activities and ran UNIX scripts.

Prepared of Test Scenarios, Deployment manual and Test Metrics.

Performed Sanity Testing, Data Driven Testing & Ad-hoc testing.

Verified outperform, generated file feed, formatted and compared with cares data.

Checked the control table data, verified report data with source.

Ran the ETL process from CARES to EDH (Teradata) in UNIX environment.

Designed the Requirement Traceability Matrix document based on the Functional Requirement document and Test Cases document.

Provided daily status to Test Lead.

Defect Logging and Verifying resolved bugs and reported regular progress to the Test Manager.

Conducted peer review of test cases and provided comments.

Defect logging in bug tracking tool (QC) and Verifying resolved bugs.

Worked closely with the Developer and BA to ensure successful, high quality releases

Environment: Informatica 8.0, Oracle 10g, Toad, UNIX, Quality Center 9.2, Java, EJB, Web Logic Server

Dell INDIA July 2009 – Feb 2010

QA ANALYST

Roles and Responsibilities:

Understanding Functional Requirement Specifications and System Requirement Specifications

Provide review comments on Test Scenarios and Test Cases based on Functional

Requirement Specifications

Design and Execution of Test Scenarios and Test Cases based on Functional

Specification Document, Use Cases, Low Level Design document

Preparation of Requirement Traceability Matrix,Test Metrics and Deployment

Performed Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.

Performed system testing to ensure the validity of the requirements and mitigation

of risks prior to formal acceptance.

Performed User Acceptance Testing with UAT test scenarios.

Extensively used SQL queries for data validation and back end testing.

Functionality, Interface, and Regression testing

Report defects and subsequently validating the fix, repeating the process until done.

Tracking and Managed defects using Quality Centre

Work closely with the software engineers to ensure successful, high quality releases.

Environment: Quality Center(9.2),Java,JSP,EJB,Teradata,Toad,WebLogic Server

Hewlett-Packard India Jan 2008 – Jul 2009

QA ANALYST

Roles and Responsibilities:

Involved in leading and participating in the full software life cycle for testing activities – from test planning, test execution to test monitoring, status reporting, documentation and data validation.

Reviewed requirements documented (mapping document) by Business Analyst for thorough understanding of the application.

Validated the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.

Created Test Cases using the SDLC procedures and reviewed them with the Test lead.

Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.

Validated the external data source by connecting through Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.

Tests included System Testing, Regression and Business Objects reports testing.

Provided flexible & high quality support to wider Testing strategies on key regular deliverables & ad-hoc reporting issues.

Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.

Validated the reporting objects in the reporter against the design specification document.

Validated the data files from source to make sure correct data has been captured to be loaded to target tables.

Business process modeling and data analysis including development of business process flows and procedures

Validated the Archive process to purge the data that met the defined business rules.

Written and verbal stakeholder communication

Involved in validating the aggregate table based on the rollup process documented in the data mapping.

Performed data migration activities in informatica one version to another version

Retested the modifications, once bugs were fixed after reinstalling the application.

Reported the bugs through email notifications to developers using Mercury Quality Center.

Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.

Lead and schedule QA project status meetings and publish meeting minutes.

Developed presentation and testing implementation learning to other testing resources for cross functional training.

Environment: Asp.NET, C#.NET, SQL Server 2000, Quality Center

Motorola India Jun 2006 – Desc 2007

QA ANALYST

Roles and Responsibilities:

Documented test scenarios and test cases.

Analyze business requirements and prepared the test cases

Familiar with defect management systems

Issue and risk identification, tracking and resolution

Participated in Full Lifecycle Development on large projects.

Understood Unit, Functional, System, Performance, Technical and Operational testing and the tools utilized.

Knowledge of software development life cycle principles and awareness of Agile practices.

Environment: Quality Center 9.2, J2EE, Xml, Web Services, Oracle10g, Toad, UNIX

Quest Diagnostics India May 2004 – May 2006

QA ANALYST

Roles and Responsibilities:

Worked on Informatica Designer tools –Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor.

Created the Mappings Using Transformations like Expression, Router, Filter, Normalizer, Sequence Generator, Joiner, Lookup, Sorter and Aggregator.

Derived facets by analysis of the text of an item using entity extraction techniques.

Tested the Performance of Mapping and was responsible for design, development and Test Cases

Scheduled the sessions and workflows.

Environment: Asp.NET, C#.NET, SQL Server 2000, Quality Center

Contact this candidate