PROFESSIONAL SUMMARY:

• 11+ years into full life cycle implementation and support of PeopleSoft HRMS solutions covering all major modules such as Talent Acquisition Manager/Candidate Gateway, ePerformance, Core Human Resources (workforce administration, workforce development, compensation/salary planning), NA payroll and Benefits Self Service applications such as eProfile/eProfile Manager Desktop.
• Excellent process orientation in performing project scoping, business process re - engineering, fit/gap analysis, requirements gathering, functional design, application configuration, user interactions, testing and production support.
• Good technical Knowledge of PeopleCode, Application Engine, Workflow, Component Interface, PSQuery, SQR, SQL, Integration Broker, XML Publisher, Application Messaging.
• Strong expertise in Quality Assurance as part of full life cycle implementations of PeopleSoft HCM suite with specific emphasis on creating system/integration/UAT test strategies, test plans, requirements traceability matrix; developing test cases/test scripts; performing functional testing; managing defects and preparing comprehensive test completion reports with test metrics.
• Strong implementation skills and high level of business process knowledge of PeopleSoft HCM 8.9, 9.0, 9.1 and 9.2 suites.
• Capable in identifying gaps between business and technology based on a comprehensive understanding of available and emerging technologies.
• Excellent troubleshooting, analytical, interpersonal, problem-solving skills & good understanding of business procedures and ability to work as an individual and also part of the team.
• Excellent team player with good interpersonal and communication skills

TECHNICAL SKILLS:

ERP: PeopleSoft HRMS 8.8, 8.9,9.1 and 9.2

Modules Worked: Core HR, Talent Acquisition Manager, ePerformance, NA Payroll, eBenefits, Ben Admin, e-Profile

People Tools: Application Designer, Appengine, Component Interface, Integration Broker, PeopleCode, SQR,BI Publisher

Reporting Tools: PSQuery, SQR, Crystal Reports

Database & Tools: Oracle, SQL, Toad, QuickR, Data Mover

Operating System: DOS, Windows 98/2000/NT/XP, UNIX

Domain Knowledge: Human Resources, Retail, Banking and Manufacturing

PROFESSIONAL EXPERIENCE:

Confidential, ME

PeopleSoft Technical Consultant

Responsibilities:

• Gathered and Defined requirements, overall scope definition in terms of functional & technical requirements, Gap-Fit analysis, data mapping, and customizations.
• Working on the data Conversion Of the payroll data from Legacy system
• Involved in the data conversion activities of core HR, Payroll, Base Benefits and Self Service data
• Developed the framework for generating payroll outbound interfaces for Harris county Payroll Vendors.
• Designed the framework design for generating payroll inbound interfaces for Harris county Payroll Vendors.
• Integration of HCM environment with Finance environments for the following data components
• Departments, Business Units, Bank data and Direct Deposit data
• Personal and Workforce data
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Worked on Application Engine Programs for Confidential and HRIS Premiums Interface.
• Worked on Fluid Pages for the pay checks and open enrollment related.
• Worked on BI publisher to for generating Enrollment and Confirmation statements.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process

Techno Functional Consultant

Responsibilities:

• Involved in Issue solving day-to-day production Issues and checking the process.
• Supported payroll processing whenever help needed from functional team.
• Worked with functional analysts and collected data requirements for Conversion and Interface programs.
• Involved in regular team meetings to device strategies for smooth Data Conversion process flow.
• Customized PeopleSoft login page (signin.html) to in corporate logo and custom help-text for employees.
• Involved in mapping legacy data structures fields into PeopleSoft data tables.
• Developed and modified several SQR processes for inbound and outbound interfaces.
• Worked closely with end users and business analysts to understand client functional requirements and designed technical specifications.
• Updated the BI/XML reports for Interface control report to pre-check the validated data from all the interfaces.
• Worked on PeopleSoft HR 9.1 to 9.2 Upgrade Project.
• Working in Post Upgrade Production support/Development team - worked on Support and also development of new functionality and customization’s.
• Comparing and reporting the source and target databases, finding out previous customizations and including further customizations according to the client requirements.
• Applied customizations on copy of production, based on the actions set by analyzing the compare reports and also participated in different customizations.
• Involved in Retrofitting customizations and resolve issues logged as part of PeopleSoft HR upgrade project.
• Performance tuning of many PeopleSoft processes, during and after Upgrade.
• Involved in the Canvas Integration through Integration Broker.
• Analyzed compare reports to identify customizations that need to be re applied to 9.2/8.55
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications
• Ran various error reports PAY036, PAY010, PAY011 to analyze pay sheet records audit prior to pay confirm process and to find out employees not processed in current payroll and to trouble shoot payroll error messages for employees.
• Issues created during User Profile Creation process were corrected using ExcelToCI Template load.
• Debugged Application engine traces and log files for resolving problems in Application Engine programs.
• Installed Portal packs and setup of Self service applications.
• Worked on PS-Query, Application Engine, Integration Broker setup, Component Interfaces (EXCEL to CI), File Layout.
• Involved in developing Payroll to GL interface.
• Involved in solving error messages while sending data to GL interface, by looking back to the data being published.

