SUMMARY:

• Diversified experience in Software Testing and Quality Assurance
• Demonstrated ability to write and execute test plans, test conditions and Test Cases
• Hands on Experience in Functional, Integration, Regression, User Acceptance Testing, System Testing
• Experience in RDBMS technologies like Oracle, DB2, Teradata, MS SQL Server
• Knowledge of test automation with Mercury Quick Test Professional, Mercury Quality Centre and Test Director for test case and defect Management
• Mainframes testing skills include JCL’s for test environment, batch test file creation, DB2 querying
• Experience in preparing Test Plans, Authoring Test Cases based on customer Requirements and Test Summary Reports and Bug Reports
• Good knowledge of SDLC and STLC concepts
• Have experience in working on Agile Testing process
• Experience in writing SQL and PL/SQL statements 
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Have good knowledge on OBIEE and SSRS
• Experience in Black Box testing like Functional Testing, Adhoc, Exploratory testing, UI, Usability Testing, Regression Testing, Integration Testing, Browser compatibility testing, Security, Positive and negative Testing, System Testing, Database Testing, API Testing
• Experience with various Operating Systems; Windows and Unix
• Proficient in Manual and Automation testing of Client/Server applications, Web applications
• Knowledge on performance testing concepts
• Knowledge of game testing techniques and methodologies
• Passion for playing, testing computer games for computers, mobile phones and electronic devices
• Proficient in conducting Product Requirement meetings with the stakeholders on Development and Testability
• Experience working in Test Automation Selenium tools
• Arrange and conduct project kickoff, code review, defect triage, sprint planning, retrospective meetings
• Highly motivated, Detail oriented, able to work independently or as a part of a team
• Excellent interpersonal, communication, documentation & presentation skills

TECHNICAL SKILLS: 

Operating Systems: Windows 2000, XP, UNIX, Linux

Languages: COBOL, C, VB.NET, C#.NET, Java, PL/SQL

Data Base: SQL Server 2008/2005/2000 , MS Access, DB2 8/7/5.1, Oracle 10g/9i, Teradata, Mongodb

Defect tracking Tools: Bugzilla, Bug Tracking Tool (BTS), Jira, PVCS Tracker

Config. Tools/Source Tool: WinCvs, VFS, TFS

Web Technologies: HTML, DHTML, XML, ASP.NET

Protocols: HTTP, TCP/IP, SMTP, FTP

Scripting Languages: JavaScript, VBScript, Shell

Automation : Selenium 3.0.1 (IDE, RC, Web Driver, Grid), QTP10, Win Runner8.2

Test Management Tool : Test Director, QC, ALM

Reporting Tools : SSRS 2005/2008, OBIEE 10.0.3 

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, CA

Sr. Test Analyst

 Axiom (Web Application)

Environment: Java, HTML, JavaScript, MongoDb, Json, SQL, Selenium Webdriver, GIT, SpringBoot, Jenkins, Cucumber, Maven, JUnit, Jira

Responsibilities:

• Active participation in Sprint Planning, Review and Retro
• Analysis of all functional and business requirements from the functional design specification and product backlog sheets
• Preparation of Test Plan and Test Strategy document
• Perform ambiguity reviews on requirements and design documents
• Preparation of Test Cases
• Review and modify the already existing test cases in ALM
• Creating, Executing Selenium Test Cases and Reporting Defects
• Responsible for day to day commits and Jenkins failure fix’s
• Providing estimates to senior managers
• Conducted defect triage meetings with development and BA for fixes and validate back
• Escalate project exceptions to the Project Manager
• Coordinating with the offshore and onsite team and update project plan and status reports
• Maintaining the team in terms of status reporting, resource management and reporting
• Assigning test cases to team members, monitor progress, posting application issues
• Amending the test cases to be in sync with the functional requirements, posting both application and case issues in bug tracking tool
• Preparing Estimation and Schedules for the day and for weekly as per the client schedules
• Responsible for weekly status updates showing the progress of the testing efforts and open issues

Confidential, Pleasanton, CA

Sr. Test Analyst/Lead

 Loyalty, B2E 

Environment: VB.Net, ASP.Net, C#, Java, Objective - C, HTML, JavaScript, QTP, Oracle, Corema, DataPower, Json, SQL, SeleniumTest Management Tools: HP Quality Center, Microsoft Test Manager, Jira, Rational Quality ManagerTest Management Tools: HP Quality Center, Microsoft Test Manager, Jira, Rational Quality Manager

