Pablo Mombru, Data Migration Developer in Buenos Aires, Argentina
Pablo Mombru

Data Migration Developer in Buenos Aires, Argentina

Member since July 30, 2019
Pablo has extensive experience in database programming and data management. He specializes in complete data migration processes implementations, from strategy design and data mapping up to ETL processes development, testing, and execution. He also has great experience in databases performance issues revision, diagnoses, and resolution. He has worked in teams of all sizes.
Pablo is now available for hire

Portfolio

  • Qvantel
    BSS API, Oracle PL/SQL, Pentaho, Kafka, Cassandra DB, Talend, Python
  • Oracle Chile
    Siebel CRM, Web Services, Oracle PL/SQL, CSS, HTML, Javascript
  • Alliansys Argentina
    Siebel CRM, Oracle PL/SQL

Experience

Location

Buenos Aires, Argentina

Availability

Full-time

Preferred Environment

Windows

The most amazing...

...thing I've implemented is a complete data migration of almost 20 million customers' data with no errors, in the expected timeframe.

Employment

  • Data Migration Analyst

    2017 - 2018
    Qvantel
    • Created a data mapping document between customer's legacy on house system and Qvantel's BSS API based destination system.
    • Created data profiling queries on Oracle DB legacy data for quality check, using Talend Tool profiling rules.
    • Coded and tested Pentaho's complete ETL flow process for data migration. This process included the data extraction from legacy's staging area, the data conversion to the new destination structures, and JSON files generation as an outcome of the ETL process, to be loaded into destination Qvantel Cassandra DB.
    • Conducted data migration requirements identification workshops with the customer.
    • Created a python's program for data reconciliation report's automatic generation based on data migration's results. This program generated an Excel spreadsheet with total records quantity for data to be migrated and extracted, based on staging legacy Oracle DB and destination Cassandra DB.
    Technologies: BSS API, Oracle PL/SQL, Pentaho, Kafka, Cassandra DB, Talend, Python
  • Senior Principal Consultant

    2014 - 2017
    Oracle Chile
    • Conducted functional requirements recollection workshops with the customer for accounts, contacts, and order management Siebel CRM modules.
    • Designed business and technical solution for accounts, contacts, and order management Siebel CRM functional modules, based on gathered functional requirements.
    • Created inbound and outbound online interfaces based on SOAP web services WSDL definition, for accounts and contacts functional modules.
    • Configured automatic accounts/representatives assignments, using Siebel Assignment Manager tool through creating assignment rules based on reps availability, reps workload, and particular attributes of accounts as a channel.
    • Configured business processes automation using Siebel Workflow processes for accounts and contacts creation functionality.
    Technologies: Siebel CRM, Web Services, Oracle PL/SQL, CSS, HTML, Javascript
  • CRM Architect

    2013 - 2014
    Alliansys Argentina
    • Supported ongoing operation of Siebel CRM application assets, contacts, and order management modules.
    • Executed Siebel administration tasks to keep synchronized development, testing, and production repositories.
    • Handled performance issues related to a number of concurrent Siebel sessions running and open, by parametrization of Siebel server in a production environment.
    • Managed effort estimation plan for Siebel CRM application maintenance, based on identified new requirements and corrections on existent functionality.
    Technologies: Siebel CRM, Oracle PL/SQL
  • IT Specialist

    2012 - 2013
    IBM Argentina
    • Configured Siebel PRM/IBM LDAP authentication interface by creating a connection profile in Siebel Server and corresponding binding users.
    • Resolved Siebel Partner cloud application performance issues by creating/modifying DB2 database table's indexes and applying parametrization in Siebel Server on concurrency on the server and the database.
    • Resolved Siebel Partner cloud application web services configuration issues that were affected by poor performance of the application.
    • Conducted data migration requirements gathering workshops with the customer.
    • Defined a Siebel CRM data migration strategy that included source data systems, destination source data systems and the best approach to export, convert and adapt source data to Siebel CRM structures, and load data into destination structures.
    Technologies: Siebel CRM, DB2, LDAP
  • CRM Architect

    2011 - 2012
    Capgemini Argentina
    • Handled technical design for Siebel's accounts, service requests, and order management business modules.
    • Adapted Siebel CRM order management's OOTB workflow processes in order to achieve the business requirements of the customer.
    • Handled online SOAP web services interface design and configuration, based on WSDL definitions.
    • Handled performance improvements by adjusting parametrization of Siebel server related to server concurrent sessions parametrization.
    • Handled Siebel's patches installation on Unix environment without affecting the normal operation of Siebel CRM.
    Technologies: Siebel CRM, Web Services, Oracle PL/SQL, Unix
  • CRM Architect

    2010 - 2011
    Cognizant Argentina
    • Handled Siebel CRM Cloud production instances configuration for different countries for accounts, contacts, and assets modules.
    • Executed data import and export batch interfaces for Siebel CRM Cloud production instances.
    • Created programs in C# to 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.
    Technologies: Siebel CRM, C#
  • Principal Consultant

    2006 - 2010
    Oracle Argentina
    • Conducted Siebel CRM functional requirements gathering workshops with customers for accounts, contacts, and revenue modules.
    • Created workflow processes, business services, and assignment manager rules required for Siebel CRM application implementation. Workflow processes were created for automation of accounts and contacts functionality. Business services were created in Siebel's JavaScript to be used by workflow processes. Assignment manager rules were created to assign accounts to representatives based on rep availability and workload, and account particular attributes as Zone or Channel.
    • Handled online SOAP web services interface design and configuration for Siebel CRM Accounts and Contacts modules. WSDL files were used to implement the interfaces to do updates on data.
    • Defined a Siebel CRM data migration strategy that included: source data systems, destination source data systems and the best approach to export, convert and adapt source data to Siebel CRM structures and load data into destination structures.
    • Executed a complete data migration of 20 million customers into Siebel CRM. The data included accounts data, related contacts, related addresses, and corresponding billing and service profiles.
    Technologies: Siebel CRM, Web Services, Oracle PL/SQL, CSS, HTML, JavaScript
  • Senior Consultant

    2000 - 2006
    Siebel Systems Argentina
    • Handled technical design for opportunities and service requests modules of Siebel CRM.
    • Created workflow processes and business services for Siebel CRM application implementation for opportunities and service requests modules functionality.
    • Configured different design of Siebel CRM user interface presentations for each of the four different brands of the bank. This was done by modification of CSS, HTML, and JavaScript internal Siebel files.
    • Defined a Siebel CRM data migration strategy that included: source data systems, destination source data systems and the best approach to export, convert and adapt source data to Siebel CRM structures and load data into destination structures.
    • Executed a complete data migration of 10 million customers data into Siebel CRM. The migrated data included accounts data, related contacts, assets, orders, order items, and inventory information.
    • Handled Siebel CRM version upgrades on windows platform.
    Technologies: Siebel CRM, Web Services, Oracle PL/SQL, CSS, HTML, JavaScript

