Test Cases Data

Summary

Over * years of experience in the field of Quality Assurance with extensive experience in both Manual & Automation.

Strong expertise in all phases of software test management. Defining requirements, test planning process, test automation & execution, analyzing and reporting results, tracking and managing defects

Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing

Experience in web service testing tools like Soap UI pro or any supporting tool

Extensive knowledge of SOAP REST html http and external data source testing

knowledge of SOAPuI testing Experienced with functional web services tests Skilled with creating automated web services testing processes

Able to create data-driven tests using external sources Excellent troubleshooting and problem-solving skills

Works well as a member of the web development team Highly analytical and focused on details Creative and has good critical-thinking abilities

Extensive experience in Analyzing the Source to Target Mapping Document.

Extensive experience in writing ETL Test Scenarios, Test Cases based on Source to Target Mapping Documents.

Perform various types of Data validations include Null Check, Duplicate Check,Type check, Referential Integrity Check.

Expertise in Data Warehouse, ETL Verification,BI reports, Informatica,Oracle and HP Quality Center.

Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.

Extensive knowledge in writing SQL queries based on the transformation logic present in Source to Target mapping document to compare the Source data with that of target data to make the data accurate.

Good knowledge in Shell Scripting, Written several UNIX scripts for invoking data reconciliation.

Expertise in problem solving and bug reporting using Defect tracking tools like Mercury Quality Center, ALM,JIRA

Knowledge of QTP for System, Functional, Integration and Regression testing

Experience in SDLC like Agile, waterfall methodologies.

Experience in analyzing Functional Requirement Specifications and System Requirement Specifications

Flexible and versatile to adapt to any environment and work on any project

Good interpersonal skills, programming skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies.

Education & Certifications:

Master of Computer Applications (MCA), Madras University, India in 2004

Certifications:

Scrum Master Accredited Certification (SMAC)

Product Owner Accredited Certification (SPOAC)

Technical Skills:

Testing Software

:

SoapUI,HP ALM,QualityCenter(QC),Selenium,Web Driver

Programming Languages

:

Java, J2EE,, SQL, PL/SQL

Operating Systems

:

Windows 9x/2000/XP/NT, MS-DOS and UNIX, LINUX

ETL Tools

Database Testing

Defect Management tool

:

Informatica 9/8.6/7.1.1, Data Stage 8.1/7.5

:

Transaction testing (front end to back end testing), Data Mapping/ Data Conversion

JIRA

Requirements management

:

Microsoft Excel, XML

Databases

:

Greenplum,Oracle8i/9i/10g, SQL Server 2000, My SQL, MS-Access, DB2 8.1, Sybase, Tara Data and TOAD

MS-Suite

Domain

:

:

MS-Word, MS Excel, MS-Project, MS Outlook

Insurance,Banking,Retail

Professional Experience

American Family Insurance,WI Sep’15-OCT’16

Sr. Web Services Test Engineer

Description:American Family Insurance ( AmFam) is a private mutual company that focuses on property, casualty and auto insurance, but also offers commercial insurance, life, health, and homeowner’s coverage, as well as investment and retirement-planning products. A Fortune 500 company, it operates in 19 states spanning from Washington to Georgia. AmFam has been in business for more than 80 years, and remain committed to being the most trusted and valued customer-driven insurance company.

The Geocoder Re-platform solution will support the strategic direction of maximizing AmFam investments by offering services on the most performant, scalable and adaptable platforms available. This will break down the entire solution architecture and demonstrate how the architecture will continue to meet the current requirements as well as position Amfam for future opportunities.The Geocoder Re-platform project will move the capabilities of standardizing and geocoding addresses from the mainframe to a distributed platform. The two core business requirements the new product must continue to support through various interfaces (service, batch, etc.)

SUMMARY

Developed Test Plans, test scripts and executed the test scripts

Provide estimates (time, staff) to support Quality Services and projects

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings

Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications

Analyzed recorded and modified client-server traffic using an HTTP monitor. Created and ran functional and load tests on web services prior to implementation.

Created MOCKS for web services testing. Collaborated closely with clients during testing process

Build, execute, and maintain Integration test suites

Contribute to assessment, recommendation, and implementation of automation strategies and methodologies in keeping with the goals of the Quality Services Department.

Help early detection of defects through automated verification and validation activities ensuring the integrity and quality of all work products

Performed UAT and Regression Testing

Act as the Quality Services representative on assigned areas of responsibility

Serve as an SME (Subject Matter Expert) on technical Integration testing.

Reports to Tech Lead, Senior Manager

ROLE AND RESPONSIBILITIES

Created and executed both load and functional tests for web services.

Wrote reports of findings and suggested changes.

Worked closely with the web development team to ensure quality deliverables. Created complex test cases and message flows. Developed service features as plugins.

Provide input for strategic direction and planning for the Test Engineering group.

Work on day to day issues and coordinate with development team as necessary.

Define the scope of testing needed with focus on Middleware and automation and accountable for consistent output of quality testing artifacts and testing services, adherence to quality methodologies

