PROFESSIONAL SUMMARY:

* ***** ** ********** ** IT with the implementation of Client/Server, SAAS and Web Based applications in the areas of Healthcare, Banking, Insurance.

Core competencies include long game, solid structure, innovative process, detailed RCA (root cause analysis), strong technical/analytical disposition and valid execution strategies for quality deliverables.

Performed both manual and automated testing with the implementation of Waterfall, V-Model, and Agile (including Scrum) methodologies while maintaining artifacts such as Test Plans, Test Cases, RTM, and Bug Reports using HP ALM 12.01, Rally and other testing/defect management tools.

Actively used automating Web Application Testing using Selenium WebDriver with TestNG framework.

Executed system testing, including User Acceptance Testing (UAT), smoke and sanity testing, functional testing, integration testing, regression testing, black box and usability testing for ensuring all the requirements have been tested.

Profound understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Writing test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations.

Execute Selenium Test Cases and reporting defects.

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.

Excellent experience in development and improvement; optimized and maintained ETL process using Informatica Power Center and Oracle.

Report test failures and defects using Rational’s RTC (aka, CCM), HP Quality Center and Team Foundation Server (TFS) and provide management with Regression Test Reports and Progress Reports.

Excellent experience with utilizing API for functionality and data flow using SOAP and REST service.

Experience in Web Services/API testing using Postman client and Servistate plugin.

Development of Automation Testing Framework using Java Selenium Web-Driver, TestNG, Cucumber/Behavior Driven Development (BDD) Framework, Maven, Git, Jenkins.

Good knowledge on loading flat file data into Teradata tables using Unix Shell scripts.

Worked with CI/CD tools: Jenkins for build test and also experience in creating stories based on the tasks assigned JIRA.

Strong knowledge in RTC bug reporting tool, defects handling and re-testing and assigning code fixes to developers. Provided guidance to technical team for fixing accessibility/usability violations.

Strong knowledge on TFS Test Integration.

Experienced in preparing Test Plans (both high and low-level scenarios), test data, test cases/scripts, regression suites, End-to-End workflow, project presentation and training document (knowledge transfer).

Created and inventoried (hierarchical and flat) user stories using JIRA/Rally.

Excellent presence during project release with providing production support and client training.

Defined base objects, staging tables, foreign key relationships, lookups, queries, packages, message queues, and query groups.

Created mappings and scheduling the batch jobs.

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Configured match rule set property by enabling search by rules in MDM according to business rules.

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Demonstrated ability to work in a team, facilitate effective team interactions, and to foster a positive work environment; willingness to assist teammates in order to achieve departmental goals, as well as work independently.

Demonstrated strengths in organizational, attention-to- detail, follow-through, reasoning, critical thinking, and problem-solving skills.

Participated in initial MDM implementations and future rollouts.

Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer and Toad as development tools.

Experience with RESTFUL Web services automation in testing web API’s framework.

Expertise in QA testing in distributed UNIX environment and Oracle databases.

Experience in data analysis and problem solving with large amounts of data.

Hands on experience with analysis of business, technical, and functional requirements and developed, executed and tested the test plans, test cases and test strategies.

A self-motivated, responsible and reliable team player with a set of strong technical skills.

EDUCATION:

Master’s in Information Technology Management.

Bachelor’s in computer science engineering,

TECHNICAL SKILLS:

Software Methodologies: Waterfall, Agile

Bug Reporting Tools: Quality Center ALM, JIRA, MTM

Testing Tools: QTP, Selenium Web driver, SoapUI,

Frameworks: TestNG

Databases: Oracle, MS Access, MS SQL Server, DB2

Database Tools: MS-SQL Server Management Studio

Operating Systems: Windows 98, 2000, XP, Windows 7, Windows 10, Unix

Scripting Languages: VB Script, SQL, HTML and XML

Programming Languages: Java J2EE

Others: MS Office Suite- Word, Excel, MS Visio,

Ucare Minneapolis, MN June 2019 to Present

QA Analyst

Responsibilities:

Working as a QA Analyst in PROVIDER Data Management and reporting Team.

Worked under cross platform for CLAIMS, MEMBER and DXT teams when needed.

Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.

Worked and developed Automation scripts in DVO Tool and Right data tool for Data automation

Worked in a team environment with the business user community, technical teams, and end users to successfully develop and implement quality changes into production.

Performed Functionality testing during the various phases of the application and analyzed the results.

Performed manual and automated test execution for functional, integration, regression, performance Testing required to meet the business requirements.

Involved in discussion with the QA lead during creation of test plans and updating of business Requirements.

Performed Backend Testing and Unit Testing using the SQL queries in SQL Developer and

SQLPLUS.

Performed Testing on EDI test files like 837 claims data, experience in Testing EDI HIPAA 5010 Transactions including 837,834, 835, 270, 271, 276, 277

Created extensive SQL Queries with complex multi-table joins and nested queries.

Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting Issues before/during code migration.

Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL

Also Preparing ETL and SQL routines/code for performing ETL testing and documenting the test Results.

Created and maintained SQL Scripts and Unix Shell scripts to perform backend testing on the oracle Database.

Participated in regular project status meetings and QA status meetings. Developed ETL test scripts based on technical specifications/Data design documents and Source to

Target mappings.

Developed complex SQL queries for querying data against different data bases for data verification Process.

Worked with ETL groups and Acquisition team and business analyst for understating mappings for Dimensions and facts.

Worked on issues with migration of Data from development to QA-Test Environment.

Performed UAT and Regression Testing.

Environment: SSMS, SQL Developer, ETL Informatica, TFS, SQL, Oracle.

State of Minnesota- DHS St Paul, MN July 2018- May 2019

QA Analyst

Responsibilities:

Experienced in all levels of System testing, including, Smoke & Sanity Testing, Functional Testing, Integration Testing, Regression Testing, black box and Usability Testing Accessibility Testing for connecting all the requirements.

Execute Test cases and enter defects with appropriate screen shot and requirements. Logged many defects through a year and track defects using RTC experience in Defect management process.

Worked in AEM, OIG, TEFT, MPSE, MnChoices, ISDS, MCSO projects. Created Test cases based on the BRD.

Experience in knowledge of Curam application portal for METS system, worked with claims data EDI 837 files.

Knowledge in MMIS system.

Involve in section 508/WCAG testing of web based and desktop application.

Perform Accessibility testing on web applications in desktop browsers using different screen readers and accessibility tools like JAWS, NVDA, Voiceover, WAT, WDT, WAVE, Fire Eyes and Deque World Space.

Worked on mobile Testing to ensure the accessibility requirements and used WCAG 2.0 & 508 Standards & guidelines, Android, IOS.

Test documents for compliance with Section 508 of the Americans with Disabilities Act, TAC 206 & 213.

Involvement in Test Estimations and Test strategy implementation.

Proficient in devising all the artifacts of testing such as Test Scenarios, Test Cases, Defect Reports and Test Summary Report.

Self-motivated, energetic and highly ethical in all work-related assignments thus able to immediately contribute to corporate goals and objects

Good written, communication, interpersonal skills, proven team player with an analytical mind bent to problem solving and delivering solutions.

Established QA practices thereby improving test planning, test coverage and quality of unit tests.

Test and remediate the Word and PDF, Microsoft Word, Visio, Excel, and PowerPoint documents and presentations using accessibility standards.

Skills in Web applications and Web content testing using JAWS, Magic and WAT toolbar.

WCAG 2.0 version released analysis to incorporate in the current Accessibility validation across the DHS applications alias independent projects.

Actively involved in team and project management meeting. Involve in preparation of various documentation.

Create Test strategy and Test Plan and publish Test Completion report. Allocation of tasks and tracking the progress through Delivery.

Experienced in Automation scripting using Visual Studio C# .net framework, involved in tool building for in State use only to automate application and get the violations reports on Accessibility violations, involved in functions Testing for the PDF, web based applications.

Experience in testing with baseline code validation against the WCAG and Section 508 standards. These standards are used for our Team.

Created new Test case based on the WCAG 2.0 guideline and 508 standards. And updated new Test cases for WCAG 2.1 AA guidelines.

Experience in working with BA’s to understand requirements and give suggestions for accessibility requirements.

Experience in working all UI tools like HTML, CSS, Java Script, and Bootstrap, angularJS.

Involved in implementation and execution of all aspects of Accessibility testing activities for WCAG 2.0 Level AA guidelines including planning, creation and execution of test cases, test scripts, test reports.

Testing the code on the site by running it through an Accessibility Validator like A checker which will provide a detailed breakdown of how markup and contents stack up to accessibility guidelines. Running HMTL validation check at the same time to clean up any errors lurking in the code.

Environment: HTML, CSS, JavaScript, Oracle, NVDA, WAVE, aXe, WAT, VAT, Color Contrast Analyzer, Talk Back, Voice Over, A checker, SQL Server, Windows, Web Accessibility Tool, JAWS, RTC, Microsoft SQL Server, AST tool, Visual Studio.

US Bank, Minneapolis, MN July 2015- June 2016

QA Tester

Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.

Created complex SQL queries for querying data against different data bases for data verification process.

Involved in extensive DATA validation using SQL queries and back-end testing.

Assisted quality assurance implementation in all the phases of SDLC.

Tested the SQL queries to validate each transformation rule using AQT.

Tested new Data migration tool used in the mapping of data to new system.

Executed Test cases manually and involved in Test data management (TDM).

Executed automated test scripts and found out the root cause whenever a test fails.

Prepared test data using AQT/SQL Developer database management tool by writing SQL queries.

Loading flat file Data into Teradata tables using Unix Shell scripts.

Involved in testing of Universes from different data sources like SQL Server.

Tested MicroStrategy reports for business reporting needs.

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.

Working closely with client for Test Data Management (TDM) processes.

