SUMMARY

• 10 plus Experience in different phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) with Automaton, Interface (Integration), UAT, SIT, Webservices, ETL, DWH, Backend testing.
• Experience in domains: Finance, Mortgage, Migration, Banking, Tax filing, HealthCare, Insurance, HealthCare Finance, State projects.
• Expertise and conduct Automation testing, functional testing, integration testing, system testing, regression testing and user acceptance testing.
• Expertise in methodologies: Agile Methodology/SCRUM and Waterfall methodologies.
• Expert in languages: OOPS concepts of java programming, SQL, XML, HTML, Gherkin.
• Experience in Software Development Engineer in Test with all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) and SDET.
• Experience with Team Foundation Server for Work Item.
• Experience inSQLandPL/SQL scripting and Java OOPS concepts.
• Experience in ETL/Manual testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis as per the FDD.
• Analyzing experience of business requirement, design documentation, Functional Requirement Document.
• Experience in API with SoapUI and Postman for Webservice with SOAP and REstful services testing.
• Experience of source code repository Git and CI Jenkins.
• Implemented various testing frameworks such as, Data - Driven, Hybrid, Junit, TestNG, Cucumber, JUnit, ATDD/BDD, POM Frameworks.
• Comprehensive knowledge of test strategy, test plans, and QA estimate efforts based on collaboration with project team for both Agile and Waterfall projects.
• Expertise in querying and testingRDBMSsuch asOracle,MS SQL ServerusingSQL,PL/SQLfor data integrity.
• Experience of Tools: Selenium WebDriver, Jenkins, Maven, ALM Test management, HP ALM, Jira, SoupUI, Eclipse 3.4, Selenium 2.0, Selenium IDE and Selenium Grid. Putty (for batch), Informatica (workflow) and WinScp (SFTP access).
• Experience with JDBC connections, Oracle databases and PL/SQL and SQL server.
• Expertise in Executing the Test cases and raising the defects using the Defect Tracking Tool JIRA, BUGZILLA, ALM, Salesforce.
• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Expertise in ETL/DWH testing concepts, SSIS, TOAD, concepts.
• Have good experience in performing Cross-Browser Testing and knowledge of Selenium grid.
• Good in validating Cable Modem Termination Systems (CMTS) and Data Over Cable Service Interface Specification (DOCSIS).
• Experience using TFS for work items and MTM for test management.
• Knowledge of Testing of Confidential -Commerce websites and Testing of Point-of-Sale systems.
• Meetings attended: Project Quick of Meeting, Sprint Plan meeting, Scrum Standup meeting, Retro meeting and Triage meeting.
• Experience and Collaboration with BA, Developers, Architects, Team, managers.
• Experience with Risk management which includes Event, Probability, Impact, Mitigation, Contingency, Reduction, and Exposure.
• Experience in Risk management process including Risk identification, Risk impact analysis and Risk mitigation.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema
• Experience in processing FOOD (SNAP), Cash Assistance program (TANF) which assist Cash Benefit to help low income people to achieve self-sufficiency.
• Experience of processing special programs like RCA, IDA, Homeless, Fraud, Data Conversion, Appeal, Program Alignment, Burial Assistance (BA) and automating tests in selenium WebDriver.
• Experience in managing the programs like Notices, Recertification, Midcertification, Authorizing Representative.
• Experience in validating inventory, tracking Customer and sales history on POS.
• Experience in processing EDI transactions like 834, 837, 999 in spec builder and automate them with selenium.
• Experience in performance with JMeter for Load, Stress, Performance Testing.
• Expert processing the claims (837) with FACETS and validating the member data in backend of Sybase database with SQL queries.
• Experience in processing Medical Assistance for Low-Income children and adults.
• Experience processing case for School Meals for which the child may be entitled to school nutrition programs, such as school lunch and breakfast meals in interface Testing.
• Experience processing Summer Meals where a child may be entitled to school nutrition programs for Federal Reports in Interface testing.
• Validating eligibility for Dependent Care Tax Credit program, Care Assistance program, Commodity Supplemental Food Program.
• Experience processing Low Income Home Energy Assistance Program (LIHEAP) entitles to grants to help for heating and heat maintenance bills.
• Committed and hard working with a quest to learn new technologies and willing to take up challenging tasks.
• Proven ability in working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, reporting and Assisting to Manager.
• Good in Analytical, interpersonal, and both oral and written communication skills technologies.

