Sap Basis/hana Consultant Resume
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