CV/Mission de Consultant BI Alteryx freelance

Exemple de missions de Daniel,
Consultant BI Alteryx habitant ?

• Consultant Data Architect for SAP MDG-ERP integration

  PHILIP MORRIS, Lausanne
  Jan 2019 - aujourd'hui

  Master data Project – writing specifications for ownership, governance, approval, replication
  MDG configuration for Standard MDG objects and modelling Custom Objects (Product, Equipment)
  Interface requirements for Data Exchange (RFC, ALE/IDOC, API…)
  SAP Security roles (users roles and permissions)

  Technologies: SAP S/4 HANA, SAP MDG, SAP BODS, SAP Information Steward, SAP PI, MS Power BI, Jira scrum board

• Consultant ETL and Data

  IMERYS, Paris
  Jan 2019 - Jan 2019

  Transformation - Data Migration project (Finance and Supply Chain to SAP S/4 HANA)Responsible for Data Quality of Master Data and Data Migration activities
  Definition of the solution to support migration of legacy data into the SAP S/4 HANA (Procure to Pay, Order to Cash, Fi/Co, Manufacturing) to support system testing, user acceptance testing and go lives
  Develop relationships with a wide array of stakeholders to understand the business data requirements
  Facilitate cross-functional meetings/presentations with various level of management
  Data assessment and mapping activities, and architect the underlying migration framework to extract, cleanse, transform, validate, enrich and load the legacy source data
  Review and approve data conversion requirements and mapping specifications to ensure fit for purpose for target solution (Collaboration with Solution Stream - OTC, PTP, Finance, Manufacturing, Maintenance, Quality)
  Execute technical leadership on Building conversion process leveraging SAP Data Services as the central conversion toolset, working with multiple sources stored in a central data repository
  Design and build of data validation reports and data error checking reports

  Technologies: SAP S/4 HANA, SAP MDG, SAP BODS, SAP Migration Cockpit

• Data Architect for Data Analytics projects running on HANA and Hadoop platformConsultant

  SOPRA STERIA, Toulouse at AIRBUS
  Jan 2018 - Jan 2018

  Data Architecture for Data Analytics projects
  Review of SAP HANA STUDIO Data Analytics projects at AIRBUS
  Focus on SAP HANA development Best Practices
  Hadoop / Spark design review
  Qlik Sense, HANA, SAP UI5 front-end integration
  Identification of gaps and improvement proposal
  Solving performance issues

  Technologies: SAP ECC, SAP HANA, SAP HANA STUDIO, Hadoop, NoSQL, Spark, Amazon AWS S3, OData, UI5, Qlik Sense

• SAP Data Migration Lead from legacy systems to SAP S/4 Hana

  Laboratoires Pierre Fabre, Castres,
  Jan 2017 - aujourd'hui

  AMOA, Blueprint phase
  • Definition of the strategy and solution to support the migration of legacy data into the SAP S/4 HANA (Procure to Pay, Order to Cash, Finance /Controlling)
  • Identification and qualification of source data to satisfy master and transactional data requirements for the SAP S/4 Application
  • Lead data assessment and mapping activities, and architect the underlying migration framework to extract, cleanse, transform, validate, enrich and load the legacy source data
  • Execute technical leadership on the use of the technology platform and tools to perform the profiling and migration of legacy data
  • Planning and managing the efforts of technical developers, Data Steward
  • Definition of the roll-out strategy with pre-cutover and cutover activities

  Technologies: SAP S/4 HANA, SAP ECC + Other Legacy systems, BODS Rapid Data Migration, Alteryx, SQL Server, ALM, Redmine, SharePoint

