Melissa Business Intelligence Analyst

Data / Analytics Engineer

Nimble Gravity

Aug 2024 - Current (2 years 3 months)

As a Data / Analytics Engineer, I designed and implemented dashboards using Qlik, Looker, and Power BI to provide actionable business insights for clients in logistics, retail, and consulting industries, significantly reducing manual reporting efforts previously required to obtain key metrics. I automated data workflows and pipelines with Apache Airflow, ensuring consistent and reliable data ingestion and transformation, which reduced processing delays and guaranteed timely delivery. Additionally, I built data transformations using DBT and conducted data quality checks with SODA, increasing trust in critical business datasets and reducing data errors. I automated a process to classify the annotations from building safety inspections using P

Business Intelligence Lead

Rappi

Jan 2023 - Jul 2024 (1 year 7 months)

Led the BI team's roadmap and task prioritization using Jira to establish clear ownership and ensure alignment with strategic goals for commercial, product, and billing teams across 8 Latin American countries. Designed and executed product experiments applying A/B testing and user segmentation with SQL to evaluate purchasing behavior and ads impact that informed product, marketing, and revenue strategies. Developed and maintained data pipelines using Airflow, updating key product tables and sources of truth for ad revenue and bookings, ensuring data accuracy and reliability, which led to a 99% data accuracy rate and a 60% reduction in data processing time. Coordinated the intake and resolution of data bugs and requirements by implementing s

Business Intelligence Analyst

Rappi

May 2021 - Dec 2022 (1 year 8 months)

Developed complex KPIs, and conducted data-driven analysis, implementing successful A/B tests. Maintained data repositories, built dashboards, and resolved data-related issues for enhanced business insights. Constructed KPIs using complex SQL in Snowflake, created user coverage and penetration metrics that showcase the product's value and are used in current pitches, resulting in a 10% increase in bookings $400k. Implemented an A/B test to measure the restaurant sales incrementality caused by ads and automated the results using SQL and Airflow. The outcomes were made accessible through Power BI dashboards. The automation of these results led to optimized proposals for partners, increasing bookings of high-value brands, and contributing to a

Data Steward

ALICORP

Oct 2020 - May 2021 (8 months)

Monitored and improved core Vendor process data quality using SQL Server and Power BI, maintaining 97% quality on critical fields. Performed data profiling with Alteryx and Python; documented metadata to enhance transparency and governance. Led Vendor module stream in SAP Master Data Governance implementation: captured As-Is/To-Be, authored RFC/design docs, and executed unit, integration, and functional testing; reduced manual work by 70% via workflow design and training.

Data Governance

Banco de Crédito BCP

Jun 2018 - Oct 2020 (2 years 5 months)

Ensured data quality and integrity across digital channels like mobile banking, home banking, and ATMs, monitoring data incidents using PL/SQL and Power BI. Documented and analyzed data flows across banking channels and applications by reviewing code and ensuring traceability using Excel templates to support definition and modeling phases for the Hadoop Datalake ingestion project. Conducted in-depth profiling of raw data using HUE with Impala and the IBM Infosphere tools, resulting in achieving a 40% data load target for key use cases in the new data lake ecosystem.

C

Business Intelligence Analyst

CÁLIDDA

Oct 2015 - Jun 2018 (2 years 9 months)

Managed data related to collections, report generation, process automation, and analysis of overdue portfolio. Created collection tracking reports and financing campaigns using SAP. Developed Pentaho ETL to automate collection processes, such as generating and sending debtor customer databases to the central collection agencies.

Marketing Data Analyst

Sodimac

Dec 2013 - Oct 2015 (1 year 11 months)

Maintained and segmented the customer database, measuring performance for marketing initiatives to guide targeting and spending. Built RFM segmentations in SPSS to better understand customer profiles and analyze their behavior over time. Measured and analyzed the impact of all advertising materials (catalogs, magazines), in-store campaigns, and direct marketing actions.

Business Intelligence Analyst

Grupo el Comercio

Mar 2011 - Oct 2014 (3 years 8 months)

Provided data support for digital platforms related to sales of the editorial product, web content, web portal usage, and subscriptions. Built Qlik reports for metric tracking and process automation; trained teams and administered the Qlik console (scheduling, access, licensing). Wrote complex SQL Server logic to assemble analytical datasets; produced Google Analytics reports for content and e-commerce portals.

Melissa

About

Detail

Timeline

Résumé

Melissa

About

Detail

Behavioral traits