SUMMARY

• Certified QA tester with more than 8 years of proven experience in IT industry and extensive experience in Software Quality Assurance.
• Experienced QA tester to design, build and maintain a test environment that will support the firm's quality assurance program.
• In depth knowledge of the QA testing principles and strategies with strong experience in manual testing, relational databases and backend testing using complex SQL queries;
• Expertise in Full Testing Life Cycle from Defining Testing Methodologies, Designing Test Plans, Test Environment set - up, Create and Execute Test Cases, Defect Tracking, Test Closure, Documentations with effective QA implementation in all phases of the software development lifecycle (SDLC).
• Designed and engineered automation for software tests including functional tests across a variety of technologies and products.
• Delivered effective and efficient testing solutions by meeting key project milestones and overall project deliverables on time, and adhering to development and quality standards.
• Expertise in preparing Test Plans, Test Summary Reports, Test Cases and Test Scripts for automated testing based on the User Requirement Document and System Requirement Documents and Traceability matrices. Experience in Back end database testing on database Oracle, SQL Server and Teradata with complex query writing.
• Highly proficient in different phases of Testing like System, Module and Integration Testing
• Skilled at performing both Manual and Automation Testing on Client-Server, Web-based applications and API tools. Adept in performing Interface, Functional, GUI, Database, Performance, Regression, Volume, Stress and Security testing
• Strong hands on experience with test management tool, HP ALM/Quality Center. Experience in working with version control systems such as SVN, VSS or TFS;
• Ability to work independently as well as in a team, work closely with business, testing and development teams, excellent problem solving, troubleshooting, communication and interpersonal skills and exceptional time management skills and proven ability to meet deadlines.

TECHNICAL SKILLS

Languages: SQL, XML

Operating Systems: Windows, UNIX, Linux

Databases: MS-Access, Oracle, SQL Server, TOAD for Oracle, Netezza, SQL Developer, Teradata 13.10

Testing Tools: HP Quality Center, Test Director, HP Load Runner, BugZilla, JMeter

Reporting Tools: Microsoft SSRS

Packages: MS Office (Word, Access, Excel, FrontPage), MS Project, Target Process Management, MS SharePoint, Informatica PowerCenter 6.2

PROFESSIONAL EXPERIENCE

Confidential, Middle River MD

SQA Engineer (Reporting to QA Manager)

Tools: used:MS Office, MS SharePoint, HP Quality Center, QTP, Web Testing, Windows Media Player, Internet Explorer 9, SQL

Responsibilities:

• Analyze application systems, create test case documentation, and execute plans.
• Develop and maintain test plans, manual and automated test scripts for user interface, functionality, system and "ad-hoc testing".
• Experience translating functional requirements into technical specifications.
• Ensure communication of test results and status to all groups involved.
• Successfully prepared and executed tests based on business/user requirements, system specifications and screen mock-ups.
• Responsible for reporting, bug tracking and representing QA in project status meetings
• Contribute to planning and provide hands on technical support of multiple phases of testing for the project
• Facilitate the creation of test cases and supporting data
• Conducted bi-weekly status update meetings with team abroad to inform of the testing activities and progress done each week.
• Installed the product builds and executed regression/performance testing based on test cases and test scripts created in Excel and Load Runner.
• Defect Management- Documenting issues / defects /report generation/ defect analysis/escalation.
• Deliver effective and efficient testing solutions by meeting key project milestones and overall project deliverables on time, and adhering to development and quality standards
• Coordinated monthly meetings with the CTO to report the status of overall progress for that month and addressed any issues being faced by QA team for carrying out their daily activities.
• Demonstrated the business features by executing scenarios during UAT (user acceptance testing).
• Executed developed test cases, maintained test data for all executed test cases and reviewed the result of entire QA team with test lead/ test manager for accuracy, completeness and usability at regular intervals.
• Mapped test cases back to business requirements by creating the Requirement Traceability Matrix
• Participated in the mandatory yearly audit with the team by preparing & collecting from various departments such as the Quality System Manual, Quality Policy and other business process/technical documents.

Confidential, Columbus Ohio

Tools: used:MS Office, MS SharePoint, HP Quality Center, QTP, Web Testing, Windows Media Player, Internet Explorer 8, SQL

Responsibilities:

