Mohammed Sanaullah

E-mail- ad2kps@r.postjobfree.com

Phone:248-***-****

Senior SAP Basis/Hana Admin

GC Holder

SUMMARY

Experienced SAP BASIS and HANA DB Consultant with over 10+ years involving multiple SAP projects. Implementations, upgrades, and production support on different environments.

10+ years’ experience in SAP Basis/HANA DBA Administration.

3 full lifecycle implementation experience

Experience in Both Implementation, support, and Upgrade projects

SAP Experience with pacemaker cluster configuration in Suse and RedHat.

Worked on HANA system administration using SAP HANA Cockpit and HANA Studio.

Worked on HANA 2.0 SP05 to SP06 update and worked on Hana Database restore/recovery, upgraded HANA Client, Studio, DBSL etc.,

Worked on EHP upgrades and Patch Upgrade support packs and addons – SAP Basis/ABAP/ST-PI/ST-API

Performed System Copies/refresh.

Performed OS/DB migration from Unix to Windows and DB2 to MS SQL SERVER

Experienced in SAP HANA Admin

Experience with SAP HANA administration includes monitoring SAP HANA systems and services with System Monitor, and Backup & Recovery, HANA System Refresh, HANA Remote Access using SDA.

Worked on End-End Implementation and Upgrade and Support projects.

Including SAP installation, upgrades, migration, and transport Management system, Backup & Recovery, System Monitoring, Security and Authorizations, CCMS, BRTOOLS, BRBACKUP, BRARCHIVE, BRRESTORE.

Experience with HANA Table Redistribution in Scale out systems

Experience with Offline Row store reorg and online reorg in HANA

Experience with HANA Table Partitioning

Experience with HANA System Replication using various Operation modes, Replication techniques.

Experienced in Managing applications running on SAP HANA platform, Hana DB migration and end to end HANA Road Map.

Providing On-Call rotation support for HANA DB Prod env.

Skills

Operating Systems: AIX, HP-UX, SUSE/Red hat Linux, Solaris & Windows Server.

Database: SAP HANA, Sybase, Oracle, db2, SQL & MaxDB

SAP Applications: S4/HANA, ECC, CRM, SRM, SCM, EP, PI.

Expertise in SAP HANA includes SAP S4/HANA conversion, S/4 HANA green filed implementation, Installation of HANA DB on Linux and application servers and HANA Client install on MS Windows/SQL 2012. focused build for managing HANA implementation. Configuration of HA replication and DR replication on HANA DB using SAP LT (Landscape transformation) Installation and configure table replication between source systems and HANA.

Expertise in Performing and Scheduling SAP HANA backups using HANA studio.

Installed, upgraded, and patched HANA database on Linux platform in Azure and AWS environment.

Replicate source delta table structure to HANA using SLT replication, manage SLT landscape and troubleshoot replication issues on timely BASIS. HANA Live install (side car).

HANA DB administration, SAP S/4 HANA green field implementation, brown field implementations.

Education

B com (Osmania University – INDIA)

MBA (London Institute of Technology & Research London, U.K)

Certification

SAP Certified Technology Associate – SAP HANA (Edition 2016) License NumberS0016538401

WORK EXPERIENCE

Vistex Inc. Aug 18 to Present

Sr. SAP Basis/Hana Admin

Responsibilities

Experience with support SAP HANA Production systems in various cloud environments (AWS, Azure and GCP).

Experience with SAP RISE with SOAR cloud tenant models on various customers

Experience with S4HANA 2021 installation and upgrade from 1909 to 2021

Experience with HANA upgrades from 1.0 to 2.0 latest SPS06

Application monitoring and alerts through SAP Focused Run

Experience with SAP HANA Database High Availability setup using Pacemaker cluster on SUSE and RHEL servers.

Experience with Installing Pacemaker cluster in AWS and Azure cloud environments.

