SUMMARY

• Around 6+ years of experience in Information Technology with emphasis on Software Analysis, Manual, Backed and automation Testing
• Development and QA Testing in Client/Server and web based/ browser based applications/ Data Ware housing applications with Quick Test Professional (QTP/ Automation) and Load Runner (Performance Testing).
• Involved in development of Test Processes, developed automation testing requirements, prepared test scripts, running tests, collecting test results.
• Evaluate different frameworks in QTP and define the right one for testing based on testing needs.
• Conducted System Testing/ Functional/ Integration and Regression testing using QTP.
• Excellent in converting existing Manual Test Cases into Automation Scripts in QTP environment.
• Worked on sharepoint testing and saved all test results in it.
• Worked on Microsoft dynamic too.
• Expertise in working with Checkpoints of QTP.
• Have worked with Automation Framework (of QTP) like Keyword Driven and Modular Driver Framework.
• Expert QTP engineer with VB script expertise. An eye for automation wherever possible to develop usable code.
• Strong skills in backend testing using SQL queries, with analytical and problem solving skills.
• Strong experience in ETL Application using SSIS with various source like flat files, excel, Oracle.
• Working knowledge python scripting, C# and .Net too.
• Excellent functional knowledge on various domains like - Finance, Banking, Telecom and Health Care.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) with emphasis on Testing and requirement gathering phases.
• Experienced in Waterfall SDLC, V Model, Agile, RAD, CMM testing process; testing of applications in Iterative testing methodology in a rapid deployment model.
• Developed technical and functional requirement documents using Test Director and Quality Center.
• Worked on tools like HP Quality Center &, Clear Quest.
• Expert in different types of testing that includes Regression, Functional, Integration, System, User Acceptance, Sanity, Smoke, Performance, Stress, Load, Back End/Database Testing, UAT testing..
• Experience in testing various analysis reports generated in ETL/ DW Business Objects, (SSAS) and SSRS reports.
• Excellent knowledge of web services testing using Service Oriented Architecture (SOA) tools SOAP UI.
• Ability to apply technical expertise to organize and implement white-box and black-box test efforts and to analyze requirements for software design, development, and validation.
• Experienced in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.
• Proficient in writing SQL scripts, Stored Procedures and functions for database testing
• Configuring and implementing Defect Tracking process to provide Test Metrics
• Familiarity with Agile software development lifecycle (iterative and incremental), UML design documentation.
• Experience in interacting with business analysts, developers, technical support & help them base line the requirement specifications.
• Strong analytical, interpersonal, communication, coordination, problem solving and decision-making skills.
• Effective in executing multiple tasks and assignments; dedicated team member with excellent work ethics and with capability to handle new technologies and situations

TECHNICAL SKILLS

Testing Tools: HP/Mercury Quality Center 11/10/9.2/9.0/8.2 , QTP 11.5/ 11/10/9.2/9.0/8.2 /8.0, SOAP UI, Bugzilla, SQL Developer

Defect Tracking Tools: HP/Mercury Quality Center/ALM, Bugnet, Microsoft Test Manager, JIRA

Application environments: C++, C#, .NET Framework, Web Services, SSIS/ SSRS/ SSAS, Crystal, SOA, Java, ASP.NET

Programming Languages: VB Script, shell scripting, windows batch

Databases Technologies: Oracle, SQL, MS Access, PL/SQL

Other Applications: MS Word, MS Excel, MS Access, Lotus Notes.

Operating System: UNIX, Windows 9x/NT/2000/2007/XP

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

QA Analyst

Responsibilities:

