SUMMARY

• Around 7 years of industry experience including Software Quality Assurance and software testing including SQL/SSRS/SSIS developer.
• Expertise in T - SQL (DDL, DML), ETL, Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Strong understanding/Hands-on experience of Software development Life Cycle (SDLC), Testing Life cycle, Bug Life cycle.
• Worked on different domains like E-commerce, Health Care, Insurance, Banking etc
• Extensively involved in creation of Test Plan, Test Cases, Test Scripts and project related documentation.
• Expertise in Black Box Testing, Functional testing, Integration testing, Regression testing, System testing and Multiplatform testing.
• Extensively worked on Web-based and Client-Server application on different environments like Java, .Net, and PHP.
• Worked on Banking, finance, and Insurance applications and domain.
• Strong experience in manual testing and automated testing using Mercury Interactive Suite (Quick Test Pro, Quality Center).
• Development of automated Test Scripts using VB scripting, java scripting languages.
• Experienced with MS Project and MS Office Tools like MS Word, MS Excel, and MS Access.
• Experience in Robust Defect tracking and Reporting using tools like Quality Center.
• Good experience in using SQL and PL/SQL for database querying and data manipulation.
• Self-starter, team player, proactive and extremely detail-oriented with a proven capability of working under high pressure.
• Strong analytical, communication and trouble shooting skills coupled with strong academic background.
• Good team player with excellent written, communication & interpersonal skills.

TECHNICAL SKILLS

Automated Test Tools: Quick Test Pro (QTP), exposure in selenium, Load Runner

Documentation Tools: MS Word 2000, MS Excel 2000 and FrontPage 98/2000.

Bug Tracking/management Tools: HP-ALM, Quality Center, BugZilla., Jira

Other Tools/Application: Siebel 7, Black Box Testing, White Box Testing

Operating Systems: Windows XP, 2000, 95/98.

Languages/Application: SQL, PL/SQL, JSON, C, Java, XML, XSD, JBoss.

Databases: MS SQL Server, MS Access, SSIS/SSRS/SSAS, T-SQL.

Scripting: VB Script, Java scripting

PROFESSIONAL EXPERIENCE

Confidential, OR

Sr. QA Analyst

Responsibilities:

• Led the junior testers, gave training, provided functional documents, and got daily follow-up
• Participated in Requirement Analysis, Business Analysis and Use-Case Analysis.
• Involved in technical writing of high level automation Test Plans, Test Cases, Test Scripts, and Test Scenarios in Selenium.
• Participated in Black Box Testing and Integration Testing in White Box testing approach.
• Mapped requirements to functional design elements.
• Analyze automated test plans and create test cases for selenium Tool as per new / existing requirements.
• Mapped functional design elements to rule sets and tests for test case creation.
• Made recommendations to management regarding the acquisition and/or implementation of software to increase information systems efficiency.
• Monitored post-implementation system/program performance to prevent reoccurrence of operational issues and ensure efficiency of operation.
• Prepared the test cases and test scenarios detailed in Microsoft Excel.
• Transformation of use cases to test scenarios and designing test plans and test cases.
• Involvement in efficient and optimum test planning with the available resources.
• Interaction with the business frequently gave good insight to do extensive testing.
• Oversaw test execution to ensure proper operation of system/program.
• Reviewed complex test results and the progress of problem resolution and reports progress to management.
• Using SQL Server database extensively to validate the back end data.

Environment: Selenium, Microsoft Excel, e-commerce, Java, XML, SQL Server, .net, html, php, oracle

Confidential, Houston, TX

Sr. QA analyst

Responsibilities:

• Did Requirement Analysis, Business Analysis and Use-Case Analysis, and provided to juniors.
• Analyzed and created Traceability Matrix mapping Test Scripts against Business Requirements.
• Led the UAT associates, system testers, and automation QA analyst.
• Conducted UAT sessions with business users along with business analyst.
• Conducted Smoke, Navigational testing in the production environment after Production release.
• Performed technical writing of high level automation Test Plans, Test Cases, Test Scripts, and Test Scenarios in QTP.
• Analyze automated test plans and create test cases for QTP Tool as per new / existing requirements.
• Well known about Descriptive programming in QTP.
• Developed Test Case Procedures and conducted the tests manually.
• Performed automation testing for the application with the complete coverage.
• Performed the database Validation using SQL Queries in order to validate the data
• Conducted and participated walk-through and reviews for test cases and test plans.
• Conducted Functional testing, GUI testing and Regression testing during various phases of the application development.
• Maintained and updated Requirement Traceability Matrix and test data for every project release.
• Reviewed complex test results and the progress of problem resolution and reports progress to management.
• Prepared and presented testing status in HP-ALM, and report to team lead, Project Manager etc.
• Used Bug Tracker for tracking bugs, to report the deviations found. Also interacted with developers to resolve and re-test the deviations.
• Wrote SQL queries to check data populated into tables correctly or not.
• Identified several defects and logged them using Quality Center.
• Oversaw test execution to ensure proper operation of system/program.
• Reviewed complex test results and the progress of problem resolution and reports progress to management.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution.

