Juan Camilo Vieda Quintana

Contact- (Mobile)- www.linkedin.com/in/juan-camilovieda-quintana (LinkedIn) Top Skills Tableau Customer Service SQL Languages Inglés (Full Professional) Certifications Pensamiento Sistémico Google Data Analysis Gestión de las operaciones y mejoramiento continuo utilizando las 7 herramientas de la calidad Introduction to Programming Using Python EF SET English C1 Certificate Honors-Awards Beca Excelencia Académica Juan Camilo Vieda Quintana Data Analysis | Business Intelligence | Financial Analysis | Budgeting l Forecasting l Dashboard l SQL l Power BI l Tableau l Interpretation of results | ETL | Insights | KPIs Cali, Valle del Cauca, Colombia Summary I am an Analyst with more than four years of experience in the food industry. My focus has been on the analysis phase, where I have developed outstanding skills in collecting, interpreting and presenting crucial data for strategic decision making. My passion for unlocking valuable information from complex data sets and my ability to translate these findings into concrete actions have allowed me to bring significant impact to the companies I have collaborated with. As an experienced data analyst, I have developed strong competencies in generating and analyzing reports, both in sales and finance, crucial for strategic decision-making. My expertise extends to creating commercial and financial budgets, as well as productive and business planning. My focus also encompasses strategic planning for efficient order management and precise product costing. I excel in creating management indicators that enhance business strategies and contribute to achieving objectives. I leverage advanced analysis tools such as Excel, SQL, Tableau and Power BI, along with quality tools and KPIs, ensuring a comprehensive approach to my work. My goal is to optimize company operations through strategic data analysis and evidence-based solutions My goal is to develop my professional career in the improvement of business indicators through my capacity for abstraction, analysis and synthesis, being part of a company that allows me to apply all the knowledge and experience I have acquired so far, and to continue with my self-learning capacity to grow both personally and professionally. Experience Page 1 of 3 Condicol Co S.A.S Business Intelligence Analyst February 2022 - Present (2 years 2 months) Colombia Responsibilities: • Collecting, cleaning, organizing, and analyzing relevant data to discern business trends, patterns, and opportunities. • Utilize Power BI to design, develop, and maintain interactive and intuitive dashboards that showcase data trends, patterns, and anomalies. • Integrate data from various sources, ensuring accuracy, consistency, and relevance. • Implement best practices for data visualization, including effective use of charts, graphs, and other visual elements to enhance data storytelling. • Provided crucial insights to leadership teams, aiding strategic decisionmaking in marketing, sales, operations, and product development. • Identified opportunities where data optimization enhanced business processes, increased efficiency, and boosted profitability. • Established and monitored pertinent metrics to evaluate business performance, offering recommendations based on results. Achievements: • - Drove a 108% annual sales increase through data-driven strategies. • - Cut inventory turnover days by 50% using strategic inventory management. • - Implemented Excel matrices for efficient daily inventory reviews. • - Created impactful Power BI reports for enhanced decision-making. • - Crafted comprehensive business budgets for three consecutive years -). Productos la Tribu Calima S.A.S Business Process Analyst November 2019 - January 2022 (2 years 3 months) Cali, Valle del Cauca, Colombia Responsibilities: • Generated Production, Cost, Financial, and Cash Flow budgets for the Company's P&L. • Collaborated with stakeholders to comprehend business objectives and gather, document, and prioritize business requirements within the Citi implementation framework for Power Users • Analyzed financial indicators within the Company's value chain to optimize processes. Page 2 of 3 • Analyzed current business use cases and workflows, pinpointing areas for enhancement and optimization. • Reviewed and enhanced the product costing process to improve accuracy and efficiency. • Acted as a liaison between business units and technical teams, ensuring a shared understanding of project goals and deliverables. • Monitored and reported on project progress, proactively identifying and mitigating risks and issues as they arose. • Developed P&L statements for each sales channel to track performance. • Analyzed and reported on sales performance across all channels. • Automated comprehensive company performance reports through advanced Excel matrices, optimizing key indicators and analytics workflows. Achievemnts: • Led a project resulting in a 50% increase in plant productivity. • Reduced financial discrepancies by 40% through the implementation of enhanced reporting methodologies. • Reduced salesperson breakdowns by 50% • Streamlined financial forecasting processes, resulting in a 30% increase in accuracy. • Achieved a 500% increase in exports. • Implemented accurate product cost analysis. Education Universidad Autónoma de Occidente Bachelor of Business Administration - BBA, Administración y gestión de empresas, general · (June 2018 - May 2023) Page 3 of 3