MANORANJAN ACHARYA
Kolkata
Summary
Business Analyst / Business Systems Analyst with 7+ years of experience in requirements elicitation, requirements analysis, requirements engineering, business process analysis, process improvement, data analysis, system integration, and end-to-end SDLC delivery across insurance and utilities domains. Experienced in translating business needs into Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Product Requirements Documents (PRD), Project/Process Definition Documents (PDD), User Stories, Acceptance Criteria, business rules, process flows, and functional specifications. Strong experience in As-Is/To-Be analysis, gap analysis, impact analysis, Root Cause Analysis (RCA), stakeholder management, Agile/Scrum, UAT, SQL, ETL, REST APIs, Mainframe/DB2, ODI, and OBIEE. Proven ability to collaborate with Product Owners, business stakeholders, developers, QA teams, data engineers, architects, and legacy-system teams throughout the project lifecycle.
Overview
1
1
Certification
7
7
years of professional experience
Work History
Business Analyst
TATA CONSULTANCY SERVICES (TCS)
07.2024 - Current
- Gather and analyze business requirements related to customer electricity usage, revenue, billing, and reporting, translating business needs into BRDs, functional requirements, User Stories, and Acceptance Criteria.
- Conduct data analysis and validation using Oracle SQL Developer, writing SQL queries to investigate customer usage, revenue, billing, and reporting discrepancies.
- Perform source-to-target data validation and reconciliation, comparing source-system data with transformed datasets and downstream reporting outputs to identify missing, duplicate, or incorrectly calculated records.
- Work with Oracle Data Integrator (ODI) to analyze ETL and data integration workflows, source-to-target mappings, transformation logic, business rules, dependencies, and downstream data movement.
- Work with Oracle Business Intelligence Enterprise Edition (OBIEE) to validate reports, dashboards, KPIs, filters, calculations, and reporting outputs against documented business requirements.
- Perform Root Cause Analysis (RCA) for data and reporting discrepancies by tracing issues across source data, ETL transformations, business rules, and reporting layers.
- Collaborate with developers, data engineers, QA teams, and business stakeholders to investigate defects, clarify requirements, validate data mappings, and identify practical corrective solutions.
- Define and review test scenarios and acceptance criteria, validate business rules and data transformations, review test results, support defect triage, and participate in UAT.
- Identified a source-file delimiter mismatch where a comma-delimited file was incorrectly interpreted as tab-delimited during processing; performed RCA, identified the processing issue, communicated the impact to the development team, and supported the required code correction and validation.
- Supported a platform upgrade validation activity by identifying that the expected application version was not reflected after deployment, coordinating with technical teams to investigate the issue, and validating the corrected deployment.
Business System Analyst
TATA CONSULTANCY SERVICES (TCS)
09.2022 - 06.2024
- Conducted stakeholder discussions and requirements-gathering workshops, eliciting business needs and translating them into User Stories, Acceptance Criteria, BRDs, PDDs, and functional requirements.
- Analyzed current-state and future-state workflows to identify process gaps, dependencies, manual activities, and improvement opportunities.
- Facilitated Agile/Scrum ceremonies, including Sprint Planning and Backlog Grooming/Refinement, improving requirement clarity, prioritization, dependency management, and sprint readiness.
- Collaborated with Product Owners, developers, architects, QA, and business stakeholders to perform technical feasibility and impact assessments, evaluating solution options, dependencies, constraints, and implementation impacts.
- Supported backlog prioritization by evaluating business value, technical feasibility, dependencies, risks, and delivery priorities.
- Identified process automation opportunities by analyzing existing workflows and translating high-level business requirements into actionable functional and technical requirements.
- Performed requirement clarification, change impact analysis, and stakeholder communication throughout the Agile SDLC, maintaining alignment between business expectations and delivered functionality.
Business System Analyst
COGNIZANT
04.2019 - 07.2022
- Conducted requirements elicitation, stakeholder discussions, and requirements analysis for an annuity policy issuance platform, translating business needs into BRDs, FRDs, User Stories, Acceptance Criteria, and functional requirements.
- Analyzed and documented As-Is and To-Be business processes, identifying manual validation activities, data-entry gaps, process bottlenecks, business-rule gaps, and opportunities for process improvement.
- Defined and documented business rules for annuity eligibility, product selection, premium validation, state-specific requirements, beneficiary information, payment validation, and policy documentation.
- Defined decision outcomes including PASS, HOLD, REFER, and REJECT scenarios and collaborated with development and QA teams to ensure business rules were correctly implemented and tested.
- Gathered and documented requirements for REST API integrations, including request/response specifications, field-level data mapping, validation rules, business rules, exception handling, and integration dependencies.
- Collaborated with COBOL/Mainframe and DB2 teams to analyze legacy policy-processing workflows, data elements, business rules, interfaces, and source-to-target mappings.
- Used SQL for data validation, reconciliation, and defect analysis, comparing policy and application datasets to identify inconsistencies and support issue resolution.
- Performed gap analysis and impact analysis for requirement changes and assessed downstream effects on policy processing, interfaces, data, and testing.
- Investigated QA and production issues using Root Cause Analysis (RCA), working with technical teams to identify business-rule, data, and integration causes and coordinate corrective actions.
- Managed requirements throughout the SDLC, collaborating with Product Owners, developers, QA, Operations, and business stakeholders from discovery through development, testing, UAT, and implementation.
Education
B.Tech - Computer Science
Institute of Technical Education And Research
Bhubaneswar05-2017
Higher Secondary Certificate (HSC) - Science
Kalinga Bharati Residential College
Cuttack05-2013
Secondary School Certificate (SSC) - 10th Board
Sri Aurobindo Institute of Integral Education
Bhubaneswar06-2011
Skills
- Requirements Elicitation
- Requirements Gathering
- Requirements Analysis
- Requirements Engineering
- Business Requirements
- Functional Requirements
- Business Rules
- User Stories
- Acceptance Criteria
- Stakeholder Management
- Gap Analysis
- Impact Analysis
- Requirement Traceability
- Change Analysis
- Requirement Prioritization
- As-Is / To-Be Analysis
- Process Mapping
- Workflow Analysis
- Business Process Analysis
- Process Re-engineering
- Process Improvement
- Root Cause Analysis
- Problem Statement Definition
- Process Gap Identification
- Automation Opportunities
- SQL
- Data Analysis
- Data Validation
- Data Reconciliation
- Source-to-Target Mapping
- Data Transformation
- ETL
- Data Integration
- REST API Requirements
- Request/Response Mapping
- DB2
- Mainframe
- Agile
- Scrum
- SDLC
- Sprint Planning
- Backlog Grooming
- Backlog Refinement
- Technical Feasibility
- UAT
- Test Scenario Definition
- Defect Analysis
- Defect Triage
Certification
- Business Analysis Fundamentals - Microsoft, Coursera
- Agile Fundamentals: Scrum and Kanban - Udemy
Accomplishments
- Requirements Traceability: Standardized BA documentation and templates including BRD, PDD, and PRD using Jira and Azure DevOps, improving consistency, requirement traceability, and communication across project teams.
- Defect Prevention and RCA: Identified a source-file delimiter mismatch during data processing, performed Root Cause Analysis, and coordinated with development and QA teams to implement and validate the corrective solution before production impact.
Domain Expertise
Annuity Policy Issuance, Eligibility Validation, Premium Validation, Product Requirements, State Requirements, Beneficiary Validation, Payment Validation, Policy Processing, Business Rules, Customer Electricity Usage, Revenue, Billing, Data Analytics, Reporting, KPI Validation, Data Reconciliation, Usage Analytics
Personal Information
Title: BUSINESS ANALYST | BUSINESS SYSTEMS ANALYST
Core Skills
Requirements Elicitation, Requirements Gathering, Requirements Analysis, Requirements Engineering, Business Requirements, Functional Requirements, Business Rules, User Stories, Acceptance Criteria, Stakeholder Management, Gap Analysis, Impact Analysis, Requirement Traceability, Change Analysis, Requirement Prioritization, As-Is / To-Be Analysis, Process Mapping, Workflow Analysis, Business Process Analysis, Process Re-engineering, Process Improvement, Root Cause Analysis, Problem Statement Definition, Process Gap Identification, Automation Opportunities, SQL, Data Analysis, Data Validation, Data Reconciliation, Source-to-Target Mapping, Data Transformation, ETL, Data Integration, REST API Requirements, Request/Response Mapping, DB2, Mainframe, Agile, Scrum, SDLC, Sprint Planning, Backlog Grooming, Backlog Refinement, Technical Feasibility, UAT, Test Scenario Definition, Defect Analysis, Defect Triage, QA Collaboration, Change Management, Stakeholder Collaboration, BRD, FRD, PRD, PDD, Functional Specifications, Business Cases, Process Documentation, User Personas, Acceptance Criteria, Business Rules Documentation, Jira, Confluence, Azure DevOps, Oracle SQL Developer, Oracle Data Integrator (ODI), OBIEE, ServiceNow, Draw.io, Microsoft Visio, Miro, GCP Studio
Timeline
Business Analyst
TATA CONSULTANCY SERVICES (TCS)
07.2024 - Current
Business System Analyst
TATA CONSULTANCY SERVICES (TCS)
09.2022 - 06.2024
Business System Analyst
COGNIZANT
04.2019 - 07.2022
B.Tech - Computer Science
Institute of Technical Education And Research
Higher Secondary Certificate (HSC) - Science
Kalinga Bharati Residential College
Secondary School Certificate (SSC) - 10th Board
Sri Aurobindo Institute of Integral Education