Experience with SAP HANA performance tuning using various tools like running SAP tools hdbcons, kernelprofiler, FullSystemInfodumps and HANA minichecks.

Experience with HANA migration from on-prem to cloud using HSR (HANASystemReplication) and various operation/replication modes.

Experience with HANA Disaster Recovery testing (Failover/Failback) and doing the AUTO register using my Hooks for HANA through ansible scripts.

Experience with SAP System copies, System refresh from production to non-prod QA/Pre-prod

Having 4 years’ experience in archiving (OpenText and familiar with SARA)

Responsible for monitoring and troubleshooting of SAP HANA DB

Experience with HANA system rename, and HANA SID/hostname rename using hdblcm.

Experience with XSA installation and XSA components like Web IDE components.

Experience with XSA upgrade from 81 to 146 version.

HANA DB upgrade from 1.0 to 2.0 revision SPS05

SAP HANA migration using SUM with DMO option.

SQL Database upgrade from 2016 to 2019

Experienced in managing all clouds platform thru SAP Focused Run.

Migrating SAP landscape from On-Prem Data center to AWS cloud

Integration of SAP HANA into different remote systems. Exposure to different remote access options in HANA system using SDA connections.

Performed ECC to S/4 conversion using SUM DMO tool.

Involved in data cleansing along with Functional consultants during HANA conversion.

Experience in monitoring, tuning, and troubleshooting of SAP HANA systems.

Debug various issues that occur within the Hana DB in Production and non-prod environment.

Experience in HANA Table partitioning, Table Re-org offline and online.

Conversion of HANA Scale out system to standalone.

HANA system administration using SAP HANA Cockpit and HANA Studio.

Performed proof of concept for S/4 HANA implementation.

Configured System Monitoring for HANA systems through Solution Manager.

Implementing SAP HANA Table management techniques - data compression, table partition, compression techniques, and load/unload table into memory.

HANA Installation, Data Provisioning, Admin, Modelling.

SAP BusinessObjects and HANA integration, Design document, RFPs, and estimation plans.

Experience with high availability and backup mechanism.

Implementing SAP HANA Security mechanism, HANA XS Application service, and monitoring of HANA system.

GRC Plugins installation on Hana/Fiori/GRC databases.

Backup and restore using Hana studio.

Setting up Disaster recovery for resiliency.

Configured High Availability using Pacemaker SUSE tool for HANA Database and SAP ASCS and ERS systems.

Experience with XSA installation, XSA Backup/Restore and XSA Cockpit, XSA Web IDE Setup.

Experience with XSA upgrade from 82 to 142 version.

Import/Export of HANA Delivery Unit using HANA studio and using CTS+

S4HANA upgrade from 1610 to 1809.

Support SAP HANA Production built in Cloud environment.

SAP Production support for various SAP systems like S4HANA, ECC, SRM, SCM, PI/XI, BODS, SLT, HANA Side Car, GRC, GTS, MDG, Vertex, SAP TREX

Managing Oracle RAC Clustering and managing the Oracle Database for various systems.

Harley-Davidson, WI Jan 18 to July 18

SAP Basis/Change Release Admin

Responsibilities:

Performed System Refresh cloning for Oracle Database, HANA Database, DB2, SQL server from Prod to QA.

Performed Performance tuning on HANA DB for use with Ariba and SAP HCM.

Performed Performance tuning on Oracle Databases in multiple Non-prod and Production systems.

HANA Administration

Used Focused build for S/4 Hana implementation and used test management for testing process.

Involved in S/4 HANA green filed implementation.

Worked on installing and configuring Data Provisioning tools such as SAP SLT, BODS and DXC good understanding of HANA DB performance, HA DR, and scalability.

Built and designed Azure Cloud connectivity between T&L data center and Azure Cloud East, deployed data-provisioning for HANA Analytics, using System Landscape Transformation tool, installed S/4 HANA 1610 FPS1 with SAP FIORI 2.0 front-end Central Hub scenario, and upgraded /4 HANA 1610 FPS1 to SP2.

