Qa Analyst Etl Tester

Pratheep Shanmugaraj Panneer Selvam

(QA Analyst ETL Tester Automation Engineer)

517-***-**** ********.*************@*****.***

CAREER ABRIDGEMENT

Over 15+ years of experience in Testing Software applications and Expertise in Mobile, Retail, Cloud Platform, Travel, Telecom, Banking, Insurance and Sports domain.

Proven experience in Manual, Automation and ETL testing for web & client-server applications.

Expertise in Functional, Regression, Integration, User Acceptance and Database testing.

Extensive Experience in Testing Mobile Retail app implementation like Same Day Pickup Orders, Same Day Delivery (Shipping) of Retail, Pharma and Photo Orders.

Experienced in Monitoring tools like Kibana, Dynatrace and Omniture.

Extensive experience in testing the implementation in Cloud Platform like ServiceNow Service Catalog & Service Level Management

Experienced in designing and developing automated tests in the ServiceNow Automated Test Framework (ATF) application.

Extensive experience in performing Data migration/conversion testing in Cloud platform.

Extensive Experience in writing complex SQL queries to perform backend data validations.

Extensive ETL Testing experience using Informatica (Power Center/Power Mart, Workflow Manager, Workflow Monitor)

Certified AWS Solutions Architect with very good understanding in cloud computing & architecting designs in AWS

Gained good knowledge on S3, VPC, EC2, CloudWatch, CloudFormation and Snowflake (SaaS) cloud Data warehouse.

Experienced in API/web-services testing using Postman, SOAP UI, Rest-Assured and Swagger tool.

Professional in designing, developing, and enhancing automated test scripts Selenium (Java/Cucumber Framework) Automation.

Have significant hands-on Experience in Data driven Testing and Parallel Test execution using Selenium WebDriver, TestNG and Selenium Grid.

Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins.

Used the Page Object Model design pattern to create Object Repository for web UI elements and Data Driven framework for reading the data from excel sheets using Apache POI.

Extensive experience in test management tools like ADO, Team Foundation Server (TFS), JIRA, HP-ALM and Rally for QA activities, business document mgmt. and status reporting.

Good knowledge and understanding of Software development life cycle (SDLC) and Software Testing Life Cycle (STLC).

Got an assortment of appreciations from business by proposing several IT solutions for the business needs.

Excellent problem solving and communication skills with ability to do smart work under pressure.

CERTIFICATION

AWS Certified Solutions Architect – Associate

Microsoft Certified Azure AI Fundamentals

Microsoft Certified Azure Fundamentals

Scrum Master Accredited Certification (SMAC)

Micro-Certification - Automated Test Framework

SCHOLASTICS

Bachelor of Mechanical Engineering (B.E): J.J College of Engineering & Technology, Tiruchirappalli, Tamil Nadu (Bharathidasan University), India (1999-2003).

TECHNICAL SKILLS

Programming/Scripting : VB Script, JavaScript, UNIX Shell Scripting, HTML, XML, Java, SQL

Tools : Informatica PowerCenter 10.x, Visual Studio-SSMS,

Visual Studio-SSIS, Putty, WinSCP, ServiceNow,

Automated Test Framework (ATF), Selenium (Java/Cucumber- BDD/TDD)

OpenSTA, JMeter

Management Tools : Azure DevOps (ADO), Microsoft Team Server Foundation (TFS), ALM/Quality Center (QC), Rally, JIRA

Databases : SQL-Server, Oracle 10g, MySQL

CI- CD : Jenkins, Azure

Source Code Management : GitHub, MS Visual Source Safe, CVS, SVN

IDE : Eclipse

Methodology : Agile & Waterfall

Web Service Tool : SoapUI, Rest Assured, Postman, Swagger

Web/Application Server : BEA WebLogic, Tomcat 5.5, Apache 2, Jboss4.0.5

PROJECT EXPERIENCE

