Hitesh Sarode

About Hitesh Sarode

About MeI\'m a Data Analyst specializing in e-commerce business intelligence with deep expertise in translating multi-platform retail data into actionable insights that drive strategic decisions. What I DoAt Delphi Analytics, I work with multi-brand e-commerce clients across 8+ marketplaces (Amazon, Flipkart, Shopify, Myntra, Ajio, Blinkit, Unicommerce). My focus: understanding business challenges and solving them with data.**Key Analytics Areas:**• Inventory Management - Tracking stock health, optimizing safety levels based on demand patterns• Sales Performance - Analyzing trends across channels, forecasting demand, identifying top performers• KPI Development - Creating actionable metrics (ADS, turnover ratios, lead time) that drive decisions• Channel Analytics - Understanding which marketplaces deliver highest ROI• Supply Chain Insights - Analyzing procurement lead times and fulfillment efficiency Technical FoundationI deliver insights at scale through:• **Data Skills:** SQL (ClickHouse, MySQL, BigQuery), Python (Pandas, NumPy), Data Modeling• **BI Tools:** Metabase, Redash, Power BI, Looker Studio, Excel• **Data Engineering:** Apache Airflow, ETL Development - I build my own pipelines, eliminating dependencies What Makes Me DifferentUnlike most analysts who depend on engineers for clean data, I can:• Design and implement my own data pipelines and automation• Ensure data quality end-to-end• Move faster from business question to analytical recommendation• Handle complex analytical problems with both technical depth and business acumen What Drives MeI\'m passionate about answering real business questions: Why do certain SKUs underperform? Which channels are most profitable? How do we optimize inventory to reduce tied-up capital? Let\'s ConnectI\'m actively exploring Data Analyst and Business Intelligence opportunities in e-commerce, retail, or supply chain analytics. Let\'s connect if you\'re solving data-driven strategy challenges!

Experience

1. Data Analyst

   Delphi Analytics

   Jun 2025 — Present · Nagpur, IN

   ANALYTICS ACHIEVEMENTS:• Created comprehensive inventory analysis dashboards in Metabase tracking 15+ KPIs including Average Daily Sales (ADS), turnover ratios, lead time analysis, and stock health metrics - directly supporting multi-brand client\'s strategic inventory planning and reducing tied-up capital• Delivered sales and channel performance analytics across 8+ marketplace platforms (Amazon, Flipkart, Shopify, Myntra, Ajio, Blinkit, Swiggy Instamart, Unicommerce), providing unified visibility into multi-channel retail operations and enabling data-driven channel optimization decisions• Designed advanced SQL views and analytical queries combining sales data from multiple sources (Zoho, Unicommerce, Shopify) with proper SKU mapping, enabling accurate profitability and product performance analysis across complex product hierarchies• Developed inventory forecasting models analyzing demand patterns, procurement lead times, and fulfillment states to optimize stock levels and support strategic procurement planning, reducing overstock and stockout situations TECHNICAL IMPLEMENTATION (Supporting Analytics):• Built automated ETL workflows using Python and Apache Airflow to extract daily sales, inventory, and order reports from marketplace portals and upload to AWS S3, enabling real-time analytics and eliminating manual data collection processes• Architected ClickHouse database infrastructure with optimized schemas (MergeTree engines) for multi-platform data warehousing, handling 178K+ sales records with complex analytical joins and deduplication logic• Implemented robust data transformation pipelines for CSV to Parquet conversion with column standardization, data type validation, and error handling, ensuring data quality for downstream analytics

Education

• Priyadarshini Engineering College, Higna Road

  Bachelor of Technology - BTech

  2021 — 2025