Business Systems Analyst · Requirements & UAT · SQL · AI & Automation

Sanjay Prakash Ravi

"I don't just analyze businesses — I've built them."

MSc Business Analytics (2026) · 3+ years across business analysis, operations & product roles · Dublin · Available immediately

Requirements & User Stories UAT & Defect Triage Process Mapping SQL Python Power BI Tableau Excel Jira · Confluence AI / ML n8n · Power Automate
€7,095 annual benefit in my retail business case, under 1-month payback
5×+ monthly profit growth across a 1 + 7 franchise network
Minutes not hours: handwritten exam scripts to translated text
2× featured in national newspapers
Stamp 1G · Full right to work in Ireland · No sponsorship required · Available immediately

Core capabilities

Data & Technical

SQL (joins, CTEs, window functions) Python (Pandas, FastAPI, PyTorch, scikit-learn) Power BI (DAX, dashboards) Tableau Excel (Power Query, pivot tables, XLOOKUP, VBA) REST APIs Data Pipelines AI / ML

Business Systems Analysis

Requirements Gathering Functional Specifications BRD User Stories & Acceptance Criteria As-Is / To-Be Process Mapping UAT Coordination Defect Triage Root-Cause Analysis Agile / Scrum Backlog Management SDLC Stakeholder Management

Commercial & Revenue

Pricing Purchase Orders Inventory & Stock Control P&L Accountability Gross Margin & OpEx Demand & Cash Flow Forecasting Supplier Negotiation KPI Reporting Business Cases Market Research (TAM/SAM) Competitor Analysis

AI, Automation & Tools

n8n Power Automate LLM Integration Handwriting Recognition (CRNN, ONNX) Jira Confluence Miro Lucidchart · Draw.io Figma POS & Inventory Systems Git / GitHub

About

I'm a business systems analyst with 3+ years translating business needs into system capabilities across government technology, retail, e-commerce and edtech. I gather requirements, write functional specifications, user stories and acceptance criteria, and coordinate UAT and defect triage — with hands-on SQL, Python and Power BI behind it.

Right now I'm the BA and ML developer on a deployed, air-gapped AI platform for a state-government exam publisher, and I own pricing, purchase orders and inventory for a 5-outlet Dublin retail and e-commerce business. Before that I co-founded Happy Dips, held full P&L accountability, and grew it to 1 owned branch + 7 franchises.

Most analysts study case studies. I've been the case study — built the business, ran the P&L, and designed the systems that kept the numbers honest. I hold an MSc in Business Analytics (Dublin Business School, 2.1) and have Stamp 1G with full right to work in Ireland.

Case Studies

02

Offline AI Platform for Handwritten Exam Scripts — AP Publisher (Tamil Nadu Government Exam Papers)

Business Analyst & ML Developer (Contract) · Nexus InfoTech · Remote · Feb 2026 – Present

BA for AP Publisher, which produces Tamil Nadu government exam papers. I partnered with client stakeholders and developers to translate business needs into system capabilities, leading requirements gathering for a platform bound by strict government security and compliance rules: air-gapped, with zero external data transmission. I analysed the manual as-is process and wrote functional specifications, user stories and acceptance criteria for the to-be workflow.

On the build side, I trained CRNN handwriting models (PyTorch, ONNX) to ~80% accuracy on real handwritten Hindi and integrated IndicTrans2 for on-device translation. I worked with developers on a FastAPI + React architecture, Python data pipelines for PDF/DOCX extraction and validation, and a Redis job queue, then coordinated UAT, triaged defects in Jira and validated fixes before production deployment, running Agile/Scrum sprints across the SDLC.

Requirements Gathering Functional Specifications User Stories & Acceptance Criteria Security & Compliance UAT & Defect Triage (Jira) PyTorch · ONNX · IndicTrans2 FastAPI · React · Redis

Result: A deployed offline AI platform that turns handwritten exam scripts into translated text in minutes, not hours.

03

Happy Dips — From Concept to 1 Branch + 7 Franchises

Co-Founder, Operations & Technology Lead · Chennai · Dec 2023 – Nov 2025

Held full P&L accountability for Chennai's first chocolate strawberry brand. I managed pricing, supplier negotiations, demand and cash flow forecasting, operating expenses and gross margin, tracking daily return on investment per store.

I designed and led the build of a Python web/mobile ERP-style app on SQLite linking production, inventory, purchases and sales for 25+ daily users across 8 locations. I automated end-of-day reconciliation with SQL against card-terminal, stock and cash totals, cutting daily closing from hours to a single cash count, and built Power BI dashboards for P&L, cash flow, taxes and per-outlet franchise scorecards. I also wrote the SOPs and training materials and led change management to drive adoption at every location.

