We provide IT Staff Augmentation Services!

Sap Bw On Hana Migration Support Consultant Resume

2.00 Rating

Rockwell Collins, WA

SUMMARY:

  • Over 15 years of IT experience, which includes 10 years of extensive experience in SAP Business Information Warehousing (BW) Business Objects (BO), and in HANA.
  • Over 4 years of HANA Specific experience (updated knowledge up to HANA 1.0 SP10 ).
  • Around 4 years of Native Hana development experience.
  • Having a background of SQL and PL/SQL procedures development.
  • Work experience from major IT companies such as IGATE/ Patni Computers (now IGATE), Polaris and Accenture USA.
  • Experience with 4 full BI life cycle implementations using Accelerated SAP methodology Involving Planning, Blue Printing, Gap Analysis, Development, Testing, Reporting, Go Live and Post Go Live Support.
  • Domain knowledge experience in Finance, Materials management, Inventory Management, Sales Management. CRM.
  • Good knowledge is Functional areas such as Sales Process, Purchase Process, Inventory and Finance in SAP, Knowledge about various reports pertaining to the functional processes and their handshakes with other functional modules.
  • Experienced as Solution Architect for HANA Appliance implementations, provided guidance/recommendations to the Business Information Delivery team on methods to implement HANA, SLT, BW and Business Objects and Data Services.
  • Experience in 4 HANA development projects with expert knowledge of full software development life cycle and SAP HANA Live SLT data replication and BOBJ in the project phases such as business analysis, requirements gathering and functional and technical specification documentation, development, testing and delivery.
  • Expert level modeling experience in creating Attribute views, Analytical Views, Calculation views.
  • Implemented Hana best practices in information modeling and using stored procedures, sql scripts, and using CE functions appropriately.
  • Implemented DXC (direct extractor connections) to get Data from ECC from SAP Embedded business warehouse in SAP Business Suite.
  • In depth understanding of various HANA Engines such as Calculation Engine, OLAP Engine, Join Engine, Row store engine, Column Store, SQL optimizer.
  • Expert ability to troubleshoot issues and make system changes as needed to resolve issue.
  • Expert knowledge of SAP HANA Live, SLT and BOBJ Suite, SAP Limura, including the expertise to define the type of data storage offerings (in memory and disk) supported by the HANA and design solutions to meet requirements.
  • Good Hands on experience on SAP HANA Studio 1.0 Application Architecture.
  • Experience in designing Data Modeling at different levels in End - 2-End SAP HANA solutions
  • Well versed with importing meta data, table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA IMCE (In Memory Calculation Engine) studio
  • Extensive experience in HANA Modeling & development activities such as Creating Database Schema and Database Tables, Sequences and SQL Views, Authorizations, Data provisioning using SLT & BODS 4.0
  • Creating Attribute Views, Analytical views, Calculation Views, Analytic Privileges, SQL Script, SQL Script Procedure with select Statement, SQL Script Procedure with Calculation Engine (CE) Functions, SQL Script Procedure with Imperative Logic, SQL Script Debugger.
  • Development experience related to Exposing and Consuming Data, SAPUI5, Creating User Interfaces with SAPUI5, Creating complex O Data Services and calling it from user interface.
  • Development experience using Server-Side JavaScript (XSJS), creating an XSJS Service, Extending the XSJS Service, Calling the XSJS from the UI, Debugging XSJS, Life-cycle Management, SAP HANA UI Integration Services.
  • Worked on HANA Implementations for customers to help in leveraging business to take competitive advantage with real-time reporting.
  • Validating Information Models, Comparing Object Versions, Managing Modeling Content
  • Configuring Meta data Import, Configuring the Information Modeler, Creating Schemas,
  • Manage Schema Mapping, Creating Packages, Define packages strategyDesign the Information Models for HANA, Define and implement security and Analytic Privileges.
  • Consuming data from Hadoop datasources such as Hive.