Jul ’22 – Feb ‘23 Walgreens Quality Engineer/ETL Tester

Horizon is a mobile transformation program by Walgreens that aims to decommission obsolete store systems and deploy modern day tablets and smartphones in the shop floor. MyStore is a responsive Associate Facing Application, which would act a dashboard for Store Associates to view, access key performance indicators and 3rd party apps redesigned using specially built transcoding engine. MyStore will serve as a foundation for initiatives like Rx Renewal and Retail Transformation.

Responsibilities:

●Understanding business requirements, design documents and prepare test plans for functional, regression and integration testing.

●Provide recommendations/identify gaps while gathering requirements or creating user stories.

●Design test scenario, test cases for various user stories.

●Work collaboratively with functional and integration team to setup Test data for testing needs.

●Execute test cases for Mobile apps in various test environments and mobile devices update the status in Azure DevOps (ADO)

●Design, develop and implement automated tests for new and existing applications features application. Write and execute Test scripts using Selenium and Appium for webapp and Mobile app.

●Performed API Testing using Postman tool.

●Performed ETL data Validation writing SQL Queries between Source and Target Server

●Performed Sales Detailed Reports Data validation across Store in various Devices.

●Performance Testing of API and database using JMeter

●Update the status in daily standup and replicate the same in ADO.

●Document, troubleshoot, and follow-up on all defects during the execution.

●Attend daily defect triage meetings with BA/DEV teams for prioritization.

●Interact closely with developers to discuss and resolve the priority defects.

●Provide adequate customer collaboration to clarify and refine complex requirements.

●Perform regression and integration testing in Lab and Walgreen Stores during Pre-Prod and Prod Release.

●Validating logs and HTTPS request/response through monitoring tools like Dynatrace, Kibana and Omniture.

●Meeting with QA team to talk about QA priorities, impediments, and action items.

●Reviewing and retest all bug fixes and verify results of all re-tested cases in several stages.

Jan ’22 – Jun ‘22 Ernst & Young (MR)-USA Sr. QA Analyst/ETL Tester

Essentials for Metrics provides PPEDs and all ranks with a globally consistent view of role-specific performance with a visual and interactive dashboard displaying revenue, margin, sales and pipeline, and other key business metrics. It is designed with an intuitive, actionable interface to make tracking performance easier, enable better coaching conversations and to support new sales measures introduced to elevate teaming in FY22.

Responsibilities:

●Understanding business requirements, design documents and prepare test plans for functional, regression and integration testing.

●Provide recommendations/identify gaps while gathering requirements or creating user stories.

●Involving in sprint planning and story point estimation

●Design test scenario, test cases for various user story cards.

●Work collaboratively with functional and integration team to setup Test data for testing needs.

●Execute test cases in various test environments and update the status in Team Foundation Server (TFS) & Azure DevOps (ADO)

●Perform ETL data validation testing against various test env. using VS-SSIS and excel Macro tools

●Create SQL Queries to do ETL data validations between source and target server

●Using TFS & ADO for requirement traceability, creating/executing test cases, tracking status, status reporting and bug reporting.

●Update the status in daily standup and replicate the same in TFS & ADO.

●Document, troubleshoot, and follow-up on all defects during the execution

●Attend daily defect triage meetings with BA/DEV teams for prioritization.

●Interact closely with developers to discuss and resolve the priority defects.

●Provide adequate customer collaboration to clarify and refine complex requirements

●Perform functional, regression and integration testing after data migration

●Validating logs and HTTPS request/response through dev tool for error analysis.

●Meeting with QA team to talk about QA priorities, impediments, and action items

●Reviewing and retest all bug fixes and verify results of all re-tested cases in several stages.

●Involving in the sprint retrospective meetings at the end of every sprint

Jan ’19 – Dec ’21 Ernst & Young (ServiceNow)-USA Sr.QA Analyst/ETL Tester

