Objective
peoplesoft admin


Summary

Over 7 years of result oriented professional experience in Analysis, Design, Development, Implementation, System and Database Administration and Production Support.

Over 6 years of experience as a PeopleSoft Application and Database Administrator supporting mainly PeopleSoft CRM, Financials and HRMS applications on DB2 UDB, MS SQL Server and Oracle databases.
Performed 4 full life cycle implementations, transition from the legacy system to the PeopleSoft ERP System.
performed 3 upgrades to PeopleSoft system version 7.0 to 7.5x and 7.5x to 8.x and 8. xx 12 to 8. XX 44
PeopleSoft Server Administration - expertise in installation, configuration, setup and management of the Database and PeopleSoft Internet Architecture PIA environment and related processing objects.
installed and configured Web Logic Server, Application Server components and Database Servers on UNIX or NT, MVS operating systems
Ensured system availability by implementing failover by spreading multiple domains across multiple hosts
Created multiple Server domains on separate host systems to access 1 database, an effective strategy for performance and tuning.

Extensive experience in refreshing development and QA from Production database, migrating changes to QA and Production, evaluating the required patches and applying them to the PeopleSoft system on a timely basis.
Experienced PeopleSoft Applications Administrator, performance problems with SQR reports, App Engine, tuning SQL, index creation, migration, version control and change management.

Well versed with requirement analysis, project planning and design skills, experience in developing technical specifications from functional requirements, planning technical implementations, customizing projects and upgrades and data conversion exercises.

O/S : Windows 9x/4.0/2000 Sun Solaris, AIX, Linux, HP-UX 10.20 OS390
ERP APPLICATIONS : PeopleSoft HRMS, Financials and CRM
RDBMS : DB2 UDB7/8MS-SQL Server 6.5/7.0/2000 Oracle 7. x/8. x/9/10g
PEOPLETOOLS : Administration Tools : Configuration Manager, Application Server, Process Scheduler and PeopleSoft UtilitiesDevelopment Tools : Application Designer, Business Process Designer, PeopleCode and Application Engine Security Tools : Security Administrator, Object Security, Query Security and Tree ManagerEnd User Tools : PS Query Tool
REPORTING TOOLS : SQR, Crystal Reports, nVision Reports
WEB SERVERS : BEA Web Logic 6.1/8.1 Apache, Microsoft IIS


Employment

2002 -  2003
DBA

Installed and configured the Peoplesoft DEMO and System databases and applications
Involved in resolving Performance issues and Database tuning
Create Indexes on the tables to increase the faster access
Run RUNSTATS on 1 or all the tables
Create multiple domains for the application server to reduce to traffic and maintain the load balance for the DEV, INT, STG and Production Environments
Create more the 1 weblogic server for 1 database instance and refer to the all configured application server for traffic diversion and load balancing
Scripting using Unix Shell, SQL, PL/SQL, Tuning of Databases both Application and SQL tuning
Production database maintenance and trouble shooting the problems.
Worked with hardware issues to make sure of memory leaks and network configuration for better performance
Creating tablespaces and alter tables and run PeopleSoft generated DDL Scripts
Make database refresh from the Production environments to Development and testing environments
Configured application server parameters to give best performance
Turn on the trace for the stress testing and monitor the hardware usage like CPU, Memory and network response time and SQL retrieval time etc., and analyze the trace file and take necessary action
Analyze and tune the SQLs in the Application Engine programs

Work included modifying the system from static to dynamic linked application

Modification of the existing partitioning of the database structures to balance the work load, performance tuning the batch cycle, conversion of data performance bottlenecks and load limits
Analyzed the process which are running slow and checked the tables behind the process and resolved the SQL and made changes to SQL to get the data faster and run RUNSTATS if necessary
Configured weblogic server for more than 1 application server and created multiple domains to get rid of bottlenecks
Installation of Real Application Clustering in Testing Environment
Create, test and maintain the staging, testing and development databases.
Changing the product environment with release updates for every major release.
Database backup and Recovery using RMAN with recovery catalog and with out recovery catalog
Tuning of Severs for Databases on O/S level.
Writing Shell Script which monitor the processes and pages the DBAs and System Administrator in the event of failure of any process
Setup of stand by databases and maintenance for OLTP database systems
Data modeling in both Physical and Logical Design for more than 500 table with DDL generation Apply PeopleSoft delivered patches and fixes for the PeopleSoft Application and Operating systems

