• Authored Business/Functional Requirements Document on EDI Flow from limited documentations• Worked with clients to identify business rules applied on EDI • Analyzed different vendor types and created a master vendor list with updated Vendor ID and ISA/GS ID in mySQL• Coordinated Vendors Questionnaire/Setup Forms to make sure all vendors are connected to GXS Opentext• Created mapping for EDI 850, 860 and 856 Standard to AS400 data fields between EDI and flat file… Show more • Authored Business/Functional Requirements Document on EDI Flow from limited documentations• Worked with clients to identify business rules applied on EDI • Analyzed different vendor types and created a master vendor list with updated Vendor ID and ISA/GS ID in mySQL• Coordinated Vendors Questionnaire/Setup Forms to make sure all vendors are connected to GXS Opentext• Created mapping for EDI 850, 860 and 856 Standard to AS400 data fields between EDI and flat file formats• Provided guidance to developers to make sure coding is correctly fitted to the business and functional requirements• Performed QA tests in Azure with client’s sign-off approval prior to deploying to production• Investigated, worked with developers and communicated with EDI trading partners to solve problems when EDI transmission issues come up Show less

• Analyzed size, dimension, frequency, inventory for parts and accessories by a methodology to assign new location in order to fully maximize the occupancy of planogram in the new warehouse• Created SQL reports in Access to facilitate the District Managers to generate sales comparison between dealer regular purchase with seasonal booking• Created new product, updated and maintained web page for parts and accessories in Suzuki.ca website.

• Compiled daily sales data from Hudson's Bay system and imported to Excel format and sorted by Store/Provinces/Account Executives comparing them to last year’s sales and current sales plan• Daily analyzed EDI PO transmitted by department stores and comparing the quantity ordered with our warehouse inventory & eliminated wrong/excess products • Monitored product line assortment for HBC, Sears, Sephora, Holt Renfrew and Nordstrom Department stores for over 500 cosmetic and skincare… Show more • Compiled daily sales data from Hudson's Bay system and imported to Excel format and sorted by Store/Provinces/Account Executives comparing them to last year’s sales and current sales plan• Daily analyzed EDI PO transmitted by department stores and comparing the quantity ordered with our warehouse inventory & eliminated wrong/excess products • Monitored product line assortment for HBC, Sears, Sephora, Holt Renfrew and Nordstrom Department stores for over 500 cosmetic and skincare products, based on their yearly sales achievement suggested to incorporate in the main line of products• Analyzed sales history by similar product types in every season to forecast the sales plan and allocation by store• Created allocation & shipment date worksheet for each new product in each season to send to Department Store Buyer Office• Monitored promotional sales or events and ranked by stores and by Account Executives• Supported 16 Account Executives by solving their problems or inquiries in sales plan, store inventory and shipping information• Forecasted seasonal returns and projected the net sales• Calculated the quarterly rebates for independent retail stores• Communicated closely with Logistics for any shipping issues• Set up new SKU information in different department store system to make sure the product information and dimension is correct Show less

Extensively used ODBC for data mining through AS400 SCI Supply Chain System & SQL• Created Daily Wholesale, Retail & Inventory data analysis system for each dealer up-to-date and past few years’ sales history for 10 District Sales Managers daily use resulted in better sales support & communication with dealers• Generated Daily Sale Report for inventory & production control; Daily Availability Report for 10 District Sales Managers to get quick snapshot on model availability from current… Show more Extensively used ODBC for data mining through AS400 SCI Supply Chain System & SQL• Created Daily Wholesale, Retail & Inventory data analysis system for each dealer up-to-date and past few years’ sales history for 10 District Sales Managers daily use resulted in better sales support & communication with dealers• Generated Daily Sale Report for inventory & production control; Daily Availability Report for 10 District Sales Managers to get quick snapshot on model availability from current to next few months• Gathered dealer financial data daily from GE Financial downloaded to AS400 through EDI & manipulated with SCI dealer inventory to run a Dealer Compliance report for Finance Manager for risk management • Gathered monthly Extended Warranty data from CoverageOne company to combine with dealer retail data for calculating retail promotion• Gathered monthly market sale data from MMIC reports by using VBA macros to manipulate with Suzuki sale data to compare with different brands in the market by model categories for National Manager reporting to the President • Assisted Sales Manager in providing accurate analysis on old models in dealer inventory to drive retail sales.• Ran & modified different query sets for month end rebates & co-op marketing report for Accounting Department to pay out to dealer accounts• Developed, maintained & monitored wholesale booking system to provide an accurate instant calculation on new model productions & potential promotion levels, etc in Excel format with macro formulas and be uploaded to Supply Chain System• Provided technical support to Sales team and District Managers in using desktop applications and ordering system• Investigated & solved problems for enquiries from dealer or District Sales Managers on rebate credits issues or unit availability• Provided ad hoc reports to internal staffs and external dealerships in the areas of warranty contracts, financial services and parts services Show less

* Monitored project progress in the stages of development, integration and implementation & reported weekly status by using MS Project (advanced level on collaborating multiple projects)* Collected documentation, software & hardware inventory into IT Repository Database* Developed & updated Intranet for IT & HR departments* Facilitated weekly project meeting with Project Managers

Developed & implemented HR Time & Attendance System, Levi’s Product Availability System and Product Master System.