Ayush Aggarwal profile photo 1 on Tal

Ayush Aggarwal

Oracle PL/SQL Developer & Data Engineer | 85% Query Optimization • CI/CD • ETL Pipelines | SAFe & Oracle SQL Certified | AI & Data

Bengaluru

4+ years of work experience

Vidal Health
Mar 20251 yr 5 mosPresent

Bengaluru

Designed and optimized PL/SQL stored procedures, materialized views, triggers, and indexes across Oracle environments, reducing query execution time by 85% and enabling real-time analytics for health insurance operations. Automated 15+ hours/week of manual data effort using DBMS_SCHEDULER; built multi-source ETL pipelines ingesting structured and unstructured data from Oracle, REST APIs, JSON, XML, CSV, and Excel via PL/SQL and Python (Pandas). Established Azure DevOps CI/CD pipelines for automated DDL/DML schema releases across Dev, UAT, and Production, cutting deployment time by 40% and maintaining full Git version control for all PL/SQL scripts. Delivered Level 2/3 production support for 5+ critical applications using ELK stack monitoring, resolving recurring incidents by 95%; enforced RBAC, audit policies, and database security controls for regulatory compliance. Leveraged BULK COLLECT, FORALL, and Ref Cursors to process 1M+ records daily; independently conducted full SDLC code reviews and migrations with zero post-implementation issues. Collaborated with QA, product, and cross-functional stakeholders across sprint planning, UAT validation, and production sign-offs — applying SAFe Agile practices throughout the delivery lifecycle.
Mphasis
Jul 20248 mosFeb 2025

Built complex PL/SQL procedures, functions, queries with cursors, and user-defined object types for the FedEx Air Cargo Customs Clearance System — a high-volume, compliance-critical logistics platform. Designed and maintained UNIX Bash shell scripts and cron job automation pipelines, improving operational efficiency by 30% and standardizing code reuse across environments through reusable script libraries. Tuned SQL and Bash script performance via execution plan analysis, indexing strategy, and query refactoring, achieving measurable gains in system scalability and response time for high-volume transaction processing. Implemented data transformation logic and ETL workflows loading enterprise data into Big Query and implemented Git-based version control across all environments for traceable, rollback-safe deployments. Authored MTP documents, deployment runbooks, and generated stakeholder-facing analytical reports through complex SQL queries — ensuring thorough documentation for every release. Mentored junior developers on PL/SQL best practices; contributed to capacity planning, demand forecasting, and process improvement initiatives within an Agile team environment. Provided technical support to end-users and IT staff on PL/SQL-related issues; collaborated with DBAs to ensure optimal database availability and resource utilization.
Mphasis
Jun 20222 yrs 1 moJun 2024

Performed unit and end-to-end testing to ensure production-ready deployments across environments Supported cross-functional teams by debugging and resolving complex SQL and data issues.
Cognizant
Jan 20226 mosJun 2022

Noida

Completed Salesforce Trailhead with 100+ badges and 91,000 points, achieving Ranger Rank. Built process automation workflows and business solutions using Salesforce Admin tools. Delivered two Superbadges: Process Automation Specialist & Business Administration Specialist. Designed automation flows eliminating manual CRM processes.

Education

Lovely Professional University

Bachelor of Technology - BTech-CSE, Internet of Thing

Lovely Professional University

20184 yrs2022
Meerut Public School Group

PCM

Meerut Public School Group

20126 yrs2018

Join Ayush and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Ayush Aggarwal on Tal

Headline

Oracle PL/SQL Developer & Data Engineer | 85% Query Optimization • CI/CD • ETL Pipelines | SAFe & Oracle SQL Certified | AI & Data

About

