Nicolas Lozano

Nicolas Lozano

Asistente de Optimización de Operaciones Avanzadas

Followers of Nicolas Lozano522 followers
location of Nicolas LozanoBogota, D.C., Capital District, Colombia

Connect with Nicolas Lozano to Send Message

Connect

Connect with Nicolas Lozano to Send Message

Connect
  • Timeline

  • About me

    Data Analyst | Business Analyst | Solutions Architect | AI & Machine Learning | Power BI | Azure | Python

  • Education

    • Pontificia Universidad Javeriana

      2018 - 2023
      Grado en Ingeniería Industrial

      Activities and Societies: Tesorero del grupo estudiantil IISE JAVERIANA Miembro del grupo estudiantil ONU JAVERIANA Miembro del Voluntariado CONSTRUCORES DE SONRISA JAVERIANA Monitor de la asignatura OPTIMIZACION DE OPERACIONES

    • Lambton College

      2024 - 2024
      Big Data Analytics Data Processing and Data Processing Technology/Technician
  • Experience

    • Pontificia Universidad Javeriana

      Jan 2022 - Dec 2022
      Asistente de Optimización de Operaciones Avanzadas

      • Implementé algoritmos de inteligencia artificial y optimización computacional para resolver problemas en dos empresas diferentes.• Lideré proyectos de análisis de negocios de extremo a extremo, aplicando la metodología CRISP-DM para la preparación, modelado, evaluación e implementación de datos, lo que resultó en un aumento del 5% en la eficiencia operativa.• Incremento de la eficiencia de costos por encima del 10% en operación para dos empresas analizadas.

    • IISE Capítulo Javeriano

      Jan 2022 - Nov 2022
      Coordinador de finanzas y presupuesto

      Gestión del Presupuesto: Administré el presupuesto anual del grupo, asegurando la correcta distribución de fondos para eventos y actividades.Control Financiero: Supervisé todas las transacciones financieras, manteniendo registros precisos de ingresos y gastos.Planificación Presupuestaria: Elaboré y presenté presupuestos detallados para proyectos y actividades.Recaudación de Fondos: Implementé estrategias de recaudación de fondos, incrementando los ingresos a través de eventos y patrocinadores.Informes Financieros: Preparé informes financieros periódicos para mantener a los miembros informados sobre la situación financiera.Colaboración: Trabajé en estrecha colaboración con otros miembros del comité ejecutivo para garantizar la viabilidad financiera de todas las actividades.Cumplimiento Normativo: Aseguré el cumplimiento de las normativas y políticas financieras de la universidad, manteniendo altos estándares de integridad y transparencia. Show less

    • DAVIVIENDA BANK

      Jan 2023 - Dec 2023
      DATA ANALYST|

      •Created interactive dashboards and reports in Power BI/ServiceNow to track financial KPIs, providing real-time insights to management improved decision-making efficiency by 30%, and reduced report generation time by 50%.•Developed Python scripts to automate data collection and processing from various support groups within the bank, reducing report generation time by 30%.•Identified two root problems through data analysis, allowing the IT support group to provide solutions to users. Show less

    • Upwork

      Jan 2024 - May 2024
      FREELANCE DATA ANALYST

      •Developed a trading algorithm using a Multi-Layer Perceptron (MLP) classifier for Buy, Hold, and Sell decisions. Implemented a comprehensive analysis pipeline, including data collection, feature extraction, labeling, and model training/testing, to optimize trading strategies on cryptocurrency exchanges.•Created over 5 interactive dashboards in Power BI, enhancing data visualization with visuals like Deneb and improving data accuracy using models like star schema.•Executed web scraping and API projects to extract valuable data from diverse sources, reducing data collection time by 35% and enhancing data completeness.•Conducted comprehensive EDA for various projects, utilizing Pandas, NumPy, and Matplotlib to uncover critical insights, improving analysis efficiency by 25%.•Managed projects for English-speaking clients, ensuring clear communication and timely delivery, leading to high client retention and repeat projects. Show less

    • Kap Consulting

      Aug 2024 - now
      Associate Consultant

      •Led a machine learning project predicting loan default using neural networks, achieving early recovery of 20% of loans, saving over 500 million pesos monthly.•Co-led document extraction and validation projects using OCR and OpenAI, reducing documentary audit times by 60% and increasing audit capacity by over 35%.•Co-led AI-driven document automation projects for an oil company and a government agency, reducing review time by up to 70% and improving overall efficiency.•Designed and deployed robust Azure solutions using Kubernetes, Azure Functions, Blob Storage, VNet, and virtual machines, optimizing processes and ensuring information security.•Implemented continuous integration and deployment (CI/CD) using Azure DevOps, enhancing operational efficiency and implementation quality.•Comprehensive creation of more than 5 professional dashboards in Power BI, including data connection, cleaning, semantic modeling, secure online publication, and effective permissions management, optimizing operational efficiency and reducing reporting generation and visualization times by up to 70%. Show less

  • Licenses & Certifications

    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      Mar 2025
      View certificate certificate
    • Big Data in the Age of AI

      National Association of State Boards of Accountancy (NASBA)
      Mar 2023
      View certificate certificate
    • Career Essentials in Data Analysis by Microsoft and LinkedIn

      Microsoft
      Jul 2024
      View certificate certificate
    • Industrial Engineer

      Pontificia Universidad Javeriana
      Sept 2023
      View certificate certificate