We provide IT Staff Augmentation Services!

Sap Basis/hana Consultant Resume

5.00/5 (Submit Your Rating)

San Francisco, CA

SUMMARY

  • Over 10+ years of total IT experience as SAP Basis/Netweaver Consultant and 3 years as SAP HANA Architect with core strength in all aspects of SAP systems, databases administration in implementation, production and upgrade phases of a project”
  • SAP Installation: SAP ECC 6 EHP 6/7, SRM, CRM, SCM, E - Recruitment, LiveCache, GRC, GTS, EP, PI/PO, Solution Manager, Redwood CPS, & BW Installation in distributed/High Availability/Cluster environment with Oracle, MaxDB, MS SQL and SAP HANA (scale out environment) on HP-Unix, AIX-Unix, Red Hat Linux, SUSE Linux, & Windows OS.
  • SAP Upgrade: SAP ECC6-EHP6/7, CRM, SRM, SCM, SAP Solution Manager 7.1 and SAP BW upgrade with SUM and performed Unicode conversion and system copy from Oracle to HANA with DMO. Kernel upgrades, support package patch upgrade, Add on installation and upgrade using JSPM, SPAM, SAINT and OSS note implementation.
  • SAP/DB/OS Security: SAP Application security, Oracle, SAP HANA, MaxDB & MS SQL database security, Implemented SAP Security notes, SNC (Secure Network Connection) Configuration, SSO (Single Sign-On) Configuration, CUA (Central User Administration) Configuration, SAP User and Role administration, SSL Configuration, SAP Router and Web Dispatcher security, SAP HANA Data area encryption, database audit policy and password policy configuration.
  • SAP Solution Manager: SAP Solution Manager 7.1 installation, Post installation (ST Upgrade), LMDB, SLD Content update, MOZP, Initial and Basic Configuration, Early Watch Alers, Charm, CTS+ Configuration, Wiley Introscope configuration.
  • SAP BW Upgrade: SAP BW 7.4 upgrade with SUM along with migration from Oracle to SAP HANA DB with DMO (Database Migration Option).
  • SAP Router/Web Dispatcher: SAP Router and Web Dispatcher Installation/Configuration.
  • SAP BO/BI and BODS: SAP Business Objects and SAP Business Objects Data Services installation & administration.
  • SAP HANA: Design and Architecture of SAP HANA DB for High-availability and Disaster recovery, SAP HANA DB Installation and configuration in single and Distributed environments, SAP HANA Transport Management system configuration, SAP HANA DB Upgrade, HANA Client upgrade, SAP HANA Monitoring & performance tuning, SAP HANA Security and auditing, Integration of HANA DB into Solution Manager and registration in SLD, Enable HANA DB tracing, SAP HANA SLT (DMIS 2011 Add-on) Installation and configuration, SAP HANA database (Data+Log) backup configuration with 3rd party tools.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SAP Basis/HANA Consultant

Environment: SAP BW 7.4, SAP HANA SPS08, SAP Solution manager 7.1 - ST12, SAP HANA DR, SAP

