Sap Bi/hana Consultant Resume
4.00/5 (Submit Your Rating)
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.).