Professional Summary

Above 7 years of professional experience in Quality Assurance and Software testing. In depth knowledge of Software development life cycle, testing methodologies. Proficient in System, Functional, Regression and Performance testing of Client/Server and Web Based applications. Hands-on experience with diverse testing tools like Quality Center (Test Director), QTP.

Specific Expertise

• Experience in full Software Development Life Cycle (SDLC) and Methodologies and Validations to ensure the Quality Assurance Control.
• Strong analytical and QA/ testing skills, capacity for work and diagnostic ability.
• Covered Agile and Waterfall models of SDLC
• Expertise in Analyzing Business Specifications and develop Test Scenarios, Test Cases and Test Scripts and execute them.
• Expertise in Manual and Automation Testing.
• Test Case analysis and design, Test Script development and Test Coverage.
• Test Summary Reports and Defect Tracking.
• Defect tracking and change management using Quality Center.
• Experienced on Integration Testing, System Testing, Functional Testing, Regression Testing, Database testing, User Acceptance testing and End-End Testing.
• Experienced in web service testing.
• Experienced in sales force testing
• Expertise in Agile methodology.
• Experienced with Visio in order to create diagrams
• Experienced in testing java based applications
• Good exposure with Share point
• Knowledge on java script and html
• Experienced with Black Box testing
• Experienced on writing the queries.
• Well experienced in test planning, documentation, defining and executing the Test cases using automated tools as well as Manually.
• Strong hands on experience in testing Commercial Websites and Business Applications.
• Specialized in testing Character-Based, Web, GUI (Graphic user Interface) networking and On-line client server GUI applications.
• Strong experience in interacting with developers to analyze the user requirements, functional specifications.
• Excellent communication, interpersonal, intuitive and analytical skills.
• Proven ability to work efficiently in both independent and team work environments.
• Experienced in End – End testing.

Technical Skills

Testing Tools Quality Center 9.0/8.2, Test Director8.0/7.6, Quick Test Pro 9.0/8.0/6.5, T- Plan Professional, Soap UI 3.6 for web service testing.
Bug Tracking Tool Team Foundation server, Test Director, Quality Center. 
Platforms MS-DOS, Windows 95/98/2000/NT/XP, Unix
Languages C, C++, Java, VB Script, TSL, Visual Basic, .Net, SQL, PL/SQL, ASP 
Internet Technologies VBScript, JavaScript, XML, HTML
Database Technologies Oracle 8i/9i/11i, MS-SQL Server 2000, MS- Access.
Others MS-Word, MS Excel, MS-PowerPoint

Education

Bachelor of Engineering,
Electronics and communication

Professional Experience 

Confidential, Richardson, TX Nov 11 – Till now
QA Lead

Project1: HDAP Transaction Report 
This report is a semi-monthly transaction report showing the transactions that have occurred between the 1st and 15th of the month (processed on the 16th of the month) and then from the 16th until the end of the month (processed on the 1st of the next month).

Project2: COB file loading
Client will send incoming eligibility and COB files based on the member ID corresponding to COB record in incoming eligibility the data is updated with the COB data.
Responsibilities:

• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, Detailed Design Documents.
• Involved in entering requirements, designing the test steps, writing test cases and running test scripts using Test Management Tool Quality Center
• Worked on PBM domain.
• Used Agile methodology.
• Documented test cases and expected results
• Created the Carrier, Account and Group in the AS400
• Created the Plan and attached the plan to the group.
• Submitted claims in AS400.
• Ran the extract to pull the claims to QA environment.
• Ran the CET profile twice for the month for testing in AS400
• Worked with MBRPDM to see the report for the particular profile.
• Used commands like STRSQL to check the data in the database
• Worked with the Objects (WRKOBJ)
• Added libraries by using EDTLIBL command.
• Performed screen level testing and functional testing
• Validated the file layout.
• Validated the fields, length and positions in the layout.
• Performed database testing using SQL, executed various DDL and DML statements
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the.

Involved in writing SQL queries.

