SUMMARY

• Over 6 years of experience as a Quality Assurance tester in Health care, Financial Services and Technology industries.
• Extensive experience in ETL/ Data warehouse backend testing, BI Intelligence reports testing, Dashboards testing and Web based/GUI applications.
• Proficient in writing Test Strategies, Test Cases, Test Scripts, Test Scenarios, bug tracking and test results analysis.
• Hands on expertise in ETL tools like Oracle Data Integrator 11.1.1.9.0 & 12, Informatica, OBIEE, Business Objects
• Experience working as QA Tester: Manual testing of Web based and Client/Server applications.
• Experience developing and testing various web and mobile applications as part of academic projects.
• Good knowledge of SDLC and Software Testing Life Cycle (STLC).
• Experience using JIRA tool as a part of daily scrum activities including reviewing user stories acceptance criteria, testing activities, tracking defects, reviewing the sprint activities etc.
• Experience in understanding and writing SQL queries to perform back - end testing on databases like Oracle, SQL Server.
• Excellent Knowledge of Database Systems - Oracle 10g, IBM Netezza, Sybase and SQL server
• Extensive experience in developing SQL/PL SQL scripts to validate the databases tables and reports data.
• Experienced in using Unix commands to validate the files status
• Strong experience in using FACETS which includes the Membership, Product, Provider, components Billing, Claims Processing, Commissions, Claims Processing, Customer Service, Utilization Management, Electronic Data Interchange (EDI).
• Used CTP (Claim test Pro) for Claims testing and information gathering for the claims testing purpose.
• Strong working knowledge of the 834, 837 & 835 EDI Healthcare files and Transactions.
• Hands on working experience in Mercury Quality Center, HP Application Lifecycle Management, IBM Rational Testing Tools, Clear quest, Test Manager.
• Worked with Claim Processing, Medicaid and Medicare modules as well as Interface Testing and Data Conversion.
• Experienced in performing testing including Backend, Frontend, Regression, Functional, System, Security, Black box, Integration Verification and Validation End-to-end and User Acceptance Testing
• Developed and maintained automated test scripts using UFT (Unified Functional Testing), TAF.
• Experienced in Agile Methodology and Scrum concepts, project tracking tools like JIRA, RTC and version control tools like GIT, RTC and Clear case.
• Good understanding of healthcare industry, claims management process, Medicaid and Medicare Services and insurance sector.
• Good communication skills, interpersonal skills, team coordination and versed with Software development process.

TECHNICAL SKILLS

Testing Tools: Mercury Interactive Suite (QTP)UFT, LOAD RUNNER, TEST DIRECTOR, HP QUALITY CENTER /ALM), Clear quest, JIRA, Rational Requisite Pro, Rational Test Tools Suite, ETL (Informatica)

Methodologies: SDLC, Agile, Waterfall

Operating system: Windows, Windows 95/98, Windows XP, Windows 7, UNIX, LINUX, IOS.

Languages: SQL, PL/SQL, Visual Basic, HTML.

Microsoft Tools: MS-WORD, MS-PROJECT, MS-EXCEL, MS-OFFICE.

Tracking Tools: Atlassian Jira, JIRS, Bugzilla.

Databases/ Database tools: Oracle, My SQL, SQL Server, TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

ETL Tester

Responsibilities:

• Wrote use cases and test cases based on the requirements to ensure the application maintained its previous functionality as well as incorporating the new enhancements in the redesign.
• Tested the mobile version of the application on Android and iOS phones to ensure that it functioned similar to the desktop version
• Involved in Business Functionality Review meetings, JAD Sessions and Use-Case Analysis.
• Followed Agile testing methodology and performed testing in iterations.
• Experience with executing both functional, usability and deployment testing
• Extensively participated in Sprint retrospective for improved process
• Performed both Manual and Automation testing
• Conducted SIT, System, Functional, GUI and UAT Tests
• Tested the Billing (Professional/Hospital) and claims.
• Validated the claims for Medicare.
• Extensively 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.
• Tested the ETL (Extraction, Transformation and Loading) process using Informatica.
• Reviewed the application systems and determined how to map the new applications data to the EDI System.
• Involved in creating test cases with positive & negative scenarios for all EDI transactions.
• Create EDI interface to send purchase order requests and receive acknowledgments and invoice data.
• Responsible for validation of user credentials and password validation for web portals.
• Involved in /EDI transactions Analysis, Design, Implementation and Documentation.
• Worked with data files (Flat Files, XML, SAS) Data files.
• Reviewed and Analyzed Test results using the Result Logs in QTP
• Performed Data Validation and backend testing by writing SQL queries.
• Wrote SQL, PL/SQL queries to access the data from the database tables and crosscheck the results, also been used for Automation Regression Testing.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Performed Schema validation, inbound and Outbound Data Validation.
• Tested the source, Target databases, mapping and Transformations.
• Data verification and validation using complex SQL queries.
• Extraction of test data from tables and loading of data into SQL tables.
• Reviewed the QTP Scripts developed by the team members.
• Tested the reports generated using Business Objects.
• Responsible for preparation of weekly status report.
• Worked as an ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Developed Test Plan and Acceptance Criteria.

Environment: Quality Centre, JIRA, ASP.NET, VB.NET, IIS, SQL, SSIS, SQL Server 2005, Mainframes, XML, IDM, Oracle 8i, SQL Navigator, Windows NT, XP, Unix, EDI, ETL.

