SUMMARY

• Over Nine years of experience in Analysis, Design, Development, Testing and Implementation of ERP, Custom Development software and Web applications.
• Over Eight years of experience in PeopleSoft Implementation, Upgrade, Conversion, Design, Development, Customization, Tax Updates, Year End Stuff, Security Administration and Production Support experience in HRMS (8.0, 8.3, 8.9, 9.0, 9.2) modules.
• Involved in wide variety of Functional and Technical engagements involving fit - gap analysis, requirements gathering, application design and development.
• Experience in PeopleSoft HR, Time and Labor, Base Benefits, Benefits Admin, Payroll, Self Services (eRecruit/Candidate Gateway, eBenefits, eDevelopment, eProfile, ePay, ePerformance, eCompensation) modules.
• Proficient in Application Designer, SQR, XML Publisher, Crystal Reports, nVision, Process Scheduler, PS Query, Process Monitor, Data Mover, Upgrade/Change Assistant and PIA.
• Experience in developing, Customizing Interfaces and Conversion programs using SQR, Application Engine and Component Interfaces for HR, Benefits, and Payroll modules.
• Worked with integration technologies such as Application messaging and Component interfaces to integrate Peoplesoft applications with external applications.
• Experienced in writing Functional and Technical specification documents from scratch from user Interaction/ FIT-GAP analysis and implementing the same.
• Extensive experience in databases like DB2, Oracle, and MS-SQL Server.
• Experience in writing the test plans, cases and scripts based on system specifications and expertise in regression, system, integration, functional and performance testing.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS 9.x, 8.x ( HR, Payroll, Base Benefits, Ben Admin, Time & Labor), eApps ( eRecruit, ePay, eProfile, ePerformance, eBenefits, eDevelopment & eCompensation)

PeopleTools: PeopleTools 8.5x, 8.4x/8.20/8.1x/7.5

Integration/Developer Tools: Application Designer, PeopleCode, Application Engine, Component Interfaces, Application Messaging and Integration Broker

Database: Oracle 11i/10g/9i/8i/7.x, DB2, MS-SQL Server 2000/7.0 and MS-Access

Reports: SQR, PS Query, Crystal Reports 8.5/7.x, and n/Vision

Data Management Tools: Data Mover, Mass Changer, EDI Manager and Import Manager

Languages: C, C++, COBOL, JAVA, SQL, and PL/SQL

Web Programming: ASP, HTML, DHTML, XML, Perl, VBScript and JavaScript

OS: MS-DOS, Windows 95, 98, 2000, NT, 7, 8 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, MI

Technical Lead

Responsibilities:

• Involved in the Review of Compare Reports and cleanup unnecessary customizations.
• Involved in gathering of Security Requirements and redesign the Roles/Permission Lists in 92
• Interacted with the Business Users and Analysts to gather new requirements and also troubleshoot existing issues.
• Performance tuning of various T&L and Payroll processes in new environment
• Involved in Retrofitting of Online customizations, SQR’s and queries.
• Created TL Groups and security for time entry at school/location level. Time Entry has been decentralized to schools.
• Involved in sending the Combination Codes from FIN to HCM
• Conducted daily and weekly meetings for work assignment and status updates
• Created Security processes to handle new hires, terminations and transfers. This process would automate the creation and maintenance of PeopleSoft and AD accounts
• Involved in the cleanup of various AUDIT reports during the upgrade.
• Involved in setting up of Integration Broker between HCM and FIN to synchronize various chart fields and account codes.
• Setting up of Approval Workflow Engine (AWE) for Time & Labor, Recruiting and Core HR
• Involved in Data Cleanup issues and also load the Org Structure Reporting for the company.
• Created custom processes to load department trees from flat files.
• Involved in setting up and publishing various Integration Broker messages between HCM and FIN

Confidential, KY

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in Creation of various custom pages for Group Time Entry to ease the time entry process for Group Leaders.
• Involved in creation of User Exit Rules in Time & Labor to calculate Comp Time based on the clients requirements.
• Created various archive templates and archive records for Data Archive.
• Involved in creation of various Time & Labor rules based on the clients requirements e.g Shift Rules, Overtime Rules etc.
• Involved in creation of various Inbound/Outbound files to third party vendors like Fidelity, Mercer and TALX
• Created a process to calculate the Years of Service for all employees based on their FTE and other clients requirements
• Involved in automation of the Dynamic Group creation for Time & Labor
• Ran the Data Archive processes to archive history data for Payroll and Time & Labor
• Involved in the Upgrade of Peopletools from .
• Involved in testing of Application Messaging between various environments like PORTAL, FINANCIALS and HR during the Tools upgrade.
• Configure, troubleshoot and Support all the tables involved in Payroll processing like Pay Calendars and processes such as Pay Sheet creation, Pay Calc, Pay Confirm, etc.
• Involved in creating a custom Leave Accrual process which works based on the employees anniversary date.
• Created Functional/technical specifications to load the General Deductions received from third party vendor.
• Created new separate Menus and Folders for all custom components. This would make it easy while performing upgrades and also while applying bundles/patches.
• Assisted the users in developing advanced Queries and Crystal reports.

