SUMMARY:

• Over 7+ Years of IT Experienced in Prepared documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile
• Good testing experience in healthcare and banking domains.
• Experienced in developing Test Plans and Test Cases for different types of software testing.
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Experienced in Software Development Life Cycle (SDLC) and Project Life Cycle working as QA in Healthcare domain with prime focus on Claims adjudication, billing, provider, eligibility and prior authorization for Medicare, Medicaid and Blue Programs.
• Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Positive and Negative Testing, Security Testing and Regression Testing of, Web Based and Client - Server applications
• Good Experience working with Healthcare business domain.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive experienced in Manual Testing and Database Testing (Oracle, SQL Server, Netezza).
• Performed Back End Testing by executing SQL queries.
• Excellent Working Knowledge of HIPPA, Claims Processing, FACETS.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.
• Experience working on HIPPA ANSI X12 EDI conversion.
• Experience in SQL including inner/outer joins and complex selects and writing complex NoSQL Queries in writing UNIX script
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Tracked and reported on test execution.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.
• Performed portfolios of clients and assignments and key client relationship, develop and deliver services and value charters.
• Effective Time Management Skills and consistent ability to meet client deadline.

PROFESSIONAL EXPERIENCE:

Confidential, MN

Sr.Facets Tester

• Responsible for testing the Navigation Flow, Functionality Testing, System Testing and User Acceptance Testing.
• Analyzed the business requirements and Functional Specs for developing Test Plan and the Test Strategy
• Analyzed the FACETS Requirements and conducted gap analysis. conducted Business validations for different FACETS modules Providers, Billing, Claims and Membership
• Involved In developing Test Plan, Test Requirements, Test Cases and detailed test cases in ALM/Quality Center.
• Developed user defined functions to support automated scripts.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Data mocking for different Claim file formats.
• Conducted Validations for different FACETS modules Providers, Claims and Membership
• Processing (ITS) Performed Functional, User Interface, End - to-End, Cross Browser, Application, System, Integration, Regression, UAT and Back End Testing.
• Responsible for gathering requirements, design and develop data warehousing ETL solutions and delivery reports
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Executed test cases manually in Netezza environment and documented them in HP ALM/Quality center.
• Created test plans and test cases from functional requirements for System and UAT testing.
• Created several Test Cases and Test Conditions for testing various Claims, Membership, Billing and Provider reports.
• Performed and executing SQL queries to perform Data Integrity testing to validate and test data using Netezza.
• Participated in defect reviews with the developers, managers and business people and presented the Defect reports in the defect review Meetings.
• Performed Database testing (Data Warehouse / ETL) on ETL validating data in Sources/Targets
• Responsible for testing of OPL, COB, Healthcare Claim Pricing, Healthcare Claim Benefits, End to End Claims Processing
• Data validation and Database integrity testing done by executing SQL, PL/SQL statements.
• Checked database and with application queried result is being equal, SQL queries is being extensively used to check the data from the data base using Netezza.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in Defect Review, Actuarial Review meetings periodically
• Created different pricingrules and verified whether the adjudication system is using the rules while adjudicating the Claims

Environment: s: ETL, Informatica, Data Warehouse, ALM/Quality Center, Java, Netezza, XML, UNIX, PL/SQL, Windows, SQL.

Confidential, CA

ETL Tester

• Worked with clients to better understand their needs and present solutions using structured SDLC approach.
• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects.
• Responsible for testing all new and existing ETL Data Warehouse components.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse.
• Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc..
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Worked with ETL group for understating mappings for dimensions and facts
• Tested for data in the database by writing SQL queries for SQL Server before testing the module
• Actively participated in the weekly Project Status Meetings.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Produced various test reports such as Test Execution Status, Test Execution Summary/Progress, Defect Status, Defect Summary, Defect Inject Rate on daily and weekly basis and submitted
• Performed backend testing using SQL queries and NoSQL to retrieve and verify information in Oracle.
• Tested loading of Source data target Oracle, SQL SERVER, MYSQL, NETEZZA, SYBASE systems.
• Wrote SQL statements by inserting, deleting, updating data to/from the database to test new entry, update, and delete operations.
• Arranged meetings with the Project Teams to discuss the test approach used for the Data Conversion and ETL modules
• Worked with the components of Data Warehousing like components model, ETL tools.
• Gathered business requirements from users and created designs for enhancements and to remedy defects.
• Responsible for executing SQL queries on Netezza.
• Detected, reported and tracked defects using HP ALM/Quality Center.

Environment: Oracle, ETL, Informatica,Data warehousing, SQL Server, PL/SQL, XML, Quality Center, Etc.

Confidential, NJ

• Analyzed the objectives and scope of each stage of testing process from the Test plan.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assisted for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments as required.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Extensively used SQL programming in backend and front - end functions, procedures, packages to test business rules and security.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Assisted in promotion of Data Stage code and UNIX Shell scripts from UAT to Production.
• 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.
• Assisted in System Test and UAT testing scenarios as required.
• Worked with thin client and thick client (Business Objects )
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data

Confidential, MA

Facets Tester

• Created SQL statements to validate the data tables
• Developed several hundred of test cases to cover the data movement between sources to target
• Developed test scripts in SQL to check the data integrity from the databases
• Imported preexisting Microsoft Word and Excel - based requirements and tests for analysis in MQC.
• Understand and develop Web Services test strategy for different services as part of SOA
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Negative Testing Manually. Actively participated in walkthroughs and enhancement meetings
• Implemented technical solutions for complex state-mandated prospective claims pricing methodologies
• Maintained Test Matrix and Requirement Traceability Matrix
• Performed Gap Analysis. Validate the date from EDI transaction
• Analyzed and worked with HIPAA specific EDI transactions for claims, membership enrollment, billing transactions.
• Document request/response XML's, test procedures and functional/technical findings from the test run
• Develop, design & implement department plan to operationalize new FACETS integrated processing system, to include but not limited to, workflow, management oversight and performance analysis.
• Authored test case scenarios in Excel spread sheet and export them into Mercury Quality Center.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using Quality Center.

Environment: Windows, FACETS, Quality Center, DB2, Java, UNIX, SQL, HTML, ASP.NET