Rajan Yadav

• Designed and built automated data ingestion pipelines processing 100K+ records from CSV files, APIs, and
relational databases.
• Developed Python automation tools to streamline internal data reporting, reducing manual processing effort
by approximately 50%.
• Performed data validation and quality checks ensuring datasets were clean, consistent, and analytics
ready.
• Optimized complex SQL queries using joins and window functions, reducing report execution time by 40%.
• Collaborated with cross-functional teams to improve ETL workflows, data structures, and reporting
processes, enhancing data accessibility and reliability.

• Supported enterprise data systems and databases, maintaining high availability and supporting mission
critical production environments.
• Diagnosed and resolved ETL pipeline failures and data inconsistencies using SQL-based root cause
analysis.
• Reduced recurring production incidents by 30% through root-cause analysis and process improvements.
• Maintained data workflows and assisted in system integrations across multi-team enterprise environments.