Achal Mahale

Data Engineer with 3+ years of experience designing scalable ETL/ELT pipelines, optimizing SQL and NoSQL data models, and delivering high-performance REST APIs using Python and FastAPI. Proven expertise in cloud-native infrastructure on GCP with Kubernetes, Docker, and Terraform, CI/CD automation via Azure DevOps, and enterprise BI reporting using Power BI (DAX, RLS, Incremental Refresh). Independently engineered a Parquet-based caching architecture reducing API response times by 99%.

Delivered end-to-end data engineering solutions for large-scale fleet management systems supporting 700+ assets and 20+ enterprise clients.

Data Engineer / Data Analyst at KIBBCOM Pvt. Ltd. (2023-05 – Present)

• Reduced Annual Report API from 2 min → 10 sec and Eco-Drive Events API from 30 min → 1 min by independently designing a Parquet-based caching layer on GCP, eliminating redundant MongoDB queries for static historical telemetry data.
• Built REST API-based ETL ingestion pipelines processing real-time vehicle telemetry from 700+ IoT fleet assets into MongoDB at 15K–25K events/min reliably across distributed systems.
• Developed Python ELT transformation workflows aggregating raw trip-level telemetry into per-day, per-vehicle analytical summaries, enabling fast BI querying without runtime database computation.
• Designed and optimized MongoDB aggregation pipelines for complex nested telemetry datasets — incorporating indexing strategies to reduce query latency for trip events, vehicle models, and eco-driving metrics.
• Applied PostgreSQL optimization techniques — indexing, query tuning, execution plan analysis — significantly reducing analytical workload latency at scale.
• Designed PostgreSQL schema (~10 tables) for an internal time-management system covering employee records, leave policies, and check-in/check-out workflows.
• Deployed Docker-containerised microservices on GCP Kubernetes Engine — configuring deployment YAMLs, resource limits, health probes, and Kubernetes Secrets for secure credential management.
• Built and maintained CI/CD pipelines via Azure DevOps enabling fully automated, zero-downtime deployments using rolling update strategies across all production microservices.
• Managed cloud infrastructure provisioning using Terraform — defining reusable IaC modules for GCP compute, storage, and Kubernetes cluster configurations.
• Built Power BI dashboards for 700+ vehicles across 20+ enterprise clients; implemented Row-Level Security (RLS) using CompanyID for secure multi-tenant data isolation within a single dataset.
• Developed ~30 FastAPI REST endpoints for an internal product — full CRUD for leave policies, employee records, and attendance — serving as the complete backend API layer.
• Automated delivery of ~50 client reports/month via Python Cron Jobs and SendGrid, eliminating all manual report generation.
• Built a GDPR-compliant Python Trip Simulator generating synthetic fleet telemetry (mirroring production schema) for safe staging and QA without access to real production data.
• Built a full ReactJS fleet dashboard replicating Power BI reports for the web application, including frontend components, FastAPI integration, and UI scoped to rolling 30-day fleet data.

Freelance Data Analyst at Self-Employed (2021-01 – 2023-04)

• Delivered Tableau dashboards for e-commerce and operations clients tracking KPIs including bug counts, feature requests, and usage anomalies — enabling data-driven product prioritisation.
• Built end-to-end data analysis workflows covering ingestion, transformation, statistical analysis, and stakeholder reporting across multiple client engagements.
• Structured and categorised datasets to support data-driven decision-making across product and operations teams.

Bachelor of Commerce in BCom – RNS First Grade College, Bangalore University (2018 – 2021)