Sap Hana Basis Consultant

Summary

*+ years of IT Experience out of which *+ years of experience in SAP Basis / Security / Net Weaver Architecture and 3+ years as SAP HANA Administrator

Technical expert for SAP HANA projects, responsible for activities for full cycle upgrades, performance and regression tests, sizing, SQL optimizations, SAP HANA Modeling Tuning

SAP HANA security including SAP HANA database security and SAP Net weaver Identity Management 7.2 SP3, SAP HANA user account creation / maintenance, assigning security roles /passwords, ETL based replication, nesting of roles for principal access

SAP HANA administration task, configuring the administration console, adding systems to system landscape, changing parameter values, configuring systems user management, user provisioning, creating changing roles/ users, monitoring backup systems, accessing systems behind a firewall

SAP Net Weaver products implementation: Excellent experience and understanding of Net weaver 2004s /2004, EP 7.0/6.0, PI/XI 7.1/3.0, BI 7.0, SAP BW 3.5 with J2EE add-in and NWDI/Adobe Document Server

SAP New Dimensional products implementation: Experience with installation and maintenance My SAP Business suite 2005/2004, ECC 6.0/5.0, WAS 7.00/6.40/6.20, SCM/APO 5.0/4.0, Live Cache, CRM 5.0/4.0, SRM (EBP) 5.0, SAP R/3 4.7 EE SR1, SAP R/3 4.6 B/C, Solution Manager 4.0/3.0 installation, administration and Upgrade.

Planned, Coordinated, and executed technical Upgrade from SAP R/34.7C system to ECC 6.0 on Oracle database

In-depth knowledge of Business processes, System designing, Screen designing and Report layouts

Involved in 3 complete full Life cycle implementations of ERP, Quick Sizing and ASAP methodology

Expertise in SAP Basis administration including Client Administration, Change Request Management, Transport Management System (STMS), Upgrade, Applying Support Packages on both ABAP and Java Stacks

Memory management and Parameter adjustments for Database, Operating Systems, SAP application servers, SAP applications (SQL statement, Programs).

Intensively worked on Trouble shooting System problems, Performance tuning, Workload Analysis and Database Administration

Certification and Trainings

SAP Hana HA100 – Training Completed

SAP Hana HA200 – Training Completed

SAP HANA Certified Technology Associate – HANA

Education

Chicago State University (2010-2013)

Bachelor of Health Sciences with Honors

Technical Skills

ERP : My SAP Business suite 2005/2004, SAP Net weaver 2004s/04, ECC 7.0/6.0, BI 7.0, BW 3.5, CRM 5.0/4.0, PI/XI 7.1/3.0, EP 7.0/6.0, SRM (EBP) 5.0, SCM 5.0 and Live Cache.

Ticketing tools : Peregrine, Star team 2006, HP Open view.

Backup Tools : VERITAS, Netback up,

Operating Systems : Red Hat LINUX, HP UNIX, IBM AIX, SUN SOLARIS WINDOWS 2008

Languages : C, C++, JAVA, ABAP.

Databases : SAP HANA1.0, Oracle 8i/9i/10g/11, MS SQL Server 2008, DB2 UDB.

Experience

Lexia infotech

Project 1: SAP Hana Basis Consultant (Aug 2013 – Present)

Experienced in SAP HANA 1.0, SPS07, SP08 Installation, Implementation and Administration of SAP HANA database

Experienced in Managing application running on SAP HANA platform and end to end Hana Road Map

Migrated BW and CRM to Hana Database using DMO option in SUM Tool

Experienced in Implementing Backup and Recovery, System Copy, Upgrade of the SAP HANA database, DR strategy, defining DB audit policies, Export & Import, Performance Tuning etc.

Experienced in configuring and Implementing SAP Hana Distributed system (SAP Hana Scaling)

Implemented SAP HANA Security using design time security role concept.

Installed and configured SAP Lumira on SAP HANA, also done the security roles setup for project and end users.

Involved in Business discussions and writing the Technical documentation.

Configured data replication with SAP Landscape Transformation (SLT)

Experienced in administration and troubleshooting of SAP HANA database using SAP HANA studio and DBA Cockpit, Starting / Stopping of SAP HANA, Backup & Recovery

Managing SAP HANA License, Managing SAP HANA users and monitoring system.

Troubleshooting in SAP HANA including SAP HANA tracing.

SAP HANA planning, sizing, implementation, installation, Upgrade and Migration

Managing SAP HANA Cluster, Scale up and Scale out appliance, Database fine-tuning

Controlling Access to SAP HANA Server, SAP HANA User and Role Management, Password Policy, End Clients Administration and Technical database Users

Secure SUSE Linux OS level by implementing OS level security for SAP HANA

Knowledge with SAP HANA configuration integration familiarity with Business Objects reporting suite

Experience in creating, modifying different SAP HANA Audit policy via SAP HANA studio

SAP HANA Data storage security, Data Volume Encryption, Internal Communication Channels, Communication of Hosts in a Distributed Scenario, Security of Application Servers and data Provisioning

Installed and configured Enterprise Portal 7.3 with different usage types

Configure solution manager scenarios CHARM, Business process monitoring, technical monitoring and testing

Use SAP Implementation tools to scope businesses based on RUNSAP methodology, define corresponding blueprints; develop and maintain Implementation and Template Projects.

Integrate SAP Solution Manager as a part of central monitoring infrastructure.

Installed and configured SMD agents for Solution manager 7.1 throughout the landscape

Set up Technical Monitoring through Solution Manager

Configuration of Maintenance optimizer, Early watch alerts

