J
Juan David Su谩rez D铆az
About
Detail
Data into decisions 馃搱 | Power BI | Machine Learning | Alteryx
Antioquia, Colombia
Contact Juan regarding:
work
Full-time jobs
R茅sum茅
Jobs
verified_user
0% verified
Commercial Intelligence AnalystStanley Black & Decker, Inc.Nov 2023 - Current (2 years 11 months)- Developed more than 5 dashboards in Power BI for monitoring customer sales and the customer rewards system. - Co-developed and optimized a SARIMA forecast model in Python to predict POS sales - Created a VBA macro to automate the process of sending reports via email. - Performed daily, weekly, and monthly updates for over 10 Power BI sales dashboards.- Data Quality AnalystStanley Black & Decker, Inc.Sep 2021 - Nov 2023 (2 years 3 months)- 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.
- Team Lead, Sales AnalyticsSolvo Global CareersMay 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 AnalystSolvo Global CareersDec 2020 - Apr 2021 (5 months)
- TBusiness Intelligence Projects Team MemberT-GencyJul 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 DirectorAIESEC en GuatemalaJun 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. Platforms or programs used: Mailchimp, Adobe Il
- AAdministrative assistantFeb 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
Education
verified_user
0% verified
- M谩ster, Data Science y Big Data, URL: https://accounts.iebschool.com/mi-diploma/bc48ebe68f7c45c13e273dccdb73040f/IEBS Business SchoolJan 2023 - Jan 2024 (1 year 1 month)
- Diplomatura, Marketing digitalUniversidad Pontificia BolivarianaJan 2016
- Grado en Administraci贸n y Direcci贸n de Empresas, Administraci贸n y gesti贸n de empresas, generalUniversidad Pontificia BolivarianaJan 2014 - Jan 2018 (4 years 1 month)