SUMMARY:

• Lead Software Testing Engineer with 14+ years of experience in Information Technology, with specialized in Software Quality Assurance Testing, proficient in testing Web based and Client/Server applications. Acquired significant exposure to structured object - oriented language and Automation experience on web application.
• Strong experience with Agile test methodology and Agile Development process.
• Expertise in QA Methodologies with various testing concept such as Acceptance testing, System Testing, Functional Testing, Integration Testing, Regression Testing and End-to-End Testing.
• Quality Testing including Effective Test Case Design, Test Execution and Reporting.
• Experience in preparation of Test Strategy, Test plan and Test Summary Reports.
• Solid experience with Behavior Driven Development and Behavior Driven Testing.
• Solid experience with Gherkin Language to develop Behavior Driven Testing.
• Responsible to setup teh execution of automated tests and deployment process using version control System Git and Continuous Integration (CI/CD) tools with Jenkins.
• Solid experience with Hybrid and Data Driven framework.
• Strong work experience using Bug Tracking Tools like Quality Center and JIRA.
• Experience in cross browser, cross platform web testing with Selenium Web Driver.
• Hands on experience in validating complex ETL mappings and reusable transformations for daily data loads.
• Having extensive experience in XML files data validation through XMLSpy or Editors for ETL data loads from target database.
• Hands on experience in Mainframe and Service Browser applications.
• Hands on experience in validating Document Imaging System developed in FILENET P8.
• Success driven team player with interpersonal skills, self-motivation, and early adaptation to new applications and technologies with proven skills in multi-tasking, handling multiple projects and responsibilities.
• Ability to balance competing priorities and tight deadlines.

TECHNICAL SKILLS:

Test Management Tools: V1, Quality Center 10.0, ALM 11.52 and JIRA

Automation: Selenium web driver and Karate API

Programming Language: Python, Java and Jason

API: POSTMAN and SoapUI

Operating Systems: Windows XP/2000/98/95 and UNIX

Methodologies: Waterfall, Agile and Kanban

Domain Knowledge: Banking and Financial Services

Database Tools: ETL Informatics, Oracle 9I, PL/SQL Developer, TOAD, TOAD for DA, Cygwin64 and putty.

Version Control Tool: Bitbucket for Automation code Maintenance

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

QA Lead Automation

Roles and Responsibilities:

• Participating in Daily standup, Sprint Stories Grooming and Sprint Retrospective.
• Closely working with business team (PO and BSA) in technical discussions with customer for getting teh business clarifications and requirements gaps.
• Responsible for planning test execution schedule as per teh Code Completed and Code Freeze dates for each release.
• Supporting EHT (Ethical Hacking Team) on test data creation for Vulnerabilities retesting and closing teh tickets
• Working on Automation scripts optimization to cover regression for each release
• Working with Cross portfolio teams for functional changes impact and getting approval from impacted teams
• Developing Selenium automation scripts in Python Page Object Model (POM).
• Creating API automation scripts by using Karate frame for API services.
• Creating/Update test data through Mainframe systems by using some commends (SIND, DIND, MARA, MIRA, SU01, PINR).
• Validating Vulnerability code changes for Servlets (CSRF, Body Parameter and Application Errors) and validate API’s by using POSTMAN.
• Responsible to setup teh execution of automated tests and deployment process using version control System Bitbucket and Continuous Integration (CI/CD) tools with Jenkins.
• Validating smoke automation scripts results which will run daily through Jenkins in QA environment after daily build deployments in QA environment.
• Validating intermodal pop up’s functionality by updating teh flags in Data Base tables for performing teh regression testing.
• Setting up a call with PO and Dev team to get defer defects approval and to decide teh target release date to address issues
• Responsible for creating a Test Strategy and Test Summary Reports for each release and get teh approval from required stakeholders.

Environment: ORACLE DB10G, Mainframe, TOAD for ORACEL 10.0, Angular JS, Pytest, OpenPyxl, Pytest-HTML, Pytest-xdist, Allurereports, Behave and PyOracle.

Confidential, New York, NY

ETL QA Lead

Roles and Responsibilities:

• Attending requirement review meetings with client and provide responses to their comments and capture action items and work on action items.
• Participate in QA (Quality Assurance) reviews and provides required support and clarifications as need for teh reviewers.
• Conducted Defect Triage meetings with Developers and Business users on daily basis, and also responsible for creating defect management reports using Quality Center for Executive Management and Steering Committee.
• Creation of ETL Test cases using Technical specifications and Source to Target mapping.
• Responsible for planning test execution schedule, and allocation of resources, tracking and monitoring actual work progress against planned work assignments
• Responsible for creating testing status reports and summary reports for Go/ No Go decision making and supported application deployments.
• Verifying teh Data Cleansing, Data Conversions, Data Transformation, Data Quality, Data Relationships, between Source Systems Analysis and Reporting
• Coordinated within onsite and offshore and provided KT to offshore as and when needed
• Conducting smoke test after releases and decide to accept or reject builds.
• Conducting Regression testing, functional Testing, System Testing using PLSQL scripts
• Worked in an agile technology with Scrum. Conduct QA scrum call to gather status of teh offshore team
• Data automation by preparing teh PLSQL Scripts.
• Participating in teh release planning meeting.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Involving in UAT (User Acceptance Testing) support with business users
• Worked in interface partner test execution
• Validate teh Records in Source and Target by using SQL
• Participating in technical discussions with customer for getting teh business clarifications and requirements gaps.
• Perform functional test and system test and strong data analysis and accuracy validation with teh ETL data pipelines and teh aggregated statistical queries/data Visualization in reports, dashboard, and charts.
• Preparation of Test Strategy and Test Summary Reports for every month release.
• XML files data validation through XMLSpy or Editors

Environment: ORACLE DB10G, INFORMATICA 9.1, ERWIN 7.3.1, UNIX, XML Spy 10.0, TOAD for ORACEL 10.0, TOAD for DA 2.5, AWS.