Peoplesoft System Analyst

Experience Summary

• Over * years of PeopleSoft experience, that includes Techno Functional Consultancy of PeopleSoft HRMS/HCM Application with one of the top IT companies Larsen & Toubro Infotech Ltd.(employee strength more than 11000).

• Having rich work experience in Banking, Manufacturing, Insurance and IT sectors.

• Strong experience in various HCM modules including Administer Workforce, Talent Acquisition, Position Management, NA Payroll, Variable Compensation, eLearning, ePerformance

• Assist various clients in the selection, implementation, planning, fit-gap analysis, configuration, testing, rollout and post-implementation support of large-scale PeopleSoft solutions.

• Oversee, manage, and support system implementations, in-house applications, ongoing maintenance, upgrades, enhancements, interfaces and integration with existing and new products.

• Work in a techno/functional capacity with a good understanding of business processes, relational databases, PeopleSoft data models and PeopleSoft Internet Architecture

• Build and Maintain Production Support Processes and Procedures, Build tools and Maintain quality of end product, coordinate logistics of issue resolution and effort among multiple teams involved in the process.

• Adept at leading the team of technical expertise in various situations

• Possess excellent analytical skills, Effective verbal, written and interpersonal communication skills and can work independently with minimal supervision.

• Create and review documentation on existing modifications and propose methods for improving existing business processes using latest technology.

Key Peoplesoft Skills

PeopleSoft Applications: HCM 9 with Tools 8.48, HCM 8.9 with Tools 8.47, HRMS 8.8 with Tools 8.46, HRMS 8 with Tools 8.15

Modules: Administer Workforce, NA Payroll, Base Benefits, Talent Acquisition, Recruitment Workforce, Compensation, Training and Development, Position Management, Career Planning and Succession, ePerformance, eRecruitment, eLearning, MSS, ESS

PeopleTools: Application Designer, PeopleCode, Application Engines, Component Interfaces, Tree Manager, Application Packages, PeopleSoft Integration Broker, Portal Registry, Data Mover, Process Scheduler, PeopleSoft Workflows, File Layout

Reporting Tools: SQR, PS Query, Query Manager, Crystal Reports, Toad, SQL Plus

Languages: C, Java, XML, HTML, JavaScript, SQL, Shell script, Informatica

Database: Oracle 10g, 9i, SQL Server 2000,DB2

Operating System: Windows, Unix, Linux

Project Details

Client: Investment Banking, USA (June 2007 till date)

PeopleSoft System Analyst

• Implement Global Policy and Procedure for the ongoing maintenance of Lehman HRMS 8.8 application. This involved understanding of Business requirement, Designing of Data Models, creation of Data flow maps, Development of the panels and Configuration of Security

• Provide a workflow tool which facilitates different approval processes of HRIS like Hire, Rehire, Promotion, Pay Rate Change, Termination, etc. This has been achieved by designing a flexible Workflow meta table and by integrating this application with third party Tibco workflow tool using Java and PeopleCode

• Set up and maintained interfaces between PeopleSoft Benefits module and legacy benefit system.

• Applied Patches and Bundles to PeopleSoft Development environment using Change assistant and Data Mover scripts

• Being responsible for Employee data flow to the requisite application across the firm using PeopleSoft Application Engine and Informatica tool. This has been achieved after high-level analysis of the data to be migrated, creation of Data transformation maps, data cleansing and execution of jobs

• Developed PS Queries and SQR to verify Configuration and also new Reports as per Client Requirement,Review all delivered Audit reports to ensure proper set up of Benefit Information, Employee Information and their Dependent Information

• Monitoring and Reviewing Employee and their Dependent HR Transactions, Benefit Enrollment Process and Analysis of Benefit Activities under BAS activity screen under EM BEN Admin Process

• Automatic Mass Creation and Setup of user profiles as per the business logic using customized PeopleCode scripts along with configuration of Application Security for different Business Units and customized PeopleSoft functions to grant read-only or/and read-write access to HRIS data

• Developed complex reports using ‘Excel Download’ functionality which is built on PS Queries and PeopleCode

• Created Shell scripts for scheduling program, SQLs, Mail notifications for status and other processes in the required sequence. Scheduling of Unix Jobs was also done using Shell scripts

Client: Consumer Service Provider, USA (Dec 2006 to Jun 2007)

PeopleSoft Senior TechnoFunctional Consultant

• Provided support for Core HRMS, Base Benefits and NA Payroll

• Analyzed the Jobs that failed everyday and created a report for the same. Also did a trend analysis to find the root cause of failure and fixed the issue in the major programs.

• Modified and optimized the process interfaces to the different vendor applications that are integrated with the Base Benefits and NA Payroll modules

• High Level analysis of Payroll processes at various stages. Reviewed and resolved Payroll error messages in Paysheet creation.

• Modified Payroll Jobs and Cobol processes in Creation of Paysheet, Running initial calculation process, Running final calculation process and Creation and Printing of checks and direct deposits

• Modified existing tax reporting SQR. Monitored and Applied appropriate Tax updates

• Designed and developed a user interface application module to report detailed payroll information based on selective data with PeopleSoft pages, PeopleCode and Application Engine program

• Customized PeopleSoft Workflow for W2 and W4 annual processing

