Sap Basis Hana Administrator Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Over 13+ years of total IT experience as SAP Basis/NetWeaver Consultant and 3 years as SAP HANA Administrator with core strength in all aspects of SAP systems, databases administration in implementation, production and upgrade phases of a projects
- Installed various SAP components 4.7 r/ 3, ECC5, ECC6, EP 6.0, 7.0, 7.3, BW3.5, BI 7.0, PI 7.0, 7.11, APO, GRC 5.3, Process Control 10, Web Dispatcher, SAP Router and Non ABAP Components includes SAP MDM 7.1, BOBJ BI 4.1, BOBJ BODS 4.1.
- Installation of HANA database in Scale - up and scale-out environment. Implemented GRC PlugIn for HANA, HANA Database Upgrade, SAML with HANA and BusinessObjects 4.1. Deployment of HANA live for ECC, CRM, EM, TM, and EWM
- Experienced with the SAP Basis Administrator tasks including full life cycle Implementation, Enhancement Package Update, Version Upgrades, Oracle upgrade and Support of SAP Basis, HANA and Netweaver.
- Experience in leading upgrades, Unicode conversions, and Combined Upgrade and Unicode conversion (CUUC), EHP Upgrades
- Expertise in troubleshooting issues related to SAP Business Objects product suites like installation, deployment, and configuration, scheduling reports and administration and maintenance of SAP Business Objects Servers.
- Involved in heterogeneous and homogenous system copy for ECC, BI, SCM, and live Cache.
- Performed SAP System upgrades, OS/DB migrations, Kernel upgrades, installed support package using SPAM, SAINT and SUM along with OSS notes implementation.
- Strong practice of Database backup, recovery process. Executed Multiple DR drills at various clients. Expert in Transport Management System (TMS) - Complete setup of Correction and Transport System (CTS) through STMS.
- Successfully completed upgrade project which includes SAP ECC5.0 to ECC 6.0 EHP5, PI7.0 to PI7.1, BW3.5 to BI 7.0, Solution Manager 7.01 to Solution Manager 710. Hands on experience in performance tuning and well versed in SPOOL administration.
- Performed all refresh activities including source system database backup and restore on target system with the modified control file. Performed all post refresh activities.
- Skilled in accurately estimating work requirements for implementing any changes to the landscape or the single system. Successfully completed upgrade project which includes SAP ECC5.0 to ECC 6.0 EHP5, PI7.0 to PI7.1, BW3.5 to BI 7.0, Solution Manager 7.01 to Solution Manager 710.
- Installed and configured SAP Solution Manager 7.0/7.1 along with pre and post configuration such as Basis Configuration, System Preparation, Managed systems configuration involving the SMD Agents, Host Agents, and wily setup configurations.
- Experienced with SAP Netweaver workload analysis, performance tuning and memory management. Database upgrade and applied patches, backup and recovery, performance tuning, trouble-shooting and problem resolution
- Installations - Installation and configuration of SAP products on a HIGH Availability environments that includes HANA, Oracle RAC, Linux Cluster and Windows Cluster
- System Upgrades - Upgrades and Combined Upgrade & Unicode Conversion (CU&UC) of SAP products like ECC, BW and SCM. Also worked on Database upgrades on HANA, Oracle and MS SQL
- Migrations - Migrated SAP systems in the form of Heterogeneous and Homogeneous system copies
- Maintenance & Support - Provide 24/7 support, including regular system health checks and recommend enhancements and periodic maintenance for complex landscapes
PROFESSIONAL EXPERIENCE
Confidential
SAP Basis HANA Administrator
Responsibilities:
- Installation and configuration of HANA databases in Scale-up and scale-out environments.
- Installation and configuration of BW 7.4 on HANA environments and used the hdbuserstore to store and manage connection information in the secure store
- Configured security settings for Auditing and enabled Data Volume encryption in the persistence layer
- Installed and configured SAP System Landscape Transformation as separate SLT on NetWeaver systems.
- Configuration of parameters using the SAP HANA cockpit, the SAP HANA studio, or the alter system alter configuration statement
- Installed HANA live content for ECC, CRM, EM, TM, and EWM. Installation of GRC Plug-in for HANA.
- Upgraded BW on HANA environment to 7.5 SP02 from 7.4 SP06
- Upgraded SAP HANA SPS using HLM from previous versions to SPS12 Rev 03
- Used HLM HANA Lifecycle Manager to Administrate, Integrate into system landscape, update SAP HANA Components and deployed HANA content.
- Upgrade BOBJ BI from 4.1 SP4 to 4.1 SP7 Patch 3
- Upgrade BOBJ Data Services and Information Steward from 4.2 SP2 to 4.2 SP6 Patch1, Migrated reports from 3.1 to 4.1 using upgrade management tool
- Performed SAP HANA Operations such as configuration of table partitioning and table distribution in Scale Out system configurations
- Configured SAP HANA System Replication and disaster recovery solution that provides continuous synchronization of a HANA database to a secondary location
- Gathering and analyzing data regarding the performance of Sap HANA systems such as resource shortages of CPU, memory, disk I/O and, for distributed systems, network performance.
- Transport management using export/Import using HANA Studio.
- Performed Failover test cases for HANA in Scale-out Environment.
- Prepared stable solution for SAP HANA Backup and Recovery using NetBackup backint configuration.
- Configured Single Sign-On (SSO) using Security Assertion Markup Language (SAML) between SAP BusinessObjects BI Platform 4.1 (BI Platform) and SAP HANA Database 1.0.
- Performed System refresh of BW on HANA using export and import method and post system refresh activities.
- Administration of SAP HANA Data Provisioning through SLT, Smart data access to Teradata, SAS and BOBJ Data Services.
Confidential
SAP Basis Administrator
Responsibilities:
- Involved in SAP HANA Administration including creation and management of schemas for different SAP systems, data model objects, and import/export content.
- Worked on installing and configuring Data Provisioning tools such as SAP SLT and BODS
- Added additional hosts to accommodate data growth and redistributing data for impacted tables
- Involved in installation and configuration of SAP Business Objects Data Services 4.0.
- Upgraded HANA database from SPS07 to SPS09 and SPS10 using hdblcm along with HANA Add-on update
- Transport of HANA content export/Import using HANA Studio
Confidential
SAP Basis Administrator
Responsibilities:
- Installation and configuration of SCM 5.1 on Windows 2003 SP3 + MS SQL Server 2005, applying support pack stacks and add-ons, activating the services and post installation activities.
- ECC 6.0 updated to EHP5 using SUM
- Upgraded SCM to 7.1 from 5.1 as well as LiveCache using In-place upgrade strategy
- Migrated SAP systems from CIBER Datacenter to SAVVIS Datacenter
- Applied java patches and Business packages by using SDM (Software Deployment Manager), JSPM
- Applied Cumulative and Service packs on SQL server 2005 & 2008.
- Installation and configuration of NetWeaver BW 7.3 on Windows cluster environment
- Applied Support packs, SAP Notes and Kernel Upgrade.
- Attended weekly customer calls and making the action plans based on the MOM.
- Configured and scheduled the dynamic sessions for Early Watch alert reports through SDCCN in Solution Manager 7.0.
- Configured Transport Management System (TMS) in the R/3 Landscape by setting up Production System as the Transport Domain Controller and distributed transport configuration to all other systems in the System Landscape.
Confidential
SAP Basis Administrator
Responsibilities:
- Involved in the Planning, Design of the project requirements.
- Installation and configuration of ECC6 with EHP4 SPS6, PI 7.11, BI 7.3 and Solution manger 7.0
- Upgraded Oracle DB from 10.2.0.4 to 11.2.0.2 on standalone DB and RAC environments.
- Completed Combined upgrade and Unicode conversion project on BW to 7.4 from 7.3
- Installed Master Data Management 7.1 SP6 with Oracle DB and integrated MDM with EP
- Involved in DR systems testing
- Upgrade kernel to the latest patch levels.
- Configure central monitoring for Dev, QA and Production servers in Solution manger.
- Perform post installation activities such as client copy, support pack stack, STMS, parameter changes.
- Configured EWA for the productions systems.
- Applied RTCCTOOL recommendations and implemented RSECNOTE tool to identify the Security notes In order to shun the security flaws in the system.
- Initiating go live check with SAP and applying the go live recommendations.
- Applied EWA recommendations.
Confidential
SAP Basis Administrator
Responsibilities:
- Applying Support packs, SAP Notes, Kernel Upgrade.
- Trouble shooting the printer issues and adding the new printers.
- Configured Single Sign (SSO) to the SAP EP 7.0 System.
- Created Clients and performed the Client copy, deleted the clients.
- Configured the Workflow for Automatic transports for ECC and BI systems
- Configured Transport Management System (TMS) in the R/3 Landscape by setting up Production System as the Transport Domain Controller and distributed transport configuration to all other systems in the System Landscape.
- Configured Central User Administration.
- Configured the Maintenance Optimizer and Service desk in Solution Manger.
- Defined satellite Systems in Solution Manager and maintained the RFC destinations.
- Configured and scheduled the dynamic sessions for Early Watch alert reports through SDCCN in Solution Manager 7.0.
Confidential
SAP Basis Administrator
Responsibilities:
- Daily and periodic administrative tasks include monitoring system logs, Work processes, Transports, locks, updates, spooler, kernels and patches/support packs, SAP notes.
- Performance monitoring, Report Creation, shot dumps, Health checks, Root cause analysis, issue resolution and fine tuning.
- Applied support package stacks.
- Enterprise Portal (EP), JCOs, JSPM, Cert Keys
- Scheduled, ran and monitored backup jobs of the SAP Database and required OS directories.
- Configured and monitoring setup of SAP application from Solution Manager.
Confidential
SAP Basis Administrator
Responsibilities:
- Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications.
- Build and enhanced BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains
- Developed queries based on client requirement. Used calculated key figures, formulas, restrictions, conditions, Exceptions in the queries. Developed report-to-report interfaces, Published views on web.
- Created and maintained data sources at SAP OLTP source and extracted data info cubes after creating transfer rules, info packages and update rules.
- Worked extensively on standard and custom defined LO and LIS extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery billing information.
- Developed flexible queries using filters, navigational attributes in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
- Involved in developing front-end queries using Query Designer and Web Application Designer and publishing results on the web.
- Performed Query performance Tuning by analyzing and applying, aggregates, line item dimensions, data compression, Query read Mode, Bit Map Index, Partition a parallel query option.
- Prepared the documentation on data flow design from two Legacy system, restriction, and filter of data, Data Modeling, Unit Testing, User Training, and Report Designing objects.
Confidential
SAP Basis Administrator
Responsibilities:
- Built the Master and transactional process chains and scheduled accordingly to upload the data into info providers with appropriate dependencies.
- Developed and designed formatted, company-wide reporting (Enterprise Reporting) using the BEx Report Designer.
- Involved in maintaining, Testing and monitoring 40 different queries
- Performed defect resolution in Unit Test (UT), System Test (ST) and User Acceptance Test (UAT).
- Built the Master and transactional process chains and scheduled accordingly to upload the data into info providers with appropriate dependencies.
- Created Meta chain to schedule daily loads
- Monitored BW Server to ensure completion of daily scheduled Batch jobs.