Back to selected work

IT operations · Process automation · Python · SQL

Laptop Warranty Management Automation

A Python and SQL workflow developed to support laptop warranty tracking and generate email notifications.

Delivery status
Deployed to production
My role
Automation development

Context

The problem to address

The initiative aimed to improve laptop warranty information tracking and notification handling in the service desk workflow.

Contribution

My responsibilities

  • Developed a Python and SQL automation solution for laptop warranty tracking.
  • Implemented automated email notifications as part of the warranty workflow.

Implementation

Decisions and methods

  • Combined warranty information handling and email notification generation to support consistent service desk administration.

Outcome

Delivery and outcomes

  • Deployed to production for use by IT Service Desk staff.
  • Designed to streamline repetitive administration and support more consistent warranty information.

Supporting detail

Workflow overview

Warranty logging workflow
  1. Device and warranty informationInformation used in the workflow
  2. Python and SQL processingWarranty tracking
  3. Email notificationsNotification generation

Conceptual overview of warranty tracking and notification generation.