We provide IT Staff Augmentation Services!

Payroll Consultant Resume

2.00/5 (Submit Your Rating)

St Louis, MissourI

SUMMARY

  • About 10 years of experience in PeopleSoft development, Upgrade and Production Support at various levels
  • Worked extensively on People Tools, PeopleSoft Application Designer, Application Packages, Component Interface, Workflow and Application Engine, Integration Broker.
  • Have good techno functional knowledge in Core HCM, Base Benefits, Time and Labour, NA Payroll and Self Service Modules.
  • Have had exposure to E Benefits and E Compensation as part of job.
  • Oracle PeopleSoft People Tools 1 and 2 certified expert.
  • Oracle PeopleSoft Enterprise 9 Human Resources Consultant certified expert.
  • Extensively used third party tools like Toad, SQL developer, Ultraedit, Notepad ++, PHIRE, DM Hummingbird etc..
  • Good experience in SDLC phases of the project i.e. Planning, Analysis, Design, Coding, Testing, Implementation and Maintenance with Strong Testing skills
  • Expertise in preparation of Business Requirements document, Technical Design document and Test plans to meet project - specific standards
  • Effective team player and ability to learn new skills/tools on demand and deliver excellently in short time. Self-motivated and enjoy working in a challenging environment.
  • Organized, highly motivated and goal-oriented individual with strong leadership capabilities.
  • Effective in work situations requiring an ability to manage multiple and concurrent projects and responsibilities.
  • Experience in managing multiple project single handily.
  • Experience of 7 end to end implementation of custom modules.
  • Support experience in SAAS applications like SuccessFactors, TALEO, SumTotal Learning Management System and VEMO.

TECHNICAL SKILLS

PeopleSoft Applications: HCM, HRMS, HRIS.

Modules: Base Benefits, Benefits Administration, Self Service, Core HR, NA Payroll, Time and Labor, E Recruitment.

Tools: People Tools, PeopleSoft Application Designer, Application Engine, Application Packages, Component Interface, Workflow, File Layout, Component Interface, Process Scheduler, Integration Broker.

Reporting Tools: SQR and PS-Query

Security Tools: PeopleSoft Security, Object Security, Query Security

Programming Languages: People Code, PL/SQL

RDBMS: Oracle 10g/ 9i

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential - St. Louis, Missouri

Payroll Consultant

Responsibilities:

  • Created a region table to define regions based on which payroll would be run.
  • Defined a global variable to contain the production database name, which would be used to separate actions that need to be performed in production from other instances.
  • Improved the performance of Employee PaySheet page by aggregating the Payline data.
  • Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.
  • Worked with the support team to fix issues coming in as a part of production support.
  • Advised customers on discrete business problems, formulates options including assessing their relative merits and risks, and works with customer(s) to determine the best solution.
  • Assist with maintenance and troubleshooting of scheduled processes.
  • Demonstrates expert understanding in all PeopleSoft HCM applications development processes, serving as a resource to others.
  • Supported all level of users within the company and in projects in a support mode
  • Coordinated and applied number Bundles & Patches to keep the system to latest patch.
  • Hands on experience on designing the new interfaces.
  • There was integration data coming in from PeopleSoft Time and Labor which had to be analyzed.
  • Worked on POC for the upgrade of Payroll, Core HR, Benefits Administration, ePay, eBenefits and other self-service modules.
  • Functionally analyzed and tested the interfaces.

Confidential

Developer/Project Lead

Responsibilities:

  • First level support of SAAS applications like TALEO, SuccessFactors, VEMO and SumTotal.
  • Established interfaces between PeopleSoft and SAAS Applications.
  • Coordinated requirement gathering.
  • Created technical design document
  • Integral part of Technical team providing support for development and support activities in PS HCM 9.0.
  • Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.
  • Understands changing business needs for the HR business areas supported and the subsequent impact on internal and external applications.
  • Perform fit/gap analysis and development for providing long term access solution to PS HR system for terminated associates.
  • Advises customers on discrete business problems, formulates options including assessing their relative merits and risks, and works with customer(s) to determine the best solution.
  • Assist with maintenance and troubleshooting of scheduled processes.
  • Demonstrates expert understanding in all Peoplesoft HCM applications development processes, serving as a resource to others.
  • Supported all level of users within the company and in projects in a support mode
  • Coordinated and applied number Bundles & Patches to keep the system to latest patch.
  • Provide end user training and direction for ad hoc data reporting and, as needed, develop reports using the PeopleSoft reporting toolset.
  • Hands on experience on designing the new interfaces.
  • Worked on integration broker to analyze synchronous data exchange as a part of custom drop server.
  • Gathered client's requirements from users and administrators about Benefit Programs, Plan Types, Benefit Plans, Rules and Rates and incorporated them into the system.
  • Worked on to interface data flow between the SAAS application and PeopleSoft modules like E Recruit and E Performance.

