Mary Margaret Guzman Email & Phone Number

Metro Manila, Philippines

Create data visualizations, reports and analyses using SQL, BigQuery, Looker Studio and Python to support multiple functions including Operations, Business Development, Customer Service, CRM and Finance.

Created and maintained dashboards and reports using Tableau and Excel to report Key Performance Indicators for the English Flights team, including the Manila, Cairo, and Edinburgh sites.

Developed forecasting models for target setting of order movement of Shopee’s campaign sales. Analyzed booking, pickup, and delivery behaviors to inform targets and identify improvements and trends.

Handled the logistics concerns of Shopee's managed sellers and coordinated with different departments including Operations, Customer Service and Product teams to ensure timely resolutions to concerns.

Conducted process documentation and process mapping of the company’s Sales and Marketing Function including existing procedures, policies and forms and provided areas for future process improvements.

Conducted process analysis of the payment process specifically for Key Accounts and identified improvements for implementation.

Suggested improvements on the product costing process of the company through conducting a time study and created templates for easier use of the suggested product costing process.

Conducted process mapping and analysis of a sales force automation tool and identified improvements for implementation using Lean Methodology.

Bachelor'S Degree, Industrial Engineering

Highschool Diploma