Ram Makwana

Data Engineer with overall 7+ years of experience designing, developing, and optimizing scalable data pipelines, data warehousing solutions, and ETL/ELT workflows across Microsoft Azure and Google Cloud Platform (GCP) environments. Advanced proficiency in SQL and Python, with hands-on expertise in Apache Spark (PySpark), Apache Airflow, Databricks, and BigQuery for building reliable, high-performance data architecture. Experienced in Medallion architecture, data modeling, data integration from structured and semi-structured data sources, data quality and data governance implementation, and CI/CD automation using Terraform and Git.

Proven record partnering with data scientists, analysts, and business stakeholders in Agile delivery environments to translate requirements into scalable data engineering solutions, while mentoring junior engineers on data platform best practices.

Data Engineer I at General Mills India (2022-11 – Present)

• Design and build scalable, reliable data pipelines using ADLS Gen2, Azure Data Factory (ADF), and Azure Databricks, improving data processing efficiency and reducing manual intervention by 35%.
• Develop and maintain ETL/ELT workflows using Apache Airflow and DBT, improving orchestration reliability and reducing manual effort by 40%.
• Build PySpark-based transformations in Databricks for scalable, high-performance distributed processing of structured and unstructured data.
• Design and optimize BigQuery data warehouse architecture leveraging partitioning, clustering, and materialized views, improving query performance by 45%.
• Write complex SQL using Common Table Expressions (CTEs) and window functions to build efficient, maintainable transformation logic and analytical queries.
• Leverage AI-assisted development tools (GitHub Copilot) to accelerate SQL and PySpark code development, reducing development time by 50% while maintaining coding standards.
• Lead cost optimization initiatives across cloud data platforms, reducing operational expenses by $1800 annually through improved job scheduling and cluster management.
• Implemented Row-Level Security and IAM-based access controls across 6 business domains, enforcing role-based access to sensitive data.
• Collaborate with data scientists, analysts, and product managers in Agile delivery environments to translate business requirements into scalable data models and data architecture.
• Establish CI/CD pipelines using Git for automated deployments, reducing manual release effort by 50% and improving reliability and consistency.
• Mentor junior data engineers on cloud architecture, data pipeline design, and SQL query optimization best practices.

Big Data Developer at Tata Consultancy Services Limited (2020-01 – 2022-11)

• Migrated legacy systems to a Hadoop and Apache Spark-based big data platform, modernizing analytics capabilities and improving data processing performance by 30%.
• Developed and maintained Hive and Spark Streaming solutions for near real-time data ingestion, improving pipeline efficiency by 30% and enabling faster business insights.
• Integrated structured and unstructured data from multiple sources - including SAP, flat files, and APIs - into consolidated analytical datasets for enterprise data integration.
• Supported business intelligence (BI) reporting through SAP Web Intelligence (Webi) and contributed to data model design.
• Conducted root cause analysis for data quality issues and prepared remediation frameworks aligned with data governance standards.
• Worked on Banking Data and create data ingestion pipeline and loaded into Hadoop system

Android App Developer at Rupeeseed Technology Ventures Pvt Ltd. (2019-02 – 2019-08)

• Create Android app layouts and UI components, delivering responsive user experiences.
• Integrated REST and internal APIs to retrieve and process application data.
• Designed scalable Android applications using standard design patterns and development frameworks, reducing maintenance effort by 20%

B.E in Electronics & Telecommunication Engineering – Thakur College of Engineering and Technology, Mumbai (2014-05 – 2018-06)