SUMMARY

• Experienced PeopleSoft DBA is offering more than 16 years of PeopleSoft experience working in US. Has worked with a wide variety of industries and highly proficient in leading technical teams, effort estimation and work allocation, PeopleSoft upgrades and implementations, server administration, database administration, change implementation, capacity planning, performance analysis and performance tuning. Has excellent communication skills, is self-motivated and a good team player.
• Excellent Troubleshooting and Debugging Skills
• Detail oriented with managerial, organizational and communication skills.
• Strong in PeopleSoft Architecture, Database concepts, Server Administration, Installs and Upgrades, Managing teams etc.

Detailed PeopleSoft Experience

Confidential

PeopleSoft DBA

• Worked on 3 different Tools and Application upgrade projects for multiple clients: FSCM 8.9 Tools 8.49 to FSCM 9.2 Tools 8.53, FSCM 9.2 Tools 8.53 to FSCM 9.2 Tools 8.54. Worked single handedly from installing the software, building the demo and copy of production databases, configuring the app/prcs/web servers to performing the upgrades using Upgrade Assistant and Oracle Virtual Images and applied the 1099 and other required patches/bundles.
• Also worked with Amazon AWS console to configure, take backups and restore databases for Test and Production environments.

Environment: PeopleSoft FSCM 9.2 / Tools 8.54, Oracle 11g, SQL Server 2008, Windows 2008 server and Amazon AWS.

Confidential

Competency Lead Upgrade Services

• Primary responsibility is to see that the deliverables for different clients are delivered on time and proper communication is established. Recruiting the team members, managing the resources, estimating the work on hand and allocating them appropriate work, helping and mentoring them on various aspects of PeopleSoft Development, Testing, Administration, Script Automation, managing Maintenance Schedules and Production Support are the main job responsibilities.

Environment: PeopleSoft HRMS Financials 9.1/ Tools 8.52.09, Oracle 11g, OEL 6, Windows 2008 server

Confidential

PeopleSoft DBA

• Supporting the existing PeopleSoft production environment, setting up new servers, troubleshooting day to day issues, developing strategies to stabilize the system and improve security and performance are the main job responsibilities on this assignment. Worked hand in hand with the development and DBA teams and also assisted the new resources in understanding of the system over a period of time.

Environment: PeopleSoft HRMS 8.9/ Tools 8.49.27, Oracle 11g, RHEL 5.3, Windows 2008 server

Confidential

PeopleSoft DBA

• Worked as a consultant in the role of PeopleSoft DBA with IBM for Children's Hospital of LA in California. The project was about supporting their current production environment.
• Performed Database Refreshes for the DR environment. Worked on pre and post refresh activities before deploying the database to the users.
• Worked on Oracle database security.
• Troubleshoot issues pertaining to data, tablespaces, etc whenever any jobs fail and resolve them.
• Installed and Configured People Tools Change Assistant on Windows Server 2008.
• Applied Tax Updates 11D, 11E and 11F to all environments and resolved any issues that cropped up.
• Applied HR Bundles 15, 16, 17 and 18 with their pre-requisite and post-requisite updates to all environments.
• Performed ad-hoc emergency migrations to Production.
• Troubleshoot issues of Process Scheduler, Application Server and Web Logic Server.
• Resolve Oracle database and PeopleSoft application issues in non-prod regions after weekly system checks.

Environment: PeopleSoft HRMS Financials 9/ Tools 8.49.27, Oracle 11g, AIX 6, Windows 2008 server

Confidential

PeopleSoft Administrator

• Worked as a PeopleSoft Administrator with the Confidential. The project was about upgrading the People Tools from 8.49 to 8.50 on all their Production and Non-Production Linux and HP-Unix servers.
• Installed and Configured People Tools 8.50 on 8 application servers and 18 Web Logic servers for production.
• Used Change Assistant to upgrade People Tools from 8.49 to 8.50.08 on development, training, testing and production databases.
• Raised service tickets for the hardware team to clone and build production application and Web Servers.
• Modified signin.html on all non-prod PIA sites to force uppercase user IDs to be entered on login page and also to include OSU specific headers.
• Configured the application, web and process scheduler servers for all environments on LINUX and NT servers.
• Applied patches using Change Assistant
• Researched WLST monitoring of Web Logic servers for real time server heap size usage and garbage collection.

