SUMMARY:

• Over 11 years of experience in Implementation, Customization, Upgrade and Development of PeopleSoft HRMS applications
• Extensive experience in Implementation, Customization, Upgrade, Maintenance and Production Support of PeopleSoft HRMS applications with Modules such as HR, Payroll, Benefits, Benefits Administration, Time and Labor, Absence Management, ESS and MSS.
• Very strong SQR coding skills and experience modifying complex existing SQRs. Developed many SQRs including Complicated Interfaces and Conversion reports using important SQR methods like Break Logic, Load - Lookup, Arrays and Multiple reports.
• Extensively worked on People Tools such as Application Designer, People Code, Application Engine, Maintain Security, Query and File Layout, Process scheduler, Data Mover, Component Interface, Integration Broker, Application Messaging, XML Publisher and Reporting tools (SQR and Crystal Reports).
• Expert report writing skills using SQR, Crystal Reports, nVision and PS QUERY.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization and new development.
• Extensively involved in implementation of collaborative applications (self-services areas) eRecruit, eBenefits, eDevelopment, eProfile, eCompensation, ePay and ePerformance.
• Extensive experience in transferring existing data from legacy system to PeopleSoft application database tables using SQR, Application Engine, People Code, File layout and Component Interface.
• Used STAT extensively for object migrations.
• Significant PeopleSoft implementation experience from project conception through roll-out which includes fit gap analysis, development, major customization, testing, and training.
• Excellent End User Facing capabilities, Explain & Present the products and project estimations, budgets required for the projects & their alternate solutions.
• In-Depth understanding of PeopleSoft Internet Architecture (PIA), Data models and client server applications on Windows and UNIX platforms.
• Tested PeopleSoft Applications by creating Test plans and test cases.
• Very good exposure to Testing Tools (Mercury and Rational).
• Experience in Unit, Integration, Interface, Functional, Regression, Acceptance, Load and System Testing using Black Box and White Box methods.

TECHNICAL SKILLS:

PeopleSoft Application: HCM/HRMS 9.1/9.0/ 8.8/8.4 SP1/8/ 7.5 (Payroll, Base Benefits, BenefitsAdministration, Benefits, eRecruit, Time and Labor, Pension AdministrationUpgrade, Global Payroll)

People Tools: 8.54/8.52/8.51/8.50 / 8.49/8.47/8.45/8.44/8.43/8.41/8.20/ 8.17/7. x (Application DesignerApplication Engine, Maintain Security, Query, Process scheduler, WorkflowAdministrator)

Reporting Tools: SQR, PS Query, Crystal Reports, nVision, Business Objects

Operating systems: Windows-95/98/NT/2000/XP, MS-DOS, UNIX

Languages: People Code, C, C++, Java, SQL-PL/SQL, HTML, XML, VB Script, Java ScriptCOBOL.

Web Servers: Web Logic 5.1/6.1/8.1, IIS 6.0, MQ series, SOAP.

Databases: Oracle 10g,9i,8.x/7.0, MS SQL Server, DB2, MS Access

Data Management: Data Mover, Import Manager

Integration Tools: Component Interface, File Layout, Integration Broker

PROFESSIONAL EXPERIENCE:

Confidential, Suwanee, GA

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Worked on customization of PeopleSoft process using People Code.
• Worked on the SQR enhancements Requested by the End Users.
• Inserted Tree nodes through SQL’s as part of GL ACCOUNTS Redesign.
• Resolved the Issues During 9.2 Upgrade.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Involved in Production Support.
• Resolving the Defects Countered in Unit Testing, Integration Testing.
• Working along with DBA’s to fix the performance issues.
• Created the DBLINK to EBS finance System and Linked with Job page, users will get Valid Departments Associated with Business unit Assigned to the Employee.
• Customized the Delivered HIPAA 834 for the BCBS.
• Customized the Open Enrollment Pages based on the Requirements.
• Modified Text Catalogs to update Information on Open Enrollment pages.
• Worked with functional team to fix data issues and recreating ACA XML files and submitting it to IRS.
• Created Custom Interface for UNUM to Provide the STD, LTD and FMLA information
• Created Custom Interface for Fidelity to Provide the employee information to create profiles on Fidelity system for Employee Stock Purchase Program.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Developed several inbound & outbound interfaces to transmit the benefits related data to the vendors.
• Played key role in development of Interfaces, Online Customizations using SQRs, People Code and Application Engine programs.
• Extensively worked with Application Designer to modify record Definitions, pages, components, menus and giving access to them by using Maintain security.
• Adding permission lists to the run control pages and used process scheduler to run the reports online.
• Used Maintain Security to give access to the pages and customized Menu and created Permission lists, Users, Roles and assigned Roles to users.
• Worked on portal security including the access to pages and folders.
• Created several SQR’s to Load Employee Data into Peoplesoft as part of Ruckus Implementation.