SCM Live Cache Upgrade from 7.0.9.18 to 7.0.9.21

E-Recruiting erex Upgrade from version 7.10.48.00 to 7.10.58.00

SQL upgrade / RTM install from version 2008 r2 to 2012 r2 and 2014

Upgrade B.W Net weaver7.0.1 EHP1 to BW7.3 ABAP and portals

Installed and Configured BOBJ 4.1

Installed and configured ESS/ MSS on Portal.

Configured SSO with BW and ECC as backend

Installed Enhancement Packages, Support Package Stacks on ABAP and Java Stack instances using EHPI installer, SUM, SPAM/SAINT and JSPM and utilized SDM tool for major patches

Configured Data base Mirroring in SQL 2012

Project 2: SAP Basis Administrator (May 2012 – Jul 2013)

Installation and configuration of ECC 6.0 EPH4, EP 7.0, BI 7.0 EHP1, PI 7.1 EHP1, Solman 7.0 EHP1 in central and distributed environment

Implemented ChaRM, Solution Manager Diagnostics (SMD) and Business Process Monitoring

Configured Winshuttle application with SAP

Configured Data Service Application

Configuration of IVIEWS for SAP logon clients through Portal

Installation and configuration of Web Dispatcher

Maintenance of SAP License for both ABAP and JAVA.

Configuration of SAP CCMS agents in the entire landscape

Configured and maintaining the systems at SAP Service Market place

Reviewed the SAP Safeguarding team reports before the GO-LIVE and implemented the required changes as on suggested by SAP

Applied SAP notes depending on the requirement, created logical systems and RFC connections

Configured maintenance optimizer in the Solution Manager

Client Management Oracle 10.2 Installations, patchsets and applying oracle patches.

Tuning Oracle parameters as on required

Written monitoring scripts, backup scripts, statistics scripts and scripts to automate to avoid the manual activities and scheduled in the cron with email notifications

Project 3: SAP Security Administrator (Sep 2011 – May 2012)

Participated in meetings to update functional team and business owners on resolving security issues and redesigning of the roles

Prepared detailed project plan to clean up existing security risks, SOD violations and excessive authorizations to users

Used PA30 transaction in HR to view info types, employee related data

Used PA20, PA40 and PA70 transactions for maintenance of HR records

Used SUIM and table browsers, SE16 & SE16N to pull reports on users, roles and analyze them

Also performed user comparison, role comparisons with in clients and across systems

Involved in setting Clients, Performed Client Copy and Clients Exports

Used PFCG in creating single roles, composite roles and derived roles

Troubleshoot Authorization Errors analyzing SU53 and tracing in ST01 Performed reconciliation of user.

Created authorization groups in SE54 to and assigned in S_TABU_DIS to restrict table access

Analyzed and classified SAP Users for SAP Licensing issue using USMM and SU01

Used SU10, Scripts and Bolt-Ons for mass creation of IDs in systems.

Maintained check indicators for authorization objects in Transaction SU24

Refined roles based on test scenarios

Created different types of users such as Dialog, Systems, Service Users

Maintained user administration using Central User Administration

Worked closely with Audit team for SAP Security Audit

Worked with process experts for creating Matrices

Created and assigned roles to Positions using the PD Authorizations

Project 4: IT Security Analyst (Jun 2010 – Aug 2011)

User / Role maintenance

Monitor the organization’s networks for security breaches and investigate a violation when one occurs

Install and use software, such as firewalls and data encryption programs, to protect sensitive information

Prepare reports that document security breaches and the extent of the damage caused by the breaches

Research the latest information technology (IT) security trends

Help plan and carry out an organization’s way of handling security

Develop security standards and best practices for the organization

Balance service and cost for the supply chain organization while meeting or exceeding key performance indicators.

Documenting service failures that impact the customer and the organization.

Work collaboratively with the following departments: Credit and Collections, Customer Master, various sales representatives, Center for One Baxter, and others.

Set-up new accounts, document service requirements, maintain other records, and prepare customer required reports.

Project 5: IT Security Administrator (Feb 2009 – Jun 2010)

Perform network scanning and vulnerability assessments.

Provide technical advice on access control, security models, disaster recovery, business continuity planning, and security awareness training.

Analyze and define security requirements for local and wide area networks.

Plan, implement, monitor, and troubleshoot internal information technology security policies, application security, access control, and corporate data safeguards

Update secure configurations by routinely reviewing vendor sites, bulletins, and notifications for security information.

Configure, support and evaluate security tools.

Review network designs and evaluate compliance to applicable security standards.

Conduct security audits and provide recommendations to mitigate risks.

Ensure compliance to security standards and policy.

Evaluate project initiation documents.

Design solutions, configure or support Firewalls, Content Engines, Intruder Detection or Prevention Systems.

Configure and support anti-virus software.

Configure and support patch management systems.

Produce or modify disaster recovery and business continuity work practices.

Configure and optimize server and desktop operating systems and enterprise patch management systems.

Knowledge of common protocols such as SNMP, HTTP, HTTPS, SMTP, NTP, LDAP, KERBEROS, RADIUS and FTP.

Ensure representation in change management working parties.

Configure and support VPNs and enterprise gateway devices.

United Rx – Pharmacy / Inventory / System Technician (Sep, 2008 – Jan, 2009)

TCF National Bank – Branch Supervisor (Aug, 2007- Sep, 2008)

Skills

SAP Netweaver

SAP Basis Administration

SAP R/3

SAP Portal

SAP Implementation

SAP ECC

Enterprise Portals

Performance Tuning

SAP HANA

SQL

Oracle

Linux

Contact this candidate