Andrea Fernández Barón

Andrea Fernández Barón  new_releases

About

Detail

Data Analyst | Michael Page | Ex- Rappi | Business Data Analyst | Project Management Consultant | MBIT - Andes Student
Bogotá, Bogota, Colombia

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Michael Page
    Data Analyst
    Michael Page
    Oct 2021 - Current (4 years 11 months)
    - Connecting the construction team and the partner to develop the stakeholder analytic area. - KPIs & Transform data to visualizing insights, Using of Azure DevOps (Agile). Tools: Power BI (DAX), PQuery (M), P Pivot, SQL (Azure SQL, SQLServer), embedded connection to Power BI, Azure Data Lakes, Sharepoint, OneDrive. - Creation of KPIs and transform that data to visualizing insights Using of Azure DevOps for agile project management and progress tracking.
  • Tecnopac
    Project Management Consultant
    Tecnopac
    May 2021 - Current (5 years 4 months)
    - Governance Structure, project/ Programme planning, stakeholder and resource management. Prioritization of Mechanisms - Strategic objectives, process design for IT governance. Developed a PMO to data collection. Conducting follow-up studies on project - Identify trends and inefficiencies to prevent problems from arising. DMAIC methodology to build processes. Tools: DMAIC, ADKAR, BBDO analysis, Goals Cascade COBIT, Miro, Notion, GSuit, Canvas, Decks, Jira, Confluence, Power Pivot, Power Query, - y, Power BI, Excel and Google sheets macros, Google sheets automation, IT Project Management Model (ITPM), Scrum agile.
  • Rappi
    Business Intelligence Analyst
    Rappi
    May 2021 - Oct 2021 (6 months)
    - Exploratory/raw data analysis to accomplish the LA growth plan. Translating business logic and objectives into SQL (Snowflake, Redash) Data visualizations and dashboard updates using Power BI, Periscope and Excel Macros. - Statistical analysis to extract insights, business and market knowledge. Jira for project management and progress tracking. Tools: Redash, Snowflake data cloud, Snowflake data warehouse, Bitbucket, Confluence, Jira, Trello, Power Pivot, Power Query, - , Power BI, Periscope, Google sheets, Excel and Google sheets macros, Google workspace, Query Function Google sheets, Jira Service Management, CMS Rappi, Scripts, Python, Scrum agile.
  • Corvus Lab
    Big Data Analyst
    Corvus Lab
    Nov 2020 - Dec 2020 (2 months)
    - Roles parametrization & plan monitoring for each company department, KPIs, OKRs to track performance and efficiency. Data cleansing and structure to build datasets. Tools: Trello, P Pivot, P Query, Miro, Data Studio, Excel/G sheets automation, MySQL.
  • C
    Co-Founder
    Convocatoria Global (Colombia)
    Mar 2020 - Mar 2022 (2 years 1 month)
    - Co-Founder, desarrollo del negocio, Analista BI. Direccionamiento de portafolio y creación de estrategias de marketing; KPIs.
  • F
    Project Analyst
    Fundación Wayuuda
    Aug 2018 - Jul 2020 (2 years)
    - Restructuring of enterprise architecture and construction of metrics for tracking. Design and construction of statistical analysis models on large datasets using SQL Server and reporting with SharePoint and SSRS to support investment rounds - Project management; execution and delivery time tracking and budget design. Tools: Trello, Canvas, Data Studio, Google Analytics, Excel and Google sheets macros, Google sheets automation, SQL(SQLServer), Google Drive, Google Forms, LEAN methodologie.
Education verified_user 0% verified
  • University of the Andes
    Master's Degreein Business Information Technology - MBIT
    University of the Andes
    Jan 2022 - Current (4 years 8 months)
  • Servicio Nacional de Aprendizaje (SENA)
    Technological Specialization In Database Management and Security, Data Processing and Technology
    Servicio Nacional de Aprendizaje (SENA)
    Jan 2019 - Aug 2019 (8 months)
  • Universidad Autónoma de Bucaramanga
    Bachelor of Economics
    Universidad Autónoma de Bucaramanga
    Feb 2013 - Jul 2019 (6 years 6 months)