SUMMARY:

• A PeopleSoft Techno - Functional consultant is seeking assignment with the organization of repute to play a long term role in a team deploying my skills and expertise for ERP maintenance / upgrade / implementation project.
• Overall 14 Years of experience in IT - ERP - PeopleSoft HRMS/HCM.
• 5 years of vital experience as lead consultant providing PeopleSoft application support to leading healthcare firm in US.
• Had been a key resource in PeopleSoft HCM implementation/upgrade/maintenance projects.
• Involved in System Design, Development, Consulting, Database maintenance and implementation of HRMS/HCM product.
• Involved in Analysis, design, development and implementation of value addition tools to the business using PeopleTools and Oracle database viz. Security Compliance - Data Scrambler, Application system Table Conversion.
• Successful implementation of third party interface for HR and payroll data for Affordable Care Act (ACA) project within a short span of time.
• Setting up new templates, rating model and custom signatures in ePerformance module for the business requirement to have multiple performance evaluation for employee and leader evaluation.
• Designed and developed complex portal pages in PeopleSoft that are to be used predominantly by Physician Doctors with ease and comfort.
• Provided design proposals and developed physician year end statements like 1099, 1098 automation using PeopleSoft XML publisher.
• Effectively managed development team to meet project timelines during all phases from design to deployment for PeopleSoft upgrade project.
• Automated the system analysis and conversion process for Onelink project considerably reducing manual effort and man hours.
• Nominated for Confidential technical excellence award.
• PeopleSoft Techno-Functional Consultant with extensive experience on Human Capital Management for 14 years.
• Provide design documents and translate into component-level designs to accelerate development.
• Provide design expertise in support of development team efforts to provide flexible reusable components to increase cost effectiveness.
• Analyze, design and review design of applications to ensure that customer specifications are satisfied.
• Develop and provide technical documentation; participate and oversee test-plan development, integration and deployment.
• Participate in business process work sessions, project meetings and joint applications development sessions.
• Provide leadership and work guidance to less experienced personnel.
• Guide the work of less experienced developers to ensure that application development are according to business specifications.
• Function as a domain expert and work closely with software developers to explain the application design.
• Coordinate offshore activities to enhance product quality and efficiency.
• Utilize experience in development and testing methodologies to adhere SDLC quality standards.
• Ensure SOX compliance for documentations of technical design, Unit Test Plan, Unit Test Results, UAT approval and production migration.
• Extensively worked developing HR and Benefits modules and supporting physician system for North America payroll.
• Played a vital role in PeopleSoft HRMS 8.3 implementation, PeopleSoft 8.3 to HCM 8.9 upgrade and HCM 8.9 to 9.1 upgrade.
• Has developed complex SQRs for the implementation of Benefit Administration Modules for Open Enrollment and Event Maintenance.
• Experienced as a key resource in PeopleSoft Upgrade and Implementation Projects developing custom tools for impact analysis, performance tuning and data reconciliation.
• Has done conversion and customization for implementing multiple job concepts.
• Has extensively used PeopleSoft Tools viz. Application designer, Application Engine, PSQuery to develop new pages, components and processes for complex business applications.
• Used Integration Broker to consume web service using REST protocol from external third party vendor.
• Maintaining daily activities related to HR, Time & Labor, Benefit and Payroll Business Functions.
• Tracking and maintaining of Employee’s company, compensation and other critical changes.
• Has used XML Publisher to develop custom reports that required redundant code for formatting in legacy SQR programs.
• Has done designing and development for custom modules in HR, Payroll, Time and Labor, Compensation, Benefits Administration and Workforce Administration.
• Support System/User Acceptance Testing.

TECHNICAL SUMMARY:

Languages: PeopleCode, SQR, Java, HTML

ERP: PeopleSoft HCM 9.2, 9.1,8.9, PeopleSoft HRMS 8.3

Software: Microsoft Office

Technologies: ERP, OOPS

Operating Systems: Windows 2000 Professional, NT, XP, UNIX

Tools: PeopleTools 8.47, 8.49, 8.52, 8.53, 8.54, 8.55, XML Publisher, STAT, Win SCP, WS FTP, Putty, Beyond Compare, SQRW, TOAD, SQL Developer, SQL Plus

Databases: Oracle 11g, 9i, DB2, PL/SQL

Scripting: Iscript, JavaScript, VBScript

Industries: HRMS, HCM

PEOPLESOFT EXPERTISE:

Development Tools: Application Designer, PeopleCode (Using Row set concepts, handling data with XML read/write, Style Sheets, File Read/Write through File Layout, Exception handling with Message Catalogs, etc) and Process Scheduler

Data Management Tools: Application Engine, Application Message (Message Channels, Data Manipulation with CI in Subscription people code), Component Interface, SQR (Building inbound / outbound interfaces from/to third party) and Data Mover

Administration Tools: Security Administrator (Maintain Security - Permission lists, Roles, User Profile)

Reporting Tools: PS Query, XML Publisher, SQR

HCM Modules: Workforce Administration, North America Payroll, Benefits Administration, Base Benefits, ePerformance

ENGAGEMENT OVERVIEW:

Lead PeopleSoft Consultant

Confidential, Pasadena, CA

