Saado شاماتا

Role: Senior Product Consultant / Team Leader

As part of Primeware consulting team, I am mainly responsible for developing data integration between different databases using different ETL/ELT tools: ODI 12c, Informatica

 Tahakom, KSA:
o Technical lead on 6 resources: 2 integrations on Talend ETL and 4 BI team using Tableau.
o Integration with 6 data sources (SQL servers DB, SAP, E-gate (PostgreSQL) with cloudera big data environment CDP.
o Responsible of getting all business requirement from different business departments and write BRD documents.
o Responsible of preparing the solution designs for all data sources integrations with the cloudera environment each data source with the approach needed based on incremental data (CDC) or batches processes.
o Responsible of designing the integration jobs for initial and CDC jobs on Talend to be implemented by the integration team.
o Responsible of designing all tables on cloudera environment using Hive, Impala, Kudu, parquet…
o Responsible of preparing the data for the dashboards to be built on Tableau by creating views and data needed on Impala.


 Financial institution, KSA:
o Implementation of oracle big data tool with different components related.
o Data integration from different type of databases to the oracle big data using Informatica ETL tool.

 Bank Audi Lebanon: Integration FCUBS - IFRMS: ODI 12c
o Planning and scheduling tasks for 2 team members.
o Technical support for the members.
o Data integration between new core banking FCUBS and IFRMS using Oracle Data Integrator 12c.
o Developing complex mappings with rules.
o Developing several packages.
o Developing and scheduling of loan plans for the whole project (Parallel or serial run).

 Bank Audi Lebanon: Integration FCUBS - POWERCARDS: Informatica
o Data integration between FCUBS - POWERCARDS using Informatica.
o Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
o Developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
o Developing data mappings between source systems and warehouse components.
o Utilized transformations like Router, Expression, Sequence Generator, Filter, Aggregator, and Lookups.
o Extracting data from excel files, high volume of data sets from data files, Oracle, DB2, using informatica ETL Mappings and loaded to data store area.
o Extensively working in the performance tuning of the programs, ETL procedures and processes.
o Resolving code defects and production issues.

 Financial institution, LEBANON:
o Upgrade Solution from Oracle forms 6i to Oracle APEX 18.2.
o Reverse engineering of forms 6i in order to upgrade to the APEX technology.

Team Leader :
•Analyzing and writing technical specification.
•Developing new enhancements on the system.
•Insurance system bug fixing: production and claims system based on Oracle platform (forms and reports 6i/10g).
•Performance tuning.
•Analyzing repetitive bug issues, and finding the solution for the root problems.
•Distributing tasks.
•Following-up on the tasks’ deadlines.

house Supply chain and Warehouse systems:
•Coordinating with project managers in France.
•Analyzing client’s requests.
•Preparing the detailed technical documents for the developers.
•Implementing of the systems in France and Belgium.
•Part of the QA team.
•Delivering the project to the client.
•Review developer’s code (forms/reports 6i, 10g and PL/SQL packages).

In house ERP solution:
•Implementing the solution in KSA with wide knowledge of its below financial modules:
•Journal Voucher
•Payment Voucher
•Payable & Invoices
•Treasury (Cash Management, Cheques.....)
•Part of the development team on oracle forms and reports 6i and 10g.