Lead Peoplesoft Consultant Resume
Indianapolis, IndianA
SUMMARY:
- Over 10+ years of experience as a PeopleSoft Techno - Functional consultant and with advance Enterprise Integration, conversions and implement of various PeopleSoft HRMS applications. Strong experience in Module Development, Production/On-Call Support, Customizations, Change Enhancements in Reports, Interfaces,, Extensions and Workflow (AWE) using People Code, SQR s and People Tools 8.x respectively.
- Experience in Core HR, Base Benefits, Ben-Admin, eBenefits, North American Payroll, Time & Labor, ePerformance and Self-Service (ESS, MSS), Talent Acquisition Management, Compensation and Financial Billing, Contracts modules.
- Expertise in People Tools such as Application Designer, Component Interfaces and Application Engine, Integration Broker, Application Messages, Application Package, Web services, XML, SOAP, and Approval framework Engine.
- Extensively worked on ADP eTime Data Conversion programs using SQR for Core HR, Base Benefits, Compensation, paycheck, other earnings, deduction, and tax data from proposal to go-live phases.
- Good experience in documentation of functional/technical designs, code modifications, analyzing test results and providing support for System Integration Testing (SIT) and User Acceptance Testing (UAT) testing.
- Experience in interacting with users to analyze and create design documents for the implementation of new functionalities and Change Enhancement Requests as per business requirements.
- Good knowledge in trouble shooting Integration broker for synchronous and asynchronous messages
- Successfully implemented Integration between SharePoint and PeopleSoft system to expose core HRMS components to third party system using PeopleSoft Component based web services
- I was part of critical production support process, resolving various database & Application issues and helping business users during critical process runs.
- Lead secure File transfer architecture road maps, defined encryption techniques and implementations of pgp keys for sensitive file transfers.
- Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Cente
- Created various Inbound and Outbound interfaces using SQR s and Application Engine s to send and receive data from third party applications like ADP, Aetna etc...
- Understanding of the CMMI quality guidelines and as part of company process conducted Quality meetings such as defect prevention and preparing the documents like Trend Analysis.
- Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn and undertake challenging tasks
- Attentive to detail with a logical and analytical approach to solving complex problems and issues.
TECHNICAL SKILLS:
PeopleSoft Functional: Administer Work Force (AWF), Base Benefit, Time & Labor, NA Payroll, TAM, E-Performance, Absence Management, EPM, GL)
PeopleSoft Processes: Configuration/ Setup, Installation, Upgrade, Fixes/Bundles/maintenance Packs,, NA Tax udates and Open Enrolment
People Tools: App Designer, Application Engine, Component Interface, Excel to CI, Data Mover.PeopleCode, Process Scheduler and Approval Frame Work Engine (AWE).
Reporting Tools: SQR, PS Query, XML Publisher, Pivot Grid.
Databases: SQL Server 2005 / Oracle 8i, 9i, 10g, 11g.
Script Language: HTML, Java-Script, XML
Operating Systems: Windows 98/NT/XP, UNIX
Knowledge: Crystal Reports, JQuery
Office Tools: MS Project 2007
Other Technologies: C#, .Net, Ajax.
Other Tools: HP Quality Center, SNOW, UC4, FileZilla, Putty, PVCS, STAT
PROFESSIONAL EXPERIENCE:
Confidential, Indianapolis, Indiana
Lead PeopleSoft Consultant
Responsibilities:
- Involved in requirement & development meetings to understand NGS (National Government Service) project. This project maintains the labor distribution process and identify the distribute pay line adjustments and off-cycle payments if they involve earnings codes that are identified as requiring labor distribution. The goal of this project is to balance the Labor distribution between Confidential and NGS applications.
- Co-ordinate with offshore team on application monthly release work items.
- Leading a team of 10 associates and distribute the work items as per priority using RTC tool.
- Involved in Business and Functional requirement gathering and create FSD & TDD documents for all WI.
- Co-ordinate & follow-up with Business/Infra team regarding planned/unplanned PeopleSoft outage and major issues.
- Involved in PeopleSoft North American Payroll TAX update’s using PUM tool.
- Responsible and one point of contact for fixing PeopleSoft Production support issues raised in 'SNOW' within SLA and adhere process documentation as per the process.
- Daily process monitoring during payroll week and non-payroll week along with on-call support during non-working hours
- Involved in PeopleSoft migration using STAT 5.7.2
- Hands on experience in PeopleSoft Base Benefits, Time & Labor and NA Payroll modules.
- Closely work with Business team in requirement phase to understand complete end-end functionality for any small/large work items and provide proposed design along with LOE (Level of Estimates)
- Co-ordinate with BSA (Business system Analysis) team during SIT/UAT and address the issue to business with the help of offshore team till it closure.
Environment: PeopleSoft HCM 9.2, People Tools 8.54, Oracle 12, SNOW, UNIX, STAT 5.7.2, RTC Tool, Toad, Ipswich WS FTP, Ultra Edit.
Confidential, New Jersey
Sr PeopleSoft Technical Fuctional Consultant
Responsibilities:
- Perfomed the configuration and develop and customize template-based rules.
- Dealt with Union Retroactive rate increases, and calculated retro union rate increases.
- End to End implementation of Time and Labor rules
- Worked on PeopleSoft Payroll to ADP payroll conversion interface
- Extensively worked on eTime migration from PeopleSoft Time and Labor
- Hands on experince in capturing PS T&L business rules and help ADP team in designing IDD docs
- Worked on PS T&L to ADP eTime Conversion proprograms for schedule, shift, employees and Badge details for Parrallel and production run.
- Developed number of Interfaces and Data conversion using SQR, Application Engine.
- Also developed application engine which compares Payable time summary versus eTime summary and generate log files in excel format for review in parallel run
- Created Personal, Biographical and Payroll interfaces that should generate output files in excel and send them to ADP team during the conversion testing.
- Prepare application, technical & functional design documents as per the client's requirements
- Responsible for all kinds of reviews during ticket resolution and enhancements like design document review, People Code review.
- Estimating the change requests.
- Prepared Test Cases and executed Test Plans using Test Director as per the functionality.
- Migrated projects to different environments using STAT and used Application Designer for taking the compare reports.
- Involved in Development, UAT, Go Live Activities and Post production support.
- Modification & enhancement of existing reports and business process through People Code and PS Queries.
Environment: PeopleSoft HCM 9.0, People Tools 8.52/8.53, Oracle 11g, Remedy, UNIX, STAT 5.5
Confidential
Lead Technical Consultant
Responsibilities:
- Extensively worked on customisation of Recruitment module
- Extensively worked deliverd customisation on Recruitement module where JR creations has by passed upon requesting and different types of hiring request to offer accpeted stage along with complex multi level approval frame using Approval Work Flow (AWE)
- Developing technical specifications from functional requirements.
- Developed Application Engine programs using Component Interfaces and File Layouts to load data into PeopleSoft tables
- Involved in complex data upload such as Job data upload, personal data upload, dependents data information from legacy system to PeopleSoft using file layouts, application engine and Component Interfaces.
- Worked on Application Engine to convert SQR programs to AE programs and schedule them for Job process.
- Impletemted Component Interface(CI) for upload interface programs.
- Developed Complex reports with graph model & analytic representation of portfolio level data Reports
- Provided analysis and resolution for system defects identified during testing.
- Prepared Technical Design Documents, Coding & Code Review Documents, Unit Test & UAT Documents
Environment: PeopleSoft HCM 9.1, People Tools 8.51, Oracle 11g, HP Quality Center 9.0, UNIXConfidential
Sr. PeopleSoft Technical Consultant
Responsibilities:
- Worked extensively in retrofitting of fields, records, pages, components, application engines
- Involved in the development of conversion programs to load data from older version to the upgraded version.
- Provided analysis and resolution for system defects identified during testing.
- Extensively involved in unit / integration testing of the upgrade version after each upgrade pass
- Creating and Maintaining the user profiles and mass profile changes and supported the day to needs of the development and functional teams in different environments
- Ran System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
- Extensively involved in unit / integration testing of the upgrade version after each upgrade pass.
- Tested and validated the data conversion programs.
- Involved in setting up security using roles, permission lists, row level security and testing the security aspects.
- Preparation of Weekly status report for client update during the upgrade phase
Environment: PeopleSoft HCM 9.0, People Tools 8.54, UNIX, Oracle 10g
Confidential
Technical Consultant
Responsibilities:
- Understand business requirements and functional specifications and translate to technical solutions.
- Involved in the Design, Coding, and Unit Testing for all customization carried out as per the business rules.
- Worked on the production support issues for pay slips process.
- Worked on the customized App engine process to fix data load issue for Payee deduction page.
- Involved in Requirement Analysis & Design for Change Request.
- Interacting with Business and IT users to obtain the system details and to prepare the requirement specification
- Used Process Scheduler to Schedule the process at a specific time and run recursively on the server periodically.
- Extensively used PeopleCode for customization of pages and validating the data
- Developing customizations for enhancements and proper documentation (i.e. Technical specification, impact analysis and unit test cases).
- Review of the deliverables viz design, unit test cases and technical documents of other team members
- Constantly Interacting with offshore team to get the updates on the assigned workitems, deliverables and production support issues
- Coordinating with the team for resolving business critical issues.
- Design and Develop TSD and FSD and circulate among team members after getting sign-off from client
- Developed complex customized SQR Programs.
- Designed and developed inbound and outbound interface using SQR and Application engine.
- Responsible for deliverables from offshore team.
- Ensure to meet deadlines by the team as well as individual work item.
- High level Quality review updates to management in Senior Review meetings (SRM).
- SLA Reporting: Weekly status report and KPI report for monthly
Environment: PeopleSoft HCM - v9.0 and People Tools v8.48, SQR, Oracle 10 g, Process Scheduler.
Confidential
PeopleSoft HCM Developer
Responsibilities:
- The main objective of this project is to implement PeopleSoft HRMS 9.0 Application. Includes Rollouts, Business Solutions, Change Request and Global Payroll Implementation.
- Involved in Requirement Analysis & Design for rollouts (country specific)
- Completely involved in all phases of Germany Rollout like Scoping, Mapping, Functional & Technical Design, Regression Analysis, Configuration, Testing and Bug-fixing
- Worked on HRMS 9.0 setup’s & configuration as per business needs
- Developed processes including CI for mass uploads from external system to PeopleSoft System
- Responsible for analyzing system specifications and preparing Technical Design Documents and Unit Test Plans as per the requirement
- Design & Developed data conversion programs to facilitate data migration from legacy system to PeopleSoft Systems
- Performed bug fixing & enhancements during System Test & UAT
- Developed interactive reports using SQR
- Extensively involved in entire life cycle of project (PDLC & PMLC)
- Handled entire internal quality process
Environment: PeopleSoft HRMS 9.0, People Tools 8.48, OS-Windows 2003, UNIX, Oracle 10g
Confidential
PeopleSoft Developer
Responsibilities:
- Responsible for core HRMS enhancements and support.
- Analyzing the issues with the functional users and make sure for design/develop the root cause fixes.
- Developed interfaces, which will read the data from the external file and populate into db using file layout.
- Developed SQR process that reads data from PeopleSoft tables and creates a flat file that will, then be used as an input file for passing data to third party application.
- Developed many SQR’s including complicated interfaces and conversion reports using standard SQR methods like Break Logic, Load-Lookup, Arrays and Multiple reports and reusable programs like SQC’s.
- Creating process definitions and scheduled the custom/modified SQRs to the Process Scheduler.
- Coordinated with testing team at all levels of testing of the entire application functionality. And also fixed the issues related to the changed processes.
Environment: PeopleSoft HRMS 8.9, People Tools 8.48, OS-Windows 2003, DB-MS SQL server 2000
Confidential
PeopleSoft Developer
Responsibilities:
- Involved in design and requirement gathering for Core FSCM/HRMS enhancements
- Developed an Online Self Service application that takes text data and displays results in HTML format for personal use of the employees.
- Worked on customization in delivered functionality in different modules as per client needs which involves creating or changing objects like Records, Pages, Components, Menus, Application Engine and SQL Objects and was responsible in preparing Technical Specifications for every customization carried out & maintaining the activity sheet for project migration adhering client’s processes
- Converted crystal report billing process to sqr process
- Worked on Project Costing and Billing module extensively
- Played major role in organization restructure which involves impact analysis, writing SQL scripts & developed relevant reference documents
- Worked on performance tuning of both online and batch process
- Worked on solving production critical i s sues
Environment: PeopleSoft ESA 8.9 & HRMS 8.0, People Tools 8.15, OS-Windows NT, DB-Oracle 9i