PAPUN KUMAR

PROJECT 1 (ORACLE TO POSTGRESQL MIGRATION & CDC DELTA PIPELINES) 2025-CONTINUED - Led the successful migration of ~10 billion historical records from Oracle to PostgreSQL, ensuring data integrity, performance, and minimal downtime. - Designed and implemented nearreal-time delta ingestion pipelines using HVR to capture and synchronise source system changes efficiently. - Collaborated closely with the clients enterprise architect to enhance and optimise the data ingestion framework, scaling the architecture to support future growth of up to 62 billion records. PROJECT 2 (CHATBOT ANALYTICS DATA PLATFORM ON AWS & DATABRICKS) 2025 - Designed and built end-to-end data pipelines using Databricks, AWS services, and REST APIs (Postman) to ingest JSON data from three chatbot platforms into Amazon Aurora, enabling SQL-based analytics and executive-level Power BI dashboards for Directors and CTOs. - Enhanced and scaled the data ingestion and validation framework to support 11 chatbot data sources, improving data quality, extensibility, and onboarding efficiency through a newly developed architecture. - Collaborated with two internal team members while leading and coordinating two external teams (~6 members total), driving delivery of the new development plan through effective cross-team communication and technical guidance. PROJECT 3 (ENTERPRISE DATA SOLUTIONS DELIVERY) 2021-2024 - Owned requirements gathering, analysis, and scalability planning to deliver data solutions aligned with customer needs. - Designed, developed, and optimised robust data pipelines across multiple source systems, ensuring performance and reliability. - Led the successful end-to-end delivery of six critical systems while managing and mentoring teams of 27 members.

Acquired in-depth knowledge of internal usage of third-party tools and existing ETL processes through structured knowledge transfer sessions.

PROJECT 4 (TALEND ETL ORCHESTRATION TO SALESFORCE/CROPIN) 2018-2020 - Designed, developed, and managed Talend ETL jobs to orchestrate data flows from multiple in-house applications and SQL/AS400 databases to target platforms including Salesforce and Cropin. - Owned the full ETL analysis, job design, customization, deployment, scheduling, monitoring, performance tuning, and ongoing maintenanceensuring reliable and optimized data pipelines. - Installed and configured Talend and related applications, produced comprehensive technical documentation, and led root cause analysis for job and system failures to improve stability and resilience. PROJECT 5 (ATLASSIAN SUITE MIGRATION & ADMINISTRATION) 2017-2018 - Led migration of Crop Sciences data into the Atlassian ecosystem and administered the full Atlassian suite (JIRA, Confluence, Bitbucket, Bamboo, Crowd), ensuring seamless adoption and platform stability. - Set up and customized Atlassian tools by migrating existing projects, designing JIRA workflows and dashboards, managing user and project configurations, integrating Active Directory via Crowd, and migrating CI/CD pipelines and code repositories.

PROJECT 6 (PRE MERGER ENVIRONMENT SETUP & R PACKAGE INTEGRATION) 2017 - Contributed to a pre-merger program by setting up a new technical environment in India, supporting platform readiness and regional rollout. - Customized and migrated R packages using RStudio, integrated Single Sign-On (SSO) authentication, and executed build and deployment activities to ensure secure and seamless system integration.