2001 -  2002
Consultant

Involved in the Deployment and full lifecycle Development of PeopleSoft Application.
Involved in conducting meetings with users, technical or functional team and managers for generating specifications to accommodate client needs and establish standards while working in the capacity of a Technical Lead.
Providing a consistent user interface through simple and menu style navigation
Developed Self service functions and Integrating to PeopleSoft HRMS and FDM
Involved in the upgrade Process of HRMS/ FDM modules from 7.5 to 8.0/8.1
Database Administration for Production, DEV, INT and Staging Environments
Did SQL Tuning for retrieval of high data by resolving and running RUNSTATS on the tables

Check the status of the process Kill, Restart, re-Run the process
Involved in increasing the performance for overall system with Database, application and server tuning
Did analysis, trace and debug the process which are running slow and took necessary action to get good performance
Create, Alter the tablespaces and maintained the space for large volume of data
Configuring different instances with different Application and Web Servers
Creating Database and various DB2 objects
Involved in web server, Application Server configuration and set the parameters to get better performance in PSAPPSERV. CFG and configuraton. properties files
SQL and system monitoring and tuning.
Data/ Object Migrations, Backup and Recovery, Resolving Time-outs/ Deadlocks
Space management, ALTER, REORGS, RUNSTATS
Monitoring/ Tuning various Peoplesoft processes for Application Engine, SQR Reports, SQL Queries etc.,
Creating tablespaces, tables, index, views plans and packages
Configured Oracle for PeopleSoft Application and configured client
Executing PeopleSoft scripts and resolved the SQL Scripts
Database designing physical and logical data modeling using Cool Gen
Running REORGS weekly and on request, Daily image copies
Trouble shooting using Detector, Performance tuning using Insight
Involved in Resolving space related issues, Resolving security and authorization issues, Data Migration, DASD reclamation, Applications support
Involved in Writing DMS Scripts Across DMO and System Databases and wrote customized scripts for customized applications of HRMS and Financial modules

Developing Work List Pagelet for the integration of HRMS and FDM Workflow
Providing user group Employees with a user Friendly User Interface to Peoplesoft Applications
Installed the Enterprise Portal, Content Provider Portal Pack Projects for Peoplesoft Applications Integrating from Various Sources and making PeopleSoft Pages easily accessible for users from single Source
Developing Customized reports for the integration of Peoplesoft HRMS and FDM Repositories.
Implementation of HR Workflow and developing applications for Requests and Approvals upto 5 levels
Running PeopleSoft Delivered DMS Scripts for the implementation of PeopleSoft and Solutions
Made effective usage of Single Sign on Capability for PeopleSoft Applications avoiding the user to login to the various applications of PeopleSoft again and Again
Installation and administrating the BEA Tuxedo Application Server and Database Server
Worked On Application Messaging for Publish and Subscribe Process
Working with ePay providing online access for the employees to view 6 transactions like Direct Deposits, View Paycheck, Third Party Enquiry, Voluntary Deductions, W2 - Reissue Request and W4 Tax Information.
Updating the Tables for eRecruit for Applying Job, View Job Posting, Interview Schedules and Results. And eRecruit manager Desktop for creating of Job Requisition, Job Offer and Approval Offer and Preparing for New hire.
Working with Application Engine to create different Sections, steps and Actions for the steps.
Worked extensively in writing and modifying PeopleCode and SQR.
Analyzed, designed, developed various SQRs like Employee locator file, Charitable deductions Report, Head count Report, Union dues Report, Termination Report, Severance Report, Unemployment Wages Report, New Hire reporting for North Carolina State, Quarter to date Labor hours Report, QTD Standard Insurance Report.
Worked with the Process Scheduler to run the Process
Worked for Time and Labor Module for the Regular and Non Regular employees.
Developed an SQR to automate the enrollment process of new hires into the STD and LTD plan depending on the employee eBenefit program, employee type and job type.
Created several end user Public Queres like Union dues for a particular pay period and Year to date deductions for the employees, Terminated employee details for a particular location.
Helped the user to Run payroll processes and Custom Processes and troubleshoot the payroll Error Message, if any.
Helped in Creating Parallel test plans and helped in conducting Parallel Testing and comparing the results.
involved in documentation and end user training.
Providing Technical and Functional Production Support for all Interfaces, Reports and PS Application.

