SUMMARY

• 11 years of experience in all phases of product life cycle including business analysis, system analysis, design, development and implementation of business applications and Government Applications.
• 5+ years of strong MS SQL Server Developer experience in Finance, Banking, Telecommunications, and Insurance domains with expertise in MS SQL Server 2008/2005/2000 suite of product like SSRS.
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
• Extensive experience in teh development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Excellent knowledge in Software Development Life Cycle, Software Testing Life Cycle and Defect Life Cycle.
• Experienced in implementing ALM/Quality Center for test planning, test case development, test case execution and test results analysis.
• Experienced in preparing Traceability Matrix using ALM/Quality Center to test cases to teh requirements and defects.
• Used Quality Center for error reporting and communicating between developers, product support and test team members. Created Reports in Quality Center for metrics reporting.
• Used agile methodology to ensure teh new features meet teh customer requirements and acceptable quality assurance standards.
• Expertise in develop, maintain, and implement integration/system test strategy, test plans, test processes, test scenarios, and test scripts.
• Collaborate with developers, business analysts, and Project manager in application design and document reviews and teh project plan.
• Involved in developing Test Scenarios, Test Plans, writing Test Cases, and analyzing test results and reporting teh defects.
• Experienced in various test strategies like System Testing, End to End Testing, Functional Testing, and Negative, positive testing, Integration Testing, Regression Testing, User Acceptance Testing, and Smoke/Sanity Testing.
• Expert in designing complex reports like reports using Cascading parameters, Drill - Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Proficient in Database performance optimization, debugging and tuning using teh Query Analyzer, SQL Profiler and SQL Server Debugger.
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Hands on experience in web designing using HTML, CSS and JavaScript to display reports on teh server.
• Expertise in Enhancements and Evaluation of Banking, Insurance and Financial Applications.
• Solid Experience in SQL, PL/SQL, writing Complex SQL & Testing scripts for Backend Testing.
• Expertise in Implementing teh Testing Life cycle with V & V (Verification and Validation) model.
• Expertise and in-depth knowledge Data Base testing on different types of testing to validate and verify teh data accuracy.
• Ability to learn new technologies and challenging concepts quickly and implement them.
• Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.
• Experienced in complete testing life cycle which includes analysis, implementation, testing, and regression testing of a software application.
• Ability to work productively and effectively in a team as well as individually.

TECHNICAL SKILLS

Automated Testing Tools: Win Runner 7.2/7.5/7.6, Silk 7.1, QTP 8.2 and Load Runner 7.8/7.6

Test Management Tools: Bugzilla 2.18, Test Director 8.2/7.6, HP ALM/QC

Languages: T-SQL, PL/SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET

Reporting Tools: SSRS, Business Intelligence Tools

Application Software: MS-Excel, MS-Word, MS-PowerPoint and MS Outlook

RDBMS/DBMS: MS SQL Server 2008 R2, 2005, 2000, Microsoft SQL Server Management Studio, Business Intelligence Design Studio, DB2 MS-Access

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista, Windows 2000Advanced Server

PROFESSIONAL EXPERIENCE

Confidential, AR

Quality Analyst

Responsibilities:

• Responsible for creating reports based on teh requirements using SSRS 2008.
• Identified teh database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined teh report layout and identified Datasets for teh report generation.
• Successfully created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on teh financial data.
• Scheduled teh monthly/weekly/daily reports to run automatically.
• Successfully Developed and implemented procedures to ensure teh quality, usability and accuracy of reports.
• Implemented teh Agile methodology for production. Releases on every second week in a month.
• Designed and developed Tests Scripts for Manual Testing of all teh modules.
• Documented Test cases corresponding to business rules and other operating conditions.
• Used agile methodology to ensure teh new features meet teh customer requirements and acceptable quality assurance standards.
• Prepared test procedures and test strategies such as examining application, testing environment and testing resources to test teh application in a given timeline.
• Assisted QA team with manual testing for payment applications.
• Hosted daily defect review meeting and assigned work among testers equally.
• Deeply studied teh business requirements and then created appropriate and in depth test plan and test cases in HP ALM/ Quality Center.
• Validated Test Scripts, Logged defects in Defects module of ALM/Quality Center.
• Re-validated teh Resolved bugs in UAT and Production Environments.
• Supported Production for teh new Releases.
• Generated Weekly Reports, Defect Reports and Customized Summary Reports.
• Worked as a team with other QA testers to ensure dat all projects are executed accurately and completely and assisted other testers with account selection, clarification of ambiguity with test results and general questions dat arise.
• Executed teh transactions manually and verify teh back end functionalities and data exploitation.

