We provide IT Staff Augmentation Services!

Peoplesoft Techno-functional Consultant Resume

SUMMARY:

  • Over 8 years of IT Experience in PeopleSoft ERP Implementation, Upgrade, Application Design, Development, Production Support and Migration Projects.
  • Expertise in complete life cycle of the project involving Requirements, Analysis, Specifications, Design, Development, Testing and Maintenance, Application Performance and Testing.
  • Creating technical specifications based on functional specifications, articulating application architecture and designing, managing technology delivery, coordinating discussions with Functional Analysts through full software development cycle.
  • Expectations Management - Setting Milestones, managing and meeting the milestone expectations at various levels of the organization.
  • Change Management - Assessment, Understanding, Communicating and Managing changes associated with people, processes, and technology and deploying across various levels in the organization.
  • Effective Team Player and individual Contributor with Step Learning.
  • Techno-Functional Experience in the Customization, Managing Enterprise Portal, Conversions, Interfaces and Implementation of PeopleSoft 9.2/9.1/9.0/8.9/8.8 HCM(Core HR, Position Management, Base Benefits, Absence Management and Time and Labor) modules.
  • Served as a key technical resource to implement PeopleSoft HCM Modules.
  • Business analysis and performing data conversion for various PS tables.
  • Developed Upgrade Plans, executed and reviewed Compare Reports, applied Upgrade/Change Application steps, fixes and patches for the upgrade process, and performed production test moves.
  • Experience working on People Tools and PeopleSoft Security.
  • Involved in resolving day-to-day production tickets in Finance.
  • Providing Technical solution designs in order to reduce the major portion of Customization.
  • Good knowledge of PeopleSoft Internet Architecture.
  • Developed PS queries in order to help the client day-to-day activity like Budget Status Report, Journal Entry Detail, and Un Paid Items, which have been billed.
  • Have extensive hands on experience and involved in preparing all project related documents like Business Requirement Document (BRD), Change Request (CR), As-Is, To-Be, Technical Design Document (TDD), Unit Test Plan (UTP), Defect Tracking, Effort Estimation, Issue Logs, and Status Reports.
  • Worked on PeopleSoft Security by creating and testing user roles and permission list.
  • Worked on Configuring PeopleSoft Portal and People Tools like Application Designer, People Code and Application Engine etc.
  • Proficient in preparing complex reports using SQR, PS Query, Crystal, XML publisher and PeopleSoft Integration tools.

TECHNICAL SKILLS:

ERP : PeopleSoft HCM and Financials 8.0/8.4/8.8/8.9/9.0/9.1/9.2 (core HR, Benefits, Confidential, AP, AR, AM, BI, CM, DM, Inventory, Order Management, Contracts)

People Tools: Application Designer, Application Engine, Application packages, Security, Workflow, Integration Broker, Data Mover, Tree Manager, Component Interface, Application Messaging, File Layout, Workflow.

Integration Tools : Integration Broker, Component Interface, File Layout.

Reporting Tools: PS/Query, XML Publisher and SQR

Database: ORACLE 11g, 10g/9i/8i, DB2, MySQL, SQL Server 2008.

GUI/ Development Tools: Designer, TOAD, Erwin and SQL *Plus, SQL* Navigator, SQL*Loader

Web Services: IIS, Apache Tomcat

Programming Languages: C, Java, XML, SQL, PL /SQL, HTML, CSS, Shell Scripting

Operating Systems : Windows 2008/2003/XP/2000/98/95

