Daniel - Consultant AIX

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: Teradata, Fastloader, Oracle 9i, Business Objects (Designer, Administrator), TOAD, PL/SQL, Sqlloader, Sql*Plus, UNIX, Visio, MS Project.

• 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


EUMETSAT, Darmstadt, Germany, Software Lifecycle Developer,
Datawarehouse / BI environment
SSII APSIDE Consultant
January 2003 / November 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

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.

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


France TELECOM, 33000 Pessac, France, Business Process Analyst
SSII ALGORIEL TECHNOLOGIES Consultant
April 2002 / December 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.

Technologies: UML design with Objecteering 5.1
• 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.


FRANCE TELECOM, Research & Development, BI dept. , Paris, Datawarehouse Developer.
SSII UMANIS Consultant
July 2001 / March 2002

Project: Implementation of a Marketing Analysis Information System.
Software Engineer, in charge of Data Warehouse development.

Technologies: Oracle 8.i, UNIX AIX, DataStage, Business Objects. Volume => 20 To.

• Conduct and participate in information gathering workshops, interviews, and design sessions
• Design and develop conceptual, logical, physical data models for data warehouse and transactional database applications (Dimensional data modelling)
• Coordinate with internal project teams, and DBAs to ensure creation of physical databases
• Database tuning (Star schemas, Parallel execution, bitmap indexes)
• Metadata management (from OLTP to Data warehouse) - (DataStage)
• Business Objects universes, (hierarchy, dimension, fact tables), Aggregate navigation


VALEO Distribution, Automotive equipment supplier, Paris, Database Engineer
SSII UMANIS Consultant
April 2001 / Jun 2001

Database Engineer, in charge of Data Warehouse design.

Technologies: Oracle 8.i, PL/SQL, DBA studio.
• Database loading (PL/SQL stored procedures).
• On-line Data restitution on Intranet via Java classes.
• Database tuning, Data archiving and data retrieval (Partitioned tables).


CGI Bank, Lille, France, Datamart Designer for Asset Management in industrial sectors
SSII UMANIS Consultant
February 2001 / March 2001

Database Engineer, in charge of Datamart design for Asset Management in industrial sectors

Technologies: Oracle 8.i, PL/SQL, DBA studio.
• Business analysis.
• Development of PL/SQL procedures.


ALLIANZ POLSKA Insurance Company, Warsaw, Poland, Datawarehouse Designer
SSII UMANIS Consultant
October 2000 / January 2001

Responsible of Data Warehouse design. Motor Policies and Motor Claims Datamarts.

Technologies: Oracle, Designer 2000, DataStage, PL/SQL, Cognos Powerplay, Impromptu).
• Design and develop conceptual, logical, physical data models for data warehouse and transactional database applications (hierarchy, dimension tables, fact tables).
• Coordinate with internal teams, and DBAs to ensure creation of physical database.
• Develop reusable architectural data components, identify opportunities for shared data
• Metadata management ETL from OLTP to Data warehouse (DataStage).
• Generation and maintenance of Cubes models to fulfil user’s requirements.
• Reports (sources: database contents, XML files, stored procedures, Web Connect).

CREDIT LYONNAIS Bank, Paris. Web site Developer for Company employee savings
Consultant SSII UMANIS
Jun 2000 / September 2000

Software engineer in charge of database design. Web site for (Company employee savings).

Technologies: HTTP Server, Websphere Application Server, WebSphere Studio.
• Class diagram, UML modeling.
• Java programming, Servlet, JSP, Java script, JDBC.

INTERESTS

Reading, music, sciences, football, travelling.

REFERENCES

Christian Jeker: Data Integration Project Manager - Nestlé GLOBE Technology Solutions,
+41 79 239 47 19

Frédéric Hanset: SAP Project Manager - Sicpa S.A., Av. Albert Amon 1, 1373 Chavornay, Switzerland. Mobile: +41 76 532 32 21

Gerry Lucca: SAP Outlook Project Manager - SAP Data Migration/ Deployment - Givaudan: Tel: +41 22 989 60 76. Mobile: +41 79 358 22 10.