SUMMARY

• Over 13 Years of Total IT experience which includes around 9 Years experience as a PeopleSoft Application Administrator/DBA supporting mainly PeopleSoft HRMS, Financials and CRM applications on Oracle, DB2 and MS SQL Server databases
• Expertise in installation, configuration, setup and management of PeopleSoft Internet Architecture (PIA), Database and related processing objects.
• Successfully performed multiple Application/Tools upgrades.
• Expert Architect in designing peoplesoft PIA architecture considering redundancy, scalability, optimal performance and sizing, tuning, capacity planning of PIA components.
• Experience in Tuxedo Administration and Application Server Performance Tuning.
• Expertise in designing and setting up messaging architecture for peoplesoft
• Performed full life cycle implementations, transition from the legacy system to the PeopleSoft ERP System.
• Experience in installing, configuring Web Logic Server, Application Server components and Database Servers on UNIX (AIX, HP, Solaris and Linux)/ Windows NT operating systems.
• Experience in PeopleSoft Applications Administration including performance problems wif SQR reports, crystal, nvision, Cobol/remote Cobol, App Engine, tuning SQL, index creation, migration, version control and change management.
• Possess excellent troubleshooting abilities to maintain corporate PeopleSoft infrastructure systems components Oracle, BEA Weblogic, Tuxedo Servers and Process Scheduler etc.
• Experience in configuring peoplesoft webservers wif third party load balancers like Cisco, BIGIP and Citrix Netscaler.
• Solid experience in setting up Peoplesoft Peopletools and Application security by configuring required Roles, Permission Lists, Object Groups and Query security.
• Experience in setting up and maintaining external (DMZ) webservers and working wif security team to open ports through firewall (rules/policies).
• Experience wif Batch scheduling softwares, AutoSys, Tivoli and ControlM, UC4.
• PeopleSoft Development experience wif Application Designer and Query Tool.
• Experience in setting up LDAP for peoplesoft integrating wif various directory servers, single signon between peoplesoft to peoplesoft and peoplesoft to third party systems
• Expertise in Configuring Peoplebooks context sensitive help, Verity Help on both windows and unix platforms.
• Migrating changes from Development to test through Production, valuating the required service packs, rolling patches, product patches, updates, bundles and applying them to the PeopleSoft system on a timely basis using Change Assistant.
• Expertise configuring integrations between peoplesoft 8.4x system to 8.4x system, 8.4x to 8.2x system to IBM MQ series, 8.4x system to third party - using Integration Broker.
• Expertise in setting up and publishing peopletools and related tools onto citrix server for offshore access.
• Experience wif PeopleSoft SOA and sound noledge of Oracle fusion middleware.
• Expertise in Project migrations using Quest Stat, Phire, Data migrations using Datamover from one environment to another.
• Installation of oracle software, creating database instances, configuring tuning of instances, space management, backup and recovery.
• Involved in Windows Batch scripts, Unix shell scripting, setting up LDAP for peoplesoft integrations.
• Extensive experience in Refreshing Development /Test / QA /PreProd from Production database using RMAN.
• Expertise in Query optimization, DB Optimization, building better indexes for the tables and fine-tuning of existing indexes.
• Experience in setting up RenServer and Performance Monitor for peoplesoft.
• Involved in installing cobol compiler for peoplesoft and third party softwares like mohamine.
• Experience in setting up Microsoft share point for documentation, developing workplans, creating tasks using Microsoft Project.

TECHNICAL SKILLS

Enterprise Applications: PeopleSoft HRMS, FINANCIALS SCM, CRM, PORTAL and EPM, ELM

Languages: People Code, SQL, PL/SQL, C, C++, Java, VB, UNIX Shell and Batch Scripting

Servers: BEA Web Logic 8.1,9.2,10.3, IBM Web Sphere, Microsoft IIS, Apache, Tuxedo 6.1,8.1,9.1, 10gR3

RDBMS: Oracle 8.x/9.x/10g/11g, DB2, Sybase15.0, MS-SQL Server 2000/2005

Reporting Tools: nVision, SQR, Crystal Reports

Operating Systems: Windows 2000/2003/2008 , HP-UX, Sun Solaris, OS/390, Linux, IBM AIX

