We provide IT Staff Augmentation Services!

Qa Tester Resume

Oklahama City, OK

SUMMARY:

  • Around 6+ Years of experience in Performance Testing, Stress Testing, Load Testing, Functionality Testing, Integration Testing, System Testing, Regression Testing.
  • Created and Published Test Cases, Test Plans, Automated and Manual Test Scripts,
  • Test Metrics, Defect Reports and Test Results.
  • Experienced in identifying scenarios, analyzing large data, creating test data, maintaining test cases, developing automation test scripts, performance testing, manual test execution and presenting test results.
  • Created and Published Test Cases, Test Plans, Automated and Manual Test Scripts, Test Metrics, Defect Reports and Test Results.
  • Performed data centric backend testing of applications using UNIX and SQL scripts.
  • Experience in UNIX Shell Programming for scheduling, file manipulation etc.
  • Involved conducting usability sessions on the existing version of the intranet and testing the existing enterprise portal design or website.
  • Working experience in Microsoft SQL Server Reporting Services ( SSRS ), Microsoft SQL Server Analysis Services (SSAS) and Integration Services (SSIS).
  • Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
  • Skilled in utilizing Test Automation and Test Management tools such as QTP, Win Runner, Load Runner, Test Director and Quality Center (QC) and experienced in performing White Box&Black Box Testing.
  • Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
  • Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server … and Transformation .
  • Experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server, and Informatics Power Center, Power art (Repository Manager, Server manager, and Mapping Designer, Mapplet Designer, Transformation Developer and Warehouse designer).
  • Experience mostly involved in ETL design & development using MSBI suit SSIS, SSRS & SSAS, Informatica Power Center.
  • Worked Extensively on ETL process using SSIS package.
  • Good understanding of business intelligence concepts and concepts related to reporting tools such as SSRS , WebFOCUS and Tableau .
  • Experienced in identifying scenarios, analyzing large data, creating test data, maintaining test cases, developing automation test scripts, performance testing, manual test execution and presenting test results.
  • Experienced in Functional, Integration, Regression, System and Performance Testing
  • Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to … .
  • Excellent T - SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
  • Experience in QA and Manual Testing in Mobile handset and GSM/GPRS/3G/CDMA WAP Applications.
  • Experience with unit testing, Integration testing and system testing for iphone.

TECHNICAL SKILLS:

Operating systems: Win 95, 98, 2000, XP,NT, Sun Solaris, AS 400, VSAM,MS-DOS,UNIX

Languages: C, C++, HTML, DHTML, XML,ASP.NET

Testing Tools: Load Runner, Winrunner Rational Clear Quest, QTP, Selenium WebDriver, TestNG, Selenium IDE.

Test Management Tools: HP Quality Center (QC), HP Quick Test Professional, HP Application Lifecycle Management (ALM), Post man

Databases: SQL Server, Oracle, Sybase, DB2UDB, PL/SQL, Oracle 8.x,9.x,10.x, DB2, SQL Server, Ms Access

Web/App Servers: Apache, Web Logic, Web Sphere and IIS

Scripting: VBScript, JavaScript, ShellScript, VuGen Scripting

Others: Shell Scripts, MS Office, TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Oklahama city, OK

QA Tester

Responsibilities:

  • Responsible for preparing Master Test Plan, the document projecting the scope and various activities involved in the project lifecycle.
  • Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
  • Involved in designing and reviewing test scenarios, test cases and requirement traceability Matrices. Conducting test execution and reporting and tracking defects to closure.
  • Responsible for preparing test data and test environment to execute the test cases.
  • Responsible for peer review the test cases prepared by other team members and executing the test Cases .
  • Involved in the Smoke test, Functional test & Regression testing
  • Involved on testing the new functionality based on test cases and coordinated with development team in fixing the issues, Defect Management by Logging and Tracking bugs during execution in Test lab.
  • Regularly followed up with the development team to discuss the defects identified during Testing.
  • Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.
  • Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using HPalm
  • Run Compatibility Testing (cross Windows/ Mac and Android/ iOS platforms, cross browsers, cross mobile devices - phones, tablets, iPads etc)
  • Coordinated QA, SIT and UAT sessions and executed UAT scenarios with end users for final approval and user signoff.
  • Participate in weekly test planning, project status meetings and reviews.
  • Tested the application under different networks and Internet speeds including on 3G, 4G/LTE and Wi-Fi.
  • Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
  • Responsible for providing valuable feedback to developers in order to fix the defects.
  • Responsible for preparing test strategy and test plan and requirement traceability document.
  • Responsible for requirement review meetings test scenarios and test case walkthrough sessions, defect triage calls and test results presentations during software testing life cycle.
  • Ensured the quality of testing defects status and bug reporting throughout the testing process by working with fellow as well as senior testers.
  • Involved in collecting test status metrics, preparation and submission of daily and weekly status report.

