Utilities Group 02/15 ? present
Migrating BW 7.3 to BW-on-HANA 7.4
Lead for HANA migration as architect.
Concepts and overall architecture of HANA and HANA-related new technologies implementing self-service BI strategy.
Technical implementation manager for HANA migration and related role-out projects.
Adopting new SCRUM methodology across all teams, scoping user stories and epics.
Sizing analysis and reducing DB size.
Housekeeping and technical preparations for migration (ASU-toolbox, Notes, etc.)
Post-migration tasks, HANA optimization
Role-Out of HANA Studio to developer team.
Facilitate BW Modeling Tools as new perspective in HANA Studio.
HANA views (calculation views, analytical views, attribute views),
Composite Providers (new type), advanced DSO?s, Open ODS views.
Defining developer guidelines and naming conventions for native HANA development and new BW objects.
Development Framework: Setup initial package hierarchy and schemata
Concept for HANA transports introducing HANA Lifecycle Application Management (HALM) in non-CTS+ environment. Enable CTS+. Migration to from HALM to CTS+/Solution Manager based standard transport process.
Security and role concept utilizing HANA repository roles.
Facilitating system-generated HANA views for existing BW objects.
Setup of DBMS-based user and role management.
Migrating 3rd party Oracle based application to HANA native. Migrating Oracle schemata to HANA schemata. Facilitate code enhancements to in Java application. Stakeholder management.
Data migration with SLT. Trigger-based replication of IS-U data into HANA.
Using SDA for agile report development and prototyping, ODP framework, BODS
CRM: Market Communication Dashboard, monitoring disputed cases
HANA based pre-segmentation for customer segmentation process, campaign support
Integration of 3rd party non-SAP market data for CRM and HANA (Enomic)
Analysis for Office 1.4 and migration to 2.1
Roll-out Lumira for geo data visualization
Roll-out Design Studio for self-service dashboards and web-based reporting
Offering extranet BI reporting web services to 3rd party users
HANA Client installations, ODBC/JDBC access to HANA, INA Web Service, BO integration
?
Tools: ERP (FI, CO, MM, SD, HR), IS-U, HANA, BW, BI-IP, BO, BODS, SOLMAN, SDA, SLT
Lumira, Analysis Office, Design Studio
HP ALM (QC), Oracle, Sybase, Hadoop, Siebel CRM, SCRUM
Roles: project management, solution architect, architecture design and standards, change management, requirement engeneering, knowledge transfer
?
Global Manufacturer and Retailer [adidas] 02/14 ? 12/2014
New Planning Application for aligned Sales and Production Forecast of Global Group
New BI-IP based planning application running on BW on HANA with Planning Application Kit (PAK), facilitating direct end user input across the entire organization, replacing manual consolidation of excel files by HQ finance department
Global Integration for merging data over incremental global Roll-Out, data migration, homogenization, currency translation, implementing new Season Concept across all systems, decommissioning TM1 Cognos database
AFS
Master data, Organizational Hierarchy, Product Hierarchy, Material Master, Customers, Business Partner, Global Season, Pricing, Conditions, Discounts, AFS data sources, POS data, SD/CO enhancements
HANA
Native HANA, HANA studio, complex calculation views, composite provider, virtual provider, indexing
Master data management, Global integration, reference data, data homogenization
Authorization concept, role design, BAdI for virtual authorizations
Prototype AFS Migration to Fashion Management on HANA
BI-IP/BO 4
Planning functions, sequences, aggregation levels, query design, customer exit variables,
performance analysis and optimization, partitioning concept, archiving, Business Objects Analysis as planning frontend, workbook design, embedding planning sequences as ribbons, VBA
PPM
Aligning planning targets with PPM planning
Initiatives for waves and seasons
Project buckets, resource management
Project workflow changes
Tools: ERP (FI, CO, MM, SD), AFS, FMS, HANA, BW, BI-IP, PAK, BPC, BO, SOLMAN
Microstrategy, Jira, Confluence, PPM, Clear
Roles: requirement analysis, solution design, scoping, release management, knowledge transfer
International Mining Group [BHP Billiton] 06/13 ? 12/13
Change Cycle 1 ? first small project delivery cycle after closing 1SAP project
Restructure: Major organizational change for entire group merging legacy top-level consolidation groups into fewer new consolidation groups, divestments, switch from proportionate accounting to equity accounting
New management reporting (for board and group management committee):
Complex BI solution for monthly reporting on financial, HSEC, HR, production and marketing metrics combining consolidated financial actuals from BCS and BI budget and forecast figures.
Balance sheet reporting, income statement, cash flow, notes, commentary.
Monitoring project portfolio KPI?s of capital investment projects.
BCS
Customizing, Organisational Change
Master data management, management hierarchy changes, parent indicator, new legal entities and consolidation units, consolidation of investments, accounting method change to equity accounting, chart of accounts, account mappings
Data strategy, manual postings, reconciliation
ECC and BI impact from BCS changes
BI
BI System Landscape, Scope definition of BI design
Evaluating all reports affected by consolidation hierarchy change
Group management reporting, GMC report (monthly management report of group consolidated financial results to the board and group management committee)
Re-modelling and data cleansing of surrogate organisational characteristic (reporting unit) for data homogenization across the organisation
Treasury:
account monitoring, account balance reconciliation, deposit management, line management
Changes in metric definitions, business process optimisation and impact on ARIS process definitions, ETL process optimization, BI Planning process changes, APD utilisation in ETL
BW 7.3 / HANA / BO 4
Migration strategy to BW 7.3
HANA evaluation vs. existing BI Accelerator
BI Fronted Tool Evaluation
Requirement engineering, functional specifications, scope management, change request management, task allocation, adopting new project methodology, liaising with team leads, process owners, business stakeholders
Tools: ERP (FI, CO, TR, PS), BW, BI-IP, BO, BWA, BCS, SOLMAN
Mercury, HP Quality Center, Concerto, ARIS, MS Access
Roles: project management, solution design, requirement analysis
International Retail Group [WIV International] 06/12 ? 05/13
Greenfield SAP Roll-out: ERP, CRM, BW, HANA, BO
FI, CO, Logistics
Balance Sheet, Controlling, SEPA, Group Consolidation
Customer Segmentation, CRM Activities
Pricing, Conditions, Transportation, Commissions, Credit Management
Material Master Data, Master Data Management, Customer Data/BP
BW 7.3 HANA / BO 4 Roll-Out:
Migration to BW 7.3
Migration to HANA
HANA Prototype, stress testing, defining CRM interface
HANA Studio, Virtual Cubes, Composite Providers, Indexing (BWA-Indices, indexed queries)
HANA Performance Optimization (for large customer base)
Analysis authorizations in BW
Data Modelling, LSA++
Customer-Exits in ERP and BW
Logistics Cockpit
Data Migration, import of legacy data from AS400
BO:
BW/BO integration
Advanced Analysis, Crystal Reports, pdf generation, email distribution list
CRM:
Campaigns and Marketing
Customer Segmentation, Segmentation Builder, BW Interface
WebUI, Webdynpro
Business Partner data synchronization
?
Tools: ERP (FI, CO, MM, SD, WM, TM, ICM, BP), IS-Retail, BW, BO, BPC, CRM, HANA, SOLMAN
SQL Server, Cognos, AS400 (iSeries)
Roles: project management, solution architect, requirement analysis, knowledge transfer
Media [Axel Springer] 01/12 ? 05/12
BW/BI 7.3 Upgrade and Business Objects 4 Roll-Out Project
Changes to concept for internal controls over financial reporting (controlling)
Improvement of Process Controls and System Access Management
Workflow for Role Assignment Requests
BW/BI-IP:
Switching to analysis authorizations in BW
Managing analysis authorization from central reference table
Roll-out technical content solution for managing analysis authorizations
Changes to legacy solution for managing selections
Customer-Exit changes
Performance Optimization for authorization checks in queries containing large hierarchies
Authorizations and security for BI-IP and BPS retraction into ERP
BCS:
Upgrade iasNotes 2.6 to Notes Management10.0
Organizational Changes
Security Concept for managing consolidation tasks
Performance Improvement
BO:
BW/BO integration
Integrated BI authorization concept
Single-Sign-On for BO
SAP roles for BO
New IFRS reports for balance sheet and notes
Tools: ERP (FI, CO, TR, HR), IS-Retail, BW, BCS, BI-IP, EP, GRC, ESS/MSS
Jira, Quality Center
Roles: solution design, coding, implementation management
Bank [African Development Bank] 02/11 ? 12/11
Portfolio and Project Management
Roll-out of new SAP PPM 5.0 in a SAP PS legacy environment as new platform for integrated portfolio, project and resource management supporting new IT governance principles and strategic IT portfolio development objectives.
Implementing new project initiation workflow, create reporting solution for portfolio monitoring replacing manually prepared excel files..
?
Hardware and Basis Strategy SAP Systems
Strategic decision on platform architecture
Hardware deployment strategy leveraging from existing boxes after ECC upgrade
Virtualization strategy for SAP systems
Identifying basis team staffing requirements
Utilizing external SAP hosting
Reviewing ISO 27000 certification documents of service provider
System Security
Validation of infrastructure and controls against internal security framework
Network Connectivity and VPN
User management in externally hosted systems
Tools: ERP (PS, HR, FI, CO), PPM, BW, BI-IP, EP, ADS, BO, CML, BPC, SRM
MS Project, Adobe Forms, IPsec, Mercury Quality Center
Roles: portfolio management, solution architect, RfP, vendor relations
Consultancy 07/10 ? 01/11
Global Procurement Analytics [Roche]
Upgrade Ariba 8 to version 9 (Buyer, Contract Management and Sourcing)
Extraction from both legacy Ariba 8 and new Ariba 9 into BW to facilitate analytical reporting on procurement, Rfx templates for project tenders, WBS configuration
Tools: ERP (MM, SCM, PS, HR), BW, BI, BI-IP, Business Objects XI 3.1, Xcelsius 2008,
Oracle, Ariba, TOAD
Roles: business analysis, solution design, data modelling
Concept for new BI Strategy and BI-IT Platform
Greenfield implementation of SAP ERP, CRM, gATP across all main subsidiaries
Re-structuring complex, grown legacy BI landscape (Teradata, BW)
Consolidating data into new MPP-enabled Enterprise Data Warehouse creating single point of truth for the first time ever:
Requirement analysis
Creating a reference architecture (topological rules)
Drive make of buy decision for the data model
Drive platform decision and architecture (ETL tools, OLAP tools, scheduling, etc.),
System landscape design, hardware sizing, resource allocation
Scoping implementation project preparing formal request for tender
Tools: ERP, CRM, SCM, gATP, BW, BI, BI-IP, Oracle, Neoview, Teradata, MS SQL Server,
Informatica, Ab Initio, Business Objects, Cognos, Arcplan, SAS, Microstrategy,
Control-M
Roles: business analysis, architecture and design, conceptional data model, roll-out plan,
project planning, vendor communication, RfI, RfQ
Colorado Project
Re-structuring UK business into new legal entity
Apply for new banking license from local regulator (FSA)
Organisational changes in ECC, BCS, BW/BI
Changes in Bank Analyser and Reporting BW to meet FSA requirements
Financial statement preparation for new legal entity, calculation run, module editor, RDB, Extraction into BW and BW reporting
New data streams (from special ledger), BI reporting changes on BCS data
Facilitate communication and requirement elicitation among business units and between the bank and the regulator / central bank
ECC Upgrade
Migration to ECC 6
Hardware upgrade, profile parameter changes, performance optimisation,
Solution Manager roll-out, interfaces to BCS and BI,
Functional: New GL, organizational changes
Authorisations and Role Management
Finance and Credit MI
Implementing new management information services for finance and credit risk reporting. Roll-out of Business Objects XI Rel 3.1 with SAP Integration Kit in a mixed BW 3.5/BI 7 landscape (WebI, Xcelsius) for balance sheet and cost reporting. Set up BOBJ-SAP platform, interfaces, authorisations. Consolidating credit and market risk data from BCS, Bank Analyzer and other systems into a new Credit Risk MI service (BOBJ). Commentary, ancillary database, input interface. BOBJ and BI query performance optimisation. Identify risk groups, liquidity reporting and treasury management
NAMA Project
Facilitate Management and Operational Reporting of loan portfolio at group level from different Business Units and from various technical platforms. Identify portfolio to be transferred to NAMA. Facilitate communication to regulator and auditors. Data consolidation and harmonization for assets from corporate and business banking across all subsidiaries. Implementation of new interfaces, Bank Analyzer enhancements. Architecture changes for syndicating NAMA data, create a Bank-in-the-Bank environment, organisational changes in ECC and BCS, NAMA enhancements in BW backend and BI-IP planning applications, reporting and authorization changes to ring fence NAMA data, query development, BOBJ integration, master data migration
Tools: Bank Analyzer (BA,CRA,FSP,DR,RR,BP), BW, BI, BCS, CRM, ECC: FI,CO,TR,HR
Business Objects; Unix, Oracle, MS Office, Lotus, ACBS, Murex, Summit, BIPS
Roles: business and process analysis, blue printing, architecture and interfaces, customizing
and development, change management, test management, release management
Integration of BW reporting into new group-wide Business Objects XI reporting platform
other manual authorization objects, BW and SEM authorizations)
1998 - 2003 Various data warehousing projects for clients Switzerland, Austria and Germany
1996 - 1998 STN International: Oracle database design and administration
Enterprise Data Warehouse Architecture (EDW), Layered Scalable Architecture (LSA, LSA++), BW Accelerator (BWA) und HANA, HANA Studio, SQL development;
Mixed landscapes of BW and BI7, BI upgrades, ASU Toolbox, system carve-outs and system mergers;
requirement analysis, blue print, implementation, ETL concept and administration, performance optimisation, data migration, support
ERP
FI: Accounts Payable, Accounts Receivable, New General Ledger, New GL Migration Cockpit, subledgers, Special Ledgers, Postings, Financial Information System, risk management, chart of accounts, FI Business Content
CO: Cost Center Accounting (CCA), profitability (COPA), activity based cost (ABC), cost elements, product cost, cost planning, profitability segments, inter-company trade / internal orders (OPA); standard hierarchy, multiple chart of accounts, profit center groups, information system, Pull vs. Push analysis, quantity consumption, function trees, flexible functions and formulae, CO reporting in BW/BI, CO-relevant master data, extractors; end-to-end requirement analysis and handling of change requests
TR: Cash Management and Cash Budget Management, Financial Management Areas, Commitment Item hierarchy, FI integration at posting level, treasury business content, treasury reporting and authorizations, CFM Transaction Manager Information System
HR/HCM: personnel management (PA), administration (PA-PA), manager?s desktop, cost planning, budget management, Employee Self Service (ESS), Manager Self Service (MSS), personnel time management (PT), time recording, evaluation, CATS, organizational structure, structural authorizations
Logistics: MM, SD, LO, LSE, PP, GTS;
purchase orders, vendors, BOM, inventory, sales orders, customers, deliveries, transportation cost, warehouses, inter-company trade, customs, product availability, pricing, billing, material cost, sales revenue and AR integration, short and mid-term capacity planning, relevant workflows and SoD, on-time delivery, Ariba integration, Supplier Relationship Management, tenders, demand planning (APO)
PS: networks configuration, subnetworks, assignments, WBS, organisational data, summarization hierarchy, activities, milestones, defining standards, Open PS for MS Project (interface), capital investment measures, billing plan, resource planning, capacity planning, work centers, bucket hierarchy
PPM: defining portfolios, portfolio item types, decision points, project budgeting/financial planning, FI integration, integrated phase model item/project, project management, project plan templates, resource management, teams and pools, Business Partner data and roles, project roles, MS Project import/export, PS integration, time recording, HR integration, organizational management, structural authorizations, access control lists, SoD in PPM and decision workflow
Weitere Länder: Flexibel hinsichtlich des Einsatzortes, und ausgewiesene internationale Erfahrung. Einsetzbar innerhalb Europas und darüber hinaus. Einsätze bisher u. a. in Europa (innerhalb, sowie außerhalb der Union), Mittlerer Osten, Afrika und Asien
Utilities Group 02/15 ? present
Migrating BW 7.3 to BW-on-HANA 7.4
Lead for HANA migration as architect.
Concepts and overall architecture of HANA and HANA-related new technologies implementing self-service BI strategy.
Technical implementation manager for HANA migration and related role-out projects.
Adopting new SCRUM methodology across all teams, scoping user stories and epics.
Sizing analysis and reducing DB size.
Housekeeping and technical preparations for migration (ASU-toolbox, Notes, etc.)
Post-migration tasks, HANA optimization
Role-Out of HANA Studio to developer team.
Facilitate BW Modeling Tools as new perspective in HANA Studio.
HANA views (calculation views, analytical views, attribute views),
Composite Providers (new type), advanced DSO?s, Open ODS views.
Defining developer guidelines and naming conventions for native HANA development and new BW objects.
Development Framework: Setup initial package hierarchy and schemata
Concept for HANA transports introducing HANA Lifecycle Application Management (HALM) in non-CTS+ environment. Enable CTS+. Migration to from HALM to CTS+/Solution Manager based standard transport process.
Security and role concept utilizing HANA repository roles.
Facilitating system-generated HANA views for existing BW objects.
Setup of DBMS-based user and role management.
Migrating 3rd party Oracle based application to HANA native. Migrating Oracle schemata to HANA schemata. Facilitate code enhancements to in Java application. Stakeholder management.
Data migration with SLT. Trigger-based replication of IS-U data into HANA.
Using SDA for agile report development and prototyping, ODP framework, BODS
CRM: Market Communication Dashboard, monitoring disputed cases
HANA based pre-segmentation for customer segmentation process, campaign support
Integration of 3rd party non-SAP market data for CRM and HANA (Enomic)
Analysis for Office 1.4 and migration to 2.1
Roll-out Lumira for geo data visualization
Roll-out Design Studio for self-service dashboards and web-based reporting
Offering extranet BI reporting web services to 3rd party users
HANA Client installations, ODBC/JDBC access to HANA, INA Web Service, BO integration
?
Tools: ERP (FI, CO, MM, SD, HR), IS-U, HANA, BW, BI-IP, BO, BODS, SOLMAN, SDA, SLT
Lumira, Analysis Office, Design Studio
HP ALM (QC), Oracle, Sybase, Hadoop, Siebel CRM, SCRUM
Roles: project management, solution architect, architecture design and standards, change management, requirement engeneering, knowledge transfer
?
Global Manufacturer and Retailer [adidas] 02/14 ? 12/2014
New Planning Application for aligned Sales and Production Forecast of Global Group
New BI-IP based planning application running on BW on HANA with Planning Application Kit (PAK), facilitating direct end user input across the entire organization, replacing manual consolidation of excel files by HQ finance department
Global Integration for merging data over incremental global Roll-Out, data migration, homogenization, currency translation, implementing new Season Concept across all systems, decommissioning TM1 Cognos database
AFS
Master data, Organizational Hierarchy, Product Hierarchy, Material Master, Customers, Business Partner, Global Season, Pricing, Conditions, Discounts, AFS data sources, POS data, SD/CO enhancements
HANA
Native HANA, HANA studio, complex calculation views, composite provider, virtual provider, indexing
Master data management, Global integration, reference data, data homogenization
Authorization concept, role design, BAdI for virtual authorizations
Prototype AFS Migration to Fashion Management on HANA
BI-IP/BO 4
Planning functions, sequences, aggregation levels, query design, customer exit variables,
performance analysis and optimization, partitioning concept, archiving, Business Objects Analysis as planning frontend, workbook design, embedding planning sequences as ribbons, VBA
PPM
Aligning planning targets with PPM planning
Initiatives for waves and seasons
Project buckets, resource management
Project workflow changes
Tools: ERP (FI, CO, MM, SD), AFS, FMS, HANA, BW, BI-IP, PAK, BPC, BO, SOLMAN
Microstrategy, Jira, Confluence, PPM, Clear
Roles: requirement analysis, solution design, scoping, release management, knowledge transfer
International Mining Group [BHP Billiton] 06/13 ? 12/13
Change Cycle 1 ? first small project delivery cycle after closing 1SAP project
Restructure: Major organizational change for entire group merging legacy top-level consolidation groups into fewer new consolidation groups, divestments, switch from proportionate accounting to equity accounting
New management reporting (for board and group management committee):
Complex BI solution for monthly reporting on financial, HSEC, HR, production and marketing metrics combining consolidated financial actuals from BCS and BI budget and forecast figures.
Balance sheet reporting, income statement, cash flow, notes, commentary.
Monitoring project portfolio KPI?s of capital investment projects.
BCS
Customizing, Organisational Change
Master data management, management hierarchy changes, parent indicator, new legal entities and consolidation units, consolidation of investments, accounting method change to equity accounting, chart of accounts, account mappings
Data strategy, manual postings, reconciliation
ECC and BI impact from BCS changes
BI
BI System Landscape, Scope definition of BI design
Evaluating all reports affected by consolidation hierarchy change
Group management reporting, GMC report (monthly management report of group consolidated financial results to the board and group management committee)
Re-modelling and data cleansing of surrogate organisational characteristic (reporting unit) for data homogenization across the organisation
Treasury:
account monitoring, account balance reconciliation, deposit management, line management
Changes in metric definitions, business process optimisation and impact on ARIS process definitions, ETL process optimization, BI Planning process changes, APD utilisation in ETL
BW 7.3 / HANA / BO 4
Migration strategy to BW 7.3
HANA evaluation vs. existing BI Accelerator
BI Fronted Tool Evaluation
Requirement engineering, functional specifications, scope management, change request management, task allocation, adopting new project methodology, liaising with team leads, process owners, business stakeholders
Tools: ERP (FI, CO, TR, PS), BW, BI-IP, BO, BWA, BCS, SOLMAN
Mercury, HP Quality Center, Concerto, ARIS, MS Access
Roles: project management, solution design, requirement analysis
International Retail Group [WIV International] 06/12 ? 05/13
Greenfield SAP Roll-out: ERP, CRM, BW, HANA, BO
FI, CO, Logistics
Balance Sheet, Controlling, SEPA, Group Consolidation
Customer Segmentation, CRM Activities
Pricing, Conditions, Transportation, Commissions, Credit Management
Material Master Data, Master Data Management, Customer Data/BP
BW 7.3 HANA / BO 4 Roll-Out:
Migration to BW 7.3
Migration to HANA
HANA Prototype, stress testing, defining CRM interface
HANA Studio, Virtual Cubes, Composite Providers, Indexing (BWA-Indices, indexed queries)
HANA Performance Optimization (for large customer base)
Analysis authorizations in BW
Data Modelling, LSA++
Customer-Exits in ERP and BW
Logistics Cockpit
Data Migration, import of legacy data from AS400
BO:
BW/BO integration
Advanced Analysis, Crystal Reports, pdf generation, email distribution list
CRM:
Campaigns and Marketing
Customer Segmentation, Segmentation Builder, BW Interface
WebUI, Webdynpro
Business Partner data synchronization
?
Tools: ERP (FI, CO, MM, SD, WM, TM, ICM, BP), IS-Retail, BW, BO, BPC, CRM, HANA, SOLMAN
SQL Server, Cognos, AS400 (iSeries)
Roles: project management, solution architect, requirement analysis, knowledge transfer
Media [Axel Springer] 01/12 ? 05/12
BW/BI 7.3 Upgrade and Business Objects 4 Roll-Out Project
Changes to concept for internal controls over financial reporting (controlling)
Improvement of Process Controls and System Access Management
Workflow for Role Assignment Requests
BW/BI-IP:
Switching to analysis authorizations in BW
Managing analysis authorization from central reference table
Roll-out technical content solution for managing analysis authorizations
Changes to legacy solution for managing selections
Customer-Exit changes
Performance Optimization for authorization checks in queries containing large hierarchies
Authorizations and security for BI-IP and BPS retraction into ERP
BCS:
Upgrade iasNotes 2.6 to Notes Management10.0
Organizational Changes
Security Concept for managing consolidation tasks
Performance Improvement
BO:
BW/BO integration
Integrated BI authorization concept
Single-Sign-On for BO
SAP roles for BO
New IFRS reports for balance sheet and notes
Tools: ERP (FI, CO, TR, HR), IS-Retail, BW, BCS, BI-IP, EP, GRC, ESS/MSS
Jira, Quality Center
Roles: solution design, coding, implementation management
Bank [African Development Bank] 02/11 ? 12/11
Portfolio and Project Management
Roll-out of new SAP PPM 5.0 in a SAP PS legacy environment as new platform for integrated portfolio, project and resource management supporting new IT governance principles and strategic IT portfolio development objectives.
Implementing new project initiation workflow, create reporting solution for portfolio monitoring replacing manually prepared excel files..
?
Hardware and Basis Strategy SAP Systems
Strategic decision on platform architecture
Hardware deployment strategy leveraging from existing boxes after ECC upgrade
Virtualization strategy for SAP systems
Identifying basis team staffing requirements
Utilizing external SAP hosting
Reviewing ISO 27000 certification documents of service provider
System Security
Validation of infrastructure and controls against internal security framework
Network Connectivity and VPN
User management in externally hosted systems
Tools: ERP (PS, HR, FI, CO), PPM, BW, BI-IP, EP, ADS, BO, CML, BPC, SRM
MS Project, Adobe Forms, IPsec, Mercury Quality Center
Roles: portfolio management, solution architect, RfP, vendor relations
Consultancy 07/10 ? 01/11
Global Procurement Analytics [Roche]
Upgrade Ariba 8 to version 9 (Buyer, Contract Management and Sourcing)
Extraction from both legacy Ariba 8 and new Ariba 9 into BW to facilitate analytical reporting on procurement, Rfx templates for project tenders, WBS configuration
Tools: ERP (MM, SCM, PS, HR), BW, BI, BI-IP, Business Objects XI 3.1, Xcelsius 2008,
Oracle, Ariba, TOAD
Roles: business analysis, solution design, data modelling
Concept for new BI Strategy and BI-IT Platform
Greenfield implementation of SAP ERP, CRM, gATP across all main subsidiaries
Re-structuring complex, grown legacy BI landscape (Teradata, BW)
Consolidating data into new MPP-enabled Enterprise Data Warehouse creating single point of truth for the first time ever:
Requirement analysis
Creating a reference architecture (topological rules)
Drive make of buy decision for the data model
Drive platform decision and architecture (ETL tools, OLAP tools, scheduling, etc.),
System landscape design, hardware sizing, resource allocation
Scoping implementation project preparing formal request for tender
Tools: ERP, CRM, SCM, gATP, BW, BI, BI-IP, Oracle, Neoview, Teradata, MS SQL Server,
Informatica, Ab Initio, Business Objects, Cognos, Arcplan, SAS, Microstrategy,
Control-M
Roles: business analysis, architecture and design, conceptional data model, roll-out plan,
project planning, vendor communication, RfI, RfQ
Colorado Project
Re-structuring UK business into new legal entity
Apply for new banking license from local regulator (FSA)
Organisational changes in ECC, BCS, BW/BI
Changes in Bank Analyser and Reporting BW to meet FSA requirements
Financial statement preparation for new legal entity, calculation run, module editor, RDB, Extraction into BW and BW reporting
New data streams (from special ledger), BI reporting changes on BCS data
Facilitate communication and requirement elicitation among business units and between the bank and the regulator / central bank
ECC Upgrade
Migration to ECC 6
Hardware upgrade, profile parameter changes, performance optimisation,
Solution Manager roll-out, interfaces to BCS and BI,
Functional: New GL, organizational changes
Authorisations and Role Management
Finance and Credit MI
Implementing new management information services for finance and credit risk reporting. Roll-out of Business Objects XI Rel 3.1 with SAP Integration Kit in a mixed BW 3.5/BI 7 landscape (WebI, Xcelsius) for balance sheet and cost reporting. Set up BOBJ-SAP platform, interfaces, authorisations. Consolidating credit and market risk data from BCS, Bank Analyzer and other systems into a new Credit Risk MI service (BOBJ). Commentary, ancillary database, input interface. BOBJ and BI query performance optimisation. Identify risk groups, liquidity reporting and treasury management
NAMA Project
Facilitate Management and Operational Reporting of loan portfolio at group level from different Business Units and from various technical platforms. Identify portfolio to be transferred to NAMA. Facilitate communication to regulator and auditors. Data consolidation and harmonization for assets from corporate and business banking across all subsidiaries. Implementation of new interfaces, Bank Analyzer enhancements. Architecture changes for syndicating NAMA data, create a Bank-in-the-Bank environment, organisational changes in ECC and BCS, NAMA enhancements in BW backend and BI-IP planning applications, reporting and authorization changes to ring fence NAMA data, query development, BOBJ integration, master data migration
Tools: Bank Analyzer (BA,CRA,FSP,DR,RR,BP), BW, BI, BCS, CRM, ECC: FI,CO,TR,HR
Business Objects; Unix, Oracle, MS Office, Lotus, ACBS, Murex, Summit, BIPS
Roles: business and process analysis, blue printing, architecture and interfaces, customizing
and development, change management, test management, release management
Integration of BW reporting into new group-wide Business Objects XI reporting platform
other manual authorization objects, BW and SEM authorizations)
1998 - 2003 Various data warehousing projects for clients Switzerland, Austria and Germany
1996 - 1998 STN International: Oracle database design and administration
Enterprise Data Warehouse Architecture (EDW), Layered Scalable Architecture (LSA, LSA++), BW Accelerator (BWA) und HANA, HANA Studio, SQL development;
Mixed landscapes of BW and BI7, BI upgrades, ASU Toolbox, system carve-outs and system mergers;
requirement analysis, blue print, implementation, ETL concept and administration, performance optimisation, data migration, support
ERP
FI: Accounts Payable, Accounts Receivable, New General Ledger, New GL Migration Cockpit, subledgers, Special Ledgers, Postings, Financial Information System, risk management, chart of accounts, FI Business Content
CO: Cost Center Accounting (CCA), profitability (COPA), activity based cost (ABC), cost elements, product cost, cost planning, profitability segments, inter-company trade / internal orders (OPA); standard hierarchy, multiple chart of accounts, profit center groups, information system, Pull vs. Push analysis, quantity consumption, function trees, flexible functions and formulae, CO reporting in BW/BI, CO-relevant master data, extractors; end-to-end requirement analysis and handling of change requests
TR: Cash Management and Cash Budget Management, Financial Management Areas, Commitment Item hierarchy, FI integration at posting level, treasury business content, treasury reporting and authorizations, CFM Transaction Manager Information System
HR/HCM: personnel management (PA), administration (PA-PA), manager?s desktop, cost planning, budget management, Employee Self Service (ESS), Manager Self Service (MSS), personnel time management (PT), time recording, evaluation, CATS, organizational structure, structural authorizations
Logistics: MM, SD, LO, LSE, PP, GTS;
purchase orders, vendors, BOM, inventory, sales orders, customers, deliveries, transportation cost, warehouses, inter-company trade, customs, product availability, pricing, billing, material cost, sales revenue and AR integration, short and mid-term capacity planning, relevant workflows and SoD, on-time delivery, Ariba integration, Supplier Relationship Management, tenders, demand planning (APO)
PS: networks configuration, subnetworks, assignments, WBS, organisational data, summarization hierarchy, activities, milestones, defining standards, Open PS for MS Project (interface), capital investment measures, billing plan, resource planning, capacity planning, work centers, bucket hierarchy
PPM: defining portfolios, portfolio item types, decision points, project budgeting/financial planning, FI integration, integrated phase model item/project, project management, project plan templates, resource management, teams and pools, Business Partner data and roles, project roles, MS Project import/export, PS integration, time recording, HR integration, organizational management, structural authorizations, access control lists, SoD in PPM and decision workflow
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.
Weitere Länder: Flexibel hinsichtlich des Einsatzortes, und ausgewiesene internationale Erfahrung. Einsetzbar innerhalb Europas und darüber hinaus. Einsätze bisher u. a. in Europa (innerhalb, sowie außerhalb der Union), Mittlerer Osten, Afrika und Asien