We provide IT Staff Augmentation Services!

Sap Basis/hana Consultant Resume

2.00/5 (Submit Your Rating)

Boston, MassachusettS

SUMMARY

  • Highly skilled SAP HANA Basis Administrator wif proven track record establishing and carrying out SAP implementations, related policies, and procedures in support of large SAP implementations is now looking for a challenging role as a SAP HANA Administrator. My experience working on large, complex platforms enables me to quickly identify wat works while being open to better ideas. Intimately familiar wif on - shore/off-shore model and is adept at providing seamless continuity through teh different time zones.
  • Thorough knowledge of planning, designing, and architecting SAP systems across a variety of platforms and databases. Install support packs, conduct upgrades, backups/recovery, system refresh and troubleshooting as well as administer databases, conduct failover of production systems, monitor and ensure performance of SAP systems.Collaborate wif internal and external stakeholders, work cross-functionally to gain insight and develop solutions to meet business needs. Drive delivery by prioritizing individual and team tasks to meet project deadlines.
  • Excellent communication, interpersonal, organizational and prioritization skills, work well independently and as team member, in diverse, fast-paced environments. Responsible for full lifecycle implementations. Coach, mentor and motivate team to meet - and exceed - corporate objectives. Successfully handle multiple projects simultaneously.

PROFESSIONAL EXPERIENCE

Confidential, Boston, Massachusetts

SAP BASIS/HANA Consultant

Responsibilities:

  • Installed 4 TB S/4 HANA 1610 appliance, configured backups and followed-up wif daily monitoring/performance activities.
  • Installed NW 7.5 SAP MII, MDG and PI/PO running on VM HANA databases, each wif 512GB.
  • Installed SAP Workforce Performance Builder(WPB) on Windows 2012 R2 wif SQL DB and Tomcat 7.1 server
  • Installed NW 7.5 SAP FIORI on Sybase ASE.
  • Migrated BODS ASE database from ISO 1 UTF 8 Character set for Unicode conversion. Tuned DB for better cache throughput based on SAP best practice.
  • Used SPAM/SAINT/SUM to apply addons and get to desired patch level.
  • Language install - added Spanish language to S/4 HANA in Development and Test systems, changing default languages for each client based on specifications.
  • Facilitated several Knowledge Transfer sessions to Support Team as part of transition.

Confidential, Wilmington, Delaware

SAP HANA ADMINISTRATOR

Responsibilities:

  • Implemented and managed SLT replication between 4 R/3, 1 ECC and 1 BW system into HANA DB.
  • Created multiple schemas using SLT “DB Connect” and HANA Studio. Dropped/ and recreated schemas in Test, QA and Prod to facilitate data movement and created new tenant databases per project requirements.
  • Using HANA Studio, managed multiple production HANA systems; first-generation sidecar HANA (SP3) through teh existing multiple node, 8 TB HANA systems (SP11); tuned performance issues using trace and system log.
  • Implemented High-Availability wif System replication using SYNCMEM log synchronization.
  • Developed and implemented HANA Security Policy to adhere to auditing guidelines. Shared gap analysis wif leadership and worked wif offshore team to implement.
  • Monitored system backups and data-merge daily, taking appropriate actions. Configured HANA for automatic email notification of specific exceptions. Developed log and backup retention policy wif stakeholders to better manage space on filesystem.
  • Scaled-out existing system to accommodate data growth, redistributing impacted tables. Migrated Single-container system to multi-tenant DB and re-architectured Production environment wif failover host.
  • Facilitated multiple team sessions on In-memory Technology to better leverage our team’s capability. Developed HANA questionnaire used to test users’ knowledge of HANA, prior to granting access.

SAP BASIS ADMINISTRATOR

Confidential

Responsibilities:

  • Monitored several R/3, ECC, BW, SRM and APO systems daily, resolving exceptions in timely manner.
  • On-call rotation between onshore and offshore teams supporting 175 SIDs, wif hot hand-off for all critical issues.
  • Participated in Collaborative Work Teams (CWT) and follow-up Root Cause Analysis (RCA).
  • Investigated, troubleshot and resolved production batch failures managed by Control-M 6.3 working wif functional leads to rerun.
  • Assisted project teams in activating new jobs (configuration file) prior to project go-live.
  • Establish Trusted and non-Trusted RFC across landscape.
  • Enforced change-process for all requests and managed shared printers between Prod and QA.
  • Applied OSS Notes, registered objects and Developers on SAP Marketplace, opened client as needed.
  • Configured transport routes in TMS landscape and participated in several major life-cycles including dual production paths for go-live.
  • Prepared buffers for weekly production migrations.
  • Performed SAP Add-on and Kernel upgrades per project requirement; modified system parameters and tuned buffers based on recommendations from SAP Early Watch Report.
  • Monitored and tuned 40 TB BW/BWA system for BW loads; modified SAP buffer and parameters to exploit technology; managed BIA servers and collaborated wif BW functional team on rebuild of BIA indexes.
  • Assisted DB2 Administrators on quarterly database reorganization both online and offline table moves.
  • Participated in planning/execution of quarterly Prod QA refreshes.
  • Built and reviewed project plan for system refreshes, assigned resources and provided daily progress report to leadership.

SAP BW

Confidential

Responsibilities:

  • Performed Statistical Setup in R/3 to reload data into BW Info cubes; documented optimal settings for very large LIS (SD and MM).
  • Created info objects and info cubes to support new functionality/ enhancements; conducted Info cube reloads to support project team and data recovery assigning resources to distribute workload globally.
  • Supported quarterly maintenance by stopping/starting BW queues prior to outage.
  • Designed and managed multiple BW queues to simultaneously send ERP data to multiple BW systems (BW upgrade project).
  • Tuned BW packets to minimize delay and configured parallel PSA-processing for faster loading.
  • Performed annual review for staff and participated in rating /rankings; conducted monthly one-on-one meetings wif staff to discuss performance and provide feedback; made recommendations to leadership on promotions.

Database Administrator

Confidential

Responsibilities:

  • Migrated 45 databases from Oracle 7.2 to 8i and from HP-UX 10 to Sun-Solaris platform.
  • Architectured data/index layout across different controllers and disks for 30% better throughput.
  • Migrated all production databases for point-in-time recovery.
  • Facilitated several SGA and checkpoint tuning sessions to new hires.
  • Automated NT backup scripts to minimize manual intervention

TECHNICAL SKILLS

ERP Package: SAP R/3 4.6c, ECC 6.00 EHP5-8, BW/BWA/ BI 7.5,7.4, 7.3, 3.5, 2.1C, APO 3.0, SCM, CRM and GTS

Operating Systems: IBM-AIX 6.1, Sun Solaris, Linux Redhat/SUSE9, HP-UX10, VMWare, Windows 2012 R2

Network: NFS, DNS, SSH/SNC/SSO, TCP/IP Protocols, Gateway

RDMSDB: HANA, IBM DB2 V9.7, Sybase ASE, Oracle 7.3/8i/10g

Tools: Control-M, Remedy, TREX, SAPGUI, HANA Cockpit/Studio, ChaRM, Galileo

We'd love your feedback!