EY and ServiceNow offer an integrated business-led, technology-enabled approach to deliver service management and business automation services for the enterprise built on ServiceNow’s single cloud-based platform. Our services can transform a wide range of business functions including customer service, HR, facilities, legal and IT operations.

Responsibilities:

●Understanding the Business requirements during Backlog Grooming and Sprint Planning of User Stories

●Involved in sprint planning and story point estimation.

●Prepare test plans for functional, regression, automation, and integration testing.

●Prepare Test Cases for user stories in every sprint for Service Catalog & Service Level Management.

●Perform functional testing on system implementation supporting the enhancement or fix of ServiceNow applications Self Service Portal (SSP) and SNOW Instance in several Module like ITBM/ITFM/ITSM, CSM, CMDB, HR, Knowledge Management, Performance Analytic, Problem & Change Management and Data Migration testing and API integration testing using REST/SOAPUI and several integration system like SAP, Archer as upstream/downstream and was being part of KANBAN Team for production support and post production release testing

●Identify End-End Regression Scenario for Test Automation.

●Design and develop automated tests scripts for new and existing ServiceNow applications.

●Perform Automation Testing on system implementation in ServiceNow applications Self Service Portal (SSP) and SNOW Instance.

●Perform data migration testing in various ServiceNow Cloud Platform test environments.

●Performed integration testing of API/web services with ServiceNow.

●Document, troubleshoot, and follow-up on all issues that are identified during test execution of manual and automated testing

●Validating the API/web services using Postman tool.

●Using TFS & ADO for requirement traceability, creating/executing test cases, tracking status, status reporting and bug reporting.

●Worked closely with Business stakeholders, Technical and Functional teams

●Interact closely with developers to discuss and resolve the bugs based on their priorities

●Collaborate with onshore and offshore testers for day-day QA deliverables

Mar ’18 – Dec’18 SITA (Switzerland) QA Analyst\QA Lead

SITA provides on-board connectivity solutions that enable passengers to connect to the Internet on devices such as laptops and smartphones as well as make and receive phone calls and text message. The Airport Vision system has been designed with a flexible database and a modular architecture and is designed to accommodate and adapt to new technologies. It seamlessly integrates into SITA Airport Management Solution (AMS) or can stand on its own.

Responsibilities:

●Understanding business requirements, design documents and prepare test plans for functional, regression and integration testing.

●Provide recommendations/identify gaps while gathering requirements/creating stories.

●Involving in sprint planning and story point estimation

●Design test scenario, test cases for various user stories.

●Updating the status in daily standup and replicate the same in JIRA.

●Creating daily status reports for user stories.

●Identify Regression Scenario for Test Automation

●Design, develop and implement automated tests for new and existing applications features application. Write and execute Test scripts using JAVA, Selenium and TestNG. Creating TestNG Framework environment to develop the test scripts.

●Attended daily SCRUM meetings with the team members. Extensively involved in developing test cases using the design and requirement document and mapping with the requirement traceability matrix

●Used selenium grid to run test cases in multiple browsers and platforms

●Incorporated Page Object Pattern in developing Automation scripts.

●Generate the automation test case reports.

●Configured the test suite to Jenkins to make it run on every successful deployment, which helped reduce the feedback loop time to the developers.

●Execute automation test scripts against various test environments.

●Using Quality Center for execution, traceability, tracking execution against the plan and defect mgmt. Also using JIRA for business document mgmt., status reporting and bug reporting.

●Responsible for project management activities like work allocation, status Tracking & reporting, maintaining QA metrics.

●Attending daily defect triage meetings with IT and business team.

●Reviewing and retest all bug fixes and verify results of all re-tested cases in several stages.

●Interacting often with developers to discuss and resolve the bugs based on their priorities.

●Perform web service testing using Postman for internal/external systems

●Conducting the sprint review and retrospective meetings after the end of every sprint.

Mar ’16 – Mar’18 Liverpool Insurance company Guidewire QA Analyst