Setup and maintained Oracle Data Guard for DR systems and periodic DR compliance testing.

Experienced with CTS (Change Transport System) to ensure all transport requests are promoted properly through the landscape to minimize risk and maximize system reliability, availability, and performance.

Leading, planning sizing DMO migration project from technical side for moving ECC 6.0 systems & Portal systems in both N & N+1 landscape from Oracle 11g to Hana 1.0 sp12. Which included ECC 6.0 EHP6 to EHP8 and Portal NW7.4 to 7.5 upgrade as well.

Documented the procedures.

Training users.

Experienced in Redwood Scheduling Jobs in SAP systems& Trouble shooting.

Support Patches Upgrades.

System maintenance activities.

Apply OSS notes, code fixes and resolve end user problems.

Setting Up System Landscape: Configured Transport Management System, Creating the Transport Domain Controller, Include the System into the Domain, Creating Virtual system, creating the Backup Domain Controller, Configuring the Transport Routes.

EP Configuration and Integration between BI/EP to ECC.

SSO Certificates Configuration and Import/Export

SLD Configuration

Gardner Denver, WI Sep 16 to Dec 17

SAP Basis/Hana Admin

Responsibilities:

Generating Early Watch Alerts for all SAP systems from Solution Manager

Applied Support Packages and Kernel upgrade.

HANA system administration using SAP HANA Cockpit and HANA Studio.

Experience in managing users and roles in SAP HANA system.

Implementing SAP HANA Table management techniques - data compression, table partition, compression techniques, and load/unload table into memory.

HANA Installation, Data Provisioning, Admin, Modelling.

SAP BusinessObjects and HANA integration, Design document, RFPs, and estimation plans.

Experience with high availability and backup mechanism.

Implementing SAP HANA Security mechanism, HANA XS Application service, and monitoring of HANA system.

Experience with setting up HANA Cleaner, Consistency checks for Backup Catalog, DB checks.

SAP HANA migration using SUM with DMO option.

SQL Database upgrade from 2016 to 2019

GRC Plugins installation on Hana/Fiori/GRC databases.

Backup and restore using Hana studio.

Setting up Disaster recovery for resiliency.

HANA Revision upgrade 1.0

Experience with configuring file based, Backint backup solutions for Hana.

We Energies, WI Oct 15 to Aug 16

SAP Basis/Hana Admin

Responsibilities:

Applied ST-PI and ST-API Patch upgrade in all SAP Systems

SME Level Technical support and monthly On-Call Rotation.

Leading production support team coaching and mentoring junior basis resource. Creating and updating SOPs for production support and upgrade tasks.

Upgraded SAP ECC 6.0 from EHP 5 to EHP7

Involved in SAP ECC systems migration and upgrade from Oracle DB ECC 6.0 ehp7 to Hana DB ECC 6.0 ehp8 using DMO.

Primary contact for ECC systems troubleshooting, maintenance, and support.

Responsible for performing daily and weekly system health check like Checking Application Servers and Work Process, System log and ABAP Dumps, Backup, Background Jobs, Update and Lock, Performance Monitoring, Table Space, Review database log.

Performed SAP EHP 4 to EHP 6 upgrade (ENHANCEMENT Packages) through SUM tool.

Upgraded PI NW 7.4 dual stack to NW 7.5 and performed mandatory dual stack split.

Applied mandatory HR hot packs in ECC systems.

Performed numerous systems refreshes for ECC, BI and SNC systems.

Installed and configured SLT server, connections and ECC ad-on for Hana live real time replication of table from ECC to BI systems using SLT.

Installed NW 7.4 EP applied ESS/MSS patches and performed post installation configurations like backend UME configuration, ADS, VIM portal etc.

Provided technical support and work on technical requirements for Charm and Retrofit Implementation for N+1 landscape.

