CV/Mission d'Expert datastage freelance

Exemple de missions de Behrouz,
Expert datastage habitant ?

• Position : IBM DataStage Expert

  Client : BEI BANK - The European Investment Bank
  Jan 2022 - aujourd'hui

  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

• Position : IBM DataStage Expert

  Client : ING BANK
  Jan 2021 - Jan 2021

  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

• Position : Data Modeler, Data Migration Analyst, IBM DataStage Expert.

  Client : BCEE BANK(The State Bank and Savings Fund of Luxembourg)
  Jan 2020 - Jan 2021

  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 …

• Position : IBM DataStage Expert.

  Client : BGL (BNP Paribas) (Luxembourg)
  Jan 2018 - Jan 2020

  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

• Position : ETL/DWH Consultant

  ( + Remote support 24/7) Client : Renault (France)
  Jan 2015 - Jan 2019

  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

• Position : DataStage Consultant

  (+ Remote support 24/7) Client : Delhaize (Belgium)
  Jan 2015 - Jan 2017

  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)
  Jan 2013 - Jan 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

• Position : Team Leader at IBM level 2

  Client : IBM (UAE)
  Jan 2013 - Jan 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 ,...