Experience

Mercari India

• India
• Technology, Information and Internet
• 1 - 100 Employee

• Full Stack Engineer

  • May 2023 - Present



Optum

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Software Engineer

  • Mar 2020 - Jun 2022

  Product: LifeScience Data warehouse (Backend) - provides analysts with insights into payers, providers and patient’s data- Improved data pipeline runtime from 67 hours in Oracle to 50 hours in Amazon Redshift (25% reduction)- Completed a proof-of-concept on the migration of a complex data pipeline from Oracle to AWS Redshift- Migrated 400+ SQL stored procedures to AWS Redshift, in 8 months, as a 4-member team-----------------------------------------------------Product: Crimson Medical Referral (Frontend + Backend) – a medical referral management system to support better care coordination- Moved Database Migration tool from RedGate SQL to DbUp, an open-source tool, to save license costs- Reduced the front-end build artifact size from 67MB to 19MB (71% reduction)- Reduced the overall front-end build and deployment time from 2 hours to 20-25 minutes (79% reduction)- Leveraged Azure Blob Storage and Azure Content Delivery Network to serve front-end as a static website- Migrated the application from .NET Framework to .NET Core 3.1 and redesigned it into microservices for the cloud (Azure)- Introduced Jenkins pipeline to automate builds, tests, SONAR code quality and FORTIFY security scans- Contributed to an open source logging library which we were using to log to Azure Blobs. Show less

• Associate Software Engineer

  • Jul 2018 - Feb 2020

  Product: Optum Performance Analytics (OPA) - an integrated enterprise analytics platform for health plans- Migrated a Microstrategy (Business Intelligence tool) project from Oracle to Amazon Redshift.- Established a generic approach to handle data differences caused due to differences in numeric computations in Amazon Redshift, compared to Oracle.- Coded multiple python scripts to automate client onboarding, which leveraged Microstrategy APIs.- Implemented delta Microstrategy package migration to reduce release deployment time significantly.-----------------------------------------------------Product: Crimson Medical Group Advantage (CMGA) - Platform to provide insights into the medical performance of an Org., through various dashboards.- Built multiple data pipelines on SQL Server Integration Service (SSIS) platform (an ETL tool), to source data from the application database to a common data warehouse for multiple products in the organization.- Added support for 50+ metrics on our Microstrategy instance, a Business Intelligence (BI) tool and SQL server.- Supported the QA team with writing automated TSQLt tests to verify table schemas to avoid ETL failures and follow internal best practices. Show less



Optum

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Software Engineer Intern

  • Jan 2018 - May 2018

  Product: Crimson Medical Group Advantage (CMGA) - Platform to provide insights into the medical performance of an Org., through various dashboards. - Investigated a few data difference issues in the product's business Intelligence platform (Microstrategy instance based on SQL server) and documented the data pipeline flow for the team. - Assisted the QA team in adding automated tests for the web API, using the existing SoapUI tool. - Experimented with D3.js to visualize data better and figure out possible metrics data patterns. Show less



Bayer

• Chemical Manufacturing
• 700 & Above Employee

• Software Engineer Intern

  • Dec 2016 - Dec 2016

  Product Reporting Tool - A tool to help generate custom reports based on the companies plant data - Developed an ASP.NET web application that helps generate a custom report based on the manufacturing plant data (Bayer Vapi plant). - Implemented LDAP authentication, ability to upload plant data using CSV files, and guide step-by-step report generation based on the plant data stored in the SQL server database. Product Reporting Tool - A tool to help generate custom reports based on the companies plant data - Developed an ASP.NET web application that helps generate a custom report based on the manufacturing plant data (Bayer Vapi plant). - Implemented LDAP authentication, ability to upload plant data using CSV files, and guide step-by-step report generation based on the plant data stored in the SQL server database.