Prachi Dwivedi

Business Analyst with 3+ years of experience delivering Agile projects across cloud infrastructure, enterprise applications and data analytics. Proven expertise in requirements gathering, business process analysis, stakeholder management, Agile Scrum, backlog management, user story creation and UAT working closely with Product Owners, Solution Architects and cross-functional teams to deliver business value. Hands-on experience with Jira, SQL, Python, Azure SQL, Azure Data Factory, Advanced Excel and Power BI to analyse data optimise business processes and support data-driven decision making.

Skilled in translating complex business requirements into clear functional solutions improving operational efficiency thus reducing manual effort and ensuring successful project delivery. Strong communicator with a track record of collaborating with business and technical teams to deliver scalable customer-focused solutions in fast-paced Agile environments.

Business Analyst at ScotiTech, UK (2025-06 – Present)

AppDeploy - Enterprise Mobile Application Distribution Platform

• Gathered and analysed business requirements from Product Owners and stakeholders, then converted them into Epics, Features and User Stories in Jira with clear acceptance criteria to ensure development teams had fully testable and unambiguous requirements.
• Facilitated Agile Scrum ceremonies including sprint planning, backlog refinement, daily stand-ups and retrospectives ensuring prioritisation was aligned to business value and sprint delivery goals.
• Designed AS-IS and TO-BE process flows and functional documentation helping stakeholders visualise changes and reducing ambiguity during development and testing cycles.
• Collaborated closely with Solution Architects, Developers and QA teams to validate technical feasibility, clarify requirements and maintain end-to-end traceability from requirement through to release using Jira.
• Improved sprint delivery efficiency by maintaining a well-groomed product backlog, strengthening user story quality and reducing rework through early requirement clarification and continuous stakeholder engagement.

Business Analyst at TANGJI Tech India Pvt. Ltd (2022-05 – 2023-04)

Sales & Operations Analytics Platform

• Brought together the reports for business requirements from Sales and Operations stakeholders and translated them into user stories and acceptance criteria in Jira enabling the Agile delivery of automated reporting solutions.
• Collaborated with Data Engineers to develop SQL queries and Python-based data validation scripts for analysing sales and operational data reducing manual reporting effort by 60%.
• Performed data analysis using SQL to identify sales trends, data quality issues, providing actionable insights that improved business decision-making and report accuracy.
• Created AS-IS and TO-BE process flows, data mapping documents and functional specifications ensuring end-to-end traceability and alignment between business and technical teams.
• Facilitated sprint planning, backlog refinement working closely with cross-functional teams to ensure business requirements were delivered on time with minimal production defects.
• Designed dashboards and KPI reports by validating business logic and reporting requirements contributing to 30% faster reporting and improved visibility into key operational metrics.

Business Intelligence Analyst at HCL Technologies (PepsiCo Project) (2021-03 – 2022-05)

PepsiCo Enterprise Data Modernization on Microsoft Azure

• Collected and analysed business requirements for migrating enterprise data from on-premises SQL Server to Azure SQL Database, translating requirements into Epics, User Stories and acceptance criteria in Jira enabling successful Agile sprint delivery.
• Collaborated with Data Engineers and Solution Architects to design and implement Azure Data Factory pipelines for automated ETL processes reducing manual data movement by 70% and improving data reliability.
• Created AS-IS/TO-BE process flows, data mapping documents and functional specifications improving requirement clarity and reducing development rework by 30%.
• Facilitated Agile Scrum ceremonies including sprint planning, backlog refinement, daily stand-ups and retrospectives ensuring cross-functional teams delivered Azure migration milestones on schedule.
• Coordinated UAT and production releases by validating business requirements against Azure SQL and ADF solutions contributing to 99.9% data accuracy and faster reporting for business stakeholders.

Associate Technical Support at Tech Mahindra (2019-08 – 2020-01)

Remote IT Service Desk & Incident Management

• Provided remote technical support to 100+ end users, diagnosing and resolving hardware, software, network issues using remote access tools, achieving a 95% first-call resolution rate.
• Analysed incident and service request data using Advanced Excel i.e. Pivot Tables, XLOOKUP, Power Query, and dashboards to monitor ticket trends, SLA compliance, and recurring issues helping reduce average resolution time by 20%.
• Created automated Excel reports and performance dashboards for daily and weekly service desk metrics, reducing manual reporting effort by 50% and improving visibility into operational performance.
• Supported user onboarding, software installations, password resets, VPN connectivity, and system configuration remotely while maintaining accurate ticket documentation and delivering consistent customer support.

Bachelor of Engineering in Electronics and Communication Engineering (2009 – 2013)