Sap Hana Architect Resume Profile
NJ
Summary
- Overall 12 years experience in the areas of SAP HANA Administration, OS/DB Migrations, Upgrades, Database Upgrades, Administration, Designing, Unicode Migration, Sizing and effective implementation of SAP System Landscape
- Experienced with SAP HANA SYSTEM Replication for two different sites, tested takeover and failback
- Implemented SAP HANA SPS07 for SAP BW 7.4, Sizing of ECC EHP7 for HANA and BW Systems
- Implemented SAP BPC 10.0 for SAP HANA SPS7 and integrated BW for BPC
- Experienced with SAP HANA SP7 Scale Up, MASTER and SLAVE Nodes Config and Tracing, Indexes rebuild, Licenses installation and Disaster recovery
- Assisted BW DSO Conversions, BW Issues on HANA, DMO Migration of SAP BW 7.3 to SAP BW 7.4 on SAP HANA SPS07
- SAP HANA Backup and Recovery, HANA Column Store Views, HANA ROW Store to COLUMN Store Conversions
- Team Lead for SAP Basis On-Site and Offshore for SAP ECC Upgrade, GTS Upgrade, Architected OS/DB Migration Project
- Implementation of Large Scale TREX 7.10/7.20 with MASTER/SLAVE Configuration
- Installed and Upgraded SAP ECC 6.0, EHP 6, BI 7.3, PI 7.3, GTS 7.02 and 7.3, SRM 7.0, TREX 7.20, Solution Manager 7.1 on Windows, Unix, Linux Environments
- Upgraded SAP ECC EHP's using SUM Tool, EHPi Installer for Older Versions
- Experienced with setting up Solution Manager for SAP Monitoring, CCMS Alerts, CHARM, E2E RCA, Early Watch Alerts, Configured SMD Agents for non-HA and HA Environments
- Experienced with SAP Systems in HA Environment such as VERITAS Clustering for AIX, Microsoft Windows Clustering for Windows and SQL Server Environments
- Disaster Recovery Exercise for SQL Server 2012 using DR Scripts, SAP HANA failed over to secondary DR site and failed back to Primary DR Site
- Experience with Database Administration of Oracle, SQL Server, SAP HANA SCALE Up
- Handled various Operating Systems such as SUSE Linux, REDHAT, HP-UX, Windows, IBM AIX on VMWare and Virtual Machines
- Experienced with Sizing landscape using SAP Quick Sizer tool, working with HP's SIZING tool and scaling the Hardware, Network and Database, considering SAP Best Practices
- Expert in Performance tuning, analyzing System bottlenecks and production support
Technical Expertise
- ERP: SAP ECC 6.06, Netweaver 7.31, Portal 7.31, PI/XI 7.31
- Solution Manager 7.1, SRM 7.0, ERP Suite, E-Recruiting
- Database Administration: Oracle 10x, 11x, SQL SERVER 2008 2012, SAP HANA
- Operating Systems: HP UX IA 64, PA-RISC, Windows NT/2000-2003 server/XP,
- DOS, Linux, Sun Solaris, IBM-AIX
- Add-On's: Vistex, OpenText, BSI Tax Factory
Professional Experience:
Confidential
Role: SAP HANA Architect
Responsibilities:
- Implemented SAP BW 7.4 on HANA SPS 7 and handled the HANA and BW 7.4 Issues
- SAP HANA SPS Upgrades, Maintenance revision updates and applying Licenses and Memory Configuration
- Tested SAP HANA SYSTEM Replication, Installed SAP HANA SPS80 and SPS82 on SUSE Linux 11 SP3
- OS/DB Migration of SAP BW 7.31 to SAP BW 7.4 on HANA using DMO Option and optimized overall export/import time
- Installed and configured SAP BPC 10 for HANA SPS7 and integrated BW for BPC reports
- Installed and configured SAP BOBJ for SAP HANA and SAP BW and supported reporting issues
- Production Support for SAP HANA, Day to Day Memory Monitoring, moving Tables from One Index Server to different Index Server
- Working with SAP Support for BW 7.4 Implementation Issues, HANA issues and upcoming Versions
- OS DB Migration of BW 7.31 to BW 7.4 on HANA using DMO option and used the Table Splitting and Package Splitting features for better conversion
- Post Upgrade Issues for BW 7.4 HANA in terms of DSO Conversion, Infocube HANA Optimization
- Reporting issues on HANA SPS 7, ROW Store to COLUMN Store Conversion and applied Stat Service Memory parameters
- Production Support for SAP GTS, ECC, BW, SRM and CRM Systems on DB2 Database
- Rebuild of SAP GTS TREX Indexes, PLM and HCM Indexes for Embedded Search
- TREX Issues for GTS, ECC, HCM and PLM on day to day basis
- HANA BOBJ Issues for Report Server Issues, Report Rendering Issues and Memory Hog Issues
- ECC Load Balancing Issues, ECC RFC and SMQ Issues and ECC Sizing for HANA POC
- Majorly Performance Tuning, System Builds, HANA and BW Combination issues and Ticket Handling on Day to Day Basis
Environment: HANA SPS 7, BW 7.3 to 7.4 Migration, GTS, ECC, HCM, LSO, PLM, TREX, Sizing, POC HANA, Performance Tuning, SAP BOBJ, BPC
Confidential
Role: SR SAP Basis HANA Administrator
Responsibilities:
- Installed and Configured SAP HANA SPS 7 for BOBJ and BW 7.31 on Linux
- Sizing and Scaling SAP HANA for SAP BW and Installed Solman Agents
- Migration of RHEL 5.8 to 6.3 and Migrated SAP Kernel and SAP Systems to newer Linux Machines
- Installed of SAP BOBJ 4.1, configured storage, OLAP Connections to BW System and configured SAP Security
- Handled the Post Migration Activity and created Project Plan for the rest of the systems
- Worked on Project Plans for SAP GTS, ECC EHP7 and Integrated SAP Solution Manager
- System Builds, System Refreshes for SAP ECC, BW, GTS and Exported Java for Refresh SYNC reasons
- Sizing of Production Landscape, resized Extended Memory and worked with Adding Cores to HP UX Machines
- Worked on SAP Production Support Activities such as Transports, System Copies and handling production support tickets.
- Handled SAP Portal Issues, NWDI Transport Issues and supported Portal ESS and MSS Issues
- Rebuild the required SAP BW Accelerator Indexes and Supported SAP BW Issues using RSMO, RSPCM, LBWQ, LBWG and SMQ1/2
- Performance Tuning of SAP BW 7.3, Info cube Partitioning, Parallel Processing of BW process
Environment: SAP ECC, BW, Portal, HANA, SRM, GTS, Solution Manager, Windows and HP UX
Confidential
Role: SAP Upgrade Basis Team Lead
Responsibilities:
- POC of SAP HANA for BW 7.31, sizing, DMO for Migration from Oracle
- SAP HANA SPS5 installations and configuration of memory Parameters for POC
- Installed Solman Agents on SAP HAN Database Servers and configured EWA for HANA
- Handled SAP BW Upgrade issues, Connectivity issues and worked with BW Developer Team for repairing Info Cubes, ODS Objects and Reporting Performance
- Migrated SAP Portal NWDI workspaces and implemented SAP ESS and MSS for Netweaver 7.31
- Created Project Plan, Project Timeline, Budget plan and execution steps for the Upgrades
- Generated Solution Manager Stack XML file for ECC, GTS Upgrades and upgraded CIM and CR Content to correct Product definition issues
- Upgraded SAP ECC EHP3 to EHP6 on Netweaver 7.03 on AIX, Oracle 11g, VERITAS Clustering, Linux Application Servers
- Upgraded SAP GTS 7.2 to 10, Upgraded TREX Revision Packages with AIX, Oracle 11g, VERITAS Clustering, Linux Application Servers
- Archived GTS SPLAUD Audit Log Tables for improving the XPRA's Performance during the Upgrade
- Created Dual Landscape for the sake of Upgrade, created Production Transport path
- Supported HP Quality Center Defects logged by Application and Development Team
- Minimized the downtime by Archiving, Updating Stat, using ICNV for the identified Tables
- Handled SGEN Modes for the GTS and ECC Upgrades, skipped SGEN when needed
- Updated ESR Content for Netweaver PI and worked with Developers to change the release from EHP3 to EHP6
- Upgraded SAP Kernel to 721 EXT as per SAP's Upgrade recommendations
- Worked with Add-on Products like Vistex, OpenText Invoice Management, High Radius etc. and Skipped Add-on's during the Upgrade
- Upgraded Vistex from 60A to 60E using 2 step approach and handled custom program modules
- Upgraded Oracle from 11.2.0.2 to 11.2.0.3 and applied latest SBP's as per SAP's recommendation
- Reduced the XPRA's execution time, overall Downtime for the Upgrade by sizing the Work process distribution, Tablespace sizing and bumping the Cores of the App Server
Environment: SAP HANA, SAP ECC EHP6, Portal 7.31, SAP GTS 10, Solman 7.1, Oracle 11g, AIX, Linux, Vertias Clustering, Kernel 721, TREX 720, SAP HANA
Confidential
Role: ECC EHP6 Upgrade, E-Rec, TREX Architect
Responsibilities:
- Upgraded SAP ECC, BW to 7.31 on SQL 2012, Windows 2012
- Implemented SAP Portal 7.30 on Windows and SQL Platform and Integrated Sharepoint Portal to SAP Portal
- Implemented SAP ESS and MSS for SAP Portal and SAP HR as backend System
- Disaster Recovery of SAP Systems, SQL 2012 DB's using DR Scripts, Fail Over and Fail back from Primary DR Site with Secondary DR Site.
- E-Recruiting Refresh, TREX Refresh, Index Maintenance of SES Indexes using TREX Admin tool and SAP TREX Admin tool
- Created additional SAP Systems using Munging Script, refreshed SAP Data with Production backups as requested by Clients
- Production Support for SAP ECC, BW, SCM-APO, Live Cache, Solution Manager, E-Recruiting, TREX
- Database Administration of SQL Server 2012, AlwaysOn, Clustering, DB Mirroring and handling the SQL issues
- Monitored DB Mirroring Instances, AlwaysON Instances, Cluster Instances
- Test and Sand Box Refreshes from Production, Windows and SQL Patching on Monthly basis
- Implementation of Currency Conversion for ECC, worked with SAP for Performance Tuning after Go-live
- Sizing of SAP Systems using the Test results from PerfMon, HP Load Runner and worked with Microsoft's Internal SQL Team for Sizing SQL Server
- Support for SAP BW Data loads, E-Recruiting Search Issues, TREX Issues and Live Cache Issues on Day to Day Basis
- Supported BOP Jobs for SCM Live Cache Implementation and administered the Live Cache Connection issues
- Worked on Solman Setup and Integration of Satellite Systems and implemented Solman Work Centers
- Applied Windows Updates, SQL Hotfixes on DEV, Test, Production Systems Quarterly
- Applied SAP Support Packs Quarterly Releases, followed N-6 rule before applying
Environment: SAP ECC, BW, TREX, LiveCache, SCM, E-Recruiting, SQL Server 2012, Windows 2012, Solution Manager 7.1
Confidential
Role: SAP Performance, Netweaver Architect
Responsibilities:
- Upgrading SAP Portal and BW 7.02 to 7.3 using SAPUp and worked on eliminating Upgrade Issues
- Applied SAP Support Packs on Portal, BW 7.31 and ECC EHP4 and worked on SPAU and SPDD
- Migration of SAP ECC, BW, SRM, PI from 2003 to 2008 R2.
- Performance tuning of BW, SRM and ECC Systems and applying the Best Practices
- Database Administration of SQL Server and Oracle, Partitioning, Compression and Index Reorgs as needed
- Worked on SAP ECC, BW, SRM, E-Recruiting and Solution Manager in the areas of Performance and System Stability
- Worked on Re-Indexing E-Recruiting and TREX and speed up the processing of Indexing Documents
- Worked on New FPN Functionality between Portal, BW and Portal, resolved the New FPN Federated Portal issues with P4 Communication
- Client Copies, creation of GOLD client, TDMS handling of Data between 2 systems in the landscape
- Worked on Performance for ECC, Table Stats, Re-Indexing, SQL Tuning and Program Tuning from ABAP and DB level
- Worked on BW backend Tuning, BW System Tuning by adapting the SAP recommended Parameters
- Worked on J2EE JVM installation on all the J2EE Systems
- Implemented SAP Solman 7.1 EHP1 and connected Satellite Systems.
- Implemented SAP BW Accelerator and worked on Re-Indexing
Environment: SAP ECC EHP 4, E-Recruiting, BI 7.31, Portal 7.31, SAP Web Dispatcher, Windows 2003/2008, VMWare, SAP Solution Manager 7.1, SAP SRM SRM-SUS
Confidential
Role: Migration Lead, Netweaver and Solution Manager Architect
Responsibilities:
- Migration of SAP ECC 6.0 from HP-UX to SUSE Linux 11 SP2 using R3load Method
- Mitigated Migration Issues using SAP Best Practices and worked on new user Provision after Migration
- Used Table Splitting, Package Splitting and Parallel R3load process to speed up import and Export
- VMWare Administration of Linux and Windows and tweaked VM Performance bases on SAP Recommendations
- Administration of SAP BOBJ 4.0 and XI 3.1, applied BOBJ Patches and worked on Security
- Implemented SAP Solution Manager 7.1 SP6 for CEN Monitoring, Wily Dashboards and EWA Alert Reports
- Implemented SAP ESS and MSS Business Packages for Netweaver Portal 7.02 on Linux Machine
- Applied Portal Support Packs and worked on NWDI Configuration and Administration
- Architected SAP Portal 7.02 for External Facing Portal and Implemented SAP ESS and MSS Configurations
- Applied SAP HR ECC 6.0 EHP4 Support Packages and worked on SPAU and SPDD Configuration
- Implemented Oracle 11g RMAN, ASM and OEM and Monitored them using SOlman 7.1
- Worked on SAP Portal Theme Editor, Transporting Portal Packages, assigning User roles and backend Profiles
- Created NWDI DEV, QAS, Consolidation and Production Environment and Administered the CBS and CMS on NWDI Console
- Linux Administration for provisioning Disks using Practitioner, adding and removing HOT CPU and Memory and Updating required Libraries
- Handling Error Scenarios of R3load, creating new backup strategy for Oracle with RMAN
- Architect for the landscape like position of Central SLD, Portal Clustering, Sizing using Quick Sizer tool
- Upgrade Oracle 10.2.0.4 to 11.2.0.2 using DBUA, updated DB Stats as post upgrade step
- Worked with SAP Security for Creating Users for SAP ESS and MSS Landscapes
- Configured Solution Manager 7.1 for Early Watch Alerts for all the systems including Portal, MDM, SRM Specific KPI's were also produced in the report
- Integration of LDAP to SAP ECC and Portal and implemented SPNEgo for Portal
Environment: SAP ECC 6.0 EHP4,Portal, SRM, BW, Solution Manager 7.1, Oracle 10g, 11g, ASM, RMAN, HP-UX, SUSE Linux 11, VMWare, BOBJ 4.0, XI 3.1
Confidential
Role: Netweaver Architect
- Day to Day Administration of SAP Portal, BW and ECC Systems on HP-UX and Windows Environments
- Integrated BW reports into Portal iView's and assisted Portal Developers for everyday Issues
- Performance tuning, data volume management of Large tables in SAP ECC and BW, and creating additional indexes on tables as needed
- Implemented BW Accelerator, tweaked BW Accelerator Performance
- Prod support of BW data loads, System Copies, using ZGold to create client copies, Query tuning as needed
- Applied EHP4 on ECC 6.0 using EHPI and resolved the installation issues
- Added Portal Server Nodes to cluster the portal, installed EHP1 for Netweaver Portal 7.0 on HP-UX machine
- Implemented Web-BEX Portal configuration and debugged all the remote view related issues
- Applied SAP Enterprise Portal EH1 to EHP2 7.02 latest patch and applied MDM Support packs
- Implemented reduced downtime on Pre-Prod systems and tested the Database after upgrade
- Upgraded Oracle 10g database to 11.2.01 using DBUA and applied SBP patch using MOPatch utility
- System build and performance tuning of SAP Portal 7.02 EHP2, SAP SRM 7.01, SAP MDM 7.1 SP05 and SAP ECC 6.0 EHP4
- Performance testing of QA landscape using HP Load runner and troubles hooted the issues.
- Configured SAP Solution Manager according Business requirements
- Preparation of DEV/QAS Systems for ECC 6.0 EHP4 Upgrade.
- Activated and Published SAP Internet Transaction Server services using SICF and ran the program SIAC to publish all the relevant programs
- Activated Solution Manager for SAP Service Preparation, MOPZ, License Mgmt, EWA's of ABAP and J2EE
- Upgrade SAP Portal from 7.0 SP 21 to 7.02 EHp2 using Enhancement pack installer
- Applied SAP ABAP and J2EE Support packs in all the DEV and QAS Systems
Environment: SAP ECC 6.0 EHP4, BI, Portal, Solution Manager 7.01 and Oracle 11.2.0.1, SAP BI 7.0, SAP BO XI 3.1
Confidential
Role: SAP Basis Netweaver Consultant
Responsibilities:
- Implemented SAP ECC 6 EHP 3, E-Recruiting, BI, Portal, PI, SRM, SRM SUS, CUA and Supported the landscape for Finance, HR and pay roll Go-Lives
- Installed and Configured SAP E-Recruit along with TREX, SRM , BI, Portal on MS SQL Server 2005
- Federated SAP BI with Portal for Web Queries and implemented SSL for External facing Portal
- Tweaked the performance of ECC and BI systems for large user logins and tweaked the ABAP and J2EE memory parameters
- Customized SAP SRM 5.0 and SRM SUS 5.0, supported External Bid Invitations, SRM Shopping Carts, Sourcing Cockpit issues
- Integrated SAP E-Recruiting and SAP SRM with TREX and managed indexing issues
- Installed and configured SAP Solution Manager EHP1, implemented Wily EM, SMD and Wily agents, CHARM, Maintenance Optimizer, CCMS Automatic Email monitoring from Satellite Systems in the event of Alert, LVSM Tool and TDMS.
- Configured and maintained TDMS in Solution Manager and created client copies in DEV
- Everyday user counts, Systems CPU Utilization counts were updated in an Excel Sheet and supplied it to Senior Management for review
- Activated SAP SRM VMC using SM52 transaction, addressed SRM Sourcing Cockpit and Shopping Cart issues by working with power users
- Revised the landscape by adding more app servers, reviewed the SAP Early watch report on daily basis to ensure smooth running of SAP Systems
- Introduced F5 load balancer for SAP External facing Portal, managed incoming connections by adding more J2EE nodes, addressed Web Dynpro and Web GUI issues when the user is out of Network.
- Worked on System and Client copies on quarterly basis and tested the systems for any data corruptions
- Addressed Network issues associated with VMWare and Windows in distributed installation by installing niping and wireshark third party tools
- Installed and configured ESS and MSS, supported HR and Finance iViews for power users
Environment: SAP ECC EHP 3, E-Recruiting, PI EHP1, BI EHP1, Portal EHP1, SAP Web Dispatcher, Windows 2003/2008, VMWare, SAP Solution Manager EHP1, SAP SRM SRM-SUS