Andrea Camila Barón Ruiz Email & Phone Number

Bogotá, Bogota, Co

Bogota, D.C., Capital District, Colombia

• Developed 7 marketing campaigns to promote new services and products, resulting in a 75% increase in list size and a 35% increase in legacy customer acquisition through Google Ads campaigns.• Conducted in-depth analysis of large datasets to identify trends, patterns, and insights to support business objectives.• Collaborated closely with marketing teams to define KPIs and key metrics providing clear insights into campaign performance. Utilized PostgreSQL analytical functions to conduct trend analysis, audience segmentation, and return on investment (ROI) evaluation.• Created advanced data visualizations using tools such as Tableau and Matplotlib to effectively communicate findings to stakeholders.• Developed and implemented algorithms to clean, preprocess, and validate data for accuracy and completeness.• Utilized Tableau to communicate results and insights derived from data visualizations to a variety of audiences, from technical to non-technical. Focused on providing information clearly and comprehensibly, highlighting key conclusions and data-based recommendations to effectively support decision-making.• Transferred clients from the old platform to the new, increasing the site conversion rate by 38%.• By utilizing tiered promotional programs, we maximized incentives for consumers and increased the typical customer order value by 19%.• In the first 24 months, sales increased by over 53% and 28 new accounts were added.• By using Hootsuite Analytics and Google Analytics, we easily tracked the performance of all social media channel activity for our clients in one place.• Technologies used: Google Ads, Hootsuite Analytics, Google Analytics, PostgreSQL, Tableau, DV360, Google Tag Manager

Bogotá D.C. Area, Colombia

• Managed and optimized sales and marketing data, ensuring its accuracy and completeness.• Conducted comprehensive analysis and tracked sales performance to identify growth opportunities and improvements.• Prepared reports with summary tables, graphs, and diagrams to present valuable insights to stakeholders.• Led the creation and design of interactive dashboards in Tableau to visually present data in an attractive and accessible manner. Utilized various Tableau functionalities such as dynamic filters and parameters to allow users to explore data intuitively and personalizedly.• Collaborated on qualitative and quantitative workforce research, supporting human resources and talent management efforts.• Streamlined marketing processes using Salesforce and Pardot, resulting in increased efficiency and productivity.• Utilized Google Ads analytics tools to gather key data on campaign performance. Developed detailed reports highlighting essential metrics such as click-through rates (CTR), cost-per-click (CPC), and conversions. Additionally, used Google Analytics to obtain deeper insights into user behavior.• Assisted the Business Development department in data mining and proposal creation for potential clients.• Technologies used: Google Ads, Google Analytics, Tableau, Salesforce, Pardot, SQL.

Bogota

• Developed and implemented creative marketing campaigns across various marketing channels, including blogs, newsletters, print/digital media, and social media, resulting in increased traffic and sales for prominent client companies such as Alpina, Pfizer, Abbott, Johnson & Johnson, Unilever, and P&G.• Designed and developed interactive dashboards using Power BI, providing actionable insights for decision-making.• Collected, summarized, and analyzed market information and campaign performance, diligently tracking key metrics and return on investment (ROI) to optimize marketing initiatives.• Leveraged strategic alliances, public relations, and thought leadership opportunities to effectively promote the brand and establish valuable collaborations with other companies.• Used data analysis and market insights to support strategic decision-making and stay informed about industry trends and best practices.• Led and managed the optimization of campaigns in Google Ads, utilizing advanced strategies, segmentation, and ad creativity to maximize performance. Worked on identifying key keywords to enhance campaign visibility and efficiency.• Coordinated and prepared trade show events, round tables, and webinars, designing advertising and social media posts to enhance the brand's reputation and reach.• Designed and executed social media content across all channels to engage and expand the brand's online presence.• Technologies used: Google Ads, Google Analytics, PostgreSQL, Tableau, DV360

Bogota

• Assisted clients with inquires and resolving problems with billing and mortgage account• Delivered high levels of customer service to meet their needs, while enhancing the customer experience at Mortgage levelsAchievements• Improved customer service rates by 35%.• Improvement of communication channels with customers, reducing complaint rates by 54%.

Bogota, D.C., Capital District, Colombia

• Maintained records of personnel-related data (payroll, personal information, leaves, and turnover rates)• Assisted in ad-hoc HR projects such as collection of employee feedback.Achievements• Effective management of processes related to the area, management of personnel documentation, programming and integration of company events.

Postgraduate Degree, Logistics, Materials, And Supply Chain Management

Postgraduate Degree Marketing, Marketing/Marketing Management, General

Evaluation And Project Development

Bachelor Of Business Administration (B.B.A.), Business Administration And Management, General