Environment: PeopleSoft HRMS, Financials 9/8.49, Oracle 10g, LINUX 5, Unix Solaris, Windows 2008 server, STAT 5.2.1

Confidential

PeopleSoft DBA / Administrator

• Confidential is a leading global engineering, consulting and construction company and specializes in infrastructure development in energy, water, telecommunications, federal, management consulting and environmental markets.
• This is an upgrade project focused at upgrading their current PeopleSoft HRMS 8.8SP1 PT 8.4 application to the latest HRMS 9.1 PT 8.50 and also implementing eProfile Manager Self Service as part of the upgrade. Working with a team of 3 onsite 2 BAs PM and 6 offshore technical and functional iGATE resources and the HP team who maintains the infrastructure and provides DBA and Network support, single handedly spearheaded the upgrade project. Performed an Upgrade from PeopleSoft HRMS 8.8 SP1 People Tools 8.44 on Oracle 9.2.0.4 database and AIX 5.1 to PeopleSoft HRMS 9.1 PeopleTools 8.50.08, Oracle 11gR2 database on Unix AIX 5.3.

Environment: PeopleSoft HRMS 9.1 PeopleTools 8.50.08, Oracle 11gR2, UNIX AIX 5.3, Windows Server 2008, Internet Explorer 8

Confidential

Associate PeopleSoft Administrator / Desktop Support

• Worked as an Associate PeopleSoft Admin with added responsibility of a Security Administrator supporting their applications. The project is about combining different accounting systems of various state agencies to one combined PeopleSoft Financial application. Worked on Oracle Data Integrity ODI prototype on how to mask data elements on PeopleSoft pages and also control what data is displayed when users use non PeopleSoft reporting tools like SQL Plus, TOAD etc. Developed PL/SQL procedures to define policies and business logic while working with delivered packages for that purpose. Also worked on a prototype configuring and testing LDAP connectivity between PeopleSoft and State directory services. Reported the pros and cons of deploying the LDAP connectivity authentication and authorization to the management.

Environment: PeopleSoft Financials 9/8.49, Oracle 10g, UNIX AIX 5.3, STAT 5.2.1

Confidential

PeopleSoft Administrator

• Worked as a PeopleSoft Administrator supporting and monitoring the HCMS/ELM/CRM applications with over 1,000 users and 35,000 active employees.
• Worked on the PeopleSoft 8.3 - 8.8SP1 - 9 upgrade on Tools 8.4x and streamlined business procedures/processes.
• Installed/Configured/Deployed ELM 9 Tools 8.49 under Oracle 10g and Unix AIX 5.3 environment
• Installed/Configured/Deployed 4th Tuxedo Application Server in HCMS production environment.
• Applied Tax Updates for all environments using Change Assistant and STAT.
• Lead the Stress Testing effort for OE 2008.
• Successfully lead the DR exercises. Developed project plans and documented essential steps for manual failover to ensure minimal downtime. Coordinated with all teams involved for all their relevant tasks. Performed all the prep tasks, distributed PSADMIN tasks among team members and documented lessons learned for future reference.
• Troubleshoot various Production issues involving IPlanet, Web Logic and Tuxedo app servers or data issues.
• Used STAT for Prod and Non-Prod migrations as well as the Tivoli Maestro console to troubleshoot maestro jobs that are run in the batch trails every day.
• Involved in system performance monitoring and tuning, storage management, database backup and disaster recovery etc
• Worked with the DBA team in applying database patches.
• Worked with development team to implement FTP processing from within the PeopleSoft application.
• Organized/scheduled meetings to discuss various issues with DBA and Development teams.
• Recommended and Implemented Service-Now for managing service requests thereby drastically reducing emails and improving team productivity.
• Skillfully addressed day-to-day activities DB Refreshes, Migrations, FTP Requests, UNIX Permissions, Space Mgmt., etc. .
• Managed / distributed off hours tasks to offshore team members.

Environment: PeopleSoft HCMS 9/8.49, CRM 8.8SP1/8.44, ELM 8.8SP1/8.44, Oracle 10g, UNIX AIX 5.3, Financials, EPM, Maestro Job Scheduler, STAT.

Confidential

PeopleSoft Administrator / Technical Analyst

