Modern Woodmen of America is a member-owned fraternal financial services organization. Modern Woodmen's main product lines are life insurance, annuity and investment.

Responsibilities:
• Perform the business meeting to finalize the tasks for IT
• Extract the data from data base using IBM SQL Studio and SQL navigator tools validate the required information send the data claim process
• validate the Agent data, ability to analyze, translate, and define business requirements into system specifications for members
• Perform UFT and Selenium scripts for automation of web and windows applications testing
• Reading and understanding code, and performing code reviews throughout the software development lifecycle
• Creating test deliverables and performing testing
• Executing test scenarios, writing test scripts and tracking defects to ensure that application meet technical and business requirements
• Recommending improvements based on testing results
• Performing business analysis and utilizing knowledge of TFS for tasks and work management.
• Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.

BCBSFL provides healthcare benefit for individual, small and midsized businesses and large employers. Worked on a data conversion application, which loads EDI claims files into the document imaging system. Claims were received in ANSI X 12 837 format and were converted to the internal XML file format. Files were indexed and loaded into document imaging system. Testing procedures verified document images against claims management database.

Responsibilities:
• Provider and Members data, analyze results using statistical techniques and provide ongoing reports
• Extract the data from data base using IBM SQL Studio and SQL navigator tools validate the required information send the data claim process
• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
• Acquire data from primary or secondary data sources and maintain databases/data system
• Reviewing and analyzing the BRD, FRD and Detail design documents, and understanding the SDLC methodology of the organization.
• Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.
• Documenting the test plan, test cases, test scripts and expected results using Quality Center (for GUI testing, Functional testing, Data validation, Security testing, Compatibility testing, Performance testing)
• Preparation of test data for the positive and negative test cases.
• Conducting the walk thru of the test plan with the developers and design team
• Verified HIPAA compliant X 12 format for EDI transactions.
• Validated EDI files against ICD-9 compliance and cross walk ICD 9 - 10 and also ICD10 - 9
• Wrote test cases to check the formats of transaction requirement for 834/835,837,276/278.
• Experience in Testing HIPAA Gateway EDI Transactions. Experience in HIPAA transactions EDI 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).
• Tested the EDI interfaces and X 12/EDI transactions (270, 271, 835,837 and 997).
• Backend testing by executing the SQL commands for data retrieval/verification, data updating and data insertion into the tables
• Prepared test matrix and test status reports to reflect the status of testing and bug fixes of the HP Quality Center.
• Used Quality Center to track the defects encountered during testing.
• Test cases are designed for the black box testing and perform boundary value analysis, decision table analysis for business rules, and state transition verification.
• Extensively used Quality Center for defect tracking and prioritizing defects and enhancement requests after base lining the requirements.
• Tested the database integrity by writing SQL queries
• Tested XML files using XML Spy.
• Involved in database testing by writing and executing SQL queries to validate that data is being populated in appropriate tables.
• Involved in manual testing of ETL components, SQL, PL/SQL blocks.
• Conducted and Attended review meetings, performed Walkthroughs with the developers and development team to set a hard-freeze date and gather input for creating the Test Plans and Test Specifications.

Environment: J2EE, Quality Center, DB2, Mainframe, SQL, Oracle, Microsoft, XML, HTML, MS-Excel, Web Services, Web Applications

Involved in voluntary training on QA validation at IIS LLC, to gain professional experience. During the training period gained expert knowledge in the field of Software Development Life Cycle with emphasis on Quality Assurance using various tools such as Mercury Interactive tools under Windows and Unix Environments. The extensive software testing exposure includes the manual and automated testing of Client-Server, Multi-Tier, Stand-alone and Web-based applications with tools like Quick Test Professional. Gained experience in all forms of testing including Functional, Integration, Performance, and User Acceptance testing. Improvised excellent judgment skills during the extensive training period to identify areas of high risk critical business areas early in an application and prioritize tasks to focus testing effort in a fast paced environment. Developed excellent professional skills by working independently and as a part of the team in structured and unstructured environments.

Responsibilities:
• Formatting the Business Requirements and helping the technical lead to come up with the User Stories.
• Analyzed the project requirements, available resources and end user's expectation to determine the outline for the EPIC module.
• Created and Managed Test Plans Test Cases and Test Procedures.
• Performed Data Discovery, Data Profiling to validate the Data that was used in the project and helping Developers to create the tables according to the Data model.
• Attending Scrum meetings, Sprint retrospective meeting, Sprint Planning, Sprint Story Grooming meeting with Product owners and Scrum Managers.
• Managed Sprint Tasks, all the Scrum activities using Rally .
• Participating in Design sessions, code review sessions, and planning sessions with peers.
• Performing SQL Testing using complex SQL queries like Joins, Update, Insert and other SQL scripts.
• Performed Store Procedures testing using complex SQL queries and validate the Test Cases depending on the Data in the output.
• Verified cross-walk for understanding major changes from ICD-9 to ICD-10. Drafted the major changes that would appear in ICD-10 version.
• Verified the EDI raw data as per 5010 format.
• Performed Automation testing using Selenium Web driver, to validate the data in the tables and to perform end to end testing.
• Created test scripts to perform to run the Web services in Selenium and perform automation testing.
• Performed web services testing using Soap UI and REST using different assertion techniques.
• Performed SQL Testing, Data manipulation, Data Integration, Server Validation using SQL Server and Razor SQL.
• Validated Test Cases and Managed all the Defects using Rally testing tool.
• Performed ETL Testing using Informix tool and with Unix environment.
• Performed Regression Testing, Smoke Testing, Integration Testing, and User Acceptance Testing using the Test Cases created in Rally.
• Responsible for generating Test status Report for the Test Cases validated for SQL Queries constructed by SQL Server Database.

Responsibilities:
• Studied at SDSU in a graduate program with chemistry major during which also worked on various projects involving complex testing procedures following STP's and SOP's as per the requirements.
• Created the detailed system test cases from the business requirements documents.
• Integration Test, User Acceptance Test under different environments.
• Reviewed vendor solution designs and assists in coordinating testing between vendor and client for product enhancements.
• Responsible for testing the entire functionality of the application.
• Tested the interface between database and the application.
• Tested HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
• Tested the LPF generated from the 837 files using the File aid and Copybook.
• Unit Tested 837 (Institutional, Dental, and Professional), 835, 270/271, 276/277, 820, and 277U transactions with TSO, ISPF, and File Aid.
• Involved in Data mapping to/from legacy to FACETS that will be used to populate the oracle database.
• Good Understanding on FACETS application.
• Involved in processing claims in FACETS and validating the full cycle process to make sure the checks are generated and 835's are generated.
• Developed test scripts for Data Driven tests. Executed the test scripts and analyzed the results.
• SQL queries are used for backend testing on the UNIX platform.
• Participated in requirement walkthroughs and creation of test plan.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Involved in both Manual and Automated testing.
• Created and implemented functional tests using QTP and customized QTP scripts with VB scripts
• Involved in load testing end-to-end testing scenarios using large data files.
• Prepared QTP Automation Test Plan.
• Developed and executed automated scripts using QTP to ensure functionality of application.
• Performed Back End testing by executing SQL queries.
• Involved in ETL testing process as Extracting batch files, Transforming and Loading into database.
• Performed Integration testing, System testing and Regression testing.
• Interfacing with developers to resolve the technical issues. Environment: QTP, Fire fox, Windows XP, Oracle, MS-Project Server, Share Point, MS-Visio, SQL, JAVA, JSP, JavaScript, XML, FACETS, Windows 2000/NT/XP, IIS, JavaScript, UNIX, IIS.