FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

SAP BW Consultant

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 SAP BW Consultant Skills

Below we've compiled a list of the most important skills for a SAP BW Consultant. We ranked the top skills based on the percentage of SAP BW Consultant resumes they appeared on. For example, 8.0% of SAP BW Consultant resumes contained BEX as a skill. Let's find out what skills a SAP BW Consultant actually needs in order to be successful in the workplace.

These are the most important skills for a SAP BW Consultant:

1. BEX

demand arrow
high Demand
Here's how BEX is used in SAP BW Consultant jobs:
  • Developed customer exit for variables and coded in user exit for BEX reporting.
  • Worked extensively on BEX analyzer and BEX browser.
  • Used BEx Reporting and Web Application Design for developing and designing queries for the end user as per the client needs.
  • Created queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx reporting.
  • Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
  • Actualized various types of BEx query variables including User exit, Replacement Path, Text and formula variables.
  • Worked on User Exit Programs in BEx queries for populating time periods as per user requirement.
  • Worked extensively on BEx Analyzer and customized the reports creating variables, exceptions and conditions.
  • Adhered to SAP best practices to design BEx queries for performance optimization of Financial reports.
  • Created Universes over BEx queries and InfoCubes of SAP BI using Universe Designer.
  • Worked on Web Application Designer tool and Bex Analyzer to generate the reports.
  • Worked on reporting requirements like designing and improving their BEx reports.
  • Designed queries using BEx Analyzer Reporting tool for data presentation.
  • Migrated BEx WAD 3.5 reports to Business Objects reports.
  • Migrated BW 3.5 BEx queries and WAD reports to 7.x.
  • Created Bex report with time line buckets to show the AR receivables for Ageing and prior to Net due date.
  • Created Multi Providers and Info Sets on which BEx reports were developed and published queries on web.
  • Created and executed queries against various infoproviders using BEx analyzer to report the sales and billing data.
  • Created BEx queries first and created Universe on top of the BEx Query.
  • SAP BO Analysis Office, BEx Query Designer, BEx Web Application Designer, BEx Analyzer & BEx Web Analyzer.

Show More

2. Info Packages

demand arrow
high Demand
Here's how Info Packages is used in SAP BW Consultant jobs:
  • Created info Packages and populated info Cubes with initialization and delta loads at predefined scheduled time settings.
  • Created Info Packages and Process chains to do Full, Initial, and Delta extraction for both Master and Transaction data.
  • Parallel loading of data through different Info Packages to the same Data Targets using Process chains to improve the load performance.
  • Created and scheduled Info Packages for Full, Delta Initialization, and Delta updates to load both master and transaction data.
  • Designed and developed process chains for master data loads and transaction data loads with the help of Info Packages.
  • Monitored Info Package data loads, analyzed reason for failures and edited Info Packages manually to resolve issues.
  • Administered data loads and scheduling using Info Packages, Monitor, SAP job and process monitoring utilities.
  • Created Info packages for uploading the master and transaction data, Process chains for daily delta loads.
  • Extracted and populated data into InfoCubes after creating transfer rules, info packages and update rules.
  • Carried out several data loads by executing info Packages using both the update methods i.e.
  • Created Info Packages with Full Loads, Delta loads, Initialization with/without data transfer etc.
  • Created info packages for full, initial & delta loads from R/3 & Files.
  • Created info sources, info packages and schedulers to extract data from R/3.
  • Monitored data loads and analyzed the reasons for frequent failures of info packages.
  • Experienced in creating update rules and uploading records by scheduling Info packages.
  • Used process chains to schedule the info packages and data transfer processes.
  • Created Info Packages and Scheduling the data into the Data Targets.
  • Created Info packages to load the data and schedule background jobs.
  • Designed and modified Transformations, Info Packages and DTP's.
  • Extracted data from FI-CO Data loading for the cubes and ODS through info packages in full and delta loads.

Show More

3. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in SAP BW Consultant jobs:
  • Provided technical leadership and mentoring to a data management team developing a Data Warehouse.
  • Developed several transformations in the process of building Data Warehouse database.
  • Designed purchasing application in BI based on enterprise data warehouse concept.
  • Used ETL (SAP BW/BI) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team.
  • Involved in SAP BW Data Warehouse Architecture Design, Functional document, ETL, Physical and Logical Data Modeling.
  • Involved in Modeling/Designing and implementing data warehouse solutions using SAP BI 7.0 using with SAP ECC for Materiel Management.
  • Lead the implementations of several planning (sales, finance), data warehouse and reporting applications.
  • Administered the transportation of BW objects, archiving solutions and the management of administrative data warehouse functions.
  • Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
  • Involved in creating various data marts from data warehouse and generated reports using Business Objects.
  • Modeled DSO's to stage the data before transferring into the data warehouse layer.
  • Created MS DTS for the integration of several Data marts into the Data Warehouse.
  • Project #3: Project name: Pricing Data Warehouse
  • Implemented custom data warehouse layer with Data store, info providers and multi provider based on reporting requirements.
  • Involved in Data Warehouse modeling, Multi Dimensional/ Star Schema and Extended Star Schema models.
  • Facilitate overall data structures for customer master from MDM suite to Astellas data warehouse.
  • needed to meet business requirements and establish the Enterprise Data Warehouse.
  • SAP BW : Data Warehouse Design ASAP methodology BI content BW Performane BW Modeling Data Extraction BEx Reporting BW Statistics Process Chains
  • Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.

Show More

1 Data Warehouse Jobs

No jobs at selected location

4. BI

demand arrow
high Demand
Here's how BI is used in SAP BW Consultant jobs:
  • Applied security and administration by creating the users and roles for the organizational level visibility.
  • Developed queries for overhead management and profitability analysis and integrated the queries.
  • Designed the Data flow for extracting Sales and Shipment Data from ECC to APO/BI and extracted data from the Planning Area.
  • Experience in creating BIAR files, and using Import Wizard to move from development to QA and production.
  • Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports.
  • Created financial reports using COPA and FI-GL data extracted from SAP R/3 to BI.
  • Experience with Business Objects, Tableau as the front end BI reporting tool.
  • Experience is converting DESKI reports to WEBI reports using Report Conversion tool.
  • Loaded the FMH, Customer sales related Hierarchy data into SAP BI.
  • Debug and correct issues with data extraction & loads with BI.
  • Coded ABAP logic in SAP BI Systems as per the requirements.
  • Involved in bug fixes in the process chains, DTP, Load Cycles and PSA in SAP BI.
  • Monitored the BI Load for countries in North America, EMEA and AP.
  • Provided ongoing evaluations of new BI technology solutions while monitoring and supporting tickets for parts repair processing using SAP QM module.
  • Participated in Cut over Transports, Data load Execution, Go-Live Cutover plan and Post Go-Live support with BI support Team.
  • Designed and implemented the BOBJ sales reporting on SAP BI 7.0 integrated with customizing NetSuite source.
  • Migrated WAD Templates to BI 7.0 and other functional upgrades to BI 7.0 systems.
  • Created WEBI reports and Adhoc reports as per the Business requirements.
  • Designed the universe by using SAP BI as the backend.
  • SAP BO Design Studio, Xcelsius/Dashboards and Webi Deski and Webi Reports.

Show More

3 BI Jobs

No jobs at selected location

5. Web Intelligence

demand arrow
high Demand
Here's how Web Intelligence is used in SAP BW Consultant jobs:
  • Automated Document Scheduling, Publishing and Distribution for Web Intelligence and InfoView clients using the Broadcast Agent and XI Scheduler.
  • Involved in creating and publishing reports on the web using the Info View in Web Intelligence.
  • Designed universes and created Web Intelligence documents for queries developed on the commission data.
  • Design complex Web Intelligence and WebI Rich client Reports using BO 4.1.
  • Created Web Intelligence reports and processed them to next level for reporting.
  • Designed and Developed BO reports for Budget Input Application using Web Intelligence.
  • Created and maintained Business Objects reports in Web Intelligence Info View.
  • Worked extensively on Business Objects XI 3.0 and Web Intelligence.
  • Implemented web intelligence in distributed (clustered) Environment.
  • Created reports using Web intelligence (WebI).
  • Created Web Intelligence reports for HANA views.
  • Developed Segmentation Analysis Xcelsius dashboard using Live Office, QAAWS, Web Intelligence, and Universe based on user requirements.
  • Developed Business Object Universe on top of the BEx Query and created web intelligence reports Using store sales data.
  • Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence (WEBI).
  • Designed, developed, and optimized Universes using Universe Designer for ad-hoc reporting using Web Intelligence.
  • Created Web Intelligence documents for ad-hoc requirements across the board for all kinds of users.
  • Developed Reports on Invoicing - AIS, POS using Web Intelligence (Webi).
  • Designed multiple & complex Web Intelligence (WEBI) Ad-hoc reports & Scorecards.
  • Worked on end-to-end implementation of several Web Intelligence reports in Finance module ( based on GL, AP & AR ).
  • Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) and Rich Client.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. ECC

demand arrow
high Demand
Here's how ECC is used in SAP BW Consultant jobs:
  • Extracted Data from Existing BI Info Providers and ECC Custom Data Sources using Generic extraction and also using Flat files.
  • Used DXC to bring the data from ECC in order to reduce complexity of data modeling task in SAP HANA.
  • Created documentation of test plan, test case and test protocols for developments in ECC and BW.
  • Loaded the data from ECC to BI and used initialization with delta update and full update methods.
  • Gathered and analyzed the requirement to replicate the ECC content in HANA using the Real-time SLT Process.
  • Extracted data, initialized delta for uploading of transaction data from ECC by V3 updates.
  • Extracted Cost center statistical key figure actual for headcount from ECC data source 0CO_OM_CCA_3.
  • Performed trigger based data replication using SLT technique for SAP ECC SD, FI.
  • Worked closely with Functional team to validate BW data in ECC related to Logistics.
  • Performed Unit, Integrity tests and data consistency was verified with ECC 6.0.
  • Extracted daily deltas of Cost Center actual from ECC data source 0CO_OM_CCA_9.
  • Developed Real-Time Information models to support SLT replicated tables from SAP ECC.
  • Activated the Logistic Cockpit Data sources in SAP ECC 6.0 System.
  • Customized/designed Data Flow right From ECC to BI and further.
  • Reconciled the data of BI with ECC after loading.
  • Loaded data to the APO data targets from ECC.
  • Loaded SAP ECC tables using SAP SLT data replication.
  • Worked on creating Costing Based CO-PA Datasource and loaded data from ECC to BI.
  • Define enhancements on the ECC side of the LO Cockpit datasources.
  • Replicated ecc tables in HANA using SLT.

Show More

7. SAP BW