SAP-BW EXPERTISE:

  • Experienced in Interaction with Users, Requirements Gathering, Creating Functional/Technical Specifications.
  • Proficient of various data design models - Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models.
  • Expertise in Data Modeling and Re-Modeling of Info Cubes, DSOs (Standard, Direct update and Write optimized), Info Objects, Info Areas, Info Sets, Virtual Providers and hybrid providers. Sound Knowledge of Multi Providers, Data Marts, Open Hub Services.
  • Experience in Info-Cube management with Aggregates, compression, Roll-up, Reconstruction, Indexes.
  • Proficient with planning, design implementation, trouble shooting and performance tuning support of SAP Business Information Warehouse.
  • Expertise in data extractions from Back-end Business Warehouse Component Extractors like LO-Cockpit, CO-PA, FI and Generic Extractors.
  • Excellent skills working with Flat File Extraction, BI Content Data Sources and extraction models including Full and Delta updates.
  • Proficient in creating Views, Data sources in SAP R/3 and replicating them to BW in the process to load Generic R/3 Data into SAP BW/BI
  • Experience in development with BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.
  • Comprehensive knowledge in Business Information warehouse design and development. Good working knowledge in Administrative workbench, Data Modeling, Data Extraction, Data Loading (Full/Delta upload).s
  • Expertise with BW reporting using BEx Analyzer, BEx Browser, Web Application Designer, and implementing BEx Queries, Calculated and Restricted Key figures, variables, workbooks, security roles and profiles.
  • Experience in Scheduling, Monitoring, Creating Info-Sources, Info-cubes, DSO objects, Multi-Providers, Info-Objects, Info-Sources, Update rules and Transfer Rules.
  • Extensive knowledge and experience in collection, activation and use of Business content.
  • Expertise in OLTP extractions from SAP R/3 using LO Cockpit, COPA, Generic Extractions and non-SAP systems. Resolving performance issues on queries with the help of BW Statistics cubes and queries.
  • Expertise in Generic Extraction with Functional Modules, Views & Tables.
  • Expertise in DB Connect Interface Extraction of Data from Oracle to SAP-BW and design the Remote Cubes
  • Transporting of Info-Provider data to Desktop computers and External systems using Open Hub Services.
  • Expert in Configuring Standard-Cubes, Multi Providers, and DSO object to upload the data from R/3 and flat files
  • Experienced in various update methods Direct Delta and Queued Delta
  • Extensive knowledge in job Process Chain, scheduling tools, event triggers and event chains.
  • Well versed in (BOBJ) Business Objects (BOXI 3.1 and BO 4.0) with experience in Central Management Console(CMC), Central Configuration Management (CCM).
  • Expertise in migrating from version XI R2 to XIR3, Business Objects Universes, Users, Report Objects, Personal Data Files
  • Fundamentally very strong at SQL, various types of joins, PL SQL.
  • Experienced in design and developing WEBI reports, Crystal reports, xcelsius dashboards.
  • Experienced in Universe designing using IDT and UDT tools.
  • Experienced in developing BO reports with BEX query as a source using BICS connection.
  • Experienced in Web based Central Management control, Life Cycle Management tool LCM and with upgrade management tools UCM.
  • Expertise in developing Crystal reports & Dashboard design.
  • Very well versed with BO 4.0 and BO 3.x
  • Experience in Designing, Sub-reporting, Olap, Adhoc queries, Drill down, Cross-tab reports.
  • Experienced in implementing reporting applications using Crystal Reports, Crystal Enterprise, Xcelsius, Business Objects Enterprise,SAPBusiness Explorer, Oracle SQL and PL/SQL

TECHNICAL EXPERTISE:

Data Warehousing tools: SAP BW 3.x /7.0/7.3/7.4

ERP: SAP ECC, MM, SD

Programing Languages: ABAP, SQL / PL SQL, HANA XS, JSON, Java.

Databases: Oracle, SAP HANA1.0 sp5/sp6/sp7

Reporting tools: Bex, SAP BO 3.x / BO 4.0.

ETL Tools: BODS 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Rockwell Collins, WA

SAP BW on HANA Migration Support Consultant

Responsibilities:

  • Reviewed the migration Cutover plan from BW stand point (preparation steps, post migration tasks, validation steps) and ensured that the necessary cutover steps were existing in order to ensure a smooth migration process.
  • Revisited the issues faced during the migrations done on their Sandbox and QA systems and provided recommendations.
  • Extended support to solve issues raised during migration and in validation by coordinating with BASIS and Security teams.
  • Provided recommendations on best suited transportation process for Hana objects.
  • Provided recommendations on design standards on BW Hana objects adhering to LSA++ architecture.
  • Provided recommendations on Hana Security model, package structure organization and on Dynamic tearing options with Hana optimized BW modeling objects.
  • Suggested to leverage PAL in BW using Hana Analysis process (HAP) for their Financial forecasting solution based on actuals loaded in BW.

Environment: SAP BW 7.4 on Oracle, SAP BW 7.4 SP 13 on HANA Unicode.

Confidential, WA

SAP HANA Solution Architect

Responsibilities:

  • Produced a comprehensive design for Hana schema and information modeling design.
  • Produced a predictive analysis schema to model airlines prognostic data.
  • Implemented Hana best practices in information modeling to use stored procedures, sql scripts.
  • Modeled COPA, Y2D, What If scenarios.
  • Modeled Accounts Payable, Accounts Receivables scenarios.
  • Modeled scenarios such as Vendor Open items, Invoices List and purchasing reports such as RFQ by Vendor, RFQ by material, Inventory cycle count reports to name a few.
  • Made use of Hana Live views for CRM and customized them according the reporting specific needs.
  • Developed several calculation views and sql script procedures for warehouse schema.
  • Developed several Analytic views and Attribute views, calculation views for warehouse schema.
  • Worked on complex SQL Queries to provide informational modeling through Script based calculation views and also using stored procedures using various joins such as inner join, left outer join, right outer join, full outer join, text join also used alias tables, sub queries on a need basis.
  • Avoided use of cursors adhering to best modeling practices in Hana.
  • Developed analytic privileges and dynamic analytic privileges for row level data access control.
  • Made use of Restricted, Calculated Measures, Variables and Input Parameters in Information model artifacts on need basis.
  • Worked on performance tuning - Performed Query Performance, Load Monitoring, Disk space monitoring.
  • Developed a partition strategy, worked on table partitioning and data tiring.
  • Developed Complex stored procedures to bulk load data from .csv files to Hana tables with capability to handle delta.
  • Implemented Fuzzy search on various fields.
  • Worked on SAP SLT configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables, to load, replicate and suspend
  • Worked on AWS Hana Instance, S3 and EC2 during the POC phase.
  • Designed and implemented the Hana application security - designed user roles and user provisioning, privileges, package privileges, analytic privileges.

Environment: SAP HANA SP 9, Hana Studio, SLT, ECC.

Confidential, Houston, Tx

SAP BW HANA Solution Architect

