SUMMARY:

• 5 years of experience as Software Test engineer and Data Analyst in testing Web and Mobile applications using Manual and Automation testing procedures.
• Designing Test cases and Test plans by analyzing requirements from functional specification and technical design documentation.
• Backend Testing. Wrote complex T - SQL/SQL Queries using SQL Server Management studio.
• Manipulate large amount of test data in complex database environment.
• Functional, Regression, UI, system and Integration, White box and Black box Testing in QAT and UAT environment.
• With Agile (Scrum) and waterfall methodologies
• Strong knowledge of T-SQL programming and complex joins.
• Extensively used Bug management system of TFS, Jira, Clear Quest and HP QC (like WTT).
• Extensively involved in all phases of SDLC and Defect life cycle.

TECHNICAL SKILLS:

Testing Tools: MS SQL Server 2012/2008, HP Quality Center (like WTT), Team Foundation Server (TFS), Jira, ClearQuest, VSTS, IBM Tealeaf

Databases: MS-SQL Server 2012/2008/2005, Teradata SQL Assistant 12.0, Oracle, IBM DB2

Languages: SQL, T-SQL, XML, HTML

Database Tools: SQL Server Management Studio (SSMS), Query Analyzer, SQL Developer, SSIS

Mobile Platforms: iOS, Android, Windows Phone 7, Blackberry OS

PROFESSIONAL EXPERIENCE:

Test Data Analyst

Confidential

Environment: IBM Tealeaf, HP Quality Center (QC), SQL Server 2008/2012, SSIS, XML, HTML, Telegence Billing System.

• Collect and analyze data from different technology systems and map the data of source and target systems.
• Troubleshoot data issues and collaborate with internal staff to identify and correct issues to ensure the validity and efficacy of data.
• Testing data consistency in the ETL process and verify the final reports against legacy systems in QAT environment.
• Verification of wireless Billing data against the Telegence Billing system.
• Conducting root cause analysis if/when data discrepancies arise.
• Working closely with the other business teams to investigate potential data issues raised by partner teams.
• Communicate results of investigations to business, development, operations, or support groups.
• File defects or change requests, as needed.

UAT Commissions Test Analyst

Confidential

Environment: MS SQL Server 2008, HP Quality Center, Oracle, ICommAdmin, ReconDetail Tool, Samson Telecom Billing System

• Analyzing business requirements, designing specifications and developing test cases and test scripts for testing RPS channel in Commissions team.
• Writing T- SQL scripts using SQL Server Management Studio in SQL Server 2008.
• Performing functional and Integration testing using HP-Quality Center.
• Logging, tracking, and verifying resolution of software and specification defects using HP-Quality Center that would impact the payouts of sales representatives.
• Representing the UAT team in daily status meeting.
• Participating in Code / Test review meeting with developers / Business Analyst.
• Writing complex SQL scripts to validate the compensation payout to dealers.
• Writing test mitigation plans if the testing is not completed within the testing milestone.

UAT Test Analyst

Confidential

Environment: MS SQL Server 2008, Quality Center, Oracle, Samson Telecom Billing System

• Analyzing business requirements, designing specifications and developing test cases and test scripts for testing RPS channel in Commissions team.
• Writing T- SQL scripts using SQL Server Management Studio in SQL Server 2008.
• Performing functional and Integration testing using HP-Quality Center.
• Logging, tracking, and verifying resolution of software and specification defects using HP-Quality Center that would impact the payouts of sales representatives.

Software Test Engineer

Confidential

Environment: QTP 10.00, HP Quality Center (QC), UNIX, IBM DB2, Oracle, SQL Developer, Teradata SQL Assistant 12.0, SoapUI 3.0.1, Jira, Telegence Billing System

• Own procurement of billing data from different legacy backend systems and various databases as requested by the test teams.
• Creating and validating test data in the Telegence Billing system for QAT and UAT functional testing.
• Writing SQL scripts and stored procedures for backend data validation.
• Troubleshooting, logging, and regressing defects across UI, Middle Tier, and the database layer.
• Performing end to end data validation by querying databases, mainframe systems and middle tier services; capturing logs and analyzing their contents for troubleshooting.

Test Design Engineer

Confidential

Environment: Quality Center (Test Management), Clear Quest (Defect Management), Oracle, iOS, Android, WP7, Blackberry OS, Jira, SoapUI 3.0.1, SQL Developer, XML, HTML

• Developing test plan after analyzing business requirements, design specification and technical design documents. Participating in test plan reviews.
• Writing test scripts for execution by testers.
• Generating Data requests based on test scenarios followed by coordinating with offshore data team to generate and manipulate data.
• Performing functional, regression and End-to-End testing; analyzing the server logs for correctness of transactions.
• Writing SQL query templates for the Telegence Billing system data validation to be used by test execution team.
• Representing DSS team in bug triage meetings and defect war rooms.
• Coordinating with external teams to resolve any blocking issues.
• Generating daily status reports and sending it to higher management.
• Conducting training sessions to onboard new team members.