Summary

• I have over 10 years of result oriented professional experience mainly with PeopleSoft applications and Oracle databases. In my past projects, I have worked as a PeopleSoft System Administrator/Oracle DBA on many Upgrade, Implementation, and Technical Support projects. I have worked on many PeopleSoft Applications Financials, HRMS, CRM, EPM and Portal . I have experience working with onsite-offshore models. Short descriptions of the skills which I have acquired with my experience are as follows.
• Experience with implementation projects. Implemented PeopleSoft Financials and HCM
• Experience with upgrade project. Upgrade PeopleSoft Financials 9.0 to 9.1 at MetLife, EPM 9.0 to 9.1 at Citi, and Financials 8.4 to 8.8 and HCM 8.3 to 8.8 at Duke Energy. Also performed many People Tools upgrade on various projects.
• Experience with integration broker. Setup and configured Integration Broker for messaging between Financials and HCM. Also setup IB to 3rd party applications. Tuned, executed and monitored many App messages. Tuned and resolved many issues related to integration broker on various occasions.
• Experience with PeopleSoft installations. Installed all the server components on the corresponding tiers of the PeopleSoft architecture. Created PeopleSoft database, Application Server, Web Server and Batch Server. Used Web Logic on the Web Server in all the projects.
• Extensive experience with Web Logic Servers. Created distributed multi-server domains to create web logic clusters. Setup proxy servers, and worked on SSO setup.
• Experience with PeopleSoft maintenance. Extensive experience using PeopleSoft Change Assistant for applying bundles, maintenance packs and tax updates.
• Experience working on performance tuning and load balancing. Experience working with PeopleSoft Performance Monitor. Setup PPM to monitor many PeopleSoft environments.
• Experience working as PeopleSoft Security Administrator. Created and maintained Users, Roles and Permission Lists. Experience working with SSL certificates. Installed SSL certificates on all the web servers. Setup REN Server and installed a separate SSL certificate for the REN server.
• Experience working with Quest STAT. Performed migrations using STAT. Also worked as the STAT security administrator.
• Experience working with various SFTP and NDM setups for file transfer.
• Experience working with PeopleSoft Process Schedulers, SQRs, COBOL programs, nVisions, Crystal Reports, Application Engine programs, and Peoplecode. Used many scheduling tools like AutoSys, Maestro, and ControlM for scheduling and running jobs.
• Experience working with Exa-Logic servers and Oracle Engineered Systems.
• Experience with some Database related activities with Oracle Databases. Some of the activities were, taking hot/cold backups, performing refreshes, performing export and import, monitoring the database, and running SQL trace. Experienced in cloning the database using cold and hot backups. Experience with designing and implementing of Backup and Recovery strategies for Oracle databases using RMAN utility. Responsible for planning, designing, implementation and maintaining Oracle databases on different flavors of UNIX Windows environments.
• Well versed with requirement analysis, project planning, and design skills including experience in developing technical specifications from functional requirements, planning technical implementations, customizing projects and upgrades and data conversion exercises. Good Mentoring skills and experience working with onsite/offshore model.

Technical Skills:

