Peoplesoft Techno-functional Consultant Resume Profile
SUMMARY
- Key member in a project implementation for a leading resorts company in Florida USD 640,000
- Seasoned PeopleSoft HCM consultant with over 8 years of PeopleSoft Applications 8.1,8.3,8.8,8.9,9.0 to 9.1 and in BI tools such as Cognos ReportNet and Cognos Query Studio.
- Instrumental in PeopleSoft functional and technical solution, scope, fit gap analysis, requirements gathering, quality management, performance improvement, process reengineering, change management, global implementations, and production support.
- Expertise in modules - PeopleSoft Time and Labor, Recruiting TAM and CG , Global Payroll, Security Configuration, Workforce Administration and Self Service.
- Certified in North American Payroll FPC by American Payroll Association.
- Showcased product features and vendor capabilities to client teams pre-implementation phase
- Led a 6 person team for a 7 month implementation and eventual roll out to other properties in Bahamas, Paris and South Africa.
- HR Process redesign with recruiter teams and payroll members
- Post graduate diploma in Management from one of India's top management schools.
- Key member in 3 successful implementations, 1 upgrade and 3 production support projects.
- Involved in all aspects of ERP implementations From RFP response and project scoping to areas such as presales and user training.
- Strong experience in designing user interfaces and data migration programs through use of Application Engine, SQR, Component Interface and File Layouts.
- Highly proficient in analysis and resolution of technical and functional issues associated with delivered PeopleSoft programs.
- Clientele include 3 Fortune 500 and S P 500 companies, a leading investment bank and an international resorts provider.
TECHNICAL SKILLS
ERP Suites | PeopleSoft HCM, JD Edwards |
Tools used | Cognos Report Studio, MS Office suite |
PeopleTools | Peopletools 8.47x, 8.x and 7.5, Object Based Peoplecode, Peoplecode ,SQL/SQR for PeopleSoft, Crystal Reports for PeopleSoft, Process Scheduler, PeopleSoft HRMS, PeopleSoft Portals, Application Engine, Application Messaging, HTML ACCESS, WebClient, iClient |
Technologies | Integration Broker, App Messaging, Component Interface, Business Interlinks |
Operating Systems | Windows 3.1, Windows NT, Windows 95, Windows 2000, UNIX Sun Solaris, HP AIX |
Database | Oracle 10g, 9i, 8i, 8, 7 , SQL Server, SQL Anywhere |
Modules | Core HCM, Workforce Administration, Global Payroll, TAM and CG, Time and Labor, Security Administration |
PROFESSIONAL EXPERIENCE
Confidential
PeopleSoft Techno-Functional Consultant
Confidential is a leading Insurance provider. With Confidential and more than 1.5 million plan participants, with more than 200 years of expertise, The Confidential is a leader in property and casualty insurance, group benefits and mutual funds. The scope of the project was to implement PeopleSoft Time and Labor for their biweekly and semimonthly employees.
Responsibilities
- Technical analyst for PeopleSoft Time and Labor for Hartford Insurance
- Analyze the PeopleSoft Time Admin application engine program and prepare support documentation
- Create custom PS queries, SQL statements and reports for operations team in case of ongoing support and for time load process
- Prepare Business Requirements Document for new enhancements highlighting design approach and impacts on existing system.
- Create test cases and unit test plans for application testing by vendor teams
- Technical and functional analysis for support issues and document resolutions and fixes.
- Analyze custom peoplecode and test various scenarios for online transactions. Suggest peoplecode modifications as part of fixes or enhancements.
- Analyze SQR reports for errors in employee T L data or report lay out issues.
- Test workflow modifications in AWE and approval processes as well as email configuration.
- Built test data in the database to via PeopleSoft panels/pages to test different scenarios.
- Created technical and functional specifications.
- Created test scripts for system and integration testing.
Confidential
PeopleSoft Techno-Functional Consultant
Confidential is an Confidential aerospace and defense corporation. Confidential is made up of multiple Business units Confidential Commercial Airplanes, Confidential Capital and Confidential Shared Services Group. The upgrade project involved migration of security and core HR customizations from 8.8 over to PeopleSoft 9.1. Key activities involved retrofitting of SQR programs and Interfaces and re-customization of core workforce admin people code and security setups.
Consulting
- Structuring PeopleSoft solution approaches, business process reengineering and understanding of business problems.
- Retrofit of core HR SQR programs for 9.1 upgrade.
- Redesign of existing people code customizations.
- Tune SQR programs to redesign long running queries and enhance run performance.
- Draft RFP responses for client proposals.
- Modify application engine programs used for data migration. Incorporate custom logic into the data migration programs as per customer requests.
- Perform package evaluation, prepare compliance statements and roll out plans for proposed solution.
- Perform resource and effort estimations for new developments.
- Modify and design new PeopleSoft queries.
Confidential
Senior Manager
Technology Management
- Manage software products at the reconciliations division at ICICI.
- Showcase product features to various operations divisions and increase usage across departments.
- Comparative research of industry products to identify areas of improvement/pain points.
Vendor Management
- Prepare weekly and monthly status reports resource utilization, change requests in progress for business and technology forums.
- Analyze change requests, prioritize and allocate among vendor resources.
- Track deployment and evaluation of change requests from scoping and feasibility to final closure.
- Suggest architectural improvements on system/database design so as to better handle future business requirements.
- Resource budgeting for each financial year based on anticipatory requirements.
Confidential
PeopleSoft Technical Consultant
Confidential, uses several HR and compliance systems. The project involved designing security interfaces for porting data from the Confidential system to their security software. For example employee terminations and new hires in PeopleSoft require ID activates and access in the security system used by Confidential.
Responsibilities Activities as PeopleSoft Consultant:
- Prepare project plan and effort estimations.
- Involved in study of client business processes, end-user training, identifying critical gaps and design of solutions/workarounds.
- Set quality and process guidelines, communication protocols and configuration management as part of HCM ERP implementation for AIG corporate.
- Requirements gathering and preparation of file templates.
- Create detailed design documents for the SQR interfaces.
- Code and test plan reviews.
- End user training for teams in Hong Kong, China and Nan Shan.
- Data integration Using Java to CI templates to move date from custom web application to PeopleSoft.
Confidential
Role: PeopleSoft Techno-Functional Consultant
Confidential is a leading international resorts provider headquartered in Confidential. Prior to using PeopleSoft HRMS, they used JD Edwards for their HR processes and some of their recruiting processes were done manually.
The scope of the project was Confidential of PeopleSoft 9 in the back office of the resorts at Confidential and then eventual roll out to their properties in Confidential.
Responsibilities Activities as PeopleSoft Consultant:
- Presales Client presentations on the various modules and PeopleSoft benefits.
- Create As-Is and Fit-Gap documents during project study phase.
- Prepare data migration templates for various modules and use Excel to CI for master data migration.
- Design application engine programs and component interfaces for handling data migration for applicant data, employee job data and set up information master HR data such as job openings, SetIDs and jobcodes .
- Review of data migration programs for Core HR data and TAM.
- Configure customize approval processes AWE for replacement and new job openings.
- Customize Peoplecode for HRMS self service processes to route emails to the appropriate administrators based on the transactions.
- Design recruiter reports using XML Publisher.
- End-User training and UAT facilitation.
- Develop online customizations as per user requests Develop custom pages with file attachment options as well as to modify workflow email defaults.
- Use SQL loader and PeopleSoft data mover to prepare scripts for setup data migration.
- Coordinate with various job board vendors on outbound file formats and frequency of process execution.
- Security administration Create security roles and permission lists for the various users and super users and run custom processes to assign these roles to user profiles.
- Worked on Route controls and route control profiles to minimize workflow customizations.
- Setup master data for TAM and Candidate Gateway Job profiles, Job openings, Job opening templates, Job board integration.
Confidential
Role: GHRMS Techno-Functional Consultant Support consultant
Confidential a world leader in the production of industrial and earth moving equipment, uses PeopleSoft for its recruiting processes. It also uses Health and Safety and Plan salaries modules, for processing the HR activities of its employees.
The upgrade project involves moving the current production version PeopleSoft 8.3 , to the latest 8.9 versions, so as to drop off all custom enhancements brought by Confidential. Also in line, was a parallel implementation of Cognos report net, to suit the reporting needs of the various customers.
Responsibilities:
- Involved in the support and customization of the PeopleSoft erecruit module for production.
- Implementation and proposal of Change Requests.
- Analyze and support tickets on recruiting issues for resume viewing, job application, errors in resume submission and security challenges in manager access and internal job openings.
- Modify existing PeopleSoft Application packages for custom email features and approval workflow enhancements.
- Involved in the testing of e-recruit modules 8.9 Functionality .
- PeopleSoft Security Administrator for 8.3 and the new 8.9 Instances
- Data migration of security components Roles, Permission Lists and Users through application engine and component interfaces.
- Design and fix existing security Interfaces and develop new Interfaces.
- SQL tuning for SQR programs Performance enhancement
- Migrate delivered PeopleSoft Queries and SQR reports to Cognos Report Studio and Cognos ReportNet.
Confidential
Role: PeopleSoft Technical Consultant
The core of Aladdin upgrades PeopleSoft Human Resource Management Systems from version 7.02 to 8.8.It includes Confidential etc.
Responsibilities:
- Involved in the Customization and analysis of Payroll Reports.
- Implementation of Change Requests.
- Involved in the testing of e-recruit modules
- Create Application Engine with Component Interface with data migrations Competency information
- Work on outbound interfaces for benefits providers Using PeopleSoft Application engine and File Layouts.
- Creation of application engine programs with file layouts for outbound interfaces for Fidelity benefits data based interface
- Support for Stock and Benefits Modules.
- Enhancements Worker's compensation process SQR report , ISERP Sheltered employee retirement program are some of the processes modified.
- Design of core HR data migration interfaces Job data, Personal Data and Benefits.
- Customizations related to component interface for processes involving mass updates.
- Analyze PeopleSoft workflow and emailing requirements Based on self service ESS MSS
Confidential
Role: PeopleSoft Technical Consultant
- Confidential has its Human Resource systems running on PeopleSoft and homegrown legacy systems in Mainframe and client server technology. The entire Confidential Data exists in PeopleSoft 8.1, while the payroll data exists in 8.8. Therefore the project scope was to migrate the data from 8.1 to 8.8
- Also, the system used for payroll processing in Standard Chartered is a third party system called 'Abs Pay'. The aim of the project was to implement Global Payroll for four countries Confidential.
Responsibilities:
- Manage user service requests on HRMS and Global Payroll modules.
- Analysis of the Business Requirement Document BRD for complete functional understanding.
- Analysis of the program code for potential impacts.
- Draft Technical Design Documents based on the Business Requirement Document.
- Build Unit Test Plans and cases for the developed objects.
- Develop the code as per the functional design and test it exhaustively based on the plan.
- Conduct code reviews as per the guidelines
- Conduct UAT for all the developed customizations and receive signoff for their consequent rollout to production.
- Implementation of Banking file and GL Process creation of staging tables, process flow and underlying programs
- Development and optimization of Component Interfaces for Migrating data of Components such as Job, Bank Accounts, Personal and Dependant Information
- Analyze defects in PeopleSoft delivered payroll interfaces and prepare fixes for the same.
- Tune SQLs for delivered PeopleSoft application engine programs to enhance overall batch runtime and performance.
- Design data migration programs using PeopleSoft Application Engines and Component interfaces for Job data, Personal data, Benefits data and dependent information
- Perform, impact analysis for new rules introduced in Global Payroll Malaysia Create effort estimation documents for each customization
- Test PeopleSoft global payroll segmentation and retroactivity and make changes accordingly to the various payroll SQRs.
- Prepare defensive queries in PeopleSoft Query manager and in SQL for operations team to weed out defective employees for system audits.
- Manually fix any errors/discrepancies from the data migration programs and rerun the interfaces for the generated exceptions.
- Resolve pay slip related errors/issues post implementation and document any encountered bugs.
- Prepare training manuals and data fix sheets for known payroll issues to conduct smooth transition for the payroll operations team.
- Conduct user training for Confidential and Kenya payroll teams on PeopleSoft Global Payroll and Standard Chartered customizations.