Pratham Agrawal — Software Engineer

Software Engineer specializing in building large-scale backend and data-intensive systems in production environments. Currently at Affinsys.ai, I design and develop analytics platforms, distributed backend services, and high-throughput data pipelines used across multiple clients and teams. My work focuses on improving system scalability, reliability, and query performance in real-world workloads. **Core expertise:** • Backend systems using Python and Go • Analytics platforms (NLQ → SQL, dashboards, reporting) • Data pipelines, warehousing, and high-throughput ingestion • PostgreSQL performance tuning, indexing, and materialized views • Distributed systems with Kafka, RabbitMQ, and NATS • Containerized deployments using Docker and Kubernetes **Professional highlights:** • Built an analytics platform supporting 20+ dashboards and 200+ charts, reducing dashboard creation time by 80% • Designed a high-performance event-driven data warehouse ingesting data from 10+ services • Implemented enterprise-grade PostgreSQL high availability with sub-minute failover and zero downtime (Mirror-DB) • Improved query and API performance by up to 50% through schema design and indexing strategies Previously interned at CME Group, where I optimized data processing workflows and improved report generation performance by 30–40%. **Tech Stack:** Python | Go | SQL | PostgreSQL | Kafka | RabbitMQ | Airflow | Docker | Kubernetes | AWS **Location:** Bangalore, India Open to participating in paid expert surveys, market research studies, and consulting engagements related to data infrastructure, PostgreSQL high availability, and distributed systems.

Stackforce AI infers this person is a Backend Engineer specializing in SaaS and Data Engineering.

Location: Bangalore Urban, Karnataka, India

Experience: 2 yrs 11 mos