Tools: & Utilities: Oracle Enterprise Manager, Erwin 3.x, SQR 3.5, 4.x, SQL Loader, SQL Plus, Toad.

Development Tools: Application Designer

Administration Tools: Data Mover, Application Designer, Object Security, Upgrade/Change Assistant

Reporting Tools: PS/nVision, Crystal Reports, PS query

Version Control: PVCS Merant Version Manager, Quest STAT 5.3, Changeman DS, PHIRE

PROFESSIONAL EXPERIENCE

Confidential, Columbus,OH

Sr.Peoplesoft Administrator

Responsibilities:

• Planned for the Hardware Replatform project including tasks like reviewing the existing architecture, documenting the exisiting architecture and collecting performace benchmarks, and capacity planning for the new setup, documenting the to-be new architecture by assessing hardware and software requirements, compatibility and optimization, validate platform certifications and reviewing release notes.
• Involved in developing Hardware re-platform project plans including identifying tasks, resources required estimation of time and effort, and ability to effectively report on status
• Architect for 32 Peoplesoft, Demo, System, Configuration, Development, QA and Training environments and 3 non PeopleSoft environments like PHIRE, UC4, SOLIX.
• Designed PeopleSoft Application Migration strategy from Old Hardware to new Hardware.
• Involved in Financial Upgrade (8.8/9.1), HRMS Upgrade (8.9/9.1), planned for the upgrade including tasks like reviewing oracle support site for applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and reviewing release notes. Configuring EMF, Upload Environment to oracle and search for any updates. Running compare reports during initial upgrade and assist developers to identify customizations during fit gap sessions.Troubleshooting upgrade and data conversion issues.
• Involved in developing upgrade project plans including identifying tasks, resources required estimation of time and effort, and ability to effectively report on status
• Designed the technical architecture for all environments including hardware configuration, PeopleSoft instances, change management flow/path and delivered the corresponding Technical Architecture Strategy document
• Responsible for setup and maintenance of PeopleSoft applications like Financials & Supply Chain Management and HCM/Benefits, Customer Relationship Management (CRM), Enterprise Performance Management (EPM), Enterprise Learning Management (ELM).
• Designed, planned, created and documented the PeopleSoft architecture and environment based on scalability and hardware availability requirements
• Responsible for set up and maintaining multiple Tools versions wifin a common server environment at each tier.
• Installation and configuration of PeopleSoft system on UNIX and Windows Server in a multi-server, load balanced environment.
• Created base templates for Webserver, Appserver, Process Scheduler, Jump Server (OPS Box) separately and installed component specific softwares, by gathering, planning the pre-requisties and finally created a GOLD COPY VM and from which a GOLD COPY VM Set (Contains Webserver VM, App Server VM, Process Scheduler VM, Jump Box VM) and categorized as per tools version.
• Responsible for setup and maintain proper functioning of PIA, Tuxedo, Web Logic, SQR, and COBOL.
• Build Appserver, Process Scheduler and Webserver domains upon business requirements.
• Configuration of load balanced Web and App server environment wif failover capability. Installing and managing Digital Certificates on Web Server and CSS
• Extensively worked on SSL setup and configuration, identified and defined the Load balancer configuration and worked wif Load balancer team in setting up the Load balancer and configuration of SSL certificates while enforcing SSL offload.
• Served as the authorized requestor for CSR generation and for requesting certificate from certification authorities.
• Implemented and configured SSL at server level for Integration Broker setup an setting up CI based web services. Generate WSDL, provide and consume web services
• Designed and implemented report distribution for peoplesoft considering redundancy.
• Configured Loadbalancer for Webservers, Implemented failovers for application servers and enabled Master scheduler for Process Schedulers
• Responsible for setup and maintaining PS messaging and has designed a complex architecture involving multiple applications at different tools versions (8.46, 8.49, 8.50, 8.51) wif the gateways routing through load balancer and wif SSL offloading at Load balancer and absence of SSL at web server layer.
• Worked extensively in setting up File Servers and worked wif Windows Team in setting up basic autantication for file servers.
• Acted as point of contact for all Network related activities from a PeopleSoft perspective and responsible for authorizing server reboots, identify and troubleshooting PeopleSoft related network issues.
• Worked extensively wif Windows Team in designing the ESX hosts, sizing, capacity planning of the Virtual Machines (VMs)
• Worked extensively wif Windows team, Unix Team, Network team and DBA Team in designing the Zone Layout (DEV, QA, TR) for all the Non Prod Environments including the segmentation of the layers into Web tier, App tier and Database tier and categorizing various components like web servers, app servers, process schedulers, Database servers, jump servers (OPS Boxes) into relevant tiers
• Worked exclusively in identifying and documenting all the required firewall rules for all environments and for each tier dat are required for the various PeopleSoft components to function in a 4-tier setup, 3-tier setup, 2-tier setup and file transfer setup.
• Worked extensively wif Windows Team, Unix Team, multiple Network Teams and Load balancer Teams in troubleshooting Windows issues, Unix Issues, Network Issues including inter network issues, Firewall Issues and Load balancer related issues
• Worked extensively in applying bundles and for various applications and tax updates and applying PeopleSoft application patches/fixes.
• Responsible for setup of PHIRE, identified software requirements, pre-requisites, designing the architecture and identify the complex network rules Worked extensively on for change control and worked on extensively for migrations.
• Responsible for setup of tomcat, SOLIX and configuring Tomcat SOLIX for data masking.
• Worked extensively wif batch scheduling tool UC4, identified the hardware, software requirements, identifying firewall rules, documenting, troubleshooting
• Worked extensively on day to day Production support in a 24x7 pattern on a rotation basis and addressed the issues in timely fashion and maintained the application wif minimal downtime.
• Handled Change Management and Help Desk tickets as per SAS70 compliance.
• Opened service requests wif Oracle PeopleSoft support to fix issues encountered through upgrade process.
• Worked wif Portal Project Team wif LDAP autantication setup wif Active Directory (AD) and integrating it wif PeopleSoft.
• Effectively resolved performance problem by analyzing the log files, tuning parameters in configuration files and worked wif DBA team in the analysis of AWR reports, tables, building indexes and SQL tuning.
• Analyzed and maintained optimal parameters in configuration files across the applications.
• Worked wif DBAs, UNIX administrators, NT administrators, SAN administrators and Network Administrators for ongoing maintenance activities and Infrastructural changes.
• Coordinated wif Managers, Developers and associated teams for System outage and maintenance activities.
• Worked wif Network team, coordinating server reboot plans, performing safe tests after various patching efforts like Windows Patching, DNS patching, Database patching, Developed and devised a failover plan for rebooting of the servers conforming to HA and in order to has the applications available all the time.
• Worked effectively wif developers and team to meet project deadlines.
• Performed Disaster recovery exercise on an yearly basis.
• Conducted meetings for monthly releases and major implementations and discussed over scope and risk of the project.
• Designed process to monitor health of PeopleSoft system through custom monitor scripts and working wif other PeopleSoft Admins Windows team, Unix team, DBA’s, Network team and resolve the issues.
• Proactively analyzed and determined PeopleSoft system and database performance activities.
• Provided mentoring and training of DBAs and PeopleSoft Administrators.