Environment: PeopleSoft HCM 9.2/9.1, People Tools 8.55/8.54, Oracle11, Windows-NT/2000/XP and UNIX, SQL*plus, SQL Tools, TOAD.

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Worked on customization of PeopleSoft process using People Code.
• Worked on the SQR enhancements Requested by the End Users.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Involved in Production Support.
• Resolve the Issues assigned to me through service now.
• Resolving the Defects Countered in Unit Testing, Integration Testing.
• Working along with DBA’s to fix the performance issues.
• Daily maintenance of open events and the benefits process error log.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Developed several inbound & outbound interfaces to transmit the benefits related data to the vendors.
• Played key role in development of Interfaces, Online Customizations using SQRs, People Code and Application Engine programs.
• Extensively worked with Application Designer to modify record Definitions, pages, components, menus and giving access to them by using Maintain security.
• Adding permission lists to the run control pages and used process scheduler to run the reports online.
• Used Maintain Security to give access to the pages and customized Menu and created Permission lists, Users, Roles and assigned Roles to users.
• Worked on portal security including the access to pages and folders.

PeopleSoft HCM 9.1, People Tools 8.54/8.52, Oracle11, Windows-NT/2000/XP and UNIX, SQL*plus, SQL Tools, TOAD, Crystal Reports.

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Involved in Production Support.
• Worked on customization of PeopleSoft process using People Code.
• Developed a New SQR report which will fetch the Employee information from various tables and insert them in a table, and a text file was generated from that table to update Org Chart information in Org Publisher.
• Converted Custom SQR’s into XMLP table format Word Documents by converting SQR logic as App Engine People code Logic
• Worked on the SQR enhancements Requested by the End Users.
• Daily maintenance of open events and the benefits process error log.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Developed several inbound & outbound interfaces to transmit the benefits related data to the vendors.
• Played key role in development of Interfaces, Online Customizations using SQRs, People Code and Application Engine programs.
• Extensively worked with Application Designer to modify record Definitions, pages, components, menus and giving access to them by using Maintain security.
• Adding permission lists to the run control pages and used process scheduler to run the reports online.
• Used Maintain Security to give access to the pages and customized Menu and created Permission lists, Users, Roles and assigned Roles to users.
• Worked on portal security including the access to pages and folders.

PeopleSoft HCM 9.0, People Tools 8.52, Oracle11, Windows-NT/2000/XP and UNIX, SQL*plus, SQL Tools, TOAD, Crystal Reports.

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Development and modification of Outbound and Inbound SQR interfaces.
• Upgraded PeopleSoft HRMS from 9.0 to 9.1 using Application Upgrade Assistant, Application Designer and Data Mover Scripts.
• Involved in Production Support.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Experience in retrofit of SQRs during upgrade from HRMS 9.0 to HRMS9.1.
• Involved in Unit Testing and Systems Integration Testing during up gradation of People soft system from 9.0 to 9.1.
• Worked on the Customizations of Recruitment/TAM Module.
• Worked extensively with eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on the Recruiting Process of eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on setting up the Integration broker to run the sync between HCM and ELM for all the HR related data.
• Created 20 complex rules for all sites which include tardiness rule, overtime rule, shift allowance etc.
• Worked on customizing timesheet page to change the way security is used in T&L. Based on the role, managers and timekeepers get different access based on the Pay period.
• Created and maintained custom Time & Labor Rule Application Engine module

  to apply multi-site, multi-contract specific overtime, holiday, and shift and labor rules to 7000 employee population.

• Performed troubleshooting of Time Admin Process failure and its failure to create time - analyzed Exceptions, Time reporter active status, Effective dates, Rules, and Time reporter status.
• Worked on mapping functional requirements to technical requirements.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables.
• Worked on interface programs for migrating data from other systems to People Soft.
• Involved in documentation of technical specifications, developing test cases and technical design.