Confidential

ETL Tester

Responsibilities:

• Reviewing and understanding Business Requirements Document and Functional Specification Document, Data models and Mapping document with Business Logic/Transformation rules.
• Developed Test Plans, Test Cases, Test Scripts, Requirement Traceability Matrix and Test Coverage reports for System Integration Testing and Functional Testing.
• Worked with the Subject Matter Experts to ensure that requirements were correct and complete.
• Performed Unit, Integration, End-to- End, Regression and UAT tests phases for data integration and data migration.
• Executed Integration/End to End testing for the entire process. Verification and validation of the data and mappings during various stages.
• Designed SSIS packages and schedule them in jobs for data transfer.
• Written complex SQL queries to validate the data conditions based on ETL data mapping document.
• Created SSIS Packages using Derived Columns, Condition Split, Merge Join, Aggregate, Execute SSIS Packages.
• Used SQL scripts to perform backend database testing.
• Developed and presented power point presentations in walking the tech, business and sponsors to understand the QA test plans, progress reports, risks, build release requirements, test prioritization, resource allocation, team training needs and defect life cycles.
• Performed regression and stress testing using QuickTestPro(QTP) and Load runner.
• Managed script creation for regression testing using QuickTestPro (QTP)10.
• Conduct walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation.
• Develop and document application test plans based on software requirements and technical specifications.
• Developed detailed Test cases using the prototype and performed Manual Testing.
• Logged, tracked and provided status reports of production issues.
• Interacted with developers to resolve the defects. Performed Regression testing to verify that bug fixes did not break some other parts of the system.
• Performed Cross Browser testing by running application on different Browsers and version of Browsers.
• Validated the data by using SQL queries extensively.
• Developed Requirement Traceability Matrix (RTM).
• Participated in pre-release meetings and documentation approvals.
• Train the users and support the UAT.

Environment: ETL Informatica Power Center 8.1, SQL, PL/SQL, UNIX, Toad, Test Director V7.6, SSIS, SSAS, SSRS, Sun Solaris, MS SQL server, HTML, ALM, TOAD, Oracle 10g, QTP, Crystal Reports

Confidential

ETL QA Analyst

Responsibilities:

• Responsible to create the test cases referencing to the ETL mapping document
• Configure the test environment by executing the required DDL scripts to create the database objects tables, views and packages
• Adept at using both manual and automated testing tools to perform, integration, UAT, positive and negative, functionality, end to end and regression testing.
• Followed software testing methodologies and plans to ensure software product quality.
• Used Quality Center for documenting requirements, view, modify requirement tree and converting requirements to tests.
• Tracked changes made to the requirements, tests and defects using Quality Center ALM.
• Parameterized test scripts to ensure comprehensive Positive and Negative testing with unique data.
• For certain modules automation testing was performed using Quick Test professional.
• Developed test data to meet the requirements.
• Wrote SQL queries for Database testing (End to End Testing) and was also involved in performing Back-End Testing by writing SQL queries to extract the data from SQL database.
• Developed the SQL scripts to validate that the transactions (Insert, update and delete) made in the source are written into the Target Database.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values, data aggregations, Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation
• Created the contexts and set up the topology to connect to various sources in test environment
• Generated the test scenarios in Core Advanced Application.
• Used SQL Queries to verify the data from the Oracle database.
• Customized the scripts according to the requirements by inserting conditional statements, checkpoint and loops.
• Performed regression testing to validate the data between Production and Test environments
• Track and report upon testing activities including testing results, test case coverage, defects discovered and their status.
• Entered the defects identified during testing in all environments in HP ALM, JIRA.
• Actively participated in daily scrum and report the issues identified.

Environment: Informatica 8.6.1/8.1, MS SQL Server 2005/2008, QTP, Oracle 10g, PL/SQL, TOAD 8.0, SQL, Linux, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1, Cognos, WEBLOAD

Confidential

Manual & Automation Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared Test Cases and Test Plans for the mappings developed.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the execution.
• Created Test Cases, traceability matrix based on mapping document and requirements. Validated the web services using the Soap UI.
• Creates table pairs in Informatica data validation option (DVO) and validated the data moving from source to target.
• Created System / Regression and Acceptance testing activities like creation of test setup, test plan, test data creation, environment setup etc.
• Analysed system Specifications and design document and developed test plan in Quality Center. Performed Functionality testing of GUI/Web applications.
• Used Quality Center to report Bugs.
• Performed Cross Browser testing by running application on different Browsers and version of Browsers.
• Developed detailed Test cases using the prototype and performed Manual Testing.
• Tested in all type of testing environment, Development.
• Maintained the Traceability Matrix using MS Excel.
• Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
• Loaded data to different databases using SQL scripts to create required test data
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Profiled the data using Informatica data quality (IDQ).
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions.
• Participating actively in daily Meetings and Release Management activities.

Environment: Informatica Power Center 9.5/ 9.1, Informatica Data Validation Option (DVO), Informatica Data Quality (IDQ), Clear Case, OBIEE, Clear Quest, SQL, PL/SQL, UNIX, Putty, Shell Scripting, Soap UI, Web Services, .NET, HTML, ASP .NET, SSIS, SSRS, Session Log files, TFS, XML files, Sybase, Oracle 11g, Compare IT, HP Quality Center, Autosys, SQL Server 2012, TOAD