Hatim Talwara

Analyzed 100,000+ transactions using SQL and Excel to identify top revenue-generating categories and regions, informing targeted sales strategies.

Built interactive Tableau dashboards for real-time tracking of daily sales and growth trends, enhancing visibility into performance metrics.

Delivered comprehensive KPI reporting (revenue, AOV, conversion, category performance) using Excel & Tableau to provide critical business insights.

Used Excel statistical functions to perform trend and variance analysis, directly supporting sales planning and forecasting.

Automated recurring reports with Tableau dashboards, cutting manual effort by 60% and improving reporting efficiency.

Presented actionable insights from dashboards to management, driving informed promotion and product-mix decisions that optimized sales performance.

Built and supported automated ETL pipelines using Fivetran and Trifacta, ingesting multi-source data into Snowflake and reducing data refresh time by 30%.

Designed and maintained Snowflake data models and warehouse tables, improving SQL and HiveQL query performance by 25% for analytics and reporting use cases.

Developed and optimized SQL, PL/SQL, and HiveQL queries on large datasets (10M+ records) using DBeaver (Hive) to support business and ad-hoc analysis.

Created Python-based data validation and monitoring scripts, increasing pipeline reliability and SLA adherence by 20% while reducing manual checks.

Collaborated with senior engineers and analysts to translate business requirements into scalable, production-ready data pipelines aligned with big data environments.