CV SSMS : Nos derniers consultants inscrits

Résumé des missions d'Abaid,
freelance SSMS habitant Paris (75)

• Senior BI

  EUROPEAN INVESTMENT BANK (EIB) - LUXEMBOURG 20 MONTHS
  Jan 2021 - aujourd'hui

  BACKGROUND:
  Data Processing Projects
  ROLE:
  • Creation of reports directly in BO based on requirements obtained from mock-ups and discussions with users.
  • Visual rendering of the reports includes, among others, Gantt-Chart and Kanban (with different details subject
  to various filters).
  • Development/migration of new reports in BO based on existing SSRS reports.
  • Review the existing universe including correction of bugs
  • Animation of the workshops and the framing of business needs,
  • Data Extraction, Data Transformation, Data Construction, and Data Load using SAP BODS.
  • Designing complex SAP Data Services job flows to extract from/load to SAP systems and other DBs.
  • Create Load Programs in BODS to load different data objects.
  • Design jobs in SAP BODS & BODS scheduling and Management Console.
  • Core Banking Interfacing T24.
  • Analysis and definition of user needs, elaboration of functional specifications
  • Recipe/ Preparation of recipe books, integration recipe, monitoring of functional and technical recipes.
  • Drafting of the operating file (switchover plan and instructions for starting production)
  • Set up the Business intelligence (KPI, reporting’s complex …)
  • Creating KPI and Report Power BI and Tableau
  • Proficient in Data Engineering and adept at data integration using the Informatica Central stack, with a focus on
  PowerCenter.
  • Creating script SQL complex, SSMS SQL SERVER management
  • Train End-users
  • Process mapping: Identification of business process impacts and update of procedures.
  3

  Power BI, Tableau, SAP BI 4.2-3, SAP BW4/HANA, SQL, T24, SQL Server, Azure Data Studio, SQL/PL-SQL, SAP Web Intelligence, SharePoint, MS Project

• MANAGER BI

  DAR ALAMAN ISLAMIC BANK - CASABLANCA
  Jan 2017 - Jan 2021

  BACKGROUND:
  Projects New participative bank (SGMA DAR
  EL AMANE) ROLE:
  • Animation of the workshops and the framing of business needs,
  • Change management: Writing user manuals and training materials, facilitating training for trainers and users.
  • Management and implementation of integration project Anti-Money Laundering (AML) Siron V15
  • modules in CBS ETHIX- ERP and T24
  • KYC and KYT, FACTA extraction and XML files
  • Design/ Development of specifications, design files, functional specifications.
  • Analysis and definition of user needs, elaboration of functional specifications
  • Recipe/ Preparation of recipe books, integration recipe, monitoring of functional and technical recipes.
  • Drafting of the operating file (switchover plan and instructions for starting production)
  • Set up Business intelligence SAP BO universe (KPI, commercial reports, regulatory reports, etc.)
  • Manage several projects (costs, lead time, quality, and risks)
  • Reporting managing of projects Power BI and SharePoint, MS Project
  • Validation development & Unit testing
  • Mastery, SSMS SQL SERVER management
  • Design and implementation of the Data Warehouse, Data Marts for the BI layer and regulatory reporting,
  • Set up bank statements and desktop publishing and GED.
  • Monitoring the Banking Reporting Back Office and Agencies activity.
  • Implement the Bank Overhead Project.
  • Process mapping: Identification of business process impacts and update of procedures

  SAP BI-BO, Power BI, Oracle, SQL Server, SQL/PL-SQL, SAS, SIRON V15, Crystal Report, MICROSTRATEGY, SAP ANALYTICS CLOUD, JIRA, MS Project, SharePoint

• SENIOR CONSULTANT

  TOTAL
  Jan 2015 - Jan 2017

  BACKGROUND:
  Support & Project HRIS and SAP BO
  ROLE:
  • Formalize the information system needs of the Human Resources Directorate.
  • Indirect contact with the General Management, responsible for overseeing the entire technical activity.
  • Manage several projects (costs, lead time, quality, and risks)
  4
  • Oversee project design and delivery
  • Facilitation of scoping meetings and steering committee...
  • Administer, configure HRIS systems (HR ACCESS AND SAP HR).
  • Formalize, centralize the requests for evolution or correction from the different users within the human
  resources department (the project manager).
  • Train HRIS users, including pay and career managers. Assist with all HR contacts.
  • Write training materials and train SAP BI users,
  • Analyze, quantify, and carry out evolutions/projects in compliance with quality processes
  • Create/update all documentation related to projects/developments (STD, operating files, etc.)
  • Contribute to the modeling and production of dashboards, OLAP cubes, dashboards...
  • Creating the Semantic Layer with MicroStrategy Architect
  • Construction of analysis documents with MicroStrategy Report Services
  • Transactional Reporting with MicroStrategy Transaction Services Participate/Facilitate
  • Meetings Conduct ongoing technology monitoring and be able to propose current solutions to meet needs and
  be consistent with the existing ones.

  SAP BI, Oracle, MySQL, SAP HR4U, HR Access, MICROSTRATEGY, Microsoft Project