Responsibilities:

  • Created project plan for existing SAP BW landscape for upgradation and migration to SAP HANA.
  • Participated in hardware sizing activity for existing SAP BW system. Upgraded and migrated to SAP HANA SPS08 rev 83.
  • Performed test upgrade of SAP BW test system (Prod copy) and migrated to SAP HANA using DMO.
  • Installed SAP HANA database in scale-out environment (9 worker + 2 standby = 11 nodes) for high availability and configured auto host failover. Also installed DR site and configured system replication between 2 sites (Primary and Secondary).
  • Performed actual SAP upgrade for DEV, Consolidation, QA and Performance servers (9 worker + 2 standby = 11 nodes).
  • Setup of Kerberos, SAML for authentication and creation of users, roles and privileges and setting up of audit policies and password policies.
  • Performed Production System upgrade from SAP BW NetWeaver 7.0 EHP3 on oracle to SAP BW NetWeaver 7.4 on SAP HANA SPS08 Database with DMO on IBM X6 hardware.
  • Configured SAP HANA landscape in SAP Solution Manager and DBA Cockpit.
  • Provided post upgrade and go live support for SAP BW on HANA landscape.
  • Upgraded SAP HANA Client to Rev 85 on SAP BW Application Servers to solve some system dumps.
  • Installed SAP HANA support patches & implemented SAP notes at SAP BW application and SAP HANA Database level to fix the issues which we were raised on daily basis.
  • Configured SAP HANA Database with external backup tool (EMC DDBoost).
  • Configured RFC Connection between SAP BW on HANA and SAP Business Object Data Service.
  • Migrated SAP HANA Statistics server to Embedded Statistics Server (ESS).
  • Upgrade SAP BW Application kernel to latest available PL.
  • Performed performance tuning activities at SAP HANA DB level and split big tables into several partitions as recommended by SAP.
  • Provided SAP BW support for infocubes, DSO, process chain, info objects and PSA issues.
  • Performed DR unit testing exercise to test takeover from Primary SAP BW on HANA site to DR Site.
  • Analyzed SAP HANA traces, logs and dumps to troubleshoot SAP HANA DB issues.
  • Worked with OS team to perform various activities on HANA System.
  • Installed SAP SLT and configured it with SAP HANA Database.
  • Trained operations team in supporting McKesson landscape
  • Conducted knowledge transfer sessions on BW HANA support activities

Confidential, Allentown, PA

SAP Basis/HANA Administrator

Environment: SAP ECC 6.0 EHP 6, SAP Netweaver 7.3 EHP 1, SAP NW 7.4, EP 7, BI 7.0 EHP 2, BW 7.3, CRM 7.0 EHP 2, Solution Manager 7.1, SAP BCM, SAP HANA SP6

Responsibilities:

  • Upgrade existing SAP ECC6 to SAP ECC6 EHP7 with SAP Netweaver 7.4, CRM upgrade from 7.0 EHP1 to 7.0 EHP3 with Netweaver 7.4.
  • Design and plan Software and hardware platform landscape architecture for SAP instances and database (MSSQL/HANA) instances, design SAP HANA High Availability and Disaster Recovery architecture for production environment.
  • Performed Installation, setup, configuration of SAP HANA database, SAP HANA studio and SAP HANA client.
  • Implemented SAP HANA security including User Management, Roles, and Privileges.
  • Performed Backup and Recovery.
  • Tuned of HANA DB performance.
  • Supported functional teams and developers in development and enhancement of BW (BI Content) extractors, Generic Datasources, PSA, DTP, InfoObjects, DSO, InfoCubes, process chains which were used for Bex reporting.
  • Upgraded BW 7.0 to BW 7.3 and migrated to BW 7.3 on HANA.
  • Responsible for monitoring and troubleshooting of SAP HANA.
  • Integration between SAP CRM Interaction center and SAP BCM telephony system and performed troubleshooting to resolve various issues related to telephony integration by checking ICI traces, OII logs, CDT logs and HTTPWatch traces.
  • Analyzed CRM, ECC, BI system performance, ABAP short dumps, failed updates, System Logs, helped in resolving end user issues.
  • Performed Kernel upgrades and patch updates.
  • Performed Load Balancing between Application Servers using SAP web dispatcher.
  • Implemented major production break and code fixes and applied OSS notes.
  • Performed client copies and client refreshes, remote Client copies and client transports.
  • Performed system refreshes and system copies.
  • Solution Manager 7.1 installation and support package upgrade with SPAM/SAINT and Java component with JSPM Manager, SLD content (cimsap & CRDelta) upgrade, SAP Early Watch Alerts configuration, Maintenance Optimizer configuration, CTS+ configuration for SAP EP, SAP MII, NWDI and SLD objects.
  • Installed ST-PI and ST-A/PI patches along with SPAM upgrades.
  • Maintained all the system profiles & its parameters in all the systems in the landscape.
  • Performed standard administration and monitoring tasks in a highly critical environment involving users in several countries.
  • Carried out daily the system performance Health checks, System Monitoring, Performance monitoring and did performance tuning.
  • Scheduled and monitored background jobs.