Techno Functional Consultant

Responsibilities:

• Involved in Fine Tuning of Database Tables, which are used in Data Conversion.
• Worked on workflow notification for position request and position change request on title change and department change.
• Involved in Data Conversion for payroll from external system using SQR and Application Engine.
• PeopleSoft HCM upgrade from 8.9 to 9.2 for Core HR, Benefits, Ben Admin, NA Payroll, Taleo
• Analyzed compare reports to identify customizations that need to be re applied to 9.2/8.53.
• Involved in Unit testing and system testing for the customizations and processes.
• Involved in the PeopleSoft Upgrade from 8.9 to 9.2 HCM in 2014-15
• Documented table structure setup, modification of the Workflow process for daily event processing, Open Enrollment functionality and strategy for Data conversions.
• Created design specs so that additional functionality can be added to the Maintain Job Activity workflow to suit the business process.
• Involved in Data mapping between the two systems.
• Worked on implementing workflow to route the employee information to the HR manager when the employee is transferred from one agency to another agency.
• Lead the enhancements for Open enrollment 2015 in HEB
• Working for H.E. Butt Grocery Inc client in the UNIX/Linux/PeopleSoft Production Support project as Technical Lead. As a Production Support expert, responsible for ensuring compliancy to technical processes.
• Lead implementing HEB's Online Open Enrollment that went live in 2009 and Online Event maintenance in 2012. Highly customized online OE and event maintenance through PeopleSoft.
• Responsible for coming up with the design and details for the bolt-on Benefit Customization to meet HEB’s procedures for handling Event maintenance and Open Enrolment. Partners can make their enrollment by calling Customer Service or through Self Service themselves. Customer Service can perform the enrollment on behalf of the Partner in the same as a Partner does. This is a feather in the cap. Oracle and PwC (Vendor who performed 9.2 Upgrade) were surprised by it.
• Handled Open Enrollment data conversion from 8.9 environment to 9.2 without any elections impacted.
• Responsible for yearly changes related to Total Rewards Statement, Low hour letters, Weekly Benefit Eligible changes, Company Match and 401K related changes, Annual leave accruals, deleting the carry over leave accruals through automation.
• Handled maintenance tasks such as applying maintenance packs, People Tools Upgrade, Tax Update from time to time during the year.
• Worked on BI Publisher to generate the reports.
• Developed a custom GL Interface program from PeopleSoft to financial system using an SQR.
• Developed the custom process to enroll the employees into Benefits.
• Developed various reports for Payroll and Benefits using an SQR.
• Annual run for their EEO report/W2/IRS reports
• Worked on several changes on the benefit interfaces with different Vendors like BCBS, Ceridian, Vision, Dental etc. interfaces.
• Involved the generation of W2 for the employees for the year 2014 and fixed the issues.
• Worked on View Paycheck functionality in HCM 8.9 so as to show up the PDF paychecks online in Self-Service
• Modified Print Paychecks (PAY003) and Create Direct Deposits (DDP003) processes to enable the PDF paychecks
• Developed a new Employee Self Service Home Page so as to group the personal and job info of employees in a logical manner. The new page was the single point of contact for all the self-service transactions including Personal Information, Payroll Information and Time Reporting Info.
• Developed a new Manager Self Service Home Page to group all the employee-related information in a single page. The new page had links to direct the managers to various pages including Personal and Job Information, Approve Time, Compensation History
• Created new Interface for Yearly Turkey Coupon data from PeopleSoft.
• Handle On-Call Production Support Schedule
• Work closely with Business in getting the requirements for future enhancements and translating it into required design with appropriate timelines to achieve the same through the development and testing
• Retrofitted several objects as part upgrade from 8.9 to 9.2.
• HEB PAN Form Administration is a custom bolt on which is one point of data entry to handle the employee information. This has CI’s invoked to handle creation/updating and correction of job and person related details. This was a major challenge when it was upgraded to 9.2.
• Worked on several changes on the benefit interfaces with different Vendors like BCBS, Ceridian, Vision, Dental etc. interfaces.
• Developed an application engine which sends out an XML file to the vendor system
• Customized various SQRs which deals with putting/getting files to/from FTP servers hosted by third-party vendors
• Customized the Peoplecode to send out confirmation mails to Employee when changes were effected on Direct Deposit and W4.
• Solely responsible for the Unit Testing and QA Testing for the deliverables.
• Came up with Test Plan and Test Case documents for the QA and Unit Testing.
• Developed Detailed Technical Design Documents for all the customizations.
• Extensively coordinated with the business for executing UAT.
• Successful mentoring and knowledge transition to the new resources brought on-board.
• Setup and Configured Integration Broker and trusted nodes for PeopleSoft single sign on
• Performed Configuration, Testing using PS Query for Core HR, Payroll, T&L, Benefits, and Payroll.
• Designed pages for the Benefits Administration, a new benefit plan for workers, Earnings, Deductions, Benefit plans, Benefit programs, Coverage, Coverage codes, Eligibility codes were configured. Coverage and coverage codes for union & non-union workers were different.
• Project co-ordination between customers and technical staff.
• Configured Delivered messages between HR and Financials delivered such as person basic sync, workforce sync, jobcode sync, location sync Using Integration Broker
• Near real-time validation using an asynchronous message (XML over HTTP and PSFT)
• Configured appropriate objects and used people code to achieve the functionality.
• Excellent skills in tracing and troubleshooting the people code and Application engine

