Pablo Mombru

As a SQL/ETL Expert, I was in charge of the following:
• Creating, maintaining, testing, and executing several ETL processes to continuously migrate financial data from various sources, including MySQL database, Salesforce CRM, and USA's Gov, into a PostgreSQL database hosted on an AWS infrastructure.
• Elaborating complex queries to gather information from multiple sources, including MySQL, PostgreSQL, and Redshift databases hosted on an AWS infrastructure.
• Creating and configuring complex data build tool (dbt) models to migrate data from relational databases like SQL Server and PostgreSQL to AWS Redshift DB, optimizing and fine-tuning dbt processes.
• Building and implementing Apache Airflow's complex pipelines to run dbt execution and testing tasks to accomplish data migration processes.
• Developing Python scripts to generate business reports in Excel format, extracting data from diverse data sources, and automating access to production databases.
• Designing and creating Tableau dashboards tailored to business requirements, utilizing diverse data sources based on RDBMS and Excel spreadsheets.
• Managing and configuring AWS tools such as Redshift database clusters, CloudWatch, S3 buckets, EC2 instances, and Secrets Manager.

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.