Sr.sap Hana Administrator Resume
2.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY:
- Seasoned SAP HANA ADMINISTRATION and Basis consultant with over 5 years.
- Have in depth Knowledge of SAP HANA Architecture and understanding of SAP HANA landscape components.
- Worked Closely with SAP Technical team on implementing customer projects on HANA and involved in support and monitoring activities post go - live.
- Extensive knowledge in workload analysis, performance tuning, Memory management and capacity management, Expensive SQL Analysis, memory dump analysis.
- Experience in monitoring, tuning and troubleshooting of BW and HANA system.
- Experience in HANA system administration using SAP HANA Cockpit and HANA Studio.
- Experience in Data Volume management like analyzing the tables and to find the scope for archiving, Housekeeping, Reorganizing and shrinking.
- Experience in implementing SAP HANA Table management techniques - data compression techniques, table partition, and load/unload table into memory.
- Experience in system copy, sap note analysis and its implementation.
- Supported during system migration, DB refresh and system refresh activities.
- Worked on components like ECC, BW, MDG, NLS, Solution manager on OS platforms like Linux, AIX, Windows and Databases like Oracle and HANA.
- Installed and configured SAP Router for GRC systems which are maintained in Azure.
- Automation of starting GRC systems at OS level.
- Involved in business discussion. Analyzed and Proposed Landscape virtual management implementation to the client.
- Experience Client administration including client creation, client copy, and client deletion.
- Day to day monitoring of the system, including but not limited to dump analysis, job’s runtime and termination, system log review, space utilization, stuck trfc’s.
- Support for SAP Basis incidents.
- Job and batch processing management - both initial creation and maintenance.
- Security management - definition of technical roles; creation and maintenance of user roles and technical roles
- SAP Sybase IQ and Microsoft SQL database understanding and/or experience.
- Ability to meet deadlines and handle multiple tasks, flexible in work schedules and effective team player with good communication skills.
AREA OF KNOWLEDGE:
- Strong understanding in SAP R/3 Architecture.
- Setting up the system landscape with configuring the TMS and creating the domain controller, backup domain controller and creating the systems into domain.
- Configuration and distribution TMS configuration.
- Profile parameter maintenance.
- Applying support packages using ABAP (SPAM).
- Applying add-on plug in using SAINT.
- Applying SAPLICENSE for both (ABAP+JAVA) and (Standalone JAVA) systems.
- Taking both Online, Offline backups for the SAP Systems with BR*TOOLS.
- BR tools related activities like table space administration and extending the table space.
- Creating and maintaining roles using profile generator tool.
- SAP performance statistics collection and performance tuning.
- Create logical system and assign logical systems to the clients.
- Workload analysis and performance tuning - memory management, buffer synchronization.
- User Management like User Creation, deletion of user, users locks.
- Analyzing of missing authorizations and assigning Roles to users.
- Profile maintenance through PFCG.
- Creating derived and composite roles with proper approvals.
- Role maintenances and creating transport request for roles.
- Configured Operation Modes and Profile parameters maintenance.
- Setup CCMS monitoring.
WORK EXPERIENCE:
Confidential
Sr.SAP HANA Administrator
Environment: HANA (1.00.122.10.1496218861 ), SUSE Linux Enterprise Server 11.4, SAP BW 750, ECC 6.0, Oracle 11.2.0.4., SAP Portal, ECC,NLS.
Responsibilities:
- Monitoring, tuning and troubleshooting of BW and HANA systems.
- Created interactive KPI metrics dashboard to anticipate trends and future growth from SAP HANA Cockpit and HANA Studio.
- Perform Data Volume management like analyzing the tables to find the scope for archiving, Housekeeping, Reorganizing and shrinking.
- Implementing SAP HANA Table management techniques - data compression techniques, table partition, and load/unload table into memory.
- Capacity Planning and Sizing the landscape.
- Housekeeping of PSA/CL tables in SAP BW by following the data retention strategy and archiving of BW admin tables to save the space.
- Row store reorganization and column store defragmentation (reclaiming of data volume space).
- Analyzing the data generated by EWA report to proactively detect and diagnose the performance problems in application, Database as well as OS.
- Supported during system migration and HANA DB Upgrade.
- Provided support to project teams throughout establishment cycles.
- Interacting in partnership with client and other vendors.
- Supported process improvements to continuously improve the stability and performance of applications.
- Create Wily Health Check Dashboards for all the upstream and downstream systems.
- Mentored, Coached, Trained and managed resources in improving the technical skills.
Confidential
SAP HANA Administrator
Environment: HANA (1.00.122.10.1496218861 ), SUSE Linux Enterprise Server 11.4, SAP BW 750, ECC 6.0, Oracle 11.2.0.4.
Responsibilities:
- Monitoring, tuning and troubleshooting of BW and HANA systems.
- Created interactive KPI metrics dashboard to anticipate trends and future growth from SAP HANA Cockpit and HANA Studio.
- Perform Data Volume management like analyzing the tables to find the scope for archiving, Housekeeping, Reorganizing and shrinking.
- Implementing SAP HANA Table management techniques - data compression techniques, table partition, and load/unload table into memory.
- Sizing the landscape.
- Housekeeping of PSA/CL tables in SAP BW and archiving of BW admin tables to save the space.
- Row store reorganization and column store defragmentation (reclaiming of data volume space).
- Analyzing the data generated by EWA report to proactively detect and diagnose the performance problems in application, Database as well as OS.
- Supported during system migration and HANA DB Upgrade.
- Provided support to project teams throughout establishment cycles.
- Interacting in partnership with client and other vendors.
- Supported process improvements to continuously improve the stability and performance of applications.
- Create Wily Health Check Dashboards for all the upstream and downstream systems.
Confidential
SAP NetWeaver consultant
Environment: ECC 6.0, Solution manager 7.0, MDG, GRC, Oracle, Linux.
Responsibilities:
- Installed and configured SAP Router for GRC systems which are maintained in Azure.
- Performed Service transition from Development to support and identified system bottlenecks and opportunities for betterment.
- Automation of starting GRC systems at OS level.
- Scheduling batch jobs and housekeeping jobs.
- Support during System and DB Refresh activity.
- Handled Printer related issues.
- Configuring printers and monitoring spool requests.
- Opening (https, R/3support) connection to SAP using OSS message and maintaining the user credentials.
- Applying Snotes & opening client.
- Back-ground job analysis and checking cancelled job’s complete analysis of auto job’s which are running in system.
- Content server administration and troubleshooting.
- Providing developer access key and object key.
- RFC connections set up.
- SAP performance statistics collection and performance tuning.
- Experience in mail configuration using SOST.
- Responding to Daily tickets and monitoring ticketing tool (Service Now).
- Monthly maintenance activities.
- Responsible for daily monitoring of the R/3 servers, Work processes, File system, RFC connections.
- SAP Security issues, user profile and role management.
- Daily analysing of ABAP dumps, System logs, Lock Entries, work processes, Spool data.
- Monitoring Background jobs, re-scheduling, cancelling long running jobs.
- Moving transport requests through STMS and OS level as per the client requests.
- Activating Business functions, Inbound and outbound configurations.
- Performed pre and post installation activities for the system landscape.
- Strong knowledge on service market place to download the various support packages, reporting error messages to SAP and generating license keys.
- Involved in business discussion and Proposed Landscape virtual management implementation to the client.
- User creation, assigning roles and profiles, extending the validity of the user.
- Assigning missing authorization using SU53 screenshots.