�ݺ�ߣ

VENU Mail:venu.hana@outlook.com
Mobile: 8147880732
Experience Summary:
Having 4+ years of extensive experience including 3 + years of experience as a SAP BI/BW
(7.X) and 1.6 years in SAP HANA & 1.6 years of experience as a SAP Basis Consultant.
 Good knowledge in SAP HANA 2.0
 Expertise in HANA Modeling. Creating new Information Models in HANA, Attribute,
Analytical and complex Calculation views, calculated attributes,
 Good knowledge on Importing and Exporting Landscapes, Tables and Models,
Documentation, User Management, and Analytical Privileges and import/Export
Information models across systems in SAP HANA
 Good exposure on Schemas, table definitions, Attributes, Measures & Hierarchies in
HANA.
 Good Knowledge in SAP HANA security including User Management, Roles and
Privileges.
 Good experience on input parameters and restricted columns & calculated
columns.
 Good experience on creating procedures in time and unit & currency conversions.
 Creating Delivery units and importing them into systems.
 Using Unions, projections and aggregation in the Graphical Calculation Views to
union, filter and aggregate columns of the calculation views
 Worked on import and export functionalities to get models and files (csv) to studio
for views.
 Used delivery units for transportation of modeling objects from Development to QA
and from QA to production.
 Create Measures using SUM, MIN, MAX, and COUNT.
 Wring the SQL procedures
 Experienced in design and development of Basic cubes and Data Sources as per
requirements
 Experienced in configuring Multi Providers and Info set Reporting requirements.

 Strong Experience in SAP BI / BW Strong knowledge in SAP BW 7.x experience in
BW Modeling, BW Extraction, Performance Optimization, BEx Reporting, Analysis
Process Design.
 Build and enhance BI objects such as InfoObjects, InfoCubes, InfoSources/Data
Sources, and Master Data, Transformations, Update Rules, DSO, Extractors, Info
sets, Aggregates, Process Chains,
 Develop code for flat file data load requirements in terms of file delivery between
servers, file formatting, process chain trigger, and error handling in BW
 Create generic extractors and views in ECC.

 Activate and enhance business content data sources in ECC.
 Modelling and handling various types of SAP extractors in modelling like LO,
Genaric extraction.
 Develop BW queries using BEX query designer.
 - BW data load processing and automation.
 Exp in installing the BI content installation
 Worked on different types of performance tuning like frontend time, OLAP time, DB
time.
 Strong knowledge in SAP BW - Data Modeling, Data
 Extractions/Transformations/Loading, Reporting
 Good understanding of Data Warehousing concepts
 Coordinated on loading data to SAP HANA from different source systems using SLT for
Real-Time
 Configuring STMS by defining landscape between the systems.
 Monitoring and Importing Transport requests from transport organizer.
 Defining Operation modes and assigning time intervals to modes.
 Applying OSS Notes, Patches, Support Packages, Add-Ons and Spam/Saint up
gradation.
 Client administration: Client creation, Modifying the client settings, Local client
copy, client deletion client export/import and monitor these processes in the client
copy and at OS level.
 Exp on monitoring the work process mechanisms and Memory allocation for the
work processes.
 Having good exposure in SAP R/3 System Administration, monitoring and end user
support.
 Exp on table space administration.
 Monitored and performed daily health checks and Monitor Enterprise Portal
servers.
 Applying patches to EP system using JSPM, SDM and SUM tools.
 Export and import business packages like CIM & CR contents in EP system.
 Configuration (SSO)between EP & back end system
 Extensively working with Config tool, visual admin tool and Configure JCO-RFC
connections.
 Maintain license in ABAP and Java systems.
Technical Skills:
 SAP HANA 1.X,BW 7.X
 SQL Server,DB2
Education:
B Tech from JawaharlalNehru technological University,Hyderabad-2011
Professional Experience:

 Working in TECH MAHINDRA Bangalore as SAP HANA/BW consultant FEB-2015 to
till date
 Working in UST GLOBAL Bangalore as SAP BI consultant from June-2013 to JAN-
2015
 Working in UST GLOBAL Bangalore as Basis & Netweaver consultant from OCT -
