BUSINESS ANALYSIS · DATA · TECHNOLOGY

Turning business problems into data-driven solutions.

Hi, I'm Prerna a data professional with 2+years of experience, building my expertise in Business Analysis, Requirements Analysis, Process Improvement, SQL, Data Analytics, and Technical Solution Design.

Explore my projects ↗ Let's connect

2+ yearsData experience

BA portfolioPractical case studies

Tech + businessMy focus

PROJECT SNAPSHOTCASE STUDY 01

Business problem

↓

Requirements & analysis

↓

Proposed solution

↓

Validation & outcomes

Structured thinking. Measurable outcomes.

01 / ABOUT

Curious about the why, focused on the how.

My background in data helps me connect business questions with evidence. I'm developing a practical Business Analyst toolkit: understanding stakeholder needs, documenting requirements, mapping workflows, and translating them into clear specifications for delivery teams.

↗

Business-first thinking

Clarify the problem, define scope, and connect requirements to business value.

⌘

Structured documentation

Organize requirements, user stories, acceptance criteria, and test scenarios.

▥

Data-informed decisions

Use SQL, reporting, and KPI thinking to investigate issues and measure results.

02 / SKILLS

A toolkit for connecting the dots.

Business Analysis

Requirement GatheringBRD / FRDUser StoriesAcceptance CriteriaStakeholder AnalysisAS-IS / TO-BEProcess MappingUATRTM

Technical & Data

SQLREST API ConceptsJSONPostman · LearningData MappingPower BIExcelDashboard Requirements

Ways of Working

Agile / ScrumRequirements TraceabilityGap AnalysisRoot Cause AnalysisCross-functional CollaborationProcess Improvement

03 / SELECTED PROJECTS

From problem statement to solution design.

CASE STUDIES

FEATURED · BUSINESS ANALYSIS01

Food Delivery Order Management System

A self-driven case study simulating how a BA could investigate order cancellations, restaurant response delays, payment-status issues, and delivery-tracking gaps.

BUSINESS CHALLENGE

Improve order visibility and reduce avoidable friction across the ordering journey.

BA APPROACH

Stakeholder analysis, AS-IS/TO-BE mapping, requirements, user stories, API requirements, and UAT.

MEASUREMENT

Define KPIs such as cancellation rate, restaurant acceptance time, and on-time delivery.

BRDUser StoriesProcess FlowAPI RequirementsUAT

DATA ANALYSIS02

Sales Performance Analysis

Analyze sales trends, product/category performance, and key business metrics to identify useful reporting questions.

SQLPower BIKPI Design

TECHNICAL BA03

Customer & Order API Requirements

Document sample request/response fields, validation rules, status handling, and failure scenarios for an order API.

REST APIsJSONData Mapping

04 / DELIVERABLES

Artifacts that show how I think.

01Project Charter & ScopeProblem statement, objectives, scope, assumptions, risks↗ 02Stakeholder AnalysisStakeholder register, influence/interest, engagement plan↗ 03AS-IS / TO-BE Process FlowCurrent workflow, pain points, proposed workflow↗ 04BRD, User Stories & Acceptance CriteriaBusiness needs translated into testable requirements↗ 05API & Data MappingSample endpoint, fields, validation, error cases↗ 06UAT Test Cases & RTMRequirement coverage, expected results, traceability↗

05 / MY APPROACH

A repeatable way to solve problems.

Discover

Understand the business goal, users, stakeholders, and constraints.

Analyze

Map the current process, investigate gaps, and validate root causes.

Specify

Document requirements, user stories, rules, and data/API needs.

Validate

Align stakeholders and prepare UAT scenarios to check expected behavior.

LET'S CONNECT

Have a problem worth solving?

I'm interested in Business Analyst, Technical BA, and data-focused opportunities where business understanding and analytical thinking come together.

LinkedIn ↗ Email ↗ Resume PDF ↗