• PeopleSoft: Financials/SCM 9.1/9.0/8.9//8.8/8.4/8.0, HCM 9.1/9.0/8.9/8.8/8.3, EPM 9.1/9.0/8.9/8.3, ELM 8.8, CRM 8.8/8.4, and Portal 9.1/8.9/8.4 People Tools 8.52/8.51/8.50/8.49/8.48/ 8.47/ 8.46/ 8.44/ 8.21
• Application Servers: Tuxedo 10.3/9.1/8.1/6.5
• Web Servers: BEA Web Logic 10.3/9.2/8.1/6.1, Oracle Application Server, IBM Web-Sphere Application Server WAS 4.0/5.1, Apache Tomcat 4.1 5.x, and Microsoft IIS 4.0, 5.0, 6.0
• Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000, IBM DB2, MS Access 98 2000
• Operating System: Oracle Engineered Systems Exa-Logic and Exa-Data, Oracle Linux , UNIX HP-UNX, Sun Solaris, IBM AIX and Red Hat Linux, Windows 2000, 2003, 2008, NT Server/Workstation
• PeopleSoft Utilities/Tools: Application Designer, Data Mover, Configuration Manager, Change Assistant, PS Query, PS Security, REN server, PPM, Integration Broker
• Oracle Utilities/Tools: Oracle Enterprise Manager DB Console, RMAN, SQL Plus
• Scheduling Tools: PeopleSoft process scheduler, Maestro scheduler, ControlM, AutoSys
• Reporting: Oracle Business Intelligence Enterprise Edition OBIEE , Hyperion, Cognos
• ETL Application: Ab Initio, Informatica
• Microsoft Tools: Microsoft Office Word, Excel, PowerPoint , MS Outlook, MS Project, MS Visio
• Other Utilities/Tools: Quest Toad, SQL Developer, Quest STAT, BMC Remedy IT Service Management, BMC Patrol, Alarm Point, Service Now, Mercury Quality Center, SSH techtia, Humming Bird Exceed

Experience:

Confidenital

Position: PeopleSoft Administrator

Environment: Application -

• Corning Life Sciences PS FSCM 9.1, PT 8.52, Web Logic 10.3, Tuxedo 10.3
• Corning Global Supply Chain PS FSCM 9.1, PT 8.52, Web Logic 10.3, Tuxedo 10.3

Migrations: Quest STAT 5.6.1

Scheduler: ControlM, PeopleSoft Process Scheduler

Ticketing System: Service Now

Database: Oracle 11g

Operating System: Oracle Engineered Systems Exa-Logic and Oracle Linux

• Responsibilities: I am the Lead for all the PeopleSoft Supply Chain applications which were running on Oracle Engineered Systems i.e. Exa-Logic and Exa-Data. There were mainly two Supply Chain applications, Corning Life Sciences and Corning Global Supply Chain. Both these are PeopleSoft FSCM 9.1 applications. Our team supported PeopleSoft and Exa-Logic components of Oracle's Engineered Systems. I have outlined some of my roles and responsibilities as follows:
• Worked on day to day support activities for PeopleSoft and Exa-Logic
• Worked closely along with the Oracle analysts during the Exa-Logic patching
• Worked on transitioning our production application from PROD data center to DR data center and back. This was a part of the DR test as well as patching for the production Exa-logic servers.
• Setup new environments. Carved out space, and created new mount points ZFS shares for mounting the new file systems for the new PS HOMEs and PS CFG HOMEs. Install web logic, tuxedo, people tools, and setup the web server multi-server domain , application server domain, and process scheduler servers.
• Setup environments to connect to primary and stand-by databases so that the regular online traffic gets processed by the primary database, while specific reporting traffic gets processed via the reporting database thus reducing the load on the primary database, and hence improving the performance. This was setup in conjunction with the Golden Gate Replication setup with Oracle database.
• Worked on multiple Environment refreshes of non-prod environments from production. Automated and improved the refresh process wherever applicable.
• Worked on multiple performance issues. Turned on SQL trace, analyzed trace file, and work with the DBAs in tuning the database tables.
• Worked on COBOL issues, other batch job issues, and issues with report repository.
• Setup integration gateways for load balancing, and also setup the PUBSUB domains for failover. This was for high availability as integration gateway was a single point of failure.
• Worked with integration with 3rd party applications like Biztalk
• Worked with Oracle Traffic Director OTD as virtual load balancer for distributing traffic across various web server domains.
• Conducted training with the offshore team, and participated in cross training for Exa-Logic and Exa-Data. Mentored the team.
• Identified, and documented all the processes and BAU activities conducted as part of the day to day activities. Updated the run books wherever applicable.
• Reviewed the architecture diagrams, gave my recommendations, and made the required and approved changes in production to improve the architecture, and increase the high availability. Updated the architecture diagrams to reflect the new changes introduced in the architecture.