demand arrow
high Demand
Here's how SAP BW is used in SAP BW Consultant jobs:
  • Installed and configured Windows AD and SAP SSO functionality between BOE and SAP BW using SNC Configuration for Business Objects 4.1.
  • Integrated Business Objects with SAP BW/BI and Portal Integration kit to publish the reports onto the Enterprise using BW/R3 portal.
  • Designed new Queries and Modified the existing Queries (SAP BW 3.5) according to requirements and generated reports.
  • Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
  • Created Multi-Source universe using relational connection based on SAP BW, MS Access and Flat files.
  • Integrated SAP BW 7.3 system with Business Objects 4.0.
  • Loaded flat file data into SAP BW system periodically.
  • Worked with Logistic Cockpit data sources for SAP BW-SD.
  • Rolled out SAP BW project for reporting needs on SAP FI, CO, MM and SD data.
  • Worked on SAP BW on HANA migration for migrating objects from SAP BW 7.0 to 7.4.
  • Performed data loads via SAP BW extractors (DXC) to HANA from legacy BW.
  • Implemented SAP BW 3.0B and 2.1C for SD and MM modules.
  • Created BICS connections to connect directly to a SAP BExquery or a SAP BW Info Provider at Information Design Tool.
  • Worked on Dashboard Design Tool development using web service on top of SAP BW Created queries to determine No.
  • Key Team member for BIA implementation for high performance and Scalability of SAP BW implementation.
  • SAP BW on HANA: Lead the effort in migrating the SQL server 2008 database to HANA database.
  • Build Informatica mappings to load Customers data from SAP BW application tables for Ecolab's various business units into HANA column-tables.
  • Used Vistex standard extractors and Generic extractors to load data from Vistex to SAP BW.
  • SAP BW 3.5, BW Implementation and Support Implementation Leading 6 members STBC Team.
  • Loaded master data and transactional data from SAPR/3 system toSAP BW.

Show More

4 SAP BW Jobs

No jobs at selected location

8. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in SAP BW Consultant jobs:
  • Interacted with Business Analyst and end users to gather initial business requirements and developed reporting prototypes for user presentations.
  • Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.
  • Conducted meetings with management and user community to understand their requirements and convert Business requirements into technical specifications.
  • Interacted with the management and business decision-makers to identify business requirements.
  • Created Functional Specs and Technical design documents as per business requirements.
  • Collected business requirements and define functional & technical specifications.
  • Created complex technical documentation for the business requirements.
  • Played an important role in documenting the Business requirements from the users and writing Functional Specification for the same.
  • Performed ongoing customization and fine tuning on existing Business objects and Cubes to support the changing business requirements.
  • Modified older queries to accommodate new business requirements and to utilize the enhanced features offered by BI 7.0.
  • Interacted with end-users to gather business requirements and transformed them into technical work plan.
  • Created functional specifications for matching the business requirements to the design of BW.
  • Worked in developing custom routines in the BW as per the business requirements.
  • Interacted with business heads to finalize the Business Requirements for the application.
  • Developed the new process chains as per the business requirements.
  • Modified BI content extractors based on the business requirements.
  • Enhanced the Data Sources as per the business requirements.
  • Created custom reports using BEx Query Designer, Crystal Reports 2011 as per the business requirements.
  • Maintained customized Info Cubes, Operational Data Sources, and Multi Cubes for the business requirements.
  • Created Analytical privileges to control the data for the various business requirements.

Show More

9. Process Chains

demand arrow
high Demand
Here's how Process Chains is used in SAP BW Consultant jobs:
  • Monitored process chain, made changes to existing chains and created remote process chains connecting multiple systems.
  • Used Delta and Full Upload which automated the loading of data into the InfoCube using Process Chains.
  • Worked on data load scheduling, designing and monitoring process chains, ensuring timely completion of loads.
  • Created Process Chains to automate the data load and data target administration and monitored the processes.
  • Developed, scheduled, maintained and managed process chains to automate the data transfer process.
  • Scheduled jobs using Process Chains for Data Load, Compression and created BIA indexes.
  • Modified few process chains to improve performance and to avoid regular job failures.
  • Created process chains for scheduling background jobs for Reporting Agent and Aggregate Maintenance.
  • Designed the Process Chains with different ways of loading the data.
  • Designed delta loading strategies, process chains and scheduled batch jobs.
  • Created the Process Chains which is used for daily uploads.
  • Created Process chains to transport them to the production system.
  • Created Process Chains to schedule periodic data loads.
  • Monitor the process chains and fix the failures.
  • Created process chains using RSPC transaction code.
  • Worked with infopackage groups and process chains for effective scheduling and automation of various data load processes.
  • Created process chains for periodic upload of the master data as well as the transactional data.
  • Designed and developed process chains, load schedules for loading Master and Transactional data.
  • Scheduled process chains for performance tuning jobs like creating Aggregates, Rollups, Indices and compression techniques.
  • Designed, and Created process chains for the Master data and Transactional data data flows.

Show More

1 Process Chains Jobs

No jobs at selected location

10. SAP R/3

demand arrow
high Demand
Here's how SAP R/3 is used in SAP BW Consultant jobs:
  • Maintained Reconciliation's to verify the Data in SAP R/3 and SAP BW are same or not after the data loads.
  • Worked on MM including Inventory Management DataSources to extract the data from SAP R/3 to SAP BW 3.5 data targets.
  • Analyzed the existing operating concern in SAP R/3 system to create data source according to reporting requirements in CO-PA.
  • Involved in project on development, testing and support of applications before and after release SAP R/3 4.6C.
  • Scheduled periodic data loads from SAP R/3 to BW and also scheduled periodic loads into the Info Cubes.
  • Key figure * Design implementation strategies, as transaction data has to be fed form SAP R/3.
  • Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
  • Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
  • Worked on data extraction of SAP R/3 (LO-Cockpit) system using various extractors.
  • Scheduled the data packet size in the SAP R/3 4.7 according the business requirements.
  • Created test data in SAP R/3 system for testing BW reports functionality.
  • Worked on transporting objects between BW system environments and corresponding SAP R/3.
  • Maintained SAP R/3 under control by Data Archiving.
  • Activated Data sources in SAP R/3.
  • Worked on the extraction of data's from LO cockpit-SAP R/3, FICO and MM to BW.
  • Activated Data sources in SAP R/3 using T code RSA5.
  • Worked on uploading master data and transactional data from SAP R/3 via Data staging to PSA, ODS and Info Cubes.
  • Scheduled and Monitored periodic data loads from SAP R/3 to BW Worked on PSA for data staging and data cleansing.
  • Uploaded Master and Transactional data from flat files and SAP R/3.
  • Extracted Purchasing data from SAP R/3 (ECC) using Datasources 2LIS_02_ITM and 2LIS_02_SCL.

Show More

11. Objects Universes

demand arrow
high Demand
Here's how Objects Universes is used in SAP BW Consultant jobs:
  • Worked on gathering, analyzing, and documenting functional requirements and data specifications for Business Objects Universes and Reports.
  • Involved in performance tuning and optimization on business objects universes by creating aggregate tables.
  • Analyze migration strategies for Business Objects Universes and reports across multiple Business Objects Repositories (Development, QA and Production).
  • Created classes, objects in SAP Business Objects Universes with condition objects and developed hierarchies to support drill down reports.
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
  • Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc.
  • Created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules.
  • Used Stored Procedures, Views and Created Derived tables to develop Business Objects Universes.
  • Developed SAP Business Objects Universes and used Web Intelligence Tool to provide effective reports.
  • Worked on back end views, tables required by the business objects universes.
  • Created Business Objects Universes and also enhanced it as and when necessary.
  • Developed Business Objects Universes using SAP BI Queries as Source Data.
  • Developed Business Objects Universes with classes, objects and condition objects.
  • Developed SAP BW queries which were accessible to BusinessObjects Universes.
  • Implemented Business Objects Universes hitting directly the Teradata database.
  • Designed/Developed Business Objects Universes using Universe Designer on top of SAP BW InfoCubes and BEx queries.
  • Used Crystal Reports to create reports that connect to Business Objects Universes with minimal effort.
  • Experience building Business Objects universes, especially with SAP BW Infocubes and BEX quesries is also preferred.

Show More

12. DSO

demand arrow
high Demand
Here's how DSO is used in SAP BW Consultant jobs:
  • Analyzed the existing the DSO's and Cubes and making a proper decision to make them in memory computing Info providers.
  • Created and maintained Info Sets on multiple DSO and master data, with custom fields and assigned to roles/user groups.
  • Created intermediate write optimized DSO Structures and APD's in BI7.0 to improve performance while loading AP data.
  • Created write optimized DSO's, standard DSO's, end routine and process chains.
  • Developed Secondary Indexes for DSO to improve the data load performance for downstream feeds.
  • Used DirectUpdate DSO in the process of APD (Analysis Process Designer).
  • Designed and developed Custom Info Cubes and DSO objects in MM application components.
  • Developed DSO objects to load Sales Order Data from the Data Source.
  • Created DSO for Sales orders and Purchasing.
  • Created Look up's from various DSO's to populate the fields.
  • Created transformation routines to look up on various DSOs to derive Business partner/Vendor/Settlement Partner relation.
  • Extracted the Master and Transaction Data from Flat files and then loading into Info Objects, DSOs and Info Cubes.
  • Designed and developed custom Hana optimized DSO objects, and activated Transformations for these data targets and evaluates data.
  • Build and imported SAP HANA optimized Infocube's and DSO's into SAP HANA environment.
  • Created transactional Info Cubes and DSO objects for sales planning in SEM-BPS.
  • Customized Cubes and DSOs as per customer requirements.
  • Loaded DSOs with heavy data using DB Connect.
  • Created BEx queries for comparing historical and delta data loads in EDW and existing DSOs above the EDW layer.
  • Developed dataflows with IOBJs, DSO, cubes, MPROV as enhancements.
  • Created DSOs, Info Cubes and Multi- provider for queries.

Show More

13. Master Data

demand arrow
high Demand
Here's how Master Data is used in SAP BW Consultant jobs:
  • Worked on Master Data Customization.
  • Developed LSMW for material, Customer, Vendor and Info records master data and enhanced it with various requirements of clients.
  • Worked extensively on performance tuning on existing process chains, set up the dependencies, master data and hierarchies.
  • Extracted data using LO, FI and Generic extractors & initialized delta and Uploaded master data from R/3 systems.
  • Involved in creating the BWA indexes, master data indexes and DB indexes prior to HANA data base.
  • Configured daily, weekly, monthly Process Chains for loading master data and transaction data into business warehouse.
  • Created custom Master data info object and added Credit related objects as attributes and mapped to 0FI_AR_9.
  • Master Data included Agreement Master Data, Item Master Data, Vendor/Supplier Master and Hierarchies.
  • Involved in postponement of transaction data whenever there is a master data load failure.
  • Created Generic Data source using DB View Extraction method for CRM Master Data.
  • Created master data InfoSources for uploading attributes, texts and hierarchies.
  • Enhanced the Article and Site master data.
  • Developed Virtual Provider with BW objects upon HANA Models to use Navigationalattributes and Master data related to BW Objects.
  • Exported and importedmaster data, transaction data from production to various test environments to support the various projects.
  • Created Monthly and daily Process Chains to automate the Data loading process for Master Data and Transactional data.
  • Stored transaction data in BW Info Cubes, staging ODSs and master data in Info Objects.
  • Created process chains to load data for custom master data infoobject ZCRE_DATA from 0FI_AR_9.
  • Worked on Production Version Recipe Master data report Performed BW 7.3 upgrade testing.
  • Extracted Transactional data and Master data using Table/View and function module based Generic Extractors from Vistex to SAP BW.
  • Enhanced the Master data Infoobjects, Datasources basing on the client requirement.

