Professional Profile

Around Eight years of exhaustive experience as PeopleSoft Apps DBA/Administrator/Upgrade Specialist/Developer, which involve regular activities like application installation, administration, maintenance, upgrades, applying bundles, patches, fixes, tax updates and performance tuning apart from product support, data, query, user security and some development of PS processes, Interfaces, App. Engines, App packages etc. for every PeopleSoft product. Performed PeopleSoft Administration duties for HRMS/HCM, Finance/SCM, EPM, CRM and Enterprise Portal applications. I have assisted and performed Installations and Upgrades, developed client-specific Upgrade strategies, Infrastructure/Architecture strategies. And I was also in a role as Oracle DBA and SQL Server DBA performing duties like database cloning, refreshes, performance tuning, tweaking oracle database parameters for performance, space management, user security, data migrations, scheduling and automating jobs etc. My objective is to add value and make a positive difference for your organization through technology. I am reliable, conscientious and proactive team player.

Skills Summary

Relevant Project Experience

PeopleSoft DBA/Admin

Confidential

• Responsible for all phases of the HCM 9.0 project re-implementation on the infrastructure side which included the initial infrastructure design, installation and configuration of Development box, Testing Box, Pre-Prod box and Production box, performance tuning testing, deployment and Production support.
• Changed init.ora parameters to fine tune and accommodate oracle and PeopleSoft environments while installation.
• Involved in performing PeopleSoft HRMS tools Upgrades 8.19/8.49.07 and Financials / SCM tools Upgrade 8.44.17/8.49.07 using Change Assistant.
• Responsible for Production support of HRMS 8.19/8.0 and FSCM 8.44.17/8.4 sp2 mp4 .
• Installed HR/Benefits Administration 9.0 and production support.
• Installed Payroll/T L/TAM 9.0 and production support.
• I was involved in full lifecycle deployment of PeopleSoft HCM 9.0 Application and provide production support to HCM Portal applications.
• Designed the physical and logical layout of the servers based on user requirements, scalability and uptime requirements.
• Implemented Lightweight Directory Access Protocol LDAP Authentication on HCM 8.49.07/9.0 MP2 Bundle5
• Dynamic Role Assignment using LDAP, Active Directory.
• Implemented security for PeopleSoft environments SSL .
• Involved in implementing HCM 9.0 Security.
• Administered HCM 9.0 Security Administration which involves PeopleSoft Security definitions, Query and Definition security, Application data security and PeopleSoft internet architecture security.
• Worked on oracle wallet for the creating CSR's and importing CA's to implement HTTPS on PeopleSoft environments.
• Installed and configured Oracle OAS 10.0.1.3 and some performance tuning on this web server.
• Applied Patches Fixes, Tax Updates, Bundles, Maintenance Packs to non-production and production environments
• Involved in performing the Initial Upgrade, one Test Move to Production before a Final Move to Production.
• Applied Required for Upgrade RFUs patches, Maintenance Packs and application Bundles as necessary.
• Worked on implementing e-recruiting Talent Acquisition Manager .
• Worked with Resume Mirror Talent Tech INC for implementing e- recruiting.
• Implemented Candidate Gateway for e-recruitment.
• Setting up single signon between Enterprise Portal and Financials/SCM, HCM, CRM environments
• Configured the Integration Broker and Application Messaging setup between HCM and Financials in PeopleTools 8.49.
• Developed and maintained UNIX shell scripts and Windows Batch files for automating administration.
• Frequently running the Audit Reports on the Databases and fixing all the discrepancies in the PeopleSoft Databases and maintain integrity
• Worked extensively in Security by designing developing Roles, Permission List User Profile.
• Installation and Configuration of PIA on Windows NT/2000 and UNIX Boxes.
• Installed People Books for online availability for all the users.
• Migrated projects between PeopleSoft Instances using Application Designer.
• Researched on performance issues and plan for future growth in databases capacity planning including Hardware/Software.
• Involved in performing database refreshes /database cloning at the request of the developers.
• Database administration tasks like creating permission to users and services accounts for third party applications and PeopleSoft applications.
• Involved in database performance tuning and SQL scripting.
• Involved in tuning the table spaces, updating the statistics re-org of tables and indexes and SQL query tuning based on the execution plan and i/o's.
• Involved in developing HCM processes, Interfaces, App. Engine's for data conversion.
• Automated the process of purging the cache, starting and stopping of all the PeopleSoft Servers using shell and batch scripting.
• Assisted the load testing team in performance testing the new release by tuning the system appropriately.
• Proven ability to effectively troubleshoot systems administration issues and communicate.
• Training the Staff for Post Production Maintenance of PeopleSoft Databases also teaching them to maintain, configure of Application Server, Process Scheduler, PIA, User Security, how to look at error log, applying patches and bundles on PeopleSoft databases. Exporting and Importing of various PeopleSoft databases.