Confidenital

Position: PeopleSoft Administrator

Environment: Application -

• Domestic GL PS Fin 9.1, PT 8.52, Web Logic 10.3, Tuxedo 10.3
• International GL PS Fin 9.0/9.1, multi-lingual, PT 8.52/8.51, Web Logic 10.3, Tuxedo 10.3
• Sub Ledgers PS Fin 9.1, PT 8.51 Web Logic 10.3, Tuxedo 10.3
• HCM 9.1, CRM 9.0, ELM 9.1 and PT 8.51/8.50, Web Logic 10.3, Tuxedo 10.3

Migrations: Quest STAT 5.6.1

Reporting: OBIEE

Scheduler: Maestro, PeopleSoft Process Scheduler

Ticketing/Monitoring Tools: BMC Remedy, BMC Patrol, Alarm Point, Service Now

Database: Oracle 11g

Operating System: IBM AIX and Windows

• Responsibilities: I was the Lead for all the International GL Application which used PeopleSoft Financials. There were mainly two International GL applications for European Ledger and Asian Ledger. Both these were multi-lingual applications and used Unicode database. I have outlined some of my roles and responsibilities as follows:
• Led the re-implementation project for Asian Ledger. The Asian Ledger used PeopleSoft Financials 9.0 and People Tools 8.51. As part of the re-implementation project we upgraded the application to 9.1 and People Tools to 8.52. We also re-implemented much functionality and therefore had a lot of new customizations as part of this new project.
• Used the Remedy tool to create many change tickets and incident tickets. Created change tickets for the UNIX team to create new file systems, and batch IDs for the new servers. Also created change tickets for the DBAs to build new shell databases, or clone existing databases to create new databases for the new environments, mainly for the International GL applications.
• Created multiple new environments for the Asian Ledger upgrade. Created all the 3-tiers for the new environment App, web and database/batch servers .
• Created new DEMO and SYS environments from scratch for the Asian Ledger application, on new AIX servers. Installed the software. Installed Tuxedo on Application and Batch servers and Web Logic on web servers. Then installed the People Tools to create the PS HOME. Set up many environment variables and updated the .profile. Setup the PSNT process scheduler on Windows.
• Setup a Web Logic Distributed Multi-server domain to create a web logic cluster. Configured iPlanet servers to work as Proxy servers to load balance multiple web logic servers PIA1 and PIA2. Setup web logic servers for PT 8.51 as well as 8.52
• Worked on Integration Broker for the HR environment. Tuned the IB settings. Turned on the master/slave configuration for IB and used the dynamic slave option. Changed some of the queues to unordered for parallel processing.
• Applied patch, bundles, and Maintenance packs multiple times on various Finance applications. Extensively used change assistant for applying these patches. Configured PeopleSoft Environment Management Framework for applying the change packages.
• Assisted the DBAs in tuning long running PS Queries for PeopleSoft applications.
• Worked on multiple environment refresh activities, and performed the pre-refresh and post refresh activities.
• Worked on many issues when the Maestro job would fail. I would work along with the Maestro team to troubleshoot the root cause of the failure, and fix the jobs.
• Travelled to India for 2 months, and trained the offshore team on PeopleSoft application, and MetLife processes. Conducted a 2 hour group session everyday with the offshore team. Apart from the group sessions, also conducted individual sessions with each employee on a regular basis, tracking their individual progress and understanding about the applications. . I also mentored the offshore team, and got them up to speed with all the relevant projects at MetLife. The offshore team consists of 25 employees, and is managed by iGate.
• Created many documents about various aspects of work, client specific processes and procedures, new environment build documents, new architecture diagrams and excel spreadsheets with environment specific and application specific information. Consolidated many old documents, and updated and revised many documents. Transitioned and delegated many operational activities to the offshore team and setup new processes and procedures for the team to follow.