Technical Consultant

Responsibilities:

• Worked for UST Global client in the PeopleSoft HRM implementation as a team member.
• Involved in requirement Gathering for eRecruit, Talent Acquisition, Candidate Gateway.
• Responsible for setting up eRecruit, Talent Acquisition, Candidate Gateway for recruiting process.
• Worked on testing PeopleSoft ePerformance module customizations for employee
• Performance reviews.
• Designed screens for the Talent Acquisition, Candidate Gateway, eRecruit for End Users
• Performed research and study of the existing system tables and business processes. Also involved in the in - depth study of the customizations made in the HR, e Recruit.
• Identified all the Business Process, Desktop reports and evaluated the required Business processes /reports in Core HR, eRecruit, Talent Acquisition, Candidate Gateway
• Customization of reports & interfaces. Involved in Implementation and Customization of employee self-service (ESS) modules such as eRecruit and eProfile.
• Effectively communicated with business users, functional and technical team also built solid technical specifications.
• Project co-ordination between customers and technical staff.
• Prepared presentation scripts illustrating system functionality for the Firms system owners and decision makers.
• Executed unit test plans for medium complexity batch interface programs for eRecruit, Talent Acquisition, Candidate Gateway
• Conducted Test Coordination meetings with QA teams.
• Focal point between development resources and design team ensuring consistent interpretation of requirements.
• Loaded setup data using Excel to CI.
• Worked on enhancements and modifications to the custom built Online objects and SQR reports
• Created Quality assurance plan for post go live usage. Created all testing, training and end user documentation for HRMS
• Working with customers to analyze and design systems functionality to meet business requirements.
• Involved in customizing existing People Code based on Client s functional requirements
• Modify inbound and outbound SQR interfaces to change the file format based on the Vendor s new file format requirements
• Design & Define Business logic, Process Flows of Future Mode system
• Involved in Work shop Session to Finalize Selected Solutions of Functional Requirement.
• Provide estimates for upcoming tasks and give details of deviation from original vs Actuals
• Configured and customized the Job Openings (JO) functionality.
• Post the Job Openings externally.
• Designed an outbound interface with appengine/CI to post the JOs externally.
• Designed an inbound interface with appengine/CI to load the applied applicant data back to PeopleSoft