Le Cecile Charissa D. Gantuangco

Le Cecile Charissa D. Gantuangco

$15/hr
Data/Reporting Analyst
Reply rate:
100.0%
Availability:
Full-time (40 hrs/wk)
Location:
Cebu City, Cebu, Philippines
Experience:
15 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.