Web Application Data Validation

M.V.Sarath Kumar

https://www.linkedin.com/in/venkata-makarla-46308979/

Phone : 314-***-****/******.*******@*****.***

SUMMARY PROFESSIONAL :

** ***** ** ********** ** Python Automation, Big Data (Hive, Spark, PySpark, Spark SQL, Phoenix, HBase) Test Automation, and Data Validation with strong expertise in Selenium, SQL, and ETL/Data Warehousing tools. Hands-on in building automation frameworks, validating large-scale data pipelines, and ensuring end-to-end quality across web, API, and database layers.

TECHNICAL SKILLS:

Programming & Automation: Python, Selenium, PyTest, TestNG, Cucumber

Databases: Oracle, SQL Server, Teradata, Snowflake, DB2

ETL / Data Warehouse: DataStage, Informatica, Hive, Spark, BigQuery

Test Management & CI/CD : JIRA, ALM, QTest, Jenkins

API Testing: Postman, SOAP UI, Ready API

Other: PySpark, Shell Scripting, Power BI

PROFESSIONAL EXPERIENCE:

Role: SDET July 2022 –till date

Client: Elevance Health –Dallas, TX, Hybrid

Responsibilities:

Worked as Automation Architect as Designed and implemented an agile automation solution for a Localized Web application using Python, Selenium, and Pandas within a short timeframe.

Experience in creating CI/CD pipelines and implementing quality gates at required stages.

Automated data validation and web application testing using Python and Selenium.

Wrote advanced SQL queries for validating large datasets in Snowflake, Oracle, Teradata.

Built automation framework for validating Source-to-Target ETL mappings across files (CSV, JSON, XML) and DWH tables.

Automated web application validation using Selenium WebDriver with Page Object Model (POM) and Data-Driven Testing.

Developed and executed cross-browser validation (Chrome, Edge, Firefox) using Selenium Grid.

Worked with ETL/ELT pipelines (Databricks, Snowflake, Bigquery) ensuring data quality, completeness, and transformation accuracy.

Validated UI functional flows: login authentication, form submissions, dropdowns, checkboxes, web tables, and file upload/downloads.

Implemented end-to-end database validation by fetching UI inputs and verifying against backend SQL queries in Oracle & Snowflake.

Integrated Selenium tests with REST API validations for hybrid test coverage.

Performed regression and smoke testing for every release cycle.

validated and managed migration of data scripts using advanced programming languages like Python, Spark, PySpark scripts for loading the data from the source file to AWS, Hadoop environments.

Good programming skills in languages such as Python and Pytest framework as part of testing.

Role: SEDT Apr 2020 to June 2022

Client: Wells Fargo Ltd – Dallas, TX

Implementation partner: Persistent

Responsibilities:

Worked as Automation Architect as Designed and implemented an agile automation solution for a Localized Web application using Python, Selenium, and Pandas within a short timeframe.

Validated SOAP UI and Restful API service. I participate in BDD testing using Rest Assured, TestNG, Cucumber and JMeter

Worked on the Automation testing tools UFT, and Selenium, and developed frameworks for API testing on SOAP UI, and Postman for the applications involved in projects and complete proof of concepts for the applications identified.

Validate ETL/ELT processes for (Extract, load (raw data), Transform the data ingested, load validation, Load data and ingestion processes and reconciliation techniques.

Worked on Gherkins-cucumber (BDD) framework by writing Gherkin scenarios, created and maintained step definitions.

Integrated Tosca scripts using Jenkins where the same scripts can run in both Test and prod environments

Validated Power BI reports along with Data Validation, Visualization Accuracy, Functionality Test, Data completeness, Source to Target, Business level validation User Acceptance Testing

Conducted end-to-end testing of Snowflake data pipelines, ensuring data accuracy and performance.

Automated web application validation using Selenium WebDriver with Page Object Model (POM) and Data-Driven Testing.

Developed and executed cross-browser validation (Chrome, Edge, Firefox) using Selenium Grid.

Built Selenium-PyTest automation framework integrated with Jenkins CI/CD.

Validated UI functional flows: login authentication, form submissions, dropdowns, checkboxes, web tables, and file upload/downloads.

Implemented end-to-end database validation by fetching UI inputs and verifying against backend SQL queries in Oracle & Snowflake.

Integrated Selenium tests with REST API validations for hybrid test coverage.

Performed regression and smoke testing for every release cycle.

Role: ETL Tester July 2016-Feb 2020

Client: Health Care Service Corporation (HCSC), Richardson, TX

Implementation partner: Infosys

Responsibilities:

Worked on Multiple Hadoop and DWH Projects like (VBC, DACO, GPD, Walgreens, etc.), both ETL and Hadoop technologies.

I worked on Teradata, EDW and Hadoop technologies (Teradata, DB2, Hive, Sqoop, Phoenix, HBase HIPAA/GDPR and Pig).

Developed Automation suite using shell, HQL scripts and Python for Ingestion and Consumption.

Worked on complex SQL, cloud Queries and sub queries as part of Source to Target validation.

Prepared and ran SQL queries to verify Dimensional and Fact tables. Verifying the data in target database by ETL process. Verified column mapping between source and target.

Prepared test data for functional & Integration testing and Interactions with BA & Dev teams to resolve the issue also worked on FHIR and HIPAA data as part of our project while working with external vendor data GDPR.

Wrote Test Plan, Test Strategy, Test Cases, Test scripts, raised Defects and participated in Triage meetings to ensure defects are addressed by the proper resource.

Worked on ALM, CI/CD, Zephyr Scale and JIRA tools to maintain test life cycle and create stories, updated tasks and raised defects in JIRA and sync in HIPAA, QTEST.

Involved in functional study of the application and running the jobs/Workflows for ETL process.

Role: Sr. System Analyst Dec 2010 to April 2016

Employer: Bank of America - Hyderabad, India

Responsibilities:

Involved in cloud functional study of the application and running the jobs/Workflows for ETL process.

Prepared Test plan and Test approach documents. Involved in designing, reviewing, & executing Test cases.

Prepared test data for functional & Integration testing and Interactions with BA & Dev teams to resolve the issues.

Worked on Mainframe files (GDG, VSAM, PS) and JCL jobs. Automated procedures, application extension, and scripting using REXX as part of validating Direct Deposit and CC transaction files.

Involved in Requirements testing, build verification testing, Data completeness testing, Data transformation testing, Data migration testing, Web services testing, End2End testing, Performance testing, Continuous Integration Testing (using Jenkins) and Regression testing.

I worked on Teradata, EDW and Hadoop technologies (Teradata, DB2, Hive, Sqoop, HBase, Pig, HDFS, MapReduce and UDFs).

Developed Automation suite using shell, HQL scripts and Python for Ingestion and Consumption.

Worked on complex SQL, cloud Queries and sub queries as part of Source to Target validation.

Prepared and ran SQL queries to verify Dimensional and Fact tables. Verifying the data in target database by ETL process. Verified column mapping between source and target.

Wrote Test Plan, Test Strategy, Test Cases, Test scripts, raised Defects and participated in Triage meetings to ensure defects are addressed by the proper resource.

Role: Team Lead

Employer : Accenture -Hyderabad - India August 2007 to Nov 2010

Responsibilities:

Involved in preparation of Project Plan, Design documents and submitted for successful sign off.

Developed Functional Decomposition / Modular Framework using QTP/UFT. Developed libraries, Master script, utility functions, error handling.

Involved in preparation of Estimates and worked closely with client team in resolving any Issues.

Identified the Risks (Technical, Process and People) and suggested mitigation for the same.

Coded the requirements in .Net environment and uploaded the scripts in VSS environment.

Worked in Virgin Media (Mobile and Internet Services) Business Support System (BSS).

Prepare and maintain Lessons learnt and best practice documents.

Conducting final review of the project for successful closure.

Role: QA

Employer: CA (India) Technologies Pvt Ltd - Hyderabad, India July 2004 to June 2007

Responsibilities:

CA Harvest Software Change Manager (CA Harvest SCM) provides powerful, process-driven capabilities for managing development teams across your enterprise, encompassing multiple platforms and release management tools. CA Harvest SCM can help your enterprise simplify the software release management process as well as the development and maintenance of business applications with streamlined workflows and automated source code versioning.

Role: Consultant

Client: Intel Technologies India Oct 2003 to Jul 2004

Location: Bangalore, India

Intel Device Manager Diagnostics Utility (DMIX) for Precision and Latitude series running the following Windows Operating Systems. We can team more than one Network adapter and create virtual adaptors for better delivery of Data.

Certifications:

•ITIL V3 Foundation

•Spark Certified.

•QTP 9.2 Certified.

Education Qualification:

Masters in computer applications, Madurai University, Tamil Nadu, India, 2005.

Master of Commerce, Nagarjuna University, Guntur, India, 1995

Contact this candidate