Show More

14. Business Content

demand arrow
high Demand
Here's how Business Content is used in SAP BW Consultant jobs:
  • Activated Business Content for standard objects and enhanced and created customized objects where required.
  • Activated Business Content as required.
  • Worked on activation of the standard business content for GL Accounts and Profit center, Material Management and Sales and distribution.
  • Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
  • Worked on activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO, SD.
  • Installed Business Content, Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.
  • Modified and used standard BI business content Info Cubes and created custom Cubes and DSO according to the requirements.
  • Identified Info Cubes, DSO's, data sources, info sources, reports and Installed from Business content.
  • Worked on activating BW Standard Business Content extractors (Inventory Management) and Info Cubes (Inventory Management).
  • Extracted data from standard Business Content sales, PO and Inventory extractors and custom-built extractors depending on requirements.
  • Participated in discussion with end user for data modeling, business content, granularity and performance tuning.
  • Worked on custom extractors as well as business content extractors for both master data and transaction data.
  • Extended Standard Business Contents based on client requirements using User Exit and Function Module.
  • Worked on activation of the business content for cost controlling and Cost CentreInfocubes.
  • Created Extract Structure at R/3, Replicate at BW and Installed Business Content.
  • Worked with 0PCA_C01 and 0COPA_C01 cubes from business content.
  • Perform GAP analysis against Business Content.
  • Activated the business content for FI AR & GL, SD Sales and Billing & Product Costing.
  • Analyzed business reporting requirements that could be satisfied and activated/modified corresponding Business content infocubes.
  • Activated and installed business content Infocubes, Queries to prepare BW Statistics report.

Show More

15. MM

demand arrow
average Demand
Here's how MM is used in SAP BW Consultant jobs:
  • Involved in testing of BW reports in SD & MM and validated the data between R/3 system and BW.
  • Maintained project status, error list, and communicated with the management about the project and development status.
  • Call flows are nothing but use cases such as getting customer account summary, pay credit balance etc.
  • Created end to end solution to create AR corporate summary report, including Universe design work and Publications.
  • Developed a BDC program in MM to load material master data from legacy system to SAP system.
  • Established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • Developed Reliance Retail - Daily Sales Summary Report with complex comparison with previous year history data.
  • Developed reports on the MM cubes to check the price variance for materials from different vendors.
  • Collaborated with SD, MM and FI functional consultants to resolve business and configuration issues.
  • Extracted data from MM and uploaded the data into the procurement cubes.
  • Established the best modeling and recommended strategies and architecture for SAP HANA.
  • Worked on LSMW for different Master data upload on MM, SD.
  • Configure SAP R3 MM Module.
  • Followed Agile Methodology for report development with pair programming and prototyping for user signoff and validation of the developed reports.
  • Developed Sales commission reports based on Invoice (2LIS_13_VDITM), Profit center data ( 0EC_PCA_3) and legacy data.
  • Executed change run program to update all the info provider area with the change in the infoobjects in MM.
  • Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
  • Loaded Master and Transactional data into BI system using Flat file extraction in MM.
  • Created bi-monthly commission statement for the entire sales force using SAP Vistex data.
  • Extracted data from MM (Stock Initialization- 2lis_03_BX data sources) .

Show More

16. Dashboards

demand arrow
average Demand
Here's how Dashboards is used in SAP BW Consultant jobs:
  • Conducted many iterations of requirements gathering sessions and crafted many operational and executive dashboards.
  • Facilitated development of rigorous executive reporting dashboards.
  • Interacted with business users to know their business views in developing and modifying Dashboards, Reports, Universes and User Security.
  • Designed, Created, and implemented Universes, Crystal Reports, and Dashboard designer Dashboards using best practices.
  • Created Analytic Dashboards for upscale users on the Financial Actual Budget and Target Budget.
  • Developed some complex Dashboards using Design Studio and Dashboards 4.0 for key business units.
  • Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and InfoView.
  • Created dashboards and reports with advanced Java scripting and CSS using Design Studio.
  • Designed Dashboards Using SAP Best Practices and Performance Improvement supported Data Modeling Followed.
  • Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio.
  • Worked on optimizing the performance of the dashboards.
  • Worked on Performance tuning for Dashboards and reports.
  • Designed and developed several multisource dashboards.
  • Created dashboards for top management using Xcelcius 2008 consisting of store sales and store traffic count.
  • Developed Performance Management Dashboards to set goals, measure and monitorKPI's for balance scorecard initiative.
  • Worked on POC for implementing ITSM analytics and BI monitoring dashboards in Solution Manager 7.1.
  • Gathered requirements on an adhoc basis from senior management in brainstorming sessions and developed dashboards using BO Xcelssius product suite.
  • Created universes on HANA views- Hybrid, and analytical and migrated and developed WEBi and Dashboards.
  • Created multi-layered dashboards for Finance and Accounting, Sales, Merchandizing and Marketing and Operations.
  • Created Product Dashboards for TRX, NRx trending using BEx queries & BEx Web Application Designer.

Show More

17. Key Figures

demand arrow
average Demand
Here's how Key Figures is used in SAP BW Consultant jobs:
  • Analyzed the requirements to implement Snapshot scenario for cumulative key figures.
  • Involved in taking necessary actions in order to correct calculated key figures and restricted key figures as user requirement.
  • Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key figures and calculated key figures.
  • Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
  • Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance the reporting features.
  • Used Structures, Calculated Key figures, restricted Key figures, selection, formula, Exception and conditions.
  • Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BW Queries.
  • Used CO-PA Extraction and developed CO-PA cube using multiple characteristics and key figures for Profitability Analysis.
  • Used Restricted Key Figures, Variables, and Report to Report Interface (RRI).
  • Created many formulas and calculated key figures to display the key figures with proper manipulations.
  • Configured use of restricted key figures, variables and calculated key figures in queries.
  • Worked on Info Set queries for reporting on master data and calculated key figures.
  • Created queries using Variables, Conditions, Exceptions, Formulas, Calculated key figures.
  • Worked on Virtual key figures and characteristics to calculate the retail daily margin.
  • Remodeled Info Cubes to add new characteristics key figures using new remodeling tools.
  • Created Info Cubes and DSO with Delivered/Custom Info Objects & Key figures.
  • Created restricted key figures and formulas in the reports.
  • Created BEx reports with Exceptions, Variables, Restricted and Calculated Key figures for detailed level reporting.
  • Created reusable structures, Restricted Key Figures, Formulas and BEx Reports.
  • Worked with Non cumulate Key figures when Extracting Inventory data.

Show More

18. Abap/4

demand arrow
average Demand
Here's how Abap/4 is used in SAP BW Consultant jobs:
  • Developed Start Routines, Update Routines and Transfer Routines using ABAP/4 and debugged the Update rules and Transfer rules.
  • Designed and developed the automation of loads, extracts and also flat file loads based on ABAP/4 programming variants.
  • Incorporated Transfer functions for Info Cubes using ABAP/4 as well as in populating master data and transaction data.
  • Developed an ABAP/4 conversion program to extract the data from Legacy System for Vendor master data transfer.
  • Incorporated Transfer rules for InfoCubes and customized update rules using ABAP/4.
  • Enhanced the Business content InfoCubes and R/3 extractors using ABAP/4.
  • Monitored loading errors and analyzed system logs and ABAP/4 dumps.
  • Developed complex routines in OO ABAP/4 for transforming data.
  • Created Data Extraction programs for generating reports using ABAP/4.
  • Generated/modified the functional consultant specified ABAP/4 reports for MM.
  • Modified and helped ABAP/4 programs for conversion project.
  • Customized reports using ABAP/4 coding.
  • Used Routines (Function Modules) & Abap/4 code for data Manipulation in transfer/update rules.

Show More

19. Fi/Co

demand arrow
average Demand
Here's how Fi/Co is used in SAP BW Consultant jobs:
  • Designed and developed 2 levels ODS comprising detailed and consolidated FI/CO information.
  • Worked on activation of Standard Business Contents, customized and created BW cubes in SAP FI/CO, SD and MM areas.
  • Configured and Installed Business Content extractors in various functional areas like SD MM and FI/CO to meet the user requirements.
  • Worked on LO extractors, Functional module extractors, FI/CO Extractors, SD Extractors, MM Extractors and data sources.
  • Involved in full life cycle implementation of SAP BW for FI/CO module and actively involved in ASAP methodology.
  • Created info cubes, ODS, Info sources and data sources from business content, for FI/CO modules.
  • Involved in design, development and extraction from R/3 systems and flat file for FI/CO and SD.
  • Created, maintained and modified existing queries on different Multi-Providers related to SD and FI/CO modules.
  • Installed and extended standard Business Content of SD&FI/CO using SAP best practices building blocks.
  • Integrate data from CRM and FI/CO module to simulate the effect of trade promotion.
  • Involved in implementing the SAP BW FI/CO module for NAO profitability analysis.
  • Experience in working with FI/CO and Generic Extractors.
  • Designed/Developed BI Data model for FI/CO area.
  • Extracted from FI/CO MM, PP and SD modules of SAP data using LO Execution Cockpit and V3 updates.
  • Experienced in the functional and technical areas of SAP FI/CO, SD, MM, PP Modules.
  • Involved in standard SAP modules such as SD, PP, FI/CO and MM.
  • SAP BI Express implementation of modules FI/CO, CO-PA, SD & MM.
  • Created Reports on SAP HR, SAP Payroll, SAP FI/CO and CATTS.
  • Identified the SAP integration points HR & FI/CO.
  • Arranged master and transactional data loads for SRM, SCM, and FI/CO/PCA functional areas.

Show More

20. Multi Providers

