Sap Hana Sr Consultant Resume
5.00/5 (Submit Your Rating)
Irvine, CA
SUMMARY:
- More than 8+ years of experience managing SAP Business Suite productsinfrastructure.
- Experience in business processes, change management following the best practices from SAP.
- Participating on complex projects, including installation, Migrations, system copies and Upgrades on SAP products like (ECC,PI,PORTAL,BW,BPC,BO,DATASERVICES,CRM,SOLUTION MANAGER,FIORI,WEB DISPATCHER, SCM, GRC, SMP MOBILE HANA, SLT, SAP ARIBA, SAP SUCCESS FACTORS.
- Hand on experience and understanding of HANA architecture.
- Ability to lead small technical groups to reach objectives following SLA and Business processes to server the customer.
- SAP security and authorizations including Hana security.
TECHNICAL SKILLS:
Operating Systems: Windows 2012/2008/IBM AIX, LINUX Redhat 7.4 and SUSE 11
Database: MS SQL Server 2008/2012, Oracle 10g,11g,12g MAXDB, HANA 1.0
SAP PRODUCTS VERSIONS: SAP ECC 6.0, Enterprise Portals 7.31.7.4,7.5, BW 7.4 SAP Netweaver7.5, Solution Manager 7.1,7.2 BO 4.1, 4.2, PI 7.5, Gateway 7.4, HANA 1.0
Packages: MS Office Word, Excel, PowerPoint, Visio, Projects
HANA SKILLS:
- Data Provisioning, SLT, SDA,SDI
- Installation SP 08, SP09, SP10, SP11,SP12, Updates
- Migrations from Oracle to HANA ECC, BPC, Hybris Products
- Hight availability (system replication, FailOver, storage replication
- Export/Import
- System copies
- Backup/restores
- Performance Tuning
- Multitenant instances
- Single and Distribute instances
- SQL
- Sizing scale up and scale out.
PROFESSIONAL EXPERIENCE:
Confidential, Irvine, CA
SAP HANA SR CONSULTANT
Responsibilities:
- Worked onInstalling Sap Hana on Cloud infrastructure, working with INFRASTUCTURE team to define SIZING (CPU, MEMORY, DISK) according with the requirement of Hybris application needs to run Hana.
- Defined High Availability (system replication) on PRD instances
- Worked Performing prerequisites on Oracle side such a getting the size of tables, count of tables, define lob segments size.
- Worked on Installing DPA agents on oracle, register deploy oracle adapter
- Set up Smart Data Source connection to hana
- Worked on Creating users and its schemas to perform migration trough SDI
- Worked Creating virtual tables
- Worked on Creating Init schema to compare and adjust data types supporting on hana
- Worked on Migrating Data from Oracle to hana trough SDI
- Performed on Post migration activities, define row count, generate indexes trough the hac
- Performed on ResettingDataHub connector on App nodes to be connected with a hana instance
- Performed on Adding string on HAC on DataHub to connect with SAP transfer Idocs.
- Performed on Leading technically hana side the migration project plan with each client (adjusting timeline, effort to perform, guiding the customer trough all the project migration since POC, DEV, STG and PRD.
- Worded on Troubleshooting errors on Hybris and Hana
- Advised customer to adjust some parameters that can help to the performance on HANA.
- Resolvedhana alerts
- Working Supporting errors on hana during the test of the customer
- Performed Go lives support to the customer like (Linea Directa, Textron, Gelighting, Mabe, Pepsico, Hershey’s, bridgestone,Palacio de hierro, Whirpool, Liverpool, Aristotle, Yandbal, until the customer get stable.
Confidential
SAP HANA/BASIS CONSULTANT
Responsibilities:
- Lead Technically Db Migration/Sap Upgrade internal customer project from Oracle to HANA ECC product through DMO following best practices from SAP
- Lead Technically DB Migration/Sap Upgrade internal customer project from Oracle to Hana GRC product through DMO following best practices from SAP
- Prepared prerequisites on Oracle side, perform Oracle upgrade from 10g to 11g, getting db size table on oracle side.
- Performed system copy on oracle from Production to build systems to migrate
- Preparedhana instance on multitenant environment, sizing hana instance (CPU,MEMORY,DISK) according to the requirements for each SAP product.
- Worked on Readiness check on LINUX OS level to agree hanarequirements.
- Performed System replication on HANA to set up High availability on PRD instances
- Worked on Configuration Solution Manager to connect to the ECC product,
- Set up data migration trough DMO and upgrade from EHP 6 to EHP 8
- Worked on Troubleshooting errors during migration on DB and App.
- Performed Post migration activities
- Adjusted Hana parameters recommended by SAP to perform a better performance
- Adjustedhana backups on daily basis
- Worked on Following timelines to deliver migration on time to the customer.
- Worked on readiness check post migration on DB size
- Supported SLT configuration connecting ECC on oracle db to hanadb to replicate tables presenting on BI reports.
- Installed on SLT patches upgrade
- Worked on Troubleshooting SLT errors on ECC side
- Set up SLT configuration after system copies on ECC side
- Monitored SLT and supported alerts on it
- Performed troubleshooting on SLT hana instance side.
- Worked on Hana upgrade from SP 9 to 12 on APP BO
- Worked on export/import hanadb trough sapinst, building hanadb
- Performed hana system copies using Backup/restore method and using copy data/log method.
- Installing hana instances in a multitenant environments to connect BPC from SAP Business SUITE.
- Worked on adjustedhdbuserstore on hana OS level to connect APP from hana.
- Set up db connections through dB cockpit on APP side
- Performed performance tuning on HANA DB connected to SAP BPC, adjusted memory parameters to increase performance
- Worked on hanaos level side to change system password
- Detected bottlenecks memory issues on OS level and resolving adjusting parameters of configuration on HANA OS level.
- Monitored hana instances to avoid issues.
- Set up configuration on HANA STUDIO to send alerts through email.
- Scaled up Hana instances connected to SAP BPC adjusting, memory, cpu, disk
- Resolved hana alerts performing the best practices from SAP.
- Resolved sql code issues on hanaanalizingsql traces
- Resolved issues on authorizations on HANA db
- Worked on promoting ibp tasks trough Hana Cloud Integration
- Worked on HANA connected to BW using scale out hana instances.
- Set up table unload and load once necessary
- Set up table distribution through portioning hash, round robin techniques.
- Worked on PI installation landscape, performing after installation Support package upgrade
- Worked on SAP portal installation landscape then performing Support Packages Upgraders.
- Worked on SAP Fiori implementation including install, setup and configuration.Worked on implementing Fiori apps such as Approve purchase order, manager approval and GRC apps.
- Worked on SAP WEBDISPATCHER configuration to access SMP MOBILE, FIORI, PORTAL including set up of certificate, connection on DMZ and moving outside the network.
- SAP solution 7.1 installation.
- Executed connection of SAP SUCCESS FACTORS ON BOOMI to ECC connect trough web services
- Executed installation on SAP ARIBA on ECC then installed some keys trough OS level to get the connection available.
- Upgraded CPS(Redwood) product on sap Netweaver performing a migration from Windows server 2008 to Windows server 2012 on db MSQL 2012.
- Performed set up connection on Redwood to different hosts on SAP.
- Worked on Troubleshooting on Redwood application jobs
- Worked on installation S/4 hana landscape
Confidential
SAP BASIS CONSULTANT
Responsibilities:
- Performed Database Administration, Table space Administration, archive log, Checking Oracle trace file, log file for troubleshooting.
- Performed client copies local and export/import
- Performed post client copies activities
- Monitoring of the complete R/3 System, Buffers, Database, Work processes, Instances, Workload.
- Worked on system copies homogenies from Oracle, MAXDB.
- Performed pre and post activities on homogenies system copies
- Installed Support package update
- Performed kernel installation, update and upgrade
- Monitored alerts from SAP systems
- Daily activity tasks such as transports trough STMS, Schedule new jobs, apply sap notes
- Worked on troubleshooting performance Issues
- Daily Monitored on some important tcodes on SAP to discard any issue, sm21,sm12,st22,sm50,sm51
- Configured STMS for the landscape
- Monitored DB space on Oracle, MaxDB, MSQL.
- Set up RFC’s configuration to connect with external systems.
