Open for Data Analyst & BI Roles · Kerala, India

Transforming Complex Data into Actionable Decisions.

SQL · Microsoft Excel · Power BI · Python · Automated ETL & Dashboards

MCA graduate and early-career Data Analyst from Kerala, India. I specialize in turning raw, messy business records into structured insights—developing automated data cleaning pipelines, calculating executive KPIs, and engineering interactive Power BI reports that drive measurable business outcomes.

View Case Studies Download Resume Get in Touch
GitHub (eraofemperor) LinkedIn Profile
Analytical Profile

About Akhil Shibu

Rooted in computer application fundamentals and analytical discipline, transforming unstructured records into verified, actionable intelligence.

I am an MCA graduate from CHMM College for Advanced Studies in Kerala, specializing in data analytics, business intelligence engineering, and automated ETL pipelines. My work focuses on real-world business and public safety challenges—analyzing traffic risk concentrations, developing repeatable spreadsheet cleaning pipelines, and delivering executive dashboards.

Rather than relying on superficial visualizations, I prioritize the complete analytical lifecycle: scoping stakeholder requirements, profiling raw schemas, applying automated data validation rules, aggregating multi-dimensional records with SQL window functions, and designing DAX star schemas inside Power BI.

My practical experience comes from intensive portfolio development (Datasentrix, Kerala Road Safety Intelligence, and Bike Sales Analytics) combined with enterprise virtual job simulations with Deloitte Australia and Tata Insights.

Analytical Principles

  • Data Hygiene First Auditing schema drift, null records, and statistical outliers before drawing business conclusions.
  • Decision-Centric Reporting Designing KPI scorecards and drill-downs that directly answer executive bottlenecks.
  • Automated & Repeatable Engineering structured SQL scripts and Python pipelines rather than error-prone manual steps.
Case Studies

Featured Projects

Production-grade analytical platforms, public data investigations, and executive business intelligence dashboards.

01 · Analytics Platform · Python / Django / SQL Completed Architecture

Datasentrix

An end-to-end automated data hygiene and reporting platform built to bridge the gap between messy multi-source spreadsheets and dependable executive reporting.

Problem Ad-hoc data prep in commercial teams leads to unrepeatable errors, schema drift, and unreliable downstream dashboard aggregations.
Pipeline Automated null primary key drop-offs, Z-score outlier isolation, cohort retention aggregations, and automated KPI generation.
Learned Structuring a cleaning-to-reporting pipeline end to end with robust validation yield tracking.
Python Django SQL Data Validation Cohort Modeling
View on GitHub
02 · Geospatial & Public Safety Telemetry Completed Analysis

Road Accident Analysis in Kerala

Comprehensive statistical investigation of 34,500+ traffic incident records across all 14 Kerala districts, pinpointing high-fatality corridors and nighttime risk clusters.

Problem Where, when, and why do severe road accidents occur across Kerala's national highways and rural arterial networks?
Findings Thiruvananthapuram and Ernakulam carry 29.1% of all fatal incidents. Crashes between 20:00 and 04:00 exhibited a 64.2% higher fatality severity ratio.
Method SQL window functions (RANK() OVER), severity weighting indices, and district-level Power BI heatmaps.
SQL Window Functions Power BI Microsoft Excel Pandas MoRTH Public Data
View on GitHub
03 · Commercial Intelligence & Margin Analysis Interactive Dashboard

Bike Sales Excel Dashboard

Multi-dimensional commercial performance workbook analyzing product margins, demographic customer purchasing patterns, and regional seasonal variance.

Problem Which products, categories, and regional distribution tiers drive commercial sales performance and gross margin?
Focus Sales performance, product and category drill-down, regional demographic variance, dynamic slicers, and revenue trends.
Tooling Advanced Excel formulas (XLOOKUP, conditional logic), dynamic Pivot Tables, slicer timelines, and KPI summary scorecards.
Microsoft Excel Pivot Tables Data Modeling KPI Cards Slicers
View on GitHub
Capabilities

Core Skills & Technical Competencies

A disciplined blend of statistical validation, business intelligence reporting, and database programming.

Data Analytics & Hygiene

Data Cleaning Schema Validation Exploratory Analysis (EDA) Z-Score Outlier Detection KPI Design Trend & Cohort Analysis Root Cause Diagnostics Descriptive Statistics

Business Intelligence

Power BI DAX Measures Star Schema Modeling Executive KPI Cards Interactive Slicers Drill-down Hierarchies Microsoft Excel Pivot Tables & Lookups

Languages & Frameworks

