Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Sainadh Reddy

Summary

Results-driven Ab Initio Developer with 5.5 years of experience designing, building, and optimizing high-volume ETL pipelines using the Ab Initio suite. Proven expertise in developing robust data workflows, implementing complex business logic, and ensuring production stability in fast-paced environments. Skilled in Unix shell scripting, Autosys job scheduling, and end-to-end ETL lifecycle support. Known for quick adaptability, strong debugging skills, and collaborative problem-solving. Experienced across banking and healthcare domains, with hands-on delivery of regulatory, operational, and financial ETL solutions. Regularly collaborated with QA and business teams, conducted code reviews, and mentored junior developers in Ab Initio best practices.

Overview

6
6
years of professional experience

Work History

Ab Initio Developer

Discover Financial Services
03.2023 - Current
  • Designed and developed scalable ETL pipelines using Ab Initio for regulatory and financial data processing.
  • Led transformation logic implementation for batch processes handling high-volume input files (multi-files, fixed-width, delimited).
  • Created source-to-target mappings and supported impact analysis for new data workflows.
  • Built reusable graphs and components using parameterization and sandboxing.
  • Developed and maintained job orchestration workflows in Autosys and Conduct>It with built-in error recovery logic.
  • Used Ab Initio CDC for incremental load processing and efficient data sync.
  • Performed unit testing, debugging, and root-cause analysis on production failures within SLAs.
  • Supported compliance reporting pipelines with performance-tuned ETL graphs.

ETL Developer – Ab Initio

IBM (Walgreens Project)
04.2019 - 07.2022
  • Reengineered legacy ETL systems into optimized Ab Initio workflows handling prescription data.
  • Built and managed high-performance graphs using features like MFS, partitions, broadcast-replicate, and rollup.
  • Standardized development using modular components and parameterized graphs.
  • Developed Unix scripts for file handling, validation, and integration with job control.
  • Collaborated closely with QA, BA, and support teams to ensure accuracy and maintainability.
  • Led production deployment activities and post-deployment job validation.
  • Built custom validation frameworks using Ab Initio components to automate field-level checks, schema validations, and file-level controls before ingestion.
  • Implemented audit trail logging and file-level metadata capture for traceability and compliance, reducing post-load reconciliation issues.
  • Developed pre-processing shell scripts for data cleansing and dynamic file renaming, ensuring compatibility with graph-level ingestion rules.

Education

M.S. - Information Assurance

Wilmington University
Delaware, USA
01.2024

B.Sc. (Hons) - Horticulture

Dr. YSR Horticultural University
A.P., India
01.2019

Skills

  • ETL Tools: Ab Initio (GDE up to 411, Co>Operating System, Conduct>It, EME, Express>It)
  • Scheduling Tools: Autosys, Conduct>It
  • Operating Systems: UNIX, Windows
  • Databases: Oracle, SQL Server, DB2 (basic knowledge)
  • Languages: SQL, Unix Shell Scripting
  • Other Tools: Power BI (basic reporting), AWS

Projects

Liquidity Coverage Ratio (LCR), Discover Financial Services, 16 months, 8, Ab Initio Developer, Ab Initio, Unix, Autosys, Developed regulatory ETL jobs from scratch using Ab Initio for liquidity ratio reporting., Applied data validations and transformations as per Fed compliance guidelines., Managed STTM documentation and coordinated with QA for validation coverage., Streamlined job scheduling with full error handling and dependency management. Standard Profitability Formula, Discover Financial Services, 10 months, 7, Developer / Reviewer, Ab Initio, Oracle, Unix, Rebuilt profitability report ETLs by consolidating 15 legacy apps into 2 optimized workflows., Created robust validation layers and automated error alerts for data integrity assurance., Supported migration testing and environment transitions to ensure continuity., Developed dynamic parameter-driven graphs to handle multiple product types and profitability models with a single reusable framework., Created lookup-based join logic using broadcast and partitioned datasets to improve transformation efficiency and minimize memory usage., Implemented row-level data tracing and reconciliation logic to enable end-to-end auditability between input sources and final profitability reports. Prescription Data Analytics (PDA), Walgreens, 3.3 years, 12, Ab Initio Consultant, Ab Initio, Oracle, Unix, Designed ETL processes for daily processing of pharmacy prescription data., Tuned performance using advanced Ab Initio features (max-core, partitioning, broadcast)., Maintained SLA-sensitive jobs with 24x7 support coverage during go-lives., Built custom validation frameworks using Ab Initio components to automate field-level checks, schema validations, and file-level controls before ingestion., Implemented audit trail logging and file-level metadata capture for traceability and compliance, reducing post-load reconciliation issues., Developed pre-processing shell scripts for data cleansing and dynamic file renaming, ensuring compatibility with graph-level ingestion rules.

Timeline

Ab Initio Developer

Discover Financial Services
03.2023 - Current

ETL Developer – Ab Initio

IBM (Walgreens Project)
04.2019 - 07.2022

M.S. - Information Assurance

Wilmington University

B.Sc. (Hons) - Horticulture

Dr. YSR Horticultural University
Sainadh Reddy