Pablo Mombru

I was responsible for developing and implementing ETL/ELT pipelines to transfer sales and shipment orders from an external SQL Server database into Snowflake data warehouse databases. Additionally, I designed and implemented data models for both the technical and semantic layers in Snowflake, ensuring they could be effectively consumed by reporting tools.

To automate processes, I created Python programs that served as a scheduler, retrieving orders from the external database and executing dbt processes to load both staging and final tables. I also developed Tableau dashboards as proofs of concept to demonstrate data visualization features, comparing them against Power BI.

As a SQL/ETL expert, I managed several critical tasks. I created, maintained, and executed ETL processes to migrate financial data from sources like MySQL, Salesforce CRM, and the USA government into a PostgreSQL database on AWS. I crafted complex queries to extract data from MySQL, PostgreSQL, and Redshift databases hosted on AWS. Additionally, I developed and optimized dbt models to migrate data from SQL Server and PostgreSQL to AWS Redshift.

For data migration tasks, I built complex Apache Airflow pipelines to handle dbt execution and testing. I designed and created Tableau dashboards tailored to business requirements using diverse data sources, including RDBMS and Excel. My work involved creating complex Tableau data sources by linking existing ones to display fields from different databases in dashboards.

Moreover, I managed AWS tools like Redshift clusters, CloudWatch, S3 buckets, EC2 instances, and Secrets Manager, ensuring robust infrastructure management and efficient data handling across platforms.

I was in charge of:
• Analyzing and identifying the source data to be migrated from different sources DBs such as MySQL DB, MS Access DB, and CSV files.
• Designing and modeling a PostgreSQL database as the destination database for the data migration based on customer requirements and source DB structure.
• Creating a data mapping document to map source DBs data to new destination DB tables and fields and creating a data migration strategy and plan to achieve the migration.
• Exporting data from sources DBs using each DB's export tool (MySQL and MS Access) and Penatho's PDI Kettle processes.
• Importing the source data into staging tables in the PostgreSQL destination DB through the DB import tool and Penatho's PDI Kettle processes.
• Creating PSQL functions in the PostgreSQL destination DB to adapt and import the staging data into the final core tables.
• Working on cleaning and normalizing the imported data as a post-migration process through PSQL functions created in the PostgreSQL destination DB.
• Documenting the whole data migration process and strategy.

I imported customers' data into a non-relational Cassandra DB through Kafka loaders. The information to load was organized in JSON files created by the Pentaho ETL process from the legacy system staging Oracle DB.

I migrated 20 million customer data into the Siebel CRM database without errors and on the expected date. The migrated information included customer data and related contacts, addresses, and billing/service profiles.

I created programs in C# to access (query, insert, and update) data into Siebel CRM Cloud production instances by calling exposed Siebel's web services. The web services instances were called through a proxy object whose instance was created and managed in the C# programs.

I configured different Siebel CRM user interfaces for the four other bank brands by modifying CSS, HTML, and JavaScript internal files. A different user interface was created for each brand with different background colors and font types.

For the customer to quickly check the outcome of the data migration, I developed a data reconciliation Python program to generate an automatic Excel report, based on data from Oracle databases, with total quantities of records.

This program:
• Obtained the information to be migrated from legacy Oracle DB.
• Obtained the converted and adapted data from intermediate Oracle DB.
• Generated pre and post-total records quantities for each migrated entity.
• Created an Excel spreadsheet to inform total quantities to be migrated and total quantities converted.