Gnyandeep Chiliveru

Data Engineer at Onecent Homes (2026-03 – Present)

Designed and built a PostgreSQL (Supabase) data warehouse schema with optimised table relationships, indexing strategies, and SQL query tuning — supporting real-time CRM reporting and high-frequency application data retrieval with sub-100ms query performance.
Developed Python-based REST API data connectors integrating Meta Ads and WhatsApp Business APIs — handling OAuth authentication, webhook processing, JSON transformation, and automated ingestion into PostgreSQL — giving marketing stakeholders real-time cost-per-lead and channel ROI visibility.
Automated full CRM data pipeline workflows for full CRM data pipeline — including lead deduplication logic, status update triggers, and follow-up scheduling — eliminating manual data entry and making the pipeline fully automated end-to-end.
Architected a JSON-driven property asset ingestion pipeline and CDN-optimised delivery system for a 360° walkthrough platform, reducing new listing onboarding time by 30% and mobile page load time by 35–45%.

Graduate Engineer Trainee at HCLTech (2024-01 – 2026-01)

Client: Transamerica USA (US$100B+ Insurance) L3 Data Engineering & Pipeline Operations Support

Sustained 99%+ SLA compliance across 92+ daily production ETL pipelines — tracked via Control-M monitoring dashboards — by building proactive failure-detection workflows and runbooks that reduced mean time-to-recovery by 30% for financial reporting and compliance teams.
Accelerated SQL query load time by 35% and cut reporting cycle time by 25% — benchmarked against baselines for 500+ users — by restructuring high-volume Oracle query architecture using pre-aggregated tables, indexing strategies, and optimised DML/DDL transformations.
Engineered PySpark deduplication and anomaly-detection workflows across multi-source financial datasets, driving a 20% reduction in data quality incidents — evidenced by weekly compliance logs — and passed SOX KC6B source-to-target integrity audits.
Reduced pipeline MTTR by 30% and improved recurring incident resolution — assessed by support ticket velocity — by authoring 15+ knowledge base articles for an AI-assisted search system and directing a 5-engineer L2 team across US time zone shifts.

About