IT Environment: People Tools 8.49.07, 8.44.03, Finance/SCM 8.44.03/8.4 , HCM 8.19/8.0 to 8.49.07, HRMS 8.0 to HCM 9.0, Portal 8.9, Oracle 9.2.07, Oracle 10g, Microsoft SQL server 2000/2005, BEA Web Logic 6.1/8.1 SP5/9.2, Oracle OAS 10.1.3.1.1, Tuxedo 8.1/9.1, Solaris 2.9, Windows Server 2003, Upgrade Assistant, Change Assistant

PeopleSoft Admin/Oracle DBA

Confidential

• As the primary PeopleSoft architect, was responsible for the high-level design/maintenance of PeopleSoft infrastructure including web servers, application servers and batch servers. Significantly enhanced the application performance by addressing the PeopleSoft Internet Architecture issues. Was involved in successfully performing Application upgrades for PeopleSoft Financials and SCM 8.0 to 8.4 8.43.13 and EPM 8.0 to 8.8 SP1.
• Responsible for all phases of the project on the infrastructure side which included the initial infrastructure design, installation and configuration of software, performance tuning testing, deployment and Production support.
• I was involved in full lifecycle deployment of PeopleSoft Financials Application and provide production support to EPM Portal 8.8 applications.
• Design of the physical and logical layout of the servers 3 tier architecture was done based on user requirements, scalability needs and uptime requirements.
• Experience with load balancing and fail over mechanisms of PeopleSoft Applications.
• Worked on implementation phase which included installation of hardware and software, configuration of Application server and PIA and tuning of the PeopleSoft environment. PeopleSoft components such as Web server, Application server, Integration broker and Process scheduler were configured.
• Administered HCM 9.0 Security Administration which involves PeopleSoft Security definitions, Query and Definition security and PeopleSoft internet architecture security.
• User Oracle RMAN and Import/export utilities extensively.
• Performance monitoring was done during testing phase in order to identify problem areas and tune the system accordingly. Additional monitoring scripts were setup to monitor and notify on critical system events.
• Provided Production support 24x7 on Financials, EPM Portal project as PeopleSoft Administrator.
• Applied Patches Fixes, Tax Updates, Bundles, Maintenance Packs to non-production and production environments
• Involved in performing PeopleSoft Financials Application Upgrades 8.0/8.8 .
• Applied Required for Upgrade RFUs patches, Maintenance Packs and application Bundles as necessary.
• Involved in performing the Initial Upgrade, two Test Moves to Production before a Final Move to Production.
• Extensive experience with Integration Broker and Application Messaging in 8.48 and 8.43 environments
• Experience in configuring PeopleSoft single signon between Enterprise Portal and other Content Provider databases
• Developed and maintained UNIX shell scripts and programs for automating administration.
• Used Quest STAT 5.3.0 to migrate PeopleSoft objects non-PeopleSoft objects using STAT CSRs Change Service Request between QAT PRD environments and ensured the integrity of the servers which adhere to the migration workflow, and improved their change management practices
• Since there was no consistency in using Log on and Password i.e. same users had different User ID and Password. PeopleSoft LDAP MS Active Directory was implemented to resolve this issue of multiple OprID's in different PeopleSoft product lines Portal, HCM Finance using Active Directory
• Involved in performing database refreshes /database cloning at the request of the developers.
• Assisted the load testing team in performance testing the new release by tuning the system appropriately.
• Proven ability to effectively troubleshoot systems administration issues and communicate.
• IT Environment: PeopleTools 8.43.08, Finance/SCM 8.20/8.0 to 8.43.18/8.4 , Portal 8.9, Oracle 9.2.07, Oracle 10g, BEA WebLogic 6.1/8.1 SP5/9.2, Tuxedo 8.1/9.1, Solaris 2.9, Change Assistant, Web Sphere 5.1/6.1

