Enzo Pedroso Bori Email & Phone Number

Cape Coral, Fl, Us

Cape Coral, Fl, Us

Sunnyvale, Ca, Us

Helping the business to design they Oracle base solutions with Data Modeling and later database implementations.

Data pipelines development for reporting projects with Apache Airflow, PentahoBI and Event triggers, connecting Azure Storage with data coming from AWS Python lambda and S3 repositories. Azure infrastructure management of applications running in container services and communicating with Azure SQL and Azure Synapsys and Azure and microservices distributes into Python Azure functions and AWS Python lambda. Azure security best practices implementation with credential management throw Key Vault, minimal access data policy and Azure Entra ID. Business Datawarehouse modeling and implementation in Azure Synapsys, considering all the good practices of Kimball methodologies and data modeling techniques. Data asset Cataloging documentation maintenance and data lineage through Colibra and LinkedIn DataHub (https://datahubproject.io/) tools. The documented metadata is used for business data privacy state and data quality issues broadcast through reports and other channels notifications. PowerBI reports development to get state of the art business operations and make decisions through data. The data are read from a Datawarehouse, and the real time calculations needed are made using DAX to ad-hoc requirements. Create custom checks and auditory reports for the IT team support, using Pentaho BI reporting services into an Azure VM. Implemented a web application to make the Datawarehouse Master Data completeness easy for the business user. Work with GoRule engine (like Drools) for faster changing data rules and adapt solutions to the business velocity. Shell scripting macros implementation for maintenance tasks.

Santiago, Región Metropolitana, Cl

Data Governance projects on the Google Cloud ecosystem, making the guidelines and data policies for different clients. Using the Data Catalog GCP tool for capture data products metadata using the discovery approach with integrations with services in the cloud or on-premises environment like relational databases. Creation of alerts from the metadata discovery that check metadata completion, data profiling or security compliance with the business Data Government policies. Generate several reports with Google Data Studio to show the data governance advances to the Business Board. Help with Data Mesh Architecture implementation.Using the Data Catalog GCP tool for capture data products metadata using the discovery approach with integrations with services in the cloud or on-premises environment like databases. Creation of alerts from the metadata discovery that check metadata completion, data profiling or security compliance with the business Data Government policies. Generate several reports with Google Data Studio to show the data governance advances to the Business Board. Help with Data Mesh Architecture implementation.

San Francisco, Ca, Us

Data pipeline development using GCP and AWS Cloud Services for different client's data process. Some of the technologies worked were pipelines automation with Airflow, data processing with EMR and Lambda functions or Datawarehouse in CGP BigQuery. Collaborate with the IT team with pipeline fixes or PySpark code optimizations. Different parametric systems data maintenance automation using Pentaho BI in the cloud like an easy path to drop daily manual IT operations tasks, like parameters initial data load. Creation of conceptual, logical and physical data models for use in different business areas. BigQuery Datawarehouse model documentation using data modeling tools like ER/Studio in conjunction to the database metadata management in Data Catalog. Web solution implementation to complement the Datawarehouse metadata maintenance using Google Cloud APIs.

Santiago, Santiago Metropolitan Region, Cl

Chilean Public Education Pay Engine implementation using technologies like Pentaho BI, Process workflow solutions and MSSQL Server clusters for public education system payments. It allows to manage the 3% of Chilean PIB assigned to the public education. Pentaho installations administration, in on-premises, cloud or docker. I am also able to manage Pentaho in cluster configurations, Carte services and security integrated with company Active Directory. Data integrations between the on-premises databases and AWS implementations like MongoDB in EC2 and Dockers apps to keep sensitive data on-premises and comply the Chilean government regulations. Correct use of the open-source ecosystem to control the Government assigned budget, using technologies like PostgreSQL, MongoDB, Pentaho BI suite, ProcessMaker workflow solution, RabbitMQ and others. Reporting solution development and team validations through the best practice usability for Power BI dashboards creation, paginated reports and final user training for self-service. I could also work with SSRS, Pentaho Reporting Service, and Qlick View. Management of end-to-end operations of ETL data pipelines, keeping uptime of 99%. Helped in User Acceptance Testing for business customers, verifying ETL jobs developing. Created conceptual, logical and physical data models for use in different business areas. Implement the best practice policy in areas like metadata maintenance, data lineage and data quality. Master Data Database implementation. Data migration between commercial systems like Oracle to open-source equivalent solutions like PostgreSQL. Incorporated Drools engine in data manipulation logics in use case that changes are faster. Help in data solution implementations for compliance with technical and business strategies. Trained non-technical users and answered technical support questions.

Santiago, Santiago, Cl

Team Data leader and Data Integrations architecture.

Huechuraba, Santiago, Cl

Processing and analytics services development to support real time data generated by the Metropolitan public transportation. I could work with solutions for geo data analytics like MySQL, PostgreSQL geo extensions, No-SQL Databases like MongoDB, Sonic Message Queuing and others. Third party companies use the output data for Buses fleet management. Datawarehouse model implementation for historical public transportation data. Datawarehouse migrations and data ingestion using Pentaho BI suite. Data coming from Cassandra databases was migrated to a PostgreSQL Datawarehouse for better query using SQL. Integration to social network data to grasp insight related to public transportation using java code and Pentaho BI. The output data allows analytics in real time based on user's sentiment using AI services. Reporting solution implementation to show the operation state using tools like Microsoft Reporting Service or WebFocus.

Santiago, Metropolitana, Cl

Responsibilities for different bank client's projects generating online services like the first online money transfer implementation in chilean bank industry. DBA and SQL Business logic implementation using Oracle 10 PL/SQL for fraud detection and SQL Server 2009 ETL designer using Microsoft integration service 2012. Reports development with Microsoft Reporting Services and Analysis Services 2012. Accomplishments: DBA leader for modeling and implementation of the first online tax service in Kenya, Africa with Oracle 10.

Santiago, Cl

Company Oracle Datawarehouse modeling and deployment using the best practices of Kimball methodology and modeling tools like ER/Studio. Metadata documentation management of the Datawarehouse model using Modeling Tools like ER/Studio. Data cleansing and data pipeline ingestion into the Datawarehouse.Achievement: Deploy the company Datawarehouse with the KPI needed for company decision making.

MS SQL Server developer and database administrator.Develop Storage warehouse logistic service using SQL in MS SQL Server.BI team support with OLAP Cube Development to produce a state of the art monthly report consumed by the business board.Achievement:Reduced the laboratory warehouse inventory error to almost 0.

Postgraduate Degree, Big Data And Data Science

Bachelor'S Degree, Computer Systems Networking And Telecommunications

Postgraduate Degree, Computer And Information Systems Security/Information Assurance