🐍 it_asset_automation.py ×
📦 projects.json
📓 home-software-developer.ipynb
srcscriptsit_asset_automation.py
💡

Architecture Preview Mode FinOps Active

To maintain a sustainable and cost-efficient cloud infrastructure, the backend services for this project are currently in "On-Demand" mode. While the frontend and system architecture are fully available for review, a complete end-to-end live demonstration can be requested or conducted during a technical interview.

Frontend: Active
Backend: On-Demand (FinOps Optimized)
Request Live Demo
In [1]:
# Data Transformation Pipeline
# Handling 200+ employee records across multiple portals

import pandas as pd

def process_inventory(file_path):
    df = pd.read_excel(file_path)
    # Logic to clean and normalize hardware IDs
    df_clean = df.drop_duplicates(subset=['hardware_id']).fillna('N/A')
    return df_clean
Out [1]:
Data Operations

Enterprise IT Asset Automation

Engineered a robust enterprise automation suite using Python and Pandas that eliminated 90% of manual hardware tracking toil for 200+ employees.

Python 3.12 Pandas OpenPyXL Win32Com
In [2]:
# Automating Multi-Channel Dispatch
# Implementing Rate Limiting to bypass SMTP bottlenecks

import time

def dispatch_alerts(targets):
    for batch in chunk(targets, 10):
        send_batch(batch)
        time.sleep(5)  # Throttle to avoid throttling
Out [2]:

Logic Optimization

Refactored original loops into asynchronous batch processors, achieving a baseline stability for large scale notification dispatch without triggering enterprise WAF filters.

Data Resilience

Integrated automatic CSV state saving. The system tracks its own progress, allowing for zero-duplicate reruns even in case of connection failure.