Environment: Word, PPT, Excel, HP/ALM, QTP,API Testing, Post Man,Integrations, JSON, XML,COBOL,Mule soft integrations,Functional Testing, Database testing, Regression, System Integration, System testing and User Acceptance testing,Mainframes applicatio,Apple,android mobile application.

Confidential

QA/ETL Tester

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Worked with Business Analysts to define testing requirements to satisfy the business objectives.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing ).
  • Experience in SDLC and Agile methodologies such as SCRUM.
  • Writing in SQL and PL/SQL scripting.
  • Gathering business requirements from the Business team and generating system workflows Involved in creating the targeted questionnaire for SMEs and Business users for elaborating requirements.
  • Experience in Web based applications like online banking, healthcare transactions applications.
  • Preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Expertise in Data Warehouse, ETL Verification, BI reports.
  • Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
  • Involving in Functional Testing & Regression Testing.
  • Take a preshot and post shot of data package execution in QA.
  • Verifing SSIS logs for execution packegs and results.
  • Creating test cases for ETL mappings and design documents for production support.
  • Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
  • Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
  • Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
  • Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
  • Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
  • Extensively involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules.
  • Extensive SQL querying on Staging, Datawarehouse andDataMarts.
  • Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
  • Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.
  • Worked on projects independently and also managed a Facets testing effort.
  • System Integration testing for Facets core modules with external systems.
  • Tested Subscribers/Providers and claims in Facets.
  • As a QA Tester for BCBS of KS, Involved in testing Facets / Membership and Claims applications.
  • Involved in loading data to staging area and into Warehouse tables using SQL Loader.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Understands data models and excels at transformations.
  • Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.
  • Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
  • Validated XML files that was sent from blueshield to benfitfocus.
  • Validated the SSIS packages and the transformations in data and control flow tasks.
  • Validated SSRS reports according to report specifications.
  • Performed adjudication of Medical and Hospital claims for Network Rules testing to validate members get correct benefit for in Network and Out of network with the Plan Network set and correct Provider.
  • Create PCP claims to validate the members get correct benefits in In-Network and Out of Network with network rules apply.
  • Managed multiple migration projects switching BI technologies to improve efficiencies and increase cost savings. Business Objects, WebFocus, MSBI, Tableau are some of the BI tools we use.
  • Created recurring SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Load.
  • Worked on Android, Windows Mobile platforms to qualify applications.
  • Performed functional testing of individual modules (Accounts, Trading, Quotes and More) of the Application on iOS, Android.
  • Analyzed, designed, developed, implemented and maintained Parallel jobs using IBM info sphere Data stage.
  • Tested the Network, Network area, Network group in Facets.

Environment: IBM Datastage,MS SQL Server 2005/2008,MS Access, Word, PPT, Excel and Visio,FACETS 4.31/4.51, HP Quality Center, QTP, IBM Websphere DataStage , Market Place ( BenfitFocus Web Application).

Confidential

QA/Automation Tester