Confidenital

Position: PeopleSoft Administrator/DBA

Environment: Application - Fin 9.1 and HCM 9.1, PORTAL 9.1, PT 8.51/8.50, Tuxedo 9.1, Web Logic 9.2

Migrations: Phire

Scheduler: ControlM, PeopleSoft Process Scheduler

Ticketing Tool: Incident and Change Management

Database: Oracle 11g

Operating System: Red Hat Linux 9.1 and Windows

• Responsibilities: CapitalOne had recently acquired HSBC and ING. Therefore we had to integrate the HR data for these companies into our HCM application. This was a major initiative at Capital One. Capital One uses ADP for running payroll, and we have an ongoing process to in source the payroll calculations for running payrolls. These were the major initiatives on the HCM application. My role was to perform regular maintenance and support of PeopleSoft Financials, HCM, and PORTAL application, and also support these special projects for HCM. Here I have outlined some of my roles and responsibilities.
• Supported all the Financials, HCM and PORTAL applications.
• Worked on integration broker issues, and tuning app messages to gain performance. Tuned the PUBSUB server processes. Created dedicated channels for processing the WORKFORCE SYNC message.
• Created various UNIX shell scripts for automating the regular maintenance process.
• Using PSADMIN monitored the work done by each app server processes, and thus tuned the app server processes, by changing the number of min/max for PSAPPSRV, and the recycle timeout settings. Tuned JVM heap size on web servers.
• Applied Tax Updates on the HCM application using Change Assistant.
• The HCM application was missing many patches, and bundles. Since Maintenance pack 6 cumulative contains all the bundles and fixes released for HCM 9.1, therefore applied Maintenance pack 6 cumulative on all the HCM applications. This was a major initiative taken by me, and involved a lot of testing and retrofitting.
• Support special projects in HCM on an ongoing basis. As a part of this special project, we had to build many additional environments for HCM. Thus installed Web Logic, Tuxedo, Oracle client, PeopleTools, HCM application, created the PS HOME, web server domains, application server domains, process scheduler servers, and imported the database for other environments. Then performed the post import activities like resetting passwords, updating the PSDBOWNER table, etc.
• Perform migrations using PHIRE a PeopleSoft migration tools .
• Used ControlM for scheduling jobs. ControlM is a scheduling tool which can be used to scheduler PeopleSoft batch jobs as well as run UNIX scripts.
• Our HCM application has 7 physical servers. Each server has a web multi-server domain, and 3 application server domains. Therefore we have 21 application server domains for productions. Due to this, the process of building cache takes a very long time and users would face a lot of performance issues after clearing cache. Thus I created a pre-load cache project and included the frequently used objects in this pre-load cache project, and used this project to build app server cache. This helped in enhancing the performance of the application.
• Collected performance information for production servers, like CPU usage, memory utilization, and user counts, for all the 7 HR production servers, and 2 Financials, and Portal servers. Imported this data into excel, and generated graphs for CPU/Memory utilization, and user count. These graphs helped us understand which times were the busiest, and how much did the CPU/Memory go up with the user count increasing. This analysis further helped us better tune our application servers and web servers.

Confidenital

Project: Consumer Bank Risk is basically a PeopleSoft EPM application highly customized according to Basel 2 requirements. We are currently on EPM 9.0 and are planning for an Application upgrade to 9.1 and Tools upgrade from 8.49 to 8.51

Position: Upgrade/Infrastructure Lead

Environment: Applications -