Confidential, Washington DC

Developer/Project Lead

Responsibilities:

  • End to end Implementation of new Hierarchy and Workflow process.
  • Automated the process both from the PeopleSoft page and using an SQR.
  • Ability to design, code, test, and install complex computer programs and customizations based on technical specifications
  • Requirement gathering from the Business People and transform those into Design of Data mart.
  • Analyzed the client business process and providing the necessary business solution to using PS delivered components and tools..
  • Participated in development of system test plans and acceptance criteria.
  • Work with functional users and IT team members on a routine basis to troubleshoot reported problems pertaining to application software. Also involved in formalizing plans for Parallel Testing.
  • Ability to diagnose & resolve PeopleSoft system relatederrors to ensure the accuracy of corporate business critical systems.
  • Provide all technical support during the implementation of new features and modules as needed.
  • Collaborate with customers and onsite/ offshore developers in order to execute projects through full lifecycle software development
  • Conducted Code Review for the Fit Gap done by the team members.
  • Proactively identifies risks and ways to mitigate
  • Acquires, monitors and uses client feedback
  • Designed and create the custom Open Enrolment worksheet for the employees. Number of outbound interfaces are developed using SQR program to transmit Benefits data to vendor.

Confidential

Developer/Project Lead

Responsibilities:

  • End to end Implementation of new Pension Portal Design.
  • Created back end tables which will be updated from the front end .net pages.
  • Integrated PeopleSoft with .net pages using the component interface by configuring the web service.
  • Primary task involved designing, effort estimation, building and testing of data migration programs
  • Helping team members resolve technical issues and training new team members
  • Regular reporting of team progress status to client Program Manager
  • Worked on Online Customizations using Application Designer
  • Adding local language translations to pages fields and content references during a local country roll-out
  • Building and maintaining Department Security Trees at the start of a data load cycle
  • Development of outbound interfaces using SQRs and automating SFTP to transfer output files onto target server
  • Maintaining Data Migration related Quality Documents, best practices and lessons learnt
  • Supporting Data Migration central team during the SIT, UAT and Go-Live phases during local country roll-outs
  • Ability to write operation manuals

Confidential

Developer/Project Lead

Responsibilities:

  • End to end Implementation interface between the World Bank and Confidential .
  • Automated the pension calculation process of transferred employees.
  • Created SQRs to exchange mail reports between Confidential and World Bank .
  • Maintain current PeopleSoft HRMS menus, pages, components, records, tables, & modifications and support upgrades as needed
  • Understand the Customer requirements from Onsite team and delivery of assigned work units
  • Worked on Online Customizations using Application Designer
  • Development and Customization of reports using SQR
  • Involved in Design, Build & Unit Testing stages
  • Development of Custom SQR to onboard the employees as non-Agilent workers.

Confidential

Developer/Project Lead

Responsibilities:

  • End to end Implementation of new Awards and Recognition System.
  • Created a page to enter departmental/ organization wide awards.
  • Created a page to allocate fund for various departments.
  • Created an SQR process to help pay the employees who got awards through off cycle payroll.
  • Customized MSS - Transactions(HR Online transaction -HROLT) and Worked as a Subject Matter Expert in MSS & ESS
  • Worked directly with Human Resources end users to provide 24x7 HR support
  • Lead Peoplesoft HR team and actively participated in ensuring the smooth business operations for the vendor.
  • Involved in estimation and planning along with Project Manager.
  • Working on online/batch enhancements using application designer
  • Perform System Setup activities to support business process changes and organizational realignments to maximize productivity of business
  • Security Administration Activities & Online Customization
  • Develop technical specifications to address new business requirements and involved in impact analysis when delivered object is customized.
  • Researched questions with respect to both maintenance and development activities and interacted with database administrators and business system users in this effort.
  • Development of new Pages/Components/Menu & changes to existing Business Functionality using PeopleTools.
  • Able to do performance tuning and knows how to troubleshoot and quickly resolve issues on pre-production support

