CMDB and Cloud-Cost Analytics Platform

Summary

A production platform consolidating configuration and cost data from an ITSM system and two public clouds into a searchable analytics store, replacing manual reporting across the support organization. Data flows in through resilient Python clients for the ServiceNow Table API and the Azure and AWS cost APIs, and Elasticsearch index mappings with lifecycle management make the combined ITSM, cloud-cost and time-card data searchable.

Highlights

• Built resilient Python clients for third-party APIs: a paginated ServiceNow Table API client, an Azure cost API client with exponential backoff, and an AWS cost-and-usage pipeline with retries and input validation.
• Designed Elasticsearch index mappings and lifecycle management across ITSM, cloud-cost and time-card indices.
• Built caching modules for contacts, time cards and activity snapshots.

Technologies

• Python
• Elasticsearch
• ServiceNow API
• Azure Cost Management API
• AWS (Boto3)
• Redis