Confidential, Jackson, MI

SAP Basis/HANA Consultant

Environment: SAP ECC 6.0 EHP 5, SAP Netweaver 7.0 EHP 2, SAP NW 7.3, SAP HANA SP 5, EP 7, BI 7.0 EHP 2, CRM 7.0 EHP1, e-recruitment 7.0 Ehp 1, Solution Manager 7.01, SAP GRC 10.0, PPM 5.0, SAP PI 7.1 EHP 1, SAP Redwood CPS 8.0, HP-UX ia64, SLES 11, Oracle 11g, SAP HANA Studio, SAP SLT 1.0.

Responsibilities:

  • Experience in setting up an end to end solution involving different components in SAP HANA Eco System.
  • Performed Installation, configuration, upgrade of SAP HANA database, SAP HANA studio and SAP HANA client. Installed SAP HANA 1.0 SP4 upgraded it to SAP HANA 1.0 SP5.
  • 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 configuringData Provisioning tools such as SAP SLT, BODS and DXC.
  • Configured SLT, BODS (ETL), DXC to connect SAP HANA with SAP systems (SAP ECC & SAP BW source systems) and extracted tables, performed metadata import, schema mapping, loads in the areas of FI, SD, MM, PP-Logistics, HR, and supply chain.
  • Created ETL Batch jobs and Real Time jobs, created standard dataflows, abap dataflows and built transformations in BODS and also used SAP Z program outputs and called Z programs from BODS to load data from SAP ECC to HANA.
  • Implemented SAP HANA security including User Management, Roles, and Privileges.
  • Assisted in creation of HANA artifacts, HANA Attribute, Analytic and Calculation views.
  • Created and maintained delivery units and packages in SAP HANA for import export process.
  • Performed Backup and Recovery.
  • Good understanding of HANA DB performance, HA, DR and scalability.
  • Strong knowledge of BO reporting tools (Analysis for Office) for reporting, query and analysis purposes and integrating them with SAP HANA.
  • Deployed RDS (Rapid Deployment Solutions) packages for Management Reporting, COPA accelerator and supported developers and Data Modelers for performance and data access requirements.
  • Monitored the usage of system resources and performance while the applications are running and HANA Cubes (views) are being consumed by the BO Tools and did performance tuning and optimized them.
  • Responsible for monitoring and troubleshooting of SAP HANA.
  • Installed SAP Redwood CPS 8.0 and performed administrative tasks.
  • Installed license and configured various sap systems with CPS, managed users and roles and assigned users to isolation groups, configured notification and alerting.
  • Created, scheduled and submitted job definitions and job chains and monitored them using job monitor.
  • Involved in release process, ECC 6.0 EHP5 upgrade process.
  • Performed kernel upgrade, database upgrade, and support package upgrade in all SAP modules.
  • Administration of SLD and PI.
  • Set transport routes for NWDI for Java, created tracks and replicated the tracks.
  • Change coordinator from Basis stream, coordinated with functional stream for production changes.
  • Analyzed ECC, BW system performance, ABAP short dumps, failed updates, System Logs and did performance tuning of BI system.
  • Implemented code fixes, applied OSS notes and did system refreshes.
  • Performed daily activities involving System Monitoring, Database monitoring and OS Monitoring and scheduled Health checks and did troubleshooting and resolved end user issues.
  • Provided on-call support during system outages and crisis, with focus on immediate resolution and root-cause analysis (RCA).

Confidential, San Diego, CA

SAP Basis/NetWeaver Administrator

