Oracle Project
Resume:
Prasanth Bhaskaran
Summary
. Over *.* years of experience in Oracle Database & PeopleSoft
Administration.
. Worked on people tool upgrade, implementation and support projects.
. Worked on both oracle along with PeopleSoft application
. Experience in installation, configuration and support of Oracle,
PeopleSoft, BEA Tuxedo, Oracle Weblogic, OEM11g/12c, Cobol
Compiler, BO Crystal Report, and OBIEE11g in both Windows and Linux
platforms.
. Upgrade of People Tool to the latest
version(PT850,PT851,PT852,PT853)
. Proactively monitor Web Servers, Application Servers, Process
Schedulers, middleware (Web logic and Tuxedo) and tune for optimum
performance and respond to outages.
. Perform upgrades of PeopleSoft system like patch,bundles,MPs
. Provide Admin support to the technical support team/development
team.
. Configuration of RMAN and backups to take Database backups for
oracle9i,10g & 11g.
. Migration of database cross platform using RMAN scripts.
. Tuning of the oracle database to improve the performance of the
PeopleSoft Application
. Installation and Administration on Third party software's.
. Database refreshing using Oracle Data pump, MAN Cross platform
migration, Cold backup.
. Troubleshooting payroll (GPP Process) related performance issue.
. PeopleSoft application integration on HCM & FSCM.
. Part of one complete life Cycle implementation of HCM 9.1 in NSE-
India.
. Integration of OBIEE11g analytics report with PeopleSoft HCM9.1
applications.
. Installation and configuration of PeopleSoft latest release over
AWS EC2 cloud servers.
. PeopleSoft Application upgrade HCM9.1 to HCM9.2
. PeopleSoft HCM9.2/FSCM9.2 installation over 8.53 AWS cloud servers.
. PeopleSoft SSO configuration using PortWise application.
. PeopleSoft Patch apply using PUM
. PeopleSoft Tools Upgrade
. SES11g Installation and integration with HCM9.2 & FSCM9.2
applications.
. 24*7 on call support for all application related issues on routine
basis.
Technical Skills
RDBMS: Oracle 9i, 10gR2, 11gR2
Operating systems: RHEL 5, HP-UX, IBM AIX 5.3/6/7, Windows 2003R2,
Windows 2008 R2 Server, OEL5.3
PeopleSoft Tools: PT 8.47. 8.50, 8.51, 8.52, 8.53 (CRM, HRMS,FSCM
and CAMPUS SOLUTION)
Applications: HCM8.9,CS9.0,HCM9.1/9.2,FSCM9.1/92,ELS9.1,
Portal 9.1
Third party Tools: BEA Tuxedo, BEA Weblogic, HP Kintana, Micro
focus COBOL compiler, SES11g, Verity, Radware Load
Balancer, PortWise SSO
Tools/Utilities: FTP, TOAD, EXP, IMP, EXPDP, IMPDP, SQL Plus
Business intelligence tools: SAP BO 3.1, OBIEE11g
Enterprise Manager: OEM11g, OEM12c
Version Control tools: PVCS, TortoisesVPN
Work / Project Experience
Current Organization: Citagus Software Pvt. Ltd.
Project experiences
Minacs (Support Project)
Description: Aditya Birla Minacs ("Minacs") is a business and technology
outsourcing company with headquarters in Bangalore, India; Toronto
(Oshawa), Canada; and Detroit (Farmington Hills), USA. It is a subsidiary
of the Aditya Birla Group.With 20,300 employees (as of June 2011)[citation
needed] and 35 operations centers in Canada, Germany, Hungary, India,
Jamaica, the Philippines, the United Kingdom, and the United States, Minacs
provides the manufacturing, banking, financial services, insurance,
telecom, high technology, media, and entertainment, healthcare, and
government and public sectors with outsourced customer life cycle,
marketing, finance and accounting, procurement and IT services
Duration : Nov 2010 - Dec 2011
Title : PeopleSoft DBA
Technology : PeopleSoft849, Oracle, Third party tools, FSCM9, HRMS9
Tasks / Accomplishments:
. Worked on revamping the PeopleSoft environment
. Resolving the issue that was arising on related to performance of the
environment.
. Involved in Oracle/PeopleSoft database refreshes
. Applied people tool patchs and applications MP's
. Performance tuning of PeopleSoft environment and oracle databases
. Involved in gathering stats and rebuilding indexes on demand by
developers.
. Monitoring and troubleshooting app, web and proc server issues.
. Created a demo and MP environment
. Involved in projected migration between DEV/QA/PROD
. Involved in Creating Oracle users, roles, synonyms, DB links etc.
. Coordinates and implement changes to development, test, and production
environments.
. Involved in clearing cache for web, app and proc servers on demand.
Bank Of India (On Site - Support Project)
Description: Bank of India (BoI) (BSE: BOI) is an Indian state-owned
commercial bank with headquarters in Mumbai, Maharashtra. Government-owned
since nationalization in 1969, It is India's 4th largest PSU bank, after
State Bank of India, Punjab National Bank and Bank of Baroda. It has 4157
branches as on 21/04/2012, including 29 branches outside India, more than
45,000 employees.
Duration : Dec 2011 - Feb 2013
Title : PeopleSoft DBA
Technology : PeopleSoft847, Oracle, Third party tools, HRMS9
Tasks / Accomplishments:
. Install Oracle and PeopleSoft instance on HP-Unix 11i & IBM AIX 5.3
for development and QA.
. Configure archiving and RMAN setup with recovery catalog for
production severs for backup and recovery.
. Performance monitoring of oracle database using various tools like
STATSPACK and monitoring scripts.
. Day to day Support to all PeopleSoft finance modules implemented,
support PeopleSoft HRMS Modules implemented.
. Install PS Software, configuration/re-configuration of process
scheduler, application server, web server and creation of new
instance.
. Handle all Server related problems like process scheduler, application
server, web server etc.
. Handle all oracle database related problems.
. Reset Password of Users, Creation of New Users, Creation of New Roles,
Creation of new Permissions, Assigning Roles, Assigning Permissions,
privileges etc.
. Maintenance of Development, test and Production systems. Day to day
activities will include trouble-shooting problems, performance tuning,
capacity planning, architecture and migrations.
. Plan and manage the installation of application patches and releases
on development, test and production systems.
. Coordinates and implement changes to development, test, and production
environments.
. Handle other day to day issues along with <Vendor> Techno-functional
person and HP Unix & IBM AIX Administrator.
. Provide technical administration and migration support for PeopleSoft
development, test and production environments.
. Refreshing of DEV/UAT & TEST environment using cold & emp-imp
utilities.
. Configure monitoring tools to evaluate the performance of systems.
. Manage and tune application servers, web servers for PeopleSoft
environments.
. Extraction and install ion of SSL certificate in Web server.
. Coordinating & working with DEV & User's during the payroll running
days.
. Resolving the performance issue in payroll processing
. Radware load balancer implementation over Weblogic 8.1 servers.
. PortWise SSO Configuration over PeopleSoft 8.47.
NSE (Nifty) (Implementation Project)
Description: The National Stock Exchange (NSE) is stock exchange located at
Mumbai, Maharashtra, India. It is in the top 20 largest stock exchanges in
the world by market capitalization and largest in India by daily turnover
and number of trades, for both equities and derivative trading.NSE has a
market capitalization of around US$1 trillion
Duration: Jan 2012 - Feb 2013
Profile: PeopleSoft and Oracle database
Tools and Platform: Oracle10g, RHEL5, People tools 8.51, HRMS9.1
Tasks / Accomplishments:
. Installation & configuration of complete PeopleSoft soft
infrastructure for both DEV/UAT & Production
. Project migration between DEV/QA/PROD
. Installation & configuration PeopleSoft performance monitoring for
production env.
. PeopleSoft database refreshes.
. Backup of database
. Applying MPs, people tools & database opatch DEV/QA/PROD.
. Rebuild indexes on demand by developers.
. Coordinates and implement changes to development, test, and production
environments.
. Monitoring and troubleshooting app, web and proc server issues.
. Clearing cache for web, app and proc servers on demand.
. Escalating and coordinating issues with Oracle Support.
. Troubleshooting payroll (GPP Process) related performance issue.
. Refreshing of DEV/UAT as per as dev team recommendation using cold or
oracle dump utility.
. Micro focus cobol installation and license installation and
environment configuration in both DEV/UAT/PROD
. Involved in complete life cycle implementation & coordinating with dev
& functional team.
. Configuration of forget password link in UAT/PROD env.
. 24*7 on call support for all application and database related issues
on rotation basis.
DLZP Group (Support Project):
Description: DLZP Group is proud to announce the availability of the
PeopleSoft Test Drive program. Through the program, customers can evaluate
a private and customized PeopleSoft environment running on the Amazon Web
Services (AWS); all provisioned in minutes with step-by-step instructions
for using and evaluating the environment. PeopleSoft Human Capital
Management (HCM) and PeopleSoft Financials and Supply Chain Management
(FSCM) applications can all be experienced via the Amazon Cloud.
Duration: Mar 2013 - Jul 2013
Profile: PeopleSoft and Oracle database
Tools and Platform: Oracle11gR2, RHEL5,Windows Server 2008 R2 DC, People
tools 8.51, HCM9.1,FSCM9.1,PT8.53,HCM9.2,FSCM9.2,Amazon Cloud EC2
Tasks / Accomplishments:
. Installation and configuration PeopleSoft latest tools and
applications in AWS EC2 servers.
. DEMO/SYSTEM HCM9.1/9.2, FSCM9.1/9.2,CRM9.1 Revision 2 database
creation.
. Migration of database from Oracle database 32bit to Oracle database 64
bit.
. Apply Tools patches and application MP's for both HCM 9.1/FSCM 9.1/ CS
9.0 instances.
. Automated the database startup, web, application domains in Windows
servers 2008 R2 DC.
. Backup and refreshing of PeopleSoft application database.
. 2-Tier & 3-tier Client workstation configuration.
. SES11g Installation and integration with PeopleSoft FSCM/HCM9.2
applications.
. COBOL Compiler installation for both Windows and Linux servers.
. Verity installation and running Portal registry process.
. Crystal report installation and runtime configuration.
. Database installation and environment configuration.
. Oracle database PSU patch apply using patch tool.
Current Organization: Aditya Birla Management Corporation Limited.
Aditya Birla Management Corporation Limited (Internal Project)
Description: A US $40 billion corporation, the Aditya Birla Group is in the
League of Fortune 500. It is anchored by an extraordinary force of over
136,000 employees, belonging to 42 different nationalities.
Duration : Aug 2013 - Till Date
Title : PeopleSoft DBA
Technology : PeopleSoft853, Oracle, Third party tools, HRMS9.1, HCM9.2,
ELS9.1, Portal 9.1, Taleo, PUM, Oracle VM Box Template,OEM12c/11g,Hyperion/ESSBASE
Tasks / Accomplishments:
. Installation & configuration of complete PeopleSoft soft
infrastructure for both DEV/UAT & Production
. Project migration between DEV/QA/PROD
. Installation & configuration PeopleSoft performance monitoring for
production env.
. PeopleSoft database refreshes.
. Backup of database
. Applying MPs, people tools & database opatch DEV/QA/PROD.
. Rebuild indexes on demand by developers.
. Coordinates and implement changes to development, test, and production
environments.
. Monitoring and troubleshooting app, web and proc server issues.
. Clearing cache for web, app and proc servers on demand.
. Escalating and coordinating issues with Oracle Support.
. Troubleshooting payroll (GPP Process) related performance issue.
. Oracle PUM Template configuration & apply latest patches using PUM
tools.
. Complete tools up-gradation management from DEMO/TEST/DEV /UAT & PROD.
. Complete Application up-gradation from HCM9.1 to HCM 9.2
. Managing the vendors & assigning the task on daily operational psadmin
activity
. Monitoring the complete PS infrastructure & manage the third party
vendors single handy.
. Periodic DR-Test & monitor the PR-DR sync regularly.
. Switching the reporting application to DR- Ready only database to
optimize the performance.
. Database tuning STAT update & index rebuild both online & offline
mode.
. Collecting the AWR report to perform the optimum performance.
Awards/Achievements:
MCA (Anna University Coimbatore) Rank holder 2010 with 9.2(CGPA) out of 10.
Training:
Course/Training Vendor
Oracle10g Database Introduction to SQL SQL Star
Chennai
RHEL 5 SQL Star
Chennai
PeopleSoft admin training Internal
training
PeopleSoft upgrade training Internal
training
PERSONAL DETAILS:
Name : Prasanth Bhaskaran
Father Name : Madhusudhanan B Nair
Gender : Male
Nationality : INDIAN
Languages Known : English, Hindi, Malayalam (MT), Tamil &
Bengali
Age & Date of Birth : 26+, 02/07/1986
Passport No : G5142723
Pan Number : BGBPP6170Q
Passport Status : Valid
Hobbies : Playing Cricket, Chatting,
Adventure tours, Listening songs
Present Address : B-3Lake View Side, Near Muszid, Balladur,
Bangalore- 560037
Permanent Address : Prasanth Bhaskaran
C/O Kamalawthi
Science &Technology,Dollygunj
Port Blair, S Andaman
Mobile : Mobile:+91-982*******(Mumbai) And
095********(Bangalore)
Mail Id : ***********@*******.***
Official Id : ********.*********@***********.***
I declare that the given details are true and correct to the best of my
knowledge.
Location: Mumbai
Contact this candidate