• Active participation in Sprint Planning and Review
• Analysis of all functional and business requirements from the functional design specification and product backlog sheets
• Performed cross-browser/platform testing for web based applications for iPhone, iPad and Android
• Performed testing on iPhone6, iPhone5, iPad, Samsung S5 and other devices
• Preparation of Test Plan and Test Strategy document
• Perform ambiguity reviews on requirements and design documents
• Preparation of Test Cases
• Review and modify the already existing test cases in ALM
• Executing Selenium Test Cases and Reporting Defects
• Execution of Test Cases on different devices and platforms including IOS and Android
• Providing estimates to senior managers
• Involved in executing the automated test cases using Perfecto Mobile Tool
• Conducted defect triage meetings with development and BA for fixes and validate back
• Conducted Database Integrity testing by executing SQL statements
• Escalate project exceptions to the Project Manager
• Coordinating with the offshore and onsite team and update project plan and status reports
• Maintaining the team in terms of status reporting, resource management and reporting
• Assigning test cases to team members, monitor progress, posting application issues
• Amending the test cases to be in sync with the functional requirements, posting both application and case issues in bug tracking tool
• Preparing Estimation and Schedules for the day and for weekly as per the client schedules
• Responsible for weekly status updates showing the progress of the testing efforts and open issues

Confidential, Pleasanton, CA 

Sr. Test Engineer (ETL)

Safeway Loyalty

Environment: VB.Net, ASP.Net, C#, HTML, SQL, Java, DB2, Teradata, Unix, HP Quality Center 10.0, QTP 10.0, Oracle 10g, Selenium, Teradata V2R6, PL/SQL, XML, UNIX, Cassandra

• Analysis of all functional and business requirements from the functional design specification and product backlog sheets
• Preparation of Test Plan and Test Strategy document
• Perform ambiguity reviews on requirements and design documents
• Enhancing the Test Scripts for Global Execution
• Involved in Regression Testing using Selenium
• Review and modify the already existing test cases in ALM
• To ensure that data created, maintained and reported by the application is accurate
• Pass defect log to development for fixes and validate back
• To ensure that data created, maintained and reported by the application is accurate
• Conducted Database Integrity testing by running SQL statements
• Participating in the requirements review, Defect Triage meetings
• Responsible for different Data mapping activities from Source systems to Teradata
• Testing of ETLs by running the scripts in Unix environment
• Setup and Validation of ETL scripts in Oracle and Teradata DBs
• Tested the ETL mappings and other ETL Processes 
• Testing database migration from Oracle to Teradata
• Involved in Regression testing using automation tool QTP/UFT
• Verify users will be able to clip the offers and redeem them at POS

Confidential

Senior Test Analyst

Environment: Vb.Net, Asp.Net, C#, Java, Html, Microsoft Access, Team Foundation Server, Windows 2000/XP, My SQL, Windows XP, Quality Center

• Analysis of all functional and business requirements from the functional design specification and product backlog sheets
• Preparation of Test Plan and Test Strategy document
• Perform ambiguity reviews on requirements and design documents
• Preparation of Test Cases
• Review and modify the test cases in QC
• Monitoring and reporting test metrics and defects using Team Foundation server
• Execution of Test Cases and Posting defects
• Pass defect log to development for fixes and validate back
• Worked on Medicare, Medicaid insurances
• Good working experience of Quality Center/ALM, SQL Server
• Enhanced test cases using Java Programming features
• Execution of Selenium test cases and reporting defects 
• Good understanding in different Frameworks (Data driven, BPT, Keyword)
• To ensure that data created, maintained and reported by the application is accurate
• Preparation of weekly and monthly status reports

Confidential , IN 

Software Engineer

Environment: .Net, My SQL, Windows 2003, SQL Server, Mercury Quality Centre, db2, Oracle

• Development and implementation of Test Plans both for functional and Automation Testing
• Preparing a detailed Test Specification and test scripts
• Queried database with SQL to obtain data for billing information
• Maintaining the functional tests and execution results in Quality Center 10
• Amending the test cases to be in sync with the functional requirements, posting both application and test case issues in bug tracking tool.
• Preparation of Test Summary Report

Confidential

ETL Tester

Environment: Oracle 10gSQL, PL/SQL, UNIX, Putty, Teradata V2R6, Flat files, Mainframes, Java, HP Quality Center, SQL Server 2008, SSIS

• Preparation of test plan, test scenarios and test cases for DWH and ETL testing
• Execution of SQL scripts using SQL queries to validate data
• Responsible for testing daily load jobs of ETL jobs
• Executed automated test scripts for Regression testing
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs
• Perform ambiguity reviews on requirements and design documents
• Analyzed and tested Mappings with OLTP source data, staging and target data
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts. Performed complex data validation using SQL queries
• Tested the ETL mappings and other ETL Processes
• Involved in testing PL/SQL programs, PL/SQL batch processes, UNIX Shell Scripts
• Analyzing the application and authoring test cases to meet all the requirements based on the Technical and Design Documents
• Participated in requirements review and test case review meetings
• Conducted Database Integrity testing by executing SQL statements