SUMMARY

• Have 9 years of experience as PeopleSoft Techno Functional Consultant with a proven track record of delivering expert PeopleSoft solutions that includes Implementation, Customization, Upgrade, Maintenance, Support and Testing Projects. Predominantly focused on Design, Customization and Implementation of PeopleSoft HCM Modules (Core HR, Base Benefits, Benefits Administration, NA Payroll, Payroll Interface, Time and Labor, Workforce Administration, Manage Competencies, ESS, MSS, Compensation.
• Experience in PeopleSoft Implementation, Maintenance, Upgrading, Interfacing/Reporting, Troubleshooting and Production support.
• Strong PeopleSoft analytical experience in HR, Base Benefits, Payroll, Payroll Interface, Benefits administration, Employee Self - Services, Manager Self-Services, Base Benefits, ePerformance and complete understanding of complete project life cycle.
• Excellent experience as a technical 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, PeopleCode Debugger and Application Security.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server, SQL and Oracle PL/SQL.
• Experience with Data Cleansing, Data Profiling and Data analysis. UNIX Shell Scripting, SQL and PL/SQL coding.
• Very strong in SQL’s. Extensively worked with SQR, PeopleSoft Query, Connected Query in creation and generation of organizational reports.
• Extensive experience in designing, development, fit gap analysis and requirement gathering of enhancements to existing requirements for consolidation.
• Worked on various full lifecycle projects like Peoplesoft Payroll Implementation, Peoplesoft Tax Updates, ADP Tax Updates
• Excellent skills in Customization of PeopleSoft HRMS. Wrote efficient (row by row, mass update and parallel processing) custom Application Engines, SQR’s for data conversion from Legacy to PeopleSoft records by performing various validations, File Layout and Component Interfaces.
• Experience also includes debugging and performance tuning of processes. Well versed with Debugging tools like SQL trace, PC debugger, and Application Engine trace for troubleshooting.
• Understanding the functional design documents to develop Technical Design Document along with test strategy / test plan.
• Involved in development of Test Plans, writing & execution of test Cases and generating test Scripts.
• Extensively used PeopleTools for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR’s/AE through PeopleSoft environment.
• Good understanding of PIA such as app server configuration, PIA, Process Scheduler, web server.
• Worked intensively with Security Administrator to implement security in various levels. Creating Roles, Permission Lists User Profiles, Portal Security, Folders, Content References and Definition Security.
• Data analysis in PeopleSoft HRMS and developing reports using PS Query.
• Analyzing the custom functionalities in PeopleSoft.
• Involved in knowledge transfer to the client’s team for security, PeopleCode, PeopleTools, Workflow, interfaces, reports and troubleshooting.
• Good Understanding of Fluid Pages, dashboards.

TECHNICAL SKILLS

ERP: PeopleSoft 9.2/9.1/9.0/8.9

PeopleSoft Tools: Application Designer, PeopleCode, Workflow, Approval Workflow Engine, Application Engine, Change Assistant

PeopleSoft Modules: HR, Payroll for North America Benefits Admin, Time & Labor, Base Benefits, ESS, MSS, Compensation and emodules

Reporting Tools: SQR, PS Query, BI Publisher

Debugging Tools &migration Tool: SQL Trace, PeopleCode Debugger, Application Engine Trace, STAT

Integration Tools: File Layout, Component Interface, Application Messaging, Integration Broker

Databases: Oracle 8.x/9i/10g, SQL Server,DB2

Data Management & Batch Processing Tools: Data Mover, Application Engine, Import Manager and Process Scheduler

Administration Tools: Portal Administration, Object Security, Workflow Administration and Query Security

Operating Systems: Windows 8, 7, XP, NT, 2000, 98, 95, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Walnut Creek, CA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Team is responsible to provide 24 hour support to PeopleSoft HRMS modules, provide bug fixes, and enhance/customize the system as per business needs
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing and modifying the SQR’s.
• Creating of Application Engines to send the Payroll data to ADP.
• Applying patches provided by ADP to send payroll data to ADP.
• Sending live PeopleSoft data(Job, Personal, Contract Data, Payroll) to Equifax.
• Data analysis in PeopleSoft HRMS and developing reports using PS Query.
• Analyze the production issues faced by the users while running the payroll and providing them the solutions.
• Extensive experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server, SQL and Oracle PL/SQL.
• Responsibility included requirement Gathering, Analysis, Design and Estimation.
• Creating complex SQL to retrieve the data from PS.
• Involved in the development of reports using Vista plus.
• Development of new objects based on user requirement.
• Unit testing and drive User acceptance testing
• Analyze and provide functional and technical solution to issues reported by user based on the priority of the problem so that the business operation does not affect.
• ADP maintains the tax programs for Countrywide and sends frequent updates. My role is of a primary technical developer/contact on the Countrywide team for this project.
• Performed SQR, COBOL, SQL, and Peoplesoft Query troubleshooting and performance tuning.
• Primary technical contact for ADP Tax Updates. ADP maintains Countrywide’s periodic and quarterly tax programs.
• Responsible to migration of the PeopleSoft object and project from Development environment for Test, pre-prod and production environment using the PeopleSoft STAT tool
• Analyzed and approved the compare reports before and after applying tax updates, starting with the Demo and Sandbox, Testing environment, QA and Production.
• Quickly resolved escalated employee benefits issues that were received in the company's Benefits call-center.
• Conducted New Hire Benefits Orientations to ensure employees a thorough understanding of their benefits choices.
• Integrated iCIMS Onboarding system with PeopleSoft.
• Executing Data Mover Scripts(DMS) based on the requirement.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Created Training Guide for Benefits Department, updated benefits forms.
• Created custom processes to load benefits data from Excel file to PeopleSoft.
• Made customizations in the Leave Accrual Process.

Confidential - Boston, MA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Team was responsible to support PeopleSoft HRMS modules, provide bug fixes, and enhance/customize the system as per business needs
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing and modifying the SQR’s.
• Creating of Application Engines to send the PeopleSoft Data to Sailpoint system through a scheduled process.
• Sending live PeopleSoft data(Job, Personal, Contract Data) to Sailpoint system through Integration Broker.
• Data analysis in PeopleSoft HRMS and developing reports using PS Query.
• Analyzing the custom functionalities in PeopleSoft
• Responsibility included requirement Gathering, Analysis, Design and Estimation.
• Creating complex SQL to retrieve the data from PS.
• Development of new objects based on user requirement.
• Unit testing and drive User acceptance testing
• Analyze and provide functional and technical solution to issues reported by user based on the priority of the problem so that the business operation does not affect.
• Responsible to migration of the PeopleSoft object and project from Development environment for Test, pre-prod and production environment using the PeopleSoft STAT tool
• Followed Agile Product Methodology and participated in Story Grooming, Planning, Tasking/Sizing, Deploying and Retrospectives.

Confidential -Houston, TX

PeopleSoft Techno Functional Consultant

Responsibilities:

• Team was responsible to support PeopleSoft modules, provide bug fixes, and enhance/customize the system as per business needs
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing the SQR’s for benefits outbound interfaces.
• Assisted in analyzing various Production Issues pertaining to BI Publisher, Integration Broker, PS Queries etc.
• Analyzing the custom functionalities in PeopleSoft
• Update data in production environment using Excel to CI.
• Responsibility included requirement Gathering, Analysis, Design and Estimation.
• Creating complex SQL to retrieve the data from PS.
• Retrofitting the customization of PeopleCode code / SQR.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Converting SQR report to BI Publisher wherever Business need was.
• Lead a team to resolve critical bugs and ensure that there is no business downtime caused by any issues.
• Supporting the end user problems related to PeopleSoft System of Confidential .
• Development of new objects based on user requirement.
• Unit testing and drive User acceptance testing
• Configured Application Messages Between HR 9.1 and ELM 9.1 using Integration Broker 8.48 and resolved issues related to App Messaging.
• Trouble shooted Post production issues of HR9.1 and ELM9.1 Implementation.
• Analyze and provide functional and technical solution to issues reported by user based on the priority of the problem so that the business operation does not affect.
• Followed Agile Product Methodology and participated in Story Grooming, Planning, Tasking/Sizing, Deploying and Retrospectives.

Confidential -New York

PeopleSoft Techno Functional Consultant

Responsibilities:

• Inspira is a staff selection system at Confidential, implemented to promote transparency and good governance in the selection process.
• The designated staff representatives will review, along with HRMS representatives, recommendations for filling job openings, in order to ensure that applications were reviewed on the basis of the evaluation criteria listed in the job openings and that the applicable procedures were followed.
• Team was responsible for supporting/enhancing this PeopleSoft HR System.
• Data analysis in PeopleSoft HRMS and developing reports using PS Query.
• Responsibility included requirement Gathering, Analysis, Design and Estimation.
• Technical Issues Resolution (Analysis, fixing and Tracking)
• Creating complex SQL to retrieve the data from PeopleSoft.
• Preparing test case documents and testing extracts.
• Fixing up technical issue by providing resolution as Technical Fixes for issues as part of code changes and process changes.
• Test case preparation and Quality analysis.
• Functional Consultant for PeopleSoft HCM responsible for supporting daily business operations and resolving end user problems.
• Maintaining and Updating job openings.
• Creating Job data, Personal data, User Profiles for employees newly hired by Confidential Secretariat.
• Updating Employees’ Dependents and Beneficiary Information for the employees
• Updating and Maintaining Benefits Information for the employees
• Granting duly approved roles and other security access to the Users
• Supporting the reporting requirements
• Supporting the Benefits Open enrollment and mid-year benefits updates
• Updating Approval Workflows as per the changing business needs.

Confidential -Newark, NJ

PeopleSoft Techno Functional Consultant

Responsibilities:

• Ran Upgrade Compare reports to identify the customized, orphaned objects in the PeopleSoft database.
• Extensively involved in the analysis and retrofitting the existing PeopleCode, SQL’s, SQR’s
• Application Engine’s and other PeopleSoft impacted objects.
• Involved in the initial analysis of upgrade plan and performed Initial Pass and Move to Production passes required for the upgrade.
• Extensively worked and given support to Payroll, ESS, MSS, HR users.
• Worked on Testing and developing number of Reports, Interfaces, Conversions and Extensions.
• Tested and Developed Inbound/Outbound interfaces for HR and Benefits data.
• Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
• Used Application Designer to modify custom PeopleSoft objects. Modified existing records and created new records and views to meet the application needs. Created and modified pages and existing menus to reflect the customized pages and controlled the process flow with PeopleCode.
• Worked on testing PeopleSoft ePerformance module customizations for employee performance reviews.
• Assisted in analyzing various Production Issues pertaining to BI Publisher, Integration Broker, PS Queries etc.
• Created test plans for the objects in HR and Benefits modules.
• Extensively used PeopleTools for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR’s/AE through PeopleSoft environment.
• Interacted with QA Team for conducting functional testing, regression and user acceptance testing for PeopleSoft HR, Payroll applications.
• Creating report files using PS query
• Tested and verified SQR interfaces and applications using PS Query, Process Scheduler.
• Worked on testing Data Conversion from legacy system to PeopleSoft system and developed utility in PeopleSoft using Application Engine, Component Interface.
• Involved in Integration testing, Unit testing, System testing Regression testing and User Acceptance testing for the modules like HR, Benefits and Payroll.
• Helped Users in developing complex Queries.
• Helped users with all PeopleSoft Modules related issues
• Retrofitting the customization of PeopleCode code / SQR.
• Involved into bug fixes of newer Version of PeopleSoft. Also created Tickets and followed up with Oracle support to get delivered issues clarified/fixed.
• Involved in Fit-Gap Analysis, Keep-Drop Analysis. Prepared compilation reports and shared across Business teams for Decision making activities.
• Converting SQR report to BI Publisher wherever Business need was.
• Prepared staging record structures for PS Query to be re-used BI Publisher reports.
• Performing Early Morning Checks on all the PeopleSoft Environments.
• Monitoring the Various PeopleSoft Processes.
• Resolving the issues that came in the Production Environment
• Working on new Developments that are coming in 9.1.
• Providing the Production files to the user when requested. Retrofitting the code, bug fix etc.
• Preparing Test cases for DEV, System test Environment
• Resolving the issues that come in DEV, System test, UAT Environment
• Creation of Employee data for testing in DEV environment.

Confidential

PeopleSoft HCM Technical Consultant

Responsibilities:

• Retrofitting the customization of PeopleCode code / SQR.
• Involved in Fit-Gap Analysis, Keep-Drop Analysis. Prepared compilation reports and shared across Business teams for Decision making activities.
• Converting SQR report to BI Publisher wherever Business need was.
• Prepared staging record structures for PS Query to be re-used BI Publisher reports.
• Generating Complex PDF Reports Using BI Publisher.
• Converted Complex SQR’s to BI Publisher
• Worked With I Scripts
• Creation and Modification of SQR’s
• Modification/Troubleshooting of SQR’s related to all modules in PeopleSoft.
• Writing new application engine programs and maintaining the old ones to generate the discrepancy reports for the discrepancies in the JOB and POSITION records.
• Development of fields, pages, components and customizations of existing.
• Developing Technical specifications based on the requirements stated by the client. Created High Level Design documents.
• Defined test plans based on user requirements
• Development and scheduling of various SQR reports.
• Creation of permission-lists, roles, user profiles and granting permissions on components depending on user’s job responsibilities.
• Understanding the interface requirement and creating functional and technical document for the same.
• Creation of run control record, pages and components.
• Migrating project from development to test environment.
• Analysis of data Migration needed and Configuration which need to be migrated in new System.
• Study of delivered elements available in PeopleSoft and use of maximum delivered functionality given by PeopleSoft.
• Complete understanding of App Package which provides OOPs Concept in PeopleSoft.
• Implemented online report, FTP using SQR, implemented Role and row level security.
• Advance search in Recruitment.
• Knowledge of Integration Broker and Email Collaboration.
• Configured Application Messages Between HR 9.1 and ELM 9.1 using Integration Broker 8.48 and resolved issues related to App Messaging.
• Trouble shooted Post production issues of HR9.1 and ELM9.1 Implementation.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Creation and Modification of SQR’s
• Writing new application engine programs and maintaining the old ones to generate the discrepancy reports for the discrepancies in the JOB and POSITION records.
• Development of fields, pages, components and customizations of existing.
• Developing Technical specifications based on the requirements stated by the client. Defined test plans based on user requirements
• Development and scheduling of various SQR reports.
• Creation of permission-lists, roles, user profiles and granting permissions on components depending on user’s job responsibilities.
• Creation of run control record, pages and components.
• Migrating project from development to test environment.
• Analysis of data Migration needed and Configuration which need to be migrated in new System.
• Study of delivered elements available in PeopleSoft and use of maximum delivered functionality given by PeopleSoft.