Senior Software Engineer
Current•Led development of Next Day Rate workflow in Product Automation Tool (PAT), decreasing delivery time of new insurance rates from 30 days to 1, by automating communication with internal services and implementing role-based permissions •Designed and implemented cloud service to activate customer discounts based on smart home device telemetry, and updated Java/Spring Boot data broker between AWS and on-prem SQL database•Consolidated multiple internal business functions into PAT, allowing users to upload Excel files, generate SQL from Excel files, and notify stakeholders of changes via email and Confluence updates•Reduced development effort to validate insurance premiums by moving from SAS/SQL-based calculation system to cloud-based application using Python, Fargate, Lambda, S3, Postgres, Docker, Flask, Pandas, and Datadog for monitoring. Parsed Excel files containing instructions for calculating rates, stored values in Postgres, and determined calculation logic at runtime •Increased business adoption of PAT by listening to users’ feedback and implementing new features and bug fixes using Python, Flask, React, Redux, Celery, Docker, Postgres, and AWS.•Sped up average time for file upload workflow in PAT by refactoring front-end and API code to avoid sending and manipulating files twice in case user navigated backwards in UI