This Guidewire implementation project is a part of the Pioneer Programme which is focused on delivering significant bottom line financial benefits by transforming the GI Direct business for Auto and Home products. A

new enhanced business approach (Guidewire) supported by the deployment of new technology will enable the

business to transform its current processes. Core to this transformation is the provision of new policy

administration and billing systems.

Responsibilities:

●Participating in requirement planning meetings and understanding the business objectives.

●Involving in sprint planning and story point estimation

●Preparing the test plan, test estimation, test scenarios and test cases and walk through to

BAs and Devs for review.

●Ensure the requirement traceability coverage with the test scenarios and configuring test data

based on the test cases before functional and regression test execution cycle starts.

●Coordinate with development teams for code deployments and managing the test execution cycles for SIT & UAT testing

●Working on the following functionalities like new submission, policy change, renewal, cancellation, rescind, reinstatement, rewrite, spin, split, cancellation delinquency, out of sequence, preemption workflows

●Integration points between PC and BC and external vendor systems via SoapUI.

●Data analysis on transactional PC/BC data and validating the Data in Oracle Database

●Managing and controlling the JIRA Kanban boards, test plans, test executions, test cases, test

filters and dashboards.

●Reporting defects and managing through to successful resolution via JIRA

●Responsible for producing all testing status reports including daily status reports and weekly status

reports and collating the test evidence and obtain sign off post-execution.

●Responsible for adherence to test working practices and structures and providing project meeting

outputs.

●Responsible for generating test completion reports and providing Post Implementation Testing

scope recommendations.

●Meeting with QA team to talk about QA priorities, impediments, and action items

●Reviewing and retest all bug fixes and verify results of all re-tested cases in several stages.

●Involving in the sprint retrospective meetings at the end of every sprint

Collaborate with onshore and offshore testers for day-day QA deliverables

Feb’12–Mar’16 International Baccalaureate (UK) QA Analyst\QA Lead

The organization aims to develop inquiring, knowledgeable and caring young people who help to create a better and more peaceful world through intercultural understanding and respect. These programs encourage students across the world to become active, compassionate, and lifelong learners who understand that other people, with their differences, can also be right

Responsibilities:

●Understanding the business requirements by studying requirement specification, activity diagrams as part of functional documentation and functional document.

●Created test estimates and Prepare test plans for functional, regression, automation and integration testing.

●Preparing Test cases for various enhancements against new releases of project.

●Responsible for Test Data Preparation, Test Execution and Defect tracking with Artifacts.

●Performing DB table validation by Creating Complex SQL Queries

●Identify Regression Scenario for Test Automation

●Design, develop and implement automated tests for new and existing applications features application. Write and execute Test scripts using Selenium and TestNG. Creating TestNG Framework environment to develop the test scripts.

●Attended daily SCRUM meetings with the team members. Extensively involved in developing test cases using the design and requirement document and mapping with the requirement traceability matrix

●Used selenium grid to run test cases in multiple browsers and platforms

●Incorporated Page Object Pattern in developing Automation scripts.

●Generate the automation test case reports.

●Configured the test suite to Jenkins to make it run on every successful deployment, which helped reduce the feedback loop time to the developers.

●Validating the API call using Postman and Rest-Assured.

●Execute automation test scripts against various test environments.

●Reviewing and Re-test all bug fixes and verify results of all re-tested cases in several stages.

●Used ServiceNow for Incident & Problem Management for production testing with KANBAN approach

●Have done Performance Testing and Reported Performance testing results with Timer Artifacts using OPENSTA

●Responsible for executing the test cases, traceability, tracking execution against the plan.

●Also used Rally for business document mgmt., status updates and reporting.

●Interacted often with IT team members to discuss and resolve defects based on their priorities.

May’10 – Apr’11 Telstra (Australia) QA Analyst

Telecom Billing is a process of collecting usage, aggregating it, applying required charges, and finally generating invoices for the customers. Telecom Billing process also includes receiving and recording payments from the customers billing payment and via mobile view and payment of Customer bill details and payment and new service plan and product details.

