Sap Hana/Basis

Marco Alan I. Pimentel

`

Address: Blk * Lot * New Guinea St. Annex 25 Alsea Homes Paranaque

Metro Manila Philippines

Mobile: +639*********

Email: *************@*****.***

Professional Summary

A Senior SAP BASIS with more than 9 years of experience with various SAP implementations on different platforms. Solid experience in SAP system administration, DB & OS Administration (DB), Server Administration and Management. Has extensive experience on different OS platforms such as Unix (AIX, HP-UX), Linux (SuSE, REDHAT) and Windows platform and DBA on Informix, DB2, Oracle, MS SQL, and SAP HANA

SAP BASIS Skills

Application

4.6c & d, 4.7, ECC 6.0 (EHP5-8), CRM, SRM, BW 3.5/7.0/7.3/7.4/7.5 (ABAP and JAVA/Portal), BW/4 HANA, BO 4.1/4.2 SP5, BPC 10.1, SLT, SAP HR, POSCAR, FIORI, GRC 10.0/10.1, Webdispatcher, ESS/MSS, Solution Manager, XI, Solution Manager 7.0/7.1/7.2, SAPROUTER

Upgrade SAP Systems

SAP R/3 4.7 to SAP ERP EHP6

SAP R/3 4.6C to SAP ERP EHP6

Database

DB2 9.1, 9.5, 9.7, 10.1 and 10.5, Oracle 10g/11g/12c, HANA 1.0 SPS12, 2.0 SPS00 - SPS03, SQL 2005/2008/2012, SYBASE, MaxDB, Informix.

Operating System

Windows Server (NT, 2000, 2003, 20008, 2012), IBM AIX (6.1 & 7.1), Linux (SUSE, RHEL, CentOS), HP-UX

Backup Utility

Netvault, Legato Networker

Others

Server Installation (Rack and Stack), Server Administration and Troubleshooting (IBM Power Systems, HP, IBM Xseries), Virtual Machines (Hyper-V, VMware)

HMC administration and configuration (LPAR, Dynamic Resource Management, etc.)

Experience on OS installation/configuration/hardening on different platforms (Windows, AIX/Linux, VIOs, etc.), administration and configuration.

Storage migration from EMC CX3/CZ4 to VNX5300/VNX5400

Cluster Configuration and Management (DB2-HADR, AIX HACMP, Oracle Clusterware, HANA System Replication)

Solarwinds

Network Troubleshooting.

Professional Experience

The Dairy Farm Company, Limited - ROHQ Pasig City, Philippines

SAP Specialist - Senior BASIS/HANA Administrator August 2017 – Present

DUTIES AND RESPONSIBILITIES:

–Provides 24x7 support for BASIS and manage Dairy Farm SAP systems, N+1 environment (ECC FICO, Retail, POSDM, POSCAR, BW on HANA, BW4HANA, Portal, BO/BI, DS, XI, SLT, FIORI, GRC, Solution Manager) including Development, QAs, Failover/DR, and Production.

–GRC 10.0/10.1 full cycle implementation (Dev and Production), sizing, installation, configuration (ARA, EAM, ARM, and BRM) and integration of backend clients.

–FIORI installation and configuration, user authorization build.

–SLT installation, configuration/setup, troubleshooting, etc.

–HANA transport, views export/import.

–HANA Administration Tasks like table distribution and partitioning, delta merge and compression, unload/load table, alerts, trace, backup and restore, etc

–HANA Live content installation.

–HANA installation, patching/revision update, system rename, server migration, conversion to MDC, etc.

–HANA System Replication configuration and setup.

–HANA Cockpit 2.0 installtion, update and configuration.

–HANA security administration and troubleshooting

–FIORI full cycle project implementation, sizing, installation, patching, configuration, post implementation and performance tuning.

–FIORI authorization and security implementation/setup both FE and BE.

–Mass user and role creation.

–BI 4.2 SP5 patch with additional server for apache load balancer and server workload distribution via server group.

–BI Performance tuning, analysis and troubleshooting. Importing BI/BOBJ transports.

–Work closely with other teams to identify improvement opportunities and improve efficiency to all systems, primarily Production servers with SAPs TPO and BPPO quality check services.

–Solman setup and configuration (CUA, EWA, SLD/LMDB, System Prep/Basic Configuration, Managed System, TechMon, DVM, CHARM, Wily Introscope, CTS+, HANA CTS+ etc.), SMD Agent installation/configuration

–SAP XI performance tuning and configuration via configtool/NWA. Analysis and troubleshooting via monitoring tools.

–BW4 HANA table replication SLT, ODP-SLT, HANA SDI, etc.

–BASIS Administration Tasks, System Refresh both ABAP and JAVA stack (system copy, backup/restore), Client Copy (Local, Remote, Export/Import), New Client, Client Deletion and maintain client settings, Operation Modes/Load Balancing, Workload/Performance Tuning, License Administration, installation and configuration of SAPRouter, STMS, Table reorg, update stats/runstats, Printer setup, Language installation, others.

–Identify and provide analysis on ways to improve performance through housekeeping of standard tables and business transactions based on agreed retention period, Configuration and setup of Data Archiving thru SARA.

–OSS user access administration, maintain system data/connection, license, keys, PAM, etc.

–Work with Audit to remediate various aspects in terms of security (Role Remediation, Excessive Access), recommended system parameter, SOD based on GRC rule set for ARA.

Project Involvements

January 2019 - March 2019 - POSCAR and HANA 2.0 installation

New project for a new landscape release for DF Singapore.

Responsible for installation of new POSCAR Production Environment via System Copy - Backup and Restore.

Server Migration of HANA DBs - installation of new HANA on the new server as old server will be repurposed, then backup/restore.

Configure system replication (primary - secondary) async mode.

October 2018 - January 2019 - FIORI 2.0 Full Cycle Project Implementation

Provide contributions on sizing and design

Responsible for installation, post implementation, configuration on Dev/QAs and on a distributed system Pre-Production and Production.

Responsible for design and implementation of authorization in FIORI FE (PFCG role, Catalog and Group) and ECC Backend in coordination with Functional Team.

Installation of SSL Certificate, Theme Logo, etc.

June – August 2018 – GRC 10.1 Full Cycle Project Implementation

Responsible for sizing, installation and configuration, post implementation of two-tiered system landscape (Dev-Prod) GRC 10.1 on SAP Netweaver 7.52/Oracle 12.1 RAC on ASM on a distributed system with ASCS/ERS running on HA Oracle Clusterware

ARA, EAM, BRM, and ARM configuration and integration to managed systems.

May - June 2018 - BW Patch Update from SPS6 to SPS18

Establish a guideline/strategy/timeline on BW patch update

Perform the BW patch update on Sandbox,Dev/QAs/PreProd and Production.

SAP BASIS –Analyst Programmer August 2016 – August 2017

DUTIES AND RESPONSIBILITIES:

–Provides 24x7 support for BASIS and manage Dairy Farm SAP systems, N+1 environment (ECC FICO, Retail, POSDM, BW on HANA, Portal, BO/DS, XI, Solution Manager) including Development, QAs, Failover/DR, and Production.

–Oracle Clusterware Administration.

–HANA DB administration, Security/User Administration, Hana Backup/Restore.

–Troubleshooting on various issues (IDOC interface, BW Process Chain, Memory Management)

–Performs Health check of SAP R/3 System by Monitored performance tuning, load on processor and Memory bottlenecks etc.

–Management of Transport Request (N+1 Landscape)

–Perform, configure, creation CHARM activities, EWA in Solution Manager, Wily Introscope

–Perform User Management, Security Management, Authorization Build, Creation, Troubleshooting, Support, CUA administration, LSMW.

–Perform Client Copy, Database Refresh and TDMS activities.

–Installation of Patches, Kernel upgrade, SAP service tools - Add-ons, etc.

–System tuning, performance, workload and configuration management.

–User Authorization Build and Troubleshooting.

–Sizing

Project Involvements

September – November 2016 – Retail/FICO Project – Singapore Roll-out

-Responsible for project support involving various task from user authorization, system sizing, client-copy/TDMS activities and others.

-Monitors and provides technical support to Functional and ABAP consultants.

December – May 2017 – Retail/FICO Project – Malaysia Roll-out

-Onsite Cut-over/Go-Live support involving various task from user authorization/creation/assignment, system sizing, client-copy/tdms activities and others.

San Miguel IT Systems, Inc. (SMITS, Inc.)

A subsidiary of San Miguel Corporations.

Ortigas, Pasig City

SAP BASIS Specialist Lead January 2016 – August 2016

DUTIES AND RESPONSIBILITIES:

–BASIS Lead for San Miguel FOOD Group (BPC, GRC, ECC, BW, Solman, and others)

–Provides 24x7 support for BASIS lvl 1 & lvl 2 and manage assigned SMC SAP systems including Development, QAs, Failover/DR, and Production.

–Performs Health check of SAP R/3 System by Monitored performance tuning, load on processor and Memory bottlenecks etc

Tasks and Responsibilities

–SAP implementations

–SAP version upgrades

–SAP OS/DB migrations

–Server sizing

–Capacity management, Storage Maintenance and Migration.

–System architecture and landscape design

–System tuning and configuration management

SAP BASIS Administrator - Level 2 October 2011 – December 2015

DUTIES AND RESPONSIBILITIES:

–Bare-metal installation (OS, DB, SAP ASCS/ERS, Application Servers) including Server Setup (Server racking and stacking/DC transfer, Network, SCSI, HMC, Tape Drive – LTO5, etc.)

–Provides 24x7 - 2nd level support and manage assigned SMC SAP systems including Development, QAs, Failover/DR, and Production.

–Performs Health check of SAP R/3 System by Monitored performance tuning, load on processor and Memory bottlenecks etc

–Administers Scheduled Database Backup, TAPE backup (LTO 3, LTO 5 - mksysb)

–Monitor activities like system status, analyzing system logs, system traces, ABAP dumps, SAP System Buffers and Database Buffers, workload analysis, problem analysis and resolution and other activities required to maintain system uptime.

–Provide level 2 technical support to assigned ERP Systems (DEV/QAS and FO systems)

–Perform system administration activities on SAP ERP/B1 systems, Operating Systems, Database Systems and server hardware

–Perform System monitoring, performance and workload analysis

–Provide 2nd level troubleshooting and root-cause analysis

–Analyze ABAP short dumps and update errors

–Analyze system and security logs

–Coordinate with SAP enterprise support via the SAP Service Marketplace

–Execute and management of Backup & Restore procedures

–Perform storage extensions, upgrades

–Perform database consistency checks and corrections

–Application of Support Packages and kernel patches

–Perform SAP, OS, DB Installations

–Initiate requests and perform application of SAP license keys

–Perform SAP system copies (homogeneous and heterogeneous)

–Set up of the STMS/correction and transport system

–Perform disaster recovery procedures, database restore on DB2, ORACLE and INFORMIX.

–Preparation of monthly server performance and capacity reports

–Keeps track of database performance that involves extending table space sizes and reorganizing tables/indexes when needed.

–Provides technical support to BAP (Basis Admin Pool) and SAP functional areas like Developers and users.

–Performed various installations and configurations (Solution Manager 7.1, ECC 6.0, SAP Netweaver, BI 4.1, Personas, FIORI, PERSONAS, SAPROUTER, TREX, etc.)

–Knowledgeable in user role maintenance.

SAP BASIS Administrator - Level 1 April 2011 – October 2011

DUTIES AND RESPONSIBILITIES:

- Responsible to monitor and escalate (if necessary) all SAP related performance & availability issues, backup problems, etc. to SMITS ESTS Level 2 and Technical Leads.

- Perform EWA Report Analysis.

- Perform external SAP B1 installation projects.

Project Involvements

August – November 2015 - SMC SAP BPC implementation

-responsible for installation and configuration of SAP BPC (DEV, QAS and PROD)

-Monitors and provides technical support to Functional and ABAP consultants.

May – June 2015 - Server Migration/upgrade for EAGLE Cement Corporation

-Installation of Windows Server 2012

-Upgrade DB2 version from 9.1 to 10.1

-Responsible for installation (system copy) and configuration of SAP ERP (DEV, QAS, DR and PROD).

-Responsible for DB2 HADR implementation and management.

-Responsible for installation and configuration of SAP Solution Manager 7.1

-Monitors/provides technical support for any concerns. DB Backup/Restore.

-Been handling client BASIS support for more than 4 years.

February - April 2015 - San Miguel Purefoods Corporation (SMPFC) SAP server migration from

IBM Power750 to Power8.

- ASCS/CI/DB, ERS, 8 Unix application servers, 1 Windows application server

- Assisted in the installation and configuration of VIO server

- Assisted in the installation and configuration on AIX 7.1 for all LPARs

- OS Patch, Post installation configuration, Network configuration.

- OS image backup.

- HMC management and administration.

- HACMP installation, configuration and implementation.

May – September 2014 – SMC SAP GRC implementation

- Responsible for installation and configuration of SAP GRC Access Control 10.0 - 2-Tier landscape (DEV, PROD). Integration of backend systems.

May – July 2014 – SMC HR PBA implementation

- ECC 6.0 EHP6, DB2 10.5 (DEV, QAS/FO, PROD)

October 2011 – May 2012 – SMC SMPFC Project Cybertron SAP implementation

- Harmonized different SAP instances into a single SAP system.

- ERP 6.0 EHP5 - High-Availability setup (HACMP), CI/DB, ERS instance.

- SAP BW 7.3 (ABAP and JAVA)

Other SAP Upgrade:

Upgrade SAP 4.7 to ERP 6 EHP 6 (w/ Unicode conversion)

Upgrade DB2 9.7 to 10.5

IT Group, Incorporated July 2010 – October 2010

ERP Intern

Worked as an intern for the ERP Department. Task is to update and create a technical user’s manual for the ERP/CRM systems made for clients.

Assisted in pc troubleshoot, networking, OS installation, helpdesk support.

Assisted in SQL scripting and crystal reports.

TELUS International Philippines July 2007 – May 2008

Technical Support Representative (IT)– Dell Spare Parts (US)

Troubleshoot any issue regarding computer problems. Network connectivity, Application, Server Monitoring and OS installation, Hardware and software troubleshooting, etc.

Sales Representative

Accomplishment/Certification

SAP HANA WPHADM Training Certificate SAP/KAISA Phil March 2018

HANA 2.0 SPS 00

* HA100 - SAP HANA 2.0 Introduction

* HA200 - SAP HANA 2.0 Operations and Administration

* HA240 - SAP HANA 2.0 Authorization, Security and Scenarios

* HA250 - SAP HANA 2.0 Migration to SAP HANA using DMO

Performed migration from Sybase to HANA 2.0

Trainings

1. BW/4 HANA Dairy Farm May 2019

2. SAP Business Object Administration Dairy Farm December 2018

3. SAP FIORI Dairy Farm October 2018

4. SAP HANA Workshop SAP Philippines August 2015

5. SAP SM100 SAP Philippines September 10-14, 2012

6. SAP ADM100 SMITS, Inc. June 2011

7. SAP Business One Installation Training SMITS, Inc. September 2011

OPEN SAP Online Training Certificate

1. System Conversion to SAP S/4 HANA OPEN SAP March 2019

2. Introduction to SAP HANA Administration OPEN SAP Nov 2017

Educational Background

College Bachelor of Science in Computer Engineering

Don Bosco Technical College - Mandaluyong City Philippines

Contact this candidate