• Created and executed test scripts traced to requirements to validate the quality of the work products, always keeping the customer experience in mind
• Identified and recorded defects in Quality Center.
• Communication With Design team to sort out technical issues with Dev Team to forward the same once the issues/ queries are sorted out
• Performed Defect Management and responsible for preparing and managing the metrics
• Organized status meetings and send the Status Report (Daily, Weekly etc.) to the Client.
• Involved in Regression testing usingQTPand enhanced the scripts by adding functions and inserted Synchronizationpointsin scripts whenever necessary.
• Coordinate in administering and managing the bugs in Quality Center
• Assisted in test configuration management activities for moderately complex work efforts
• Worked with vendors and business partners to address ambiguity and provide clear, concise requirements
• Created test scripts in Quality Center and mapped them to maintain the Traceability Matrix
• Analyzed test plans and test cases based on requirements and general design documents involved in both manual and automation testing
• Supported and coordinated testing activities which includes review of test cases and test conditions
• Conducted meetings and walkthroughs and updated test plans and scripts for any functionality changes
• Executed analysis of the defects identified during the testing process
• Detected bugs/ defects during execution of scenarios, logging them in defect tracking tool and working with assigned developer till closure of the bug life cycle.
• Prepared testing summary reports, monitored progress during each test to ensure that the solution is validated and on time and that it meets or exceeds expectations
• Assisted in test configuration management activities
• Performed both manual and automated testing activities

Confidential, Indianapolis, IN

Tools: used: HP Quality Center, MS Project, MS Office, SQL, Toad for Oracle, Informatica PowerCenter, SSRS

Responsibilities:

• Reviewed functional and technical documentation in order to identify requirements for the creation of test plans, test cases and test scripts.
• Reviewed test cases in the repository based on the use cases, high level design, low level design, project test plan for correctness and comprehensiveness and ensured they match project requirements.
• Performed back end testing for all the 3 phases of the project involving Oracle SQL data
• Developed high level test scripts and test cases for the different stages of the project using Quality Center Test Plan module
• Performed front end testing on SSRS reports containing data coming from the Oracle databases
• Created and executed SQL queries to validate that actual test results match the expected results
• Manipulated and created test data in TOAD for Oracle and TOAD for Data Analyst (Netezza) for the purpose of testing in the various phases of the project
• Developed solid test documentation, including the creation and maintenance of comprehensive Test Plans and Test Cases
• Performed complex SQL joins on 3-4 tables using SQL statements and utilized the data retrieved for testing purposes
• Executed various Shell Scripts in UNIX to trigger the workflows that truncated and loaded data into the Oracle tables in TOAD.
• Successfully maintained constant conversation with Senior Management, Project Managers, Developers and Clients in regard to enhancements and fixes to applications, in order to deliver projects in a timely and cost effective manner.
• Creation SIT Test Summary Report, UAT Test Summary Report, Regression Test Summary Report and Performance Testing Test Summary Report.
• Employed Informatica Power Center tool to monitor workflows and verified that data into the tables
• Documented defects in Quality Center and worked with the developers to resolve them
• Created test plans, test cases and test scripts
• Wrote SQL queries and performed complex joins on tables in Toad for Oracle
• Performed back end data testing on tables in Toad for Oracle
• Recorded defects in Quality Center and worked with development team to resolve them

Confidential

Senior Systems Support Analyst

Responsibilities:

• Provided day to day support for System Administrator tasks for managing SQL Server 2005/2008 and Microsoft infrastructure components for Confidential clients
• Planning, documentation and infrastructure server expansion of 20 servers to support
• Setup the server with installation of SQL Server 2008 Enterprise setup the cluster, Migrate data from different sources including Oracle 10g/11g
• Provided day to day support for Microsoft products and network infrastructure
• Handled escalated support tickets from helpdesk for level 2 support
• Integration of Virtual Machine backups into existing physical server utilizing backup procedures
• Rebuild of Windows Server / 2008 R2 Active Directory domain controllers, integrated DNS and DHCP services
• Development of Strategic IT Plan / Technology Roadmap documents
• Supporting users and providing first level technical support to users
• Provided technical support to users in area of Active Directory, DNS, Exchange, BES, Outlook, Office, Printing and network connectivity issues
• Part of the team to provision users in AD, mailboxes in Exchange, and blackberries in BES and BIS
• Handled helpdesk support calls, and email support
• Provided quality customer service and met the call center SLA
• Monitored and supported AD including adding/deleting users and shared permissions.
• Analyzed and resolved network and server connectivity issues

Confidential

Technical Support Analyst

Responsibilities:

• Provided day to day support for Microsoft products and network infrastructure
• Handled escalated support tickets from helpdesk for level 2 support
• Integration of Virtual Machine backups into existing physical server utilizing backup procedures
• Provided 1st & 2nd level support to the computer related issues.
• Setup the server with installation of windows server 2005 and worked with the windows clustering team, Install SQL Server 2008 Enterprise setup the cluster, Migrate data from different sources
• Responsible for SQL Server installation, Database Upgrade/Migration from SQL Server 2000 to SQL Server 2005 on Windows Server 2003 environment.
• Project included parallel test migration with database & Application testing.
• Prepared Documentation on Migration methods and steps including Login transfers.
• Involved in analyzing troubleshooting and problem resolution.
• Troubleshoot complex issues, i.e. performance of directory service in terms of messaging, replication issues.
• Held a key role in analyzing and identifying issues, and root cause analysis. Then recommending design/architectural change to avoid all related issues.
• Produced technical and high level documents for management and presentation to business.
• Managed servers for the company, and looked after backend line of servers hosting 5000+ user base