Shivshankar Ravi

Developed an automated MicroStrategy subscription management system in Go for legacy reporting workflows, achieving 81% unit test coverage.

Collaborated with external stakeholders in Agile sprints to deliver iterative improvements and ensure project milestones were met efficiently. Built and maintained ETL pipelines with DBT, Dagster, and Tableau across multiple data layers. Developed a Python script to automate cleanup of temporary tables in Postgres via Dagster orchestration, saving 10 GB of storage monthly. Utilized Kafka for reliable data streaming to optimize marketplace data flows. Conducted in-depth evaluation and integration of data catalog tools as part of a master's thesis for enhanced data quality and discovery.

Collaborated with cross-functional teams to analyze client requirements, design scalable data architecture, efficient data warehouse modeling, and streamlined ETL/ELT pipelines. Automated resource monitoring in Snowflake enabling real-time credit tracking and cost/performance optimization. Developed cost monitoring solutions to optimize client data infrastructure spending. Conducted technical sharing sessions for junior engineers. Leveraged AWS-based alerting systems to improve proactive monitoring and minimize downtime. Implemented proof of concept with Debezium, MSK Kafka, and PostgreSQL. Used DBT for Change Data Capture to ensure accurate updates in Enterprise Data Warehouse and created 20+ dynamic Tableau dashboards for business insights.