PROFESSIONAL SUMMARY

• 6+ years of experience in Quality Assurance/Software Testing and in writing System Test Plans, Test Cases, Documentation and in manual testing using Quality Center/Test Director for Web based applications, Client/server, Mainframe, DWH in domains like Healthcare, Retail, Mortgage.
• Experience in Writing System Test Plans, Test Cases, Test Scripts, SQL scripts, Documentation and Setting up Test Plan and Test lab Environments in ALM.
• Experienced in working with the QA methodologies and processes.
• Worked on Agile methodology, participated in Sprint meetings on daily basis.
• Conversant with all phases of Project Life Cycle including Requirement gathering, Analysis, Testing, Software quality standards, change management and Quality procedures.
• Created Test Scripts and Test Conditions to perform the Functional, Integration, System, and End - to-End testing of the application to ensure Requirements Traceability using Quality Center.
• Extensive experience in Black Box, Regression, Web Service, User Acceptance Testing, Database/backend and Smoke Testing.
• Proficient in developing and executing Test plans, Test scripts,verification, test result validation, and ensuring that the software meets the system requirements.
• Expertise in Web/Internet testing of HTML, DHTML, XML, JavaScript, VBScript, ASP, .NET, and Java applications.
• Experience in Backend testing using SQL Queries for Oracle and SQL Server databases.
• Experience in testing Service Oriented Architectures (SOA) and web services using SOAP UI
• Thorough understanding HIPAA Transactions & Code Sets Standards like EDI 820,834,835,837,270,271,276 etc.
• Extensive experience in testing Extraction, Transformation and Loading of data from multiple sources into Data warehouse.
• Experience in testing Business Intelligence reports generated by various BI Tools like Business Objects.
• Expertise in handling the entire QA process documentation using Quality Center.
• Well organized, creative and Team Player with proven ability to complete given tasks on time.
• Experience in defect identification, tracking, defect management using Defect/Bug Tracking System and technically sound in knowledge.
• Responsible for weekly status meetings showing progress and future testing efforts.
• Strong analytical and communication skills with capable of working efficiently under stress and tight deadlines.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile.

Testing Procedures: Black Box, White Box, Unit, Functional, Integration, System, Regression, Smoke, Acceptance, User Interface, Database, Datawarehouse/ETL, BI/Reports Web Services testing and UAT.

QA Tools: HP ALM, HP QC, MQC, Team Foundation Server(TFS),Microsoft Test Manager (MTM), JIRA, Bug Tracker (Bugzilla, Confidential Process)

Programming Languages: Java, J2EE, .Net

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, Linux

RDBMS: Oracle 10/11.x, MS SQL Server, Teradata, DB2

Database Tools: SQL *Plus, SQL Query Analyzer, AQT and TOAD

Web Browsers: Internet Explorer, Netscape Navigator, Fire Fox

Web Servers: MS IIS, Java web server, WebSphere, WebLogic

Web Technologies: HTML, DHTML, XML, Java Script, VB Script

Web Services: SOAP UI 3.5.1, XML

ETL and Reporting Tools: Business Objects, Cognos, Informatica, DataStage

Mainframes: COBOL, DB2, TSO/ISPF, CICS, JCL, MVS, File-Aid

PROFESSIONAL EXPERIENCE

QA Analyst

Confidential

Responsibilities:

• Responsible for gathering and analyzing business and system functional requirements and for understanding and translating these needs into testing requirement documents
• Responsible for updating/writing test cases in conjunction with business requirements as a result of changes induced due to Defects or CRs
• Created test cases, test plan and test Scenarios to validate data from Jesta.
• Performed all aspects of verification, validation including functional, regression and system testing
• Prepared Test Data and scripts for UAT Testing
• Study of detailed requirement of end users of system & their expectations from Applications and systems.
• Studied and understood the Data warehouse, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Ran SQL queries to verify the number of records from Source to Confidential and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications
• Validated Source - Confidential mappings applying various transformation rules and Business Rules.
• Wrote complex SQL s to validate Confidential data based on the business requirements.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings
• Checked the naming standards, data integrity and referential integrity.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Submitted Status and Test Evaluation Reports to Project Lead on daily basis and constantly updated test deliverables.

Environment: Agile, HP Quality Center (ALM11), VB.NET, ASP.Net, Web services, SOAPUI, XML, AQT, Informatica, Cognos, JESTA, Oracle, Toad, UNIX.

Confidential, MN

QA Analyst

Responsibilities:

• Attended daily stand up scrum meeting to provide updates to the team.
• Provided estimates on user stories and daily updates to the managers based on the data requests and execution metrics.
• Created Test Plan for various Client Implementations.
• Created Test scenarios and Test cases for different user stories using Quality Center.
• Performed functional, integration, system, regression and smoke testing
• Performed UAT and presented the results to business.
• Created plans and Member Pay IDs in Rx-Claims system.
• Verified correctness of data after the transformation rules were applied on source data.
• Validated Source - Confidential mappings applying various transformation rules and Business Rules.
• Tested Request and Response for the services built for BPW application in support of managing Rx-Claims Plans and different attachments using SOAPUI tool.
• Provided Test Metrics, status reports, and schedules to the management as necessary.
• Created Defects and tracked resolution using Quality Center.
• Retested the defects after each build to ensure application is functioning as expected.
• Supported SQA team by providing directions, mentoring and training to new team members.

Environment: Agile, HP Quality Center (ALM11), Java, J2EE, XML, JUnit, Web services, SOAPUI, AQT, Data Stage, Business Objects, IBM AS400, DB2, Excel, Word.

Confidential, MN

QA Analyst

Responsibilities:

• Studied the user requirements prepared by the client business and technical users to evolve the technology architecture for the project.
• Worked with the team of 5 onsite and 10 offshore members for manual testing execution and defect management process
• Wrote test cases based on the user stories from product backlog and high level design documents.
• Participated in Sprint Planning and Sprint Review meetings.
• Participated in daily SCRUM/stand up meetings to report any issues and risks
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate Confidential data based on the business requirements.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings
• Write SQL queries to validate that actual test results match with expected results
• Check the naming standards, data integrity and referential integrity.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Tested Web Services using SOAP UI tool by creating test XML’s with expected data and verified the responses in SOAP UI as per the business requirements.
• Defects tracking, review, analyze and compare results using Quality Center.

Environment: HP Quality Center (ALM11), Java, J2EE, XML, JUnit, Web services, SOAPUI, Data Stage, Business Objects, Oracle 9i, Tera Data, SQL, PL/SQL, TOAD, Windows 2003/2000/XP.

Confidential, TX

QA Analyst

Responsibilities:

• Design & Executed Quality test plans & cases to verify reliability, accuracy & compatibility of application
• Responsible for testing Web based applications, executing and documenting functional, regression, and integration test scripts
• Integration testing, Functionality testing & Performance testing is done manually as per HIPAA (Health Insurance Portability and Accountability Act)
• Managed requirements and creating traceability in TFS.
• Designed the Data for interpreting the Positive/Negative results.
• Developed test cases from business and functional requirements.
• Tested HIPAA Transactions & Code Sets Standards like 837 (professional and Institutional)
• Validated HIPAA Transactions like 820, 834, 835, 837i, 837p for errors and omissions.
• Performed creation and verification of test cases to verify data with DB2 database.
• Used TFS for managing the overall testing effort to define and store information about test documents, requirements, scripts, schedules and sessions.
• Written SQL scripts in QMF to validate backend data.
• Used MTM for Tracking the Defects.
• Interacted with developers & various team members to discuss/ resolve defects with their priorities.
• Tested web services based interactions between servers and web application using SOAP UI tool.
• Performed database testing using SQL and developed SQL Queries for backend testing Healthcare Billing application.

Environment: Water-Fall, Team Foundation Server(TFS),Microsoft Test Manager (MTM), VB.NET, ASP.Net, XML, SOAP UI, Oracle, DB2, SQL, TOAD, Mainframes (IBM - Anchor, Rumba), CICS, JCL, File Manager, TSO/ISPF, IBM utilities, QMF for windows and MS Office.

Confidential, TX

QA Tester

Responsibilities:

• Created detailed Test plan, Test Scenarios and Test cases according to the business requirements, participate in walkthroughs and coordinating with other teams.
• Created close ties with designers and software developers to understand application functionality and navigational flow
• Participated in developing High level test scenarios and then created detailed Test Scripts which maps to the technical requirements
• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Involved in writing and execution of test cases using the Mercury Quality Centre 11.0 and spreadsheet.
• Used Rational Clear Quest as a defect-tracking tool to report application defects and enhancements request and discussed with developers to resolve technical issues.
• Documented, tracked and communicated test plans, test results, analysis, and unresolved defects.
• Performed different types of tests like Integration, Functional, Regression, Smoke and Performance testing.
• Extensive experience in planning for Project Deployment validation and support the development team to test quick fixes if any issues encountered while implementation.
• Worked closely with QA analysts of other applications to perform integration testing.
• Used SQL queries Extensive to perform Back-end testing on the database views for various functionality.
• Tested Web Services using SOAP UI tool by creating test XML’s with expected data and verified the responses in SOAP UI as per the business requirements.

Environment: HP Quality Center, AS400, VB.NET, ASP.Net, COBOL, SQL Server 2005/2008, SQL Query Analyzer, QTP10, XML and SOAP UI 3.5.1.