demand arrow
average Demand
Here's how Multi Providers is used in SAP BW Consultant jobs:
  • Design and Development of Custom Info cubes, ODS objects, Multi Providers, Info sets and master data objects.
  • Created multi providers to combine sales and billing data to give the users the flexibility to create cross functional reporting.
  • Designed and built the data extractors for the DSO, Info Cube, Multi providers with required enhancements.
  • Developed basic cubes and Multi providers for Premium's, Claim's, and Sales data.
  • Customized existing financial Info cubes, DSO & Multi providers according to business needs in BI.
  • Customized Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines.
  • Involved in transporting the cubes, Transformations and Multi Providers from Development to Quality system.
  • Created Multi Providers to enhance the reporting base and thereby improving the performance.
  • Used multi providers for improved report performance and reports on several Info Cubes.
  • Designed and developed Info Cubes with various aggregate levels and Multi providers.
  • Created Multi Providers, based on Info cubes, DSO objects.
  • Created Multi providers and enhanced queries for optimal performance.
  • Enhanced existing Multi providers & Info sets, Cubes.
  • Worked on Basic Cubes and Multi Providers.
  • Worked on developing universes using Universe Designer on SAP BW/BI BEx queries, Info Cubes, DSO's and Multi Providers.
  • Developed enhancements, InfoObjects, InfoCubes, DSO, Queries, Multi Providers and Custom Multi providers in BW implementation phases.
  • Involved in developing Universe and reports on SAP BI including DSO, Info Cubes, Multi Providers and BEx Query development.
  • Worked with SAP BI Modeling components like Info Cubes, DSOs, Info Sets and multi providers.
  • Designed and developed DSOs, Info cubes and Multi Providers for data loads and reporting requirements.
  • Created OLAP universes on Info cubes, Multi Providers and BEx Queries using Universe Designer.

Show More

21. ODS

demand arrow
average Demand
Here's how ODS is used in SAP BW Consultant jobs:
  • Worked on US Address & Global Address cleaning, Match transformations to clean the data by suing Quality transformations in BODI/BODS.
  • Designed & Developed custom Data Source, Info Source, Extractor, Info Cube and ODS to fulfill user requirements.
  • Leverage SAP SLT and Business Object Data Services (BODS) to acquire the data into SAP HANA Data Mart.
  • Performed analysis, Design, Development and Implementation of Customized Info cubes and ODS Objects for business End-Users.
  • Created new InfoCube, ODS, Info-sources, data sources, new Characteristics and Key figures.
  • Analyzed the Info Cubes and ODS objects to meet the reporting needs of the client.
  • Created ODS objects for the data extracted from the inventory and material valuation data sources.
  • Worked with development teams and project management teams to prioritize defects and remediation methods.
  • Loaded Data into the ODS Object before populate the data into the Info Cube.
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
  • Created custom CO-PA Cube, ODS, Data Mart to satisfy business requirements.
  • Staged Data in the ODS before transferring to the Info cubes.
  • Designed custom ODS for the material movements and designed loading strategies.
  • Worked on RRI jump queries and ODS queries.
  • Implemented 4 Cubes with ODS layers.
  • Developed custom Info Object, ODS, Info Cubes, MultProviders and reports for operational reporting, analytical and strategic reporting.
  • Constructed custom cubes, ODS, Multi Cubes & Queries depending upon individual requirements.
  • Worked in performance tuning methods- Info cube partitioning, datapackage sizing, PSA partitioning.
  • Design and development of Info cubes, Multi providers, ODS.
  • Created complex transformation's in BODS dataflows as per modeling requirements.

Show More

22. SAP BO

demand arrow
average Demand
Here's how SAP BO is used in SAP BW Consultant jobs:
  • Resolved and fulfilled SAP BO Incidents and service requests raised by business users according to SLA using Service now tool.
  • Involve in BO universe design and on integration of SAP BW and SAP BO using SAP integration Kit.
  • Developed WEBI, Analysis Office reports using BW queries with different possibilities available in SAP BO environment.
  • Worked on SAP BO Design Studio and developed reports and exported to Mobile Devices using QR Code.
  • Worked with the SAP BODS team to load data from Novartis own Contract pricing application to BW.
  • Developed SAP BO XI 3.1 Universe and WEBI Reports for PMO's using Universe Design tool.
  • Involved in migrating SAP BO universes and reports to Business Objects XI R2.
  • Project Leader for the Integration between SAP BW and SAP BO applications.
  • Designed SAP BO design studio Dashboards for Sales and Procurement.
  • Monitored, debugged and followed SAP BODS optimization techniques.
  • Project Description/Scope: SAP BI Implementation./ SAP BO.
  • SAP BODS was used for data provisioning.
  • Supported for SAP BO XI R2 for North America and SAP BO 3.1/4.0/4.1 versions for EMEA regions.
  • Experience on the usage of SAP BO 4.x suite of tools.
  • Developed and Broad casted Head count, Turn over and Time to Fill web intelligence reports Using Sap BO Info view.
  • Converted SAP BI COPA, FICO and MM reports from query designer into SAP BO report using Webi.
  • Worked on Inventory Loss reports with SAP BO WEBI as frontend reporting.
  • Created SAP BO Analysis for Office Reports for analytical reporting.
  • Worked on developing SAP BOBJ OER WEBI , OLAP reports, Dashboard design on underlying Bex queries for reporting purpose.
  • Generated Webi reports in SAP BO 4.0 Creation of BO Reports and Dashboards using Bex queries and cubes.

Show More

23. Source Systems

demand arrow
average Demand
Here's how Source Systems is used in SAP BW Consultant jobs:
  • Created Info Objects, Info Sources and Source Systems to load data into Info Cubes using Transfer and Update rules.
  • Load data into master data hierarchy through several source systems through direct update meant to populate an info object.
  • Performed data extraction, transformation and loading from SAP and non-SAP source systems into the SAP BW.
  • Analyzed and activated relevant Business Content and setup R/3, Flat File and BW as Source Systems.
  • Performed data validation of BI info providers with respect to source systems using ABAP/ reconciliation programs.
  • Monitor the data loads (daily/weekly/monthly) from source systems by means of process chains.
  • Verified the data quality and ensured the system is in sync the source systems.
  • Extracted data using LO Cockpit, CO-PA data sources from R/3 CRM source systems.
  • Worked on the mapping of the source systems from one client to another client.
  • Maintained Manual Reconciliation and also loaded data from external source systems such as EPDW.
  • Set up source systems to load both SAP/R3 and non-SAP transaction data to BW.
  • Involved in the monitoring data transfers from source systems into BW using PSA.
  • Created various Process Chains to automate the data loads from different source systems.
  • Uploaded Master Data and Transaction Data from Different Source systems.
  • Assigned source systems to the InfoSources and updated.
  • Created Source systems and Infopackges, which connects Data Stage and SAP BW for loading data to ODS and Info Cubes.
  • Proof of Concept Analyzed the source of the information and did a detail study on the source systems.
  • Involved with PSA in Monitoring the Data Transfer from Source Systems into BW for Flat file extraction.
  • Inialized the various data sources feeding to different data targets from different source systems.
  • Access to different Data sources was made via Adaptors like SAPI, SAPICRT and SAPIDIRECT, DBEEXTRACT for SAP Source Systems.

Show More

24. DTP

demand arrow
average Demand
Here's how DTP is used in SAP BW Consultant jobs:
  • Prepared list of inactive objects & extra objects, loaded 1, 60,000 records from flat file using DTP.
  • Created Data Transfer Process (DTP) to transfer data within BI from PSA (Persistence staging area).
  • Schedule the data loads by creating info packages, DTP's and process chains.
  • Involved in creating many complex OLAP variables, DTP routines.
  • Created and Maintained DTP and Info Packages for Loading.
  • Created and Maintained DTP and InfoPackage for Loading.
  • Designed and created custom Multiproviders, InfoCubes, DSO, InfoSets, enhance extractors, transformation, DTP and Info package.
  • Created custom Info Objects, Info Sources, DSO objects, InfoCubes, Multi-Providers and complex Transformations and DTPs.
  • Have created necessary DTP'S for Init & Daily Delta Loads for both Master & Transaction Data.
  • Created and activated ODS, Info Cubes, Info Sets, Multi-Providers, Transformations and DTPs.
  • Worked on customer exits, infopack and DTP routines, start and end routines etc.
  • Created DTP's, Transformations and DSO's, Info cubes and Multiprovider's.
  • Defined transformations, created DTP's and Infopackage for scheduling loads to data targets.
  • Worked with infopackages, transformations and DTP to load the data.
  • Worked on creating Transformations and DTPs.
  • Worked with Transformations and DTPs.
  • Created transformations, DTPs, info packages, and info providers for the master data, and transactional data- data flows.
  • Created DTPs, Infopackages for Full, Initial and Full repair loads for both Master and Transaction data.
  • Created Transformation mappings, DTPs, Info packages for all above DSOs.
  • Created and activated Info Cubes, DSOs, Multi Providers, Transformations, and DTPs.

Show More

25. Transaction Data

demand arrow
average Demand
Here's how Transaction Data is used in SAP BW Consultant jobs:
  • Performed Master and Transaction data extractor enhancements to accommodate various client requirements.
  • Performed Master and Transaction data extractor enhancements to meet report requirements.
  • Performed Master data and Transaction data Extractions (SAP, Non-SAP) and automated the data loads using process chains.
  • Loaded transaction data into PSA and updated data from PSA to ODS and finally activated the ODS to enable reporting.
  • Involved in transferring the master data and Transaction data from the R/3 systems to the Info Cubes in BW.
  • Created own Data Sources using Generic Data extraction for Master data and Transaction data Extraction using Transaction RSO2.
  • Installed standard cubes and its related objects from business content and loaded the master data and transaction data.
  • Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.
  • Created Process chains, Meta chains and Remote chains for daily loads and Monthly loads of Transaction Data.
  • Created Process Chains for Transaction Data and Master Data load including SD, MM and many InfoObjects.
  • Created/Scheduled InfoPackages and Process Chain for loading Master Data and Transaction Data and monitored the loads.
  • Extracted the master and transaction data from R/3 and Flat files as necessary and Monitored loads.
  • Created Maintenance Orders - Costs and Allocation Info Cube and Extraction of master and transaction data.
  • Involved in the activity of Process Chain creation for Master and Transaction data.
  • Uploaded transaction data into ODS objects from flat files and Oracle 8i.
  • Extended master data, text and transaction data extractors using ABAP.
  • Uploaded Transaction Data from the Flat File as the Source System.
  • Created process chains to load master data and transaction data.
  • Used APDs to perform several look ups to tie the transaction data to specific master data attributes.
  • Extracted Master and Transaction Data from Flat files and loading into InfoObjects, DSOs and InfoCubes.

Show More

26. Lo Cockpit