Environment: SAP ECC 6.0 EHP 4, SAP Netweaver 7.3, EP 7, BI 7.02, SRM 7.0, CRM 7.0, SCM 7.0, TREX, Solution Manager 7.0 EHP1, SAP Virsa GRC 5.3, IBM iSeries 5500, AIX 5.3, AIX 6.1, Oracle 10g.

Responsibilities:

  • Installed, configured and supported NetWeaver EP 7.0, KM, TREX and Adobe Document services on Oracle 10.2.0.2.
  • Made use of JSPM for applying Kernel, Portal and Java patches.
  • Installed SAP Netweaver Web-AS Java 7.3 and upgraded the SAP REDWOOD CPS package to M33.27 stack.
  • Involved in Portal Administration by creating users, assigning roles, setting up the page preferences by personalizing the page content.
  • Configured Single Sign On (SSO) to the SAP ECC and BW systems. Also configured portal security using the logon tickets for SSO.
  • Created portal pages and populated the pages with customized iViews that retrieve information from heterogeneous data sources and branded the portal according to client’s requirements.
  • Performed setup of ESS/MSS Business Package using JSPM and connectivity to KM and TREX.
  • Created required PCD objects, customized and created WebDynpro content in ESS and MSS according to the customer requirements. Also deployed various par file fixes according to Sap notes.
  • Configured the user management engine (UME) to use an LDAP directory as the data source.
  • Trouble shooting of SAP heart beat problem under SAP JDI landscape.
  • Performed an Optimized solution for SAP Batch Job Administration and monitoring by integrating SAP Redwood with SAP solution Manager.
  • Automated SAP batch jobs Escalations from failed and long running jobs using Redwood CPS.
  • Implemented CRM to support customer related processes end to end.
  • Installed and Configured SAP Solution Manger 7.0 on AIX 5.3 with database Oracle 10g for implementing Live support through Service Desk, Change Request Management and Central System Monitoring of the whole Landscape.
  • Connected all Systems in landscape to Solution Manager 7.0 and Installed Support Packs (Maintenance Optimizer) on all the systems in the Landscape.
  • Configured and scheduled the dynamic sessions for EarlyWatch alert reports through SDCCN in Solution manager.
  • Performed Kernel upgrades and patches updates as the system was unable to start after upgrading the kernel by logging on with SAPNet (OSS) and then installed .dll files again.
  • System monitoring of the SCM landscape including LiveCache monitoring, LiveCache Management.
  • Performed technical upgrade of APO 3.1 systems to SCM 7.0 & applied support package level 8.
  • Manually pushed IDOC’s between production servers.
  • Performed Unicode conversions and solved code page issues.
  • Installed the New languages for SAP systems and Configuring/Setting the system for Translation and Supplementation of the languages in the system.
  • Performed SPACE statistics using latest BRTOOLS 640.
  • Performed Archiving with the help of SAP Archive Development Kit (ADK) by making use of transaction SARA.
  • Updated SPAM/SAINT v7.00 from patch level 20 to 24.
  • Configured remote printers using Putty and Smitty tool and involved in troubleshooting printer issues.
  • Assisted in installing SAP Virsa GRC tools, involves SAP Virsa GRC 5.1 installation and configuration Upgrade to SAP Virsa GRC 5.3.
  • Extensive experience in configuring Profile Generator and user menus for each profile by Using SAP supplied user role templates and Virsa Access Enforcer and Virsa Firefighter for assigning profiles to end-users.
  • Applied CATT Scripts for Mass user creation and maintenance.
  • Worked on User Roles, Profiles and Authorizations.
  • Performed SAP OS Migration from AIX 5.3 to AIX 6.1. Complete landscape was migrated keeping the database at the same oracle 10.2 level. NW 7.3, SCM, SRM, ECC, BW, GRC, CRM, Solution Manager.
  • Created and tested the efficiency of logon groups and load balancing.
  • Performed system Health checks as scheduled.
  • Supported SAPGUI front-end installation and solved problems related to it.
  • Involved in User/developer support including troubleshooting, transports, OSS administration, and user maintenance.
  • Created Vantive tickets for Network and Storage team in order to restore the Production access issues.
  • Made use of Accelerated SAP (ASAP) tool which makes the transformation easier.

