Sap Data
Resume:
M.RAMU
****.*****@*****.***
Professional Summary:
8+ Years of Experience in Information Technology which is having 6 years experience on SAP BI/BO and HANA consultant. Experience
in SAP BI 7.x/BO 4.x and HANA SPs09 1.x 2 end to end BW Implementations, 1 SLT server Implementation and support, 1 migration
and upgrade HANA project and 1 native HANA project. Consulting responsibilities included Business process mapping, system
Configuration, Integration testing and User training.
Having expertise in HANA projects like HANA Modeling, Implementations and Administration.
Experience on replication techniques such as SLT Trigger based, BODS ETL based and DXC Direct extractor.
Creating Information Views like Analytic, attribute and calculation views based on requirement.
Expertise in configuration and customization of FI (GL, AP, AR, AA,SPL)
Replicated FI tables from SAP ECC server to HANA DB by using SLT server.
Good Knowledge on HANA Studio for creates a Sql Script, Procedure and packages.
Experience on HANA Security like User management, Privileges and network communication security.
Have good experience on SAP HANA DB Installation, configuration, backups, Recovery, Monitoring and Trace log file.
Troubleshooting issues on HANA PRO/DEV/TEST Instances.
Experience in Business Objects reporting systems using Crystal Reports 8.0/9.0/XI, Business Objects XI R2/ R3, Business Objects
Universe design, Web Intelligence, Info view and CMC.
Worked in HANA DB migration and PCA.
Expert in creating reports using Web Intelligence 4.1
Experience creating Dashboards using Xcelsius 2008, Dashboard Designer
Creating Universes on Information Designer Tool (IDT) 4.1
Expertise Reporting BEx: Designed Queries, Workbooks, Filters, Conditions, Structures Calculated/Restricted key figures and Customer exit
Variables and worked on formatted reports, Report Designer and Web Application Designer.
Experienced Extraction Processes in Generic, LO Extractions, WEB Service Data Sources, BODS and Data Source Enhancements.
Experienced in creating complex BO webi reports, Crystal Reports and dashboards using advanced features.
Implemented BW/BO 4.o best practice for report optimization.
Good knowledge on designing dashboards using designin studio connecting to BI HANA.
Experienced on Oracle Database administration, backup and recovery, performance issues.maintance and support difference insistences like
Pro,Dev,test database instances
Participate in new projects from a BW development standpoint to ensure that projects are executed in accordance with SAP Best Practices
and also completed on time
Technical Skills
Data Warehousing SAP BI 7.3, BI 7.0, BW 3.5.,
ERP SAP R/3 ECC 6.0/5.0, SAP R/3 4.7
Data Bases SAP HANA1.0, Oracle 10g/11g, Sqlserver 2008/2005.My sql.
Functional Modules SD, MM, PP, HR, FI-CO, CRM, SAP BPC, SAP security.
Data Replication, ETL SAP BODS 4.x, Informatics Power Center 9.x, SLT, DXC
Reporting Tools WEBi, Dashboard (Xcelcius), BEx Query Designer, Bex Analyzer, Crystal Reports for Enterprise, WAD, MS
Excel, BO Explorer, Tableau. Cognos 8
Business Modeling HANA Design Studio, Data Services Workbench, Data Warehousing Workbench (RSA1), Information Design
Tool (IDT),
Programming PL/SQL, SQL
Databases SAP HANA 1.0 (SP7), Oracle 10g/9i/8i, MS SQL server 2008, MS Access.
Operating Systems Windows NT/2000/XP/7, Windows Server 2008, Unix, Linux
Testing HP Quality Center
Project Methodologies Agile/Scrum, ASAP
1
Work Experience:
SAP BO HANA
Reliance India ltd India June14 To Sept15
Consultant
Sap BO HANA
NNIT A/S Denmark(Onsite) Feb12 To April14
Consultant
Bon appetite
Denmark(Onite) Sap BO Consultant Dec10 to Feb 12
Group A/S
Birla soft India Jr.Oracle DBA Sept07 To Nov 09
Education Details:
Master of Computer Applications (M.C.A) from J.N.T.University, India. From 2004 to 2007.
Bachelors of Computer Science (B.Sc.(Computers) from A.N.University, India. From 2001 to 2004.
Project Summery:
Project: SAP HANA Implementation and support June 14 to Sept 15
Client: Reliance India ltd
Role: SAP HANA/BI/BODS Consultant
Location: Mumbai, India
Role & Responsibility:-
As a Project Lead in the project streamline the entire process and working on survival guide and management related things Conducted SAP
HANA Overview session for the customer & done assessment.
SAP HANA in-Memory Platform core technology, including architecture, landscape design, installation, upgrades, performance tuning, and
system integration.
Strong experience in solution architect on Native HANA & BW on HANA.
Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, and DXC.
Worked on Data store security, Certificate management, risk of trace and files.
Performed data validation and account determination for mapping of the processes on to the SAP R/4 system.
Maintain the HANA Security like User management, Privileges and network communication security.
Support the SAP security team for Hana security authorization and single sign on and Data replication techniques.
Experience of working on HANA projects related to Business Suite on HANA ECC
Experience in extraction of data from Excel, External data base, SAP BW, SAP ECC, SAP LANDSCAPE TRANSFORMATION (SLT) to
HANA Data Base.
Developed HANA model in Hana studio like attribute View, Analytic view, Calculation view.
Conduct workshop with business users and get KPI'S requirement and define the reporting layout.
Developed Sql, Sql Script, Stored Procedures and CE Functions as per business requirement.
Created the Attribute view, Analytic views, Calculated views (Graphical and SQL)
Assigning SAP HANA Package Privileges to user to Control access to information.
Worked on change management process to move the transport requests into Quality system.
Experience in Creating and executing Data Service Job in SAP BODS to populate HANA.
Created Information models for ECC tables and created variables, calculated columns, restricted columns, Applying filters and worked with
input parameters
Configuring and Monitoring work flows in SAP BODS Management Console.
Involved in taking client requirement for BO reporting on top of HANA.
Involved in Creating Universe and Web intelligence WEBI reports.
Ability to translate business requirements into a technical solution
Combined Two different source data and a analytical index for a flat file using Composite Provider
Worked on Installation, Configuration,enhancement and Authorization Assistant of HANA Live business suite and worked on
SD,MM,PP,FI Virtual data model and Publish report in Webi,Business Explore and Dashboard designer as per business requirement
2
Environment: SAP HANA 1.0(SP7, SP8), HANA Design Studio, SLT, SAP BI BW 7.4, SAP BODS 4.1, SAP BOBI 4.1, SAP R3 ECC,
CRM, Oracle DB
SqlserveDB, Cognos 8.
Project: SAP BO-HANA Implementation and modeling Feb 12 to April 14
Client: NNIT A/S
Role: SAP BO HANA Consultant.
Location: Copenhagen,Denmark
Roles & Responsibilitys:
Good experience on Analytic, Calculation views, Attribute views and Hierarchies.
Creating views by using CE functions (CE_JOIN_VIEW, CE_OLAP_VIEW, and CE_CALC_VIEW).
Good knowledge on Sql Script, Store procedure and Table types.
Created information view in Hana Modeling.
Created user and roles with privileges from default schema _sys_privilliages in Administrator console.
Apply Currency Conversion in analytic views by using TCURR, TCURV, TCURF, TCURN, and TCURX TABLES.
Created calculated columns and hierarchies in information views
Data replicating from SAP Source system and NON Sap Source system to HANA DB by using 3 different techniques
Using CE function write Sql script by creating views.
Combined HANA view is composite provider using transient provider
Creating SAP HANA Delivery Units and configuring
SAP HANA Information Packages that provisioning data
Importing SAP ERP Metadata using SLT
Importing Range tracker data Metadata into SAP HANA Database using BODS
Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
Resolving Loops using Aliases and defining the Contexts for the Universes and exported them to the Repository to make resources available
to the users and group
Created web intelligence reports and tested them properly.
Involved in migrations i.e. universe and reports.
Expert in Dashboard refreshment. And updating to Users.
Maintenance of existing universes and WebI reports
Testing the Design and Development of Reports.
Created the reports as per client requirement and changing the format as well.
Involved in the reports scheduling and maintains the reports and instances as well.
Preparing Weekly Status Report (WSR) and sending to the Manager.
Implementing the data level security for the universe.
Environment: SAP Business Objects 4.0, SAP HANA 1.0 (SP4), SAP BODS 4.0, Oracle 10g, PL/SQL. SAP BO 4.0, SAP R3 ECC, CRM,
Sql sever.
Project: Customer level report Project Dec 10 to Feb12
Client: Bon Appetit Group A/S
Role: SAP BO Consultant.
Location: Copenhagen,Denmark
Roles & Responsibilitys:
Involved in designing and building of Universes, Classes and Objects by resolving complex loops by defining contexts and aliases.
Enhanced the existing Universe and added the new tables, classes and objects as per the requirement.
Designed rank, Exceptional reports according to the user requirement.
Created the reports using the Universes as the main data providers and created user objects including dimensions, details and measures.
3
Created alerts using Business objects to highlight the columns based on business criteria.
Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, and charts for
creating Business Object reports.
Involved in scheduled the reports on daily, weekly, monthly, quarterly and yearly basis as per the user requirement
Created live office Spread sheets according to requirements and used these spread sheets, to create interactive dashboards and power point
presentations using Xcelsius 2008.
Created OLAP Universes using Bex Queries & Infocubes.
Created alerts using Business objects to highlight the columns based on business criteria.
Created bar charts, pie charts, gauges for predicting flow in pipes and exported them to power point, PDF and presented them in user
meetings.
Involved in providing the complete Business Objects XiR2 reporting solution and during the course of action have used Universe using
Designer, Business views using Business View Manager, Analytical reports using Desktop Intelligence and Webi.
Created bar charts, pie charts, gauges for predicting flow in pipes and exported them to power point, PDF and presented them in user
meetings.
Environment: SAP BW 3.5, SAP R/3 4.7, ECC 5.0, SAP Business Explorer (BEx), MS SQL Server, Windows NT
Project: Maintenance and support Oct07 to Nov 09
Client: Birla Soft
Environnent: Oracle 10G
Location : Hyderabad, India
Rles & Responsibilitys:
Giving support to various environments like PROD, PS, UAT, DEV and TEST.
Appling patches by using Ad patch.
Involving in Cloning Activities
Taking oracle support for bug fixes and performance issues.
Applying database patches.
Involving in Cold Backups, Hot Backups and RMAN Backups.
Managing Table spaces.
Tracking invalid objects and compiling.
Defining and Administering of Concurrent Managers and Work shifts.
Creating users and assigning responsibilities to them.
Supporting onsite team during their off-hours on various instances.
Taking Oracle-Support for bug fixes and performance issues.
Managing Table spaces.
Refreshing database schemas in DEV and TEST environments.
Taking Hot Backup, Cold Backup for various Environments.
Applying Database patches using opatch utility..
Environment: Oracle 10g/9i,Redhat lunux enterprise,Sql, Pl/sql.
4
Contact this candidate