Stephanie Katara's Work | ContraWork by Stephanie Katara
Stephanie Katara

Stephanie Katara

Data Entry & Excel | Data Cleaning & E-commerce

    1
    Followers
Followed by GALLERY L

Rajkot, India

WorkAbout

Rajkot, India

Cover image for E-commerce Sales and Order Analysis
E-commerce Sales and Order Analysis (Full 10-Question Script)
0
8
Cover image for This project simulates an end-to-end
This project simulates an end-to-end data pipeline for an international luxury fashion house facing two critical operational challenges: Targeted CRM Marketing: Identifying high-value VIP customer segments across global markets. Supply Chain Efficiency: Isolating stagnant, slow-moving warehouse inventory (dead stock) that ties up operational capital.
0
16
Cover image for This project demonstrates an end-to-end
This project demonstrates an end-to-end data auditing pipeline built to solve typical data fragmentation issues faced by growing French e-commerce brand. By bridging disconnected customer registries, transactional records, and fulfilment center warehouse logs, this architecture automates inventory compliance checks under the French Anti Waste Law (Loi AGEC) and extracts core customer value metrics. Based on simulated 4-table relational database model across 250 sales transactions, the unified data engine successfully extracted the following business insights. • Total Revenue Audited: 24,057€ • Total Order Process: 250 packages • VIP Customer Tier Count: 33 Premium Clients (Users with lifetime spend ≥ €300) • Fulfillment Center Non-Compliance Alert: 8 items flagged as critical deadstock (stored over 120 days) • Total Warehouse Capital Frozen: 3,369€ locked-up in slow moving apparel stock To eliminate data siloes and replace manual entries with an automated dashboard reporting interface, the following rational systems were designed: Cross-Sheet Relational Data Bridges: Deployed advanced multi-criteria XLOOKUP formulas to map transactional row items back to unique customer city and ID profiles across the registry databases. Dynamic Financial Aggregations: Utilized targeted SUMIF and COUNTIF arrays to calculate Customer Lifetime Value (CLV) and track real time transaction velocities. Automated Regulatory Alert Logic: Implemented nested conditional IF(and()) time-subtraction parameters to instantly measure warehouse shelf age (=TODAY() – Arrival_date) against France’s strict 120-days storage limits.
0
16