We provide IT Staff Augmentation Services!

Sap Bw/hana Modeller Resume

SUMMARY

  • SAP HANA 1.0 Consultant with 3 year of experience in working on POC's, leveraging businesses to take competitive advantage with real - time reporting.
  • Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting); Knowledge on HADOOP with HANA SDA (Smart Data Access)
  • Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC; Received Data from Multiple modules-FICO,MM,SD
  • Experience with Data Extraction Transfer Loading (ETL) using SAP BO Data Services 4.0 for loading data from SAP ECC system and Files to SAP HANA.
  • Experience in Data Provisioning Technique Direct Extractor Connection- created Data Sources and transferring data to HANA Via SAP BW.
  • Created Infocubes, DSO, Transient, Virtual Providers and published HANA model in BW; Import BW model to HANA as Analytical Views.
  • Experience in Trigger-Based data Provisioning using SAP LT Replication Server (SLT).
  • Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio.
  • Configured the connection in LT replication server between SAP source system (ECC) and HANA;
  • Created data flows to extract data from POS DM to SAP APO and SAP BW for reporting purpose.
  • Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions as needed.
  • Experience in Configuring and Consuming SAP HANA models in BI clients such as SAP Business Object Explorer and MS Excel.
  • Implemented SAP COPA - HANA side car scenario, replicated COPA transaction and master data to HANA system through SLT, created attributed view, Analytical and calculation view for COPA and developed COPA reports.
  • Experience in creating Analytical Privileges;
  • Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, Web Intelligence, Business Explorer(BEx) and various reporting tools like Crystal Report Enterprise, Lumira.
  • Developed all relevant reports per user requirements including maintenance notifications, activity and malfunction reports.
  • Adoptive to learn new technological skills and demonstrates good time management skills.
  • Experience in Business Objects Reporting functionalities such as Aliases and Dice, Filters, Sorts, Graphs, Query Prompts and Breaks.
  • Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema.
  • Motivated self-starter with excellent communication, presentation and interpersonal skills, willing to travel 100% and work in challenging and cross-platform environments.
  • Team player with demonstrated collaborative working relationship.
  • Transported objects from DEV to QA catalog and content objects using delivery unit mode.
  • Good Communication, Inter personnel skills and Good team member.
  • Involved in the production support, and interacted with the Reporting developers to change the code of the Tables based on their reporting requirements.

TECHNICAL SKILLS

ERP: SAP ECC 6.0

EDW Tools: BW 7.4 SAP HANA 1.0 SPS 09, SPS 10

DBMS: Oracle, MS SQL, SAP HANA

Reporting tools: BEx, BO 4.x, WebI, IDT, Analysis for office, SAP Lumira, CRE

ETL: SAP BODS 4.2

Operating systems: Windows, SUSE Linux

Data Provisioning: SLT, BODS, DXC

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/HANA Modeller

Responsibilities:

  • Designing and creation of Attribute, Analytical, and Calculation Views(Graphical) using HANA Studio; Creates schemas, tables; Worked on different joins (left outer joins or referential joins; Inner Joins; Text Joins)
  • Worked on providing security restrictions on models using Analytic Privileges and assigning authorization roles to different types of users.
  • Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading; Data provisioned from multiple Modules like FICO, MM and SD.
  • Extracted SNP and DP data from SAP APO in to SAP BW and created reports combining inventory data and APO data. Developed Transformation Logic in both Start And End Routine.
  • Working experience on Data Migration from different data base systems to SAP HANA using SLT and DXC
  • Responsible for developing complex SAP Data Services(DS) Data flows/Workflows using different types of transforms like Query transform, Table compare transform, Case transform, Map operation, Merge, History preserve based on the business requirements.
  • Designed and implemented native HANA models in SAP HANA (SPS 11). Created Attribute, Analytical and Calculation views, Currency conversions, Procedures.
  • Had created Virtual, Transient Infoproviders and Composite providers in BW on top of HANA Model, created DB Connect to load data from HANA to DW.
  • OLAP Universe design using SAP BEx Query and Info Cubes. To access DS and InfoSet data, created BEx queries first and created Universe on top of the BEx Query. Accessed SAP InfoCubes, Transient Providers, Virtual Providers.
  • Design, Development, and implementation of BW Objects like Info Cubes, DSOs, Transformations and DTPs; Worked on Start/End/Field Routines
  • Promotion of HANA code to production using export/import of information models and delivery units. Involved in transports using Delivery Units; Transported Universe from one System to another system.
  • Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
  • Creation of local and secure connections and Universe in IDT; Created universe using IDT and report development in WebI.
  • Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, WebI, Business Explorer(BEx) and various reporting tools like Crystal Report Enterprise, Lumira.

Environment: SAP HANA 1.0 SPS 09, SPS10, BW 7.4, BODS 4.2

Confidential

SAP HANA/BW Consultant

Responsibilities:

  • Creation of schemas and managing schema mapping; Developed & designed Attribute views, Analytic views, and Calculation views; Export & Import of Packages.
  • Configured and Extracted data from SAP ECC, SAP CRM and SAP BW on HANA Data Base using SLT, BODS and DXC methods of Data provisioning.
  • Leveraged the simplified data model of SAP S4 HANA for faster execution of transactions and faster reporting.
  • Strong experience in building solution using Modelling tools SAP HANA, Native HANA and BW, creating HANA models using Graphical views
  • Experience with SAP BW 7.3 on HANA,SAP BW 7.4 on HANA migration.
  • Worked on extraction of data from Excel, External data base, SAP BW, SAP ECC, SAP Landscape Transformation (SLT) to HANA Data Base; Replicating Data from SAP and Non SAP using SAP SLT server and Advanced SLT server.
  • Created Infocubes, DSO, Transient, Virtual Providers and published HANA model in BW; Import BW model to HANA as Analytical Views; Worked on Start/End/Field Routines
  • Created HANA-optimized InfoCube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes; Used BW 7.4 Info Providers (Transient, Composite, Multi providers) for HANA models
  • Successfully adopted the change from their current legacy systems to the entering SAP S4 Hana system
  • Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Developed MS analysis Reports, Input Templates and Tableau Dashboard on HANA views.
  • Worked with different Data Quality Transform such as Data Cleanse and Match Transform; Used transforms like the Case, Merge, and Row-Generator.
  • Promotion of HANA code to production using export/import of information models and delivery units.
  • Experience in working with modules of Business Objects XI Enterprise suite like Information Design Tool, CMC, Web Intelligence, Business Explorer(BEx) and various reporting tools like Crystal Report Enterprise, Lumira.

Environment: SAP S4/HANA, SAP HANA 2.0 SPS 09, SPS10, BW 7.4, BODS 4.2, Tableau

Hire Now