SUMMARY

• Over7 yearsof IT experience in Analysis and Testing of Business Intelligence solutions using Conversion Data,Data Warehouse/Data Mart Design, Manual,ETL, OLAP, Client/Server applications.
• Excellent working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Expertise in writingSQL QueriesusingOracle,SQL ServerandTeradatain validating data into Data Warehouse/ETL applications.
• Extensively involved in writing Test Plan, Test Cases, Test Scripts and project related documentation.
• Worked extensively in development of BRD Documentation as per client requirement.
• Good experience with Testing Tools like QTP/UFT and Quality Center/ALM, Soap UI, Rational Functional Tester.
• Experience in .Net Programming & MSSQL Server Programming for Web and Desktop application
• Experience in Water Fall, Agile scrum methodology
• Expertise in analyzing client needs by participating in requirement review and design meetings.
• Involved extensively in various stages of Functional testing, Integration testing, Regression testing, User Acceptance testing, Negative regression, System Integration (SIT), User Acceptance Test (UAT), Security, Browser compatibility
• Extensive working knowledge inShellScripting,UNIX, LINUXandWindowsplatforms.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts based on baseline requirements.
• Extensively used HP Quality Center/ALM and Bug Tracking System for reporting Defects, performing bug tracking, submitting the quality bugs, raising the issues, changes and defects resolving bugs.
• EMR system and EDI transactions for claim process, ICD 9 to ICD 10 conversion knowledge from healthcare domain.
• Involved in test planning, writing test cases/scripts, test case automation and test execution.
• Expertise in handling Onsite - Offshore model, client handling and continues business process
• Worked on joins, views, functions using SQL and good in documenting the testing process.
• Ability to execute test cases for functional testing, system integration testing, create defects, manage defects.
• Actively participated with user groups to perform extensive User Acceptance Testing (UAT).
• Expertise working with Soap UI.
• Experience in testing Web Services through XML
• Solid Back-end testing experience in writing and executing SQL Queries.
• Developed and executed formal test plans to ensure the delivery of quality software applications
• Estimated UAT effort for individual change item and ensured schedule commitments were met.
• Experience in working on UNIX, Sun Solaris, Linux, Windows platform. Developed Shell scripts.
• Exceptional ability to quickly acquaint with new concepts and technology.
• Strong analytical, problem solving skills and a good team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Testing Tool: HP Quick Test Professional(QTP), HP Quality Center Load Runner 11.0

Microsoft Technologies: ASP.NET, ADO.NET, VB.NET

Database Technologies: Microsoft SQL-Server, Oracle 11g, SSRS, ETL, Oracle, DB2, SQL

Performance Tool: Microsoft VisualStudio, Microsoft SQL Server

Programming Language: C, C++, C#

Web/Application Server: IIS-7

Testing Methodologies: Smoke Testing, Performance Testing, System Testing, Functional Testing, Regression Testing, Acceptance Testing

System: MS Windows, Unix/LINUX, AS 400

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

QA Tester

Responsibilities:

• Worked as a QA engineer and was responsible for automation UI testing framework designing, file processing testing and services testing.
• I also halped them in optimizing existing testing framework design; as a result test case development work got drastically simplified. dis required me to work closely with Telerik technical support team.
• Review and analyze the Business Requirement Document and Design Document using Rational RequisitePro.
• The IS&R testing team creates test cases and test scripts based on User Stories and related requirements for any given Sprint.
• Tested by giving input to theSOAPrequest throughSOAP UIand validated the responses by executing queries against the database.
• Verify logs on the servers logging within SecureFx.
• Open a defect ticket to look at the fields using Clear Quest
• Attended daily standups and weekly test meeting to report the progress of testing.
• Performed regression testing for every modification in the application for new builds using SOAP UI Pro.
• Updated the XML for appropriate test cases using XML spy and notepad++.
• Make sure the Scheduler should are up and running to capture operational metrics.
• Verify the Request is sent to the right end nodes while sending request thru SOAP UI.
• Check the Metrics table to make sure the transaction is logged correctly.
• Run queries to verify the payloads are logged in the database.
• Write negative TIN verification scripts and run the scripts using SOAP UI.
• Conducted Smoke Testing once the build is ready.
• Prepared the End of Test report once the testing is done.
• Verified the Error codes as per the requirements in RequisitePro.
• Verify the Transactional logs and error logs login to SecureFx.
• Working closely with Business Analysts, Developers, project managers and users.
• Participating in all project meetings to analyze and extract business requirements.

Environment: SOAP UI, Telerik, Oracle 11g, Internet Explorer, Clear Quest, XML Spy, Secure CRT/Secure FX, Notepad ++ / Text pad, Web Methods, RequisitePro

Confidential, El Paso, TX

QA Analyst

