SUMMARY

• Sr. Computer Programmer Analyst with 7 years of experience on large diversified projects in Manual, Automated and Database testing.
• 4 years of experience working at Client location in the USA.
• Experience of leading a team at on - site and offshore.
• Experience in various business verticals including Insurance, Banking and Life Sciences.
• Experience in Automation Testing in QTP 11.
• Experience in preparing the Test scripts using QTP.
• Expertise in Data driven and Keyword driven frameworks
• Experience of working on a POC project in QTP.
• Expertise in Database Testing, Back End testing using SQL queries and Cross Browser Testing.
• Experience working with Perl and VB scripting language.
• Experience in creating Effort Estimation, Test Plan and Test Strategy documents.
• Expertise in all phases of a project lifecycle starting from requirement gathering, BRD, FSD and TDD reviews, test case design, execution and defect life cycles.
• Regular interactions with Business Analysts, Business and Development teams to gather the exact requirements and technical details.
• Help business team in creating workflows.
• Prepared Requirements Traceability Matrix (RTM) to ensure that all the requirements are covered thoroughly and each test case is mapped with at least one requirement.
• Experience in working with Agile/Scrum as well as traditional SDLC cycle.
• Experience of using testing tools like Quality Center/ALM, JIRA.
• Expertise in working with the different modules of Quality Center such as Requirements, Test Plan, Test Lab, Defects and Dashboards.
• Experience in creating QC Reports using SQL in Dashboard.
• Designed a tool to work on QC Test plan using VB Scripting.
• Experience to lead a team, manage and coordinate the work in a time sensitive environment.
• International Software Testing Qualifications Board (ISTQB) Certified Tester (Foundation level)
• Experience in creating Database queries using SQL Server 2008.
• Familiar to Programming language like C, C++, Java- Servlet, JSP.
• Flexible and versatile to adapt to any new environment and work on any project.
• Good analytical skills, communication, interpersonal skills and written skills.
• Innovative professional with the ability to identify, analyze and solve problems to increase customer satisfaction.
• Ability to perform under pressure and solve problems with minimal turnaround time.
• Focus on delivering Business solution.
• Ability to learn quickly and have been able to demonstrate this capability through working on Proof of concept project.
• Good understanding of technical trends, architectures and highly motivated to know more about the latest technology, new software and products.
• Excellent skills in problem solving and delivering realistic and practical solutions
• Self-starter, independent, motivated, and enthusiastic team player with excellent analytical, written, communication and interpersonal skills

TECHNICAL SKILLS

Primary Skills: HP Quality Center 11/ALM, QTP, Perl, Microsoft SQL Server 2008.

Automation Tools: HP QuickTest Professional 11

IDE: Eclipse, Netbeans IDE

Methodology: Waterfall and Agile Methodology

Testing: Functional, Integration, Smoke, Regression, Database and Automation Testing

Languages & Technologies: Perl, Ruby, VBScript, HTML

Databases: Microsoft SQL Server 2008, Oracle 10g, MS Access

Tools: HP Quality Center 11/ALM, SharePoint, JIRA, MS Office Professional

Deployment\Installation: Tomcat, IIS

OS: Windows XP, Windows 2007, Windows 2008, Unix

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr. Computer Programmer Analyst

Responsibilities:

• Review the documentation and provide feedback to the business.
• Involved in daily stand ups Sprint planning, Sprint review and Retrospective.
• Working with Business Analyst and technical team for product grooming.
• Involved in data validation using SQL queries and back end testing.
• Generated reports usingSQLServerReportingServices (SSRS).
• Working in MicrosoftSQLServer Database Administration including planning, implementing, backup, and recovery strategies.
• Test Plan preparation
• Created, modify, schedule, test and or troubleshootSQLServer Integration Services (SSIS) packages, stored procedures, Tables and Views.

Environment: Windows7, SQL Server Management Studio, Quality Center, Cube, Data mart, SharePoint, Version One

Confidential, MN

Sr. Computer Programmer Analyst

Responsibilities:

