- 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 Extract Transform & Load (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 driving measurable business impact
- Academic Foundation: Currently pursuing BS in Data Science and Applications from IIT Madras (Second Year), combining formal education with practical industry experience
- Business Intelligence: Strong foundation in statistical analysis, database management, and data visualization, with demonstrated ability to translate complex data patterns into clear visual narratives
- Impact-Driven Results: Delivered insights enabling 30% reduction in overstock, 25% improvement in inventory turnover, and 15% increase in profit margins across client organizations
- Technical Versatility: Proficient in Python, SQL, Excel (Advanced), and various data processing tools for end-to-end analytics solutions
Professional Summary
Key Clients & Partnerships
Twin Bird
️ House Of Vedas
Lite Store
Meeranshi
Portfolio Showcase
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, format conversion (CSV, Excel, JSON, XML), API data extraction, data merging & joining, data validation & verification |
| 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
Freelance Data Analyst & Reporting Specialist
Twin Bird, House Of Vedas (HOV), Lite Store | 2025 – Present
Developed comprehensive analytical frameworks and custom reporting solutions for retail and e-commerce businesses, transforming raw transactional data into strategic insights.
- Report Development: Designed and implemented 12+ distinct report types covering sales analytics, inventory management, customer behavior, and profitability analysis
- Reporting Excellence: Created streamlined reporting pipelines reducing manual analysis time by 70%, enabling daily insights delivery with minimal effort
- Multi-dimensional Analysis: Built pivot analysis frameworks analyzing data across time dimensions (daily, weekly, monthly, quarterly, yearly) and business dimensions (product, category, location, customer)
- Inventory Optimization: Developed stock-to-sale ratio algorithms and dead stock identification systems saving clients 15-20% in holding costs
- Financial Intelligence: Implemented profit & loss reporting frameworks with margin analysis, enabling product-level profitability tracking
- Data-Driven Impact: Delivered insights leading to 30% reduction in overstock, 25% improvement in inventory turnover, and 15% increase in profit margins
- Dashboard Engineering: Created interactive dashboards processing 50,000+ transaction records with real-time data refresh capabilities
- Client Partnership: Worked closely with business stakeholders to understand requirements, translate needs into analytical solutions, and train teams on report usage
Specialized Reporting Capabilities
Create Custom Reports for Business Intelligence
From multi-dimensional pivot analysis to advanced forecasting models, I create comprehensive reporting suites that cover every aspect of retail and e-commerce analytics. Each report is designed to answer specific business questions and drive actionable decisions.
01
Multi-Dimensional Pivot Analysis
Comprehensive data exploration across multiple time and business dimensions with dynamic filtering capabilities.
- Monthly, weekly, daily, quarterly, yearly views
- Weekday vs weekend performance patterns
- Category, brand, and product-level breakdowns
- Store/location-wise comparison
- Custom dimension combinations
02
Comparative Analysis Report
Flexible date-range comparison tool enabling performance benchmarking across any time periods.
- Any date vs any date comparison
- Period-over-period analysis (WoW, MoM, QoQ, YoY)
- Same-day-last-year seasonality comparison
- Growth rate and variance calculations
- Visual comparison highlighting key differences
03
Stock-to-Sale Ratio Analysis
Advanced inventory efficiency metric tracking optimal stock levels based on historical sales patterns.
- Real-time ratio calculations
- Trend-based sales forecasting
- Category and product-wise analysis
- Overstock and understock alerts
- Recommended reorder quantities
04
Fast-Moving Items Identification
Velocity-based analysis identifying top-performing products within selected date ranges.
- Sales velocity calculation (units per day)
- ABC classification analysis
- Top N product rankings
- Category contribution analysis
- Seasonal variation in fast-movers
05
Dead Stock Identification Report
Comprehensive analysis of slow-moving and non-moving inventory with actionable recommendations.
- Zero-sale products identification
- Age-of-inventory analysis (30/60/90/180+ days)
- Value locked in dead stock
- Category-wise distribution
- Markdown and clearance recommendations
06
Profit & Loss Analysis
Detailed financial performance tracking with multi-level cost attribution and margin analysis.
- Revenue analysis with discount impact
- COGS tracking and gross profit
- Product-level profitability scoring
- Category and brand-wise P&L
- Break-even and contribution margins
07
Store Performance & Location Analysis
Comprehensive store-level analytics comparing performance across Stores
- Store-wise sales comparison and ranking
- Location performance benchmarking
- Store productivity metrics (sales per sq ft)
- Peak hours and traffic pattern analysis
- Store inventory efficiency by location
- Best/worst performing store identification
08
Seasonal Trend & Pattern Analysis
Time-series analysis identifying cyclical patterns, seasonality, and forecasting opportunities.
- Month-over-month trend identification
- Peak vs off-season performance
- Day-of-week patterns and cycles
- Holiday impact analysis
- Forecasting models for planning
09
Product Category Performance
Comprehensive category-level analytics for strategic planning and merchandising decisions.
- Revenue contribution by category
- Unit volume and ASP trends
- Cross-category purchase patterns
- Category growth rates
- Market basket analysis
10
Inventory Turnover & Efficiency
Working capital optimization through inventory velocity tracking and efficiency metrics.
- Inventory turnover ratio calculations
- Weeks sales of inventory (DSI)
- Category-wise turnover comparison
- Stock-out frequency analysis
- Optimal inventory level 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 and stakeholder understanding
- Business Impact Focus: Every analysis answers "so what?" and "what next?" - focusing on actionable insights over raw data
- Continuous Learning: Stay current with latest analytical techniques through formal IIT Madras education and self-study
- Accuracy & Integrity: Maintain highest standards of data accuracy and ethical handling of business information
- Client Partnership: Work collaboratively to understand unique business needs and deliver tailored, practical 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. Whether you need comprehensive reporting infrastructure or specific analytical solutions, I bring both technical expertise and business acumen to every engagement.
Contact Information
Phone
+91 97398 81313Location
Bangalore, Karnataka
India
Let's Transform Your Data Into Insights
Available for freelance projects, consulting engagements, and part-time opportunities. Whether you need custom reporting solutions, data analytics support, or business intelligence dashboards, I'm here to help turn your data into actionable strategies.
Get In Touch