Albert Shaju

Masters Graduate

[email protected] +49 15731366786

Resume

Hello, I am

Albert Shaju.

1

Excel
Project

4

PowerBI
Projects

1

SQL
Project

About Me

Hi, I am a Data Analyst with strong skills in SQL, Python, Excel, and Power BI, focused on turning business data into clear insights and measurable results. My work spans retail, hospitality, finance, and supply-chain analytics, where I have built end-to-end dashboards, automated reporting workflows, and delivered insights that support decision-making.

With an MSc in Data Analytics & Information Systems Management and multiple real-world analytical projects, I specialize in data cleaning, KPI development, forecasting, and performance analysis. I approach every problem with a business-first mindset, transforming raw datasets into actionable strategies that improve efficiency, revenue, and customer understanding.

I am driven by clarity, accuracy, and impact—using data to solve problems, optimize operations, and support smarter business decisions.

Key Skills

SQl

python

tableau

spss

dax studio

Microsoft Power BI

Advanced Excel

Power Query Editor

DAX Language

M Query Language

Microsoft SQL Server

pandas

numpy

My Projects

Analytics for Sales (FMCG) industry

Domain/Function: Sales Analytics / FMCG

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Sales, Finance, Marketing & Supply Chain Analytics

Revitalizing Revenue: Hospitality Insights with AtliQ Grands

Domain/Function: Hospitality – Revenue Analytics

AtliQ Mart - Supply Chain Analysis

Domain/Function: Supply Chain Analysis

Finance & Supply chain Analytics

Domain/Function: Finance & Supply chain Analytics

Shield Insurance Analysis

Domain/Function: Shield Insurance Analysis

My Experience

Sortation Associate — Data-Driven Operations

Amazon Logistics, Essen, Germany
Nov 2025 – Present

Monitored and validated high-volume operational data using scan-based systems, ensuring accuracy of daily throughput and defect KPIs.
Identified workflow bottlenecks through real-time data patterns, improving routing accuracy and operational documentation.
Performed structured data checks and discrepancy analysis to maintain consistency across internal tracking systems.
Organized and updated daily performance metrics used by supervisors for workforce planning and shift optimization.
Contributed to continuous improvement by highlighting data inconsistencies and proposing corrections to prevent repeated errors.

Data Analyst Intern

AtliQ Technologies, Vadodara, Gujarat, India
Dec 2023 – Jan 2024

Automated data cleaning workflows and built interactive dashboards to track IT performance, reducing reporting time by 30%.
Analyzed system and application performance metrics, improving decision-making for operational teams.
Delivered actionable insights through Power BI visualizations, supporting strategic planning and business growth initiatives.

Data Insights & Reporting Analyst

Ideenkreis Tech Pvt. Ltd., Kerala, India
Jan 2023 – Nov 2023

Cleaned, validated, and standardized multi-source data from CRM, ERP, and SQL systems, ensuring high-quality inputs for dashboards.
Performed routine data audits, identifying inconsistencies and improving data integrity across business reports.
Built recurring KPI reports using SQL, Excel Power Query, and Power BI, improving reporting accuracy and reducing manual errors by 30–40%.
Supported process improvements by documenting workflow rules and optimizing data validation processes, improving team efficiency.
Ensured end-to-end management of data refresh cycles and dashboard updates with consistent delivery timelines.

Resident Engineer & Zscaler SPOC (Graduate Trainee)

Tata Consultancy Services, Trivandrum, Kerala, India
Oct 2021 – Dec 2022

Managed IT systems for 3,000+ users, ensuring 99.9% uptime and improving SLA compliance by 8%.
Reduced incident resolution times by 30% through automation, data-driven troubleshooting, and workflow optimization.
Cleaned and organized IT operational datasets using Excel and SQL, improving accuracy of internal reporting.
Automated repetitive IT tasks using PowerShell and Python, reducing manual effort by 20%.
Conducted technical training for 200+ employees, reducing support ticket volume by 15%.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

Python: Beginner to Advanced For Data Professionals

Cybersecurity for Business Specialization