2011 to May-2013
Project Name mm02-UK-WP5-Magnet Development
Client Telefonica-O2,DACNORTEL-UK
Location Offshore.
Team Size 5
Role SAP HANA/BW consultant
Client Description:
Telefónica entered the United Kingdom after buying O2 in January 2006. Since then, O2 is
the commercial brand of Telefónica UK Limited and is a leading digital communications
company with the highest customer satisfaction for any mobile provider according to
Ofcom.
The company runs 2G, 3G and 4G networks across the UK, as well as operating O2 Wifi and
owning half of Tesco Mobile. Telefonica UK now provides 4G outdoor coverage of almost
60%, while it continues to focus on offering its customers a high quality network
experience and an exclusive content offering.
O2 has over 450 retail stores and sponsors The O2 Arena in London, O2 Academy venues
and the England rugby team.
 Telefónica manages a total of almost 25 million accesses in the United Kingdom
 Telefónica UK’s revenue reached 7,062 million euros (+0.2% year-on-year) and
OIBDA amounted to 1,744 million euros (+1.1% year-on-year)
 Telefónica invested 755 million euros in the United Kingdom during 2014
Roles and Responsibilities:-
 Worked on Creating Attribute, Analytical and Calculation views, procedures,
Creating & Modifying Analytic privileges.
 Creating calculation view with cube star join for performance tuning.
 Hands on creating decision table, analytical privileges for authorizations.
 Hands on creating variables, input parameters, calculated columns in HANA Studio.
 Worked on creating Explorer Information Spaces in Business Object Explorer.
 Worked on Creating Universe on Analytical and Calculation views
 Creating Delivery units and importing them into systems.
 Using Unions, projections and aggregation in the Graphical Calculation Views to
union, filter and aggregate columns of the calculation views

 Worked on import and export functionalities to get models and files (csv) to studio
for views.
 Create Measures using SUM, MIN, MAX, and COUNT.
 Expert in writing stored procedures.
 Creating the datastore between the source systems and target systems.
 Creating the transformations as per the requirement.
 Coordinated on loading data to SAP HANA from different source systems using SLT
for Real-Time
 Also worked on SDA and SDI with different transformations.
 Worked on life cycle management for creating the delivery units for export and
import.
 Ability to run plan viz to analyze performance bottlenecks in the HANA views
 Understanding of different techniques to optimize performance of HANA views
 Creating HANA optimized DSO, INFOCUBES and INFOOBJECTS for reporting BEX.
 Experienced on creating information models on HANA studio and call to webi
reports
 Stored data from SAP ECC tables into DSO objects through PSA to perform detailed
level reporting
 Expertise in the area of SAP BW Administrator Workbench. Creating Info objects,
Datastore object(DSO), Infocubes, Multi providers and Infosets
 Created 7.x queries using BEx Query Designer, Analyzer. Created user exits,
Characteristics variables, Formula variables, calculated key figure
 Expertise in data modeling, extraction and loading (full/delta upload)
 Uploading master data and transactional data both from flat files and SAP R/3
systems.
 Extensively involved in creating of Transformation and Data Transfer Process
(DTP) for the Data Loads
 Scheduled Info Packages in order to load Master Data and Transactional Data from
SAP R/3 as well as Flat File Source Systems into PSA level in BW system.
 Created Variables, Conditions, Restricted Key figures, and Calculated Key figures.
 Involved in complete life cycle implementation of BW projects that include data
Modeling, report generation and data extraction.
 Experienced in design and development of Basic cubes and Data Sources as per
requirements
Project Name Enterprise Data Warehouse DANA Enhancements.
Client DANA HOLDING CORPORATION-US.
Location Offshore.
Team Size 5
Role SAP BI consultant

Client Description:
It is a world leader in the supply of axles; driveshaft’s and structural, sealing, and thermal-
management products; as well as genuine service parts. The company's customer base
includes virtually every major vehicle and engine manufacturer in the global automotive,
commercial vehicle, and off-highway markets, which collectively produce more than 65
million vehicles annually. Based in Toledo, Ohio, the company's continuing operations
employ approximately 35,000 people in 28 countries.
This project involves handling the enhancements, service incidents and request raised by
the users and full support to the client in fixing the issues.
 Creating hana optimized DSO, INFOCUBES and INFOOBJECTS for reporting BEX.
 Expertise in Creating Info objects, Datastore object(DSO), Infocubes, Multi providers