Responsibilities:

• Review and analyze the Business Requirement Document and Design Document.
• Worked with Business /Technical Analyst in analysis of functional design specifications of ETL/Data warehouse applications of Global Direct, Sales Order Processing and Blue Hornet Email for Microsoft & Adobe clients
• Review the Test Cases and update in the Quality Center.
• Write test scripts in QTP to automate the scripts.
• Write the Test cases based on the requirements.
• Used Quality Center for planning, documenting and developing the test cases.
• Working with HP Application Lifecycle Management (ALM) for tracking the application changes.
• Ensure the Test Script is up-to-date with current business changes.
• Attended daily standups and weekly test meeting to report the progress of testing.
• Defects were tracked reviewed and analyzed and reported using Quality Center.
• Conducted Smoke Testing once the build is ready.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• UsedTOAD for Oraclein creating & executingSQL queriesfor testing ETL process.
• Performed regression testing for every modification in the application & new builds using QTP/UFT.
• Recorded and also wrote some scripts in Expert View in QTP/UFT and executed them.
• Used Quality Center for test management.
• Created the Automation Test Plan and extensively used QTP/UFT for creating scripts for functional and regression testing of various features of the application.
• Environment: QTP/UFT, Application Lifecycle Management, Oracle 11g, Internet Explorer, BO.

Environment: Facets, QTP/UFT, Java, SOAP UI, JIRA, Mercury Quality Center, ETL, PL/SQL, SQL SERVER, Internet explorer, Windows, Oracle, MS Office

Confidential, Dallas TX

Sr. QA Analyst

Responsibilities:

• Attended Requirement Review meeting with Business Users, Developers and provided feedback comments.
• Reviewed OSS and Billing specific functional specifications documents(UC, UI, Business rules and FRS)
• Responsible for creating the Test Plans and giving an overview of Test Plans in Test Plan Review meetings to get them signed off.
• Created Test cases and Test data to TEMPeffectively test Billing application functional scenarios.
• Interacted with Subject matter Experts and Development teams to identify and refine test Test Scenario’s & Test Cases.
• Worked with HP ALM to create test cases, to execute test cases and to log application defects.
• Implemented and installed all the HP Tools including QTP, Security Center, and Agile.
• Conduct peer review of test cases to ensure functional requirement are covered for the documented business designs specifications.
• Developed Traceability matrix from Requirements document and detailed design documents.
• Created requirement traceability using HP ALM tool.
• Worked with AS 400 systems as part of End to End testing.
• Performed Smoke/Functional/Integration/Regression and Manual Performance testing.
• Involved in testing various modules of the project such as Enrollments, Web Self Service, Billing, Invoicing, Payments, Collections and Integration between various modules and external systems.
• UsedDescriptive programmingto handle multiple objects with similar properties.
• Involved in testing the application in various environments such as Test, Stage & UAT environments.
• Worked with Unix command user interface and executed UNIX commands as part of end to end testing
• Validated server log files, event logs, audit logs by executing UNIX commands.
• Written and executed UNIX commands and UNIX scripts to validate server side records as part of end to end transaction validation
• Tested applications compatibility on different platforms (Windows, Linux, Mac OS)
• Involved in writing and executing SQL Queries in PL/SQL Developer tool for Back-End testing.
• Simulated the testing of integrated applications using XML and FTP tools for system testing.
• Developing and enhancing the automated test scripts using Quick Test Professional as per requirements.
• Coordinating with Development and Business users to resolve any issues related to defects.
• Participated in system specification meetings, team meetings, status meetings, coordinated with developers and team members.
• Worked on Agile (Scrum Master, Sprints) testing methodology.

Environment: SW Planner, HP ALM, JIRA,UNIX, Linux, AX 400, Service Center, SQL, Oracle, PL/SQL Developer, QTP,XML, AS/400, Share Point, Putty, Mainframe, ECIS, Web Services.

Confidential, Richardson, TX

Sr.QA Tester

Responsibilities:

• Worked on workman's compensation registration, classification, payment, injuries, claims, and act information.
• Captured the claim details
• Used MS Sql server Management studio for Creating & executing SQL queries fortesting the conversion & ETL process.
• Developed the Software Requirements Specification (SRS), the Test Plan, and all Test Cases for the proprietary Web application.
• Analyzing Data Processing implementingData Mart applicationsmainly transformation processes using ETL tool and understanding ofETL workflowsandETL mappingsand also monitoring the Production Environment.
• Wrote test plans and test cases using Quality Center and Excel.
• Involved in Functionality testing of the web Application.
• Participated in weekly updated status meeting along with project managers and Team Members
• Performed functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing and Smoke testing of the web Application, its interfaces and Client-Server Utilities
• Developed Test Scripts for manual testing and automated them using Win Runner, Load Runner and QTP.
• Wrote SQL Queries to access test database data.
• Performed functionality testing of all core functions of the application by functional and performance testing. Developed test plans and traceability index.
• Collaborated with management to gauge user functional requirements, enhancement requests, and project time line for application development and delivery.
• Working closely with Business Analysts, Developers, project managers and users. Participating in all project meetings to analyze and extract business requirements.
• Performed Business functionality testing, which involved testing of all core functions of the application.
• Usedcheckpointsto check the functionality in QTP.
• Automated all regression tests scripts usingQTPand generatedAutomationObject Model
• Conducted testing of Legacy and GUI applications in Windows XP and NT environments.
• Responsible for Manual and Automated Application testing: Functional, Performance and User acceptance testing.
• Developed test plans and traceability matrix.
• Responsible for Bug reporting and tracking using Quality Center
• Conducted Smoke, Integration, System, Regression and GUI testing.
• Opening, regressing, reproducing and resolving OS and test bugs.
• Identified the Test Cases for Performance as per the Client requirements and created the Test Cases in Quality Center.
• Used Quality Center to track and analyze defects.
• Interacted with the Project Manager and Developers to discuss the GAPS in the TESTING requirements.

Environment: Quality Center, Java Windows 98/NT/XP, UNIX, ETL, SQL Oracle 10gR2/11gR2.

Confidential, Denver, CO

Sr.QA Analyst

Responsibilities:

• Confidential provides the services for their potential customers through browser-based application.
• As a Quality analyst, I worked on web-based Work Flow management and Bill Management Systems dat are accessed by potential and new customers.
• The eligible customers were allowed to view detailed information of their account and services.
• Developed System Test Plan and Test Cases.
• Responsible for UAT, GUI and Web testing.
• Executed appropriate tests (some manually and some in QTP to ensure the application and integrating systems perform to the expected specifications and analyzed test results.
• Manually tested the applications functions before automation.
• Created Trouble Reports (Modification Request) for software defects on Quality Center.
• Organized, prioritized, tracked and controlled requirements using Requirements manager module.
• Reviewed and analyzed requirement document for writing the Test cases.
• Developed a Test plan based on testing requirements and created Test cases using Test Plan manager module.
• Involved in the creation and execution of manual test cases to facilitate both positive and negative testing.
• Worked with Manual and Automated testing of different Web applications on Windows and UNIX/Linux Environment.
• Tested Web Services through Soap UI.
• Integration Testing was done on all system components and internal and external interfaces to validate all the system components interface with each other and other systems accurately.
• Involved in various levels of testing including smoke test between various builds and patches.
• Conducted UAT (User acceptance testing) for the AUT (Application under test).
• Stored, analyzed and prioritized defects using Defects Manager module in QC.
• Developed different kinds of reports dat showed the number of test cases executed, number passed/failed and the number of test cases left to execute on a daily & also on a weekly basis.

Environment: Windows 98/NT/XP, Oracle, DB2, Quality Center, SQL Enterprise Manager, JAVA, UNIX/LINUX, AS 400 and DHTML/HTML.

Confidential, Minneapolis, MN

QA Analyst

Responsibilities:

• Attended the Business requirement meeting, and was given the Activity Diagram and FRD by the BA.
• Involved in Test plan review and execution. Attended Scrum meetingevery day
• Converted the test scenarios into Test cases Executed the test scripts manually.
• Documented details oftest plans, test casesandexpected resultsinQuality Center.
• Extensivelydocumented Test RequirementsandTest Plan using Quality Centerto track the stakeholders requested enhancements and changes.
• UsedSynchronization, Call function, Parameterization, Checkpoints, Regular Expressions to enhance testeffectivity also created reusable actions.
• Performed manual and automation tests on various modules usingpositiveandnegative scenario.
• Conducted Functional, Regression testing
• Reviewed and analyzed functional specifications
• Created test data to use while test execution
• Enhanced test scripts wherever necessary based on the functionality changes.
• Design detailed test cases for new features and future regressions
• Conducted Retesting once the defects were fixed.
• Analyzed theend-to-end functionalityby testing the application manually.
• Carried outsecurity teststo check dat only valid users could access certain sections of the site.
• Writing andreviewing Manual test casesandcustomizing Quality Centeras needed.
• Performed Back End testing of the database by using SQLqueries to verify data conversion and data repetition.
• Grouped Manual test cases in sets and scheduled them for execution usingQuality Center.
• Monitoredtest results, tracked defectsand communicated them using HP Quality Center.
• Actively participated in bug meetings with QA team and developers to discuss and resolve outstanding defects.

Environment: Windows, Quality Center, MS SQL, Oracle, PL/SQL, UNIX, Oracle, MS-Excel, ICD 10.