Certified SAP BW/HANA Senior Consultant

* Master data maintenance for stores and shopping center
* Development and maintenance of sap Hana views for performance
* Report development and maintenance in sap bex query designer
* Report designing and maintenance in sap bo design studio
* Data backup and master data maintenance based on user list of shopping center
* Custom mail/alert on the progress of the process chain
* Objects involved in developments: direct update dso, write optimized dso, composite provider,
SAP Hana views, real time infocube.
Technical environment: SAP HANA 1 sps12, SAP BW 7.4, BEX, Design Studio, BI-IP

* HANA and Business Objects Development done across SD, MM, PP, QM, FI the business Areas for
the BI Projects.
* Developed all Technical Specifications based on Functional Specifications that outlines required
Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA
design to meet and satisfy the Business Reporting Requirements.
* Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for
Transaction Data and Calculation Views Graphical to Join/Union the various Attribute and Analytic
Views for report consumption with time dimensions. Calculation views constitute 80% of the
development in SAP HANA.
* Developed data flows and workflow using standard SAP BW data sources for ap data upload and
delta management and custom and flat file data sources for non-sap data upload and delta
management.
* Mixed modeling scenarios: Sap BW data mart in join/union with Sap HANA views in composite
provider.
* BEX queries on top of the composite provider.
* Worked with LCM Life Cycle Management Console (solution manager) to Transport the Objects In
System Landscape Dev, QA and Prod
* Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression
testing, User Acceptance Testing UAT and documentation.
Technical environment: (SAP BW 7.4, SAP HANA1 SPS 10, BEX), SOLMAN

* HANA and Business Objects Development done across all the business Areas for the BI Projects.
* Developed all Technical Specifications based on Functional Specifications that outlines required
Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA
design to meet and satisfy the Business Reporting Requirements.
* Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for
Transaction Data and Calculation Views Graphical to Join/Union the various Attribute and Analytic
Views for report consumption with time dimensions.
* Developed data flows and workflow using BODS for non-sap data source upload and delta
management.
* Created Universes on top of HANA calculation views and developed the Webi reports and
dashboards using IDT Information design tool.
* Consumption of HANA information Models in BW by creating Composite.
* Developed multi-data source challenging reports by merging data from multiple Data Sources
using Web Intelligence WEBI.
* Designed Web Reports Using Be Queries BICS Connection.
* Worked with LCM Life Cycle Management Console to Transport the Objects in System Landscape
Dev, QA and Prod
* Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression
testing, User Acceptance Testing UAT and documentation.
Technical environment: SAP BW7.4 on HANA SPS11, ECC6.0, SAP BI4 suite, SD, MM, PP, FI-CO,
SOLUTION MANAGER

* Involved in project implementation for BW/BI to meet the Business requirements.
* Created and maintained various business specific Info Cubes, Operational Data Store, PSA, Info
Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.
* Conducted and maintained migration of 3.x objects to BW7.x versions which involved migration of
transfer rules, infoSources and update rules.
* Performed loading of master data and transaction data from flat file and SQL database Using
BODS.
* Designed and managed process Chains for full and delta loads for data targets.
* Worked extensively on LO Cockpit extraction and FI extraction to meet daily financial reports.
* Identifying Data sources, Installation of Data sources and editing as per requirement.
* Maintain list of all the activities for all the tickets until it is closed.
* Troubleshooting data load errors by deleting locked entries, performing Error DTP and checking
PSA maintenance.
* Monitoring of info packages and analysing the reasons for frequent failures of info packages.
* Creating Standard and Custom queries for various Sales & Distribution and Financial reporting as
per business requirement.
* Maintenance of queries and publishing reports to respective stakeholders.
Technical environment: SAP BI BW 7.4, ECC6.0 Business Areas: SD, FI.

* Performed full life cycle E2E implementation for BI/BW for SD & FI modules as per TO BE analysis.
* Participated in requirements gathering, data modelling, planning and scheduling data extraction
from source systems, interacting with users for customized and standard reports, gap analysis and
associated solutions.
* Involved in creating and enhancing Info Providers, Multi Providers, Transformations, and DTPs.
* Learned to improve data load performance by using parallelizing data loads, increasing the
number of DTP processes in 7.4, pre-deleting Info Cube indexes and utilizing write-optimized DSO in
7.4 data flows where applicable.
* Improved report performance by using Info Cube Compression, Aggregates, Line Item
dimensions and Database partitioning.




* Worked with Process-Chains to automate the Data Loads, Rollups into Aggregates.
* Extracted and enhanced Data Sources from FI-AR, FI-AP, Sales order, Shipping/delivery and Billing
modules.
* Created BEX queries used by end-users to generate Standard reports, Invoice Variances, Goods
Receipt Variances, Ordering Activities, Purchase Order Quantities, Purchase Order Values, Average
Delivery Processing Times
* Assisted in developing flexible queries using Filters, Navigational Attributes, and Variables in BEX
Analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of
information.
* Supported data load monitoring team and involved in production Outage and Cutover periods.
* Involved in Data Load Monitoring using RSPC, RSMO, SM37 and SM50 and Production Support
issues.
Technical environment: SAP BW 7.4, ECC6.0 Business Areas: SD, FI.

* Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes,
DSOs, Data Sources, DTPs, Transformations and Multi Providers
* Set up periodic Data loads from legacy system (flat files)
* Involved in extracting the data from R/3 source system
* Installing and creating BI objects like info objects, DSOs, Info cubes.
* Creating and managing dataflow using DTP, transformations and info packages.
* Data Source Enhancement according to customer requirement.
* Designed and developed queries to generate reports in BEX Analyzer.
* Worked extensively on query designer.
* Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update
Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.
* Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.
* Created ODS, Info Cube, Multi-providers and Info sets and extracted SD data (Data sources Like
2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit (LBWE)
extraction. Extensively worked for Sales Order Review.
* Setup and monitored collective run jobs for SD module in LO Cockpit.
* Monitored loads for SD module from R/3 source system.
* Corrected delta load failure for SD module.
* Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.
* Extensively used Structures, cell definition, calculated key figures, restricted key figures, new
selection, new formula, exceptions and conditions.
* Involved in frequent client meetings to discuss project status.
Technical environment: SAP BW 7.4, ECC6.0 Business Areas: SD, FI.