Ravi Prakash R

Experience

1. Data Warehouse Analyst

   FedEx

   Sep 2023 — Present · Memphis, TN, US

   Designed and optimized ETL/ELT pipelines using Informatica IDMC to integrate shipment, logistics, and billing data across global operations. Migrated legacy mainframe workflows (JCL, COBOL, COOLGEN, and WebFOCUS) into cloud-native IDMC pipelines. Developed dimensional data models in Snowflake and Redshift for freight tracking and operational reporting. Built real-time data ingestion frameworks with Kafka for live package status and exception reporting. Conducted data profiling, validation, and reconciliation to ensure accurate and consistent shipment data. Implemented metadata management and data lineage tracking to support compliance and auditing needs. Automated legacy report logic translation, reducing manual maintenance by 40%. Enhanced ETL performance through orchestration optimization, parallelism, and incremental load strategies. Collaborated with operations, finance, and planning teams to translate reporting requirements into data models and ETL workflows. Delivered self-service datasets for predictive route optimization and SLA tracking. Built real-time dashboards for proactive monitoring of package deliveries and logistics efficiency. Conducted structured UAT, regression testing, and stakeholder validation for new data pipelines. Ensured PII masking, encryption, and governance controls for sensitive customer and shipment data. Authored ETL workflow documentation, technical diagrams, and operational SOPs.