We provide IT Staff Augmentation Services!

Sr. Qa Tester/ Web Services Resume

Cambridge, MA

SUMMARY:

  • Over 8+ years of Experience in Software Quality Assurance, Automation Testing BI and Testing in different environments and platforms.
  • Solid Back End Testing experience by writing and executing SQL Queries
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
  • Strong experience in web services testing using Service Oriented Architecture tool Soap UI
  • Experience in test tools like TFS, HP Quality Center /ALM11, JIRA, WebDriver, HP QTP/HP UFT, Web services testing using SOAP UI
  • Experienced in creating and executing Test Scripts using test script like HP QTP/HP UFT .
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application
  • Experience in TDM (Test Data Management) with good knowledge in SQL and XML.
  • Experience in all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC), Bug life cycle and Methods like Agile Scrum, Waterfall and V model.
  • Has knowledge in defect tracking tools JIRA, GITHUP, TFS, Bugzilla
  • Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
  • Creation of test data and Automation of test cases for system and analyzing bug tracking reports
  • Hands on experience in testing soap UI and XML web service interfaces and running basic UNIX shell scripts.
  • Experience in using automation tools like HP Quality Center/ALM and HP QTP/HP UFT
  • Expertise Shell Scripting experience on UNIX, Linux and Windows environment
  • Extensively strong on databases including Oracle, MS SQL Server, and Teradata
  • Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
  • Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
  • Experience in testing and writing complex SQL, T - SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C and C++ Concepts, Test Script Language (TSL),CSS, HTML, VBScript, JavaScript, Shell Scripting

Databases: Oracle 10g/9i/8i, MS SQL Server 2008, MS Access 2008, Teradata V2R6, DB2 UDB 8.2/8.1, Informix

Reporting Tools: Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, and Reporter), Cognos 8.0 Series, OBIEE, Crystal Reports, Hyperion Reports 7.x/2.x

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional (QTP), JIRA, Performance Center, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe

PROFESSIONAL EXPERIENCE:

Confidential, Cambridge, MA

Sr. QA Tester/ Web Services

Responsibilities:

  • Involved in loading the flat files into Oracle Database and involved in writing Complex SQL Queries
  • Prepared the guides for UAT.
  • Prepared Execution procedure document format to prepare the Test cases based on mapping document.
  • Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
  • Generated Test analysis reports and graphs using HP ALM/HP Quality Center
  • Developed automated scripts using HP QTP/HP UFT to perform functional and performance testing
  • Worked on EPIC BRIDGES work queue interface error and modify HL7 Messages when errored.
  • Developed Web Service Test with Soap UI to test SOA platform.
  • Developed and executed test scripts by using QTP/HP UFT and analyzed the Test Reports.
  • Expert in Waterfall Lifecycle, Agile and Iterative project testing methodologies
  • Performed black box/functional testing, regression testing on Application Under Test
  • Execute testing as per test plan. Document, maintain and communicate process, procedure, findings and test results in TFS/Test Manager
  • Involved in testing SOA with Restful/SOAP UI Web Services.
  • Participated actively in different phases of the agile development life cycle.
  • Performed error resolution of HL7 messages reported on various interfaces.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Review all the test scripts written, approve all Validation Test Scripts and Create reports for Validation activities using HP ALM/ HP Quality Center.
  • Worked with business analyst and developers in setting up test data
  • Tested several dashboards and deployed them across the organization to monitor the performance
  • Created and executed data driven test scripts in QTP/HP UFT.
  • Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
  • Demonstrated technical description of HL7 messages supported the HL7 segments and fields
  • Used SQL tools to run SQL queries and validate the data loaded in to the target tables
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • Created entire architecture for backend testing. Internal and third party API using Test Complete and SOAP UI.
  • Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
  • Responsible for analyzing and documenting business requirements for the TDM.
  • Highly proficient in using Test Automation Tools such as HP Quick Test Professional QTP/HP UFT, HP Quality Center/ALM
  • Worked on Waterfall, and Agile methodologies.
  • Tested application and filed defects using HP Quality Center /ALM and TFS.
  • Conducted functionality testing using Quick Test Pro (QTP)/ HP UFT, recorded and wrote test scripts and created user defined functions in scripts.
  • Preparing manual test cases and test data for Scenarios
  • Installed SOAP UI to test Web Services using WSDL file given by Development team and Tested.
  • Implemented SDLC, QA methodologies and concepts in the Project
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used workflow manager for session management, database connection management and scheduling of jobs

Environment: XML, Agile, HL7, XSLT, XPath, XQuery, SQL Server, TDM, SOAP UI, HTML, HP ALM/ HP Quality Center, QTP/HP UFT, T-SQL, SQL, Teradata 13.0, Oracle 11g, PL/SQL, DB2, Business Objects XI3.1, MS Access, Flat Files, c#.

Confidential, Charlotte, NC

QA Tester/ Web Services