Responsibilities:

  • Responsible for creating Test Plans based on Functionality and Business rules, generated Test Cases and reported bugs using Quality Center and executed Test Scripts in QTP.
  • Responsible for back-end testing/database testing, which was done using SQL queries.
  • Closely working with dev team to get the issues\bugs resolved and Performance testing for I-phone Applications.
  • QA team to create test data, test cases and provide test strategy and transactions.
  • Provide Test Plan, Defect reports and QA status.
  • Involved in Performing Back-End Testing by writing SQL queries to extract the data from database.
  • Responsible for production Defects tracking, reviewing and working with various teams for setting up roadmap for the defect fixing.
  • Interacted with customers and managers for enhancements and providing QA estimates and results.
  • Tracked software bugs using Quality Center and communicated the same to developers to resolve technical issues.
  • Worked on the performance tuning of the MicroStrategy reports .
  • Performed Data Driven Tests to validate the same scenario with different test data using Quick Test Professional.
  • Created SSRS Report Model Projects in MSBI studio and created, modified and managed various.
  • Tested the application on I Phone when the operating system was unveiled and made sure the application was enhanced to be compatible with the Android devices.
  • Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master.
  • Designed, developed and executed Quick Test Pro scripts for Functional, Regression Testing, and callable scripts.
  • Conducted appropriate requirement analysis, documentation and communication so that risks could easily be identified and monitored.
  • Identified Real World Scenarios and Day in Life Performance Tests.
  • Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
  • Performed functional testing byexecuting the QTP Scripts from Test Director. Used Python to launch QTP scripts from command line for continuous integration testing.
  • Performed Black Box,White Box, Performance testing, Regression, and Validation testing during the testing life cycle of the product release.
  • Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
  • Configured Selenium WebDriver, Testing, Maven tool and created selenium automation scripts in java using testing prior to agile release.
  • Developed and Implemented automation using Selenium WebDriver and Java. Used Eclipse IDE to develop & debug the code.
  • Developed test scripts for mobile applications on Android, Apple, BREW, RIM & WinM platforms using Device Anywhere.
  • Configured Selenium WebDriver, TestNG, Maven tool and created selenium automation scripts in java using TestNG prior to agile release.
  • Actively involved in QA Testing (UI and API), and collaborating with off-shore QA personnel on current projects and documenting and reporting defects and test results in JIRA.

Environment: Automation Testing, Quality, Center 8.0, Oracle, Java Script, Agile/Scrum, JIRA, Windows XP/2000, UNIX, Linux, Visual Studio, Windows Server 2003 and XML, XAML, HTML, SQL server.

Confidential

QA/ETL Tester

Responsibilities:

  • Interaction with Users to understand the business requirements and prepare Business Requirement Document.
  • Test plan, Test case preparation and building Requirement Traceability matrix.
  • Used Informatica as an ETL Tool for Developing the Data Warehouse.
  • Attended IT Lunch and Learn Meetings for various topics like HLA, Big Data.
  • Create new SSIS packages to ETL data from Salesforce to SQL Server and vice versa.
  • Validation of saving the new securities and new contracts for Options and futures to Golden copy.
  • Verification SAC specific SECCODE for the new securities while saving to GC.
  • Validation of posting securities to downstream applications Pane and Geneva.
  • As an ETL SSIS Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
  • Estimated the time taken for the workflows to be migrated from the Informatica to the DMExpress.
  • Executed the workflows as batches of DMExpress through Informatica server.
  • Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
  • MSBI, collected update telemetry data, filtered and created report for management.
  • Extensively involved in testing PL/SQL stored procedures in Netezza database.
  • Experienced in creating and maintaining detailed Test Plans in “Quality Center” and establishing Mapping between Requirements, Test Cases and Defects.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Lead the efforts to build Standards, Processes and Governances for PA application and MSBI platform for crises management, smother and consistent development, seamless transition and doubling efficiencies.
  • Testing of the chat conversations, Send Receive Picture messages, MMS, sending sms from the chat, calling from the conversation.
  • Experience testing distributed systems, including testing on the Hadoop platform and user-level Hadoop configuration and administration skills.
  • Defects were tracked, reviewed, analyzed and compared using Quality Center.
  • Validation of data loaded in Microsoft Enterprise Cache and expiration of the cache.
  • Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
  • Expertise in Data Warehouse, ETL Verification, BI reports.
  • Worked on Testing of City for Citi Payment Web Application which uses Restful Web services, XML, DOM, JSON and AJAX features.
  • Migrated Child org data like Accounts, Contacts, Activities to Parent org using Apex Data loader .
  • Created recurring SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Load.
  • Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
  • Teradata SQL Conversion to Hadoop and Data validation .
  • Worked on the performance tuning of the MicroStrategy reports .
  • Writing complex SQL queries for data validation for verifying the SSIS Packages and SSRS for reporting.
  • Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
  • Hands on built four environments including development testing staging and production using Aqualogic Enterprise Security/Oracle Entitlement Server ALES/OES 10g for entitlements.
  • Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution using Informatica& SQL Server Integration Services (SSIS 2005,2008,2008R2).
  • Developed and tested UNIX shell scripts as part of the ETL process.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services ( SSRS ).
  • Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
  • Developed multiple Map Reduce programs for analyzing the insurance data of the customer and produce summary results from Hadoop to downstream systems.
  • Involved in running Hadoop jobs for processing millions of records of text data.
  • Experience in Testing BI applications using OBIEE, SSRS.
  • Designed and developed test scripts for manual testing of the entire module.
  • Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
  • Created design and implementation artifacts using Oracle Entitlement Server 10g.
  • Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
  • Wrote SAS programs in UNIX platform.
  • Created some macros in Teradata to load the test data in to Target tables.
  • Monitored test scripts and status using Rational Functional Tester and Manual.

