SUMMARY

• Over 7+ years of experience in every phase of Software Development Life Cycle (SDLC) and Sr. QA Engineer.
• Experience wif mapping and validating various EDI files such as 834, 820, 835, 837, etc.
• Strong noledge of software development methodologies including the agile methodology, Waterfall, and RAD Methodology.
• Skilled in bug reporting and tracking using ALM (Quality Center), IMB Clear quest and JIRA.
• Experience in developing, trouble shooting and customizing test scripts using Quick Test Professional QTP /HP UFT for Functional and Regression Testing.
• Experienced in using management tools such as HP ALM, JIRA - Zephyr combination, CA Agile Central (Rally) for writing the test cases, test data, executing the test cases, tracking, logging and reporting defects as well as developing Test Analysis Report (TAR).
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tested the HIPAA EDI transactions 834, 837/835, 276/277, 270/271 according to the requirement test scenarios.
• Familiar wif data analytics tools such as Tableau and looker.
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Data stage using SQL Server, Oracle, DB2, and UNIX.
• Extensive experience wif Reporting Tools like OBIEE, Cognos, Business Objects.
• Worked wif Microsoft SQL Server. Thorough noledge and understanding of Dimensional Data Modeling, Star schema, Snow-Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and other Data-Warehousing concepts.
• Solid understanding of, Claims Processing, Benefit/Eligibility, COB, Authorization /Referrals, and has experience in HIPAA standards and corresponding EDI transactions.
• Hands on experience wif solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling and database/data warehouse experience.
• Excellent communication and organizational skills wif the ability to adapt to a new environment.
• Experience in facilitating meetings wif clients to discuss and sign-off on the document.
• Good experience in Back-End Testing using SQL queries on Oracle, MS SQL Server to validate the consistency of data.
• Expertise in Unit testing, Integration testing, Regression testing, System testing, User Acceptance testing, and Implementation testing.
• Extensive working experience in Functionality, System, Integration, Front-End, GUI, Back-End, Recovery Testing, Compatibility Testing, Usability Testing, Regression, Tracking Bug Reports using Bug tracking Tools like Quality Center.
• Experience in usage of defect tracking tools Quality Center/ALM, Clear Quest, Rally, JIRA for logging the defects, generation of reports and analyzes the reports.
• Used Agile-testing methodology for achieving deadlines in UAT.
• Performed planning and development of Test Plans, Test Strategies, Test Cases and Test Scenario to meet product’s business requirement
• Good noledge of SQL and experience at conducting backend testing.
• Expertise in Testing of Client/Server and Web based applications.
• Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, configuration Testing, User Acceptance Testing.
• Tested web applications in Agile, waterfall development processes.
• Strong experience in Front-end Testing and Database (back-end) Testing, GUI testing black box testing, white box testing, gray box and User acceptance testing.
• Possess strong problem-solving skills wif the ability to adapt to a new environment and meet deadlines.
• Motivated self-starter wif exceptional team building, leadership, and interpersonal skills. Good team player wif the ability to work in time sensitive environments.
• Experience in creating and maintaining the Requirements definition documents dat included Business requirements and Functional requirements.
• Solid experience in creating and validating TCS letters through various FACETS Applications (Utilization Management, Claim Processing and Customer Service Applications) in the QAE1 environment.

AREAS OF EXPERTISE:

• Client Service & Relationships
• End-User Communication
• Team Leadership & Adaptability
• and Development
• Cross-Group Collaboration
• Test Scripts & Test Cases
• Test Plans Development
• Defect Resolution
• SDLC Best Practices
• Release Management
• TEMPEffective Communications
• Testing Tools Integrative Decision Making
• Problem Solving and troubleshooting
• Multitasking & Prioritizing
• Critical Thinking

TECHNICAL SKILLS:

Operating Systems: Windows

Languages: Java, SQL, HTML, XML

Testing Tools: Selenium, SOAP UI

Bug Reporting Tools: JIRA, HP ALM/ Quality Center, Tableau

Project Methodologies: Agile Scrum, Waterfall

RDBMS/Database: MS SQL server, MS Access, Oracle

ETL Tools: MS SQL server integration Services, Oracle Data Integrator(ODI)

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

Sr. QA Engineer

Responsibilities:

• Conducted SIT,PRE-PROD and Production testing on native mobile ABCBS, ABC,BCBSGA,EBCBS
• Responsible for writing the Test Cases and Test Scenarios based on our team assigned features and technical Specifications and loaded in script less tool.
• Involved in creating and executing test cases, defect tracking, generating bug report and TAR using CA Agile Central (Rally).
• Performed back-end testing using SQL queries to validate data and perform Data integrity testing.
• Identified issues and logged an observation in Jira tan reported to the Test Lead.
• Tested Confidential native apps in perfecto tool in various environment such as SIT, Pre-Prod and production environment.
• Performed back end testing in SQL on the Oracle database
• Translated business requirements into functional specifications and documented the work processes and information flows of the organization.
• Tested the ETL wif XML as source and tables in the data warehouse as target.
• Performed data mapping and modeling.
• Extracted data from SQL and developed interactive dashboard and BI report using Tableau for providing business insights.
• Worked wif the Agile methodology reviewing the Business requirement, Functional Design Documents and Technical Specification documents.
• Troubleshoot any problems found wifin FACETS and when testing the SQL data database while validating the business rule.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis
• Expertise to use Rally, Jira and Quality center/ALM for the test management and bug reporting.
• Extensively implemented backward compatibility testing wif given version number for GAP analysis.
• Performed detailed testing both on SPA and native apps on various environments.
• Communicated our team sprint testing updates every Wednesday to our testing manager.
• Participated in tester in order to be familiar wif future technology.
• Presented innovation ideas which can further enhance the testing work for the team.
• Followed up TDM (Test Data Management) team for particular data from specific source in order to complete the stores on time.
• Generated various risk reports from Bloomberg like Liquidity risk, Credit risk using Tableau and MS Excel
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Found the defects logged, coordinate wif developers did regression testing after the defect is fixed.
• Ran the SQL queries for checking the data stored in the database.
• Logged observation in case their is defect and prioritized the severity as per the requirement.
• Participated in daily stand up meeting and informed the scrum master the issues, impediments about the stories.
• Attended planning meeting analyzed the test data need for each stories and prepared the procedures for the same.
• Shared action items need to be done to enhance team performance during retrospective meeting.
• Discussed more serious issues in post scrum in order to complete stories on given deadlines.

Confidential, Detroit, MI

QA Engineer

Responsibilities:

• Analyzed and identified the requirements from Group Class Plan (GCP) document for member and subscriber demographic information and the insurance plans.
• Responsible for writing the Test Cases and Test Scenarios based on the Business Requirement Document (BRD) and technical Specifications and loaded in HP ALM.
• Identified issues wif the testing tools and the environment configurability and reported to the Lead.
• Created test members through Express Claim Test Pro application for testing purposes.
• Extensively used Express Claim Test Pro application to modify existing claims data to suit the testing scenarios for the new markets.
• Responsible for maintaining the defects on Rally and follow up wif developers for open defects before going for Testing.
• Worked on source to target data mapping based on data from various source systems
• Designed, Developed, and Implemented a star schema model in the data warehouse through dimensional modeling
• Used ETL tool for Extraction, Transformation and Loading the data into target database.
• Checked the data flow through the front end and back end and used SQL queries to extract the data from the database.
• Performed customer analysis and cluster analysis using Tableau and presented to the senior management for clarity on target customer segments.
• Conducted Back-End Testing for Oracle databases using complex SQL queries.
• Performed detailed testing for Authorization of claims, Benefits, Claims Payment, Pricing, Member Accumulator and System Readiness Review testing.
• Used an Agile model of development life cycle (SCRUM).
• Retrieved claims data from different test environments by executing SQL statements in TOAD
• Performed end-to-end testing of Billing, Enrollment Claim Processing and Subscriber/Member module.
• Performed Member Accumulator check based on the respective claims and member plans.
• Provided regular status updates to Team Lead on high priority issues and Testing Progress.
• Performed Integration and Regression testing to check compatibility of new functionality wif the existing functionalities for IOS and Android mobile app.
• Creation of test scripts for mobile applications.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Involved wif iPhone mobile application testing on device and simulator using Xcode and java.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Used ETL to transfer data from a source to a target (ETL stands for extract, transfer, loaded)
• Logged defects, determined repair priorities and tracked the defects until resolution using HP ALM.
• Maintained a traceability matrix of the requirements and the associated test cases and the defects logged.
• Participated in defect review board (DRB) meetings and provided technical expertise on how to resolve the issues related to configuration and/or test scenarios.

Premera Confidential, Seattle, WA

QA Engineer

Responsibilities:

• Created Test Cases and Test data after analyzing the BRD under AGILE development methodology.
• Performed Functional and GUI testing on Facets Billing, Customer service and Subscriber application under Facets
• Validated Load Receipt functionality, Cash Receipt functionality, Group Invoice functionality, and Policy Details extract functionality.
• Logged of defects in HP ALM to maintain Test requirements and to communicate the bugs wif the Developers.
• Extensive involvement in Data Analysis Activities including Data Visualization, Data Profiling, Data Quality, Data Governance, Source to Target Data Mapping, Data Testing.
• Used ETL to implement the slowly changing dimension to maintain historical data in data warehouse.
• Performed Backend testing by writing SQL validation queries in Oracle Toad against the database.
• Involved in testing of HIPPA 835 for the payment of claims and transfer of remittance information
• Executed Performance test procedures to check to time span
• Validated member’s benefits against the benefits matrix.
• Involved in creating test cases for regression testing and assist test lead during the testing activities.
• Analyzed and testing data on different billing and functionality manually and writing queries on database for validating data
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Performed detailed testing for Authorization of claims, Benefits, Claims Payment, Pricing, Member Accumulator and System Readiness Review testing.
• Used Firebug to do web based application testing wif selenium for the commands and locator application
• Maintained requirement traceability matrix on daily basis and participating in daily defect triage and status meeting.
• Created input test files as per the business requirements in Ultra edit and processing them in batch server to load data to respective tables in database and to generate the output
• Updated Functional Specs as per the change request received from client
• Performed Online Security testing of different profiles in Facets.

Confidential, Milwaukee

QA Engineer

Responsibilities:

• Developed functional test plan based on business and functional requirements. Created Test Cases as per Business requirements.
• Involved in logical and physical data modeling, database design, star schema, snowflake schema design, ETL process, data analysis, documentation, implementation and support.
• Involved in Functionality, GUI testing, Regression Testing, Integration Testing, System Testing, User Acceptance Testing, Positive Testing and Negative Testing on Application.
• Working in an agile environment where in each sprint conducted testing for sprint release.
• Wif a good noledge in FDR processing system, involved in all the walkthrough sessions.
• Validated opening of a new account and closing of an account using TSYS screens.
• Verified the customer dispute transaction and balances of the accounts by screen-wise accessing TSYS both in Test and Stage environments.
• Create analysis, dashboards, and reports for various departments (SQL and Tableau).
• Developed Agile testing strategies and plans for the project. Interacted wif Developer team and Product Owner continuously to ensure quality requirements and final products. Participated Sprint Planning, Daily Stand-up, Iteration Review and Retrospective meeting.
• Testing & monitoring tasks related to the FDR system. Successfully converted and uploaded FDR data to Oracle databases.
• Used TSYS to check the status of accounts and to condition them.
• Maintained and tested credit card application scorecards in TSYS.
• Used HP ALM to map requirements to test cases, provide traceability to requirements, create test sets, and selectively run tests both manually and using automation test scripts. Also used MTM for the accounting system implementation project.
• Used HP ALM defect section to report defects to development team.
• Extracting data from Mainframe flat files using Macros.
• Used standard business analysis methodology to define use case, business process flow and system specification
• Developing test scripts to test FDR System by using Teradata SQL Assistant Tool.
• Clearly communicated defects wif developers and updated comments in HP ALM.
• Analyzed the project documentation to ensure a thorough understanding of the requirements including, but not limited to user stories, technical specification, design documents, use cases, flow chart, etc. Understood all the business rules, application rules, work flows, etc.
• Prepared test cases wif all types of positive and negative scenarios. Applied test techniques like EVP, BVA and Decisional Coverage to write and executed test cases. Created organized traceability matrix to ensure test coverage and defect fixation status.
• Conducted end to end testing, UI validation, functional testing, cross browser testing and logged the defects in Jira.
• Gatheird data from different source for ETL processing to load to target database.
• Prepared UAT test cases wif test data, conducted UAT session wif business users, collected feedback from the users and incorporated those feedbacks in the test plan according to the decision.
• Performed web service using Postman to validate business logic before integrating the API wif front end. Utilized GET, POST, PUT and DELETE request as per needed
• Possessed expert level of understanding of WSDL, XSD, Schema, DTD, XML documents for Web Services Testing. Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.
• Experienced in preparing/writing and executing test cases, creating traceability matrix as well as defining required test data for mobile application both in iOS and Android devices. Validated using simulators and emulators and also wif real time dev.

Environment: Java, J2EE, EJB, JavaScript, JSP, FDR, TSYS, Mainframe, Html, XML, Oracle, UNIX, Windows, Internet Explorer, Netscape, Mozilla and Quality Center