Confidential

Developer/Project Lead

Responsibilities:

  • End to end Implementation Voluntary Savings Plan (VSP).
  • Simplified transfer of savings from the previous company to Confidential .
  • Created several SQR processes to transfer data between Confidential and WELLS FARGO who is Confidential ’s 401K vendor.
  • Developed understanding of Employees base benefits
  • Ability to design, code, test, and install complex computer programs and customizations based on technical specifications
  • Requirement gathering from the Business People and transform those into Design of Data mart.
  • Analyzed the client business process and providing the necessary business solution to using PS delivered components and tools..
  • Participated in development of system test plans and acceptance criteria.
  • Work with functional users and IT team members on a routine basis to troubleshoot reported problems pertaining to application software. Also involved in formalizing plans for Parallel Testing.
  • Ability to diagnose & resolve PeopleSoft system relatederrors to ensure the accuracy of corporate business critical systems.
  • Provide all technical support during the implementation of new features and modules as needed.
  • Collaborate with customers and onsite/ offshore developers in order to execute projects through full lifecycle software development
  • Conducted Code Review for the Fit Gap done by the team members.
  • Proactively identifies risks and ways to mitigate
  • Acquires, monitors and uses client feedback

Confidential

Developer/Project Lead

Responsibilities:

  • End to end Implementation of Medicare Part B which is an ideal part of medical insurance in Confidential .
  • Created several configuration and user data entry pages.
  • Ability to design, code, test, and install complex computer programs and customizations based on technical specifications
  • Requirement gathering from the Business People and transform those into Design of Data mart.
  • Analyzed the client business process and providing the necessary business solution to using PS delivered components and tools..
  • Participated in development of system test plans and acceptance criteria.
  • Work with functional users and IT team members on a routine basis to troubleshoot reported problems pertaining to application software. Also involved in formalizing plans for Parallel Testing.
  • Ability to diagnose & resolve PeopleSoft system relatederrors to ensure the accuracy of corporate business critical systems.
  • Provide all technical support during the implementation of new features and modules as needed.
  • Collaborate with customers and onsite/ offshore developers in order to execute projects through full lifecycle software development
  • Conducted Code Review for the Fit Gap done by the team members.
  • Proactively identifies risks and ways to mitigate
  • Acquires, monitors and uses client feedback
  • Designed and create the custom Open Enrolment worksheet for the employees. Number of outbound interfaces are developed using SQR program to transmit Benefits data to vendor.

Confidential

Developer/Project Lead

Responsibilities:

  • End to end Implementation of new RPA system.
  • Made self service easy for 18 transactions.
  • Created a Skelton tool which can be used to enhance RPA for more transactions.
  • Integral part of Technical team providing support for development and support activities in PS HCM 9.0.
  • Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.
  • Understands changing business needs for the HR business areas supported and the subsequent impact on internal and external applications.
  • Performed fit gap analysis and development for implementation custom solution for maintaining the Off-premise worker (OPW) data in PS HR.
  • Perform fit/gap analysis and development for providing long term access solution to PS HR system for terminated associates.
  • Advises customers on discrete business problems, formulates options including assessing their relative merits and risks, and works with customer(s) to determine the best solution.
  • Assist with maintenance and troubleshooting of scheduled processes.
  • Demonstrates expert understanding in all Peoplesoft HCM applications development processes, serving as a resource to others.
  • Coordinated and applied number Bundles & Patches to keep the system to latest patch.
  • Provide end user training and direction for ad hoc data reporting and, as needed, develop reports using the PeopleSoft reporting toolset.
  • Hands on experience on designing the new interfaces.

Confidential

Senior Software Developer

Responsibilities:

  • Involved in requirement gathering sessions with the HR Managers.
  • Prepared Fit-Gap documents for the Self service.
  • Prepared Technical Design documents for coordination with offshore team.
  • Working on enhancements rose as tickets in the maestro tool.
  • Involved in Batch monitoring using IBMs ECS WEB.
  • Created new SQRs and added them to the batch server.
  • Mapping the in and out dependencies for a process in the batch server.
  • Provided 24/ 7 support with utmost responsibility.
  • Dealt with major customization like tax updates for Canada.
  • Bringing in new logic to the program based the requirements filed in ticket.
  • Maintain current PeopleSoft HRMS menus, pages, components, records, tables, & modifications and support upgrades as needed
  • Understand the Customer requirements from Onsite team and delivery of assigned work units
  • Implementation of Real time notification to inform managers for Buddy assignment and their onboarding schedule.
  • Worked on Online Customizations using Application Designer
  • Development and Customization of reports using SQR
  • Involved in Design, Build & Unit Testing stages
  • Development of Custom SQR to onboard the employees as non-Agilent workers.

