SUMMARY:

• Information technology professional with 13 + years of experience in Requirement’s Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance Testing . I had very strong Manual QA background and worked as Senior Manual Tester, Web Application Tester, Mobile Application Tester, Back end Tester, ETL/BI Tester, Quality Data Analyst and also have good exposure to Automation Testing tools like UFT, Selenium etc.
• Worked with Multiple clients in various domains performing different QA roles
• Worked with several test management tools like HP Quality Center (QC), ALM, Jira, Rally etc.
• To read all the requirement documents and understand what needs to be tested.
• Based on the available resources decide how it is to be tested and when it has to be tested
• Solid knowledge on Content Management System, also tested application which involves Captcha images or content
• Worked with several systems like Pega, Siebel and PeopleSoft etc.
• Inform the test manager about what all resources will be required for software testing.
• Develop test cases and prioritize testing activities as required.
• Execute all the test case and report defects, define severity and priority for each defect.
• Carry out regression testing every time when changes are made to the code to fix defects.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Expert in testing mobiles apps on different operating systems like Windows, Unix
• Experienced in validating web applications across operating systems and different browser versions
• Strong knowledge in functional/regression/UAT/GUI testing etc
• Worked on several test management tools like HP quality center, Jira and Bugzilla
• Had sound knowledge on automation tools like Selenium, UFT & Perfecto etc.
• Experience in executing test cases suing automation tools like UFT or Perfecto
• Quality Assurance: Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and manual testing based on the User Requirement Document and System Requirement documents.
• Experience in writing Test Plan and Test Strategies for Data Warehousing Applications.
• Good experience in System, Integration, Performance, Sanity, Security, Load, Database, UAT, Usability and Regression Testing.
• Professional Experience in Retail, Financial, Mortgage, Brokerage, Banking, HealthCare applications and strong understanding of Banking / Financials / Mortgage lending applications.
• Experience in data validation of various sources like Teradata , DB2, Informix, Oracle, SQL Server and Sybase.
• Excellent written and verbal communication & interpersonal skills.

TECHNICAL SKILLS:

Testing Tools: Test Director 8.0/7.6/7.2, Load Runner 7.6/7.2, Rational Clear Quest

Networking: GSM, GPRS, TCP/IP, UDP, MPLS, Core Networks, Wireless Networks including 802.11, Network stack, LAN, WAN and MAN

Middleware: SOAP, REST, TIBCO

Languages: Java, .NET, XML, HTML, SQL, Java Script, VB Script

Operating Systems: Windows 10, UNIX, Linux

Databases: MS Access, Teradata, MS SQL Server 2008 R2, Oracle10g/9i/8i, DB2

ETL Tools: Informatica Power Center 7.1.3/8.6.1 , Abinitio 2.1, Data Stage 8.0/8.6, SSIS

Reporting Tools: Business Objects 4.0/5.0, Cognos 7.3/10, OBIEE 10.0, SSRS

Browsers: Internet Explorer, Netscape Navigator, Fire fox, Chrome

Bug Tracking Tool: Quality Center, Jira

GUI Tools: Visual Basic 5.0/ 6.0, Crystal Reports 4.6/6.0

App/Web Servers: Apache, Tomcat, Web logic, Web spheres, TFS

MS Suite: : MS Office 2007/2010/2011 (Word, Excel, Power Point, Outlook)

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. QA Analyst

Responsibilities:

• Lead a team of 4 resources in offshore and worked closely on a daily basis for status report
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
• Validated all kinds of transformations used in every work flow used to transform data.
• Checking the data flow from one end to another by using SQL queries.
• Involved in Smoke, Functional, Regression, System, Integration and Security testing during all phases.
• Performed manually testing using Cross browser and Cross Platform.
• Validated various Hyperlinks on web pages also performed GUI testing manually.
• Participated in the team to performed User Acceptance Testing.
• Involved in the executing and retrieving the data for SQL Queries.
• Interacted with developers and users to resolve major bugs.
• Created Test input requirements and prepared the test data for Data Driven testing. for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS - Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: PEGA 8.3.1, Oracle, XML, SOAP, Teradata, Microsoft Office, Quality Center, TFS, SharePoint

Confidential, Bellevue, WA