PeopleSoft System Administrator

Confidential

• Assist with frequent project developers' requests for system configuration and database administration, and institute standard guidelines to streamline resource management and to standardize operating procedures that impact the technical infrastructure.
• Investigate opportunities for minimizing wall-clock time and, optimizing system performance by fine-tuning delivered PeopleSoft processes
• Worked as PeopleSoft System Administrator for the Implementation Project for PeopleSoft Applications HCM 8.3, Portal 8.4 with PeopleTools 8.41, 8.42, 8.43, Oracle 9i, Unix, Windows 2003
• Troubleshoot system Problems and the issues of Databases, PeopleSoft environment, Applications Financials, HCM, EPM, Portal and Technical issues and supporting the Developer needs
• Installed Benefits Administration and HR in HRMS 8.3
• Configure Application Server / Process Scheduler / Web server domains and perform tuning and load balancing as necessary
• Migrate PeopleSoft Objects and code between the databases and run compare reports for developers
• Upgrading People Tools from 8.42 to 8.43 and Application from Fin 8.3 to Fin 8.4 SP1
• Frequently running the Audit Reports on the Databases and fixing all the discrepancies in the PeopleSoft Databases and maintain integrity
• Researched on performance issues and plan for future growth in databases capacity planning including Hardware/Software
• Worked extensively in Security by designing developing Roles, Permission List User Profile for development environment.
• Wrote UNIX shell scripts for automated shutdown and startup of the entire PeopleSoft Application for maintenance purposes
• Expertise in configuration of PeopleSoft Web Servers Web Logic 6.1 on Sun Solaris environments.
• IT Environment: PeopleTools 8.41, 8.42 8.43, Financials 8.4/8.4 SP1, HCM 8.3, EPM 8.8 mp2, Portal 8.4, Oracle 9i, Solaris 2.9, Windows 2003

PeopleSoft Administrator

Confidential

• Dynamics Research Corporation has decided to Implement PeopleSoft HRMS, Financials/Supply Chain Management. I was involved in creating and administrating the whole project setting up Demo, Sandbox, Dev and Production databases. All the Databases have been PeopleSoft Certified.
• I was involved in the installation of Oracle 8i/9i Demo, Sandbox, Dev and Production Oracle Databases for PeopleSoft HRMS, PeopleSoft Financials/Supply Chain Management and Third Party Power plant on UNIX and Windows NT/2000 Boxes.
• Implementation and upgrade of PeopleSoft HRMS 8 SP1/8.8 applications in accordance with PeopleSoft procedure's from Scratch.
• Installation of PeopleTools8.42, PeopleSoft Financials/Supply Chain Management 8.42SP1 in accordance with PeopleSoft procedure from Scratch.
• Used Release Scripts with SQL Query tools after Install of PeopleTools after Data mover script to bring the PeopleTools version to latest version.
• Applied latest Patches and Fixes released periodically by PeopleSoft.
• Installed 2-tier Clients for developers, Functional users and Testers on Windows NT/2000.
• Installed BEA-Tuxedo and configured and maintained Application Server, Process Scheduler for all the databases on Windows and Solaris.
• Installed NT service for all Process Scheduler and Application Servers.
• Installation and Configuration of Weblogic by updating license and applying Service pack.
• Installation and Configuration of PIA on Windows NT/2000 and UNIX Boxes.
• Installed PeopleBooks for online availability for all the users.
• Migrated lot of projects between PeopleSoft Instances using Application Designer.
• Used Application Designer, Data Mover extensively during the upgrade process.
• Installed Crystal Reports for all the users on Windows NT/2000.
• Completely responsible for configuring, monitoring, and administering the PeopleSoft Demo, Development, Test and Production databases.
• Created Temporary Users, Permissions, Roles during the Demo, Development and Test Phases.
• Trained the DRC Staff for Post Production Maintenance of PeopleSoft Databases also teaching them to maintain, configure of Application Server, Process Scheduler, PIA, User Security, how to look at error log, applying patches and bundles on PeopleSoft databases. Exporting and Importing of various PeopleSoft databases.