Environment: VBScript, DMExpress -6.5 6.9, Shell Script, Oracle EBS R12, HP Quality Center, Crystal Reports, OBIEE10.1.3 , NUnit, Quality Center, Ab Initio , OBIEE10.1.3, Excel, SSIS, SSRS, Access, Windows Server 2003, T-SQL, UNIX and Linux, IBM DB2/UDB.

Confidential

ETL Tester

Responsibilities:

  • Involved in design and development of test plans based on high-level and detailed designs and analyzing business requirements.
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
  • Traveling throughout regional offices to provide support and training to end users as an SME (Subject Matter Expert) in Claims processing & management, mentored & trained entry levels.
  • Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system (Amysis) to FACETS (Client Server based system).
  • Worked on facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect and added them to MicroStrategy Project which was created using Project Builder.
  • Executed the workflows as batches of DMExpress through Unix server.
  • Involved in doing manual testing and created test data for functional testing
  • Performed Functional, Smoke, End-to-end and User acceptance testing.
  • Involved in validating various SSIS and SSRS packages according to functional requirements.
  • Performed Regression testing after each service pack.
  • Tested Complex ETL SSIS and SSRS Packages, Sessions based on business user requirements and business rules to load data from different source.
  • Did theforward and backward data mapping between the fields in mainframe and FACETS .
  • Tested the Integration between different applications and Reported software defects in Quality Center.
  • Worked closely with the developers to resolve technical issues (bugs).
  • Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
  • Experience in Bug Tracking and Reporting using Test Director/ HP Quality Center.
  • Involved in the team meetings to discuss the issues and problems.
  • Generated reports using SSRS . Identified the Data Source and defined them to build the Data Source Views.
  • Strong knowledge of Performance Testing, Regression Testing Adhoc Testing, and Integration testing..
  • Reviewed the application’s Specifications, and then built test cases for system testing

Environment: Siemens Soarian Financials, Oracle, HP QTP 10.x, MS SQL Server, Mainframe, Soarian Clinical, Quality Center, Toad, Java, Manual Testing, Windows NT and MS Office Products, Netezza4.x, OBIEE 10.1.3, T-SQL, SSIS, SSRS .

Confidential

Manual Tester

Responsibilities:

  • Performed GUI Testing of the Web-application using Win Runner Web test add-in on Windows platform.
  • Performed Manual Testing of the web application on Solaris/Unix Platforms.
  • Developed Test Plans and Test Cases.
  • Documented the Test cases, Test results and Test procedure.
  • Performed in both Manual and Automated testing using LoadRunner.
  • Used Test Director for Manual Testing.
  • Implementing Regression tests for every modified build.
  • Interacted with end users to obtain specific system requirements and for User Acceptance Tests (UAT).
  • Defects are managed in Clear Quest.
  • Involved in configuring new versions in Clear case.
  • Performed Positive and Negative Testing.
  • Reported the defects to Developers using Test Director.
  • Participated in Walkthroughs and Defect report meetings periodically.
  • Conducted Distributed and Multi-User Testing.
  • Tracked the issues Build, versions management by using VSS.
  • Summarize Detail Test Reports with error logs and send them to developers.
  • Work closely with developers and other staff members to form a unified team.

Environment: Agile Methodology, Mainframes OS 390, UNIX (Sun Solaris), SQL Server, Oracle, .net framework 2.0, asp.net, vb.net, c#, JavaScript, VBScript, Visual Source Safe, Test Director, WinRunner, LoadRunner.

Hire Now