Proof of work
Real artefacts from
real production work
Not slides about work — the actual flows, dashboards, queries, reports, and prompts I shipped in production.
Bug Reminder Automation — Microsoft Power Automate
Production flow routing bug acknowledgement reminders across 9 product teams via MS Teams. Fetches live Jira data, branches by module, @mentions the responsible PM, and posts an adaptive card — fully automated, zero manual steps.
Recurrence trigger → HTTP call to Jira API → Parse JSON → Conditional branch → For Each unacknowledged bug → Switch by product module (9 cases) → Get @mention token → Increment variable → Append to string → Compose adaptive card → Post to MS Teams channel
Product Analytics Dashboard — Power BI
Stakeholder dashboard tracking platform KPIs — accounts, users, calls, MAUs, and usage trends — built and maintained as the single source of truth for product decisions
Platform Uptime & MTTR — Performance Report
Monthly uptime and mean time to recovery tracking across the platform. Authored the analysis, trend commentary, and executive outlook for stakeholders.
SQL Queries Repository — Production Analytics
Centralized query library authored for user activity analytics, client accounts, billing, CRM mapping, and DID management across multiple databases
-- Tracks unique product engagement per day
SELECT DATE(created_at) AS activity_date,
COUNT(DISTINCT user_id) AS daily_active_user
FROM access_log
WHERE created_at BETWEEN '2025-03-01' AND '2025-04-01'
GROUP BY DATE(created_at) ORDER BY activity_date;
-- Full account: agents, channels, pilot number
SELECT u.client_id, u.extensions AS allowed_agents,
COUNT(ps.id) AS agent_count,
billing.channels, sb.defaultuser AS pilot_number
FROM users AS u
LEFT JOIN ps_endpoint_agents AS ps ON u.id = ps.added_by
GROUP BY u.id;
Platform Bug Report — Module-wise Analysis
Cross-platform bug tracking with TAT breach analysis, module-wise qualification rates, and monthly trend commentary authored for engineering and leadership
UIX / APPs
28
Reporting & Analytics
22
API
17
Dialer
17
Campaigns & Contacts
9
Voice / Integrations
8
Reported: 118
Acknowledged: 98
Qualified: 52 (44.1%)
Critical: 0 ✓
Platform Incident Report — SRE Operations
Monthly incident report across 6 platforms. Authored MTTR tracking, platform-wise breakdown, severity analysis, and executive outlook for leadership review.
20
Total Incidents
99.92%
Platform Uptime
74 min
Avg MTTR
0
Critical
4
Major
15
Minor
AI Voice Bot — Bilingual SDR Lead Qualification
Production-grade LLM + TTS prompt engineering for a bilingual (EN/HI) voice SDR with 12+ edge case handlers, barge-in detection, CRM auto-logging, and lead scoring
Lead Data Collected Automatically
Product TypePurchase IntentFull Name + AgeCity & StateInsurance PurposeKey PrioritiesExisting InsuranceBudget EstimateContact PreferenceCallback Time
Bot Capabilities Engineered
Seamless EN → HI switchBarge-in stop + listenWrong number handlingHuman escalationElderly assistance modeInstant quote flowWhatsApp/Email fallbackCRM auto-logging
CRM Lead Status Output
🔥 Hot
🌡️ Warm
❄️ Cold
✗ Not Interested
⊘ Invalid
Live Conversation Sample
Bot
"Hello! I'm reaching out regarding your recent inquiry about one of our insurance plans. Is now a good time to talk?"
Customer
"Haan baat karo." [switches to Hindi]
Bot — auto-switches to Hindi instantly
"बिल्कुल! आप किस प्रकार का बीमा लेना चाहते हैं — स्वास्थ्य, जीवन, मोटर, या यात्रा?"
Customer
"Health insurance for family."
"समझ गया! क्या आप जल्द खरीदना चाहते हैं या अभी options explore कर रहे हैं?"
→ CRM logs: Product=Health, Purpose=Family, Language=HI, Status=Warm