Technology: PeopleSoft HCM versions 9.1, PeopleTools versions 8.51, 8.53, 8.54, Oracle database version 11g

Responsibilities:

• Interaction with Key Client Representative to study the business process and their requirements and to provide appropriate solutions in HR, Payroll, Benefits enrollment and reporting, Leave management and year-end tax statements.
• Solution Document Preparation.
• Perform Fit-Gap analysis.
• Technical Configuration Mapping.
• Team Management for Technical.
• Migration from Third Party System.
• User Training & UAT support and Parallel Run.

Confidential, Pasadena, CA

Lead Consultant

Technology: PeopleSoft HCM 8.9, PeopleTools versions 8.47, Oracle database versions 11i

Responsibilities:

• Interact with the client to discuss requirement details for business specifications.
• Technical guidance to team members. Review development progress and deliverables.
• Train new team members in the application development and compliance adherence for SDLC process.
• Provide support for UAT testing by users
• Update development status and discuss impact analysis details with the client in weekly conference calls that happen during PST (Pacific Standard Time).
• Impact analysis done for the PeopleSoft online and SQR objects that uses loaction and department fields.
• Develop generic SQRs to convert data in all impacted tables.
• Performance tuning done with the help of cluster index and analyze table, to handle volumionus tables of Time and Labor, Payroll system.

Consultant

Confidential, Pasadena, CA

Technology: PeopleSoft HRMS/HCM versions 8.3 and 8.9, PeopleTools versions 8.17, 8.22 and 8.47, Oracle database versions 8i and 10gR2

Responsibilities:

• Provide support for HR personnel actions viz. hiring, transfer, job status change, administrative title appointment/resignation, retirement.
• Interaction with business user to gather requirement specification.
• Technical design document, Unit Test Plan and Unit Test Results document preparation.
• Perform impact analysis and system conversion.
• Value addition tool development.
• Release migration documentation.
• UAT support, Go-live support and Post Live Support.
• Develop custom module to send State Disability Integration/Paid Family Leave (SDI/PFL) claims to integrate with payroll tables.
• Customize benefits SQR programs for Open Enrollment and Event Management under Benefits Administration.
• Customize SQR process to generate 1099 detail letter for year end processing.
• Customize SQR process to handle domestic partner enrollment and termination for delta dental interface.
• Develop XML Publisher report using PeopleSoft Query for Benefits and New Hire forms.
• Develop PeopleSoft Objects using STAT for version control and document the design and development process for SOX compliance.

Confidential

Senior Developer

Technology: PeopleSoft HRMS/HCM versions 8.3 and 8.9, PeopleTools versions 8.17, 8.22 and 8.47, Oracle database versions 8i and 10gR2

Responsibilities:

• Analyzed the impact for multiple jobs and extracted the PeopleSoft objects that need to be modified. Performed the data setup for running payroll for a new company and paygroup setup with the multiple employee record in place for retiree project.
• Developed analysis tool using SQR to extract the employee record occurrence in records and programs. This tool was time efficient and provided necessary details like page navigation for the impacted objects that could be used for testing the changes.
• Did exception generation, conversion methodology analysis, data extraction and translation of department/location for OneLink project.
• Developed Component Interface to load Life Add Benefits table data from file for retiree project.
• Played a major role in analyzing impact on HR, Benefits and Time and Labor programs due to customization done in PeopleSoft delivered modules and modified impacted programs as per new changes for upgrade project.
• Retrofitting and system testing for customization during upgrade from 8.3 to 8.9.
• Developed scripts to update primary phone flag for personal data table, due to the change happened from home phone to work phone set as primary in 8.9.
• Did impact analysis and required changes for person model in 8.9 viz. join with per org table, changes done for employment record being changed from table to view.
• Specification Preparation for new customizations.
• Review of Delivery to ensure adherence to standards and quality according to CMM Level 5 requirements.

Confidential

Senior Developer

Technology: PeopleSoft HRMS/HCM versions 8.3, PeopleTools versions 8.17, 8.22, DB2.

Responsibilities:

• Involved in new development and maintenance of PeopleSoft HRMS modules.
• Functional and Technical understanding of the Client’s business.
• Specification Preparation for new customizations.
• Developed complex Application Engine process to run as a nightly scheduled job to trigger alerts/notifications for Licensure/Certification module when a new hire, rehire or job transfer happens.
• Unit, System, end-to-end testing for HR modules as per functional requirement to ensure quality product development and delivery.
• Short term assignment for two months at Lincolnshire, Illinois, USA to do system study of an existing custom module - License/Certification and to gather business requirement from user to develop a new module that could integrate with HR process like New Hire, Rehire and Job change.

Confidential

Developer

Technology: PeopleSoft HRMS/HCM versions 8.3, PeopleTools versions 8.17, 8.22, DB2.

Responsibilities:

• Developed Application Engine processes for custom modules viz. New Hire, Rehire, Job Changes, Termination, Retirement and Death.
• Developed pages, components and date manipulation coding for custom modules viz. Merit Base Pay, Off Cycle Base Pay, Management Incentive Bonus and GN Bonus.
• Preparing test cases and test results documentation.
• Developed “Save as Draft” functionality using Application Messaging concept to integrate Taleo Interface data for hiring process through job data component.