SUMMARY

• Over 9+ years in Quality Assurance & Software Testing of various domains
• Proven ability to lead projects with testing team based both on onshore and offshore
• Strong understanding of QA principles, QA Process and SDLC - Agile & Waterfall
• 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
• Experience in preparing Test Plans, Authoring Test Cases based on customer Requirements and Test Summary Reports and Bug Reports
• Experience in ETL/ Data warehouse backend testing and BI reports testing(Business Objects and Crystal Reports)
• Experience in preparing Use-cases, and writing UAT plans and UAT test cases
• Experience working in Test Automation using UFT and Selenium basic scripting and maintaining the scripts
• 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
• Experience in performance testing using Fiddler
• Experience in load testing using WAPT
• Proficient in conducting Product Requirement meetings with the stakeholders on Development and Testability
• Arrange and conduct project kickoff, code review, defect triage, sprint planning, retrospective meetings

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

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

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

ETL Tool: Datastage 8.0/7.0

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

Protocols: HTTP, TCP/IP, SMTP, FTP

Scripting Languages: JavaScript, VBScript, Shell

Automation: Selenium (IDE, RC, WebDriver, Grid), QTP10, Win Runner8.2

Test Management Tool: Test Director, QC, ALM

Reporting Tools: SSRS 2005/2008, OBIEE 10.0.3

Web Services: SOAP UI, POSTMAN

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. QA Analyst/Lead

Environment: JAVA, HTML, JavaScript, SQL, Selenium Webdriver, GIT, SpringBoot, Jenkins, Cucumber, Maven, Junit, Jira, Fiddler, URS, SSRS, tableau, Postman

Responsibilities:

• Work directly with Client and Business Analyst to determine Business Requirements, Functional Requirements, Detailed Design Documents
• Responsible for generating the Test Strategy, Detailed Test Plans and Test Cases
• Improve quality assurance to increase throughput, improve quality and continuously improve our testing process
• Coordinate with product managers, project managers, technical managers and Operations
• Delegating test execution task to test team, monitor progress, posting application issues
• Create, maintain and debug Selenium scripts
• Responsible for maintaining automation frameworks
• Responsible for day to day commits and Jenkins failure fix’s
• Review and modify the already existing test cases in ALM
• Validated API services using POSTMAN
• Conducted defect triage meetings with development and BA for fixes and validate back
• Performing and supervise load test
• Performing and supervise Performance testing
• Performed back end testing using SQL and Oracle
• Escalate project exceptions to the Project Manager
• Maintaining the team in terms of status reporting, resource management and reporting
• Provided training for other team members
• Monitoring test progress throughout the project release cycle, providing test results and detailed status reports
• 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

Sr. Test Analyst/QA Lead

Environment: VB.Net, ASP.Net, C#, Java, Objective-C, HTML, JavaScript, QTP, Corema, DataPower, Json, SQL, Java, DB2, HP Quality Center 10.0, QTP 10.0, Oracle 10g, Teradata V2R6, PL/SQL, XML, UNIX, Cassandra

Responsibilities:

• 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 Andriod
• 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
• Execution of Test Cases on different devices and platforms including IOS and Android
• Providing estimates to senior managers
• Involved in end­to­end testing of the Web, Mobile Applications
• Conducted defect triage meetings with development and BA for fixes and validate back
• Escalate project exceptions to the Project Manager
• Maintaining the team in terms of status reporting, resource management and reporting
• Conducted Database Integrity testing by running SQL statements
• 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

Test Analyst

Environment: .Net, Oracle 10g, SQL, PL/SQL, UNIX, Putty, Teradata, Flat files, Mainframes, Java, HP QC, Firebug

Responsibilities:

• 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
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs
• 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 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
• Conducted Database Integrity testing by executing SQL statements

Confidential

Software Engineer

Environment: .Net, My SQL, Windows 2003

Responsibilities:

• Preparation of Test Cases
• Responsible for testing daily load jobs of ETL jobs
• Performed data validation using SQL queries
• Generate and modification of JCL’s in QA for batch execution and analysis of the same
• Review and modify the test cases in QC
• Execution of Test Cases and Posting defects
• Pass defect log to development for fixes and validate back
• To ensure that data created, maintained and reported by the application is accurate.
• Used Quality Center 7.6/8.0 for Test Plan, Test Run and Defect Reporting/Tracking.
• Assist the QA management in making solid "go/no-go" decisions for the launch of each application