We provide IT Staff Augmentation Services!

Sap Bw/abap/native Hana Developer Resume

5.00/5 (Submit Your Rating)

Cincinnati, OH

SUMMARY

  • Over 8+ years of experience in all the phases of Software Development Life Cycle (SDLC) such as requirements gathering, analysis, designing, development, testing and reporting using SAP Business Intelligence (BI)/Data warehousing (BW), SAP HANA, and SAP Business Objects.
  • SAP Certified having 7 years of experience in SAP BI/BW on HANA/ABAP/Native HANA involved in different types of project executions which include implementations and Support projects.
  • Over 5 years of experience in SAP HANA Modeling, Data Provisioning & Reporting.
  • Strong understanding of Data Warehouse Concepts, ETL, OLTP, OLAP, Star Schema, KPI’s, FACT & Dimensions tables, Conceptual, Physical & Logical Data Modeling.
  • Experience in 3 complete life cycles implementations of SAP BW/BI. Knowledge of BW4HANA. Worked on Blue Printing, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up - loads), Scheduling, Monitoring, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation.
  • Expertise in designing and building SAP-BW/BI Components Info Objects, Info object Catalogs, Info Cubes (HANA Optimized, BW Star Schema), Data Store Objects (DSO), Advanced Data Store Objects (ADSO), Open ODS Views, Composite Provider, Info Sets, Hybrid Provider, Multi Providers, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Process Chains, Transformations ( Update and Transfer rules), Data Transfer Process (DTP), Open Hub Service.
  • Used Business Content extensively, loaded data using (BC) Technical Content. Extracted data from ECC, LO Cockpit Extraction, Generic Extraction (View, FM, Info set Query), Flat file Extraction for Master data and Transactional data and Activating Data structure, transporting data sources, customizing and enhancing the existing data sources to meet the business requirements.
  • Creating Aggregates, Cube partitioning, Creating Line-Item dimensions, Cube compression.
  • Extensive experience in support, Data loads, Validation and troubleshooting of transaction data and Master data, Transport Management, process chains, Full/Delta loads, Scheduling and Monitoring, exporting data using Open HUB Destination.
  • Created Calculated KF’s, Restricted KF’s, Exceptions, RRI (Report to Report Interface), Conditions, Formula Variables & Customer Exit Variables in Query Designer, BEx Analyzer.
  • User Exit Functions, ABAP enhancements in ECC Generic Extractions, BI data modeling like Start Routines and End Routines and Customer Exit Variables.
  • Experience in Business Objects 4.2/4.0/XI 3.1 with Universe Design Tool (UDT), Information Design Tool (IDT), Web Intelligence (WeBI), SAP Lumira.
  • Expertise in working with BEx Analyzer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
  • Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Experience with working on mixed scenarios using both HANA as data mart + BW on HANA and Knowledge on S/4 HANA (CDS Views).
  • Experience in developing data models in SAP HANA SPS12 created Calculation views,
  • Experience in Data Provisioning Using Trigger-based replication (SAP Landscape Transformation (LT) Replication Server), SAP HANA Direct Extractor Connection (DXC) and ETL-based replication (SAP DATA Services - BODS).
  • Harmonized new ECC data into existing global platform using HANA side car approach.
  • Extensively worked in creating Calculations Views of type dimension based on Master Data, Calculation View based on combination of ECC tables for satisfying the business reporting requirement.
  • Worked extensively on SQL Scripts (Table Functions, Stored Procedures)
  • Experience in data provisioning using SDA to HANA from a Non-SAP Sources like Microsoft Server Environment.
  • Experience in performance tuning of Calculation views by utilizing the SAP Best practices.
  • Developed WeBI reports, Analysis for office reports and dashboards using Lumira (Discovery).
  • Responsible for Design/ Build/ Testing/ Deployment.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2000/WIN XP

Languages: ABAP/4, SQL/PLSQL

GUIS: SAP GUI

ERP: BI7.0/7.4/7.5,SAP R/3, ECC 6.0, S4HANA

Database: HANA, Oracle 8i/9i, SQL Server 2005/2008

Reporting tools: BEX, WEBI, Advance Analysis for Excel, Lumira 2.0

ETL Tool: BODS, SLT

Microsoft Office: MS-Words and MS-Excel

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

SAP BW/ABAP/Native HANA Developer

Responsibilities:

  • Created ADSO, Composite Provider and Open ODS as per Requirement.
  • Created Info package, transformation and DTP between source and target.
  • Worked on designing SAP BW data flows (DSO s, Info cubes, MultiProviders, Composite Providers, Transformation and DTP).
  • Developed queries utilizing BEx Query designer.
  • Monitoring the existing process chains for all the flows and resolving the issues as per the priority.
  • Involved in replicating data for real time reporting into SAP HANA from ECC 6.0 using SLT.
  • Create/Develop HANA Models using SAP HANA Studio SPS 12, which includes calculation views (graphical, scripted), Table Functions, Procedures following best practices for data model's optimization and performance tuning.
  • Involved in creation of Error DTP.
  • Maintained routines like start, field, and end routines for required objects.
  • Created reports on BEX Query Designer using filter, variable, formula, selection.
  • Involved in unit test and integration test.
  • Created Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
  • Data Source Enhancement according to customer requirement.
  • Based on Client Requirement identifying the Data Sources, ADSO and Info cubes required for meeting their reports.
  • Extracted (Master and Transactional data) from SAP R/3 i.e., SD, FI and Loading extracted data into Data Targets.
  • Loaded data from SAP R/3 to BW and used initialization with delta update and full update methods.
  • Recognize the right data source as per the requirements, find out the target object in BI and install all the required objects.
  • Involved in frequent client meetings to discuss project status.