Experience

  • Tigo Bolivia (Development)

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

  • Telecom Argentina (Development)

    I migrated 20 million customer's data into Siebel CRM database with no errors and in the expected date. The migrated information included customer's data as well as related contacts, addresses, and billing/service profiles.

  • Merk (Development)

    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.

  • Banco de Chile (Chile's Bank) (Development)

    I configured different Siebel CRM user interfaces for the 4 different bank's brands through modifying CSS, HTML and JS internal files. For each brand, a different user interface was created with different background colors and font types.

  • Tigo Bolivia (Development)

    In order for the customer to do a fast check of the outcome of the data migration, I developed a data reconciliation python's 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.

Skills

  • Languages

    SQL, Python, JavaScript, CSS, HTML, XML, XSD
  • Tools

    Siebel CRM, SoapUI, Tableau, Google Analytics
  • Paradigms

    Entity-relationship Diagrams
  • Storage

    Siebel EIM, PostgreSQL, Oracle DBMS, Database Programming, SQL Stored Procedures, SQL Functions, Cassandra, JSON
  • Other

    Data Migration, Siebel EAI, Siebel Administration, Siebel Open UI, Web Services
  • Platforms

    Apache Kafka, Pentaho, Talend

Education

  • Bachelor's degree in Computer Sciences
    1990 - 1995
    Catholic University of Argentina - Buenoa Aires, Argentina

Certifications

  • Siebel 8.1 Certified Consultant
    APRIL 2012 - PRESENT
    EXO

To view more profiles

Join Toptal
Share it with others