demand arrow
average Demand
Here's how Lo Cockpit is used in SAP BW Consultant jobs:
  • Worked extensively with LO Cockpit to activate required logistics data sources and good awareness of delta management.
  • Worked extensively on LO Cockpit extractions loaded the data from R/3 to BW and used Initialization with delta update methods.
  • Activated LO cockpit, extract structures and data sources in sales order management to facilitate the data extraction to BW.
  • Extracted data from SAP ECC using LO Cockpit and worked on enhancing the extract structures based on the Client Specs.
  • Worked extensively on the extraction of SD, LO cockpit and worked on generic data extraction in FI-SL.
  • Worked on SAP BW functionality like LO Cockpit, COPA, Generic extractions and flat file extractions.
  • Worked on LO cockpit for Maintaining extract structures, Info Sources and activating the update.
  • Worked on LO cockpit for Maintenance of extract structures for Orders, Billing & Deliveries.
  • Experience in the creation of the setup tables for the LO Cockpit extraction.
  • Customized LO cockpit using enhancements wrote User-Exit programs to populate enhanced fields.
  • Activated standard extractors for the required Application components in LO cockpit.
  • Worked extensively on standard and custom defined LO Cockpit Extractions.
  • Used LO cockpit, for extracting sales order information.
  • Performed Data Extraction and Data Staging using LO Cockpit.
  • Work extensively on LO Cockpit and extracted data.
  • Performed and setup multiple extractors in LO cockpit.
  • Worked on LO Cockpit and LIS Extractions.
  • Activated the Data Source 2LIS_04_P_MATNR in the LO cockpit.
  • Developed the staging layer in the BW for FI and LO Cockpit Extractors by using the write Optimized DSO's.
  • Involved in the Configuration of Generic Extraction and LO Cockpit functionalities.

Show More

27. Go-Live

demand arrow
average Demand
Here's how Go-Live is used in SAP BW Consultant jobs:
  • Evaluate technical impact assessment of changes in a live system after Go-Live and identify the best possible solutions.
  • Developed break fix on the data model and reports after Go-live and responsible for the system change control.
  • Involved in cut over activities for two releases (R5.0 and R5.1) during the business go-live.
  • Conducted super user training and documentation on best practices for support and maintain post go-live system.
  • End user support, Project Go-live Review, Define the Scope of next Iteration of Implementation
  • Prepared the list of cut-over activities and co-ordinate with PMO & Basis during production Go-live.
  • Performed the upgrade steps to be done as a BW Consultant to go-live.
  • Supported the Cut-over & Go-live in the final phase of the project.
  • Defined phases for requirements that were not critical for initial go-live.
  • Created documentation to facilitate the knowledge transfer during the go-live.
  • Worked as an onshore SPOC for BAU during project go-live.
  • Design and Implement a deployment plan for go-live.
  • Worked on Go-Live support after implementing the project.
  • Post Go-Live Support, handled Support Issues.
  • Involved in UAT and Go-live process.
  • Worked on Post Go-live support.
  • Involved on Post Go-Live support.
  • Involved in cutover plan preparation for go-live.
  • Worked at project life-cycles in realization, UAT, defect fixes, cutover, pre go-live, go-live and post go-live.
  • Involved in preparation of cutover/Golive documents for the complete schedule at the time of go-live.

Show More

28. Update Rules

demand arrow
average Demand
Here's how Update Rules is used in SAP BW Consultant jobs:
  • Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
  • Used ABAP Routines in Update rules & Transfer Rules to update characteristics and Key Figures in the Info Cubes.
  • Created & maintained transfer rules, transfer routines, update rules, and update routines to maintain data consistency.
  • Transferred Data to the InfoCube and the Operational Data Store from the InfoSource using transfer and update rules.
  • Modified Update rules, transfer rules, update routines and transfer routines as per client requirements.
  • Used ABAP conversion routines in transfer rules and update rules to load and update data targets.
  • Direct Data Staging: Update from Master Data into an Information Object without using Update Rules.
  • Created transport and communication structures, transfer rules, update rules for ODS and Info Cube.
  • Debugged and modified ABAP routines for user exits start routines, update rules and transfer rules.
  • Created and Activated Communication Structure, Transfer Structure, Transfer rules and Update Rules.
  • Developed ODS object to load transaction data from Info Source and defined update rules.
  • Activated the info sources, info objects, transfer rules and update rules.
  • Created Update rules to update data from multiple DSO objects and master data.
  • Created Transfer Rules & Update Rules using ABAP routines wherever those required.
  • Developed Transfer rules, update rules & worked on update routines.
  • Created/changed transfer rules, update rules as per Clients requirement.
  • Created custom InfoCubes including update rules.
  • Developed routines in BI Flexible Data Staging: Update into any data targets using Communication Structure and Update Rules.
  • Transported Info Objects, Info Cubes, Queries, and update rules, Multi cubes from Development to Quality.
  • Developed Transfer rules, update rules and Start routines to incorporate Business logic for data manipulation.

Show More

29. SQL

demand arrow
average Demand
Here's how SQL is used in SAP BW Consultant jobs:
  • Designed, developed and optimized HANA data models using attribute views, analytic views, calculation views, and SQL procedures.
  • Worked on various Platform Transforms like Case, Map_Operation, Merge, Query, Row_Generation, SQL, Validation.
  • Designed data services job to load the weekly Summary data from the RADAR Database to SQL Staging area.
  • Used Data Federation Administration Tool for monitoring the SQL queries, test SQL queries and browsing history.
  • Created reports using the Universes, Stored Procedures and Free Hand SQL as the data providers.
  • Created Full Client reports using different Data providers like Oracle, Excel sheets, SQL server.
  • Used system generated SQL and custom SQL and generated table joins involving multiple tables.
  • Worked on SQL scripts using CE functions for Calculation View and Procedures.
  • Tuned and Enhanced Universes with SQL Queries for the Report Performance.
  • Develop SQL scripts and functions for complex reusable scenarios in HANA.
  • Optimize various SQL queries to make the reports run faster.
  • Created SQL script based Calculation Views using CE functions.
  • Involved in performance tuning of SQL queries.
  • Developed complex SQL Scripts in Calculations Views.
  • Experience in Stored Procedure, SQL.
  • Migrated existing DB (SQL DB) into HANA DB.
  • SAP HANA database uses SQL script.
  • Used BW statistics, RSRV, and SQL Trace tools.
  • Involved in DataProvisioning, Created Attribute views, Analytical views, Calculation views Graphical and Calculation views of type SQL.
  • Used multiple data sources including HANA, sql, and Oracle into visual analytics.

Show More

3 SQL Jobs

No jobs at selected location

30. Workbooks

demand arrow
low Demand
Here's how Workbooks is used in SAP BW Consultant jobs:
  • Developed customized Reports and WorkBooks.
  • Configured Custom cubes, Transformations, Multiple Update Groups, ODS, Cubes, Aggregates, queries and workbooks.
  • Developed workbooks to collect different KPI's and also provided the result in the form of charts.
  • Implemented cells, workbooks and OLAP variables (like Customer exits, formula variables etc.)
  • Installed Business Content for standard Info Objects, Info Cubes, Queries, Workbooks and Roles.
  • Trained users in creating Ad-Hoc queries, Workbooks, Information Broadcasting, and Web Report.
  • Worked with BEX Query Designer, Analyzer in building queries and worked with workbooks.
  • Created workbooks and wrote VBA Macros for the reports as per the requirements.
  • Checked weather the workbooks are executing perfectly as before they were.
  • Created, migrated the Queries, Workbooks, Views, Data Flow, Design from BW 3.5 to BI 7.0.
  • Created custom variables; Assigned workbooks to roles, Configured BEx Browser to organize the workbooks under roles in folders.
  • Work on BEx Queries, virtual characteristics, cell definitions, workbooks, user profiles and role assignment.
  • Developed Queries, Workbooks & Query Views and Web Templates Created process Chains, Worked on transports.
  • Created several Workbooks using BEx Analyzer by using the queries created using query designer.
  • Developed several queries and workbooks using BEx Analyzer according to end users requirement.
  • Migrated all the queries, Workbooks and Webtemplates to BI 7.0.
  • Created BEx Workbooks by adding formats, buttons, Macros.
  • Created workbooks by including a set of BEx reports.
  • Developed the Daily Sales Reporting for US and Europe Regions using BEx workbooks and Macro's coded in Visual Basic.
  • Checked InfoSpoke access, Authorisation Concept, conversion of chart settings, Multiproviders, Infosets Worked on Queries & workbooks.

Show More

31. Xcelsius

demand arrow
low Demand
Here's how Xcelsius is used in SAP BW Consultant jobs:
  • Worked exclusively on Xcelsius for interactive Dashboards for analysis of Quarterly and Yearly sales.
  • Designed and developed OTC metrics dashboards and used live office to feed data into Xcelsius from source WEBI reports.
  • Developed Complex Interactive Dashboards using Xcelsius with Line, Bar, Combination Charts, Selectors for What-If Analysis.
  • Developed XCelsius Complex Dashboard equivalent to existing SAP BI Dashboard for Procure to Pay Summary Data.
  • Experience on SAP QAAWS used in mapping data directly from Universe to Xcelsius Dashboards.
  • Implemented dynamic charts and graphs in dashboards to improve look and feel using Xcelsius.
  • Created Web I reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
  • Created Revenue Dashboard, Sales figure Dashboard using Xcelsius and Dashboard Designer.
  • Created Complex and Ad-Hoc Reports using Web Intelligent and Xcelsius.
  • Created four Xcelsius Dynamic dashboards over SAP BI.
  • Worked in Xcelsius 2008 for summary level reports.
  • Created Dashboards and Scorecards using XCelsius 2008.
  • Designed/Developed WEBI Reports, Crystal Reports, Xcelsius dashboards for Finance and Sales to represent several KPI's and Analytics.
  • Involved in designing EXEC_DASH Board universe for all the reporting Needs Involved in Designing Xcelsius Graphs using QAAWS.
  • Scheduled reports to run on a periodic basis Worked on XCELSIUS Dashboard development using QAAWS and Live-Office.
  • Created Xcelsius Dynamic Dashboards over SAP BI data with Complex Calculations to get Alerts for Xcelsius Dashboards.
  • Created multi-layered Xcelsius dashboards for SRM bidding, financial reporting and for client facing project team status
  • Created both technical and functional designs for BEx queries, WebI and Xcelsius reports.
  • Worked on deployment of Webi reports and Xcelsius dashboards.
  • Created various reports on Webi and dashboards on Xcelsius.

Show More

32. Bobj

