Technical/Functional:

Professional Experience:

• 10 years of IT Experience
• 10 years of experience in Complete ERP Software Development Life Cycle SDLC in AGILE Waterfall methodologies
• 10 years of PeopleSoft Development/Programming Experience
• 10 years of SQR reporting Experience
• 6 Years of Data mapping and Conversion experience from legacy/existing systems to PeopleSoft system

Confidential

Project Description I was a member of the PeopleSoft HCM 9.1 Support team at Quest Diagnostics for HR, Payroll, Benefits, Compensation and Recruiting modules and also, I was involved in the development of Benefits related customizations for the OE Open Enrollment 2014. I was heavily involved in the performance tuning of various Talent Acquisition Manager TAM and Candidate Gateway CG components.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Modified the Top Year End Leave Accrual Process as per the client requirements.
• Heavily worked on the development CIGNA Eligibility Verification Automation SQR process for the Life and Disability elections.
• Modified several SQR Vendor Interface Programs like AETNAHMO, Horizon BCBS as per the client requirements for the new Benefit year.
• Customized pages for eBenefits to deliver Benefit Enrollment pages, Health Plan pages, Managing Insurance Plans
• Modified the Relationship/Dependent Benef codes on Update Dependent Beneficiary pages in eBenefits as part of the Open Enrollment 2014.
• Created several custom indexes on eRecruit tables and ran the AWR reports to make sure the performance is improved on the eRecruit pages.
• Developed custom messages using People Code once the External Applicant successfully logged onto the Careers component.
• Involved in adding various Content types on the Recruiting Profiles as per the client specifications.
• Worked on the performance tuning of Careers page from Candidate Gateway module. The page takes lot of time during initial loading of the component.
• Fixed several production issues by modifying the Application Package People code on Manage hires and Job Opening details link in TAM module.
• Involved in the development of Job Opening Archival process to archive 70k job opening records into Historical tables.
• Created several reports for recruiters using XML Publisher.
• Involved in the development of Health Benefits Interface to the vendor The Vitality Group using SQR.
• Developed Benefits New Life Event Change report for the user group to verify the day to day Life event changes from the Employee Self Service.
• Developed various interface programs using Application Engine and File layout for Aon-Hewitt dependent verification system by replacing the existing changes file approach to full file approach.
• Developed the outbound SQR process to send Baseline, Historical 2010-2014 and On-going files
• for HDMS Health Data and Management systems which provide Comprehensive Analytic services to the Employer in the health and welfare benefits decision life cycle.
• Customized various pages in MSS Supervisor Change request components as the per the Client's requirements.
• Developed the custom functionality for MSS Manager Self Service Terminate Employee request by creating custom records, pages, components etc., as per the client's requirements.
• Responsible for production support, involving SQR's, Application Engines, People code, PS Query.

Environment: PeopleSoft HCM 9.1, HR, Payroll, Benefits, Ben-Admin, TAM, Candidate Gateway, People Tools 8.52.07, Windows NT/LINUX, Oracle 11g

Confidential

