Peoplesoft Administrator Resume
Boston, MA
SUMMARY
- Around 8 years of experience in IT industry as a PeopleSoft Administrator, which includes implementation, customization, upgrade and maintenance of PeopleSoft HRMS/FSCM/CRM/Campus Solution Applications.
- Documentation of technical specifications and developing test cases.
- Good experience in installation and build engineer of PeopleSoft Applications.
- Worked on PeopleTools (Application Designer/Data Mover/Configuration Manager).
- Upgrade of PeopleTools and Applications using Change Assistant.
- Worked on third part tools like STAT, Phire, Tidal, Control - M, Salesforce etc.
- Integrating one Application wif another using Component Interface.
- Installation and Configuration of PeopleSoft Environment in both NT & UNIX.
- Excellent understanding of PeopleSoft Internet Architecture including Web server, Application server, Process Scheduler(Batch server) and Database servers.
- Applying PeopleSoft Patches, Tax Update, Fixes, Bundles, Maintenance Packs and Updates.
- Involved in configuring and partitioning of the queues in Integration Broker.
- Experience in databases like Oracle, Microsoft SQL, Sybase and IBM DB2.
- Experience in writing complex Database reports and customizing PeopleSoft delivered SQR reports.
- Handling workload wifin the PeopleSoft systems using Application server.
- Migrating and copying projects from one environment to another.
- Inserting Fields, Records, Menus, SQL, PeopleCode, Components and registering Components using Application Designer.
- Implementing Single Sign on.
- Proficiency in enterprise application concepts and use of security controls in OraclePeopleSoft9.2.
- Responsible for optimizing core security set up.Review and advise on current processes for managing and monitoring application-level access including pages, processes, queries, trees, reports, components, services, integrations, customizations etc.
- Worked on latest technologies like DPK, SES, Elastic Search, PS Test Framework, PUM, Change Assistant(CA) and Fluid User Interface.
- Experience in PeopleSoft security, Roles and Permission Lists.
- Good noledge in Configuring of 3-tier and 2-tier components of the PeopleSoft.
TECHNICAL SKILLS
PeopleSoft Application: 9.2/9.1/9.0/8.9/8.8/8. x
PeopleTools: 8.55/8.53/8.5 x/8.4x
Modules: HR, Payroll, Benefits, Benefits Administration, Interaction Hub (PORTAL), FSCM, PO, ELM, HRMS, Campus Solution/Student Admin
Development Tools and Platforms: Application Designer, Application Engine, PeopleCode, Process Scheduler, Data Mover, Component Interface, Application, Tuxedo, Weblogic, VMware, Integration Broker, Interaction Hub, Single Sign-on (SSO), unified navigation.
Reporting Tools: PS query, SQR, Crystal reports, nVision, BI Publisher
Upgrade Tools: Change Assistant, PeopleSoft Update Manager(PUM)
Languages: PeopleCode, Java, C, C++, PL/SQL, SQR, HTML, XML.
Operating System: Windows XP/2000/NT/95/98, Linux, Unix
RDBMS: Oracle 12c, 11g, 10g, 9i, Microsoft SQL Server 2008/2005, IBM DB2
PeopleSoft HRMS/ FSCM: Core HCM, Global/NA Payroll, ESS/MSS, Ben Admin, TAM, Time & Labor, Career/Succession Planning, Competency Management, Front Office, ePerformance, Profile Management, Absence Management, Compensation, Position Management, Query/XML. PS Query (GL, AP, PO, AR, BI, Cash Management, Deal Management, EPM)
PROFESSIONAL EXPERIENCE
Confidential, Boston, MA
PeopleSoft Administrator
Responsibilities:
- Created Change Package from PUM and applying to target database using Change Assistant.
- Worked on Process Scheduler to schedule various SQR's and Application Engine Programs.
- Migrating objects from one environment to other using Phire.
- RunningData Mover Scripts (DMS)on HR and Benefits tables to validate in different environments.
- Involved in configuring and partitioning of the queues in Integration Broker.
- Implementing PeopleSoft Internet Architecture me.e., PeopleSoft Database (Oracle, Microsoft SQL, IBM DB2), Application Server, Web Server (Oracle Weblogic and IBM Web Sphere), PeopleTools Development Environment (Two Tier and Three Tier Environments) and Application access types.
- Installing and configuring Oracle Security Enterprise Search (SES) and integrating wif PeopleSoft environments.
- Imported PUM Image to Oracle VM.
- Managed and implemented ERP security controls.
- Performing PeopleTools upgrade.
- Developed Component Interface to load bulk data into setup pages and Plan Admin components.
- Applying regular patches, fixes and updates.
- Configured PeopleSoft Interaction Hub and the Integration Broker along wif SSO to integrate wif multiple PeopleSoft applications.
- Installing Tuxedo on UNIX and applied Tuxedo RP.
- Tuned SQL/SQRs/App Engine to improve system performances.
- Wrote severalSQL Queriesand verified data consistency throughout the Database.
- Performedtesting (Functionality, Regression, Acceptance) of the application.
- Copying/Testing Sand Boxes (Dev, Test & Prod) and Migrating Projects from one environment to another.
- Setting up all the properties for each field residing in the records.
- Experience wif trouble shooting PIA.
- Setting up User profiles, Permission Lists and Roles etc.
- Maintaining PeopleSoft Security which includes row level, access group, process group, query, portal etc.
- Involved in preparing General Design, Detail Design and Functional Specification documents for the new custom processes, reports and verifying successful connection to the client environment.
- Involved in designing and developing Record Definitions, Pages, Sub Pages and Components based on business requirements.
- Involved in Resolvingday-to-day production ticketsin HR and Payroll.
- Building Demo Environments for testing which is useful for upgrading.
- Configured and maintained all the tables involved inPayrollprocessing, such as Pay calendar, Job Code, Deductions and Processes such as Paysheet creation, Paycalcs, pay confirm, Tax Tables etc.
- Involved in the testing phase of the application by setting up the test cases.
Environment: s:PeopleSoftHCM/FSCM 9.2/9.1, People Tools 8.55, Oracle 12c, PS Query, GL, AP, PO, AR, BI.
Confidential, Ann Arbor, MI
PeopleSoft Administrator
Responsibilities:
- Built Testing Environments for test purposes (Demo Environments).
- Used Process Scheduler to schedule SQR, Application Engine, PS-Query and Crystal reports.
- Created Change Package from PUM and applied to target database using Change Assistant.
- Applied updates, fixes and upgraded PeopleSoft applications using Change Assistant.
- Participated in root cause and fit gap analysis and documentations.
- Transferring Application data between PeopleSoft Database using Data Mover.
- Copying/Migrating Projects and objects from one environment to another using App Designer
- Applying regular PeopleSoft Patches, Fixes and Tax updates.
- Implemented PeopleSoft Internet Architecture me.e., PeopleSoft Database, Application Server, Web Server, PeopleTools Development Environment.
- Tuning the performance of PeopleSoft systems by restarting Application server, Web server and clearing cache.
- Worked on Application Designer to customize Run Control Pages and Menu, developed new process definitions and attached it to PeopleSoft Project.
- Customized SQR reports in AR and BI for Detail Aging, pending items and Invoice details.
- Handled work load using Application Server wifin the PeopleSoft systems.
- Responsible for customizing the application such as creating new records, fields, pages, components and menus using Application Designer.
- Created new Permission Lists, Roles and assigned it to specific users.
- Experience in tuning the performance of PIA.
- Configured IB using unified navigation for PORTAL (Interaction hub) to integrate multiple PeopleSoft environments.
- Tuned the performance of the SQR reports using SQL, Stored Procedures and Temp Tables.
- Involved introubleshootingduring Payroll process and on-line support to the end-users.
- Interacted wif the end users while performing the Acceptance testing for new clients and trained them in the new functionality whenever a new build was developed.
- Tested application manually for verifying objects and functionality.
Environment: s: PeopleSoft HRMS/FSCM 9.2/9.1, PeopleTools 8.53, Oracle 11g, Core FTP, UNIX, Process Scheduler NT
Confidential
PeopleSoft Admin
Responsibilities:
- Performing production support role for PeopleSoft Applications
- Configuring Web Server, Application Server and Batch servers.
- Performed PeopleTools Upgrade.
- Worked on applying PeopleSoft Patches, Bundles and Maintenance Packs.
- Performing project migration across PeopleSoft environments.
- Migrated Security objects across environments.
- Creating Demo environments and configure all the settings.
- Performing Root Cause Analysis for PeopleSoft environment issues.
- Performing PeopleSoft security related support such as User profile creation, assigning roles and permission list to Users and performing Integration Broker Configuration.
- Applied Weblogic patches using OPATCH utility.
- Tuning the performance of PIA, SQR, SQL and Application Server
- Data refresh between PeopleSoft environments, backups, creating partitions, managing table space size, PeopleSoft related queries and database query performance tuning.
- Performing COGNOS administration on Windows server such as backup and archival the cubes, server maintenance and jobs monitoring.
- Used Performance Monitor to check system performance, utilization and memory usage
- Ran DMS to check for data inconsistency in Database.
- Improved performance by clearing cache, tuning, increasing JVM Heap size, increasing no of instances, reducing processes etc.
- Involved in creating custom pages for issue tracking, HSA employer contribution and eRequisition.
- Ran the SQR and Application Engine process and resolved related issues.
- Resolved issues related to Integration Broker(PUB/SUB), Application server, Process scheduler and Report Nodes
- Used tools like Phire, Autosys, Salesforce for data migration, process scheduling and tickets resolution
Environment: PeopleSoft HCM/FSCM 9.0/8.8, PeopleTools 8.49, IBM DB2, UNIX, Windows.
Confidential, Santa Clara, CA
PS Administrator/Developer
Responsibilities:
- Designed and configuredChart-fieldsfor assurance. Modified and customizedchart-field labelsto suit assurance business.
- ConfiguredBusiness Units, Ledgers, Ledger Groups and Journal Sources.
- Designed and configuredcombination edits and closing rules.
- DesignedGL Journal approval workflow.
- CreatednVision Balance Sheet reports. Modified and maintainedIncome Statements, Trial Balances and Cash flow statementsfor existing Business Units.
- Configured newAllocationsincludingInter-Unit Allocations.
- ConfiguredACH layout, payment source and pay-cycle steps.
- Designed and configuredpayment handling codesandpayment term timing codes.
- Designed and configuredvendor categories and wifholding codes(1099)
- Designed, configured and testedACH and check paymentswif Bank of America.
- DesignedAP Voucher approval workflow.
- Maintained business units and accounts reporting trees usingTree Manager.
- Assisted users in suspensejournal corrections. Worked wif enhanced 8.8Spreadsheet LoaderandExcel to CI utility.
- Participated in Campus Community Fit-Gap sessions and documented outcomes of assessment sessions.
- Used SQL, PeopleCode and developed process to determine student home campus depending on majority enrollment and academic career.
- Performedmonth-endandquarter-end close. Troubleshoot out of balance Balance-sheets.
- Configured newJournal SourceandtroubleshotnewGL Interface issues.
Environment: s: PeopleSoft 9.0, PeopleTools 8.52, Campus Solution 9.0, Visio, Crystal Reports, nVision.
Confidential, Tampa, FL
PeopleSoft Administrator/Developer
Responsibilities:
- Performed the role of a PeopleSoft Technical consultant in the organization.
- Customized thePromotion/Demotion pageusingApplication Designer.
- Implemented Application Engine ProgramforPay Increasesto update compensation.
- Inserting bulk data using Component Interface Resolved issues, which were designed to updateJOB data.
- Involved in configuring and partitioning of the queues in Integration Broker.
- Worked on day-to-dayProduction support.
- Designed anew CIfor global job codes.
- Tuning PIA by restarting and resolving issues wif Application server and Web Server.
- Created SQR reports and generated the errors reports daily.
- Developed Queries usingPS Queryand exported the results wif Microsoft Excel.
- DevelopedCrystal Reportsto perform calculations.
- Tuned the performance of the SQR reports using SQL, Stored Procedures and Temp Tables.
- Extensively usedProcess Schedulerfor running different reports and to create and submit groups of processes as a job, and conditionally schedule successive processes based on the status of a previous process in the job.
- Responsible for deployment of Support & bug fixing in Staging Platform and Production.
- Responsible for resolving issues in Application server and Process scheduler.
Environment: s:PeopleSoft 8.8/8.9, PeopleTools 8.5/8.4, MS SQL, Unix, SQR, Application Engine, Workforce Administration, NA payroll and Base Benefits.
Confidential, Rockville, MD
PS Admin
Responsibilities:
- Performed the role of PeopleSoft Administrator in the organization.
- Supporting and maintaining PeopleSoft HCM Applications.
- Extensively used PeopleTools for creation or modification of Process Definitions, Records, Pages, and Menus to run Custom SQR’s.
- Created new field definitions and added it to the existing record and page definitions through Application Designer.
- Creating Demo environments for testing purposes.
- Performed Acceptance testing for new clients me.e., Creating existing year Pay calendars, validating the pay sheets & Run ID’s, Running Pre Calc, final Calc and confirming the Payroll process, reviewing the paycheck summary and running different reports.
- Implemented new SQL scripts for Data migration between various environments.
- Created customized reports for auditing the quarterly audits.
- Tuning PIA and PeopleSoft systems by restarting the Application Server and Web server.
- Performed debugging analysis and provided online help to customers.
- Involved introubleshootingduring payroll process and on-line support to the end-users.
- Resolved customer issues related to PeopleCode, SQR, Query, Crystal Reports and Process Scheduler.
- Tested, replicatedandresolvedvarious issues reported.
- Responsible for running several processes and resolved issues
- Solved issues related to reports, web server, pub/sub server, memory space etc.
Environment: s: PeopleSoft HCM 8.3/8.0, PeopleTools 8.4x, Oracle, Windows, Linux.