Gokul Ilangovan - Technical Business Analyst & Data Analyst - Technical Business Analyst & Data Analyst

About

Highly analytical Technical Business Analyst and Data Analyst with 3+ years of experience in translating complex data into actionable insights and strategic solutions. Proven expertise in data mining, transformation, and visualization across cloud platforms, delivering impactful dashboards and robust data pipelines. Adept at functional requirements documentation, stakeholder collaboration, and ensuring data quality to drive significant improvements in conversion rates and customer retention.

Work Experience

Data Analyst

Pillir

Apr 2020 - May 2023

Remote, US

Led data analysis and visualization initiatives for a cloud-based platform, driving significant improvements in data integrity, stakeholder self-service capabilities, and business performance.

Designed and deployed 10+ interactive dashboards using Power BI and Tableau, visualizing critical KPIs (CAC, CTR, ROAS) and reducing ad-hoc data requests by 35%.
Integrated diverse performance data from Google Analytics, Facebook Ads, and internal sources, boosting conversion rates by 22% through comprehensive analysis.
Developed automated data pipelines with SQL and Databricks, enhancing data transparency and optimizing business processes through detailed functional workflow documentation.
Constructed data models in Snowflake to support churn prediction and targeted email strategies, contributing to an 18% increase in customer retention.
Executed advanced data cleaning on 10M+ rows in Excel and Google Sheets, significantly improving data integrity and accuracy for downstream analytics.
Collaborated with engineering and QA teams to define and validate test cases for marketing data integrations, elevating pipeline accuracy by 30%.
Presented data-driven insights to senior stakeholders, influencing key budget reallocations and shaping marketing strategy.
Translated complex business requirements into functional specifications, user stories, and KPI tracking dashboards, ensuring alignment across technical and business teams.

Education

Computer Engineering

Anna University

Chennai, Tamil Nadu, IN

Data Analytics

Dublin City University

Dublin, Leinster, IE

Certificates

Google Professional Data Analytics

Google

Microsoft Azure Fundamentals

Microsoft

ECBA - Entry Certificate in Business Analysis

IIBA

Projects

Revenue Insights in Hospitality Domain

Analyzed hotel booking and revenue data to uncover critical patterns, trends, and anomalies within the hospitality sector.

British Airways Review Analysis

Conducted an in-depth analysis of over 15,000 British Airways customer reviews to understand sentiment and identify key areas for service improvement.

Semantic Analysis of Amazon Review (Thesis)

Thesis project focused on applying machine learning techniques to analyze Amazon reviews for anomaly and pattern detection, specifically for fraud prevention.

Languages

English

Skills

Programming & Scripting

Python
SQL
PL/SQL
XML
JavaScript (basic)

Data Analysis & Visualization Tools

Power BI
Tableau
Oracle Analytics
Excel
Google Sheets
Matplotlib
Seaborn
DAX

Databases

Oracle
Snowflake
MySQL

Big Data & ETL

Hadoop
Spark
Databricks
Airflow (DAG)
API-based Data Ingestion
ETL Workflows

Cloud Platforms

Azure Cloud
Amazon S3

Machine Learning & Statistics

R
SPSS
Pandas
Scikit-learn
NLP (TF-IDF, Sentiment Scoring)
Anomaly Detection
Pattern Detection

Business Analysis & Project Management

Functional Requirements
User Stories
Test Case Design & Validation
Business Process Documentation
Data Mapping & Transformation
Data Modeling (Snowflake, Oracle)
Integration Testing
Dev/QA/Ops Collaboration
Jira
GitHub

Soft Skills

Clear Communication (Verbal & Written)
Presentation Skills
Team Player
Stakeholder Management
Cross-functional Teamwork
Analytical Thinking
Data-Driven Decision Making
Problem Solving
Works Well Under Pressure
Meets Deadlines
Self-Starter