We provide IT Staff Augmentation Services!

Peoplesoft Technical Consultant Resume

4.00/5 (Submit Your Rating)

Summary:
Over 10 years experience within IT and the last 8 years have been working with PeopleSoft HRMS and Financials systems. Expertise lies in the areas of PS HRMS (HR, Payroll, PayMatch, Global Payroll, Benefits, Student Administration, Self - Service, Talent Acquisition Mgr, Enterprise Learning, eLearning, eBenefits, eCompensation, eRecruit, ePerformance, Open Enrollment, Absence Management, and Time and Labor) and Financials (Accounts Payable, Accounts Receivable, Asset Management, General Ledger, Grants Management, Billing, eBill, Workflow, Purchasing, Project Costing, Inventory, Commitment Control and CRM) from versions 7.5 to 9.1, Kronos v2c., Performance Tuning, Peoplesoft Security Specialist.

Experience:

Confidential, 03/08 - 03/11
Peoplesoft Technical Consultant

  • Wrote and developed technical specs for Benefits/ Ben Admin, T & L, Recruit, TAM, ePerformance, and North American and Canadian Payroll.
  • Performing testing on tuning of the environments and fix issues.
  • Check stats of the tuning results.
  • Setup and configure payroll of the current year, core tax processes, functional tax processes, and first payroll of the new year. Build a calendar of events to use as a template for the annual business process. Create and maintin queries for data clearnup and balance adjustments; Analyze modiles and make all necessary modifications based on statutory and compliance requirements; work with partners to create test and use cases in support of all testing phases, test payrolls (including last payroll of current year and first payroll of new year), and review outside vendor interfaces; Produce all W-2s, 1099-Misc Forms, 1099-Misc (W2-PR and forms), and Canadian Forms; setup and configure federal and state magnetic media /electronic files
  • Perform tax updates and fixes.
  • Create batch job schedulers,
  • Performed upgrades for Peoplesoft 9.0 and Peoplesoft 9.1
  • Perform QA Testing and write test scripts
  • Conduct weekly meetings with clients, as well as, consultant staff to ensure all issues are resolved.
  • PeopleSoft Team Lead; provided full life-cycle systems development and production support.
    Lead eApps ePerformance planning, analysis, development, and testing activities during PeopleSoft upgrades and provide tools, standards, templates, code reviews, and methodology. Provided hands-on support of eApps customizations, interfaces, data issues, and other technical issues. Lead technical design, development, testing, and documentation for eApps projects. Provided technical expertise to Functional Analysts, technical analysis on design issues, and guidance on problem resolution.
  • Created training materials and conduct transfer for HR and eApps (eBenefits, ePerformance, and ePay, and eRecruit).
  • Performed HRMS knowledge transfer and provide training via classroom sessions and webinar sessions.
  • Prepared Function Requirement Documents for HRMS, as well as, Fit/Gap Analysis.
  • Setup and configure earning codes, deduction codes, paygroups, holiday schedule, wage loss plan, and tax locations.
  • Calculate payroll, review calculation results, identify any errors, confirm payroll. Produce paycheques and setup other payroll reports.
  • Setup payroll foundation tables and process benefit deductions.
  • Setup and configure Canadian payroll tax tables, employee data, setup, garnishments.
  • Perform any customizations as per client's enhancement requests.
  • Lead planning, analysis, development, and testing activities during PeopleSoft upgrades and provide tools, standards, templates, code reviews, and methodology. Provided hands-on support of customizations, interfaces, data issues, and other technical issues. Lead technical design, development, testing, and documentation for projects. Provided technical expertise to Functional Analysts, technical analysis on design issues, and guidance on problem resolution.
  • Setup and configure the evaluation process, complete the evaluation cycle for ePerformance.
  • Created ePerformance templates and documents.
  • Perform customization for Positions, commits sections for both managers and employees, and workflow for clients.
  • Ensure users have the ability to approve evaluations.
  • Ensure that data was uploaded for users to run ePerformance reports.
  • Setup and ePerformance business processes.
  • Create reports such as AE, Component Interfaces, Crystal, and XML.
  • Setup Security for HR and eApps ePerformance modules (user ids, roles, permission lists, department level security, and query security.
  • Setup and upload ePerformance data.
  • Setup document types, templates, and sections.
  • Develop customizations around HR and eApps ePerformance modules per client's request.
  • Responsible for leading the technical aspect of 9.0 and 9.1 upgrades for clients
  • Setup and Configure Single Signon and enable Active Directory in order that users can log into the network without having to sign into each application separately. The authentication updates both PS and AD upon the user logging into the application.
  • Setup and configure customized automated benefits programs, define eligibility rules, define event rule parameters, change elections and coverage, process open Enrollment and Perform Event Maintenance, establish validation across plan types, configure eBenefits to make benefit changes, setup benefit program records, setup reports, configure cross-plan validation, setup event classes, setup event rules for life insurance and disability plans, define flexible credit and earnings codes, run Open Enrollment processes, run Snapshot processes, define event rules for self-service, activate multiple jobs, setup benefit record numbers, configure print statements, setup the foundation tables, setup base benefits audit reports, setup benefits process records for employees for open enrollment, perform employee election entry for open enrollment, and setup for next year's open enrollment
  • Create SQL scripts to convert data from one environment to another.
  • Use SQL query tool to command and execute.
  • Setup document types, templates, and sections.
  • Performed upgrade and system configurations for HR v9.1 for Employee Service, eBenefits, Base Benefits, Ben Admin, NA Payroll, and Canadian Payroll.
  • Responsible for assisting and guiding design, configuration and testing and provided a transfer of knowledge, training and implementation recommendations to ensure leading-practice standards were met.
  • Configure and setup Integrate Integration Broker.
  • Develop reports for clients for ePerformance, eBenefits, HR, Canadian Payroll, and NA Payroll.
  • Developed solutions for / with LDAP, ADAM, SSO, Single Sign On, Enterprise Access Control, authentication and authorization.
  • Automate provisioning and deprovisioning.
  • Maintain a working knowledge of high level languages, database techniques, system productivity tools, programming techniques and software standards
  • Assisted users with testing
  • Performed mass data load into tables
  • Managed and developed functional custom specifications.
  • Developed and maintained project plans, policies, and procedures that were to be implemented.
  • Customized and create SQRs, app engine processes, and Component Interfaces.
  • Use Peoplecode to make code changes.
  • Create workflow using SMTP.
  • Receive, validate and converting XML files and loading into Oracle tables.
  • Experience with App Messaging and BusinessLinks..
  • Designed and executed Data Mapping, cleansing and Cutover plans for Conversion.
  • Integration between financial modules and external financial systems.
  • Test and validated results of data and tools upgrade process.
  • Test of delivered reports, delivered processes, and customizations.
  • Provided functional configuration for modules. .
  • Assisted users and developed training documents for each module.
  • Setup user profiles, provided security changes, setup roles, permission lists, and row level security.

Confidential, (Arlington, VA) (Remote) 02/07 - 12/07
Peoplesoft Lead Administrator HCM/ELM Security Consultant/Enterprise Portal 9 Consultant - 1st Phase
Peoplesoft Lead MSS/ESS/eProfile Manager Functional and Technical Consultant - 2nd phase

  • Designed and configured Peoplesoft security for v9.0 Implementation (HR, Manager Self Service, Employee Self Service, ELM, Enterprise Portal 9, and Recruiting Solutions).
  • Setup 454 user profiles, permission lists, roles, department security tree, row level security (data), query security, reporting, according to approved security design.
  • Worked with functional/technical leads for unit testing, users acceptance testing, and post go live issues.
  • Performed fit/gap analysis for version 9.0 for Manager Self Service, Employee Self Service, and eProfile Manager.
  • Document business processes for each module.
  • Setup design sessions with Project business owners to document process processes and mappings.
  • Review any customizations to determine if they are approved to be migrated over.
  • Run compare reports between environments.
  • Perform sqr modifications.
  • Setup integration broker.
  • Setup configuration tables for MSS, ESS, and eProfile Manager.
  • Perform mappings.
  • Create training materials and train users on security processes.
  • Create app engine processes for MSS in order to perform automatic user setup nightly in the event Managers and newly employees are hired into the system. This process was also designed to remove users in the event they are termed. Setup security for MSS, ESS, and eProfile Manager.
  • Worked with users/managers to determine appropriate level of menu access for each module.
  • Created scripts via SQL Plus and Data Mover to import and export data from one environment to another. Prepared documentation on Security policies and procedures for client.
  • Provided Security restructure for Peoplesoft HRMS and ELM systems is in compliance with Sarbanes Oxley. Setup Enterprise Portal 9 for each user's login. Configure and setup FULL_SYNC, WORKFORCE_SYNC, and incremental sync integration broker messaging between HR 9.0 and ELM 9.0 (PeopleTools 8.49).
  • Developed and implemented security strategy to sync up user profiles from HR to ELM and facilitate the management of ELM user security from within the HR application.
  • Created and implemented a project plan which includes a development and migration strategy from dev to system test to user acceptance testing and production environments. Created all ELM migration scripts
  • Identified and fixed PS bugs in ELM application. Customized code and screens to meet customer needs (PeopleCode, Page modifications). Worked closely with ELM functional resource to setup and troubleshoot application. Configured initial ELM system and setup installation defaults. Identify necessary recurring processes based on application needs and schedule them.
  • Configured and Setup AICC and SCORM compliant Activities. Setup Account authentication against Microsoft Active Directory system with implementing single signon in order that the users were able to use one single id and password to log into each application.

Confidential, 11/06 - 02/07
Peoplesoft Lead Architect and Lead Security

  • Maintain and develop custom modifications to system.
  • Setup system configurations for HR, Benefits, Global Payroll, ELM Integration with HR, Talent Acquisition Manager, and eApps for v 9.0.
  • Setup Integration Broker.
  • Setup security for HR (roles, query trees, permission lists, row level security)
  • Created App Engine and Component Interfaces, as per client's specs.
  • Met with Auditors to ensure Security was SOX compliance.
  • Provided training documentation on Peoplesoft Security for v8.9.
  • Created roles/permission lists for HRMS, Payroll, Talent Acquisition Manager, and Benefits modules.
  • Took lead in assisting IT Department with cleanup work for upgrade prior to go-live.
  • Setup Payroll, Benefits, and HRMS, and eApps users for user acceptance testing.
  • Migrate objects from one environment to another.
  • Configure Portal and Single Sign on
  • Ensure Process Scheduler is up and running.
  • Check stats, troubleshoot, and perform maintenance for Performance Tuning using Eagle Eye Performance Tuning Tool.
  • Wrote SQL scripts via SQL Query Tool.
  • Convert data from one environment to another.
  • Refresh databases as requested by client.
  • Check PSNT and UNIX server for stability.
  • Modify SQR and code as requested.
  • Configured Websphere Portal over SSL.
  • Ensure Development and Testing environment were up and running accordingly.
  • Perform application upgrades/database enhancements per client's request.
  • Install, test, and implement additional PeopleSoft products such as HireRight and e-Learning.
  • Complete project migrations, perform installations, and configure components within the PeopleSoft Internet structure.
  • Provide on going support before and after upgrade.
  • Conduct routine hardware and software audits of workstations and servers to ensure compliance with established standards, policies, and configuration guidelines.
  • Bounced app and web servers.
  • Develop customizations as per client request.
  • Install patches/fixes per Peoplesoft Tools requirements.
  • Conduct routine security audits of Peoplesoft enviroment to ensure SOX compliance.

Confidential, (Natchez, MS) (Remote) 08/06 - 11/06
Peoplesoft Technical Fast Security Peoplecode for v7.5

  • Revised Peoplecode to enable the fast security changes to take effect immediately when the HR personnel make employee record changes or perform new hires. This new code change bypassed the client of having to run the Fast Security application engine manually.
  • Implemented query security for performance on 354 tables.
  • Assisted client with the migrating of the project from TEST To PRD.

Confidential, (Alpharetta, GA) (Remote) 07/04 - 05/06
Peoplesoft Technical/Functional Specialist

PROJECTS

  • NEU (Northeastern University) - upgraded Student Administration from v 7.6 to 8.9. Setup Security user profiles for 16,000 users for Campus Community, Student Recruiting, Student Admissions, Records and Enrollment, Financial Aid, Student Financials, Academic Advising, and Records and Enrollment. Implemented Peoplesoft CRM v8.8, Tools Rel. 8.44.06.
  • KCTCS (Kentucky Community Technical College) - implemented Student Administration for 9.0. Setup Security user profiles for 13,300 users for Campus Community, Student Recruiting, Student Admissions, Records and Enrollment, Financial Aid, Student Financials, Academic Advising, and Records and Enrollment.
  • CBT (Caleb Brett) - upgraded Financials from v8.0 to 8.8. Setup Security for 200 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Inventory, Commitment Control, and Asset Management. Implemented eRecruit module. Upgraded Peoplesoft HRMS from v.8.3 to 8.9. Setup Security for 97 users for PS HRMS (HR, Global Payroll, Benefits).
  • Navitarie - upgrade Financials from v8.0 to 8.8. Setup Security for 630 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, Inventory, Commitment Control, and Project Costing.
  • Self Realization Fellowship - implemented Peoplesoft HRMS for v9.0. Setup Security for 332 users for PS HRMS (HR, Payroll, Benefits). Implemented Peoplesoft Financials for v8.8. Setup Security for 150 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, eBill, and Project Costing. Responsible for tax updates and fixes.
  • Williams Lea - implemented Peoplesoft HRMS and ePerformance for v8.9. Setup Security for 554 users for PS HRMS (HR, Payroll, Benefits). Implemented Peoplesoft Financials for v8.8. Setup Security for 223 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, and Project Costing).
  • UAP (United Agriculture) - upgraded Peoplesoft Financials from v8.3 to 8.8. Setup Security for 287 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, and Project Costing. Upgraded Peoplesoft HRMS from 7.5 to 8.9. Setup Security for 327 users for PS HRMS (HR, Payroll, Benefits
  • UMG (Universal Music) - upgraded Peoplesoft Financials from v8.3 to 8.8. Setup Security for 665 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, and Project Costing). Established user profiles, roles, and permissions for each user according to role. Upgraded Peoplesoft HRMS Time & Labor from 8.3 to 8.9. Setup Security for 25 users for Time & Labor and 1200 Time Entry users.
  • BWAY - upgraded Peoplesoft Financials from v8.3 to 8.8. Setup Security for 132 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, and Project Costing). Implemented eRecruit, ePay, ePerformance, and eCompensation, for v8.9. Setup Security for 3211 users for eApp modules
  • Scott & White - upgraded Peoplesoft Financials from v8.0 to 8.8. Setup Security for 643 users for General Ledger, Account Payable, Purchasing, Accounts Receivable, Billing, Asset Management, Workflow, Inventory, and Project Costing). Implemented PS HRMS, (HR, Payroll, Benefits) for v8.9. Setup Security for 103 users.

