Dev Anand Jayakumar

Data Analytics Portfolio

Dev Anand
Jayakumar

Data Analyst - Campaign & Financial Analyst

Certified Data Analyst professional specialized in campaign and product analytics for the loyalty industry, supporting large customer bases with end-to-end campaign management, reporting, automation, and business-focused analytical solutions.

✉ devanand765@gmail.com ☎ +353 899590574 📍 Dublin, Ireland

About Me

About Me

Based in Dublin, Ireland, I am a data analyst with over four years of experience working across campaign analytics, financial reporting, dashboard development, and process automation.

My background combines SQL, Excel, Power BI, Tableau, Python, Snowflake, Azure, and Power Automate to analyse large datasets, optimise reporting processes, and translate data into clear insights for business stakeholders.

At Tata Consultancy Services and Mu Sigma, I supported campaign performance analysis, A/B testing, KPI reporting, financial analysis, and dashboard automation. My work included reducing reporting effort, improving query performance, automating recurring tasks, and presenting decision-ready insights.

I recently completed my M.Sc. in Computing, Data Analytics at Dublin City University, and I am currently seeking opportunities in Ireland as a Data Analyst, Campaign Analyst, Financial Analyst, or Reporting Analyst.

Technical Skills

Analytics & Reporting

SQL, Excel, KPI tracking, campaign analysis, product analysis, financial analysis, trend analysis, and business reporting.

Visualisation & Storytelling

Power BI, Tableau, dashboard design, performance reporting, executive summaries, and insight communication.

Automation & Platforms

Python, Snowflake, Power Automate, Power Query, Azure, SQL procedures, scheduled workflows, and process improvement.

Tools & Technologies

SQL Excel Power BI Tableau Python Snowflake Azure Power Automate Power Query A/B Testing Campaign Analysis Financial Reporting

Work Experience

C

Operations Specialist

Covalen (CPL)
Oct 2025 - Present
Limerick, Ireland
  • Contributed to a 10-12% reduction in repeated contacts by analysing recurring customer queries and promoting self-service solutions.
  • Analysed operational data and call trends using advanced Excel features to support data-driven decision-making.
  • Developed structured validation checklists to achieve near 100% verification accuracy and strengthen GDPR compliance controls.
  • Monitored KPIs such as AHT, AWT, and service levels to improve operational visibility and identify workflow inefficiencies.
M

Senior Data Analyst

Mu Sigma
Aug 2022 - Sept 2023
Bengaluru, India
  • Reduced query runtime by 30% by developing and optimising SQL queries in Snowflake using clustering keys, materialized views, and partitioning strategies.
  • Created Power BI dashboards to visualise KPIs and present insights to senior stakeholders for data-driven decision-making.
  • Utilised Snowflake to perform complex SQL queries and aggregate data from multiple sources to support real-time analytics and reporting.
  • Improved reporting efficiency by 25% through business valuation, financial analysis, and Power Query-based transformation.
Key Achievement

Improved analytical performance and reporting efficiency by combining faster SQL processing with clearer business dashboards for stakeholder decision-making.

T

Data Analyst

Tata Consultancy Services
May 2019 - July 2022
Chennai, India
  • Developed Power BI dashboards for campaign metrics, contributing to a 75% reduction in manhours for major retail offers.
  • Enhanced Excel reports for KPI calculations such as sales uplift, sales-to-cost ratio, and ROI, reducing manual calculation effort.
  • Conducted A/B testing to optimise targeting conditions, contributing to a 10% increase in customer engagement.
  • Automated repetitive tasks using Power Automate and SQL scheduled tasks, improving operational efficiency by 25% and reducing manual effort by 15%.
Key Achievement

Delivered measurable campaign reporting improvements by reducing manual effort, increasing customer engagement, and automating repeat analytical workflows.

Featured Projects

Project 1

Campaign Automation Using SQL

SQL Stored Procedures Task Scheduling Automation

Why this project started: Recurring campaign targeting and reminder activities involved repeated manual effort, higher turnaround time, and avoidable dependency on repetitive operational steps.

What was achieved: Built an automated process using stored procedures and scheduled tasks to streamline recurring campaign operations, reduce manual effort by 15%, and improve consistency in execution.

Project 2

Power BI KPI Dashboard

Power BI Excel Dashboarding Reporting

Why this project started: Stakeholders needed faster visibility into campaign, sales, and operational KPIs without waiting for manually prepared reports.

What was achieved: Created an interactive KPI dashboard that improved visibility, reduced reporting delays, and supported faster data-driven decision-making.

Project 3

A/B Testing Analysis for Campaign Optimisation

Python Excel A/B Testing Campaign Analysis

Why this project started: Campaign teams needed a more evidence-based way to identify which targeting and communication strategies were performing better.

What was achieved: Evaluated campaign variants, measured uplift, and supported improved targeting decisions that contributed to a 10% increase in customer engagement.

Project 4

Financial & Reporting Analysis Improvement

Excel Power Query Financial Analysis Reporting

Why this project started: Financial reporting and business valuation work required a more structured and efficient process to reduce turnaround time and improve reliability.

What was achieved: Improved reporting efficiency by 25% by streamlining data transformation, reducing manual work, and producing more structured outputs for business reviews.

Case Studies

Case Study 1

Tenant and Landlord Rating Platform for Fairer Housing Access

Problem: In Ireland, rental listings can create difficulties for both genuine tenants and responsible landlords. Tenants often face high rents, delayed repairs, weak property maintenance, and situations where landlords may not be registered with the RTB. At the same time, landlords and agents also need a better way to identify suitable tenants based on fit, reliability, and mutual expectations.

Idea: Build a rating and matching platform connected to rental-style listing workflows, where property posts are shown only to applicants who match the landlord’s criteria and where tenant and landlord ratings improve transparency on both sides.

Goal: Create a fairer and more data-driven rental ecosystem that reduces exploitation, improves trust, and helps both tenants and landlords make better decisions before entering an agreement.

Status: Initial case study idea. Approach, tools, data model, and implementation plan will be added later.

Education Background

M.Sc. in Computing, Data Analytics

Dublin City University | Dublin, Ireland | Graduated Nov 2024

Completed postgraduate study focused on data analytics, structured data processing, analytics-driven problem solving, and practical application of modern analytical techniques.

Get In Touch

Contact Details

Email: devanand765@gmail.com

Phone: +353 899590574

Location: Dublin, Ireland