Responsibilities:

  • Worked in Full ASAP Implementation cycle involving Project preparation, Business Blue Print, Realization, Go-live for initial implementation on BW 7.1.
  • Determined the requirements based on workshops conducted with business users. Documented requirements keeping in view the source and target systems.
  • Prepared data mapping documents and technical specifications for data mapping .
  • Worked on BW Phase 2 data mart design and implemented Business content data source extractions for ISOIL for reporting requirements on operations and performance management of upstream.
  • Worked on FI Extractions and data flows, designed infocubes,DSOs and Multi providers to full fill reporting requirements.
  • Worked on COPA extraction.
  • Developed several master data Info objects with attributes.
  • Worked on Open hub destinations to enable external systems to pull data from BW models.
  • Worked on Various filtering techniques at PSA level.
  • Worked on various transformation objects like Start Routine,End Routine, Transformation rule group, Master data look up.
  • Developed expert routines to convert wide format source data and load it in long format in the target InfoCube.
  • Worked on Data explosion technique, developed End routines to return table type in the target InfoCube.
  • Converted Standard DSO to Hana Optimized DSO, converted standard InfoCubes into Hana Optimized InfoCubes.
  • Provided information modeling to create modeling artifacts such as Attribute views, Analytical Views, Calculation views.
  • Developed Restricted, Calculated Measures, Variables and Input Parameters .
  • Developed several calculation views with both Graphical calculation views and SQL script based calculation views .
  • Developed Analytic privileges and Dynamic analytic privileges in order to provide control on row level data access.
  • Created Store Procedures and to do complex calculations with inserts, updates and delta handling mechanism.
  • Leveraged my in depth understanding of various HANA Engines such as Calculation Engine,OLAP Engine, Join Engine,Row store engine, Column Store, SQL optimizer to implement the project.
  • Worked on standard stored procedures to load data with delta handling mechanism.
  • Worked in collaboration with Basis team on table partitioning to achieve load balancing and parallelization in HANA. Implemented partitioning methods such as Hash.
  • Worked on HANA User Access administration in collaboration with Security team to Create and modify roles, users.
  • Worked on HANA Live virtual models provided by SAP. Worked on extending the HANA Live query views to get the cater the business requirements.
  • Worked on HANA System Monitoring activities such as Query Performance,Load Monitoring,Disk space monitoring.
  • Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables.
  • Worked on Hana studio to load, replicate, stop replication suspend and resume tables in Server based table data provisioning screen.
  • Creating different types of jobs in SAP SLT like Real time job, schedule by interval, schedule by time. Managing the Replication Process Using the SAP HANA Studio.
  • Worked on SAP SLT complex table structure changes (change data type or length, add or delete key fields) the trigger and logging table have to be dropped and recreated. Also on HANA side dropped and recreated to ensure data consistency.
  • Created Data Services job to pull data from SQL and Oracle into HANA database.
  • Developed Data Services job to pull data from Flat & Excel files into HANA database.
  • Worked with BODS to load data from non SAP Source systems.
  • Used query, match, validate transforms and look up function for data integration purposes.
  • Collected functional requirements for reports and analytics for operations performance management for ISOIL.
  • Collected functional requirements for reporting purposes for FI module for
  • General Ledger reports - trail balance, general ledger list
  • Accounts Receivable reports - list of customers, customer wise sales, customer wise advances.
  • Accounts Payable reports - list of vendors, vendor wise purchases,vendor wise advances.
  • Worked on LO based extractions for SD and MM modules .
  • Analyzed available data provisioning options suited for the requirement.
  • Created Technical specifications and standard modeling documents for HANA.
  • Created Hana models such as Attribute views for master data, Analytical views for transactional data, Calculation views for reporting in Hana Studio.
  • Implemented best practices for HANA modeling, best practices for BOBJ Universe design SAP HANA.
  • Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
  • Migrated HANA content from development, testing environment to Production environment using delivery units.
  • Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, Web Intelligence reports and dashboards from HANA data sources.
  • Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Value management.
  • Analyzed the existing Database Application and designed a Prototype of Universe based on the Business Requirements
  • Designed and developed Universes by defining Joins, Cardinalities and applied contexts and aliases to remove dependencies.
  • Created reports for the users on a regular and ad-hoc basis using Business Objects and WebI, which were used by the managers to make key decisions.
  • Created reports using Business Objects functionality like slice and dice, drill down, cross tab, master detail tables and formula.
  • Created complex reports by linking data from multiple data providers, using free hand SQL, PL/SQL and functionalities like Combined Queries.
  • Involved in the Performance tuning of the reports both at the Universe level and the report level.
  • Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
  • Implemented Single Pass Report Bursting on Deski reports in the Infoview where this reports can be Scheduled and published to various BO users depending on the filters applied.
  • Worked with TOAD (running on Oracle 9i client) to cross check the data accuracy, validation and the Performance of the reports.
  • Created different types of reports like Master/Detail, Cross Tab and Charts (for trend analysis).
  • Formatted the reports as per business requirements and design.
  • Coordinated with users to determine existing issues and also involved in gathering new requirements.
  • Writing PL/SQL Scripts for some data marts
  • Migrated universes and reports across Development, Testing and Production Domains.

Environment: SAP Business Objects XI 3.1 Suite (Designer, Web Intelligence Rich Client, QaaWS, Import Wizard, Info View, CMC, Live Office), Business Objects XI 4.0, BEx Analyzer, BEx Web, Crystal Reports 2008,Xcelsius 2008, SAP Netweaver BW 7.3

Confidential, Tartran, MN

SAP BW HANA Senior Consultant

