Abdul Raheem Syed
Cell: +1-346-***-****
Email: adu7d2@r.postjobfree.com
Summary:
Around 10+ years of experience in Information Technology areas involving PeopleSoft System Administration, Application and Tools Upgrades, Oracle database Administration, Oracle Application server administration and UNIX administration.
Professional expertise in Installation, Tools and Application Upgrades, Configuring and maintenance of PeopleSoft applications and applying Maintenance Packs, Bundles. Tax-Updates. Expertise on RDBMS like Oracle. Finesse revolves around Database refreshes, Scheduling Cron jobs and Appserver/Web Server Performance Enhancement. Experienced in the Oracle DB upgrades to 19c.
PeopleSoft Experience:
Working as Oracle DBA for upgrading the Oracle database from 12c to 19c.
Installed and maintained the 6 RAC Node DB for 19c.
Majorly responsible for upgrading the client Database into brand new servers, which includes Installing Oracle Software, creating oracle databases, and performing upgrades of the databases and software to the new release levels.
Actively involved in resolving the issues encountered at the time of DB installation and upgrade
Specializing in PeopleSoft Major Upgrades, Maintenance and patching activities, including support during the configuration, unit and system testing, user acceptance testing, for a successful project.
Expertise in implementing Change management using PUM, change assistant by handling applying bundles, patches and maintenance packs
Strong experience in performing requirement analysis, project planning and implementation
Extensively worked on Install and configure PeopleSoft server hosts, components, and for 3-Tier and 2-Tier clients.
Contributed to all phases of the software life cycle, including analysis, design, implementation and Maintenance.
Creating Application server, web server and process scheduler domains for the environment.
Refreshment of PS databases, Code Migrations.
Create Windows Client Profiles for various development, test and production users and install.
Implement load balancing for Web servers and application servers and monitor.
Maintain integrity and internal consistency of the database using DDDAUDIT, SYSAUDIT reports periodically.
Install Change Assist for Upgrade in newer versions of PeopleSoft and Installing and configuring PeopleSoft Test Framework.
Planning backup and recovery strategy for various database environments and good knowledge of exports/imports, RMAN
Experience in SQL Tuning Advisor, SQL Profiles, SQL Plan Management and SQL Tuning using hints & indexes
Migrating standalone Database to AWS Cloud
Additional Skills:
Databases - Oracle 9i to 19c, MS SQL Server
Application Server - Tuxedo, Oracle Application server, PeopleSoft
Web Server - Web-logic, OAS
Operating System - AIX, SUN Solaris 5.x, RedHat Linux,
Windows XP/2003/2000/NT/98/95/2016R2
Languages - SQL, PL/SQL, UNIX Shell
Cloud - Amazon/AWS
Educational Qualification:
Master of Computer Applications from Ferguson P.G College, Hyderabad in 2006.
Certifications:
Oracle Certified Professional 9i
Professional Experience:
Client: Hilton Hotels Worldwide, McLean, VA Aug 2021- Till now
Job title: Sr. Consultant
Job Responsibilities:
Working as Oracle DBA for upgrading the Oracle database from 12c to 19c.
Installed and maintained the 6 RAC Node DB for 19c.
Majorly responsible for upgrading the client Database into brand new servers, which includes Installing Oracle Software, creating oracle databases, and performing upgrades of the databases and software to the new release levels.
Actively involved in resolving the issues encountered at the time of DB installation and upgrade.
Performing the necessary tests after the upgrades are done successfully.
Performing the starting up and shutting down the database and managing the database's storage structures.
Involved in raising Service Requests with Oracle when bugs are found.
Working as PeopleSoft and the role involves providing support, maintenance, troubleshooting and applying patches/tax updates.
Performing daily PeopleSoft health checkup.
People tools upgraded from 8.54 to 8.57.
Performed a complete PeopleSoft installation using HCM 9.1, People tools 8.57 on the Lab servers for internal development team.
PeopleSoft/Oracle Patch Management/Upgrades - Researched & applied Patches and Fixes/Maintenance Packs/Tax Updates manually and using Change Assistant. Installed and configured Change Assistant to apply the People Tools upgrade
Compile the COBOL programs on PSUNX & PSNT using the COBOL compiler when the new cobols are delivered with patches and fixes.
Maintain the Oracle database server, Export & Import, RMAN Backups which are further used for Environment & Database Refreshes
Performing security related task like creating Oracle users and assigning roles.
Installing and configuring PeopleSoft Test Framework
Troubleshoot and fix performance issues
Worked on Migration projects
Configure and setup of Oracle Secure Enterprise Search (Oracle SES).
Applied all Tax Updates after as a part of maintenance
Environment: Oracle 19c 6 RAC Node, People FSCM 9.2 & FSCM US/UK 8.9, Peoplesoft tools 8.56/8.57, HCM 9.1, Red hat Linux 7.0, Windows 2016.
Client: Hilton Hotels Worldwide, McLean, VA(worked from Hyderabad, India) April 2014-Nov 2015
Job title: ERP Sr. Analyst
Job Responsibilities:
Primary Analyst for Major Upgrade projects, and member of team responsible for implementations, Migrations and Upgrades
Installed and Configure PUM for 9.2 Upgrades
Installed Oracle Enterprise Manager and Configured PeopleSoft plugin to Monitor and Manage PeopleSoft systems
Supported during testing for unit, system, and user acceptance and post implementation production support.
Configured tools to Monitor and Administer PeopleSoft Applications
Installing and Maintaining PeopleSoft Environment with People tools and all applications
Install and Administer Oracle Search Enterprise Server.
Configured PeopleSoft Plug-in on Oracle Enterprise Manager grid control.
Worked on Migration projects involving in Non-Unicode to Unicode conversion.
Installing Tuxedo and applying Tuxedo rolling patch
Installing Web Logic and applying patches
Performing Database Refreshes
Troubleshoot and fix performance issues
Implementing Single Sign On.
Installing and configuring PeopleSoft Test Framework
Performed Data Masking using Oracle Enterprise Manager Tools
Applied SQL profiles using Oracle Enterprise Manager Cloud 12c
Environment: Oracle 12c, FSCM, HCM 9.1, People tools 8.54, Red hat Linux 5.0 & 6.0, Windows 2012.
Client: Trinity Industries Inc, Dallas, TX (worked from Hyd, India) April 2014-Nov 2015
Job title: ERP Sr. Analyst
Job Responsibilities:
Technical Specialist, specializing in PeopleSoft Major Upgrades, Maintenance and patching activities, including support during the configuration, unit and system test, user acceptance testing, for a successful project.
Upgrade of PeopleSoft Tools from 8.50 to 8.53.
Installation, configuration and editing of Application Server, Web Server and Process Schedulers.
Applied all Tax Updates after as a part of maintenance
Installing and configuring PeopleSoft Test Framework
Environment: FSCM, People tools 8.50, 8.53, HCM 9.1 Sun Solaris 10, Windows 2008.
Client: Masco Corporation June 2009 – April 2014
Job Title: Consultant
Job Responsibilities
Technical specializing in PeopleSoft Major Upgrades, Maintenance and patching activities, including support during the configuration, unit and system testing, user acceptance testing, for a successful project.
Primary Analyst for Major Upgrade projects, and member of team responsible for implementations, Migrations and Upgrades
Handling tools patch and performing minor upgrades on modules primarily covering HRMS, ELM and FSCM.
Hands on experience using PeopleSoft and third-party development tools like Application Designer, Application Engines, SQR Reporting. Exposure to COBOL Customizations.
Supported during testing for unit, system, and user acceptance and post implementation production support.
Configured tools to Monitor and Administer PeopleSoft Applications
Installing and Maintaining PeopleSoft Environment with People tools and all applications
Install and Administer Oracle Search Enterprise Server
Worked on Migration projects involving in Non-Unicode to Unicode conversion
Installing Tuxedo and applying Tuxedo rolling patch
Installing Web Logic and applying patches
Performing Database Refreshes
Troubleshoot and fix performance issues
Implementing Single Sign On.
Implementation of New PeopleSoft Environments and creating a similar copy of the installations existing.
Research, Applying Fixes/Bundles, Tax updates and upgrades (tools & application).
Configuring & Editing Application Servers, Process Scheduler & Web Server.
Handling Production related issues while in UAT phase and on production move of upgrades.
Retrofitting of customizations of objects as integral part of Upgrades
Managing multiple environments (Demo/Test/Dev/Production) addressing areas such as security, monitoring, performance tuning.
Hands on experience in manual & automated DB refreshes of Oracle & SQL Server DB.
Handling Second Level Support after client go-live.
Involvement in non-routine projects for advanced engineering like Operational Acceptance certification of PeopleSoft products at AT&T and automation scripts for database and environment refreshes.
Actively participated in documentations to develop installation guides and operating procedures of PeopleSoft and third-party products integrations.
Upgrade of PeopleSoft Tools from 8.47 to 8.52.
Installation, configuration and editing of Application Server, Web Server and Process Schedulers.
Applied all Tax Updates after as a part of maintenance
Installed and Configured UPK
Environment: People tools 8.50, PeopleSoft HCM 9.1, Red hat Enterprise Linux 5.0/windows 2008
Client: Elkay Manufacturing June 2009 – April 2014
Job Title: Consultant
Upgrade of PeopleSoft applications from 8.9 to 9.1 and tools Upgrade from 8.47 to 8.50
Installation, configuration and editing of Application Server, Web Server and Process Schedulers
Tune the Application Servers for Peak Performance by testing the changes from Development Databases through Production Environment. Installed Tuxedo/Jolt, BEA Web logic Patches on application servers and web servers respectively to bring the servers current with the release
Configured Forgot Password functionality; Candidate gateway setup
Applied all Tax Updates after as a part of maintenance
Troubleshoot all issues pertaining to the application web and process scheduler servers
Create permission lists, roles and user profiles as per the business requirements
Maintain the Oracle database server, Export & Import; Backups & Recovery
Environment & Database Refreshes
Patches on application servers and web servers respectively to bring the servers current with the release
Plan and perform Backup & Recovery procedures activities (both in archive & no archive mode) using RMAN & Export/Import utilities
Environment: People tools 8.50, PeopleSoft HCM 9.1, Red hat Enterprise Linux 5.0/windows 2008
Client: 1-800Flowers, Carle Place, NY Aug 2008 to June 2009
Job Title: Database Administrator
Job Responsibilities:
Configured Physical standby database through Physical backup.
Performed database cloning through Rman/Physical Backup.
Performing Point-in-time recovery using recovery manager.
Taking Compressed and Incremental backups using RMAN.
Successfully Upgraded Oracle database 9i to higher versions.
Applying patches using OPatch utility.
For monitoring of critical errors in alert log on time base. Performed routine checks of space utilization. Extended Table spaces by resizing/adding data files when needed.
Alert Log Monitoring.
Environment: Oracle 9i
Client: General Motors March 2007 to July 2008
Job Title: Jr. Database Administrator
Job Responsibilities:
Creating users, roles, profiles, assigning roles and profiles to users.
Creating table spaces, Data files, Log files and control files.
Taking logical and physical backups periodically.
Configure SQL client using Database configuration assistant tool/creating networking Configuration files and creating service name.
Storage management, sizing the database objects, monitoring file Systems and table spaces growth
Used direct path loading via SQL*Loader
Database Space management
Environment: Oracle 9i
Training:
PeopleSoft HRMS and FSCM – AT&T, Hyderabad, 2010. Internal training at AT&T to enhance our functional knowledge on PeopleSoft HRMS and FSCM.