We provide IT Staff Augmentation Services!

Peoplesoft Technical Consultant Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Accomplished IT Professional with over 12 years of experience as Peoplesoft Lead Techno functional consultant in PeopleSoft Implementation,Upgrade,Interfacing,Report Writing, Data Migration, Production Support and Maintenance projects which includes Design, Development, Testing, Upgrade, Production Support and Maintenance of PeopleSoft Applications.
  • Strong PeopleSoft analytical experience in Core HR, Base Benefits, Payroll, Payroll Interface, Benefits administration, Absence Management, Time & Labor, Employee Self - Services, Manager Self-Services, eBenefits, ePerformance,eCompensation and complete understanding of complete project life cycle.
  • Highly Proficient in PeopleSoft, PeopleTools - Application Designer, Application Engine, Component Interface, Data Mover, PeopleCode, Application Packages, PS Integration Broker, PS Security, Interfaces, Excel to CI, SQR and various other developer tools.
  • Experience in integrations between PeopleSoft and Back-Office applications, PeopleSoft and third-party applications between different PeopleSoft modules using Integration Broker and Application messaging.
  • Significant experience in conversions between PeopleSoft and legacy systems. Involved in converting employee data, payroll balances (earnings, accumulators, deductions, taxes and check YTD), time and absence data.
  • Extensive experience working with PeopleSoft Fluid development and CSS to modify XML documents.
  • Worked closely with external vendors on the implementation & upgrade projects.
  • Extensive knowledge in PL\SQL, Stored Procedures with Oracle and IBM DB2 databases.
  • Proficient in mini upgrade deployment like Bundles, Tax Updates, Patches and Tools Upgrade.
  • Proficient in developing, enhancing and retrofitting various PS objects, inbound and outbound interfaces using SQR, SQC, Application Engine and Component Interfaces, third party integrations(Java Integration with PeopleSoft system).
  • Extensive knowledge on Data conversion, Data mapping, Performance tuning, downstream interfaces, Online request handling, Change control, Version control and working with Third-Party systems.
  • Working Knowledge in Oracle Cloud HCM Projects especially in co-existence model with Peoplesoft
  • Maintaining and Scheduling Batch Jobs in Autosys and providing support through all the phases of development and implementation.
  • Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists User Profiles, Portal Security, Folders, Content References and Definition Security.
  • Efficient in coordinating with Business for productive solutions and in implementing workarounds.
  • Expertise in full Software development life cycle experience (Solution design to UAT including POST Production Support) with adequate technical competencies and methodologies like Agile, SCRUM, Waterfall SDLC methodologies.
  • Experience leading a team in a development and support environment.
  • Independently prepare functional designs, technical designs, code, documentation and review that meet the needs of complex business requirements and provide support for System and UAT testing, and supervise the work with other programmer analysts.
  • Strong knowledge and adherence to development standards (including testing and migration procedures) and implementing best practices.
  • Well versed in the Global Delivery Model for execution of projects involving onsite and offshore teams and in providing Knowledge Transfer sessions with clients and offshore team.
  • Self-motivated fast learner, diligent, hardworking and active team player with high analytical and problem solving skills and effective communication. Skilled in proactive identification and resolution of critical issues.
  • Demonstrated proficiency in leading and mentoring individuals to maximize productivity and forming cohesive team environment.

TECHNICAL SKILLS

  • Windows 7/8 /95/98/NT/XP/Vista
  • UNIX
  • Oracle 8i,9i, 10g,11g
  • MS SQL Server, IBM DB2, Microsoft Access, Oracle Cloud
  • PeopleSoft HRMS/HCM 8.0,8.4, 8.8,8.9,9,9.1,9.2
  • Core HR
  • North American Payroll
  • ELM
  • Base Benefits & Benefits Administration.
  • Time and Labor
  • Recruitment
  • Employee Self Service Modules ePay eBenefits
  • TAM
  • PeopleSoft Security
  • PeopleSoft account receivables
  • People Tools
  • Application Designer
  • PS-Query
  • People Code
  • App Engine
  • SQR
  • Component Interface
  • File layout
  • Excel to CI
  • Integration Broker
  • Work Flow
  • Process Scheduler
  • PeopleSoft Portal
  • WebServices,REST services
  • Process Scheduler
  • Clarify
  • Tree Manager
  • SQR
  • Crystal Reports
  • XML Publisher
  • PS Query
  • Crystal Reports nVision
  • BI Publisher

