David Lam Email and Phone Number
David Lam work email
- Valid
David Lam personal email
- Valid
I am a Senior Business Analyst with over 15 years of retail experience, specializing in ERP implementations, business unit support, data extraction for reporting, and continuous process improvement. I am driven by a commitment to self-growth, inspiring my team, and enhancing business processes to foster both individual and company-wide success.Passionate about understanding how businesses evolve through technology and system enhancements, I bring value to any organization through my expertise in inventory accuracy and system optimization. My experience includes in-depth knowledge of Oracle, SAP, and OMS systems, along with a strong understanding of relational databases and advanced SQL scripting. I have a comprehensive view of business flow, from product creation and supply chain management to store operations.I am career-driven and consistently challenge myself to stay ahead by learning cutting-edge technologies. This allows me to support IT teams and align them with business needs, driving growth and innovation across the organization.
Psycho Bunny
View- Website:
- psychobunny.com
- Employees:
- 675
-
Sr. Business System Analyst : Amazon AthenaPsycho BunnyMontreal, Qc, Ca
-
Sr. Business System Analyst : DeposcoPsycho Bunny Nov 2022 - PresentMontreal, Quebec, CaInventory 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 Snowflake.To ensure data integrity: • 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.
-
Sr. Business System Analyst : SnowflakePsycho Bunny Nov 2022 - PresentMontreal, Quebec, CaSnowflake 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 integrity and identifying problematic transactions.With in-depth knowledge of Psycho Bunny’s ecosystem, I effectively analyze data to: • 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.
-
Sr. Business System Analyst : RetalonPsycho Bunny Oct 2022 - PresentMontreal, Quebec, CaRole 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 levels for each store and optimize overall inventory management.Accomplishments: • 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.
-
Sr. Business System Analyst : Fluent OmsPsycho Bunny Aug 2022 - PresentMontreal, Quebec, CaIn 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 identify inventory issues effectively and guide our support team in resolving these challenges to maintain high inventory accuracy.
-
It Analyst : InventoryThe Avon Company Canada Limited Apr 2022 - Jun 2022Pointe-Claire, Quebec, CaInventory reconciliation analysis to correct and fix interface timing issues between WMS feed to E1 financial system -
It Analyst : Rpm Email SoftwareThe Avon Company Canada Limited Feb 2022 - Jun 2022Pointe-Claire, Quebec, CaSetup promotional content in HTML, write a SQL query to extract sales reps tiers and distribute the message to their inbox
-
It Analyst : Companion PlusThe Avon Company Canada Limited Nov 2021 - Jun 2022Pointe-Claire, Quebec, CaImprove order management process. Documenting new features for change management. Collaboration with customer service for consumer insight for functional improvement
-
It Analyst : Sap AnalystThe Avon Company Canada Limited Apr 2021 - Dec 2021Pointe-Claire, Quebec, CaDirect to Consumer concepts. Order management with WMS. Promotion timeline. PLM interface resolution
-
Senior Business AnalystJesta I.S. Sep 2019 - Apr 2020Montreal, Quebec, CaTechnical 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. Competency is Vision's module in :• Inventory movement • PO management • Price management • Cycle Counts • Allocation / Distribution • Replenishment using industry forecasting methods • Legacy interfacing WMS and POS with the Vision SuiteCreating test scripts to avoid potential process gaps and accurately defining system processes to ensure the client has a clear understanding of all the project’s requirements. Shaping relationships with developers and other team members to find new solutions to help better manage complex processes and improve data governance. -
Business Analyst | Sap Implantation | Fiori Mobile App SupportAldo Group Sep 2016 - May 2019Montreal, 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 -
Senior Business Analyst | Erp Oracle Retek | Support | Administration | Data AnalyticsAldo Group Aug 2008 - May 2019Montreal, 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 • interfaced new consignment partners to expand sales • expansion Aldo's web site to European markets to reach a wider audience • Interfaced new 3PL Bleckmann in European sector to reduce cost and faster delivery • Interfaced 3PL New York Hub to improve logistics and delivery time • Launch of Aldo Gift Cards program through e-com • Improve replenishment to better forecast inventory levels at retail stores • Add new business rules and new price zones for Oracle MDO (Oracle Markdown Optimization) to improve pricing suggestions
-
Distibutor Aldo Us And Uk DivisionAldo Group Aug 2006 - Aug 2008Montreal, 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
David Lam Skills
David Lam Education Details
-
Mcgill UniversityComputer Science
Frequently Asked Questions about David Lam
What company does David Lam work for?
David Lam works for Psycho Bunny
What is David Lam's role at the current company?
David Lam's current role is Sr. Business System Analyst : Amazon Athena.
What is David Lam's email address?
David Lam's email address is da****@****ail.com
What schools did David Lam attend?
David Lam attended Mcgill University.
What skills is David Lam known for?
David Lam has skills like Inventory Management, Sql, Retail, Business Analysis, Merchandising, Requirements Analysis, Team Leadership, Quality Assurance, Markdown Management, Integration, Technical Assistance, Markdown Optimization.
Who are David Lam's colleagues?
David Lam's colleagues are Sean Boothe, Jayde Souza, Angely Vazquez, Omar Silva, Sébastien Darche, April Shotwell, Will Clary.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial