Supply Chain Oracle

SYED A. ALEEM, Senior Oracle Applications DBA

Mobile: 630-***-****

Email:***********@*****.***

LinkedIn Profile: https://www.linkedin.com/pub/syed-aleem/4/663/731

Profile

Over 17+ years of experience in Information Technology as a senior Oracle DBA, Oracle E-Business Applications DBA and Programmer/Analyst that includes last 16 + years as an Oracle Applications DBA and core DBA in primary and lead roles with increasing responsibilities within Oracle E-Business suite (11i /R12) and Fusion Middleware WebLogic, OBIEE, and Oracle Agile PLM Implementations, Planning, Installations, Upgrades, Configuration, System Administration, Maintenance, Troubleshooting, Cloning, Patching, Code migration, Database Cross platform migration using Oracle tools and technologies.

My extensive Senior Oracle Apps DBA/Architect experience is ranging from EBS versions 10.7 thru R12 and supporting E-Business Financials, HRMS, Supply Chain, ASCP, Discrete Manufacturing modules and Oracle Agile PLM and databases ranging from version 7.x thru 12c.

I also have several years of strong experience in E-Business/Database project management. This experience includes successfully leading and completing all phases of the Oracle Applications E-Business implementations, upgrades and integration projects.

Summary of Experience

Managed, supported and maintained several E-Business 10.7, 11.0.x, 11i.x and 12.x & Custom Oracle Applications including Production, Development, Test, UAT & QA in 24x7 environment

Managed all phases of Implementation Life cycle, Requirements Gathering, Technical Design, Development and Implementation

Managed consultants for E-Business implementations, upgrades and quarterly patching projects

Developed project documentation for complete upgrade cycle and coordinated with other project managers leading the concurrent implementations including Presentations and Workshop Sessions

Expertise in Oracle Enterprise Manager (OEM) Grid Control 12c, 11g installation and configuration

Expertise in Systems Architecture Design, Installations, Upgrades, Migrations, Maintenance & administration of the Oracle E-Business Suite environments, Fusion Middleware WebLogic, SOA, OBIEE & ODI

Experience on configure Oracle Weblogic administration, installation and configuration

Expertise in Oracle E-Business R12.2 Installation, Upgrade & Online Patching

Expertise in Oracle E-Business R12.2, R12.1.3 and 11i Application Infrastructures, Architecture design and Storage requirement in single/multi tier environment

Expertise in Database and E-Business Upgrades of 11i and R12 Applications, Cloning, and Refreshing Databases

Extensive experience in E-Business R12.2, R12.1.3, 11i AD utilities, Patching Techniques, Patch Analysis, Patch Impact and Patch Management

Expertise in sizing and Capacity Planning for Oracle E-Business 11i/R12, Fusion Middleware and Agile PLM 9.3.2

Expertise in Supporting, Maintaining and Installing ASCP Instances

Expertise in Supporting, Maintaining, Installing, Cloning and Troubleshooting Oracle Agile PLM Applications 9.3.2

Lead and managed full cycle of 11gr2 database upgrade project for E-Business 11i, identified improvement opportunities & guiding the team for all phases of project lifecycle

Proficient in multiple, large RDBMS and Application 11i/R12 Administration, Server Installation & Performance Tuning, Security Management, Backup & Recovery, Data/Code Migration & Data Integration of Oracle11g,10g/9i/8i/8.x/7.x. and Cloning

Managed User Acceptance Testing, Integration Testing and Regression Testing for databases and applications

Administer Oracle database Security across all databases and maintain financial audit requirements for Oracle RDBMS and E-Business Suite.

Participate in planning and implementation of off-site disaster recovery planning and testing

Proactively Monitor and Perform Health-Check for the Databases and E-Business Suite using Oracle Grid Control 12c and documented findings and implement recommendations

As a member of team plan and implement Oracle Real Application Clusters RAC 11g on RHEL Linux 6.x and provided DBA support in all phases of a project including maintenance and administration

Experienced in Space Management, Memory Tuning and Application Tuning

Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin and database)

Extensive experience working with Oracle Support Opening, Managing, and Resolving Oracle SR's.

Worked in conjunction with Business & Functional Users, Project Management office to resolve all issues prior to Go Live and post Go Live.

Reviewed and improved existing systems, and provide advice on new technologies and best practices and recommendations

Devised and implemented quarterly Patching Strategy for ERP applications11i & R12 and Certifications

Upgrade Projects

Upgrade R12.2 to R12.2.4 & R12.2.5

Production Manufacturing, Supply Chain & Financials Module 11.5.10.2 to R12.1.3

Production Manufacturing, Supply Chain & Financials Module 11.5.9 to 11.5.10.2

Production Manufacturing, Supply Chain & Financials Module 10.7 NCA to 11.5.9

Multiple Oracle Database Upgrades from 8i to 10g, 10g to 11g & 11g to 12c

