David Lam Email & Phone Number

Montreal, QC, CA

Montreal, Quebec, CA

• Inventory Management Process Using DeposcoI utilize Deposco as the final tool to validate e-commerce (Ecom) transactions, point-of-sale (POS) transactions, and store shipments after extracting compliant reports from.
• I collaborate with our technical or store support teams to identify and resolve inventory discrepancies.
• This process improves the accuracy and cleanliness of in-transit movements, preventing inflated net inventory figures.By streamlining these steps, I help maintain a reliable and efficient inventory management system.

Montreal, Quebec, CA

• Snowflake Expertise:Using Snowflake as a key tool, I extract inventory data essential for maintaining inventory accuracy. I have developed scripts to validate data feeds from other systems into the OMS, ensuring data.
• Detect and address problem transactions.
• Identify aged transactions that remain unprocessed at the store level.This proactive approach enhances inventory reliability and supports efficient operations across all systems.

Montreal, Quebec, CA

• Role and Responsibilities:In my role supporting Retalon, I monitor the OMS inventory, which directly feeds into the Retalon system. By ensuring inventory accuracy, I help the Retalon system better forecast inventory.
• Monitored inventory movements and promptly alerted business units to potential issues and their side effects.
• Contributed to improved inventory accuracy within Psycho Bunny’s system flow over the past year.
• Collaborated with the technical support team to resolve timing issues with webhooks, reducing the number of failed triggers and ensuring inventory tables are updated accurately.
• Achieved a clearer, more reliable picture of inventory data, supporting better decision-making across the business.

Montreal, Quebec, CA

In my role, I use Snowflake to monitor orders and inventory transactions, ensuring inventory accuracy to prevent short shipments. This process also feeds reliable inventory data to Retalon, our allocation system, and NetSuite, our financial system. My accomplishments include developing a solid understanding of system functionalities, enabling me to.

Pointe-Claire, Quebec, CA

Inventory reconciliation analysis to correct and fix interface timing issues between WMS feed to E1 financial system

Pointe-Claire, Quebec, CA

Setup promotional content in HTML, write a SQL query to extract sales reps tiers and distribute the message to their inbox

Pointe-Claire, Quebec, CA

Improve order management process. Documenting new features for change management. Collaboration with customer service for consumer insight for functional improvement

Pointe-Claire, Quebec, CA

Direct to Consumer concepts. Order management with WMS. Promotion timeline. PLM interface resolution

Montreal, Quebec, CA

• Technical knowledge of the Vision Suite software. Understanding of system's parameter, system's interface with legacy systems, and improve business processes through listening and understanding client's requirements..
• Inventory movement
• PO management
• Price management
• Cycle Counts
• Allocation / Distribution

Montreal, Quebec, CA

• SAP knowledge to support mobile app, MiM (Merchandise Inventory Management)
• Successfully completed several MiM projects
• Training and support store operations
• Support 3PL interfacing SAP
• Mapping | testing | documentation | legacy Oracle MDO to SAP pricing module

Montreal, Quebec, CA

• RETEK Support and training users
• RETEK administration in configuring new store openings | creating new price zones | creating new departments/class/subclass
• Deploy new projects to improve business process where I have completed 10 projects
• Cross functional analysis
• Collaborate with Change Management team and documenting new business processes
• Accomplishments include

Montreal, Quebec, CA

• Analyzed sale trends to recommend repeat orders to maximize sales
• Allocation and distribution of new and repeat merchandise to stores
• Managed warehouse through stock allocation and replenishment
• Managed store inventory through store to store recalls and / or store to warehouse recalls
• Collaborated with the Planning team to maintain markdowns and promotion