• Used share point in order to share the documents.
• Created tasks using TFS for each sprint.
• Identify, log and follow-ups on all defects found during testing by using TFS.
• Retested the bugs which are fixed and closed in TFS.
• Worked on multiple projects.
• Coordinated the offshore and participated in the business meetings like walkthroughs for the TC and TR approvals.

Environment: Quality Center 9.5, AS400, Microsoft Team foundation server, SQL, Share Point,

Confidential, AZ Jan 10 – Oct 11
Sr. ETL Tester

Confidential delivers high-quality, affordable health care services That means utilizing the most advanced medical technology. It means clinical expertise, by way of the nation’s top doctors and nurses. It means working closely with patients so that they can lead healthy, meaningful lives. The project involves Upgrade to clinical application “AllScript”. AllScripts application uses .net/infragistic net advantage v 2006 vol 1.

Confidential delivers high-quality, affordable health care services in a compassionate environment that meets each patient’s physical, mental and spiritual needs. AtCatholic Healthcare West (CHW) a family of more than 60,000 caregivers and staff are delivering excellent care to diverse communities across Arizona, California and Nevada. CHW core IT business is dealing with electronic health transactions and record, the project mainly involved validating and implementing Siemens Medseries4 application to be HIPAA 5010 Compliant.

Responsibilities:

• Gathered all requirement documentations; analyzed high level business requirement documents for Electronic Health Record (EHR) projects
• Created test scenarios and test cases for AllScripts (EHR application for various providers)
• Generated reports in HP ALM QC 11.00
• Used SQL on Toad platform to perform Backend Testing on databases.
• Imported requirements, test scenarios and test cases from MS Excel/ MS Word to HP ALM QC 11.00
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Normalize, Update strategy & stored procedure transformation.
• Creating test cases and test planning to verify the workflow of transactional, Data warehouse databases, Data Migration, BI Reports, Micro strategy reports, mapping, and ETL processes in SQL Server at mainframe level.
• Excellent knowledge in Data warehouse methodology, modeling, mapping, and ETL testing, BI report testing, Mainframe
• Involved in creating the design and technical specifications for the ETL process of the project.
• Worked with Data Warehousing developers who extensively used Informatica, ETL tools to design mappings to move data from source to target database-using stages to understand the functionality
• Used HP Quality Center for organizing Requirements, Test Cases and Defects.
• Extensively used UNIX commands and also used SQL queries to extract data from the target tables to prove the data mapping
• Quality Center used as the engine to drive the regression suite across every build.
• Worked with Quality Center Admin in customizing fields for Users.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Assisted Quality Center Admin in creating Users, Domains and their access levels.
• Involved in entering requirements, developing test plan tree, designing the test steps, writing test cases and running test scripts using Test Management Tool Quality Center.
• Exported test cases and requirements from MS Excel to Quality Center
• Conducted Data Validation checks by comparing the UAT backend Database and the Production Database
• Extensively done Backend Manual testing
• Used SQL on UNIX platform to perform Backend Testing on databases.
• Developed test scripts for Acceptance test, Maintenance test and Regression tests and executed them.
• Created traceability matrices for test scripts, test data and the defects to monitor the execution status.
• Created Test Plan and Test Cases for all the enhancements made and production defects for both the system in the period which supported for these systems based on the Technical Design Document and Requirements Specification Document.
• In depth understanding of Unit, Functional, Integration, Regression, User Acceptance, System, White Box & Black Box Testing.
• Maintaining a close relationship with all the stakeholders involved in the project.
• Responsible for test execution, evaluated test results, and follow up with testing team on resolutions.
• Created Test cases by taking input from Business Analysts and Technical Manager.
• Tested the feeds regarding the functionality and Performance manually.
• Execution of Test plan, Implementation Plans & identified areas for process improvement of workflows, mappings in Informatica Power Center.
• Logged in to defects using Sprinter in HP ALM QC, tracked defects and created standard defect reports for higher management
• Supported test leads and project managers in recording and tracking defects during the test life cycle using HP ALM Quality Center 11.00
• Supported test leads and project managers importing requirements, test cases, defects from MS Excel to HP ALM QC 11.00
• Supported test leads, and testers in execution of test plans using HP ALM QC 11.00
• Involved in testing all phase of end to end testing such as UAT, Functionality, Regression, and HIPAA 5010 TCS testing.
• Worked with Data Warehousing developers who extensively used Informatica, ETL tools to design mappings to move data from source to target database-using stages to understand the functionality
• Validated patient information / demographics in Cerner and MIRA using QTP scripts
• Validated diagnostic codes and clinical information in Med Series 4 (MS 4) application
• GeneratedMS4 command queriesto validate the library files in the MS4.