I build Oracle PL/SQL and data engineering systems that power mission-critical operations — health insurance claims, customs clearance for global logistics, and enterprise analytics platforms. Four years in, the work is the same: make data move fast, reliably, and at scale. My stack spans the full data engineering lifecycle: Oracle PL/SQL (stored procedures, triggers, materialized views, dynamic SQL, BULK COLLECT, FORALL), ETL pipeline design across structured and unstructured sources (JSON, XML, REST APIs, CSV), Python (Pandas/NumPy), Azure DevOps, Git-based version control, ELK stack monitoring, and Agile delivery under the SAFe framework. Beyond the code, I focus on compliance, governance, and security — enforcing RBAC policies, audit controls, and industry standards that regulated industries like insurance and finance depend on. I've also mentored junior developers and authored deployment runbooks, because a well-documented system outlasts any single engineer. I'm SAFe certified and Oracle SQL certified — and I was recognized with a Kudos Award for resolving critical production incidents and delivering projects on schedule with zero defects. I'm actively exploring senior PL/SQL and Data Engineering roles in AI & Data practices — particularly where cloud-integrated Oracle environments, automation, and platform modernization are central to the work. Let's connect if that's where your team is headed.

Location

Bengaluru

Work experience

Software Engineer at Vidal Health, Mar 2025 - Present · 1 yr 5 mos, Bengaluru, Designed and optimized PL/SQL stored procedures, materialized views, triggers, and indexes across Oracle environments, reducing query execution time by 85% and enabling real-time analytics for health insurance operations. Automated 15+ hours/week of manual data effort using DBMS_SCHEDULER; built multi-source ETL pipelines ingesting structured and unstructured data from Oracle, REST APIs, JSON, XML, CSV, and Excel via PL/SQL and Python (Pandas). Established Azure DevOps CI/CD pipelines for automated DDL/DML schema releases across Dev, UAT, and Production, cutting deployment time by 40% and maintaining full Git version control for all PL/SQL scripts. Delivered Level 2/3 production support for 5+ critical applications using ELK stack monitoring, resolving recurring incidents by 95%; enforced RBAC, audit policies, and database security controls for regulatory compliance. Leveraged BULK COLLECT, FORALL, and Ref Cursors to process 1M+ records daily; independently conducted full SDLC code reviews and migrations with zero post-implementation issues. Collaborated with QA, product, and cross-functional stakeholders across sprint planning, UAT validation, and production sign-offs — applying SAFe Agile practices throughout the delivery lifecycle.

Software Engineer at Mphasis, Jul 2024 - Feb 2025 · 8 mos, Built complex PL/SQL procedures, functions, queries with cursors, and user-defined object types for the FedEx Air Cargo Customs Clearance System — a high-volume, compliance-critical logistics platform. Designed and maintained UNIX Bash shell scripts and cron job automation pipelines, improving operational efficiency by 30% and standardizing code reuse across environments through reusable script libraries. Tuned SQL and Bash script performance via execution plan analysis, indexing strategy, and query refactoring, achieving measurable gains in system scalability and response time for high-volume transaction processing. Implemented data transformation logic and ETL workflows loading enterprise data into Big Query and implemented Git-based version control across all environments for traceable, rollback-safe deployments. Authored MTP documents, deployment runbooks, and generated stakeholder-facing analytical reports through complex SQL queries — ensuring thorough documentation for every release. Mentored junior developers on PL/SQL best practices; contributed to capacity planning, demand forecasting, and process improvement initiatives within an Agile team environment. Provided technical support to end-users and IT staff on PL/SQL-related issues; collaborated with DBAs to ensure optimal database availability and resource utilization.

Associate Software Engineer at Mphasis, Jun 2022 - Jun 2024 · 2 yrs 1 mo, Performed unit and end-to-end testing to ensure production-ready deployments across environments Supported cross-functional teams by debugging and resolving complex SQL and data issues.

Salesforce Developer Intern at Cognizant, Jan 2022 - Jun 2022 · 6 mos, Noida, Completed Salesforce Trailhead with 100+ badges and 91,000 points, achieving Ranger Rank. Built process automation workflows and business solutions using Salesforce Admin tools. Delivered two Superbadges: Process Automation Specialist & Business Administration Specialist. Designed automation flows eliminating manual CRM processes.

Education

Bachelor of Technology - BTech-CSE, Internet of Thing, Lovely Professional University

PCM, Meerut Public School Group