• Key player of PS Technologies team 10 onshore and 14 offshore . 15K facilities, 800 Admin Users, 15 Sun Servers, 60 database instances and 1 Million employees.
• Tools Upgrades: Upgraded HRMS 8.8 to 8.8SP1 Tools 8.42.09 to 8.43.17 CRM Tools 8.16.02 to 8.22.14
• Tax Updates: Applied all tax updates for the years 04, 05, 06 and also 07A
• PeopleSoft Patches: Applied PeopleSoft patches including the latest DST patch across all instances
• Instance Builds: Refreshes/Restores Friendly/Hostile from Hot/Cold backups and IVTs
• Server Configuration: App server and Process Scheduler server configurations, maintenance and issue triage
• Source Control: Code Syncs, Migrations, Migration Audits and Strategy, Change Control
• Security: UNIX Level users/groups/permissions , Oracle roles/privileges , PeopleSoft BK ups, Role Maintenance Design, Audits, Strategy - Advise Functional Users
• UNIX File/Dir permissions - clean up and roll out, end user support COBOL compiles, file ftp, triage etc
• Autosys: Server Configuration Setup, Job/JIL Analysis Design, Creation, Execution of job streams in production and non-production environments.
• Application Messaging: Involved in Configuring, Analysis, Triage of Gateways/Channels/Nodes/Messages
• Utilities: Developed/modified SQR, App Engine, Component Interfaces, Excel Macro utilities to help technical/functional teams
• Volume/Stress Testing Batch Online: Lead the effort to plan, configure, co-ordinate, develop processes and overall execution
• HRMS and CRM Database Reductions: Development, Execution, Maintenance and Ownership
• Base Table Support: modify and maintain PL/SQL procedure, generate table compare reports across databases, data export/import, SQL and DMS Updates/Deletes/Inserts
• Data Conversion: Helped in converted data from legacy using SQL Loader / SQR and App Engine
• Production Support: Job scheduling execution, Issue Triage, Co-ordination with Functional Team etc
• FTP Processing: Design, Development, Configuration, Application Support
• Performance Tuning: Helped developers in debugging and SQL tuning for many processes using hints, indexes and scalar queries to greatly improve process run times over a long period of time. Also performed peer reviews and code audits to improve and maintain quality of code based on the development standards.
• Mentoring Offshore/Onshore teams: Scheduling, Resourcing and Skill Set Development

Environment: PeopleSoft HRMS 8.9/Tools 8.46, CRM 8.0 Tools 8.22.14, BEA Web Logic 5.1 and 8.1, IPlanet 6, Windows 2000/NT Terminal Servers, UNIX SunOS 5.8 Oracle 9i Release 9.2.0.8, Kintana Mercury IT Governance Center 5.5 , PVCS Version Management Server 6.7.11

Modules Used: HR, Payroll, Benefits, Ben Admin, Pension, Time Labor, Portal, CRM.

Confidential

IT Programmer Analyst

• Implemented the PeopleSoft HRMS version 8.8 and upgraded Kronos Workforce Central applications. Worked on converting and interfacing the data between 3 systems: Unisys mainframe , PeopleSoft and Kronos. Monitored the developmental activities of the technical team by planning, coordinating and documenting various activities. Conducted several end user sessions to gather the requirements.

PeopleSoft Project

• Worked with customizations, reports and interfaces on Payroll and Time and Labor modules during the upgrade.
• Assisted with setting up security and workflow.
• Modified the Employee home page for security incorporating the contents of the security matrix.
• Incorporated the company business rules in workflow implementation in various business processes.
• Developed the conventions for coding the message channels in Application Messaging between Various Modules for information exchange.
• Applied tax updates and worked with payroll users on related issues.
• Developed and customized certain pages and components in the Time and Labor module to process time and leave accrual adjustments.

Kronos Project

• Provide ongoing support for Kronos Workforce Central System, interfaces, processes, and reports.
• Successfully completed an upgrade from Kronos 4.3 to 5.0.
• Developed PL/SQL packages to import and extract data, and SQL Loader scripts to load data from the incoming ASCII text files from PeopleSoft.
• Developed ad-hoc queries to identify employee time, pay rules, schedule and other data across all departments.
• Provided solutions on various business processes for efficient and accurate processing of data.
• Developed interfaces from PeopleSoft Time Labor to Kronos Workforce Central and vice versa.

Environment: PeopleSoft HRMS 8.3/Tools 8.4, Kronos WFC 4.2, Windows 2000/NT, UNIX, Web Logic Oracle 8i Release 8.1.7.2.1.

