Alberto Mario Chamorro Pacheco

Alberto Mario Chamorro Pacheco  new_releases

About

Detail

Data Analyst / Analytics Engineer
Colombia
Contact Alberto regarding: 
groups
Networking

Timeline

work
Job
school
Education
folder
Project

Résumé

Jobs verified_user 25% verified
  • Lean Tech
    Sr Data Analyst public Remote experience
    Lean Tech
    Jan 2026 - Current (5 months)
    ● Architected and automated end-to-end reporting ecosystems within Snowflake, utilizing scheduled SQL tasks and Python to provide real-time visibility into Linehaul Analytics and global goods transportation. ● Optimized Snowflake warehouse performance by implementing data archiving strategies and re-engineering table schemas, resulting in a 30% reduction in query runtimes. ● Optimized supply chain financial health by developing interactive dashboards tracking COGS and Revenue Impact, enabling executive leadership to identify and mitigate cost leakages. ● Led data infrastructure improvements by migrating legacy datasets into optimized table structures, ensuring scalability and faster data retrieval for critical COGS AND Revenue impact Ana
  • Atlantic Talent Services
    Sr. System Analyst verified_user Verified experience public Remote experience
    Atlantic Talent Services
    Jul 2022 - Dec 2025 (3 years 6 months)
    • Collects, cleans, and transforms raw data from various sources into structured datasets for analysis, utilizing SQL, Python (Pandas, PySpark), and Excel. • Performs thorough data analysis using statistical techniques to identify patterns and trends, leveraging strong data manipulation skills in Snowflake and PostgreSQL. • Collaborates with developers and stakeholders to understand business requirements, providing data-driven recommendations to satisfy expectations. • Applies familiarity with data modeling, data warehousing, and database management systems to manage and query large datasets effectively. • Consumes datasets from diverse sources including APIs, ETL workflows, databases, and web scraping processes to support analytica
  • Teleperformance Colombia
    Workforce Analyst public Remote experience
    Teleperformance Colombia
    Aug 2021 - Jul 2022 (1 year)
    • Collected and analyzed staff performance and customer feedback data based on Agile Scrum methodology to identify opportunities for process improvements. • Developed complex, easy-to-understand Excel reports to monitor and track key performance indicators (KPIs). • Prepared and presented workforce analysis reports for company leadership, translating complex data into actionable insights to inform policies and strategic decision-making. Additionally, utilized SQL skills to generate real-time monitoring reports, tracking agent states, queues, and service level agreements (SLAs). This capability enabled the quick detection of issues such as spikes in call volume, long wait times, and abandoned calls, further enhancing our operational effi
  • Coremar Group
    QA profesional
    Coremar Group
    Jan 2021 - Jul 2021 (7 months)
    • Managed and analyzed data resources using Excel to generate reports that clarified and supported action plans for improving business processes based on third-party needs.
Education verified_user 0% verified
  • C
    Applied Data Science with Python Specialization
    Coursera: Michigan University.
    Aug 2024 - Nov 2024 (4 months)
  • C
    Learn SQL Basics for Data Science Specialization
    Coursera: Michigan University.
    Aug 2024 - Sep 2024 (2 months)
  • C
    Python for Everybody Specialization public Remote experience
    Coursera: Michigan University.
    Jul 2024 - Sep 2024 (3 months)
  • C
    Python Data Types
    Codefinity
    Jan 2023 - Feb 2023 (2 months)
  • C
    Introduction to Python
    Codefinity
    Jan 2023 - Feb 2023 (2 months)
  • C
    String Manipulation
    Codefinity
    Jan 2023 - Feb 2023 (2 months)
  • U
    Excel - Power BI intensive
    Udemy online
    Sep 2021 - Current (4 years 9 months)
  • Cousera
    Google Data Analytics
    Cousera
    Mar 2021 - Jul 2022 (1 year 5 months)
  • Corporación Universitaria de Cataluña
    Project Management
    Corporación Universitaria de Cataluña
    Mar 2018 - Jul 2018 (5 months)
  • Universidad del Atlántico
    Industrial Engineering
    Universidad del Atlántico
    Feb 2010 - Jun 2016 (6 years 5 months)
Projects (professional or personal) verified_user 0% verified
  • CUC
    Universidad del Atlántico
    Universidad del Norte
    Personal projects
    CUC, Universidad del Atlántico, Universidad del Norte
    Jul 2016 - Current (9 years 11 months)
    In my personal projects, I focus on developing and executing various initiatives that enhance my skills and knowledge in data management and visualization. I create comprehensive reports that handle large datasets, ensuring that the information is well-organized and accessible. I utilize SQL to transform and manage this data effectively, which allows for improved analysis and decision-making. Additionally, I leverage Microsoft Power BI as my preferred tool for generating insightful visualization reports, enabling clearer communication of data-driven insights. Furthermore, I have built personal data pipelines orchestrated with Apache Airflow, which are fully version-controlled in GitHub. This integration with CI/CD workflows allows me to aut