PEOPLESOFT DBA
Name : P Venkata Ramakrishna
Voice : 91 – 800-***-**** Email id : ************.**@*******.***
EXPERIENCE:
Having 4.11 years of experience as PeopleSoft Administrator, oracle databases expertise in installation, configuration, Monitoring, maintenance and administration of Application Server, Process Scheduler and Web Server. Excellent analytical, problem solving and management skills.
PROFILE SUMMARY:
Over all 4.11 years of experience as a PeopleSoft Database Administrator Supporting mainly HRMS and FSCM modules on Oracle, and their supporting Operating Systems.
Installation, configuration, setup and management of PeopleSoft Internet Architecture (PIA) environment.
Successfully installed and configured Web Logic Server, Application Server, Process Scheduler and Database on UNIX / NT operating systems.
Monitored the Server and Client queue statuses at several tuxedo and web server domains.
Administering Application server, Process Scheduler Server and Web Server.
Experience of applying Service Packs, Maintenance Packs, Bundles, Patches and Tax Updates.
Security Administration at Network, Database and PeopleSoft application levels
Proficient in Data and Project Migrations using Data Mover and Application Designer.
Installation and Configuration of the Oracle Server on Windows 2003 and Linux Platform
Performing Backup/Recovery procedure for Oracle Database including Hot and Cold Backup
Having knowledge in Import, Export, backup procedures.
Having experience in verity index process and troubleshooting (PeopleSearch)
Troubleshoot and resolve Security Issues
Excellent analytical, problem solving, and time management skills
TECHNICAL EXPERIENCE SUMMARY:
People Tools
Data Mover, Integration Broker (PIA), Change Assistant, Security, Process Scheduler, Configuration Manager, Application Designer, Tuxedo Application server.
ERP
Applications HRMS- 8.9/9.0/9.1/9.2, FSCM- 9.0/9.1,
People Tools 8.49/8.50/8.51/8.53.
Database
Oracle 9i/10g/11g/12c and 2008
Web server
Oracle Web logic 8.1/9.2/10.3
Application Server
TUXEDO 8.1/9.1/10gR3
Operating System
Windows 2003/XP/NT, RHEL AS 4/OEL 4,Solaris
EDUCATION:
Completed my B.Tech From Sri Vasavi Engineering College, Tadepalligudem, W.G.Dist, A.P in 2007.
Completed my Intermediate from Aditya Junior College, Bheemavaram, W.G.Dist, A.P in 2002.
Completed Board of secondary Education from Aditya Residential High School, Bheemavaram, W.G.Dist, A.P in 2000.
PROFESSIONAL EXPERIENCE:
Working as a PeopleSoft DBA in ATOS, Hyderabad from Oct 2013 to Till date
Worked as a PeopleSoft Admin in CAPGEMINI, Pune from Aug 2010 to Sep 2013.
Project #1:
Client : HUDZPBS
Duration : Oct 2013 to Till Date
Role : PeopleSoft DBA
Database : Oracle 11g
Environments : HRMS 9.2, PeopleTools 8.53, NT & ORACLE 11G.
Project : HRMS Production Support .
The HUDZPBS was a project for HUDSON which is an Australia based company which connects, advises, and supports organizations and their employees. Their specialized recruitment, RPO and Talent Management solutions help to find great people and then turn them into great performers - adding value and increasing productivity at every stage of the employment lifecycle.HUDZPBS is a PayBill support project which works on supporting the various aspects of PayBill.
RESPONSIBILITIES:
Responsible for all 2 tier and 3 tier client setups on HRMS to include Crystal Reports.
Managed systems security and PeopleSoft security for HRMS.
Supported local end users in troubleshooting and resolving issues.
Created Application Server Domains, Process Scheduler and Web Server Domains
Involved in the Performance of the databases and application by creating multiple domains across the instances.
Configuration of Integration Broker, defining Gateway, creating and configuring nodes for HR and Finance
Extensively used PSADMIN utility to Administer, Create & Delete Application Server and Process Scheduler Server.
Monitored the Server and Client queue status at several tuxedo and web server domains.
Migrated several Projects from Development Database into Testing Database
Creating user and configuring user profiles, roles, permission lists. Granting full access/ read only access permissions to the users for Application Designer.
Extensively used PSADMIN utility to Administer, Create & Delete Application Server and Process Scheduler Server.
Implemented forgot password functionality.
Opened service requests in oracle support and fixed the issues
Involved in Knowledge transfer and Training for the users
Identified individual fixes from bundles and patches and applied
Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service
Supporting Developers, Testers on transferring newly created/updated codes from Dev to Test to Production databases
Helping developers in various ways like resetting the passwords and setting up the Client machines for the developer
Project #2
Client : CORNING
Role : PeopleSoft Admin
Duration : Aug 2010 to Sep 2013
Environment : HRMS 9.0, FSCM 9.0 and PeopleTools 8.50
Database : Oracle 10g
Corning support was a project for corning which is an U.S based company and is the world leader in specialty glass and ceramics. Drawing on more than 160 years of materials science and process engineering knowledge, Corning creates and makes keystone components that enable high-technology systems for consumer electronics. Corning’s operations in India are represented by Corning Technologies India Private Limited. In Gurgaon, they offer the customers world class products and service which includes access to our vast global technical resources, applications engineering support.
Responsibilities:
Installed PeopleSoft applications – People Tools 8.50 Application (HCM 9.0 and FSCM 9.0), Tuxedo 10gR3, and Web Logic 10.3.5
Take care of the Migration of data and PeopleSoft objects.
Created Application Server Domains, Process Scheduler Server and Web Server Domains.
Installed Demo instance with latest release
Design and implement the new architecture and server setup
Troubleshoot and Follow up on technical issues with team and users
Performance monitoring and tuning for scripts
Involved in the Performance of the databases and application by creating multiple domains across the instances.
Creating user and configuring user profiles, roles, permission lists. Granting full access/ read only access permissions to the users for Application Designer.
Handled troubleshooting issues for Application Server, Process Scheduler Server and Web Servers.
Checked and cleared the application server cache on a regular basis as maintenance
Administering Application server and Process Scheduler Server using psadmin utility.
Prepared and maintained the documentation of all the installation and configurations of databases and applications
Involved in Knowledge transfer and Training for the users