and Infosets
 Uploading master data and transactional data both from flat files and SAP R/3
systems.
 Hands-on experience in BW reporting using BEx Query designer, BEx Analyzer and
creating queries
 Scheduled Info Packages in order to load Master Data and Transactional Data from
SAP R/3 as well as Flat File Source Systems into PSA level in BW system.
 Strong Experience in SAP BI / BW Strong knowledge in SAP BW 7.x experience in
BW Modeling, BW Extraction, Performance Optimization, BEx Reporting, Analysis
Process Design.
 Build and enhance BI objects such as InfoObjects, InfoCubes, InfoSources/Data
Sources, and Master Data, Transformations, Update Rules, DSO, Extractors, Info sets,
Aggregates, Process Chains,
 Develop code for flat file data load requirements in terms of file delivery between
servers, file formatting, process chain trigger, and error handling in BW
 Create generic extractors and views in ECC.
 Activate and enhance business content data sources in ECC.
 Modelling and handling various types of SAP extractors in modelling like LO,
Genaric extraction.
 Develop BW queries using BEX query designer.
 - BW data load processing and automation.
 Exp in installing the BI content installation
 Worked on different types of performance tuning like frontend time, OLAP time, DB
time.
 Strong knowledge in SAP BW - Data Modeling, Data
Extractions/Transformations/Loading, Reporting
 Good understanding of Data Warehousing concepts
 Writing the routines as per the requirement.

Organization : UST GLOBAL
Client : Jain Irrigation Pvt. Ltd
Designation : SAP BASIS & Netweaver CONSULTANT
Environment : ECC6.0, Oracel0g, 11g and UNIX, Windows 2003.
Client Description:-Jain Irrigation has multi product industrial profile and
manufacturers of Drip and Sprinkler Irrigation Systems and Components; PVC,
Polyethylene (HDPE, MDPE) & Polypropylene Piping Systems; Plastic Sheets (PVC & PC
sheets); Dehydrated Onions and Vegetables; Processed Fruits; Tissue Culture, Hybrid &
Grafted Plants; Greenhouses, Poly and Shade Houses; Bio-fertilizers; Solar Water Heating
Systems and Solar Photovoltaic pipe lances (Solar lighting systems) and Bio-Energy
sources. We render consultancy for complete or partial project planning and
implementation
 Installation of ECC6.O EHP5, Netweaver 7.0,7.3, pre-installation activities and
Performed Post installation activities.
 System health Checks like all application servers, Work process overview, Spool
logs, lock entries, Performance monitoring, Checking space statistics, and Backup
logs.
 Monitoring work processes and their statuses from time to time
 Configuring STMS by defining landscape between the systems.
 Monitoring and Importing Transport requests from transport organizer.
 Defining Operation modes and assigning time intervals to modes.
 Client administration: Client creation, Modifying the client settings, Local client
copy, client deletion client export/import and monitor these processes in the client
copy and at OS level.
 Exp on monitoring the work process mechanisms and Memory allocation for the
work processes.
 Having good exposure in SAP R/3 System Administration, monitoring and end user
support.
 Exp on table space administration.
 Responsible for daily monitoring of the R/3 servers. Work processes, File system,
and RFC connection.
 Good Knowledge on EHP upgrading
 Day to-day monitoring tasks like checking database growth and swaps.
 Maintaining static and dynamic profile parameters from RZ10 and RZ11.
 Responsible for testing and transporting roles across landscape. Portal
administration.
 Using admin tools (Configtool, visual administrator, NWA etc.)
 Working with Configtool like adding server process, Visual admin tool, JCMON Tool

 Configuring single sign-on between EP and back end systems.
 Monitored and performed daily health checks and Monitor Enterprise Portal
servers.
 Applying patches to EP system using JSPM, SDM and SUM tools.
 Export and import business packages like CIM & CR content.
 Generating license keys in SMP
 Knowledge on EP concepts like user administration, system administration
,content administration

�ݺ�ߣ

VENU4 YEARS

Recommended

More Related Content

What's hot (19)

Viewers also liked (13)

Similar to VENU4 YEARS (20)

VENU4 YEARS