Confidential, Kalama, WA

SAP BASIS Administrator

Environment: SAP ECC 6.0 EHP 3, SAP NetWeaver 7.0, PI 7.0, SAP BW 7.0, SCM 2007, CRM 2007, EP 7.0, Solution Manager 7.0 EHP1, SAP CPS Redwood M28.07, HP-UX 11.23, Oracle 10g.

Responsibilities:

  • Installed Solution Manager 7.0 EHP1 and configured all the satellite systems for centralized system administration and monitoring.
  • Worked on customizing using Solution Manager to drive configuration activities in target systems and created new systems and logical components in it.
  • Outlined high-level overview of SAP Solution Manager (CHARM) with its strategy, benefits and scenarios such as Implementation and Customizing Distribution, Service Desk, Solution Monitoring, Service Delivery.
  • Performed the installation of CPS Redwood scheduler on a Netweaver landscape and integrated with ABAP stack by installing the add-on BC-XBP interface.
  • Maintained the RFC and proper user authorizations between the CPS redwood and solution manager.
  • Performed the job interception to extract the current production jobs from ECC and schedule them in CPS and automated the job administration from Redwood.
  • Involved in configuring SAP BW in order to support Open Hub Services which enables delivery of high quality audited enterprise information to applications through web services.
  • Extensively worked on performance tuning of BW for smooth functioning of data warehouse.
  • Installed SAP IPC server system and established connection with the SAP CRM Server.
  • Tuned the SCM system and LiveCache according to the recommendations of SAP.
  • Involved in upgrade of EP 7.0 by applying support pack 19.
  • Created and maintained RFC destinations between various systems.
  • Involved in installation and configuration of Exchange Infrastructure (XI).
  • Worked on XI system scenarios, analysis, mapping definitions and migration of environment and configuration.
  • Experience with Java and ABAP mappings while creating and mapping inbound/outbound interfaces in ID of XI.
  • Monitored ECC system with CCMS daily and Upgraded Support packs using transaction SPAM from SAP services.
  • Worked with team on Data Mapping for conversion of Legacy system into SAP.
  • Performed client administration activities including creating clients, client copy (local and remote), deleting clients and assigning logical systems to clients.
  • Performed security administration in SAP ECC, EP such as creating users assigning roles, composite profiles and authorizations, mass user maintenance.
  • Carried out the post installation activities like configuring STMS, kernel upgrade, Plug-ins upgrade applying the support packs, defining operation modes on central SLD, ECC.
  • Resolved portal performance issues by taking java thread dumps using JCMON and analyzing the dump files to resolve the performance issues.
  • Responsible for troubleshooting issues, applying OSS notes and patches, adjusted profile parameters to optimize the performance of the target system.
  • Ran BRTOOLS 640 for Database Management for displaying character based interface.
  • Performed Database Administration, Table space administration, adding data file, archive log, extended Table spaces, Buffering Table, Backed up Database and Offline Archive logs
  • Designed and modified the existing Data Recovery strategy by testing various backup and recovery scenarios.
  • Performed system refresh, homogeneous system copy.
  • Performed daily activities involving System Monitoring, Database Monitoring and OS Monitoring.
  • Imported and maintained all system profiles.
  • Monitored the OS related performance problems and scheduled and monitored background jobs.

Confidential, Moonachie NJ

SAP BASIS Administrator

Environment:SAP NW 7.0, SAP ECC 6.0 EHP2, SAP Solution Manager 7 EHP1, SAP BW 7.0, Oracle 10g, IBM-AIX 5.1, Windows 2003.

