Sap Hana Installation And Migration Resume
Glendale, CA
SUMMARY:
- Has over Twelve Years of IT experience in the administration of SAP systems which includes nearly 11 years of extensive experience in SAP BASIS module with Migrations, Upgrade, implementations and three years of experience in SAP HANA Database
- Experience in HANA Installation, HANA Revision upgrades, HANA Add - on Installations using hdblcm. Performed HANA table re-partitioning, designed HANA consistency checks for complex environments, designed and implemented HANA High availability and System Replication for HA/DR systems.
- Designed and implemented one of the largest HANA Scale-out systems for SAP BI systems. Designed and Implemented first of its kind SAP HANA ERP scale-out system. Worked closely with functional teams for distributing the eligible tables on HANA ERP scale-out system.
- Performed SAP HANA Migrations from DB2 and Oracle systems. Usage of SAP SLT for data migration from multiple SAP Systems to a Single HANA system. Installation of S/4 HANA on premise edition. Applying SP stacks using SUM tool. Installation and configuration of SAP SLT system. Performing replication monitoring and Monitoring the SLT Triggers on HANA DB side.
- Performance analysis of complex HANA Environments. Worked with SAP for issues related to high CPU and memory usage, HANA Index server crashes and assisted in identifying the issues for special build HANA Revision packages, which are customer specific.
- Performed several SAP migrations using Distribution Monitor, Migration Monitor and SWPM.
- Performed SAP BW migration of a 27 TB system running on Oracle database in a span of 12 hours using distribution monitor
- SAP expertise includes SAP Security Activity, Change and Transport system, User Management,
- Core Strengths include Installation and maintenance of SAP Net weaver ABAP and JAVA, ECC6.0, Enhancement packages, Enterprise portal, SAP Net weaver Gateway, SCM, SRM
- SAP R/3 Administration includes Installation of SAP R/3 in Sandbox, Performing the post steps for the installation, Monitoring the System, Scheduling the standard and custom Batch jobs, Creating/modifying the roles and authorizations, Applying the SAP License, Support packs, kernel patches, SAP Notes, performing Client copies, Database copies and System copies across the Landscape.
TECHNICAL SKILLS:
SAP Components: SAP ECC, SAP Netweaver 7.0, 7.1, 7.3, 7.4, 7.5, SAP BI, SAP SCM, SAP SRM, EP
Database: SAP HANA, Oracle, MS-Sql, SAP MAX DB, Live cache
Operating Systems: AIX, SUSE Linux, Windows Server
PROFESSIONAL EXPERIENCE:
Confidential, Glendale, CA
SAP HANA Installation and Migration
Responsibilities:
- Designed and installed Complex SAP HANA BW scale-out environments with 33 nodes(SiteA&B)
- Designed Technical configuration and Installed first of its kind HANA ERP Scale out System with 2 Nodes(24 TB each)
- Worked on Installation and Migration to on premise S/4 HANA 1511 and SFIN Conversion together with SAP Application development teams
- Designed regular HANA Consistency checks to run in different non-peak hours in a week to avoid CPU and Memory utilization using max concurrency
- Installed several HANA Revision upgrades specially released for Customer based on the issues encountered
- Designed and Implemented HADR setup for Pre-prod and Production systems
- Performed HANA Failover and Failback
- Configured and tested HANA DR with multiple System Replication modes.
- Performed HANA Add-on installations, Safely uninstalling the Add-on whenever needed using hdblcm and hdbalm
- Generating and Analyzing HANA full system dumps, kernel profiler traces, Context files and crash dumps
- Designed and Performed table re-distribution and table partitioning for eligible tables.
- Performing table distribution across the nodes
- Monitoring the SAP HANA System using HANA Studio
- Analyzing HANA performance issues and troubleshooting the issues
- Worked closely with SAP on the Index server crashes identifying the bugs to create new special Builds(HANA Revisions) for Customer
- Added Additional Hosts to the existing HANA Database using hdblcm
- Installed and configured SAP SLT system for table replication.
- Monitoring the Active SLT triggers for any performance issues and sequence cache issues on HANA DB end.
- Configured HANA Host Auto Failover for Scale out systems with Multiple Master Nodes for failover
- Performed HANA DB Backups and Restored the HANA DB backups to test systems/Pre-PRD for restore testing and data validation
- Performed HANA Backup consistency checks for FS backup and TSM backups.
Confidential
Data Center Migrations, Support and Upgrades
Responsibilities:
- Datacenter Migrations from EON (Hannover, Germany) to HP
- Performed Homogenous and Heterogeneous System Copies
- Performed System Copies/ Migrations Using SAP INST and SPM tools
- Using Migration Tools for Parallel Export and import for Production
- Environments and completing the migration within the timelines
- Trouble shooting the issues during the Migration and analyzing the log
- Files for the migration.
- Identified Largest Tables and defined table splitting strategy to minimize the downtime of Migration
- Performed Unicode Conversions for multiple SAP Landscapes
- Performed OS/ DB Conversions for more than 15 landscapes
- Designed and Documented the SAP Landscapes
- Performed DB Migrations for SAP Landscapes from Oracle to MS-SQL Server as a part of Rollout from EON to HORIZON at Onshore Germany
- Performed Solution Manager System Copies from Production to Sand Box system for Monitoring Rollout testing.
- Migrated 4 BI 7.3&Oracle landscapes from AIX to Linux
- Upgrade BW systems, SCM systems from Netweaver 7.0 to Netweaver 7.3
Confidential
Production Support, Upgrades
Responsibilities:
- Providing Support of SAP ECC, BI, SCM, SRM, Solution Manager systems
- Performed System Copies
- Performed Kernel Upgrades, JRE Upgrade
- Performed Support pack Upgrades, Add-on, EHP upgrades, oracle DB Upgrades
- Designed and Documented the SAP Landscapes
- Performed DB copies using backup/restore methods, Homogenous system copies.
- Mentored junior staff with KT sessions on troubleshooting issues during upgrades, Support packs, Kernel Upgrades
- Upgraded BI Landscape from Bi7.0 to 7.3 using SUM
- Configured Solution manager to generate EWA reports, generate Stack files for upgrades
Confidential
Production Support
Responsibilities:
- Providing end user day-to-day support
- Connected Progress DB to BI system using UD Connect
- Performed Archiving for tables as suggested by the SAP EWA
- Installed 4.7 system and performed system copies
- Renew SAP Router
- Upgrading the kernel
- Applying Support packs and add-ons
- Monitoring the performance of the system
- Adding data files to the table space
- Performed system Copy of R/3 and SCM system
Confidential
Senior Consultant-SAP BASIS
Responsibilities:
- Upgraded the SAP R/3 4.7 EE to ECC 6.0
- Upgraded the Database from SQL Server 2000 to SQL Server 2005
- Performed the Unicode Conversion along with the upgrade for the R/3 Landscape
- Configured the ECC landscape after the upgrade
- Installed SAP ECC 6.0 on MSCS
- Starting and stopping the SAP server in MSCS
- Integrated the ECC Landscape to SCM and BI landscape
- Installed Solution Manager
- Configured the Solution Manager components
- Integrated the satellite systems to Solution Manager. Configured the Service data collection to satellite systems from Solution Manager
- Configured Service desk
- Configured the Early watch Alerts for Solution manager
- Configured RCA and Solution Manager Diagnostics
- Installed Agents in satellite systems
- Configured the Maintenance Optimizer
- Configured RTCCTOOL and SDCCN by implementing ST-PI and ST-A\PI Plug-in
Confidential
Production Support
Responsibilities:
- Providing end user day-to-day support.
- Modifying roles and user profiles assigning the required transaction access to the user using SUIM & PFCG by analyzing the SU53 screen shots.
- User creation, deletion users, dialog users.
- Working on OSS issues like providing object key, opening connection for user etc.
- Imported and maintained all system profiles
- R/3 System Monitoring.
- Analyzing System errors & ABAP Dumps.
- Applying required Patches.
- Installed SAPGUI 6.20, 6.40,7.0,7.10 and also GUI patches
- Applied sap note.
- Client copy, deletion, Client export, import and Client refresh.
- Administering Backgrounds Job, updates, locks and Spool.
- Transport Management System.
- Created transported requests, performed imports using tp.
- Analyzed different transport log files to troubleshoot transport problems
- Defining Backup and Monitoring.
- SCM APO Monitoring
- Live Cache Administration
- Monitoring Live Cache
- Starting and stopping Live Cache
- Changing Live Cache Parameters
- Monitoring APO
- Scheduling and Monitoring APO Jobs
- Performed DB-refresh of R/3, APO, BI systems regularly
- Performed Client Transport
- Performed Live Cache backup at regular intervals
- Working with DBM-GUI and DBM-CLI
- Has been a part of the BI - Implementation
- Performed System Copy on BI Landscape
- Performed BI and EP integration
- Performed External DB Connectivity to BI system
- Handled Bex and WAD Issues from users.
- Implemented BI Admin Cockpit in BI system.
- Integrated External Database to BI systems
Confidential
SAP BI Implementation
Responsibilities:
- Performed the sizing using the Quick sizer tool for implementation
- Downloaded the required media from SAP SMP
- Installed SQL Server 2005
- Installed the SAP BI with ABAP and Java Stacks
- Performed the post steps after the installation
- Configured Single sign on for JAVA Stack
- Configured the STMS for transporting the developments
- Applied BI- Content in the system
- Applied Support packs for Java and ABAP stacks
- Deployed the SAP BI- Admin Cockpit
- Handled the BEX and WAD issues from developers
- Performed System Copies across the landscaped
Confidential
SAP SCM Upgrade from APO 3.0 to SCM 5.0
Responsibilities:
- Performed Step Upgrade from APO 3.0 to SCM 4.1 and SCM 5.0
- Performed the Pre and Post Upgrade activities
- Upgraded the Live cache
- Performed the Live cache backup and restore
- Installed SCM 5.0
- Upgrade the database from SQL Server 2000 to SQL Server 2005.
- Scheduled the APO specific background jobs
- Setup the connectivity between the R/3 4.7 EE and SCM 5.0 systems across the landscapes
- Configured the STMS for transporting after the upgrade.
Confidential
Responsibilities:
- Providing end user day-to-day support.
- Working on OSS issues like providing object key, opening connection for user etc.
- Maintaining Operation Modes.
- Imported and maintained all system profiles
- R/3 System Monitoring.
- Analyzing System errors & ABAP Dumps.
- Applying required Patches.
- Installed SAPGUI 6.20, 6.40 and also GUI patches
- Applied sap note.
- Client copy, deletion, Client export, import and Client refresh.
- Administering Backgrounds Job, updates, locks and Spool.
- Transport Management System.
- Created transported requests, performed imports using tp.
- Analyzed different transport log files to troubleshoot transport problems
- Defining Backup and Monitoring.
- Worked with SAPDBA tool.
- Database Monitoring for space utilization & performance tuning.
- Identifying the Space Critical Objects and Adding the Data files.
- Monitoring the remote systems from Solution Manager.
Confidential
Responsibilities:
- Installing SAP R/3 4.7EE
- Performing Post-installation Activities
- Scheduling SAP Standard B/G Jobs
- Creating User Accounts for Intelli Users
- Assigning Authorizations for the users
- Creating Roles, generating the profiles according to organization levels.
- Installed BI and EP on Test Servers.
- Installed and configured Solution Manager on test server.
- Installed ECC5 IDES version on test version.
- Acquiring License from SAP.
- Creating and maintaining user accounts in SAP market Place
- Generating Keys for new installations and upgrades in Solution Manager.
Confidential
System Administrator
Responsibilities:
- Installing the Various Operating Systems at End-User Desktops and Servers.
- Installing Various DB Software’s like Oracle 8, 9i, MS-SqlServer2000 on Servers for Development purpose.
- Handling the Tickets to resolve the issues at end-user desktops.
- MS Window NT/2000/XP installation and configuration, Administration of Microsoft NT/2000 server including user accounts, print services, Tape Backups and MS exchange management