Responsibilities:

  • Analyzed available data provisioning options suited for the requirement.
  • Created Technical specifications and standard modeling documents for HANA.
  • Implemented DXC ( direct extractor connections ) to get Data from ECC from SAP Embedded business warehouse in SAP Business Suite.
  • Provided information modeling by developing modeling artifacts such as Attribute views,Analytical views, Calculation views.
  • Handled data filtering at lower level modeling layers and developed calculation views to handle application layer level calculations pushed to Hana IMDB to leverage the in memory capabilities.
  • Worked on standard stored procedures to load data with delta handling mechanism.
  • Worked on table partitioning to achieve load balancing and parallelization in HANA.
  • Implemented partitioning methods such as Hash, Round Robin, Range partitioning and multi level partitioning.
  • Worked on HANA User Access administration in collaboration with Security team to Create and modify roles, users.
  • Worked on XSJS Applications to create information models consumed by SAPUI5 tools, developed ODATA services, JSON scripts.
  • Converted BW info providers to HANA optimized info providers ( HANA optimised Info cubes / Hana optimized DSO ) by using the transaction RSMIGRHANADB.
  • Followed the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
  • Developed SQL script procedures to push down complex reporting logic to HANA database layer to utilize HANA processing capabilities.
  • Implemented information models from SAP Hana Analytics Foundation ( SHAF) or HANA Live.
  • Consumed information models in HANA Live for ECC FI and SD and MM modules using business objects tools such as BO explorer, Web Intelligence and Dashboards.
  • Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
  • Developed Analytical privileges and mapped the analytic privileges at reporting layer over the information models to control data access by various users across the organization.
  • Created Universes on top of HANA information models and developed the Webi reports, Info spaces in BO explorer.
  • Migrated HANA content from development, testing environment to Production environment using delivery units.
  • Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Value management.
  • Developed integration strategies to populate data into HANA from multiple legacy systems(SAP and non-SAP ) and recommended the appropriate tool to support this integration.
  • Designed and developed Universes by defining Joins, Cardinality and applied contexts and aliases to remove dependencies.
  • Created reports for the users on a regular and ad-hoc basis using Business Objects and WebI, which were used by the managers to make key decisions.
  • Created reports using Business Objects functionality like slice and dice, drill down, cross tab, master detail tables and formula.
  • Involved in the Performance tuning of the reports both at the Universe level and the report level.
  • Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
  • Implemented Single Pass Report Bursting on Deski reports in the Infoview where this reports can be scheduled and published to various BO users depending on the filters applied.
  • Created different types of reports like Master/Detail, Cross Tab and Charts (for trend analysis).
  • Formatted the reports as per business requirements and design.
  • Coordinated with users to determine existing issues and also involved in gathering new requirements. Writing PL/SQL Scripts for some data marts
  • Migrated universes and reports across Development, Testing and Production Domains.

Environment: SAP Business Objects XI 3.1 Suite (Designer, Web Intelligence Rich Client, QaaWS, Import Wizard, Info View, CMC, Live Office), BEx Analyzer, BEx Web, Crystal Reports 2008,Xcelsius 2008, SAP Netweaver BW 7.3. SAP HANA 1.0, SAP FI, SD.

Confidential, Wilmington, DE

SAP BOBJ BW Lead Consultant

Responsibilities:

  • Implementation project as per ASAP methodology - Project preparation, Business Blue Print, Realization, Go-live.
  • Conducted workshops with users to gather requirements and to understand the work flow of the as-is system, analyzed work flow to design To-be solutions, documented the findings, assessed scope of studies.
  • Created Project Plan for scheduling based on Business requirement. Preparation of the technical specification by understanding business functionality from the functional specifications, according to the client's requirement.
  • Implementation project as per ASAP methodology - Project preparation, Business Blue Print, Realization, Go-live.
  • Understand and document the requirements based on the source and target systems and also created data mapping documents and Developed Specifications data mapping and Unit Test Plans for each of the Conversion Processes.
  • Responsible for design, development and extraction of data from ECC source system into BI from SD and MM using LO cockpit extraction methods.
  • Created Info Objects for the reporting areas, which includes building all structures within BI.
  • Created transfer structure, communication structure, transfer rules and update rules.
  • Installed Business Content and activated SAP delivered standard InfoCubes .
  • Customized Business contents info InfoCubes and activated business contents to meet business requirements
  • Involved in Design, Development and Enhancements of InfoCubes, DSO Objects .
  • Managed and monitored data loads with full update and delta mechanism and optimized the performance by adjusting pocket size and data selections.
  • Designed and developed classical info sets in ECC and built Info Set queries.
  • Developed process chains to load the data.
  • Actively involved in Transports, Troubleshooting and Data Validation.
  • Worked with Basis team to resolve the performance related issues such as recreating the indexes on the database tables.
  • Involved in deploying role based reports in various environments such as (but not limited to) Portal, BEx Browser.
  • Monitored and supported day to day production activity,handled report data issues and monitored daily data load scheduled through process chain.
  • Creation of Attribute views, Analytic views and Calculation Views based on replication data using HANA modeler.
  • Worked on Restricted, Calculated Measures, Variables and Input Parameters in Analytic views. Created Store Procedure using SQLScript.
  • Creation of Analytic privilege to apply restrictions on the Information views.
  • Restricted access to data by assigning relevant roles to users based on user profile. Created Information spaces in explorer based on HANA Information views.
  • Worked on SAP SLT Configuration and Monitoring Dashboard to create schema, monitor tables, monitor connections, monitor statistics of tables.
  • Worked on Hana studio to load, replicate, stop replication suspend and resume tables in Server based table data provisioning screen.
  • Creating different types of jobs in SAP SLT like Real time job, schedule by interval, schedule by time. Managing the Replication Process Using the SAP HANA Studio.
  • Worked on SAP SLT complex table structure changes (change data type or length, add or delete key fields) the trigger and logging table have to be dropped and recreated. Also on HANA side dropped and recreated to ensure data consistency.
  • Involved developing Universes to consume HANA information models, provided technical suggestions helping to decide to develop universes over information models or on HANA tables.
  • Used shortcut joins, contexts, aliases etc to resolve join path problems and achieve reporting requirements.
  • Created reports using WebI and Crystal Reports like Product Performance Selection, Suppliers Report, Line of Business (LOB) Reports, Supply Chain Performance and Menu Reports etc.
  • Implemented Aggregate Awareness and Index Awareness in universes.
  • Generated complex reports using Crystal Reports functionality such as parameters, formula workshop, and alerts.
  • Used the advantages of Experts in Crystal Reports for Grouping, Sections, Selection and Sorting.
  • Included in reports advance features such as sub-reports, cross-tabs, charts, and hierarchical structures.
  • Built the Sales and Marketing dashboards utilizing the QaaWS and Live Office connections in Xcelsius 2008.
  • Designed and developed the Excel models using best practices to serve as base for building the Xcelsius dashboards.
  • Utilized LCM (Life Cycle Management) tool for promoting/migrating the corporate dashboards including
  • Xcelsius (flash) files, QaaWS, Web Intelligence reports and Universes from development to production environment.
  • Set up groups and users for Business Objects deployment and managed user profiles. (BO Administration)
  • Performance Tuning of long running queries and came up with recommendations with fine tuning the report queries, universe and suggested database modifications. Created advanced Universe objects with Oracle SQL hints to improve performance of long-running reports..
  • Troubleshoot existing reports to eliminate data discrepancies and respond to end-user inquiries.
  • Generated various numbers of reports on a daily, weekly and monthly basis.

