Qa Tester Resume
Miami, FL
SUMMARY
- Over 8 years of IT Experience in preparing documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
- Good experience in domains like Retail and Online Banking, Finance, Healthcare, Airline, Insurance, Telecom etc.
- Experienced in developing Test Plans and Test Cases for different types of software testing.
- Experience with Mobile Compatibility testing and Mobile application testing - iPhone, Android, iPad/ Tablets, Windows phones.
- Proficient in Mostly Manual and some Automated Testing Tools.
- Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
- Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Positive and Negative Testing, Security Testing, Stress Testing, Load Testing and Regression Testing of Stand alone, Web Based Client-Server applications.
- Experience in complete project life cycle development including Analysis, Design, and Coding, Unit Testing, Integration Testing, System Testing, UAT & maintenance.
- Manual Testing experience involves Test Planning, Test scenario creation, Test case writing, Test data creation using MS Excel, SQL and Perl, DB validation, Defect reporting with Test and Defect management in ALM/Quality Center/Test director
- Develop test cases (both positive and negative testing, boundary conditions) and use cases based on technical documentation and feature description.
- Experience in working with different modules of ALM/Quality Center such as Requirements, BPT, Test Plan, Test Lab and Defects.
- Experience in working with Business Analysts to understand the business critical functions and workflows define in BPT module of ALM/Quality Center and to convert them into automation test scripts using QTP.
- Performed Back End Testing by executing SQL queries.
- Experience withMobile application testing - iPhone, Android, Blackberry and feature phones using Simulator"Device anywhere" “Perfecto”.
- Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
- Performed User Acceptance Testing (UAT) manually.
- Participated in design walkthroughs and verified QC Test Scripts and results.
- Tracked and reported on test execution.
- Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
- Performed portfolios of clients and assignments and key client relationship, develop and deliver services and value charters
- Good team player with excellent communication skills and ability to lead, manage and work independently in a time sensitive environment.
TECHNICAL SKILLS
Testing Tools: QTP, Win Runner, SOAPUI, RFT, TFS
Test Mgmt Tools: ALM/Quality Center, Microsoft Visual Studio Test Management
Requirement Mgmt Tools: Caliber RM, Test Director, ALM/Quality Center, JIRA, Team Track
Scripting Languages: C, C++, TSL, VB, SQL, PL/SQL
Project Methodologies: SDLC, Agile, Waterfall, Spiral, RUP
Mobile Devices: Blackberry (Curve, Storm, Bold, Torch), HTC, Samsung, IPhone, IPADWindows Phone
Mobile OS: Windows mobile, Palm OS, Android, IOS, Blackberry OS
Servers: MS IIS, Apache, Web logic
Database: MS SQL Server, MS Access, Oracle
Other Tools: MS Excel, MS Word, MS PowerPoint, MS Visio, MS Project, Visual Studio
Platforms: Windows, UNIX, Linux
PROFESSIONAL EXPERIENCE
Confidential, Miami, FL
QA Tester
Responsibilities:
- Involved in preparing and Reviewing of Test Cases.
- Document management system was utilized in the access control and management of the requirement specifications produced in this role.
- Working with clients to better understand their needs and present solutions using structured SCRUM approach.
- Created best-practice requirements deliverables, such as use Cases, system process flows and context diagrams
- Gathered requirements, developed Process Model and detailed Business Policies.
- Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
- Followed the RUP methodology for the entire SDLC.
- Used SOAP UI for XML based Web Methods testing
- Performing Multiple rounds of Test Execution using SOAP UI across various releases of services
- Managed requirement activities using an iterative and incremental methodology such as Agile using User stories and Acceptance Criteria.
- Responsible for test management using Quality Center andLoadRunner forloadtesting.
- Monitored activities and implemented strategic sales tactics through visual merchandising
- Responsible for writing and implementation of the test plan, and various test cases.
- Develop user manuals, presentations and training manuals as per project specifications and timelines.
- Deliver requirements under the AgileScrumSDLC methodology to meet a very fast release schedule.
- Prepared documents such as Project Scope, Project Vision, Project Success, Business Requirements, Functional Specification, Data Warehouse Process Flow (SQL queries & Crystal Reports) using MS Office (Word, Excel, Visio) and dashboards
- Provided data to the Business Analysts during UAT
- Logged defects in UAT Environment using Quality Center.
- Developed and executed test cases test Scenarios using Quality Center.
- Created and executed scripts manually for Functionality testing
- Developed and executed test cases test Scenarios and followed-up defects using Quality Center.
- Tracked defects using Quality Center.
- Created test scripts for Security, Positive, Negative and User Acceptance Testing (UAT).
- Provided customer support as required to meet service level agreements.
- Documented and reported defects within established process and tracking systems using Quality Center.
- Generated various reports and graphs from Clear quest and Quality Center and analyzed the testing process overview.
- Wrote test cases and test scripts for the User Acceptance testing. . Design, write and maintain data requests and/or queries to support the business.
Environment: Web Services, MS Visio, Oracle, Quality Center, MS Excel, MS Access, Test Director, NT/2000, DB2, UNIX, MS Office
Confidential, Atlanta, GA
Sr. SQA Analyst
Responsibilities:
- Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
- Expert in writing test scripts manually based on BRDs, FRDs and SRSs.
- Created and managed system testing schedule
- Provided test team status reports on weekly basis to the project manager.
- Tested manually as per the specification documents.
- Performed Functionality testing during the various phases of the application and analyzed the results manually using Rational Manual Tester.
- Automated web based GUI test cases
- Conducted GUI, Backend, Data Driven and Security Testing.
- Tested processesand methodologies used to deliver Customer order application (Web Application) for quality standards interface to meet customer expectation.
- Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
- Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
- Created and maintained back-end testing on the oracle database.
- Executed test cases and reported defects in Clear Quest.
- Conducted regression testing on new builds/versions.
- Developed and executed test cases test Scenarios and followed-up defects using Clear Quest.
- Tracked defects using Clear Quest.
- Performed Defect Management activities to prioritize and resolve any issue/bug found during various software testing cycles such as SIT, UAT, Smoke Tests etc..
- Generated various reports such as Test Execution Status/Progress, Defect Status for project stakeholders and submitted them on daily and weekly basis.
- Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
- Conducted Defect Status meeting to discuss resolution of issues.
Environment: Windows, Rational Clear Quest, SQL, Oracle, Rational Manual Tester, PL/SQL, XML, J2EE, MS Office (Excel, Office, Outlook, Visio)
Confidential, Chevy Chase, MD
QA Tester
Responsibilities:
- Converted Business Requirements and Design Documentation into Test Cases and Test Scripts.
- Created description object with specified properties and values during run time, to use instead of logical names in test scripts.
- Performed Web Testing to check for broken links in a page.
- Performed data driven test for multiple scenarios with different sets of data in WINRUNNER.
- Performed data driven test for multiple scenarios with different sets of data using internal and external data sources.
- Performed Web Testing to check for broken links in a page.
- Performed Acceptance, Usability, Cross-Platform and Regression Testing during different stages of the application development.
- Used Quality Center to store Test Plans, Test Cases, Test Scripts and for bug tracking.
- Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool Quality Center.
- Monitored the progress and verified the fix of the bugs that were logged into Quality Center.
- Responsible for performing various types of process evaluations during each phase of the software development life cycle, including audit, review, walk through and hands on system testing.
- Extensively used Microsoft Office Suite of products for documentation and data interpretation.
- Bug Reporting and Tracking using Mercury Quality Center.
- Conducted the defect report using Document Generator in Quality Center.
- Interacted with the developers to report and using Quality Center
- Used Quality Center documentation management and defect tracking.
- Participated in Triage Meetings, weekly status meetings with IT and business people
Environment: Windows, Quality Center, Oracle, WINRUNNER, SQL Server, Java, Java Script, Unix, Internet explorer, Oracle, MS Office
Confidential, Urbandale, IA
Quality Assurance Analyst
Responsibilities:
- Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
- Interacted with business analysts to gather the requirements for business and performance testing.
- Have good exposure to modern Agile methodologies such as SCRUM and TDD.
- Prepared Test Data and executed Test Cases from Quality Center.
- Prepared test data and helped load test data into the test database environment.
- Testing of EDI X12 837 and 835 Transaction sets for claims processing
- Followed Agile Methodology to emphasize on real time communication over written documentation.
- Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using QTP
- Participated in building automation test scripts based on BPT module of Quality Center.
- Participated in the management of testing project with the help of QTP.
- Wrote complex SQL queries in TOAD to perform Backend testing.
- Performed Database testing using SQL queries
- Assigned the tasks of testing and evaluating Mainframe interactions with distributed systems
- Run SQL queries testing and data transfer to the Mainframe for claims process. Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing,
- Validated enhancements encompassing a large variety of platforms: Mainframe (online and batch), Web, custom built front-end entry applications, interfaces with external clients.
- Involved in creating of Test Accounts in Mainframe application according to the Business Requirements in utilization for testing
- Executed Configuration Testing to check if the application was compatible in different environment for each module of the application.
- Performed “Rate Quote” check according to Medicaid Policy and verified if the system prompts proper response for the customers who are not qualified for Medicaid program.
- Developed QTP Automation Test Scripts to perform Functionality, Security, UAT and Regression Testing for different modules of application.
- Conducted Back-End Testing manually for the purpose of Database Integrity.
- Defect tracking and bug reporting using Quality Center.
- Developed test scripts in SQL to check the data integrity from the databases
- Conducted result analysis and interacted with developers to resolve bugs.
- Bug Reporting and Tracking using Quality Center
- Performed User Acceptance Testing (UAT)
- Generated defect reports using Quality Center and presented using MS Office tools
- Performed Usability Testing
Environment: QTP, QUALITY CENTER, JIRA, SQL SERVER, Internet explorer, Mainframe, CICS, TSO, Windows, Oracle, MS Office.
Confidential, Los Angeles, CA
QA Analyst
Responsibilities:
- Tested Confidential application on devices that include iPhone, iPad, Android Device
- Involved in Development of Test Cases, Release Plan and Test Plan based on the information gathered through business requirements, Product Backlog and design/application walkthroughs.
- Performed on various video transformations (Transmux, encoding, transcoding, closed captions, colour space, HD vs SD, Resolutions, bit rates, bit depth, filters, various ABR formats - HLS, HDS, Smooth Streaming etc)
- Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
- Used JIRA bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.
- ConductedFunctionality testingduring various phases of the application.
- Added assertions, property transfer, Data Gen, XPATH Query expressions and expected results in SOAPUI to validate the request and response XML.
- Performed configuration/ compatibility and user interface testing manually.
- ImplementingAgile(Scrum) methodology throughout the Branch.
- Had thorough knowledge of Agile methodology. Attended daily scrums, sprint planning and Sprint Kick off
- Worked on a E-Commerce Web-based application accessed by potential customers for all the different offerings
- Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet.
- Exported Manual test cases into Quality Center and maintained the same in the Test Plan module
- Developed and executed Automation scripts for Regression Test Suite using HP QTP.
- Responsible for writing SQL queries, insert/update statements
- Conducted Parameterization to data tables, system performance tuning, heavy data-driven testing created object repositories in QTP.
- Worked in an Agile team to test the functionality of the Web 2.0 based customer facing site
- Responsible for researching and solving production errors within our customer-facing website and internal applications
- Developed test scripts for the test cases in QTP for functional and regression testing.
- Automate existing functional manual regression/smoke test cases using QTP
- Responsible Test planning, Test designing, and Test execution of Ecommerce application
- Responsible for developing and writing black box and GUI test cases
- Tested WebServices, SOAP and REST service, Validated XML using SOAPUI Tool
- Identified high-level requirements for documenting detailed business requirements using
- Responsible for mobile testing of clients' websites on the following platforms (Android, iOS, Tablets, Blackberry and Windows Phone)
- Tested tablet version of sites using variety of iOS and Android tablets.
- Participated in conducting System testing and End to End testing manually.
- Maintained the Test Matrix and Traceability Matrix.
- Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, iOS etc.
- Worked with three mobile application simultaneously: iOS (iPhone & iPad), Android and WP7
- Performed Web Testing to check for broken links in a page.
- Requested different versions of iOS, Android and Blackberry mobile devices
- Analyzed the Crash reports on various mobile platforms and reported to the development team
- Performed end-to-end testing, Integration Testing, and UAT Testing.
- Used Quality Center to prepare Test cases, procedures, Requirements Traceability Matrix and JIRA for managing the Defects
- Extensive use of SQL queries to perform data integrity testing.
Environment: Quality Center, JIRA, J2EE, QTP, SQL, Oracle, Clear case, SOAPUI, Fiddler, REST, Android SDK, iOS SDK, iPad, iPhone, Android smart phones and tablets, etc.
Confidential, Framingham, MA
QA Tester
Responsibilities:
- Worked closely with QA Manager and Business Analyst to prepare Business Requirements to create Test Plans, Test Cases and Test Approach/Strategy documents.
- Attended Change Request Meetings to ensure products and changes are fully documented for further Test changes.
- Worked extensively on web-based testing and involved in UAT environment, pre-production environment and production environment
- Used Agile Methodology to minimize risk by implementing software development in short time boxes or iterations.
- Performed SIT, UAT, Functional/Regression, Smoke/Sanity, Backend, and Interface testing for web application by creating various positive/negative test cases.
- Responsible for implementing QA/testing methodologies including test case/scenario development, executing, and defect tracking using Quality center.
- Manually tested the Web application to ensure the flow of the application functionality.
- Created Test Plans and Scenario which describes the features and functions to be tested.
- Performed Regression Testing, Functional, UAT and Ad-hoc testing.
- Contributed functional and technical assistance/production support, including service requests and remedy tickets; worked with SQL.
- Functionally validated Web Services delivered in SOAP XML format as provided in specification document.
- Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
- Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
- Performed Data Integrity Testing, Functionality Testing & Back-end testing.
- Gathered business requirements from users and created designs for enhancements and to remedy defects.
- Involved to report test planning, defects and executing activities using Quality Center reports.
- Resolved program Compile Errors, defects and Environmental issues.
- Performed Security Testing on the application.
- Detected, reported and tracked defects using Quality Center.
- Conducted the defect report in Quality Center.
- Interacted with the developers to report and using Quality Center.
- Developed the reports using Quality Center.
- Maintained and modified the QTP scripts with user defined functions as a part of functional and regression test.
- Measured server performance under load by creating Rendezvous points to simulate heavy load on the server.
- Interacted with developing team to resolve technical issues and investigated software faults.
Environment: Windows, UNIX, Quality Center, QTP, UAT, Agile Scrum, Fujitsu POS, Soap UI, XML, Oracle, MS Office.
Confidential, VA
QATester
Responsibilities:
- Analyzed business requirements and functional specifications to develop test plans, test scenarios and test cases accordingly.
- Conducted smoke testing, functional testing, integration testing and system testing for the Customers Information application and it's sub-modules like personal details, credit history, and annual income of Household.
- Interacted with the Back Office Teams, so the Applicants information and details are properly entered into the System.
- Maintained the Requirements Traceability Matrix.
- Created the Manual Test Cases, their documentation and automate them on later basis.
- Successful implementation of online transaction processing applications and its associated modules like database testing and validation.
- Extensively used SQL to query various databases to retrieve Information in accordance with the Requirements.
- Performed User Acceptance Testing at the Client's Location.
- Performed cross browser testing of the application on various Browsers to ensure that it functions similarly on all browsers.
- Worked with business analysts, developers and content department to resolve issues.
Environment: Quality Center 9.0, Quality Test Pro, Oracle 10g, XML, J2EE, UML, ASP.Net, MS Project.
Confidential, Dallas, TX
QA Tester
Responsibilities:
- Worked on Android devices, iPhone and Amazon Kindle Fire.
- Requirement traceability matrix to ensure all the requirements is covered during testing.
- Developed test cases as per the approved business requirements and test plan.
- Identify the client/organizational needs and provide suitable Agile system based solutions
- Tested application under the Agile, scrum and sprint development and process.
- Ability to work using cross functional using Agile Methodology.
- Executed test cases and test script as per Wireframes and Visual Design Documents.
- Developed Test Strategies and Test Scenarios.
- Responsible for uploading test plans, test scripts into Quality Center.
- Responsible for mapping and scheduling the scripts as per the assigned schedule.
- Defects were raised in the HP Quality Center/ HP ALM for logging, tracking and reporting bugs.
- Created and maintained SQL Scripts to perform back-end testing on the oracle database.
- Performed Database testing using SQL queries
- Wrote complex SQL queries for database validation using TOAD also tested stored procedures and triggers
- Created automation scripts in QTP and made a suite of scripts when needed.
- Automated the Back-End testing for reusability by writing UNIX Shell Scripts
- Tested the GUI features and verified the functional testing of the application through Android emulator.
- Involved in preparing the Automation Design document, identifying the test cases to be automated for Regression Testing using QTP.
- Experience with mobile cloud platform like Device Anywhere and Perfecto Mobile.
- Functional, GUI and interruption testing have been tested using the mobile platform.
- Executed the orders submitted in the mobile apps through mainframes.
- Log, track and review the defects using the Quality Center. Follow up on them, until the defect is fixed, retested and closed.
- Root cause analysis of defects and continuous process improvements
- Involved in the end to end testing of the native application and the mobile browser application.
- Submit the trade through the mobile app verify them in the order management system and execute them in the mainframes.
- Maintained Functional and Technical documentation.
- Analyzed and identified issues, and work closely with development teams to resolve those technical issues.
- Good understanding of the Record and run automation scripts in the automation tools
Environment: Device Anywhere, Android Emulator, J2EE, Java, SVN, Quality Center, HTML, Java Script, PL/SQL etc.
Confidential, Somers, NY
QA/Mobile Tester
Responsibilities:
- Work closely with the SCRUM team to create test scripts and test cases to ensure coverage of all areas of the product/feature(s)
- Placed orders in Break-fix and Staging environments to test various functionalities
- Working on Windows versions of the apps.
- Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
- Involved in automating the test scripts using Testing Anywhere tool
- Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
- Tested the UI of the end product on mobile, PC, tablets platforms to ensure that language translation and currency conversions were displaying as required
- Flashing the device, in order to upgrade the firmware version, which is embedded with that of the API
- Performed Grey Box, Black box testing and User Acceptance Testing.
- Executed browser compatibility testing for web (Firefox, Chrome, Safari) and mobile (Chrome) components
- Worked closely with Platform Subject Matter Expert's in understanding the upcoming and existing API's on different mobile platforms
- Uncovered multiple issues related to the data population in the backend database using QTP.
- PerformedManual Testing by Unit Testing, Integration Testing using Quality Center for the test cases.
- Performed browser compatibility and configuration testing on various operating systems.
- Work directly with managers and development team in an Agile environment
- Execution of Functional and Acceptance Test cases for a web-based Application in a fast paced Agile development environment
- Reported defects usingQTP,Quality Centerand interacted with the development team to resolve any defects/issues and worked with Rational Clear Quest.
- Participated in the testing of website applications on mobile devices.
- Validate Data Grid and Data Tables for expected results during Unit Testing cycle using SQL queries
- Creating Test Plans, Test Cases and Test Scripts by using Quality Center
- Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
- Conducted GUI, Backend, Data Driven and Security Testing.
- Developed and executed test cases test Scenarios and followed-up defects using Quality Center.
- Tracked defects using Quality Center.
Environment: Tablets, Quality Center, Java, C++, Windows Phone, SQL, Browsers like Firefox, Chrome, Safari, QTP, C#, J2EE, UNIX, Etc
Confidential, Des Moines, IA
QA / ETL Tester
Responsibilities:
- Designed and maintained test schedules, test plan, test strategy, test assignment documents for various testing activities (using SharePoint and Quality Center)
- Executed test cases and reported defects using Quality Center
- Involved in Cross platform and cross-browser functional, integration, and regression testing
- Create Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.
- Provided test team status reports on weekly basis to the project manager.
- Develop integrations to related systems to exchange requirements, test plans, and defect information
- Provided professional services ranging from the mapping of business processes, data integration between systems, technical development, and on-site software training for clients
- Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
- ImplementingAgile(Scrum) methodology throughout the Branch.
- Involved in manual and automated testing.
- Responsible for performing various types of back-end testing such as data validation, data migration, data conversion, data integrity testing.
- Running queries against databases to verify the correctness of XML response
- Used XML Spy tool to validateXMLschemas and to do transformations.
- Performing Data Analysis between the tables and applications by using SQL.
- Executed system level integration testing, generating scenarios and missions utilized in testing process and participated in peer reviews
- Performed the XML Validation of the bulk order through the SQL Navigator.
- Worked on many Oracle PLSQL Stored Procedures, triggers and indexes on Oracle tables to ensure the functionality
- Performed Data Profiling of current state of data in the Data Warehouseby doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
- Do a proper data profiling based on requirement and a high level validation in every phase of the project
- Performed Usability and Integration testing manually.
- Created customized report using OLAP Tools such as Crystal Report for business use
- Facilitated four extensively used Star Schema methodology in building the design of the logical data model into the Dimensional data modeling.
- Uncovered multiple issues related to the data population in the backend database using QTP.
- Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
- Written several complex SQL queries for validating Business Objects Reports
- Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
- Performed Data Analysis & validation by writing complex join queries
- Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
- Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
- Wrote Shell Scripts to facilitate batch testing in UNIX environment.
- Worked with ETL group for understating mappings for dimensions and facts
- Involved in testing data mapping and conversion in a server based data Warehouse.
- Excellent Understanding of Data warehousing concepts - Data marts, Star, Snowflake, Fact, fact less, Dimensions, Hierarchy, Measures, cubes Etc
- Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
- Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
- Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (Load and integration testing) and Documenting the test results
- Verified number of Informatica Graphs based on business requirements using various Filter, Partition, reformat, rollup, join, scan, normalize, gather, replicate, merge, etc functions.
- Created and maintained SQL Scripts and Unix Shell scripts to perform backend testing on the oracle database.
- Automated the Backend testing for reusability by writing Unix Shell Scripts.
Environment: Windows, Quality Center, QTP, SQL Server, SVN, SSIS, XML, XML Schemas, Crystal Reports, Oracle/UNIX, Enterprise Data Warehouse, ETL, SSRS, Informatica, etc
Confidential, NY, NY
QA Tester
Responsibilities:
- Analyzed business process workflows and critical business functions through walkthroughs and requirement documents.
- Wrote test plans and test cases based on the business requirements which involved market risk analysis and risk management like continuous time finance & asset pricing, stochastic processes & simulations, credit derivatives, structured products, documentation, value at risk, risk & return optimization.
- Created various test sets for different test cycles within Test Lab module of HP ALM/Quality Center and perform the test case assignment within HP ALM/Quality Center for offshore QA testers.
- Involved in manual and automated testing of the applications usingQTP.
- Executed testing methodologies which will include both GUI testing and database Validation testing.
- Good Knowledge in developing test scripts, running test scripts and analyzing results using testing tools Load Runner,HPALM/Quality Center, Test Director and Rational Test Manager
- Wrote Test Plan and Test Cases according to business requirement.
- Worked extensively on web-based testing and involved in UAT environment, pre-production environment and production environment
- Creating and updating test cases based on new and/or /updated functional or interface requirements
- Extensively involved in Risk analysis, Securities and their valuation, Asset Management (risks and returns), Asset Allocations, Bond pricing, Financial Derivatives, Cash flows, Financing Structure, Portfolio Analysis etc..
- Extract data from an MS SQL Server and create MS Excel and reports for business specific data validation.
- Performed Defect Root Cause Analysis, interacted with related Team, and tracked defects in a Test Director.
- Wrote various SQL queries to validate data inserted, deleted and updated in the Oracle database
- Performed Functionality testing, System testing and Regression Testing
- Performed Development Integration, Functional, Regression and End to End User Acceptance testing for the data services.
- Created Regression Test cases Suite in HP ALM/Quality Center and performed regression testing to make sure there were no broken functionalities.
- Performed various types of testing such as sanity/smoke test, features testing, functionality, interface, regression, integration, GUI, performance, data validation, back end(TOAD), Reports testing (Business Objects)
- Uncovered multiple issues related to the data population in the backend database using QTP.
- Wrote SQL queries and performed Backend Testing for data validation to check the data integrity during migration from backend to front end.
- Develop, review and execute End-to-End Test Plans, Scenarios and Test cases according to product specification and track the test coverage through requirements traceability matrixes
- Raised Defects and maintained the status of the defect in HP ALM/Quality Center.
- Performed Regression Testing, Functional, UAT and Ad-hoc testing.
- Created and maintained SQL Scripts and Unix Shell scripts to perform backend testing on the oracle database.
- Creating relevant UAT artifacts including UAT test plans, UAT test scenarios and UAT test cases to be executed during UAT.
- Participated in weekly meeting with the management team and walkthroughs
- Performed functional testing of the application throughQTP
- Performed backend testing to validate the data using SQL queries
- Performed the Backend integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Database.
- Interacted with developers to report and track bugs using JIRA.
Environment: s: Java, J2EE, MS SQL Server, QTP, HP ALM/Quality Center, JIRA, Business Objects, SQL, MS SQL Server Management Studio, Etc.
Confidential, Mountlake Terrace, WA
Sr. SQA Analyst
Responsibilities:
- Performed analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS conversion compliances based on GEM business rules
- Created Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.
- Designed and maintained test schedules, test plan, test strategy, test assignment documents for various testing activities (using SharePoint and Microsoft Visual Studio Test manager)
- Used TFS as Test management tool.
- Tested 4010/5010 conversion EDI transactions, 834, 837, 837/835, 270/271, 276/277
- Developed and executed test cases and test Scenarios and followed-up defects using TFS.
- Executed test cases and reported defects using Microsoft Visual Studio test manager
- Entering and managing defects to completion using TFS
- Validated EDI functionality as per HIPPA compliance for various inbound and outbound EDI transactions to FACETS
- Worked with Member creation/termination and Claim Processing in Facets.
- Used TFS for test documentation management and defect tracking.
- Gather requirements and document the proposed processes to the existing system. Modules included: Claims Processing Files and HIPAA Guidelines adherence across the company
- Developed test scenarios for claims processing workflows in FACETS integrated with ICD 10 codes
- Tested integration scenarios to ensure the right ICD 10 code is transmitted to billing and appropriate pricing is performed
- Defect tracking Microsoft Visual Studio (TFS)
- Enhanced applications associated with Claim Numbers so that duplicate Claim Numbers could be allowed in the system. Updated the Electronic Claims, Confidential t Screen and Sales Administration processes
- Validated X 12 files sent by external vendors to ensure that they are passing EDI Gateway level using SpecBuilder.
- Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
- Import test cases from excel/word to Microsoft Visual Studio Team Foundation server
- Used Custom Reports, Built In reports and System Reports, Trend Reports function within TFS to track and report issue related activities.
- Performing end-to-end testing, integration testing, UAT (User Acceptance Testing) and regression testing and Validate test results
- Also developed and executed test scenarios for online tool that enables providers to search for ICD 10 codes for various medical conditions
- Generated various reports and graphs from TFS and analyzed the testing process overview.
- Prioritize testing priorities based on business risk, Access testing assets anytime; anywhere via a browser interface using TFS.
- Created description object with specified properties and values during run time, to use instead of logical names in test scripts.
- Proficiency in tools such as MS Project, Word, Excel, PowerPoint and Visio
- Had thorough knowledge of agile methodology. Attended daily scrums, sprint planning and Sprint Kick off
- Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
- Executed automated test cases in TFS
- Performed Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
- Continued reviewing Ratings/Reviews from end user after each App updates.
Environment: EDI, FACETS, MS SQL Server, TFS, SpecBuilder, QTP, Web Services, SOAP UI, API, XML, UAT, Java, MS Office, MS Access etc.