SUMMARY

• Software QA Analyst / ETL Tester with 6 years of intensive experience in QA Methodologies and testing of web, Mainframe and client - server applications.
• Experience in entire SDLC (Waterfall, Agile/Scrum) and QA life Cycle.
• Expertise in Manual and Automation Testing.
• Extensive experience in Test Case analysis and design, Test Script development, Test Data, Test Coverage and Defect Tracking.
• Well versed in Requirement analysis, Business analysis, use-case analysis, change management and configuration management.
• Experience with SQL and UNIX shell scripts.
• 6 years of experience in Integration Testing, System Testing, Performance Testing, Functional Testing, Regression Testing, Smoke Testing, Database testing, User Acceptance testing and End-to-End Testing.

TECHNICAL SKILLS

Operating Systems: UNIX, MS-DOS, MVS, MS-Windows 95/98/NT, MVS

Testing Tools: Rational Suite of Tools, HP/Mercury Tools (6.0, 7.0 and 8.0)

Languages: C, C++, J2EE, SQL, PL-SQL, COBOL, JCL, Perl.

Development Tools: VBScript, JavaScript, VB, Power Builder, Tibco tools, XML, XML SPY, ASP, .NET.

Database: MS Access, SQL Server, Oracle, DB2

ETL: Informatica, Cognos

Reporting Tools: Crystal Reports, Business Objects, Reports3.0

Packages: MS-OFFICE (Documentation Packages), Lotus Notes

Hardware Platforms: IBM, HP, Solaris, PC Compatibles.

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Senior QA Tester

Responsibilities:

• Developed Test Plans, Test Cases and Test Scripts, Test data, Test Summary Reports.
• Followed Agile/Scrum process throughout the SDLC.
• Conducted Functional, Integration, System, Regression, Smoke, Positive and Backend Testing.
• Test case Management was done using HP ALM.
• Tested the Manual claims, pended claims and Multiplan claims.
• Tested Web services in Workstation which gets data from various Endpoints like Provider, Subscriber and Claim history.
• Extensively tested and validated ICD 10 codes, procedure codes (CPT) codes and the amount billed for the services rendered.
• Extensively Worked with ANSI X12 EDI, 837, 834, 270, 271, 276, 277, 278, 820 and 997 transactions
• Involved in validation of ANSI X12 837 and 835 claims used for Professional, Institutional and Dental Claims by Writing Test cases, Test Plans.
• Prepared the 837 I and 837 P XML files using XSD Schema in Altova XML SPY.
• Tested ANSI X12 834 for Benefits, Enrollment and Maintenance applications.
• Tested ANSI X12 820 for EFT Payments/Payment Orders/Remittance Advice.
• Participated in testing various interfaces (Inbound and Out bound) of Facets
• Validated messages (General Inquiry, Informational and Claim Status) in Host and Home
• Writing and execution of Test cases for Facets application.
• Tested the Member/Subscriber, Provider and claims in Facets.
• Worked with Medicare, Medicaid and Vision claims.
• Analysis, Project planning, Status reporting, document review and defect entry verification
• Validated the claims and validated the claims pricing scenarios in Facets.
• Used HP ALM for managing the defect flow.

Environment: HP ALM 11.0, XML SPY, SOAP, Oracle, TOAD, SQL, PL/SQL, Trizetto Facets 5.0, Unix, Tibco, MS-Office, Windows NT/XP, MQ Series v6.o

Confidential, Denver, CO

Senior BI / ETL Tester

Responsibilities:

• Developed Test Plans, Test Cases and Test Scripts, Test data, Test Summary Reports.
• Followed Agile/Scrum process throughout the SDLC.
• Conducted Functional, Integration, System, Regression, Smoke, Positive and Backend Testing.
• Test case Management was done using HP Quality Center / ALM.
• Tested the Manual claims, pended claims and Multiplan claims.
• Tested Web services in Workstation which gets data from various Endpoints like Provider, Subscriber and Claim history.
• We used Medical claims are sent by doctor’s offices with these ICD 9/10 codes, along with procedure codes known as CPT codes, and the amount billed for the services rendered.
• Extensively Worked with ANSI X12 EDI 4010/, 837, 834, 270, 271, 276, 277, 278 and 997 transactions
• Participated in testing various interfaces (Inbound and Out bound) of Facets
• Validated the Membership Portals.
• Bypass Pended Medical and Hospital Claims and Dental claims as per the PCA Criteria.
• Involved in validation of ANSI X12 5010 for 837 and 835 claims used for Professional, Institutional and Dental Claims by Writing Test cases, Test Plans.
• Prepared the 837 I and 837 P XML files using XSD Schema in Altova XML SPY.
• Involved in Validation of ANSI X12 for Enrollment.
• Validated messages (General Inquiry, Informational and Claim Status) in Host and Home
• Writing and execution of Test cases for Facets application.
• Tested the Member/Subscriber, Provider and claims in Facets.
• Involved in Status calls, Business and Technical design meetings
• Created data and Tested reports generated for Facets customer service application.
• Worked with Medicare, Medicaid and Vision claims.
• Analysis, Project planning, Status reporting, document review and defect entry verification
• Validated the claims and validated the claims pricing scenarios in Facets.
• Validated the diagnosis codes and procedure codes for claims in Facets.
• Tested the Rendering provider and billing provider claims.
• Tested the Dental pre-determination claims.
• Tested the ETL process using Informatica.
• Responsible for Testing ETL/DW (Data Warehouse) and Business Intelligence (Business Objects) applications.
• Tested the Data warehouse (ETL) applications developed using Star Schema / Snow Flake schema and also using ETL tool (Informatica).
• Tested and Validated various reports developed using Business Objects.
• Tested and Validated data files (SSIS, SAS, SSRS)
• Created complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Created SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Wrote SQL Statements, Simple and Complex SQL Queries to validate data.
• Tested the source, Target databases, mapping and Transformations.
• Performed Data Validation and backend testing by writing SQL queries.
• Wrote SQL statements to extract data from the Tables.
• Used SQL Developer to connect to database and pull out the test data.
• Tested the Mainframe (CICS) screens.
• Automated the functionality using QTP.
• Developed and executed VB Scripts using QTP.
• Tested the various actions on claims like Pending Denying, Resolving Exception, Splitting claims etc.
• Prepared Test data for Performance team.
• Used HP Quality Center/ALM for managing the defect flow.