Sr. QA Analyst

Responsibilities:

• Provide technical support to the various team such as automation team, QA team and design team to meet production expectation.
• Understanding the software requirements and knowing how the end user will use the application
• Creating test cases from the user stories or from test scenarios
• Execute the test cases and prepare test results and make sure that the application is defect free
• Execute repetitive test cases using automation tools like UFT and TESLA
• RCA for failures on network side and defect tracking using HPQC.
• Oversee production deployment and communicate project goals, timeline to upper management.
• Prepare Test Status Reports and Defect Matrix and share the information to broader audience
• Created Test input requirements and prepared the test data for data driven testing.
• Involved in developing detailed Test plan, Test cases and test scripts using Test Director for Functional, Security and Regression Testing.
• Validate different call flows like registration, de- registration, messaging, file transfer etc.
• Troubleshot issues based on the need and have the defect assigned to right team
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics
• Validating the data passed to downstream systems and verify results
• Tested the processes for both before data validation and after data validation process
• Log the defects in defect management tool HP QC and monitor the status as and when required

Environment: SIP, Wireshark, XML, iOS 6.0 (Mobile Client Application) / Android, HP Quality Center, Windows OS, Chrome, Firefox, Tesla, UFT, Jira

Confidential, Bellevue, WA

Sr. Test Engineer

Responsibilities:

• Analyzed Software requirements, Business requirements and Functional Specifications documents to get a better understanding of the application from both technical and business perspectives.
• Actively participated in Test Planning, Functional Specification reviews, Design/Code reviews, Implementation /Engineering reviews, Guidelines, Process and Standards.
• Analyzing the Requirements from the client
• Participating in preparing Test Plan and Test Scenarios
• Preparing Test Cases for module, integration and system testing
• Preparing Test Data’s for the test cases in Test environment
• Preparing Test Environment to execute the test cases
• Analyzing the Test Cases prepared by other team members
• Executing the Test Cases and Defect Tracking
• Preparing Lesson Learnt documents from the previous project testing experience
• Preparing Suggestion Documents to improve the quality of the application
• Designed and developed the Test plan, Test Scripts, test goals for the applications and executed them.
• Maintained and modified to accommodate new changes to the software by interacting with development team and conducting meetings with partners and vendors.
• Identified Test Data requirements and created Test Data for System and E2E testing
• Performed Functionality, Integration, Performance, System, Regression tests manually based on Analysis, and understanding of the requirements, non-functional specifications, and end-user needs on SIP,HTTP,HTTPS protocols, XML applications, ORACLE database, Weblogic server on both UNIX and WINDOWS environment.
• Participated in User Acceptance Testing (UAT) and user feedback reported to QA Manager in the form of Change requests (CR’s)
• Created Data-Driven tests to check the performance of the application with different sets of data. Developed SQL scripts to extract data from the target tables to provide the data mapping.
• Worked closely with the Project Management, Development, Engineering and Operations teams in performing QA/QC activities and smooth deployment into Production environment and Post Production support.
• Actively participated and supported on all other on-going Projects within and outside Data Engineering Systems platforms.
• Listed and recommended testing strategies to be employed to test the critical areas of different modules.

Environment: SIP, Wireshark, XML, iOS 6.0 (Mobile Client Application) / Android, J2EE, MYSQL, Quality Center, Windows OS, Chrome, Firefox, Tesla, Jira

Confidential, Beaverton, OR

Sr. Data Analyst

Responsibilities:

• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center 10.0
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Collected requirements and tested several business reports.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Performed high-end data analyst with very strong database skills and SQL.
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed

Environment: Informatica 8.6, Oracle 10g, MS Excel, UNIX, Quality Center 10, Toad 9.1, Unix Shell scripting, Autosys 4.0, Windows XP.

Confidential, Milwaukee, WI

Manual QA & Data Integration Analyst

Responsibilities:

• Worked with Architect and Business users to collect the requirements to test the warehouse/mart.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Prepared Test Plan document to track the execution and results of test activities.
• Actively participated in calls with offshore team to track the progress of various testing activities.
• Conducted team meetings and project meetings when needed to in-order to meet testing deadlines.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed scripts, utilities, data sets and other programming test tools as required for executing test plans.
• Tested number of complex ETL graphs, transformation logic for both full load and daily data loads.
• Creating test cases for ETL graphs and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/SIT/QA/UAT/Prod.
• Extensively worked with flat files and excel sheet data sources. 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 QC
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.
• Document the test execution and results in shared environment to have them available to other team members and get the status from fellow teams.
• Used various techniques like using automation scripts to drive the execution smooth and quicker.

Environment : Informatica 8.6, Peoplesoft, Rapid SQL, SQL SERVER 2008, Db2, Windows XP, SQL.

Confidential, Irvine, CA

Quality Data Analyst

Responsibilities:

• Analyzed business requirements documents and writing Functional Test cases, Integration Test cases.
• Mapping of test cases to user requirements and coordinating with the Development team for defect analysis.
• Attending Status meetings, standup meetings and Defect Review meetings during execution.
• Understanding the System Requirements for web application and creating high level Scenarios and writing low level test cases.
• Used the Agile methodology to build the different phases of Software development life cycle. (SDLC).
• Involved in gathering the requirements for the Operational Reports.
• Designing, Executing and Defect Tracking in TFS.
• Helped the Testing team by writing SQL statements to validate the reports.

Environment: Data Stage 8.6, TFS, SSIS, SSRS, SQL SERVER 2008 R2, Windows XP, SQL, PL/SQL.

Confidential, Framingham, MA

ETL QA Analyst

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC (Agile).
• Involved in preparation of Effort estimation and schedule documents and presented to clients.
• Facilitate System, Regression and User Acceptance Testing.
• Design and Develop Testing Strategy and Plans for different application releases.
• Created and executed detail function test scripts and Test cases based on the business requirements.
• Incremental development/testing of Enterprise Data Warehouse.
• Responsible for Data Mapping testing by writing complex SQL Queries.
• Validating fields present in the reports are as agreed in specifications.
• Arranged meetings with business customers in better understanding the reports by using business naming conventions.
• Involved in validating the aggregate table based on the rollup process documented in data mapping.
• Utilized Quality Center to map the Requirements, Test Cases to develop Requirement Traceability Matrix.
• Created multiple test scenarios based on business rules to create data driven testing.
• Performed various types of testing, such as Black box, Functional, Performance, Negative, System and Regression testing.
• Determined testing scope and prioritized deliverables in different phases.
• Tested data warehouse components, data marts, testing of Dimension and Fact loads.
• Preparation of test scenarios for data flow and testing of automation of jobs.
• Tested ETL process for both before data validation and after data validation process.
• Tested the messages published by ETL tool and data loaded into various databases.
• Extensively used ETL Data Stage to load from operational system (Oracle database) and flat files into the target data warehouse.

Environment: Data Stage 8.6, Mainframe, Quality Center 11.0, SQL SERVER 2008, Biz Talk Server, Rumba UNIX Display, Windows, DB2, Cognos 10.0, SQL.

Confidential

QA Analyst

Responsibilities:

• Review web-based application and identify critical functionalities
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the DB2 database in UNIX environment.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Tested on the Data Validation rules of various input data files through the generic conditioning graph ensuring the integrity of data used for processing based on the rules.
• Tested jobs and used Ab Initio as an ETL tool to load the final loads.
• Worked with the DW Architecture team in Testing complex Delta processing Loads.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Involved in creating both positive and negative test data to cover all business scenarios.
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests. for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Gathering, Understanding and Documenting Requirements
• Develop and execute Test Plans and Test Cases from requirements and specifications documents
• Participate and create Test Plans
• Manually create, develop and executed Test Cases
• Execute manual testing for all cases
• Test Engineer / UAT Support
• Team Coordination & Mentoring New Team Members.
• Worked in capacity of Module lead / SPOC for testing of SMS & Admin Portal modules.
• Involved in requirement analysis, impact analysis sessions with respect to testing activities & efforts for new requirements.
• Test Case Creation, Peer Reviews & Execution
• Functional, Integration, System & Regression testing of Web/Mobile (iOS/Android) application.

Environment: Windows OS, SQL, Oracle, TFS, Jira, Quality Center, Chrome, Firefox, SOAP, XML