Sr. Peoplesoft Consultant Resume Profile
Schenectady, NY
Personal Profile:
Sr. PeopleSoft Consultant, with over 20 years of experience in IT industry, which includes over 15 years of experience in PeopleSoft HCM/EPM/Financials doing requirements gathering, fit/gap analysis, design, configuration, implementation, upgrade, and support. Performed comprehensive project needs analysis of client requirements, and prepared design documentation Participated in all phases of the SDLC of the projects. Worked closely with cross-functional teams in successfully defining and delivering the customer's operational and strategic objectives Proven ability to work effectively in a fast-paced, shifting priorities, and deadline driven environment Excellent communication, leadership, organizational, presentation, and interpersonal skills Demonstrated ability to understand customer needs and manage expectations.
Skills Profile:
ERP: PeopleSoft HCM/HRMS 9.1/9.0/8.9/8.8/8.3/7.5/7.0 HR, Payroll, Base Benefits, Benefits Administration, Time Labor, Position Management, ESS, MSS, eProfile, ePay, eBenefits, eRecruit, ePerformance, eDevelopment, eLearn .
PeopleSoft EPM 9.0/8.9/8.8/8.3 Enterprise Performance Management, HCM warehouse, Financials warehouse, Business Planning/Budgeting Analytic Applications
PeopleSoft Financials V9.1/9.0/8.9/8.8 GL, AR, AP, AM, BI, eProcurement, Purchasing
Database: ORACLE 11g/10g/9i/8.0/7.0, DB2/UDB, MSSQL Server 7/2000, Sybase and MS Access
Languages: C , JAVA, XML, iScript, SQL, PL/SQL, SQR V8.8/8.18/6.x/4.3.2, ASP, HTML, COBOL, JCL, Unix and korn shell scripting
GUI: PeopleTools 8.52.x/8.51.x/8.48.x/8.46.x/8.16.x/7.5x/7.0x, Developer 2000
Reports: SQR, SQL, PS/Query, Crystal Reports, PS/nVision, MS Access.
OS: MS-DOS, Win XP/NT/2000/98, OS/390 and UNIX HP-Unix 11
Tools: Application Designer, Application Engine, Component Interface, Integration Broker, Data Mover, Tree Manager, Import Manager, Upgrade Assistant, Ascential DataStage 7.5.2/7.1, and Informatica PowerMart 7.1 ETL Tools, ERD, MS Visual Source Safe, Maestro/JSC, SQA Robot, ISTG, Control-M, Weblogic, Apache, Tuxedo.
Utilities: MS Visio, Stat 5.0, NIKU 6, TestDirector 7.6, ITG Kintana, TeamTrack, PlanView, SnagIt 6, Check Point VPN SecureClient, MS Office suite, IE 6.0, FTP, Lotus Notes, Golden, TOAD, SQL Navigator, Command Center, SQL Loader, MS Outlook.
Work Experience:
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM 9.1, PeopleTools 8.52.03, PeopleCode, Application Packages, AWE, Application Engine, Component Interface, Oracle 11g, PL/SQL, SQR, PS/Query, TOAD, CAPI, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant responsible for support of PeopleSoft HCM/HRMS 9.1 HR, Benefits Administration, Payroll, ESS .
- Responsible for fit/gap Analysis, design and development of a bolt-on application for Employee Family Services and to convert data from Ceridian into GE PeopleSoft HRMS system.
- Designed and developed a conversion strategy and mapping data elements from Ceridian into PeopleSoft.
- Analyzed the business requirements and created design documents.
- Responsible for analysis, design, troubleshooting and resolving several issues.
- Prepared test scripts for system testing, integration and user acceptance testing and involved system testing, integration testing, user acceptance testing closely worked with business team in resolving various testing issues and user training.
- Provide production support and resolving day to day issues.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM/HRMS 9.1, PeopleTools 8.52.03, PeopleCode, Application Packages, Component Interface, SQL Server 2008, SQR, PS/Query, Windows NT.
- Working as a Sr. PeopleSoft Consultant responsible for implementation of Time Labor, and Absence Management modules in PeopleSoft HCM/HRMS 9.1.
- Created Functional and Technical Design documents
- Provide support and resolve day to day issues in PeopleSoft HCM/HRMS 9.1 HR, Benefits Administration and NA Payroll modules .
- Worked closely with the business users and designed and developed inbound and outbound Fidelity interfaces
- Responsible for creating custom Time Labor rules to meet client's requirements.
- Setup new Benefit Plans and provide support for Open Enrollment 2014.
- Designed and customized eBenefits to meet client's retirements for Open Enrollment
- Created PS/Queries as per the requirements
- Created and executed test plans for Unit Testing, System Integration Testing, User Acceptance Testing and Parallel Testing.
- Comprehensively documented all the customizations made
- Provide functional and technical production support.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM 9.1/8.8, PeopleTools 8.52.03, PeopleCode, Application Packages, Component Interface, Oracle 11g, PL/SQL, SQR, PS/Query, TOAD, CAPI, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant responsible for upgrading PeopleSoft HCM/HRMS HR, Benefits Administration, Payroll, ESS from 8.8 to 9.1 by doing fit/gap analysis, design, testing and support.
- Responsible for Analysis, and design of a bolt-on application for brining in employee data from Acquisitions and Transitions into GE HRMS system.
- Analyzed the business requirements and created design documents
- Worked very closely with business users to understand their requirements and design solutions to meet them.
- Responsible for analysis, design, troubleshooting and resolving several issues.
- Created and executed test plans for Unit Testing, System Integration Testing and UAT testing.
- Created several reports using PS/Query as per business requirements
- Responsible for providing production support.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM 9.1/8.9, PeopleSoft Financials 9.1/8.9, PeopleTools 8.51.09, PeopleCode, Oracle 10g, PL/SQL, SQR, SQC, PS/Query, TOAD, STAT, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant responsible for upgrade of PeopleSoft HCM/HRMS HR, Benefits Administration, Time Labor, Payroll Interface, eProfile, eBenefits, ePerformance and eCompensation from 8.9 to 9.1 and PeopleSoft Financials GL, AR, AP, BI, eProcurement, Purchasing from 8.9 to 9.1 by doing fit/gap analysis, and design.
- Responsible for configuration, setup and enhancements of PeopleSoft HCM V9.1.
- Created Detail Design documents as per business requirements.
- Set up BenAdmin Events and Eligibility Rules in Benefits Administration.
- Responsible for setting up and configuration of the custom Elig Config fields.
- Customized eBenefits as per the client requirements.
- Customized Leave Accrual process as per the business needs.
- Provide support for 2011/2012 Open Enrollments.
- Responsible for design and development of various Benefits Interfaces.
- Setup Time and Labor Workgroups, Rules, Rule Programs and TRC Programs as part of the Dow Jones employees' integration project.
- Designed, and setup complex Time and Labor Rules as per the client requirements.
- Designed several custom Time and Labor Processes such as Holiday load, Employee Schedule load, Regular Hours load, Artemis Hours Load and etc.
- Designed and developed a process to extract customer's open items and identify if they are eligible for overdue charges and to calculate the overdue charges.
- Designed and developed several interface programs for PeopleSoft Fianancials
- Worked closely with business users in designing complex business applications.
- Created and executed test plans and test scripts for Unit Testing, System Integration Testing and UAT testing.
- Worked with DBA's on resolving performance issues by using explain plans, indexes, and stats for fine tuning the SQL's
- Responsible for providing production support of PeopleSoft HCM and Financials 9.1.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM 9.0, PeopleSoft EPM 9.0, PeopleSoft Financials 9.0, PeopleTools 8.49, Ascential DataStage 7.5.2, PeopleCode, Component Interface, Oracle 10g, Crystal Reports XI, PL/SQL, SQR, SQC, PS/Query, TOAD, Lotus Notes, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant responsible for implementation, enhancements and production support of PeopleSoft HCM/HRMS V9.0 HR, Benefits Administration, Time Labor, Payroll Interface, eProfile, eBenefits, ePerformance and eCompensation and PeopleSoft Financials 9.0 AR, AP, GL, AM, BI .
- Responsible for fit/gap analysis, troubleshooting, requirements gathering, implementation design, configuration, testing, and support.
- Responsible for fit/gap analysis, troubleshooting, requirements gathering, design, configuration, testing, and support.
- Expertise in resolving functional and technical issues related to HR, Benefits Administration and Time and Labor modules.
- Responsible for creating Functional Technical Design documents
- Responsible for setup of BenAdmin Events and Eligibility rules
- Set up and configured the custom Elig Config fields to meet client requirements.
- Worked closely with Benefits vendors such as BCBS, Kaiser, MetLife and VSP to troubleshoot and resolve various benefits outbound interface issues.
- Customized eBenefits as per the client requirements.
- Responsible for designing and implementing a customized solution for giving the business users the ability to make manual adjustments to employees Leave Accrual Balances.
- Designed and developed COBRA interface program to identify and send COBRA eligible employees information to the vendor as per their interface specification.
- Designed and developed several complex Application Engine programs to load inbound interfaces into PeopleSoft Components using Component Interface.
- Customized both Punch and Elapsed Timesheets to display Leave Balance information.
- Designed and developed custom Time and Labor Rules as per client requirements.
- Created a custom process to load leave hours taken to leave accruals.
- Designed and developer interfaces for PeopleSoft Financials 9.0
- Involved in troubleshooting issues related to Accounts Payable pay cycle process and bank recon process and lock box files.
- Responsible for production support of PeopleSoft HCM, Financials and EPM 9.0
- Designed and developed custom ETL maps using Ascential DataStage 7.5.2 for loading data into Financials warehouse.
- Designed and developed several reports using PS/Query as per business requirements.
- Created and executed test plans for unit testing, system testing, integration testing and UAT testing.
- Responsible for production support resolving several complex functional and technical issues.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft EPM 9.0, PeopleSoft HCM 9.0, PeopleTools 8.49, Change Assistant, Data Mover, Oracle 10g, Ascential DataStage ETL Tool 7.5.2, OBIEE 10.1.3.3.2, Hyperion 9, SQR, PS/Query, TOAD, SQL Developer, SSH Secure Shell 3.2.9, FootPrints, Oracle Calendar, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant responsible for implementing PeopleSoft EPM 9.0 and PeopleSoft HCM Warehouse.
- Participated in fit/gap analysis and worked closely with the business to understand their requirements and converted them into functional and technical designs.
- Performed comprehensive Systems Analysis, Systems Architecture and design to meet the customer requirements.
- Responsible for applying PeopleSoft EPM 9.0 Maintenance Packs - MP4 and MP5 - using Change Assistant.
- Worked very closely with functional and technical team members such as System Administrator, DBA and Business users to resolve several complex issues.
- Acted as a primary technical liaison with PeopleSoft to resolve several issues by logging cases with them using PeopleSoft Customer Connection.
- Responsible for Installation of Ascential DataStage 7.5.2 on UNIX Sun Solaris 9 platform, and configuration of database connections.
- Responsible for System testing and troubleshooting all PeopleSoft delivered ETL jobs
- Implemented PeopleSoft HCM Warehouse by extracting data from PeopleSoft HCM 9.0
- Responsible for loading all the OWS and MDW tables in PeopleSoft HCM Warehouse including Compensation Mart, Learning and Development Mart, Recruitment Mart, and Workforce Profile Mart.
- Implemented customized conformed dimensions to facilitate the use of conformed dimensions across multiple data warehouses.
- Created functional and technical design documents to meet the client requirements
- Customized delivered ETL jobs using Ascential DataStage 7.5.2
- Designed and developed several custom ETL jobs that use CRC Logic to extract the incremental load from source tables to migrate the data from UCB custom tables in PeopleSoft HCM 9.0 into PeopleSoft HCM warehouse.
- Analyzed and resolved several complex technical issues
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM 8.9, PeopleSoft EPM 8.9, PeopleTools 8.48, PeopleCode, Component Interface, Oracle 10g, Ascential DataStage ETL Tool 7.5.1, Crystal Reports XI, Control M, PL/SQL, SQR, PS/Query, TOAD, SQL Developer, SecureCRT, WinSCP, FileNet/Workplace, TeamTrack, Test Director, Crystal Reports, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant and a key member of the team responsible for the upgrade of PeopleSoft HCM from V8.8 to V8.9 and post upgrade responsible for the implementation of Competency Management, Enterprise Learning, eLearn, ePerformance, and eDevelopment modules as per the client's requirements.
- Responsible for interacting with business to understand their requirements and to create RSD's Requirements Solution Document and the DD's Detail Design Document to implement their requirements.
- Designed and developed several inbound and outbound interfaces as per the client requirements using Application Engine, SQR and PS/Query
- Developed custom bolt-on applications and customized several PS delivered applications to meet the user requirements
- Responsible for data conversion strategy, designing and developing data conversion programs for converting CNA Learning Management System Accenture data into PeopleSoft Enterprise Learning module.
- Created and executed test plans for unit testing, system testing, integration testing and UAT testing.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft HCM 8.9, PeopleTools 8.48, PeopleCode, Component Interface, Oracle 10g, PL/SQL, iScript, SQR, PS/Query, TOAD, Maestro/JSC, PVCS, Lotus Notes, Core FTP, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant, responsible for implementing post upgrade enhancements for HR, Payroll, Benefits Administration, eProfile, ePay, eBenefits modules in PeopleSoft HCM 8.9 system.
- Interacted with benefits vendors to gather requirements for HIPAA interface file.
- Setup new benefits vendors for the open enrollment
- Responsible for resolving several complex issues during open enrollment
- Analyzed business user requirements and implemented them by creating functional design documents
- Designed several inbound/outbound interfaces such as Minnesota Life Interface, Mellon interface, UPAS Partner Distribution statement, UPAS Control tables refresh interface
- Created test plans and test cases, and executed unit testing, system testing and UAT testing
- Analyzed and implemented several CR/IR - change requests and Incident requests
- Resolved several complex issues and provided end-user training.
Confidential
Sr. PeopleSoft Consultant
Environment: PeopleSoft EPM 8.9, PeopleSoft Financials 8.9, PeopleSoft HRMS 8.9, PeopleTools 8.48, Oracle 9i, DB/2, PL/SQL, PeopleCode, SQR, PS/Query, Ascential DataStage 7.5 ETL Tool, Informatica Power Center 7.1 ETL Tool, WebFocus 7.1, TOAD, AutoSys, TeamTrack, PlanView, Windows NT and Unix.
- Working as a Sr. PeopleSoft Consultant, responsible for analysis, design, development, troubleshooting, testing and supporting of PeopleSoft Applications.
- Responsible for development, troubleshooting and resolving several issues using PeopleTools, PeopleCode, Application Engine, Security Administrator, Tree Manager, Query Manager, Data Mover and SQR.
- Designed and developed several bolt-on applications using Application Designer including fields, records, pages, components and menus and security was implemented as per the business needs of the client.
- Responsible for doing enhancements and troubleshooting of HRMS warehouse, Financials warehouse, and Business Planning/Budgeting analytical applications
- Responsible for design and development of several ETL maps using Ascential DataStage 7.5.1 ETL tool to load Financials information - GL/AR/AP/AM - into GDW
- Created several Application Engine programs to meet client requirements
- Created several Jobstreams in PeopleSoft EPM
- Designed and developed custom ETL maps using Ascential DataStage 7.5.1.
- Designed developed several outbound feeds by setting up Meta data in PeopleSoft EPM.
- Designed and developed custom reporting, summary and dimension tables to support the management reporting requirements of the client.
- Designed and developed reports using WebFocus as per client requirements.
- Created and customized Unix korn shell scripts as per requirements
- Resolved several complex technical issues and participated in change control processes