demand arrow
low Demand
Here's how Bobj is used in SAP BW Consultant jobs:
  • Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BOBJ for end user access.
  • Provided Training to BOBJ - BI Business Users, team members and created end-user training material and documentation.
  • Worked on BW and BOBJ Integration, created BOBJ reports in WEBI and generated dashboards.
  • Trained multiple Business groups in North America & Western Europe on SAP BOBJ functionality.
  • Developed SAP BOBJ WebI reports on the universe generated by the calculation view.
  • Created many Variables and Prompts in BOBJ according to the user requirement.
  • Involved in performance tuning of various WEBI reports in BOBJ side.
  • Worked on SAP BOBJ reporting tools for creating reports.
  • Conducted training sessions during the SAP BOBJ 4.0 upgrade.
  • Established best recommended strategies for SAP HANA and BOBJ.
  • Analyze and architect the BW on HANA and BOBJ system.
  • Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
  • Created Secured Connections to build the OLAP Universes using the Source as BEx Queries in the BOBJ Designer.
  • Used SAP 4.1 Business Object tools to create a Webi Reports and Dashboards in BOBJ.
  • Developed BOBJ universes, webi reports and dashboards on top of HANA.
  • Worked in SAP BW HANA, SAP HANA live,BW,BOBJ project.
  • Designed a large BOBJ Universe for ad hoc reporting, Webi reports and a complex P&L dashboard.
  • Worked on BOBJ Dashboard 4.0 with development of reports by using the BEx Query as Datasources.
  • Created complex Bex queries on the Multiproviders with structures to support BOBJ universes.
  • Designed and developed FSDs, TSDs for BOBJ reporting on top of SAP BI/BW, R/3 systems.

Show More

33. WAD

demand arrow
low Demand
Here's how WAD is used in SAP BW Consultant jobs:
  • Worked in Web Reporting using WAD, Edited HTML, inserted JavaScript, Report designer, Web Analyzer and broadcaster.
  • Worked with Web Application Designer (WAD) for creating web templates for FI, PP modules.
  • Created web reports through report template in WAD (Web Application designer).
  • Created several web reports using WAD and published the reports to portal.
  • Developed few customized web templates using WAD to suit client's requirement.
  • Created Web templates using Web Application Designer (WAD).
  • Created dashboards for AR, Billing applications by using WAD.
  • Redefined the queries in WAD and report designer.
  • Involved in solving WAD reports.
  • Involved in publishing new WAD reports to Enterprise portal Involved in assigning the roles to the user in category wise.
  • Rewrite some of the WAD reports to SAP Design studio as a part of BW upgrade project.
  • Developed BEx reports using Query Designer and set as data providers in WAD by using Broadcasting features.
  • Web template otherwise global template was used for developing web reports using Bex Query Designer and WAD.
  • Created web reports through report templates in WAD, Training end users in query development-using BEx.
  • Involved in WAD to design studio migration project and created drilldowns for this wad reports.
  • Published IViews for WAD templates and embedded in the portal in the respective business roles.
  • Developed reports using BEx Analyzer and Web Application Designer (WAD).
  • Designed new applications using new Templates in BEx WAD.
  • Created input ready query using BEx Query Designer and WAD for posting planningdata into Real Time InfoCube to have planned date.
  • Developed Web reports corresponding to BEx queries using BEx WAD tool.

Show More

34. PSA

demand arrow
low Demand
Here's how PSA is used in SAP BW Consultant jobs:
  • Worked on Remote Cubes to support real time data and Extracted required data from the Data Source of PSA to DSO.
  • Failed data packets were analyzed for quality check in PSA and reloaded to ODS and further loaded into Info cubes.
  • Worked on continuous improvements such as tuning the performances of the data sources, PSA and Change log cleanup activities.
  • Created Production System Data Storage maintenance ABAP Program to maintain the system storage watch and deletion of PSA data.
  • Automated deletion of PSA & Change Log tables in process chains as a part of Data Management Strategy.
  • Performed automated deletion of PSA and Change Log tables using Process Chains to improve the Data Management.
  • Stored data from SAP R/3 tables into ODS objects through PSA to perform detailed level of reporting.
  • Created a Process Chain, which deletes the PSA Data based on the Retention Periods.
  • Updated Data through PSA for Info Cube, ODS using Delta, Full update.
  • Created process chains for data loading, delta uploading and periodical PSA deletion.
  • Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
  • Designed Three Info cubes with daily and Monthly Granularity, extraction from PSA.
  • Validated data consistency in Reports with data in the PSA and RSA3.
  • Created various transfer rules with and without PSA update.
  • Uploaded data from R/3, flat files using PSA.
  • Loaded Transactional Data into PSA and updated Data from PSA to DSO and Activated DSO Data for Reporting and Analysis.
  • Created aggregates and indices, deleted PSA tables, DSO Change logs and performed fine tunes routines where necessary.
  • Created process chains for the above dataflows and also created PC for purging the PSA requests periodically.
  • Involved in PSA maintenance Experience working with New Integrated planning module.
  • Involved in performance enhancement features such as cube indexing, maintaining aggregates, roll upsand cube compressions.

Show More

35. HR

demand arrow
low Demand
Here's how HR is used in SAP BW Consultant jobs:
  • Created custom fields on Employee Master and HR Position master using complex update logic according to the business requirements.
  • Maintain Generic Data sources with Delta capability and Extraction checking of the Data source through Extract checker.
  • Created WEBI reports & Crystal Reports and deployed them through Info View with Universe as Source.
  • Extracted data from ECC, classification system, through Web service and Flat File.
  • Performed LO, profitability (CO-PA) and Generic extractions throughout the project.
  • Worked from Release 1 through Release 5 in Pfizer Global ERP Deployment Program.
  • Extracted HR payroll data using data source 0HR_PY_1for a required wage type.
  • Handled exceptions through SAP Mail, batch printing and alert monitor.
  • Worked on standard HR- Payroll and benefits extractors and reports.
  • Used Process Chains to schedule data loads from SAP SD, MM and HR to BW.
  • Worked extensively on FI-CO, SD, HR, COPA.
  • Worked through SAP Consulting, NA.
  • Realigned over 60 multi-providers and dependent objects through a Global landscape without impacting reporting functionality for the Environment Realignment Project.
  • Created Objects and prepared Reports like financial reports, HR reports, standard and ad-hoc reports, and universes.
  • Developed BEx XLS Queries and Workbooks by which BW data analyzed through navigation.
  • Created Three Xcelsius Dynamic Dashboards over SAP BI data.
  • Analyze the Business requirement & Arrange Design Walkthroughs.
  • Worked on three HANA POCs and two HANA Projects.
  • Created Web enabled Dashboard "HR Tracker".
  • Implemented Analytical Dashboards and reporting for Pulse, Ismart and HR analytics Projects using Business Objects Tools and Spotfire.

Show More

36. User Acceptance

demand arrow
low Demand
Here's how User Acceptance is used in SAP BW Consultant jobs:
  • Involved in user acceptance testing and data validation testing and prepared documentation.
  • Participated in fixing defects raised during user acceptance testing phase.
  • Support integration and user acceptance testing.
  • Involved in Unit Testing, Data loading, Execute Workbooks, Integration Testing, and User Acceptance Test.
  • Involved in support system, performance, integration, user acceptance and regression testing and created Test Scripts.
  • Prepared Test Plan & Test Script for Unit Testing, System Integration Testing and User Acceptance Testing.
  • Worked with test group and business users to perform unit, Integration, user acceptance testing.
  • Performed unit testing, system integration testing, and user acceptance testing at various levels.
  • Planned and executed Integration test and involved in designing User Acceptance Test and Procedures.
  • Involved in Unit Testing, Regression Testing and User Acceptance Testing in GPS project.
  • Managed project promotion activities- transports, user acceptance testing, initial data loads.
  • Developed documentation, conducted User Acceptance events, and trained the end users.
  • Compiled the test cases for User Acceptance testing of the BW objects.
  • Perform in depth Unit Testing and assist with User Acceptance Testing.
  • Created test scenarios for Integration testing and User Acceptance testing.
  • Developed prototype and presented the demo session for user acceptance.
  • Prepared Test Cases and results for User Acceptance Testing.
  • Prepare User Acceptance Testing uses cases.
  • Involved in User acceptance test (UAT) of BI reports.
  • Activated BW standard queries based on user acceptance and collected in BEx transport and imported.

Show More

37. CRM

demand arrow
low Demand
Here's how CRM is used in SAP BW Consultant jobs:
  • Worked as CRM Techno-functional consultant to develop reports like Activity Monitoring Report, Opportunity Monitoring Report, Territory Monitoring Report etc.
  • Enhanced 0DOC_NUM master data InfoObject with CRM Service Order information to make synchronize the relation between Service Order to Purchase Order.
  • Involved in Business requirements gathering, analysis and designing BW solutions of specifically on CRM and SRM modules.
  • Developed data model for Actual and planned data with CRM-BI IP for report requirement of target Customer sales.
  • Worked on Performance Optimization of CRM reports based on the analysis after implementation of BI Accelerators.
  • Analyzed and corrected production problems as they occur in the SAP BW & CRM system.
  • Extracted and design BW model views on the opportunities and complaints data from SAP CRM.
  • Worked extensively on implementation and extracting from CRM to BW and reporting on them.
  • Developed reports for SAP CRM, and MM and have worked in FICO integration.
  • Worked on CRM-BI IP integration to load data in to planned and Actual cubes.
  • Involved in SAP CRM enhancements to add custom attributes to the business transactions.
  • Worked on CRM Trade Promotion management reports & Trade Funds Management reports.
  • Experience developing Crystal Reports 2008 on top of SAP BW and CRM.
  • Configure, validate and promote requested enhancements to existing BW/CRM solutions.
  • Created complex reports integrating SAP CRM and BW.
  • Worked with SAP on CRM Extractor Delta Issues and suggested the Basis Team to Apply the OSS Notes in the system.
  • Enhanced Activity data source (0CRM_SALES_ACT_1) in CRM to add custom fields like owner Id and buyer contact fields.
  • Generated reports using BEx Query Designer SAP CRM as a source system.
  • Designed and developed CRM Mailing Outbounds as a part of Campaign Report.
  • Team lead for all the deliverables related to CRM B2B.

Show More

38. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in SAP BW Consultant jobs:
  • Interfaced with Business Community to obtain reporting requirements that were converted to functional and technical specifications.
  • Involved in gathering business requirements, GAP Analysis, design and development of technical specifications.
  • Designed and developed functional specifications, technical specifications for BO reporting.
  • Involved in converting the Functional Specifications into Technical Specifications.
  • Designed functional and technical specifications for SAP BI implementations.
  • Created Technical specifications and standard modeling documents for HANA.
  • Created Technical specifications based on the Functional specifications.
  • Prepare requirements, functional and technical specifications.
  • Involved in setting up the project plan, designing the functional, technical specifications, testing plan and production migration plans.
  • Perform analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
  • Developed design specifications, Technical Specifications, Mapping documents, and Unit Test Script documents based on the reporting requirements.
  • Analyzed the Query Technical Specifications, designed the queries and if required suggested changes to the client for optimal solution.
  • Designed the Query Technical Specifications for complex Key Financial Metric (KFM) reports and their components reports.
  • Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
  • Prepare functional, technical specifications, work estimates and hand over/communicate to the team.
  • Defined work packages and technical specifications for design, development, testing and roll-out.
  • Used RRI concept whenever it is required as per the Technical Specifications.
  • Involved in writing the technical specifications for the reports and forms.
  • Prepared technical specifications for HR - Time Audit report Jump Functionality.
  • Project Responsibilities: Development Activities: Analyzing functional and technical specifications.