Upgraded DMS systems from NW 7.0 to NW 7.5.

Installed and configured SAP TDMS 4.0 system. Performed / Monitored data flow from Production to QA via TDMS.

Installed Success Factors add-ons on ECC systems for success factors integration.

Performed Oracle upgrade from 11g to 12c.

Installed and configured SAP Fiori system on NW 7.5.

Installed and managed Fiori applications for ERP systems.

Worked on Charm and Retrofit configuration on Solution Manager.

Upgraded Central SLD system from NW 7.4 Java only to NW 7.5 Java only and applied periodically CR and CIM content.

Upgraded Hana Database HDB 1.0 sp7 to sp9 and from sp9 to sp11.

Installed and configured Solution Manager 7.1 system.

Upgraded SAP Data Services from 4.1 to 4.2.

Applied support packs on ECC and SNC systems.

Configured technical monitoring for SAP systems in Solution Manager based on MAI.

Performed Oracle Database administration activities like DB Checks, Table space management –Resizing, extending, and adding data files, Creation of Database Indexes, Oracle patching (o-patch & mo-patch), Oracle Client Upgrade.

HP, MI May 15 to Sep15

SAP Basis Admin

Responsibilities:

Worked on SAP NetWeaver Master Data Management 7.1

Integrated with SAP MDM with NetWeaver Portal

Created and executed logical data models for SAP systems and processes.

Developed and managed data architecture standards and operating guidelines.

Designed functional specifications for ABAP requirements, as directed.

Assisted in maintaining functionality and features of SAP MDM applications.

Performed MDM tool analysis and supported MDM solution design.

Compiled reports on functional specifications and business requirements of SAP MDM applications

Upgraded MDM systems SP09 to SP13

MDM DB refresh from Production to Dev and QA systems

Generated MDM DB Views after refresh from Production.

Oracle upgrade from 11.2.0.3 to 11.2.0.4

Department of the Interior (FBMS Federal Project) VA Jan 15 to Apr 15

SAP Basis and uPerform Admin

Responsibilities:

Workload analysis, load distribution, Performance Monitoring, Short dumps, Health checks and fine tuning.

Solution Manager, EWA reports, System Landscape Directory (SLD).

Backups, Recovery, Standby/Failover Administration.

Applying Support packs and Kernel Upgrade.

Generating Solution manager key for the Landscape as required

Installing Web AS Java as add-on.

Download and applying Support Patches and SAP Notes.

DB Reorg, Table space Administration. Monitoring the objects and extents.

Change Management (ITIL), Service Level Agreement (SLA).

Disaster Recovery (DR) plan, Restores, implementation of IRS/SOX Audit Security standards and report generation.

Daily and periodic administrative tasks include monitoring system logs, Work processes.

Transports, locks, updates, spooler, kernels, and patches/support packs.

Client Administration including client copy / export / import / delete.

Performance monitoring, Report Creation, shot dumps, Health checks and fine tuning.

SAP spool configuration. Transports in ABAP and Java Environments (Using STMS, SDM)

Publishing Internal ITS. Managed interfaces with third party tools and new technologies (BOBJ),

Provided 24x7 on-call support on rotation basis and weekend maintenance.

Setup and managed document workflows

Created and configured templates for training team for WSI (Work Statement Instruction)

Integrated Solution Manager and uPerform and created documents or recording in Solution Manager

Developed authoring standards and collaborated with client training Lead to configure End user website.

Performed quality review of all documents.

Published all documents and assigned website context.

Publish all NetWeaver portal documents with the iView IDs to enable context-sensitive help.

Conducted knowledge transfer of perform Administration to System Admin

SYNCREON, MI Mar 13 to Dec 14

SAP Basis Admin

Responsibilities:

Defined and documented technical system requirements and systems management procedures.

Applied Enhancement Packs 6 for ECC

