BW Developer
3M
Marikina City, Philippines
6d ago
source : ictjob.ph

3M i

s looking for BW Developer who will join their growing team in Bonifacio Stopover, BGC, Taguig City .

The Philippines site, located at the Bonifacio Stopover Corporate Center, is the third and final Global Service Center (GSC) of 3M Company , which will bring all the advantages of the GSC model to the Asia Pacific region.

  • It is responsible for optimizing 3M Company's delivery of transactional services in the region, and essentially strengthens 3M Company'
  • s operations around the world, as all three GSCs will work together to bring the highest level of service no matter where they are.

    3M Service Center will partner with the other GSCs to provide around-the-clock global service. It will host activities ranging from, among others, sourcing, IT, Finance, human resources, all of which are IT-enabled.

    3M Global Service Center in the Philippines intends to provide a full range of IT-enabled Business Process Outsourcing IT-

    enabled professional services in Finance, Sourcing, Human Resources, and IT solutions from the Philippines , for 3M Company, such as :

  • Record-to-Report - Processing of Financial Transactions that include Accounts Receivables processing, Payments processing, Fixed Assets and Projects processing, General Ledger and Month end closing activities and Reporting;
  • Source-to-Pay

  • Processing of Sourcing transactions related to Vendor PO and Vendor Invoice Processing;
  • Hire-to-Retire

  • Human resource transaction support services;
  • Master Data

  • Master data management;
  • Global Operations Support

  • SAP Global Operations Support services that include the areas of IT support, SAP Incident and Change Request management; and
  • Business Services

  • Processing of activities related to Customer Service e.g. account management, standard pricing and maintenance, customer data management.
  • 3M Company was incorporated in 1929 under the laws of the State of Delaware, USA to continue its business operations that started as early as 1902 .

    3M's head office is located at St. Paul, Minnesota, USA . 3M is a diversified technology company with global presence over more than 65 countries including 29 international companies with manufacturing operations and 35 companies with laboratories .

    3M Service Center APAC, Inc. was registered with the Securities and Exchange Commission on 08 September 2015. It is wholly-

    owned by 3M Singapore Pte. Ltd.

    JOB OVERVIEW

    The Data Warehouse Sr. Developer is part of the Global Reporting and Analytics team at the Global Service Center in the Philippines.

    They work in close collaboration with the global team in creating data warehouse solutions based on functional designs using an iterative development process.

    As BW Developer , you are expected to do the following tasks :

  • Analyzes and reviews business requirements and helps create functional design documents
  • Conducts technical design reviews
  • Review the Security Model for HANA View or Bex Report
  • Conducts impact analysis on development work
  • Develops optimized Data Acquisition Layer(PSA) , Quality And Harmonization layer (Transformation, WODSO& ODSO); Reporting Layer (Standard DSO, Cubes, Composite Provider, Multiproviders & Info set)
  • Develops BW Extractor solutions
  • Develops BW Transformation with Complex ABAP Logic and Routines, APDs
  • Develops Process Chains, Optimized selection for DTP and IP Data Loads
  • Creates enhancement of BEX Objects
  • Creates or modifies HANA views and creates modeling functions in HANA
  • Develops SQL Scripts using various Data Type extension, Variables, Procedures and Best Practices for HANA Modeling .
  • Executes testing and validation and cutover activities for developed objects
  • Performs data loading
  • Ensures proper procedures are followed and appropriate documentation is created
  • QUALIFICATIONS

  • Analyzes and reviews business requirements and helps create functional design documents
  • Conducts technical design reviews
  • Review the Security Model for HANA View or Bex Report
  • Conducts impact analysis on development work
  • Develops optimized Data Acquisition Layer(PSA) , Quality And Harmonization layer (Transformation, WODSO& ODSO); Reporting Layer (Standard DSO, Cubes, Composite Provider, Multiproviders & Info set)
  • Develops BW Extractor solutions
  • Develops BW Transformation with Complex ABAP Logic and Routines, APDs
  • Develops Process Chains, Optimized selection for DTP and IP Data Loads
  • Creates enhancement of BEX Objects
  • Creates or modifies HANA views and creates modeling functions in HANA
  • Develops SQL Scripts using various Data Type extension, Variables, Procedures and Best Practices for HANA Modeling.
  • Executes testing and validation and cutover activities for developed objects
  • Performs data loading
  • Ensures proper procedures are followed and appropriate documentation is created
  • SKILLS

  • Experienced in creating optimized Data Acquisition Layer (PSA) , Quality And Harmonization layer (Transformation, WODSO & ODSO) and Reporting Layer (Standard DSO, Cubes, Composite Provider, Multiproviders & Info set
  • Experienced in creating BI ABAP to write complex Transformation Rules & Routines, APD, Functional Module based Generic Extractors and CMOD enhancements for Standard Extractors
  • Experienced in Data extraction from Various Source Systems (SAP & Non-SAP) and building complex transformations in BW; Knowledgeable in Extraction process from Standard Extractors to Customizing Extractors
  • Knowledgeable in the Full, Delta and Queue Mechanism in SAP for BW Extractors
  • Experienced in Process Chain Monitoring, BW Administration Process & Transport Connections
  • Knowledgeable in HANA Modelling in Information Views
  • Experienced in the migration of Bex to HANA and understanding the HANA functions versus Bex Functions
  • Experienced in SQL Scripting for HANA Modeling ad well as analysis and performance tuning in HANA
  • Knowledgeable in HANA Security
  • Willing to work in BGC, Taguig City
  • Amenable to be assigned on regular working hours (9AM - 6PM / 8AM - 5PM)
  • 1 FULL TIME position is available
  • Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form