• GCBC Global Consumer Basel Consolidator Global Consumer central warehouse for collecting and processing data required for Basel reporting to the regulators. This application is built on PeopleSoft EPM 9.0
• PeopleSoft EPM 9.0 Web Logic 9.2, Tuxedo 9.1 Oracle 11g ETL Ab Initio Reporting Cognos
• CENTRIS Data warehouse to store account level data. It is a consolidated data management layer to support consumer risk regulatory, management risk reporting and risk analytics.
• Web Server Web Sphere Scheduling Tool Autosys ETL Ab Initio DB Oracle
• RAMP Retail risk Analytical Modeling Platform This application is built to support regulatory and management needs such as Basel II analytics, Loan Loss Reserve, Product centric analytics etc.
• SAS Scheduling Tool Autosys ETL Ab Initio DB Oracle

Migrations: Quest STAT

Scheduler: AutoSys, PeopleSoft Process Scheduler

Tickets: Virtual Change RFC , Mercury Quality Center

ETL Application: Ab Initio

Reporting: Cognos

Database: Oracle 11g

Operating System: IBM AIX, and Windows

• Responsibilities: As an Infrastructure Lead, I am responsible for building, and maintenance of the Infrastructure for all the above mentioned applications.
• GCBC uses PeopleSoft application. Currently we have EPM 9.0 and People Tools 8.49. We are planning for an application upgrade from 9.0 to 9.1 and PT 8.49 to 8.51. I am managing the upgrade project. The following is a summary of my responsibilities related to upgrade.
• Reviewed PeopleSoft release notes to understand the new features introduced in this PeopleSoft application. Build the new DEMO database, and tested the new application and People Tools version.
• Performed an analysis and calculated the additional SAN requirement for the upgrade and then put in a request to procure this additional SAN.
• Reviewed the project plan and other documentations of the previous PS upgrades on this application. Conducted a series of meetings with various teams to understand the challenges in the previous upgrades
• Conducted regular meetings with Citi engineering team, Application Services team, DBAs and SAs to create and finalize the upgrade plan. Used MS Project to create and update this project plan.
• Extensively used Change Assistant for PeopleSoft Upgrade. Ran the upgrade job and completed the First Initial Pass for the Upgrade.
• Worked very closely with the application development for the process of retrofitting.
• CENTRIS and RAMP are relatively new applications. I am responsible for building these applications. A brief description of my responsibilities are
• Register a new Application ID for these applications.
• Perform a detailed analysis for the SAN, CPU, and Memory requirements for these applications. Review, and finalize the operating systems and naming conventions for this application. Located the software wraps required. Reviewed and fulfilled all the software license requirements. Put in the appropriate requests to procure the hardware with the required justifications. This was a very huge initiative and I had to coordinate with many teams. I had a series of meetings with the Application Managers, and the portfolio architect to understand the requirement, and to iron out all the details involved in the process.
• Worked with the SAs to allocate appropriate SAN and create the new file systems on the DB servers and file servers. Prepared a list of database schemas, roles, default users, table spaces, estimated sizes of each table space and worked with the DBAs to create these databases.
• Worked with the security team for new Functional ID and User ID creation. Created new Power Pack policy, and added the new servers, functional IDs and User IDs to these policies. Worked with database security team for database ID creation. Made sure all DB users have the appropriate roles assigned to them.
• We are planning to use IBM Natezza as future backend database for our data warehouse. Performed a proof of concept by creating a Natezza database, and loading GCBC data to the database for testing the new appliance. Conducted regular meetings with IBM consultants to understand Natezza appliance.

Confidenital

Project: Operational Risk has 2 PeopleSoft EPM applications Foundation and Basel , and a PeopleSoft PORTAL for single sign on. It uses Informatica as the ETL tools and is now moving to Ab Initio. It also has Hyperion BI tool. It uses AutoSys to run all the batch jobs. Currently all these applications are running on Sun Solaris Servers and having Oracle 10g database. There is a huge effort to migrate all Solaris servers to IBM pSeries AIX, Wintel platforms to VMware clusters and all RAID10 SAN to RAID5 and to move some applications to STEs Stared Technology environments . This move will give a huge cost saving.

Position: Infrastructure Lead