Role : PeopleSoft Consultant
Peoplesoft Consultant
Apr99 December 00
Project : Analysis, Configuration, Implementation, upgrade and production Support of PeopleSoft HRMS.

Analyzed the requirements and Set Up Payroll Tables like Paygroup, Earning Codes, Earning Programs, Pay Calendar, Runid, Shift, Form ID, Holiday Schedule and General Deduction.
Set Up HR Core Tables for New Companies and new Benefit Programs in HRMS Application.
Created Pay Calendar and RUNIDs for Parallel Testing. Ran Payroll Cycles like PaySheet Generation, Pay Calc and Pay Confirm and compared the Payroll Register with ADP Payroll Register.
Set Up HR Core Tables for New Companies and new Benefit Programs in HRMS Application.
Involved in Fit and Gap Analysis of PS HR, Base Benefit and Payroll Application.
Created Parallel test plans and conducted Parallel Testing and compared the results.
Provided Training to the user to Run Payroll Processes, Custom Processes, Reports and Troubleshoot the Payroll Error Message, if any.

Data Mapping and Migration of Employees Federal, State, Local Tax Data, Tax Distribution, Additional Pay, Direct Deposit, Garnishment, General Deduction and YTD Balances from ADP to PeopleSoft.
Analyzed, Designed, Developed and Tested, GL Interface, 401K Interface, Direct Deposit Interface and Check Reconciliation Process by using SQR.
Applied Tax Upgrades and recognizing changes in customized Reports and Processes.
Modifying, Compiling and Running Payroll COBOL Batch Processes.
Created Parallel test plans and conducted Parallel Testing and compared the results.
Created New Panel and Panel Groups to put new processes in Process Scheduler. Wrote People Code to assign Row Level Security for different Users.
Helped the user to Run Payroll Processes and Custom Processes and Troubleshoot the Payroll Error Message, if any.
Modified Check Printing Report for reading Signatures and MICR Fonts that stored on HP 8000 Series Printer. Loaded MICR fonts on HP Printer by using Font Loading Utility.
Designed and modified Open Enrollment Form and W-2 Forms for 2001.
Created Design and Training Document for HR and Payroll Application.
Created Operators and Operator Classes for users by using Security Administrator.
Involved in setting up control tables like Installation, Company, Location, Job Codes, Paygroups, Pay Calendars, State tables and etc.
Involved in implementing the PeopleSoft HRMS Web Client Application for the client.
Coordinated open enrollment processing with self service application.
Involved in implementing Benefits Administrator., Human s, Payroll on Self Service Application. These inclusive of Employee Information, Dependent and Beneficiary Information, Benefits Election, Flexible Spending Account, Online Paycheck Information and Time and Labor approval.
Web Client Application is tested to execute clearly. Validated and Granted Security Access. Used PeopleCode extensively on panel level customization and used PeopleSoft Applet Tags, Parameters, Operator Alias and used PeopleCode to Populate Search Dialog key fields.
Designed HTML files to Control the Toolbar Display, Hide Buttons, Used Secondary Panels instead of Scrolls, to hide Effective Dates, SetID or Business Unit keys and Minimized usage of Codes.
As Per Client Requirement Created New Query, nVision and Crystal Info Reports for HR, Benefit and Payroll Users.
involved in documentation and end user training.
Providing Technical and Functional Production Support for all Interfaces, Reports and PS HRMS Application.

Environment : PeopleSoft HRMS 7.0/7.51 PeopleTools, PeopleCode, SQR, Oracle, Windows NT, UNIX and Report Smith.

1997 -  1998

Project : Implementation and upgrade of PeopleSoft HR, Benefits and Payroll and Time and Labor.
Role : Technical Consultant
Responsibilities Include : Configured and customized PeopleSoft HRMS, Base Benefits and Payroll modules.
Participated in development and modification of custom PeopleSoft SQR reports.