Project Description I was a member of the Conversion/Support team at NYC MTA New York City Metropolitan Transportation Authority for HR, Payroll, T L, TAM, Pension and ELM modules and also I was involved in the development of Conversion Programmes using SQR to convert the legacy data into current HRMS modules. I was heavily involved in the development of Yearly-End Payroll PARIS, Empire FOIL reports using Application Engine.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Involved in preparing the Technical Specification documents from the Functional Specification documents for the Conversion Project.
• Involved in the development of Custom Conversion programmes using SQR to convert the Payroll CY Balances information to PY Pension Year Balances.
• Involved in the development of custom SQR Process which is run after the Pre-Calc process. The process will create the offsets for Pensionable Gross and for OT in the PS PAY OTH EARNS once they exceed the predefined limits for the Plan Year.
• Worked heavily on people code to fix the MTA-Police timesheet issues.
• Created custom components in payroll module to allow the Payroll users to inactivate the PSHUP transactions.
• Involved in setting up the run control id's and Run control parameters for the Payroll Batch jobs through 'Configure Run Control Update' utility.
• Involved in the development of NYCERS inquiry and detail components for the NYCERS third party Pension system to search for both historical and current payroll and time and labor information for some of the agencies like NY Transit and MABSTOA.
• Created Custom views by using DB Links to fetch the data from legacy systems.
• Fixed several issues on the NY Exam and NY Exam Facility components from TAM module.
• Customized eRecruit pages by adding new fields like Action, Action Reason, Salary Plan, Salary Grade, Step, Pay Location, and Probation Date to Job Offer page and also added these fields as read-only fields on Prepare for Hire and Manage Hires Details pages as part of the business changes required by the users.
• Retrofitted the eProfile Pages 'Employee Information', 'Compensation History' to match the business requirements.
• Involved in the development of Year-End Payroll PARIS, Empire FOIL reports using Application Engine and File Layout.
• Developed the Applicant Flow report for 2012 for different agencies like NY Transit, LIRR etc., using SQR.
• Created ad-hoc queries using PS Query to check the missing pay checks in ePay once the payroll process is completed.
• Involved in modifying the Delivered application engine LM TA PRCSS to load the Training Admin data into the ELM side.
• Converting existing SQR reports to XML Publisher reports to enhance the reports look and feel with pictorial charts and excel formulas for Corporate Management.
• Developed several ad-hoc queries using PS Query to fetch the old union code, position data vs new union code and position data when employees move from one agency to another agency.
• Developed Annual Pension reports for MTAHQ, MTA Bus, Long Island Rail Road LIRR , Metro- North MNR , MabsToA etc., using SQR reporting tool based on the Functional Specifications from the Users.
• Worked heavily on day to day production issues and involved in the migration of objects to production environment through the version control tool PHIRE.

Environment: PeopleSoft HCM 9.0, HR, Payroll, Pension, Time and Labor, Kronos, ELM, TAM, eCompensation, People Tools 8.49.20, Windows NT/LINUX, Oracle 11g, PHIRE

Confidential

Project Description I was the only member of the Conversion team at Wakefern Food Corp for ELM module. I was involved in the conversion of Legacy system Ronetco data into Wakefern ELM 9.0 system. I was heavily involved in developing the Application Engine programmes and setup of the Integration Broker tool.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Involved in preparing the Technical Specification documents from the Functional Specification documents for the Conversion Project.
• Involved in loading the HR data from the legacy system to the ELM side using Integration Broker and Application engine.
• Involved in bringing over the Legacy system HR data into the ELM side by using the Full sync messages, some of the messages that were used are Person Basic Sync, Workforce Sync, Person Basic Fullsync and Workforce Fullsync.
• Involved in fixing the issues in company sync, jobcode sync and position sync.
• Customized the delivered page 'Activity Roster Enrollment Status page' as per the client's requirements like displaying the Hire date to determine the seniority when necessary and the Approving Manager details.
• Involved in modifying the AE program LM ACT RMNDR to print the facility for a class in the text of the Activity Reminder Notification.
• Extensively worked on Change Assistant tool to apply the Bundles 17-23 to the ELM database.

After the go-live dates, worked on creating several SQL scripts to fix the conversion related data issues and also on the Production issues.

Environment: PeopleSoft HCM 9.0, HR, ELM, People Tools 8.49.18, Windows NT/AIX64, DB2 9.5, Mainframe OS/390

Confidential

Project Description I was a member of the support team at MBUSA for Payroll and T L modules and also I was involved in the development of a custom project Simplex-People soft Time Attendance Project. Simplex system is the third-party system used to capture the Punch-in and Punch-out time for the Employee badges. I was heavily involved in developing reports/processes using SQR and Third party-Interfaces using Application Engine tool.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Involved in preparing the Technical Specification documents from the Functional Specification documents for the Simplex-People soft Time Attendance Project.
• Developed the Outbound Application Engine programme to send the daily active employee badge information to the Simplex System.
• Developed the Inbound Application Engine programme using the File-layout to load the elapsed time .CSV file from Simplex system
• Developed the new SQR process, Simplex compare process to load the exceptions into the custom tables we created for this project. An exception is created if there is a difference between the elapsed time from the simplex system and the payable time from people soft beyond the tolerance level set by the payroll team.
• Developed the Application engine program to send-out the emails to the respective Time approvers if there are any exceptions from the Simplex compare process.
• Developed new Outbound Application Engine programme to send the Leave Balances Personal, Vacation and Sick balances for the Exempt, Non-Exempt and Part-time employees from the MBUSA Customer Care department. Created custom views on PS LEAVE ACCRUAL table to pull the leave balances.