Environment: Application - EPM 8.9, Enterprise PORTAL 8.9, Tuxedo 8.1, Web Logic 8.1, People Tools 8.47,

Reporting: Hyperion, Cognos

Migrations: Quest STAT

ETL Application: Informatica, Ab Initio

Scheduler: AutoSys, PeopleSoft Process Scheduler

Tickets: Virtual Change RFC , Mercury Quality Center

Database: Oracle 10g

Operating System: Sun Solaris 9, IBM AIX, Win 2007

Responsibilities:

• Being a key member and the only onsite resources for the 24 7 COE Center Of Excellence group I was responsible for all the file object, PeopleSoft object, and Database object migrations. COE group is the group that has access to the controlled environments namely QA, UAT and Production for Foundation, Basel and Portal on both the existing and new Data Center. Every single byte of code or configuration that is developed by each team is ultimately implemented by COE Support Group. These requests vary in complexity and time consumption. This is in addition to the standard administrative activities of starting/stopping and maintaining the applications themselves. Some of my daily activities were as follows:
• Administration of 55 application servers, 40 web servers, 40 process schedulers, and 12 Informatica Repositories
• Support 38 Oracle databases and coordination with DBAs for refreshes, reboots, patching and tuning
• Coordination of all the server related activities reboots, patching, memory and storage allocation
• Migration of code PeopleSoft, Hyperion Reports, Informatica, and SQL scripts , and migration of Abinitio config files
• Migration of PeopleSoft releases using Quest STAT
• Copy of files for testing team, ETL profile changes, DDL executions table and index creations and changes , DML executions metadata updates, deletes and inserts
• SFTP key generation and configuration with partner systems
• NDM node configuration and connectivity setup with partner systems
• Since we were moving to a new data center, I had to build various PeopleSoft environments in the new datacenter. My responsibilities included installing Web Logic, Tuxedo, copying files from existing PS HOMEs to new PS HOMEs, creating application and web server domains, creating process scheduler servers, generating a pair of public/private keys, adding public keys from one server to another to enable SFTP, SCP and SSH.
• Performed database/environment refreshes on numerous occasions.
• Setup NDM on the new servers for file transfers. Also setup SFTP connectivity by adding the public keys of remote servers.

Confidenital

Project: Enterprise Financials Implementation integration of Financials and HCM and support and maintenance of existing HCM, ELM and Financials applications.

Position: PeopleSoft Administrator/Oracle DBA

Environment: Application PeopleSoft Fin 8.9, HCM 8.9 and ELM 8.8 People Tools 8.48 Tuxedo 8.1, Web Logic 8.1

Tickets: Mercury Quality Center

Migrations: Quest STAT

Database: Oracle 10g

Operating System: Sun Solaris 9 and Win 2003

Responsibilities:

• Build servers for PeopleSoft Financials, HCM, and ELM. Installed Tuxedo and Web Logic on the App/Web servers
• Created web clusters. Setup People Books on the web server. Created Application Server domains. Created Process Scheduler Servers. Setup master scheduler for Process Schedulers. Installed Micro Focus Cobol compiler on Batch Server
• Installed Oracle Application Server for a SOA suite product BPEL. Also installed BPEL engine on the OAS.
• Installed PeopleSoft on the File Server and mapped it to the workstations of all the PS developers so that they can run the PeopleSoft Clients of the file server. Created separate libraries of PS HOMES for Financials, HCM and ELM applications.
• Worked on all the tiers of PeopleSoft environment Application Server, Web Server, Process Scheduler and 2-tier clients . Supported these applications 24x7. Was on call on a rotational basis.
• Monitored all the databases using Oracle Enterprise Manager O.E.M. 10g DB Console. Carried out hot backup, cold backup through RMAN backup Restoration. Monitored database growth and sized databases as required. Monitored disk space usage, and balanced I/O load. Worked on troubleshooting connectivity issues and network problems. Monitored alert logs, error trace, free spaces, and file systems.
• Experience setting up PeopleSoft Security for HCM, ELM and Financials modules Created Permission Lists, Roles, User Profiles. Experience using Data mover utility for running many DMS scripts for exporting, importing PeopleSoft security and encrypting passwords.
• Experience Using Change Assistant. Knowledge of Environment Management Framework. Applied bundles and maintenance packs on Financials application, and tax updates on HCM application. Applied People Tools patches to upgrade People Tools from 8.48.04 to 8.48.09 and then from 8.48.09 to 4.48.15.
• Worked as a part of an integration team on integration between Financials and HCM applications. Setup local node and remote nodes. Executed many App messages and monitored them. Performed a lot of tuning on the server to handle huge messages.
• Maintained documents for all the setups, configurations and changes made in the environment. Created MS Word documents with screenshots, Excel spreadsheets, and Visio diagrams as part of the documentation.
• Worked on database refresh steps. Used data mover scripts for exporting and importing important tables, like the security tables and the configuration tables before the refresh. Did some manual configurations after the refresh too. Prepared a document for the refresh strategy and the before and after refresh steps to make sure no piece breaks in, during the refresh. Took database backups on a regular basis. Hot backup for production type databases and cold backups for non production type databases.

Confidenital

Position: PeopleSoft Administrator/Oracle DBA.

Environment: Application Fin 8.8/8.4, HRMS 8.8/8.3, PORTAL 8.4 People Tools 8.44/8.21 Tuxedo 8.1, Web Logic 8.1

Database: Oracle 10g/9i

Operating System: Sun Solaris, and Win 2003

Responsibilities:

• Worked on PeopleSoft HCM 8.3SP1 to 8.8 upgrade, and Financials 8.4 to 8.8 upgrade. Executed the Change Assistant job to perform the upgrade. Performed the first initial pass as well as many test move to production passes and the final move to production pass. Documented all the steps in the Change Assistant template. Included the timings for each step. This helped the client to decide on the go live window goals and eventually achieve the goals.
• Studies the documentations provided at PeopleSoft Customer Connection to understand the requirements for upgrade, evaluate hardware and software requirements, and validate platform certifications, and other related documentations.
• Performed migrations of projects from Development to Test to UAT to production as per the workflow defined and the business rules. Performed the compare project and set the upgrade flags as required.
• Worked on Production support. Handle on-going technical issues and generally troubleshoot and fix issues as they arise.
• Fine-tuned and created 'Gold Copies' of psappsrv.cfg and psprcs.cfg files. Also created 'Gold Copies of some PS HOMES. Created custom templates for Application Server and Process Scheduler configurations.
• Used Change Assistant to apply bundles, and maintenance packs.
• Installed and configured all the tiers in PIA setup The File server, Application server, Batch server, Web servers and Database server to support the PIA.
• Created many PeopleSoft environments. Created Web Server domains. Installed SSL certificates on the Web server. Created Application Server domains. Setup load balancing for Application/Web servers. Created Process Scheduler on the Batch server. Configured and setup Master Scheduler for various Test and Production environments.
• Installed Oracle and created PeopleSoft database. Worked along with the DBA for Database analysis and sizing of Production/Test databases, performance issues, Oracle server installation, and maintenance and supporting multiple test instances. Assisted the DBA with SQL tuning and running statistics on the database. Performed database refreshes from the production database as and when required. Performed system verification after the refresh. Created a document for database refresh and system verification. Performed cold backups for all non-production type databases.
• Configured Integration Broker setup. Activated messages, configured nodes and Integration Gateways, modified the IntegrationGateway.properties file and turned on the PUB/SUB processes on the Application Server.
• Made recommendations on hardware and Software to meet PeopleSoft certification and maximize performance. Also worked with PeopleSoft to validate HW/SW requirements for installation. Ensure all performance modifications are identified and documented.