Siddhant Pawar

About Siddhant Pawar

I am a results-driven Software Engineer with a strong focus on data engineering, workflow automation, and scalable analytics solutions, enabling data-driven decision-making across global enterprise teams.My work spans both data engineering and applied data science. I have built hierarchical time-series forecasting models using Python, SQL, and dbt to predict procurement spend for top vendors, deploying production-ready solutions on OpenShift AI with a focus on scalability, reliability, and accuracy.On the data engineering side, I led the onboarding of Snowflake, migrating 350+ tables (~1.5 TB) from Oracle using Fivetran. I designed robust financial data marts with incremental models, reconciliation checks, and Git-based version control, ensuring data quality and analytical consistency.I have also delivered enterprise-grade integrations and workflow automations across Oracle, ServiceNow, Workato, AWS S3, and Google Drive, streamlining data flows and automating large-scale report delivery beyond traditional system limits. Additionally, I automated SQL-driven processes for purchasing categories, tax flags, and reporting, improving accuracy across 10M+ records while eliminating 500+ manual tasks.I thrive in cross-functional collaboration, problem-solving, and end-to-end ownership—from proof of concept to production deployment. Passionate about AI, data engineering, and intelligent systems, I continuously seek opportunities to build scalable solutions that deliver measurable business impact while adapting to emerging technologies.

Experience

1. Associate Software Engineer

   IBM

   Jan 2026 — Present · Pune, IN

   Part of the same team transitioned from Red Hat to IBMSAP Ariba – Supplier Master Data Integration• Designed and implemented end-to-end supplier master data integration between Oracle ERP and SAP Ariba using Workato, Oracle REST APIs, and JSON transformations, supporting complex vendor hierarchies (vendors, sites, bank accounts, intermediary banks).• Built incremental INSERT and UPDATE pipelines using timestamp-based filtering and lookup tables to process delta changes only, improving performance and eliminating data redundancy.• Implemented robust reconciliation logic for external and internal supplier questionnaires, ensuring data completeness and accuracy during partial updates and vendor corrections.• Designed vendor-level job execution, audit logging, and monitoring, along with automated business and IT notifications, significantly improving traceability, error handling, and operational support.• Developed and scheduled supplier deactivation workflows using SAP Ariba APIs to maintain vendor lifecycle and status consistency across integrated systems.• Collaborated closely with functional procurement teams and integration stakeholders to align technical workflows with business validation rules and compliance requirements.

Education

• Vishwakarma Institute Of Technology

  Bachelor of Technology - BTech, Computer Engineering