• Developed Recurrences and assigned them to various Process Scheduler programs to automate them as per the client request.

• Created online Portal Registry Structures, Content References for the newly created or modified pages, processes as per the requirements of version 8.49 people tools.
• Created Roles, Permission Lists and User Profiles as part of Security and assigned different roles to various users based on the pre-determined guidelines.
• Resolve and report Benefits deduction related issue and help payroll fixing that.
• Create and execute test scripts in the String Test environment TST environment and User Acceptance Test environment UAT environment for quality check that Benefit Administration and HR customizations are precise and running properly.
• Coordinated with Developers, Users and Testing Team in successfully implementing the business requirements and customizations into PeopleSoft Application. Created Test Scripts and Test Results in all the testing phases from Unit Testing through System Testing. Built test data in the database via PeopleSoft pages/panels to test different test scenarios.
• Involved in performance tuning of People soft Time Administration process.
• Worked on various ADP interfaces like ADP check print process etc., to accommodate the proposed customizations from the client.
• Customized pages for ePay to deliver Paycheck information, Direct Deposit information, W4 online
• Designed Developed several complex reports using Application Engines and XML Publisher.
• Involved in Requirements gathering interacting with Business Users, Demonstrating the PeopleSoft XML Publisher capabilities.
• Modified an SQR report to extract the data from Payroll/Benefits information to send HIPAA and COBRA letters to the associates and their dependents when they lose benefit coverages.
• Applied the ADP Tax-updates for the 3rd and 4th quarters to the people soft system.
• Created various SQR reports for Simplex Audit Project like No Swipe Exceptions Report, Exceptions Not Approved Report and Exceptions By Period Report.
• Provided the 24/7 payroll TL support to the multiple Daimler business units like Daimler Buses DBNA , Daimler Trucks DTNA , MBUSI and MBUSA.

Environment: PeopleSoft HCM 9.0, HR, Benefits, NA Payroll and Time Labor, People Tools 8.49, Windows NT/AIX64, DB2 9.5

Confidential

Project Description - ERS is one of the agencies of State of Texas which will deal with the retirement benefits of all the state employees. Being a member of ERS development team I was responsible for development of different customizations proposed by the Legislative.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Involved in preparing Business Requirement Documents and Functional Specification documents.
• Developed Application Engine programs in HR, Benefits, Pension and Payroll modules for various external agencies for health, dental and savings bond deductions. Coordinated with interface vendors in conducting user testing, fixing the issues addressed by them from time to time.
• Worked on different reports related to Death PLSO letters which are based on the custom built templates.
• Worked extensively on peoplecode, Application Engines and Application packages.
• Worked on various production tickets in Pension module.
• Worked on people tools like workflow to incorporate the new business rules into the system.
• Developed number of new SQR reports like 'Members Contribution and Pensionable earnings Audit Report over a period of two consecutive months. Customized some of the delivered ones as per the client requirement. Also created PS Queries to be used by HR/Benefits/Payroll key users for reporting and testing purposes and also enabled security by adding them to Query Access Manager.
• Designed and developed several SQR reports to compare the percentage variance in the LECOS contribution amounts between two successive months.

Environment: PeopleSoft HCM 8.8, HR, Benefits, Ben-Admin, Time Labor and Pension Administration, People Tools 8.49, Windows NT/LINUX, Oracle 11g

Confidential

Project Description I was a member of the support team at A F for multi-national implementation of Absence Management and Time Attendance modules. I was involved in the Complete Software Development Cycle SDLC using AGILE methodology.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Experience of Lean Agile SDLC with scrums, extreme programming, feature driven development continuous Integration in behaviour driven pair programming environment for 15 days sprint.
• Designed and developed several XML Publisher reports using Query and Rowset based data sources.
• Designed and developed custom Report repository to store the user generated XML publisher reports and effectively maintain history of multiple versions of the reports.
• Developed an Application Engine to send daily event reports as email attachments to the respective store managers using XML Publisher.
• Experience in performance tuning of various SQLs and Application Engines.
• Involved in unit testing and manual testing of Application.
• Involved in preparation of System Test Plans and uploaded to HP Quality Center for testing the customized SQRs and Application Engines.
• Prepared Integration Test Scripts. Performed Integration testing to verify data flow through various modules of the custom application for various scenarios.

