Data Validation Test Automation

SHEIKH MOHD ASHRAF

QA Engineer / SDET

*************@*****.*** +1-571-***-**** Franklinville, PA Linkedin Professional Summary

QA Automation/SDET & Data Validation Engineer with 6+ years of experience in test automation, mobile app testing, and data validation. Delivered high-quality B2B/B2C, eCommerce, and healthcare solutions. Designed and implemented a custom BDD automation framework using Selenium, Java, TestNG, and Cucumber. Automated HIPAA-compliant EDI transactions, enhancing data quality for migration projects. Promoted twice in seven years, demonstrating career progression and expertise in quality assurance and data validation Technical skills

Test Automation & Frameworks: Selenium WebDriver, TestNG, JUnit, Cucumber, Jasmine, Protractor, Robot Framework, SpecFlow

Programming/Scripting: Java, JavaScript, Python, SQL, Groovy, Shell Scripting API/Web Services Testing: REST-assured, Postman, SOAP UI, Swagger, JSON, XML Data QA & EDI: HIPAA Compliance, ETL Testing, X12 Transactions (837, 835, 834, 270/271), Source-Target Mapping Data Analytics & AI/ML: Python (Pandas, NumPy, Scikit-learn), Data Mining, Machine Learning Performance Testing: Apache JMeter, LoadRunner, AWS-based performance testing CI/CD & DevOps: Jenkins, GitLab CI/CD, Azure DevOps, Docker Version Control & Test Management: Git, GitHub, Bitbucket, Jira, Zephyr Scale, ALM/Quality Center Databases: SQL, Oracle, MySQL, MongoDB, SQL Developers Development Methodologies: Agile (Scrum/Kanban), BDD, TDD, Waterfall Web Technologies: HTML5, CSS3, JavaScript, AngularJS, React Cloud Platforms: Microsoft Azure (AKS, AAD, DevOps, VMs, Key Vaults, Networking), AWS (EC2, S3, IAM, RDS, VPC, Lambda, CloudWatch)

Professional Experience

Cigna Windsor, CT. Aug 2024 - Present

QA Automation & Data Validation Engineer

Spearheaded a BDD test automation framework by integrating 4 open source tools resulting in the framework being recognized as one of the most impactful innovations by senior leadership.

Integrated Java-based automation scripts with Jenkins CI/CD pipelines, enabling continuous testing for AngularJS and Java web applications, and resulting in a 50% faster feedback loop for engineering teams.

Forged a streamlined data validation workflow for HIPAA-compliant EDI transactions using Postman, resulting in processing 500+ EDI transactions daily, increasing overall throughput and data accuracy.

Constructed Python-based ETL processes with advanced SQL scripting, validating data transformation logic and impacting a 40% reduction in data cleansing efforts for regulatory reporting.

Revolutionized ETL testing by architecting advanced SQL and Python scripts, verifying source-to-target mapping, and cleansing logic. Also, maintained 100% personal test case execution coverage for all releases.

Deployed Python-based tools for deep log inspection, automated report creation, and data validation, and personally resolved 5+ data reconciliation tickets weekly.

Championed API pipeline integrity by architecting robust automation suites using REST-assured/Java and Swagger, testing 50+ critical API endpoints and solidifying data validation, which was recognized by senior leadership.

Spearheaded performance assessments of cloud-based claims services leveraging Apache JMeter, identifying critical infrastructure scaling issues and optimizing resource allocation by 20%. Virginia Department of Education Richmond, Virginia Jan 2021 – Aug 2024 SDET / Data Validation Engineer

Championed data-driven testing, leveraging observability tools to identify top failure points, leading to targeted fixes that improved application stability and reduced user-reported issues by 40%.

Established a standardized automation process, which was adopted by all the engineers on the team, resulting in a remarkable decrease in manual testing hours by 10 hours weekly.

Automated API testing using REST-assured to achieve 95% coverage and improve data accuracy, leading to zero critical data anomalies in production within the first month post-implementation.

Pioneered SQL validation processes identifying and fixing 50+ data anomalies within 2 weeks, ensuring data consistency and reducing subsequent debugging time for developers.

Automated code quality checks within the TDD framework, resulting in a 60% boost in code excellence and a 40% reduction in time spent on code reviews.

Designed data profiling modules using Python, Pandas, and NumPy to assess the distribution of 100+ data fields and identify skewed datasets, leading to better model selection.

Guided the development and maintenance of comprehensive test suites in Zephyr Scale, resulting in faster test execution times and a 30% reduction in the regression testing cycle for new releases.

Engineered performance benchmarks for Android, iOS, and web applications under simulated user loads, surpassing the benchmarks by 10%, guaranteeing optimal user experience during high-traffic periods and peak usage.

EmidsTechnologies Nashville, Tennessee Jul 2018 – Dec 2020 Data QA / Quality Analyst

Conducted comprehensive business requirements analysis via documentation review, stakeholder interviews, and end-to-end workflow decomposition.

Designed and developed detailed test plans, test cases, and test scenarios covering diverse benefit plan configurations and complex healthcare claims adjudication processes.

Managed the defect lifecycle for complex 837 claims scenarios, providing root cause analysis and facilitating cross-functional issue resolution.

Collaborated closely with Subject Matter Experts (SMEs), developers, and product owners to enhance test coverage, prioritize defects, and ensure CMS Medicare regulatory compliance.

Utilized HP ALM/Quality Center for defect logging, test execution tracking, requirements traceability, and quality metrics reporting throughout the SDLC.

Aetna, Hartford, Connecticut Feb 2017 – Jul 2018

Junior Data Quality Analyst

Masterminded the requirements gathering process, pinpointing critical test objectives based on technical specifications; this cut the number of critical severity incidents in test environments by 65%.

Championed the design of 150+ test scenarios for FACETS modules, prioritized testing for Coordination of Benefits (COB) and ETL data migration, and reduced data errors by 22% in critical reports.

Hardened data consistency by implementing SQL queries and conducted thorough backend validation, leading to a 99.9% data accuracy rate in critical FACETS modules, a personal achievement.

Directed data quality assurance for Salesforce implementations, conducting 100+ tests weekly on data migrations, and identifying/rectifying inconsistencies; this contributed to a boost in user satisfaction.

Launched automated regression testing with UNIX shell scripts and ReadyAPI, diminishing manual testing time by 60 hours weekly, and accelerating product release cycles.

Championed the validation of search engine features by conducting 300+ test cases using REST Assured and JUnit, which reduced bug reports by 10% and improved data quality. Education

Master of Science (MSc) in Software Engineering Jan 2022 - Dec 2024 University of Tennessee, Knoxville, TN

Contact this candidate