Confidential

Senior Software Developer

Responsibilities:

  • Worked on Approval Workflow Engine. Customized AWE for Full Time/ Part Time Authorizations and Promotions.
  • Analyzed the major Functional Specification Documents and created the impact analysis document, scope of project and assumption document.
  • Created a new page to manage probations.
  • Modified the Action Reason page to be dependent on Regulatory Regions.
  • Integral part of Technical team providing support for development and support activities in PS HCM 9.0.
  • Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.
  • Understands changing business needs for the HR business areas supported and the subsequent impact on internal and external applications.
  • Performed fit gap analysis and development for implementation custom solution for maintaining the Off-premise worker (OPW) data in PS HR.
  • Perform fit/gap analysis and development for providing long term access solution to PS HR system for terminated associates.
  • Advises customers on discrete business problems, formulates options including assessing their relative merits and risks, and works with customer(s) to determine the best solution.
  • Assist with maintenance and troubleshooting of scheduled processes.
  • Demonstrates expert understanding in all Peoplesoft HCM applications development processes, serving as a resource to others.
  • Supported all level of users within the company and in projects in a support mode
  • Coordinated and applied number Bundles & Patches to keep the system to latest patch.
  • Provide end user training and direction for ad hoc data reporting and, as needed, develop reports using the PeopleSoft reporting toolset.
  • Hands on experience on designing the new interfaces.

Confidential

Senior Software Developer

Responsibilities:

  • Involved in requirement gathering sessions with the HR Managers.
  • Prepared Fit-Gap documents for the Self service.
  • Prepared Technical Design documents for coordination with offshore team.
  • Working on enhancements rose as tickets in the maestro tool.
  • Involved in Batch monitoring using IBMs ECS WEB.
  • Created new SQRs and added them to the batch server.
  • Mapping the in and out dependencies for a process in the batch server.
  • Provided 24/ 7 support with utmost responsibility.
  • Dealt with major customization like tax updates for Canada.
  • Bringing in new logic to the program based the requirements filed in ticket.
  • Maintain current PeopleSoft HRMS menus, pages, components, records, tables, & modifications and support upgrades as needed
  • Understand the Customer requirements from Onsite team and delivery of assigned work units
  • Implementation of Real time notification to inform managers for Buddy assignment and their onboarding schedule.
  • Worked on Online Customizations using Application Designer
  • Development and Customization of reports using SQR
  • Involved in Design, Build & Unit Testing stages
  • Development of Custom SQR to onboard the employees as non-Agilent workers.

Confidential

Senior Software Developer

Responsibilities:

  • PeopleSoft HCM application upgrade from 8.3 to 8.9 to 9.0
  • Modified existing SQRs as per the customization request
  • Writing and modifying People Code for validations and manipulations
  • Created TDDs for the SQR those were to be developed.
  • Conducted the ‘Development Quality Testing’ for the retrofitted SQRs and Online Pages.
  • Develop conversion and/or load programs to support software upgrades, re-defined business processes and Integration of new businesses where necessary
  • Primary task involved designing, effort estimation, building and testing of data migration programs
  • Playing a Role in developing the Data Migration Strategy
  • Helping team members resolve technical issues and training new team members
  • Regular reporting of team progress status to client Program Manager
  • Worked on Online Customizations using Application Designer
  • Adding local language translations to pages fields and content references during a local country roll-out
  • Building and maintaining Department Security Trees at the start of a data load cycle
  • Development of outbound interfaces using SQRs and automating SFTP to transfer output files onto target server
  • Maintaining Data Migration related Quality Documents, best practices and lessons learnt
  • Supporting Data Migration central team during the SIT, UAT and Go-Live phases during local country roll-outs
  • Ability to write operation manuals

Confidential

Senior Software Developer

