luis alejandro gutierrez

luis alejandro gutierrez

About

Detail

Developer BI
Bogotá, Bogota, Colombia

Contact luis regarding: 
work
Full-time jobs
Starting at USD1.5K/month
Flexible work
Starting at USD16/hour

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • TELUS Digital
    Online Data Analyst
    TELUS Digital
    Sep 2023 - Current (2 years 7 months)
  • Colsubsidio
    BI ANALYST
    Colsubsidio
    May 2022 - Feb 2023 (10 months)
    Normalize the data, extract it in SAP PSCD, load and transform it using Power BI. Build, modify, and create DML (Data Manipulation Language), DDL (Data Definition Language), and TCL (Transaction Control Language) queries through SQL Server for the BI area to optimize reports for the departments. Automate reports using SQL Server and Power BI to enhance information visualization.
  • SQDM
    Developer BI
    SQDM
    Jan 2021 - Apr 2022 (1 year 4 months)
    Implement ETL (Extract, Transform, Load) through ODI (Oracle Database Integration) for the automatic generation of spools based on client parameters. Query and manage database engines in Netezza, Oracle, SQL Server for data mapping and analysis using DML, DDL, and TCL queries for revenue assurance. Automate tableau dashboards for key insights in the area. Develop postpaid and prepaid dashboards presenting the main insights: downgrades and upgrades for revenue assurance. Achievement: Developed a postpaid and prepaid dashboard presenting key insights: downgrades and upgrades for revenue assurance. This dashboard addressed many inconsistencies in the previous development approach. Automating this dashboard resulted in a 30% optimization in the
  • More Products
    BI ANALYST
    More Products
    Jan 2020 - Dec 2020 (1 year)
    Normalize data: clean, organize, and transform data in Excel and Power BI for the control dashboard. Build control dashboards and automate them for key insights in the supply area: price, market share, customer type, up-sells, cross-sells, sell-in, sell-out, profitability. Provide route map advice and post-sales support to clients. Manage inventory forecast for key channels (E-commerce, new businesses, retail). Achievement: Achieved optimization of information visualization in the cloud-based inventory-supply dashboard for key channels (retail, new businesses, E-commerce), resulting in a 40% improvement in response time for out-of-stock products compared to the previous Excel-based process.
  • Lagobo SA
    B2B BUSINESS ANALYST
    Lagobo SA
    Oct 2016 - Nov 2019 (3 years 2 months)
    Responsibilities: Create, update, and modify query optimization in SQL Server for the generation of sales reports per customer and inventory distribution by sales representative. Create, update, and modify dashboards for the B2B channel, incorporating forecast, upsells, downsells, etc. Acquire new clients and continuously improve relationships with business partners (Pareto clients). Provide advisory and post-sales support in collaboration with business partners to enhance KPIs related to B2B customer experience. Achievement: Achieved a 30% improvement in response time for key indicators in the B2B commercial channel, providing an organized and easily accessible information display for sales representatives. This optimization facilitated
Education verified_user 0% verified
  • Lambton College
    big data analytics
    Lambton College
    Apr 2023 - Nov 2024 (1 year 8 months)
  • Lambton College
    Big Data Analytics, Tecnología de la información
    Lambton College
    Nov 2022 - Nov 2024 (2 years 1 month)
  • Servicio Nacional de Aprendizaje SENA
    Analysis and Development of Information Systems, Programación informática
    Servicio Nacional de Aprendizaje SENA
    Jan 2021 - Jan 2023 (2 years 1 month)
    Análisis y desarrollo de sistemas de información.
  • Politécnico Grancolombiano
    Specialist in Business Intelligence Project Management, Tecnología de la información
    Politécnico Grancolombiano
    Jan 2020 - Dec 2021 (2 years)
  • Fundación Universitaria del Area Andina
    Profesional, International business
    Fundación Universitaria del Area Andina
    Jan 2014 - Dec 2019 (6 years)