OBJECTIVE:

QA Lead with diverse knowledge in SQL and UNIX, ready to work in a challenging and professional environment by constantly learning new technologies and helping the organization achieve it's goals and a Business Analyst with c ommitment to ongoing professional development and research to ensure currency and innovation in management and problem - solving.

SUMMARY:

• Around 10 years of Software Testing experience.
• Involved in various Phases and Types of testing such as Functional, System, Regression, Mainframe testing, Sanity testing and Automation Testing.
• Performed extensive System testing, Database testing, Backend testing, White box testing, Black box testing, SOA testing, GUI testing and UAT testing.
• Responsible for developing Test strategies, Test Plans, Test Cases, Test Scripts, Test Procedures and Testing Standards based on business requirements, rules and system specifications.
• Good concept of ETL, Data Warehouse and BI applications integration.
• Extensive experience in working with Load Runner,QTP and UFT 12 version.
• Experience in installing & configuring various tools such as UFT, Rapid SQL, MS Query, SAS for query execution.
• Worked on Automation Framework, Automation feasibility, Development and execution of scripts using VB script, Peer review, Metric calculation, Development estimation, and defining process methodology.
• Experience with API testing Webservices, XML,HTTPS.
• Created and executed testing processes, Requirement Mapping, Test Execution and Defect tracking & documentation.
• Created/executed test cases, participated in the status and retrospective meetings with members of Project management team as well as Development and Deployment team.
• Responsible for smoke testing, look and feel, UI, design, fail over, functional, regression testing.
• Comprehensive knowledge of Core Java JSP, Agile technologies, XML and Web Services.
• Extensively worked with SQL Queries to retrieve data from tables for validations purpose using SSIS.
• Identified, analyzed, and documented defects utilizing JIRA as defect tracking system.
• Involved in defect reporting, defect tracking and defect reproducing.
• Exposure on relational databases DB2, Oracle and SQL. Excellent SQL skills and working knowledge of RDBMS with solid Back End Testing experience by writing and executing complex SQL Queries.
• Extensive knowledge of Object Oriented Analysis and Design using UML, Rational Unified Process (RUP), CMMI, Requisite Pro, DOORS and MS Visio.
• Thorough knowledge of UML, RUP, Waterfall, Agile- SCRUM, RAD methodology and rational tools.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, and activity diagrams), and Class Diagrams based on UML methodology using Rational Rose.
• Expertise in project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Knowledgeable in Physical and logical data modeling using ERwin and ER-Studio.
• Experienced inTesting Web Applications in multi-tier, Client-Server, Object-Oriented technology.
• Experience in testing code developed in TDD/ BDD environments.
• Good experience in Acceptance Test driven development technique (ATDD).
• Experienced inTesting Web Applications in multi-tier, Client-Server, Object-Oriented technology.
• Very effective in defect detection, self-motivated &a team player.

TECHNICAL SKILLS:

Testing Tools: HP ALM, Confidential, QTP/UFT

Languages: Java, HTML, JavaScript, VBScript, Gherkin, SQL, PL/SQL

Defect Management Tool: Quality Center, JIRA, Bugzilla

Databases: Sybase 15, SQL Server 2008, MS SQL,Oracle 10 g,IBM DB2,MS

Version Control: SVN, GIT, Microsoft Visual Source Safe, TFS,PVCS, SCCS

Tools: IBM DOORS, SoapUI, Informatica Dynamic Data Masking tool

Requirement Management: MS Visio 2010, MS Office, Rational Rose, IBM DOORS.

Project Management: MS Office 2010, Lotus Notes, MS Outlook

Data Modeling Analysis: Rational Rose, MS Visio, ERwin Studio

Presentation: MS Office/Excel/PowerPoint 2010

Operating System: MS Windows XP, Windows7, UNIX

WORK EXPERIENCE:

Test Lead/Business Analyst

Confidential, Virginia

Responsibilities:

• Involved in gathering the requirements for the application during the review meetings with the Business.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio.
• Got the business sign-off on the BRD after the requirements were streamlined.
• Published the requirements in DOORS once they were baselined.
• Performed gap analysis ensuring business SOX compliance.
• Create and distribute project deliverables - Project estimates, Test strategy, project plan, test artifacts, status reports to the project management team.
• Involved in SIT test execution and support to create complex queries to test various types of database (DB2, MSSQL, Oracle and Sybase) using various query tools mentioned above in Environment and tools section.
• Support UAT team and walkthrough test artifacts (test strategy, test plan and summary reports, test cases and various query patterns) for their testing.
• Extensively created all kinds of query patterns for various database testing.
• Designed and executed modularized re-usable automated scripts using- QTP/UFT, VBScript.
• Create/ support the Automation scripts to integrate into Confidential framework to overcome manual activities as per the requirements.
• Supported/guided team members to create Automation scripts and usage.
• Used Data Driven Testing methodology to test the application with multiple sets of data.
• Maintain testing activities in ALM - create folder structure and upload test cases, create releases and assign test cases to test cycles, generate testing status dashboard, RTM, defect management etc.
• Interacted and coordinated with the Performance testing team for analyzing Load Testing and Stress Testing results on various modules using Load Runner.
• Create knowledge-based articles (KBA), Job aid documents for business users to validate in pre-prod and prod environments.
• Host daily defect triage meetings with all stakeholders, updated them on problem status and ensured speedy resolutions.
• Responsible for Documentation in each phase of RUP Methodology, Risk Assessment, and Validation Verification process.
• Co-ordinate and analyze the database performance working closely with Performance testing team.
• POC for UAT, Prod team and SIT testing activities and deliverables.
• Performed Business Testing by writing queries to retrieve relevant data using SQL developer from various databases.
• Demonstrated leadership skills working with different team members and groups to help improve overall product quality.
• Guided testing team activities and providing sign-off of test phase completion.
• Experience creating test schedules, and creating and executing test strategies based on software specifications.
• Experience coordinating, tracking, and analyzing testing activities, including hands-on use of defect management tools to identify, document, track and communicate problems to technical staff.

Environment: IBM Doors, Visio, UML, OO modeling, RUP, CMMI, Databases (MySQL,DB2, MSSQL, Oracle, Sybase) HP UFT 12.51, HP ALM 11.52, Rapid SQL 8.7.5, Oracle SQL Developer 1.5.5, iSQL, SQL Server 2014 Management Studio, MSQuery, DBArtisan, Load Runner, GIT,MS Excel/Access, PC SAS.

Confidential, Virginia

Responsibilities:

• Collated business requirements, then translating these into functional specifications and detailed test plans.
• Identifying possible improvements to financial and operational efficiency.
• Provided input to the development of formal business cases.
• Converted business requirements into functional requirements, created Functional Requirement Document (FRD), managed and maintained requirements traceability using DOORS.
• Wrote SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Worked with the Performance testing team in creating performance test scripts and configuration of performance tests using Load Runner.
• Maintained system protocols by writing and updating procedures.
• Scheduled and Participated in technical meetings.
• Established and maintained communication channels with senior managers, key team members and stakeholders.
• Responsible for creating artifacts for Rational Unified Process (RUP) - use cases, system architecture document using UML, supplemental requirements document, architecture diagrams; verifying technical production infrastructure; designing and executing performance tests and documentation.
• Re-engineered the business model using data modeling tools like MS Visio.
• Creating detailed documentation of business systems.
• Documented business requirements and define its scope and objectives.
• Developed project plans and ensuring plan adherence.
• Involved in Gap Analysis and assisted the development team to understand the To-Be process.
• Used analytical tools, reports and Key Performance Indicators to monitor operational performance.
• Working closely with stakeholders to determine the priority of specific requirements based on their value to the business.
• Involved in identifying issues and recommending solutions.
• Provided clients with initial and ongoing support throughout the lifecycle of a program.
• Proactively conversed with stakeholders at all levels.
• Developed and Documented Test scenarios and Test cases in accordance with the Business Requirements Documents and the Functional Requirements Specification documents.
• Designed and executed test scenarios and test scripts involving testing of web services(SOAP and REST) and XML with Soap UI for the local WSDL / with URL and created Test cases, executed them to test application's complete business flow.
• Perform responsibilities of developing test scripts by using SOA test tools.
• Prepared Test Metrics and generated monthly status reports for upper management review.
• Developed estimates for business analysis tasks.

Environment: IBM DOORS 9.5, RUP, SoapUI, REST, HTML, Java, Javascript, Databases (DB2, MSSQL, Oracle, Sybase), HP ALM 11.52, Rapid SQL 8.7.5, Load Runner, Microsoft Office, MS Excel/Access and PowerPoint.

Confidential, Virginia

Responsibilities:

• Involved in the Business requirements meetings, coordinated with the Business Analysts and UAT Plan for the implementation of new features.
• Created Test Plan, Test Strategyfor the overall applications for Infrastructure Testing.
• Involved with the Architect, Stakeholders, and Business Analysts to discuss and finalize the Test scenarios.
• Performed Back End Testing and wrote queries to retrieve relevant data using SQL from various databases - Sybase, Oracle, DB2, MS SQL.
• Created the Test Summary Report (TSR) to detail the testing effort such as Test Case ID, number of Test Cases executed, passed, failed and status of Test Cases.
• Used Load Runner to regularly test performance life cycles.
• Maintained documentation regarding delays.
• Collected metrics, coordinated test results looking for inconsistencies and ways to improve overall companywide performance.
• Created Release Cycles for mapping the requirements to the test cases and generate RTM.
• Executed the test cases, documented evidences and uploaded to ALM.
• Rectified major errors encountered during HP ALM Audit.
• Mentored junior testers on the projects for Infrastructure testing.