Responsibilities:

●Understanding the business requirements by analyzing the Business requirement document.

●Preparing Test Plan and Test Cases for user stories.

●Prepared Test Data for bill File Generation and payment operations using several 3rd parties tools (Kennan, Flexcab & TIBCO Integration tools).

●Perform functional and system testing.

●Identify Regression Scenario for Test Automation.

●Design and develop automation scripts for new and existing applications features.

●Execute automation test scripts against various test environments.

●Document, troubleshoot, and follow-up on all issues that are identified during the performance and execution of manual and automated testing.

●Reviewing, Trouble shooting and Re-test all bug fixes in several stages.

●Responsible for activities like work allocation, status reporting and capture metrics

●Provided constant support and worked with client team to resolve issues during implementation, UAT and Support phase.

●Responsible for executing automation scripts for Smoke and Regression testing.

●Responsible for activities like work allocation, status reporting and capture metrics.

●Used QC for execution, traceability, tracking execution and defect mgmt.

●Creation of test summary report.

May’06-Jul’07 Dispodrom AG(Switzerland) QA Analyst

Musikvertrieb is in the business of video/audio production, publishing, consumer electronics and multimedia distribution. This application is having an Administration module, Catalog module, B2B application for two industrial partners Musikvertrieb and Impuls (the organization which is selling Sony products throughout Swiss), Two Content Management Systems for both MV and Impuls.

Responsibilities:

●Understanding the business requirements by analyzing the Business requirement document.

●Prepare test plans and test cases for functional, regression and integration testing.

●Involved in Test Data preparation and Execution.

●Reviewing for various Business Process.

●Responsible person in the following QA areas like

Business requirement analysis

Test Strategy Preparation

●Interacting often with developers to discuss and resolve the bugs based on their priorities.

●Review of Test Scripts and Verification results created by team members.

●Trouble shooting – Domain/Technical.

●Project Management activities like Work allocation, Status Tracking, Team Building/maintaining Reports.

●Test Execution – Smoke, System and Regression.

●Report Performance testing results with Timer Artifacts using Jmeter.

Aug’05-May’06 Ussoccer.com (USA) QA Analyst

The CMS or Content Management System is developed to manage the whole content of the website. The CDS or Content Display System is the actual display of the website. Here the various articles published by the Editors of the site are taken and shown interactive to the user.

Responsibilities:

●Understanding the business requirements by analyzing the Business requirement document.

●Understand the business requirements, test plan and test strategy and prepare the Test Cases for functional, negative, regression and integration testing using several testing methodologies Techniques.

●Performed Review of Test Cases created by team members.

●Involved in Test Data preparation and Test Execution of application in various environments.

●Interacting often with developers to discuss and resolve the bugs based on their priorities.

●Track the Test Execution Coverage against RTM and provide the artifacts for Test Execution

●Responsible for Test Execution Coverage and reviewing artifacts for Test Execution

●Participated in Root Cause Analysis Meeting.

Apr’04-Aug’05 Ketera E-Procurement(USA) QA Analyst

Ketera Procurement provides a comprehensive solution for procurement enabling companies to attain increased control and significant cost savings throughout the procure-to-pay process.

Responsibilities:

●Understanding the business requirements by analyzing the Business requirement document.

●Interact with Team and Business for any gaps in requirements.

●Understand business requirements, test plan and test strategy, application workflow and prepare the Test Cases for functional, negative, regression and integration testing using several testing methodologies Techniques.

●Performed Review of Test Cases created by team members.

●Involved in Test Data preparation and Test Execution of application in various environments.

●Interacting often with developers to discuss and resolve the bugs based on their priorities.

●Prepare the Test Execution Coverage against RTM and provide the artifacts for Test Execution

●Participated usually in Root Cause Analysis Meeting and Discussions.

Contact this candidate