Responsibilities:

  • Created test data for testing specific Membership functionality
  • Analyze software failures, report detailed steps to reproduce. Identified, analyzed, and documented defects utilizing JIRA and Asana as a defect tracking systems.
  • Tested the application in highly dynamic environment with sprint team using agile Scrum methodology.
  • Performed the functional testing of Web Services using SOAP UI.
  • Managed and executed the test process, using Agile Methodology
  • Use SOAP UI, API tester to test Web Services.
  • Used checkpoints to check the functionality in QTP/HP UFT.
  • Integrated, tested and supported multiple HL7 interface projects while working in conjunction with different vendors.
  • Developed test scripts using QTP for existing test cases and done Unit testing.
  • Used SQL queries to perform the backend testing of the Oracle database.
  • Work towards the quick resolution and resumption of testing.
  • Extraction of test data from tables and loading of data into SQL tables
  • Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and extreme Programming
  • Involved in different Databases like Oracle, DB2, Teradata and Sybase.
  • Developed test harness for Web Services automated testing by means of SOAP UI
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Validating the data passed to downstream systems
  • Using a simplified Java format, manipulated HL7 data in XML transmissions to match vendor specifications.
  • Participated in defining and executing test strategies using agile methodology.
  • Worked with data validation, constraints, source to target row counts
  • Created SQL's for data mockups in tables and for doing data validations on the backend in Oracle Database.
  • Tested request and response XML's based web services interfaces using Soap UI.
  • Create team specific Agile process flow in JIRA to move tasks from one activity to another
  • Used data conversion to Protect the data and prevent data loss
  • Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access
  • Involved in defect reporting, defect tracking and defect reproducing using bug tracking systems Jira and Asana
  • Involved in production support for HL7 messages that went to error queue.
  • Extensively involved in Web service testing using SOAP UI.
  • Worked with Functional test automation and test automation framework using HP UFT
  • Created macros to automate the process of refreshing the data in MS Access
  • Provided technical support and coaching to team members about functionality of MS Access
  • Managed and executed the test process, using Agile/Scrum Methodology.
  • Used Microsoft excel and Word 2003 to document the test status reports and the Test Data
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Agile/Scrum, DB2, HL7, Oracle, SQL, SQL Server, Automation Testing, TDM, SOAP UI, CSG, TFS, QTP/HP UFT, Teradata 12, XML, XSLT, XML Spy 2008, UNIX, Shell Scripting, WinSQL, Ultra editor, Rumba UNIX Display, Jira.

Confidential, Woonsocket, RI

QA Tester/ SQL

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
  • Written complex SQL queries for querying data against different data bases for data verification process
  • Used Quality Center to track and report system defects
  • Performed UAT testing.
  • Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application
  • Worked on Parasoft SOAtest for API integrity and testing
  • Involved in other test planning meetings and submitted test metrics daily to the management
  • Tracked claims in databases and Excel spreadsheets
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application
  • Preparation of technical specifications and Source to Target mappings
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
  • Analyzed SQL code to ensure Business Objects queries the correct data from the database
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
  • Executed the test process, using Agile Methodology.
  • Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
  • Setting up, monitoring and using Job Control System in Development/QA/Prod
  • Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals for customers
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
  • Worked with business team to test the reports developed in Cognos
  • Validated Web Service including request & response validation using SOAP UI Pro
  • Participated in defining and executing test strategies using agile methodology.
  • Scheduling and automating jobs to be run in a batch process
  • Effectively communicate testing activities and findings in oral and written formats
  • Reported bugs and tracked defects using Test Director 6.5
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Worked on issues with migration from development to testing
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: Agile, Cognos, UNIX Shell Scripting, claims, SQL *Loader, Soap UI, HP ALM/ Quality Center, Oracle8i, SQL Server 2000, Windows 2000, CCA, TOAD, PL/SQL.

Confidential, Columbus, OH

QA Manual Tester/ SQL

Responsibilities:

  • Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
  • Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
  • Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
  • Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
  • Used UNIX to verify the session log files for error and warning details.
  • Executed the Test Scripts in TOAD and documented the results in RTM.
  • Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader.
  • Performed UAT, Usability, Cross-Platform and Regression Testing during different stages of the application development
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Responsible for testing Business Reports developed by Business Objects XIR2
  • The reports that were created in Business Objects were testing by running the SQL statements
  • Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
  • Compared query result sets from different database systems using UNIX diff command.
  • Verified correctness of data after the transformation rules were applied on source data.
  • Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
  • Maintained the batch processes using Unix Shell Scripts
  • Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
  • Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
  • Wrote complex SQL s to validate target data based on the business requirements.
  • Used PL/SQL programs for performance testing.
  • Used SQL and PL/SQL scripts to perform backend database testing.

Environment: Business Objects XIR2, Quality Center, SQL, c#, PL/SQL, DB2, PL/SQL, Teradata, UNIX Shell Scripting, Toad, Oracle, XML, Autosys, TSO, JCL, CCA, Windows

Confidential

QA Manual Tester

Responsibilities:

  • Involved in Design and development of test plans based on high-level and detailed designs
  • Analyzed the use cases given by the business analysts and developed test cases using them
  • Responsible for complete manual testing of application under test (UAT)
  • Written complex SQL queries for data validation and to verify the extract rules
  • Performed black box/functional testing, regression testing on Application Under Test
  • Performed manual testing on various modules of the Application
  • Generates functional test cases that capture actual code behavior as a deployed application is exercised
  • Did extensive backend testing using SQL, UNIX and PL/SQL
  • Written complex SQL queries for data validation and data verification
  • Executes the test suite to identify regressions and unexpected side effects
  • Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
  • Monitors test coverage and achieves high coverage using branch coverage analysis
  • Tests individual methods, classes, or large, complex applications
  • Tracks how test results and code quality change over time
  • Conducted performance and load testing using Load Runner
  • Analyzed, reported and kept track of defects using Test Director

Environment: Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, Manual Testing, Test Director, Load Runner, Oracle.

Hire Now