DAILY RESPONSIBILITIES:

  • Provide expert of troubleshooting tickets , via HEAT, for isolating technical \\ function problems within Kronos Payroll, Peoplesoft HRMS (HR, Payroll, Benefits, Student Administration, Self - Service, eBenefits, eCompensation, eRecruit, ePerformance, and Time and Labor) and Financials (Accounts Payable, Accounts Receivable, Asset Management, General Ledger, Billing, Workflow, Purchasing, Project Costing, Inventory, Commitment Control, CRM, from versions 7.5 to 8.9 for 56 hosting clients.
  • Provided Kronos and Peoplesoft Security restructure for all clients' systems are in compliance with Sarbanes Oxley - SAS70.
  • Created and documented disaster recovery plans.
  • Implemented and documented client requirements for ISO 20000 and ISO 27000.
  • Assisted with change control activity.
  • Defined secure system configuration, tested ICT business and disaster recovery plans.
  • Created audit information security documentation controls for company.
  • Lead audit activities for support.
  • Assisted with RFP and Information Security responses for clients.
  • Implemented Fast View Table 1 on JOB_DATA and PERSONAL_DATA components for Search Records EmpL_SRCH_CORand PERS_SRCH_GBL.Used FAST_SCRTY_1 in order to load a pre-indexed table,FAST_SCRTY_1,with the security tree information matched with the content of the job data record. With this one used, system performance is greatly enhanced. Also, resolved the fast security issues with a recommended Peoplesoft customization to the HR_FASTVIEW app engine to allow the process to see inactive departments.
  • Provide resolution for Cedar Peoplesoft Patches/Fixes and Tax Update issues, debugging, migrating of objects from one environment to the other via Data Mover and/or ftp on both NT and Unix servers, app engine, peoplecoding, testing menu and component panels before going 'live' with new customizations, and provide modifications to SQRs.
  • Work with DBAs to ensure refreshes of environments are being completed when requested.
  • Work with DBAs to ensure all .ora name files are being updated accordingly.
  • Work with Winserver Administration team to ensure printer setups and new installation of servers are installed accordingly.
  • Work with Network Administration team to ensure IP changes, router changes, outages of network, and Firepass issues/changes are completed in a timely manner.
  • Create scripts via SQL Plus and Data Mover to import and export data from one environment to another.
  • Prepare documentation on Security policies and procedures for each client.
  • Create PS Queries, upon customer's request.
  • Troubleshoot issues with nVision and Crystal reports.
  • Create projects and test plans for each task that I am assigned to in regards to upgrades and implementations.
  • Ensure Unix and NT Process Schedulers are brought up in a timely manner when down, via PC Anywhere.
  • Bounce app servers when requested.
  • Ensure SLA's (Service Level Agreements) - Target and Actual resolution and response times are responded to within 15 minutes and resolved in a timely manner.

Confidential, (Atlanta, GA) 9/98 - 11/03
Peoplesoft Security Analyst (HRMS, Time and Labor, Financials, Kronos , JP Morgan)

  • Over a five year period provided Security upgrade knowledge for the following projects; Peoplesoft HRMS 6.0 to 7.0 to 7.5 to 8.3 to 8.8 and Peoplesoft Financials 6.0 to 7.0 to 7.5 to 8.4.
  • Provided leadership and direction to the Security staff to insure group goals are met and served as subject expert for security group
  • Maintained security for PeopleSoft Financials & HRMS including adding, deleting, and reassigning users for domestic offices; provided documentation and developed processes and methodology for regional security of London and Hong Kong office
  • Oversee day-to-day operations for Security related issues.
  • Worked with Management Team to ensure PeopleSoft issues were resolved in a timely manner.
  • Assisted with QA testing for security as part of change control security testing for Financials and HRMS environments, which include Base Benefits.
  • Reviewed Remedy tickets daily to ensure they were resolved in a timely manner.
  • Supported 2400 PeopleSoft end users, both domestic and international.
  • Performed regular system access password changes for PeopleSoft Financials & HRMS, both domestic and international
  • Performed security audits on all systems, end-user testing, create/maintain security documentation
  • Backup for migrations team. Migrated objects and projects from one environment to the other.
  • Produced and distribute security reports quarterly to Controllers in accordance with security policy
  • Provided expertise in configuring PeopleSoft security for both Financials and HRMS to meet functional requirements. This includes configuring role actions, roles and permission lists, row level security, and user preferences, and workflow.
  • Provided expertise in using LDAP authentication in the PeopleSoft environment.
  • Provided knowledge of security issues around integrating PeopleSoft with other applications using an integration broker.
  • Provided knowledge of single sign-on in the PeopleSoft environment.
  • Created scripts via SQL Plus and Data Mover to import and export data from one environment to another.
  • Prepared and maintained documentation on Security policies and procedures.
  • Maintained Security for all environments such as: QA, Train, Production, Conversion, Sandbox, Configuration, Developments, and Test.
  • Maintained Security for tree manager in HRMS.
  • Added departments and companies in HRMS environment to appropriate tree node (business unit)
  • Maintained effective - dated trees within HRMS to make sure appropriate departments and companies were added.
  • Customized payroll company table within application designer to fit Security structure for payroll departments
  • Created queries according to user requests.
  • Acted as a liaison between project team and user community in order of gathering requirements for upgrade of Financials and HRMS.
  • Added appropriate tables to query access groups within HRMS.
  • Maintained department tables for Payroll, HR, Benefits, and GLI.
  • Worked with development in starting and stopping PIA (Peoplesoft Internet Architecture) in order to remove cache.
  • Determined functional/business requirements.
  • Processed documentation for the implementation of Administer Training, eRecruit, eCompensation, Base Benefits, and Career and Succession Planning within the HRMS Peoplesoft system.
  • Constructed process analysis for technical and functional team.
  • Assisted with end - user training materials.
  • Assisted technical group in the development life cycle.
  • Used Mercury as an automation tool for load testing of HRMS 8.8.

Confidential, (Atlanta, GA) 1/96 - 9/98
Sr. Staff Accountant/Analyst

  • Responsible for accuracy of assets in Peoplesoft Fixed Assets System.
  • Reviewed maintenance and supplies expense for capital purchases.
  • Maintained the schedule of prepaid maintenance contracts and amortize to expense.
  • Reconciled bank statements, prepared journal/accrual entries, and reviewed P & L statements during month-end close.
  • Compared quarterly, month-to-month, and year-to-date variances.
  • Reviewed balance sheets and budgets for all Medaphis business units.

Education:

Business Administration
Accounting

Skills:
Software: Kronos v2c, Remedy, HEAT, Ftp, PC Anywhere, Terminal Servers, Unix, NT, Windows XP/2000/2003, NT, Unix, Active Directory, IT Infrastructure Security, Web-Based Application Security, AS400 Security, MS SQL, Toad, Peoplesoft Security, PeopleSoft Financials 7.5 - 8.9, PeopleSoft HR/Payroll 7.5 - 9.0, Time and Labor 8.9, SQRs, Data Migration, Data Mover, SQL, SQR, Application Engine, Application Designer, Workflow, Fixed Assets Management System, Certifications in PeopleTools , Peoplesoft HRMS and Financials, Peoplesoft Directory Interface, LDAP, Single Signon, and Global Payroll
Databases: Oracle, SQL Server

We'd love your feedback!