Getting started with Google Workspace Specialization

Technical Support Fundamentals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/albert-shaju

Call Me

+49 15731366786

GitHub

https://github.com/Albert-Shaju

Excel Project

Analytics for Sales (FMCG) industry

Domain/Function: Sales Analytics / FMCG

This project delivers two Excel-based sales performance reports that help FMCG sales teams evaluate customer contributions, analyze market results against targets, and identify opportunities to improve revenue and strategic growth.

View Project
on GitHUB

Customer Performance Overview: Displays multi-year net sales trends and highlights top- and bottom-performing customers.

Market vs Target Performance: Compares annual country-level sales against targets to assess market achievement and gaps.

Project Details

⭐ BUSINESS PROBLEM

Sales teams lacked visibility into customer-wise performance, discount efficiency, and market achievement against annual targets, limiting their ability to make proactive revenue decisions.

⭐ APPROACH

Used Excel Power Query to clean and transform raw FMCG sales data. Built dynamic PivotTable-based reports to analyze YoY sales, discount patterns, and market performance. Applied conditional formatting and visualization techniques to highlight critical trends.

⭐ INSIGHTS
• Revealed top- and bottom-performing customers across multiple years.
• Identified underperforming countries and gaps in target achievement.
• Highlighted discount-heavy segments impacting profitability.

⭐ BUSINESS IMPACT
• Enabled data-driven sales planning and early identification of growth opportunities.
• Helped management refine negotiation strategies and optimize revenue.
• Provided a repeatable, refreshable reporting framework for the sales team.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Domain/Function: Sales, Finance, Marketing & Supply Chain Analytics

AtliQ Hardware struggled with limited data visibility due to Excel-based reporting. This project delivers a unified Power BI solution with strong data modeling and drillable insights for sales, finance, marketing, and supply chain teams to improve decision-making.

View Project
on GitHUB

User-centric landing page that provides high-level KPIs and guides stakeholders to functional dashboards.

Data model connecting 10+ tables to enable clean relationships, optimized DAX calculations, and scalable reporting.

Project Details

BUSINESS PROBLEM

AtliQ Hardware relied heavily on Excel-based reporting, resulting in inconsistent KPIs, slow decision-making, and poor visibility across sales, marketing, finance, and supply chain functions.

APPROACH

Built a Power BI solution with a data model of 10+ tables, automated data cleanup with Power Query, and developed advanced DAX measures. Added drill-throughs, bookmarks, and functional dashboards for each department.

INSIGHTS

– Identified profitability trends across customers, regions, and products.
– Revealed gaps in sales forecast accuracy and marketing ROI.
– Detected inventory inefficiencies and supply chain bottlenecks.

BUSINESS IMPACT

– Enabled unified cross-functional reporting and faster decision-making.
– Improved KPI visibility for executives and department heads.
– Provided a scalable BI platform that supports strategic planning and operational optimization.

Live Interactive Dashboard

PowerBI Project

Revitalizing Revenue: Hospitality Insights with AtliQ Grands

Domain/Function: Hospitality – Revenue Analytics

AtliQ Grands, a leading five-star hotel chain in India, faced declining revenue and market share due to competitive pressure and poor decision-making. This Power BI project provides actionable revenue, occupancy, and booking insights to help management recover performance.

View Project
on GitHUB

User-focused landing page with clear KPIs and visual storytelling for quick revenue and occupancy insights.

Data model with 6 interconnected tables enabling clean relationships and accurate DAX calculations.

Project Details

Business Problem:
AtliQ Grands was losing revenue and market share due to inconsistent pricing, poor visibility into booking trends, and ineffective decision-making across its hotel portfolio.

Approach:
Built a Power BI revenue dashboard using Power Query and a 6-table data model. Developed DAX-based KPIs for RevPAR, occupancy, booking trends, and channel performance. Designed a user-centric interface with drill-through reports.

Insights:
Identified underperforming cities, uncovered seasonal demand shifts, revealed pricing gaps across room categories, and highlighted inefficient booking channels.

