SUMMARY

• About 7+ years of professional experience in Software Quality Assurance field with extensive skills in Manual testing of web - based and mobile applications
• Extensive experience with strategic test Management and documentation such as writing Data Requirement reports, Test Plans, Detailed Test cases, Test Analysis Reports, and publication of Test Results
• Experienced in using test managements tools such as JIRA, Bugzilla, HP-Quality Center-ALM
• Active participation in daily scrum, peer review meetings, requirement analysis, defect reviews with the development team and training the team members
• Implemented the Software Development Lifecycle (SDLC) to follow standards in the application development.
• Good knowledge of QA methodologies and process of software validation principles. Worked extensively in Agile projects with hectic schedules of 2 & 4 week Sprint cycles.
• Complete understanding and hands on experience in installing and configuring Automated Tools and Setting QA Test Environment.
• Experience in creating Manual and Automated scripts for performing Functional, Regression, Integration and System Testing (End to End testing).
• Coordinated UAT sessions and worked with cross functional teams.
• Experienced in working with Project manager, Development team, Business Analysts and End-users.
• Strong communication and interpersonal skills and proven ability to test with minimum software specifications.
• Participated in sprint review meetings and well versed with working in a fast paced development activity following continuous integration and DevOps model
• Working in a DevOps Environment had the opportunity to interact with business users, developers and operations team and played active role in certifying the functionality.
• Analyzed user stories for impact and performed end to end testing of various features constantly updated because of the continuous integration development practices.
• Played active role in daily Scrum meetings and discussed accomplishments, issues and targets, and contributed for the overall quality of the application
• Conversant with test automation, designed, scheduled and executed end to end automation scripts to test the business functionality from an automation perspective and support regression testing adopting Hybrid Frameworks
• Coordinated the test efforts of both on-site and off-shore teams and reported directly to the QA Manager

TECHNICAL SKILLS

Testing Tools: Quick Test Pro, HP Mercury - Quality Center, JIRA

Languages: SQL, HTML, XML, VB Script

Operating: Windows XP / 2000/ 7 / 10, Mac OS, UNIX and Linux, Android Systems

Browsers: Internet Explorer, Google Chrome, Mozilla Firefox, & Safari mobile, Mobile App Testing

Database: MS SQL Server, Oracle, MS Access

Tools: Pitney Bowes - Spectrum (ETL/MDM), SQL Server Reporting Services

Others: MS- Office Suite, iPad, iPhone

PROFESSIONAL EXPERIENCE

Confidential, Cary, NY

Senior ETL Tester

Responsibilities:

• Prepared Test Plan, Test scenarios, Tracker Sheets and Test Cases for the User Stories
• Attended the Stakeholders, Business Analysts’ and Product Owners’ call and discussed the requirements in detail
• Discussed the User Stories of the current Sprint with the Developers and thereby noted the points for drafting the Test Cases
• Updated the day-to-day tasks in the daily Scrum call with the team and the clients
• Participated in the Backlog Grooming sessions to discuss the upcoming User Stories for the future Sprints and the requirements
• Developed and modified SQL validation scripts, and writing scripts in SQL to validate the outputs
• Participated in the Sprint Review and the Sprint Retrospective meetings to go through the Sprint and any possible improvements
• Uploaded the Test Cases to the JIRA board and executed them once the User Stories came to the QA lane
• Performed Metadata check to compare the source v/s target data
• Created Minus queries to perform Data quality and correctness check
• Created the Jobs to load the data from Hub to QA-DB and Source to QA-DB
• Tested the customer data by setting the thresholds for Match-merge process
• Tested by inspecting the Data flows by inserting the Inspection points in case of the data loading failure
• Performed Data Standardization check using Data profiler (Metadata Insights) to match the requirement formats
• Scheduled and monitored the Process Flows
• Scheduled daily loads and monitored the logs for any failures
• When defect was encountered, logged it into JIRA and directed to the developer, and once fixed performed Regression test. And then moved it over to the PO review
• Provided Knowledge Transfer session to the new recruit and guided through the testing process in detail
• Have in depth knowledge of Spectrum ETL, Data Hub Visualization, Management Console, Relationship Analysis Client and Mater Data Management and the Match-Merge rule
• Tested API Stories in the SOAP UI and matched the results with the Management Console
• Have detailed knowledge of the Data Flows created by the developers in the Spectrum and also re-created the ETL Jobs for testing purposes in the QA environment
• Have the Knowledge of Team Foundation Server and imported the code from the QA branch for testing
• Tested the Data Quality from the application and also cross checking with the SQL Server Databases using Minus queries to compare the source and target data
• Worked in the dynamic Agile Environment

Confidential, Denver CO

Senior ETL Tester

Responsibilities:

• Prepared Test Plan, Test scenarios, Tracker Sheets and Test Cases for the User Stories
• Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.
• Designed developed and implemented user acceptance testing protocols as the final phase of applications development
• Captured and tested all modifications to proposed functional requirements and Document test procedures to ensure replicability. Receive and understand client requests validate preprocessing methodologies Problem solving/ Escalation and query assignment.
• Designed Test Cases for ETL to compare Source and Target database systems
• Involved in testing to run various ETL Scripts to load the data into Target Database
• Used Informatica and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
• Liaise with client on various requests. Maintain batch documentation including manuals and diagram.
• Extensively used SQL Queries for data validation.
• Performed analysis of Mapping Documents and 'Schema Compare' with Database tables, logged the defects and worked with the Database Modeling Team to resolve them.
• Developed testing programs that address areas such as software scenarios, Regression testing, negative testing, error or bug retests.
• Documented software defects, using bug tracking systems using Quality Center (QC) and report defects to the software developers.
• Attended reviews and walkthroughs to better understand the Requirement documents
• Prepared Test scripts and Test plans for Company Structure, My Business, etc.
• Conducted Back-end and Regression testing during the various phases of the application.