Show More

39. Query Performance

demand arrow
low Demand
Here's how Query Performance is used in SAP BW Consultant jobs:
  • Improved Query Performance by Creating Aggregates, Indexes and Compressed Info cubes To Improve the Load and Query Performance.
  • Used BW Statistics, Query Monitor and optimized Update Rules, Aggregates and created Indexes to enhance query performance.
  • Resolved Query Performance issues using transactions like RSRT, RSRTRACE, ST03N, RSDDSTAT, and BW Statistics.
  • Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to improve the Query performance.
  • Resolved issues in Database Performance Tuning, Data Load Performance Tuning, and Query Performance Tuning.
  • Improved data loading and query performance by doing compression, aggregates, and partitioning.
  • Worked with Aggregates, Partitioning and Indexes for increasing the Query Performance.
  • Created Cube/DSO Indexes, compressing/partitioning the cubes to enhance the query performance.
  • Created the Aggregates according to the report requirements for better query performance.
  • Handled Query performance issues using appropriate objects while construction of Query.
  • Worked on query performance and troubleshooting of reports using RSRT.
  • Created Aggregates on Info Cubes to improve the query performance.
  • Worked on BI Accelerator to improve the Query Performance.
  • Worked on BWA to improves the Query Performance.
  • Created aggregates to improve the query response & Analyzed Query performance to suggest optimizations as per theory and practical observations.
  • Apply Data modeling best practice to existing BW environment to get better query performance.
  • Created Aggregates on Infocubes in order to generate reports and improve query performance.
  • Worked on Query performance techniques like building Aggregates, Indexes, and Rollups.
  • Maintained Aggregates, indices and compressed InfoCube to improve query performance.
  • Worked on Rollups and Partitioning to improve the query performance.

Show More

40. Data Targets

demand arrow
low Demand
Here's how Data Targets is used in SAP BW Consultant jobs:
  • Modeled Data targets according to the reporting requirements.
  • Designed and developed custom ODS objects, Info Cubes for Inventory data and activated Update rules for these data targets.
  • Assigned data classes and appropriate size categories to all data targets and building regular compression into data load processing.
  • Prepared design documents from the Business Requirement docs and identified the relevant Data Targets to meet the customer requirements.
  • Participated in validating the data consistency in reports with data targets against PSA after loading them to data targets.
  • Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data Targets.
  • Worked extensively on LO Cockpit extractor for loading data into standard data targets for Sales and Distribution data.
  • Worked with functional consultant for mapping the source data (R3/non R3) to Data Targets in BI.
  • Reconciled and validated data targets like Info cubes and ODS objects with R/3 and BW data analysis.
  • Defined and maintained transformations, DTP s and Info package for scheduling the loads to data targets.
  • Used to Monitor regular data loads using process chains which will update various BW data targets.
  • Created custom data targets, update rules, transfer rules and info sources.
  • Involved in mapping of info source with the Data targets using update rules.
  • Loaded and monitored data in data targets using InfoPackage.
  • Worked on creating data targets i.e.
  • Worked on creation of End routines for Infocubes which does changes of data and ultimately send to other data targets.
  • Designed and developed custom ODS and Infocubes for Sales data and activated Update rules for these data targets.
  • Enhanced datasources to input extra fields from R/3 to BW data targets.
  • Experienced in InfoCube managing activities like creating Indices, Rollup and compression the data in Data Targets.
  • Created Process Chains to schedule the data loads into data targets, infocubes and Rollups.

Show More

41. ETL

demand arrow
low Demand
Here's how ETL is used in SAP BW Consultant jobs:
  • Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
  • Worked on RDS to implement ETL Replication and also using Rapid Marts for SAP road map.
  • Followed ETL and SAP BI Best practices to build and transport deployment groups between system landscapes.
  • Used PSA for checking data quality before loading and BW monitor for troubleshooting during ETL.
  • Performed ETL to load data in to the SAP BW system from multiple sources.
  • Worked on Universe Database to create Hash Files, Intermediate files while ETL process.
  • Developed the ETL procedure to extract the last 7 data into BW.
  • Monitored, Debugged and followed ETL best practices for efficient data loading.
  • Tested the ETL process with new data flow using emulated data sources.
  • Designed and Implementation of ETL architecture in IBM Data Stage Environment.
  • Worked on ETL (Extraction, Transformation, Loading).
  • Worked on ETL Process for Non-SAP Source using BODS.
  • Experienced in using BODS for ETL purposes.
  • Worked on RDS to implement ETL Replication.
  • Worked parallel with ETL team and SAP BO team for sending the data to ETL through open hub and Infospoke.
  • Developed, Implemented and Managed Extractions , Transformations and Load (ETL) of more than 100 Flat files.
  • Worked closely with Informatica ETL team to pull data from BI Open hubs data into TIBCO-CIM.
  • Architected, developed and implemented SAP EIM (Data Services) ETL jobs for customers.
  • Trained company's IT team on details of the ETL process and OLAP in BI 7.0.
  • Used Cognos and Informatica for ETL & reporting.

Show More

42. User Exits

demand arrow
low Demand
Here's how User Exits is used in SAP BW Consultant jobs:
  • Customized standard business content extractors and enhanced Data Sources in various applications using User Exits.
  • Implemented BI Content data Source enhancements, Generic extractors, User exits and Customized delta built up for the data sources.
  • Created Custom DataSource & required Custom User Exits for data extraction, InfoSource & Custom Update Routine for data transformation.
  • Worked on the enhancement of the business content data sources by using append structures and user exits from transaction CMOD.
  • Performed Data Extraction and Data Staging using CO-PA and extended the structures using user exits to support the business needs.
  • Enhanced the DataSources to include the custom fields in extract structures and used user exits to populate the data.
  • Worked with Start Routine, Field Routine, End Routine, Expert Routine and proficient in writing user exits.
  • Enhanced the standard extractors, by adding fields and User Exits to handle customer specific business requirements.
  • Implemented user exits in BI to calculate version of the forecast dynamically in the planning reports.
  • Extend the Business Content Data sources using Enhancements and populate the appended fields using User Exits.
  • Used Cell-Definitions, Structures, Exceptions, Conditions, and various User Exits in the Reports.
  • Design, development and testing of reports, user exits, SAP scripts and print programs.
  • Extended the extract structures by adding new fields and populating them with the user exits.
  • Worked on ABAP in writing programs and debugging Routines, and User Exits.
  • Enhanced standard extractor to populate the custom fields using user exits.
  • Worked on standard SAP enhancements using user exits and BADI s..
  • Developed Custom extractors using User Exits and Function modules.
  • Created and enhanced User exits on R/3 and BW.
  • Worked on User Exits for Enhancement of Extract Structure.
  • Used ABAP for enhancing DataSources for User Exits.

Show More

43. Hub

demand arrow
low Demand
Here's how Hub is used in SAP BW Consultant jobs:
  • Carried out Transport to staging and production environments, data transfer using Open Hub Services (OHB) /Info Spokes.
  • Led the architecture and design of the open hubs to facilitate the SAP BI data to the downstream systems.
  • Involved in the implementation of Open-Hub Service to send the daily snapshot data to an external application.
  • Open Hub interface to transfer data from BI to Flat Files to load to an external system.
  • Worked on Open Hub Destinations through which the data is consumed by different third party systems.
  • Created Info Spokes to retrieve data from BI to Flat File using Open Hub Service Concept.
  • Developed Open Hub destinations to send the BI data to MS Sequel Sever for further reporting.
  • Worked on Open Hub services to supply data to the external systems for analysis.
  • Created Open Hub Destination to load the BW data to 3rd party system.
  • Work on Open Hub to transfer data from Info Providers to Flat Files.
  • Created Open hub models to send the data from BW to other systems.
  • Created Open Hub Destination to load data from SAP BW to external Target.
  • Designed and developed open hub solutions for extracts to external systems.
  • Involved in Open Hub Destination to store data from SAP BI to local databases for ad-hoc reporting purpose of ERP users.
  • Worked extensively on the Open Hub service, created Infospokes to distribute the data to other EDW Systems.
  • Exported the data from BW into external systems using Open hub services and APDs.
  • Developed InfoSpokes using Open Hub service to extract data from BW into .CSV format.
  • Involved in creating Cube, DSO's, Multiproviders, Open Hub Destination.
  • Have created Open Hub Destinations and APD s using BEx queries as source
  • Used BEx queries, APDs and Open Hubs to extract data.

Show More

45. PP

demand arrow
low Demand
Here's how PP is used in SAP BW Consultant jobs:
  • Extracted data from different modules and uploaded the data into the procurement cubes and activated the appropriate Business Content cube.
  • Enhanced the BI process chain monitoring from tidal tool to solution manager 7.1 for advanced alerts and automatic support messages.
  • Developed Technical design document based on the Functional Design Document and Business requirements gathering and got approved from COE team.
  • Developed Custom Aggregation Levels, Filters, Planning Functions and Planning Sequences for various applications which handles different version.
  • Developed front-end queries using Query Designer and Web Application Designer (WAD) and publishing results on the web.
  • Developed Revenue equipment tracking application using Sales orders (2LIS_11_VAITM, 2LIS_12_VCITM, 2LIS_02_ITM).
  • Developed the True history Application based on Sales order items (2LIS_11_VAITM).
  • Worked in Web Application Designer (WAD) for creating web templates.
  • Enhanced new Info Objects to be attached/mapped in Info Sources/Communication structures.
  • Coordinate and support QA and UAT for enhancements and productions fixes.
  • Worked on Web Application Designer and published reports on web.
  • Rewrite all the Visual composer applications to SAP Dashboards 4.0.
  • Involved in daily, weekly, monthly Application Monitoring activities.
  • Execute the effective Knowledge transfer to production and support.
  • Interacted with Business units to enhance the existing applications.
  • Managed offshore team (development and support) and acted as SPOC all the communications / interactions with users and onsite.
  • Developed Generic Datasource to pull the data from R/3,which has the mapping of Profit centers and Cost Centers.
  • Performed Query Performance Tuning by analyzing and applying aggregates, line item dimensions, data compression, and indices.
  • Created DSOs for the Vendor/Supplier Agreement data from the BW for Reporting purposes.
  • Project Type Operations Support and Enhancements Project Project Description * Worked on BW 7.3 system, connected to respective ECC system.

Show More

46. Co-Pa