Environment: PeopleSoft 9.0/9.1, People Tools 8.52, SQR, MS SQL Server, Windows XP and UNIX

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 9.1 and People tools 8.51
• Extensively worked on lot of Interfaces (In & Out bound) and Reports for converting data from AS400 system to PeopleSoft.
• Responsible of the design, development and testing of all HR, Payroll, Benefits and Ben Administration.
• Customized and implemented PeopleSoft HRMS modules
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Extensively involved in performing customizations to the HR application by creating new fields, pages and components.
• Used File Layout Definition tool to get data from the legacy system.
• Developed custom PeopleSoft on-line organizational, instructor and facility calendar panels for assigning courses and retrieving non-training days.
• Worked on setup of SetID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System Generated SQR reports to create summary reports on payroll details check and validate the data.
• Maintaining PeopleSoft user security using PeopleSoft Security Administrator and Operator Preferences.
• Including on boarding of new employees for one-time cutover as well as ongoing processes.
• 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.
• Executed unit test plans for medium complexity batch interface programs for eRecruit and Self Service Modules.
• Worked on customization of PeopleSoft process using People Code.
• Submit absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enable plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise eBenefits Self-Service Estimate Pension function.
• Involved in PeopleSoft Enterprise HCM solutions to integrate pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.

ENVIRONMENT: PeopleSoft HCM 9.1, People Tools 8.51, PL/SQL, UNIX, Weblogic6.1, TOAD, Crystal Reports.

PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in the production & support and upgrade of the PeopleSoft HCM 8.9 TO 9.1 (HR, Benefits and Benefits Administration, Payroll) modules based on organizational needs and requirements.
• Set up the open enrollment system for the new employees. Prepared the election analysis reports for the Open Enrollment Process.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Played key role in retrofitting of Interfaces, Online Customizations using Sqr’s, People Code and Application Engine programs.
• Improved system productivity and processing execution time of Open Enrollment.
• Interaction with end-users to define system setup, improve benefits system processing and data requirements for Benefits and Open Enrollment.
• Provided Gap and Business Analysis to identify modifications and business requirements, functional and technical programming for HRMS, Benefits Administration, Payroll, Employee Self-Service, Workflow, eBenefits modules which consisted of design documentation, table structure setup and modification of workflow process for daily event processing and Open Enrollment functionality.
• Implemented complex technical and system design specifications for benefits, eBenefits and Self-Service. Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
• Managed daily HRMS which consisted of multiple jobs and benefit event maintenance and implementation of yearly Open Enrollment, which consisted of employee choice options and selective Benefit elections of non-choice active and retired employees.
• Daily maintenance of open events and the benefits process error log.
• Provided functional and technical support for Benefits Billing and Cobra. Performed functional and technical one-on-one EUT for HRMS and Benefits Administration.
• Development of functional and technical step-by - step documentation.

ENVIRONMENT: PeopleSoft HCM 9.1, People Tools 8.51, PL/SQL, UNIX, Weblogic6.1, TOAD, Crystal Reports.

PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in the production & support and upgrade of the PeopleSoft HCM 9.1 (HR, Benefits and Benefits Administration, Payroll and Time & Labor) modules based on organizational needs and requirements.
• Performed the Fit - Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Extensively worked on Tax Updates in functional implementation parts and involved in year end tasks particularly by applying payroll tax updates for running the payroll as expected.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Applied regular tax updates, patches & bundles to all relevant instances applied the Bundles, patches Tax Updates 10-A, B, C, D, E, F and resolved issues related to year-end processing.
• Worked on NA Payroll Year-End Processing and generating W-2’s.
• Responsible for setting up eRecruit, Talent Acquisition, Candidate Gateway for recruiting process.
• Designed screens for the Talent Acquisition, Candidate Gateway, eRecruit for End Users.
• Identified all the Business Process, Desktop reports and evaluated the required Business processes reports in Core HR, eRecruit, Talent Acquisition, Candidate Gateway.
• Developed several inbound & outbound interfaces to transmit the benefits related data to the vendors.
• As part of PeopleSoft upgrade Fine expertise on Change Assistance (Upgrade Assistance), Quest Stat and data migration.
• Involved in upgrade Assistant to prepare Upgrade for comparison Reports, Upgrade Statistics for Oracle to run the Benefit Reports and configured options to run unattended processes for error notification by Email.
• Responsible for implementing Position Data Pages in MSS by creating departmental budgets, Defined budget period calendars and source transactions.
• Modified the Absence Approval page in Manager self service in order to update or delete the approved absence.
• Involved in Setting up the Absence Data and Developed Report for Employee Absence and Track Vacations.

