•

• Generate daily, weekly and monthly executive reporting package, validate the data, provide any potential strategies to improve the profitability for the business• Develop and build metrics data, key performance indicators, and reports to measure performance, forecast and provide recommendations that drive business improvements• Extract, convert and transform financial data from different sources using IMS, SAS, MS Access and Excel, develop ad-hoc reports and deliver the results according to the client’s requirements• Automate template using VBA programs, participate in business process re-engineering and implement business cases with tight timelines• Bridge the gap between business and IT, ensuring business requirements are interpreted correctly by developers through user friendly interfaces or straightforward reports• Review detailed design deliverables to ensure fulfillment of requirements, conduct user acceptance testing, manage requirement changes via established change control processes

• Extracted, manipulated and analyzed financial data from PeopleSoft, Access, flat files and other sources; translated the complex models into the easy understandable spreadsheets, reports and charts; prepared the corresponding PowerPoint presentation for the internal and external stakeholders • Conducted the economic analysis for daily sales, estimated and adjust freight expenses for shipping couriers, provided suggestions for senior management group, and minimized the cost for Sears Canada Inc.• Created, documented and maintained master files for vendors, carriers and customers, updated the delivery schedules for all the retail stores and catalogue agents• Generated journal entries and posted charges to PeopleSoft system, reconciled the freight account, verified duplicates and discrepant payments• Liaised with logistics organization, buying teams, stores, service providers and other business partners to investigate outstanding issues and highlighted opportunities for improvement• Utilized PeopleSoft and Essbase databases to retrieve the financial reports for the regional managers, followed up on the inaccurate charges and post adjustments

• Provided and reviewed financial report by the Cognos system for more than 50 carriers, monitored the status of orders to prevent delays in processing customer orders, tracked KPIs for all carriers • Analyzed the freight reports, answered internal and external customer inquiries, investigated and followed up on outstanding invoices and credit notes • Forecasted the freight charges and targets by using Access database, reviewed of customer sales patterns, implemented and coded invoices for the inbound and outbound freight loads• Optimized operation of the logistics department using Excel spreadsheets to process invoices, retrieved and prepared the billing invoices from PeopleSoft system for Wal-Mart, Loblaw’s and other retail customers• Prioritized the rush loads for all business partners, tracked the status of the loads and investigated reasons for delays and highlighted opportunities for improvement• Provided the month-end and year-end financial reports, coordinated with accounts payable and accounts receivable departments to make payment decisions