SUMMARY:

• Over 8+ years of IT experience working as a PeopleSoft Techno - Functional Analyst in HRMS(HCM) applications on various OS/Database environments.
• Excellent knowledge of the new PeopleSoft 9.1 version regarding the enhancements from the previous versions.
• Experienced in following software development life cycle (SDLC) procedures for building PeopleSoft Applications in Retail, Financial Services, Manufacturing and Utilities industries.
• Strong functional & business experience in PeopleSoft HCM (HR, Benefits, Ben. Admin., Payroll, Time & Labor, TAM and e-Modules (Self service).Knowledge of Payroll-GL Integration.
• Involved in data mapping, Conversion, Implementation, Customization, Upgrade and Production Support of PeopleSoft HRMS applications.
• Experienced in applying Maintenance Packs, Patches, Bundles and Tax Updates.
• Highly skilled in developing Conversions, Interfaces, Processes and Reports using People Tools, People Code, SQR, CI, Integration Broker and Application Engine programs.
• Thorough understanding of PeopleSoft Security Administration involving Roles, permission list and user Profiles.
• Technically proficient in using People Tools, Crystal Reports, PS-Query, Data Mover, Process scheduler, Upgrade Assistant/Change Assistant and PeopleSoft Integration Tools (Application Messaging, Component Interfaces.).
• Extensive experience in Oracle, PL/SQL, SQL Server Performance Tuning.
• Excellent technical, analytical, presentation, communication and leadership skills.
• Strong team player. Excellent communication skills and ability to interact with Business users, Functional and Technical, to meet the project deadlines.

SKILL:

ERP: PeopleSoft HRMS 9.1/9.0/8.9/8.8/8.3/8.0/7.5.

Functional Modules: HR, Benefits,: Benefits Administration (Ben. Admin.), Payroll, Time and Labor(T&L), eBenefits, eRecruit, Talent Acquisition Management(TAM) .

People Tools: People Tools 8.51/8.49/8.48/8.47/8.45/8.44/8.43/8.16/8.1/7.5 (Application Designer, Application Engine, PeopleSoft Internet Architecture (PIA), Process Scheduler, Data Mover, PS-Query, Integration Broker/Tools, Component Interface.

GUI/Web/Design/Testing Tools: Crystal Reports 9.0/8.0, Forms, Reports, SQR, MS Project, TOAD, SQL*PLUS, Excel Macros.

Languages: PeopleCode:, SQR, SQL, PL/SQL, C, HTML, Java, JavaScript, VBScript, ASP.

Databases: Oracle, DB2, SQL Server and MS: Access.

OS: Windows 95/NT/200/XP, UNIX, Linux .

EXPERIENCE:

Confidential, Fremont, CA

PeopleSoft Techno/Functional Consultant

Environment: PeopleSoft-HCM9.1/BaseBenefits/TL/MSS/E-Perf./ESS/MSS/ELM/IB/Absence Mgmt, People Tools 8.51, Oracle 11g.

Responsibilities:

• Involved in Development, Integration and maintenance of PeopleSoft HR and Oracle Finance e-business suite.
• Made Setup and Configuration changes to workflow routing rules addressing new business elements.
• Designed and developed Conversion programs bringing existing data and mapping corresponding values to new elements.
• Involved in the development of inbound interface to hire from third party input file.
• Made changes to the existing reports and performed testing to accommodate new setup items.
• Developed various reports using SQR, Application Engine, Xml publisher etc tools
• Developed inbound and outbound interfaces from PeopleSoft ELM to third party training vendors.
• Developed various customizations, as per clients needs, for E-Performance Pages, templates and reports.
• Customized Time reporting and payable time pages for T&L.
• Developed various custom Time & Labor rules.
• As part of development life cycle wrote technical documents along with a few functional documents.
• Developed new reports for variable compensation, payroll, learning management.
• Designed and developed interfaces using Component Interface (CI) for loading various compensation elements.
• Built custom components and records for organizational hierarchy and reporting purposes.
• Designed various absence management reports to capture leave of absences used for payroll, benefits calculation purposes.
• Worked on creating custom templates from the delivered TBH used by the inbound hiring process.
• Wrote and performed testing for Finance head count reports.
• Developed custom workflow components for full/part time, dept., supervisor, job data changes.
• Performed Integration to various third party systems through outbound interfaces.
• Performed integration and resolved issues for HR and CRM help desk using Integration broker.

Confidential, Nashville, TN

PeopleSoft Techno/Functional Consultant

Environment: PeopleSoft HCM 9.0/Base HR/MSS/e-Performance/Manager Desktop/e-Profile/IB, People Tools 8.49 Oracle/MS SQL Server 2008.

Responsibilities:

• Involved in Design and development of the data conversion from legacy system (AXAPTA) to PeopleSoft.
• Setup and Configure workflow for Managerial Self service (MSS) using deptid, location combination routing rules.
• Involved in the configuring and testing of workflow routing rules and route control profiles for MSS using Approval Workflow Engine(AWE).
• Designed and developed Inbound interfaces using File layouts and Component Interface (CI) addressing complex business rules.
• Developed Datamover scripts for moving Custom setup & Mapping data across the environments.
• Built scripts & processes for secured FTP to third party sites.
• Configured and setup Excel to CI for loading configuration data.
• Customized full sync. Integration Broker message for sending extra set of data elements from HR to Finance.
• Developed custom IB messages to other third party vendors.
• Designed & developed custom Compensation Tool to handle Merit & Bonus for the organization.
• Created SQR processes to generate Compensation Merit & Bonus statistics for Managers/Directors.
• Developed SQR reports for Merit Recommendation Letters.
• Developed Application Engine processes to generate Outbound files in csv & excel formats.
• Developed change file Outbound interfaces for external vendors Payforce, Kronos using audit functionality.
• Designed and developed extensive unit test cases/scenarios for Interfaces UAT.
• Developed Head count management - a bolt-on application for finance forecasting/planning.
• Developed complex custom application package PeopleCode for robust, reuse and enhance object oriented programming techniques.
• Built outbound interface to feed Hyperion data models involving complex data structure and logic for forecasting purposes.
• Involved in various customizations to job/personal data components and corresponding changes to custom component interfaces.
• Developed custom Managerial workflow for Employee pay premiums using combination routing rules.
• Modified the delivered Transfer/Promotion MSS to include Employee pay premiums for selected group of people.
• Involved in writing and executing test cases for re-platforming from oracle to sql server.
• Built a custom Application engine to process new hires into PeopleSoft with information from external recruitment vendor (Vurv).

Confidential, Virginia Beach, VA

PeopleSoft Techno/Functional Consultant

Environment: HCM 8.9, TAM, Ben Admin., Time & Labor, Integration Broker, Payroll People tools 8.47, MS SQL Server 2005, Win NT

Responsibilities:

• Involved in Applying Maintenance Packs and cleaning of audit reports.
• Analyzed Compare Reports and identified the objects to be retrofit.
• Involved in job, person data mapping and conversion from ADP to PeopleSoft.
• Developed application engine programs for converting Payroll related data from ADP to PeopleSoft using Component Interfaces.
• Performed retrofitting and enhancements of customizations as per client’s requirements
• Designed and Developed customized setup pages in e-Recruit to handle customizations.
• Modified the Integration Broker (Hire Request and Post Hire Request messages).
• Debugged the Payroll check reversal ‘PSPPYREV’ (COBOL) process and fixed the errors.
• Used Security administrator to create required operator-Ids & operator classes. Worked with security administrator to implement object security and restrict the access to a group of users.
• Designed and developed the Applications Limit number concept in TAM to restrict the number of applications based on ‘Calendar year’
• Modified the variable compensation award allocation workflow to route to only manager’s worklist
• Cusotmized the Benefit Providers EDI interface('BN 834 HIPAA') Application Engine as per client’s requirement.
• Gathered requirements and performed the Health Savings Account(HSA) setup creating new benefit plans and setting up FSA.
• Designed and developed an SQR outbound interface to HSA providers.
• Investigated and Performance tuned applications in Talent Acquisition Management (TAM)
• Worked extensively with Application package code for debugging, tracing & performance tuning sql’s in e-recruit
• Customized Payroll Tax import Sqr file(SAGE) as per third party requirements
• Created and modified the Application Packages to validate and move the applicant data from eRecruit to HR module.
• Established the connections between PeopleSoft and Third-Party systems for bi-directional data flow using PeopleSoft Component Interface Framework and PeopleSoft Application Messaging Manager.
• Designed and Developed Inbound & outbound payroll, benefits info. SQR interfaces to the third party system
• Interacted with Business Analysts and users to gather requirements.
• Designed and developed E-mail Notification functionality using PeopleCode n Job Cancellation status change in e-Recruit.
• Involved in the design and development of the run control split program for payroll calculation and confirm process in the batch schedule.
• Added row level security to SQR reports and accordingly modified the online run control pages.
• Modified benefit Admin. BAS004 and BAS005 SQR reports.
• Setup Departmental Security by creating Dept security tree to Grant/Restrict the user access.

Confidential, Piscataway, NJ

PeopleSoft Techno/Functional Consultant

Environment: HCM 8.8, Ben. Admin., People tools 8.43,Oracle 9i, Java 1.3, Weblogic 6.1, UNIX.

Responsibilities:

• Interacted with the users to gather the requirements and also prepared the technical specs.
• Designed the technical specifications for integrating PeopleSoft to the BPM (third party system).
• Customized the Manager Self Service (MSS) transactions workflow using PeopleCode and Component Interface as per the requirements.
• Designed Technical specification for customization in Recruiting, Candidate-Gateway (eRecruit) Talent Acquisition Manager for employees to submit resumes and attachments online.
• Customized the delivered components to combine Promotion with Salary Change, Demotion with Salary Change, and Job Reclassification with Salary change transactions.
• Developed custom components along with Workflow for Job Change Requests which includes Demotion, Temporary assignments, Return from Temporary Assignment, Data Change etc.
• Worked on Resume Upload process and Duplicate Applicants Merge Process.
• Created and modified the Application Packages to validate and move the applicant data from eRecruit to HR module.
• Customized the Prepare for Hire page by adding new fields and populated the new fields with the values related to the Applicant and the Job Opening ID.
• Modified the Interview Evaluation Remainder Application Engine (HRS INT EVAL).
• Developed a custom Application Engine to Inactivate the Applicant Status and to update the Status Reasons of the Terminated/Retired employees.
• Wrote an SQR Interface to populate data from the external system into PeopleSoft tables Hrs Applicant, Hrs App Address, Hrs App Email.
• Customized the PeopleCode on the Manage Applicants page and also modified the Find Job Openings page.
• Designed and developed the web services Integration points to be leveraged by the BPM.
• Developed component Interfaces to provide communication between third party and PeopleSoft.
• Developed a CI to insert an effective dated, effective sequenced job action row accepting the input parameters from the BPM.
• Developed a user defined function in CI to activate the On-Demand Event Maintenance (COBOL) process for the employee input through BPM.
• Built the java files for the CI’s through the Application Designer.
• Involved in deploying the Java API’s on the weblogic to provide the WSDL’s.
• Responsible for testing the user defined functions in CI through a test jsp page.

Confidential, Chicago, IL

PeopleSoft Technical Consultant

Environment: T&L 8.8, HR,Payroll 8.8, People tools 8.44, Oracle 9i, UNIX.

Responsibilities:

• Designed and developed a customized process (AutoEnroll) to automatically enroll employees based on eligibility setup criteria into Time and Labor workgroups through online.
• Developed a Global Application Engine Batch program(using Component Interface ) as conversion to enroll the employees into the Time and Labor workgroups.
• Designed and developed a customized Application Engine program to calculate the employee Entitlements based on the eligibility criteria in a regulatory region.
• Involved in design, development and testing of Employee self service(ESS) and Manager self service (MSS) customized Absence planning Application pages.
• Designed and developed SQR process to load Global T&L Entitlement and Absence data into the Absence planning application tables.
• Interacted with Functional Team and SME’s to gather requirements.
• Developed Application Engine to generate Emails to the manager’s on a daily basis to notify the absence planning & entitlement thresholds.
• Designed, developed and resolved the defects for Application engine programs that use Component Interfaces for Batch Data Loads.
• Designed & Developed Test cases for the User Sytem Testing.
• Modified online and Batch Payout (based on the Entitlement bucket values) Calculations for the terminated employees.
• Customized the Punch time & Elapsed time pages
• Customized an SQR process which sends payable time from Time & Labor to the Payroll.
• Developed Entitlement Calculation Tool to derive the entitlement amounts based on types of Calculations for different regions
• Designed and developed the HR, Benefit, Wage verification statements.
• Customized the SQR Report for Managers to display the earned hours, entitlements taken of the employees under them.
• Customized the DYN ROLE App Engine to maintain the reporting hierarchy and security among the extended regulatory regions.

Confidential, Louisville, KY

PeopleSoft Technical Consultant

Environment: HRMS 8.3 SP1/8.9, People Tools 8.4X, Oracle 10g, UNIX.

Responsibilities:

• Performed fit gap analysis to come up with current business processes, enhancements and customizations for HR, Payroll, Benefits for the 8.9 upgrade.
• Designed and developed the reporting relationship programs.
• Involved in the design, development, testing, implementation and support of the custom Job Application System (JAS) for HR recruitment at the client.
• Customized PeopleSoft delivered Candidate-Gateway(eRecruit) pages to hide some fields.
• Wrote an Interface to populate data from the external system into PeopleSoft tables HRS APPLICANT, HRS APP ADDRESS, HRS APP EMAIL.
• Knowledge of MOHIMAN (Resume extracting software) to populate the data in to PeopleSoft fields.
• Developed a workflow in eRecruit to send a pending requisition for Manager approval.
• Performed the volumetric-capacity planning for the HR tables.
• Designed and developed the auto FTP processes for the BDL programs.
• Customized the delivered General Ledger process and the interface for the payroll accounting as per the clients requirements.
• Worked on the 2005 payroll Year-End process. Developed the Year End reports for Voucher, FormID.
• Created programs to generate Mailing Labels for W-4, W-5 forms requests.
• 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.
• Monitored and supported the year-end batch payroll adjustment runs.
• Involved in Payroll Processing Pay Calendar, Paysheet Creation, Pay Calculation, and Pay Confirmation. Worked on payroll tables like PS PAY CALENDAR, PS PAY CHECK, PS PAY EARNINGS, and PS PAY DEDUCTIONS etc
• As part of the leave accrual customization developed online page for vacation requests. Developed an App Engine program that sends vacation hours to Payroll and e-mail about the request to the manager.
• Customized the Benefits snap shot program as per client requirements and performed tuning. Designed and developed the Managed care interfaces to benefits’ vendors.
• Implemented the regular fixes and Tax-updates for the system. Performed the retrofit of the custom changes to the SQR’s, People Code as part of the tax updates.
• As part of the production support team, after the post implementation process, supported the entire people soft system involving HR, Benefits, Payroll, eHR, eBenefits, Benefits Administration, Manager Self Service, Security.
• Involved in the design of the HCM security profile.
• Separate permission lists were created for granting access on cross modular functionality such as HR, Benefits, Payroll and inquiry pages.

Confidential, Houston, TX

PeopleSoft Technical Consultant

Environment: HRMS 8.8/PeopleTools 8.44, Oracle 9i, Windows NT, UNIX, SQR, Crystal Reports

Responsibilities:

• Involved in the implementation and customization of the PeopleSoft HRMS 8.8 (HR, Benefits, Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Prepared field-to-field mapping for the data conversions.
• Participated in setting up of Department, Location, Job codes, Paygroups, Health, disability, and FSA.
• Involved in the business process meetings along with Functional Team lead to identify the customizations.
• Played key role in development of Interfaces, Online Customizations using SQRs, People Code and Application Engine programs.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft HEALTH BENEFIT, LIFE ADD BEN, SAVINGS PLAN, LEAVE PLAN, and LEAVE ACCRUAL Tables.
• Developed new Conversion SQR programs for flat file creation by mapping the fields between legacy (EIS and Tessaract) and PeopleSoft systems.
• Set up the open enrollment system for the new employees. Prepared the election analysis reports for the Open Enrollment Process.
• Developed several outbound interfaces to transmit the benefits related data to the vendors (Cigna, Kaiser Permanente).
• Modified search records to implement row level security.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Pay roll conversion was done for the New Year 2004 to avoid the conversion of YTDs and W2 creation. Till this conversion both the legacy system and PeopleSoft system ran in parallel.
• Developed programs for employee general deduction data conversions using the Component Interface, File Layout, Application Engine and PeopleCode.
• Application Designer was used to create new pages to provide Graphical User Interface to the users, Search Views, Audit tables to track row level security, and to create menu.
• Used PeopleCode to control the program flow logic and for the validation to meet the current business rules.
• Developed Application Engine Program to Load the External Data into Temp
• Tables and from temp tables into PeopleSoft application tables.
• Analyzed and debugged the problems and provided online help to customers.
• Conducted interactive sessions to transfer knowledge in PeopleTools, PeopleCode and SQR to client employees.
• Tested and replicated and resolved various issues reported by customers
• Maintained and updated the Department Tree and the Query Tree in the development database.
• Modified existing report formats and developed crystal reports using PS query.