Prerna Pasi

Operations and Product Support Specialist

London, UK 3+ yrs exp 86 · Excellent

About

Data-driven Operations and Product Support Specialist with experience in managing data workflows, optimising operational processes, and supporting transaction-related reporting across compliance and business operations environments. Proven ability to analyse complex datasets, identify root causes of discrepancies, and improve data accuracy and process efficiency. Skilled in building dashboards, automating workflows, driving resolutions, and collaborating with cross-functional stakeholders. Equipped with strong analytical capabilities, stakeholder communication skills, and a foundation in project management. Currently working as a Business Analyst Intern at Let Sell Property, facilitating stakeholder requirement gathering, sales pipeline analysis, and data-driven decision-making.

Skills & Expertise (25)

Microsoft Excel Advanced

8.7/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

Power Query Advanced

7.8/10

Years Exp

XLOOKUP Advanced

7.5/10

Years Exp

VLOOKUP Advanced

7.5/10

Years Exp

Countifs Advanced

7.5/10

Years Exp

Microsoft 365 Advanced

7.0/10

Years Exp

SQL Intermediate

6.8/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Google Workspace Intermediate

6.5/10

Years Exp

Exploratory data analysis Intermediate

6.0/10

Years Exp

CRM Data Management Intermediate

6.0/10

Years Exp

Beautiful Soup Intermediate

5.5/10

Years Exp

Microsoft Word Microsoft PowerPoint Team Leadership Business growth Process Mapping Performance Tracking KPI Monitoring Continuous Process Improvement Root Cause Analysis Data Quality Assurance validation Cross-Functional Collaboration

Work Experience

Business Analyst Intern

Let Sell Property

Nov 2025 - Present

Gather and document business requirements from stakeholders and property consultants with a keen focus on improving process visibility and contributing to a 20% reduction in reporting turnaround time through structured requirement analysis. Identify trends and play a key role in enhancing reporting accuracy by 15% through in-depth property listing and transaction data analysis using Excel and CRM tools whilst supporting revenue-focused business decisions. Monitor sales pipeline performance and lead conversion metrics through customised reporting frameworks, increasing visibility by 10% and enabling proactive follow-ups and forecasting. Map and evaluate existing workflows to recommend process enhancements for maximising task completion efficiency by 18%. Facilitate stakeholder discussions across sales, operations, and marketing teams to align reporting expectations, clarify requirements, and support execution of business improvement initiatives. Conduct competitor and market analysis within the real estate sector to track pricing trends, preferences, and new market opportunities. Facilitate user acceptance testing and issue resolution for reporting enhancements and workflow updates, ensuring successful deployment of process improvements.

Operations Analyst

Itelenet Solutions Ltd.

Mar 2025 - Aug 2025

Designed and implemented operational dashboards using Excel (Power Query, Pivot Tables, XLOOKUP) to support performance tracking and enable data-driven decision-making across compliance and operations teams. Upheld operational excellence standards by maintaining audit-ready compliance records and implementing standardised documentation protocols across all UK client operations. Streamlined data collection, validation, and reporting workflows, enhancing KPI tracking accuracy whilst simultaneously reducing manual effort by 60% through process optimisation. Generated operational dashboards and performance reports utilising advanced Excel capabilities, facilitating continuous improvement initiatives and enabling data-driven decision-making across departments. Strengthened cross-functional collaboration by implementing structured document control systems through Microsoft 365 and Google Workspace for improving information accessibility and team coordination.

Data Processing Analyst

NIQ

Nov 2021 - Dec 2023

Streamlined Competitor Category classification workflows for FMCG products through Python automation (pandas, NumPy) integrated with Excel, accelerating clean data availability by 30% for internal analytics and reporting teams. Executed complex queries within NIQ's proprietary ISS (SQL-based platform) to identify pending Combination Pack items, supporting operations teams with accurate workload estimation, prioritisation frameworks, and delivery planning. Enhanced dataset integrity by 35% through systematic validation of parent–child ITEM relationships and elimination of non-workable items using Excel functions (VLOOKUP/XLOOKUP) alongside rule-based verification protocols. Strengthened data quality and downstream reporting confidence by implementing structured cleansing processes, including deduplication, null value handling, and standardisation, resulting in a reduction of discrepancies by 40% across datasets. Designed Excel dashboards and tracking systems utilising Pivot Tables and COUNTIFS functions with a keen focus on optimising pending item visibility and elevating planning accuracy by 25% for cross-functional stakeholders.