Shripal Mehta

As a data analyst, I studied the survey responses of the participants and built visualisations and dashboards in Tableau. Also used MS Excel and SQL for working on specific bits of the project ask.

• Enhanced real-time data acquisition and transformation of 8 million daily JSON messages (30 TB data volume) by building ETL pipelines to develop, integrate, test, and deploy Kafka Consumer.

• Built a robust Data Dictionary (for tracking & versioning) of 3000+ attributes sourced from real-time Kafka Topics into a single database.

• Implemented Day-0 & Day-1 data loads for Hadoop Warehouse with dynamic partitioned Hive tables.

• Strengthened data governance and security by implementing role-based access control.

• Boosted efficiency by 30% through introduction of real-time failure notification alerts.

• Collaborated cross-functionally with project managers, developers, testers, and data scientists to strategically align objectives.