Responsibilities:

  • Modified existing SQRs. as per the customization request
  • Preparing Functional Spec’s and Technical documents.
  • Enhancements in SQR’s, New SQR programs for interface and reports.
  • Modified existing PS Queries based on customers request.
  • Develop conversion and/or load programs to support software upgrades, re-defined business processes and Integration of new businesses where necessary
  • Primary task involved designing, effort estimation, building and testing of data migration programs
  • Helping team members resolve technical issues and training new team members
  • Regular reporting of team progress status to client Program Manager
  • Developing and maintaining 45 interfaces (Bulk Load Processes - AE & CI) used during the migrations
  • Worked on Online Customizations using Application Designer
  • Adding local language translations to pages fields and content references during a local country roll-out
  • Building and maintaining Department Security Trees at the start of a data load cycle
  • Development of outbound interfaces using SQRs and automating SFTP to transfer output files onto target server
  • Maintaining Data Migration related Quality Documents, best practices and lessons learnt
  • Supporting Data Migration central team during the SIT, UAT and Go-Live phases during local country roll-outs
  • Ability to write operation manuals

Confidential

PeopleSoft Technical Analyst

Responsibilities:

  • Involved in preparation of Keep drop Analysis documents
  • Preparation & review of Upgrade documents related to the work product.
  • Running the CIS nightly batch run on a daily basis
  • Generation of Database Compare reports & queries.
  • Taking hot and cold backups of data base.
  • Involved in activities such as mapping the People Wise implementations into existing PeopleSoft modules.
  • Performing database refresh.
  • Implementation and proposal of Change Requests.
  • Migrating projects to different environments.
  • Involved in Batch monitoring as a part of Support work.
  • Worked directly with Human Resources end users to provide 24x7 HR support
  • Lead Peoplesoft HR team and actively participated in ensuring the smooth business operations for the vendor.
  • Involved in estimation and planning along with Project Manager.
  • Extensively worked on Core HRMS and client specific bolt-on modules
  • Working on online/batch enhancements using application designer
  • Perform System Setup activities to support business process changes and organizational realignments to maximize productivity of business
  • Lead and successfully implemented various bundles and patches on PS 8.9
  • Security Administration Activities & Online Customization
  • Develop technical specifications to address new business requirements and involved in impact analysis when delivered object is customized.
  • Researched questions with respect to both maintenance and development activities and interacted with database administrators and business system users in this effort.
  • Development of new Pages/Components/Menu & changes to existing Business Functionality using PeopleTools.
  • Able to do performance tuning and knows how to troubleshoot and quickly resolve issues on pre-production support

Confidential

Systems Developer

Responsibilities:

  • Implementation and proposal of Change Requests.
  • Preparation & review of Upgrade documents related to the work product.
  • Generation of Database Compare reports & queries.
  • Performing database refresh.
  • Migrating projects to different environments.
  • Involved in Batch monitoring as a part of Support work.
  • Performing database refresh.
  • Developed understanding of Employees base benefits
  • Ability to design, code, test, and install complex computer programs and customizations based on technical specifications
  • Requirement gathering from the Business People and transform those into Design of Data mart.
  • Analyzed the client business process and providing the necessary business solution to using PS delivered components and tools..
  • Participated in development of system test plans and acceptance criteria.
  • Work with functional users and IT team members on a routine basis to troubleshoot reported problems pertaining to application software. Also involved in formalizing plans for Parallel Testing.
  • Ability to diagnose & resolve PeopleSoft system relatederrors to ensure the accuracy of corporate business critical systems.
  • Provide all technical support during the implementation of new features and modules as needed.
  • Collaborate with customers and onsite/ offshore developers in order to execute projects through full lifecycle software development
  • Conducted Code Review for the Fit Gap done by the team members.
  • Proactively identifies risks and ways to mitigate
  • Acquires, monitors and uses client feedback
  • Designed and create the custom Open Enrolment worksheet for the employees.
  • Number of outbound interfaces are developed using SQR program to transmit Benefits data to vendor.

Confidential

Support Engineer

Responsibilities:

  • Megellan support included basic trouble shooting of issues related to their GPS devices.
  • Support was provided for Ad-Hoc map update.
  • PeopleSoft was used to enter and retrieve information about the customer.
  • Provide all technical support during the implementation of new features and modules as needed.
  • Collaborate with customers and onsite/ offshore developers in order to execute projects through full lifecycle software development
  • Conducted Code Review for the Fit Gap done by the team members.
  • Proactively identifies risks and ways to mitigate
  • Acquires, monitors and uses client feedback
  • Took effort to understand about the various modules of PeopleSoft used by Megellen.

We'd love your feedback!