Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Ashokkumar Avudainayagam

Austin,United States

Summary

Lead Data Engineer with 17 years of experience in data engineering, warehousing, cloud architecture, and DevOps. Proven track record of leading large-scale data initiatives, architecting scalable data solutions, and driving operational excellence within Agile environments. Skilled in leveraging modern cloud platforms and big data technologies to power enterprise analytics, enhance data reliability, and support strategic decision-making.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

Infosys Limited
03.2020 - Current
  • Orchestrated the global launch of a transformative data product for Apple Care+, enabling reconciliation of GL postings vs. daily invoices and elevating data quality by 70%.
  • Engineered a pivotal MVP by establishing lineage between SAP GL postings and invoice feeder documents, clearing a balance of $30M in the Insurance premium payable account.
  • Amplified user adoption and engagement by 80%, fortifying data integrity and accuracy for seamless period/quarter-end reporting with minimal operational debt.
  • Designed and developed scalable ETL pipelines using the Keystone Framework, leveraging Apache Spark to extract, transform, and load data from SAP/Hana CV into Snowflake through AWS S3 as an intermediary storage.
  • Automated data ingestion from AWS S3 into Snowflake using Snowflake's COPY Command for efficient, batch data loading, ensuring timely data updates for analytics and reporting.
  • Monitored and managed pipeline performance using Apache Airflow for job scheduling and dependency management, ensuring pipeline reliability and data quality.
  • Led a team of developers, coordinating tasks and mentoring on best practices for data engineering, while collaborating with cross-functional teams to align on data requirements and troubleshoot pipeline issues.

Lead Data Engineer

Infosys Limited
06.2012 - 02.2020
  • Led 24x7 production support for in-house Teradata and bigdata-based data warehouse systems, enabling seamless delivery of 30K+ daily batch processes across business units.
  • Executed Black Friday and Thanksgiving Day Peak BI Flash Reporting by architecting, scripting, and materializing the technical vision for this business-critical initiative, delivering real-time reporting to executives and senior leadership.
  • Supported a robust big data pipeline using spark and HQL to ingest into Hive raw layer, apply surrogate key logic, consolidate online and retail data, and aggregate for BI consumption.
  • Achieved $500K/year in IT cost savings through automation of inventory control processing and defining clear product requirements; improved store audit data integrity by 90%.
  • Acted as SME and lead on the Design for Operations team, implementing architectural standards and minimizing technical debt across the Enterprise Information Management tribe.
  • Provided on-call L2 support in shifts, resolving batch and data production issues/defects, achieving an incident resolution rate of 850+ incidents per month by delivering workarounds and technical solutions to various business units.
  • Acted as L3 support within the Problem Management team, addressing production issues and delivering permanent, long-term solutions, resolving 20+ problems per month escalated from incident management.
  • Conducted thorough risk assessments to identify system constraints and developed effective mitigation strategies to address potential challenges.
  • Monitored service contracts and SLAs, identifying potential risks and implementing proactive measures to ensure compliance and prevent delays or breaches in support processes.

Senior Data Engineer

Infosys Limited
06.2008 - 05.2012
  • Contributed to the development and support of a centralized in-house Teradata data warehouse system designed to maintain a "Single Version of the Truth" for various business units.
  • Developed high-performance relational data stores and compute solutions using RDBMS technologies like Teradata, leveraging Teradata utilities such as Mload, Fload, and Fastexport to create accurate datasets for data analytics.
  • Optimized Teradata Bteq SQL scripts, improving query performance and achieving 60% increase in efficiency.
  • Ensured data quality, integrity, and reliability across the data warehouse by designing, maintaining, and implementing data governance practices and optimizing database efficiency.

Education

Bachelor of Technology - Electronics & Communication

Amrita Vishwa Vidyapeetham
India
2008

Skills

  • Data Engineering
  • ETL Development
  • Big Data & Cloud Technologies
  • Data Integration & Transformation
  • 24x7 Production Support & Incident Management
  • Business Intelligence (BI) & Reporting

Certification

  • Microsoft Certified Azure Developer
  • Lex - Spark Programming Certification (Infosys internal)
  • Scrum Alliance - Certified ScrumMaster
  • SAFe POPM 6.0
  • Teradata Certified Professional. (V12) (TE0 - 121)
  • Teradata Certified Professional. (V2R5)
  • IBM Datastage 8.5 Certification
  • Oracle 10g certification.

Timeline

Lead Data Engineer

Infosys Limited
03.2020 - Current

Lead Data Engineer

Infosys Limited
06.2012 - 02.2020

Senior Data Engineer

Infosys Limited
06.2008 - 05.2012

Bachelor of Technology - Electronics & Communication

Amrita Vishwa Vidyapeetham

Similar Profiles

CREATE PROFILE
Ashokkumar Avudainayagam