Ray Leung Email & Phone Number

Toronto, Canada Area

Responsible for Profitability Reporting/Financial cost models building for Bell Wireline business including SMB, Enterprise and residential business by using data analytics. implementation of new cost allocation in SAP BPC• Developed and maintained financial cost models, ensuring they accurately allocate costs to various product levels within the company.• Spearheaded the delivery of Activity-based reports to identify and recovery of costs to ensure profitability.• Developed, maintained, and completed analysis of various financial cost models. Using SAS, SQL, POWER BI, Teradata to analyse operational data for building financial drivers to feed in the expense cost model.• Reported monthly on Profit and Loss for all Business units.• Facilitated enhancement of reporting processes and resolution of business hurdles for product managers, Sales, and Finance teams. Delivered comprehensive gross margin analysis by product categories, integrating operational expenses for previously unavailable insights

Toronto, Ontario, Canada

Oversaw the preparation of monthly results reports, prepared revenue and expense journal entries for revenue recognition and ensured accurate matching of expenses to bill revenue for Bell Enterprise Product Business.• Interfaced with Supply Chain, Purchasing and Product Management to track and analyze vendor rebates.• Managed portfolio analysis to ensure COGS align properly with revenues and produced Journal entries.• Produced month-end deck for executive for Enterprise Gateways portfolio includes explanation of forecast/budget variances.• Collaborated with the Operations Team to assess potential risks that could impact operational efficiency, financial performance, as well as to identify opportunities for improvement within operational processes.• Worked closely with Supply chain, Purchasing team for forecasting and budgeting to ensure that the organization has accurate projections and plans in place to meet future demands

Mississauga, Ontario, Canada

Fulfilled both Business Analyst and Project Management functions for the implementation and ongoing maintenance/support of the Clarity Financial Reporting System for Bell SMB Business. Provided leadership on this project for integration new features and system performance management and improvement. Liaised extensively with the vendor to ensure that project benchmarks were on time and on budget. 2 Bell Finance excellence awards were granted. • Administered and managed security controls created reports and templates and developed and delivered user training.• Acted as Project Manager to implement Clarity system, continuously integrating new features and functions in the reporting system and maintained user and security profiles.• Supported end users and Developer to improve performance and reliability of the system.• Performed data testing, validation and reconciliation throughout month-end cycles for quality assurance purposes• Documented key business processes for Standardization, Training , Knowledge and Performance Monitoring and Improvement

Mississauga, Ontario, Canada

Improved analysis and enhanced customer-level profitability by utilizing extensive business and SAP knowledge.• Provided data analysis support to management for revenue forecast. • Reviewed COGS to correct issues that negatively impact results, and prepared journal entries on COGS accruals.• Issued monthly revenue reports highlighting respective portfolios to Product Management.• Performed Inventory forecast, annual budgeting and month-end reporting. • Assessed aged inventory balances and took remedial action to mitigate impacts. Maintained Gateways SQL database

Toronto, Canada Area

Productivity Management/Process Improvement/Data Analysis, 2004 - 2006• Liaised with Productivity Consultant to improve productivity of field forces. Enhanced Technician dispatch process.• Developed Employee Coaching Tool for tracking performance of entire Bell Canada field forces Reporting, Data Analysis, 2001 - 2004• Designed, and analyzed statistical reports on Provisioning, Repair Performance, profitability and productivity using SAS, SQL, SAP BI/BW and MS Access.• Managed staff to generate reports and client relationships• Created and maintained internal web page and web application for management/department use.• Performed monthly and weekly field performance reports and analyzed results to provide recommendations.

Toronto, Ontario, Canada

• Provided timely data to Production Manager to support business decisions. Monitored company performance.• Assisted with the preparation of profitability analysis for each national vender, including post audit analysis.• Created Margin Report for all branches using database reporting tool (Business Objects)

Toronto, Ontario, Canada

• Provided data management and analysis services to this software vendor.