Juan David Suárez Díaz Analista de marketing comercial

Commercial Market Intelligence Analyst

Stanley Black & Decker, Inc.

Sep 2021 - Current (5 years 1 month)

- Developed a Power BI dashboard using SQL for data modeling and DAX for data visualization and manipulation, monitoring trends for over 20 clients
- Streamlined manual processes by creating 5 Alteryx workflows, 2 VBA macros, and 1 Python script, resulting in a time-saving of over 50%
- Conducted monthly and weekly data cleansing for more than 20 clients utilizing Excel, VBA, and Alteryx to ensure data accuracy and consistency.

Trade Marketing Analysis Team Leader

Solvo Global

May 2021 - Aug 2021 (4 months)

Direct employment through Solvo Global with the company Prime Meats of Duluth, Georgia, USA.

- Produced 10+ sales reports (e.g., clients retention, product coverage, sales goals) using MicroStrategy, Excel, Google Sheets, and PBI
- Streamlined reporting processes with 3 Google Sheets report automations through Google Apps Script
- Led and mentored a team of 2 data analysts, providing guidance and instruction in data analysis and visualization techniques.

Sales Data Analyst

Solvo Global

Dec 2020 - Apr 2021 (5 months)

Business Intelligence Projects Team Member

Trascender Global

Jul 2020 - Apr 2021 (10 months)

- Realization of Business Intelligence projects, using knowledge in Google Sheets, VBA, SQL, MS Access, Power BI, Google Data Studio and Tableau.
- Sales of projects to foreign companies (USA, ENG, etc.)
- Working as a freelancer

Marketing B2C National Director

AIESEC en Guatemala

Jun 2019 - Jul 2020 (1 year 2 months)

- Responsible for managing the brand of the AIESEC organization at an external level.
- Lead a network of volunteers oriented towards inter-institutional relations with universities in Guatemala and youth-oriented marketing, generating spaces for positioning and projects in conjunction with these institutions.
- Creation of digital strategy for AIESEC social networks in Guatemala (Facebook and Instagram)
- Community Management (Facebook, and Instagram).
- Evaluation and analysis of digital metrics of social networks and website of AIESEC in Guatemala.
- Provide sessions as a facilitator to volunteer members and students outside the organization based on the AIESEC leadership development model.

Platf

I

Administrative assistant

Ingenio Destreza Mental

Feb 2019 - Jun 2019 (5 months)

- Financial transaction record keeping
- Support in generating social media content
- Search for new clients
- Following up with partners
- Logistic support

Juan David Suárez Díaz

About

Detail

Timeline

Résumé

Juan David Suárez Díaz

About

Detail

Behavioral traits