• Review the documentation for the behavior of the existing application.
• Attend meetings for new requirements, Review Business requirement documents, Functional specification documents, Technical design documents for the new enhancements and do the impact analysis.
• Mentor the team in understanding the customer needs, explaining the requirements and help them work on testing needs of the application.
• Developed Data Driven and Keyword Driven Framework usingQTP.
• Customized test Result inQTP. Read Excel Data into CustomQTPData Table using Custom Function. File System Object (FSO).
• Used For loop, Conditional if statement to handle application logic. Designed Functions Library, Functions Subroutine's common function, regular Expressions and Environment Variables usingQTP in VB Scripts.
• Used Descriptive, Synchronization, Call function, Parameterization, Checkpoints, Error Handling, Recovery Scenarios, Regular Expressions to enhance test effectively also created reusable actions by usingQTP/UFT
• Develop test scripts on Expert View and enhanced those scripts using Functional Libraries from scratch and performed regression testing for every new release usingQTPas an automation tool with VB scripting.
• Prepared test data and test results (input / output files) for data driven method by using Global and Local spreadsheets inQTPfor testing multiple.
• Prepared both actions based and component based scripts usingQTP. Component based scripts were stored in Quality Centre. Executed the action based scripts from Quality Centre/ ALM.
• Parameterized the tests by entering different sets of data usingQTP.
• Resolving issues and queries raised by the team.
• Identify test scenarios and test case design.
• Involved in Datasheet preparation for test cases
• Involved in creating an automation framework using QuickTest Professional
• Create automation scripts using QuickTest Professional
• Develop SQL queries for test data
• Run the automation scripts and report failures
• UI and Database level testing.
• UI testing of the functionalities for accounting and client relationship management.
• Logging and tracking the defects in Quality Center (ALM later on) and following up with the development and business teams in defect triage meetings.
• Maintaining traceability of test cases with the requirements to ensure complete test coverage.
• Participated in performance tuning of stored procedures used in the application.
• Test case and Release notes review
• Knowledge sharing with the team members and new resources.
• Conducted weekly Triage calls and Scrum meetings with business and development team to address issues/defects.
• Helped deliver the project by actively taking part in other responsibilities like writing on-boarding documents, presenting demos to end customers and also provided support to on-boarding teams to accelerate them
• Always took a step ahead to make sure to share ideas and concepts related to any new useful technologies with other members of my team and as well as across teams by providing demos. This cross collaboration not only benefited other teams but also helped our team in finding out any issues that team came across and their possible solutions

Environment: QTP/UFT 12.02, Load Runner, ALM 12.02, Windows7, Windows XP, SQL Server Management Studio, Quality Center, SharePoint

Confidential

Senior Software Engineer

Responsibilities:

• Understanding the business requirements and the data architecture for source and target systems, finding the loopholes in the documentations in the requirement gathering phase.
• Review of the mapping documents based on the understanding of the business and functional requirements before the design phase.
• Written a VB batch file to migrate years oftestdata from excel totestlink, which saved a lot of manual tasks for the whole team. And also trained the manual testers on working on the script
• Creating SQL queries for validating the ETL solution, automating the test cases and file validation using Perl.
• Maintaining traceability of test cases with the requirements to ensure complete test coverage.
• Executing the test cases, logging and tracking defects in QC, attending bug triage meetings.
• Performance tuning for the SQL queries to test on high volumes of data.
• Carried out testing of the product in controlled and real situations before going live
• Prepared training manuals for users.
• Developing SQL Queries for validation and retrieval of data.
• Involved in updating Requirement Traceability Matrix.

Environment: Windows XP, Unix, Perl, SQL Server Management Studio, Oracle, MS-Excel, Quality Center, VB

Confidential

Software Engineer

Responsibilities:

• Requirement analysis by reviewing BRD and FSD for the new enhancements and do the impact analysis.
• Identify test scenarios and test case design.
• Application deployment on Tomcat/IIS and Weblogic
• UI and Database level testing.
• Logging and tracking the defects in JIRA and following up with the development and business teams in defect triage meetings.
• Installer Testing
• Test case and Release notes review
• Attend project and status meetings with stakeholders to discuss progress of coding/development effort, review coding methods, address concerns about the project.
• Involved in testing various components of the application in various phases, including unit testing, integration testing, user acceptance testing.

Environment:Windows XP, Perl, QA Manual, VSS, Tomcat, IIS, WebLogic, Server Side Testing, SQL Server Management Studio, Oracle, PostgreSQL, JIRA

Confidential 

Software Engineer

Responsibilities:

• Creating and running test scripts using Ruby scripting
• Knowledge sharing on the Tool
• Organize test data to be used for Automation
• Actively participated in daily and weekly status meeting calls.

Environment: Windows XP, Watir, Ruby