Confidential, Denver CO

Senior ETL Tester

Responsibilities:

• Microsoft SQL Server Version upgrade- tested and compared the reports from the Legacy to Development to New Prod Environment
• Documented the Variances and notified the Developers by uploading the Results to the Box folder
• Participated in the discussions and scrum calls to discuss the status of the tested reports for the deployment

Environment: SQL Server, Agile Scrum, JIRA, Pitney Bowes, SOAP UI, MS Office

Confidential, NY

Automation / ETL Tester

Responsibilities:

• Active participant of Agile Scrum methodology activities
• Worked with development teams for issue analysis and resolution
• Worked with Global resources and supported data loading activities
• Participated in Manual and Automated data loading using ETL processes
• Extensively used Management Console and ESP Workstation for automated data loading
• Transported source data files from Source to Staging and Target environments using Unix
• Compared data accuracy between Source and Target systems for volume and correctness
• Manually tested, verified and validated that the final output meets user requirements
• Created jobs to load data into QA tables by using home-grown ETL tool and compared results with main ETL jobs
• Heavily used SQL queries for backend data testing
• Conducting Peer review meetings, defect triage, requirement reviews, training & updating the senior management with testing status were some additional responsibilities
• Provided in Knowledge sharing sessions to the team and target users
• Responsible for writing and maintain scripts for regression and functional testing using data driven framework.
• Reviewed the Test Basis, designed and documented Test Strategies, Test Plan, Test Cases and executed test cases.
• Involved in testing the application utilizing the Scrum (Agile) methodology
• Test management process has been implemented by pivotal activities like Defect Reporting, Tracking using JIRA and interacting with the development team and the real-time users
• Extensive experience in Data loading
• Responsible for manually testing the Mobile application, Usability and Use case adherence.
• Used Appium to test the mobile application's features for native, hybrid and mobile web
• Appium is used for simulating the automated test cycles for performance
• Used Appium to write test scripts for both iOS and Android

Environment: Oracle, Unix, Agile Scrum, Windows, JIRA, Management Console, ESP Workstation, HPQuality Center-ALM, MS Office, TestNG, Maven Jenkins, GitHub, iPad, iPhone

Confidential, NYC, NY

QA Automation/Manual Tester

Responsibilities:

• Conducted Business requirements review meetings and identification of key scenarios for functionality testing
• Wrote Test Plan, Test Scenarios, Test Cases and Test Matrix documents analyzing the Use Cases
• Responsible for manually testing the entire application for GUI, Functionality, Business Logic and Use case adherence. Played active role in daily scrum meeting and worked closely with the developers in defect analysis, triage, code reviews and prioritization of issues
• Played active role in allocation of responsibilities, training, and organizing the testing team efforts.
• Participated in the testing effort at all the stages of SDLC (Agile model) and executed test cases and documented the test results using HP Quality Center.
• Automated the key functional scenarios using QTP to support regression testing and managed the entire test efforts in an integrated QC environment.
• Extensively involved with backend testing by writing SQL queries. Analyzed BRD/FRD.
• Tested financial applications, reports, and tools. Involved in integration testing for Accounting & Finance related applications
• Generated test strategies and test plan.
• Developed Test Cases based on BRD & FRD. Executed test case.
• Tracked and filed defect. Assigned developer to fix defect.
• Performed accessibility testing of web-based applications against Section 508 compliance
• Participated in requirement analysis & risk assessment, reviewed user stories and requirement, analyzed testing.
• Conducted black box, end to end testing, Regression, Integration testing, Backend testing, UAT testing.
• Performed Functional testing using QTP. Tested report using Cognos. Tested web based application.
• Customized the Test Cases and Test Plans in ALM according to any changes of requirement.
• Extensively used ALM for defect tracking and reporting. Received on job training on XML, UFT, QTP
• Tested Internet Application on different browsers.
• Expertise in working with Quality Center for logging, tracking, retesting and reporting the defects.
• Involved in User Acceptance testing.
• Creating Test Matrix for reports.
• Received on job training on Load and stress testing using Load Runner. Participated in scrum, sprint analysis.
• Created & executed automation scripts under supervision & instruction. Performed Database testing (SQL).
• Tested Market data with solid understanding of financial markets and asset types (equities, fixed income, Mortgage, derivatives, and commodities).
• Wrote and executed SQL queries.
• Writing Test Cases, Test Scripts, and Testing Scenarios, using Quick Test Professional for Regression testing, implementing the required Checkpoints and updating them from time to time
• Used SQL for extracting the required data related to testing, test dataset creation and verification
• Peer review meetings, defect triage, requirement reviews, training & updating the senior management with testing status were some additional responsibilities
• Tested the application for browser and operating system compatibility and also accessibility on mobile devices
• Participated in end-user training of the application during UAT phase

Environment: Java, HTML, UNIX, Oracle, Windows NT/XP, HP Quality Center-ALM, Internet Explorer, Google Chrome, iPhone