• Developed scripts in VB to test validity of data across databases.
• Execute VB scripts using QTP to POC QTP’s ability to do backend testing directly.
• Procure requirements from business analysts for the BASEL validations.
• Build SQL queries to test the requirements manually first. Used TOAD.
• Used Agile Software Development methodologies to enable efficient and effective high-quality software development.
• Modify and tune SQL queries for faster performance. Used AWR reports to analyze SQL.
• Extensively involved in back-end data warehouse and data mart testing using PL/SQL scripts to check the data consistency, ETL process, data integrity in the application and database as data was fetched from different databases.
• Used share point to save test results.
• Create VB functions for generic functionalities like comparing data from baseline to target line, getting two tables value same, expected value of tables same.
• Created module in VB to automatically generate HTML reports in a specific directory.
• Worked on testing scenarios involved with dependency injection in C# for various data patterns.
• Compared database extracts using excel. Program module was written in VB.
• Provide a daily update to senior management with key issues, highlights and accomplishments.
• Preparation and Review of Gap analysis Document

Environment: QTP 11, Toad, Oracle 12c/11g, VB scripting, Power point, Excel, JIRA

Confidential, Bluffton, SC

QA Analyst/ Tester

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Worked on conversion of existing manual integration tests into automated tests using QTP for a few modules of the application.
• Also developed automated test scripts using QTP to perform Functional and Regression testing for the modules for which I did system testing.
• Extensively worked with Expert View and Keyword View in QTP.
• Performed Data Driven testing with multiple test data inputs with QTP and MS-Excel.
• Worked with different types of recording modes (in QTP), synchronization point.
• Experience working with Object Identification and Object Spy (features of QTP).
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Executed and managed test cases and reported bugs in Quality Center.
• Used Agile testing methodology for achieving deadlines in UAT.
• Formulate methods to perform Positive and Negative testing against requirements.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, user Acceptance Testing (UAT) and Data validation testing.
• Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.

Environment: Windows 7, Vista, XP,UNIX, QC 10.0, QTP 10.0, SOAPUI, HTML, XML, Java, Oracle 11g, SQL Server 2012, TOAD, SQL, PL/SQL, Clear Case, Clear Quest, UML, Word, Excel, PowerPoint, Outlook, MS Visio, MS Project

Confidential, Memphis, TN

QA Analyst

Responsibilities:

• SQL Server Administrator for 360 View tracking software for freight. Primarily responsible for upgrade and migration to the new server.
• Upgraded SQL server 2008 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,
• Worked on UAT Testing.
• Worked on QTP and created VB function for automation.
• 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.

Environment: MS SQL Server, MS SQL Management Console, Windows 2008 server, Bugzilla.

Confidential

QA Analyst

Responsibilities:

• Involved in creating Test plan and several test cases.
• Analyzed the business requirements and wrote Test Cases and Test Strategy for functional requirements.
• Responsible for Database testing using SQL queries in MS SQL Server.
• Analyzed the system specifications and helped team members to achieve test goals.
• Recorded scripts in Quick Test Pro to perform Functionality testing.
• Experience in building automation scripts in Quick Test Professional to automate smoke, sanity and regression testing. Automate test data load for every build cycle.
• Inserted various check points in QTP for testing the properties of objects.
• Ensured that all the test cases were written and updated in Quality Center.
• Reviewed test specifications, cases and performed manual testing.
• Involved in writing SQL Queries for retrieving and transforming data from SQL server.

Environment: ASP.net, Windows 2000, QTP, SQL server.

Confidential

QA Analyst

Responsibilities:

• Analyzed Business Requirements and System Specification documents and identify the test scenarios.
• Prepare detailed test plan based on the specifications document.
• Prepare Test Cases for testing the Business functionality, GUI, security, and usability.
• Test Data set up for validating the system for different type of customers and rate plan.
• Generating and verifying the bills of the customer
• Execute test cases in Quality Center.
• Perform End-to-End testing.
• Perform Database validation using SQL.
• Perform Integration, System and Regression testing.
• Track and log defects in Quality Center and coordinated meetings with developers and business analysts to prioritize the bugs.
• Perform Retest for defect fixes.
• Coordination between Delivery, Design and development teams for resolution of defects
• Participated in defect review & Go/No Go meetings.

Environment: Quality Center 9.0, UNIX, Toad, Oracle. Siebel