Developed strong analytical and problem-solving skills in fast-paced marketing environment. Skilled in data analysis, visualization, and translating complex data into actionable insights. Seeking to transition into new field, leveraging transferable skills to add value and drive success.
Overview
11
11
years of professional experience
Work History
Marketing Data Analyst
Ibex Global Solutions Philippines Inc.
02.2022 - Current
Get hands-on with data within SFDC and Marketo to analyze data quality improvement opportunities
Build and refine segmentation that supports marketing teams on go-to-market activities
Perform research to ensure routing accuracy and lead disposition
Support ad-hoc Marketing Operations projects
Oversee day-to-day campaign execution and initiatives
Examine results and implement improvements
Managing incoming operations requests and changes to ticket queue
Assist and facilitate webinar production to ensure consistent quality and customer experience
Support Revenue, Partner, and Field Marketing teams to execute go-to-market campaigns, audience targeting, list segmentation, and list upload
Work within the Marketing Ops teams to identify and prioritize touchpoints and attributes that support audience segmentation, campaign activation, and measurement
Database Lead
Coca-Cola Beverages Philippines Inc.
09.2019 - 01.2021
Overseeing Database Administration Activity
Provides Database analyses necessary to support local and support center initiatives
Ensure smooth implementation of Database related Projects (i.e clean up, all outlets survey)
Ensuring integrity and accuracy of the Database
Assist Presellers with PACE concerns (i.e updating of SCLs)
Daily checking of PACE (SCL update, configurations, settings)
Escalate the issue to IT for resolution
Job Description: Database Lead
Database Management
Admin for PACE Tool (for assigned Area)
Database Administrator
Coca-Cola FEMSA Philippines
09.2016 - 01.2019
Ensure the integrity and completeness of data by creating/following standard work processes and assuring the implementation of these RTM processes
Perform data maintenance to ensure the information mapping in the databases and portals is100% matched and accurate
Responsible for the maintenance of BASDEV Outlet Universe (OM01, SCL, OM06), Personnel Mapping (RS02/OM16) in BASDEV
Responsible for maintaining the Mobile SCL Portal and SFA Portal for all Pre-seller routes under the Malabon DC West GMA region
Responsible for the maintenance of the Onelink Customer Database (SAP)
Generate reports to assess the performance of RTM Operations and provide information for Strategic Route Planning and other Region Offices
Extract OM01 and OM06 on the first day of the period to have a final count of the previous period’s BASDEV Outlet Universe count
Extract SAP, OM01, OM06, OM16 and RS02 Master List on a weekly basis
Generate newly opened outlets status daily to be provided to the RTM Engineers, RTM Team Leads, and the Commercial and Planning Group
This report is used to fast-track new outlets’ approval and address the aging BASDEV issues
Generate and Analyze reports from Margin Minder and Business Intelligence to determine the current status of the database and if there are any data inconsistencies
Pre Seller Representative
Coca-Cola FEMSA Philippines
10.2013 - 01.2016
Prospect potential customers and win competition including exclusive outlets; Identify business conditions, strategies and actions of competitors; Negotiate with outlets on agreements / contracts (OP) and trade terms based on the value proposal e.g
Credit, discount, promotion, bundles, outlet decoration / makeover; Execute and follow-up on KPIs such as sales, volume and availability; Develop new categories in gold clients; Guarantee the execution of the PicOS elements, price and availability; Register work orders e.g
Master data update and cold drink equipment requests; Perform administrative services such as data maintenance, survey and asset control; Conduct in-store check on inventory; Ensure sell-in of suggested order quantity per SKU (portfolio compliance); Perform the price promotions in order to increase sales; Ensure order taking in all outlets; Ensure transmission of order or sinking process for delivery; Perform returns / exchange of products, when Sales Manager authorizes; Ensure deployment and utilization of merchandising materials in outlet; Execute merchandising on promotions and cold drink equipment as per PicOS
Train outlet owners on achieving PicOS e.g
Maintenance of cold drink equipment prices, image, etc.; Ensure smooth interactions and hand-off with other internal functions e.g
Follow-up on work orders
Improved customer satisfaction by providing product knowledge and recommending appropriate solutions.
Education
Bachelor of Science - Information Technology
Bulacan State University
City of Malolos, Bulacan
03.2013
Skills
Database: SAP
Software: Marketo, Salesforce, Excel, Powerpoint
Platform: Microsoft Office
Digital marketing strategy
Data-driven decision making
Customer segmentation
References
Noel, Vergara, Regional Sales Manager, +639190878410, Coca-Cola Beverages Philippines Inc.
Divina Gracia, Espiritu, Planning Information Analyst, +639190876702, Coca-Cola Bottlers Philippines Inc.
Veronica Aungon, Business Solutions and Devops Manager, +690688571309, Manila Multipurpose Terminal
Timeline
Marketing Data Analyst
Ibex Global Solutions Philippines Inc.
02.2022 - Current
Database Lead
Coca-Cola Beverages Philippines Inc.
09.2019 - 01.2021
Database Administrator
Coca-Cola FEMSA Philippines
09.2016 - 01.2019
Pre Seller Representative
Coca-Cola FEMSA Philippines
10.2013 - 01.2016
Bachelor of Science - Information Technology
Bulacan State University
Similar Profiles
Carla Maria V. LegaspiCarla Maria V. Legaspi
Operations Manager at Ibex Global Solutions Philippines, Inc.Operations Manager at Ibex Global Solutions Philippines, Inc.