• Consultant Business Analyst / Database Expert

  Nestlé, Vevey
  Jan 2012 - Jan 2017

  Responsible for the GLOBE Master Data Repository exposed to the Complementary Applications (i.e. non-SAP applications) via a complex ETL/SQL based architecture.• Rework the existing architecture to overcome the current limitations and to cope with the future requirements
  • Act as the primary contact with stakeholders to collect business requirements
  • Writing functional requirements/ technical specifications
  • Design and support of the new Master Data Repository and ETL projects
  o Design of Central Data Repository
  o Design of ETL processes extracting from SAP and BW to feed SQL Server Master Data Repositories dedicated to Third party applications
  • Design and support Migration process of ETL applications:
  o Migrating ETL applications from INFORMATICA to BODS 4.x
  o Migrating Database content from SQL Server to SAP HANA XSA
   SAP HANA Studio - CDS artifacts development, Calculation Views
  o Migrating from BODS extraction jobs to LTRS (Landscape Transformation Replication Server) / SDI (Smart Data Integration)
  • Coordinate developments with development teams
  o BODS Data Profiling, Standardization, Data Cleansing, Business Rules implementation, Deduplication)
  • Source management with Team Foundation Server
  • Batch execution schedule with Tivoli Workload Scheduler
  • Manage releases content
  • Conduct the testing phases (Test plan and Non Regression Tests) with HP ALM/QC
  • Communicate with zones and users
  • Act as the primary contact for Master Data Repository 3rd level support

  Technologies: SQL Server 2008/2012, Oracle, SAP HANA Design Studio, SAP HANA IDE XSA, SAP ECC (Vendor, Material, Customer etc.), BW, ETL BODS 4.x (Management Console, Designer, Central Repository) / Informatica Power Center 8.5.1 - Designer, Workflow Manager, Workflow Monitor), Power Designer, Visio, TOAD, Quality Center (Application Lifecycle Management)

• Consultant ETL / Database Expert and Funtional analyse

  SICPA, Lausanne
  Jan 2010 - Jan 2012

  SAP Roll-out for SICPA’s European factories: (Spanish and Swiss production factories)
  
  Responsible for ETL flows for Data migration from AS400 to SAP SD, MM, EH&S, FI-CO - Master Data and Transactional Data Conversion Processes:
  Analyse phase/ Extraction/ Transformation/Cleansing / LSMW built/ Rollout.• Conduct and participate in information gathering workshops, interviews with key users, and design sessions necessary to capture the business needs and develop conceptual business models
  • Source systems analysis - BPCS (Customers, Vendors, Materials, BOM, Recipes)
  • Data cleansing, standardization, deduplication, gap analyse, validation with Business
  • SQL Database Modelling, T-SQL procedures (Business Transformation)
  • Data integration with Business Objects Data Services 4.x:
  • Test plan and Non Regression Tests
  • BODS Administration and Configuration, Central/Local repository management
  • Data Integrator and Data Quality development (Data Profiling, Standardization, Data Cleansing vs. Dictionaries and Business Rules, Deduplication)
  • Jobs Scheduling and Monitoring

  Technologies : SQL Server 2008, SAP ECC6 – SD/MM/PP/FI-CO, SQL Server, Oracle 10/11g, DB2, AS400, UNIX, Business Objects Data Services 3.x /4.x, LSMW, ABAP, T-SQL, TOAD, BPCS Legacy Systems, PowerPoint, MS Project, Sql Studio Management, Quality Center, Power Designer

• Consultant ETL / Database Expert and Functional analyse HAYS Consultant

  GIVAUDAN, Genève
  Jan 2007 - Jan 2009

  SAP Roll-out for Givaudan’s worldwide production sites: (France, Switzerland, Germany, Netherland and UK) - Knowledge transfer for USA Rollout
  
  Responsible for Master Data and Transactional Data Migration: Migration from AS400 into SAP (SD, MM, FI-CO, QM, PM, EH&S, BW), ETL (Master data – Customers, Vendors, Materials, FI-CO - Transactional data, Historical data)
  Analyse phase
  • Integration of Order To Cash and Procure to Pay SAP business processes.
  • Conduct and participate in information gathering workshops, interviews with key users, and design sessions necessary to capture the business needs and develop conceptual business models
  • Understanding the SAP Business Processes and translating into conceptual data models and IT solution
  • Writing high level specifications and functional specifications
  • Coordinate with internal business teams to validate data models
  • Coordination and communication of task status
  • Creation and maintenance of project plan
  • Coordination of data flow dependencies and data quality processes: Identifying data sources and targets, Evaluating data quality, data mapping and data migration assessment, Source-to-target gap analysis an multiple systems impact assessment, Planning for resolving gaps in the source to target data mapping, Initial data quality assessment
  
  Data Transformation
  • Implementation of Data Quality plans and Transformation rules (Informatica Data Quality)
  • Technical Design for Staging Database architecture based on the input of functional designs
  • Design of DataSatage Extraction / Transform chain
  • Generate analysis plans
  • Monitor and enforce compliance of data dictionary standards to minimize data redundancies and enhance information quality throughout the organization.
  • Data Quality Analysis plans, Scorecards, KPIs
  • Cleansing plans: Removing noises, Standardization plans
  • Data deduplication process with Athanor
  
  SAP Master Data Migration
  • Testing phases (Unit, Integration, Regression tests)
  • SAP Roll-out: Migration and testing within SAP (SD, MM, FI-CO, QM, PM, EH&S, BW)
  • End-users support

  Technologies: SAP ECC6 – Oracle 10/11g, UNIX, INFORMATICA Data Quality/Athanor, DataStage, LSMW, ABAP, PL/SQL, TOAD, PowerPoint, MS Project, Mercury