Environment: HP ALM, QTP/UFT, Load Runner, Sybase, SQL Server, Oracle, DB2, Active Directory, Unix/Linux, Windows, MAC OIM, Remedy.

S r. Test Analyst

Confidential

Responsibilities:

• Requirements gathering and analysis for each sprint by the study of client applications and clarifications through sprint review meetings with Business Analyst and developers.
• Written acceptance criteria and acceptance test scenarios using Cucumber to drive development, based on Acceptance Test Driven Development (ATDD) approach.
• Exclusively worked in Agile Scrum Environment.
• Involved in Agile methodology of testing and had direct interaction with the client.
• Validated Transaction testing of Front end by applying knowledge in Core Java and Advanced java concepts like Exception, JDBC, I/O, Collections.
• Performed peer review of test artifacts namely test data, test case and test script prepared for testing the application.
• Test results and daily status reporting in the scrum meetings and publication of test metrics with test evidence in Confidential and SharePoint for senior management review after the sprint tasks are completed.
• Defect reporting, tracking and closure using Confidential .
• Coordinated and led defect review meeting and defect clarification with other stakeholders of the project.
• Planned for the tasks targeted for the next sprint with the business, developers and all other stakeholders.
• Participated in knowledge sharing meetings involving the necessary changes to be made in the framework with the team members.

Environment: Quality Center 10.0, Java, Apache, ATDD, JUnit, SharePoint, Cucumber, Gherkin, Jenkins, Excel.

Sr. QA Analyst ( ETL)

Confidential, New Jersey

Responsibilities:

• Created test data, test conditions and test cases from use-case, identified test cases to be automated for regression testing.
• Knowledgeable in Investment Management under Asset Management.
• Written Test Cases for ETL to compare Source and Target database systems.
• Performed back-end testing using SQL queries to make sure that data entered has been uploaded correctly into the database.
• Prepared SQL scripts to verify data and validating data from source and target through ETL loading.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads in Power Center.
• Creating test cases for ETL mappings and design documents for production support.
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL projects.
• Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Involved in installation, un-installation and deployment of product.
• Tested business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Tested the workflow of the test data to be extracted from the Staging tables and loaded the data into database main tables in SSIS using Management Studio.
• Identifying duplicate records in the staging area before data gets processed.
• Executing and monitoring jobs through Autosys.
• Identified Defects, created Defect Report, logged/tracked Defects using Quality Center.
• Conducted defect review meetings on a daily basis.
• Analyzed the Defect Metrics to identify the project status.
• Execution of Smoke Test, Functional Test and Regression Test.

Environment: Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor),SQL Server 2014 Management Studio, Quality Center, SSIS, Autosys, Putty, Windows XP, SQL, TFS, MS Office suite.

System Analyst / QA Analyst

Confidential, Virginia

Responsibilities:

• Involved in Requirement study from Use cases.
• Created test cases for testing database application and prepared Test Case documents such as RTM, test summary report.
• Involved in execution of Test Cases and Preparation of Test Data.
• Conducted Peer Review of team member’s scenarios, test cases and scripts.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Developed test cases for SQL objects verification and testing.
• Extensively written SQL scripts for back-end validations.
• Ensured that the mappings are correct and conducted data validation testing.
• Extensively involved in Regression testing manually.
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures for enforcing changes through defect tracking.
• Created Defect reports and traceability matrix in Defect management and Bug Reporting tool.
• Worked with utility tools like Putty for UNIX terminal connectivity, tested the connectivity, FTP’ing of files.
• Written UNIX script to read the data from a CSV file and load into the database.
• Verified/monitored the Autosys jobs delivered the expected files in a timely manner.

Environment: Quality Center 10.0, QTP, Sybase, UNIX, MS-Office 2007, Putty, Autosys.

QA Tester

Confidential, New York

Responsibilities:

• Writing test cases for the User Requirements documented in the Functional Specification Document in the form of Use Cases.
• Creating test data based on the test cases and executing the test cases.
• Involved in creating Requirement Traceability Matrix.
• Tracking the Defects using Bugzilla and prepared the status reports.
• Writing Test Cases according to the Functional Specifications.
• Performed Functional Testing to validate the functionality of the Application.
• Executing Test Cases to validate the Functionality and Transactions.
• Participating Weekly Status Meeting along with the team.

Environment: JIRA,Buzilla, Sybase, DB Artisan, MS-Office, Putty