Diana Ruiz Figueroa

D

Data Governance

DelfosTi

Sep 2024 - Current (11 months)

D

Data Governance Senior

DelfosTi

Sep 2024 - Current (11 months)

Designed and implemented an end-to-end data governance strategy following the DAMA methodology. Ensured data quality and security at all levels during the migration ingestion process to Databricks. Responsible for data modeling and architecture. Analyzed and verified SQL processes and field mapping for QA. Conducted impact analysis of production script processes. Tracked production tables and fields in the Data Warehouse (DWH) and Data Lake. Coordinated migration decisions from Sandbox processes to Data Lake with various roles. Documented migration processes from Sandbox (Oracle) to Cloud Data Lake

Data Governance

Bluetab Solutions

Oct 2023 - Current (1 year 10 months)

Responsible for understanding the client's data migration needs. Analyze and define the strategy for the migration to Data Lake Cloud-Onpremise, analyzing and verifying inputs, outputs and SQL processes. Perform impact analysis at the script level of production processes. Perform the mapping of productive tables and fields in DWH and Data Lake. Coordinate with the different roles the migration decisions from a Sandbox process to Datalake. Responsible for the documentation for the migration from Sandbox (Oracle) to Datalake. Responsible for creating information tables using JIRA X-RAY

B

Data Governance Consultant

BLUETAB SOLUTIONS PERU S.A.C.

Oct 2023 - Jul 2024 (10 months)

Analyzed client data needs and defined business strategies for migration to Cloud Data Lake. Verified SQL processes and field mappings for QA. Conducted impact analysis of production script processes. Tracked production tables and fields in DWH and Data Lake. Coordinated with various roles on migration decisions for Sandbox processes to Data Lake. Documented migration processes from Sandbox (Oracle) to Data Lake. Balanced information using JIRA X-RAY. Managed technical metadata availability and data formats for consumption, coordinating with technical custodians and data engineers. Ensured proper implementation of the data strategy and framework under the DAMA methodology.

R

Business Intelligence Analyst – Trade Marketing

ROM OUTSOURCING SAC

Jun 2023 - Oct 2023 (5 months)

Responsible for the EPSON account. Responsible for generating automated BI reports and reports with high quality of business data. Optimization of queries and SQL Server queries. Management of ETL processes in Visual Studio (SSIS). Maintenance and implementation of Data Warehouse/Datamart projects. Management of non relational databases (Mongo DB). Responsible for analyzing commercial results and proposing improvement actions. Responsible for presenting results and key indicators to the client. Responsible for conducting training for the sales force. • Implementation of +4 dashboards for correct monitoring of the operation • Identified improvements in data collection and analysis processes, leading to a 30% improvement in data management

G

Business Intelligence Analyst – Trade Marketing

Grupo Tawa - Rom Outsourcing SAC

Jun 2023 - Oct 2023 (5 months)

Managed the EPSON account. Developed automated BI reports with high-quality commercial data. Migrated data from an on-premise environment to the cloud. Optimized Sandbox processes and SQL queries. Implemented data catalogs and dictionaries. Managed ETL processes using Visual Studio (SSIS). Maintained and implemented Data Warehouse/Datamart projects. Handled non-relational databases (MongoDB). Analyzed commercial results and proposed improvement actions. Presented results and key indicators to clients. Conducted training sessions for the sales force. Key achievements: • Implemented over four dashboards to improve operational monitoring. • Identified data collection and analysis process improvements, increasing data management efficiency by

G

Business Intelligence Analyst

GRUPO LUCKY SAC

Dec 2022 - Jun 2023 (7 months)

Responsible for the accounts of Yape, Izi Pay Ya, Ladrillos Sagitario. Responsible for identifying client needs and proposing BI projects that allow the visualization of business results. Responsible for data quality in the DTS. Responsible for automating reports for commercial management. SQL query optimization. Responsible for leading meetings with the client. Responsible for training the commercial team in charge of data collection. • I built key dashboards to improve commercial management (sales tracking, generation of efficiencies, business coverage), improving the promotion strategy and identifying suitable geographic areas. • I transformed and automated data loading and report generation, reducing times by 60%. • I developed and d

G

Business Intelligence Analyst

Grupo Lucky S.A.C

Dec 2022 - Jun 2023 (7 months)

Managed accounts including Yape, Izi Pay Ya, and Ladrillos Sagitario. Identified client needs and proposed BI projects for commercial results visualization. Conducted field mapping and created data catalogs and dictionaries. Ensured data strategy and reduced Sandbox processes. Ensured data quality in DTS processes. Automated reports for commercial management. Optimized SQL queries. Led client meetings and trained the commercial team on data collection Key achievements: • Built key dashboards to improve commercial management (sales tracking, efficiency generation, business coverage). • Automated data loading and report generation, reducing process times by 60%.

R

JR Data Analyst - T&C (Human Resources

Ransa Comercial SA

Jun 2021 - Dec 2022 (1 year 7 months)

Responsible for interacting with the various human management teams to understand their needs and workflows. Responsible for collecting data and creating various visualizations (Power Bi) depending on the needs of the internal client. Responsible for collaborating with different team members to profile, analyze and model data. Responsible for analyzing and improving data quality and automation of the reporting system. Train the end user, guaranteeing correct understanding of the report and reducing dependence on data access. • Management and compilation of databases for the correct monitoring of corporate programs, specialist training, registration of inductions, audits and development of regulatory courses at the Ransa group level. • I au

R

JR Data Engineer- T&C (Human Resources)

RANSA COMERCIAL S.A.

Jun 2021 - Dec 2022 (1 year 7 months)

Interacted with human resources teams to understand their needs and workflows. Collected data and created various visualizations (Power BI) based on internal client needs. Collaborated with team members to profile, analyze, and model data. Improved data quality and automated reporting systems. Trained end users to ensure report comprehension and reduce data access dependency. Key achievements: • Managed databases to monitor corporate programs, specialized training, inductions, audits, and regulatory courses across Ransa group. • Automated BI reports for the vice presidency, reducing processes by 30% and enabling automated data delivery via Power Automate.

Diana Ruiz Figueroa

About

Detail

Timeline

Résumé