Yogesh Kumar Deo

Project - Parcellogix

• Designed and implemented a cloud-native Data Warehouse on GCP for parcel invoice and tracking analytics.
• Integrated APIs and invoice data from FedEx, UPS, USPS for unified analytics.
• Built scalable Python-based data pipelines using GCP Cloud Functions and GCS.
• Developed BigQuery data models with DBT, ensuring optimized performance and scalability.
• Automated workflows with Rundeck and SSIS to streamline data processing.
• Delivered BI reporting using Sigma, enabling logistics cost optimization and tracking insights.
• Led a team of 3-4 in business analysis and application development, delivering secure, scalable solutions.
• Created robust data models for shipment tracking, invoice reconciliation, and carrier performance analysis.

Project - Inveterate

• Built end-to-end Data Warehouse and BI solution, enhancing loyalty and membership analytics.
• Developed ingestion pipelines using Python + GCP Cloud Functions + GCS.
• Designed scalable BigQuery warehouse with DBT transformations.
• Modeled customer lifecycle, loyalty programs, and engagement metrics.
• Developed dashboards using Metabase for business stakeholders.
• Provided insights into customer retention, rewards utilization, and campaign effectiveness through advanced reporting.

Project : RecordX

• Built a Python/FastAPI analytics microservice exposing dashboards, time series, case status/SLA, engagement, and law-firm comparison APIs backed by ClickHouse.
• Implemented NATS JetStream event ingestion for near–real-time metrics and an HTTP metrics API for direct recording.
• Added a dlt pipeline (scheduled sidecar) to extract MongoDB into ClickHouse for historical backfill and completeness alongside streaming data.
• Modeled analytical marts with SQLMesh for pre-computed SLA, lifecycle, transitions, and benchmarks; containerized stack with Docker Compose and pytest coverage.

• Led a team of 8–10 in business analysis and application development, delivering secure, scalable solutions.
• Built complete data warehouse + BI ecosystem using DBT, Postgres, and Sigma.
• Developed 50+ Python (Meltano Approach) connectors for multiple data sources (Shopify, Facebook, etc.).
• Created advanced Sigma dashboards (LTV, marketing, funnel analysis).
• Implemented Looker-based BI platform with LML modeling.
• Designed scalable data pipelines and warehouse models using DBT.
• Built marketing and product analytics dashboards.
• Developed 45+ Tableau dashboards and data sources.
• Delivered insights for B2B/B2C sales analytics.
• Built BI dashboards and forecasting models using R & Tableau.
• Developed QA analytics platform using GCP, DBT, Superset, Power BI.
• Implemented microservices architecture with API integrations.

• Delivered BI solutions for Google Retail (Chromecast, Pixel) using Tableau.
• Built dashboards for sales, compliance, and performance analytics.
• Worked on government project Pradhan Mantri Matru Vandana Yojana (data integration, dashboards, UAT).
• Developed SQL-based reporting systems and analytics frameworks.