Modules Used: HR, Payroll, Time and Labor.

Confidential

Technical Specialist

• Worked on upgrading the PeopleSoft HRMS application and also in customizing pages/people code/app engines, report generation and data conversion. Upgraded the HRMS applications from 7.5 to 8.3.
• Prepared design specifications and developed custom PeopleSoft 8.3 records and pages for special Payroll and Benefits processing and reporting needs during design and development phases of project.
• Worked on major customizations and processes such as setting up of encumbrance definitions, tax distributions, encumber additional pay and associated fringe benefits, savings plan investment changes, life insurance calculation process, premium waiver discounts, commitment accounting view page etc.
• Converted data from legacy and developed several interfaces to outside vendors and reports as needed.
• Modified custom SQR's to include sign changes in field names that came with the new version.
• Worked on year-end processing of W-2's for all the employees and on loading tax data for the coming year.
• Modified Time and Labor and Self service benefit enrollment pages with user specified text messages. Added hyperlinks, changed page field defaults, tab orders, labels etc.

Environment: PeopleSoft HRMS 8.3/Tools 8.17 and HRMS 7.5/Tools 7.61, PeopleSoft Enterprise Portal 8.4x, Windows 2000/NT, UNIX, Web Logic Oracle 8i Release 8.1.7.3.0.

Modules Used: HR, Payroll, Benefits Administration, Time and Labor, eProfile, eProfile Manager Desktop, ePay, eBenefits, eRecruit, eRecruit Desktop Manager, eCompensation and eCompensation Manager Desktop.

Confidential

Techno-Functional HRMS Upgrade Lead

• Involved in upgrading the PeopleSoft HR, Benefits and Payroll applications from version 7.5 to 8.3 for this leading provider of real-estate distribution facilities.
• Upgraded their tools from 7.56 to 8.17 and application from 7.5 to 8.3
• Applied all relevant tax updates across all databases and helped in code sync.
• Provided leadership and direction to the project technical team and defined upgrade conversion strategy
• Conducted Fit/Gap sessions. Demonstrated new features and enhancements of PeopleSoft 8 HRMS to the team Managers and end-users. Developed Unit Test Plan and Test Scripts for Payroll, HR and Benefits.
• Debugged various application processes
• Tuned 15 SQLs to enhance performance using optimizer hints, indexes to avoid full table scans.

Environment: PeopleSoft HRMS 8.3/Tools 8.17 and HRMS 7.5, Windows 2000/NT, HP-UNIX, Web Logic Oracle 8i.

Modules Used: HR, Payroll, Benefits Administration, eProfile, ePay, eBenefits, eRecruit, eRecruit Desktop Manager, eCompensation and eCompensation Desktop Manager.

Confidential

Team Lead Programmer/Analyst

• Attended PeopleSoft 8 Boot Camp training program at Confidential. Performed functional testing over the Internet using a web browser. Worked on PeopleTools with remote access to the terminal server at Pleasanton.
• Worked on interfacing 52 internal and external systems with the PeopleSoft application. Worked with end-users to capture detailed information of the data flow. Customized application to a great extent and Modified, tested 20 interfaces and Reports

Environment: HRMS 8 SP1/Tools 8.15/Oracle HRMS 7.0/Sybase, Solaris 5.5.1, Windows NT and SQR 4.3.4

Modules Used: HR and Base Benefits

Confidential

Technical Team Lead Programmer/Analyst

• Developed and supported HR, Benefits, and Payroll applications for PeopleSoft 7.5. Involved in upgrade, conversion/data migration, development, customization and generation of interfaces and reports.
• Developed, modified and tested 65 SQRs and SQCs.
• Used Workflow Administrator and also created workflow to existing business processes.
• Worked on major application customizations like Position Management, Intermittent Pay Calendars, Retiree Medical Subsidy and Billing, Residency Tracking and Residency check, Leave Accruals, Retirement Plan Eligibility etc.
• Developed and tested various interfaces for BlueCross Health Membership, Provantage Vision, Residency Check, New Hires, Medco Prescriptions etc.

Environment: PeopleSoft HRMS 7.51/Tools 7.56, Oracle 7.3, Windows NT and UNIX.

Modules Used: HR, Payroll, Base Benefits and Benefits Administration