DOC

BW_ROLES_SKILLS

By Jack Carroll,2014-07-21 08:54
11 views 0
BW_ROLES_SKILLS

Roles in BW Projects

    BW Data Extraction Consultant

    Description

    The BW Data Extraction Consultant is responsible to identify and obtain the data required to

    satisfy the requirements of the BW project. This data may include:

    ? SAP R/3 data

    ? New Dimension product data

    ? Data external to SAP within the organization (legacy data)

    ? Data external to SAP from outside the organization (provider data D&B, Nielson)

    The BW Data Extraction Consultant role has a broad range of responsibilities and may require

    multiple individuals to satisfy the role depending on the scope of the BW project and the

    complexity and quality of the data.

    If SAP R/3 and New Dimension data only is required to satisfy requirements and if this data is

    included in the standard Business Content of BW, this role may be combined with the BW

    Application Consultant role. This standard Business Content allows for extraction of R/3 and New

    Dimension data in a straightforward and rapid manner.

    If non-SAP data is required, if standard Business Content must be enhanced significantly, if BAPI

    interfaces are being used, and/or if the data quality from the source system is insufficient, this role

    can be quite complex and can required significant resources. This complexity and quality of data

    is a primary contributor to the size and scope of the BW project.

    If legacy data is being extracted a close relationship is required with the legacy extraction expert.

    In some cases, the legacy extraction expert may assume this responsibility.

    Time Commitment

     the time which must be committed to this Role to ensure the project requirements are met

    Project Complexity Time Commitment Low If standard Business Content of BW is the only

    data required, this role can be combined with

    the BW Application Consultant. The role is

    primarily performed during the early to mid-

    phases of the project with completion of

    extractions required by the middle of the project

    so that testing, training, and implementation can

    be completed. Medium If extensions to the standard Business Content

    of BW is required (either by including addition

    SAP data or extracting from non-SAP sources),

    this role should be satisfied by individuals other

    than the BW Application Consultant so that

    efforts may continue in parallel.

    High Depending on the complexity and quality of the

    data necessary to satisfy the requirements, this

    role may require a significant number of

    resources. A resource could potentially be

    required for each major extraction that has to be

    developed.

    Key Attributes

    Key attributes of an individual supporting the analysis and design functions of this role include:

    ? SAP R/3 and BW application knowledge in the business process area

    ? The ability to develop a solution using BW to solve a company’s business requirements

    ? The ability to work effectively in a diversified team

    ? Strong analytical skills

    ? The ability to work independently and as a team member

    ? Strong time management skills and multi-tasking capabilities

    ? Knowledge of application software tools, including presentation, spreadsheet, and

    word processing applications

    ? A working understanding of the AcceleratedSAP methodology and tools

    ? Experience in the customer’s industry

    ? An understanding of the source data (both SAP and non-SAP data)

    Key attributes of an individual supporting the development functions of this role include:

    ? Experience with data warehouse data analysis

    ? Experience with data extraction development

    ? Detailed knowledge of the data required to be extracted

    ? Knowledge of the customer’s current business processes

    ? Knowledge of data quality issues

    ? Knowledge of scheduling tools

    ? An indepth understanding of specific data extraction tools or development language

    being used to extract the data (e.g., 4GL’s or specialized data extraction tools, BAPI’s)

    ? Strong written and oral communication skills

    ? Strong analytical skills

    ? The ability to work in diversified teams

    Key Tasks

    Specifically, the BW Data Extraction Consultant is responsible for:

    ? Designing the data solution to satisfy defined business requirements

    ? Identifying the data in the source environment

    ? Mapping the data to the BW environment

    ? Identifying data quality gaps

    ? Developing a plan to close data quality gaps

    ? Developing the required extraction programs, if necessary

    ? Developing the associated interface programs, if necessary

    ? Testing of all developed programs

    ? Ensuring integration testing of data from various sources ? Developing a production support plan Don’ts The BW Data Extraction Consultant should not become ineffective because of long-standing data quality problems, but should identify these problems and escalate them to the Customer Project Manager for resolution. Often data quality and inconsistency issues are systemic in the organization and must be addressed a higher level in the organization to get resolved. Avoid the tendency to attempt to cleanse all data within the BW extraction process. Often data cleansing is best performed at the legacy source system level.

