Harish.r
Data Analyst with 4+ years of experience in retail, inventory, logistics, and supply chain analytics
Hire this person
Send a job offer directly to this candidate
About
Data Analyst with 4+ years of experience in retail, inventory, logistics, and supply chain analytics, delivering data-driven insights across enterprise and client-facing environments. Proficient in Tableau, SQL, Excel, Power BI, and Python, with hands-on experience analyzing ERP/WMS, inventory, vendor, shipment, and order data. Experienced in developing KPI dashboards, tracking store and vendor performance, inventory flow, shipment performance, and logistics metrics, and identifying operational inefficiencies.
Skilled in data reconciliation, demand forecasting, import/export and trade compliance analysis, and presenting actionable insights to cross-functional stakeholders and leadership.
Experience
Data Analyst - Nike, Inc. - Beaverton, OR, USA
(2025-06)
- Designed and maintained 15+ Power BI dashboards tracking sales performance, inventory turnover, and customer lifetime value (CLV) across 200+ SKUs, used daily by merchandising, category management, and demand planning teams
- Partnered with marketing analytics to design, execute, and analyze A/B tests on email and on-site promotional campaigns, driving a 12% YoY improvement in conversion rate
- Analyzed ERP/WMS data related to inventory movements, order fulfillment, warehouse activity, and shipment status to support retail and supply-chain reporting
- Authored complex SQL queries (joins, window functions, CTEs) against Snowflake data warehouse (50M+ row transactional tables) to automate weekly executive reporting, reducing manual reporting time by 70%
- Built Python (Pandas, NumPy) ETL scripts to clean, transform, and reconcile data from Shopify, Google Analytics 4, and internal order management systems into a unified customer data layer
- Led root-cause analysis on cart abandonment and return-rate anomalies using SQL and statistical analysis, presenting findings to senior leadership that informed a $400K UX investment decision
- Collaborated cross-functionally with data engineering to define requirements for a new ETL pipeline feeding the BI layer, improving data freshness from daily batch to near real-time
- Analyzed import/export and trade-compliance data for international shipments, identifying documentation exceptions and potential delays affecting delivery timelines
- Built and maintained data quality validation checks within SQL pipelines, reducing dashboard reporting errors by an estimated 25%
- Mentored 2 junior analysts on SQL query optimization, DAX measures, and dashboard design best practices, improving team-wide reporting turnaround
- Documented business and technical requirements (BRDs/TRDs) for new analytics initiatives, ensuring alignment between business stakeholders and data engineering
Data Analyst Intern - Deloitte - New Jersey, USA
(2024-05 - 2024-08)
- Supported a retail/e-commerce client engagement within Deloitte's Analytics & Cognitive practice, tracking KPIs (revenue, AOV, CAC, churn) across 3 sales channels using Tableau dashboards refreshed via automated SQL pipelines
- Conducted cohort and RFM (Recency-Frequency-Monetary) segmentation analysis using SQL and Excel to support a customer segmentation strategy presented to client CRM and marketing leadership
- Supported retail analytics involving ERP/WMS, inventory, order, and shipment datasets, performing SQL-based reconciliation between operational systems and the enterprise data warehouse
- Built demand forecasting models using historical sales data in Python and Excel, contributing to client recommendations that reduced projected stockouts during peak holiday periods by 18%
- Developed Tableau dashboards monitoring inventory, shipment tracking, vendor performance, and supply-chain KPIs for client stakeholders
- Partnered with the client's supply chain analytics team to identify inventory discrepancies through SQL-based reconciliation, supporting an estimated $150K in projected annual shrinkage savings
- Created ad-hoc and recurring client deliverables (PowerPoint, Excel, Tableau), translating complex data findings into clear, actionable recommendations for non-technical stakeholders
- Participated in Agile sprint ceremonies (stand-ups, sprint planning, retrospectives) supporting iterative delivery of client analytics deliverables
Data Analyst - Accenture - Hyderabad, India
(2021-03 - 2022-11)
- Delivered analytics solutions for a global retail/e-commerce client account, analyzing transactional and clickstream data across 1M+ monthly active users using SQL and Excel for ad-hoc and recurring client reporting
- Built and maintained Power BI dashboards for the client's regional sales leadership, tracking GMV (Gross Merchandise Value), order fulfilment SLAs, and product return rates across 12 states
- Supported the client's pricing and discounting strategy during high-volume sale events (e.g., festive season sales) by modeling demand elasticity in Excel and Python, informing promotional pricing decisions
- Automated daily MIS (Management Information System) reports for the client using SQL stored procedures and VBA macros, reducing manual reporting turnaround from 3 hours to 20 minutes
- Coordinated with client category management and operations teams to identify slow-moving inventory through data analysis, contributing to a 10% reduction in dead stock
- Documented data definitions and built a shared metrics glossary in Confluence to standardize KPI reporting and reduce metric discrepancies across client business units
- Performed data validation and quality assurance on client data pipelines, identifying and resolving discrepancies prior to executive reporting cycles
- Trained 3 incoming analysts on client SQL data models, reporting standards, and dashboard maintenance procedures
Education
Master of Science - Information Technology - Saint Francis College (2025-05)

