Sunil Lendave

Results-driven Senior Executive at Vodafone Intelligence Solutions with expertise in Ab Initio and SQL. Achieved a 40% improvement in data extraction speed while mentoring junior developers. Proven ability to optimize ETL processes and enhance performance, demonstrating strong analytical skills and a commitment to continuous improvement.

Teradata TTU Upgrade Project:

• Collaborated with 15+ downstream teams using Teradata to assess SQL compatibility and guide them in adapting to the upgraded TTU environment.
• Wrote and optimized complex SQL queries to compare row-level data across old and new environments, ensuring zero data mismatch.
• Maintained detailed SQL logs and test cases for validation, audit, and rollback scenarios.
• Enabled faster downstream team migration by creating reusable SQL validation scripts, reducing verification effort by 40%.
• Ensured 100% data validation accuracy across all test cases during upgrade certification.

Erasing tech Debt:

• Analyzed 60+ Teradata sandboxes to audit database assets including tables, views, and BTEQ scripts.
• Identified unused or obsolete database objects that were not part of any active ETL pipelines or downstream functionalities.
• Collaborated closely with the Architecture team by delivering structured reports, which were used to define High-Level Design (HLD) for optimized data models

Abinitio Simplification:

• Conducted deep code analysis across 70+ critical Ab Initio graphs to identify overused components, logic redundancy, and performance bottlenecks.
• Replaced older constructs (e.g., heavy joins, custom transforms) with lightweight built-in components and modular design patterns to improve reusability and runtime efficiency.
• Maintained exact output structure and record sequence to ensure zero impact to downstream consumers and BAU.
• Achieved up to 45% reduction in job CPU time and 30–40% shorter execution time across top-tier production jobs.
• Recognized by the architecture and operations teams as a core contributor to system-wide performance uplift without any disruption to live business processes.