Payroll Consultant Resume
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.