Aniket Annam

System Architecture & Product Development • Query Builder Tool: Created a configuration-based application that generates SQL queries with dynamic selectors and aggregators, serving as the primary data-fetch layer for the internal UI and reporting systems. • Bulk Action Framework: Designed a distributed system consisting of a Python FastAPI service (bulkActionSvc) and a Python script engine (bulkActionScripts) to process 10,000 to 20,000 simultaneous campaign and ad operations. • Lead Management System: Re-developed the lead processing flow—incorporating Lead Attribution (UTM/ Pixel tracking) and Lead Priority ranking—to deliver real-time data to clients with a complete business use cases. • CRM Integration Product: Developed the leadCrmSyncApp, an offline application using python that synchronizes internal lead data with external client CRMs like Salesforce via scheduled batch processing. • Google Cloud Platform: Built ArgoCD pipeline for Migrating all of the services (python, node and java) which were deployed on our hetzner cloud provider virtual machines to kubernetes. Microservices & API Development • Query Builder: Built a centralized Python FastAPI service to consolidate scattered data-fetch endpoints, resulting in a 40% increase in request throughput. which helped developers to not alter any internal system for any data business or client's new requirement addition to fetch from database. • Ad Creative Services: Developed adcreativeSvc (MongoDB) for dynamic template mapping and craftSvc for transforming advertiser inputs into platform-specific ad SKUs for Google and Facebook. • Auth & Permissions: Part of building user permission and authentication process pipeline so that data will be visible to the user who had permissions in our internal infra application hadesSvc, an internal IAM system for managing user permissions, grant details, and advertiser onboarding/ deboarding workflows. • Campaign Management: Developed a MySQL-backed marketing service allowing users to structure, store, and reuse campaign templates across multiple seasonal occasions. Data Engineering • Redshift to BigQuery Migration: Executed the complete migration of the data warehouse, including the redesign of ETL pipelines to optimize for BigQuery’s storage-free/ query-cost model, reducing overall warehousing expenses by 22%. • CDC Pipeline Development: Built a real-time MongoDB-to-MySQL replicator using Debezium to transform unstructured template and ad data into a structured relational format, supporting 1-to-many mappings for campaign analytics. • Multi-Source Data Ingestion: Engineered daily sync pipelines using Google Ads and Facebook Graph APIs to ingest performance data into Redshift and BigQuery. • Automated Cloud Backups: Developed Python and Bash scripts to automate backup processes for cloud databases, ensuring zero data loss during maintenance cycles.