BW Data Access Consultant

    Description

    The BW Data Access Consultant is responsible to assess the business requirements, and design

    and develop a data access solution for the BW project. This solution may include use of:

    ? BW’s Business Explorer

    ? Non-SAP Data Access tools (e.g., Business Objects, Cognos, Crystal Reports, and

    other certified data access tools)

    ? Visual Basic development

    ? Web development

    ? WAP (wireless) development

    ? R/3 drill-through

    The BW Data Access Consultant role has a broad range of responsibilities and may require

    multiple individuals to satisfy the role depending on the scope of the BW project and the

    requirements associated with data access.

    The BW Data Access Consultant should work closely with the individuals responsible for

    business requirements gathering and analysis and have a thorough understanding of the way the

    data will be used to make business decisions.

    Often significant change management issues are generated as a result of modifications required

    by end users to the data access design and implementation. As a result the BW Data Access

    Consultant is in a key position to provide valuable information to the change agent or change

    management process.

    Time Commitment

     the time which must be committed to this Role to ensure the project requirements are met

    Project Complexity Time Commitment

    Low If standard Queries from BW are used and the

    Business Explorer is the tool selected, this effort

    can be performed by the BW Application

    Consultant Medium If modifications or significant extensions are

    required to the Queries from BW, a resource

    should be committed specifically to work in this

    area. High If a product other than the Business Explorer is

    selected, a skilled consultant with this expertise

    should be committed to the project. If VBA or

    Web development is needed, this too requires

    specialized skills and resources.

    Key Attributes

    The BW Data Access Consultant should have:

    ? Strong business emphasis and perspective

    ? Excellent communication skills since the role works closely with the end users of the

    BW

    ? Experience with the appropriate data access tool(s)

    ? Strong analytical skills

    ? An understanding of the customer’s business processes

    ? An understanding of the associated output/display requirements ? The ability to work with diversified teams

    Key Tasks

    Specifically, the BW Data Access Consultant is responsible for designing the data access solution to include:

    ? Understanding the data that will be available in BW in business terms ? Identifying the way end users want to analyze the data in BW ? Designing the data access solution to satisfy defined business requirements The BW Data Access Consultant is also responsible for developing the data access solution to include:

    ? Developing options for data access (i.e. web solution, R/3 drill through, ODS reporting, rdmaster data reporting, 3 party tools)

    ? Developing prototypes of data access for review with end users

    ? Developing the required data access solutions

    ? Developing the associated interface programs and/or customized web enhancements,

    if necessary

    ? Configuring the Reporting Agent, if necessary

    ? Configuring the GIS

    ? Testing of all developed solutions

    ? Ensuring integration testing of data access solution

    ? Developing a production support plan

    ? Working with training development to include data access solution in BW course

    materials

    Don’ts

    The BW Data Access Consultant should not assume that they know what the end user wants

    without developing and demonstrating prototypes throughout the process. Often end user

    requirements evolve as they see the kind of data that is available.

    Also, the BW Data Access Consultant should not wait until all valid data is available in BW before developing prototypes, but rather use data that is not valid where the end user will focus on the design of the access method rather than the data.

BW Data Architect

    Description

    The BW Data Architect is responsible for the overall data design of the BW project. This includes

    the design of the:

    ? BW InfoCubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates)

    ? BW ODS Objects

    ? BW Datamarts

    ? Logical Models

    ? BW Process Models

    ? BW Enterprise Models

    The BW Data Architect plays a critical role in the BW project and is the link between the end

    user’s business requirements and the data architecture solution that will satisfy these

    requirements. All other activities in the BW project are contingent upon the data design being

    sound and flexible enough to satisfy evolving business requirements.

    Time Commitment

     the time which must be committed to this Role to ensure the project requirements are met

    Project Complexity Time Commitment

    Low If the BW project utilizes standard BW content

    and InfoCubes, this role can be satisfied by the

    BW Application Consultant.

    Medium If the BW project requires enhancements to the

    standard BW content and InfoCubes and/or

    requires the integration of non-SAP data, this

    role may require a committed resource.

    High If the BW project requires significant

    modification and enhancement to standard BW

    content and InfoCubes, it is highly

    recommended that an experienced resource be

    committed full-time to the project.

    Key Attributes

    The BW Data Architect must have:

    ? An understanding of the BW data architecture

    ? An understanding of multidimensional modeling

    ? An understanding of the differences between operational systems data modeling and

    data warehouse data modeling

    ? An understanding of the end user’s data ? An understanding of the integration points of the data (e.g., customer number, invoice

    number)

    ? Excellent troubleshooting and analytical skills

    ? Excellent communication skills