IT Environment: PeopleSoft Financials SCM 8.8, HCM 8 SP1/8.8, PeopleTools 8.42/8.45, WebLogic 6.1/8.1 Tuxedo 6.5/8.1, Oracle 9.2.0.4, HP-UX 11.0/NT 2003

PeopleSoft Administrator/Developer

Confidential

• Installed, configured and maintained the PeopleSoft HRMS 8.0/8.3 and Fin 8.0/8.4 Process scheduler and Application servers.
• Expertise in installation and maintenance of PeopleSoft Internet Architecture using IBM AIX 5.1/Citrix/CarbonCopy environment.
• Successfully installed and Configured Web Servers using WebLogic 5.1/6.1 and PeopleSoft Internet Architecture.
• Practical experience in all phases of systems Project life cycle.
• Successfully installed PeopleBooks and People Tools 8.17/8.18 8.41/42 for HRMS and Financials environments.
• Successfully installed and developed Batch Process scheduler servers for HRMS 8.3 and FIN 8.4 .
• Responsibilities included support to PeopleSoft HRMS and Financials developers monitoring App/Web Servers, clearing cache files, generating trace files, bouncing App/Web servers, migrating projects between environments.
• Load balancing App Servers and Web Logic servers creating fail-over App Servers.
• Administration of Process schedulers on NT and AIX.
• Monitoring night batch jobs on critical days and on call production support.
• Created Workflow Emails and Work lists for Retirement, Location changes etc. Designed various Worklists to trigger at different conditions to inform the respective role users regarding the log errors/system errors during the nightly processes.
• Extensively involved in programming, loading and testing of payroll conversion data using SQRs.
• Created applications using Application Engine and performed background SQL processing against the data
• Wrote Dynamic and static SQL statements
• Production support for People Soft Human Resources and interfaces with legacy systems

IT Environment: PeopleSoft HRMS 8.0/8.3 HR, Payroll, Benefits , Finance 8.0/8.4 PeopleTools 8.16, SQR, SQL, and AIX 5.1, WebLogic 5.1 6.1

PeopleSoft Consultant/Developer

Confidential

• Worked at EPI as a Technical Infrastructure/Upgrade Specialist in a PeopleSoft HRMS 8.4, Financials/SCM 8.4, CRM 8.4, Portal 8.4, and Oracle9i 9.2 on HP-Unix 11i. Configured five totally new PIA environments on the patch servers and upgraded almost twenty current environments to PeopleTools 8.43.13 version and applied Service Packs on top of them.
• Created new Oracle and PeopleSoft databases
• Performed Oracle databases physical and logical backups and restores
• Helped fine tune Oracle databases query performance with TOAD and PeopleSoft app designer
• Added indexes, SQL query hints and run database statistics to help CBO optimization
• Configured PeopleTools 8.43.13 environments
• Configured CRM 8x Service Pack 1 with PeopleTools 8.17.13
• Configured HRMS 8x Service Pack 1 with PeopleTools 8.17.13
• Configured Financials 8x Service Pack 1 with PeopleTools 8.17.13
• Configured Portal 8x Service Pack 1 with PeopleTools 8.43.13
• Configured Weblogic 6.10 and installed its Service Pack 4 on all environments
• Configured PeopleBooks and verity search in all environments
• Installed and configured Oracle 9i software on HP enterprise servers
• Changed Kernel and init.ora parameters to fine tune Oracle and PeopleSoft environments
• Supported end user development/production issues and trouble-shoot any configuration issues
• Installed and applied patches/patch bundles to all environments
• Performed application tuning, database tuning and operating system tuning

IT Environment: Oracle9i, PeopleSoft Release PeopleTools 8.17, HRMS 8.4, Financials/SCM 8.4, CRM 8.4, Portal 8.4, Tuxedo 6.1, Crystals, WebLogic 6.1 SP4/5.1 SP13, HP-Unix 11i