Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Languages
References
Timeline
Generic

AMALKANTH RAJARATNAM

London,England

Summary

Results-driven data professional with 7+ years of experience in data analytics, leveraging the tools listed below to drive financial decision-making. Proficient in advanced analytics to enhance business insights and support strategic initiatives. Seeking to apply technical expertise and analytical skills in a data-driven role within a dynamic organization.

Overview

11
11
years of professional experience

Work History

Data Analyst

Tesco
08.2018 - Current

Cost-to-serve

Responsible for producing extensive data sets from various sources to deliver cost breakdowns at different levels for stakeholders. The model determines the cost of serving each product by analysing factors such as product size, delivery distance, pay rates, and activity times associated with the product. This allows the business to identify and prioritise its most profitable products.

  • Process 1.5 billion rows of data weekly to generate 25 million for the model, ensuring that any outliers in the dataset are identified and removed to prevent impact on the final output
  • Maintains 95% accuracy in comparison to the final reporting figures for £2 billion in costs.
  • Developed dashboards for the wider team to use, helping them analyse and break down costs for their product lines.
  • Capable of modifying large models to align with finance expectations. Successfully integrated IFRS 16 and enhanced the model at the supplier level to provide valuable insights to suppliers, along with implementing various other improvements.
  • Collaborate with stakeholders to assess the cost to serve for stores and products that are not yet part of the business.
  • Automated emails for stakeholders, providing personalised insights tailored to their specific needs

Project Finance - Network Plan

  • Oversaw finances of projects within 10-year network plan, managing over £100m with additional projects in the pipeline. Leveraged real-time dashboards to monitor financial performance, manage purchase orders, and efficiently resolve procurement issues.

Adhoc

  • Streamlined processes by automating repetitive tasks, resulting in time and cost savings, as well as freeing up storage space
  • Built strong relationships with team members by consistently providing finance and data support when needed

Finance Manager

Tesco
08.2021 - 03.2022

Responsible for reporting on performances of 4 large distribution centres and providing insights to improve operations.

  • Produced £250m budget in close collaboration with stakeholders
  • Provide weekly reports, identifying underperforming KPIs and translating them into financial figures
  • Collaborated with project managers to establish overlays for project and assess their impact on forecast

HR Analyst

G4S
London, England
08.2018 - 09.2018

Managed global HR and H&S reporting, developed training materials, produced senior management reports, and coordinated global employee survey for 120 businesses. Supported HR projects and collaborated with executives on TOM project, coordinating global teams to define structures.

Team Leader

Tesco
London, England
08.2014 - 09.2018

Delivered efficient, customer-oriented service in a high-pressure environment, consistently meeting the needs of customers, colleagues, and the store to maintain high standards in a location generating £100K in weekly sales.

Education

Bachelor of Science - Financial Mathematics

Brunel University
London
07-2017

Skills

    Microsoft SQL

    Teradata

    Excel

    VBA

    Alteryx

    Tableau

    Power BI

    MicroStrategy

    Python (Learning)

    MS Project

    R (Learning)

Affiliations

  • Learning new skills/tools to make life simpler
  • Transforming weaknesses into strengths

Accomplishments

    Emcee at weddings/private events - hosting over 100,000 guests in total

Languages

English
Fluent
Tamil
Native

References

References available upon request.

Timeline

Finance Manager

Tesco
08.2021 - 03.2022

HR Analyst

G4S
08.2018 - 09.2018

Data Analyst

Tesco
08.2018 - Current

Team Leader

Tesco
08.2014 - 09.2018

Bachelor of Science - Financial Mathematics

Brunel University
AMALKANTH RAJARATNAM