PROFESSIONAL EXPERIENCE:

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

  • Worked with full life cycle of PeopleSoft HCM Application Implementation and People Tools Upgrade as per business requirement.
  • Worked with STAT tool for all the enhancements and change requests.
  • Download/Install PUM Update Image 016 and PUM Upgrade Source Image and apply required for Install/Upgrade Fixes.
  • Building custom components, Dashboards, pagelets and Fluid pages and Activity Guides.
  • Involved in PeopleSoft services for upgrading Labs, PUM installation and PUM Images are used with Change Assistant for upgrading and applying maintenance updates.
  • Involved in completing all the steps including installing, configuring and conducting the PUM updates and also extracting Confidential Tax Updates from PUM 016 Image.
  • Worked on fluid interface during the upgrade preparation for Role based access such as(Manager self service, Employee self service)
  • Responsible for drafting the design and analyzing the documents for business process activities.
  • Extensively worked on PeopleSoft HCM modules System Development, Conversion, Customization, Migration and Support of HR, Benefits, Benefits Administration, Confidential, Absence Management and Time & Labor modules.
  • Developed Confidential Conversion program using Application Engine between ADP and PS for Fed Tax, State Tax, Local Tax, Balances (Deductions, Earnings and Tax), Direct Deposit Distribution, Garnishment Details, Pay Check, Pay Line, Pay Other Earns and Pay Special Earns.
  • Extensively worked on customizing existing People Code and writing new People Code, including Application Engine People Code, Application Package People Code, Application Message People Code, Record/Record-Field People Code, and Component People Code.
  • Designed and developed FMLA outbound interface from Time and Labor to Benefits, for the FMLA reported hours. Created the mapping between Reported time table in T&L and the Benefits FMLA Leave History table. Developed the validations for Entitlements.
  • Applied the PS Tax Updates, Patches and Bundles regularly also analyzed changes delivered by Oracle as a part of Tax Updates and performed necessary retrofits.
  • Involved in running the Compare reports after the Tax Updates to reconcile the data between the production and test environment.
  • Worked on modifications for Open Enrollment as well as support to the HRIS team. Closely worked with the Benefits Analyst and users to gather the requirements for interfaces for Open Enrollment.
  • Developed a custom SQR for Benefits Terminations of employees when they lose coverage. This program ensures that the employees are enrolled only in those plans for which they are eligible. Customized the PeopleSoft delivered e-Benefits Summary page and people code so that employees can view their current Benefit elections, but cannot update it.
  • Developed an app-engine program to provide the vender a list of employees who are eligible for medical, dental, vision, flexible spending accounts and supplemental life insurance.
  • Configured and customized the delivered EIP using Application Messaging (by using nodes, messages, channels) to dispatch XML Format to the 3rd party vendors using Integration Broker.
  • Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
  • Resolved known bugs or new issues for the existing reports and encountered during testing.
  • Created custom reports and modified reports using XML publisher, SQR and Application Engine Programs.
  • Involved in removing redundant information in security related records in PeopleSoft using combination of SQR, PS Query and Excel spreadsheets.
  • Resolved issues in Query Manager and fix the issue to accommodate Users request.
  • Designed User Id, roles, permission lists according to customer requirement and security trees for maintaining security within the HR and Finance modules.

Environment: PeopleSoft 9.2 Financials and HR (Benefits, Core HR, Confidential ) People Tools 8.49/8.52 (Application Designer, People Code, Application Engine, XML Publisher, Integration Broker, AWE, nVision and SQR) on Oracle 11g database.

Confidential, Houston, TX

PeopleSoft Techno-Functional Consultant