Environment: SAP BI 7.5,BW on Hana, ECC 6.0, SAP ABAP

Confidential, St. Louis, MO

SAP BW/ABAP/Native HANA Developer

Responsibilities:

  • Worked on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and MultiProviders.
  • Set up periodic Data loads from legacy system (flat files).
  • Architecting and designing solutions using SAP BW, SAP native HANA, BW on HANA, SAP Landscape Transformation (SLT), Business Objects, Tableau and Business objects data services (BODS) in the functional areas of SAP Sales and Distribution (SD), Material management (MM), Finance and Costing (FICO).
  • Development of Data Store Objects, Info Cubes, Multi-providers, Info sets, Complex transformation routines using ABAP/4 language, Open hub’s, Process Chains, DTP’s, and Transformations using SAP BW.
  • Development of Calculation views, stored procedures, Analytic Privileges, column tables and security roles for restricting user data access using SAP HANA.
  • Development of Open ODS, Composite Provider, Advanced DSO’ and HANA Optimized info cubes using BW on HANA and Native HANA.
  • Manage project applications for SAP BW and Native HANA, change and bug fix releases.
  • Worked on BEX Query Designer using filter, variable, formula, selection.
  • Monitoring of Info packages and analyzing the reasons for failures of Info packages.
  • Monitoring the process chains.
  • Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
  • Monitored Data loading, analyzed failed data packets and if possible, manually edited in PSA and reloaded to DSO.
  • Created ODS, InfoCube, Multi-providers and Infosets and extracted SD data (Data sources Like 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL) of SAP R3 into SAP BW using LO Cockpit (LBWE) extraction. Extensively worked for Sales Order Review.
  • Monitored loads for SD module from R/3 source system.
  • Maintaining Work History for all the tickets until it is closed.
  • Handling of Change Requests with enhancement requirements, involved in creation of Technical Specifications documents for the same.
  • Scheduled data loads to BW from SAP R/3, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.
  • Worked in BW related ABAP, Knowledge in BADIs and OOPs Concepts, Transformation routines, Data source Enhancement Code, Utilization of Internal tables, Field symbols
  • Involved in performance issues like aggregate, compression, and index.
  • Worked extensively on query designer.

Environment: SAP BI 7.5, ECC 6.0, SAP ABAP

Confidential, Santa Clara, CA

SAP BW/ABAP/Native HANA Developer

Responsibilities:

  • Created Stored Procedures, Attribute Views, Analytical Views and Calculation Views.
  • Good hands-on experience in creating Calculation View of SQL Script.
  • Expertise & Exceptional Skills with SAP HANA Modelling
  • Design and implement SAP HANA information models using Attribute Views, Analytic Views, Calculation Views, Stored Procedures, CE Functions and SQL script, carry out currency and UOM conversions.
  • Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables and input parameters to satisfy reporting requirements using SAP HANA Studio.
  • Created Analytic privileges based on dates and other complex filters using stored procedures as part of HANA security.
  • Created calculated columns, restricted columns, input parameters, variables.
  • Deep knowledge and experience of writing complex SQL Scripts, Procedures
  • Good Understanding on the Standard HANA Content
  • Involved in design and development of Advanced DSOs and Composite providers.
  • Involved in creation of Transformations and Data transfer process to load data from PSA to data targets.
  • Optimized the information views using explain and visualize plan to reduce the time taken for reporting.
  • Used SLT replication server to load real-time data form ECC to HANA.
  • Loaded data from SQL server data base into HANA using SLT and BODS.
  • Ability to understand Business Scenarios and translate it into data models with business logic (Translate the Business KPIs into HANA)
  • Created BW Reports in Query Designer, MP, Cubes, ADSO, Info source and Info objects.
  • Worked in WEBI for creating Reports.

Environment: Native HANA, BW, ABAP, SAP BO

Confidential, Dayton, OH

SAP BW/ ABAP/HANA Consultant

Responsibilities:

  • Developed and enhanced BW BI Content extractors, Generic Datasources, PSA, DTP, InfoObjects, DSO, InfoCubes, process chains which were used for Bex reporting.
  • Responsible for monitoring and troubleshooting of SAP HANA.
  • Worked on transport Management Systems, Importing Change requests.
  • Extensively worked on data extraction from SAP R/3 using Generic extraction.
  • Extensively worked on data extraction from Flat File.
  • Created multiple data layers merging Flat file and SAP data as per business rules
  • Implemented BW Formulas, Field routines as per the logic of functional spec.
  • Monitoring Data load activities and recovered failures.
  • Worked on Enhancements (Data source enhancements and reporting).
  • Created Attribute views, Analytical Views, Calculation views in HANA for POC.

Environment: SAP ECC 6.0, BW, ABAP, Native HANA.

We'd love your feedback!