Summary
Overview
Work History
Education
Skills
Timeline
Generic

Laura Prada Avila

Industrial Engineer
Bogota,Colombia

Summary

Industrial Engineer with experience since 2014 in data base management, building reports, analytical functions, interpretation of information, creating dashboards in excel and power bi (2019). Strong knowledge of Microsoft office, SQL skills, data bases and Power Bi. Enjoying being constantly challenged to learn and to do more.

Overview

5
5
years of professional experience
1
1
Language

Work History

Information Analyst Engineer

Dale - Grupo Aval Soluciones Digitales
04.2022 - Current
  • Collecting data from various sources such as databases, spreadsheets, APIs, or cloud services.
  • Developing interactive dashboards and reports using Power BI's drag-and-drop interface.
  • Choosing appropriate visualizations to effectively communicate insights.
  • Customizing the appearance and layout of reports to enhance user experience.
  • Cleaning and transforming data to ensure consistency and accuracy using Ateryx and sql.
  • Analyze, design, and develop well-defined. methods and procedures for better management of data.
  • Implementing data security measures to ensure that sensitive information is protected.
  • Optimizing SQL queries for performance by analyzing execution plans and identifying opportunities for optimization.
  • Utilizing indexing strategies to improve query performance.

Information Analyst Engineer

CABLE & WIRELESS BUSINESS
12.2020 - 04.2022
  • Developing and maintaining BI dashboards and reporting them in PowerBI.
  • Sharing reports and dashboards with stakeholders using Power BI Service.
  • Collaborating with team members by co-authoring reports and sharing insights.
  • Distributing insights through automated email subscriptions or embedding reports into other applications.
  • Optimizing data models and queries for better performance.
  • Connecting to data sources, importing data, and transforming data for business intelligence.
  • Exporting query result to visualization tools like PowerBI for further analysis.
  • Creating reports using sql querys.

Reporting Lead

Teleperformance - Cisco
12.2019 - 12.2020
  • Supporting daily reporting based on business requirements.
  • Maintenance and monitoring of daily KPIs.
  • Providing training and support to users to help them understand and utilize Power BI effectively.
  • Gathering reporting requirements from internal stakeholders.
  • Setting up role-based access controls to restrict access to certain data.
  • Building data models that standardize information across Teleperformance and Cisco.
  • Developing from scratch and maintaining BI dashboards and reporting them in Power BI.

Analyst I

Nueva EPS
03.2019 - 12.2019
  • Develop and build tools reports to gather information.
  • Using SQL's Data Manipulation Language commands like INSERT, UPDATE, and DELETE to modify data in tables.
  • Applying filters, sorting, and aggregating functions (e.g., SUM, AVG, COUNT) to manipulate and summarize data.
  • Analyse data and extract insights to find root causes and inform the team.
  • Gather information from a wide range of sources (Excel, Access, SQL).
  • Writing complex SQL queries to perform analytical tasks such as trend analysis, cohort analysis, and segmentation.
  • Proactively identify opportunities to improve efficiency in operation.

Education

Associate of Science - Analytics Projects in Python Certificate

Universidad De Los Andes
Bogotá - Colombia
05.2001 -

Associate of Science - Business Intelligence And Big Data Certificate

Universidad EAN
Bogotá - Colombia
05.2001 -

Associate of Science - Project Management Certificate

APC Australian Pacific College
Melbourne - Australia
05.2001 -

Bachelor of Science - Bachelor of Science in Industrial Engineering

Universidad Catolica De Colombia
Bogotá - Colombia
05.2001 -

Skills

Bilingual (English – Spanish), SQL, Alteryx, Excel, PowerBi, basic python, DAX, problem solving skills, dashboard design knowledge, analytical ability

undefined

Timeline

Information Analyst Engineer

Dale - Grupo Aval Soluciones Digitales
04.2022 - Current

Information Analyst Engineer

CABLE & WIRELESS BUSINESS
12.2020 - 04.2022

Reporting Lead

Teleperformance - Cisco
12.2019 - 12.2020

Analyst I

Nueva EPS
03.2019 - 12.2019

Associate of Science - Analytics Projects in Python Certificate

Universidad De Los Andes
05.2001 -

Associate of Science - Business Intelligence And Big Data Certificate

Universidad EAN
05.2001 -

Associate of Science - Project Management Certificate

APC Australian Pacific College
05.2001 -

Bachelor of Science - Bachelor of Science in Industrial Engineering

Universidad Catolica De Colombia
05.2001 -

Similar Profiles

CREATE PROFILE
Laura Prada AvilaIndustrial Engineer