Confidential, SC

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in Department Restructuring of the Organization by creating various Departments, Companies, Paygroups, Departments trees etc.
• Created New Department trees and Row Security permission lists for new stores/companies.
• Involved in Setting up of Row Level Security by creating various department trees.
• Actively involved in Testing of Bundles, Regulatory Updates and Tax Updates and migrating them to other environments from DEMO database.
• Customized PAY003 and DDP003 to print the Marketing image behind the advice and checks.
• Created the New Hires Electronic Report to be submitted for state of SC and GA to stay in compliance with the State code of laws
• Involved in the customization of EEO reports to eliminate the independent companies as per the client’s requirements.
• Involved in testing of the Tax Updates by running preparing test scripts and running various kinds of payroll.
• Created a custom process to Export the W-2 information and print using Win Filer.
• Involved in Creation of Deduction Subsets for Off Cycle processing
• Created a custom process to load earnings into Paysheets. The process first loads the interface table PSHUP TXN and then into Paysheets.
• Created a custom SQR to generate a Positive Pay File to Bank of America.
• Created a custom Time Load process which loads the Hourly Employees Time to Paysheets, the process also creates Paysheets for Inactive employees.
• Implemented the workflow and worklists for e-Profile and Manager desktop.
• Modified the Special Accumulators (Average Hours) to add missing Earn codes.
• Created custom scripts to Unsheet the Stand Alone Off cycle calendars.
• Worked on Integration Broker to automate all the FTP and SFTP File Transfers to third party vendors.
• Involved in testing of various Outbound Interfaces to third party vendors like Benefit Focus (Medical benefits) and API (401K)
• Involved in writing test scripts, unit testing, integration testing, Documentation & End-user training

Confidential, OH

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in PeopleSoft HRMS upgrade from version 8.3 to 9.0 (Peopletools )
• Ran DDDAUDIT & SYSAUDIT to check the integrity of the database and cleaned up the discrepancies and orphan objects.
• Involved in Performance tuning of various Data Conversion Application engine programs to run faster.
• Created various DMS scripts to migration the configuration changes from one environment to another, Also included these scripts as part of the upgrade template.
• Created Bolton Application to Enroll an employee into Time and Labor workgroups when hired
• Involved in retrofitting the Time Load interfaces from KRONOS, IBD and POS to PeopleSoft.
• Worked on the delivered process TL ST LOADER and customized it as per the client’s requirements.
• Worked on consolidating the redundant Workgroups and also created new application programs to reassign new workgroups to the employee population.
• Involved in retrofitting of various Time and Labor RULES customizations from 8.3 to 9.0
• Created New Template based Rules (Daily & Weekly threshold, Holiday, Exceptional etc) as per the Clients requirements
• Created workgroup enrollment matrix which assists in determining the workgroup eligibility
• Involved in creation of New Dynamic groups, Also involved in consolidating the existing Dynamic groups based on the workgroup changes
• Assisted the client to convert the existing Java programs/interfaces into PeopleSoft
• Was responsible for creating and moving projects from Development database to Test and Production.
• Defined overtime limits, tracked overtime balances and assigned overtime limits to workgroups.
• Involved in trouble shooting issues which arise due to transfer of employees from one workgroup to another during mid-period of interest calculation.
• Defined Work schedules for Biweekly, Weekly and employees working on Rotating Schedules.
• Involved in tuning of SQR’s and Application engines for better performance.
• Solved issues which arise due to elapsed time and punch time errors.
• Involved in Unit testing, Documentation & End-user training.

Confidential, NY

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in year-end processes like Tax Updates, W-2 Processing and Audit reports.
• Involved in writing Interfaces (Inbound &Outbound) using SQR’s for HR, Benefits, Payroll, Work Brain (Time & Labor to PS) and Payroll to GL.
• Created a new benefits outbound interface to send the Employees 401K information to T.Rowe Price.
• Involved in creating new HR Interfaces to send Employee information to TALX.
• Created programs to generate Mailing Labels for W-4, W-5 forms requests.
• Monitored and supported the year-end batch payroll adjustment runs.
• Modified the W-2 print file program (TAX960US) to meet client’s sorting needs and split out the print file during batch execution, 1 for inter-company distribution and 1 for US mail distribution.
• Applied the Tax Updates 07C, 07D, 07E and 07F to the DEMO database and later migrated them to Development and Test databases.
• Involved in retrofitting the lost customizations to the various SQR’s and online objects.
• Involved in testing of the Tax Update by running various kinds of payrolls.
• Involved in unit testing, integration testing, Documentation & End-user training
• Interact with business analysts & end users to gather requirements to write the technical design specifications.
• Worked with users & business analyst to fix the production issues.
• According to priority of the production issues, did the analysis and fixed the production issues.
• Applied the various EEO Patches to stay in compliance with the Federal Changes.
• Created a New EEO report to list the details of all the employees being reported to the Federal Government.
• Established Static and Dynamic workgroups and assigned employees.
• Defined Work schedules for Biweekly, Weekly and employees working on Rotating Schedules.
• Set up Time and Labor Security for Time reporters who were enrolled into Time and Labor in a phased manner.
• Used People Soft delivered Time and Labor rules and also developed and Customized Time and Labor rules which included Holiday, Weekly Threshold, Daily Threshold, Day Breaker Rules.
• Created new inbound/outbound interfaces to send the benefits information to Aetna Dental.
• Worked on the Payroll to GL Interface to deal with the new Expenses mappings.
• Involved in Debugging and resolving the GL Suspense account issues.