PROFESSIONAL EXPERIENCE

Confidential

Peoplesoft Technical Consultant

Responsibilities:

  • Understand the business requirement and prepare high level design and detailed designed documents.
  • Worked on customizations and enhancements in HCM/FSCM modules.
  • Production Support to HCM/FSCM modules.
  • Monitor various interfaces, both inbound/outbound from HCM/FSCM and fix in case of any issues.
  • Verify payroll data sent to ADP and report to business in case of any corrections needed.
  • Troubleshoot support issues to determine source of issue and the best approach for a resolution. Write SQL queries to research intermittent issues.
  • Modified IB error notification process to exclude given service operations from sending email notifications.
  • Worked on fixing errors on Advanced Shipment Receipts process in Purchasing.
  • Worked on Fluid pages for custom Manager Self service module.
  • Created custom purchase order close program to include activity date from the run control page.

Environment: PeopleSoft HRMS 9.2, People Tools 8.55.14, Windows NT,Oracle DB

Confidential

Peoplesoft Technical Consultant

Responsibilities:

  • Created custom module in PeopleSoft to capture hourly employees’ attendance incidents from time management system.
  • Created incident reports using BI publisher and sent these reports to FileNet using Integration Broker.
  • Created multiple integrations between PeopleSoft and third-party systems using IB/SFTP.
  • Created multiple tax reports using SQR which run on AIX.
  • Involved in Production Support and successfully resolved various issues related to payroll and HR by interacting with Users and the Business team.
  • Implemented Employee and Manager Self Service for Time & Labor,mPerformance & mPerks
  • Production support for more than 100 interfaces in/out of PeopleSoft.
  • Created and maintained custom Application Engine to send anniversary/birthday greetings to all employees.
  • Performed a lead role in Design, Implementation & Testing the custom Employee Self Service module.
  • Project co-ordination between customers and technical staff.
  • Worked on AWE in custom module for hiring employees into Peoplesoft.
  • Responsible for writing Test plan and Test Scripts for implementation HRMS modules
  • Conducted Test Coordination meetings with QA teams.
  • Design and review of Business Solution document, High level design and detailed designed documents.
  • Worked with Business users on gathering requirements, design, develop and deploy to production.
  • Created functional design specification documents and coordinating & conducting system integration, conversion, and user acceptance testing.
  • Estimate, plan, assign, assist and track development specific to business requirements.
  • Troubleshoot self-services Myinfo issues to determine source of issue and the best approach for a resolution.
  • Sending Monthly and Quaterly tax reports to all the states.
  • Run the Audit reports monthly and yearly and provided to third party Audit team.
  • Overtime Report: Developed a report to provide overtime details for a specific pay period.
  • Developed number of SQR Reports, PS Queries and other application customizations for fixing issues and new enhancements.
  • Worked on Integration Broker and Application Class PeopleCode, for automating the Enrollment/Maintenance process for re-hires and new hires.
  • Security related issues for the stores and performance issues.
  • Troubleshoot payroll processing issues to determine source of issue and the best approach for a resolution. Write SQL queries to research intermittent issues.
  • Running Contract pay and late pay after payroll process and involved in developing the customized payroll reports.
  • Fixed the setup issue with the Careers Page for the external Applicant. The link received by the external applicant in his email was not directing to the desired page in Recruiting.
  • Implemented Core Row Level and Department Security in the Benefits and Payroll Interfaces.
  • Scheduled the security processes to run on a nightly basis by using the “Job Definition” and “Schedule a Job Set” feature of PeopleSoft.
  • Developed custom SQR programs and modifications according to Confidential specific business requirements using Application Designer, Component Interface, PeopleCode, SQL, SQR, ExcelToCI, etc.
  • Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
  • Analyzing the custom functionalities in PeopleSoft.
  • Worked on Integration Broker created REST services for the integration of phone numbers in mPerks and team member appreciation cards using Application Class PeopleCode
  • Creating complex SQL to retrieve the data from different time systems.
  • Assign tasks to the offshore team and system test the offshore deliverables on Integrations.
  • Participate in weekly and monthly status reporting and governance meetings with the customer.
  • Involved in Production Support and join tech line calls to help resolve issues.
  • Open Service Requests with Oracle and assist the development team to solve existing issues
  • Arranged review meetings and discussed issues with developers and other team members and Implemented Software Development Life Cycle (SDLC) using Agile (scrum).

