Diwakar Paliwal

Built and maintained scalable ETL pipelines using Snowflake and Databricks with PySpark for distributed processing of 25+ financial datasets, ensuring 100% data accuracy across reconciliation workflows; Developed automated reconciliation reports using Python (pandas) and SQL, onboarding them to internal automation tool (Finance Platform) and reducing manual reporting time by 90%; Led end-to-end migration of legacy reporting systems to modern cloud-based workflows, restating 10+ years of historical data using SQL-based transformation logic and validation frameworks; Developed Python scripts to integrate with REST APIs for automated data ingestion, enabling seamless data extraction from external sources into data pipelines; Took ownership of 150+ monthly BAU processes during team attrition, training new resources on Python, SQL, and platform workflows while ensuring SLA compliance and timely delivery

Managed SQL databases and optimized data retrieval using advanced stored procedures, improving query performance by over 60% and streamlining daily operations; Implemented trigger-based data validations to ensure data integrity, proactively detecting anomalies and protecting downstream analytics workflows; Developed comprehensive documentation of data processes and workflows, receiving multiple client appreciations and internal awards for delivering high-quality solutions

Awarded Gold Medal and conferred Honors Degree for academic excellence, graduating with CGPA of 9.8 in B.Tech Biotechnology