Prashant Patel
Malvern
Summary
Dynamic and solution-oriented DevSecOps and Automation Specialist with over 22 years of experience bridging the gap between business needs and technological advancements. Expertise in translating complex business challenges into cost-effective technology solutions while designing scalable automation frameworks that enhance operational efficiency. Proven track record in cultivating strategic partnerships, championing the adoption of innovative tools, and delivering enterprise-wide solutions that significantly improve accuracy and decision-making processes. Recognized for strong communication skills and mentorship capabilities, complemented by deep knowledge in test automation, data management, analytics, and performance engineering.
Overview
26
26
years of professional experience
Work History
Senior DevSecOps Automation Engineer
Vanguard
11.2021 - Current
- Engineered enterprise-wide automation frameworks using Python, Robot Framework, and Selenium, cutting manual regression effort by 70% and saving $325K annually.
- Automated test-data provisioning and environment setup within CI/CD pipelines, reducing release cycles from two weeks → three days.
- Migrated legacy Java/Selenium suites to modern Python/Robot architecture, halving maintenance effort and boosting reliability across 10+ applications.
- Developed reusable CI/CD components with GitHub Actions, enabling zero-touch nightly builds and consistent test execution.
- Integrated performance test automation into build pipelines, uncovering 20% performance improvements in key APIs.
- Designed and implemented AWS ETL pipelines (S3 → Glue → Athena) to ingest, cleanse, and convert vendor CSVs to Parquet—delivering query-ready datasets and eliminating manual data prep.
- Built event-driven Lambda triggers for real-time ingestion, reducing latency from hours → minutes between vendor file arrival and analytics availability.
- Developed data-quality validation rules and schema-transformation logic that improved accuracy by 30%, ensuring trusted reporting across business units.
- Automated KMS encryption and IAM least-privilege policies, achieving 100% compliance with corporate data-security standards.
- Created CloudWatch/SNS monitoring for Glue and Lambda job alerts, improving reliability and mean-time-to-detect for failures.
- Quality, Data Governance & Operational Excellence
- Performed root-cause analysis on 1,000+ defects, driving sustainable fixes to recurring data and automation issues.
- Managed Operational Excellence dashboards (Jira → Tableau) providing real-time visibility into 300+ automation adoption initiatives.
- Strengthened data integrity through standardized validation checks and reconciliation of mismatched datasets.
- Championed a shift-left QA approach, embedding early automation and static analysis to detect issues pre-UAT.
- Mentored onshore and offshore teams on automation best practices, improving test coverage and throughput.
- Innovation & Leadership
- Received 23 corporate recognitions for automation innovation, delivery excellence, and cross-functional collaboration.
- Delivered hackathon-winning prototypes such as an AI-powered knowledge base using AWS Bedrock + vector embeddings to automate technical Q&A.
- Launched the internal “Every Computer Click Is Automatable” campaign, inspiring grassroots process-automation adoption and saving hundreds of hours quarterly.
- Mentored and coached engineers to design scalable, reusable frameworks—boosting automation adoption by 40%.
- Presented automation and data-engineering outcomes to senior leadership, influencing strategic investment in DevSecOps capabilities.
Automation Architect/Senior QA Analyst
Iconectiv
07.2017 - 11.2021
- Designed, developed, and maintained a hybrid data-driven automation framework using Selenium, Python, and Robot Framework, incorporating Page Object Model and TestNG annotations.
- Led framework governance by conducting code reviews, enforcing standards, and mentoring junior associates on test automation design and planning.
- Performed regular script maintenance, created reusable methods, and ensured all test cases were automation-friendly and aligned with framework guidelines.
- Collaborated with cross-functional teams to ensure quality releases and provided estimates for time and resources.
- Wrote and executed SQL queries for data validation and test data creation across front-end and back-end layers.
- Researched and integrated new tools and methodologies, delivering automated solutions for time-consuming and ad-hoc tasks.
- Educated development teams on building automation-ready applications through effective use of unique element identifiers.
Test Data Administrator
Albridge Solution, a BNYM Company
07.2013 - 07.2017
- Ensured compliance with corporate data policies by securely masking and monitoring highly confidential datasets in non-production environments, protecting sensitive information and maintaining audit readiness.
- Executed full test data lifecycle management (discovery, extraction, masking, archiving, loading) to ensure consistency, accuracy, and reliability of datasets across multiple environments.
- Performed root cause analysis of process execution issues by analyzing logs and resolving data conflicts, improving system stability and data reliability.
- Developed and implemented validation techniques that eliminated orphaned records and safeguarded data integrity during large-scale masking operations.
- Analyzed production datasets at scale (billions of records) and designed complex SQL queries to deliver optimized subsets, improving testing efficiency and analytics accuracy.
- Performed data refreshes across multiple UAT systems to ensure accurate, up-to-date datasets for testing and business validation.
- Utilized Oracle Data Pump and UNIX scp to securely extract, transfer, and import massive non-PII datasets, reducing downtime and mitigating migration risks.
Lead Automation Engineer/Senior QA Analyst
Albridge Solution, a BNYM Company
06.2006 - 06.2013
- Designed and implemented a UFT-based test automation framework with parameterized, data-driven scripts, incorporating advanced VBScript logic to enhance reusability and minimize maintenance.
- Executed comprehensive testing across multiple builds, including sanity, regression, end-to-end, production, ad-hoc, backend, boundary, and negative testing, while documenting and reporting detailed test results.
- Mentored junior associates on automation design, scripting techniques, and QA best practices to improve team competency.
- Conducted performance testing using QaLoad 5.9, including gathering requirements, scripting, executing benchmarks, and sharing results—often under tight deadlines for major releases.
- Validated large datasets and analyzed logs using UNIX shell utilities (awk, sed, cut, wc), and automated test data creation through Excel macros.
- Wrote and executed complex SQL queries to validate backend data and support test case creation.
- Logged and tracked defects through closure, participated in root cause analysis, and developed global templates in HP Quality Center to standardize processes and enhance efficiency.
- Collaborated closely with development, business analysis, data quality, and production support teams to ensure high-quality releases.
Lead Automation Engineer/Senior QA Analyst
IDT Corp
04.2005 - 06.2007
QA Engineer
Automatic Data Processing, Inc. (ADP)
07.2003 - 03.2005
QA Software Test Engineer
Micro Design Services LLC (MDS)
01.2001 - 07.2003
Data Analyst
Managed Healthcare Associates (MHA)
03.2000 - 01.2001
Education
Associate in Applied Science - Computer Information Systems
DeVry University
North Brunswick, NJ02.2000
Associate in Applied Science - Chemistry
Middlesex County College
Edison, NJ08.1997
Skills
- Cloud & DevOps: AWS (CloudFormation, S3, ECS), GitHub, Workflows, Jenkins
- Software: Jira, Postman, Locust, LoadRunner, Splunk, Robot Framework, Dynatrace, IBM Optim, Beyond Compare, Firebug, Eclipse, Tamper Data
- Language/Script: Python, SQL, PL/SQL, Java, Selenium, groovy, UNIX Shell Scripting, XML, VB Script, VB 60, Java Script, HTML, Perl, XML, WSDL, PHP, AJAX
- Database: Oracle, Sybase, MS SQL Server
- Operating System: Windows, UNIX, Linux
- Protocol: TCP, IP, FTTP, HTTPS, FTP, SCP, Telnet, SOAP, SAML, JSON
Timeline
Senior DevSecOps Automation Engineer
Vanguard
11.2021 - Current
Automation Architect/Senior QA Analyst
Iconectiv
07.2017 - 11.2021
Test Data Administrator
Albridge Solution, a BNYM Company
07.2013 - 07.2017
Lead Automation Engineer/Senior QA Analyst
Albridge Solution, a BNYM Company
06.2006 - 06.2013
Lead Automation Engineer/Senior QA Analyst
IDT Corp
04.2005 - 06.2007
QA Engineer
Automatic Data Processing, Inc. (ADP)
07.2003 - 03.2005
QA Software Test Engineer
Micro Design Services LLC (MDS)
01.2001 - 07.2003
Data Analyst
Managed Healthcare Associates (MHA)
03.2000 - 01.2001
Associate in Applied Science - Chemistry
Middlesex County College
Associate in Applied Science - Computer Information Systems
DeVry University
Similar Profiles
Daniel FyermanDaniel Fyerman
Client Relations Specialist at VanguardClient Relations Specialist at Vanguard
Kathleen KercherKathleen Kercher
Travel Security Program Manager at VanguardTravel Security Program Manager at Vanguard
Deanne DraytonDeanne Drayton
Client Service Representative at VanguardClient Service Representative at Vanguard
Marjahan AkhterMarjahan Akhter
Security Guard at VanguardSecurity Guard at Vanguard
Reed EngleReed Engle
Service Associate at Kilwins Chocolates & Ice CreamService Associate at Kilwins Chocolates & Ice Cream