Home

Sree Ram - QA / Lead QA Test Engineer 15+

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: GC

Sree QA / Lead QA Test Engineer Profile 15 Plus years of experience in Information Technology in the field of Software Quality Assurance, Data Analysis, ETL, OLAP, Databases, SQL, Software, Functional, Automation Testing. Extensive knowledge and experience in all phases of Software Development Life Cycle, Continuous Integration CI, Configuration Management (CM). from initiation to deployment and support. Expertise in STLC: Planning, Development, Test Environment Setup, Test Execution, Test Cycle Closure, Entry and Exit Criteria, Expertise in analysing Business/System Requirement documents, FDD (Functional Design Document), TDD (Technical Design Document) and Run Book. Extensive knowledge in aws cloud Delinea Secret Server, S3 buckets, EC2, VPC and airflow. Expertise in designing, developing, Analysing, estimating efforts, and executing Test Strategies, Test Plans and Test Cases, Bug / Defect Tracker, RTM, Test Results, Test Base and Test Results, Risk management, Risk identification, Risk impact analysis and Risk mitigation and replications. Expertise in perform testings such as: Black Box, White Box, Gray Box, Functional, Unit, Integration, Smoke, Sanity, System, Regression, Acceptance, End-to End, web Services API, Data Warehouse. Expert in define and establish quality assurance procedures, standards, metrics reporting , Firmware / Software and Builds. Excellent communication and problem -solving skills. Domains -Experience Healthcare, Insurance, Telecom. Finance, Mortgage, Banking, Tax filing and Accounting, Aeronautical, Embedded Systems like TV, Mobile, System. Experience: DA/Testing Functional, Webservice Service API, SOA, Restful, Automation, Backend, Data warehouse, ETL. Types of testing - SIT, Integration, Unit, Regression, Sanity, Smoke, Black Box, White Box, Acceptance, Web Testing, BI testing, Compatible, usability testing. ExpertiseData Analysis, Data Mining, Data Manipulation, Data Visualization, Data Modeling, Data Profiling, Data Forecasting, Data Auditing, Data Mapping, Data Loading, Data Validation, Data Integration Business Intelligence, Data Warehousing/ ETL. Claims processing including UB and HCFA and adjudication of the claims including ITS Home and Host including triggering SF, DF, RF files. Creating, linking, and validating "Depository Financial Institution (DFI)", "Payer", "Insurance Product , Network", Category, Benefit Plan, Benefit Payment, Claim, "Product-Network", "Benefit Category", "Benefit Plan", "Contract Classification", "Contract", "Provider (Facility / Provider Group)", "Professional (Individual Provider)", "Provider Contract", "Member Group", "Member", Claim. Validating Claim benefits, deductible, COB, Submission Dates, Receive Dates for inpatient and outpatients. Validating claims provider, subscriber/member details and their contacts. Validating claim's DFI, Payer, Insurance products, Network, Benefit Category, Benefit Plan, Benefit Payment, Contract Classification, Contract, Provider, Professional, Provider Contract, Fee Schedule, Member. Validating Insurance Products and its Network, Benefit Plan, Benefit Payment, Member, Claim. SQL Queries, Store Procedures, Triggers, Views, Indexes, functions, joins, subqueries. Methods for API/Webservices testing - HTTP, POST, GET, and WSDL and URL/URI EDI Files -834, 837, 999, 835, 850, 810, 270, 271, 276, 177 mock-up and validation. Federal Employees Health Benefits Program such as Part A (Hospital Insurance) and Medicare Part B (Medical Insurance) coverage, prescription drug coverage (Part D). Case submitting, processing, maintaining for programs SNAP, TANF, CASH, APEAL, FRAUD, Data Conversion, Homeless, Refugee, IDA, Disaster SNAP, POWER. Absent Parent Child Support Evidence (APCH), Child Support (CH) evidence, Absent Patent (AP) evidence for Child Support. Strong debugging and analytical skills for computer platforms, with any embedded SW domain experience. Strong Experience in applications including reports, parameters, claims management, intake services, carrier/client interfaces and vendor/business partner interfaces. Program -Skills T-SQL, PL/SQL, Java OOPs, Java Script, XML, HTML, Gherkin and Python. Tools Jira, ALM, SoapUI, Putty, Postman, Selenium WebDriver, Eclipse, Microsoft Teams, TFS, Informatica (workflow), WinSCP (SFTP access), MS visual studio, Informatica 7.1/6.2, Data junction, Ab-Initio, Data Stage, SSIS, Windward, Ikasystem, Facets, Testrail. Data Modeling Tools Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5, Embarcadero ER/ Studio 9.7. Databases Oracle, MySQL, SQL Server, Sybase. Database Skills o Experience in database validation using MS-SQL, MySQL, Oracle, TOAD. o Hands on experience create Tables, Views, Indexes, Stored Procedures, Functions and Triggers. o Creating and execution of complex queries using T-SQL, PL/SQL o Creating DTS/SSIS Packages to Import/Export data and reports using SSRS, Crystal Reports. Project Management Managing projects using Extreme programming and Scrum process of Agile and waterfall Methodology. Leading testing teams onshore and offshore, helping in defining project scope, scheduling meeting analyzing requirements. Establishing Test estimates, milestones, identifying risks and define and monitoring guidelines. Tracking and reporting on the status of projects to stakeholders. Commitment and attention to detail and a commitment to delivering high-quality software solutions. Lead Activities Leading the team including offshore, Conducting Scrum Stand-up meeting, Assigning the tasks and Planning, Execution, Reporting, Training, Mentoring, aligning with and supporting business goals, collaborate developers. PROJECT EXPERIENCE Client: Vizio Role Test Manager / Lead Test Engineer /AUG2023 Current Vizio Holding Corp. is an American publicly traded company that designs and sells televisions, sound bars, viewer data, and advertising. Responsibilities: Major Role: Managing the team including offshore and performing hands on ETL and UI testing. Managing multiple projects and Tasks and Teams and leading teams in on-sight and offshore. Maintaining Scrum/standup calls as a scrum master including Quick of and retro meeting. Gathering the documents such as spec documents and preparing test plan, Clarification tracker, RTM, Test scenarios, Test Cases, bug reports and estimation Reports. Scheduling interview calls for new commers and scheduling KT sessions for new resources. Preparing KT documents for the new resources to make them understand business of the client and project. Identifying the test environment and testing tools team types of testing and priority and timeline and criticality for software. Discussing with Voice president and mangers with regards requirements and Devices and tools that QA team need to make available to the resource to perform testing. Getting access to the test environments such as Dev, QA, Prod environments to perform testing based on the requirement. Designing the testing in Test rail and assigning the tasks every day for resources and testing as well. Reviewing legacy bugs to perform Jira Cleanup activity. Testing with Airplay, Mobile casting and UI testing and API testing and backend validation with SQL queries. Logging the bugs in Jira and assigning to dev team and do follow up the bug status and providing the required info that need dev to fix if needed and closing the ticket by re-testing and updating documents. Performing Smoke, Adhoc, s SIT/Full Sweep, Sanity and UAT, performance Testing with tools: Test Rail, Jira, and timer tool. Performing Apps Testing including Apps Launch, Apps Switching, Apps playback in various environments based on the requirement and comparing the results. Performing testing on Native apps and HTML apps and with connect and power off scenario. Performing embed testing with TVs (5581, 5586, 5583-08, NVT2690-2K, Novatek-HKC, 5597 15x/17x/18x) of releases such FUR6.0, FURL6.0, FUR6.xxx, FUR7.0 and 7.xxx, with builds / FW# ex: 86.700.39.1-v-1. My device with TV such as Soundbar, Antenna and voice assistance: Alexa, Google Chrome, Firestick, and remotes such as IR and BT devices. Performing upgradability testing to check for the new updates in TV by OTA / Silent updates. Performing applications on modules such as Conjure, LOKI, OOBE, Network, WiFi, WatchFree, System Menu, Input Switching. Performing various types of testing in environments / SC config such OSQA-TEST, Release Candidate, and prod. Preparing WSR (Weekly Status Report) for every week and presenting to the client and sharing the report to client and Infovision as well. Performing upgradability testing by sideloading/OTA updates with DevOps teams and validating binaries updated. Performing API testing with Postman and validating backend testing and validating the UI features. ETL and DB validation: Validating Mapping documents, Structure validation, Constraint validation, Data Consistency validation, Data completeness, Data Correctness, Transformation, Data Quality validation, Duplicate Validation and Data Check in source and target and full data validation. Validating the standard date format across all the records in source and Destination to be as expected. Validating the precision values and compared in source and Destination. Performed the Null check for every column that displays null values as per the business document with IS NULL statements. Validating data length check, data type. Validating data in reports such as Top Impacted Itineraries , Hot Flight reports , My Flights Making Hot , My Flights Made Hot Dashboard , Detailed View , Aggregated View , Flight Number Assignment . Environment: Device Config tool, Axial, POSTMAN, NOC Prod ServiceNow, JIRA, Oracle Developer, Agile/Scrum/Kanban, Restful API Testing, SQL Server, python, Microsoft Test Manager, Microsoft Teams, AWS_CLOUDS, DUO Authorization, Outlook, SQL server, slack, Client: United Airlines Role Lead Test Engineer / APR2022 JUL2023 LOC: IL Remote Project: NP Modernization - Desktop App AWS cloud Migration web app for IBPR, FNA and IDEAS applications. United Airlines is migrating all the desktop applications to AWS cloud with some new features. Responsibilities: Leading the teams including offshore and Onsight, Interacting with teams such as Scrum master, BA, Developers, and client UAT teams. Gathering the documents such as Run book FDD, TDD, project plan from business and preparing testing documents including Clarification tracker, RTM, Test plan, Test scenarios, Test Cases, bug reports and estimation Reports. Identifying the test environment and testing tools and preparing the team and arranging the application KT to the team members. Getting access to the test environments such as Dev, QA, aws_dev, aws_QA and prod for IBPR, IDEAS, FNA applications. Preparing WSR reports for every week, Status Trackers for every day, Bug Tracker and defining entry and exit criteria for the tasks. Designing the test cases for backend processes such as UACodeshare process, Pub_Daily Capture, Pub_Daily SSIM creation, SSM Process, Handoff creation process, QC Capture, Download the files from PSS. Design and execute test for Schedule pub_UI-Login, schedule_pub_ui_compare UI. Design and execute the tests for UI of IBPR and compare the legacy with aws application for the modules such as evaluate, preview, post analysis, Maintenance, Alert -Evaluate Results and with Top impacted Itineraries, Hot Flights Report, My Flights Making Hot, My Flights Made Hot, Aggregated view, Detailed View, Dashboard, Block Protect, reaccomodation option, Reaccomodation option Noprotect including UI functionalities. Design and execute UI and data validation for Flight Number Assignment (FNA) for the models FNA, QC, CANDLIST, Tables, Reports, Runinfo for the functionality create, copy, save and delete functionality. Compare exported reports data between legacy and aws app. Data Analyst: Developing algorithms to transform data into actionable insights. Collaborating with management to fulfill company objectives. Creating new data validation methods and data analysis tools Day-to-day tasks for a software engineer might include Designing and maintaining software systems. Building, testing, and maintaining database pipeline architectures and evaluating and testing new software programs. Optimizing software for speed and scalability and writing and testing code. ETL and DB validation: Validating Mapping documents, Structure validation, Constraint validation, Data Consistency validation, Data completeness, Data Correctness, Transformation, Data Quality validation, Duplicate Validation and Data Check in source and target and full data validation. Designing, analyzing, and managing all data within the system is performing activities that will help ensure successful data conversion. Validating the source format of numbering the columns in source and Destination databases. Validating the standard date format across all the records in source and Destination to be as expected. Validating the precision values and compared in source and Destination. Performed the Null check for every column that displays null values as per the business document with IS NULL statements. Validating data length check, data type. Validating data in reports such as Top Impacted Itineraries , Hot Flight reports , My Flights Making Hot , My Flights Made Hot Dashboard , Detailed View , Aggregated View , Flight Number Assignment . Environment: POSTMAN, SOAPUI, ServiceNow, CRM, Rest APIs, JIRA, Oracle Developer, Agile/Scrum/Kanban, Restful API Testing, SQL Server, python, Microsoft Test Manager, Microsoft Teams, AWS_CLOUDS, DUO Authorization, Outlook, SQL server. Client: Kaiser Permanente / Role: QA Co-ordinator / Software Test Engineer-ETL & DB /LOC: CA/ SEP2021- MAR2022 Kaiser Permanente is recognized as one of America's leading health care providers and not-for-profit health plans. Kaiser Permanente is an HMO plan with a Medicare contract. Enrolment in Kaiser Permanente provides services to Medicare and Medicaid beneficiaries based on the zones for various state and federal clients.KP is located at 1301 California St, Redlands, CA 9237. Responsibilities: DA/ Functional, Regression, Security, Link, API, ETL, FACETS, Data warehouse, Backend/database testing, UI, UAT, Automation testing. Attending scrum meeting and updating the assignment and impediments to scrum master and team. Involving in sprint plan meeting and estimating story points for the stories for the sprint on scrum /Kanban board. In-depth understanding of Medicaid and Medicare architecture and technical requirements, along with current knowledge of best practices. Scheduling team meeting such as Sync call with offshore and onshore team for co-ordination of assignment and status updates and collaboration of team assignment. Interacting with Dev Lead with regards code deployment, environments, code version releases. Designing the Test Scenario and Test cases and reviewing Test Cases designed by Team and gathering URLs for UI and database details and table info for backend validation, data mapping documents for ETL testing, regression prioritized test cases for automation testing. Performing Database testing, Webservice Service API Testing, EDI, Backend, Data warehouse, ETL, Security, Link, backend, DWH testing. Supporting UAT and production testing team loading the EDI 837 I and 837P files bases working with CTRLM team. Creating EDI 837 institutional and Professional and validating the acknowledgment 999 EDI files using Edifecs spec builder. Validating claims using the FACETS application. Designing and developed of ETL processes using Informatica ETL tool for dimension and fact file creation. Data Analysis including: Work with executives and other business leaders to identify opportunities for improvement. Collaborate with team members to collect and analyze data. Create presentations and reports based on recommendations and findings. Use graphs, infographics, and other methods to visualize data. Create reports for internal teams and/or external clients. Database testing including: Performing functional, Non-functional testing on databases and UI. Performing Database Schema and Trigger Testing Verify the Key and indexes in each table. Designing SQL queries to implement CRUD. Verifying whether a stored procedure is defined, and the output results are compared. Validating the data types in the database to field values in front-end application. Validating the length of data field in database to length of data types in the application. Checking if there are any unmapped tables or columns in the database from application field objects. Validating Naming conventions of database tables and columns are verified as per Business document. Validating the Keys and Indexes in the database, i.e., primary, and foreign keys in tables are defined as per requirement. Check if the primary keys and their corresponding foreign keys are the same in two tables. Check Unique and NOT NULL characteristics of keys are maintained. Validating Length and data type of keys and indexes for fields as per the document. ETL validation including: Analyzing assessment document, designing the scenarios, and preparing test plan. Ensure sound interface specification documentation to facilitate data exchange between various system components. Validating the file name for the extracted from source and loaded in landing zone. Mocking up the claims for ETL process and performed run ETL jobs in Jenkins. Checking source and target record count in source and target tables with SQL function. Checking for the duplicate records in stage and Target database with SQL statements. Validating the standard date format across all the records in source and Destination to be as expected. Validating the precision values and compared in source and Destination. Performing the Null check for every column that displays null values as per the business document with NULL statements. Automation testing includes: Identifying the elements with locators and developing the scripts in java and running the automated scripts. Setting automation framework (TESTNG) and cucumber for regression testing with java. My API testing includes: Gathering payload and WSDL file for Webservice testing with SoapUI. Creating collections, Test Suits, Test Cases, implementing methods such PUT, POST, GET, DELETE. My UI/GUI/FRONTEND testing including: Checking the functionality of application, buttons, forms and fields, calendar and images, navigation from one page to other, and the overall functionality of the application. Inserting new UB and HCFA claims by providing Patient information, provider information, COB information if it has, UB/HCF claims information, UB/HCFA codes information. Validating claim status, claim details, payment details, EOB notes, History, Track. Benefits, deductible, provider, member details, receive date, COB, CPT codes. Environment: java OOPs JavaScript, POSTMAN, SOAPUI, FACETS, ServiceNow, Selenium Web driver, CRM, Rest APIs, JSON, JIRA, Oracle Developer, Agile/Scrum/Kanban, Restful API Testing, SQL Server, python, Medicaid system, Microsoft Test Manager. Client: EHI (Advantansure)/ Role: QA Lead / Software Test Engineer-ETL /LOC: Richmond VA/ SEP2019- AUG2021. EHI (Advantansure) is in the business of delivering Health Information Technology (HIT), Solutions, & Services to healthcare practices. Supporting clients: BCBS-Nebraska, BCBS-Kansas, Lasso, BCBS-Michigan, BCBS-North Dakota, BCBS-Vermont, BCBS-Wellmed, BCBS-Premiere etc. under ecosystems. Responsibilities: Functional, Regression, Security, Link, API, ETL, Data warehouse, Backend/database testing, UI, UAT, Automation testing. Attending scrum meeting and updating the assignment and impediments to scrum master and team. Involving in sprint plan meeting and estimating story points for the stories for the sprint on scrum /Kanban board. Scheduling team meeting such as Sync call with offshore and onshore team for co-ordination of assignment and status updates and collaboration of team assignment. Interacting with Test manager to discuss about the test setup, team tasks and assignment and hours allocation and team performance. Interacting with PO (Product owner) with regard assignment, PPM codes for the Epics, CRs, Stories, DLE (Detailed Level Design). Interacting with Dev Lead with regards code deployment, environments, code version releases. Performing testing in Local environment (QA), deferent regions such Region C, G, H, Stage and production environments. Reviewing Test Cases designed by Team and gathering URLs for UI and database details and table info for backend validation, data mapping documents for ETL testing, regression prioritized test cases for automation testing. Executing the test cases and logging defects/story bugs in Jira assigning to the dev lead and retesting, preparing test results assigning to BA and PO for their approval. Performing Webservice Service API Testing, Automation, EDI, Backend, Data warehouse, ETL testing and UAT, SIT, SOAP, ETL, Security, Link, backend, DWH testing. Validating the Medicare and Medicaid claims processed in claims tables, claims history table for inpatient and outpatients ITS home and host claim as well by triggering Claims to validate the Claim s Group, Benefit plan, Benefit Effective Date, Term Date, Subscriber Number, provider id, claim details, payments, EOB Reports, History. Executing Packages, Triggers, procedures for claims validation in claims database. Supporting UAT and production testing team loading the EDI 837 I and 837P files bases working with CTRLM team. Creating EDI 837 institutional and Professional and validating the acknowledgment 999 EDI files using Edifecs spec builder. Mocking up EDI 834 on Edifecs spec builder and load files in drop location to get picked up by the job in order to process and implement the business rules. Validating the EDI 999 acknowledgment and validating the backend testing for the values in the UI. Data Analysis including: Work with executives and other business leaders to identify opportunities for improvement Collaborate with team members to collect and analyze data. Create presentations and reports based on recommendations and findings. Use graphs, infographics, and other methods to visualize data. Create reports for internal teams and/or external clients. UI/GUI/FRONTEND testing including: Checking the functionality of application, buttons, forms and fields, calendar and images, navigation from one page to other, and the overall functionality of the application. Inserting new UB and HCFA claims by providing Patient information, provider information, COB information if it has, UB/HCF claims information, UB/HCFA codes information. Validating claim status, claim details, payment details, EOB notes, History, Track. Creating "Depository Financial Institution (DFI)" and Validating DFI which is used by Payer, Provider, Professional, Claim. Creating "Payer" and linking to DFI and validating payer in Member Group, Claim, Insurance Product, Network. Creating "Insurance Product and linking to Network and payer and validating in Network, Benefit Plan, Benefit Payment, Member, Claim. Creating "Network" linking to Insurance Product, Payer, Benefit Category validating in Insurance Product, Provider, Professional, Benefit Category, Benefit Plan, Benefit Payment, Claim. Creating "Product-Network" and linking to Insurance Product, Network and validating its existence in Insurance Product, Network. Creating "Benefit Category", Linking to Various limiting factors (Tags) That allow the benefit to be specific to certain provided services. Such as Service code, Diagnosis, Revenue code, Patient Gender, Etc. And validating it in Benefit Plan, Benefit Payment, Claim, Network. Creating "Benefit Plan", Linking to Network, Benefit Category, Insurance Product and validating its existence in Member Group, Member, Claim, Benefit Payment Benefit Payment' Linking "Contract Classification" to Various limiting factors (Tags) That allow the contract classification to be specific to certain provided services. Such as Service code, Diagnosis, Revenue code, Patient Gender, Etc. Creating "Contract" and linking to Fee Schedule, Classification and validating it in Provider Contract, Provider, Professional, Claim. Creating "Provider (Facility / Provider Group)" and linking to Network, Professional, Contract, DFI and validating it in Professional, Provider Contract, Claim. Creating Professional (Individual Provider) and linking to Network, Provider, Contract, DFI and validating in Provider Contract, Claim. Creating "Provider Contract" and linking to Network, Contract, Provider, Professional and validating in claim. Creating a Fee Schedule" and linking to Various limiting factors (Tags) That allow the fee schedule to be specific to certain provided services. Such as Service code, Revenue code, etc. And validating it in Contract and Claim. Linking Member Group to Group, Benefit Plan, Insurance Product and validating in Claim. Creating "Member" and linking to Group, Benefit Plan, Insurance Product and validating in Claims. Inserting new "Claim" and linking to DFI, Payer, Insurance Product, Network, Benefit Category, Benefit Plan, Benefit Payment, Contract Classification, Contract, Provider, Professional, Provider Contract, Fee Schedule, Member and validating claims status and event codes, Benefits, deductible, provider, member details, receive date, COB, CPT codes. ETL validation including: Analyzing assessment documents, designing the scenarios, and preparing test plan. Validating the file name for the extracted from source and loaded in landing zone. Mocking up the claims for ETL process and performed run ETL jobs in Jenkins. Checking source and target record count in source and target tables with SQL function. Checking for the duplicate records in stage and Target database with SQL statements. Validating the standard date format across all the records in source and Destination to be as expected. Validating the precision values and compared in source and Destination. Performing the Null check for every column that displays null values as per the business document with NULL statements. Automation testing includes: Identifying the elements with locators and developing the scripts in java and running the automated scripts. Setting automation framework (TESTNG) for regression testing with java. API testing includes: Gathering payload and WSDL file for Webservice testing with SoapUI. Creating collections, Test Suits, Test Cases, implementing methods such PUT, POST, GET, DELETE. Updating the request file with valid data for positive test cases and invalid data for negative test scenarios. Validating the response file for status and messages. Mobile app Testing includes: Testing GUI features of Mobile for native application, web application, Web browser application, social medial applications. Testing touch screen feature of Mobile Testing Functionality of every feature on mobile. Testing GPRS, Memory testing, network testing and severity testing, SIT, Functional, installation, uninstallation, HTML, Check in multiple mobile app, cross browser =, Gateway testing, Network and Battery testing. Testing Display sized, Resolution and network testing with 2G, 3G, 4G and WIFI performing testing such as interrupt testing, Compatibility testing, negative testing. Testing messages by sending and receiving with different mobiles and browsers. Testing simulators and emulators. Environment: java OOPs JavaScript, POSTMAN, SOAPUI, TFS, Selenium Web driver, CRM, Rest APIs, JSON, JIRA, Oracle Developer, Agile/Scrum/Kanban, Restful API Testing, SQL Server, python, Microsoft Test Manager. Client: Verizon - Role Senior Software Lead Test Engineer / OCT2017-AUG2019// LOC: 700 Irving, TX FXO XO migration to VZ [ ETL] Verizon is one of the largest communication technology companies in the world. ... The company offers voice, data and video services and solutions. My responsibility at the client is validating and testing the migrated applications and data from XO telecommunications moving to Verizon. Responsibilities: ETL, Rest Services, Data warehouse, Backend, and Mobile testing. Gathering the documents from business and preparing testing documents including Clarification tracker, RTM, Test plan, Test scenarios, Test Cases, bug reports. Reviewing the test conditions prepared by team and provided review comments to modify the test cases in order to reuse. ETL validation including: Validating Mapping documents, Structure validation, Constraint validation, Data Consistency validation, Data completeness, Data Correctness, Transformation, Data Quality validation, Duplicate Validation and Data Check in source and target and full data validation. Validating the source format of numbering the columns in source and Destination databases. Validating the standard date format across all the records in source and Destination to be as expected. Validating the precision values and compared in source and Destination. Performed the Null check for every column that display null values as per the business document with IS NULL statements. Validating data length check, data type. Used Hive to read and write data in petabytes of data with SQL. Meta Data validation including: o check, Constraint/index check. o Validating input data and expected results as user. o Comparing the range of submissions of values in each field between the target and source data. o Validating surrogate key and data type in both source and target as per the requirement. o Validating parent to child relationship in the data Performing order and billing validation in the response file. Performing Order Placement, Billing, Data Usage and site survey. Working on Customer Relationship Management (CRM)/ SRM, Billing only Orders, MACD orders, Vendor IPT, Install, Proposals, Modification orders for business processes, customer data and customer interaction. Testing: Functional and performance test of services. Functional, Unit, Integration, Regression, Security, Interoperability, Compliance and Performance Testing. Automation: Developing test scripts for automation. Implementing TestNG, BDD and involved in Hybrid framework for UI automation with Selenium WebDriver with java. Implementing browser compatible testing and OS compatible testing. Environment: JavaScript, TFS, Selenium Web driver, JAVA, Confluence, Rest APIs, SoapUI, JSON, JIRA, Oracle Developer, Agile/Scrum, Restful API Testing, SQL Server, Spark, Microsoft Test Manager. DHS-DHCF - Senior Software UAT Test Analyst- MAR2016 SEP2017 LOC: 655 15th St NW, Washington, DC 20005 & 441 4th St NW, Washington, DC 20001 Project: DCAS R2.0, R2.2 The Department of Health Care Finance (DHCF) DC state government, formerly the Medical Assistance Administration under the Department of Health, is the District of Columbia s state Medicaid agency. Responsibilities: UAT, Regression, Functional, SOA, Backend, DWH, ETL testing.. UI Testing: Attending Agile Scrum, Review, Planning and estimation, Retro meetings. Gathering required BRDs, Mapping document, URLs, Database details. Gathering Tools info, environments info for testing. Preparing Test Plans, Test Conditions, QA metrics, Test Reports, Defects Reports. Preparing test data and executing tests and validating the application as per the requirement in front end. Designing SQL statements as per requirement and validating the values in database tables. Developing test scripts for functional testing for programmes such as Food, Cash, SHOP (Small Business Health Options Program) and IPV (Intentional Program Violation), Child and Dependent Care Tax Credit application, Absent Parent, Custodial parent, Child Support payment, IDA, POWER, SNAP (Supplemental Nutrition Assistance Program) Application, TANF (Temporary Assistance for Needy Families), Designing test cases for SOA testing and validation in response file. Editing the SOA payload to create, update, retrieve, delete users and user accounts with methods POST, PUT, GET, DELETE. Verifying the files transformed in SFTP with tool WINSCP with valid credentials and data. Validating the status as per the requirement document. Validating the requirement in the backend in database tables. Designing for Database testing and ETL testing as per the requirement/mapping documents for source and target. Performing Rest API testing on (OAG (agent), Curam (app DB) testing using tools SOAPUI and Informatica for workflow. Performing metadata validation by verifying columns names, data types, constraint like PK, FK, NULL, NOT NULL, and Default value in source and destination databases. Environment: JavaScript, Selenium Web driver, JAVA, Confluence, Rest APIs, SoapUI, JSON, JIRA, Oracle Developer, Agile/Scrum, SQL Server, Team Foundation Server, JIRA. Client: Comcast- Sr. Software Lead Test Engineer - AUG2015 FEB2016 Comcast Corporation is a global media and technology company with two primary businesses: Comcast Cable and NBCUniversal. Comcast Cable is one of the United States' largest video, high-speed Internet, and phone providers to residential customers under the XFINITY brand, and provides these services to businesses. Responsibilities: Functional and API testing. Attending daily stand-up meeting, Review meeting, sprint plan meeting, triage meeting, and Retrospective meeting. Gathering requirement, analysing requirement and designing scenarios and designing test cases. Manage the execution of Regression /Integration/Functional tests and the documentation of tests results Gathering payload and WSDL file for Webservice testing with SoapUI. Parameterising to set environment in Postman and Running collections. Running collection with desired no. of iterations in postman. Creating report and export report to desired folder from Postman. Creating collections and configuring environment in postman and Testing and finding defects in the software and logging in defects in Jira. Reporting the defects to make it easier for the developer to fix. Utilized @POST, @GET, @PUT, @DELETE methods in Postman to perform actions create, read, update and delete. Validating the response file and status code and comparing with expected values. Updating the WSDL file with test data and sending request and validating response file for expected value. Performing Order Placement, Billing, Data Usage and site survey. Working on Customer Relationship Management (CRM)/ SRM, Billing only Orders, MACD orders, Vendor IPT, Install, Proposals, Modification orders for business processes, customer data and customer interaction. Performing backend validation in oracle database tables vs API input parameters and respond file results. Environment: POSTMAN, TFS, Rest APIs, SoapUI, JIRA, Agile/Scrum, POSTMAN, SQL Server, Team Foundation Server. Client: EY- Software Test Engineer (ETL) - NOV2014 JUL2015 EY, formerly known as Ernst & Young Global Limited, is a multinational professional services network with headquarters in London, Englander is one of the largest professional services networks in the world. It primarily provides assurance (which includes financial audit), tax, consulting and advisory services, accounting to its clients. RESPONSIBILITIES: Functional, Web services, UI automation Testing, Data base and ETL Testing. Reviewing the BRD, HLD. Prepared Test Deliverables- Test Scenarios, Test Cases, Test Execution. Comparing records counts between source and target and checked for any rejected records. Checking for the Data if truncated in the column of target table. Uploading the Test cases from excel to Quality Center executed in Test Lab, raised defects in defect module. Checking for the duplicate records in stage and Target database. Validating the source format of numbering the columns in source and target. Validating the standard date format across all the records in source and Target to be as expected. Performing precision check in source and Target tables to make sure to be as expected. Validating the data check based on the business logic and filtered out the records which does not meet certain criteria. Understand each report & the mapping of every field displayed in the report with the schema and trace its origin back to the source System Preparing documentation for some of the recurring defects and resolutions and business comments for those defects. Testing the BI reports and reported the result to Stake holders. Verification of the GUI: layout format, style sheets, prompts and filters attributes and metrics on the report. Environment: JavaScript, Selenium Web driver, JAVA, Rest APIs, ETL, Informatica, SoapUI, JSON, JIRA, Oracle Developer, Agile/Scrum, Restful API Testing, SQL Server, Team Foundation Server, TFS, JIRA, Oracle. BCBS Healthnow Buffalo, NY - Senior Software Quality Assurance Analyst - JUL2013 OCT2014 Healthnow New York will provide you with the perfect healthcare plan. Individual health insurance, Medicare, insurance for businesses and more. Headquartered in Buffalo, NY. PROJECT: PUBLIC EXCHANGE, FACETS UPGRADE Public Exchange (Eligibility and Benefit Enrolment) Payment collection Facets upgradation Responsibilities: ETL and DWH Testing, Rest API, backend testing and UI testing. Attending agile, HLD (high Level Document) / BRD (Business Requirement Document) review, final meetings. Collecting the Business Requirement Documents from and understanding the business flow well. Automating UI with Selenium WebDriver with java for Regression Testing. Logging in to the NYS Exchange Test system and created the 834-enrollment transaction with Membership details of QHP single and multiple members details in QHP (Qualified Health Plan) with different plans (Full APTC, NO APTC, Partial APTC). Automated application eHealth for Obama Health care insurance for regression testing with Selenium Web Driver with TestNG framework. Automated the UI Customer and Employer portal to perform registration and claiming the insurance. Moving up EDI 834 file on Edifecs Spec builder to create test files, analyzing all EDI test files with 5010 implementations as per guides and gap analysis of EDI transactions. Performed Data warehouse testing for testing for Sybase client server. Performed ETL testing with Informatica for source and target and reporting data marts. Testing the claims processing with EDI transactions (270, 271, 835, and 837) in HIPPA. Validating the inbound file of 834 (Benefit enrollment) data which is coming from State NYS through Verifying the file 834 in EE (Error Exchange) which is moved to correction UI because of the premium pending. Verified the 834 enrollments in extreme systems which are meant to generate the first premium invoice Logging into on demand verified the invoice stored in folder and verified the billing entity in the facets Verifying the 834-effectuated file in Gate way and 999 in FTP. Involved in EDI transactions: 834, 835, 837, 820 process and prepared the test data maintained the claims. Validating and processing the Claims in Facets 4.71 and 5.01. ETL Testing responsibilities includes: Retrieving 1000 of Hospital claims, medical claims, with inpatient and Outpatient claims data from Qual1 Database with tiger proprietary tool of BCBS Healthnow. Involved on 820 (Payment Order/Remittance Advice). Validated Inbound/Outbound EDI transactions of 835 (Health Care Claim payment and remittance advice). Experience on Membership/Enrollment for Individual & Groups created and Validating Inbound/Outbound EDI transactions 271(Eligibility Coverage Information), 276 (Health Care Claim Status Inquiry), 999 (Implementation Acknowledgment). Designing the Test Cases in Test plan Module in ALM, Executing the Tests in Test Lab. Performing Data completeness to Compared total counts between the source and target, compare unique values and utilizing the data profiling tool to show the range of value distributions of fields in the data set. Checking the Data truncated in the column of target table. Verifying the data inconsistency and compared data in DVO. Checked for duplicate records and unique values loaded into the target Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting. Retested the existing test cases with the different kind of source systems for different periods of data. Preparing documentation for some of the recurring defects and resolutions and business comments for those defects. Understand each BI report & the mapping of every field displayed in the report with the schema and trace its origin back to the source System Environment: Agile/Scrum, Selenium WebDriver, FACETS, EDI 834,837,820, 276, 275, SQL Server, ALM (QC), Restful Service Testing. ALLY [GMAC]- Fort Washington PA - ROLES: Sr. QA / JAN2011 JUN2013 Ally is one of the largest car finance companies in the U.S., providing car financing and leasing. It is on the list of largest banks in the United States by assets. Responsibilities: Backend and ETL and Rest API testing. ETL Responsibilities: Accumulating required documents for REST API testing. Designing test cases based on the requirement and functionality. Validating Response Status, Response Header, Response Body using Rest Assured. Verifying Authentication and Authorization in REST Webservices Performing operations create, update, delete and Retrieve. Validating the data field validation, data validation for unique data. Checking for the duplicate records in stage and Target database. Performing boundary value analysis. Validating the source format of numbering the columns in source and target. Validating the standard date format across all the records in source and Target to be as expected. Validating the precision values and compared in source and target. Performing the Null check for every column that display null values. Validating the date format across all the records in source and Target as expected Environment: TFS, Agile/Scrum, Code GUI, SQL Server, QC, SOAPUI, UAT, ORACLE DB, SOAPUI ROLE: BCBS (Excellus) Rochester NY - Sr. Software QA - AUG2009 DEC 2010 Excellus BlueCross BlueShield is a non-profit health insurance company. It is a part of the Blue Cross Blue Shield Association, located at upstate New York. I worked on HIPAA 4010 migration to HIPAA 5010, in order to minimize the downstream application changes. Responsibilities: ETL, Backend, DWH, UAT testing. Working with Business analysts to understand High Level/System requirements in order to transform business requirements into functional specifications. Validating data completeness, data correctness, data transformation. Checking Nulls, duplicate records. Validating date checks and performing full data validation and data cleansing. Analysed Source to Stage and Stage to Target Mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied and target tables. Developing SQL queries and test data for Back-end testing/Database testing and participated in end-to-end testing. Involving in designing Test Plans, Test Cases, and Test Scripts to validate the functionality and executed with RQM and performed backend testing with SQL queries. Performing Regression testing and Report testing. Designing test documents for Mainframe based on application Managed Care Protocol System. Preparing Traceability Matrix with requirements versus test cases. Submitting 837 Claims via FTP Process and viewed in the HIPAA. Helped automation team in developing scripts and execution for regression testing. Processing Claims (837) for Institutional, Professional and Dental using FACETS and validated them with backend testing with SQL queries. Working Extensively with Inbound 837 I and 837 P, 835s (Out bounds) and Inbound claims processing systems. Environment: MS Access, Sybase, SQL server 2008, Oracle, SQL, IBM AS400 Mainframe, DB2, RQM, Waterfall, Mainframes, MS Excel and Windows XP [email protected] +1 571-5800-333 Keywords: cprogramm continuous integration quality analyst business analyst user interface business intelligence sthree database information technology hewlett packard purchase order fourg microsoft procedural language California Colorado Idaho Illinois New York Pennsylvania South Carolina Texas Virginia