Serge - Consultant INFORMATICA

Project: ETL DEVELOPER DATASTAGE

• Migration of DataStage 11.7 to CP4D.
• Set up of a landing zone, staging area
• Actimize process Optimization.
• DataStage applications Tuning on Vortex. Scd2 historization, change data capture and Loading mechanism improvement.
• Involved in several project like Instant payment optimization, Datalake Lump Sum.

Project Sector: Automotive
Project context: Big Data Integration of disparate types of data, big data analytics with sap. Data Validation, Data Cleansing into the company Datawarehouse.
Activities and responsibilities: As a Project Manager I
• set up processes that could detect vehicle breakdowns in advance and anticipate the repair of faulty parts within Arval.

• I was involved in predicting the sales of electric cars following the announcement of the new car law, predicting the type of models that would sell in large numbers based on the last 2 years of sales history.

• Data preparation analysis, Data Modeling, Data Integration, Data visualization.
orchestration of End-to-end machine learning pipelines.
• Unit and integration testing
• Deployment and monitoring flow post-production
• Agile Methodology (DSM, Retrospective, Stories…)
• Performed the Dataiku platform upgrade from version 8 to version 9.
Technologies: Oracle 12c, Dataiku platform, Cosmo, Putty, Machine learning, Big data, SAS Reporting, Jira.

Project: ETL DEVELOPER DATASTAGE/INFORMATICA
Start Date: AUG 20218-JULY 2021
Project Sector: ING BANK
Project context: Ensure the ETL processing of Credit card acquisition, Credit Card transactions and other files to be loaded in the Datawarehouse.
Activities and responsibilities:
• Data Migration from Informatica to DataStage, Data Integration, Data Cleansing of new jobs
• Electronic signatures monitoring of new Ing customers…Which was tracing the different steps a customer takes when he is downloading his documents on the website.
• Put in place errors handlings in several DataStage & Informatica Flows(jobs)
• Extraction of data from legacy system, transformed them with the new type of credit card and processed their Integration into our Datawarehouse/Dmart.

• I have worked on the « Batch the frais” by modeling Dimensions and Fact tables to replace the way they were sourcing their data to refine Eckert data information.

• Improving some ETL strategies in regards of the data loading and data integration (Staging Area, Delta loading, Full Loading)
• Dataflows Partitioning
• Data Archiving with SCD type 2.
• Worked and participated in several workshops on KYC concept.
• Fixing and debugging process flows bottle neck
• Recruiting and coaching new developers.
• Performing Production support
Technologies: DataStage, Informatica, SQL Scripting, Oracle Sql/Plsql, Unix shell scripting …

Project Sector: European Bank in Luxemburg
Project context: Dataflow improvement and Data quality control
Activities and responsibilities:
• I have worked on the Admin warehouse where I performed some ETL transformations in their Datawarehouse, calculations on total hours based on the function code of the different employees in the Operational Data Store Monitoring the performance of different data flows
• Managing Jira
• Communication with different stakeholders

Project Sector: Royal Commission in Saudi Arabia
Project context: Datawarehouse design & Datawarehouse/Dmart creation
Activities and responsibilities:
• Our job was to first bring together the multiple sources of data and begin to structure them in the oracle tables and set up the most efficient way to extract the data and reduce manual actions as much as possible
• 3 months to create a POC. Gathering of business requirements organized by city statistical indicators divided into different sectors and segments. Dimensions and facts creation in Oracle Data Integrator.
• ODI topology configuration: data server, physical server, logical server, and context.
• ODI Interfaces, scenarios, and packages creation. ODI load plans.
• OBI Admin tool, I created physical layer, Bmodeling and presentation layer.
• With OBIEE I was generating several automated dashboards reports.

Responsible to set up Bots application in several environments which consisted to track customers orders. I used plsql to create procedures which was handling the datafeed from the source databases towards some target views. Index rebuilding, tables schrinking, use of oracle plsql hints. All the scripts were executed via Unix shell. I put in place a real time processing which was propagating all the orders every seconds.
I maintained and support the application on a daily basis. According to requirements, I merged some oracle objects, and ensured that it will be deployed throughout the different environments.

In FTS Project : I have Worked with business leaders to understand business strategies,operations. Includes analysis of business and user needs, documenting requirements, and revising existing BOTS system logic difficulties as necessary.
I have most of the time acted as a liaison between the IT development group and business units for the development and implementation of new FTS systems and enhancement of existing BOTS systems.
I also contributed in evaluation of this new applications and identified systems requirements. I did evaluated new IT developments and evolving business requirements, and recommended appropriate systems alternatives and/or enhancements to current systems.
I Lead analysis sessions. Prepared communications and made presentations on system

PLSQL DEVELOPER

Set up and deploy of a tracking system application in several environments which consists of tracing customer
orders. Oracle Plsql Procedures handles this data propagation.
All the scripts were executed via unix shell. I put in place a real time processing which was propagating all the
orders every seconds. I maintained and support the application on a daily basis. I also performed some index Schrinking and used Plsql hints.

ETL INFORMATICA DEVELOPER

Responsible of feeding the staging area and the Datawarehouse. Put in place an Incremental load+
Implementation of a loading strategy. Dimensions and facts Tables creation in a star schemas datawarehouse
architecture. Oracle Plsql Procedures tuning. Feeding hundreds of tables in the Data warehouse via Oracle
11g Plsql packages and ETL jobs. Implementing control tables/dashboard to trace files loading/rejected
rows…Control of performance and storage volume.
Technical Specifications documents creation. ERD Design with Erwin and implementation.

ETL Datastage Developer

30% of my role was to do the analysis of varied sources of data, determining extraction methodologies
and loading to operational data models & data marts.
For the rest I performed the following: Jobs/mapping, Jobs execution, Jobs scheduling.
Loading data in staging area and feeding the datawarehouse & The DataMart.
Implementation of exception handling mechanism.
Metadata collection/maintenance/deployment.
Automate Reports with BOXi
Automation of Oracle PL/SQL procedures/Functions.
Extraction automation.
integration/Extraction of many jobs in parallel.
Modification of ETL process with Datastage 7.5:ETL development , Merge stage, Data comparisons,
slow changing dimensions type 2.
Analysis of Asset management investment funds in terms of inventories, cash flow.
Translating business visions and needs into technical documentations
Production follow up on a daily basis.

DATAMODELER/ INFORMATICA DEVELOPER

BI reports creation/execution.
I Supervised a team of 8 persons ( scheduling and assigning tasks) and provided them technical
guidance .
UML Data modeling, Denormalization of Operational data Store(ODS).
Design of new mappings/applications and performance improvement of existing ones.
Design of a small Dwhouse with Kimball Concept.
Unix Shell scripting to create configuration files and mapping variables implementation for incremental
load.
Fix and debugging issues of new application in collaboration with off shore Team in Bengalore.
Analysis of complex Informatica mapping, use of variables and set up of Informatica best practices.

ETL DEVELOPER

Design and Data integration of disparate legacy files.
Implementation of Data Model, DWH, Datamarts.
Data Quality, Slowly changing dimensions.
Performance Tuning and debug of SQL/PLSQL ( functions/procedures, sqlldr, external tables,
partitioning, indexes, tuning)
Database triggers, Materialized views, Query optimization and Performance tuning Informatica -
Building multi-dimensional Kimball-based Datamarts with Type 2 historical dimensions in Snow
Flake Schema.
PL/SQL packages and triggers.
Historization with cube, hierarchy parent child, fact tables, dimensions.
Optimize the existing jobs using SQL/PLSQL tuning methodologies, explain plan, statistics…
Work with the end users to understand the business requirements