Summary

• Over 7 Years of experience as a QA Analyst in analysis, design and automated testing of Client/Server, Data Warehousing and Web-Based Applications.
• Actively participated in all the stages of the Software Development Life Cycle and Testing Life Cycle.
• Proven skills in automating the test scripts for the System testing and Regression.
• To obtain a challenging position in fast paced environment in the field of Software Quality Assurance and EDI Analysis that would best utilize my technical and interpersonal skills.
• Excellent in analyzing Business Requirements Specification, developing Test Plans, Test Cases and Test Scripts.
• Hands on experience with all phases of Software Development Life Cycle SDLC .
• Worked on different QA Methodologies such as Agile, Waterfall, and RUP.
• Well versed with all the Testing concepts and methodologies.
• Experience with creating and implementing Requirements Traceability Matrix RTM .
• Skilled in GUI testing, Functional Testing, Regression Testing, Integration Testing and User Acceptance Testing, Oss/Bss Testing.
• Experience in HIPAA EDI transactions 837 Institutional/Professional , 835 Payment Remittance Advice 270 Eligibility Request / 271 Eligibility Response , 276 Claims Status Inquiry Request / 277 Claims Status Inquiry Response , 834 Benefit Enrollment and Maintenance Transaction , 278 Prior Authorization , 997 Transaction Acknowledgement .
• Working knowledge of ANSI X12 EDI transactions.
• Working Knowledge of ICD-9, ICD-10 and CPT diagnostic codes.
• Developed SQL queries using joins and sub queries to test data tables against the source and target and to validate data and verify.
• Business knowledge of Group, member, provider enrollment, HL7, Medicaid/Medicare member eligibility, Benefit Plan enrollment, and MMIS.
• Participated in design reviews with the Development team.
• Self-starter and ability to adapt and learn new things quickly.
• Excellent Communication and Documentation Skills.
• Good Process Management and organizing skills with remarkable ability in gathering requirements to bring out quality products

Technical Skills

Professional Experience

Confidential

Migration Consultant

Responsibilities:

• Experience in implementing LOG files to debug Test Director and SQL trace for DB checkpoints.
• Experienced in setting parameters for Site Config and in developing and using API s .
• Extracting the data from different databases SQL Server, MySQL and Oracle using complex queries.
• Writing Stored Procedures and functions to retrieve the data according to the client requirements
• Performed script Migration from development to testing and testing to production systems.
• Performed tasks of executing, scheduling and validating the sessions in Informatica workflow manager.
• Performed Network testing of Opelin telecommunication tool.
• Involved in preparing test plan and test cases during various phases of the product life cycle.
• Created Entity Relation diagram for data base analysis. Involved in Database Testing using SQL Queries.
• Ran the SQL queries to check that database was updated as per the inputs provided by the user.
• Analyzed the legacy defect tracking tools and its fields and its functionality.
• Created and customized user accounts of quality center user's.
• Wrote stored procedures, functions and queries by using Toad to extract the data and do conversions from legacy database in a format that can be imported into QC.
• Involved in setting up user permissions /privileges and QC 9.2 database maintenance.

Environment: Windows 2003 Servers, Unix, Quality Center 9.2, MYSQL, SQL 2000, Oracle 10g, Informatica Power Center 7.1, Windows XP, Oracle 9i, DB2, PL/SQL, SQL Server 2000, Flat files, UNIX shell scripting

Confidential

Quality Analyst

Responsibilities:

• Worked closely with Business Analysts to understand and analyze the requirements.
• Reviewed test strategy for the application and various Test plans and Test cases.
• Extensively tested the GUI components and conducted Functional and Regression testing for each build.
• Responsible for tracking defects using Test Director and made sure those defects are efficiently passed from one layer to another.
• Conducted black box testing to conclude the application works based on the requirements.
• Experience with HP Quality Assurance / ALM Tools Support, Administration, Patches and Upgrades.
• Responsible for performing system integration testing.
• Conducted Data validation testing using SQL queries.
• Reviewed computer logs Unix logs Scripts , reported program processing errors identified using
• UNIX shell scripts, SQL queries, joins and possible improvements.
• System testing, Regression testing for Oss/Bss System.
• Analyzed test results and defect data, reported on the status of projects, provided ideas for improvement, recommended process improvements, worked well with engineering teams both S/W and H/W .
• Designed and executed the automation scripts for regression testing.

Environment: Oracle 8, J2EE, ASP, VBScript, Dreamweaver, HTML, XML,Windows2000, UNIX, MS Excel, SQL, TOAD, Quick Test Pro, Test Director

Confidential

QA Tester

Responsibilities:

• Involved in creation of work products in all phases of SDLC and TDLC
• Reviewed the Requirements documents for 4010/5010 ANSI X12 Transactions and created the Test plan and test cases for 837I/P/D,835,276,277,270,271,834 HIPAA EDI Transactions for Iteration Testing, Integration Testing and System Testing.
• Reviewed the Requirements document for 5010 and prepared the test plan and test cases.
• Involved in Manual Testing of the application.
• Conducted functional, system, data and regression testing.
• Interacted with the Developers and BA for defects and problem resolution
• Wrote SQL statements to extract data from Tables
• Worked with transactions and validated the data by using SQL.
• Generated Bug Reports and Test case coverage reports for status meeting and also involved in resource planning for test cases coverage
• Involved in Bug Review meetings and participated in weekly meetings with management team.
• Provided testing results and weekly status reports to the QA Manager
• Tested the HIPAA EDI Transactions 837I/P/D, 270/271, 276/277, 835,834 for 5010
• Involved In loading the flat files into Oracle Database and involved in writing SQL Queries.
• Involved in writing Complex SQL Queries using TOAD to validate the loads.
• Validated the data on web screens against the data points and database.
• Validated the Cognos reports for Provider Portal and validated the data against the Database.
• Validated the data on screens against the database

Environment: XML, SQL, MS Excel, MS Word, MS Access, UNIX, IAS Web server, Web logic, Oracle, TFS, DB2,VB Script, TOAD, Lotus Notes6.5, .Net, e Docs, Quality Center, QTP.

Confidential

Sr. QA Analyst

Responsibilities:

• Drive the completion and complete alignment of system design from business requirements and architectural design.
• Track, drive and coordinate program development activities, per requirements and design, with Business owners, IT PMO, and IT Development teams across US and EMEA.
• Document and analyze business requirements, functional requirements, system capabilities, and detailed design.
• Tested HIPAA Gateway Application Interface for all inbound and outbound messages Healthcare Eligibility 270 and 271, Healthcare Claim Status request 276 and 277, Healthcare Claim 837 and 835
• Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
• Ensure consistent and effective communication among all parties.
• Proactively identify and resolve issues by working with all portfolio teams
• Create and publish periodic executive reports.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.
• Written smoke test cases in Quality Center and modified them when they are automated.
• Prepared and executed test cases for Navigational test, Functionality testing and GUI testing using Test Director.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Created requirements analysis and design phase artifacts using, Rational Software Modeler and MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.
• Managed Scope and change throughout the SDLC process of the product.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Conducted Black Box Testing on the application and validated the dataflow in the application.
• Tested security test and audit test for this particular system. Performed Black Box, functional testing, end to end testing for world points system
• Involved in creating logical and physical model of the database using MS Visio, MS SQL Server 2008.
• Manually tested the whole application before going for the automated testing.
• Involved in testing the conversion of the application into web application using XML web services.
• UAT testing performed along with call center managers to make sure that application meets their requirements.

Environment: Java, Business Object, Quick Test Pro 8.2, Mercury Quality Center, J2EE, UNIX, XML, Sybase, SQL, PL/SQL, Oracle9i, MS Vision, MS Office, Quality Center 10, QTP, DB2,Crystal Report, Bugzilla, Microsoft SharePoint

Confidential

QA Tester

Responsibilities:

• Created Test Plans, Test Cases from Requirement Specifications and created various negative and positive tests.
• Analyzed technical design and functional documents to determine requirements.
• Worked with Business Analysts to understand the functionality of the application.
• Participated in test case review meetings with the business owners and developers to ensure all business scenarios and test conditions are captured.
• Responsible for conducting Bug Triage Meetings and generating Testing Status
• Reports and Manage defect logs, monitor issues and risks.
• Support Business Users in conducting UAT Testing by ensuring all UAT Documentations are complete and support the business users in developing the UAT Test Plan and establishing testing scope.
• Used Quality Center for Test case Designing, Test Analysis, Test Execution, Defect Tracking and Test Evaluation.
• Responsible for testing custom reports and Performed Back-end testing using SQL Queries.
• Involved in verifying the process, exception and error output UNIX logs.
• Involved in testing CR's for Invoices, Post Enrollment Kit and NY SPAP for UA with Facets.
• Responsible to perform various tests like Integration testing, Regression testing, Functional testing, and User Interface testing.
• Participated in various meetings and discussed Enhancement and Modification Request issues Change Requests .
• Worked with the developers to make sure the defects are fixed and re-tested.
• Worked on Agile methodology.

Environment: Facets 4.31, UNIX, Win NT, Quick Test pro, Quality Center, Win Runner, QTP, MS - Office Tools