Developed and Performed execution of Test Scripts manually to verify the expected results.

Validated that application meets requirements and functioning as per the technical and functional specifications.

Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica power center Workflow monitor.

Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.

Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.

Involved in recording change requests on the Change Requests.

Extracted data from various sources like Oracle, flat files and SQL Server.

Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.

Validated end user report requests using SQL and MicroStrategy tools.

Extensive use of defect tracking tools, such as Jira ALM, Quality Center, Test Director, VSS tracker, Clear Quest and Test Track Pro.

Involved in Test data management (TDM) Team.

Used T-SQL for Querying the SQL Server database for data validation.

It is built especially for more non-technical users and allows you to collect data from any cloud service, load it into your data warehouse, and it optimizes your data according to your data warehouse.

Let's you store all your data yourself, so you never lose access to information even if you stop using a source application; allows for up-to-date analytics; full historical sync when connecting a data source so you can even query deleted data.

Developed and involved in both Manual Testing and Automation Test scripts based on use cases developed.

Worked with iterative development environment using Agile Methodology.

Tested the data and data integrity among various sources and targets.

Environment: ETL (Informatics 9.1), Agile, MicroStrategy, TDM, Teradata 13.0, SQL Server, AQT, Oracle 11g, SQL, PL/SQL, UNIX, ALM/HP Quality Center 11, TOAD, SQL Navigator, Windows XP Professional, MS Excel, XML, XSD, XSLT, XML Spy, Unix Shell Scripting

UnitedHealth Group - Eden Prairie, MN May 2013- Jun 2015

QA Manual Tester

Responsibilities:

Analyzed the system specifications, business requirements for full understanding of the project.

Analysis of Business Requirements and Functional Specifications excogitate the System Test Plan for the Functionality, integration, regression, smoke and UI testing.

Developed and executed the test cases manually and documented both the results.

Regression testing, Integration testing, System Integration, Smoke testing are done.

Conducted walkthrough of the test artifacts with the business analyst and developer.

Manually tested every module of the application as per new builds received from the development team.

Analyzed System specifications and performed user Acceptance testing.

Used Oracle SQL developer to check SQL queries for optimal performance and scalability under real-time workloads.

Used Pentaho Data Integration Designer to create ETL transformations.

Initiated SQL DB queries and XML server requests to extract data.

Involved in Testing according to HIPPA code set 834 enrolment and disenrollment in a health plan.

Involved with backend testing of the SQL database and verified the EDI data transactions going fine in the database.

Well experienced in executing User Acceptance Testing (UAT), Regression Testing, System Testing, Functionality Testing, Performance Testing, Black Box Testing, GUI Testing, Sanity Testing, and Usability Testing for Web Client and Server application testing.

Created SQL queries to retrieve data from database to validate the input data.

Actively participated in walkthroughs and enhancement meetings.

Environment: Java, HTML, XML, Selenium, HIPPA, TestNG, Quality Center, JIRA, MS Office, XML, Oracle, SQL, Windows, Unix. SoapUI, WEB Sphere, SSIS

Macy’s, Cincinnati, OH April 2011- March 2013

QA Analyst

Description:

Ecommerce- Retail Cloud-suite is a merchandising solution that allows Retailers to keep pace and anticipate the evolving demands of their increasingly tech-savvy customers. The solution's elegant user experience, infused with data-driven insights, lets retailers spend less time managing data and more time evaluating information and refining customer service visions. Ecommerce Retail Cloud-suite empowers retailers to implement their visions by enabling each retailer to configure the solution uniquely to meet their customers' specific needs

Prepared Test Plan based on Stakeholder Requirements, Solution Specifications and Test Strategy documents.

Documented test cases in Quality Center with pre-conditions, post-conditions, validations etc.

Wrote complex SQLs to retrieve source data and verify the target data.

Executed batch jobs in Autosys and validate the data.

Progression testing involving Software testing including application security and vulnerabilities.

Documented software bugs and wrote test reports by using Microsoft Test Manager (MTM) and Team Foundation Server (TFS).

Accessibility, GUI functionality testing as part of risk-based regression testing.

Inbound, outbound, reporting and maintenance batch jobs are executed in system test environment.

Co-ordinate restoration of production data in system test environment.

Starting/Stopping of Application, Batch and Web Servers.

Prepared Risk Assessment Matrix to quantify the level of regression testing.

Develop Test Cases, Test Scripts and Test Data.

Execute Test Cases, Validate and document testing results.

Prepared Test Incident Report Document, Test Result Summery Report Document, Test Execution Report Document.

Conducted Stakeholder meetings to review Test Plan, Risk assessment Matrix, Test cases, Test Documentation Report.

Reported bugs and tracked defects using Quality Center/ALM.

Environment: Java, HTML, XML, Selenium, HIPPA, TestNG, Quality Center, JIRA, MS Office, XML, Oracle, SQL, Windows, Unix. SoapUI, Web Services

Contact this candidate