Orville S. McGrath

Contact: 302-***-****(M) Email: acy8w4@r.postjobfree.com;

Location: New Castle, Delaware; Flexibility: 80% Travel

Professional Summary:

Analytical problem solver and articulate communicator that thrives in fast-paced, SAP environments; listens well and knows how to inspire others while respecting the disciplines of the project teams.

Drives delivery by prioritizing individual and team tasks to meet project deadlines.

Developed and implemented HANA Security Policy to mitigate audit risks and worked with stakeholders to embrace SAP’s best practice. Configured high-availability (HA) in production using a standby host for failover.

SAP Batchjob Re-architecture Project – Collaborated with stakeholders and global functional leads in this two year project, redesigning 15k batchjobs across 27 business units. Developed and published Control-M standards, naming convention and release coordination to facilitate rollout. By leveraging jobs across multiple businesses, we reduced batchjobs by 45% and Incidents by 25%. Additionally, new Jobname immediately encapsulated batch characteristics such as; Prod/QA, Cluster, workstream, region/global and job frequency making it easier to identify owner.

Quality Process Improvement Initiative – Represented our Basis team in this global, cross-team process improvement initiative tasked with a weekly review, follow-up mitigation of Level-1 and 2 incidents. Identified technical and procedural gaps and followed-up with detailed recommendations for Team Leads to implement which resulted in a 40% decline in SAP Basis exceptions over six months.

Hardware Reduction Project – Saved $1M annually in VM licensing cost by eliminating 25% of VM frames used to manage 127 severs across Prod, QA, Test and Disaster Recovery sites. Shared multiple cost-benefit proposals to client and later developed an execution plan once the project was approved.

IT Works Volunteer – Mentor inner-city high school graduates registered in the program’s 4-month, tuition-free CNA training providing guidance and support to your assigned student throughout the program and culminating with graduation.

SKILLS MATRIX

Tools

SAP R/3 4.6c, ECC 6.00, BW/BWA/ BI 7.30, 7.0, 3.5, 2.1C, APO 3.0/4.0

ERP Package:

SAP R/3 4.6c, ECC 6.00, BW/BWA/ BI 7.30, 7.0, 3.5, 2.1C, APO 3.0/4.0

Operating System

IBM-AIX 6.1, Sun Solaris, Linux SUSE9, HP-UX 10, VMWare, Windows 2000/NT/XP/7

RDMSDB

HANA, IBM DB2 V9, Oracle 7.3/8i/10g

Networking

NFS, DNS, SSH/SNC/SSO, TCP/IP protocols, Gateway

Tools

Control-M, Remedy, TREX, SAPGUI, SAP HANA Studio, CHarm, Galileo

Work Experience:

SAP HANA Administrator – (Aug 2011 – Jun 2016) Accenture LLC – Wilmington, Delaware (Client: DuPont)

Responsibilities:

Implemented and managed SLT replication between 5 ERP and 1 BW systems into HANA.

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 the existing 4 TB HANA systems (SP10). Analyzed performance issues using trace and system log..

Developed and implemented HANA Security Policy to adhere to auditing guidelines. Shared gap analysis with leadership and worked with offshore team to implement. .

Monitored system backups and data-merge daily, taking appropriate actions. Configured HANA for automatic email notification of specific exceptions. Developed backup retention plan with 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 Architectured Production systems with High-availability (HA)

Worked with and trained junior resources on HANA technology. Created HANA questionnaire used to ascertain users’ knowledge of HANA, a prerequisite for getting access.

Environment: BW 7.3, 7.4, HANA 1.X SP3/9/10, R/3 4.6, ECC 6.0

SAP Basis Administrator – (Jan 2008 – Jun 2016) Accenture – Wilmington, Delaware (on behalf of our client DuPont)

Responsibilities:

Daily monitoring of several R/3, ECC, BW and APO systems. Resolved exceptions and escalated as needed.

On-call rotation between onshore and offshore teams supporting 175 SIDs, with hot hand-off for all critical issues. Participate in Collaborative Work Teams (CWT) and follow-up Root Cause Analysis (RCA).

