Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic

Rohan Raman

Dublin

Summary

With over 2 years of data analytics expertise, I excel in uncovering actionable insights through meticulous analysis. Proficient in statistical analysis, visualization, and machine learning, I specialize in distilling complex datasets into compelling narratives.

Overview

3
3
years of professional experience

Work History

Senior Data Insights Associate

Davy
Dublin
08.2024 - Current
  • Developed and deployed interactive Power BI dashboards, boosting reporting efficiency by 30%, and equipping wealth managers with actionable investment insights.
  • Utilized SQL Server and Snowflake to analyze complex financial data, tracking asset performance, fund activity, and client behavior for strategic decision-making.
  • Delivered key insights into asset allocation and funds under management (FUM), optimizing investment strategies, and improving client retention.
  • Automated task creation in Azure DevOps using Power Automate reduces manual processes by 25% and enhances workflow efficiency.
  • Produced high-quality financial reports using advanced Excel techniques, offering data-driven insights into fund performance and market trends.
  • Monitored financial inflows, outflows, and account activity to identify trends, mitigate risk, and optimize fund allocations.
  • Collaborated with cross-functional teams to ensure accurate data availability, applying advanced analytics to support decision-making.

Data Analyst

PTSB
Dublin
10.2022 - 08.2024
  • Created interactive dashboards and reports that provided real-time insights into customer behavior, payments, and MI.
  • Gathered, manipulated, and cleaned data to extract meaningful KPIs.
  • Transformed credit card reporting with advanced SQL and Excel.
  • Spearheaded customer segmentation enhancement using SQL.
  • Automated Excel template production using VBA, driving 30% efficiency gains.
  • Engineered nine SQL calculators, driving 80% efficiency.
  • Optimized address matching using Python fuzzy matching (93% accuracy).
  • Slashed processing time by 70% through rigorous data analysis.

Data Science Intern

HCL Technologies
Bengaluru
12.2020 - 06.2021
  • Engineered an End-to-End transcription tool using deep learning for audio CVs
  • Led audio data collection and synthesis to fine-tune speech-to-text models
  • Conducted extensive research on audio-to-text models and language modeling

Web Developer

Darts India
Chennai
06.2020 - 07.2020
  • Developed a dynamic web app with node.js, HTML, CSS, and JavaScript for displaying real-time stock data
  • Led data extraction from NSE, managing API JSON integration and MySQL database population

Data Science Intern

Hewlett Packard
Singapore
12.2019 - 01.2020
  • Trained in decision models, data mining, statistical methods, regression, and more
  • Utilized Python and Excel for data analysis and visualization
  • Ranked second among interns for overall performance

Education

Power BI Data Analyst -

Data Camp
Dublin
03.2024

MSc. - Data Analytics

Dublin City University
Dublin
09.2022

Bachelors - Computer Engineering

VIT University
Vellore
07.2021

Skills

  • Collaboration
  • SQL Server
  • Data analysis
  • Data visualization
  • Data reporting and dashboards
  • Financial data analysis
  • Attention to detail
  • Statistical analysis
  • Python for Data Science
  • Power BI
  • Teradata
  • Microsoft Excel
  • VBA
  • Machine learning
  • NLP
  • ETL
  • SAS VA
  • IBM Job Scheduler
  • Problem Solving
  • Stakeholder Management
  • Microsoft Office
  • Jira
  • Git/ GitHub
  • MS Visio
  • Azure DevOps
  • Microstrategy
  • Power Automate
  • Snowflake

Projects

  • Customer Churn Analysis in Power BI, 12/01/23, Conducted exploratory analysis to scrutinize customer churn patterns., Investigated demographics, location, and timeframes to uncover trends.
  • HR Analytics in Power BI, 01/01/24, Performed exploratory analysis to uncover trends within HR data., Analyzed employee demographics and performance to examine attrition and retention.

Timeline

Senior Data Insights Associate

Davy
08.2024 - Current

Data Analyst

PTSB
10.2022 - 08.2024

Data Science Intern

HCL Technologies
12.2020 - 06.2021

Web Developer

Darts India
06.2020 - 07.2020

Data Science Intern

Hewlett Packard
12.2019 - 01.2020

Power BI Data Analyst -

Data Camp

MSc. - Data Analytics

Dublin City University

Bachelors - Computer Engineering

VIT University
Rohan Raman