We provide IT Staff Augmentation Services!

Sap Bi/hana Consultant Resume

SUMMARY

  • SAP HANA Certified Associate Consultant
  • SAP BW 7.4 Certified Associate Consultant
  • Worked on BW Technical and Functional migration from 3.x to 7.x and 7.x to 7.4 for the BI data model
  • Hands on experience & strong exposure with latest Modelling objects is required (Creation of Composite Providers, Open ODS Views etc.).
  • Worked on SAP BW roles migration project from 3.x to 7.x.
  • Worked on migrating the Transactional & Master data flows from 3.x to 7.x
  • Good understanding of design/optimization principles for BW on HANA
  • Worked on Database Migration for SAP BW Landscape from MSSQL to SAP HANA using Experience with HANA Cube/DSO optimization and trouble shooting
  • Experience in SAP HANA data modeling using Attribute View, Analytic View, and Calculation View etc...
  • Worked in SAP HANA Reporting using Web Intelligence
  • Experience in Configuring and Designing InfoCubes, ODS/DSO, DataSources, InfoSources, InfoObjects, Multi Provider, Transformation and DTP etc.
  • Extensive Experience in Analysis, Design, Development, Customization and Implementation of SAP BI and SAP BO
  • Extraction of data from SAP - R/3 using Generic-Extraction, LO COCKPIT Extraction, DataSource Enhancement etc
  • Installed Business Content for standard Info Objects, Info Sources, Info Cubes, DSO, Queries, Workbooks and Roles etc.
  • Worked on Information Broadcasting in BI for sending the reports to the Users through e-mails
  • Created Process Chains to Automate Data Load
  • Validate the reports in old version (BW 3.5) with the upgraded version (BW 7.0).
  • Good team player, Strong team orientation & leadership qualities, hardworking and enthusiastic.

PROFESSIONAL EXPERIENCE

Confidential

SAP BI/Hana Consultant

Responsibilities:

  • Experience in SAP BW on HANA.
  • Good understanding of design/optimization principles for BW on HANA
  • Strong Experience SAP HANA 1.0 and specifically SAP BW on HANA
  • Experience with HANA Cube/DSO optimization and trouble shooting
  • Created Technical specifications and standard modeling documents for HANA.
  • Extensively worked on SAP ECC as a source system for generating reports using BEx Query Designer.
  • Created customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization.
  • Build and enhanced BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO and Info Cubes
  • Worked extensively on generic extractor to achieve the business logic.
  • Maintained Process Chains to automate and schedule the data loads
  • Worked on transporting deliverables to quality and later on production system
  • Experience in SAP Analysis office.

Confidential

Lead - SAP HANA/BI/BO

Responsibilities:

  • Expert in understanding of the complete Architecture HANA (Data Loading, Data Modeling & Reporting)
  • Expert in Creation of Analytical and Attribute Views and complex models by using SQL Script in Calculation Views
  • Consuming the Hana models in BW through ODP
  • Created & Designed Universe for reporting from Information models
  • Experience handling integration between multiple systems for reporting - SAP ECC, SAP BW, BOBJ integration, etc.
  • Worked Loading data into table definitions, suspending data loads, resuming data loads.
  • Experience in SAP BO 4.0 using IDT (Information Design Tool), Web Intelligence
  • Experience in creating Restricted and calculated measures in HANA.
  • Experience in created measure using various aggregation types available like Min, Max, and Sum.
  • Created Variables and applied them as filters and also worked on various input parameters

Confidential

Associate Consultant

Responsibilities:

  • Installed Business Content for standard Info Objects, Info Cubes, DSO, Datasource, Multiprovider and Queries.
  • Involved in overall design, development, of custom InfoCubes, ODS, InfoSources/DataSources, Multi provider based on customer requirements.
  • Technical design and building BI Objects (Cubes, ODS object, Info Objects, Transformation, Data transfer process, Multi-providers etc
  • Involved in Transformation and DTP (Data Transfer Process) when creating Info cube and DSO in BI7.0
  • Extensively built queries on Info Cubes, ODS objects, Multi providers, using BEx tool
  • Enhancement of info objects, data source to accommodate additional attributes and required fields according to business requirement.
  • Worked basic Field routines: start routines, end routines.
  • Created Process chains for Master data and Transaction data loads to automate the data loading in the organization and these process chains were scheduled for periodic loads
  • Used Delta Update mechanisms for uploading the data / delta records to BW from R/3 in specific intervals
  • Worked Restricted (RKF), Calculated Key Figures (CKF), Variables, Conditions and Exceptions etc
  • Worked on Database Migration for SAP BW Landscape from MSSQL to SAP HANA using Greenfield approach
  • Worked on BW Technical migration from 7.x to 7.4 for the BI data model (in different application areas e.g. FI, CO, Funds Management, Treasury, SD etc.).

Hire Now