SUMMARY

• Seven years of experience in implementation, upgrade, writing interfaces and administration of PeopleSoft HRMS (Core HR, E - Performance, Payroll, Benefits, eRecruit, TAM, Manager Self Service, Employee Self Service, Time and Labor, Absence Management), PeopleSoft ELM.
• Extensive experience on PeopleSoft HCM (Absence Management, Core HR, Base Benefits Administration, Base Benefits, eBenefits, eCompensation, Variable Compensation, Employee / Manager Self-Service (ESS and MSS), ePerformance, Payroll, and Time & Labor.
• Strong Techno-Functional experience in PeopleSoft Financials 9.2, 8.8, 8.4, 8.3, 8.0, 7.5, 7.0 and Experience in analysis, design, and development and testing of various Peoplesoft modules such as GL, Order to Cash process, Purchase Order.
• Extensive Functional experience in Configuration and Customization in FI-GL, AR, AP, Bank Accounting, BCM, Treasury, Cash Management and experience.
• Experience in PeopleSoft ERP Implementation, Upgrade, Application Design, Development, Production Support and Migration Projects.
• Involved mostly in all upgrade activities in upgrading PeopleSoft SCM & Finance (AP, GL, PO, ePro) system from different versions of people soft (starting at people soft 7.0) to 9.2
• Establish Gaps as per Client requirements and develop Functional Specs required for necessary enhancements to the People soft functionality.
• Experience as a Functional Consultant/Business Analyst in PeopleSoft Financial and SCM Applications such as General Ledger, Commitment Control, Payables, Receivables, Asset Management, Billing, Project Costing, Purchase Order, Expenses, Contracts, Inventory and E-procurement.
• Involve in Configuration options and processes in PeopleSoft Receivables to make improved decisions about managing customers, payments and collections.
• Expertise in the Analysis (Fit-Gap), Design and Development of PeopleSoft Financials and SCM.
• Experience in analysis and documentation of various PeopleSoft Security measures.
• Worked on all phases of project life cycle starting from Implementation, upgrade testing and support & maintenance projects.
• Expertise in Payroll, Absence Management, Benefits, Benefits Admin, Global Payroll, Payroll Interface, Manager Self-Service (MSS) and Employee Self-service (ESS) module of PeopleSoft Suite of applications.
• Excellent experience in Data loading into Fusion HCM using HCM Data Loader(HDL) Tool which includes Workforce structure data, Worker data, Work relationship data and Salary info.
• Extensively worked on API's, Alerts, and RICE, Workflow, XML Publisher Reports, SQL Loader utility scripts, JAVA and PL/SQL for writing stored procedures, functions, reports and fast formulas
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
• Strong Experience in PeopleSoft Implementation, Project Management with Strong Background in System Development Life Cycle, Customization, Maintenance, Upgrade, Interfacing, Reporting, Data Conversion, Trouble-shooting, Performance Tuning and Production Support on the Benefits, eApps, HR, Payroll and Time & Labor modules.
• Conduct fit-gap sessions with HR, Pension, and Benefits business groups and gather business requirements for the Upgrade.
• Experience in Creating Reports and Analytics using OBIEE and ODI tools in HCM Cloud BI.
• Expertise in Configurations, Personalization, HCM Data loaders (HDL), Spreadsheet loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Absence Management and Payroll modules.
• Executed number of Full Implementations and conversions for PSFT HCM v9.0, v9.1 & v9.2 and ELM v9.2.
• Worked on the HCM Recruiting Solutions product suite comprises of Candidate Gateway (CG), Talent Acquisition Manager (TAM) and Resume Processing modules.
• Extensively used HCM Data Loader(HDL), File-based loader (FBL), Spreadsheet Loader and Payroll Batch Loader (PBL) for Migration/Data loading/Conversion of several business objects related to Core HR as well as Payroll modules.
• Expertise in coordinating and bridging gap between IT and business to exchange ideas, leading geographically dispersed teams to resolve issues and roll out innovative and strategic reporting roadmaps utilizing key performance Indicators (KPI's) and business performance metrics.
• Experience in designing, customizing and implementing PeopleSoft HCM Modules (Core HR, Base Benefits, Benefits Administration, NA Payroll, Payroll Interface, Time and Labor, Workforce Administration, Manage Competencies, ESS, MSS, Compensation) and PeopleSoft CRM(BORM/CDM), Support and Helpdesk.
• Excellent experience as a techno-functional consultant in PeopleTools such as XML Publisher, SQR's, Application Designer, Component Interface, PeopleCode, Page Designing, Application Engine, Component Interfaces, workflow, Application Package, Application Messaging, Integration Broker, Data Mover, Integration Broker Administration, and Application Security.
• Strong in SQL's. Extensively worked with SQR, PeopleSoft Query, Connected Query in creation and generation of organizational reports.

TECHNICAL SKILLS

ERP: Core HR, Payroll, Base Benefits, Benefits Administration, Time and Labor, Payroll Interface, Employee Self Service modules, General Ledger, Accounts Payables, Accounts Receivables, Purchasing, Inventory, Expenses, Resource Management, Projects, Budgets, Asset Management and Time Collection Devices (TCD), eSettlements, Business Planning & Budgeting, Treasury, Grants, Enterprise Performance Management (EPM)

PeopleTools: Application Designer, Application Engine, Application Package, Web Services, PeopleSoft Internet Architecture, PeopleSoft Upgrade, Process Scheduler, Workflow, Component Interfaces, Integration Broker, PeopleCode, Data Mover, PS/Query, Upgrade Assistant, xml Publisher, AWE.

Reporting Tools: SQR 3.x/4.x/6.0, Crystal Reports PS/nVision, OBIEE

Programming: PeopleCode, SQL, PL/SQL, C, C++, Visual Basic 6.0/7.0, HTML, XML, JavaScript, Java and VBScript

Database: Oracle 11g, 9.i/8.i/8, SQL Server MS Access

PROFESSIONAL EXPERIENCE

Sr. PeopleSoft Analyst

Confidential - Providence, RI

Responsibilities:

• Involved in the implementation and Production support of PeopleSoft 9.2 FSCM modules Accounts Payables, Inventory, Purchasing, Commitment Control, Contracts, Asset Management and GL Modules.
• Involved in the application upgrade from PeopleSoft FSCM 9.1 to 9.2.
• Configured the core financial requirements and new definitions as per business requirements.
• Worked on multiple Projects & Involved in the production & support and upgrade of HR/Benefits/Payroll, Time & Labor modules using PeopleSoft 9.2 and People tools 8.53
• Developed conversions programs to load Payroll and Benefit tables in PeopleSoft using SQR and Import manager and wrote a SQR programs to modify balances in Payroll.
• Involved in developing a roadmap for mapping the existing end-to end procure-to-pay processes onto the new PeopleSoft system.
• Implementation of Self-Service (eProfile and eProfile Manager Desktop), ePerformance, eCompensation and Position Management modules for EIS International Center PeopleSoft 8.9 system.
• Setup, configuration, testing and training in PeopleSoft Accounts Payables, Inventory, Purchasing modules. Involved in integrating PeopleSoft system with a 3rd party system using Web Services and Integration Broker.
• Set up the process scheduler job definition to link processes together. Setup Recurrence Definitions and batch processes.
• Performed full life cycle testing of Procure-to-Pay-AM processes to make sure that requisition is created, sourced into PO and the asset is pushed correctly from AP to AM.
• Provided documentation to the users on the processes such as Close Short Process, Return to Vendors, Procurement Contract Versioning etc.
• Document and manage defects and issues related to the testing of designed solutions in PeopleSoft Accounts Payables.
• Involved in writing and executing of Test cases pertaining to AP, PO and Accounts Receivables.
• Tested Accounts Payables module by running Pay Cycle Manager, Generating Checks etc.
• To evaluate performance, as well as a portal environment to support access by authorized internal and external users, use EPM tools.
• Supported Payroll (Payroll Administration - PaySheet, PayCalc and PayConfirm Processes) and worked on issues related to payroll.
• Analyzed current PeopleSoft system to design and configure 9.2 tables for HR, Benefits (Benefits Administration), ePerformance and Talent Management (Succession Planning).
• Delivered presentations on new functionality around the new PeopleSoft "Fluid" interface and Work center configuration for the Financials and Supply Chain modules.
• Involved in Journal Generating, Editing and Posting of Journals in the GL module.
• Worked on EDI Manager for Account Payable. Involved in data mapping and setting up of action codes and event codes.
• Integrated PeopleSoft Payables with Pay/Bill Management such that payable time information for contractors is sent from Pay/Bill to Payables and the Voucher Build process builds into vouchers.
• Worked on enhancements, customizations based on Service Requests by business users for PeopleSoft online objects and Non-PeopleSoft objects like SQRs.
• Set up Work List for AP Voucher Approval by Virtual Approve and customization of AP pages according to the user requirement.
• Automated the receiving of Electronic Invoices, creating vouchers and printing the checks for the participating vendors in AP module
• Designed and developed Workflow to Approve Voucher Payments from Expense Report based on the amount either to set the Voucher Status as Approved or to route to the appropriate Managers for Approval.
• Modified Accounts Payable pages to hide confidential information like Bank Account Number.
• Interfaced PeopleSoft Inventory and Purchasing transactions to mobile handheld devices to process PO receipts, inventory issues, stock transfers etc. in the stockroom.

PeopleSoft Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 9.1 and People tools 8.51
• Extensively worked on lot of Interfaces (In & Out bound) and Reports for converting data from AS400 system to PeopleSoft.
• Customized HR and Payroll menus, Inquiry pages, altered records, SQL View texts, People Code functions like SQL Exec, Scroll Select etc.
• Worked on setup of SetID table, Company Information, Define Establishments, Location, Department, Salary Grades, Job Codes and Pay Groups for the basic HRMS System.
• Retrofitted data from PeopleSoft 9.1 version to 9.2 for various modules like Core HR, Global Payroll and Self Service.
• Created SQR program to convert Entitlements, Takes, Adjustments and Leave Plan balances from Absence Management to Time & Labor
• Worked on customizing the built-in applicant tracking system delivered by Talent Acquisition Manager in the process of identifying and hiring talent quickly.
• Submitted absence requests on behalf of their employees, view current and projected absence balances for their employees and approve or deny absence requests.
• Enable plan participants to project pension benefits via the Internet by using PeopleSoft Enterprise e Benefits Self-Service Estimate Pension function.
• Involved in integration of pension data in a single database, store effective-dated employment history to track jobs, employment status, salaried or hourly status, union affiliation and more.
• Used Application Designer to create new pages to provide Graphical User Interface to the users, Search Views, Audit tables and to create menu.
• Used People Code to control the program flow logic and for the validation to meet the current business rules.
• Addressed major PeopleSoft functionality flaws including Amount Based approval routings and Expenses Header level department Approvals
• Customized the Time Admin process to post the Payable time to N.A Payroll before finalizing the Absence Management Process.
• Involved in the consolidation of the PeopleSoft HCM 9.2 (HR, Benefits and Benefits Administration & Payroll) modules based on organizational needs and requirements.
• Developed new Conversion SQR programs for flat file creation by mapping the fields between legacy (EIS and Tessaract) and PeopleSoft systems.
• Generated SQR reports to create summary reports on payroll details check and validate the data.
• Extensively worked on the Approval Workflow Engine (AWE) to provide capabilities for creating, running, and managing the approval processes.
• Involved in setting up the rules and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info changes etc. in collaborative applications.
• Executed unit test plans for medium complexity batch interface programs for eRecruit and Self-Service Modules.
• Set up the open enrollment system for the new employees and prepared the election analysis reports for the Open Enrollment Process.
• Upgraded PeopleSoft HRMS - HR, Payroll, Base Benefits.
• Developed test Strategy, test Plan, requirements traceability matrix, use cases, test scripts for system and regression testing of HR and Manager Self Service applications using Quality Center.
• Worked on PeopleSoft Integration Broker to develop messaging integrations which included configuring messaging systems and managing integration gateways.
• Developed Application Engine Program to Load the External Data into Temp Tables and from Temp Tables into PeopleSoft application tables.
• Conducted interactive sessions to transfer knowledge in People Tools, People Code and SQR to client employees.
• Maintained and updated the Department Tree and the Query Tree in the development database.
• Modified existing report formats and developed crystal reports using PS query.

PeopleSoft Analyst

Confidential - Raleigh, NC

Responsibilities:

• Involved in full software development life cycle including gathering requirements, fit-gap analysis, system configuration, testing, rollout, and post go-live support.
• Gathered client requirements and defined business processes for functionality within HR, Benefits, and Payroll.
• Put together functional specifications and worked with technical team as they did their technical design.
• Involved in production support and global rollout of the PeopleSoft system, conversion of employee population to PeopleSoft 9.0, conversion of the legacy retiree system to PeopleSoft
• Led company-wide requirements gathering and setup for all PeopleSoft system users, including creation of user profiles, roles, permission lists, department security tree, and query access manager.
• Wrote multiple end user reports, tested various inbound/outbound interfaces to vendors, and validated data conversion.
• Interacted and collaborated closely with business stakeholders to understand business needs as well as processes and data sources to translate the business requirements into effective Information System solutions.
• Created custom Component Interface programs to send Kronos absence data to PeopleSoft Absence Management.
• Acted as functional Lead for tasks including Core HR (Workforce Administration, Position Management, Succession Planning), Base Benefits, Benefits Administration, Payroll and Self-Service modules
• Responsible for hands on setup and configuration of PeopleSoft HR foundation tables, Base Benefit and Benefits Administration tables including Benefits Programs, Benefit Plans, Eligibility Rules and Payroll tables including pay groups, pay calendars, deductions, earnings codes etc.
• Led conversion/implementation team through defining business process, fit gap analysis, requirements gathering, and documentation.
• Assessed client's system, including business processes, configuration, and customizations, to advice and make decision on upgrade to PeopleSoft v9.2.
• Functional team lead for conversion of Lawson HRIS system to PeopleSoft HCM v9.2 system, including HR, Benefits, and Payroll modules.
• Managed the requirements gathering, setup and configuration changes, and testing for client's PeopleSoft system related to their annual benefits, open enrollment changes, including benefit programs, benefit plans, coverages, eligibility rules, event rules etc.
• Responsible for key deliverables including as-is business process, fit-gap analysis, to-be business process, functional specifications, security matrix, configuration workbook, test scripts, and training guides.
• Interacted and collaborated closely with business users to understand business needs, processes, interfaces, vendors, and data sources, to translate business requirements into effective HRIS solutions.
• Provided day to day reporting on HR, Benefits, Payroll, and Recruiting data and maintained programs and modules that support HR, Benefits, Payroll, and Recruiting.
• Responsible for production support as well as managing HRIS related projects, including conversion of data for acquired company and standardization of HR, Benefits, and Payroll data for multi entity organization.
• Led setup and conversion of PeopleSoft foundation/transaction tables, Base Benefit and Benefit Administration Tables, Payroll tables, user profiles etc.
• Led the building of interfaces to Benefits vendors, ACH and Positive Pay file for banks and GL.
• Led documentation concerning all HRIS project related work and activities including HR transactions, benefits administration and payroll calculation.
• Led client with all levels of testing including unit testing, systems integration testing, and UAT (User Acceptance Testing).
• Wrote multiple end user reports, tested various inbound/outbound interfaces to vendors, and validated data conversion.
• Completed all configurations and table setup for conversion of legacy retiree system employees to PeopleSoft, including foundation tables, HR tables, Benefits tables, Payroll tables etc.
• Monitored and maintained system to insure proper operation and data integrity, including data scrubbing/cleansing, tree maintenance, report maintenance, etc.

Business Analyst

Confidential

Responsibilities:

• Designing, coding and testing PeopleSoft Human Resource and Payroll modules.
• Involved in converting the general designs to detailed designs for PeopleSoft HR/Payroll products for custom reports and online PeopleSoft processes according to the client requirements.
• Involved in design and implementation of standard heading SQCs customized to suit client requirements for all the payroll-related reports for PeopleSoft.
• Analyzed the requirements for US Payroll, HR, Benefits, Benefits Administration, Time and Labor, Resource Management, epay, ebenefits, eperformance, eprofile, edesktop manager.
• Configured PeopleSoft Absence Management: Created schedules for part time and full time employees, entitlements and accruals for vacations, absences types (Leave of absence, unjustified, vacations, PTO). Defined rules for each absence type, entry, approval, and absence elements.
• Worked on detailed designs for HR module for retrieving the employee's historical data from Oracle Data Warehouse.
• Worked on Automatic Union Dues Set-Up utilizing PeopleTools and PeopleCode to in corporate new and complex validations.
• Involved with Business Process Analysis, Fit Analysis and Development Design to support expanding the Time and Labor functionality to implement schedules, automated overtime processing, leave tracking, interfacing to Project Costing and converting from Salaried/Monthly to Exception Hourly/Biweekly Payroll
• Developed many tax calculation reports like percentage of Tax variation from previous quarter current quarter. Federal and State tax reports.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared the Technical design specifications.
• Set up Workgroups, TRC's, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time & Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time & Labor.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over time.
• Developed data mover scripts to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.

Environment: PeopleSoft HCM (TAM, Profile Management, ePerformance, NA Payroll, T&L) v8.8/9.1, People Tools 8.52, AWE, IB, App Engine, Application Packages, Send Master, SOAP UI.