Environment: PeopleSoft Financials 8.8/9.1, HRMS 8.9/9.1, CRM 8.9/9.0, EPM8.9/9.0, ELM9.0, PeopleTools 8.46/8.49/8.50/8.51 , Change Assistant, Oracle10g/11g,HP Unix,Windows 2003/2008, Weblogic 8.1/9.2/10g,Tuxedo 8.1/9.1/10/11 g, PHIRE,UC4,SOLIX

Confidential, Rochester Hills, MI

Sr.Peoplesoft Administrator

Responsibilities:

• Involved in Financial Upgrade (8.4/8.9), HRMS Upgrade (8.8/9.0), PeopleTools only Upgrade ( ), CRM Upgrade(8.9/9.0).
• Planned for the Upgrade including tasks like reviewing oracle support site for applying Updates and fixes required for upgrade, assess hardware and software requirements, validate platform certifications and reviewing release notes. Downloading upgrade scripts and templates,upgrade documentation, required for upgrade files.
• Involved in developing upgrade project plans including identifying tasks, resources required estimation of time and effort, and ability to effectively report on status
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, update statistics.
• Designed Instance Migration strategy for upgrade.
• Installing and setting up change assistant for peopletools only and application upgrade.Creating new environment, new job, importing template and running upgrade steps.
• Configuring change assistant to apply change packages.Steps including configuring PSEMHUB,starting PSEMAgent,uploading environment to oracle support, searching for updates and applying the same using change assistant.
• Designed and Deployed n-tier and Messaging Architecture for Production and Test environments.
• Tuned webservers, application servers, process scheduler servers and sized unix and windows servers accordingly.
• Architect for more TEMPthan 25 Peoplesoft Test environments and Production environment.
• Designed and implemented report distribution for peoplesoft considering redundancy.
• Configured Loadbalancer for Webservers, Implemented failovers for application servers and enabled Master scheduler for Process Schedulers.
• Involved in Deploying 2 user licensed MicroFocus COBOL compilers for production and test environments.
• Installing Weblogic Webservers,Tuxedo AppServers/Process Schedulers.
• Installing Weblogic service packs and Tuxedo Rolling patches.
• Startup/Shutdown the App Server, Web Server, Batch (Process Scheduler) Servers
• Created Startup and Shutdown scripts for the Web Logic Web Server and Tuxedo Application Server and Process Scheduler Domains.
• Installed and Configured PeopleBooks,Context sensitive help and Verity help.
• Intergration Broker setup for PS - PS and PS - Non PS systems.
• Setting up of single signon(SSO) between Peoplesoft systems.
• Configured RenServer for report viwing through window.
• Installed and configured Peformance monitor to gather application performance stats for performance/load test.
• Created Performance test environment, conducted Load/Stress and Performance test, captured the response times and tuned the system accordingly.
• Managing/creating user profiles, roles and Permission lists for peopletools and application security.
• Effectively involved in resolving the defects during system test and UAT.
• Used Quest Stat to Migrate several Projects from Development Database into QA Testing Database and tan into Production after successful testing.
• Troubleshooting peformance issues wif batch jobs, Out Of Memory/Memory leak issues wif webservers and application server sql/peoplecode errors.
• Installed SSL ceritificates for new servers and renewed for the old once creating CSR requests.
• Invloved in applying application updates/tax updates/bundles, MP's and critical patch updates as part of regular production maintainance.
• Documentation, developing workplans and uploading to Microsoft Share point.
• Involved in Disaster Recovery planning and testing
• 24/7 Post Production Support.
• Involved in performing Database refreshes and backups using RMAN.Peformed pre and post refresh tasks.
• Provided custom signon peoplecode solutions to resolve external users timeout and single signon issues.
• Monitoring webserver using weblogic console, application servers using tuxedo command line and box resource utlization using custom unix scripts and commands.
• Created and implemented unix scripts for log/file cleanup and routine tasks like server startup and shutdown.
• Implemented purge processes for process request and messaging tables

