PR
Open to new opportunities

Ponraj
Kumar R

Business Analyst  ·  3 Years Experience  ·  Tech Mahindra

Ponraj Kumar R
Ponraj Kumar R
Business Analyst
3
Yrs Exp
10+
BA Skills
UK
Project
Tech Mahindra
Openreach UK Fibre
Business Analysis
Power BI
Agile / Scrum
SQL & Python
Stakeholder Management
JIRA & Confluence
UAT & BRD/FRD
AI-Enabled Workflows
Tech Mahindra
Openreach UK Fibre
Business Analysis
Power BI
Agile / Scrum
SQL & Python
Stakeholder Management
JIRA & Confluence
UAT & BRD/FRD
AI-Enabled Workflows

Skills & Expertise

Requirements Elicitation (BRD/FRD/SRS)90%
Power BI (DAX, Dashboards)85%
Stakeholder Management92%
SQL (MySQL)80%
Process Mapping & Gap Analysis88%
Agile / Scrum & SDLC85%
Excel (Pivot Tables, Dashboards)90%
Python (Pandas, NumPy)70%
User Stories & Wireframing85%
Data Analysis & EDA82%
Technologies & Tools
Power BI Tableau Excel Advanced SQL / MySQL Python Pandas NumPy Matplotlib JIRA Confluence MS Visio DAX Power Query Star Schema ETL ChatGPT Claude AI MS Copilot BRD / FRD User Stories UAT As-Is / To-Be Agile / Scrum EDA PowerPoint

Work Experience

Business Analyst
Sep 2021 – Jun 2024
Tech Mahindra Ltd
📍 Chennai, India  ·  Openreach UK Fibre Programme

Led requirements elicitation workshops with 10+ stakeholders across planning, field survey, and delivery teams - documented functional and non-functional requirements into structured BRD-equivalent artefacts, reducing requirement ambiguity and accelerating sign-off cycles. Validated and governed data quality across 300+ network planning sites - identified naming convention violations, ON number mismatches, and FNC-cable misalignments; reduced post-survey rework by flagging errors at source before field deployment. Mapped 8+ end-to-end network planning workflows (As-Is to To-Be) - identified process gaps and proposed changes that eliminated a recurring category of planning errors across site releases. Authored User Story-equivalent task definitions and acceptance criteria for WFMT/LLUMS commissioning workflows - contributed to on-time, zero-defect delivery across concurrent site releases by ensuring clear, traceable acceptance conditions. Produced weekly planning performance reports for senior stakeholders - translated raw site data into prioritised risk and delivery dashboards, directly informing resource allocation decisions across the UK Fibre rollout. Supported UAT-equivalent pre-commissioning validation — co-ordinated site readiness checks against planning specifications; signed off sites before handover with 100% spec compliance.

Requirements Elicitation Stakeholder Management Process Mapping UAT / Validation BRD / FRD Data Analysis User Stories Power BI Reporting AI-Enabled BA

Featured Projects

GitHub · Data Analytics Projects
Customer & Sales Dashboard Power BI
🔍 View Dashboard
🛒
Customer & Sales Dashboard – Power BI

Interactive Power BI dashboard built using customer and sales data from an electronic shop. Analyzes sales trends, customer demographics, product performance, and revenue contribution using Star Schema data modeling with DAX measures and Power Query transformation.

Power BIDAXStar SchemaPower QueryKPIs
NCR Ride Booking Dashboard Excel
🔍 View Dashboard
🚖
NCR Ride Booking Dashboard – Excel

Analyzes ride booking data from NCR (National Capital Region) to uncover booking trends, cancellation reasons, driver performance, and customer behavior patterns. Built entirely in Microsoft Excel using Pivot Tables, Slicers, and interactive charts — no external tools required.

Excel AdvancedPivot TablesPower QueryKPI MetricsSlicers
EV Population Data Dashboard Tableau
🔍 View Dashboard
EV Population Data Dashboard – Tableau

Explores Electric Vehicle adoption trends, manufacturer dominance, and regional EV distribution across the United States. Built as an interactive Tableau dashboard comparing BEVs vs PHEVs, identifying top-performing manufacturers, and revealing high-adoption urban/coastal patterns.

TableauData VisualisationEDAExcel PrepBEV vs PHEV
Business Analysis · Professional Projects
🛰️
Stakeholder Requirements Elicitation

Led requirements elicitation workshops with 10+ stakeholders across planning, field survey, and delivery teams. Documented functional and non-functional requirements into structured BRD-equivalent artefacts, reducing ambiguity and accelerating sign-off cycles.

BRD ArtefactsWorkshopsJIRA
🔍
Data Quality Governance & Validation

Validated data quality across 300+ network planning sites. Identified naming convention violations, ON number mismatches, and FNC-cable misalignments — reducing post-survey rework by flagging errors at source before field deployment.

Data GovernanceQANetwork Planning
🗺️
Workflow Mapping & Process Improvement

Mapped 8+ end-to-end network planning workflows (As-Is to To-Be). Identified process gaps and proposed changes that eliminated a recurring category of planning errors across site releases.

Process MappingAs-Is / To-BeGap Analysis
UAT, Reporting & Delivery Assurance

Authored user story-equivalent task definitions and acceptance criteria for WFMT/LLUMS commissioning workflows. Supported UAT-equivalent pre-commissioning validation and produced weekly performance dashboards — achieving 100% spec compliance on site handovers.

UATReportingStakeholder MgmtConfluence

Education & Certifications

Bachelor of Technology – Electronics & Communication Engineering
Ponnaiyah Ramajayam Institute of Science & Technology, Chennai
August 2020CGPA: 6.89
Master's in Business Analytics & Digital Marketing
Guvi
December 2024Certified
🎓
Master's in Business Analytics & Digital Marketing
Guvi  ·  December 2024  ·  ID: 7L5Y7S0137374QEv9J
🐍
Data Analyst with Python
Elysium Academy  ·  December 2025
🇮🇳
Tamil
Native
🇬🇧
English
Professional Proficiency

Get In Touch

📧
Email
pnrjkmr2008@gmail.com
📱
Phone
+91 76391 90004
📍
Location
Chennai, India
💼
LinkedIn
ponrajkumar-businessanalyst
Availability
Open to New Opportunities
Ponraj Kumar