Data Engineer Intern - Bloom Insurance Agency

Bloomington, Indiana

Bitbucket, NLP, Power BI, Python, SQL, SSIS, SSMS

• 🚀 Implemented ETL pipeline to process over ~500 GB data to extract insights on insurance policies using Python and SSIS.
• 🔍 Integrated SSMS, and NLP Techniques for developing data applications to enhance policy analysis capability by ~10%.
• 📊 Conducted over 25 analyses, and designed 10+ interactive dashboards using Power BI dashboards to provide visualization on AQE reports using DAX to drive revenue growth by 20 percent.
• 🐞 Debugged code for Broker product implementing unit and integration test automation to enhance operational resilience.

Software Data Engineer - Part time

Indiana University Bloomington - Bloomington, Indiana

Jetstream, Pyspark, React, JavaScript, Java, Spring Boot, ETL

• 🚀 Enhanced campus-wide operational efficiency by designing microservices and implementing automated scripts, utilizing ServiceNow to resolve technical challenges, which resulted in a 40% reduction in response times.
• 💻 Developed scalable system APIs for Student Technology Centers, resulting in a 40% increase in multi-tier web application uptime and seamless functionality for over 45,000 users monthly using Java and Spring Boot.
• ⚡ Developed and optimized ELT pipelines using Apache Spark consolidating data and enhancing scalability for Technology Centers ingesting Jetstream2 improving data analysis performance and uptime for over 60,000 users daily.

Software Developer - Data Team

Mahindra & Mahindra Financial Services - Pune, India

• 📊 Programmed a customer risk assessment scorecard model to help credit underwriters for loan products, reducing approval delay time by ~65%, and ensuring data privacy and compliance with RBI and ISO/IEC 27001.
• 🤖 Scripted chatbot integrating LLMs using GPT-3.5-turbo APIs to provide answers about company policies, deployed the solution using Lambda and Snowflake for data management, and API Gateway for managing low-latency API requests.
• 🔄 Collaborated with stakeholders to develop ETL pipelines from Salesforce, S3, and APIs to Snowflake for customer leads management dashboard used by 5000+ executives using Python, and AWS Glue.
• 💼 Developed finance data mart integrating LMS and LOS with 150 features on Snowflake, improving regulatory reporting efficiency by 90% and lowering operational costs via Lambda and S3 automation.
• ⚙️ Engineered PySpark ETL pipeline leveraging Debezium and AWS to process 2 million records for Change Data Capture (CDC), reducing processing time by 15% and improving reliability.
• 🐳 Containerized applications using Docker and automated deployments with Jenkins (CI/CD), reducing downtime by 30-35%.

Software Developer / Data Engineer

Piramal Capital & Housing Finance - Mumbai, India

• 🛠️ Designed an automated system using Python and macros in Excel for monthly masking information of 45,000+ customers.
• 🔍 Constructed an anomaly detection workflow with Elasticsearch and Kafka to monitor API performance and generate real-time alerts for faulty APIs with an accuracy of ~80%.
• 📧 Constructed anomaly detection system which calculates error thresholds in the APIs and generates email notifications to alert about the faulty API in real-time with an accuracy of ~80%.
• 📉 Streamlined API management and monitoring by leveraging Elasticsearch and Logstash reducing API downtime to ~10 minutes and improving overall system reliability.
• 👥 Led a team of 4 interns, delivering key milestones on time by managing tasks using JIRA, following Agile framework to demonstrate leadership skills.
• 🔍 Reviewed code processes, utilizing SonarQube to rectify code smells, and vulnerabilities integrating with Jenkins for automated deployment reducing post-release defects by 20% writing unit and integration tests.

Software (Python) Developer

Cogno AI, Mumbai, India

Mumbai, India

• 🤖 Enhanced customer engagement by 20% with 10+ chatbots for the clients, using the Rasa framework with natural language processing (NLP) and dialogue management in the Agile setting.
• 🔄 Remodeled systems for clients using JavaScript and Postman implementing agile methodology.
• 📋 Administered clients’ requirements to prepare flows and technical documentation using Agile for application developments.