• CONSULTANT

  ROQUETTE
  Jan 2014 - Jan 2015

  BACKGROUND:
  Support & BI Project
  ROLE:
  • Implementation of ETL SAP BODS solutions
  • developing real-time Interfaces like IDOC, BAPI SAP applications with SAP BODS
  • Application Scalable Maintenance Management
  • Analysis and definition of user needs, elaboration of functional specifications
  • Management Support and maintenance, Administration on BW.
  • Budget estimate: licenses, benefits
  • Definition of the architecture to be implemented
  • Review of new BI features 4.1
  • Animation of workshops and scoping business needs
  • Creation of Queries on BI 4.1 (info view, Rich Client) and SAP BW
  • Tests, validations, follow-up of the production of new applications
  • Mastery, SSMS SQL SERVER management, SYBASE IQ
  • Drafting of the Business Case (Production Plan and Instructions)
  • Administration of BI4.1 and SAP BODS
  • RP4.1 Installation and Training and SAP BODS
  • Modularization and design in Qlik Sense
  • Installation and Administration and Modeling SAP Business Objects Design Studio and SAP Lumira
  • SAP HANA Globalization
  5

  SAP BODS, BI 4.1, SAP BW 7.3, Dashboards 4.0, SQL SERVER, SSMS, ORACLE, SAP ECC6, FI-CO-MM-PS-IMPP-PMQM, BW-BPS, BI-IP, Qlik Sense, BO Design Studio, SAP Lumira, Sap HANA

• SENIOR CONSULTANT BI

  SAINT GOBAIN
  Jan 2011 - Jan 2014

  BACKGROUND:
  Support & BI Project
  ROLE:
  • Project management with Microsoft Project,
  • Management of international development teams,
  • Analysis and definition of user needs, elaboration of functional specifications,
  • Installation and configuring BODS,
  • SAP BODS design and architecture
  • Management Support and maintenance, Administration on BO, BW.
  • Definition of the migration plan, switching of ETL flows,
  • Migration XI R2, XI3.1 to BI Platform 4.0,
  • Definition of the architecture to be implemented, analyze the ETL issues and fix them independently,
  • Monitoring of production, performance, and development environments for applications, Business Object, SAP
  BW (installation, configuration, patches, backup administration, etc.)
  • Upgrade BW 3.5 to 7.0 project management,
  • Tests, validations, follow-up of the production of new applications,
  • Monitoring the implementation of new projects about the development teams,
  • Documentation and awareness-raising of the entities concerned on the techniques and solutions implemented,
  • Drafting of the operating file (plan and instructions for production),
  • Master of ETL BODI Data services solutions,
  • Tickets Services Now, Jira.

  SAP BODS, SQL SERVER, SSMS, SAP BI4.1, SAP BW, QlikView, SAP ECC6, FI-CO-MM-PS-IM-PP-PM-QM, BWBPS, BI-IP, Service New, JIRA

• CONSULTANT BI

  VALLOUREC
  Jan 2010 - Jan 2011

  BACKGROUND:
  Support & evolution of the decision-making IS
  ROLE:
  • Design and development on Business Objects (version 5, 6.5, XI, XI 3.0, XI 3.1).
  • Installation of BO platforms.
  • Training of users.
  • Administration account management and right on BO.
  • Creation and evolution of the Business Objects universe all version
  • Migration BO 5,6.5, XI R2 to BO XI 3.1
  • SAP BW ODS and Cube Loading Monitoring
  6
  • Repair data loading issues, technology watch, ... SAP BW
  • Drafting of the Business Case (Production Plan and Instructions)
  • Creation of tables under oracle and administration

  ORACLE, VB, C++, Proc C, BUSINESS OBJECTS 5.1.8- 6.5- XI- XI 3.0- XI 3.1, SAP BW

• CONSULTANT BI

  FRANCE TELECOM
  Jan 2008 - Jan 2010

  BACKGROUND:
  BI support and evolution
  ROLE:
  • Design and development on BO (version 5, 6.5, XI, XI 3.0, XI 3.1). Administration account management and
  right on BO.
  • Creation and evolution of the BO universe all version
  • Implementation of DM2 (solution proposal) for project developments.
  • Internal System Migration (SQL, PLSQL*) to BO XI 3.1 Drafting of technical and functional specifications.
  • Development of test plan and test scenarios
  • Unit, integration, and acceptance tests
  • Development and writing of test report files
  • Correction of anomalies
  • Drafting of the Business Case (Production Plan and Instructions)
  • Evolution of Datamart DATA FEDERATION SAP

  ORACLE, SYBASE, TERADATA, DATA FEDERATOR, BUSINESS OBJECTS 5.1.8- 6.5- XI- XI 3.0- XI 3.1

• CONSULTANT BI

  PSA PEUGEOT-CITROEN -
  Jan 2008 - Jan 2008

  BACKGROUND:
  Support & Project
  ROLE:
  • Project Management with Microsoft Project
  • Evolution of Oracle Datamart
  • Evolution of the ETL Sunopsis (ODI) feeding process
  • Evolution de universe Business Objects
  • Administrator CMC BO
  • Breakdown of the "Countries" summary into eight tabs (economic, commercial, networks) under Bu...