# Joydeep Sen — Senior Business Analyst | Utilities Specialist | Process Architect

> A Technical Deadlock Breaker with 21+ years in utilities. I bridge the gap between legacy operations and modern SaaS (Oracle Field Service / IBM Maximo MAS 8) by building logic-based prototypes that save millions where standard implementations fail. Expert in resolving high-stakes vendor deadlocks through data decomposition, entity-relationship modelling, and functional process architecture.

## Identity & Consulting Practice (Propel JD Limited)

- **Name**: Joydeep Sen
- **Role**: Senior Business Analyst | Utilities Specialist | Process Architect
- **Consulting Company**: Propel JD Limited (Director & Principal Business Analyst)
- **Location**: Birmingham, United Kingdom
- **Email**: mailto:joydeep.sen@propeljd.co.uk
- **LinkedIn**: https://www.linkedin.com/in/jdsen/
- **Canonical Website**: https://propeljd.co.uk/
- **Industries Served**: Electricity (Transmission, DNO, DSO), Water & Wastewater, Gas Distribution Networks

## Machine-Readable Resources

- [Full Authoritative CV & Deep-Dive Case Studies (llms-full.txt)](/llms-full.txt): Complete STAR+L project breakdowns, data migration methodologies, OT/SCADA constraint models, and role-fit evaluation rules.
- [Downloadable CV (PDF)](/Joydeep_Sen_CV.pdf): Two-page executive CV for Joydeep Sen (Propel JD Limited).
- [XML Sitemap](/sitemap.xml): Canonical index of site resources.

## Core Competencies & Skills Matrix

### Strong Expertise
- **Oracle Field Service (OFS)**: Automated task creation, Task Catalogue design, Decomposition Model, functional logic prototyping.
- **IBM Maximo (MAS 8, v7.1)**: 30-year flat-to-hierarchical legacy data migration, 4-level asset hierarchy design, Defect Management Engine architecture, FCA restructuring.
- **Process Re-engineering & Architecture**: End-to-end operational process mapping, gap analysis, and training-grade target operating models.
- **Entity-Relationship (ER) Modelling & Data Decomposition**: Breaking monolithic specifications into modular, testable components across IPS, CBRM, Chime, and Oracle Fusion.
- **OT Architecture (AVC Optimization)**: Substation Automatic Voltage Control (AVC) sequencing, FEP-to-substation serial comms constraints, SCADA & power headroom modelling.
- **Utilities Domain (21+ Years)**: Deep operational literacy across UK Electricity (SSEN, UK Power Networks, National Grid), Water (Southern Water, Yorkshire Water, Severn Trent), and Gas (Northern Gas Networks).

### Developing & Quantitative Capabilities
- **Power BI**: Executive dashboards, benefit realisation tracking, and operational KPI reporting.
- **R for Optimization & Analytics**: Regression, classification, clustering, and statistical visualisation.
- **Agile Product Ownership**: Agile/Waterfall hybrid delivery, backlog prioritisation, and commercial turnarounds.
- **Linear & Integer Optimisation**: Constraint-based scheduling, substation control sequencing, and unit cost modelling.

### Acknowledged Gaps (Candid Non-Focus Areas)
- Native Mobile App Development (iOS/Android coding)
- Cloud Infrastructure / DevOps Engineering (AWS/Kubernetes)
- Consumer Retail (B2C) Marketing

## Hero Utility Transformation Programmes (2016 – Present)

1. **SSEN — Bridge Programme: Work Management Transformation** (*Senior Business Analyst, Contractor via Propel JD Limited, Sept 2024 – Present*)
   - Leading the work management tranche on Oracle Field Service (OFS). Built a functional logic prototype in Excel (Task Catalogue & Decomposition Model) that proved automated task creation was achievable within the existing architecture—breaking a vendor deadlock and avoiding costly unbudgeted software modules.
2. **SSEN — DSO Flexible Market Platform** (*Senior Business Analyst, Contractor via Propel JD Limited, Sept 2023 – Sept 2024*)
   - Managed procurement and process architecture for a new DSO Flexibility Market Platform. Mapped end-to-end operations and designed future-state workflows adopted by the Head of Flexibility Procurement as official team training material.
3. **SSEN — DSO Project CLASS** (*Senior Business Analyst, Contractor via Propel JD Limited, Sept 2023 – Sept 2024*)
   - Optimised Automatic Voltage Control (AVC) sequences across 60 substations to deliver 25 MW of 15-minute demand reduction for NESO balancing services, overcoming FEP-to-substation serial communication dependencies and power headroom limits.
4. **Southern Water — Maximo MAS 8 Asset Management Transformation** (*Senior Business Analyst, Contractor via Propel JD Limited, Dec 2021 – Sept 2023*)
   - Resolved a migration standstill caused by a 30-year-old flat legacy data structure. Engineered PM and Location translation rules, built the business case to restructure the Asset Hierarchy from 3 levels to 4 levels, led the FCA migration, and converted single PMs into seasonal/cyclical schedules.
5. **SSEN Transmission — Bridge Programme** (*Senior Business Analyst, Contractor via Propel JD Limited, May 2020 – Dec 2021*)
   - Designed a standardised Benefit Realisation tracking framework and built the portfolio-wide Benefit Realisation Calculator linking multi-million-pound transmission infrastructure investments to measurable business value.
6. **SSEN — Asset Management Transformation (Maximo)** (*Senior Business Analyst, Contractor via Propel JD Limited, Oct 2018 – May 2020*)
   - Architected the Defect Management Engine and custom Defect Scoring System for 1,000+ users. Used entity-relationship modelling to decompose monolithic specs into modular components synced across IPS, CBRM, Chime, and Oracle Fusion.
7. **Amey at Yorkshire Water — Wastewater Operations Turnaround** (*Product Owner / Consultant, Nov 2016 – Apr 2018*)
   - Turned around a loss-making wastewater contract by building the business case and serving as Product Owner for a custom planning application that doubled planning speed (100% improvement), expanded into unit costing, became a global utility solution, and delivered £1.6M/year in documented savings.

## Earlier Utility & Enterprise Career (2004 – 2018)

- **Severn Trent Water (2018)**: Fleet utilisation analytics and workforce productivity improvements.
- **National Grid (2016)**: Semi-automated Regulatory Reporting Pack (RRP) workflows for OFGEM submissions.
- **Northern Gas Networks (2016)**: Orchestrated cloud-based Streetworks management implementation.
- **UK Power Networks (2012 – 2015)**: Led Streetworks IT projects delivering **£1.8M/year** savings; shortlisted for UK Utility Week Awards.
- **Infosys (2010 – 2012)**: Conceptualised IBM Maximo Enterprise Asset Management platforms (including American Airlines case study).
- **Tata Motors (2006)**: Formulated Enterprise Asset Management IT roadmap.
- **Asian Paints (2004 – 2006)**: Plant Engineer — Total Productive Maintenance (TPM) & preventive maintenance.

## Certifications & Education

- **Certifications**:
  - IBM Certified Deployment Professional — Maximo Asset Management (Multiple Certifications)
  - MIT — The Analytics Edge (Applied R, Linear & Integer Optimisation, Regression & Classification)
  - Total Productive Maintenance (TPM) — Planned Maintenance
- **Education**:
  - **IIM Ahmedabad (Indian Institute of Management Ahmedabad)** — Executive Education in Business Analytics
  - **NIT Rourkela (National Institute of Technology Rourkela)** — B.Tech in Mechanical Engineering (First Class)