Environment: PeopleSoft Financials 8.8, HRMS 8.8/9.0, CRM 8.9/9.0,PeopleTools 8.47/8.48/8.50 , Change Assistant, Oracle10g/11g,HP Unix,Windows 2003/2008, Quest Stat, Auto Sys, Weblogic 8.1/10g,Tuxedo 8.1/11g.

Confidential, Plymouth, MN

Peoplesoft DBA

Responsibilities:

• Involved in Peoplesoft HRMS upgrade(8.3 to 8.9),Tools upgrade( )
• Planned for the Upgrade including 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 (e.g., release notes, white papers)
• Migrated several Projects from Development Database into Test,Test into QA Database and tan into Production after successful testing.
• Maintained the synchronous between the Peoplesoft Environments by comparing the projects and objects
• Installed and Configure the Report Repository for the reports to be generated.
• Configured Change Assistant for the upgrade.
• Used Application Designer to migrate the internal objects, used tree manager to migrate the trees and used Data Mover to migrate the data by writing the migration Scripts between the Peoplesoft environments
• Configured Windows development clients to connect 2-tier or 3-tier to the database.
• Extensively used PSADMIN utility to Administer, Create & Delete Application Server and Process Scheduler Server.
• Checked and cleared the application server cache on a regular basis as a maintenance process
• Involved in web server, Application Server configuration and set the parameters to get better performance in psappsrv.cfg and config.xml.
• Monitored the Server and Client queue status at several tuxedo domains
• Applied Tax Updates 5B,Bundle1,5C using Change Assistant.
• Applied PeopleTools product patch 8.47.05
• Researched and Applied upto dated Upgrade Patches during the Upgrade Process.
• Taking backups at each required steps during Upgrade Process
• Prepared copy of production database, tasks involved were to run audit reports DDDAUDIT, SYSAUDIT and Alter Audit, Apply Upgrade Options (UPGOPT) project, update statistics and freeze PeopleTools.
• Created Peoplesoft Demo and System Databases and Applied related Database patches and application Patches
• Configured Tuxedo services for windows and Unix operating systems.
• Setup trace logs at various levels like the Log fence 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.
• Worked wif the Process Scheduler to run the Process, define the process definitions and schedule the jobs
• Implemented Application Server Load balancing
• Created Documentation on Data Migration using related PeopleSoft Tools, administering Security & how to create Jobs wif multiple Processes in the Process Scheduler wif interdependencies.
• 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

