Mohammed Muid Email & Phone Number

Calgary, Alberta, Canada

Calgary, Alberta, Canada

Calgary, Canada Area

• Volume allocations reporting, and gas chart quality assurance for production accountants. • Data mining and analysis, using MS Excel, for various projects • Built & optimized vendor data analysis template using complex MS Excel functions and VBA macros to automate it, saving 32-man hours• Performed variance analysis to determine cause of volume discrepancy leading to fewer revisions and greater efficiency• Initiated and implemented new solutions to upload gas analysis data saving 40 man hours in cooperation with IT and other departments• Carried out thorough investigation for high volume client to determine cause of data integrity errors and suggest solutions.• Prepared Gas Analysis presentation, manuals, and handouts for the team.

Calgary, Canada Area

• Month end labour time and cost variance analysis for cost controllers.• PO requisitions, code and approval of payments to vendors.• Audit vendor invoices to ensure accuracy and consistency in terms of hours and rates.• Provide prompt assistance on billing matters such as billing and invoice questions or disputes, payment activity, cancellation request and address changes etc.• Investigate problem transactions and resolve in co-operation with staff and vendors.• Provide assistance in the development of dashboards and database.

Calgary, Canada Area

• Analyzed vendors, transfers, shipments and related trends and other information for the benefit of Accounting Admins & stores. • Developed MS Excel based PO Volume & Cost Summary Dashboard in conjunction with Mark’s Business Improvement Team. • Successfully, coordinated efforts to resolve PO & ASN (EDI) related issues with Mark’s product category teams, IT, & vendor.• Developed Store-Trainer information lookup database for the supply chain department.• Managed Mark’s Store Receiving Application to ensure integrity of product sku information at store level and coordinated troubleshooting efforts.• Scripted & executed MS Access & Oracle SQL queries for the Material Accounting team to aid investigations.• Assisted Mark’s Accounts Payable team, at Canadian Tire, by investigating X-Dock AP related claims with the aid of JDA PMM (Enterprise & Forecasting Tool used by Marks).• Prepared detailed daily and weekly purchase order reports and communicated on a daily basis with vendors & internal stakeholders to obtain & transmit PO related information.• Explained Mark’s electronic shipment notice policy to new vendors, which includes instructions on filling out Mark’s MS Excel based (Manual Advanced Shipment Notice) MASN templates.

Calgary, Canada Area

• Analysed freight volume data and fuel tariff rates of CP Rail and its competitors on a weekly and monthly basis.• Analysed variance between sales target and actual sales of different product categories. • Upgraded the MS Excel & PowerPoint based AAR (American Association of Railways) weekly report for the yield management team.• Assisted the New CRM project team by building MS Excel based mass data import & update worksheet to import, update & upload relevant data from several different databases for the SAP based CRM.• Provided occasional support to the yield management team by working on small projects• Aided Common Track Network with their ETI project by managing the data collection, analysis, and reporting for all service areas within the rail network. • Mentored new team members & provided general guidance to the data analysis team for ETI project.• Developed basic flowcharts, process documents, classification documents, power point presentations and MS Excel data templates to aid the project team.• Corresponded with track inspectors, managers and yard masters to resolve all arising concerns and collect information, as well as edit yard and track network maps.