Candidates About

PROFESSIONAL SUMMARY

·         7+ years of professional experience in Manual\Automation testing for delivering of quality software products and applications to meet business, market and customer needs.

·         Thorough knowledge in all phases of Software Development Life Cycle, which includes Analysis, Design, Development, Testing, Implementation and Support.

·         Good knowledge of Relational & Dimensional Data models (Star and Snow Flake), Facts and Dimension tables, SCD, Normalized, Denormalized Data, Data Extraction, Data Integration.

·         Experienced in preparing testing related documents like Test strategies, Test Plans, Test Scheduling, Test Scripts, Test Cases, Test Data, Test Summary report and Test Execution Report.

·         Hands on experience on SQL Queries, Stored procedures and Tables.

·         Thorough hands on experience with all levels of testing including Smoke Testing, Integration Testing, Functional Testing, GUI Testing, Security Testing, Browser Testing, Regression Testing and User Acceptance Testing.

·         Experienced with ETL tools like Informatica, SSIS.

·         Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.

·         Worked on Project which followed Agile Methodology.

·         Good experience on Windows and web based applications testing.

·         Thorough knowledge in Quick Test Pro (QTP) and Quality Center (QC).

·         Exposure in using Test Case Management Tools like Quality Center (QC/ALM) to design & execute the Test Cases and to map the Requirements with the Test Cases.

·         Organized, detail-oriented and could work well in a time sensitive environment.

·         Quick learner and excellent team player ability to meet tight deadlines and work under pressure.

·         Have ability to understand and articulate the business requirements and perform a detailed analysis to map them to the technical and functional requirements.

·         Good experience and knowledge of documenting, writing and modeling Test Cases, Use Cases, Functional and Non-Functional Requirements and creating flow diagrams.

·         Managed multiple projects with critical deliverables and tight deadlines.

·         Possess excellent team management, communication and analytical skills.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Client: Comcast, West Chester PA                                                                  May 2016– Till Date 

Role:  Sr.ETL QA Tester 

The primary objective of the project was to construct an aggregated data warehouse. As a QA Engineer, I used to run the test cases for the end to end process in that data warehouse. Involved in Functional Testing, User Interface Testing, Multiplatform Testing.

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool.
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using LoadRunner
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Performed data validation testing writing SQL queries.
• Wrote complex queries in SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.

Environment: - Informatica8.6, SQL, Oracle, HP Quality Center, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, HP/Unix.

Client: JPMorgan Chase, Jersey City, NJ                                                              June 2015-April 2016

Role: Sr. ETL tester

JP Morgan Chase is one of the world’s largest leading mortgage banks. The primary objective of the project was to construct an aggregated data warehouse for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing SQL queries to test the integrity of the application and SQL Server databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables                    and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to 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.
• Wrote complex queries in SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Creating traceability relationship between requirements in the same module and between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Oracle10g, QTP, SQL, DB2, SQL*Plus, UNIX, shell scripting.

Client: GEICO, Dallas, TX                                                                               June 2014 – May 2015

Role: DWH/ETL/UAT BI/ Guidewire Application Tester

BJ’s Corporation is a customer-driven ‘membership only’ warehouse club operating its statewide sale-stores in United States. BJ’s decided to add a ‘wish list’ function within its existing online website. The intent of this initiative is to greatly improve the checkout and membership area of BJs.com by applying usability and design best practices.

Responsibilities:

• End to End testing of Guide Wire Insurance Suite 7.0 (Policy, Billing & Claims) and Supporting DWH and Business Intelligence Solutions.
• Sprint planning for determining& Documenting Testing efforts required for deliverables targeted for iteration/releases.
• Working with release manager/DBAs for deploying right application build into the Testing as well as Development environment.
• Application Clock Movement and Batch Run as well carrying out users/administrative roles/permissions(Agents/UW) in the application for testing functionalities supporting core insurance operations —underwriting, policy administration, billing, and claims.
• Tested Business Requirement/ETL Mapping Rules/Reports against various GW functionalities/modules and data flows from UI to OLTP DB to Replication DB to Staging to Data Mart/EDW to Reports
• Integration testing between the systems (Policy, Billing & Claims) to create test data/scenarios for ETL, BI and UAT Testing manually as well as by employing UFT
• Performed Back-End testing using SQL queries within the QTP Script to compare and retrieve data by using Data Base Check points.
• Worked in Product Testing, CRM Testing, Web Testing, DW-BI Testing and MDM Testing.
• Validating the Data Mapping logic against business rules, UI, data dictionaries and SQL query results
• Performed Negative testing using SSIS to find how the packaging performs when it encounters invalid and unexpected values
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Validating on-demand as well as periodic/delta/daily data loads/refresh and reconcile loads across
• various databases.
• Validating the data flow from UI through to Staging DB to Reporting Data Mart using SQL Scripts
• Validating Data Migration & Conversion of Policies, claims from multiple Legacy Sources into Guidewire Application and supporting DWH and BI solutions.
• Validating data flows/mismatch between staging DB and dimensional model
• Work with BA, DA, ETL Developer, BI Developer and Users for ad-hoc solutions/Reports
• Attended review sessions with Data Analyst for any structural change (Due to incomplete Business
• requirement/granularity issues) and upgrade in the Data Mart solutions/Table solutions
• Reviewing report requirement with BA and ensuring if they contradict granularity or is supported by existing functionalities as well as DWH solutions
• Data Creation in each Center for validating the UI & creating complex scenario that would suffice the Reports targeted for the sprint/iteration/releases
• Tested reports generated in business objects.
• Wrote Complex SQL queries to support and validate the tables and reports under test.
• Extensively involved in functional testing, regression testing, performance testing, volume testing
• Developed the complete Test documents like Test Plan, Test Cases, and Test Scripts by analyzing
• Business requirement documents, Technical and functional design documents, Use cases.
• Attended Defect Review meeting for tracking/escalating defect status to the team
• Tracking Defects, generating defect Reports in ALM/Quality Center as per Severity and Priority
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Extensively involved in System testing / Functional, Regression testing and Integration testing
• Test Management through ALM.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements.

Environment: Guidewire Insurance Suite, Agile, SQL, HP ALM, SSIS, SQL Server 2008R2, Windows, UNIX, Putty, Web Services, HTML

Client: Bharti Airtel – Hyderabad, India                                           June 2012 to December 2013

Role: Manual Back-End Tester/ QA Analyst                       

Responsibilities:

• Analyzed the functional requirements of the application and developed Test strategy for the application. 
• Developed various Test plans and Test cases and analyzed Test results. 
• Analyzed and documented the test results for each build of testing. 
• Enhanced and modified the scripts according to the test case scenarios. 
• Prepared test data to verify different types of scenarios. 
• Extensively involved in the Backend / Data base testing using SQL queries. 
• Responsible for tracking defects using Test Director and made sure those defects are efficiently passed from one layer to another. 
• Involved in adding Requirements, associating Requirements to the test cases writing and executed test cases using Test Director. 
• Conducted Static Text Testing, Text-Link Testing, Image Link Testing, and Broken Link testing. 
• Tested the Applications compatibility for various versions of IE and Netscape. 
• Responsible for performing Functional testing by creating Manual and Automated Scripts using Win Runner. 
• Worked with UNIX shell scripts. Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups. 
• Responsible for user Acceptance testing by giving demos to the client and getting sign off. 
• Responsible for documenting the process for future references. 
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager. 

Environment: Test Director, Win Runner, XML, MS Office, PL/SQL, SQL, Oracle, Windows XP/2000, UNIX, MS SQL Server 2000

Client: Squircle IT Consulting Services, Hyderabad, India                         August 2010 to May 2012

Role: Test Analyst                                                                                         

Responsibilities:

• Creating test scripts, test conditions and Traceability Matrix from the functional specification using test management tool HP Quality Centre 9.2.
• Gathering requirements and creating UAT test data as part of test data acquisition plan and test script execution on the user acceptance testing environments.
• Test bed preparation, execution of manual test cases and defect management for every cycle of testing
• Performing health checks of the UAT applications daily and reporting the status to the UAT team and clients.
• Regression testing using QTP.
• Interaction with the client for understanding the application workflow, test requirements and status reporting.

Environment: Windows XP, Java, SQL, Quality Centre, Jira.

Education:

Bachelors in computer science- JNTU, India