Confidential, PA

Sr. PeopleSoft Consultant

Responsibilities:

• Interact with business analysts & end users to gather requirements to write the technical design specifications.
• Rewrote the PeopleSoft Find Data Functionality to yield the results faster.
• Involved in performance tuning of various queries and SQR’s that take long time to run.
• Involved in implementing row level security into various delivered SQR’s to prevent unauthorized people from accessing data.
• Provided expertise on installation of Change Assistant and configuration of Environment management agents.
• Created a Detail Payroll Register to give a complete listing of employee’s current earnings and Year to date earnings.
• Involved in applying the Bundles and patches and also retrofitting the lost customizations
• Ran DDDAUDIT & SYSAUDIT to check the integrity of the database and cleaned up the discrepancies.
• Assist functional team with development of test plans and scripts, and respond to all technical issues and queries that arise during the integration testing, UAT and deployment
• Developed custom Time and Labor Queries to enable Functional users to identify specific employees.
• Manage exceptions for Time reporters and approve time by Time reporters, requesting batch approval processes, reviewing attendance history.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Generated scripts to sort the Content references in various custom folders.
• Customized delivered SQRs to generate CSV files in a readable format.
• Designed a standard Run control Pages for all the reports to fetch the data based on company, location and various other requested parameters.
• Created SQRs/Application Engines to generate outbound files containing Employee and benefits information.
• Modified existing SQR’s, SQC’s to in corporate and implement the changes. Analyzed the production problems in SQR's and implemented workable solution for SQR’s problems.
• Assist functional team with development of test plans and scripts, and respond to all technical issues and queries that arise during the integration testing, UAT and deployment

Confidential, KY

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in Upgrading of PeopleSoft HRMS from 8.0 to 8.9 for Confidential .
• Ran the SYSAUDIT, DDDAUDIT, and ALTAUDIT to clean up the orphan objects in the source database.
• Extensively used the Change Assistant to Apply Updates as well as perform Upgrades.
• Involved in retrofitting of Payroll and HR queries as per the functionality in 89.
• Modified the Record Peoplecode, Component Peoplecode etc to reflect the functionality that existed earlier.
• Ran and Reviewed the Compare reports to identify the lost customizations.
• Involved in retrofitting of lost customizations to People soft objects like Records, Pages, components etc.
• Modified existing SQR’s, SQC’s to in corporate and implement the changes.
• Analyzed the production problems in SQR's and implemented workable solution for SQR’s problems.
• Customized various Data Conversion Application engine programs to run faster.
• Debugged various Pages, Components, Application engine programs that error out during the upgrade runs.
• Identified all the custom components and added them to a new menu.
• Ran the Menu Import Process and Portal Security Sync Process to register the custom components and synchronize the security.
• Involved in Performance tuning of various SQR’s and Queries that were taking too long after the upgrade.
• Was responsible for creating and moving projects from Development database to Test and Production.
• Created Run control panels for SQR’s for scheduling them on Process Scheduler.
• Applied the Tax updates to the Demo database and later migrated to all the development databases using Change Assistant.

Confidential, Wilmington - MA

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in setting up of the Integration gateway and messaging nodes in HR and Portal.
• Involved in setting up the Application messaging to synchronize the User Profiles in HR and Portal (People Tools 8.44 and 8.46).
• Developed Interface program to load the requisition data from Lotus Notes into PeopleSoft tables.
• Involved in implementing eRecruit with resume processing to track and recruit various applicants online.
• Re-Engineered Dispositions (Applicant, Requisition and Offer) based on client Requirements.
• Customized Applicant template pages such as contact details, Current and Prior Employment, Employment Details, Education, Reference Details as per the requirement of the client.
• Involved in setting up of the security by creating new roles and permission lists.
• Involved in setting up of Single Sign on between Portal 8.8 and HR 8.8.
• Developed a custom Application engine program using Component Interface to create User Profiles in HR for all employees based on their location.
• Involved in developing batch workflow for generation of Email notifications to the data security when employees are either hired or terminated. It was developed using Application Engine.
• Developed peoplecode for auto generation of Applicant-IDs in a fixed format based on the business unit.
• Developed an interface program to synchronize the data in PeopleSoft with the information present in LDAP server.
• Generation of various reports in SQR, Crystals and PS Query.