Daniel - Consultant AIX

Ref : 111227T002

Profil

Consultant, Développeur, Consultant fonctionnel, Chef de projet (58 ans)
Domicile

1814 VETRAZ - MONTHOUX
Mobilité

Occitanie, Auvergne-Rhône-Alpes

Compétences

AIX

SAP

SQL Server

Business Objects

ABAP

DataStage

Business Objects Data Integrator

Cognos Query Studio

Cognos Report Studio

Oracle 11g

Expériences professionnelles

Consultant Data Architect for SAP MDG-ERP integration

PHILIP MORRIS, Lausanne
juillet 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
février 2019 - juin 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
juillet 2018 - novembre 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,
juin 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
novembre 2012 - juin 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
avril 2010 - juillet 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
mars 2007 - décembre 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
décembre 2006 - février 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
janvier 2003 - novembre 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 “Anomaly 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
avril 2002 - décembre 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

Études et formations

Master degree in Business Intelligence (Database fundamentals, Data warehousing, Data Mining, Web services), granted 5 years after Baccalaureate

University of Luminy (Marseille), department of computer sciences(Diploma of Higher Specialist Studies)
1999

Langues

Anglais - C2

Autres compétences

PRACTICE OF DESIGN – METHODS AND PERSONAL SKILLS

Full Project Lifecycle: (Scope, Analyse, Requirements Specification, Software and Business Process Modelling, Data Modelling, Development, Test, Acceptance, Rollout, Time line, Cost). Method Waterfall, AGILE, CMMI, Solution Delivery Management, Planning and scoping project, business needs, Establishing Data Governance strategy, Project planning considerations, reporting, overall activities planning, MS project, High degree of autonomy, good personal communication skills and strong project-oriented

TRAINING

• SAP HANA XS-A WEB IDE (SAP Education Suisse Romande) – January 2017
• SAP HANA Design Studio / HANA Server – LTRS/SDI/SDQ (SAP Education Suisse Romande) – November 2015
• Business Objects Data Services, (Administor, Data Integrator, Data Quality, Data Profiler) Jun 2010, Lausanne
• Informatica Data Quality Management (ATHANOR), London, March 2007.
• Oracle DBA 1, Bordeaux, January 2003.

COMPUTER SKILLS

Business Analyse: Act as primary contact with requestor to collect business requirements, writing functional and technical specifications, process analyse and process definition
Business Process: SAP Order To Cash / Procure To Pay Business processes, Master Data knowledge for Sales & Distribution, Material Master, Bill of Material, Recipe, Production Planning, Plant Maintenance, FI & CO, Software and Business process modelling
Data Quality Management: Data Analysis (Conformity, Consistency, Completeness, Accuracy, Integrity, Duplication, Timeliness), Data Quality Activities (Data Profiling, Data Cleansing, Data Standardization, Data Deduplication, Data Consolidation, Data Validation)
Modelling: UML, Relational/Star/Snowflake and Multi-Dimensional modelling,
Datawarehouse design, PowerDesigner: (Data Modeling, Entity/Relationships)
Tests: Testing phases (Unit, Integration, regression Test), Risk, Mitigation plan
SAP LTRS /SDI/SDQ: Real-Time Data Replication with SAP Landscape Transformation Replication Server, Replication Task, Flow Graph
SAP HANA Design Studio /Web-based Development Workbench: Core Data Services (CDS) development – CDS artifacts managed in SAP HANA repository, Calculation View
Business Intelligence: Business Objects 6, XI: Solution Reporting: (Dashboarding, Cube OLAP – drill down/drill up, Web Intelligence, Desktop Intelligence, Query Reporting Analyse, Crystal Reports), BO Administrator. BW, BEX Analyser, BEX Query Designer, BEX Report Designer
Databases: Database Architecture and Design, SAP HANA DB, SQL Server 2008/2012 (SSIS), DB2, Teradata, Oracle 10/11g
Languages: PL/SQL, SQL, T-SQL, XML, ASP, VB 6, Java, JSP, UNIX Script

EDUCATION

Master degree in Business Intelligence (Database fundamentals, Data warehousing, Data Mining, Web services), granted 5 years after Baccalaureate, University of Luminy (Marseille), department of computer sciences, 1999-2000. (Diploma of Higher Specialist Studies)

French: Mother tongue / English: Fluent / Spanish: Basic.

Recommandations reçues

Recommander Daniel

Daniel n'a pas encore reçu de recommandations.

D'autres freelances
Consultant AIX

Ces profils pourraient vous intéresser !

SDM / problème manager

BOULOGNE-BILLANCOURT

Unix Windows Control-M AIX

Chef de projet PERL

JOINVILLE-LE-PONT

Perl AIX AMC Designor Agile Bash Big Data DevOps Windows Git

Consultant AIX

Paris

AIX Pack Office Networker

Consultant AIX

Marseille

AIX

Consultant AIX

AIX Solaris Linux Java HTML XML JavaScript Visual Basic SQL

Consultant PMI PMP

Paris

PMI PMP Agile AIX

Consultant AIX

AMIENS

AIX Pack Office

Architecte AIX

Paris

AIX SQL Server Linux Red Hat Solaris SAN IBM NetApp

Chef de projet MERISE

Annecy

Merise UML CMMI QlikView SharePoint PowerPoint AIX Linux COBOL

Chef de projet ITIL

Annecy

ITIL Linux Agile XP DHTML Windows NT AIX HP-UX Unix Access Windows 2000

Disponible

Mme

Prénom ^*

Nom ^*

Email ^*

Téléphone ^*

Ville ^*

Avez-vous trouvé une mission ? ^*

J'accepte d'être contacté par nos partenaires, experts en portage salarial et j'accepte la politique de confidentialité du site www.freelance-informatique.fr

Domaines d'expertise liés

CV en rapport

Daniel - Consultant AIX

Consultant, Développeur, Consultant fonctionnel, Chef de projet (58 ans)

1814 VETRAZ - MONTHOUX

Consultant Data Architect for SAP MDG-ERP integration

Consultant ETL and Data

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

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

Consultant Business Analyst / Database Expert

Consultant ETL / Database Expert and Funtional analyse

Consultant ETL / Database Expert and Functional analyse HAYS Consultant

Business Objects Developer,

Lifecycle Developer, Datawarehouse / BI environment

Business Process Analyst

Master degree in Business Intelligence (Database fundamentals, Data warehousing, Data Mining, Web services), granted 5 years after Baccalaureate

D'autres freelances Consultant AIX

SDM / problème manager

Chef de projet PERL

Consultant AIX

Consultant AIX

Consultant AIX

Consultant PMI PMP

Consultant AIX

Architecte AIX

Chef de projet MERISE

Chef de projet ITIL

D'autres freelances
Consultant AIX