Environment: Bugzilla2.14, HP Quality Center, Agile, MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, Agile methodology, MS Excel, T-SQL

Confidential, Dallas, TX

Sr. Quality Engineer

Responsibilities:

• Created SQL Server Reports using SSRS 2005.
• Successfully Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Identified teh data source and defined them to build teh data source views.
• Involved in Debugging reports and deploying reports.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Scheduled teh reports to run automatically.
• Launched teh report builder for adhoc reports.
• Configured teh report viewing security.
• Created schedules and subscriptions.
• Prepared Test Plans according to System specifications and strategy.
• Writing Test Cases corresponding to business rules and other operating conditions.
• Prepared and implemented Risk analysis plan, metric plan and traceability metrics for different types of testing.
• Worked with rapid deployment cycles and changes in testing patterns and involved in full STLC.
• Participated in stand-up sessions, analyzed teh defects and actively coordinated with developers to recreate teh errors when needed.
• Prepared Test Cases corresponding to business rules and other operating conditions.
• Tested teh application compatibility for different operating systems.
• Extensively used Quality Center for test plan and defect tracking and escalated with developers when needed.
• Maintained all project timelines and status report.
• Identified, Classified, Reviewed and Resolved Defects in consultation with Developers and other Team Members.
• Responsible for Verification of teh documents, plans, requirements and specifications.
• Performed Manual Testing for all teh Projects.
• Performed Boundary testing and Validation testing.
• Involved in Regression Testing and System Testing for various projects.
• Tested teh application compatibility for different operating systems.
• Worked as team lead for execution of teh cases and to verify for teh successful transaction and report teh defects and follow up with Development Team.

Environment: Bugzilla 2.14, Quality Center, Microsoft SQL Server 2000/2005 Enterprise Edition, SQL Server Reporting Services(SSRS), Management studio, Crystal Report, Windows XP, Ms excel 2003, Microsoft Visual Studio 2005.

Confidential, New York

Quality Engineer

Responsibilities:

• Followed V & V (Verification and Validation) model in testing life cycle to prepare test strategy.
• Prepared and implemented Risk analysis plan, metric plan and traceability metrics for different types of testing.
• Prepared Test Plans according to Compliant and testing strategy.
• Prepared and implemented Risk analysis plan, metric plan and traceability metrics for different types of testing.
• Prepared and implemented test case methods Boundary analysis, Equal partition, positive, negative and validation while designing test cases
• Prepared Test Cases corresponding to business rules and other operating conditions.
• Documented Test Cases in Test Director.
• Involved in Reviewing teh Test Cases in internal and external reviews, extensively used Team Track as a Defect Tracking Tool.
• Responsible for Verification of teh documents, plans, requirements and specifications.
• Performed Black Box, White box testing, Integration testing, System testing, Security testing, Regression testing, Performance testing, Globalization testing and User Acceptance testing.
• Tested teh application compatibility for different operating systems.
• Maintained all project timelines and status report.
• Identified, Classified, Reviewed and Resolved Defects in consultation with Developers and other Team Members.
• Meeting with teh Business Leads in finding teh data for testing, data preparation, Test script and test creation based on teh requirement and Design Document.
• Coordinated with offshore and on site teams in testing lifecycle.
• Testing teh core release projects and delivering teh same on time.
• Identified and assigned roles and responsibilities for team members in testing life cycle.

Environment: Bugzilla2.14,QTP, Test Director, Java 1.x, HTML, JavaScript, XML, JSP, Struts, Tiles, Servlets, Web Sphere, JDBC, SQL, PL/SQL, Oracle8i, Windows NT/2000, UML

Confidential, Stamford, CT

Quality Engineer

Responsibilities:

• Analysis and testing Requirements of teh conversion.
• Created various scenarios and cases to verify and compare results between two systems.
• Review of teh test cases written for Functional Testing & Regression Testing.
• Effective coordination with teh development team to resolve teh reported defects and to reduce delay.
• Errors found in teh system were acknowledged to teh test and development team through E-mail.
• Involved as a Team member in end to end testing of teh every transaction.
• Involved in Adhoc Testing.
• Extensively used Bugzilla as a Defect Tracking Tool.
• Report defects and discuss details with Team Lead
• Involved to analyze teh flow of data and validating whether teh correct data got populated in respective fields
• Use SQL Queries to make sure
• Tested backend database using SQL Queries.

Environment: Bugzilla2.14, Test Director, Java 1.x, HTML, JavaScript, XML, JSP, Struts, Tiles, Servlets, Web Sphere, JDBC, SQL, PL/SQL, Oracle8i, Windows NT/2000, UML.