SUMMARY

• Has 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 teh 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 teh custom functionalities in PeopleSoft.
• Involved in noledge transfer to teh 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 teh system as per business needs
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing and modifying teh SQR’s.
• Creating of Application Engines to send teh 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 teh production issues faced by teh users while running teh payroll and providing them teh 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 teh data from PS.
• Involved in teh 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 teh priority of teh problem so that teh business operation does not affect.
• ADP maintains teh tax programs for Countrywide and sends frequent updates. My role is of a primary technical developer/contact on teh Countrywide team for dis 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 teh PeopleSoft object and project from Development environment for Test, pre-prod and production environment using teh PeopleSoft STAT tool
• Analyzed and approved teh compare reports before and after applying tax updates, starting with teh Demo and Sandbox, Testing environment, QA and Production.
• Quickly resolved escalated employee benefits issues that were received in teh 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 teh 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 teh 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 teh Leave Accrual Process.

Key Technologies/Skills: PeopleSoft HCM 9.2, PeopleTools 8.54, Core HR, ESS/MSS, Workforce Administration, NA Payroll, Time and Labor, Base Benefits, Application Engine, File Layout, PS Security, Data Mover scripts, PS Query Manager, SQR Reports, BI Publisher, Component Interfaces, Excel to CI utility, Integration Broker, Excel to CI, Business Processes, Approval Workflow Engine (AWE)

Confidential - Boston, MA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Team was responsible to support PeopleSoft HRMS modules, provide bug fixes, and enhance/customize teh system as per business needs
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing and modifying teh SQR’s.
• Creating of Application Engines to send teh 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 teh custom functionalities in PeopleSoft
• Responsibility included requirement Gathering, Analysis, Design and Estimation.
• Creating complex SQL to retrieve teh 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 teh priority of teh problem so that teh business operation does not affect.
• Responsible to migration of teh PeopleSoft object and project from Development environment for Test, pre-prod and production environment using teh PeopleSoft STAT tool
• Followed Agile Product Methodology and participated in Story Grooming, Planning, Tasking/Sizing, Deploying and Retrospectives.

Key Technologies/Skills: PeopleSoft HCM 9.2, PeopleTools 8.54, Core HR, ESS/MSS, Workforce Administration, Recruitment, Application Engine, File Layout, PS Security, Data Mover scripts, PS Query Manager, SQR Reports, BI Publisher, Component Interfaces, Excel to CI utility, Integration Broker, Excel to CI, Business Processes, Approval Workflow Engine (AWE)

Confidential -Houston, TX

PeopleSoft Techno Functional Consultant

Responsibilities:

• Team was responsible to support PeopleSoft modules, provide bug fixes, and enhance/customize teh system as per business needs
• Estimate, plan, assign, assist and track development specific to business requirements.
• Involved in developing teh SQR’s for benefits outbound interfaces.
• Assisted in analyzing various Production Issues pertaining to BI Publisher, Integration Broker, PS Queries etc.
• Analyzing teh 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 teh data from PS.
• Retrofitting teh customization of PeopleCode code / SQR.
• Developed Interfaces using UNIX Shell Scripts to automate teh bulk load & update Processes.
• Converting SQR report to BI Publisher wherever Business need was.
• Lead a team to resolve critical bugs and ensure that their is no business downtime caused by any issues.
• Supporting teh end user problems related to PeopleSoft System of Confidential .
• 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 teh priority of teh problem so that teh business operation does not affect.
• Followed Agile Product Methodology and participated in Story Grooming, Planning, Tasking/Sizing, Deploying and Retrospectives.

Key Technologies/Skills: PeopleSoft HCM 9.1, PeopleTools 8.52, Application Engine, File Layout, PS Security, Data Mover scripts, PS Query Manager, SQR Reports, BI Publisher, Component Interfaces, Excel to CI utility, Integration Broker, Excel to CI, Business Processes, Approval Workflow Engine (AWE)

Confidential -New York

PeopleSoft Techno Functional Consultant

Responsibilities:

• Inspira is a staff selection system at United Nations, implemented to promote transparency and good governance in teh selection process.
• Teh designated staff representatives will review, along with HRMS representatives, recommendations for filling job openings, in order to ensure that applications were reviewed on teh basis of teh evaluation criteria listed in teh job openings and that teh applicable procedures were followed.
• Team was responsible for supporting/enhancing dis 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 teh 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 United Nations Secretariat.
• Updating Employees’ Dependents and Beneficiary Information for teh employees
• Updating and Maintaining Benefits Information for teh employees
• Granting duly approved roles and other security access to teh Users
• Supporting teh reporting requirements
• Supporting teh Benefits Open enrollment and mid-year benefits updates
• Updating Approval Workflows as per teh changing business needs.

Key Technologies/Skills: PeopleSoft HCM 9.0, PeopleTools 8.50, Core HR, ESS/MSS, Workforce Administration, recruitment, ePerformance, Position Management, Compensation, Benefits Administration, Base Benefits, eBenefits

Confidential, NJ

PeopleSoft Techno Functional Consultant

Responsibilities:

• Ran Upgrade Compare reports to identify teh customized, orphaned objects in teh PeopleSoft database.
• Extensively involved in teh analysis and retrofitting teh existing PeopleCode, SQL’s, SQR’s,
• Application Engine’s and other PeopleSoft impacted objects.
• Involved in teh initial analysis of upgrade plan and performed Initial Pass and Move to Production passes required for teh 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 teh application needs. Created and modified pages and existing menus to reflect teh customized pages and controlled teh 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 teh 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 teh modules like HR, Benefits and Payroll.
• Helped Users in developing complex Queries.
• Helped users with all PeopleSoft Modules related issues
• Retrofitting teh 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 teh PeopleSoft Environments.
• Monitoring teh Various PeopleSoft Processes.
• Resolving teh issues that came in teh Production Environment
• Working on new Developments that are coming in 9.1.
• Providing teh Production files to teh user when requested. Retrofitting teh code, bug fix etc.
• Preparing Test cases for DEV, System test Environment
• Resolving teh issues that come in DEV, System test, UAT Environment
• Creation of Employee data for testing in DEV environment.

Key Technologies/Skills: PeopleSoft HCM 8.9/9.1, PeopleTools 8.50, Core HR, ESS/MSS, Workforce Administration, recruitment, ePerformance, Compensation, Base Benefits, Global Payroll, Time and Labor, Application Engine, File Layout, PS Security, Data Mover scripts, PS Query Manager, SQR Reports, BI Publisher, Component Interfaces, Excel to CI utility, Integration Broker, Excel to CI, Business Processes, Approval Workflow Engine (AWE)

Confidential

PeopleSoft HCM Technical Consultant

Responsibilities:

• Retrofitting teh 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 teh old ones to generate teh discrepancy reports for teh discrepancies in teh JOB and POSITION records.
• Development of fields, pages, components and customizations of existing.
• Developing Technical specifications based on teh requirements stated by teh 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 teh interface requirement and creating functional and technical document for teh 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.

Key Technologies: PeopleSoft HCM 8.9/9.1, Core HR, ESS/MSS, Workforce Administration, recruitment, ePerformance, Position Management, Compensation, Global Payroll and Absence Management, Application Engine, File Layout, PS Security, Data Mover scripts, PS Query Manager, SQR Reports, BI Publisher, Component Interfaces, Excel to CI utility, Integration Broker, Excel to CI, Business Processes, Approval Workflow Engine (AWE)

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Creation and Modification of SQR’s
• Writing new application engine programs and maintaining teh old ones to generate teh discrepancy reports for teh discrepancies in teh JOB and POSITION records.
• Development of fields, pages, components and customizations of existing.
• Developing Technical specifications based on teh requirements stated by teh 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.

Key Technologies/Skills: PeopleSoft HCM 8.9, Core HR, ESS/MSS, Workforce Administration, Recruitment, Application Engine, File Layout, PS Security, Data Mover scripts, PS Query Manager, SQR Reports, BI Publisher, Component Interfaces