SUMMARY

• Over 10+ years of experience in Software Quality Assurance with exceptional analytical, troubleshooting and problem solving skills in Client/Server, Data warehouse and Web based application.
• Domain expertise: Mortgage (Lending), Banking (Credit Cards), Insurance, Healthcare Claims and Telecom Billing, Government, CRM.
• Strong knowledge of Secondary Mortgage applications.
• Extensively involved in User acceptance testing for mortgage fulfillment Applications.
• Knowledge of health information and health care services regulatory environment including HIPAA, Medicaid/Medicare, EDI and XML.
• Medical Claims experience in Process Documentation, Analysis and Implementation in 835/837/834/270/271/277/997 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side.
• Well versed in all the Phases of SDLC (Waterfall, Agile Scrum) and Software Testing Life Cycle (STLC).
• Experience in Manual, Automated - testing tools such as QTP, Quality Center/Test Director, Jira, Clear quest, ClearCase, Requisite pro, Rational Manager,RQM,Rational functional tester.
• Experience in creating test plan, test cases, and test scripts, test metrics test strategies.
• Involved in drafting and testing the change management components for application.
• Performed all types of testing (functional, black box, system, integration, UAT, compatibility, load, stress, performance, regression testing, white box and scalability, compatibility).
• Experienced in Requirements coverage analysis and Traceability Metrics.
• Adept in Backend Testing and Data Integrity testing using SQL statement.
• Proficient in using Quality Center for Defect Logging and Tracking
• Experience with ASP, VB, XML, Java, .Net, CRM and Web Services.
• Extensive experience with AMDOCS.
• Performed web services testing with Valium and SOAP UI.
• Involved in the ETL processes where in the organizations were using Datastage, Autosys tools.
• Strong experience in testing ETL Datastage, ETL Test Plans, Test Cases, Test Results reviews and Reports, Status reports.
• Involved in ETL Testing using ETL Tools and validating the batch jobs inETL run during system, integration and acceptance test runs.
• ETL/Extract/Reporting test cases as per best DWH industry testing practices.
• Strong analytical and problem solving, interpersonal, communication skills, self-starter, Ability to multi-task fast learner and able to adopt new technologies as needed in rapidly changing Agile.

TECHNICAL SKILLS

Testing Tools: QuickTestPro, Rational Manager, Rational Robot, Selinum IDE/RC/Core, WinRunner, LoadRunner, ClearCase, Requisite pro, Rational Manager

Defect Tracking Tools: Quality Center, Clear Quest, PVCS, STARTEAM, Jira

Scripting Languages: TSL, VBScript, JavaScript

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

Database: MS SQL Server, Oracle, Teradata, My SQL, DB2

Languages: HTML, SQL, XML, C, Java, Shell Programming

Net work Protocols: TCP/IP, HTTP, HTTPS, VPN, FTP, LDAP

ETL/DW Tools: Infomatica, Datastage, Crystal Reports, Business Objects

Data Modeling: Erwin, Visio

Project Management: MS Project, Excel

Others: MS Office, Remedy, Toad, SQL Navigator, SQL Assistant, Nexus, Share Point

PROFESSIONAL EXPERIENCE

Confidential, Dearborn MI

Sr.QA Analyst/ Coordinator

Responsibilities:

• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Attending the client calls and updating the status of the Testing status.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Executed Manual test cases using RQM.
• Used Clear Quest for Bug tracking.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed the ETL mappings to ensure the transformation rules are applied correctly.
• Created and executed SQL queries to perform source to target testing on DB2 database.
• Performed the following tests:DATA COMPLETENESSVALIDITY, UNIQUENESS, DATA INTEGRITY, DATA TRANSFORMATION, DATA QUALITY and INITIAL AND INCREMENTAL LOAD TESTS.
• Coordinated with different users in UAT process.
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Worked on UNIX Shell wrapper scripts
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• Worked on issues with migration from development to testing.
• This project is developed on Agile Methodology.

Environment: Ascential DataStage 8.5, Ajile,Teradata, Oracle, Agle,Clear Quest, RQM,MS-SQL Server 2000, SQL, Shell scripting,PL/SQL,Toad,Autosys.

Confidential, Addison TX

Sr.QA Engineer

Responsibilities:

• Worked as Sr QA Engineer on mortgage (Home Loans in my team, like training my co-worker, sending the status report to my manager in my team for critical issues communicated with the developer and business Analyst.
• Reviewed business/functional, LLD, HLD and Use Cases requirements and technical specifications of the application and developed Test Plans, Test Scenarios and Test cases.
• Tested Confidential Retail/Wholesale Business Channel, a web-basedmortgage-processing application with Mercury Tools.
• Developed and communicate project/task estimates and project plans.
• Was involved in New Build (SWAT Approval) Approvals.
• Performed Functional testing, Regression testing, Ad -hoc testing, Negative testing, End to End testing,
• Involved in User Acceptance testing (UAT), SIT (System Integration) and CIT (Component integration Testing).
• Involved in white box Testing and smoke testing.
• Mapped Test Cases to Requirements (tractability Metrics) in QC.
• Wrote Test Scenarios, Test cases in excel sheet and mapped/imported them to Quality Center.
• Coordinated efforts between product development teams and offshore test team
• Involved in testing Web services using with VALIUM’ and Log Minor.
• Used Oracle expresses Edison 2005 to verify Cheetah database.
• Executed PL/SQL (stored procedure) to test CSDB.
• Validated XML file.
• Involved in execution and Reported defects in QC and assigned to developers.
• Involved in working with EDGE branch servers (FoxPro tables) while run Lppatches and Analyze Lppatch.Logs.
• This application developed on waterfall methodology.
• Attended Status Meetings, Query Log Meetings and project Release meetings.
• Coordinated migrations to QA and Production following Production Control processes.
• Worked with the User Group to document the requirements after analyzing and finding gaps in them.

Environment: Applications/Languages: MS - Excel, PL/SQL, Oracle express Edison, FoxPro, Quality Center, Power Point, .Net and Java, VALIUM, LogMinor. MS SQL Server 2005, VB.NET, ASP.NET, XML, waterfall methodology.

Confidential, Sacramento, CA

Sr. Test Engineer

Responsibilities:

• Reviewing and Updating of Product Backlogs, Sprint Planning meetings, resource planning, Retrospective’s, Backlogs meetings, Daily stand-ups, project executing, controlling and monitoring sprints using Version1
• Involved in manual, automation.
• This project is developed on Agile Methodology.
• Reviewed the user requirement document and participated in preparing the detailed test plan and test cases.
• Created test data and Executed 3 iterations manually.
• Used HP Quality center to execute functional scenarios, bug reporting and bug tracking and view and integrate requirements (tractability matrix).
• Attended Change Request meetings to document changes and implemented procedures to test changes.
• Created automated steps for the update order component in business process testing (BPT).
• Handled parameterization in QTP while creating data tables, manipulate data sets and created multiple test iteration.
• Conducted System tests to verify the existing functionalities
• Created scripts for data driven tests to check how application performs with different sets of data.
• Participated in regression testing of the modified build.
• Functions to make the scripts reusable in QTP.
• Developed scripts to test and handle dynamic objects or Regular expressions.
• Involved in User Acceptance Testing with end users.
• Performed web services testing using with SOAP UI.
• Involved in Test reports Documentation.

Environment: Java, HP Quality Center 9.2,QTP 9.5, XML, SQL,Agile, TOAD, C, Agile, SOAP UI, Scrum, UNIX, XML, Shell scripts, Websphere.

Confidential, Madison, WI

Sr.QA Analyst

Responsibilities:

• Analyzed the Business requirements and the site specifications.
• Reviewed the User Requirements Document and participated in preparing the detailed Test Plan and Test Criteria.
• Involved in writing Test Scenarios, cases, Test conditions for various functionalities of application.
• This project developed on Agile and scrum.methdalogy.
• Worked on Medicaid and Medicare system.
• Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
• Involved in testing EDI transaction mainly focused on 834, 824, 837 and 835.
• Involved in testing in-Bound Transactions (837,276,834) submitted through Data-Exchange gateway.
• Involved in Testing Out-Bound Transactions (835 Health care claims Payment, 277 Claim Status Response, 824 Error Reporting).
• Involved in Processing 837 Healthcare Claims and 276 Health Care Claim Status Requests (276).
• Participated extensively in the Claims Testing Phases like Online Screens, Resolution Screens, Adjustment/void functionality / Mass Adjustment functionality.
• Used Rational Manager to execute functional scenarios.
• Used Requisite pro for requirement management.
• Also Used ClearCase for version control.
• Involved in bug reporting and bug tracking using Clear Quest.
• Participated in Regression testing of the modified build.
• Involved in Extensively User Acceptance Testing with validations and verification.

Environment: Java, JavaScript, HTML, DHTML, Oracle, EDI X12N 4010, Clearcase, Rational Manager, Requisite pro, Agile/scrum, Clear Quest.snagit, XML.

Confidential, Raleigh NC

QA Analyst/Tester

Responsibilities:

• This project is developed on Agile Methodology.
• Reviewing and Updating of Product Backlogs, Sprint Planning meetings, resource planning, Retrospective’s, Backlogs Grooming meetings, Daily stand-ups, project executing, controlling and monitoring sprints using Acunote.
• Created test plan and test cases.
• Performed manual testing (functional, system,compatabilty and performance testing)
• Used HP Quality Center to house all test documentation and report/track all issues and defects.
• Worked closely with development team to discuss the design and testing aspects of the applications to design the test plan and created and maintain well-defined test cases for ETL testingusing HP Quality Center (QC)
• Tested complexETL dataloads and the data flow logic betweeninterfaces.
• UsedDB2 toolto extract data and verify database schemasand updated the schema by executingSQL queriesfordata manipulation.
• Database Connectivity testing.
• Tested objects in the Universe to ensure the correct mapping of the objects.
• Tested the Universe Structure to ensure that tables are properly uploaded
• Tested the Standard Reports by writing SQL based on the Reporting Requirement and comparing the data

Environment: Java, WebSphere 5.0, Oracle,PL/SQL,HP Quick Test Professional 8.0, Agile,HP Quality Center 9.0, Windows XP,XML,UNIX,TOAD, and Oracle.

Confidential, Chicago, IL

QA Analyst

Responsibilities:

• Reviewed business requirements, created test plan test scenarios, test cases.
• Set-up the test QA environments for the integration, system and end-to-end testing.
• Quality center to test basic functionality of the application and reported the defects.
• Reviewed and enhanced the existing scripts by including checkpoints and conditional statements using Quick Test Professional.
• Documented Test Metrics, Test Logs and various reports on the weekly basis for senior management.
• Automated the regression test scripts using Quick Test Professional and ran them for every build in UAT, QA and Pre-Production Environments.
• Extensively used PVCS for Defect Reporting and Tracking.
• Worked on SQL tool Rapid Sql to run SQL queries to validate the database tables.

Environment: WebLogic, Teradata, SQL, Oracle, IMS, JAVA, JSP, UNIX, IIS, QTP 8.0, Quality Centre, 8.0, XML and COM+, UNIX, PVCS

Confidential, San Ramon, CA

QA Tester

Responsibilities:

• Walk through of Master Test Plans, Test Cases & Test Scripts based on Technical requirement.
• Review High Level Design Document, Interface Agreement documents, Detailed Design documents.
• Involved in Updating the Test Plan, test cases based on the evolving change in the requirements.
• Trained the members of the team who joined during the testing phase of the project on project scope / functionality.
• Prepared the test environment for test execution and executing the test cases.
• Processed the IR (Invoice & Adjustment) files received from ICBS (Internal carrier billing system) through XACCT (Amdocs Mediation System).
• Processed the Invoice and Agreement files through Acquisition & Formatter Module (Amdocs Enabler).
• Validated that guided Invoices & Adjustments reached ODR (Operational Data Repository) & Amdocs Ensemble Billing systems.
• Processed the erred files through (Amdocs Ensemble) EMS.
• Trained regression team on this project Confidential the end of testing.
• Used Quality Center to manage and track the test cases, test scripts.
• Used Quality Center for logging and tracking defects.
• Involved in VoIP application testing using Amdocs.
• Tested all Mobility business applications.

Environment: WindowsNT/2K, ASP.NET, C#, .NET, XML, Putty server, UNIX, Amdocs, CRM, Crystal Reports 8.0/7.0, Oracle, Windows NT/2000, IE, QTP 7.5, PL/SQL, Quality Center 7.0

Confidential, San Antonio, Texas

QA Tester

Responsibilities:

• Involved in Test plan walk through
• Involved in analysis of system requirements, business rules with Doors.
• Created test conditions and test cases using Doors and prepared test data for test execution.
• Used Test director for Test plan and executing of test cases manually.
• Reported and tracked bugs in Star Team.
• Involved in preparing Defect reports for defect meetings on regular basis during the testing phase.
• Prepared exit documents and reports
• Performed regression testing by executing the test manually.
• SQL queries used for back end testing.
• Involved in maintaining test documentation, defect metrics

Environment: Test Director 8.0, Informatica, DOORS, .NET, Weblogic, SQL, STARTEAM, MS-Windows XP, CICS, IBM OS/390, IMS, XML, MS-Office.

Confidential, Oakland, CA

QA Tester

Responsibilities:

• Reviewed manual testing strategies and performed extensive manual testing before automation testing.
• Involved in Processing claims and verifying whether it’s delivered to DIAMOND System or not.
• Involved in testing the efficiency of healthcare delivery by using HIPAA.
• Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835.
• Involved in processing claims in Diamond and validating the full cycle process to make sure the checks are generated and 835’s are generated.
• Involved in writing SQL queries to validate the payment files.
• Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
• Conducted compatibility tests with multiple operating systems, browsers, and network environments.
• Reported bugs using Test Director and Interacted with developers to resolve defects.

Environment: NET, VB, Web sphere, Oracle, Win Runner, Test Director UNIX, Load Runner, Windows NT/2000, MS-Excel, Clear Quest