Environment: PeopleSoft HCM 8.9, HR, T L, Time Attendance and Absence Management, People Tools 8.47, Windows NT/LINUX, Oracle 11g

Confidential

Project Description: This project involved the implementation of Absence Management and HR modules in PeopleSoft HCM 8.8 and Customization of PeopleSoft HCM 9.1 applications.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• Interacted with the business users to prepare the functional and technical specifications for the implementation of Absence management module by replacing the existing application.
• Created new custom records to store the absence information when the user report for an absence.
• Created new custom pages related to FMLA eligibility processing and STD processing.
• Developed various components to determine the user's eligibility for Admin Review and PA Review once the absence is denied.
• Worked on workflow technology based on the eligibility rules for approval and denial of absence letters.
• Created Payroll Workflow notifications which are triggered for an employee going on leave of absence or being suspended.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to PeopleSoft tables.
• Modified/fixed the current BENADMIN process to actually run the customized SQRs which updates the reporting records PS BEN PLAN DATA and PS BEN PER DATA.
• Worked heavily on People code, Component Interfaces and made changes according to the Client Requirements on Payroll, Benefits, T L and Absence management modules.
• Involved in loading the training history data from the HR side into the ELM side using Integration Broker and Application engine.
• Involved in setting up the Integration broker between the different environments and making sure the connection is established.
• Created audit triggers using PL/SQL for the HRMS tables.
• Identified test scenarios and prepared test data for unit and systems integration testing. Executed test scenarios in different test environments.

Environment: PeopleSoft HCM 8.8/9.1, HR, Payroll, Benefits, Ben-Admin, T L, ELM and Absence Management, People Tools 8.49/8.50, Windows NT/LINUX, Oracle 11g

Confidential

Project Description CDAS Project - FedEx Ground is a shipping company headquartered in Moon Township, Pennsylvania, a suburb of Pittsburgh. FedEx Ground now provides 1-5 day delivery of small packages to all 50 states, plus Canada and Puerto Rico.

Role: Sr. PeopleSoft HCM Techno-Functional Consultant

Performed the following tasks:

• FedEx Ground's PeopleSoft system is based on CDAS to maintain the Contractors and Drivers related processing and database information. CDAS is a custom bolt on application based on PeopleSoft 8.8 HCM.

• Played multiple roles starting from defining the PeopleSoft development scope to requirements gathering to writing technical Specifications to doing the development to testing thru documentation.
• Interacted with the Business Users very often to understand their requirements and the applications/programs affected and to see if Help Tickets were necessary of if a permanent fix is the solution.
• Modified Custom Application Engine Programs related to Driver/Agency data, Service Areas.
• Involved in implementation of custom module from the scratch by gathering the functional and technical requirements from the business users.
• Created various new Component Interfaces to load external data into the system and worked extensively on EXCEL to CI utility.
• Designed and developed several XML Publisher reports for contract driver's addendums.
• Worked on several Ad-hoc queries utilizing the PeopleSoft Query tool for the Paralegal as well as the Legal Departments on various occasions to fetch the Contractors and their Work Areas/ Terminals Department ID's combination data.

Environment: PeopleSoft HCM 8.8, Global HR, People Tools 8.48, Windows NT/UNIX, Oracle 10g

Confidential

Project Description Conversion and Integration of PeopleSoft HRMS 8.9. I was member of the development team at Mellon Bank, Pittsburgh for the merger project of Bank of New York and Mellon Bank. I was involved in the HR Systems Integration Project between the Legacy BNY and Mellon systems right from working on the Technical specifications to developing them to testing them across Development, QA, and UAT environments I was involved in the GL integration and Gap remediation tasks.

Role: PeopleSoft Conversion Specialist

Performed the following tasks:

• Worked on various GL interfaces for the merger project.
• I began working on the Gap Remediation track during the initial phase of the project which mainly consisted of working on the Technical Specifications and the corresponding development after receiving the Functional Specifications which were termed FRS's from the BNY side.
• Primarily, Gap remediation involved modifying several Mellon-Customized programs like SQR's, App engines and several online components to include the BNY data/functionality.
• Worked on Application Engine programs related to Wachovia 401K loans and payoffs as part of integration
• Involved in the performance tuning of various SQR interfaces.
• Developed people code to hide/unhide distribution information link on Genl deduction pages based on certain deduction codes.
• Customized the eRecruit screens to hide/unhide the related fields based on the options entered by the end user.
• Involved in creating the functional document for Candidate experience when they apply for jobs in eRecruit module.
• Involved in the set up of Job Opening approval process as per the business team requirement and involved in the customization of delivered process in version 8.9 as per the client requirement.
• Created/Customized Welcome Career pages for Internal/External Applicants and created new custom Text Catalogs to provide appropriate information on Job Opening/Career pages
• Worked on various critical issues on third party interfaces as well as AE programs.
• After development phase, I was involved in successful migration of programs through Change Control tool called Harvest Fusion to QA as well as UAT environments. Also, thoroughly took part in QA/UAT testing of the programs.

Environment: PeopleSoft v 8.9 HCM HR, Payroll, Base Benefits, Time and Labor, Absence Management, eRecruit, People Tools 8.48, Oracle 9i, Windows NT, UNIX .

Confidential

Project Description I was a member of Conversion and Production support and maintenance team of Supervalu's HRMS 8.8 team and involved in migrating custom objects to production environment and solving production support and Maintenance issues. I was heavily involved in the development of conversion programs between Albertson's and Supervalu.

Role: PeopleSoft Technical Consultant

Performed the following tasks:

• Worked on NA payroll issues, which are caused by the customized processes and supported Payroll team to run the weekly payroll on Mondays and Tuesdays.
• Involved in correcting the duplicate VLM time entry files which come from different stores that should be loaded into the PeopleSoft system.
• Worked as Payroll On call support and acted key role by participating in bridge calls with Business users, Functional Engineers and Admin team to resolve payroll issues.
• Developed an interface to load employee's demographic data for the entire population and the payroll information for the part time employees between payroll tower and SVU subsystem.
• Added internal links on the Manager Self service page to redirect the manager to the customized links as per the functional requirement.
• Customize people code to pre populate data on the manager self service page, and display only date to ensure that managers do not attempt to perform actions on employees who didn't report to them at a particular time on the MSS pages.
• Involved in 2007 Open-Enrollment OE08 page customizations and validations for Employee Self-Service module.
• Added people code to provide the option of running either the Personnel Transaction Report or the Dependant Coverage Report or both on a weekly basis.
• Developed an application engine program to terminate the coverage for overage dependents.
• Extensively used STAT Tool to lock the objects while making changes to the necessary objects for better Version Control.
• Co-coordinating with On-site SME's and Business Users to gather task requirements and update the status on daily basis from Off-shore.
• Developed new SQR process from scratch which sends the data to TALX to enable vendor to perform: employment verification, social services verification .

Environment: PeopleSoft v 8.8 HCM HR, Benefits, Ben Admin, Payroll, Self service modules ePay, eProfile , Manager Self Service, People Tools 8.45/ 8.47, Oracle 10G, Windows NT, UNIX .

Confidential

Project Description: Upgrade of PeopleSoft 7.5/8.0 HR, Benefits, Payroll . This project involved the Application upgrade to PeopleSoft 8.0 from HRMS 7.5. Primary duties involved were customization of PeopleSoft HRMS applications.

Role :PeopleSoft HRMS Consultant

Performed the following tasks:

• As a part of the Functional requirement, involved in the analysis of the Fit/Gaps in the PeopleSoft HRMS modules 8.0 regarding the customizations, to further proceed with the upgrade.
• Involved in Upgrade of PeopleSoft HRMS from version 7.5 to 8.0 and performed impact analysis and retrofitting of internal external objects.
• Created sample production database during the Upgrade and applied Patches and Fixes on the sample database.
• Generated and reviewed Compare Reports and discussed the impact of changes with the functional and technical teams.
• Worked on Data Mapping and Conversion of employee data from Legacy systems to PeopleSoft system using SQR and App Engine programs.
• Performed Interfacing, Conversions, Data Migration and Report Writing using People Code, People Tools and SQR and involved in Report Customizations using SQR and Crystal Reports conversions to version 8.0.

Environment: PeopleSoft HRMS 7.5/8.0, People Tools 7.58/8.12, People Code, SQR, Crystal Reports, nVision, Oracle 8i, and Windows NT