demand arrow
low Demand
Here's how Co-Pa is used in SAP BW Consultant jobs:
  • Implemented CO-PA, FI Modules and extensively involved in extracting and defining Hierarchies for Account Groups, Profit Center Groups etc.
  • Involved in activating Business Content for Standard Info Objects, DSO, InfoCubes related to FI, CO-PA, SD.
  • Performed Logistics, controlling and profitability (CO-PA), Human Resources and Generic extractions throughout the project.
  • Design technical data flow and develop technical specification for reports pertaining to SD, CO-PA and CRM application.
  • Worked on generic data extraction in CO-PA. Extracted Line Item data from GL, AR and AP.
  • Designed and created Info cube, Info source to extract data from CO-PA in to BW.
  • Worked Extensively on Standard and Custom Defined LO, CO-PA Extractors Installed Relevant SAP Business Content.
  • Installed CO-PA cubes from Business Content and customized cubes to suite the end user requirements.
  • Created transfer rules, update rules, transfer routines and update routines in CO-PA extraction.
  • Used CO-PA structures for sales trace overview to facilitate the data extraction to BW.
  • Involved in requirement gathering in functional areas of FI-AP, FI-AR and CO-PA.
  • Worked extensively on standard and custom defined CO-PA and LO extractors.
  • Designed and created data source in CO-PA on line item table.
  • Enhanced CO-PA and FI cubes with additional necessary missing fields.
  • Extracted data from R/3 using LO and CO-PA structure.
  • Worked on data extraction, LO-Cockpit, CO-PA..
  • Performed CO-PA and LO Cockpit extractions.
  • Worked on different modules such as SD, MM, FI, CO-PA and FSCM.
  • Performed extensive FI-GL, AP, AR, CCA, PCA and CO-PA extractions.
  • Developed Data Source for CO-PA on basis of operating concern and developed DSO object for the Data sources and generated reports.

Show More

47. Olap

demand arrow
low Demand
Here's how Olap is used in SAP BW Consultant jobs:
  • Developed Business Objects edition for OLAP Analysis for self-analysis & deployed WEBI reports upon iPad using BI Explorer.
  • Created BW OLAP Universes on top of BW Queries to access the BW data in Business Objects.
  • Worked on creating SAP BW OLAP universes over BEX queries in Business Objects 3.1 Environment.
  • End user training on developing and executing Analysis for OLAP and Analysis for Office reports.
  • Created OLAP Connections for the SAP HANA Information views as source for reports in IDT.
  • Created Web intelligent reports on the OLAP/relation universe which was created using Information Design Tool.
  • Worked on dashboard development using Design Studio with BW OLAP sources as the back-end.
  • Worked with Universe Builder to build OLAP universes from SAP Cubes and BW Queries.
  • Created SAP Analysis for Office reports on OLAP using SAP BW data.
  • Worked extensively on OLAP and OLTP tools.
  • Generated OLAP Universes based on BW queries.
  • Worked with both Relational Universe's and OLAP Universe's and designed several WEB-I reports on top of these Universe's.
  • Involved in improving the Query performance created on the Multi Provider by publishing the query results to the OLAP cache.
  • Implemented requested changes/enhancements to BI content, such as WebIntelligence reports, Tableau, and Analysis for OLAP workspaces.
  • Created, published and scheduled reports as per requirement on BO OLAP analysis, Explorer and Webi.
  • Created Universe, pre-defined filters, Dimension Objects and Calculated measures in OLAP universe.
  • Created and maintained universes on OLAP (Online Transaction Analytical Processing) databases.
  • Created BEx queries, and reports using OLAP and BICS connection.
  • Improved query performance and data load using OLAP livecache.
  • Created OLAP Universes on SAP data (Infocubes / BEx queries) and Relational Universes on Non-SAP data.

Show More

48. RRI

demand arrow
low Demand
Here's how RRI is used in SAP BW Consultant jobs:
  • Shell is a global group of energy and petrochemicals companies with around 93,000 employees in more than 90 countries and territories.
  • Created RRI reports for drilling down from aggregated reporting on cube to line item detail report on DSO.
  • Prepared Data Sheets for complex BW reports by referring R/3 tables in IS-Oil and CSO areas.
  • Used RRI to jump between the queries for FI reports to display the corresponding accounting documents.
  • Used RRI (Report-Report Interface) in order to get detailed information about Sales orders.
  • Worked with RRI (Report to Report interface) between ODS object and InfoCube.
  • Created RRI so that the user can jump from one report to the other.
  • Reviewed all SAP MM reports and carried out modifications as per Clients requirements.
  • Developed Reporting jump targets using RRI (t-code RSBBS) to other reports.
  • In-charged of transferring all SAP scheduled jobs in Control-M and maintaining the jobs.
  • Used RRI feature to jump between the queries to analyze the data.
  • Worked on the fixes for the frequently occurring issues.
  • Used filters and other features like RRI.
  • Designed and provided RRI reporting.
  • Used DSO to stage the data before transferring the DSO contents to the Info cube.
  • Used RRI to jump between the queries.
  • Enhanced 0EMPLOYEE infoobject to add attribute fields such as Sales District, Sales Territory etc.
  • Collaborated with SAP team in a professional manner to fix a complex re-occurring issue.
  • Used RRI techniques for some of the CRM reports.
  • Project : Blocked Tarrif Environment SAP BI 7.0 Responsibilities: Extensively involved in developing generic extractors using function modules and BADIs.

Show More

49. APO

demand arrow
low Demand
Here's how APO is used in SAP BW Consultant jobs:
  • Target Corporation is a retailing company headquartered in Minneapolis, Minnesota.
  • Worked on BI 7 for GATP relevant reporting on APO and Prepared the Sizing document by using Quick Sizer tool.
  • Involved in development, integration testing, UAT to Go live production support of OTC, RTR, APO reports.
  • Support included for different Functional areas involved in SAP BW/BPC were APO - Demand Planning and Commitment Planning.
  • Worked with Basis and Security to configure the ECC 5.0 system and APO BI system.
  • Worked on integrating and supporting BI with APO in Demand Planning and Supply Network Planning.
  • Provided support for Weekly Demand Planning cycles with data loads in BW box of APO.
  • Designed the Data flow for extracting Sales and Shipment Data from R/3 to APO/BW.
  • Created and Maintained Integration models to transfer Data between ECC and APO.
  • Perform BI - CAM design development for CCSM (Singapore/Malaysia) bottlers.
  • Help project team in extracting data, interfacing BW with APO.
  • Loaded Demand Planning and ATP relevant data from I2/APO into BW.
  • Interfaced with APO- Demand Planning for Demand Supply forecast in APO.
  • Generated regular and customized DataSources from APO DP planning areas.
  • Have good understanding of the Function modules like CRM, FICO, COPA, PCA, APO, SD/MM.
  • Performed the data flow from BW to APO and from APO to BW to get the plan data.
  • Designed the functional specs for Installing BI content in the ECC 5.0 and the APO BI system.
  • Worked on the various functional modules like FI, HR, SD and APO.
  • Worked on different areas SD, MM, APO.
  • Created Real time infocubes in BI for APO reporting and help in planning process thereby avoiding the delay of data loads.

Show More

50. GL

demand arrow
low Demand
Here's how GL is used in SAP BW Consultant jobs:
  • Designed and Developed hierarchies to support local and global reporting of primary insurance.
  • Designed global structures to incorporate query requirements.
  • Created financial reports like Balance Sheet, Income Statement, Profit and Loss using COPA and FIGL - reports.
  • Acted as liaison between US regional development center and Global BW team for incident resolution, and project execution.
  • Developed various reports using the query designers from both BPS Supply Chain Planning and Global Manufacturing and Logistics.
  • Extracted A/R Line items data using 0FI_AR_4, and G/L totals data from the leading ledger using 0FI_GL_10.
  • Created single sign-on for many reports using the URL functionality to access them directly for upscale users.
  • Report was based on the FIGL Income statement, Balance sheet, Cash flow and Assets Management.
  • Configured Single Sign on for all the Business Objects 4.0 tools to SAP BW systems.
  • Handled Tickets for the Global Support Help Desk on Query execution and Performance issues.
  • Involved in production support for CCA, PCA, CO-PC, GL, FI-CO, AP, AR modules.
  • Extracted Line Item data from GL, AR and AP.
  • Project Description: Leyland is 4th largest manufacturer of buses in the world and the 16th largest manufacturer of trucks globally.
  • Updated some of the configuration and settings for enhanced functionality of GL, AR, AP, Cash, Bank.
  • Developed WBS hierarchy report upon 2nd levelhierarchy to analyze cost and revenue on one line single item.
  • Created new BO user logins and applied security restrictions accordingly for proper usage of the reporting system.
  • Configure single sign on functionality for opendoc to access reports and dashboards from third party applications.
  • Involved in training end users located all over globe in basic and advanced adhoc reporting.
  • Design pattern fa ade and singleton.
  • SAP BI 7.0 Implementation Responsibilities Developing new reports in FI-AR, FI-AP, FI-GL and SD based on the functional specs.

Show More

SAP BW Consultant Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A SAP BW Consultant

BEX

11.5%

Info Packages

10.8%

Data Warehouse

9.8%

BI

6.6%

Web Intelligence

6.5%

ECC

4.9%

SAP BW

4.5%

Business Requirements

4.5%

Process Chains

4.2%

SAP R/3

4.0%

Objects Universes

4.0%

DSO

3.8%

Master Data

3.5%

Business Content

3.4%

MM

3.3%

Dashboards

3.3%

Key Figures

3.1%

Abap/4

2.9%

Fi/Co

2.8%

Multi Providers

2.8%
Show More

Typical Skill-Sets Required For A SAP BW Consultant

Rank Skill
1 BEX 8.0%
2 Info Packages 7.6%
3 Data Warehouse 6.8%
4 BI 4.6%
5 Web Intelligence 4.5%
6 ECC 3.4%
7 SAP BW 3.2%
8 Business Requirements 3.1%
9 Process Chains 3.0%
10 SAP R/3 2.8%
11 Objects Universes 2.8%
12 DSO 2.7%
13 Master Data 2.5%
14 Business Content 2.4%
15 MM 2.3%
16 Dashboards 2.3%
17 Key Figures 2.2%
18 Abap/4 2.0%
19 Fi/Co 2.0%
20 Multi Providers 2.0%
21 ODS 1.8%
22 SAP BO 1.7%
23 Source Systems 1.6%
24 DTP 1.4%
25 Transaction Data 1.4%
26 Lo Cockpit 1.3%
27 Go-Live 1.3%
28 Update Rules 1.3%
29 SQL 1.1%
30 Workbooks 1.1%
31 Xcelsius 1.0%
32 Bobj 1.0%
33 WAD 1.0%
34 PSA 0.9%
35 HR 0.9%
36 User Acceptance 0.9%
37 CRM 0.9%
38 Technical Specifications 0.9%
39 Query Performance 0.8%
40 Data Targets 0.8%
41 ETL 0.8%
42 User Exits 0.8%
43 Hub 0.7%
44 Navigational Attributes 0.7%
45 PP 0.7%
46 Co-Pa 0.7%
47 Olap 0.6%
48 RRI 0.6%
49 APO 0.6%
50 GL 0.6%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

8,220 SAP BW Consultant Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.