Technical Skills

ERP Applications: Oracle E-Business suite R12.2.5, R12.1.3, 11i.x (11.5.7, 11.5.9, 11.5.10.2), 10.7 NCA 11.0.3

Databases: Oracle 11g, 10gr2 9i, 8i. 8.0.x, 7.x, RAC 12c

Operating Systems: HP UNIX 10.x, 11.x, 12.x, Sun Solaris 2.6/2.8/9/10, IBM AIX, RHEL 5x, 6x, OEL 5x, 6x, Centos 5, Win-NT, MS Office (Word, Excel, PowerPoint, Access, Outlook, Projects), Visio, Toad, HP Data–protector, HP Omni Back, HP Open View, PowerBuilder 4.0, Erwin 2.6, VNC, SSH, PUTTY

Middleware: WebLogic 11g, 12c, SOA, Fusion Middleware, Oracle Application Server 10gAS, 9iAS

Languages: SQL, PL/SQL, C Shell, Korn/Bourne Shells

Web Technologies: Oracle App Server, Apache, OC4J, JDBC, Oracle Forms and Reports Server

Hardware: HP Data Storage, SAN, RAID

Reporting Tools: Oracle Reports 6i & 10g, Discoverer 10g & 11g, Data Warehouse

Oracle Tools: Oracle Forms 6i & 10g, OEM 10g, OEM 11g & OEM 12c, OAM, TOAD, ADUtilities, ADI,

Applications Management Pack (AMP 3.0/4.0), Oracle Configuration Manager (OCM),

Oracle Discoverer 10g & 11g, VMware, CITRIX, SQL Navigator, PL-SQL Developer,

Patch Wizard, Maintenance Wizard, Opatch, Trace/tkprof

Oracle Certification:

Oracle 12c Certified Professional Database Administrator, Oracle Corporation 2017

Oracle 11g Certified Professional Database Administrator, Oracle Corporation 2016 & 2017

Education

Masters in Engineering (MS), University of New Haven, West Haven, CT

Bachelor in Engineering, Bangalore University, Bangalore, India

Professional Affiliations

Member of OAUG, IOUG & NCOUG

Legal Status

US Citizen

Employment Experience

AST Corporation. Naperville IL June, 2015 to Feb, 2017

Role: Senior Oracle Applications DBA For Managed Services

Environment: Oracle E-Business 12.2.3, 12.2.5, 12.1.3, RAC 11gR2, OBIEE, SOA, ODI, CommVault, EMC,

Linux RHEL 6.x & 5.x, Grid Control 12c

Client: Clark County Water Reclamation District, NV Sept, 2016 to Feb, 2017

Upgrade R12.1.3 database from 11.2.0.3 to 12.0.1.2 (12c) in production

Providing production and development support for E-Business 12.1.3, patching, cloning and performance tuning of application and database layer

Installed HR/Payroll annual and CPU patches and run Vertex upgrade

Applied various database / applications PSU / CPU patches as required.

Troubleshoot Concurrent manager, Workflow and Output Post Processor issues

Troubleshoot Oracle Forms, Reports, OACore, JVM issues

City Of Hurst, TX Mar 2016 to Feb 2017

Upgraded production Oracle E-Business R12.2.3/11.2.03 to R12.2.5/11.2.0.4

Full Cloning of Oracle Applications R12.2.4 and Database

Provided support for online patching of R12.2.5

Client: Metra Commuter Rail, IL May, 2016 to Nov, 2016

Supported and successfully performed fresh implementation of Oracle Retail Back Office, Central Office and Oracle Retail Point of Sales Applications from 13.1.1 to 13.4.8 version

Installed and configured Oracle Retail Back Office, Central Office and Oracle Retail Point of Sales Applications 13.4.8 and integrated with Oracle Fusion Middleware WebLogic Server 10.3.6

Installed and upgrade Oracle Retail Applications databases

Performed data migration using Oracle datapump utility

Troubleshoot database architecture, configuration, installation and migration issues and provided resolution to the issue in a timely manner

Setup databases for RMAN backup

Client: City of Chattanooga, TN Jan, 2016 to Nov, 2016

Currently supporting and working with Oracle Managed Service Cloud team to migrate Oracle E-Business R12.1.3 on 12C database to Oracle Cloud

Providing production migration support, managing database backups, patching, cloning and troubleshooting database and applications issues running on E-Business 12.1.3 and 12c database

Providing support for HRMS, Payroll, Benefits, financials and third party EIS reporting module

Consolidate multiple CUSTOM_TOPs into single CUSTOM_TOP

Maintained EIS third party reporting application, patching and upgrade

Rhode Island Airport Corporation, CT Apr 2016 to Nov 2016

Providing production and development support for E-Business 12.2.3 applications as needed

Cloning E-Business 12.2.3 from production to development as needed

