Profile
Anil is a technology professional with over twenty-five years of experience in all phases of design, development and implementation of computer business application. He has worked for clients within the insurance, manufacturing, communications, healthcare and Utilities. His areas of expertise include PeopleSoft Human Capital Management, Payroll, Time & Labor, Payroll Interface, Benefit administration and E application. Fifteen years plus hands-on experience in developing applications in PeopleSoft Anil has a strong system design and programming background
PeopleSoft Certifications
Human Capital Management, PeopleSoft Enterprise
Technology, PeopleSoft Enterprise
Skills Summary
PeopleSoft
Human Capital Management
Base Benefits
Time & Labor
Payroll
Payroll Interface
Benefit Administration
E- Apps
PeopleCode
PeopleTools
App. Engine
Component Interface
App. Messaging (EIP)
Workflow
Upgrade Assistance
XML Publisher
Databases
Oracle 5x/11.x
VSAM / DB2
IDMS
Operating Systems
Windows NT
AIX
DOS
Windows 2000
HP-UX 11.11
OS/VS2
Sun Solaris
Digital UNIX
Windows (3.1, 98)
Programming Languages
SQR
COBOL
RPG
Developer 2000
Oracle Forms 3.1 / 4.5
Oracle Report writer 2.5
PLSQL
Additional Skills
Case Tool – Designer 2000
Case Tool – Turbo Analyst
HCMS Experience
PeopleSoft HCMS ver 9.2,9.1, 8.9, 8.8, 8.3, 8.0, 7.5, 6.0, 5.1
PeopleTools ver8.53, 8.51, 8.47, 8.44, 8.40, 7.50 and lower
Relevant Experience
Independent Contractor July 2004 till date
MetLife – NY PeopleSoft HRMS v 9.1 Upgrade
May 2010 –Till date
Anil is a Techno functional People soft HCMS Integration resource Upgrade, Merger & Acquisition
Currently working on 9.2 upgrade – Analyzing new functionality for NA Payroll to de-customize current customization (planning stage)
Currently working on Global rollout for Brazil, Mexico, UK, Ireland and Morocco. Setup of organization data, e.g. SetID, Company, Paygroup and Security setup by Setid Department tree. Conversion of Job data, Personal data, Earning, Bank details and Deduction. Setup Delivered Payroll interface for 5 countries.
Setup on OE 2013 for New Company Nelico set up new Benefit programs, new plan setup, eligibility rules, New benefit carriers, Catch up setup changes from flat amount to Percentage. Developing SQR for New and current carriers and data feedback to these carriers, New sqr to upload different Saving plan employee data from two carriers, One for MetLife and other for Nelico, as Nelico have 6 different saving plan with three Employer match and Match is based on YTD bases rather than Per pay check.
Setup Base benefit for 2012 for Nelico employee as it was mid year conversion Payroll was processed starting from July 2012 and all Benefit deduction were converted general deduction with the exception of savings plan and new carrier interfaces were written to send Pay roll benefit deduction
Identifying functional and technical gaps between the client’s PeopleSoft 8.9, customization and delivering PeopleSoft 9.1 application for HR, Benefit admin,Payroll and Time & labor
De-customized Pay calculation as some of the customization was delivered in 9.1 or Business decided to adopt people soft process.
Supporting the client with the 9.1 Setup of Core HR, benefit and payroll & Time & labor tables involved with day-to-day functional and technical support for HR, benefit, payroll, T&L, manager and employee self service with workflow
Customized PeopleSoft benefit COBOL for 401k match for New Company (Nelico), as match would be given even if employee is not contributing but has contributed (Percentage) greater then the e the employer match Percentage. Basically the match is on YTD bases rather then Pay check bases.
MetLife Acquired Alico (AIG Subsidiary) and Nelico Companies and were able to Merger with PeopleSoft HCMS in record time within 6 Months. Reusable Component Interface for data load. Example –Component Interface HR Data load - Personal data, Job, Dependent, Emergency Contact, Education, Payroll balance, direct deposit, Employee Tax data.
As Alico employees were acquired on 1st Nov 2010, new benefit plan and benefit programs with eligibility rules were set for the remaining year and employees were enrolled via Open Enrollment for 2010. As of 1 Jan2011 these employees are enrolled in MetLife benefit plan.
Nelico employees were enrolled into New Benefit program with different benefit plan then MetLife. Setup up of benefit plan, eligibility rules and testing the new rules was completed successfully.
Developed 5 new report via XML publisher, using Query and Connected Query for HR Department
CUNY – NY PeopleSoft HRMS v.9.0
Jan 2009 – April 2010
Anil was the Techno functional Integration resource for Data analysis and mapping HR, Benefit & Payroll from legacy system and interfacing it legacy Payroll System and Employee self service and manager self service. Analyses of the current legacy processes and recommend best PeopleSoft solutions. Demonstrated to CUNY technical team how to use Peoplesoft XML publisher using query and Connect query and XMPL word plug in for report format (RFT template) and XMPL definition and running XMPL Publisher App. Engine . His responsibilities included the following.
Studying current (New York City & New York State) Batch legacy Payroll, HR and benefit system and generation of data dictionary map between legacy and PeopleSoft HCM 9.0 data element. Which is used for conversion & interfacing from HCM to Legacy system for New York City and State payroll processing
Conversion of data from Legacy to PeopleSoft HR 9.0 using Excel to CI and custom Component Interface HR Data load - Personal data, Job, Emergency Contact, Employee Tax data. Phase 1 rollout includes 5 State and 5 Community collages approx 10 thousand employees
Implemented Mass salary change.
Implemented EIP between PeopleSoft Financial and HCM for Department and Account code.
Recommending and implemented alternatives to customizations to best meet the client’s business processes requirements
Modified On-line Personal, Job, Heath Benefit and Additional Pay pages for custom fields as required by legacy system
Develop On-line People code edits for referential integration between HCM and legacy system.
Assisting users thru production issue and debugging
Assisting CUNY employee for functional issue between Legacy and HCM reference table design.
Currently designing Payroll Interface for New York City and State employees using PeopleSoft delivered Payroll Interface process.
MetLife – NY PeopleSoft HRMS upgrade v. 8.9
Feb 2006 – Dec 2008
Anil is a Techno functional Integration resource upgrading and supporting HRMS 8.9. and Global implementation planning
Implemented PeopleSoft 8.9 Time & labor out of box with custom rules, as compared to heavily customized T&L 8.3 module
Implemented Payroll Interface and Absence management for Global Rollout India & UK
OE 2008 was done for the new acquired company from scratch, with new Benefit programs, new plan setup, eligibility rules and interfaces were written to upload data in HCMS from the carrier and Payroll benefit deduction interfaces to the carrier.
In 2008 MetLife Acquired 3 Companies and were able to Merger with PeopleSoft HCMS in record time within 90 days, after the First acquisition, India Operation of around 7,000 employees was also loaded using Reusable Component Interface for data load. Example –Component Interface HR Data load - Personal data, Job,Dependent, Emergency Contact, Education, Payroll balance, Direct deposit, Employee Tax data
Identifying functional and technical gaps between the client’s PeopleSoft 8.3, customization and delivering PeopleSoft 8.9 application for HR, Benefit admin,Payroll and Time & labor
Implemented HCM 8.9 new POI module to incorporate non employee & employee into one consolidated HCM system
Setup and Implemented Delivered 8.9 functionality for Alternative Overtime payroll FLSA calculation as compared to customization in 8.3
Supporting the client with the 8.9 Setup of Core HR, benefit and payroll & Time & labor tables involved with day-to-day functional and technical support for HR, benefit, payroll, T&L, manager and employee self service with workflow
Recommending and implemented alternatives to customizations to best meet the client’s business processes requirements
Implemented 8.9 new security SJT- MetLife customized some of the core Security objects, some due to lack of required features in HRMS 8.3 which are available in HRMS 8.9.
Assisting users thru production issue and debugging
Assisted IT and Business with the Concept of SETID and Business Unit for Global planning and impact on security tree
Assisted IT with concept of delivered Payroll Interface functionality for Global
City of New York Implementation of HCM 8.8
July 2004 – Jan 2006
Anil was the Techno functional Integration resource for Data analysis and mapping HR, Benefit & Payroll from legacy system and interfacing it legacy Payroll System. Analyses of the current legacy processes and recommend best Peoplesoft solutions. His responsibilities included the following.
Studying current Batch legacy Payroll, HR and benefit system and generation of data dictionary map between legacy and PeopleSoft HCM 8.8 data element. Which was used for conversion & interfacing from HCM to Legacy system for payroll processing
Design and develop Payroll Interface using Peoplesoft delivered process and custom process (App. Engine. & SQR) to interface HCM data into legacy batch transaction.
Design and develop Interface using Component Interface to upload legacy system mass retro regular pay and additional pay changes to HCM Job, Compensation and additional Pay
Design and develop Benefit Interface SQR for different provider for any change in benefit or dependent
Modified Peoplesoft auto generation of Emplid process to update real time DB2 (emplid) share table as this table is used by the legacy system.
Modified On-line Personal, Job, Heath Benefit, Additional Pay and compensation pages for custom fields as required by legacy system
Develop On-line Peoplecode edits for referential integration between HCM and legacy system.
Assisting users thru production issue and debugging
Assisting City employee for functional issue between Legacy and HCM reference table design.
Working for PeopleSoft Inc. as Sr. Consultant March 2002 until June 2004
Interpublic Group Implementation of HCM 8.8
March 2004 – May 2004
Anil was the functional resource Fit and Gap analysis for Benefit Administration. His responsibilities included the following.
Studying current benefit and map to PeopleSoft benefit
Supporting Human Resource and Payroll including E-Pay after go-live as the functional and technical lead role
Assisting users thru production issue and debugging
401K calculations based on the company seniority date instead of the service date and the employer before tax and after tax match
Modifying rapid time entry and fixed pay sheet upload processes
Merging the W2 data from two different PeopleSoft versions 7.5 and 7.01
GMAC Implementation of HCM 8.8
October 2003 – February 2004
Assisting PeopleSoft Lab with implementation of v. 8.8
Providing functional and technical support to implement HR, Benefit Admin, and Payroll Time and Labor including manager self service, and employee self service involving HR core table setup, Benefit Plan setup, Benefit events setup & benefit rules setup and Payroll setup, time & labor rules (Special rule half day), workgroup setup
Modifying Time admin for optimization
Implementing workflow for manger self service & employee self service
Overseeing Client was live with HR and manager & employee self service, with minimum customization
Benefit Admin and Payroll was implemented in Jan 2004
Supporting the client with the Setup of Core HR, benefit and payroll tables involved with day-to-day functional and technical support for HR, benefit, manager and employee self service with workflow
Lucent Technology – NJ Upgrade from 7.5 – 8.0
October 2002– October 2003
Anil is a Functional and Technical lead upgrading and supporting HRMS 8.0SPI. Lucent was a Mutli Currency, Unicode, Global HRMS installation. Mr. Yadav’s responsibilities included the following:
Implementing employee self-service and manager self service, and PeopleSoft payroll interface for Asia Pac, Europe
Implementing applications, message and component interfaces
Troubleshooting App. Message, Component Interface, App message interfaces with Pension system (Outsource to AON), Payroll (SAP), POST (Directory System)
Implementing four levels of approval process for manager self service, pool work list customization, workflow administration and training end Users regarding workflow business process
Implementing and customizing payroll interface for over 48 companies and pay groups across the globe with customized payroll interface change reports
Building control reports for reconciliation with payroll interface vendor
Verizon – MA PeopleSoft HRMS Upgrade from 7.5 to v. 8.3
March 2002 – October 2002 Mainframe DB2
Anil assisted with the PeopleSoft upgrade from version 7.5 to 8.3. His responsibilities included the following:
Modifying upgrade scripts and AE scripts
Adding customization code
Troubleshooting functional and technical issues regarding parallel testing
Customizing PeopleSoft processes, SQR AE program, Payroll calculation (COBOL)
Knowledge transfer of the 8.3 PeopleSoft version HR, base benefit and payroll functionality
Implementing manager self service through the workflow and approval process and customizing Paycalc
Independent Contractor until February 2002
MetLife – NY PeopleSoft HRMS v. 8.3 and 7.5
March 1999 – February 2002
Anil responsibilities included the following:
Preparing functional design documentation calculating deductions
Calculating employer SIP contribution involving calculating Employer match complying with IRS Code 3121(v) for withholding of FICA taxes on matching contributions in a NQDC plan
Functional & Technical analysis for the upgrade from 7.5 to 8.3
Modifying and customizing tables into PeopleSoft version 8
Identifying functional and technical gaps between the client’s PeopleSoft 7.5 and delivering PeopleSoft 8 application for HR and benefit admin
Customizing payroll modules
Recommending alternatives to customizations to best meet the client’s business processes requirements
Converting data from the Legacy System into PeopleSoft data mapping for HR and payroll tables
Assisting with fit/gap analysis for the General America IT department, personnel, employment, job, taxes, balance history, W2 history, deduction balance and various other records on the TESSERACT system
Providing Technical help support for the pension administration functional team involving PeopleCode, panels, batch process (COBOL programs & SQR)
Providing functional analysis for upgrading PeopleSoft HR, Benefit Admin, Payroll and Time and Labor from version 6.02 to 7.5
Providing functional analysis for HR, Benefit Admin, Retro Module & Time and Labor Module meeting Company requirements
Modifying the Retro Calculation process in COBOL implementing PeopleSoft coding standards
Correcting People Soft COBOL Programs the Saving Plan calculations
Setting up payroll earning, deduction, setid, tax tables for payroll, nondiscrimination test, before tax limit salary cap tests and other highly compensated test
Analyzing and modifying the year end process and customizing panels and PeopleCode to meet Company requirements
Developing and coordinating users roles and security permission lists for users
Organizing user acceptance testing, test plans, coordinated testing efforts, conducted system testing
Researching and resolving testing issues
Allied Signal NJ – PeopleSoft HRMS v. 7.0
February 1998 – March 1999 Mainframe DB2
Anil responsibilities included the following:
Functional analysis for benefit plans & eligibility rules to automate the Benefit Admin, Saving Plan, Internal Billing System and Leave Accrual System and GL interface with SAP and Legacy system
Modifying PeopleCode for eligibility and savings plan selection by company and Pay Group SQR
Writing calculations for the various employee Savings Plan options
Writing a data extraction program for Saving Plans for the Provider State Street Bank (SSB)
Transferring the loans and saving plan and other details into PeopleSoft Tables
Writing SQR for a Standardized GL Interface file that follows the requirements for SAP & Legacy (MSA, Walker System)
Designing and implementing the Internal Billing System
Implementing and modifying the Leave Accrual System as Company for the various divisions and eligibility rules
PG&E – San Antonia TX – PeopleSoft HRMS v. 5.1
August 1997 – January 1998
Anil responsibilities included the following:
Setting up HR, Base Benefit and Payroll modules
Setting up benefit plans, age rate, benefit/deduction program, calculation rules, FSA benefit, leave plan, life & ADD, provider, savings plan, eligibility rules, geographic location & rate schedule for 1998 enrollment
Creating a new panel for flex data entry and correction for the 1998 enrollment
Writing PeopleCode implementing Derived Work for checking price (credit) and cost per new enrollment rules
Modifying PeopleCode for eligibility and saving plan selections within savings plan
Completing open enrollment and event management processes
Writing data extraction program for benefit plan including dental, vision, medical, cancer, and FSA health
Transferring Fidelity data extracts and Fidelity loans and other details into PeopleSoft tables
Writing a generalized SQR utility to print data dictionary for fields, tables, panels and SQR programs for different plan types
Writing the Benefit-wise monthly premium reports
Setting up payroll for nondiscrimination test, before tax limit salary cap test and highly compensated test
Modifying the existing PeopleSoft pay calculation program