TECHNICAL SKILLS

Test Approaches: Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle.

Testing Tools: Selenium WebDriver, Selenium IDE, Selenium RC, Selenium Grid, Cucumber, SoapUI, JUnit, TestNG, JMeter.

Test Build& Integration Tools: Maven, ANT, Jenkins

Frameworks: Keyword Driven, Data Driven, Hybrid, Page Object Model (POM)

Programming Tools: Core JAVA, PL/QL, C#, JavaScript, JSon, SQL, Gherkins.

Markup Languages: HTML, XML, XPath, CSS Selector

Databases: MySQL, Oracle, SQL Server, Sybase, Teradata.

Database Tools: SQL Server Management Studio, SQLite, SQL Developer, SQL Loader.

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari.

Operating Systems: Windows 7/8, Windows 10, Ubuntu, UNIX, LINUX

Defect Tracking Tools: HP Quality Center, JIRA, ALM, Salesforce.

MS Office Tools: Outlook, Word, Excel, PowerPoint, MS Access, Microsoft Project

Software Design Tools: Eclipse, Firebug, Fire Path, WinSCP, putty, MS visual studio, Selenium WebDriver.

Build Tools: Git, Jenkins

Webservices: SOAPUI, POSTMAN, REST. JMeter.

PROFESSIONAL EXPERIENCE

Confidential

Automation QA Engineer

Responsibilities:

• Involved in preparing Test Plans, QA metrics and mentoring the team in testing methodologies.
• Managed life cycle of automation project involving in hosting the automation meetings, coordinating, gathering the automation requirements, defining the scope of automation testing.
• Prepared test data like and gathered URL and Credentials for caseworker and supervisor for each environment like QA, QATT, UAT and Pre-Prod for Case worker portal, Citizen portal to automate.
• Developed the automated test script for regression test suite in an application by using Selenium WebDriver and Cucumber with java.
• Creating automation using Data Driven Framework with POM to test web application.
• Participating in release planning, sprint planning, and technical design reviews and retro meetings.
• Creating automated test cases based on the functional test cases created user stories.
• Developing Selenium scripts to find, verify, select, edit and perform various operations on web elements.
• Developing Selenium scripts to get the data from the webpage by using the methods like getUrl, getTitle, getAttribute.
• Performed Interfaces API s OAG, CATCH webservices testing with SoapUI.
• Developing scripts to navigate to various iframes and to handle multiple windows and performed operations on the web elements.
• Setting the priority to the test cases using the TestNG framework.
• Used various TestNG annotations like @Test, @BeforeSuite, @AfterSuite, @BeforeTest, @AfterTest, @BeforeClass, @AfterClass, @BeforeMethod, @AfterMethod.
• Performed browser (IE, Firefox, Chrome, Safari) and platform (Windows 7/8/XP) compatibility testing in virtual machine environment.
• Wrote Selenium script for taking screenshot and also used Actions class to perform mouse and keyboard events.
• Using Select class to perform operations on the dropdown list.
• Involved in using Maven build tool to manage framework dependency jar files.
• Used Cucumber by creating the Features and Step Definition files to execute test scripts.
• Used Apache POI to read data from external sources and provide them as parameter to the locators in the test script.
• Generated test logs using Log4j for various log levels.
• Used GIT to maintain and manage the build scripts, test data used and other documents related to the project.
• Performed performance testing using JMeter.
• Implemented Selenium Synchronization for Conditional and Un-Conditional waits using Implicit Waits and Explicit Waits.
• Designing feature file in Cucumber which consist of parameters i. Confidential . Feature, Scenario, Scenario Outline, Given, When, then required for execution code
• Designing Scenario Outline in feature file to execute for multiple set of data.
• Automating the Web Application for DC Residence for Food and Cash Benefits.
• Automating the Web Application for Special Conditions like IDA, POWER,
• Performing risk analysis and impact of the defect on functionality.
• Executing web services tests SOAPUI, Automation testing in Selenium WebDriver and manual tests in ALM 11.2,
• Automating SNAP (Supplemental Nutrition Assistance Program) Application, TANF (Temporary Assistance for Needy Families) Application, SHOP (Small Business Health Options Program) and IPV (Intentional Program Violation.
• Automated Child and Dependent Care Tax Credit application, Absent Parent, Custodial parent, Child Support payment.
• Executed IVR test cases in SoapUI 5.2.1. and validating.
• Performed operations on the database using JDBC APIs.
• Performing ETL testing in ACEDS (Legacy) and DCAS (New) with web services testing.
• Involving in writingSQL queriesandDatabase Checkpointsto verify data quality and calculations, review
• Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Creating ETL test data for all ETL mapping rules to test the functionality of theInformaticagraphs.
• Developing the automated test result Reports in TestNG.
• Working on defects, CR in QA, QATT, Pre-Prod and Productions Environments.
• Performing Interfaces testing on (OAG (agent), Curam (app DB) testing using tools SOAPUI and Informatica for workflow.
• Deployed the updated code for CI with Jenkins for Regression testing.
• Verifying the files transformed in SFTP with tool WINSCP with valid credentials and data.
• Verifying the client’s data in Interface Database with SQL developer with SQL queries.
• Running the batches for applications processed in web with PUTTY.
• Performing UAT, SIT, Regression, Defect, Smoke testing manually.
• Performing interface Testing with different agents OAG, CATCH, Data Builder etc.
• Performed metadata validation by verifying columns names, data types, constraint like PK, FK, NULL, NOT NULL, Default value in source and destination databases.
• Performed Data Validation by counting and comparing column to column values between source (ACEDS DB) and Target (DECAS DB) tables.
• Verified that valid values are getting populated in target table.
• Executed mapping with ZERO-byte file to verify that whether the graph is executed successfully or not
• Executed the graph with actual testable input file and saw whether all the target tables got populated.
• Verified that the input file is not empty and such file is placed in proper directory and format matches the DML.
• Used jMeter to run the performance testing.
• Verified if the mapping adheres to the development standards and naming conversions
• Verified that the mapping is doing what the technical design says.
• Verified that the mapping works correctly in relation to other processes in data logistical flow.
• Verified that the table is truncated before initial load.
• Verified that the input and lookup files are available in the specified directory.
• Verified that the format of the output files is according to their DML.
• Verified that the log files are created properly and consists of proper information
• Validated the data as required through the components in the graph
• Performed column to column (field to field) validation.
• Verified full length of the column is moved to the target by giving maximum length in the source
• Checked whether NULL is moved correctly to target by giving null values in all the NULLBALE fields in the source.

ENVIRONMENT: Selenium, WebDriver, Windows 10, HP ALM, Eclipse, Web services, SOAP UI Pro, Java, SQL Server2008, 2012 R2, SQL Plus, PLSQL, SQL, Agile, MS Excel Add-in, XML, UNIX, Scrum, Git, Jenkins, Curam, JIRA. Putty, WebDriver. WinSCP.

Confidential

Automation QA Engineer ( selenium) and SOAPUI

Responsibilities:

• Involved in preparing Test Plans, QA metrics and mentoring the team in testing methodologies.
• Managed life cycle of automation project involving in hosting the automation meetings, coordinating, gathering the automation requirements, defining the scope of automation testing.
• Gathered test data like URL and Credentials like for caseworker and supervisor for each environment like QA, QATT, UAT and Pre-Prod for Case worker portal, Citizen portal to automate.
• Developed the automated test script for regression test suite in an application by using Selenium WebDriver and Cucumber with java.
• Created automation using Data Driven Framework with POM to test web application.
• Participated in release planning, sprint planning, and technical design reviews and retro meetings.
• Created automated test cases based on the functional test cases created for user stories.
• Developed Selenium scripts to find, verify, select, edit and perform various operations on web elements.
• Developed Selenium scripts to get the data from the webpage by using the methods like getUrl, getTitle, getAttribute.
• Developed scripts to navigate to various iframes and to handle multiple windows and performed operations on the web elements.
• Setting the priority to the test cases using the TestNG framework.
• Used various TestNG annotations like @Test, @BeforeSuite, @AfterSuite, @BeforeTest, @AfterTest, @BeforeClass, @AfterClass, @BeforeMethod, @AfterMethod.
• Performed browser (IE, Firefox, Chrome, Safari) and platform (Windows 7/8/XP) compatibility testing in virtual machine environment.
• Wrote Selenium script for taking screenshot and also used Actions class to perform mouse and keyboard events.
• Implemented API testing on Curam and Agents API with SoapUI.
• Used Select class to perform operations on the dropdown list.
• Involved in using Maven build tool to manage framework dependency jar files.
• Used Cucumber by creating the Features and Step Definition files to execute test scripts.
• Used Apache POI to read data from external sources and provide them as parameter to the locators in the test script.
• Generated test logs using Log4j for various log levels.
• Used GIT to maintain and manage the build scripts, test data used and other documents related to the project.
• Implemented Selenium Synchronization for Conditional and Un-Conditional waits using Implicit Waits and Explicit Waits.
• Designing feature file in Cucumber which consist of parameters i. Confidential . Feature, Scenario, Scenario Outline, Given, When, then required for execution code
• Designing Scenario Outline in feature file to execute for multiple set of data.
• Automating the Web Application for DC Residence for Food and Cash Benefits.
• Automating the Web Application for Special Conditions like IDA, POWER,
• Performing risk analysis and impact of the defect on functionality.
• Executing web services tests SOAPUI, Automation testing in Selenium WebDriver and manual tests in ALM 11.2,
• Used Jenkins for Continuation Integration (CI) of updated code developed and updated.
• Automated SNAP (Supplemental Nutrition Assistance Program) Application, TANF (Temporary Assistance for Needy Families) Application, SHOP (Small Business Health Options Program) and IPV (Intentional Program Violation.
• Automated Child and Dependent Care Tax Credit application, Absent Parent, Custodial parent, Child Support payment.
• Performing ETL testing in ACEDS (Legacy) and DCAS (New) with web services testing.
• Performed Interfaces testing on (OAG (agent), Curam (app DB) testing using tools SOAPUI and Informatica for workflow.
• Verified the files transformed in SFTP with tool WINSCP with valid credentials and data.
• Verified the client’s data in Interface Database with SQL developer with SQL queries.
• Running the batches for applications processed in web with PUTTY.
• Performed interface Testing with different agents OAG, CATCH etc.
• Performed Shakeout testing with zero-byte file to verify the ETL process.
• Performed Field Level validation and data level validation
• Validated the data in ACEDS (Source db) and DCAS (Target db).
• Performed flat file validation with delimited with commas, pipes etc.
• Verified data types, compared rows of source and staging and target
• Validated the data inserted in tables in the database.
• Verified data types and compared the rows in source and destination tables in databases.
• Called the store procedures in backend using the EXEC command

ENVIRONMENT: Selenium, WebDriver, Windows 10, HP ALM, Eclipse, Web services, SOAP UI Pro, Java, SQL Server2008, SQL, PL SQL, T-SQL 2012 R2, SQL Plus, SQL, Agile, MS Excel Add-in, XML, UNIX, Git, Jenkins, Scrum, Curam, JIRA. Putty, WebDriver.

Confidential

Test Lead

Responsibilities:

• Attended scrum meetings, Triage meetings and Retro meetings.
• Participated in analysis of Business and functional requirements
• Developed Test Plan and overall Test Strategy for the Application.
• Gathered BRDs and FRD is and prepared clarification Trackers.
• Validated the protocols HTTP.
• Performed BDD (Behaviour Driven Development) using Cucumber Features, Scenarios and Step Definitions.
• Used SoapUI to test the application web services.
• Implemented Restful API testing with POSTMAN.
• Managed the framework dependency jars using Maven. Used Maven to perform build from Jenkins Continuous Integration.
• Implemented Jenkins for code Continuation Integrating (CI) in test environment.
• Performed continuous integration of code and scripts using Jenkins. Configured and launched builds using Jenkins jobs and analysed the Test Results from Jenkins UI.
• Worked on SQL queries to verify data integrity and validate updated data for the Test cases in different modules of the Medicare & Medicaid application.
• Performed Usability testing of the application and workflow involving multiple functional modules
• Worked with developers to Create and update the defects, resolve and track their status using JIRA.
• Used Implicit Wait method to halt the script to provide a default waiting time 30 seconds.
• Used Explicit Wait for a particular instance to halt the execution till the time a particular condition is met or the maximum time has elapsed.
• Developed automation scripts in the selenium WebDriver with Junit frame work.
• Attended AT&T client meeting and gathered business info.
• Performed the bandwidth of the data transfer on Data Over Cable Service Interface Specification(DOCSIS).
• Tested the telecommunications standard used to provide Internet access via a cable modem.
• Developed Amazon vendors test scripts and reviewed.
• Validated the MCxx cable modem cards capability to connect cable that connect modems on the HFC network to Cisco uBR200 and uBR7100 or a uBR10k IN Community Antenna Television (CATV) headend facility.
• Designed Test Cases in Jira, reviewed the and incorporated.
• Used and executed swagger for web services testing.
• Developed the test scripts in POSTMAN.
• Developed test suites and test cases and executed.
• Developed test reports and uploading into SharePoint.
• Executed the scripts in POSTMAN.
• Logged defect in Jira.

Environment: Postman, Slack, Swagger files, SAL, java, Smart phones, REST, Git, Jenkins, Jenkins, Agile Methodology. Bugzilla, SQL, PL SQL, T-SQL.

Confidential

Automation QA Engineer

Responsibilities:

• Attended Agile Scrum meeting, Status update meeting, Collaboration meeting, Retro meeting, Triage meeting.
• Reviewed the BRD, HLD and LLD. Prepared Test Deliverables- Test Scenarios, Test Cases, Test Execution.
• Verified the integration of various components in the application and executed end-to-end testing.
• Used navigate (). back ()method to take back the web browser to back status.
• Used navigate ().forward () to navigate to the next web page with reference to the browser’s history.
• Performed Integration, System, UAT and Usability Testing.
• Used to check navigate (). refresh () launch a new web browser window and navigate to the specified URL.
• Applied object oriented Programming(OOP) concepts like encapsulation, inheritance, polymorphism, and abstraction.
• Accomplished manual and automated testing for business client’s software development.
• Designed test case for inventory and customer and sales tracking system and automated.
• Experienced in handling the issues of Synchronization in Selenium with Java using waits such as Implicit wait, Explicit wait and Fluent wait.
• Used finding elements using locators like ID, Name, Link Text, Partial Link text, XPath, CssSelector and DOM.
• Designed manual test cases and executed in TFS 2012
• Developed and tested Restful Services and SOAP services by using different tools like SOAPUI, POSTMAN.
• Tested the application as per the test cases and business logic.
• Used Firebug/Fire Path Add-on tools to identify the Object's id, Name, XPath, link in the application.
• Performed the Backend integration testing to ensure data consistency on front-end by writing and executing SQL statements on the Database.
• Involved in debugging and testing of several components of the application.
• Implementing the Cucumber tool to implement POM to automate the web application.
• Performed Functional Testing, Regression Testing, Unit Testing, Integration Testing, UAT testing, and Acceptance Testing, Backend Testing and compatibility testing.
• Preparing the test plan for automation Testing.
• Used Gherkin language to express scenario in feature files.
• Developed the automation Test Scripts with java in Selenium WebDriver.
• Implemented the Cucumber with Page Object Model to automate the web Application.
• Prepared test data for the tests to process the case and replicate the defect.
• Coordinated Business Team, Dev, Architects, Peer Team.
• Developed and maintained automated regression tests in Selenium WebDriver in eclipse IDE with java.
• Used Tools Selenium WebDriver, Eclipse IDE, HP ALM, SoupUI, Jira.
• Implemented Frameworks with Junit, TestNG, Cucumber with POM.
• Performed Functional, Regression, GUI, Web services testing.
• Performed browser (IE, Firefox, Chrome, and Safari) compatibility Testing.
• Implemented Test Driven Development (TDD) approach with excessive Junit coverage.
• Prepared results in TestNG emailable and HTML reports.
• Designed and implemented test scripts and managed Selenium test automation processes.
• Extensively Tested Web Portals, Web Browsers and Web Interfaces.
• Automated Web Services (SOAP) using SOAP UI Tool.
• Executed Single Test Run and Batch Testing and Generated Test Reports.
• Implemented JBehaveand designed feature files with Gherkins and steps, Objects with java files.
• Executed the graph with actual testable input file and saw whether all the target tables got populated.
• Verified that the input file is not empty and such file is placed in proper directory and format matches the DML.
• Verified if the mapping adheres to the development standards and naming conversions
• Verified that the mapping is doing what the technical design says.
• Verified that the mapping works correctly in relation to other processes in data logistical flow.
• Verified that the table is truncated before initial load.
• Verified that the input and lookup files are available in the specified directory.
• Verified that the format of the output files is according to their DML.
• Verified that the log files are created properly and consists of proper information
• Validated the data as required through the components in the graph
• Performed column to column (field to field) validation.
• Verified full length of the column is moved to the target by giving maximum length in the source
• Checked whether NULL is moved correctly to target by giving null values in all the NULLBALE fields in the source.

Environment: Selenium, eclipse, Java, Quality Center 10.0, and 11.00, HTML, JavaScript, REST, Oracle 10g, Cucumber, Windows XP, IE, HTTP/HTTPS, VPN/Secure CRT, Excel, SQL Toad for Data Analyst 3.7, Test Management Tool ALM, Agile, GitHub, Excel 2010, SQL, PL /SQL, T-SQL Oracle, TFS.

Confidential, Buffalo, NY

Automation Test engineer

Responsibilities:

• Attended scrum meeting, Sprint plan meetings, Retro meetings, Triage meetings.
• Involved in GUI, Functional and Regression Testing.
• Performed Structural Testing, Functional Testing and Non-functional Testing Database Testing.
• Performed crossed browser testing with different versions.
• Developed the automated test script for regression test suite in an application by using Selenium tool.
• Created automation using Data Driven Framework with POM to test web application.
• Developed test scripts to automate process of testing in Selenium WebDriver.
• Developed Selenium scripts to find, verify, select, edit and perform various operations on web elements. Used Select class to perform operations on the dropdown list.
• Developed Selenium scripts to get the data from the webpage by using the methods like getUrl, getTitle, getAttribute.
• Developed scripts to navigate to various iframes and to handle multiple windows and performed operations on the web elements.
• Experience dealing with Ajax requests in Selenium Web Driver using Synchronization.
• Performed operations on the database using JDBC APIs.
• Setting the priority to the test cases using the TestNG framework.
• Used various TestNG annotations like @Test, @BeforeSuite, @AfterSuite, @BeforeTest, @AfterTest, @BeforeClass, @AfterClass, @BeforeMethod, @AfterMethod.
• Performed browser (IE, Firefox, Chrome, Safari) and platform (Windows 7/8/XP) compatibility testing in virtual machine environment.
• Involved in automating the popups using the Alert interface.
• Configured Jenkins build job for continuous Integration and also for Regression Testing.
• Used Apache POI to read data from external sources and provide them as parameter to the locators in the test script.
• Generated test logs using Log4j for various log levels.
• Used GIT to maintain and manage the build scripts, test data used and other documents related to the project.
• Implemented Selenium Synchronization for Conditional and Un-Conditional waits using Implicit Waits and Explicit Waits.
• Used Cucumber by creating the Features and Step Definition files to execute test scripts.
• Verified that the input file is not empty and such file is placed in proper directory and format matches the DML.
• Verified if the mapping adheres to the development standards and naming conversions
• Verified that the mapping is doing what the technical design says.
• Verified that the mapping works correctly in relation to other processes in data logistical flow.
• Verified that the table is truncated before initial load.
• Verified that the input and lookup files are available in the specified directory.
• Verified that the format of the output files is according to their DML.
• Verified that the log files are created properly and consists of proper information
• Validated the data as required through the components in the graph
• Performed column to column (field to field) validation.
• Verified full length of the column is moved to the target by giving maximum length in the

Environment: Java, Selenium WebDriver, TestNG, Selenium Grid, Maven, Jenkins, Eclipse, SQL Server, GIT Hub and Cucumber, SQL, PL /SQL, T-SQL, Auto IT, Apache POI, Extent Reports, Oracle, Appium, Jira.

Confidential - Fort Washington PA

Test Lead

Responsibilities:

• Assessed & analysed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings.
• Prepared Test cases for positive and negative test scenarios as referred in the user stories keeping in mind the Boundary Value Analysis, Equivalence Partitioning.
• Implemented TestNG automation framework for Smoke Test to ascertain that the crucial functions of the application work and also implemented Regression Test to detect bugs after enhancement and configuration settings of the code.
• Used FireBug, FirePath to debug, edit and locate the objects based on ID, Name, XPath, CssSelector, Link, Partial Link, Attributes and Tags.
• Performed Parallel and Cross Browser testing on different browsers like Internet Explorer, Chrome, Safari and Firefox where multiple tests were run at the same time.
• Designed and Developed test automation Artifacts (scripts, functions, scenarios, processes) for simple to complex automated testing situations using various tools like Selenium, Cucumber, TestNG and XPath.
• Configured the Test Cases to receive input Test Data Sets for the corresponding test cases using TestNG Data Provider Annotation.
• Developed Hybrid/Data Driven Framework using the Test Suites, Test Cases & Test Data Sets were configured to perform or skip the execution and wrote the test results Passed/Failed/Skipped to the output files.
• Used SoapUI to test the application web services.
• Managed the framework dependency jars using Maven. Used Maven to perform build from Jenkins Continuous Integration.
• Performed continuous integration of code and scripts using Jenkins. Configured and launched builds using Jenkins jobs and analysed the Test Results from Jenkins UI.
• Worked on SQL queries to verify data integrity and validate updated data for the Test cases in different modules of the Medicare & Medicaid application.
• Usability testing of the application and workflow involving multiple functional modules
• Worked with developers to Create and update the defects, resolve and track their status using JIRA
• Executed mapping with ZERO-byte file to verify that whether the graph is executed successfully or not
• Executed the graph with actual testable input file and saw whether all the target tables got populated.
• Verified that the input file is not empty and such file is placed in proper directory and format matches the DML.
• Verified if the mapping adheres to the development standards and naming conversions
• Verified that the mapping is doing what the technical design says.
• Verified that the mapping works correctly in relation to other processes in data logistical flow.
• Verified that the table is truncated before initial load.
• Verified that the input and lookup files are available in the specified directory.
• Verified that the format of the output files is according to their DML.
• Verified that the log files are created properly and consists of proper information
• Validated the data as required through the components in the graph
• Performed column to column (field to field) validation.
• Verified full length of the column is moved to the target by giving maximum length in the source
• Checked whether NULL is moved correctly to target by giving null values in all the NULLBALE fields in the source.

Environment: Java, Selenium WebDriver, TestNG, Selenium Grid, Maven, Jenkins, Eclipse, SQL Server, GIT Hub and Cucumber, Auto IT, Apache POI, Extent Reports, Oracle, SQL, PL /SQL, T-SQL, Appium, Jira.

Confidential, Rochester NY

Sr. QA & BA

Responsibilities:

• Worked with Business analysts to understandHigh Level/System requirementsin order to transform business requirements intofunctional specifications.
• Developed the scenarios based on the specifications from the end client.
• AnalyzedSource to StageandStage to TargetMapping document indicating the source tables, columns, data types, transformations required, business rules to be applied and target tables.
• Involved in designing the Scenarios and designing test scripts for Medicaid eligible members.
• Executed the Test scripts and prepared the test report and validated the eligible members for Medicare based on their income level.
• DevelopedSQL queriesfor Back-end testing/Database testing and participated in end to end testing.
• Involved in writingTest Plans,Test Cases, Test Scriptsto validate the functionality and executed with RQM and performed backend testing with SQL queries.
• UsedRQM as test management tool to manage and organize Requirements Coverage, Test Case Management, Test Execution and Defect Management.
• Involved inTesting of reportsby extracting the SQL generated by Micro Strategy and executed them in backend and validated them in QA and UAT environments.
• PerformedRegression testingand Report testing.
• PreparedTraceability Matrixwith requirements versus test cases
• Submitted 837 Claims via FTP Process and viewed in the HIPAA.
• Processed Claims (837) for Institutional, Professional and Dental usingFACETS and validated them with backend testing with SQL queries.
• Helped automation testing team in developing automation test scripts for regression testing
• Worked Extensively with Inbound837 I and 837 P, 835s (Out bounds)claims processing systems
• Helped automation testing team in developing the scripts and execution for Regression Testing.
• Executed mapping with ZERO-byte file to verify that whether the graph is executed successfully or not
• Executed the graph with actual testable input file and saw whether all the target tables got populated.
• Verified that the input file is not empty and such file is placed in proper directory and format matches the DML.
• Verified if the mapping adheres to the development standards and naming conversions
• Verified that the mapping is doing what the technical design says.
• Verified that the mapping works correctly in relation to other processes in data logistical flow.
• Verified that the table is truncated before initial load.
• Verified that the input and lookup files are available in the specified directory.
• Verified that the format of the output files is according to their DML.
• Verified that the log files are created properly and consists of proper information
• Validated the data as required through the components in the graph
• Performed column to column (field to field) validation.
• Verified full length of the column is moved to the target by giving maximum length in the source
• Checked whether NULL is moved correctly to target by giving null values in all the NULLBALE fields in the source.

ENVIRONMENT: MS Access, Sybase, SQL server 2008, Oracle, SQL, PL /SQL, T-SQL DB2, RQM, Water fall, MS Excel and Windows XP.

Confidential - PA

QA Test Engineer

Responsibilities:

• Attended meetings from Project plan, Test plan, Status meeting, Defect meeting.
• Performed Functional Testing, Regression Testing, Unit Testing, Integration Testing, Backend Testing.
• Performed backend testing with SQL for front-end functions.
• Prepared Traceability Matrixwith requirements versus test cases.
• Designed test scenarios, test Cases and Prepared Defect document and Test Result document.
• Verified input files, directories, format matches, error codes, naming conventions etc.
• Developed Test Plans,Test Cases, Test Scripts, RTM, Defect document, Test Results.
• Verifying and validating data values in General Ledgers (GL) related to Loan.
• Implemented STLC for my entire test preparation and execution.
• Performed data validation testing writingSQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Executed mapping with ZERO-byte file to verify that whether the graph is executed successfully or not
• Verified that the mapping is doing what the technical design says.
• Verified that the format of the output files is according to their DML.
• Performed column to column (field to field) validation
• UsedHP Quality Center as test management tool to manage and organize Requirements Coverage
• Extensively interacted with the developers and users to resolve technical issues and tracked defects.
• Maintained and executed Change Promotion Requests from DEV to PROD and TEST environments.
• Used tools SQL Server, Oracle PL/SQL Developer for database queries.
• Helped performance testing team in developing the scripts in LoadRunner.

Environment: Rational ClearQuest, SQL Server 2005, C#, .Net, MS-word, MS-Excel, RQM, Windows XP Professional, Water fall, LoadRunner, SQL, PL /SQL, T-SQL.