Participate in the review and analysis of business requirements, functional specification and design documents to ensure testability; reporting of gaps/discrepancies

Responsible for performing Integration testing and ensure all services developed are well integrated according to the specifications.

Responsible for coordinating with offshore and ensure that deliverables are meeting service test team

Responsible for researching and improving quality testing productivity and effectiveness within the service testing domain

Build, execute, and maintain Integration test harnesses,tests scripts as assigned

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads

Creating test cases for ETL mappings and design documents for production support.

Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases

Effectively communicate testing activities and findings in oral and written formats

Extracted data from various sources like Oracle, flat files and DB2 server.

Worked on issues with migration of Data from development to QA-Test Environment

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

Ensure all testing artifacts are completed on time and in keeping with the quality standards and goals of the Quality Services organization

Collaborate in the definition and implementation of QA testing methodologies in all application areas. Collaborate in the definition and gathering of testing metrics.

Provide system and applications support to users including troubleshooting and issue resolution. Ensure fixes and changes are adequately tested.

Escalated Defects while studying Project Requirements and writing Test Cases by using SOAPui and followed logged defects throughout its lifecycle in JIRA.

Provide testing estimations and metrics as required to team lead and Manager

Provide on-the-job training and mentoring for new staff members as assigned

Provide input to establishment/maintenance/improvement of methodologies, templates, process/procedure as appropriate.

Environment: Informatica, Java,Java Scripting,SoapUI, Groovy Script, Windows 2008RC and Firefox, JIRA

SunTrust Bank, GA Nov 2013– July 2015

ETL Tester

Description:SunTrust Data Hub project is a part of Wealth and Investment Management’s strategic program provides a comprehensive and consistent data storage environment, centralized data repository (Data Warehouse) for all SunTrust Investment Services. It is created to ensure data is efficiently and accurately processed, reported and archived. Several data sources/ Service Provider Feeds such as National Financial Services (NFS), CAPS, Putnam, DTCC etc., are used as input to the STS Data Hub. It’s also charged with developing an application called New and Improved Key Master (NIK) that will support data entry of transactions that occur outside of the designated vendors like NFS, Nationwide, etc. .

Responsibilities

Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.

Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.

Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.

Used ALM for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result

Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.

Experience in manual testing which involves web-based application testing for provider and claims system.

Promoted Unix Informatica application releases from development to QA and to UAT environments

Used Agile testing methodology for achieving deadlines in UAT testing.

Tested the ETL mappings from Source to Target.

Written test cases for checking the populated data correctly into fact and dimension tables.

Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.

Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.

Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.

Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata

Responsible for different Data mapping activities from Source systems to Teradata

Extensively used Informatica power center for extraction, transformation and loading process.

Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using ALM.

Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target

Coordinated with development team in system integration test and services level unit testing.

Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.

Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.

Extensively used SQL Queries to verify and validate the Database Updates.

Actively participated in creating requirements Traceability matrices and Test plans

Prepared test requirements, test plan approach document and test cases.

Performed Unit and functional testing for all the Mappings and Sessions.

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

Environment: Informatica, Java, PL/SQL, SQL, Java Scripting, XML, Windows 2008RC and Firefox, ALM

Target July 2011 – Jun2013

ETL Tester

Description: Social savings Application is a new Face book application that will provide users with various offers. Using this application, users can add offers to their Cartwheel list and then redeem in the Target stores using their Social Savings barcode

Responsibilities:

Involved in analyzing Source to Target Mapping Documents and development of ETL Test Scripts, Test Cases and executing & reviewing them.

Developed ETL Test Designs for different scenarios based on Source to Target mapping Documents.

Performed Data Validation includes Null Check, Type Check, Duplicate Check and Referential Integrity Check among the tables in order to make the data accurate.

Developed both positive and negative Test Cases for different functionalities.

Developed extraction mappings to load data from Source systems to ODS to Data Warehouse

Involved in developing the ETL data flows to move the data across Legacy, OLTP, Data ware house and Marts.

Extensively created mapping/ mapplets, reusable transformations using all the transformations like Joiner, Normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.

Executed Test scripts, analyzed the results and reported bugs in Quality Center.

Involved in maintaining and uploading the Test Scripts to Quality Center.

Performed User Acceptance testing in TEST and PROD environment.

Used SQL queries to run Comparison testing to compare data in database and data displayed on front-end.

Involved in Peer Reviews, Functional and Requirement Reviews.

Involved & prepared the test data creation.

Closely worked with Developers to resolve the issues faced during testing.

Participated in regular project status meetings related to testing.

Participated in Defect triage meetings to discuss about the defects.

Reporting and tracking the defects using Defect Tracking tools (HP Quality Center).

Accounts, Points and Rewards associated with the Customers and Clients doing cross browser testing.

Recorded and managed defects utilizing Quality Center.

Environment: Informatica, Oracle 10g, DB2, Mercury Quality Center, UAT, UNIX, SQL

Contact this candidate