• Business Objects Developer,

  AIR France, ToulouseSSII APSIDE
  Jan 2006 - Jan 2007

  Department Data Warehouse Revenue. Development of Business Objects universes for decisional reporting. Merging databases KLM/AIR FRANCE. (SSII Apside consultant)• Information gathering workshops, interviews, and design sessions to capture the business needs and develop conceptual business models
  • Design and develop conceptual, logical, physical data models for data warehouse and transactional database applications (Star schema)
  • Coordinate with internal teams and DBAs to ensure creation of physical database
  • Develop reusable architectural data components, identify opportunities for shared data
  • Development of extraction scripts (UNIX scripts) from flat files into teradata database.
  • Business Objects universes, new indicators, review data mart and data warehouse designs

  Technologies: Teradata, Fastloader, Oracle 9i, Business Objects (Designer, Administrator), TOAD, PL/SQL, Sqlloader, Sql*Plus, UNIX, Visio, MS Project.

• Lifecycle Developer, Datawarehouse / BI environment

  EUMETSAT, Darmstadt, Germany, Software
  Jan 2003 - Jan 2006

  European Organisation for the Exploitation of Meteorological Satellites - Technical Support Division, Software Development. (SSII Apside consultant)
  
  Responsible for Data Migration and Software development life cycle. Datawarehouse / BI
  • Conduct information gathering, interviews, design sessions to capture the business needs and develop conceptual business models
  • Database migration (from SQL Server to Oracle using Oracle Migration Workbench)
  • Maintenance of Business Objects Universe (Finance, Operations)
  • Metadata management (Mapping, Transformations, star schema)
  • Enhancements of new Application features, Test, validation, rollout - Project Management Tool, Budget/Cost control, Payroll, Financial applications
  • User requirements analysis, Verification, Validation and Tests.
  • Documentation (Design, Hardware, System specifications, configuration, user guide).
  • Coordination of delegated tasks:
  o Loading process (PL/SQL, SQL Loader), Archiving process (partitioning)
  o Backup and recovery procedures, Database design and implementation.
  o Database tuning and performance monitoring, Database security,
  • Define the working procedures templates ISO 9001:2000:
  o Maintenance scope, System and Software Development and Maintenance, System Requirements Specification Template, Software Design Specifications, Verification and Validation Specifications and Procedures, Test Record, Inspection Record, Coding Standards, Major/Minor/Patch Release Milestone Checklist.
  • Design of 𠇊nomaly Processing Tool”: (used to track anomalies related to Meteosat Second Generation development, Eumetsat Polar System development).
  • Conducting Functional specifications (user requirements, UML, use cases, validation)
  • Hardware and System specifications (architecture, design, configuration)
  • Application modeling and design: (UML, Oracle, UNIX, PL/SQL, VB6, Java)
  • Data migration (from SQL Server to Oracle using Oracle Migration Workbench)
  • Development, Test and Production environment.

  Technologies: Oracle Enterprise Manager, Business Objects (Designer, Administrator), MS SQL, T-SQL, Sql Optimizer, Oracle 10g TOAD, UNIX, Java, VBA, MS Project, Configuration Management Tool, Bugzilla.

• Business Process Analyst

  France TELECOM, 33000 Pessac, France,SSII ALGORIEL TECHNOLOGIES
  Jan 2002 - Jan 2002

  French telecommunications provider, Billing Information System department, France. Project e – billing:
  Responsible of UML modelling. UML design, Business logic and System analysis: SOA architecture.
  • Implementation of E-Billing Archiving System to provide customers with data on line.
  • Business analysis (Identification of business processes and business resources
  • System analysis: Class diagram, Use Case diagram, Activity and Sequence diagram.

  Technologies: UML design with Objecteering 5.1