SQL (PostgreSQL / MySQL) CTEs & Subqueries Window Functions (RANK, LAG) Python 3 Pandas NumPy Matplotlib / Seaborn Django Backend Pipelines
Methodology

The 8-Stage Analytical Pipeline

How every business question moves from raw, unstructured data into verified executive action.

01 · UNDERSTAND
Business Objective
Clarify stakeholder KPIs, core decision bottlenecks, and measurable success criteria.
02 · INSPECT
Schema & Quality
Audit raw schemas, data types, cardinality, missing null distribution, and duplicates.
03 · CLEAN
Validation Hygiene
Apply programmatic validation rules, impute or drop invalid records, and isolate outliers.
04 · TRANSFORM
Feature Engineering
Construct calculated dimensions, time lags, moving averages, and relational star schemas.
05 · ANALYZE
SQL & Modeling
Execute multi-level aggregations, window partition ranks, and statistical variance checks.
06 · VISUALIZE
BI Dashboarding
Build intuitive visual representations with dynamic slicers and drill-down capabilities.
07 · DIAGNOSE
Root Cause Insight
Synthesize why anomalies occurred—separating seasonal noise from structural shifts.
08 · ACT
Recommendation
Translate diagnostic findings into prioritized, high-leverage operational decisions.
Simulated Experience

Virtual Job Simulations

Practical, client-style business intelligence exercises completed via Forage (2026).

Data Analytics Job Simulation

Deloitte Australia · Forage (2026)

Executed client-facing data analysis tasks involving spreadsheet forensic cleaning, forensic data modeling, executive dashboard construction, and business insights presentation for commercial clients.

Client Dashboards Spreadsheet Analysis Data Storytelling

GenAI-Powered Analytics Simulation

Tata Insights · Forage (2026)

Completed end-to-end exploratory data analysis (EDA), predictive dataset preparation, automated data storytelling, model validation, and responsible AI evaluation for corporate decision-makers.

Exploratory Analysis Predictive Modeling Model Validation
Education & Credentials

Academic Degree & Professional Certifications

Formal university degree in Computer Applications paired with industry-standard Google Cloud and AI certifications.

Master of Computer Applications (MCA)

CHMM College For Advanced Studies · Department of Computer Applications, Kerala, India

Comprehensive postgraduate coursework encompassing Relational Database Management Systems (RDBMS), Advanced SQL Query Optimization, Python Software Engineering, Algorithms & Data Structures, and Enterprise Web Architectures.

Google Cloud

Google Cloud Fundamentals: Core Infrastructure

Foundational compute, storage, BigQuery data warehousing, VPC networks, and cloud architecture fundamentals.

Coursera · Authorized by Google Cloud
Google

Google API Architecture & Integration

API endpoint lifecycle, authentication models, RESTful data exchange, and cloud service integration.

Coursera · Authorized by Google
IIT / Coursera

AI Programming & Machine Learning Foundations

Applied Python for artificial intelligence, NumPy matrix manipulation, mathematical modeling, and evaluation.

Coursera · Issued by IIT Faculty
Inquiries

Frequently Asked Questions

Direct, structured answers regarding technical proficiency, analytical workflows, and availability.

Akhil Shibu is an MCA graduate and early-career Data Analyst from Kerala, India. He builds production-grade data pipelines, interactive Power BI reports, and Excel analytics models using SQL, Python, and DAX.
The core toolkit includes SQL (CTEs, Window Functions, Group By), Microsoft Excel (Pivot tables, XLOOKUP, dynamic charts), Power BI (DAX measures, star schema modeling), and Python (Pandas, NumPy, Matplotlib, Django backend pipelines).
Key projects include Datasentrix (an automated data cleaning, validation, and KPI generation platform), Road Accident Analysis in Kerala (geospatial severity ranking of 34,500+ traffic incidents), and the Bike Sales Excel Dashboard (commercial margin and demographic analysis).
Akhil has completed three specialized courses on Coursera: Google Cloud Fundamentals: Core Infrastructure (Google Cloud), Google API Architecture (Google), and AI Programming (IIT).
I am actively seeking roles as a Data Analyst, Business Intelligence (BI) Analyst, Reporting Analyst, MIS Analyst, or Operations Analyst. Open to on-site, hybrid, and remote opportunities across India and globally.

Let's Discuss Data & Opportunities

Looking for an analyst who combines rigorous data hygiene with executive reporting? Feel free to reach out directly.

akhilshibu03@gmail.com +91 9061511805 Kerala, India
Send Email Call Direct LinkedIn GitHub