Ranjani Balu

Data Analyst - Techboox - UK

(2025-01)

Act as a strategic liaison between digital teams and commercial stakeholders, gathering and translating business requirements into clear, prioritised data and reporting requirements.
Apply advanced Excel and SQL to validate data, investigate data issues, and produce reporting outputs, ensuring high data quality and consistency.
Work with system-based data structures and data models, identifying source data inputs and transformation rules to support business operations.
Support user acceptance testing (UAT) for data and system changes, ensuring outputs align with documented business requirements.
Collaborate with stakeholders through reviews and discussions to inform project prioritisation, process improvements, and change management activities.
Contribute to continuous improvement of SOPs and process documentation, ensuring consistency, scalability, and quality.
Analyse customer and operational data to identify reporting gaps and improve customer and business outcomes.

Data Analyst - HCL Technologies Ltd (Client: Goldman Sachs)

(2013-01 - 2021-12)

Gathered, analysed, and documented business and data requirements for large-scale data architecture and system implementation initiatives, producing functional specifications and supporting documentation.
Designed and maintained data models and system-based data structures, defining source system inputs, transformation logic, and data quality requirements to improve scalability and accuracy.
Delivered end-to-end data solutions using SQL, Excel, Python, and Power BI, supporting data integration and reporting frameworks across departments.
Partnered with product, digital, and business stakeholders in workshops and requirement review sessions to translate needs into structured data and reporting solutions.
Supported testing, UAT, and launch readiness for system and reporting changes, ensuring traceability between requirements, data models, and deliverables.
Developed and maintained SOP documentation, training materials, and data governance processes.
Conducted data investigation, validation, and issue resolution to identify risks, gaps, and dependencies, improving data consistency and reporting quality.
Worked within ERP/SaaS-based environments (Oracle-like systems) to manage structured data and reporting workflows.
Applied project management practices across cross-functional initiatives in Agile environments.
Built and validated dashboards, KPIs, and reporting outputs analysing customer feedback and performance data, including SLA compliance and satisfaction metrics.

Multichannel Customer Support Data Analyst - HCL Technologies Ltd (Client: Goldman Sachs)

(2013-01 - 2021-12)

Analysed current and future-state reporting requirements, building dashboards covering SLA compliance and customer satisfaction metrics.
Represented data insights in customer feedback workstreams, identifying improvements that enhanced customer and operational outcomes.
Performed exploratory data analysis and data cleaning using SQL and Python to ensure high-quality datasets feeding into reporting.
Generated KPI reports and automated reporting solutions using SQL queries, delivering recommendations that improved efficiency and performance.

About