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.).