We provide IT Staff Augmentation Services!

Sap Bw/hana Modeller Resume

Houston, TX

PROFESSIONAL SUMMARY:

  • Certified SAP HANA Consultant with 5 years 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); Working Knowledge on SDI (Smart Data Integration)
  • Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC; Received Data from Multiple modules-FICO,MM,SD
  • Worked on extracting data from SAP ECC, SAP CRM, MS SQL Server and SAP APO to BW and then also worked on improving reporting performance.
  • Experience in Data Provisioning Technique Direct Extractor Connection- created Data Sources and transferring data models 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).
  • Experienced in designing and implementing different types of data flows in BODS which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc.
  • Extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality.
  • Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods
  • Experience in Configuring and Consuming SAP HANA models in BI clients such as SAP Business Object Explorer and MS Excel.
  • Worked with multiple teams like Informatics, R/3, APO to solve various issues in BW.
  • 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.
  • Develop extract processes from BW using BODS (ETL tool)
  • Worked on DSO's, Transformations & DTP in BI 7.3
  • Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, Update rules, Extractors, Info packages, Info object Catalogs, Data sources, Data Extraction, Business Content and Process Chains.
  • Transferred data using HANA Cloud Integration(HCI)-Data Services(DS) to HANA Cloud Platform using Web Services
  • Transferred data from different modules like ECC, Flat file using HANA Cloud Integration(HCI)-Data Services(DS) to HANA Cloud Platform.
  • Transferred objects from Sandbox to Production in HANA Cloud Ingration(HCI)
  • 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.
  • 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.
  • Certifications:
  • SAP Certified Application Associate - SAP HANA (C HANAIMP151)

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, TOAD

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, Houston, Tx

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)
  • Created Batch jobs using BODS ETL Tool to extract SAP and Non- SAP Data.
  • 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.
  • 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.
  • 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.
  • Designing the Data flow for extracting Sales and Shipment Data from R/3 to APO/BW.
  • Good understanding of functional process for APO/BI BW reporting.
  • Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, Update rules, Extractors, Info packages, Info object Catalogs, Data sources, Data Extraction, Business Content and Process Chains.
  • Experienced in designing and implementing different types of data flows in BODS which includes Case, Merge, Validation, Map Operation, Data Transfer, Row Generation, Table Comparison transforms etc.
  • Transferred data using HANA Cloud Platform(HCP)-Data Services(DS) to HANA Cloud Platform using Web Services
  • Transferred data from different modules like ECC, Flat file using HANA Cloud Integration(HCI)-Data Services(DS) to HANA Cloud Platform.
  • 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, SQL, TOAD

Confidential, Albany

Teaching Assistant

Responsibilities:

  • Worked under Prof. Zheleva at SUNY, Albany.
  • Gave presentations related to WireShark Tool.
  • Evaluated Papers and graded students
  • Analyzed network congestion and formula for calculating the congestion over a network

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.
  • Strong experience in building solution using Modelling tools SAP HANA, Native HANA and BW, creating HANA models using Graphical views
  • Created Batch jobs using BODS ETL Tool to extract SAP and Non- SAP Data.
  • 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
  • Develop extract processes from BW using BODS (ETL tool)
  • Worked on DSO's, Transformations & DTP in BI 7.3
  • Extensively worked in Business Information Warehouse Info Cubes, DSOs, Info sources, Info objects, Transfer rules, Update rules, Extractors, Info packages, Info object Catalogs, Data sources, Data Extraction, Business Content and Process Chains.
  • Developed MS analysis Reports, Input Templates and Tableau Dashboard on HANA views.

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

Hire Now