CV/Mission d'Expert datastage freelance

Exemple de missions de Behrouz,
Expert datastage habitant ?

Client : BEI BANK - The European Investment Bank
janvier 2022 - aujourd'hui
Position : IBM DataStage Expert – Installation configuration of Infosphere DataStage
Project : Infosphere Migration to 11.7

Main responsibility for upgrade project was to Install and configure IBM Infosphere Datastage and IGC, Keep the system healthy and make sure we take the best performance for new environment and if need apply some performance to some jobs to have better job performances.
Linux system analysis to prepare Files system,etc..Requesting creation of FS in Linux, requesting creation of Linux OS + Request for number of CPU memory space disk files system .configuration of DataStage. Doing pre-installation package:
Preparing Linux server for installation, Preparing response file for installation, Installation of Infosphere DataStage on POC server
Patching Infosphere ,SP2 SP3 SP4, Install ODBC patch Testing environment Checking installation logs
Post installation: configuration of DSenv, Configuration of interface file Installation of SYBASE client Configuration of Sybase client
Configuration of DSENV for Sybase and Oracle Configuration of WAS console Configuration of Admin console, adding user/group/project, Node creation, creating hierarchal folders in new server , executing test job for all different DB to make sure all is seted up in place and running smoothly, Involving in Stage conversion from DRS to Sybase.
Fixing up IQ stage issue with IBM( as IQ is not working in new version of Datastage
Creation of Datastage projects on all environment, creation of Environment variable, exporting/importing jobs from old environment to new environment
Configuration Installing DataStage on 16 servers,vmd/t/u/p 01/02/03/04.Helping on connector migration from DRS to SYBASE entreprise/SYBASE , Involving as Datastage Expert to fix failed jobs during migration.

IGC:
Doing pre-installation package:
Preparing Linux server for installation, Preparing response file for installation, Installation of IGC on POC server
Installation of IGC on 2 servers /VMU/VMP,
Upgrade on place from 11.3, installing all required patches before moving to 11.5, upgrade on place to 11.5, upgrading WAS console, upgrading to 11.5.1
Exporting term and category , exporting Term and category with historical from 11.5
Installing Infosphere IGC on 4 environemnt Dev,test,UAT and Prod on 11.7.1.3
Importing IGC term/category to 11.7.1
Technologies: IBM InfoSphere DataStage 11.5, 11.7 (Enterprise Edition), Linux, Oracle,SAL SERVER, SYBASE IQ, IGC, Agile methodology,Azure devops/pipline,GIT,service now

Client : ING BANK
février 2021 - décembre 2021
Position : IBM DataStage Expert
Project : Record retention, Data Archiving, Datastage Migration to 11.7

Responsibilities:
Working on complex project, Record retention, creating generic job to identify old aged record and track them
Through various target system such Data lake, DWH, DataMart to delete or Update/anonymizing the record.
Determine functional and technical requirement,
Modifying IGC policy and creating dummy example. Build plan and retention schedule with access rights and record type.
Prepare delete statement for each asset and make ready execution for particular asset to delete the records.
Prepare istool command for each execution to be executed for each sequence individually called from different project by different assets teams. Making RR Engine as a global platform at ING. Using Azure Pilepline, GIT, to do MTP and move to ACC for Datastage jobs and tables.
Doing Datastage project Migration from 11.5 to 11.7 at ING. Setting up, configuration of projects. Setting up, configuration/parameters of projects
support for trouble on DataStage, changing node configuration for different jobs.
pipline,GIT,service now

Client : BCEE BANK(The State Bank and Savings Fund of Luxembourg)
juin 2020 - août 2021
Position : Data Modeler, Data Migration Analyst, IBM DataStage Expert.
Project : KTP Migration,TaskForce

Responsibilities:
Migrating Data from old legacy source system (KTP) to Staging area and DWH data vault system.
Discuss and develop entity relation diagrams at a conceptual level.
Doing Impact analysis and working with a variety of tools: Power designer, IBM Infosphere Information Governance Catalog etc...
Defines the information architecture principles, and Develop new models as required that enable
the implementation of the intended business architecture in Data Vault Model. creating MCD,MLD,MPD
Builds the enterprise metadata repository based on the information flow and usage, understands profiles of the data required including volumetric. Works closely with the data governance and the development teams to co-create the Source to Target Mapping (STTM) document.
Tesing and develop Data Stage Jobs to ingest data into Staging area and then into DWH.
Integrate and map data into existing data vault tables as requested by Business and data consumer.
Helping on Configuration of Datastage. managing workflow management in DEV. support for trouble on DataStage, cleaning file system, kill process, involving in restarting the server. Creating creating SEQ/jobs to go through all project and do reset of all job in different project which has not success state, to do clean up on jobs in not runnable state
_ IBM InfoSphere DataStage 11.3 (Enterprise Edition), Linux, Oracle,flat file,DB2 mainframe ,Postgre,TM5,TWS, Service Now,Track,IGC, Agile methodology,webfocus, fex file …

Client : BGL (BNP Paribas) (Luxembourg)
juin 2018 - mars 2020
Position : IBM DataStage Expert.
Project : DATAHUB, Personetics, CSDR,IHUB
Responsibilities:
Main task, to keep up to date DataHub from multiple sources system (Oracle, Flat file, XML, Postgre,SQlite,SQL Server)
by creating new generic jobs
Designed Data HUB target tables, on crypting and decrypting source data & splitting it into separate target tables
Write hundreds of DDL scripts to create tables, views and indexes, tables partitioning …
Assisted gathering business requirements and worked closely with Business Analysts
to develop Data Model, ETL procedures to design Data Warehouse.
Help to finalizing technical analysis mapping
Monitor and tune ETL processes for performance improvements identify, research, and resolve data warehouse
load issues (personetic batch load).
Define the scheduling requirements for ETL processes in Autosys, Job executions and load validations etc..
Creation RAI documentation,
working in fast-pace, agile environment agile scrum methodology using Harvest for move to Integration and MTP
Fixing bugs, issue and supporting production codes.
developing new projects such PERSONETIC, CSDR, etc.…
_ IBM InfoSphere DataStage 11.3 (Enterprise Edition), Linux, Oracle,flat file,XML Postgre,SQL Server, Autosys, Jira, harvest workbench, RAI, Agile methodology ,BO, Oracle Exadata

( + Remote support 24/7) Client : Renault (France)
septembre 2015 - février 2019
Position : ETL/DWH Consultant
Project : SQUAD (Datawarehouse)
Responsibilities:
Working in several project,
Ensure effective Design, Development, Validation and Support activities in line with client needs and architectural requirements,
adherence to the organizational guidelines and processes.
Developing Data warehouse applications including: Analysis, Requirements, Design, Coding, Testing, Deployment, Support and Upgrades & Migration. Setting up projects, developing generic job.
agile scrum methodology using IODA for move to Integration and MTP
Fixing bugs, issue and supporting production codes.
11.3 (Enterprise Edition), AIX, Oracle,flat file BO,SSAS,SSRS

(+ Remote support 24/7) Client : Delhaize (Belgium)
juillet 2015 - décembre 2017
Position : DataStage Consultant
Project : Retail (Datawarehousing)
Responsibilities

Help migrate Data Stage jobs from 8.1 to 11.3.
Setting up projects.
Testing and removing warning messages from all the jobs before moving to 11.3
11.3 (Enterprise Edition), AIX, DB2,Oracle,SQL, MainFrame ,TWS,XML,CSV, SSRS,Microstrategy

Datastage Technical team leader
Client : Fodfin – Ministry of Finance (Belgium)
octobre 2013 - juin 2015
Project : DWH3
Responsibilities
As a technical team leader starting a new project at FODFIN Belgium and part of my role was to understand how the business process works and to implement/deploy technology for the purpose.
Give one week training in Datastage 8.7.
Developing Datastage jobs from multiple source system to ODS (operational data store).
Developing Datastage jobs according to business requirements and help developers to design ETL datastage jobs for DWH3.
Creation of generic job and job Templates for juniors.
Coaching junior developers.
Prepare new MTP document to move jobs into ACC, PROD.
Prepare Development Guide and ETL Standard document.
Validation the design of job before moving to ACC.
Helping analysis for flow chart/ business logic.
Performing DBA task in DEV
Project _ Adding 10 new source to DWH

Position : Team Leader at IBM level 2
Client : IBM (UAE)
mars 2013 - septembre 2013
Project : Telecommunication

Mission/Project DWH (IT TELECOMUNICATION)

Responsibilities

Fixing Infosphere errors, interpret dump and associated log files (which had been provided via email)
understanding of error codes, ability to read dump files & logs, knowledge of fixes, root causes
Performance and tuning existing job.
Create SOP document.
Worked with Offshore teams. Support developer and operation team.
_9.1 (Enterprise Edition),AIX, Oracle ,...