Environment: PeopleSoftHRMS(8.3/8.9),PeopleTools(8.45/8.47),ControlMi,Change Assistant, Oracle 9i, Windows NT, Sun Solaris v5.9.

Confidential, Troy, MI

Peoplesoft DBA

Responsibilities:

• Installed PeopleSoft Database and Applications on NT and Unix Operating Systems
• Trained users on PeopleTools like Application Designer, Data Mover, etc dat are used for migration and created necessary documentation for them.
• Trouble shooting the PeopleSoft connection problems.
• Refreshing the staging, test, and development databases using the hot backups recreated by the controlfile using recovery until cancel option
• Creating and fixing the reports using the SQR and Crystal reports.
• Modified initialization parameter of database, tuned SGA, I/O and application to improve system performance.
• Applying the tax updates, patches and updates to the PeopleSoft system.
• Migrated several Projects from Development Database into QA Testing Database and tan into Production after successful testing.
• Designed and implemented Migration procedures and policies for external and internal objects and for data
• Assigned Query Security for the new projects which were migrated into Production
• Extensively used PSADMIN utility to Administer, Create & Delete Application Server and Process Scheduler Server.
• 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
• Ran the compare Reports
• Apply PeopleSoft delivered patches and fixes for the PeopleSoft Application
• Installed PeopleSoft Service as a windows service enabling Application Server domains and Process Scheduler domains to boot and shutdown as an NT service
• Installed PeopleBooks and configured the Web Server to access People Books
• 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
• Involved in running SYS and DDD Audits for the databases and clear the databases
• Involved in setting up the trace for development and production environments.
• Checked and cleared the application server cache on a regular basis as a maintenance process.
• 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
• Ran ALTER Audit to maintain the clean database
• 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.
• Identified the team roles and responsibilities for the technical upgrade process
• Maintained and Supported for 20+ Databases ranging from 40 GB to 200 GB
• Trained users on PeopleTools like Application Designer, Data Mover, etc dat are used for migration and created necessary documentation for them.
• Created Documentation on Data Migration using related PeopleSoft Tools, administering Security & how to create Jobs wif multiple Processes in the Process Scheduler wif interdependencies.
• Installed and configured the Peoplesoft DEMO and System databases and applications
• Solved all complex Application, Database, Application Server, Network and Web Server Issues
• Create multiple domains for the application server to reduce to traffic and maintain the load balance for the DEV, INT, STG and Production Environments
• Installed PeopleSoft, Fileserver, Application Server, Weblogic, and batch server on UNIX & NT platforms.
• Involved in Logical and Physical Design of databases. Organization of tablespaces across file system for performance optimization.
• Extensively used the PeopleSoft security tables PSDBOWNER, PSOPRDEFN and PSLOCK.

Environment: PeopleSoft Financials (8.4), People Tools (8.42.07), Oracle 9i, Windows NT, HP-Unix.