Prabhav Karve

Rectified financial report accuracy to 100% by optimizing 40+ scripts using pandas and Cortex Generative AI in Snowflake’s LLM tools. Delivered healthcare analytics reports by integrating data from 23+ sources through ETL pipelines built in Azure Data Factory to predict expense, revenue and healthcare trends using machine learning. Automated data collection and loading into 27+ KPI tables in Snowflake by developing Python scripts to extract data from REST APIs, improving data availability and reporting speed. Designed 17+ interactive Power BI dashboards to visualize work-time and expense KPIs for healthcare.

Developed a Business Intelligence platform for Ireland’s biggest financial service using Java and Snowflake. Implemented 20+ Spring Boot REST APIs and deployed on Jenkins CI/CD. Enabled data availability at latency less than 100 ms by ingesting near-real-time transactional data using Kafka. Constructed over 50 SQL scripts and orchestrated scalable ETL pipelines on Airflow for regulatory financial reporting. Collaborated across the data modeling team to build the target schemas on Snowflake prior to the data visualization on Power BI. Resolved 77% of the total defects in FY 2022-23 by designing defect resolutions. Enhanced deployment efficiency by automating 10+ monotonous validation checks using Python.

Launched an invoice management application in Android and a Java backend for a logistics warehouse serving 750 agents. Created React.js UI and hosted the Java Spring Boot APIs on AWS EC2. Integrated the MySQL database on AWS RDS. Reduced the invoice validation time to minutes, achieving 15% more efficient logs. Digital transformation reduced paper invoices by 75%.