Improved the Operating Efficiency

Challenges

• Accountability Tracking 0%: The guidelines for responsibilities were unclear, which led to missed deadlines; the reason was a lack of DRIs.

• Incomprehensible and Inconsistent Reporting: Without standardized reporting and data maintenance, teams operated without any direction, leading to missed deadlines, poor decision-making, and an inability to pinpoint inefficiencies in the e-commerce supply chain.

• Database Organization and Security Concerns: The database for e-commerce products was unorganized and not on record completely. This exposed the valuable data to security threats, leading to issues in data integrity and compliance. 

• Erroneous Order Processing: The team relied on client cards for inventory purchases, exposing sensitive data to high-risk, unreliable websites. Lack of training further led to frequent transaction errors, delays, and security vulnerabilities, especially in international orders.

Solutions Implemented

Operational Enhancements

• Department Segregation and Defined DRIs: I restructured the inventory departments into three distinct units: Warehouse Management, Inventory Reconciliation, and Dead Inventory Tracking. This initiative ensured clear ownership, improved accountability, and streamlined operations while minimizing stock discrepancies and inefficiencies.

• Consistent Reporting Structure and Centralized Dashboard: I implemented a daily reporting system for store leads, managing client stores and product hunting. The reporting structure and a centralized dashboard ensured real-time KPI tracking, improved visibility, and enabled data-driven decision-making to keep operations aligned with targets.

Data Management and Security

• Data-Sharing SOPs and Compliance: Standardized protocols were implemented to consolidate product data, improving quality and accessibility. I devised the SOPs and approval procedures for data sharing, to keep everything trackable and ensure the security of the client’s sensitive information.

• Security Checks: Strong security measures, including compliance with international data security standards, were adopted to protect sensitive information and maintain data integrity. I introduced the website checker tools to see the trust score before proceeding with the inventory orders, leveraging the client’s credit cards.

Order Processing Optimization

• Team Training: Comprehensive training programs were introduced to reduce order processing errors and minimize financial risks in international transactions.

• Automation Implementation: Integrated automated order processing systems to enhance accuracy, reduce manual workload, and accelerate transaction completion by integrating an AppSheet-based application. This was developed using AppSheet to automate data recording, improving accuracy and increasing operating efficiency by 95%. The data was then connected to the Google Looker Studio dashboards so stakeholders could easily track things.