Environment: PeopleSoft HCM 9.1, People Tools 8.50, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and UNIX, Weblogic6.1, Oracle 10g, SQL*plus, SQL Tools, TOAD, Crystal Reports.

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the upgrade of the PeopleSoft HCM 9.0 (HR, Benefits and Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Participated in setting up of Department, Location, Job codes, Pay groups, Health, disability and FSA.
• Involved in the business process meetings along with Functional Team lead to identify the customizations.
• 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.
• Experienced in the design and development of the Workflow. This tool was primarily used to develop Work lists, Events and Routings for various businesses needs.
• Developing test Strategy, test Plan, requirements traceability matrix, use cases, test scripts for system and regression testing of HR and Manager Self Service applications using Quality Center.
• Developed several outbound interfaces to transmit the benefits related data to the vendors.
• Worked on PeopleSoft Integration Broker to develop and administer messaging integrations. These processes include configuring messaging systems and managing integration gateways. They also include defining message channels, messages, nodes, transactions, relationships, and transaction modifiers.
• Created Absence Run Types and wrote rules on Absence takes, customized the T&L Self service modules by managing absences and customized the delegation in absence management.
• Involved in setting up of Payee overrides of an absence element.
• Responsible in writing XML Publisher reports using Bursting logic in T&L & Absence Mgmt module.
• Fixed Issues related to Manager Self-Service (MSS) for Job Opening Approvals, Absence Approvals, Student Admin
• Modified search records to implement row level security.

Environment: PeopleSoft HCM 9.0, People Tools 8.50, Oracle10g, Windows-NT/2000/XP and UNIX, SQL*plus, SQL Tools, TOAD, Crystal Reports.

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in the consolidation of the PeopleSoft HCM 8.9 (HR, Benefits and Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Played key role in development of Interfaces, Online Customizations using SQRs, People Code and Application Engine programs.
• 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.
• Developing test Strategy, test Plan, requirements traceability matrix, use cases, test scripts for system and regression testing of HR and Manager Self Service applications using Quality Center.
• Worked on PeopleSoft Integration Broker to develop and administer messaging integrations. These processes include configuring messaging systems and managing integration gateways. They also include defining message channels, messages, nodes, transactions, relationships, and transaction modifiers.
• Modified search records to implement row level security.
• Developed programs for employee general deduction data conversions using the Component Interface, File Layout, Application Engine and People Code.
• 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 People Code to control the program flow logic and for the validation to meet the current business rules.
• Customized the Time Admin process to post the Payable time to N.A Payroll before finalizing the Absence Management Process.
• To subscribe to data, third-party applications can accept and process XML messages posted by PeopleSoft using the available PeopleSoft connectors or by adding a custom built connector to the Integration Gateway.
• 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 People Tools, People Code 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.

Environment: PeopleSoft HCM 8.9, People Tools 8.47, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and UNIX, Weblogic6.1, MQ series, Kronos, ADP, Tuxedo6.5, Jolt, SQL*plus, SQL Tools, TOAD, Crystal Reports.

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Extensively worked with Application Designer to modify record Definitions, pages, components, menus and giving access to them by using Maintain security.
• Developed Functional and Technical Spec for the HR, Payroll and Benefits Reports.
• Extensively worked on Production Support by handling tickets on North American Payroll, Benefits and Time and Labor modules.
• Adding permission lists to the run control pages and used process scheduler to run the reports online.
• Designed and developed people code to set up workflow for Hiring and triggering events to mail the new-hire details to all administrators such as Payroll, Benefits and Time and Labor.
• Developed SQR reports for premium journal Reports in Benefits and compliance reports and Garnishment Reports in payroll etc
• Designed and developed the Interface programs necessary to move data into PeopleSoft tables using Application Messaging through Integration Broker.
• Extensively used Process Scheduler for running different reports create and submit groups of processes as a job, and used Process Monitor to control the processes that are submitted to the Process Scheduler and to check the status of processes.
• Design of functional specifications for eligibility and event rules customizations in Benefits Administration and Salary change request with workflow routing in Manager Self Service applications.
• Worked on portal security including the access to pages and folders.
• Created custom Application Engine programs to synchronously create user accounts in the Portal Database for new employees.
• Worked on various People Tools such as Application Designer, Data Mover, Maintain security, Object Security, Process Scheduler, PS Query, and Application Engine.
• Extensively worked Global Payroll to Isolate country-specific regulations, processes, reports, self-service, and user-defined rules from the core application by using delivered country extensions, State, calculate and distribute an employee's pay in multiple currencies.
• Worked on Global Payroll to improves accuracy, timeliness, and financial controls, consolidate disparate payroll operations for multiple countries by using a single database, yet enter and access payroll data from anywhere in the world.
• Extensively worked on Payroll interface to ADP for several interfaces.
• Extensively worked on Absence Management to submit absence requests and view their status and View current and projected absence balances.
• Used Maintain Security to give access to the pages and customized Menu and created Permission lists, Users, Roles and assigned Roles to users.
• Requirement Gathering for eRecruit, Talent Acquisition, Candidate Gateway.
• Documented for the customizations, development programs for the user reference.
• Tested different new customizations and SQR Reports based on the Client’s requirements.
• Developed Queries using PS Query and export the results with Microsoft Excel and perform further calculations and develop report.

Environment: PeopleSoft HCM 8.9, People Tools 8.47, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and UNIX, Weblogic6.1, MQ series, ADP, Kronos, Tuxedo6.5, Jolt, SQL*plus, SQL Tools, TOAD.

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved in analysis, customization, and implementation of HR/Benefits/Payroll modules using PeopleSoft 8.8 and Oracle 9i.
• Responsible of the design, development and testing of all HR, Payroll, Benefits and Time and Labor.
• Customized and implemented PeopleSoft HRMS modules
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Extensively involved in performing customizations to the HR application by creating new fields, pages and components.
• Used File Layout Definition tool to get data from the legacy system.
• Developed custom PeopleSoft on-line organizational, instructor and facility calendar panels for assigning courses and retrieving non-training days.
• Worked on setup of SetID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System Generated SQR reports to create summary reports on payroll details check and validate the data.
• Maintaining PeopleSoft user security using PeopleSoft Security Administrator and Operator Preferences.
• Including on boarding of new employees for one-time cutover as well as ongoing processes.
• 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.
• Executed unit test plans for medium complexity batch interface programs for eRecruit, Talent Acquisition, Candidate Gateway.
• Worked on customization of PeopleSoft process using People Code.
• Using Global Payroll Integrate with standard chart fields to facilitate payroll expense reporting, Use a robust Absence Management engine to manage the most common leave types and automate the leave accrual balance process.
• Submit absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enable plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise eBenefits Self-Service Estimate Pension function.
• Involved in PeopleSoft Enterprise HCM solutions to integrate pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.

Environment: PeopleSoft HRMS 8.8(HR, Payroll, Base Benefits), People Tools 8.42, Crystal Reports, SQR, Oracle 9i, Web Logic 8.1/6.1, MQ series, Tuxedo 6.5, Toad, Windows NT/2000, Query Analyzer, Application Designer, People Code, SQR, PS/Query, security/View and Process Scheduler.

PeopleSoft HCM Upgrade Consultant

Responsibilities:

• Worked on Pension Administration to manage multiple, complex defined benefit plans with a single, pure Internet solution that can be configured to match your unique plan rules.
• Interacted with Business Analysts to figure out the Process flow in various Business processes.
• Involved in analysis, design, data mapping and data conversions using SQR.
• Involved in the Application upgrade from version 8.3 to version 8.8 by using upgrade Assistant to prepare Upgrade for comparison Reports, Upgrade Statistics for Oracle to run the Benefit Reports and configured options to run unattended processes for error notification by Email.
• Involved in system testing and bug fixing during the initial and move to production phases of the Application upgrade.
• Involved in upgrade of people tools objects and primarily responsible for loading base data, fields compare reports and converting, reviewing Application Engine Reports.
• Prepared the database for the upgrade, applied required patches and fixes for the upgrade, ran DDDAUDIT, SYSAUDIT reports and cleaned the database before the upgrade process.
• Designed workflow applications for Payroll as well as Payroll interface.
• Responsible to run various Initial Audit Reports, Application Audit reports, compare Reports, Script modifications, involved in the upgrade process.
• Created run controls record pages and attached to the process scheduler, to run the process.
• Executed job for the initial pass of upgrade using Upgrade Assistant, documented issues related to upgrade steps, worked with PeopleSoft and resolved issues.
• Developed an application engine program to generate random passwords for the existing users and email them after the cut over process.
• Involved in migrating the projects from within various development environments and to production environment.
• Responsible for modifying & upgrading several customized SQR reports from PeopleSoft version 8.3 to 8.8.
• Identified in-efficient SQR programs and tuned them to improve performance.
• Performed system testing on the customized reports and pages.

Environment: PeopleSoft HRMS v 8.3/8.8, People Tools v8.1x, HR, Payroll, Benefits, People Code, Application Designer, Application Engine, File Layout, Application Upgrade Assistant, SQR, Crystal Reports 9.0, PS/Query, Configuration Manager, Object security, User security/ View, Process scheduler, Data Mover, Oracle 9i, Windows 2000/NT, HP-Unix, MQ series.