SUMMARY:

• Confidential produce and maintain an SAP/Oracle landscape that exceeds customer expectation.SAP/Oracle/Unix Administration skills and accomplishments.
• As reported by my managers, excel at preventing priority 1 problems by detecting/fixing conditions before the conditions actually grow into problems.
• Am considered the team oracle expert (my team consults me on complex oracle questions/tasks).
• Frequently volunteered for several team tasks.
• Frequently took initiative to create process documentation and perform team cross - training.
• Performed cross-training with several new-hire to quickly bring the new-hire up to speed.
• Trained out sourcing team members to perform required tasks, followed up to confirm tasks were completed, correct, and timely.
• Provided support and guidance to developers, application support persons, end users, and vendors.
• Received more than 15 company recognition and monetary awards for tasks well done.

TECHNICAL SKILLS:

Languages: SQL, PLSQL, Unix Scripting, Informix 4GL, COBOL, Others.

OS/Hardware: Linux, AIX, HPUX, Windows 2012 server, Others.

PROFESSIONAL EXPERIENCE;

SAP BASIS Administrator

Confidential

Responsibilities:

• Troubleshoot/resolved SAP/oracle performance problems: reduced 12 hour process to 15 minutes, quickly fixed a process that was halting the entire system, fixed deadlocking problems, fixed application that was uncontrollably creating archive files (and filling file system), fixed never - ending/failing processes to successfully complete, etc...
• Performed regular performance monitoring and workload analysis: set SAP/oracle traces/events and identified/analyzed/resolved slow performing queries, locked oracle statistics for increased performance, performed oracle memory, oracle parameter, and oracle log adjustments to increase performance, created statistics and indexes to increase performance, recommended application changes to increase performance.
• Proactively identified and applied SAP/oracle performance adjustments in all systems (for consistency and efficiency).

Oracle Database Administrator

Confidential

Responsibilities:

• Performed SAP installs, upgrades, plug-ins, support packs, stacks and maintenance for ECC, BW, TM, EM, PI/PO, Portal, HANA, Solution Manager, and GRC SAP systems.
• Performed SAP/oracle system creation and duplication (via SUM, SWPM, sapinst, sap export/import, sapinst, backup/restore, brtools)
• Adjusted SAP STMS, RSA1 connectivity, partner profiles, and distribution models.
• Performed SAP Business function activation and BC set activation.
• Performed Solution Manager configuration changes, monitor/reporting, CHARM.
• Performed Netweaver changes to JCO, communication channels, resource adapters, SPROXY, SSO, certificates, SLD, Product/software components.
• Performed Early Watch and Go-live report tasks for proactive problem resolution.
• Performed multiple oracle install/upgrades, SBPs (oracle patches) via runInstaller, dbca, dbua, expdp, impdp, MOPatch.
• Performed AWR advisor and ADDM recommended tasks for proactive problem resolution.
• Created oracle views for custom sap data extraction.
• Designed technical processes (oracle upgrade, UNIX upgrade), documented the processes, handed the processes off to other team members for execution, monitored the process executions.
• Performed Vertex and BSI TaxFactory install/migration/upgrades (for SAP sales and payroll tax calculation).
• Performed SQL Server performance monitoring, table creation/drop, data modification.
• Installed, upgraded, and patched oracle server/client software on Unix and MS Windows.
• Created/configured, upgraded, and maintained multiple oracle databases. Database size ranged from 5 Gigabytes - 8 Terabytes, simultaneous users range from 5 to 5000.
• Performed capacity planning and storage maintenance.
• Performed Unix upgrades, documented the process, handed off the process to others for execution.
• Assembled hardware components, apply firmware updates, install Linux operating system, create volume groups/logical volumes, configured Linux options (xntp, postfix, ftp, etc…), copied a database (from other SAP/oracle system) to the server, rsync several directories and files (as required by SAP/oracle application) from other system, configured server backup mechanisms, documented the process, handed off the process to other persons for execution, monitored execution.

Oracle Database Administrator

Confidential

Responsibilities:

• Performed many annual disaster recovery tests, documented DR process, shortened DR test by 4 hours via innovation.
• Customized/tested SAP/oracle high availability automated processes (heartbeat).
• Restored/recovered databases multiple times as required by OS malfunctions and end user mistakes.
• Designed, tested, and automated database backup/recovery strategies (via custom scripts, etc…).
• Protected production databases from developer mistakes by creating multiple test databases and enforcing change management control procedures.
• Installed, customized, and maintained SAP/oracle system refresh tool Libelle System Copy (LSC).
• Innovatively performed LSC adjustments to make LSC perform tasks that it was not designed to perform.
• Created oracle tools (export/import) to assist and speed up SAP system duplication.
• Reduced 5 simultaneous SAP/oracle system refresh time from 5 days to 1.5 days.

Build/Run Systems Analyst

Confidential

Responsibilities:

• Created innovative tools (sqlplus, UNIX scripts) to assist team and self with common jobs.
• To facilitate world's second largest merger, designed PLSQL to extract system data, created several sap systems to facilitate the merger.
• Used strong scripting experience to maintain/customize UNIX scripts that performed file transfers for SAP/Bank interfaces with pgp encryption and ssh key authentication.
• Corrected a problem with third party software when the third party support could not.
• Innovatively moved functionality away from SAP servers to target servers to ensure secure and compliant bank interface processes.

Build/Run Systems Analyst

Confidential

Responsibilities:

• Was left in charge of team during supervisor's 3 month absence, received compliments from mid-level managers during this time for a job well done.
• As reported by my managers, excel at preventing priority 1 problems by detecting/fixing conditions before the conditions actually grow into problems.
• Am considered the team oracle expert (my team consults me on complex oracle questions/tasks).
• Frequently volunteered for several team tasks.
• Frequently took initiative to create process documentation and perform team cross-training.
• Performed cross-training with several new-hire to quickly bring the new-hire up to speed.
• Trained out sourcing team members to perform required tasks, followed up to confirm tasks were completed, correct, and timely.
• Provided support and guidance to developers, application support persons, end users, and vendors.
• Received more than 15 company recognition and monetary awards for tasks well done.
• Performed project management which included plan creation, task/milestone identification and scheduling, resource identification, resource and task coordination, and communication (from project start to end).
• Identified and performed SAP/Oracle corrections to items that were missed during system creation.
• Multitasked daily by simultaneously working on several fast and slow moving projects.
• Excellent interpersonal and communication skills. Strong organizational and time-management abilities. Able to work both independently and in a team environment.

Build/Run Systems Analyst

Confidential

Responsibilities:

• Within a hosting environment, performed oracle database and UNIX support
• Adhered to company, audit, team, ITIL, and ITSM policies while performing daily tasks.
• Determined chargeable amount per user requested software modification.
• Restored personal computer functionality by formatting and loading all software.
• Performed network configuration and maintenance.