Environment: PeopleSoft HRMS 9.2, People Tools 8.55, Windows NT,Mainframes, UNIX, DB2.

Confidential, Houston, TX

Peoplesoft Technical Lead Consultant

Responsibilities:

  • Help in understanding the upgraded functionality with new online features and their setups to decide the Go\No - Go decisions with the new features and helping in upgrade activities.
  • Operational support includes like object comparison, migrations, data validation, data conversion, supporting upgrade change process, quality assurance of all development work, helping in understanding team on new functionalities.
  • Analyzing and identifying the impacted objects to decide retrofit or customize or retain the objects. The objects includes all kind of PS objects like PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs, Application Packages, style sheets and other type of objects.
  • Involved in consolidation of the business processes, which reside in PeopleSoft 9.1 instances, and support US operations and Global operations.
  • Involved in design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation
  • Studying current business processes and recommending future businesses with new advanced PS features.
  • Coordinating with users, onsite and offshore teams.
  • Analyzed the impact on current production environment and support their processes simultaneously
  • Carry out testing according to the test standards and procedures.
  • Deploying Tax updates, Bundles and other mandatory patches delivered by Oracle.
  • Extensively worked and given support to Payroll, ESS, MSS, HR users.
  • Worked with customers to analyze and resolve the Payroll related issue for multiple regions.
  • Provided 24x7 support including on-call support to customers resolving their priority issues.
  • Experience with Microsoft Service Manager for daily ticket resolutions.
  • Created SQR’s to pull applicant information from Taleo System (Recruiting Application) to Manager Hire process.
  • Used PeopleCode to control the program flow, logic and validation to meet the current business requirement. Written the PeopleCode in save edit, save post change, save pre change.
  • Resolved numerous Payroll, HR and custom modules production issues.
  • Assisted/Managed the technical team members during critical payroll runs at onsite.
  • Generate Reports for users and for Audit purpose.
  • To schedule the jobs and monitor the same.
  • To solve all the issues and request raise by business users.
  • Ensure that the Inbound and Outbound interfaces of the application are working fine
  • Assisted in analyzing various Production Issues pertaining to XML Publisher, Integration Broker, PS Queries, etc.

Environment: PeopleSoft HCM 9.1, People Tools 8.51, Oracle Database Application Designer, People code, Application Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, STATS, TOAD, XML Publisher, File Layout.

Confidential, Grand Rapids, MI

Peoplesoft Technical Consultant

Responsibilities:

  • Participating in project estimations, project plans, project plans review, discussion with users and providing inputs for enhancements.
  • Operational support includes like design, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation, object comparison, migrations, data validation, data conversion, quality assurance of all development work, training technical staff, training users on new functionalities.
  • Studying current business processes and recommending future businesses with new advanced PS features.
  • Working and retrofitting permission lists and roles.
  • Developing web services for the third party related operations based on new system functionalities.
  • Analyzing and identifying the impacted objects to decide solution approach. The objects includes all kind of PS objects like PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs, Application Packages, style sheets and other type of objects.
  • Developing minor SQRs, SQCs and other impacted processes.
  • Developing Oracle scripts to import and export data to different environments.
  • Performing Unit testing based on the test plans and providing support for functional, integration, system, performance and UAT testing process.
  • Testing end to end Client system functionalities.
  • Fixing the defects reported during System testing, UAT and production support.
  • Tracking and logging the defects identified and reported from QA, testers and users using Webstar tool.
  • Coordinating with users, onsite and offshore teams and scheduling the knowledge transfer sessions.
  • Working with Database team to proactively identifying the live performance issues in advance and helping the team to apply the fixes.
  • Working with Oracle to report and to get the fix or workarounds for various issues identified as part of defect fixing based on various severities.
  • Proactively communicating the expectations and limitations of the project and helping the team to reach the milestones as planned.
  • Interacting with users, BA team, QA team and development team to understand the limitations and enhancements and helping them to understand the best functionalities in achieving the business needs based on latest advancements.
  • Handled all the migrations between different environments through STAT tool and helped in audit reporting.
  • Helped users to test the system thoroughly and timely fixed the bugs before implementing the system.
  • Completed data conversion with minimal defects from old discipline system to new discipline system.
  • Was part of the entire cycle of system development and implementation and received client appreciations after the Go Live.

