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 Transformation - Data Migration project (Finance and Supply Chain to SAP S/4 HANA)

  IMERYS, Paris,
  Jan 2019 - Jan 2019

  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 platform at AIRBUS Consultant

  SOPRA STERIA, Toulouse,
  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

• AMOA, Blueprint phase

  Laboratoires Pierre Fabre, Castres, SAP Data Migration Lead from legacy systems to SAP S/4 Hana
  Jan 2017 - aujourd'hui

  • 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.

  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 TeamWork Consultant

  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.

  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)

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

• aujourd'hui

  • 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

• aujourd'hui

  • 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

• aujourd'hui

  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