Troubleshooting Middle Tier Weblogic and other technical stack issues

Provide support for Oracle RAC, including applying patches,backup and recovery issues with RMAN

Hampton Roads Sanitation District, VA Feb 2016 to Jul 2016

Provided production and development support for E-Business R12.2.3/11.2.0.4, online patching, techstack patching & troubleshooting application and database issues

Metra Commuter Rail, IL Jun 2015 to Dec 2015

Monitoring and providing day to day support for Oracle ODI, SOA and OBIEE troubleshooting and problem resolution

Provide day to day operational support for Oracle E-Business R12.1.3 production applications running on RAC 11gr2, and multiple production Retail Applications running on Application server 10g and 11gr2 databases

Monitoring daily RMAN backups through Grid Control 12c and CommVault and resolving backup failure issues

Review 3rd party security scan reports on applications and databases vulnerabilities and provided resolution by installing CPU's and Security patches

Provide database capacity analysis planning report

Provide production, development and test servers Memory, CPU, Logical Processor, Hyper Threading, Core per CPU and No. of Sockets report

Coordinating with the team on a daily basis, for high priority issues and resolution

Monitoring Oracle production and development Databases growth and performance using Oracle Enterprise Manager, Grid Control 12c (OEM) providing resolution using tools Automatic Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)

