Prakash Kaliyaperumal

Data Analytics Engineer @DSP

London, GB

Built scalable data warehouses using dbt for transformation, Airflow for orchestration, and Astronomer as the deployment platform.Implemented data unification solutions in Databricks, integrating multiple sources to prepare data for analysis in Power BI.Conducted point-in-time financial analysis to ensure historical accuracy in reporting.Managed Power BI Service by setting up scheduled refreshes across diverse sources (ODBC, APIs, databases), troubleshooting refresh failures.Interpreted and implemented API documentation from platforms such as Xero, HubSpot, DealHub, and CreditScore4 to extract and integrate critical data.Developed robust extraction pipelines to ingest raw data into SQL databases from scratch.Designed automation solutions to deliver real-time business insights directly in Excel.Created financial reports visualizing company creditors and debtors for clear expense tracking.

Vellore Institute of Technology

Bachelor of Technology - BTech, Electrical and Electronics Engineering

University of Stirling

Master's degree, Big data

University of Stirling

Master's degree, Big data science