CV/Mission de Consultant BI Alteryx freelance

Exemple de missions de Daniel,
Consultant BI Alteryx habitant ?

WORKING EXPERIENCE

PHILIP MORRIS, Lausanne, Consultant Data Architect for SAP MDG-ERP integration
from July 2019
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

IMERYS, Paris, Consultant ETL and Data Transformation - Data Migration project (Finance and Supply Chain to SAP S/4 HANA) February 2019 - Jun 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

SOPRA STERIA, Toulouse, Data Architect for Data Analytics projects running on HANA and Hadoop platform at AIRBUS
Consultant
May - Jul 2018 / Nov - Dec 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

Laboratoires Pierre Fabre, Castres, SAP Data Migration Lead from legacy systems to SAP S/4 Hana From Jun 2017
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

Nestlé, Vevey, Consultant Business Analyst / Database Expert
November 2012 / Jun 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)

• 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

SICPA, Lausanne, Consultant ETL / Database Expert and Funtional analyse
TeamWork Consultant
April 2010 / July 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

• 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

GIVAUDAN, Genève, Consultant ETL / Database Expert and Functional analyse
HAYS Consultant
March 2007 / December 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

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

AIR France, Toulouse, Business Objects Developer,
SSII APSIDE Consultant
December 2006 / February 2007

Department Data Warehouse Revenue. Development of Business Objects universes for decisional reporting. Merging databases KLM/AIR FRANCE. (SSII Apside consultant)

Technologies: Teradat...