LE CECILE CHARISSA G A N T U A N G C O
DATA ANALYST
Cebu City, Philippines
-
-
WORK EXPERIENCE
Marketing/Data Analyst
Jul 2012 - Feb 2020
Upwork - REMOTE
Generated reports on Salesforce and Excel to conduct trend analysis for social media content, identifying niches to
optimize organic reach
Developed tables, views, and materialized views using SQL.
Created and deployed a mobile KPI reporting package through Tableau focusing on daily performance trends, forecasted
metrics, and actuals vs, budget
Established the organization's first “Request for Refund” process for those fulfilled products with incorrect FBA
measurements in Amazon – which resulted in an accumulated over $1000 in refunds for the first time in company history
Utilized CRM platforms including Salesforce and Hubspot to service 500+ clients daily, working with the sales team to
identify pain points and marketing opportunities for success stories.
Marketing Analyst Supervisor
Apr 2012 - Sep 2014
AUTHOR SOLUTIONS PH - Cebu City, Philippines
Conceptualized initiative that significantly enhanced and standardized reporting and cut 33+ hours from regular reporting
cycles
Collaborated with the Brand Manager Marketing Analysis in business development research & development of a
companywide promotional strategy
Presented with the senior leadership group on a weekly basis the KPIs, and current financial standings, and provided
insights on actionable solutions
Supervised marketing analyst(s) and supported them ensuring the accuracy of data and deliverables of reporting with
comprehensive policies and processes.
Led projects and analyzed data to identify opportunities for improvement.
Sr. Marketing Analyst
Feb 2011 - Apr 2012
AUTHOR SOLUTIONS PH - Cebu City, Philippines
Performed all aspects of marketing consulting using marketing mix modeling, including data collection and cleansing,
statistical analysis and modeling, interpretation of results, and presentation to Senior Executives in operations
Analyzed data, created summary reporting, and performed analysis to support the decision-making of senior
management and other departments in the company
Reviewed the marketing department's monthly analysis of customer acquisition data and campaign performance and
made recommendations for improvement.
Supported Sales Team by assisting with accurate and timely generation of Daily, Weekly, Monthly, Quarterly, and Annual
reporting across all 9 brands.
Sr. Workforce Analyst
Mar 2007 - Feb 2010
TELETECH PHILIPPINES - Cebu City, Philippines
Developed, generated, and delivered reports containing accurate and timely statistical information on a daily (Daily
Staffing Report, Daily Ops Review Report), weekly (Net Staffing Analysis Report), and monthly basis (Minutes Validation) for
all programs
Maintained accurate data in reporting and tracking systems such as CenterPoint, Oracle HRMS (Human Resources
Management Systems), KRONOS, WFM, and CMS Supervisor
Generated schedules that closely match the workload of the program to ensure that the targeted service level is met and
achieved
Liaised with Operations Managers/Senior Operations Managers to ensure all program requirements were met.
EDUCATION
Bachelor Degree in Commerce Major in Management
Jun 2001 - Oct 2003
University of San Jose-Recoletos - Cebu City Philppines
SKILLSET
Microsoft Office (Excel, PowerPoint) | Google Analytics | Salesforce | HubSpot | Tableau | CRM | Analytical skills | Communication |
Python | Power BI | Trello | Asana | Canva | Planoly | Hootsuite | Wordpress.org | Google Spreadsheet | HTML | CSS