Environment: People Tools 8.49, HCM 8.9, Application Designer, People code, Application-Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, STATS, SQL Developer, XML Publisher, File Layout.

Confidential

Technical Consultant

Responsibilities:

  • project involves support of PeopleSoft modules Core HR, Benefits, Payroll Interface and Base Benefits at Confidential on PeopleSoft version of 8.0.
  • This includes smooth running of Payroll process every day, support the business during the open enrollment and enhancements to the existing functionalities as well as support the daily activities in PeopleSoft.
  • Worked on Application Engine, Component Interfaces, SQR and JCL.
  • Performance tuning of different processes which helped to peed up the production activities.
  • Converting all the record level audits to Database level triggers.
  • Studying current business processes and recommending future businesses with new advanced PS features.
  • Performing Unit testing based on the test plans and providing support for functional, integration, system, performance and UAT testing for defect free upgrade process.
  • Testing end to end Client system functionalities.
  • Fixing the defects reported during System testing and UAT.
  • Tracking and logging the defects identified and reported from testers and users.
  • Coordinating with users, onsite and offshore teams.
  • Providing support through all the phases of upgrade and preparing Go Live activities for applicable tasks.
  • Analyzed the impact on current production environment and support their processes simultaneously
  • Carry out testing according to the test standards and procedures.
  • Analyzing the issues and providing solutions within timelines as per support SLA.
  • Customized the Pay cycle Process- AP Module, for which got appreciation from Client.
  • Deploying Tax updates, Bundles and other mandatory patches delivered by Oracle.

Environment: People Tools 8.49, 8.51, FSCM 9.1, Application Designer, People code, Application Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, STATS, TOAD, XML Publisher, File Layout.

Confidential

PeopleSoft Consultant

Responsibilities:

  • Providing impact analysis, estimating the effort required and preparing technical documents based on functionalities
  • Preparing the design documents, developing the existing SQRs and processes
  • Requirements gathering, analyzing the business cases, responding to the critical production issues and leading the offshore team.
  • Played key role in Development and Testing of Interfaces, Online Customizations and data conversions using SQR, People Code, Application Engine and Component Interfaces for PeopleSoft HR module.
  • Extensively worked on Preparing Test scenarios and scripts and executing the test cases and code fixes.
  • Worked on critical Interfaces and tested the interfaces thoroughly.
  • Was part of data conversion team and developed batch programs to convert data from legacy system to Peoplesoft using application engine, file layouts and peoplecode.
  • Worked on Application Engine, Peoplecode and Component Interfaces, Inbound/Outbound Interfaces, SQR and queries.
  • Development of Online pages, customizing PeopleSoft objects and Unit testing and preparing the test cases.
  • Developing or enhancing App Engines and other online objects as per the business requirements.
  • Deploying Tax updates, Bundles and other Oracle delivered mandatory patches.
  • Developing or customizing Excel to CI for data load, PeopleSoft Menus, Components, Pages, Records, fields, Queries, Portal registry structures, PeopleCode, Process definitions, Message catalogs, Text Catalogs.
  • Provided support to fix the production issues in different areas like PeopleSoft Customers, Order Capture, Inventory and PS Security
  • Customizing the PS Security and providing required access to the people by assigning proper roles.
  • Understanding the Functional Specifications from the client and Preparing Technical Specification.
  • Developing the objects, Preparing Unit Test cases, preparing the Code review documents and reviewing the Code developed by fellow team members.
  • Involved in preparing Reports for Users using PS Query and XML Publisher.
  • Worked extensively on the People code.
  • Participated in team planning activities and training sessions.
  • Worked on interfaces and Mapping spec’s related concepts.
  • Played in critical part in migration of the projects from the development environment to other testing environments.
  • Reports-XML Publisher: Unified and Secured XML reporting for all reports through one module. Generating Reports and sending as Email to the customers.