Environment: SAP BW 7.3 SP5, HANA 1.0, ECC 6.0, Business Objects 3.X,BEx, MS Excel, MM and SD.

Confidential, WI

SAP BW/BOBJ Consultant

Responsibilities:

  • Involved in Design & Development of BW Objects which Includes Building of DSO Objects, Info Providers, Multi providers etc. to facilitate the reporting for Sales & Transportation areas.
  • Developed DSO for Miller-Coors Inventory History which will provide analytical reporting on the movement and Inventory of materials with in all plants, ware houses & Shipping locations for Miller-Coors .
  • Developed Sales item Overview DSO to accept multiple s.
  • Designed Sales multi cube over the Sales, Delivery and Billing cubes to provide visibility of data across the sales cycle in the same query
  • Activated Standard Business Content and loaded large volumes of production data into InfoCubes pertaining to SD & MM. Design, used expert knowledge of data warehousing concepts, InfoCube data design and reporting.
  • Mapping R/3 fields to BW Info objects in transfer structure during the creation of transfer rules.
  • Used SAP BW functionality like LO Extraction, developed custom BW cubes for specific user requirements that could not be met by using Standard Business Content.
  • Developed SAP BW Objects applying extended star schema modeling principles in Data Exploited all the advantages of LO Cockpit. (Delta, adding custom fields to LIS Comm. Structure.
  • Used Calculated Key figures, Restricted Key figures, conditions, Variables and Variable Offsets for customizing the reports according to the requirement.
  • Data extraction from SAP R/3 system and Flat file.
  • Involved in Performance Tuning and Unit Testing.
  • Created Process chains for Master data and Transaction data loads to automate the data loading in the organization and these process chains are scheduled for periodic loads.
  • Used ODS to stage the extracted data before loading into the Info cube
  • Created Queries and present the result in workbooks by defining rows, columns and Free Characteristics providing Drill-Downs and other features in BEx.
  • Worked with the exceptions, conditions, filters, restricted characteristics, free characteristics, calculated key figures in BEx
  • Performance tuning of queries using aggregates, indexing of Infocubes
  • Creation of different types of BO reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
  • Use of Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).

Environment: SAP BW 7.0, SAP BO XI 3.0, ECC6

We'd love your feedback!