OBJECTIVE:

Looking for a responsible and challenging position with opportunities to enrich my knowledge and skills while contributing to the success of organization and to build a result oriented professional growth.

PROFESSIONAL SUMMARY:

• Over 6+ years of work experience in the field of Software Quality Assurance working with Client/Server and Web applications
• Expertise in diverse domain technologies like Solar Energy, Finance and Banking, Healthcare, Retail and Cable
• Involvement in Setting up Test Environments,Test Planning, Test design,Test Automation, Test Execution, Defect Reporting,Test Status Reporting, Test Closure Activities
• Strong knowledge of all the phases of SDLC and STLC. Experience working with Agile (RUP, Scrum) Waterfall SDLC methodologies
• Extensive experience to analyze and document business requirements, system and functional specifications including use cases
• Extensive experience in GUI, Regression, Functional, Integration, System, User Acceptance (UAT), Sanity, Performance, Stress, Reliability, compatibility, Security and Database Testing
• Experience in QTP in running scripts for Smoke, Functional and Regression Testing
• Good Knowledge on Automation Tool like Selenium RC & Web driver
• Experience in Functional and Non - Functional (Availability, Usability, Reliability and Compatibility) Testing Types
• Solid Experience of backend testing by writing and executing complex SQL queries
• Proficient in using Test Management tool Like Quality Center and Clear Quest for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Reporting
• Ability to achieve targets and deliver results in a high-pressure environment
• Extensive experience in Product Operations, Product Testing and Product Search
• Performed business requirement analysis, generate requirements documentation
• Develop and maintain data integrity standards. Validate data and Audit data quality

TECHNICAL SKILLS:

Operating System: Unix, Solaris, Windows XP/VISTA/7, Mac OS x

Databases: Oracle, MySQL, MS Access, SQL SERVER

Browser: IE, Mozilla Firefox, Google Chrome, Safari

Programming languages: SQL, JAVA,J2EE, VB.NET, HTML, XML, C, C++, VB, VBScript, UNIX Shell Scripting

Testing Tools: QTP, LoadRunner, SoapUI, Soap Scope, Selenium IDE, JMeter

Bug tracking Tools: HP-QC, Bugzilla, IBM Rational ClearQuest, Test Director

Other Tools: Toad, VM Ware, XML Spy, Putty, Visio, Rational Requisite,MS Project, MS office Suite

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

QA Analyst

Responsibilities:

• Developed test plan and test cases by analyzing requirements, design documents and use cases diagrams
• Prepared test cases and verified the dynamic web contents, HTML pages and compatibility with multiple browser versions
• Prepared test data for testing the application in various test phases
• Monitored and tested batch job alerts and verified the status of batch jobs
• Involved in Manual and Automation testing
• Implemented various Black Box testing like GUI, Regression, Functional, Integration, System, User Acceptance (UAT), Sanity, compatibility, Security and Database Testing
• Identified test cases to be automated and executed them in QTP
• Created functional libraries and incorporated while creating the reusable scripts
• Handled dynamic objects of the application using regular expression of QTP
• Performed GUI, Regression, Functionality, positive-negative, data driven testing using QTP
• Tracked, Managed and documented the Functionality, Performance and Behavior of the application during UAT
• Extracted log files from the server by using UNIX commands.
• Performed Data-driven testing - Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote functions for the parameters to read new data from the table on each iteration.
• Used TOAD to write and executed complex SQL queries including JOINS, Operators and conditions to validate Back-end data
• Documented the errors using QC and tracked them to completion by communicating and co-coordinating with the development as well as the support group
• Supported BA and Business Users during UAT phase
• Contributed to daily status meetings with project management on testing update
• Generated Testing and Defect Status report and communicated to the Project Management Teams

Environment: HP - QTP, HP-QC, Oracle, Windows UNIX, XML, C#.NET, HTML, MS Office

Confidential, San Mateo, CA

QA Tester

Responsibilities:

• Analyzed business requirement documents, functional requirement documents and necessary resources.
• Developed Test Cases and customized in MQC according to the requirements of the project.
• Created the test scripts for the requirements.
• Involved in Manual Testing and Automated testing of the test cases
• Performed Functionality, Integration, System, Usability, Regression and User Acceptance Testing using QTP.
• Used data driven testing features, synchronization points, check points, reusable actions, Regular Expressions in QTP.
• Loaded data into an Oracle database and did database testing through SQL queries.
• Performed compatibility testing with different browsers like Firefox, Internet Explorer on different Operating Systems like windows XP, Vista, 7, Mac OS.
• Used UNIX commands to extract the log files from server to identify the root cause of issues.
• Used SOAP UI for testing the web services and API.
• Generated reports in the MQC to show the run status of the test scripts and participated in the meetings to walk through the defect reports periodically.
• Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
• Testing data and control flow to ensure that the consistency of business logic is maintained on version upgrade.
• Involved in meetings with the development team to resolve technical issues.
• Actively participated in enhancement meetings and was responsible for weekly status updates, troubleshoot new releases and production issues content.
• Interacted with the Project Manger to provide estimates for different phases in the projects and also interacted with the client team to convey the progress.

Environment: QTP 9.1, SoapUI, SQL Server 2008, Query Analyzer, UNIX, Java, Windows XP/Vista/7/Mac OS, Firefox.

Confidential, San Ramon, CA

QA Engineer

Responsibilities:

• Analyzed BRD, FRD and coordinated with business analysts to write test plan and test cases
• Performed Functional, Smoke, Regression, Usability, System Integration testing
• Prepared test data for testing the application in various test phases
• Identified and grouped test cases for automation and developed an automation framework in QTP
• Created scripts in VB for automation testing in QTP
• Wrote automation scripts to verify the web elements and UI functionality
• Expertise in using automation testing tools like QTP, Load runner and SoapUI
• Developed automated regression scripts and test scripts for functionality test in a data driven framework
• Developed reusable VBS functions for functionality testing and worked closely with the developers to identify the new objects
• Wrote and executed XML test scripts to test the application
• Performed Backend database verification manually and implemented QTP to automatically verify database with the values entered during automation testing
• Used TOAD as well as SQL analyzer to manipulate SQL queries to verify the data in the database
• Creating an effective data migration testing strategy and delivering a successful migration
• Performing the Pre-migration testing, Formal Design Review and Post-Migration Testing
• Interacted with Developers and System Analysts to understand the severity of the defects and assigned priorities to resolve the bugs
• Performed bug tracking, including submitting and assigning defects to the application developers using Rational Clear Quest.
• Tracked, Managed and documented the performance of the application during UAT

Environment: HP - QTP, HP-QC, Java, XML, Oracle 10g, Oracle 11i, Load Runner, Autosys, Windows XP, UNIX

Confidential, NYC, NY

Quality Test Engineer

Responsibilities:

• Analyzed business requirement documents and functional requirement documents and identified Business critical feature functionalities.
• Performed Manual Testing, automation testing, compatibility testing, performance testing for Test cases on each module.
• Developed automated Test scripts for Regression Testing using QTP.
• Enhanced the scripts by parameterizing, inserting checkpoints and using synchronization.
• Identified the test scenarios for automation and developed QTP actions (VB script) to simulate user actions.
• Performed database testing by firing SQL queries and tested the database for integrity.
• Performed compatibility testing with different browsers like Mozilla, Internet Explorer.
• Performed Load test scenarios using Load Runner to bombard the server with virtual user requests and test the performance under stress conditions.
• Monitored the IIS server under load to find the performance bottlenecks.
• Reported the defects using TestDirector.
• Analyzed the results by viewing graphs in LoadRunner.
• Reported the defects and analysed the results.
• Used QC for test management and bug tracking.

Environment: Java, MQC 9.0, Oracle 9i, SQL Plus, Test Director 8.0, WebSphere, LoadRunner 8.0, QTP 8.5, UNIX, Apache, Windows XP/2000/NT, IE 8, Mozilla.

Confidential, Cleveland, OH

Sr. QA / Performance Engineer

Responsibilities:

• Extensively used Mercury Performance Center/LoadRunner VUGen to develop scripts scenarios to cover entire performance testing requirements outlined by the business users.
• Worked closely with database team to setup database trace in order to pinpoint queries taking longer time to execute.
• Used multi protocol (TCP/UDP/HTTP) within Loadrunner VUGen to create and compile Loadrunner scripts.
• Involved in setting up mercury Wily Introscope monitors on application and database level to drill down and report performance bottlenecks such as CPU usage, memory availability, disk I/O.
• Involved in validating the data that has been populated into Data warehouse Fact and dimensional tables using ETL tool.
• Translated SQL Stored Procedures into ETL routines for accessing and manipulating data from database.
• Prepared batch processing scheduling by using Autosys on UNIX server.
• Used UNIX commands to extract the log files from server to identify the root cause of issues.
• Used SoapUI for testing Service Oriented Architectures (SOA) and Web Services (SOAP, REST, WSDL).
• Documented the errors using MQC and tracked them to completion by communicating and co-coordinating with the development as well as the support group.
• Responsible for the day to day monitoring of the progress of project and alerting management to the earliest signs of trouble.

Environment: MQC 9.0,F5,Sunone,LoadRunner 8.1,Performance center,Windows XP/Vista/7 .

Confidential, Livermore, CA

IS Analyst

Responsibilities:

• Documented requirements and transformed them into functional and technical requirement specifications, modeled business process flows using UML diagrams.
• Conducted one-to-one meetings and web-Conferences as well as JAD sessions with different cross functional team, analyzed and came up with suggestions providing consistent process for the communication, escalation, and resolution of issues.
• Managing schedules while working with multiple teams.
• Articulated business requirements from user interviews, and workshops and then converted requirements into technical specifications for developers.
• Wrote Complex SQL queries to fetch data from SQL Server, Vantage and Access databases.
• Compiled daily, weekly and monthly data reports on defect trends/process issues.
• Drove processes and solved problems across multiple business groups related to data.
• Enabled the lifting of process gates (back end) through initial ownership, data analysis, and daily updates.
• Troubleshooting technical and non-technical challenges.
• Analyzing client data to identify immediate improvement opportunities.
• Prepared, drafted, and revised materials for the content team and implemented day to day project management activities for data associate tasks.
• Analyzed and manipulate large data sets with MS Access and/or Excel.
• Collected and exported data from Spend compass tool to Excel/Access/text files.
• Responsible for writing complex SQL queries and spool reports to various delimiter formats for Excel and other application conversions.
• Designing and leading custom implementation strategy based on nature and accessibility of client data.
• Update, Insert and Delete SQL Features.
• Administer and act as content expert for multiple large databases comprising survey and benchmarking data.
• Assist members in trouble shooting online survey interface and online reports of survey results.
• Extract and Gather the business requirements from the business experts and architects and Document them.
• Demonstrate ability to conceptualize a design and assist in implementation of system enhancements by using web based application, share point and CSG tools.
• Assist with periodic Customer Data metrics measurements and reports
• Assisted Business Intelligence team to develop the reports for various management levels related to past business as well as to predict the future expectations
• Set up automation process to run daily, weekly and monthly reports for all departments.

Environment: Oracle, MS-Office (MS-Access, MS-Excel and MS-PowerPoint), SQL Server, Forest & trees, Benthic, Crystal Reports, Camellia, VBA script, share point and CSG tools.

Confidential, San Ramon, CA

Data/Report Analyst

Responsibilities:

• Produce customized reports for various departments from CSG Database by using SQL server and Microsoft Access.
• Maintain, edit and monitor a reporting database.
• Worked with the business team and technology team in substantiating the System Requirement Specification document for the project.
• Maintain and development internal data, execute VBA script to run macro & assistance with applications backlog, migration of legacy data, and providing systems support for existing and new systems.
• Assist in identification of data integrity problems & reusable data and objects components and recommend solutions.
• Oversaw and reviewed risk assessment data and analyzed to identify trends, recognize and foresee potential issues, and make suggestions.
• Oversaw and reviewed risk assessment data and analyzed to identify trends, recognize and foresee potential issues, and make suggestions.
• Assisted the business area in researching and resolving production and user acceptance test environment problems and to monitor customers billing.
• Used SQL query to retrieve data for reports and presentations.
• Responsible for supporting day - to-day processing of cable master files.
• Matched custom vendors and products with entries in databases.
• Uploaded product data to the master database.
• Develop & maintain SQL queries/stored procedures to extract, manipulate, and/or calculate information.
• Provided forecast repots for collections department and daily ad-hoc analytical reports as requested from various team.

Environment: SQL, SUPRTOOL, VBS script, My SQL, HTML, MS-SQL, billing, and customer support applications; Microsoft Access, Data query and report production using mainframe-based CSG tools, Microsoft Visio, focus andWindows-based access, excel tools.