Environment: Quick Test Pro, Quality Center 9, JSON, HP-ALM, E-commerce, JAVA, PHP, SQL SERVER, Microsoft Excel and Access, Windows 2000/XP.

Confidential, Moscow, WA

Sr. QA Analyst

Responsibilities:

• Created SQL Queries to Extract, Insert, and Delete data from Database including Inner and Outer Joins.
• Involved in technical writing of high level automation Test Plans, Test Cases, Test Scripts, and Test Scenarios.
• Analyze automated test plans and create test cases as per new / existing requirements.
• Interacted with the requirement team of ETL/ data warehousing and analyze the documents to do ETL testing by using SSIS and excel package.
• Do testing of number of rows, columns, formats, data type etc means check the transformation is as per as requirement or not.
• Checked all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Prepare test cases for ETL testing and execute them. After execution do reporting of defects.
• Analyze automated test plans and create test cases as per new / existing requirements.
• Analyze test cases with the development and business analysis teams.
• Maintain test logs and track defects using Team Foundation server with PM.
• As per system needs, validate our Internal Audit application in offline mode using silver light.
• Executing the test scripts for System, Functional and Regression using checkpoints, parameters, data driven and logical loops.
• Analyzing the test results and reporting defects using Quality Center.
• Performed back end testing using SQL to verify the integrity of the data.
• Supports the customer service team with customer queries.
• Drive cross functional reviews for the test cases - new feature / upgrading existing feature.

Environment: Quality Center, PM, SQL Server 2008, ETL, JSON, SSIS, Data Warehousing, C#, VB Scripts, Team Foundation Server (TFS), Seibel 7, Silver Light, MS-Excel.

Confidential, Basking Ridge, NJ

QA Analyst

Responsibilities:

• Analyzed functional requirements, wrote Test plans
• Wrote test procedures for the front-end GUI standards.
• Interacted with BA's and developers in gathering the specs. Written queries for verifying the data.
• Involved in writing and implementing numerous Test Cases and Test Scripts.
• Developed Test Cases and Test Design using Test Plan Manager
• Export Test Requirements and Test Cases from Excel in to load Runner and QTP as per requirement.
• Worked on oracle 9i to manage the database.
• Performed Manual Testing, Functional and User acceptance testing.
• Reported the defects to developers using the defect-tracking tool Bugzilla.
• Reviewed complex test results and the progress of problem resolution and reports to the management.
• Worked for load, stress, and volume testing with the help of load runner.
• Provided feedback and risk assessment throughout the SDLC
• Generated Requirements, Test Sets, and Test Plan and for reporting defects.
• Interacted with Business teams and Developers to understand business requirements and bug fixes.
• Spearheaded implementation of Mercury test suite and assisted with coordination of new test lab equipment and setup
• Created complex SQL queries to test the Backend functionality of the application.

Environment: Oracle 9i, Java, VB Script, Siebel, and HTML, MS SQL Server. Windows XP, UNIX, Bugzilla, manual testing, load runner

Confidential, Portland, OR

SQL/SSIS/SSRS Developer

Responsibilities:

• Actively participated in gathering business requirements and system specifications.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by business analysts and UI team.
• Modified current database by adding tables & relationships required to support the system.
• Responsible for marinating and enhancing Agency Management System.
• Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.
• Worked on Siebel software to maintain stakeholder’s data.
• Increased Stored Procedures performance using SQL Server Traces, Index Tuning Wizards and Executions plans.
• Planning and scheduling jobs for backup strategy to ensure reliable backup.
• Created SSIS Packages by using the tools (i.e. Send Mail task, Execute SQL Tasks, Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Designed SSIS packages to migrate the data from different sources.
• Developed different types of reports such as ad-hoc reports, matrix reports, tabular reports using report wizard in SSRS.
• Created Indexed Views to optimize queries and Triggers on Views to populate base tables.
• Created test scripts for system integration and UAT testing.

Environment: MS SQL Server 2008R2, Siebel, MS Excel 2007/2003, SQL Server Business Intelligent Development Studio (SSIS/SSRS), Team Foundation Server.

Confidential, New York, NY

Jr. QA Analyst

Responsibilities:

• Analyzed business requirements documents to get a better understanding of the system from both technical and business perspectives.
• Studied existing application functionality and new business requirements.
• Setup test environment and test data for both positive and negative testing.
• Testing application to accommodate sufficient time for developers to resolve the issues.
• Transformation of use cases to test scenarios and designing test plans and test cases.
• Performed Smoke, Black Box, Validation and Compatibility testing of the application manually.
• Performed Regression, UAT, Integration, User Interface, GUI, and Usability Testing.
• Reviewed and analyzed artifacts throughout the SDLC.
• Reviewed user documentation for accuracy of implemented functionality descriptions
• Extensively worked for the development of test standards for script development, deployment and reuse.
• Involvement in efficient and optimum test planning with the available resources.
• Interaction with the developers for resolving critical bugs and functionality modifications.
• Using SQL Server database extensively to validate the back end data.
• Participate in weekly status meetings and coordinated with the Developers and Testers to resolve and close defects.
• Actively participated in all phases of testing life cycle including document reviews, and project status meetings.

Environment: Java, SQL Server, Microsoft Excel, Windows 2000/XP, Bugzilla, manual testing, html