SUMMARY:

• Over 9 + years of extensive experience in Analyzing, Designing and Implementation of QA testing strategy for Web based and Client/Server applications using Manual testing and Automation testing of client server application in back end testing.
• Specialized in analyzing Functional/Technical specifications and writing Test plans, Test Scripts, assessing and documenting the actual results against the expected results, creation of test data and automation of test cases.
• Experience in using test automation tools such as Selenium WebDriver and SoapUI to develop automation testing scripts for Web Applications
• Performed and expert in Smoke, Functional, End to End, Regression, Performance, Usability, User Acceptance Testing (UAT) with both Manual and Automated Testing tools.
• Proficient in using testing tools such as Rally, HP A.L.M, Microsoft MTM, AND Azure Devops
• Strong knowledge of the Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) models such as Waterfall and Agile (SCRUM) methodology.
• Knowledge in Web Service testing within SoapUI and XML.
• Experience in RDBMS, Microsoft SQL Server (T - SQL), Oracle (PL/SQL), Hadoop (HQL), Netezza (NZ-SQL) associated SQL Programming Knowledge.
• Experienced in bug tracking, reporting and using testing tools for global test management.
• Experienced working in Agile, Incremental, and Iterative, Scrum, Waterfall Environments
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Developed an automated scripts and frame works using Python
• Good Experience in preparing Test Plan documents for Acceptance/Integration Testing, user documents, and production support documents.
• Proficient in writing Selenium Web Driver automation scripts in Python
• Good experience in testing both SOAP and REST services using SOAP UI and Tested both XML and JSON formats.
• Worked with ETL groups and Acquisition team and

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data Quality Analyst/Automation Engineer

Responsibilities:

• Worked on TWS (Tivoli work scheduler) Migration project form Control - M Validated job properties in TWS and Control-m job scheduler tools Used extensive HQL Queries in Hive and Impala to analyze the HDFS data Executed batch files in job scheduler tools and
• Validated the target data in Hadoop eco system Identify scenarios that may require regression and integration testing and communicate to appropriate testing groups Created advanced PL-SQL, HQL queries using joins, aggregate functions and CTE's to validate data b/n Source and
• Target Validated stored procedures for Incremental extract based on time stamp, version date and record flag Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs Tested reconcile and incremental ETL loads for the project Validated the data load process for
• Hadoop using the HiveQL query's Maintained the Requirement Traceability Matrices (RTM) to track the coverage of Requirements v/s designed test cases. Automated data validation using Python package Pandas Schedule the workflow using TWS. Sent error logs if any to project
• DBA's or assigned Project Leads to sort it out and resolve. Validating the data files from source to make sure correct data has been captured to be loaded to target tables. Validated the Map Reduce programsby using HQL queries Developed HQL Queries based on data mapping from Source to
• Target tables and the business logic used to populate target tableEnvironment: Python, Selenium, TWS, Control-M, Hive, Impala, HUE, Oracle 19c, Oracle SQL Developer, Rally, HP A.L.M, Pandas, Linux, Putty, PyCharm, Pandas

Confidential

Sr. Data Quality Analyst/Automation Engineer

Responsibilities:

• Validated the load status through Informatica Workflow Monitor
• Ran Linux scripts using PUTTY and validated the data in Target location. Extensively used Page Objects design and page navigation framework for readable test script and easy maintenance from developer perspectives. Prepared Data metrics sheet filled them and uploaded into Project share point site for Lead/Manager Review. Prepared UAT Test Plan for Supplier Portal. Monitored daily job run using Tivoli Maestro. Used File Zilla and Ultra Edit to move files for Remote server to Local drive after the daily job run process.
• Extensively used Selenium (data - driven, XPath locator) and WebDriver to test the web application Executed regression tests for the developed software interface in Python Responsible for fixing and maintaining regression automation test scripts for end to end testing using Selenium WebDriver using Python. Conducted tasks like testing functionalities of IVR systems and preparing test scripts to support the testing process Experience in implementing automation architecture using Python, Pytest, Selenium WebDriver, Jenkins, etc.
• Created libraries and test scripts in Python for the automation testing Setup testing environment and maintained framework using Python. Implemented Page Object Model framework with Python and Selenium. Used python to develop Automation framework to Validate RESTful Web Services Involved in testing both SOAP and REST services using Rest Assured and tested both XML and JSON formats. Performed speech quality analysis and speech path verification under the guidelines of senior IVR tester Developed PL-SQL
• Queries based on Business Requirements to validate Interval usage of TNS, MV90 Meters with Supplier Portal Reports. Captured functional requirements with use cases, user stories, user scenarios, use case diagrams and end-to-ends
• Identified range of non-functional requirements. Developed Automation scripts via Selenium Python for Company intranet portal Developed Test Plan, Test cases, test scenarios, expected results and prioritized tests. Wrote test cases, test conditions and test scripts in H

Confidential

QA Lead

Responsibilities:

• Providence Preferred is a Portland Oregon - based preferred provider organization composed of physicians, hospitals and ancillary service providers located throughout Oregon and southwest Washington. Providence Preferred is designed to manage the cost, delivery and quality of health care for our many insurers, third-party administrators, self-insured groups and individuals. Worked as Senior BA and QA in ICD-10 Remediation Project. Worked with various Vendors from across the country and worked on Specs for Inbound and outbound files.
• Prepared Test data using Facets Claims Test pro. Prepared BRD and Understanding Documents for User Stories Assigned to me. Peer reviewed BRD Docs and Test Plan Document. Involved in automating test cases using Selenium Web
• Driver with pytest. Performed impact analysis on applications impacted by Diagnosis codes. Was extensively involved in extract data testing process. Experience in Test driven development for functional and integration testing using Python PyUnit, Selenium frameworks. Coordinated with Oregon government to integrate the data received from them into Providence Health Plans Medication Management Process. Involved in Writing Python Scripts to develop automated scripts and frame works. Verified that the Current version of ICD-10 Diagnosis codes have been remediated with existing ICD-9 Diagnosis codes at Project level. Performed extensive data Analysis. Helped in conducting Gap Analysis (GAP), User Acceptance Testing (UAT), and System Integration testing (SIT) and SWOT analysis. Involved in implementation of HIPAA EDI Transactions (835,837) Facilitated Electronic
• Data Interchange. Performed GAP Analysis for HIPAA 4010 and 5010 transactions. Used EDI tools to verify mapping to X12 format. Recommend changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards ANSI. Analyze HIPAA EDI transactions in X12 responses and of 837, 835, 277CA and 999 and looked for defects. Performed data analysis for various version changes of EDI messages on different sub-systems.
• Providing the required test data for the developers for defect fix. Participating in QA team meeting and bug tracking meetings.Environment: Python, Selenium, Microsoft SQL Developer, Microsoft MTM, Facets, Facets Claim Test pro, BDD/TDD frameworks, HTML Reports, Allure Reports, GIT, Jenkins, HTML, XPATH

Confidential

Business Data Analyst / QA Lead

Responsibilities:

• Premera Blue Cross is a nonprofit Blue Cross Blue Shield licensed health insurance company based in Mountlake Terrace, Washington, United States. It sells health insurance plans under the Blue Cross license in Washington state except Clark County and under both the Blue Cross and Blue Shield licenses in Alaska. It also has affiliate health insurance operations in Washington and Oregon under the Lifewise brand. Created SQL test cases to validate changes to Premera's core Transaction and Master data tables in IDS.
• Created SQL test cases to validate mapping logic, referential integrity in Facts and Dimension Tables in CUE. Validated newly acquired benchmark data in the Staging Layer against a copy of the original source in the Sandbox Database.
• Created 'claims test - bed' by data profiling and selecting representative claims based off clinical and cost factors from the data warehouse. Created test ICD-10 claims data by converting ICD9 claims in test-bed into ICD10 using
• Center for Medicare and Medicaid (CMS)' s's General Equivalency Mapping (GEM) algorithm. Worked with business users and BI developers to validate ICD-10 compliance of health care groupers (DxCG, ETG-ERG, PPER) using test ICD10 claims data. Presented findings from the ICD-10 testing of upgraded groupers to department heads of Health Care Economics, Corporate Informatics and Actuarial. Test data through all the layers from Acquisition to Presentation Layer Setup the Automation framework using Selenium WebDriver to run test cases in multiple browsers and platforms.
• Tested Cognos, Siebel Reports by Validation the data in the Distribution Layer Verified data displayed in the User Interface (UI) by creating SQL queries to retrieve data from various database tables such as the Siebel base tables, extension tables, intersection tables.
• Performed data validation by verifying the column mappings from the source table to the interface table and from the interface table to the Siebel base table Coordinated with UAT/Business users during UAT Testing Submitted BA, QA sign off documents and coordinated with Release engineers during deployments Smoke tested data after Post Deployment into Production servers Used Aginity, WIN SQL and SQL Management studio tools to connect Netezza, SQL server to build my test queries Performed End to End testing during
• PRISM Retirement Tested Rx and Medical Drill through reports at presentation layer Worked on Star Schema, Hierarchies, and Fact and Dimension tables Responsible for Updating Weekly Testing Status report to the Project Manager.
• Prepared HL7 Migration Mapping spec and tested them in Acquisition Layer Prepared BRD Documents for Data flow from in Acquisition, Integration, Distribution and Presentation Layer Worked on ICD - 10 Remediation projects and performed impact analysis that concerns Diagnosis codesEnvironment: Microsoft SQL Developer, Microsoft MTM, TFS, Netezza, Facets, Cogno

Confidential

Business Analyst

Responsibilities:

• Captured and Documented Business Rules to facilitate the migration of legacy Mainframe systems to new ETL process. Assisted Business, Development, and Solution Architect, and QA team to create Electronic Billing and Enrollment platform for Employers. Performed Data quality check by Score carding, created Data Dictionary and Data Trust Score logic for Trusted Information Hub Enterprise Architecture. Designed and oversaw implementation of end to end integrated system that included intermediate Database Design, Data modeling, ETL, FTPs,
• Desktop application and Web application. Used skills and technical expertise to assist development and QA team in resolving system issues. Worked in various sprints all through the project to help and make the developers understand the functionality.
• Gathered User Requirements and Business Requirements from Business User Group and documented Business/User/Functional/Technical Requirement Specification using MS Word and MS Visio that provided appropriate scope of work for technical team to develop prototype and overall system.Environment: Microsoft SQL Developer, Microsoft MTM, TFS, Netezza, Facets, Cognos Reports, Aginity

Confidential

Clinical Analyst

Responsibilities:

• Assisted in the development of departmental policies and procedures. Ensuring that Hospital is in adherence to current DHS, FDA, HIPAA, CDPH and JC Regulations. Designing and conducting evaluations and diagnostic studies to assess the quality and performance of health programs

  Developing operational plans and policies necessary to achieve health objectives and services. Supervise professional and technical staff in implementing health programs, objectives, and goals

  Document activities, recording information such as the numbers of applications completed, presentations conducted, and persons assisted Used Form Fast tool to update Physician, Nursing, Pharmacy ordersEnvironment: Form Fast, Meditech, HIPAA