We provide IT Staff Augmentation Services!

Senior Sap Bw Hana Consultant Resume

SUMMARY

  • SAP BW/HANA Application Specialist with 12 years of experience and demonstrated proficiency in Architecting, Consulting, Performance Optimizing, and Solution Support with SAP Enterprise Data warehouse across several Global companies
  • Lead end - to-end complete life cycle implementations- from user requirement to deployment & hyper-care
  • Conducted several BW design workshops with business & project stakeholders, and technical teams
  • Architected the Enterprise Data Warehouse models
  • Lead Production Solution Support - Onshore/Offshore teams
  • Experience working in Agile and Waterfall methodologies in SDLC and BW Layered Scalable Architecture
  • Strong technical and functional experience in SAP BW with various projects spanning FI-CO/SCM/HCM functional areas across consumer products, chemical, hi-tech, manufacturing, and mining industry verticals
  • Extracting data from SAP and non-SAP systems into SAP-BW while designing ETL, data-model and reporting layer
  • Database analysis, and SAP BW/BI modelling areas (Info objects, Data Sources, DSO’s, Info cubes, Multi providers, APD’s, Open Hubs and Info spokes)
  • Expertise creating BW/4HANA objects Data Sources, ADSO’s, Open ODS Views, Composite Providers, Transformations, DTP’s, ABAP Routines, BW Query, Data Flows and End to End implementations using BWMT.
  • Created ABAP routines in BW modeling in Start Routines, End Routines, Expert Routines, Field level Routines, Programs and Function Modules to implement business rules
  • Expertise in creating Process chains. Integrated with IBM TWS Scheduling tool for batch data load monitoring
  • Created SAP HANA Design Developments, complex information models using Packages, Attribute Views, Analytic Views, and Calculation Views using graphical and SQL scripts
  • Follow best practice using LSA++ architecture with BW 7.5 on HANA and HANA Studio using Open ODS Views, Transient, Virtual, Advanced DSO’s, and Composite Providers. Data provisioning using ODP/ODQ into BW on HANA.
  • Working in SAP HANA Data Provisioning using SAP LT Replication Server (SLT) and SAP EIM (SDI/SDA) from SAP and Non SAP.
  • Written SQL scripts for Joins, Stored Procedures and Table Functions
  • Created HANA models for Sales, Sales Finance and supply chain business
  • SAP Business Objects 4.2/3.x (UDT, IDT Designer, Info view, CMC, Web Intelligence, Designer, Universe Builder, Import Wizard, Publishing Wizard, Life Cycle Manager, Promotion Management
  • Expertise in creating new universes and enhancing existing universes using Universe Design Tool (UDT) and Information Design Tool (IDT)
  • Create, Modify and improve performance of Web Intelligence Reports using underlined Universe or BEx queries
  • Support Business users on trouble shooting various production issues with Universes and Webi reports
  • Migration of BIAR files to Production Environments by performing Developments and Collecting Test Results
  • Knowledge on SAC concepts. Created Models and Stories using live data connections from BW4HANA System data
  • Created interactive reports, dashboards using various options which includes graphs, charts and table
  • Extract data from Non SAP sources and merged with BW4 data and created models and stories and published to users.
  • Experience in executing, leading production support projects in SLA model
  • Experience in building new SLA models and conducting strategic meetings with business partners
  • Expertise in resource planning, estimations and prioritization of pipeline enhancements

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP BW HANA Consultant

 

Environment: SAP BW on HANA 7.5, HDB 2.0, BOBJ 4.2, MS SQL Server and Power BI

 

Responsibilities:

  • Working with Business users and Business Analysts for business requirements and create technical specs and involved in end to end testing.
  • Created various Info Objects, Data Sources, DSO’s and Open Hubs in the BW on HANA system and enhancing the existing objects.
  • Created BW on HANA optimized objects like Info Objects, HANA Datasources, ADSO’s, Open ODS View, Composite Providers and BW Queries using BWMT
  • Connect with Non SAP Source systems (MS SQL Server’s) and extract data directly into SAP BW system using SDA (Smart Data Access).
  • Working with System administrators and co-ordinate with SAP for various system issues and new connections setup
  • Created Calculation views using BW info provider tables in order to address complex business requirements
  • Created Transformations using Start Routines, End Routines, Field Routines and Formulas to apply the business rules
  • Created DTP’s with filters and rotines, Process Chains for the data loads and schedule
  • Work with ControlM team for setting up new job for daily BATCH
  • Extraction of ECC table data into HANA tables using SLT mechanism (Load/Replicate/Suspend)
  • Creation of Technical Spec documents, Mapping Documents, Testing Documents and work with business users for UAT signoff
  • Work with Project Management, update status on daily and weekly and work in Agile/Scrum process
  • Creation of new views and enhancement of existing views in source system (MS SQL Server) as per the business requirements and understanding of existing architecture
  • Extraction of data from Non SAP systems and SAP system into BW and integrate the data using HANA Composite Provider
  • Created BOBJ universes in IDT using Bex queries and Relational tables. Created BOBJ Webi reports on BOBJ Universes and Bex queries for data reconciliations.
  • Created custom data sources and enhancing the existing SAP Data Sources and populated the data using CMOD ABAP routines.
  • Exposing the BW queries into Power BI visualization tool for creation of Dashboards. Working with the super users and help them to understand the BW queries and resolve any issues
  • HANA Calculation Views are created using Calculated Columns, Restricted Column, Input Parameters, Variables, Transparent Filters, Keep Flag.
  • Calculation Views created in Cube, Dimension and Star Join for each requirement and implemented various join types that available like Text Join, Referential, Inner, Left outer, Dynamic etc.

Confidential

Senior SAP BW HANA Technical Expert

Environment: SAP BW on HANA 7.4, HDB 1.0 and BOBJ 4.2

Responsibilities:

  • Working with Business users and Business Analysts for business requirements and create technical specs and involved in end to end testing.
  • Experience in working with ChaRM, SolMon tools for delivering solutions using Agile Sprint methodologies
  • Created various Info Objects, Data Sources, DSO’s and Open Hubs in the BW on HANA system and enhancing the existing objects.
  • Created BW on HANA objects ADSO’s, Open ODS View and Composite Providers using BWMT
  • Created Calculation views using BW info provider tables in order to address complex business requirements
  • Created Transformations using Start Routines, End Routines, Field Routines and Formulas to apply the business rules
  • Created DTP’s, Process Chains for the data loads and scheduled it for frequent data loading on Batch Mode
  • Extraction of ECC table data into HANA tables using SLT mechanism (Load/Replicate/Suspend)
  • Extraction of data from Non SAP systems and SAP system into BW and integrate the data using HANA Composite Provider
  • Write AMDP Procedures, HANA Analysis Process (HAP) and BADI’s for implementing complex business logics
  • Created BOBJ universes in IDT using Bex queries and Relational tables. Created BOBJ Webi reports on BOBJ Universes and Bex queries for data reconciliations.
  • Working with ETL (Informatica) teams for data outbound from BW system into Non SAP Systems.
  • Working extensively on Financial related data FI AR, FI AP, FI GL and FI Tax areas and Supply Chain area SAP Sales Distribution (Sales Orders, Billing and Delivery). Created custom data sources and enhancing the existing SAP Data Sources and populated the data using CMOD ABAP routines.
  • Created HANA Calculation Views on HANA tables and mixed data model scenario’s (BW info providers) and extracted data using BOBJ for the business reporting.
  • HANA Calculation Views are created using Calculated Columns, Restricted Column, Input Parameters, Variables, Transparent Filters, Keep Flag.
  • Calculation Views created in Cube, Dimension and Star Join for each requirement and implemented various join types that available like Text Join, Referential, Inner, Left outer, Dynamic etc.

Confidential, Glendale, CA

SAP BW, HANA, BOBJ Technical Lead Specialist

Environment: SAP BW 7.3/7.5, HANA 1.0 (SP12), SAP BOBJ 4.2

Responsibilities:

  • Created new data flows and enhanced existing in SAP BW environment by leveraging Data modeling concepts using LSA. Created Multi provider, Info Cube, DSO’s, Data Sources, Open Hubs and
  • Created ABAP routines for Start, End, Expert and Field for implementing business rules. Created Function Modules, programs, DTP customer filters using ABAP routines.
  • Created process chains for daily/weekly/monthly data load monitoring using Info Packages, DTP, Index and Rollup
  • Designed and Defined the Architecture for Sales overview using SAP Hana Live and SAP HANA External view from the composite provider
  • Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle DB into HANA
  • Created a Composite Providers to map all the SAP COPA sales and SD Sales Orders, Billing data
  • Created Technical specifications to outline the details for HANA modeling
  • Interacted with Business stake holders to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains
  • Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data
  • Created Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures
  • Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views
  • Created SQL scripts for procedures, functions and business rules.
  • Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
  • Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository
  • Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio
  • Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi, BO Analysis

Hire Now