PROFESSIONAL SUMMARY:

• Over 6 years of experience in the IT Industry as Software QA engineer, with particular focus and expertise in MS SQL (incl., SQL Server 2005/2008; SSIS; SSRS; SSAS).
• Having over 6 years of experience as Software QA engineer, writing and executing test plans and test cases in highly structured and loosely structured development environments and performing functional, user acceptance, browser compatibility types of testing.
• Extensively involved in Build Acceptance Testing, Functional Testing and Database Testing using SQL SERVER 2005/2008 and Cross - Browser testing using Safari, IE and Google Chrome.
• Experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Experience in enhancing and deploying the SSIS Packages from development server to production server, creating SSIS packages.
• Excellent knowledge in creating and executing complex Stored Procedures, Queries, Functions, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in SQL Tuning and Optimization using MS SQL Profiler, Index Tuning Wizard and SQL Query
• Has Working Knowledge of Automation Tools like Selenium IDE and QTP .
• Expertise in System, Functional, Regression, Integration, GUI, Usability, Performance, Load, Stress, Positive, Negative, Data Driven Testing and UAT.
• Skilled in analyzing business context and requirements for UAT testing purposes.
• Familiar with Test Strategy, Test Plan and Traceability Matrices Documents.
• Experience with the full software development and testing life cycles with exposure to both Waterfall and Agile methodologies (Scrum).
• Back end Testing ( ORACLE & SQL SERVER 2005/2008).
• Strong knowledge in MS SQL Server 2008.
• Experience in Mercury’s Test Director and Quality Center for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.
• Knowledge of programming languages like C, C++, Java, JSP , Cold Fusion and modeling languages like HTML .

AREA OF EXPERIENCE:

• Testing Strategies MS SQL
• Quality control analysis Java/J2EE
• On-time delivery Cold Fusion
• Test Estimation HTML, Java Script

TECHNICAL SKILLS:

Development Tools: Eclipse, VSS, TOAD, SQL Server Management Studio, TOAD, MS Office.

Web Technologies: J2EE, Servlets, Jsp, Struts, Cold Fusion, HTML, JavaScript.

Programming Languages: C, C++, Java/J2EE, Cold Fusion.

Web Server and Application Servers: Apache Tomcat 5.1, Jboss, Web Logic.

Testing Tool: Selenium IDE, QTP, HP Mercury Quality center, Test Director, Test Manager.

Operating Systems: MS Windows 95/NT/2000/XP, Windows 7

Databases: Oracle 11i, SQL 2005/2008.

WORK EXPERIENCE:

Test Engineer

Confidential, Chicago

Responsibilities:

• Reviewed Business requirements, IT Design documents and prepared Test Plans for all assigned project releases.
• Designed SSIS packages for extracting the data from multiple data source and load into the appropriate tables in the database.
• Created SSIS package by using various tasks and tested in DEV, QA, and PROD environment.
• Tested SSRS reports with various parameters.
• Worked on SQL scripts to load data in the tables.
• Worked with the Business Analysts & Developers to resolve the defect issues.
• Managed and conducted System testing, Integration testing and Functional testing.
• Manage multiple projects/priorities that require specific expertise or domain knowledge with limited supervision.
• Responsible for drafting complex SQL queries and perform allocation testing from front end / user interface.
• Involved in Test Execution and Defect Reporting using Quality Control.
• Provides regular status reports to the Project Manager.
• Providing the Test Plan and identifying test strategies including entry and exit criteria.
• Ensured that all test tasks follow QA methodology and that deliverables meet applicable Client standards.
• Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.
• Responsible for providing test estimates and identifying the scope of impact.
• Involved in Release support - Release to QA, involved in environment setup, testing the release process.
• Involved in Backend Database testing using SQL.
• Using SQL for checking the output of various reports.

Environment: ColdFusion, SQL SERVER 2008, SSRS, SSIS, HTML, Java Script, Visual Studio 2010, Windows 7, HP Quality Center.

Test Engineer

Confidential

Responsibilities:

• Incremental builds of the code were tested to ensure that code changes did not break existing functionality. This served as Build Verification Test (BVT).
• Involved in testing the few priority functionalities.
• Concentrated and involved more in System Integration testing.
• Actively participate in requirement gathering sessions, design reviews and other project meetings with project leads, developers and architects to coordinate all testing efforts.
• Involved in testing the data integration, system integration and business workflow.
• Extensive testing on the Performance of the Stored Procedures.
• Performed T- SQL tuning and Optimization of queries for reports that took longer execution time using MS SQL Profiler , Index Tuning Wizard and SQL Query.
• Involved in reviewing the test cases and executing the same.
• Developed Traceability Matrix and Test Coverage Reports.
• Reported defects in timely manner and logged the same into defect tracking tool.
• Verified the Fixed CRs and tracked the same to closure.
• Review tests specifications, cases and performed manual testing.
• Designed and developed test cases for putting the application on manual testing.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.

Environment: Windows XP, Java, J2EE, Servlets, JSP, Struts, SQL Server 2008, T-SQL, LDAP, Web logic.

Software Engineer

Confidential, Atlanta, GA

Responsibilities:

• Audited Business & functional necessity documents and recognized test scenarios.
• Participated in implementing test-plans and test-cases built on high-leveled and detailed design.
• Designed and developed the test cases for putting the application on manual testing.
• Broadly done manual testing, constraints verification testing’s, and the functional testing.
• Involved in the Test Case walkthroughs, assessment meetings.
• Cooperated and performed with development group to resolve the difficulties came across in a test execution.
• Involved in audit meetings and got an initiative to reach QA testing goals.
• Responsible for unit and integration testing and delivering the code to the Quality Assurance Team.
• Contributed in regular status meetings to state any bugs, problems and risks.

Environmnet : SQL Server 2005/2008, DTS, SSIS, SSRS, SQL Server OLAP 2000,BCP, Reporting Services 2005, T-SQL, MS Access, Windows XP/2003 Server

Software Engineer

Confidential, Pasadena, California

Responsibilities:

• Execute the test scripts, defect logging and reporting.
• Conduct root cause analysis of identified Production issues, providing development team with sufficient details to understand, replicate and resolve them.
• Concentrated and involved more in System Integration testing.
• Involved in testing the data integration, system integration and business workflow
• Involved in reviewing the test cases and executing the same.
• Reported defects in timely manner and logged the same into defect tracking tool.
• Involved in User Requirement Gathering and Technical Specification Documentation.
• Executed the Stored Procedures and Complex Queries for Reports.

Environment: Java, JavaScript, Servlets, Java Server Pages, Java Beans, Struts, Apache Tomcat Web Server, Oracle 8i and Windows 2000.

Software Engineer

Confidential

Responsibilities:

• Writing test plan after reviewing requirement document.
• Analyzed the requirements and written and executed the Test Cases.
• Identified various scenarios for functional and integration testing.
• Interacted extensively with development group.
• Performed functional testing.
• Creating test data based on the test cases and executing the test cases
• Database testing, by submitting data in Admin module.
• Analyze the manual test results, documented and reported through Quality center.
• Performed Database Connectivity by using Toad.
• Performed Regression Testing and End User Testing.
• Extensively use of SQL Queries to perform Transaction Testing(ORACLE)

Environment: JSP, Servlets, JDBC, Java 2, OC4J, XP, Oracle10g, Ant, Html, JavaScript.