We provide IT Staff Augmentation Services!

Sap Bw4hana/hana Lead Consultant Resume

3.50/5 (Submit Your Rating)

SUMMARY

  • Experienced SAP (BW4HANA, HANA) with more than 16 years of project experience.
  • Experience includes multiple SAP BW on SAP HANA database and BWHANA mixed modelling dashboard development
  • Hands on experience with Theobald Software, Infobright, Tableau Desktop, Microsoft PowerBI, Sap Lumira.
  • Experience in working with SAP BOBJ, SQL Server (SSMC), SSIS, SSRS, and SAP HANA
  • Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.
  • Experience with ASAP Methodology - Project requirement, Business blueprints, Realization, Final preparation, Go live and support.
  • Experience with Agile methodology.
  • Hands-on experience in analysis, architecture, implementation, migrations, upgrades, and production support of end-to-end SAP Business Intelligence environments including front-end BI (Business Objects), back-end (BW and HANA DB), Web Intelligence (WebI), Analysis for Office and Dashboards, Design Studio, and HANA DB connector.
  • Deployment of Business Objects solutions for corporate reporting using Webi Reports
  • Designed and implemented SAP BW, SAP BW on Native HANA and standalone SAP HANA data models using ADSO, ODP/ODQ, Open ODS View, and Composite Providers, SDI, SDA, CDS Views and AMDP Scripts.
  • Good Knowledge SAP Native HANA. Experience HANA data modeling using Attribute View, Analytical view and Calculation view Experience in SAP HANA Data Provisioning using SAP LT Replication Server (SLT) and Data services Knowledge.
  • Extractions - Extracted data from Integrated Planning, COPA, FICO, LO Logistics Cockpit and Generic Data Sources from Views.
  • Customizations - Datasource Enhancements, User Exit Variables, BADI’s, Start Routines and Formula Builder.
  • BEx Reporting- Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
  • Process Chains of Events, Data source Enhancement, OLTP extraction data, loading (Full /Delta Up-Load), Performance Tuning, Aggregates, and BW Transports.
  • Production Support: Extensive experience in support, Data loads, Validation and troubleshooting of transaction data and Master data, Change management, Transport Management, Roles & Security.

TECHNICAL SKILLS

Data Warehouse: SAP BW4/HANA, SAP Business Warehouse BW 3.x-7.5, SAP HANA 2.0 Native

ERP Module: SAP S/4 HANA, SAP ECC, SAP R/3 4.7, REfx, Procurement- MM, SRM, FI, AM, Retail, PP, SD & HR

ETL tools: HANA Cloud Integrator Data Service (HCI-DS), SAP BODS, SAP BPC

Emerging Solutions: SAP Cloud for Analytics solution -Digital Boardroom & Planning, Internet of Things (IoT) integration, SAP Public Cloud Offerings, Salesforce

User Experience: SAP FIORI Apps, Smart Business Apps

Reporting Tools: SAP Query Designer, BW Query, BEx, Web Reporting, Business Objects (Webi)

PROFESSIONAL EXPERIENCE

Confidential

SAP BW4HANA/Hana Lead Consultant

Responsibilities:

  • Documented and performed pre-migration activities on BW 7.4 on DB2 to BW 7.5 on HANA and on to the subsequent migration to BW/4HANA.
  • Created Data Sources using CDS views and replicated to bw4hana.
  • Replicated Data Sources from ODP/ODQ Source system
  • Implemented AMDP Routines in BW4HANA environment.
  • Created BW flows in BW4HANA using Data Flows.
  • Business Objects - Configuring front end application for planning in BOBJ Analysis for MS Office.
  • Architected Gross Margin planning applications for Budget, Forecast and Strategic Forecast (Sales and Cost of Sales) using Integrated Planning of Business Warehouse. Planning application user interface was built in Business Objects using Microsoft office for Analysis.
  • Created Sales Manager Dashboard, Daily Margin Dashboard, Service center Dashboard, Account manager Dashboard.
  • Built Generic Data Sources to load the data from the flat file.
  • Created user and assigned roles to groups.
  • Created web-based URL iView’s and iView’s for sap applications.
  • Created Work set, role and assigned role to the user.
  • Enabling single sign-on.
  • Created iView’s based on Bex report and BO reports and published in the portal.
  • Created Test roles and Training roles assigned the dashboards to the respective role.
  • Bex Broadcasting.
  • Validated the data in Dashboard.
  • Created open hub to create a flat file for NAED to send it to the business.
  • Worked on report changes as per the business needs.
  • Enhanced data sources to bring the goal data to dashboards.
  • Created 0profit ctr Hier and 0sales off Hier utilized instead off service center.
  • Pulled Purchased order data with Pricing Condition to BW.
  • Created the financial sets for 0gl account and replicated the changes in the dashboard.

Environment: SAP BW4HANA, SAP NetWeaver BW7.3, SAP ECC 6.0.

Confidential, Santa Clara, CA

HANA consultant

Responsibilities:

.

  • Building a LSA ++ architectural solution for future state self-service reporting models on BW 4/ HANA & SAP S/4 HANA
  • Enabling the power of embedded analytics (CDS Views/Queries) and consumption of the models via frontend FIORI, Lumira 2.0, Analysis for office, Tableau & Power BI.
  • Integrating Salesforce system with S/4 HANA for performing integrative analytics.
  • Working closely with C level executives to capture key KPI’s and developing and configuring executive level KPI’s for multiple modules of S/4 HANA and expose them via FIORI KPI modeller, Analysis for office (or) Lumira for Self-Service reporting, and other embedded analytical queries.
  • Working across multiple functional modules like ReFx, custom built Feasibility solutions, HCM (Success factors), FI, PPM/PS, Ariba & Salesforce building reporting solution using CDS Views, Mixed HANA scenarios & BW4 HANA as data warehouse.

Confidential

ABAP Technical Analyst

Responsibilities:

  • Configured Workflows to initiate manually when Materials are to be updated.
  • Worked on Reporting on Workflow Progress, Performance, and Work items by Processing Duration.
  • Worked on Reporting on Agent behavior.
  • Configured RFC Destination and debugged RFC connections for Workflow to Connect WM and MM.
  • Developed user exit to save the Purchase Order (ME21N) to check and make the changes if necessary, to header text entered by user (while creating the PO).

Environment: SAP 4.6B, ABAP/4, SD, MM and PP Modules, Oracle.

Confidential

SAP Technical Consultant

Responsibilities:

  • Understanding the functional specifications and preparing the Technical Specifications.
  • Developed classical and interactive reports using ALV’s.
  • Developed BDC program for the Customer Master, Material Master and Vendor Master.
  • Developed BDC program to change Vendor details using XK02.

Environment: SAP 4.6B, ABAP/4, SD, MM and PP Modules, Oracle.

We'd love your feedback!