Pablo Mombru

I was in charge of creating, maintaining, testing, and executing several ETL processes for continuous financial data migration into a PostgreSQL data warehouse from different sources, including MySQL database, Salesforce CRM, and US Government APIs.

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.