Environment: Quality Center 11, QTP 11, VB Script, ActiveX, ASP.NET, ADO.NET, C#, Window Xp, Informatics Power center 8.6 MS Excel, MS Word, Infragistics Test advantage version 6.1,Sql Server 2008,Toad

Confidential, MN Jan 09 – Dec 09 
QA Analyst

Confidential is a diversified financial services company providing banking, insurance, wealth management and estate planning, investments (fixed income, bonds, mutual funds, securities etc.), mortgage and consumer finance. The US Equity Online Brokerage Application allows the customer to view the account status, asset allocation chart, order status, account holdings and current market indices. The application also enables him/her to trade online.

• Involved in the complete testing lifecycle spanning pre-testing phase, acceptance-testing phase and also in user acceptance testing.
• Involved in entering requirements, developing test plan tree, designing the test steps, writing test cases and running test scripts using Test Management Tool Quality Center
• Documented test cases and expected results
• Ensured the appropriate parties review and sign-off on test cases prior to test execution
• Exported test cases from Excel and requirements from MSWord to Quality Center
• Involved in smoke testing and System testing
• Tested manually the various navigation steps and basic functionality of the application.
• Created positive and negative testing scenarios and tested them manually as well as using automated scripts.
• Log the defects using TFS
• Tracking and closing the defects by using TFS
• Manually executed the test cases and logged the defect in Clear Quest.
• Creating and closing tasks for sprints by using TFS
• Used share point to see the documents related to QA and project documents
• Conducted Functionality testing during various phases of the application
• Tested web services
• For regression testing used QTP
• Imported and exported data from and to Excel to and from QTP
• Used Parameterization in QTP extensively to perform Data-Driven testing
• Performed browser compatibility testing using different browsers like IE, Fire Fox etc
• Performed database testing using SQL, executed various DDLand DML statements
• Created Database Checkpoints in QTP for database testing
• Regularly interacted with Developers to discuss various problems and issues

Environment: Quality Center 9.2, QTP 9.5, Share Point, Agile, VB Script, Microsoft team foundation server, SQL, Java, SQL, HTML, XML and Unix

Confidential, Pittsburgh, PA
QA Analyst Mar07 - Dec 08

Description: Confidential is a highly Diversified and Growing Financial Services Organization spanning the Retail Business and Corporate Markets. PNC provides everything from Personal Banking Services to Wealth Management, Business Banking and Corporate & Institutional services for Organizations all over the World. The Project involved various types of Regression, Functional and Integration Automated Testing operations on the PNC Store Vision Teller application. Major application builds are released on a quarterly basis every year and Minor releases occur every week 

Responsibilities:

• Created test cases, test scripts as per the Business requirement documents
• Integrated Quality Center with Quick Test Pro maintaining the Test cases and Scripts.
• Used Quality Center for gathering Requirements, creating Test Plans, Test execution and for reporting defects.
• Performed functional, smoke, Usability, Comparability and Regression testing.
• Inserted Check Points to check for the broken Links, Text, and standard properties of an object using QTP
• Used Descriptive Programming extensively creating Description Object
• Responsible to convert the manual test cases into Test Scripts and execute them using QTP
• Worked with Object Repository to configure mandatory and assistive properties
• Involved in planning and creating Test scenarios and Test objectives to ensure that the system modification will meet the specified business requirements.
• Performed Conditional and Looping features of VBScript heavily
• Developed SQL Queries for Back-end testing/Database testing.
• Maintained test matrix and bug database and generated monthly reports.
• Performed Regression testing to ensure no new unintended defects were introduced.

Environment: Quality Center 8.2, QTP 8.2, MS Office, Java, Soap UI 3.0, JSP, J2EE, XML, Toad, UNIX