Infrastructure Architect / Peoplesoft Administrator Resume
Atlanta, GA
SUMMARY
- Over 10 years of result oriented professional experience in Analysis, Design, Implementation, System Administration, Application Security, Upgrade and Production Support.
- Extensive experience in supporting the Majority of PeopleSoft applications, including HRMS, EPM, ELMS, CRM, FSCM and Portal.
- Supported the above mentioned applications residing on Oracle, MS SQL Server, Sybase and UDB DB2 databases in a UNIX (AIX, HP - UX, IBM and Solaris), Red Hat Linux and Windows Environments.
- Effectively carried out Four PeopleSoft Application upgrades version 8.3 to 8.8, 8.8 to 8.9, 8.9 to 9.0 and 9.0 to 9.1
- Involved in several PeopleTools upgrade from and
- Experience in Upgrade Assistant & Change Assistant Tool and used in deploying Patches, Bundles, Maintenance Packs and performing Upgrades
- PeopleSoft Server Administration PeopleTools v8.5x/v8.4x/8.1x/7.5x - Expertise in installation, configuration, setup, security and management of the PeopleSoft Internet Architecture PIA environment and related processing objects
- Successfully installed and configured BEA Web Logic Server 10.3.1/ 9.2/8.1/6.1/5.1 , and Tuxedo 10.3.0/9.1/8.1/6.5 and Jolt 1.2 on HP/AIX/IBM Unix, Red Hat Linux and Windows server.
- Experience in Content Management for Enterprise Portal Application 9.0. Designed a new migration strategy for migrating contents from one Database to another.
- Worked as a Security Administrator on PeopleTools 8.1x/8.4x/8.5x. Extensive experience in setting up User profiles, Roles, Permission lists, Tree Manager and running FASTVIEW, SJT processes
- Experience in SQR reporting, Component Interface, Application Engine
- Perform Installation / Creation of Database, Backups, Recovery, User Creation and monitoring the performance of Database in SQL Server 7.0, 2000 & 2005 and Oracle 9i, 10g, 11g.
- Hands on experience in creating shell scripts for monitoring Application Server, User counts etc.
- Worked with Sox Auditors to provide them with Sox data. Worked with Auditors in defining the Control Points for the Audit making sure that Segregation of Duties and Responsibilities are implemented
- Ensured system availability by implementing failover where environment continues operating after a Web Server, Application Server or Process Scheduler host goes down.
- Used BIG IP tool for Load Balancing and Failover.
- Perform Change Management of PeopleSoft Objects using STAT software.
- Setting up Security and Administering Workflow related to PeopleSoft objects in STAT.
- Created multiple Application Server domains on separate host systems to access one database for performance failover and business continuity planning.
- Tuned Application Server and Web Server as per client need.
- Extensive experience in refreshing development & testing environment from Production database.
- Evaluating the required patches and applying them to the PeopleSoft system on a timely basis.
- Experienced PeopleSoft Applications Administrator including performance problems with SQR reports, App Engine, and working with DBA to tune the Database configuration parameters.
- Object Migration between PeopleSoft Environments, Development to Test and Production.
- Experienced in Change control and Version control management.
- Worked as Secondary DBA in Oracle and SQL Server platforms.
- Extensive experience in installing Oracle software on HP/AIX/IBM Unix, Red Hat Linux and Windows server and applying required Oracle patches
- Experience in performing Hot/Cold/Export backups and restore processes.
- Experience in Oracle Enterprise Manager and used for administering day to day activities of Oracle and Performance Tuning. Knowledge in RAC, Data Guard and RMAN.
TECHNICAL SKILLS
ERP: PeopleSoft Financials 9.1/9.0/8.9/8.8/8.4/8.0/7.5 , HRMS 9.1, 9.0, 8.9/8.8/8.3/8.0/7.5 , ELMS .8, CRM 8.9/8.8, Portal 9.0, EPM 8.9
PeopleTools: 8.51, 8.50, 8.49, 8.48, 8.47, 8.46.xx, 8.45.14, 8.43.xx 8.42.xx, 8.21, 8.18, 8.17, 7.63
Administration Tools: Process Scheduler, PeopleSoft Utilities, Configuration Manager, Application Designer, Data Mover, Application Engine, Component Interface, Business Interlinks, PeopleSoft Security, Object Security, Query Security and Tree Manager, PS Query Tool, SQR, Crystal Reports, nVision Reports, Upgrade Assistant, Change Assistant, Quest STAT 5.2,Business Process, Workflow, COBOL, ExceltoCI
Application/Web Server: BEA Web Logic 9.2/8.1/6.1/5.1 , Web Sphere 4.1/5.1,6.1,Tuxedo 9.1/8.1/6.5
Databases: Oracle 9i, Oracle 10g, Oracle 11g, DB2 Mainframe/UDB, SQL Server, MS Access
Operating Systems: Sun Solaris, z/OS, AIX, HP-UX, Windows NT/2000/2003, 2008 Linux 4.0
SQL Tools: TOAD, SQL PLUS, SQLPLUSW, SQL Client, DB2 Client
Programming Languages: C, JAVA
Other Skills: MS Word, Excel, Visio, PowerPoint, Outlook and MS Project.
Call Logging Software: Remedy, Gold Mine HEAT, Siebel ERM & CRM, Perigirin
Schedulers: CA7, Control M, Autosys
Web Applicationmy: HR Internal Confidential Web Portal, Confidential Internal Applications like ESS, MAT, and AOLU
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
Infrastructure Architect / PeopleSoft Administrator
Responsibilities:
- Worked as Infrastructure Architect in administering Confidential mission critical application PeopleSoft CRM 8.8 running in People Tools 8.50.09 in Oracle 11g on AIX 6.1 Server
- Managing the CRM Customer Care and Order Management Applications for 13 states DSL Operations
- Administered the Load Balanced PeopleSoft Infrastructure running in 4 WebSphere Servers having 13 JVMs each and on 11 PeopleSoft Application Server
- Resized the PeopleSoft Performance Testing Environment by reconfiguring PeopleSoft Application Server configuration parameters. Worked with Load Runner Team in pumping the required Load.
- Reduced Online WebSphere JVMs and increased the JVM heap memory
- Troubleshoot the chronic issues like Timeout Error, Processing Error, Latency Issues occurring in CRM 8.8
- Designed the Patrol Monitoring Agent for monitoring CRM application in non - prod environment
- Performed Technical Analysis for new changes/enhancements and code releases
- Worked on Resizing the PeopleSoft Web Server Instances and improving the performance
- Trouble shoot the issues occurring on daily basis on PeopleSoft CRM 8.8 and other supporting applications
- Worked with Oracle Technical Team in trouble shooting issues reported in Application Server Logs like “Bad Challenge Error”, ”Out Of Memory Error” which caused issues for Online Users accessing CRM 8.8
- Automated routine tasks and streamline processes to increase efficiency
- Assisted Desktop Support Agents for issues reported in Creating Cases related to DSL issues
- Worked with Confidential &T Security Team in fixing Security Vulnerabilities reported in Security Scan
- Performed daily activities like checking the Web Servers, Application Servers and Batch Servers status, Integration Broker Messages and Space monitoring in AIX servers
Confidential, LA
PeopleSoft Upgrade Specialist, IT
Responsibilities:
- Working as Upgrade specialist in performing PeopleSoft Application Upgrade for HCM 9.0 - 9.1 and FSCM 9.0 - 9.1 in PeopleTools 8.51.06
- Performed People Tools Upgrade from PT 8.49.16 to PT 8.51.06 in both HCM and FSCM 9.1 Environments
- Installed and Created PeopleSoft HCM 9.1 and FSCM 9.1 Environments in AIX and Windows 2003 Server.
- Created DEMO Databases and configured Application Server/Web Server/Batch Server
- Applied all Required for Upgrade Bundle to DEMO and Target Environment for Initial Pass.
- Defined the Upgrade Strategy to include MP2 for HCM and MP5 for Financials
- Prepared GO-LIVE Implementation Plan related to Upgrade activities for HCM 9.1 and FSCM 9.1
- Performed End to End Complete Upgrade Execution for HCM 9.1/FSCM 9.1 Initial Pass,MTP1, MTP2 and GO-LIVE
- Refreshed all the environments with the Copy of Production from Source and performed the upgrade for 3 life cycles in both HCM 9.1 and FSCM 9.1
- Created Application Server Domains and Process Schedulers for the upgraded environments.
- Configured Weblogic server for the above domains.
- Worked with functional users on pre upgrade and post upgrade tasks.
- Configure Integration Broker between HCM and FSCM 9.1 Environments.
- Installed PeopleSoft Change Assistant and defined additional steps based on Client requirement
- Created Source and Target Environments in AIX and NT Server
- Post Refresh steps are performed for Databases in each execution pass of HCM and FSCM Upgrade
- Retrofitted the Customizations and Identified the customizations to be made after Initial Pass Execution
- Performed the Initial pass Execution of HCM 9.1 and FSCM 9.1 and fixed the Defects
- Synced the Externals across the Environments
- Applied MP2 to PeopleSoft HCM 9.1 and carried forward in Development and Test Environment
- Applied Bundle 4, 5, 6 and 7 to all HCM 9.1 Environment to address T &L Performance Issues and Approving Time
- Performed the Audit Cleanup of Databases before starting Upgrade passes
- Assisting Development and Functional Team in Retrofitting and Issues/Defects reported during Upgrade
- Configured Environment Management HUB and tested the Agent running by deploying files using sample Patch Template.
- Applied MP5 to FSCM 9.1 Environments
- Configured Bonus Depreciation Changes for FSCM 9.1
- Synced up Security, Trees, and Queries from current Production to Upgraded Production Environments.
- Configured REN Server for non Prod FSCM 9.1 Web Server used in Financials AP module posting.
- Responsible for maintenance of security and disaster recovery plans
- Performed Production Support after GO-LIVE which includes supporting the environment 24*7
- Implemented LDAP authentication for new environment.
- Installed and Configured SSL for Production Environments for HCM and FSCM 9.1
- Configured REN Server for SSL enabled FSCM 9.1 Production Web Server
- Worked with Functional and Development Team in fixing AWE issues related to T&L module in HCM 9.1 Environment. Co-ordinated with ORACLE for the same and applied different POC’s.
Confidential, Maumee, OH
PeopleSoft Infrastructure Lead
Responsibilities:
- Working as Infrastructure lead in redefining the existing Infrastructure and Services from IBM AOD
- Administering the Existing PeopleSoft Application HCM 9.0 MP3 and PeopleTools 8.49.07 running in Oracle 10g on AIX 6.1 Server
- Did Infrastructure Migration of PeopleSoft Application from IBM Data Center to Confidential Maumee Data Center
- Worked with Different Groups like Firewall, Unix, Windows, Oracle Database in defining the strategies and Steps to be performed during each phase of Infrastructure Migration
- Worked with Unix Admin in defining the File System, Required Patches and creating psdan user
- Installed Tuxedo 9.1 RP 095, Web Logic 9.2 MP3 in Non Production and Production Environments
- Worked with Oracle DBA in defining the File System and restoring the Database from Cold Backup provided by IBM AOD Team in Non Production and Production Environments
- Installed PeopleSoft HCM 9.0 MP3, PeopleTools 8.49.07 in Windows 2008 Server and synched up the External Directories from IBM AOD.
- Configured PeopleTools utilities like Configuration Manager, Application Designer, Change Assistant, Data Mover, Excel to CI utility in Windows File Server
- Configured Environment Management HUB and tested the Agent running by deploying files using sample Patch Template.
- Configured Process Scheduler PSNT in Windows Server and created Application Server for Test Run in Non Production Environments. Verified the Installation by performing Instance Verification Test.
- Untar the Unix PS HOME in AIX Server and defined PS HOME in all Non Production and Production UNIX Servers. Configured Application Server, Process Scheduler PSUNX in above servers
- Configured Report Node Definitions and Failover Configurations in Configuration. properties in Web Server
- Defined the Integration Broker Gateway and configure Node Definitions
- Installed People Books and configured Search and enabled Help link from PeopleSoft URL.
- End to End Testing was completed by involving different groups like HR, Benefits, Payroll and getting their Sign Off for moving to Production
- Successful implementation of Mock Migration to Production Environments
- GO-LIVE activities are published and performed a Successful Migration to new Production Environments
- Detailed Weekly Maintenance / Monthly Maintenance by PeopleSoft Support Team are defined and executed with few challenges. Process Improvements are still under progress.
- Alert Notifications Setup for monitoring File System of Database Server/Application/Web Server
- Worked with Oracle DBA in reusing the existing Backup/Recovery Procedures followed in Confidential
- Defined the Environment Migration Cycle and Refresh Schedule for Non Production Environment
- Perform all the Non Production Change Control Activities like SQR, Project Migrations, Cobol Compilations
- Apply Tax Updates delivered by Rimini Street a 3rd party vendor in Non Production Environments and act as a Single Point of Contact from Confidential helping in end to end Coordination
- Coordinate with IBM AOD team for performing Migrations in Production Environment
- Performed the cleanup of DDDAUDIT/ SYSAUDIT which provided greater visibility and appreciation from Client. Defined the Maintenance Plan in cleaning up the Audits on regular basis.
- Created Business Requirement Document, Software Requirement Specification, Technical Design Document and Work Breakdown Structure for cleaning up DDDAUDIT/SYSAUDIT
- Perform Pre Refresh and Post Refresh activities for the Database Refresh in Non Production Environment
- Created Standard Operating Procedure (SOP) which is used by IBM AOD for refreshing PeopleSoft Databases of Non Production Environments
- Installed PeopleTools 8.48.07 in Confidential hosted Citrix Server and configured according to User Requirement
- Worked with Firewall Team in identifying the Ports to be connected through Citrix application Server to IBM Servers. Identified the Time Out Settings and helped in Improving the Performance in Citrix
- Automated Alert Notification for PeopleSoft Processes running in PeopleTools Process Scheduler
- Defined Deployment Life Cycle for Tax Updates / Migrations across the Environments
- Cleaned up Database Users, Database Links, PeopleSoft OPRIDs in Non Production and Production Environments
- Coordinate PeopleSoft Administration Activities from Onshore/Offshore Ongoing Support Team and complete those meeting Confidential SLA Requirements
- Created PeopleSoft Security Matrix, Access Tracker, Run Book, Configuration Management Plan for Confidential
- Defined the Process Flow for applying Tax Updates which are delivered from Rimini Street across the PeopleSoft Environments
- Worked with Confidential SOX Auditors in defining the Segregation and Responsibilities of PeopleSoft Application Users. Provided Security Data to Confidential Security Auditors and worked with them in identifying the Roles which are exceeding its functionality.
- Worked with IBM AOD for Infrastructure Operation Support Activities
- User Assistance for PeopleSoft Security Administration Team in helping them in their Security Tasks adding required Roles to existing Users based on Security Access Matrix. Redefined the existing PeopleSoft Security by working with Business Users and cleaning the Roles/ Permission List/User Profiles.
- Administer QuickR Application, a knowledge repository for storing Team Documents and used as a Change Control Tool for versioning the Work Request Documents. Grant Access to new Users, Modify existing User Access and control User level Permissions according to their Role.
- Also worked as a Business Analyst for implementing Interfaces for Enterprise Single Sign On Applications connecting to Partner Sites like Vanguard, AON and ACS from Confidential Web Portal
Confidential, Hillsboro, OR
PeopleSoft Architect/Administrator
Responsibilities:
- Production Support for existing PeopleSoft applications HRMS 8.8, EPM 8.8 running on PeopleTools 8.46.03 and CRM 8.9 running in PeopleTools 8.45 on Windows Server
- Monitor the ERP Support Mailbox and trouble shoot the PeopleSoft issues occurred during business hours
- Work with the offshore team in assigning the off hours tasks like Post Completion Steps after Refresh, COBOL Compilation and verify the tasks
- Apply Bundles, Tax updates to existing PeopleSoft Pre-Production and Production Environments
- Worked on adding Russian Language to existing CRM Application
- Worked on the mail server issue occurred in CRM Application and helped in fixing the issue
- Worked as PeopleSoft Technical Architect in implementing new Hardware for existing PeopleSoft Servers
- Designed the PeopleSoft Architecture for the new Hardware Windows Servers and created the architecture diagram
- Worked with Different Team in identifying the tasks to be performed by each team for Hardware Upgrade
- Created Project Plan for implementing the new Hardware for the existing PeopleSoft Production and Pre-Production environments
- Weekly Review meetings are conducted to make sure that the tasks are performed by each team without issues. Captured the issue logs and worked with the respective teams accordingly
- Installed, Configured PeopleSoft Applications in the new Hardware boxes running on clustered environments. Created Web Servers, Application Servers and Batch Servers in the new Windows Server
- Conducted Offshore training and Onsite Training for SAP Team about the PeopleSoft activities carried out in Confidential Corporation
- Documented all the tasks which are performed during my tenure and did knowledge transition to team
- Created Build Documents which walks through the entire Installation Process of PeopleSoft Installs
- Was Involved in implementing Disaster Recovery for the PeopleSoft Servers and worked with Oracle team in verifying the Data Guard Installation
- Created Scheduled Tasks to execute Scripts for shutting down and starting the PeopleSoft Application Server, Batch Server during weekly maintenance
- Updated the Server Information in KCDB ( Confidential ’s Knowledge Repository) for existing ERP Servers
- Verified the ILO connectivity for all the ERP Servers and worked with the Data Center team in configuring for servers with no ILO connectivity
Confidential, Virginia
PeopleSoft Architect
Responsibilities:
- Successfully Upgraded PeopleSoft HCM 8.9 to 9.0 and PeopleTools 8.4 .17. Installed Tuxedo 9.1 and Web Logic 9.2. Installed PeopleTools 8.49.17, HCM 9.0 and created a Demo Database
- Installed Oracle 10g software and upgraded to 10.2.0.4 version in Linux RH 4.0 server
- Performed an Oracle cold backup of Demo Database and created another Database as Standby database.
- Configured Application Server, Process Scheduler and PIA for the new Demo Database
- Applied Bundles and Required for upgrade in new Demo Database
- Performed the upgrade from Application 8.9 to 9.0 and Tools 8.4 .17 using Change Assistant.
- Installed the higher version software over existing file system and rebuild the application server, process scheduler and PIA for Copy of Production Database.
- Working on Move to Production phase with the new Copy of Production Database.
- Administering Application Servers, Batch Servers & Web Servers running for HCM 8.9 PT 8.47.04, CRM 8.9 PT 8.47.06 and Portal 9.0 PT 8.48.09
- Did migration of PeopleSoft Development, Training environments from egenera boxes to new boxes
- Created new Web Server Domains, Application Server Domains, and Process Schedulers for the above environments.
- Reconfigured the Integration Broker with the new gateway URL.
- PeopleSoft Portal Content Management from one environment to other. Has created our own practice as PeopleSoft don’t support content migration.
- Exporting the Pagelets and Content Reference tables from Source and Importing in the Target Database.
- Change Request Management, Version Control using STAT for PeopleSoft tool
- Automated patching, Migration Management and Auditing & Reporting on required basis using STAT tool.
- Managing CSR console, Job monitoring on daily basis using STAT tool.
- Upgraded Quest STAT from 5.2.0 to 5.3.2. This involved three test upgrades to make sure STAT works as designed for the existing HCM, CRM and Portal Environments.
- Performed multiple migrations using STAT Quest 5.2.0/ 5.3.2 which included migrating PS/ Non PS objects. Performed Impact Analysis and applying PeopleSoft Patches using ACM STAT process.
- Did migration of Plateau AOLU system from egenera boxes to new hosts co-coordinating with Web Server and DBA team.
- Monitored the daily jobs running in auto sys and fixing the data issue if any. Running the Brio Reports daily. Scheduling the Jobs in Autosys. Working on Remedy requests created by the users.
- Migration Activities in PeopleSoft and non PeopleSoft applications
- Created mirror environments for performing Tools Upgrade. Configured Application Server, Web Server for the new upgraded environments.
- Ran the PeopleSoft post refresh activities and Confidential steps.
- Performed Tools Upgrade from PT 8.47.04, PT8.47.06 to PT 8.48.09
- Applied Maintenance Packs MP6 Cumulative to HCM 8.9, MP 9,10 and 11 to CRM 8.9
- Configured Integration Broker and Single Sign on between these Databases.
- Working with DBA team for Database refresh and performing post People Soft DB Refresh
- Managing the Architecture Diagram. Worked on the Product Support Document (PSD)
- Working on the monitoring scripts for PeopleSoft Application Server and Process Scheduler
- Managing Confidential Internal Web Applications like AOLU, Time Trak, Brio Reporting and Other applications like MAT,ESS,Goalign
- Preparing checklists for daily activities and prepared Operations Manual for Corporate Systems Operations Team.
Confidential, Charlotte, NC
PeopleSoft Infrastructure Administrator
Responsibilities:
- Played a Key role as Technical Architect in setting up People Soft environments for Confidential International Common People Reporting Platform (ICPRP).
- Installed PeopleTools 8.49, applied product patch 04 and installed EPM 8.9 Application Software to run on an Oracle Database 10g platform on Solaris Server. Installed the same in Windows File Server.
- Installed Tuxedo 9.1 and Jolt components to support 8.49 PeopleTools Installation.
- Installed Web Sphere Network Deployment Application Server 6.0 on Solaris Server
- Created Databases for People Soft EPM Application and Cognos Application
- Created People Soft Demo Database and refreshed for other environments
- Installed Ascential Data Stage 7.5.1 in Windows File server and Solaris Server
- Installed multiple environments namely Demo, Development, and UAT Testing
- Installed People Books and configured Search and enabled Help link from PeopleSoft URL.
- Worked on PeopleSoft Security for EPM modules - Created Permission Lists, Roles, User Profiles
- Worked closely with PeopleSoft development team, functional team, DBA team, Wintel team, UNIX server team and storage team.
- Applied Patches, Maintenance Pack Cumulative version 4 and Delta 5 in EPM Demo Database and migrated to all other Environments using Change Assistant.
- Configured Application Servers and Process Scheduler Servers with different templates and tuned the configuration parameters based on the type of usage.
- Performed Database refresh on a weekly basis
- Exported and imported Peoplesoft security using Datamover scripts
- Created and Maintained environmental documentation by updating documentation, in a timely fashion, to reflect infrastructure changes, tuning procedures, other techniques.
- Supported and participated in maintaining a current application infrastructure.
- Installed People Soft HCM 8.9 & PeopleTools 8.47 on Oracle 10g database on AIX server.
- Installed Web Logic 8.1, Tuxedo 8.1 and Jolt components to support 8.47 PeopleTools Installation.
- Installed all the patches required for upgrade.
- Installed multiple environments namely Demo, Development, UAT Testing, Performance Testing, Training and Production environments. Installed Change Assistant and created Jobs for upgrading the databases.
- Installed People Soft HCM 8.9 & PeopleTools 8.47 in Windows File Server
- Upgraded the existing version of HCM 8.8 to HCM 8.9 and PeopleTools 8.43 to PeopleTools 8.47
- Worked with DBA’s in tuning conversion programs while running the upgrade
- Worked closely with DBA to fine tune SQR’s. AE’s, nVision etc and updating statistics
- Involved and performed TMTP1, TMTP2, TMTP3 & MTP till Production GO - LIVE
- Worked with functional users on pre upgrade and post upgrade tasks.
- Generated compare reports between projects and databases for analysis and migrations.
- Configured Ren Server. Implemented LDAP authentication for new environment.
- Created separate Integration Broker/App Messaging App Server domain and Nodes for the Source and Target PeopleSoft Applications including configuration of integrationgateway.properties file to include the Node Names of the Default and Remote Nodes.
- Setup PeopleSoft Performance Monitor for environment testing.
- Worked with re-platforming team in analyzing the changes made to People Soft in converting from Mainframe to UNIX platform.
- Worked with the conversion team in checking the Data validity /integrity from Mainframe to Oracle DB
- Worked with loadrunner team to crate load on various servers under test before deployment as part of performance testing.
- Refreshed all the environments with the COP from Source and performed the upgrade for 3 life cycles.
- Created Weblogic, Application Server Domains and Process Schedulers for the upgraded environments.
- Created multiple servers for Load Balancing and Fail over clustering.
- Worked with the Control M team in scheduling the jobs from COBOL to SQR
- Performed all Change Control Activities like Project Migration, External Migrations, and Cobol Compilation upon developer’s request. Followed the Change Control procedures.
- Monitored, Detected, Analyzed, fixed and communicated problems that degrade the predictable delivery of business application services. Processed migrations to Testing and Production databases quickly and efficiently adhering to Change Management standards.
- Responsible for maintenance of security and disaster recovery plans
- Performed Production Support after GO-LIVE which includes supporting the environment 24*7
- Applying the latest bundles, tools patches and Maintenance pack for existing environment for Demo, Development and UAT instances
Confidential, The Woodlands, TX
PeopleSoft Administrator
Responsibilities:
- Worked as PeopleSoft Administrator for Quaker and Frito-Lay divisions of Confidential
- Monitoring the Application Server Domains, Process Schedulers and Web Server Domains running on People Soft HRMS 8.0 SP1 PT 8.21 and People Soft HRMS 7.5 PT 7.63
- Involved in Server Migration from NT to Windows 2000 and installed all People Soft Applications and reconfigured Application Server Domains
- Applying Tax updates to all the environments and working with Migration Team in moving to Production Environment. Applied DST patches to all existing environments
- Involved in migration of Citrix Servers and Installed PeopleTools executables in Citrix Servers for developers accessing People soft
- Installed BEA Tuxedo on multiple servers on windows and UNIX operating system.
- Performed Production Support Activities like Project migrations, External Migrations
- Worked with different Hewitt internal teams for migrating the above components and adhere to Hewitt - Confidential process compliance
- Installing, Creating and Configuring PeopleSoft Domain in SIT, UAT and Production Environments for myHR web application.
- Supporting all the technologies like People Soft, Messaging Servers, Workflow Engine & Message Adapters
- Running queries in Oracle Database and fixing the user transactions or data issues.
- Triggers created for all the People Soft Databases. Setting Up Services for all the Messaging Adapters.
- Citrix Server setup for Hewitt Developers to access the above environments.
- Administered People Soft Application servers, Workflow Engine. Did Performance Tuning for the same.
- Migrated People Soft changes from one environment to other.
- Monitored the Siebel ERM, CRM and Workflow Tools and fixing the transactional issue of the Instances
Confidential
PeopleSoft Application Administrator/ Upgrade Admin
Responsibilities:
- Application Server/Process Scheduler / Web Server Configuration for Navisite Customers maintaining different People Soft Application versions like HRMS 8.x, Financials 8.x & Portal 8.x
- Worked with different versions of PeopleTools and upgraded tools starting from PT 8.21, 8.43,8.45
- Performed a PeopleTools Upgrade from using Change Assistant for a client supporting ELMS 8.8 application
- Performed an upgrade from Financials 8.3 to Financials 8.8, PT for one of the clients of Navisite using PeopleSoft Upgrade Assistant.
- Perform Environment Refreshes and Database Refreshes for clients of Navisite on daily/weekly basis
- Applying Tax Updates, Patches and Fixes. Performing Tools Upgrade and Service pack Upgrades
- Requirement Analysis study before the deployment of Patches. Analyze the patch document and identifying the pre-requisites and post-requisites
- Perform any manual steps as mentioned in the patch document based on the order.
- Migrating Custom Projects/Reports across various environments
- Troubleshooting issues related to PeopleTools and Application configuration
- Analysis of Database Compare, DDD Audit, SYS Audit, Alter Audit fix
- Working on 24*7 and involved in performing both Change Control and DBA activities.
Confidential
PeopleSoft Production Support DBA
Responsibilities:
- Daily Routine work that involves releasing the memory locks in Application, Database & Web servers.
- Monitoring the entire system and tuning the applications for a better performance by end users.
- Database Refreshes using SQL Server 7 and 2000 version.
- Successfully upgraded the PeopleTools .12 in the Production Environment.
- Creating new SQL Server DTS packages based on request from Internal Support team
- Implementation of PeopleSoft servers and SQL instance for the new PeopleSoft Module. This implementation includes establishing Web server, Application Server and Database server on three different high - end machines with appropriate installation.
- Handled the PeopleSoft Production Environment Migration to the powerful machines, which involved Installation of Web Logic 5.1.0 SP6 on Web Server. Installation of PIA, PeopleSoft Applications HRMS 8.0 SP1, Financials 8.0 SP1, PeopleTools 8.19 on Application Server.
- PeopleSoft Database Upgrade from SQL 7 to SQL 2000, which involved challenging tasks like creating the new instance of the PeopleSoft application as per our requirement.
- Populating the production data in the new instance and checking for data integrity.Recreating Indexes for the whole production database. Fine tuned Indexes and clusters to have high throughput.
- PeopleSoft Application being an online transaction processing (OLTP), tuned the database to support a large volume of transactions which involves,
- Reactive tuning to improve Production System Performance by updating STATISTICS on regular basis.
- Worked as People Soft Security Administrator, which involved in Analysis, Planning & Designing of Complete Secured PeopleSoft System.
- Preparation of Requirement Analysis Document and Functional Specification Documents.
- Creation of Access Groups, Roles, Permission Lists and attaching the same to the User Profiles based on the functionality they perform in Confidential .
- Designing Workflows for different Business process applications based on the requirements.
- Creation and Maintenance of Tree structures for different corporate using Tree Manager Application tool.
- Developed a complete secure PeopleSoft system allowing the Users to perform/ view their own operations only adhering to Confidential Security standards
- Production Support involves in Bug - fixing, Error Handling, and Development. & Testing according to the requirement from the users. Assisting Front end users to perform their Application functions effectively.
- Generating Reports, SQL Queries, PS Query, and Crystal Reports etc.
- Customizing PeopleSoft applications according to the requirements from the Functional Team