Investigate, troubleshoot and resolve production batch failures managed by Control-M 6.3 working with functional leads to rerun. Assist project teams in activating new jobs (configuration file) prior to project go-live.

Establish Trusted and non-Trusted RFC across landscape.

Configured and managed 3500+ printers using Lotus Notes DB as change tool and single source-of- truth. As gatekeeper, 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 resolving transport and buffer issues. Prepared buffers for weekly production migrations. Participated in several major life-cycles including dual production paths for project go-live.

Performed SAP Add-on and Kernel upgrades per project requirement. Modified system parameters and tuned buffers based on recommendations from Early Watch Report.

Monitored and tuned our 35 TB BW/BWA system for BW loads. Modify SAP buffer and parameters to exploit technology. Managed BIA servers and facilitated rebuild of BIA indexes.

Worked with DB2 Admin on database reorganization and online/offline table moves;

System Refresh -Participated in the planning/execution of multiple Prod à QA refreshes. Built and reviewed project plan, assigned resources and communicated progress.

Environment: R/3 4.6c, ECC 6.0, NW 2004/2004s, 7.0. 7.3, APO 3.0/4.0

SAP BW Batch Network Lead – (Jun 2005 – Jan 2008) Accenture – Wilmington, Delaware (on behalf of our client DuPont)

Responsibilities:

Managed on/offshore teams to support our daily Master Data and Transactional loads engaging Basis and DBA team as needed. Prepared BW availability metrics to leadership daily.

Performed Statistical Setup in R/3 to reload data in to BW Info cubes. Documented optimal settings for very large LIS (SD and MM)

Created info objects and info cubes to support new functionality or 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 the outage.

Designed and managed multiple BW queues to simultaneously and independently send R/3 data to multiple BW systems.

Tuned BW packets to minimize delay and configured parallel PSA-processing for faster loading.

Performed annual review for staff and participated in rating /rankings. Had the monthly one-on-one meeting with staff to discuss performance and provide feedback. Made recommendations to leadership on promotions.

Environment: BW 2.1C, 3.5

Oracle 8i Database Administrator – (Aug 2002 – Jun 2005) Accenture LLC – Wilmington, Delaware (on behalf of our client DuPont)

Responsibilities:

Migrated 57 databases from release 7.2 to 8i, for 150% better throughput via SGA optimizing and better data/indexes layout. Migrated Production systems to more efficient recovery using hot backups.

Facilitated technical interviews on behalf of the firm for prospective Oracle Database Administrators across US.

Managed Extended and moved datafiles as appropriate and worked with functional teams to stabilize environment prior to month-end.

Created tables, indexes and updated statistics for better performance while using OEM tool for SGA tuning.

Recommended architectural improvements, design and integrated solutions.

Worked with Oracle’s SME to resolve critical issues.

Environment: Sun Solaris, Windows NT

Manugistics Software Developer – (Jun 1999 – Aug 2002) Accenture LLC – Wilmington, Delaware (Client DuPont)

Responsibilities:

Used 3rd party tool running on Sun Solaris platform to better manage the client’s global supply chain.

Configured software to update railcar sightings for in-transit raw materials and finished products for more effective inventory planning.

Wrote and automated all UNIX scripts managed by the Control-M job scheduler. Collaborated with multiple vendors to implement.

Deputy Shift Manager- Mainframe Operations – (Aug 1982 Jun 1999) Citicorp N.A. – Manhattan, New York

Responsibilities:

Managed operations staff running batch and taking system backups or the Investment Banking Division...

Maintained staffing and vacation scheduling and conducted annual performance reviews.

Production support via JCL changes to facilitate batch reruns. Optimized system utilization by leveraging jobs across multiple mainframes to meet deadlines

Managed reboot of IBM 3090 logical partitions during quarterly maintenance and emergency outages.

Planned and performed annual offsite disaster recoveries with minimal disruption to onsite staffing.

Hobbies: Mentoring, War history, Family travel, Sport cars

Education: City University of New York – York College

Major: Management Information Science - 118 Credits

Contact this candidate