SUMMARY

• SAP HANA Admin including SAP HANA Database and SAPA HANA appliance.
• SQL severer Admin and implementation. Around 9 years of hands on experience.
• Administration and monitoring of 4 Servers: 10 node 8TB scale - out and more implementation of SAPA HANA appliance with CISCO USCS.
• Extensive experience in HANA Administration, Good command in stop and start server, upgrading the HANA to latest version includes HANA DB, Client and Studio, BO reporting on Explorer dashboard.
• Leading offshore team in the daily upgrade and maintenance activities.
• Experience in solving the issues related EMC/NetApp storage, UCS Hardware, SAP HANA Memory.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, Analytical Privileges.
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Creating Schemas Manage Schema Mapping and managing user/object level security.
• Coordination with SAP for S/W Issue resolution.
• Delivery lead for the offshore teams.
• Manage HANA Studio and DB Client Connectivity.
• Environmental Management (interoperability with other software, platforms) (eg: Informatica, SQL Server and BO servers).
• Migration between PROD and Non PROD.
• Manage User Access restrictions.
• Built summary tables for the dashboard.
• Many years experiences in database design, implementation, administration, and tune-up. (Tasks include schema design, data access layer design and implementation, dynamic queries, stored procedure programming, DTS, SSIS, job scheduling, backup and replication, security configuration, and etc.).
• Experienced in gathering Requirements and Business logics from Business Users and preparation of technical documents.

PROFESSIONAL EXPERIENCE

Confidential, NC

SAP HANA Admin

Responsibilities:

• Install and setup HANA 1.0 Platform Edition.
• Install and Configure DMIS Component on SLT server and setup configuration between ECC and HANA DB.
• Experience in day-to-day/weekly/monthly, on demand HANA Administration tasks such as Start/Stop HANA, Adding Systems, CPU/Disk utilization metrics, system integration, logs, trace, E-mail setup, Security provisioning, alerts, log segments, MySQL database administration, Backups/Restore, HDBSQL, monitoring HANA instances, status, space usage, alerts, memory usage, patches, table administration, upgrades, multiple report creations etc..,
• Extensively worked on Licensing, Alert Configuration, Tracing, HANA Security (connections, users (database, system, application users, passwords, authorizations, single-sign on), Table Administration, Configuration of Data replication methods, Persistent layer.
• Bring all the development and Customizing objects after successful Integration Testing and the User Acceptance Testing- to the Production systems.
• Involve the Teams to make sure the Business Acceptance Testing is successful before going live.
• Bi weekly upgrade of SAP Hana system and Suse Linux.
• Monitoring of SAP Hana appliance and manual check the file system and backup conformations.
• Hands on experience in adding the system, configuration files, Monitoring logs. Index server, CPU and Memory utilization, Host, Port and other HANA Services.
• Working with EMC/NetApp storage teams.
• Installing single/multi node SAP Hana System for Cisco and cisco customers.
• Installing SUSE Linux for SAP Hana and for Management VMs
• Working with SAP Teams to find RCT’s in SAP HANA appliance of CISCO their customers.
• Understanding the Business requirements & convert them into Blueprint.
• Define the Design Documents for the HANA Models.
• Design & Creation of HANA Attributes views, HANA Analytic views, HANA Calculation views Managing Attribute Mapping, Creation of Constant columns and Creation of Analytics Privileges.
• Activating Impacted Objects and Validating Information Models, Export/Import of Models
• Extensive experience in HANA Administration, Good command in stop and start server, upgrading the HANA to latest version includes HANA DB, Client and Studio, BO reporting on Explorer dashboard.
• Experience in SAP HANA Maintenance: health checks, system monitor, scheduled maintenances and systems re-starts, Create and schedule regular backup process
• SAP market place maintenance.
• Implementing and tuning new SAP Hana monitor Tool (EM7, Wireshark, and ITPA Tool).
• 24/7 support for production System escalations.

Environment: SAP HANA 1.X, Business Objects Data Services 4.0, SQL Server2008 R2, EMC/NetApp storage, Informatica, SUM, SAP Solution manages, Cisco VNX, VM ware, cisco Network, Cisco hardware setup and configuration.

Confidential, VA

SAP HANA, SQL Server Consultant and DC support

Responsibilities:

• Involved in a full life cycle on Hana. Company started moving to SAP shop about a year back.
• As an administrator participated in all system management activities like software upgrades, applying patches along with performance monitoring and tuning.
• Involved in the training teams that are dealing with the first customer’s project on HANA.
• Involved in Installation of SAP HANA, SAP BOBJ and configuration of SAP BODS.
• Involved in POC and worked in an agile fast paced environment.
• Hands on experience Suse Linux, crontab commands and installation, configuration and Kernel patching.
• Working experience in SAN/NAS Storage technologies in data centre environment
• HANA backup and recovery(initiated from HANA studio, SQL commands), HANA distributed and scale-up, scale-out setup skill, Root cause analysis for Performance and troubleshooting by enabling the server side tracing(queries with critical memory consumption ), HANA service and ports. Table partitioning, delta merging as needed (manually /automatic).
• Created attribute, analytical and calculation views for the companies weekly monthly and POS data.
• Developed multiple cross tab reports in OLAP analysis using the hierarchy defined in HANA views.
• Creation of CR and handling of user incidents Through BMC Remedy
• Extensive support for go-live projects on HANA and BOBJ.
• Worked closely with SAP market support team to resolve all the ticket issues.
• Worked closely with SAP Basis team, Db team and other Unix administrators for implementing solutions to complex technical issues.
• Migrating and Upgrading the SQL Server 2000 data bases into SQL Server 2005 and 2008.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server

Environment: SAP HANA 1.X SP5, SAP BODS 4.0, SAP BOBJ 4.0, BI 7.3, WEBI, IDT, Dashboard Design Tool, BO Explorer.

Confidential

Sr. SQL DBA, and Infrastructure Support Manager

Responsibilities:

• Extensive Experience in installation and configuration of MS SQL Server 2000, 2005 and 2008 versions.
• Migrating and Upgrading the SQL Server 2000 data bases into SQL Server 2005 and 2008.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Implemented database mirroring log shipping and replication.
• Created various SSRS reports according to the business requirements for project, individually authored, installed, deployed and managed reports using SSRS for a library database.
• Creating and managing SQL Server Logins, Roles and Authentication Modes as a part of Security Policies for different levels of users.
• Created and developed the stored procedures, triggers to handle complex business rules and audit analysis.
• Aspect Telecom server installation and upgradation.
• Creating and modifying user credentials on the Aspect system.
• Applying Microsoft patches and loading files during the installation.
• Good knowledge on the database and infrastructure management on the banking sector.

Environment: SQL DBA, SSRS, Windows 2003 server, MS SQL Server 2005 and 2000 With clustering environment