Experience

Waco Digital Hub

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Business Intelligence Analyst

  • Apr 2023 - Present

  Colombia Responsibilities: - Analyze business metrics using advanced data analysis techniques, identifying patterns and trends to inform strategic decisions. - Design and implement new financial metrics using statistical methodologies and quantitative modeling to improve financial performance evaluation. - Build the Business Intelligence (BI) model for management, integrating data sources, applying ETL transformations and developing interactive dashboards to facilitate informed decision making,… Show more Responsibilities: - Analyze business metrics using advanced data analysis techniques, identifying patterns and trends to inform strategic decisions. - Design and implement new financial metrics using statistical methodologies and quantitative modeling to improve financial performance evaluation. - Build the Business Intelligence (BI) model for management, integrating data sources, applying ETL transformations and developing interactive dashboards to facilitate informed decision making, making use of Power BI and Amazon S3. Achievements: - I automated business ETL in Power BI and AWS by developing a relational model, reducing processing time by approximately 200%. - Optimized business metrics analysis, increasing accuracy by approximately 20% and providing crucial insights that resulted in increased operational efficiency. - Developed and implemented 2 new financial and 5 productivity metrics, improving performance evaluation and facilitating strategic decisions that contributed to an increase and optimization of financial resources. Show less



Nub8 LATAM

• Colombia
• IT Services and IT Consulting
• 1 - 100 Employee

• Data Analyst

  • Jun 2023 - Nov 2023

  Responsibilities: - Define the reporting structure in the Customer Success domain, implementing efficient data analysis methodologies making use of Power BI, Amazon QuickSight, Amazon Athena, Amazon Glue and Amazon S3. - Develop metrics and medium-term projections using advanced quantitative analysis techniques and statistical modeling. - Apply machine learning techniques to perform forecasting of various metrics, optimizing forecast accuracy and reliability. Achievements: -… Show more Responsibilities: - Define the reporting structure in the Customer Success domain, implementing efficient data analysis methodologies making use of Power BI, Amazon QuickSight, Amazon Athena, Amazon Glue and Amazon S3. - Develop metrics and medium-term projections using advanced quantitative analysis techniques and statistical modeling. - Apply machine learning techniques to perform forecasting of various metrics, optimizing forecast accuracy and reliability. Achievements: - I created a Data Lake with AWS services that allowed automating the ETL of the Customer success area (AWS Lambda, Glue, Athena, Amazon QuickSight, etc). - Developed predictive metrics that improved medium-term forecast accuracy by approximately 25%, optimizing strategic decision making. Show less



Teleperformance

• France
• Outsourcing and Offshoring Consulting
• 700 & Above Employee

• Bilingual Business Intelligence Analyst

  • Mar 2022 - Jun 2023

  Responsibilities: - Create dashboards in Power BI for various campaigns (Meta, Discord, Microsoft, among others) integrating dynamic visualizations and relevant KPIs. - Oversee the variable compensation system, ensuring alignment of bonuses with operational and strategic objectives. - Create and implement ETL processes with SQL Server to automate data extraction, transformation and loading, optimizing the efficiency of the information flow. Achievements: - Optimized 8 Power… Show more Responsibilities: - Create dashboards in Power BI for various campaigns (Meta, Discord, Microsoft, among others) integrating dynamic visualizations and relevant KPIs. - Oversee the variable compensation system, ensuring alignment of bonuses with operational and strategic objectives. - Create and implement ETL processes with SQL Server to automate data extraction, transformation and loading, optimizing the efficiency of the information flow. Achievements: - Optimized 8 Power BI Dashboards to Direct Query mode which improved the performance of each one, optimizing server resources. - Optimized the variable compensation system, aligning bonuses with strategic objectives, going from 4 days for analysis to 4 hours. - Implemented ETL processes with SQL Server, automating data download and reducing processing time by approximately 70%, improving the availability of information for decision making. Show less



Independiente (freelance)

• IT Services and IT Consulting
• 700 & Above Employee

• Business Analyst

  • Apr 2021 - Mar 2022

  Colombia Responsibilities: - Creation and administration Great Analytics, platform dedicated to the update of financial and technological news disseminated through social networks and web platform. - Consultancy in the creation and connection of SQL database for E-commerce applications where all data related to customers, orders and products are recorded. - Consultancy in creation of testing plans for desktop applications. Achievements: - I created the Great Analytic platform for… Show more Responsibilities: - Creation and administration Great Analytics, platform dedicated to the update of financial and technological news disseminated through social networks and web platform. - Consultancy in the creation and connection of SQL database for E-commerce applications where all data related to customers, orders and products are recorded. - Consultancy in creation of testing plans for desktop applications. Achievements: - I created the Great Analytic platform for financial information regarding figures, data and market analysis https://great.glideapp.io/ - Created and administered SQL database that connected with an E-commerce application called Root Planner. Show less



Licitando Consultores

• Research Services

• Reporting Analyst

  • Jun 2020 - Apr 2021

  Colombia Responsibilities: - Preparation and presentation of monthly and annual reports and accounts. - Analysis of company financial data - Financial profiling of clients - Analysis of tender documents - Preparation of budgets for bidding processes - Client database management Achievement: - I managed to get a digital marketing company to comply with legal and financial requirements to participate in bidding processes with the MInistry of Health.



MetLife

• United States
• Insurance
• 700 & Above Employee

• Intern

  • Jan 2020 - Jul 2020

  Colombia Responsibilities: - Management of employee database at Colombian level as input for different processes in the area. - Support in the organization of corporate events - Support to the Financial Vice-Presidency in economic research. - Consolidation of information to generate reports and presentations for the regional headquarters. - Support in the operational processes of the company's financial planning area and budget analysis. Achievements: - From the financial area… Show more Responsibilities: - Management of employee database at Colombian level as input for different processes in the area. - Support in the organization of corporate events - Support to the Financial Vice-Presidency in economic research. - Consolidation of information to generate reports and presentations for the regional headquarters. - Support in the operational processes of the company's financial planning area and budget analysis. Achievements: - From the financial area I managed to consolidate information from the different departments of the area for the presentation of data and figures in a simple way to the LATAM regional headquarters (R programming language was used). Show less