Monitoring Linux Servers performance using Oracle Enterprise Manager, Grid Control 12c (OEM

Monitoring multiple Oracle production and development databases using OEM Grid Control 12c, monitor users, table spaces, memory structures, undo segments, growth of tables, indexes, logs, and alerts.

Extensively used OEM Grid Control 12c for Diagnostics & Tuning Packs, Events, Job Managers, and Change Manager

Defined and configured monitoring templates, metrics in Oracle grid control 12c (OEM)

Installed the latest CPU/PSU patches on Oracle grid control 12c (OEM) OMS and Agent

Provided support for SQL performance tuning using SQLT tool

AAR Corporation, Wood Dale IL Sept 1999 to March 2015

Role: Senior Oracle Applications DBA/Core DBA

Projects: From 2007 to 2015

Environment: Oracle E-Business Applications R12.2.4/R12.1.3/R11.5.10.2/11.5.9 Financials, Supply Chain, Discrete Manufacturing, OTL, Projects, Discoverer10g & 11gR2, Linux RHEL 6.x 5.x, HP-PARISC, HP-Itanium and Sun Solaris

Working as a Senior Oracle Apps/Core DBA & Technical Architect, maintaining and administrating mission critical Databases and E-Business Applications running on Linux/Unix Platform

Installed, Maintained and Configured E-Business R12.2 Oracle DB and Apps Tier related applications on a multi node environment for internal training and demos

Upgrade all Technology Stack Components 11i/R12 to the latest certified levels

Installing and Configured SOA Suite and WebLogic 10.3.x.x Servers

Involved in maintenance, administration and troubleshooting of production SOA instances and Weblogic Server

OBIEE Installation, Configuration and Administration of WebLogic & Fusion Middleware

Installation, Configuration and Administration of Oracle 11g RAC with ASM files system using Oracle cluster ware

Provide day to day and project support for Oracle E-Business and PLM Agile Application 9.3.2. This includes Patch Analysis, Deployment and Cloning

Performed Oracle E-Business Release 12.1.3 suite installation on a multi node environment with Shared ApplTop and Shared tech stack

Performed Oracle E-Business Release 12.1.3 suite Maintenance and Patch administration for Oracle Discrete Manufacturing, Supply Chain and Financial modules

Provide functional Support Creating Users, Assigning Responsibilities etc. of Oracle E-Business Suite 11i and R12

Engaged in Upgrade/Migrate of Oracle EBS Release 11i to R12 and R12.x (Apps and DB Tier)

Identified and installed 11i baseline patches for extended support on E-business 11i/R12

As a member of team plan and implement Oracle Real Application Clusters RAC 12c on RHEL Linux 6.x and provided DBA support in all phases of a project including maintenance and administration

As a member of team plan and implement Data Guard 10gr2 setup

Created multiple Virtual Servers and Installed Linux RHEL OS for 12c, 11gr2 & 10 gr2 databases on VMWARE

Knowledgeable with internet application setup and configuration in DMZ

Migrated several Oracle 11i environments to OATM (Oracle Applications Tablespace Model)

Upgraded multiple versions of JDK, JRE & JInitiator for E-Business Applications

Implemented proactive patching strategy to discover and apply patches on a quarterly set schedule, this includes finding and applying the latest CPU/PSU and Roll-Ups (RUPS), Family Packs for Discrete Manufacturing, Financials, Supply Chain, HRMS, Project Billing, Project Costing, Business Intelligence, One-offs & Recommended patches

Installed multiple versions of Developer 6i Patch sets 18 & 19

Installed, Configured & Administered OEM Grid Control/TOAD and Application Management Pack (AMP) 3.0/4.0 to proactively monitor all environments on HP-UX/Linux

Performed Upgrade Readiness Assessments for 11.5.10.2

Lead and managed multiple upgrades for E-Business 11.5.9 to 11.5.10.2 using Rapid Migration methodology with cross platform migration from Sun Solaris to HP-UX and HP-Itanium

Installed and configured Oracle Application server 10g & Discoverer 10g for E-business 11.5.10.2

Performed 11i Single node & Multi node Rapid cloning activities to build Development, Test, UAT and QA environments

Lead and managed database upgrade from 8.1.7.4 to 10gr2 in 11.5.9 environment

Performed day to day Application maintenance such as creating or modifying users, assigning responsibilities to users, creating and running long Request and troubleshooting

Supporting development teams in troubleshooting all Oracle EBS issues including Database performance, Work Flow, Forms, Reports and Concurrent Managers, Apache, Jserv processes, TKPROF, AWR, ASH, ADDM, EXPLAIN PLAN, Application Tracing Tools

Tuned concurrent managers with Oracle R11i E-Business Suite

Utilize the Sarbanes-Oxley (SOX) requirements and compliance for application and database security

Debugging waits events from latch contention, I/O, and enqueue or buffer busy conditions.

Gathering and analyzing database statistics.

Role: Oracle Applications DBA/Core DBA

Projects: From 2002 to 2006

Environment: Oracle Applications 10.7, 11.5.9, Financials, Supply Chain, Discrete Manufacturing, Depot Repair, Discoverer 4i, HP-PARISC, Sun Solaris

Lead and managed multiple upgrade for E-Business 10.7 NCA to 11.5.9 in a multi node environment

Performed Rapid cloning activities to build Development, Test and patch environment

Installed and upgraded several Oracle databases from 7.3.x to 8.0, 8i to 9i for AAR custom applications

Setup and configure database for hot backup through RMAN

Support SR/TAR resolution and management, including follow up with Oracle Support. Maintained day to day activity of tar log

Configuring Workflow notification mailers

Installed and configure Oracle Discoverer 4i for Oracle E–Business suite 11.5.9

Administer all database objects including tables, clusters, indexes, views, sequences, packages and procedures

Performed O/S statistics, like CPU utilization, memory utilization, I/O utilization, contention and paging/swapping

Monitor Oracle log files, alert log, trace files, datafiles, tablespace, fragmentation, current database processes and active tables

Role: Oracle Applications DBA

Projects: From 1999 to 2001

Environment: Oracle Applications 10.7, Financials, Supply Chain, Discrete Manufacturing, HP-PARISC, Sun Solaris

Maintained multiple 24x7 production, Test & development Oracle Applications 11.0.3 & 10.7 NCA in a multi-node environment for Manufacturing, Financials and Supply Chain modules

Setting up and Installing Oracle Web Application Server

Perform 2-tier and 3-tier clones of Oracle Applications 10.7 NCA & 11.0

Maintained the system current and applied the latest mini packs to rule out the potential bugs

Supporting development teams with root-cause analysis, TARs, Code Migrations, Patching (analysis, management and migration

KPMG Peat Marwick LLP Consulting Services, Chicago, IL Aug 1997 to Sept 1999

Role: Oracle Consultant

Environment: Oracle Applications 10.7, Financials, Supply Chain, Discrete Manufacturing, HP-PARISC, Sun Solaris

Experience in the design, development, creation, installation, patching, configuration, administration and implementation of Oracle RDBMS and Oracle Applications 10.7 NCA

Support technical TAR resolution and management, including follow up with Oracle Support. Maintained day to day activity of tar log

Performed database and middle tier sizing of the Oracle Applications on Sun Solaris 2.6 and HP-UX 11.0 for Oracle applications and database

Setting up and Installing Oracle Web Application Server

Define and Implemented Backup and Recovery strategies

Creating database schema, users, maintaining user privileges and enforcement of security of databases

Performed data loading and data migration from legacy system into Oracle database using SQL and PL/SQL scripts and export and import method

Scripting and automating all common database operations and monitoring techniques

United Chambers & Life Insurance Co., Naperville, IL August 1996 to August 1997

Role: Programmer/Analyst

Environment: Oracle 7.3.4, Power Builder 4.0, Windows NT, AIX

Maintained and provided technical support for a Vendor Provider System to load Network Vendors and Provider Information into the custom application and tables.

Migrated Vendor Provider System application developed in PowerBuilder 4.0 into stored procedures using PL/SQL

Created database triggers to enforce the business and security rules.

Designed and generated reports for Health Management System using Infomaker 4.0. Also generated reports using SQL, SQL*PLUS and PL/SQL.

References

Provided upon request

Contact this candidate