Environment: HP Quality Center 10.0/ALM 11.0, QTP, XML SPY, XML Schema, SOAP, Oracle, TOAD, Informatica, Business Objects, SQL, PL/SQL, T-SQL, SQL Server, SSIS, SAS, SQL Developer, Trizetto Facets 4.61/5.0, IBM Mainframes, Unix, Tibco, MS-Office, Windows NT/XP, MQ Series v6.o

Confidential, PA

Senior ETL Tester

Responsibilities:

• Developed software Test Plans and Test Cases based on business requirements document and technical specifications document
• Performed Manual Testing and maintained documentation on different types of Testing viz., Functional, Integration, Regression, System, GUI, Smoke, User-acceptance and Performance Testing
• Managed requirements using Requirements Manager of Quality Center
• Documented Test cases corresponding to business rules and other operating condition in Quality Center.
• Developed Test artifacts for Banking, Financial, Mortgage, Consumer lending, Asset management and Mutual Funds applications.
• Performed data Migration and data validation testing after the ETL process using Informatica
• Tested the ETL applications and ETL Process using Informatica.
• Developed Test Plans, Test Cases for ETL/Data Warehouse applications.
• Created Test scripts for verifying the Informatica process as part of the Enterprise Data Warehouse.
• Validated the source database, target database and transformations.
• Validated the data in Oracle, Teradata and SQL server databases.
• Validated Conditions, Rules by using SQL and PL/SQL
• Tested DW Reports developed in Cognos.
• Tested the Report Items, Prompts, Drill Through and validated the cubes in Cognos.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Developed and tested ETL mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Expression, Aggregator, Update Strategy, Rank, stored procedure, Joiner, Filter, Lookup and Router.
• Tested the backend database using SQL Queries.
• Involved in Developing Test Plans, Test Cases & Test Scripts.
• Automated the functionality using QTP.
• Developed and executed VB Scripts using QTP.
• Conducted Functional, Integration and Regression Testing using QTP.
• Performed End-to-End testing manually.
• Responsible in providing regular test reports to the management
• Conducted browser compatibility test of application
• Reported the bugs, Email notifications to the developers using the Quality Center
• Investigate software defects and interact with developers to resolve technical issues.

Environment: Informatica, Cognos Reports studio, SQL, PL/SQL, SQL Developer, SQL Server, Advanced SQL, IBM Mainframes, Java, JSP, HTML, XML, Web Logic, MQ Series, Oracle 8i, TOAD, Windows NT, Mercury Quality Center, QTP, UNIX.

Confidential, Boston, MA

Senior QA / ETL Tester

Responsibilities:

• Involved in Business functionality review meetings, JAD Sessions and Use-Case Analysis.
• Developed Test Plan and Acceptance criteria.
• Followed Agile testing methodology and performed testing in iterations.
• Attended daily Scrum calls for status report.
• Participated in Sprint retrospectives for improved process.
• Performed both Manual and Automation testing.
• Conducted SIT, System, Functional, GUI and UAT Tests.
• Tested the Patient Management in EPIC.
• Tested the Patient scheduling in Cadence (EPIC).
• Tested the Lab Orders, Transfer of patients in EPIC.
• Tested the Billing (Professional/Hospital) and claims.
• Validated the claims for Medicare.
• Mapping the requirements to test cases (Traceability matrix)
• Involved in validation of EDI Transactions (834, 837,835,270,271,276,277,997).
• Extensively worked on EDI 837 and 835 for Claims.
• Enhanced the automated Regression Scripts and conducted Data Driven Testing.
• Test cases will be developed based on the story cards supplied then scripts will be written to execute the testing steps.
• Tested the ETL (Extraction, Transformation and Loading) process using Informatica.
• Performed Schema validation, Inbound and Outbound Data Validation.
• Tested the source, Target databases, mapping and Transformations.
• Worked with data files (Flat Files, XML, SAS data files).
• Tested the target data in Oracle database using Oracle SQL Developer.
• Performed Data Validation and backend testing by writing SQL queries.
• Validated the data in Oracle, Teradata and SQL server databases.
• Wrote SQL statements to extract data from the Tables.
• Worked extensively with Database Procedures, Functions, Cursors, Joins and Triggers using PL/SQL to apply business rules.
• Tested the reports generated using Business Objects.
• Expected results will be built on each test case during Systems testing. Every attribute on the table(s) for every case will have the data that’s expected to appear on the row documented.
• Participated in Internal and External walkthroughs for prepared test plan and test cases
• Involved in the creation of the strategy document that defines the test environment, phases of testing, timelines of different phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Responsible for validation of user credentials and password validation for web portals.
• Supervised the use of Rational ClearQuest for Defect Reporting.
• Responsible for preparation of weekly status report.

Environment: EPIC Suite 2010, Rational Manual Tester, ClearQuest, Informatica, Business Objects, ASP.NET, VB.NET, IIS, SQL, SSIS, SQL Server 2005, Mainframes, XML, IDM, Oracle 8i, SQL Navigator, Windows NT, XP, Unix