? Technical competency in data modeling

    ? Multi-language skills, if an international implementation ? Working knowledge of the BW and R/3 application(s)

    ? Experience with Data Modeling application software (i.e., ERWIN, Oracle Designer, S-

    Designer, etc.)

    Key Tasks

    The BW Data Architect is responsible for capturing the business requirements for the BW project. This effort includes:

    ? Planning the business requirements gathering sessions and process ? Coordinating all business requirements gathering efforts with the BW Project Manager ? Facilitating the business requirements gathering sessions ? Capturing the information and producing the deliverables from the business

    requirements gathering sessions ? Understanding and documenting business definitions of data ? Developing the data model

    ? Ensuring integration of data from both SAP and non-SAP sources ? Fielding questions concerning the data content, definition and structure This role should also address other critical data design issues such as:

    ? Granularity of data and the potential for multiple levels of granularity ? Use of degenerate dimensions

    ? InfoCube partitioning

    ? Need for aggregation at multiple levels

    ? Need for storing derived BW data

    ? Ensuring overall integrity of all BW Models

    ? Providing Data Administration development standards for business requirements

    analysis and BW enterprise modeling ? Provide strategic planning for data management

    ? Impact analysis of data change requirements

    As stated above, the BW Data Architect is responsible for the overall data design of the BW project. This includes the design of the:

    ? BW InfoCubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates) ? BW ODS Objects

    ? BW Datamarts

    ? Logical Models

    ? BW Process Models

    ? BW Enterprise Models

    Don’ts The BW Data Architect should not become distracted with issues outside the data modeling arena but should be allowed to focus on the issues surrounding optimizing the data design for the BW project.

    The BW Data Architect should design to satisfy specific business requirements, but should keep in mind the overall, long-term goals of the BW in the organization.

BW Application Consultant

    Description

    The BW Application Consultant is responsible for utilizing BW to satisfy the business

    requirements identified for the project. As provided in the other roles, if the scope of the BW project is tightly controlled and can use standard BW Business Content, InfoCubes, and

    Queries, the BW Application Consultant may assume the responsibility to perform several roles

    concurrently to include:

    ? BW Data Architect

    ? BW Data Access Consultant

    ? BW Data Extraction Consultant

    ? SAP Project Manager

    ? Business Process Team Lead

    ? Authorization Administrator

    If this occurs, the BW Application Consultant must have a broad range of skills and this position

    will be under significant pressure during the course of the BW project. In this situation, the BW

    Application Consultant inherently must be responsible for the overall integrated design and

    realization of the BW solution.

    If the project scope is broad and must extend Business Content, InfoCubes and/or Queries,

    then the project warrants resources being assigned to the roles identified above. In this case, the

    BW Application Consultant is responsible for the overall integrated design and coordinated

    realization of the BW solution.

    If this role is assumed by an SAP Consultant, often the expectations are that they are familiar with

    all components and functionality of Business Information Warehouse. This role often naturally

    becomes a focal point for all design consideration related to BW.

    Time Commitment

     the time which must be committed to this Role to ensure the project requirements are met

    Project Complexity Time Commitment Low If the BW project utilizes standard BW content,

    InfoCubes, and/or Queries this role can be

    satisfied by the BW Application Consultant. If

    this occurs, this is full-time responsibility.

    Medium If the BW project requires enhancements to the

    standard BW content, InfoCubes, and/or

    Queries, and/or requires the integration of non-

    SAP data, this role should not assume

    responsibility for all activities, but other

    resources should be assigned. If this occurs,

    the BW Application Consultant can assume a

    less than full-time role. High If the BW project requires significant

    modification and enhancement to standard BW

    content, InfoCubes, and/or Queries it is highly

    recommended that an experienced resource

    (other than the BW Application Consultant) be

    committed to the project to satisfy these roles.

    If this occurs, the BW Application Consultant

    should assume a full-time responsibility.

    Key Attributes

    The BW Application Consultant must have:

    ? Excellent troubleshooting and analytical skills

    ? Excellent communication skills

    ? Excellent time management skills

    ? Excellent problem resolution and organizational skills ? Technical competency; with strong computer skills ? Multi-language skills, if an international implementation ? Working knowledge of the BW and R/3 application(s) Key Tasks

    The BW Application Consultant (or one of the resources identified above) uses the BW Administrator Workbench to perform the functions provided by BW:

    ? Establish connections to the BW sources

    ? Activate the standard Business Content

    ? Enable the standard InfoCubes and Queries ? Enhance the InfoCubes as required by the BW Data Architect ? Enhance the Queries as required by the BW Data Access Consultant ? Define authorization profiles and access

    ? Evaluate statistical performance and make recommendations to Basis support for

    optimization where possible ? Manage the CTS layer

    Don’ts There is a tendency to reply completely on this resource for the project. This is not recommended, since these resources will consistently be in demand and individuals having this broad range of skills are difficult to find and keep on a project. Cross-training of resources is essential to ensure the sustainability of the project.

    Ensure that this role does not assume ownership responsibility for OSS notes related to BW.

Report this document

For any questions or suggestions please email
cust-service@docsford.com