Used PS, Tools skills to execute the new reports using Process Scheduler.
customized and tested records, panels and menus per business requirements.
Configured the systems using Configuration Manager, set up the client stations.
used SQL, People tools, Operator Security and Tree Manager.
Developed new Records, Panels, Menus and Process definitions.
Wrote People code, debugged the errors using trace options.
Worked on Process Scheduler to define Processes to enable the programs to run from PeopleSoft.
Technical Environment : PeopleSoft HRMS 6.0 PeopleTools, PeopleCode, SQR, COBOL, Oracle, Windows NT and UNIX

IT Pros Technologies India

1996 -  1997

Education

Miscellaneous

Role : Senior PeopleSoft Administrator
Period : Aug2004 Sep2005
Environment : People Tools 8.45 HRMS, FIN, CRM Application
Database : Oracle

Environment : People Tools 8.45.14 FSCM 8.8 and HCM 8.9 DB2 on AIX
Role : Install, Configure and maintain the PeopleSoft Databases

Created Databases DEMO, DEV, TEST, CONFIG and PRODUCTION databases on UNIX
Installed PeopleSoft applications People Tools 8.45 Application, Tuxedo 8.1 WebLogic 8.1 and Microfocus COBOL
Created Application Server Domains and Process Scheduler Domains
Installed PIA, configured PIA for all the instances of DEMO, DEV, TEST CONFIG, STG and PROD databases
Install and Configure DB2 Client and configure db2config Assistant to get 2 tier access to Developers and Users
Involved in the Performance of the databases and application by creating multiple domains across the instances
Configured and maintained multiple PIA s for PRODUCTION databases
Download Updates and Fixes and apply to the environments and maintain the customizations for the PeopleSoft
Prepared and maintained the documentation of all the installation and configurations of databases and applications
Involved in Knowledge transfer and Training for the users
Configuration of Integration Broker, defining Gateway, creating and configuring nodes for HR and Finance
Migration of Internal and External Objects of PeopleSoft

Role : PeopleSoft Administrator
Period : December2003 Jul2004
Environment : People Tools 8.45 HRMS, FIN, CRM Application
Database : Oracle, DB2
Project : PeopleSoft Server Administration, Upgrade, Data Management, Data Migration, Security Administration and Production Support

Involved in key role for full Infrastructure designing and development for CRM Applications
Experienced in the full life cycle Implementation and Production Support of PeopleSoft Applications and Databases.
Installed PeopleSoft Database and Applications on NT and Unix Operating Systems
Installed and configured MS-SQL Server
Updated databases by applying Updates, Fixes, Patches after backup on timely basis and kept the record of the updates, fixes, Patches
Configured Application Server, Web Server and Batch Server.
Configured Windows development clients to connect 2 - tier or 3 - tier to the database for development and administration purposes.
Installed BEA Tuxedo Appserver, WebLogic Web server, MS-SQL Server, Oracle and DB2 and created Peoplesoft DEMO and System Databases and Applied related Database patches and application Patches
Configured Tuxedo services for windows and Unix operating systems.
Installed and configured Web Logic Server 6.1 Application Server components namely Tuxedo, Jolt, PeopleSoft Processes PSAPPSRV, PSSAMSRV, PSQRYSRV, PSQCKSRV, PSDBGSRV, PSOPTENG. Connecting to MS-SQL Server, Oracle and DB2 database in Windows and Unix Operating systems used PSADMIN utility to Administer, Create and Delete Application Server and Process Scheduler Server.

Monitored the Server and Client queue status at several tuxedo domains
Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service
Changed the PSAPPSRV. CFG, PSPRCS. CFG configuration file for performance and tuning to specific environment.
Checked and cleared the application server cache on a regular basis as a maintenance process.
Setup trace logs at various levels like the Logfence parameter in Domain Setting Section in the APPSRV. CFG file, trace logs in Configuration Manager for SQL, PeopleCode, AE, etc and EnableTrace parameter in configuration. properties file on the Web Server.
Created Startup and Shutdown scripts for the Web Logic Web Server and Tuxedo Application Server and Process Scheduler Domains
Created multiple Web Logic Server instances
Wrote scripts to Create table, Views, Index for a Table, Export Scripts and Import Scripts for backup and Refresh
Installed PeopleBooks and configured the Web Server to access People Books.

