SUMMARY

• Experience in QA testing with Database Administration and Development for very large and complex databases on SQL Server 2008/2005 and Oracle 10G.
• Excellent knowledge of QA testing with complete knowledge of SDLC.
• Expertise in Database Administration on Production Servers with server configuration performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensive experience in testing, maintaining and implementation of Disaster Recovery sites (DR) and High availabilities (HA) solutions for production databases.
• Experience in Query Optimization, analyzing the execution plan and index management for better Query performance.
• Proactively maintaining activities like monitoring of database space allocations, transaction log space allocations, monitoring memory, CPU utilization, disk utilization, locks, and runtime of queries.
• Extensive experience in planning and implementation of Backups and restoration strategies.
• Strong experience in ETL Application using SSIS with various source like flat files, excel, Oracle.
• Extensive knowledge of Designing, Developing, Atomization and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Good interpersonal skills, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Have worked with Automation Framework (of QTP) like Keyword Driven and Modular Driver Framework and implemented the right one for testing needs.
• Experienced in Test management and defect tracking tools like Quality center, Bugzilla.
• Expertise in converting Use cases to Test Cases.
• Proficient in Front end (Functional & GUI Testing), Black Box Testing, System and Integration Testing, Regression Testing, and User Acceptance Testing (UAT)
• Experience in writing SQL Queries for back - end Testing
• Expertise in Traceability Matrix preparation and Defect Prevention Analysis activities.
• Worked closely with development team, support team and customers. Coordinating with the onsite team and updating the status.
• Extensive data validation in batch files, reports and databases; used SQL to query database extensively for data validation; expert in SQL for sub-queries, nested queries and for complex data enquiries
• Very Strong on tools such as Erwin Data Modeler used for logical and physical data modeling and have full understanding of the Software Development Life Cycle (SDLC)
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.

TECHNICAL SKILLS

RDBMS Tools: Oracle 8i, SQL Server 2005/2008, MYSQL/MS SQL, Excel, Oracle 10G.

SQL Server: Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Client Configuration Utility, Integration Service (SSIS).

Testing tools: Quick Test Pro, Bugzilla, Win Runner, Load Runner, Selenium, Test Director/ Quality Center

Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

Mythologies: Waterfall, Agile, RUP, Scrum, RAD, UML.

Languages/Scripts: C++, SQL, Shell Script, SDLC

Tools: Set Oracle Enterprise Monitor, SQL Server Profiler

Operating Systems: Windows Server 2000, 2003, Solaris 9, Ubuntu Linux

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Support Analyst

Responsibilities:

• SQL Server Administrator for 360 View a tracking software for freight. Primarily responsible for upgrade and migration to the new server.
• Test Analyst for 360 View tracking software for freight management. Primary testing conduction directly on the MS SQL Server 2008r2 database.
• Regression tested QA environment first with front end and then with the DB backend.
• Responsible for data-set up used for QA testing. Used DML to expedite the process.
• Conducted failover testing to test cluster configuration
• Suggested /tested improvements: indexing/table structure, query code, hardware, database server configuration, etc. during performance certification phase.
• Created test packages using SSIS for batch testing.
• Defect tracking and reporting was done via Bugzilla.
• Suggested enhancements and feature from user experience point of view.
• Performed Data driven testing using multiple test data inputs with QTP and spreadsheets.
• Used Test Director to track and manage bug life cycle.
• Conducted various management activities by analyzing and verifying test results, providing status reports.
• Automated superficial regression testing with Selenium IDE.
• Responsible to oversee day-to-day activities, provide support, and facilitate problem resolution for a team of Software Quality Assurance Engineers.
• Assisted Business team with planning, coordinate and execution of User Acceptance Testing.

Confidential, Arlington, VA

Backend Testing Engineer

Responsibilities:

• Summarize requirements and use-cases for customer facing sales website .
• UAT testing for users demand.
• Testing plan with help of SDLC
• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Created an implementation document for the step by step migration of data and schema to the new instance.
• Set up Failover and SQL Mirroring on the new servers
• Suggested /tested improvements: indexing/table structure, query code, hardware, database server configuration, etc.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, and indexing updates.
• Regression tested and implemented first in Dev and QA environment.
• Provided 24 X 7 dedicated support for all Production, QA & Development MS SQL Server systems.
• Writing scalable, efficient queries using the most applicable database features.
• Manage and maintain datasets with efficient use of SQL.
• Tested client connectivity first from SQL management console.
• Creating defects, assigning owners, re-validating and closing.
• Participating in disaster recovery and failover testing.
• Working with customer to provide feedback to submit enhancement requests.

Confidential, Motlake Terrace WA

QA Tester

Responsibilities:

• Involved in Defining, and Analyzing the Test Requirements based on the Application Functionality.
• Involved in gathering business requirements, understanding the application, collecting the information from developers and writing the test plan.
• Test the web pages manually as well as using automated tools like Selenium for image positioning and display quality.
• Performed Manual and Automation testing. Verified and Validated the Automated Test scripts.
• Exported Test Requirements and Test Cases from Excel and Word to Quality Center.
• Performed Sanity testing, System testing, Functional testing, Integration testing, Web testing, and GUI testing.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting defects.
• Worked in FIX Orders, FIX Options, Messaging formats (Administrative, Application) Support, Change Management and IT Operations against Client/sever.
• Created test scenarios for System testing and Regression testing.
• Conducted Functionality testing during various phases of the application using QTP.
• Performed Data Driven testing, Inserted check points to check properties of an object using QTP.
• Developed and maintained automated test scripts using QTP to support regression testing.
• Conducted User Acceptance Test (UAT) with users and customers and wrote issues log based on outcome of UAT.
• By using Execution Grid, run all manual and automated test cases in Quality Center.
• Conducted End to End and Black box testing.
• Involved in executing SQL queries for back-end testing.
• Logged the defects in QC and retested the application after the defects are fixed.
• Tested Web page presentation manually for different browser compatibility.
• Helped Lead to create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs.
• Attended meetings to discuss on status of defects and projects.
• Advanced understanding of Perl OO concepts.
• Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.
• Executed test cases before and after bug fixes for each build for User acceptance testing.
• Interacted with Developers and QA groups at various phases of project development.

Confidential

Backend analyst

Responsibilities:

• UAT testing for SABRE airline ticketing software.
• Performance tuned queries optimization for long run query and using more CPU
• Took part in design review sessions.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL for new tables and for updating the existing ones.
• Reviewed SQL server performance report during all testing cycles.
• Worked on Replication, Log Shipping and Database Mirroring.
• Set up and used SQL Profiler to monitor query performance to the migrated database.