Vinay Mandala

Experience

• 

  IKEA

  Jan 2019 - Dec 2020

  Data Engineer

  - Built data pipelines integrating inventory and sales data across multiple retail platforms for 45+ stores- Developed automated ETL workflows using Informatica, reducing manual processing time by 70%- Architected real-time data streaming solutions using Apache Kafka, reducing stockouts by 35%- Implemented GDPR-compliant data governance framework for customer data managementCreated interactive Tableau dashboards for sales analytics, driving 25% increase in data-informed decisions- Designed AWS S3-based data lake architecture accommodating 5TB+ of retail dataOptimized batch processing workflows in Apache Hadoop, reducing nightly sales data processing time by 60% Show less

• 

  Novartis

  Dec 2020 - Aug 2022

  Data Engineer

  - Developed ETL pipelines using Apache Airflow for processing clinical research data, ensuring data integrity and regulatory compliance- Designed a real-time data ingestion system with Apache Kafka, reducing data latency by 40% for research databases- Built scalable data lake architecture on Azure Data Lake Storage for structured and unstructured clinical trial data- Led migration of on-premises clinical databases to Azure Cloud, achieving 99.9% uptime for global research teams- Optimized complex SQL queries in PostgreSQL, improving performance by 60% for large-scale clinical databases- Implemented automated data quality frameworks with robust validation processes, reducing inconsistencies by 75%- Created interactive Power BI dashboards for tracking clinical trial metrics, providing real-time insights to research teams Show less

• 

  Ameris Bank

  Aug 2023 - now

  Senior Data Engineer

  - Architected end-to-end AWS-based data pipelines for real-time transaction processing, integrating AWS Glue, Redshift, and S3, resulting in 40% faster data processing.- Designed scalable real-time data streaming architecture using Apache Kafka and AWS Kinesis, enabling immediate insights from transaction data.- Orchestrated automated ETL workflows with Apache Airflow, reducing manual intervention by 65% and improving operational efficiency by 30%.- Optimized Redshift data warehouse schema, reducing query execution time by 50% for critical financial analytics.- Integrated machine learning models into data pipelines for real-time fraud detection, increasing fraud identification rates by 25%.- Reduced infrastructure costs by 35% through strategic implementation of serverless AWS technologies. Show less