--- title: "Work and Case Studies | Studio Narrm, Melbourne" description: "Case studies from Studio Narrm founder Pranav Gore: AI agents, n8n data pipelines, analytics dashboards, banking integration and migration, RPA and telecom fulfilment architecture." url: https://studionarrm.com/work/ updated: 2026-10-22 --- Case studies # Work: integration, analytics and automation These case studies come from founder Pranav Gore's work, before and since starting Studio Narrm. Each one describes the type of problem, the approach and the skills involved. Organisations, data and internal details are deliberately left out. ## Recent: AI-assisted automation and analytics ### Operational analytics platform for a regional programme Pranav designed and built a cloud-hosted analytics web application that gives programme teams across a region one place to see how operations are performing. Problem Operational data lived in many forms, apps and spreadsheets, so answering simple questions took manual effort and reports went stale. Approach Consolidated sources into a clean data model, built interactive dashboards with filtering and drill-down, and deployed the app to a managed cloud platform. Skills - Data modelling - Dashboard design - Web app development - Cloud deployment - AI-assisted coding Outcome Leaders moved from waiting on manual reports to self-serve, near real-time insight. ### Production data pipelines and automation in n8n Pranav built and runs a portfolio of more than 50 n8n workflows on self-hosted infrastructure, several of them in production on schedules and webhooks, that sync, migrate and report on an organisation's operational data. Problem Data was spread across a CRM, an ERP, event platforms, forms and spreadsheets, so reporting and day-to-day operations relied on people copying data between tools. Approach Incremental ETL from paginated REST APIs into PostgreSQL using date-windowed delta loads, staging tables, de-duplication and upserts, with batching and rate-limit handling. Bulk migrations routed records by type into the CRM. Reporting pipelines aggregate many endpoints into regional, programme and campaign reports and funnels. Failures alert to Slack, scheduled jobs flag data-quality issues, and every workflow is backed up to Git automatically. Skills - n8n - ETL and ELT - PostgreSQL - REST API integration - Data migration - JavaScript - Docker - Workflow as code Outcome Reporting and record-keeping that used to be manual now run automatically, with monitoring that surfaces problems before users notice them. ### AI agents for outreach and data extraction Pranav builds automations that call large language models (Claude) inside business workflows to research prospects, draft personalised outreach and turn unstructured data into structured records. Problem Finding and contacting the right partners, and making sense of free-text registration data, took hours of manual research and reading. Approach Webhook-triggered agents that research and draft outreach with an LLM, a scheduled email sequence with filtering, throttling and timed follow-ups, and LLM-based structured information extraction and profiling, all with a human-friendly review path. Skills - AI agents - LLM integration - Anthropic Claude API - Prompt design - Information extraction - Email automation Outcome Outreach and data clean-up that scale with a small team, with people reviewing results instead of doing the legwork. ### Low-code operational apps Pranav designed and deployed AppSheet applications to manage participant and volunteer workflows, backed by dashboards in Looker Studio. Skills - Google AppSheet - Looker Studio - Schema design - Rapid prototyping Outcome Working tools in users' hands quickly, with data captured cleanly at the source. ## Enterprise architecture ### Customer master migration after a bank acquisition As lead solution designer, Pranav designed how customer profiles from an acquired financial institution would move into a major bank's ecosystem. Approach Mapped master data across both organisations, designed the migration and streamlined how downstream banking systems consume customer data. Skills - Master data management - Data migration - Solution design - Stakeholder management Outcome A consistent customer view across multiple downstream systems. ### Open Banking and microservices integration Pranav designed integration solutions that let modern services securely reuse mainframe capability for Open Banking. Skills - Spring Boot - Kafka - MQ - Microservices - API design - Security Outcome Legacy capability exposed at scale without rewriting core systems, while the team grew to deliver several initiatives in parallel. ### Taking over a large enterprise automation estate Pranav led the transition of development and operations for a fleet of enterprise automation robots from a long-standing incumbent vendor to an in-house team. Skills - Robotic process automation - Vendor transition - Knowledge transfer - Solution architecture Outcome No service disruption during handover, and new robots delivered within budget with no production defects. ### Telecom order management and fulfilment Pranav designed and delivered order management and fulfilment architectures for telecom carriers on Oracle OSM, UIM and AIA. Skills - Oracle OSM - Oracle UIM - webMethods - Process optimisation Outcome Automated reconciliation and outage mitigation significantly reduced support effort and operating cost, recovered lost revenue and lifted customer satisfaction.