Planned for the Upgrade, tasks like reviewing PeopleSoft Customer Connection for Applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and review documentation
Identified the team roles and responsibilities for the technical upgrade process
Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options project, update statistics and freeze PeopleTools.
Maintained and Supported for 20+ DB2 UDB Databases ranging from 40 GB to 200 GB

Involved in Logical and Physical Design of databases. Organization of tablespaces across file system for performance optimization.
Migrated several Projects from Development Database into QA Testing Database and then into Production after successful testing.
Involved in the setting up of various Operator Classes for the Financial implementation in all the 3 environments ie, Development, QA and Production Environments which included the Operator Class for Developers, Testers, Trainers, AP Approvers, AP Accounting, Project Administration, AR Viewers, Auditors, Business System Administrators, Database Administrators, GL Accounting Clerks, Technical Supporters etc., and assigned these Operator classes to Operators using Security Administrator PeopleTools.
Created several Jobs comprised of few Processes in the Process Scheduler PeopleTools depending on the functionality and interdependency. The Jobs were scheduled to run Daily AM, Daily PM, Weekly AM, Weekly PM and Monthly basis.
Trained users on PeopleTools like Application Designer, Data Mover, etc that are used for migration and created necessary documentation for them.
Created Documentation on Data Migration using related PeopleSoft Tools, administering Security and how to create Jobs with multiple Processes in the Process Scheduler with interdependencies.

Period : Mar2003 November 2003
PeopleSoft Administrator
Environment : CRM 8.4/8.8
Database : Oracle on Sun Solaris

Involved in Creation of Databases DEMO, DEV, TEST, CONFIG and PRODUCTION databases on UNIX
Installed PeopleSoft applications People Tools, CRM Application Tuxedo 6.1 WebLogic 6.1
Created Application Server Domains and Process Scheduler Domains
Installed PIA, configured PIA for all the instances of DEMO, DEV, TEST CONFIG, STG and PROD databases
Install and Configure Oracle Client and configure TNS files to get 2 tier access to Developers and Users
Involved in the Performance of the databases and application by creating multiple domains across the instances
Configured and maintained multiple PIA s for PRODUCTION databases
Download Updates and Fixes and apply to the environments and maintain the customizations for the PeopleSoft
Prepared and maintained the documentation of all the installation and configurations of databases and applications
Involved in Knowledge transfer and Training for the users
Involved in migration of the Objects across the databases
Performance tuning of application and databases
Troubleshoot issues of the Infrastructure and Production support
Supported for testing of the databases

As a DBA I was responsible for preparing guidelines for naming conventions, Menu design, Screen design, Function Specification and Program Specification. Development, Documentation and code Review along with Planning and Scheduling of the database.

IVR,

Is an interactive Voice Response System, Provides a near Personal to another wise routine customer service through its voice telephone based interface. 2 Modules comprise the application Questionnaire and Notifire. Every incoming call is presented with a series of Services by a set of wave files by the Questionnaire. On selection by way of number the system provides billing info, tariff etc.
The text to-speech conversion is handled through the SAPI interface of the Microsoft speech engine on requirement of specific details the call is transferred to stand by operator by the notifier

KCT Technologies India
Feb 95 Sept96
TITLE : SIMS 2000
Environment : Visual Basic 5.0 Using Oracle, SQL Server as Database

As a DBA responsible for the Analysis of the School data and Administration

SIMS

2000 School Information and Management System is a software package which gives a complete easy user interface and provides all types of transaction maintenance for educational institutions with high performance The features included in the package are

Maintaining Details without loss of Accuracy and Security
Analyzing the following

Faculty Evaluation, salary
Promotions
Monthly reports and updating
Yearly planning
Automatic triggering of payments and dues
Accurate Accounting and outstanding balances

KCT Technologies
TITLE : Vehicle Movement Management System
Aug94 - Jan95
Environment : COBOL

The package is developed for to store all the information of the Transport Company. The package includes the Company information to which the vehicles are supplying, the date of supply the ledger sheets, the employees working in the organization, It keeps the track of the movement of the vehicle from where to where it has gone and the schedule of the transportation. The reports are generated according to the monthly wise, vehicle wise, date wise and transport wise.