• Closely Working with Business Analyst for configuration of Benefit Administrator in PeopleSoft 8.9 such as Setting UP deduction Code, Setting up Health Care Vendors and Interfaces, Setting up Rate, Calculation Rules and Rounding Options, Setting up Benefit Statuses, Set up Job Defining Rule Eligibility, Configurations of different Benefit Plans and its Options, Defining Ben Admin Programs, Defining Job-Non Job Events, Setting up BAN Groups, Defining OE and Snap Shot Process IDs, Setting Up of Schedules for OE and EM Processes

• Developed complex PS Queries for for maintaining the integrity of the data and also as a means of a heightened security measure for auditing

• Replaced PeopleSoft process scheduler by creating Shell Scripts to run PeopleSoft processes and Jobs

• Developed upload programs for Base Benefit control tables for Provider, Dependant Relationship and Service step table

• Resolved issues of Open Enrollment and Benefit related Payroll Calculations

• Development &Customization of Benefit Audit reports to ensure integrity between Employee Benefit information, Benefit Programs and Employee data

• Modification of existing Workflows i.e Late Enrollment as per Client Requirement

Client: Manufacturing, France (Oct 2005 to Nov 2006)

PeopleSoft Upgrade Analyst

• Studied Compare reports between Vanilla and COP to identify customer Customizations. Involved in Fit-Gap Analysis of Customer Business Process and mapping of Data and default values as a part of pre upgrade transaction processing. Identified and studied Customized SQR reports, PS queries, Crystal reports and Application Engines.

• Applied PeopleTools changes including script modification, Updating PeopleTools system Tables, Loading Model Definition, Loading Message Data, Copying Projects, Populating Tablespace Data, Loading language Data.

• Designed and Developed custom tools to retrofit PS Query and SQRs. Analyzed and Reconfigured PeopleSoft Security. Altered Tables and deleted obsolete columns from COP as a part of completing the Migration. Reapplied customizations and retrofitted all Customize PeopleSoft Objects.

• Co-ordinating the efforts of migration of retrofitted projects after every upgrade pass and Resolving issues logged by functional team after every upgrade pass.

• Created Data Conversion programs loading data into bolt-on modules. Scheduled PS Queries to run to ensure data integrity in the upgraded PeopleSoft system.

• Coordinated data Set up for Training and documentation for Recruitment, Admin and Training modules in preparation of the PeopleSoft Upgrade

• Played a major role as an Integration specialist by modifying customized application messages and subscription logic, resolving the data migration issues with the help of the debugging tool

• Customized Group Build process as per client requirements which was used for Benefit program

• Developed Carrier interfaces for Benefits provider as per requirement which involved Data Analysis, Data Mapping, creation of complex views and thorough understanding of Vendor configuration files requirements.

• Development of new PeopleSoft Objects for Ben Admin Process

• Supporting and Monitoring OE and EM Ben Processes and Resolve and Fix Issue rised at time of various Ben Admin Steps such as Determining of Participant Eligibility, Calculation of Benefit Deductions, Creation and Delivery of Enrolment Forms, Participant Elections, Load, Validation of Elections and Creation and Delivery of Confirmation Forms

• Working with PeopleSoft Admin to apply patches and bundles on upgraded environment.

• Provide Post Production support and Working with Issue Manager tracking system.

Client: Health Care, Denmark (Dec 2004 to Sep 2005)

Technical Lead

• Led the technical team responsible for module implementations, development, maintenance and production support of Administer Workforce, Recruit Workforce, Compensation, ESS, MSS modules.

• Developed technical standards and procedure guidelines related to coding, configuration, management, change management, object migration and environment maintenance

• Participated in numerous technical projects, including security reorganization, infrastructure, improvement, interface development, tuning, and data maintenance

• Studied the requirement and accordingly created in-depth Technical Specifications document along with Data flow and Data models

• Developed and approved data upload templates to upload data from Legacy system to PeopleSoft system.

• Organized and hosted UAT tests and workshops. Created testing scenarios, test scripts, user training material

• Acted as team technical expert in online and batch process troubleshooting, also providing support in configuration, database, and platform issues in an Oracle/Windows NT environment

• Develop Role security Matrix and Configure PeopleSoft Component Security

• Conducted Project status meeting and review the all resources activities

• Provided project training in tracing PeopleSoft applications, as well as mentoring team members in PeopleSoft technical

Client: Consumer Service Provider, San Jose, California (Oct 2003 to Nov 2004)

PeopleSoft Technical Developer

• Developed smaller enhancements, bug fixes, performance problems, queries for E-Recruit, Base Benefits and Training (E-Development) module

• Served as a key developer for troubleshooting, as well as batch, reporting, and custom development

• Modified existing interfaces, reports and processes Extracted data for the conversion process Provided payroll and HRMS production support

• Designed and developed customized SQR and Crystal reports for reporting.

• Involved in trouble shooting & error fixing on tickets and change requests

• Worked with the HR Charter system, providing support and dealing with problems interfacing with PeopleSoft Application Messaging

• Learned structured coding practices, and gained a thorough grounding in the systems and procedures required within large corporations.

• Performed quality audits to verify the standard of deliverables

• Responsible for Migrations of projects from development server to QA server in PeopleSoft 8.8 using PeopleTools 8.44 of all developmental assignments and change requests.

• Performed Testing for various phases of test cycles including test cases and test scripts, which includes regression testing and integration testing

• Provided quality assurance on development activity including interface and report development, conversion programming, application configuration and system customization

Educational Qualification

• Bachelors in Electrical Engineering

References will be provided upon request.

Contact this candidate