Harmanjeet Singh

SUMMARY

• Over nine years of IT experience including Analysis, Design, Documentation, Development, Implementation and Testing of business application systems in ERP- PeopleSoft HCM.

• Worked as Business analyst and functional lead over 5 years in PeopleSoft HCM 8.8/8.9 module which include from requirement gathering using URD and documentation and doing fit gap analysis (current and future state) , functional specification document (FSD) and business process flow and charts.

• Also involved in creating test scripts and test cases for various project and executing these scenarios under testing tool application for Quality assurance.

• Worked with PeopleSoft – HCM (Core HRMS)8.12/8.42, 8.8/8.9 and 9.0-HR, Base benefits, Benefit Administration, vendor Profile, deductions, calculation rules and North American payroll & its interface(s), e-app (e-compensation, e-recruit, e-pay, e-development, e-performance, e-benefits and e-profile), Manager self service and employee self service, e-performance, Global assignments, Career path and Succession planning, ELM (Enterprise learning Management), Absence Management, Configuration Maintenance, PS security, CRM (customer relation management), ATS: TAM (Talent acquisition manager) and Taleo and Time and Labor. Also worked on PeopleSoft 8.8 Financial - Project costing, integration of PeopleSoft projects with Microsoft projects and RPO reports. Experience on PeopleSoft EPM.

• Experienced in People Tools (Application Designer, Import Manger, Data Mover, People Code, Security Administrator, Object Security, Maintain Security, SQR, PS/Query and Crystal Reports, Process Scheduler, Application Messaging, Utilities, Application Engine and Upgrade Assistant).

• Experience in designing databases and client-server architectures and expertise in PL/SQL and SQL*Plus. Performance Tuning and PeopleSoft Debugging. Experience in developing test cases and test scripts.

EDUCATION

Bachelors in Computer Science, India and PeopleSoft certified professional.

SKILLS

Languages People Code, PL/SQL, SQR and C

ERP Package PeopleSoft, Taleo.

Modules HRMS 8.12/8.42,8.8/8.9 and 9.0 (Core HR, Payroll, Base Benefits, Benefit Administration, Pension Administration and foundation Tables, Time & Labor, Talent Acquisition Manager, Financial 8.8 (GL, GM, AP, AR, Billing, PC, AM, CA, Security).

Tools Application Designer, Process Scheduler, Application Engine, SQR, PeopleCode, Import Manager, Data Mover

Database MS SQL, Oracle8.0.

Operating Systems Windows 98/NT and UNIX

Testing tools QTP, QA loader and TEST director, Mercury, RUP test.

Reporting tools Crystal reports, Business objects, nVision, PS Query and Cognos.

Methodologies Clear case, IPAT

Microsoft: Project, Visio, Excel.

EXPERIENCE

Sep 2009 – Jan 2010 PeopleSoft functional consultant, HHC, New York City Health and Hospitals Corp.

The project has responsibilities for roll-out for earlier deployment and implementation of new deployment for health hospital facilities. PeopleSoft core HR, benefits, training and competencies implementation was main objective. My responsibilities include functional design, conversion cut over plan, data mapping, configuring job competencies and other functional roles. Below are the details of my work plan.

• Running the reconciliation report for core HR, benefits, ELM and profile management (E-performance) modules to help client look-up their data.

• Validating the benefit plans and family coverage and dependent information from their HR files and cross-validation with vendors for billing purposes.

• Worked with presentation of conversion and error reports to help users correct the data on their old system and minimize the errors during cutover.

• Created functional spec for e-performance and manager dashboard and how documents created for period for group 11 and 12 employees and approval process for evaluation through reviewer and HR admin before updating the person profile.

• Created functional spec on keeping the person profile and non-person profile in sync using batch process. The job specific, core competency and licensure were automatically updated for employees based on their job profiles.

• Created functional spec on training (ELM module) to keep their training completion and EIP to update their profiles once training is completed.

• Help user validate the courses available under each activities and how they are tied to each role during initial training roster for HR. Also help configuring the learner group based on their job and departments.

• Stage the data for opening the job opening using VCB new approved position and tying applicants (Internal Vs External) to opening and going through the interview process, routing the resume to hiring manager through making offer and acceptance of offer until hiring employee in the PeopleSoft core HR application.

Environment: PeopleSoft HRMS 9.0 (HR, North American payroll, Base Benefit, benefit Administration, Manager and Employee self service, Profile Management, e-performance, e-profile, e-development, ELM (Enterprise Learning Management), TAM (Talent acquisition management), Candidate Gateway.

Jun 2009 – Aug 2009 PeopleSoft Functional consultant, City University of New York (Oracle consultant), NYC, New York

Worked as functional consultant in PeopleSoft HCM, Talent Acquisition manager, ELM and CRM module. My responsibilities include understanding the CUNY process and troubleshooting the day-to-day issues that users are encountering. My responsibilities also include training and helping users get along with new product and also understand the functionality of the new system.

• Worked on helping users create new positions for Appointments and reappointments for faculty and college assistant and adjuncts for following semester.

• Worked on helping creating job templates for various jobs posed on the internal and external career site using TAM Gateway.

• Worked on laying out business process for faculty members sharing the same position when one of instructor is on LOA while other is replacement for permanent position.

• Worked on designing the workflow for position request from department chair and escalation to HR department and having it approved from Budget. The system was designed flexible to add approver ad-hoc to fit in the requestor needs.

• Worked on gathering requirements on ESS and MSS modules and designing the business process for clients to request a requisition for open position, compensation, promotion and transfer of direct reports.

• Worked on helping users work on the CRM tool to add new ticket, open exiting tickets, include customer information and interested party information for communicating the status of the case.

• Also worked on ELM module to have the courses listed for a department manager and update the status so that the courses could be completed and notifications are sent out.

• Worked on workflow notification for position request and position change request on title change and department change.

• Worked on fellowship leave of absence and %leave and also on 211 waiver calculation.

• Helped client understand the department chair position management and how to implement in PeopleSoft.

• Worked on classified and faculty staff classification and step increment process.

Environment: PeopleSoft HRMS 9.0 (HR, Base Benefit, Manager and Employee self service, Profile Management, ELM (Enterprise Learning Management), Talent Acquisition management, Position Management, CRM (Customer relation Management), ESS, MSS and configuration maintenance.

Feb 2009 - May 2009 PeopleSoft Functional Consultant, PriceWaterHouseCooper, Tampa, FL

Worked as an architect on Succession planning module with PeopleSoft HCM 8.9 environment. My responsibilities include understanding the requirements and identify the gaps based on the PeopleSoft delivered functionality and document the use cases and functional specification for each change as per the client needs. Worked on couple of different projects- Partner rotation project and Succession planning for internal purposes.

• Worked on partner rotation project which is the system built to track the assignments of the partner at different clients.

• Responsibilities include understanding the business rules setup for a partner to be assigned to an assignment and rotation dates. This was further included with desired actions to the users based of the role and status changes as per the each actions.

• Notification and workflow document to design who would receive notification based on each actions.

• Clients and Roles for each client were designed to keep track of the client and their related information.

• Worked on succession planning module to include capabilities to user to search employees based on their capabilities (competency), Accomplishments, training program, evaluations and aspirations.

• Worked on creating roles, job tasks using position numbers and also partner profile. These job roles and partner profiles were associated with capabilities and accomplishment so that leaders could match on these attributes.

• Helped on designing the custom search pages and give the users the capabilities based on the match to identify the successor on near term, long term, current and previous job holder categories.

• Also worked on the defining the development of the partners (employees) based on the current and future job roles they are defining on their career paths.

• Worked on building PS queries and security for users on ad-hoc reports.

• Worked on the interface with PeopleSoft ELM on career training program attributes with PS Succession planning as one of the capabilities/competencies associated with person profile.

Environment: PeopleSoft HRMS 8.9/9.0 (HR, Base Benefit, Manager and Employee self service, Profile Management, succession planning and career management), Global assignment, Stock Administration and Variable compensation, ELM (Enterprise Learning Management) and configuration maintenance.

Nov 2008 – Jan 2009 PeopleSoft Functional Consultant, NetApp, Sunnyvale, CA

Worked as a business analyst/Functional consultant in the PeopleSoft HR, manager and employee self service, stock Admin, benefit admin and compensation modules. Role include taking requirements from the business users on Manager and Employee self service application and converting them to requirement traceability matrix. Also worked as a functional consultant on identifying Peoplesoft gaps and solutions that would be built on the different modules to deliver the self service functionality. Below is the list of activities delivered.

• Worked gathering requirements on personal profile section of the employee self service application where employee can be able to update their personal information – Name, Email and phone numbers and emergency contact.

• Also gather requirement around manager self service functionality like manager view setup, change/termination process setup, print/download/save functionality of the forms.

• Helped the clients build the work flow matrix which identifies the groups or person receiving notification during approval process. PeopleSoft roles where used while identifying the person during approval chain. Functionality was added were managers or HRBP can approve or reject the request through emails.

• Worked on Global setup of the manager and employee self service based on the jobcodes, salary plan admin and grade for various countries. These also include their payroll currently setup and pre retirement or termination reimbursement criteria.

• Also built in the Admin desktop for the HR admin to query the database on error reports so that necessary actions can be taken. Admin could also maintain approval matrix or cancel the notification process.

• All of these requirements where entered in the matrix called as requirement traceability matrix which was built using modular approach and for identifying solutions for each requirements.

• Worked from a functional perspective on identifying the PeopleSoft gaps and providing solution to the module which would render the self service functionality.

• Worked on delivering new functionality to the PeopleSoft HR system from where the HRBP could be maintained by HR community. This requirement was for both US and global regions.

• Also gave solution for Peoplesoft stock admin where the share granted (RSU and NQ) where required to be maintained on a yearly basis based on the vesting schedule. The calculation logic was also derived online using strike price and estimated stock price at that point of time.

• Worked on variable compensation within the stock admin module for the benefit pay out on an annual basis.

• Worked on deriving the peoplesoft jobcode based on the commission and the Non-commission jobs and how the managers can pull up the information on the job search page for the self service application.

Environment: PeopleSoft HRMS 9.0 (HR, Base Benefit, Manager and Employee self service, Profile Management, e-benefits, e-pay, workforce administer module, North American payroll), Global assignment, Time and Labor, Stock Administration and Variable compensation.

Jun 2008 – Oct 2008 PeopleSoft Functional Consultant, Oracle (SDLC), Fort

Myers, FL

Worked as a principal functional consultant in PeopleSoft core HR, Base benefits, Commitment Accounting and Profile management for the school district of Lee county (SDLC). Responsibilities include taking requirement, creating gap, writing up functional spec, creating test cases and scripts and unit testing of the changes to make sure changes and customization work accordingly. Below are highlights of some of the work done in these areas.

• Worked on creating the detail specification for the additional jobs of the teachers reported in the file per the FLDOE (Florida department of education) requirements.

• Helped in taking requirements for the clients to build a process in PeopleSoft so that the special DOE job codes can be maintained in the system. These job codes has to be built-in the system so that they can be reported out to the education department.

• Worked on a functional spec on creating the custom report for the teachers union employees based on their job group, certifications and location.

• Worked on developing an interface program in the system where the employee’s HR demographic information was sent over to AP (Account payable).

• Worked on building a custom program which would synchronize the date on the Benefit enrollment tables in PeopleSoft.

• Worked on developing a program which would generate notification for the COBRA eligible employees on their new election or any change of the event.

• Also worked on the cross validation process in PeopleSoft benefit module and helped the client making modifying it slightly to work as per their needs. The changes were made to disallow employees take the STD disability plan type without taking the LTD plan and vice versa.

• Worked on writing up the spec for generating an interface program to send the billing data from the PeopleSoft database for all employees and send it over to TSA companies.

• Also worked on designing a Medicare data match process which would automate the process of sending the Medicare data to the federal agency so that, primary plan for a subscriber could be identified.

• Worked on unit testing the position budget table dependency on the commitment accounting department setup table.

Environment: PeopleSoft HRMS 9.0 (HR, Base Benefit, Benefit Administration, e-benefits, COBRA, Profile Management, workforce administer module, Time and Labor, North American payroll), Absence Management, Position Management and Commitment Accounting.

Dec 2007 –May 2008 PeopleSoft Functional lead consultant, Raymond James, Tampa, FL

Worked as a business analyst in PeopleSoft application and Taleo applicant tracking system. Responsibilities include documentation on the current, future process, workflows, fit-gap analysis and being a liaison between the business operations and the IT department. Job duties include configure the Taleo (Applicant tracking system) application with on-boarding, candidate, career site, metrics and forms, smart org, requisition data and integration with PeopleSoft system.

• Worked in creating a PID (Project initiation document), current and future HR process and business process flow for the entire HR department.

• Worked in designing the applicant tracking process and its fit-gap analysis based on the information received from HR generalist and partner groups.

• Worked with configuration of Taleo enterprise edition 7.5 (applicant tracking system) and integration with Peoplesoft position management. Role includes taking requirements around the new hire import process and eventually getting entered into PeopleSoft

• Worked with the organization to automate the ESU form (Employee status update) using the Microsoft InfoPath application and getting integrated with PeopleSoft core HR data.

• Helped team creating the test scripts for each module as per the template and then having it uploaded on the mercury product for execution.

• Worked on supporting e-performance project (integrated with NA Payroll and HR core) where managers can upload the documents under each direct reports and report goals and reviews.

• Also worked as a team lead on execution of these test scripts and generating reports for quality assurance to make sure we are clean from system, Integration defects.

• Worked developing project plan, milestone and requirement document for Peoplesoft benefit administration open enrollment process and it various vendor interfaces project.

• Helped taking requirements from various medical, Vision, and dental benefit under new plans for the open enrollment for year 2008 and pass it on to our IT department for necessary enhancements. These benefits were enrolled via e-benefit applications.

• Help with taking requirement and laying out the PeopleSoft HR 8.3 application security policies and procedures.

•

Environment: Peoplesoft HRMS 8.42, 8.8/8.9 (HR, Base Benefit, Benefit Administration, COBRA, Manager self service and Employee self service, workforce administer module, North American payroll), Talent Acquisition Manager, Taleo ATS 7.5

02/05 – 11/07 Functional lead/ Business analyst, Pfizer Inc, St Louis, MO

Worked as a business analyst and functional expertise primarily on HR, Benefit and Payroll module (8.9 and 9.0). My role includes requirement gathering, fit-gap analysis, functional doc, project plan and liaison between business operations and technical developers. Below are snapshot of some of the projects worked so far:

• Worked as a project lead to setup automated FAX system to send over Peoplesoft new hire information to NY state department of taxation and finance which is one of federal requirements.

• Worked with sales group to gather requirements around the .sales attributes that were needed to be added on their position records. This was the customization we had to do to the delivered product in order to accommodate the requirements.

• Worked on Manager desktop enhancement project which would give managers new capabilities to choose different activities (promote, transfer, terminate and etc) under their organization structure. This would include creating a workflow process and setting up different events and members who need notifications.

• Worked on setting up global assignment record for APAC and EMEA region countries on their job and maintain their country specific attributes. For APAC we have specific contract field values populated based on PPL (Primary permission list setup) for their business units and setid.

• Also worked on global security project to define the list of roles/rules and permission list that users in different countries can view and also on the department security for a row level security.

• Also worked in setting up the “My Clients group” for the generalist to actually view their clients and do necessary action online like calculating the head counts, fulfill certain requisitions and many more.

• Worked on setting up the communication bridge with AT&T data flow team and the PeopleSoft integration team. Help in setting up exceptional handling during call flow and building test cases.

• Worked on e-pay and e-profile self service system implementation project in order to help employee view their pay checks on the online system and also pull up achieve checks. Along with this managers could also review their direct reports comp and make necessary requests through custom workflow setup.

• Implementation of Fitness Center application within the peoplesoft which hold different demographic data of the employee and various calculations based on company's protocol. Also worked with payroll to develop the interface to setup off cycle paychecks as reimbursement.

• Work on the batch loads of the reports to, department, promotions, Compensation, location and other reorganization within each division within the PeopleSoft core tables.

• EEO and AAP report changes based on clients need. Changes include new Ethnic group and EEO categories added as per employment regulation proposed by government contractor agency.

• Worked as analyze to take requirements to setup a interface with third party system with peoplesoft and formulation of the file layout where the benefit information is send over on every quarterly basis.

• Worked also as an analyst to setup the employment verification forms on the employee self service desktop and also an interface to 3rd party to store the sensitive information related to personal data and Payroll information.

• Worked on setting up an FTP process to transmit the zip codes data from USPS in a CD form over to peoplesoft data.

• Enhancement work for disability management system which had been implemented on Peoplesoft application and had various calculations based on module and eligibility criteria. Also worked with warehouse team to develop some ad-hoc and canned report in Cognos and Impromptu application.

• Worked on PeopleSoft EPM to generate some of the required manager activity based reporting on employee and department level.

• Also was actively involved in supporting HRsource center with various changes and Peoplesoft system enhancement.

• Worked on PeopleSoft CRM module to gather requirements to accommodate new changes they proposed for having a feedback from the HR users on case escalation process. This had made their life much easier by having the process automated.

Environment: Peoplesoft HRMS 8.42, 8.8/8.9 and 9.0 (HR, Base Benefit, Benefit Administration, pensions administer, ESS and MSS, E-recruit, E-comp, E-pay, E-Profile, Global Assignments, workforce administer module, North American payroll), e-performance and PeopleSoft TAM 9.0.

06/04 – 02/05 Techno Functional Analyst, YUM Brands, Louisville, KY

Worked as a Techno-Functional consultant on PeopleSoft HRMS 8.8- HR, Payroll, Time and Labor, E-benefits, PeopleSoft CRM 8.4 (Helpdesk) and PeopleSoft EPM. Worked on IBM Mainframes to run various processes.

• Help in designing the Pay calendar – Company/PG combo and off/on cycles depending on the each unit.

• Also worked on setting up the business flow map for the Payroll process and activities from the scratch (Pay Calendar) to the Paysheet after series of run.

• Setup the HR Desktop for the clients where the employee can view its personal data/paycheck/benefits etc and provide the flexibility for them to alter their elections online.

• Help in setting up the Business flow diagram for client where Employee can submit Absence/Vacation Online and needs approval from Supervisor.

• Worked on developing Pay Process Table for running the Off/On cycle payroll and creation of Run Control card.

• Worked on development of run Control cards for Pay calc, Pay Confirm, Pay Sheet and Time Admin Process.

• Was involved in Process of Data Transfer from PeopleSoft CRM to PeopleSoft HRMS using Application Messaging.

• Involved in generating Max Pay Report for all the Employees in Store and above Store level.

• Involved in creation of Union Dues Report for a Particular Brand.

• Also involved extensively on generation of fully customized process of Retro or Miscellaneous Pay for Payroll.

• Involved in Time Admin Process for generating Submit Time and Time Admin process and worked on Exceptions.

• Worked on Development of Technical And Functional Spec for Payroll And Time And Labor Processes.

• Also Worked on Data Mart on PeopleSoft EPM-HRMS Warehouse.

Environment: PeopleSoft HRMS 8.42 (HR, Base Benefit, Benefit Administration, pensions administer, time and labor and workforce administer module and North American payroll), PeopleSoft SCM-Helpdesk, PeopleSoft EPM, Windows NT, Unix, Application Designer, PIA, People Code, SQR, SQL, PS/Query, Crystal Reports 7.x, SQL*Plus 8.1.7, Oracle 8, PL/SQL, Configuration Manager, Application Messaging, Component Interface, File Layout, Object security, User security/ View, change controls and Report Repository. IBM Mainframes- JCL, DSN.

04/04 05/04 Techno functional Analyst, ADP, Louisville, KY

Worked as Technical consultant on PeopleSoft HRMS, ADP EV 3.0. ADP main idea is development of interfaces using SQRs.

• Worked on Interface of Benefit administration with NA Payroll.

• Worked with NA Payroll conversion from PeopleSoft 8.3 over to ADP application- core payroll data were converted like pay calendar, pay groups, company, tax distribution details, etc.

• Also worked on SQR to populate election and coverage tables as per clients need.

• Was involved in developing reports and audit tables for employees with Family status change (FSA).

• Worked with Interface report on confirmation/worksheet file layout.

• Also was involved in running processes in Unix OS using shell scripts.

• Involved in keying the dependents and running the validation process before generating Interface.

• Worked on Interface for retiree employee letter.

• Also worked on QMSCO flag report ,indicating the termination period of employees from the benefits.

Environment: PeopleSoft HRMS 8.42 (HR, Base Benefit, Benefit Administration, pensions administer, North American payroll), Windows NT, Unix, Application Designer, PIA, PeopleCode, SQR, SQL, PS/Query..

09/02 03/04 Techno-Functional Consultant, Capital One, Richmond, VA

Project included Implementation development and production support of PeopleSoft HRMS 8.12 application Base Benefit, Benefit Administration And Payroll Interface.

• Worked as Techno-functional consultant on this client from designing the application modules to its development.

• Worked on setting up the HRMS core tables- Business Unit, Permission list, Country, Jobcode, Department, Location etc.

• Also helped in setting up employee Tables based on each units.

• Also participated on setting up the record group Setid and Tablesets based on units defined.

• Worked on developing Functional design document for custom reports (Adhoc) based on client needs- Payroll deduction reports, Employee Classification reports etc.

• Setup the meeting with users to gather requirements for HR/Payroll modules for example, help in determining the pay-end-dates for off/on cycles on the calendar and running the test on UAT environment for approvals.

• Setup the reports on the Unix directory and schedule it to run based on needs through Process scheduler.

• Worked on customizations on PeopleSoft delivered reports - SQR and crystal.

• Created and worked on Customization of fields, menu, view, pages and Component as per requirement.

Environment: PeopleSoft HRMS 8.42 (HR, Base Benefit, Benefit Administration, pensions administer, time and labor and workforce administer module), Windows NT, Unix, Application Designer, PIA, PeopleCode, SQR, SQL, PS/Query, Crystal Reports 7.x, SQL*Plus 8.1.7, Oracle 8, PL/SQL, Configuration Manager, Object security, User security/ View, Change controls and Report Repository.

Contact this candidate