Environment: PeopleSoft V8.4 and V9.0, Reports, Oracle 9i, People Tools 8.47 Application Designer, People code, Application Engine, Component Interface, Excel to CI, PS Query, SQL, Web Services, IB, TOAD, SQR, XML Publisher, File Layout

Confidential, MI USA

PeopleSoft HRMS Technical Analyst

Responsibilities:

  • Involved in detail design, development and testing .
  • Analyzing the SQR Code and People Code and retrofitting the same.
  • Analyzed requirements and applied customizations.
  • Performing unit testing and System Integration Testing
  • Created the Fields, Records, Pages, Components and Menus for customization as per the requirement.
  • Created new Permission list and Roles for the specific business rules.
  • Created and registered the Processes, associated permission lists and run SQR Program through PIA.
  • Involved in Scheduling the Batch Programs to run periodically through the Process Scheduler.
  • Developed Data Mover Scripts to move the data between the environments.
  • Developed Unix Shell Scripts to run the SQR, App Engine Programs and for FTP of the generated Outbound files.
  • Participated in migrating of project in different environments such as development, testing and production.
  • Involved in extensive Data validation using SQL queries and back-end testing..
  • Gathering requirements regarding the change specified by clients
  • Technical developer and directing the project teams in-terms of business processes, gathering requirements on Implementation and support process
  • Performing Fit-Gap analysis and Functional/Technical Design Documentations.
  • Created functional design document for Journal Edit load balancer
  • Performed configuration and setup for Allocations
  • Integration Broker extensively used for event management functionality in AP
  • Involved in PS Upgrade/Patches/Bundle Fixes/Compares and project Migration operations
  • Create application packages for handling the vouchers from 3rd party system that are loaded through integration broker
  • Experience in managing / troubleshooting Web Servers / Application Servers / Process Scheduler on UNIX as well as NT operating systems and involved configuring, monitoring and troubleshooting Integration Broker
  • Developing Various Interfaces/Batch process through App Engine, SQR programs and several online customizations through People code and Cis
  • Acted as key source of contact for current Production issue relating to all the system testing
  • Involved in integration testing and system testing. Developed Testing Scenarios. Troubleshoot and fixed bugs and errors as per client requirement after applying patches and bundles
  • Strong working experience on development of the technical Strategies and methodologies
  • Developed nVision reports for providing users with the extract of vouchers on a daily basis part in migration of the projects from the development environment to other testing environments.
  • Reports-XML Publisher: Unified and Secured XML reporting for all reports through one module. Generating Reports and sending as Email to the customers.

Environment: PeopleSoft 8.3/9.0, People Tools 8.49 People Code, App Engine, Component Interfaces, Integration Broker, SQR, Workflow, App Packages, XML Publisher, Crystal, Oracle, Remedy, Cybernation

Confidential

Technical Consultan

Responsibilities:

  • Trained employees at different levels in People Tools, SQR, design and development.
  • Designed, customized and developed various PeopleSoft custom applications with different organizations to meet their standards and respective requirements.
  • Involved in detail design, development, testing, conversions and modifications of the client as part of implementation.
  • Designed, developed and implemented various conversion/interface programs starting from extracting data from Oracle Applications, designing the Flat File Layout by conducting Field Mapping, Fit/Gap Analysis by understanding both the systems.
  • Developed programs using File Layout, Application Engine and People Code extensively for the Import and Export of flat files and XML files.
  • Created Various SQR Interfaces (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, Derive various values based on the data from the external system.
  • Designed, Developed various crystal reports across various modules for specific requirements.

Environment: PeopleSoft HRMS, Financials 8.4, People Tools, People Code, SR, Oracle 8i, Process Scheduler, Tree Manger, Unix Scripts, Security, Query Manager and Windows XP.

We'd love your feedback!