Business Impact:
Enabled data-driven pricing, improved revenue forecasting, and supported strategic decisions that helped recover lost revenue and strengthen competitive positioning.

Live Interactive Dashboard

PowerBI Project

AtliQ Mart - Supply Chain Analysis

Domain/Function: Supply Chain Analysis

AtliQ Mart, an FMCG manufacturer operating across three cities, faced customer dissatisfaction due to delayed and incomplete deliveries. This Power BI project provides OTIF performance insights to help the supply chain team improve service levels before expanding into new markets.

View Project
on GitHUB

OTIF performance dashboard showing customer-wise and product-wise delivery trends with drill-through insights.

Data model illustrating relationships across order, delivery, product, and customer tables for accurate OTIF calculations.

Project Details

Business Problem:
AtliQ Mart lost key customers due to poor delivery service. Frequent delays and incomplete deliveries reduced trust, impacting contract renewals and limiting expansion into new cities. Management needed visibility into OTIF (On-Time, In-Full) performance to address service gaps.

Approach:
Built a Power BI dashboard using Power Query and a relational data model to track daily OT%, IF%, and OTIF% against customer-specific service targets. Designed DAX-based KPIs, drill-through views, and exception reports to identify delivery issues quickly.

Insights:
Revealed customers with chronic delivery failures, uncovered patterns of late dispatches, and highlighted products with repeated shortages. Identified city-wise operational inefficiencies affecting fulfillment.

Business Impact:
Enabled the supply chain team to act proactively, improving service reliability and strengthening customer relationships—critical for supporting AtliQ Mart’s planned metro expansion.

Live Interactive Dashboard

SQL Project

Finance & Supply chain Analytics

Domain/Function: Finance & Supply chain Analytics

This SQL-based project analyzes financial and supply chain performance by identifying top customers, top products, and market-wise trends. The analysis uncovered Croma’s 180% YoY sales growth in FY-2021, supporting data-driven strategic planning.

View Project
on GitHUB

Market performance badge highlighting revenue distribution and growth across regions.

SQL-based sales badge summarizing top markets and YoY performance.

Project Details

Business Problem:
The company needed clearer visibility into customer profitability, product performance, and market-wise revenue trends to support financial planning and supply chain optimization.

Approach:
Used SQL to clean, join, and analyze multi-market sales datasets. Built queries to identify top customers, best-selling products, regional growth patterns, and financial KPIs. Integrated Excel for further summarization and reporting.

Insights:
Revealed customer segments contributing the highest revenue, top-performing SKUs, and key markets driving growth. Uncovered Croma’s exceptional 180% sales surge in FY-2021, highlighting a critical market opportunity.

Business Impact:
Insights supported strategic decisions on inventory planning, customer targeting, and expansion priorities—aligning finance and supply chain teams around data-backed business strategies.

PowerBI Project

Shield Insurance Analysis

Domain/Function: Shield Insurance Analysis

This project analyzes Shield Insurance’s customer, policy, and revenue data to identify key performance drivers. Using SQL, Excel, and Power BI, the dashboard uncovers insights in customer demographics, sales channels, and policy performance to support strategic decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

sql

excel

Age View: Shows revenue and customer distribution across age groups to identify high-value demographics.

General View: Highlights acquisition, retention, and policy penetration trends for overall business evaluation.

Project Details

Business Problem:
Shield Insurance lacked a unified view of customer behavior, policy performance, and sales trends, making it difficult for leadership to identify growth drivers, optimize sales channels, and improve customer retention.

Approach:
Using SQL, Excel, and Power BI, I cleaned and modeled customer, policy, and revenue data. Designed an interactive dashboard with KPIs, demographic breakdowns, revenue trends, and channel performance. Created drill-through views to explore customer segments and policy categories.

Insights:
Identified high-performing age groups, uncovered underutilized policy types, and revealed sales channels driving the highest conversions. Highlighted demographic segments with strong revenue potential and retention risks.

Business Impact:
Enabled data-driven decisions in marketing, customer targeting, and product strategy, helping Shield Insurance optimize acquisition efforts and improve overall policy performance.