Led different upgrade projects CRM 7.1, PI 7.3, BW 7.3

Upgraded to Solution Manager 7.1

Setup EWA reports in Solution Manager

Was involved in sizing of SAP systems.

Setup MOPZ

Setup SSO for ABAP and JAVA systems

Made changes to SAP profile parameters for better performances.

Involved in workload analysis, system error analysis and establishment of standard Basis background jobs and system health checks and monitoring.

Designed and recommended the client strategies.

Configured Transportation Management system (TMS)

Generating access keys for Objects and Developers.

Applied SAP OSS notes, supported packs and fixes.

Involved in setting up Clients. Performed Client copy and Client Exports.

Configure Java with ABAP Client

Involved in Bobj installation and post configuration.

Upgraded Kernel and Applied Patches –JAVA, ABAP.

Defined and configured RFC destinations.

Configured the STMS after system refresh.

Involved in scheduling backups and archives and restoring data when required.

Performed System Transports DEV to QA and PRD

Daily monitoring activities.

Design Disaster Recovery Plan for Production systems with other teams

Performed System Copies.

Monitored SAP landscape that involves R/3 System and XI system centrally using SM.

Implement the recommendations of early watch report for Solution Manager.

Installed new application servers. Performed homogeneous system copies.

Downloading and applying OSS Notes through SNOTE.

Checking updates and Lock management.

Configured printers, Spool Management and Spool Administration.

ENERGEN/ALGASCO, AL Nov 12 to Feb 13

SAP Basis Admin

Responsibilities:

Supported on call basis issues 24/7.

Performing daily system health checks.

Installation and configuration of BOBJ (XI 3.0, XI 3.1,4.0).

Upgrade BOBJ from 3.1 to 4.0

Integration of BOBJ with the BI and ECC (Java stack) systems.

Implemented file structures and disk layouts to analyze and improve overall SAP performance.

Made changes to SAP profile parameters for better performances.

Involved in workload analysis, system error analysis and establishment of standard Basis background jobs and system health checks and monitoring.

Worked independently and as a part of team and interfaced extensively with clients to gain insight and develop solutions to meet customers’ business needs across the entire Sap landscape.

Created Sap transports and maintaining systems integrity of all Development, Quality and Production instances.

Analyzed, merged, combined, and improved security profiles business roles and positions based on the business needs.

Worked on setting up new profiles for SAP BI/BW Development, Quality and Production instances, developed tested and implemented authorization profiles from business specifications.

Worked on HR security/authorizations.

Provided sound design knowledge of authorizations for security development.

Investigated and solved security related problems to SU53 report.

Worked with internal functional teams for security requirements.

Worked on setting up CTS+, transport management system.

Creating roles and assigning authorizations.

Worked on implementing Workflow related setting and trouble shot Workflow related issues with the functional consultants.

Training the Client Security & Basis administrators as part of knowledge transfer.

SHURE INC, IL Jan 11 to Oct 12

SAP Basis Admin

Responsibilities:

Supporting 24/7 on-call Basis.

Working with day-to-day issues.

Created the troubleshooting documents for support and maintenance of each solution.

Working on Oracle as database and troubleshooting database errors.

Working on system performance tuning and space management.

Made changes to SAP profile parameters for better performances.

Applied database administration knowledge to define efficient and optimal database layout,

Performed daily system health checks, weekly checks, and was responsible for overall system tuning.

Preparing reports for CPU utilization, DB utilization and online users through CCMS RZ20.

Involved in configuring CCMS on Solution Manager.

Working on issues related to Go-live and post Go-live.

Working on Space management through BRTOOLS.

Analyzing long running jobs and SQL statements for better performance.

Configuring Trusted RFC connections.

Monitoring inbound and outbound queues.

Analyzing DB utilization work process.

Switching dialog to Background process when required.

Checking frequently failed system errors SMQ1, SMQ2, SM58, SMW01

Contact this candidate