Peoplesoft Techno - Functional Consultant Resume
New, JerseY
SUMMARY:
- PeopleSoft Techno - Functional Consultant with over 13 years of experience in System Analysis, design, development, testing, documentation, Implementation and Merger experience.
- Experience in ERP application development and customization using PeopleSoft HRMS 6.0, 7.0, 7.5x, 8.x, 9.x (Recruiting, Human Resources (all sub-modules), Base Benefits, Ben Admin, Time & Labor, Payroll, Commitment Accounting and Payroll Interface) and PeopleSoft Financials 6.0, 7.0, 7.5x, 8.x (Account Receivables, Account Payables, General Ledger, Expenses, Billing, Project Costing).
- Proficiency in Versions Upgrade .
- Thorough knowledge and hands-on experience with eApps which includes eRecruit, eRecruit Manager Desktop, Resume Processing, eBenefits, eCompensation, eCompensation Manager Desktop, eDevelopment, eProfile and ePay Modules and Kronos.
- Technically proficient in module design, interfacing, data conversion, Customizations, data mapping, upgrade, report writing and Tax updates.
- Experience in High-level Design, Detail Design and System Design.
TECHNICAL SKILLS:
OPERATING SYSTEMS: MS-DOS, WINDOWS 95/98/2000/XP/NT, UNIX (Sparc-Solaris, IBM-AIX)
LANGUAGES: PEOPLECODE, SQL, PL/SQL, PRO*C, COBOL, FORTRAN, PASCAL,VB Script, and JavaScript.
RDBMS: ORACLE 7.x/8.x/9i,10i, SQL SERVER 6.5/7.0/8.0/9.0 , INFORMIX
REPORTING TOOLS: SQR, PS/QUERY, N VISION, CRYSTAL REPORTS, XML.
ERP: PEOPLESOFT HRMS 6.0/7.0/7.5x/8.x/9.x (HRMS, Recruiting, HR, Payroll, Benefits, Time & Labour, Commitment Accoutning, Security Admin, Portal Pack, eApps - eRecruit, eRecruit Manager Desktop, Resume Processing, eBenefits, eCompensation etc.,), PEOPLETOOLS, PEOPLESOFT FINANCIALS 6.0/7.0/7.5/8. x (Account Receivables, Account Payables, General Ledger, Billing, Time & Expenses, Asset Management, Project Costing).
WEB TOOLS: HTML, DHTML, ASP, COM, DCOM, IIS, VISUAL INTERDEV.
RESOURCE MGT. TOOLS: ServiceSphere, Ascent. Citrix
PROFESSIONAL EXPERIENCE:
Confidential, New Jersey
Environment: Unix, PeopleSoft HR 9.1, Tools 8.50
Responsibilities:
- Worked as Rutgers Counterpart to Oracle team lead in implementation.
- Involved in data conversion during implementation.
- Primary contact for all HR, Payroll, T&L, Commitment accounting, Security issues during and post implementation.
- Involved in Payroll Parallel testing during implementation.
- Worked on payroll union dues Process that goes into the Paylines.
- Involved in PERS Calculation Process which is related to State employees Pensions.
- Educated users on various payroll, HR functionalities and trained them to use PSHUP etc.
- Made recommendations on T&L work group splits which improved Time Admin issues and performance.
- Debugged and fixed several T&L interfaces using integration broker.
- Stream lined several Payroll issues which resolved lot of Paycalc and Pay confirm issues which are related to Benefit and HR data issues.
- Modified/created several delivered processes to fit Rutgers needs like Paygl02, Benefits interfaces, T&L Interfaces etc (App engines, CIs, SQR and IB).
- Worked closely with users to make them understand the functionality and efficient use of the application includes HR, Ben Admin, T&L and Commitment Acctg..
- Worked on contract pay, retro pay functionality in HR and Payroll.
- Worked with complex payroll frequency scenarios switching of the frequencies and multiple jobs.
- Created new Version of Paygl02 to send daily retro distributions across to GL on daily basis.
- Also Customized the existing Paygl02 to create split files during the fiscal year end.
- Created Custom Processes Using App engines, CIs to create user profiles, Insert/Update Email addresses from IDM. And XML reports to identify the issues with User profiles.
- Created FICA Medicare process in Commitment Accounting to make the taxes and deductions distribute to the same fund sources as the Earnings instead of going to the suspense account.
- Created some complex Benefit interfaces like Common remitter interface to ING and other vendors.
- Responsible for Taxupdates, Bundles and other system related patches.
Confidential, New Jersey
Environment: NT, PeopleSoft HR 8.0sp1, Tools 8.19, HR8.9, Tools8.48 Oracle
Responsibilities:
- Lead Supporting Ver 8.9 HR, BenAdmin, NAPayroll.
- Worked on Pinnacle foods and birds eye foods Merger.
- Involved in Ver 8.9 upgrade from ver 8.0 sp1.
- Implemented ePay, eBenefits, eProfile, eRecruitment, ecompensation Manager Self service along with security which include LDAP for PS.
- Developed several custom work flows for self service and for work force Admin.
- Written Payroll to GL interfaces.
- Created Excel to CI Interfaces to load custom & PS tables.
- Written Kronos to PeopleSoft Interfaces to feed into Pay lines for 7 different Paygroups.
- Written PeopleSoft to Kronos Employee export interface from PeopleSoft.
- Responsible for Support of Kronos Workforce Connect and PeopleSoft Interfaces.
- Responsible for Production support of PeopleSoft NA Payroll and Asset Management Module.
- Responsible for applying all the tax updates since, installed and configured Change Assistant.
- Responsible for functionality testing and preparing W2 processing for 2008 and 2009.
- Written several Interface Programs to load Assets into Asset Management system for newly acquired company (Aurora Foods).
- Maintained all the Servers like App server, Process Scheduler and Web Servers for all the instances (Prod, Test, Dev and Demo) for HR and Finance modules.
- Written multiple Benefit Interfaces to vendors like BCBS, Active health etc.
- Responsible for Analyzing, setting up and testing of Pinnacles Disaster Recovery System.
Confidential, New Jersey
Environment: NT,Unix, PeopleSoft HR 8.8sp1, Tools 8.44, Oracle,DB2
Responsibilities:
- Performed in various roles from Project manager, technical team lead and hands on developer.
- Implemented HRMS, Base benefits, NA Payroll for exempt and Union Employees.
- Responsible for data mappings, conversion programs and implementation of the Garnishment, Savings bonds functionality from GEAC to PeopleSoft.
- As a Technical team lead led the responsibility of setting up the entire PeopleSoft infrastructure, recommended the instances management and was responsible for the work allotment and performance of the client’s team.
- Developed all the interfaces which included benefits interfaces, customizations, and about 120 reports.
- Prepared recommendations for process improvements in the area of HRMS, PeopleSoft delivered Processes, and Reports using PeopleSoft best practices.
- Developed a customized Process called NYDN Medill Process to track Union benefits and build exception time entry system to enter additional earnings, time for salaried employees.
- Responsible for leverage and migration of NYDN Dailywage a custom build application to track the Union employees’ time, rate and calculate their hourly wages, this is totally a customized Time & Labor Module.
- Customized Pay003, DDP003, Check recon Process and Reports associated with it.
- Developed Absentee tracking system in PeopleSoft to track employee’s leaves.
- Responsible for testing and implementing PeopleSoft Payroll Tax Updates.
- Involved in PeopleSoft Financials migration from DB2 to Oracle databases.
Confidential, Connecticut
Environment: Unix, PeopleSoft HR 8.0sp1, Tools 8.14, Oracle
Responsibilities:
- Served as technical team lead from the client side and managed three consultants.
- Implemented and supported Ben Admin, eBenefits, eRecruit, eProcurement and ePerformance management a customized application to track employees performance through out the year.
- Translated performance Management application into German, Spanish and French languages.
- Built PeopleSoft security for the entire company population to access eBenefits and ePerformance management.
- Modified User Profile Component Interface and other delivered App engine Programs.
- Implemented PeopleSoft Single sign on with Microsoft Active directory as the part of eBenefits, eRecruit roll out.
Confidential, Connecticut
Environment: Unix, PeopleSoft HR 8.3, Tools 8.16, Oracle
Responsibilities:
- Performed Production support for Confidential ’s North American and Canadian Payroll.
- Implemented eBenefits, ePay, eProfile also designed several Workflows.
- Extensively Used Various People tools like Import manager and Data mover.
- Analyzed and solved many Production support issues which includes data cleanup.
- Developed interfaces for Canadian Pay Progression.
- Developed interfaces from PeoplSoft HR to SAP Financials and Concurr T&E.
- Developed some dynamic sqr’s which can be run from Page giving dynamic criteria.
- Customized Pages, records and developed few Pages to make some reports dynamic.
Confidential, Columbus-OH and Dallas-TX
Environment: Win2k, Citrix, PeopleSoft8.3, Tools 8.16
Responsibilities:
- Team lead for eRecruit and Resume Processing Modules Implementation for Milgard Windows.
- Responsible for designing, fit gap analysis of Resume Processing, eRecruit and Recruit work force, and manager Self service Modules.
- Given client presentations about Resume Processing, eRecruit with prototype and on how these modules can fit their business.
- Responsible for setting up Mohomine for resume Processing, verity search engine for Applicant search.
- Setup delivered workflows and created some customized workflows to sent emails and work lists.
- Designed and developed Department security tree using tree manager.
Confidential, Dallas, TX
Environment: WinNT, Win2K, Winxp, MSSQL Server.
Responsibilities:
- In charge and responsible for the Confidential ’s Payroll Interface, Benefits, HR, Recruiting and T&E modules.
- Support their biweekly Payroll Interface, which includes smooth running of Payroll and sending the files to ADP.
- Involved in V.7.59 to V.8.3 Upgrade, did Compare reports, Applied Patches, did EDI-Component Interface Comparison etc.,
- Lead the HR team in IXL and Confidential Merger, which include Process designing, systems designing, Fit/Gap analysis, data mapping, data migration of their Ben, HR and Payroll data from Best Imperative system to PeopleSoft.
- Involved in the integration of Time & Expenses modules with other financial modules like Projects etc.
- Implemented eRecruit/ eRecruit Manager Desktop, eProfile / eProfile Manager ecustomizing and integrating with Recruit USA.
- Modified and supported the EDI Inbound and Outbound Processes.
- Also leaded some complex Projects like Revenue Margin Project which reflects the entire company’s Revenue and Profit Margin’s (for top mgt). The data is retrieved from various databases and various modules with in PeopleSoft Financials, HR.
- Wrote reports for Project costing, GL, AR, AP, BILLING and Projects using PS Query, SQR, Crystal and nvision.
- Developed some critical Reports in AR and AP like AR-Aging Reports, Positive Payment Reports. Guided Users through many support issues and trained them in certain areas like using and creating query report etc.,
Confidential, South Carolina
Environment: Unix (IBM AIX) O/S, Oracle (ver8.x)
Responsibilities:
- Involved in their PeopleSoft HRMS, Finanacial implementation.
- Responsible for laying out their reporting strategies.
- Responsible for setting up their HRMS (HR, Recruiting) tables.
- And tuned some of their SQR reports to accelerate their execution.
- Responsible for accelerating the execution of some nvision reports by creating a new tree structure to which many of their reports are d.
- And also developed few nvision reports like the Universities Trial-Balance and also customized some of their existing reports.
- Responsible for creating SUMMARY LEDGERS and accelerate their reports referencing them to summary Ledgers.
Confidential, CA
Senior PeopleSoft Consultant
Responsibilities:
- As a Confidential consultant, performed customization and implementation of the PeopleSoft HRMS (HR, Payroll and Benefits Administration) and Financials 7.0/7.5 (Accounts Receivable, Accounts Payable and General Ledger) for various clients in both a technical and functional capacity.
Confidential, Detroit, MI
Environment: WinNT, Oracle.
Responsibilities:
- Involved in data quality analysis and data clean up. Identified and reviewed a set of processes, analyzed the processes and the underlying data extensively using SQLTrace and Select Tool's ER Model. Recommendations made included data quality, performance tuning and design deficiencies.
- Developed conversion programs in the Accounts Receivable module from the organization's legacy database to PeopleSoft Financials 7.5.
- Modified and created new General Ledger reports according to organizational needs using PS Query and N Vision reporting tools.
- Created employee data security by creating Security Trees to grant or restrict user access to employee data information. And Created User manuals to use the system.
Confidential, Seattle, WA
Environment: WinNT, Oracle.
Responsibilities:
- Developed SQR reports for the Ben Admin, Payroll modules, as well as created some complex interface programs, which maintain Confidential Payroll Processing. The reports involved adding up before tax deductions and decoding the out-put in the pattern in which the SSga system reads.
Confidential, Chicago, IL
Environment: UNIX (Sparc-Solaris) O/S, Informix.
Responsibilities:
- Involved in setting up Benefit Administration and Payroll module Tables, which included setting up of Benefit Plans and appropriate payroll deductions. Created application scripts for the user manuals and trained users on application navigation. Modified Panels and Sub-panels in Payroll as and where needed. Developed SQR reports on the leave plans and depending eligibility rules.