Resume - Tharun Balasubramaniam | Data Analyst & Business Intelligence Specialist

Professional Summary

Data Analysis Specialist: Proven expertise in transforming raw business data from multiple sources into actionable insights through comprehensive reporting solutions and dashboards
Multi-Source Data Integration: Expert in consolidating data from multiple sources, performing complex ETL operations, and creating unified datasets from CSV, Excel, databases, and API sources
Custom Reporting Framework Developer: Delivered 12+ distinct report types covering sales analytics, inventory optimization, and profitability analysis for retail and e-commerce brands
Client Portfolio: Successfully serving multiple brands including Twin Bird, House Of Vedas, Lite Store, Ackross Home Decor and Meeranshi with tailored analytical solutions
Impact-Driven Results: Delivered insights enabling 30% reduction in overstock, 25% improvement in inventory turnover, and 15% increase in profit margins across client organizations

Key Clients & Partnerships

TWIN BIRD

HOUSE OF VEDAS

SPHERE

MEERANSHI

RICK ROGUE

Core Competencies & Technical Expertise

Competency Area	Technologies & Skills
Data Analysis	Advanced Excel (Pivot Tables, Power Query, Macros, VBA), SQL (MySQL, PostgreSQL), Python (Pandas, NumPy), R Programming, Statistical Analysis
Business Intelligence	Dashboard Design, KPI Development, Data Visualization, Automated Reporting, Real-time Analytics
Database Management	MySQL, PostgreSQL, Database Design, Query Optimization, ETL Workflows, Data Migration, Stored Procedures
Data Integration	Multi-source data consolidation, ETL (Extract, Transform, Load), data standardization, duplicate removal, data quality assurance
Statistical Methods	Descriptive & Inferential Statistics, Time Series Analysis, Product Series Analysis and Forecasting
Inventory Analytics	Stock-to-Sale Ratios, Turnover Analysis, Dead Stock Identification, Fast-Moving Items, Reorder Point Calculations
Financial Analysis	P'&'L Reporting, Margin Analysis, Cost Attribution, Revenue Analysis, Profitability Tracking, Break-even Analysis
Programming	Python, SQL, VBA, PHP, Git/GitHub, Jupyter Notebooks, Data Processing Scripts

Professional Experience

QGenx Technology Platform

February 2024 - Present

Business Intelligence & Software Developer

Full-Stack BI Development: Developing comprehensive business operations software including POS, warehouse management, and BI reporting modules using PHP, MySQL, and modern web technologies
Database Architecture: Designed and implemented complex relational database schemas for multi-tenant retail management systems with advanced security and performance optimization
SEO & Digital Strategy: Led comprehensive SEO optimization including keyword research for Indian market, competitor analysis, and content strategy development

Freelance Data Analytics Consultant

October 2022 - Present

Data Analyst & Business Intelligence Specialist

Multi-Client Portfolio Management: Serving 5+ retail and e-commerce brands with custom analytics solutions, managing diverse data requirements and business contexts
Report Framework Development: Created comprehensive suite of 12+ specialized report types covering inventory, sales, and profitability analytics
Data Pipeline Architecture: Built end-to-end ETL workflows consolidating data from POS systems, e-commerce platforms, and inventory databases
Client Impact Delivery: Documented measurable improvements: 30% reduction in overstock, 25% improvement in inventory turnover, and 15% increase in profit margins

Custom Reports & Analytics Solutions

Comprehensive Pivot Analysis Report

Multi-dimensional BI dashboard with drill-down capabilities across all key metrics

Sales analysis by product, category, brand, location, time
Dynamic filtering and grouping
Top performers identification

Advanced Comparison Reports

Flexible comparison framework for performance analysis across time periods

Any date vs any date comparison
Period-over-period analysis (WoW, MoM, QoQ, YoY)
Growth rate calculations

Stock-to-Sale Ratio Analysis

Advanced inventory efficiency metric tracking optimal stock levels

Real-time ratio calculations
Trend-based sales forecasting
Overstock and understock alerts

Fast-Moving Items Identification

Velocity-based analysis identifying top-performing products

Sales velocity calculation
ABC classification analysis
Top N product rankings

Dead Stock Identification

Comprehensive analysis of slow-moving inventory with recommendations

Zero-sale products identification
Age-of-inventory analysis
Markdown recommendations

Profit & Loss Analysis

Detailed financial performance tracking with margin analysis

Revenue analysis with discount impact
Product-level profitability scoring
Break-even calculations

Store Performance Analysis

Comprehensive store-level analytics comparing performance

Store-wise sales comparison
Location performance benchmarking
Peak hours analysis

Seasonal Trend Analysis

Time-series analysis identifying patterns and seasonality

Month-over-month trends
Peak vs off-season performance
Forecasting models

Product Category Performance

Category-level analytics for strategic planning

Revenue contribution by category
Unit volume and ASP trends
Market basket analysis

Inventory Turnover Analysis

Working capital optimization through velocity tracking

Inventory turnover ratio calculations
Category-wise comparison
Optimal inventory recommendations

Education

BS in Data Science and Applications

Indian Institute of Technology Madras (IIT Madras)

Currently in Second Year | Expected Graduation: 2028

Relevant Coursework: Statistical Methods, Machine Learning Foundations, Database Management Systems, Programming & Data Structures, Business Data Management

Languages

English - Fluent

Tamil - Native

Kannada - Fluent

Hindi - Fluent

Professional Approach

Data Storytelling: Transform complex datasets into compelling narratives that drive business decisions
Business Impact Focus: Every analysis answers "so what?" and "what next?" - focusing on actionable insights
Continuous Learning: Stay current with latest analytical techniques through formal IIT Madras education
Client Partnership: Work collaboratively to understand unique business needs and deliver tailored solutions

Value Proposition

More than just a data analyst – a strategic business partner who transforms raw data into competitive advantages. Combining formal education from IIT Madras with practical experience across multiple retail brands, I deliver insights that directly impact profitability, efficiency, and growth.