P&L Accountability Pricing & Supplier Negotiation Forecasting ERP-style App (Python, SQLite) SQL Reconciliation Power BI Dashboards SOPs & Change Management

Result: Recovered the start-up investment in the first month and grew network monthly profit 5x+ in under 2 years, scaling to 1 owned branch + 7 franchises. Featured in The New Indian Express & DT Next.

04

Infinite Engineers — New Product Concepts & a US Teletherapy Business Case

Business Analyst Intern · Chennai · Jun 2023 – Feb 2024

At a STEM edtech company supporting 800+ schools, I analysed 3 new B2C concepts, 2 of which moved forward. I led market and user research and wrote the MVP specification and user journeys for a STEM kits-and-courses product, which was piloted directly with clients.

I also built a business case for a US mental-health teletherapy platform: TAM/SAM sizing in SQL and Excel, a competitive landscape of 10+ competitors, and HIPAA regulatory requirements.

Market & User Research MVP Specification User Journeys TAM/SAM Sizing (SQL, Excel) Competitor Analysis Regulatory Requirements (HIPAA)

Result: 2 of 3 concepts moved forward; the teletherapy business case was approved for launch planning.

Detailed walkthrough available on request.

05

Webizo Digital Agency

Founder, Requirements & Delivery · Chennai · Mar 2023 – Feb 2024

Won and delivered work for 10+ clients in year one, including AMR Football Club, CappricioSec University and Truly Yours skincare. I gathered requirements, mapped client processes and delivered websites with SQL databases, then managed UAT and client sign-off.

Requirements Gathering Process Mapping Websites with SQL Databases UAT & Client Sign-off
06

ESG & Financial Performance — ML Research on S&P 500

MSc Dissertation · Dublin Business School · 2026

Built a machine learning (XGBoost) model predicting return on assets (ROA) for 50 S&P 500 companies, then used SHAP to measure how much ESG (Environmental, Social, Governance) scores add on top of financial fundamentals.

XGBoost SHAP Interpretability Cross-validation Feature Engineering Python · Pandas · scikit-learn

Key Finding: The model predicts ROA at R² 0.81 (cross-validated 0.84). SHAP showed ESG adds 3–5% explanatory power over financial fundamentals.

Full project: github.com/sanjayprakash-git/esg-financial-performance-ml →

07

BA Analysis Toolkit — AI-Powered Strategic Analysis Platform

Solo Developer · Design, Build & Deploy · 2026

A live AI app that generates structured business analysis (requirements, stakeholder, competitor, SWOT and more) with an AI-generated executive summary. Built on Vercel serverless functions, the Groq LLM API and Tavily web search for cited outputs.

Product Design LLM Integration (Groq) Web Research (Tavily) Vercel Serverless

Features: Side-by-side comparison mode, PDF export with branding, custom framework input, session history — zero signup required.

→ Try the live tool

Media & Recognition

📰

The New Indian Express

"Dreams and Education: Students who moonlight as entrepreneurs" — April 2024

📰

DT Next

"Pushing Doors of Anna Nagar's Culinary World Using Carts" — June 2024

🥉

1st Asia Open Karate Championship

Bronze Medal — Kuala Lumpur, Malaysia. 10+ years of competitive karate.

Education & Certifications

MSc Business Analytics (QQI Level 9)

Dublin Business School — 2025–2026 · Second Class Honours, Grade 1 (2.1)

Modules: Programming for Analytics, Applied Statistics & Machine Learning, Business Intelligence & Visualisation, Financial & Business Analytics, Database Management, Requirements Analysis, Project Management, Business Strategy

Dissertation: ESG & Financial Performance — XGBoost model predicting ROA (R² 0.81) on 50 S&P 500 companies, with SHAP · View on GitHub →

B.Tech Computer Science and Business Systems (CSBS)

Anna University, Chennai — 2020–2024

Microsoft PL-300: Power BI Data Analyst

In progress — expected Nov 2026

Oracle Cloud Infrastructure Foundations

Oracle Certified — 2024

Let's Connect

Open to Business Analyst, Data Analyst, Product Analyst, Reporting Analyst, and AI/Data BA roles — full-time, contract, or graduate positions in Dublin, Ireland, or remote EU.

📞 +353 89 951 0121  |  ✉️ prakesh3851@gmail.com

💬
Ask about Sanjay
Hey there! 👋 I'm Sanjay's AI assistant. How can I help you today?
Ask me about his experience, skills, or projects — or talk directly to Sanjay on WhatsApp →