Responsibilities:

  • Worked with full life cycle of PeopleSoft HCM Application Upgrade and People Tools Upgrade as per business requirement.
  • Worked on HCM Application Upgrade project from 9.0 to 9.2.
  • Developed technical specification documentation for the new changes brought out in HR version 9.2
  • Involved in 9.2 Upgrade or Update PUM steps and downloaded the tax updates and applied through PUM.
  • Created fluid pages wherever necessary.
  • Used Change Assistant to apply modified change package to other databases applying Confidential Tax Updates.
  • Created Change Package (Package includes required for upgrade fixes, required forPUM Images are used with Change Assistant for upgrading and applying maintenance updates.
  • Developed custom on-line pages and components in HCM as per the client's request.
  • Experience in data conversion strategy, planning, development and testing between ERP’s.
  • Retrofitted People Code, SQR to accommodate customizations to meet the business requirements.
  • The PeopleSoft delivered Timesheet page had a bug in case of Holiday weeks/Schedule Deviation. The “Total Schedule Hours” and “Schedule Deviation” values were not populated in case of Holiday Schedule. A custom PeopleCode fix was applied to the Application Package Code .
  • Did work with Post Production support, enhancements, Fixing process issues, Batch Job Processing and Troubleshooting.
  • Created a Mass Hire process for Acquisitions using Application Engine, Component interface and File layout with staging tables.
  • Configured setup tables for Confidential interfaces including System Table, PS Tables, Field Definitions, and Definition table and customized Job Data page with complete impact analysis to add an option “Do-not-rehire” for HR users.
  • Familiar with Setup of key elements in PeopleSoft Time and Labor like Installation Options, Time and Labor Security, Enroll Time Reporters, Time Admin Setup and Tools.
  • Maintain Time Reports of Punched & Elapsed Employees, Manage schedules, Organize employee groups, Analyzing TRC's and associated Earning Codes.
  • Track task data, Manage exceptions, Track attendance, Process payable time, Create rules for processing time, Distribute and dilute labor costs.
  • Resolved known bugs or new issues for the existing reports and encountered during testing.
  • Created custom reports and modified reports using XML publisher, SQR and Application Engine Programs.
  • Involved in removing redundant information in security related records in Peoplesoft using combination of SQR, PS Query and Excel spreadsheets.
  • Resolved issues in Query Manager and fix the issue to accommodate Users request.
  • Resolved Issues using Application Engine, SQR, Component Interface, Application Package and PS Query Manager for complex issues involved with Supply chain modules.
  • Configured domestic workflow set up using AWE (Approval Workflow Engine)
  • Set up the criteria for self-approval, register transactions, user list definitions and e-mail notifications.
  • Developed and implemented numerous queries and reports.
  • Designed User Id, roles, permission lists according to customer requirement and security trees for maintaining security within the AP and GL modules.
  • Customized PeopleSoft objects to address future dated allocation issues

Environment: PeopleSoft 9.2 HCM(Core HR, Benefits, NA Confidential, Time and Labor and Position management) People Tools 8.49/8.52 (Application Designer, People Code, Application Engine, XML Publisher, Integration Broker, AWE, nVision and SQR) on Oracle 11g database.

Confidential, Cleveland, OH

Senior PeopleSoft Consultant

Responsibilities:

  • Involved in various Customizations for North American Confidential in HCM 9.1 as per the business needs.
  • Participated in fit/gap analysis meetings and system configuration.
  • Extensively worked on Analysis of the Business requirement document and derived requirements.
  • Worked on many inbound and outbound interfaces using Application Engine and File layouts.
  • Implemented Application Engine programs with Meta SQLs.
  • Configured and maintained all the Confidential tables like Company, Pay group, Earnings, Deductions, Tax data, Pay calendar and Pay Run IDs.
  • Involved in Confidential processing: Pay sheet creation, Pay Calculation, Pay confirmation.
  • Involved in running the Compare reports after the Tax Updates to reconcile the data between the production and test environment.
  • Applied and retrofitted customizations for Tax Updates including Online and Batch changes like SQR, COBOL for both CANADA and US.
  • Applied ADP patches to PeopleSoft.
  • Worked on End-to-End implementation of Aon Hewitt benefits interface including Design, Analysis, Implementation and Testing to send deductions data .
  • Analyzed, Compiled and executed Confidential COBOL processes like PSPPYBLD, PSPPYRUN, PSPCNFRM.
  • Involved in Quarter End and Year End processing.
  • Addressed various production issues with Pay Sheet creation, Pay Calculation and Pay Confirmation.
  • Tested various Confidential process which mainly include Confidential Taxes, Confidential Interfaces, Setting up Employee Confidential Data, Calculating Pay, Taxes and Customizing Confidential and Tax Reports
  • Created all the Paychecks in 8.3 using DDP003.SQR and PAY003.SQR as PDFs and migrated them as files to 9.1 environment as part of Paycheck Data conversion process.
  • Used ExcelToCI to load the data into PeopleSoft configuration tables.
  • Configured benefits plans and rate tables based on union policies.
  • Configured ben admin eligibility and event rules.
  • Designed Benefits vendor interfaces for health, vision, COBRA and Life
  • Worked in PeopleSoft Benefit Administration to bring in the benefits plans, custom build benefits interfaces and auto enrolment process.
  • Designed, developed and tested custom SQR reports in NA Confidential, T&L and Benefits.
  • Retrofitted HR and Confidential components based on new requirements and customizations.
  • Wrote People Code to customize the delivered objects for HR records.
  • Worked on several customs Table Audits and created Test scripts for functional test.
  • Active member of Hyper care support of CANADA Confidential in New 9.1 system after go-live and addressed several production issues effectively.
  • Worked on workflow and Implemented Integration broker in Enterprise Portal and HCM.
  • Developed various Component Interfaces and Application messages to support web integration.
  • Extensively worked on Shell Scripting, good understanding about UNIX.
  • Supported Acquisitions and Divestitures from Confidential perspective.
  • Developed Run Control Pages to run the process like Application Engines, SQRs.
  • Worked with STAT tool for all the enhancements and change requests.
  • Reported bugs and tracked defects using HP Quality Center (HPQC).
  • Involved in performance fine-tuning of the SQR programs.
  • Provided Technical details of existing programs for Design analysis for Implementation of US Confidential .
  • Involved in various meetings with leaders to provide status updates on timely ba sis

Environment: PeopleSoft FSCM 9.1, People Tools 8.51/8.52, Windows NT, UNIX and Oracle 11.2.

Confidential, Houston, TX

Senior PeopleSoft Techno/Functional consultant

Responsibilities:

  • Worked as a techno functional consultant for the integration of PeopleSoft HR Applications with clients invoicing systems.
  • Involved with PeopleSoft MSS / ESS enhancement in PeopleSoft HRMS 9.0 for the client.
  • Implementation and Customization according to new business rules of the client, which includes creating new fields, Records/Sub records, Pages/Secondary Pages and menus for new developments as per the client requirement using Application Designer & People Tools.
  • Extensively worked in Coding and Unit testing.
  • Interacted with end users on daily basis to understand more about the PeopleSoft customizations required by them. Also worked closely with the end users in resolving their issues
  • Designed & customized e-Benefits Home Pages (Benefits enrollment) Flexible spending Accounts pages & life Events (Marital status Change) Using Application Designer, People Tools, People Code
  • Evaluated and remediated the e-Benefits self-service according to the business needs and requirements.
  • Involved in setting up benefits eligibility and event rules. Defined Benefit Plans.
  • Customize Benefit programs with the Benefit/Deduction Program Table Group, adopted Benefit programs for Health Plans, Life & AD/D plans, Dental Plans, Establishing Rates and Calculation Rules.
  • Created Time and Labor schedules and employee schedules.
  • Designed custom pages to store employee time profiles.
  • Build or modify new time and labor rules to support various business requirements.
  • Configured various time and labor components like TRC's, TRC programs, Workgroups, shifts and schedules, Comp leave plans, time reporting templates and rules
  • Customized timesheet to have online edits and validations to support business requirements.
  • Created Component Interfaces to populate data into Visa/Permit pages. Created customized pages based on Derived Records. Integration of Time & Labor TRC with NA Confidential .
  • Configured and customized the delivered EIP using Application Messaging (by using nodes, messages, channels) to dispatch XML Format to the 3 rd party vendors using Integration Broker.
  • Created customized Application Engines to perform XSL transformations from PeopleSoft to 3 rd party vendors. Involved in development of new modules like Job data Upload and Supervisor change upload as per Requirement.
  • Perform code review, test script/test result review before release of project.
  • Analyzed the tickets and provided reliable solutions to the customer.
  • Worked on inbound and outbound interfaces using Application Engine, Component Interface and SQR.
  • Created new reports and customized the existing reports using SQR.
  • Extensively worked on People code with object orientation (Row set, Row, Record, and Field) Familiar with stand-alone row sets in people code.
  • Worked on performance related issues in AE programs using Managing Abends and application engine debugging, restarting ABEND programs.
  • Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
  • Worked on setting up Data security using Tree manager, Department tree, and Query tree.

Environment: PeopleSoft 8.9/9.1 HR ( e-Benefits, Confidential, Time & Labor) People Tools 8.49/8.52 on Oracle 11g database.

Confidential, Washington, DC

PeopleSoft Financials Technical Consultant

Responsibilities:

  • Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.
  • Involved in the implementation and production support of Financials 8.9 (BI, AP, AR and GL).
  • Extracted, converted and loaded data from legacy system to PeopleSoft tables.
  • Systems converted - Vendors, Purchase Orders, Receipts, Contracts, and vouchers.
  • Designed and implemented the functionalities of Lockbox, write-offs of credits /debits and payments in AR Module.
  • Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
  • Developed several inquiry pages and modified existing pages for the users to enter data and run reports for the AR and Billing modules.
  • Developed several customizations by creating complex pages and business logic as per client requirement.
  • Administered, scheduled and maintained the Jobs on Process Scheduler.
  • Ran compare reports and analyzed them for the collisions, retrofitted the old customizations, SQR’s and Crystals.
  • Involved in modification and fine-tuning of Application Engine, SQR programs
  • Reviewed all interfaces that update PeopleSoft to ensure that data integrity will exist in the upgraded system.
  • Involved in production support and provided support to functional team members on SQR and People Tools/People Code understanding.

Environment: PeopleSoft Financials 8.9, People Tools 8.42/8.46, Oracle 9.2, Data Mover, Component Interface, SQR, Crystal Reports, nVision, Quest STAT.

Confidential, Cincinnati, OH

PeopleSoft Consultant

Responsibilities:

  • Worked on various Customizations for Human Resource Self-service application as per the business needs.
  • Worked on HR activities such as Employee self-service and manager self-service and other workflow process as per the business needs.
  • Extensively worked on Job data and employee data.
  • Created a Mass Hire process for Acquisitions using Application Engine, Component interface and File layout with staging tables.
  • Loaded all the Configuration tables using Excel to CI and Application Engine processes. Performed SQL queries for Data extractions.
  • Extensively worked on Analysis of the Business requirement document and derived requirements.
  • Worked on all phases of project like Development, Testing, Go-Live and configure Data to ensure successful upgrade jobs.
  • Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
  • Resolved customer issues related People Code, SQR, Query, crystal Reports and Process Scheduler.
  • Developed and automated new interfaces. Modified existing programs as per business rules.

Environment : PeopleSoft Financials 9.0, People tools 8.49, People Code, Application Engine, Upgrade Assistant, SQR and Windows 2000.

Confidential

Software Engineer - PeopleSoft

Responsibilities:

  • Handled upgrade of Purchase Requisition in purchasing module.
  • Compared definitions between two instances by generating compare reports.
  • Designed technical documents to fit delivered functionality with the customized functionality of PR.
  • Added new fields to add search record to in corporate new validations on delivered PR.
  • Created new definitions to fit delivered functionality with the customized functionality of PR in 9.0.
  • Developed people code as per the business requirement to validate PR page functionality.
  • Implemented new logic using people code to save data from customized tables to delivered tables.
  • Performed unit testing prior sending to E to E testing.
  • Involved in scrum call and discussing on the requirements on daily basis.

Environment : People Tools 8.48, Financials 9.0, Oracle 10.2.0.5, HP UX 11.23.

Software Engineer

Confidential

Responsibilities:

  • Implemented the changes in PR page functionality as per the business logic.
  • Worked on Application Designer, People Code to implement business logic on PR page.
  • Worked on the changes and Bug fixes on customized Purchase Requisition (PR) Page.
  • Worked on People Code to change the workflow for types of Receipts.
  • Created and customized PS Queries to retrieve PR, PO and Receipt Header and Line level data.
  • Worked on Application Designer and People code to customize PAF (Payment Approved Form) Page.
  • Worked on SQR to Print PAF and Receipt Page details.
  • Designed Technical Design Documents for all the changes and Bug fixes done on existing functionality.
  • Developed Test cases for Unit Testing and prepared required documents prior sending to Testing, UAT and then to Production.

Environment PeopleSoft Financials 8.9, People Tools 8.42/8.46, Oracle 9.2, Data Mover, SQR and Crystal Reports.

Hire Now