Responsibilities:

  • Applied Support packs for R/3 and BW landscape.
  • Involved in the post installation activities.
  • Created client copies according to the business requirement.
  • Configured Transport management system for ECC landscape (DEV, QAS and PRD).
  • Set up Central CCMS monitoring capability on SAP Solution Manager System for different systems and set up alerts through auto-reaction method.
  • Generated the EWA for all SAP systems from SAP Solution Manager.
  • Configured and executed SAP change control functions including the transport management system, ABAP workbench organizer and customizing organizer.
  • Extended TMS support, authorization management, STMS transport rules for customizing and self-defined objects and troubleshooting.
  • Maintained all the system profiles in development and production systems.
  • Performed Client copies, Client refresh and Client exports.
  • Apply OSS Notes and PATCHES required for Profile Generator as a pre- and post-up-gradation maintenance using SPAM and SAINT.
  • Maintained all the instance profiles in development and production systems.
  • Scheduled jobs in the background to clean up spool requests, dumps, batch-input sessions, background jobs.
  • Automated mail Alerts.
  • Spool Management and resolve printer issues and printing problems.
  • Checked CPU utilization and volume space utilization.
  • Performed daily SAP System checks and logs.

Confidential, IN

SAP BASIS & Security Administrator

Environment: SAP R/3 4.7, ECC 6.0, SAP Solution manager 7.0, Windows 2003 Server-Enterprise Edition, Oracle 10.2.0.1

Responsibilities:

  • Administered and supported the SAP Production, QAS and Development systems in a 24x7 Oracle environment with ECC6.0.
  • Setup CCMS, NWA & Earlywatch environment in solution manager & configure the complete landscape.
  • Involved in all Database activities like Database restore, system copy for ECC systems.
  • Applied kernel patches, Oracle patches (CPU, merge) in all kind of Environments.
  • Setup Change control management (CCM) in solution manager.
  • Worked on setting up Solution Manager diagnostics(SMD) & Netweaver Administrator(NWA) in
  • Solution manager & their interlinking.
  • Worked on setting up central SLD on Solution Manager.
  • Involved in Stack Upgrade activities in ECC/BI/PI environments.
  • Moved Transport requests from Development to Quality and production using Transport Management System.
  • Maintain User and System administration for SAP systems. Providing support and troubleshooting SAP Servers.
  • Tested and implemented security recommendations given by SAP audit team
  • Assisted the audit team for SOD & SOX compliance.
  • Scheduled and monitored background jobs.
  • Performed client operations such as client copy, export and import.
  • Monitored alerts and ABAP short dumps using System Administration.
  • Maintained the system profiles, used developer trace files/ABAP short dumps for troubleshooting problems.
  • Monitored SAP buffers, analyzed workload of SAP.
  • Worked with Tivoli to help ensure the availability and performance of your business-critical applications.
  • Checked CPU utilization and volume space utilization for performance analysis.
  • Daily administrative tasks include monitoring system logs, Work processes, locks and updates.

Confidential, Raleigh, NC

SAP BASIS Support and Implementation

Environment: SAP R/3 4.7, SAP ERP 2004, Solution Manager 3.2, Windows 2003 Server-Enterprise Edition, Oracle 10g

Responsibilities:

  • Involved in all Basis activities to deliver on time.
  • Performed System Copy & Database restore.
  • Involved in upgrading Solution Manager to 7.0 version
  • Performed Oracle Patchset upgrade.
  • Performing Client Copies like Local Client Copy, Remote Client Copy and Client Export and Import.
  • User Administration like Creating Users, Deleting Users.
  • Assigning Roles to Users and Performing User Comparison
  • Background administration like scheduling background jobs and analyzing jobs.
  • Applying Support Packages through SPAM.
  • Performing Kernel Up gradation.
  • Defining Operation Modes and assigning Time intervals to Operation modes.
  • Management of Table Space Allocation Using BR TOOLS.
  • Downloading and applying Notes through SNOTE.
  • Applying Java patch using SDM and JSPM.
  • Applied Oracle Patches from 10.2.0.2 to 10.2.0.5.
  • Performed System Refresh & Restore.
  • Worked on Config tool and Visual admin tool in java stack.

We'd love your feedback!