Juan Sebastian Gonzalez Mallarino

Juan Sebastian Gonzalez Mallarino

About

Detail

Mercadeo y Negocios Internacionales
Valle del Cauca, Colombia
Contact Juan regarding: 
work
Full-time jobs
Starting at USD1.5K/month
Flexible work
Starting at USD10/hour

Timeline

work
Job
school
Education
auto_stories
Publication

Résumé

Jobs verified_user 0% verified
  • T
    Business Insights Analyst
    TaskUs Colombia SAS
    Jan 2022 - Dec 2023 (2 years)
    • Partner up with Operations Managers and client's stakeholders to understand their data ecosystem and business needs to develop BI solutions aimed at keeping track of their business performance with up-to date data. • Work in liaison with the data engineering team to extract data from multiple sources (Talkdesk, Freshdesk, Salesforce, Google Sheets) and support the data automation pipeline using tools such PostgreSQL, native queries, and Power Query. • Develop dashboards in Power BI (data visualization), using Power Query, M code and DAX to account for Key Performance Indicators aimed to gauge customer satisfaction and employee productivity. • Provide Business Insights and recommendations based on findings from descriptive statistical a
  • M
    Financial Analyst
    Medov Logistics
    Nov 2020 - Jan 2022 (1 year 3 months)
    • Evaluate operational processes to design the implementation of Key Performance Indicators aimed to gauge overall productivity and reflect the current financial state of the business. • Support the data automation pipeline using Power Query to develop dashboards in Excel and Tableau to report critical Key Performance Indicators over to the CEO and management team. • Perform sales and budget forecasts using time series models. (Predictive Analytics). • Develop financial statements and productivity reports using BI tools like Excel and Tableau to keep track of the amount of accrued income as well as accounts receivable.
  • Foundever
    Customer Service Supervisor (Coach)
    Foundever
    Oct 2018 - Nov 2020 (2 years 2 months)
    • Develop dashboards in Excel to keep track of the teammate's performance and apply data analysis techniques to determine impact and prioritize coaching strategies accordingly. • Lead and coach a team of 20 collaborators to improve their customer service skills based on project management techniques such as SMART methodology and root cause analysis.
  • D
    Sales Support
    DSV
    Oct 2017 - Oct 2018 (1 year 1 month)
    Marketing and Sales Department DSV Global Transports and Logistics • Analyze databases of potential customers to develop telemarketing and sales strategies. • Perform benchmarking analysis across market competitors to generate strategies aimed at driving sales performance as well as SWOT analysis. • Quote international freight shipments and promote the logistics and supply chain services offered by the company. • Coordinate the pickup, delivery, and customs documentation of international freights (Ocean and Air). • Develop Sales Reports to management in a monthly and quarterly basis to review business performance.
Education verified_user 0% verified
  • Universidad Autónoma de Occidente
    Postgraduate Specialization in Business Intelligence
    Universidad Autónoma de Occidente
    Jan 2020 - Jan 2021 (1 year 1 month)
  • U
    B.Sc. Marketing and International Business
    Universidad Autónoma de Occidente.
    Jan 2012 - Jan 2018 (6 years 1 month)
Publications verified_user 0% verified