SUMMARY

• Having 15 +years of experience in PeopleSoft Implementation, Upgrade, and Support & Enhancement Projects of PeopleSoft HRMS, Finance Ver. 8.8 / 8.9 / 9.0/9.1/9.2.
• Worked as a Technical Lead, Techno - Functional, System Analyst, Technical Consultant and Functional consultant in various projects,
• Technical expertise in, People Tools, People Code, PS Query, XML Publisher, Application Engine, SQR, COBOL, Application Designer, Application Messaging, Component Interfaces, Web Services.
• Knowledge in Functional aspects of Core HR, Benefit Administration, NA payroll, Base Benefits, Payroll Interface, Time and Labor, Absence Management, Position Management and performance.
• Demonstrate experience in analyzing and documenting business requirements by developing process flow diagrams, implementing the Software Development Life Cycle including gathering requirements, developing, testing through production go-live.
• Coordinate Onshore/Near-shore/Offshore/Client for successful deliverables by working with Developers, Functional Team, Testers and End Users to make effective progress.
• Played a vital role in Development, Support for troubleshooting and tuning sql.
• Created Test Plan and executed Test Scripts as per the requirement.
• Having a proven ability to lead consistently hit targets, improve best practices and organize time efficiently.
• Ensuring that staff is motivated, monitored and measured in line with company targets and performance standards.
• Created Training documents and facilitated Knowledge transfer sessions to support team and Users.
• Responsible for making sure that any gaps in performance or quality are quickly identified and addressed.
• Performing Delivery Reviews, in addition to Peer Review
• Excellent team player, good independent performer, Organized and hardworking.
• Analyzing and troubleshooting the issues and try to resolve within specified Service Level Agreement.
• A highly motivated team player with an ability to quickly adapt to new environments and technologies.

TECHNICAL SKILLS

ERP: PeopleSoft 8.x,8.51,8.53,8.54 Core HR, ESS, MSS, Base Benefits, Benefit Administration, NA Payroll, Payroll Interface, Compensation, ePerformance, Time and Labor, Absence Management

People Tools: Application Designer, Application Engine, Component Interface, People Code, PeopleSoft Security, Process Scheduler, Process Monitor, Data Mover, Tree Manager, PS Query, AWE, File Layout, Configuration Manager, Application Server, Integration Tools

Reporting Tools: XML Publisher, SQR, PS Query.

Workday: Reports and Integrations.

RDBMS: ORACLE 8i 9i 10g, Microsoft SQL Server, DB2

Languages: SQL, PL SQL, VB 6.0, Basic.

OS: UNIX, MS-DOS, Windows NT XP Vista.

PROFESSIONAL EXPERIENCE

Confidential, Mineola, New York

PeopleSoft Redesign

Application and Tools: HRMS People Tools8.54, UNIX, Oracle 12c.

Responsibilities:

• Coordinating with the Users to understand the requirements.
• Tuned Sql to improve the performance for TL Rules, Benefits Outbound Interfaces and Payroll reports.
• Involved in writing the validating process for the Integration between Payroll and Absence Management.
• Involved in fixing issues related to Time and Labor / NA Payroll Integration.
• Involved in analyzing and fixing issues in Time and Labor.
• Resolved issues reported in PreSheet Audit Process.
• Resolved issues related to Benefit Deductions.
• Worked on BI Publisher report to generate a report with ineligible rows in Absence Event.
• Customized Absence Event Component as per Business requirement.
• Involved in writing reports for Payroll.
• Applied retro fits after Tax Updates.
• Involved in writing Outbound interfaces for Benefits for third party vendors.
• Involved in the conversion of Benefits Enrollments like health, FSA, Savings and Retirement plan.
• Worked and modified Benefits conversion process to enroll employees coming from Main frames.
• Customized MSS Timesheet and Employee Self Service page.
• Worked on Time and labor rules. Created new rules and modified the existing rules and Created exceptions in Time and Labor.
• Created Application Engine program to generate Demographic data file for Valic Vendor.
• Created Inbound Interface with Application Engine and Component Interface to import

Confidential, Albany, New York

PeopleSoft Integration Consultant

Application and Tools: PeopleSoft 9.2 HRMS, CRM, Portal People Tools8.53, UNIX, Oracle 11g.

Responsibilities:

• Coordinating with the Accenture Team members to understand the existing functionality to work on defects.
• Created an Integration between HCM and CRM application using Integration Broker for Loan application.
• Whenever a Pensioner or Member applies a loan a case needs to be created and closed in helpdesk.
• Used XML Publisher to generate Income Verification form for Pensioner and Beneficiary.
• Working on Defects and fixing them as part of Phase 4a implementation.

Confidential, Peoria, Illinois

PeopleSoft HCM Consultant

Application and Tools: PeopleSoft 9.2 HRMS, People Tools8.53, UNIX, Oracle 11g, ALM 11, SDLC.

Responsibilities:

• Coordinating with end Users and gathering requirements and creating technical design documents.
• Analyzing custom COBOL processes in 8.0 and 8.9 versions and converted them to Application Engine Program in 9.2.
• Created Application Engine programs for Data Conversion of HR data from 8.9 to 9.2.
• Worked on interface programs for migrating data from other systems to PeopleSoft.
• Created Outbound Interface to generate file with CAT HR changes to Hewitt.
• Created inbound interface using Application Engine to read the file from Hewitt and insert data into Personal Data Component using Component Interface using current date as Effdt.
• Developed ad-hoc reports and ad-hoc queries developed Run Control Pages as per requirements.
• Created Custom Application Engine to send information to Confidential for Direct Deposit.
• Created reports in XML Publisher.
• Created Application Engine to import deduction data coming from MetLife Enrollment file.

Confidential, Plano, TX

PeopleSoft HCM Consultant

Application and Tools: PeopleSoft 9.2 HRMS, People Tools8.53, UNIX, Oracle 11g, ALM 11, SDLC.

Responsibilities:

• Coordinated with Functional team and Business Users for gathering, understanding of requirements.
• Created Technical Design documents based on the requirements and provided assistance to offshore team on daily basis.
• Tuned Sqls in PS Queries and Application Engine program to increase the performance.
• Worked on Time and Labor rules and tuning sqls to increase the performance of Rules.
• Involved in retrofitting of Payroll Queries in 8.9 and converting them in 9.2 Queries.
• Used AE with Component Interface to import data into Payroll Component.
• Involved in development, retrofitting and enhancement activities.
• Created AWE for approvals of Claims in ESS/MSS Module.
• Converted custom SQR and COBOL processes of HR, Benefits and Payroll reports in 8.9 to Application Engine in 9.2.
• Wrote Conversion process to move data from 8.9 ELM tables to 9.2 custom tables.
• Analyzed and created Performance Improvement plan and Performance Annual Review reports of ePerformance module in OBIEE BI Publisher.
• Created scripts for Data masking and purging of data.
• Involved in retrofitting of Components, Pages, Records and Peoplecode.
• Involved in Customization of Payroll Reports.
• Created multiple reports using XML Publisher
• Involved in System Integration testing, User Acceptance testing and Performance testing to fix defects raised by Users and Functional team.
• Used Data Mover to migrate data setup data in different environments.
• Worked on Integration tools like File layout
• Worked on People Code at field level for validations and implement business rules as per the requirements of the client.
• Created PPT for training Production Support Team and perform code walkthroughs for RICE ID items.

Confidential, Houston, TX

PeopleSoft HCM Techno Functional Consultant Lead and System Analyst

Modules: Core HRMS, Payroll interface Base Benefits PeopleSoft 9.0 HRMS, People Tools8.52, Oracle, Mercury Quality Center, SDLC.

Responsibilities:

• Involved in Data Conversion of PeopleSoft data as per the specifications of Workday.
• Created Application Engine Programs to update Compensation Data in Job Component and Addresses in Personal Data Component using Component Interface and File layout for Workday integration.
• Used SQR’s for Data conversion and created outbound interfaces.
• Involved in Critical Development, fixing of critical issues and Testing and migration activities.
• Involved in setting up codes, to map codes to EDI 834 codes related to HIPAA report.
• Involved in customizing the HIPAA EDI 834 Application Engine Process.
• Created Outbound Interface using SQR to generate a CSV file and encrypted the file.
• Created outbound Interfaces using File layouts and Application Engine.
• Used People code for data validation and to execute new business logic.
• Created and Modified Records, Pages and Components using Application Designer.
• Used Data Mover scripts for Data Migration.
• Designed and Developed Dynamic PS Query report using People code based on the input parameters provided on the page in order to reduce the complexity of conditions in where clause.
• Generated XML Publisher Reports as per the requirements.
• Created Application packages for creating Data Source and Report Definitions in XML Publisher as Users had limited access to People Tools in PIA.
• Tuned SQLs for better performance.
• Provide leadership and support to a team of up to eight Nominees who are involved in development and enhancement activities.
• Handling and coordinating with end Users for gathering of requirements.
• Involved in gathering of requirements and creating the Technical Design Document.
• Worked as a deployment lead for Production migration activities.
• Coordinating with Managers and Team members on day to day activities.
• Tracking the bugs and prioritizing work accordingly.
• Involved in Training the Users and Production Support team.

Confidential, New York

PeopleSoft HCM Senior System Analyst

Modules: Core HRMS, Payroll interface Compensation, ePerformance, Time and Labor PeopleSoft 9.0 HRMS, PeopleSoft 9.0 HRMS, PeopleTools8.48, Oracle, Mercury Quality Center, ITG tool

Responsibilities:

• Handling and coordinating with end Users for gathering of requirements.
• Arranging & chairing weekly team meetings, focusing on targets & achievements.
• Able to prioritize tasks and workloads in order of importance and allocating of tasks to the team and Track record of delivering results with deadlines and coordinating with offshore team.
• Helping team in resolving critical issues and Dealing with and resolving problems and issues.
• Supporting Time and Labor Module.
• Generated PDF documents using XML Publisher with Employee Photo.
• Resolving COBOL issues related to Payroll Interface Export Process (PI INRUN).
• Coordinating with users to resolve setup issues.
• Created Application Engine to import PDF documents and storing them in Database.
• Resolving issues related to Setup of COBOL Interface and providing solution to the client.
• Involved in increasing the performance of the Payroll Interface Process.
• Supporting offshore development team to create Test data as per the requirements an resolve issues whenever Payroll Interface Export Process does not create any data in PI PARTIC EXPT.
• Responsible in debugging the issues related to Export Process.
• Provided solution to extract data.
• Involved in tuning the Custom Application Engine process.

Confidential

PeopleSoft HCM Senior System Analyst

Responsibilities:

• Lead the design and development of a specific custom module in PeopleSoft.
• Involved in estimating the tasks and duration and allocation of work to the BAU team.
• Involved in discussions and gathering of Business requirements and assisting the development team in creating Technical specifications.
• Prepared Technical Documents as per the requirements.
• Provided creative and critical solutions like
• Designed and Developed Query report on the fly in order to reduce the complexity of conditions in where clause.
• Designed and developed to store the PDF report in database. Merging the multiple PDF’s into one PDF and viewing it on the fly.
• Created Outbound Interfaces using Application Engines for generating CSV files.
• Created Application Engine Program to do the following tasks.
• Adding, Deleting and Moving of Nodes in a Tree based on the inputs provided in the file.
• To Delete the Inactive Nodes from a Tree.
• Created Workflow Notifications to send mails to the Compensation analyst whenever an Employee is made a Bonus or Salary Eligible.
• Developed and Involved in creating online customization code.
• Used XML Publisher extensively for generating reports.
• Created Component Interface for data uploads.
• Involved in Performance Tuning for better performance of Application Engine programs.
• Involved in creation of Custom and Complex Pages and Components.
• Provided complete training and documentation for Production Support Team.
• Designed, Developed and Executed set of Test Cases.
• Reviewing the test cases prepared by offshore team.
• Prepared test data to validate the functionalities.
• Updated the test status on daily and weekly basis.
• Used ITG Tool and Serena Dimensions for Project migration.
• Involved in creating SDLC’s documents, OMF and RFC for migrations.

Confidential

PeopleSoft HCM Senior System Analyst

Modules: PeopleSoft 8.0 Finance (Purchase Order, Order Management, Inventory), People Tools 8.48, Oracle.

Responsibilities:

• Prepared Technical Documents as per the requirements.
• Involved in creation of Messages, Services and Service Operation required for Asynchronous out Bound Messages.
• Created Application Engine Programs with a recurrence definition to publish a message for the following tasks
• Whenever new Purchase Orders are created and the status is dispatched in PeopleSoft.
• Whenever new Sales Orders are created in PeopleSoft.
• Whenever there is an Inventory Adjustment in PeopleSoft.
• Whenever new Product Id is created and item is assigned to Product Id.
• Exposed CI’s as a web service in order achieve the following tasks
• Create new Requisitions in PeopleSoft whenever created in EBS.
• Update Standard Lead time of the items.
• To perform Express issue and Put away issue for the items in a location.
• To update comments of Item Attributes in PeopleSoft
• Written People code in the Save Post change event to Publish Messages for the following tasks
• Whenever new Items are created in PeopleSoft.
• Whenever Items are associated with the Business Unit.
• Whenever items are associated to multiple Business Units in peopelsoft
• Involved in Unit Testing and fixing the bugs.
• Involved in weekly status reporting.

Confidential

PeopleSoft HCM Techno Functional consultant

Modules: PeopleSoft 8.9 HRMS (Core HR, ePerformance), People Tools 8.45, Sql Server.

Responsibilities:

• Involved in creation of Component Interface on Job Component, Personal information and User Profile for migrating data from 8.8 to 8.9.
• Involved in implementation and customization of ePerformance module.
• Involved in customizing EP RPT SNAP.
• Created a new Work Flow using Role Query.
• Involved in creation of reports using Application Engine.
• Involved in creating Field mapping between 8.8 and 8.9 tables and creating Automation process to migrate data from 8.9 tables to tables having a similar structure of 8.8 that is later used for Data warehousing.
• Involved in creation of out bound interfaces using Application Engine.
• Involved in creating new business logic using people code.
• Involved in resolving some security related issues.
• Created new Trees to provide Row level security.
• Created Security by permission list to provide Row level security.
• Trained the clients about the security concepts.

Confidential, Manassas, VA

Techno-functional Consultant .

Modules: People tools 8.45, PeopleSoft HRMS 8.8(Core HR, Benefit Administration, North American Payroll, Time and Labor, Windows 2000, Oracle

Responsibilities:

• Involved in configuring the setup of Benefit Administration based on the requirement.
• Created Eligibility rules, Benefit Program and benefit Plans.
• Interacted with users and vendors and created Functional documents as per the requirement.
• Involved in creation of Technical documents for out bound interface in North American Payroll module.
• Involved in creation of Outbound and Inbound interfaces using File Layouts
• Involved in creation of Application Engine Programs for batch process like enrolling employees into plans 1X, 2X and 3X having event class REH.
• Involved in online customizations on Job table while inserting a row with action as RFL (return from leave).
• Involved in creation of Component Interface for inserting rows into JOB DATA component for the Employees who have action REH and HIR.
• Involved in creation and customizations of SQR programs.
• Involved in creation of online pages for running the SQR program.
• Involved in Unit testing once the data has been uploaded.

Confidential

Techno Functional Consultant .

Modules: People tools 8.44, PeopleSoft HRMS 8.8 (eBenefits, North American Payroll), Windows2000, DB2

Responsibilities:

• Involved in creating Technical and Functional Documents based on the Functional Designs.
• Involved in creation of Application Engine program for assigning BAS GROUP ID’s for the employees in the JOB table and inserting new rows into BAS ACTIVITY table.
• Involved in creation and customizations of SQR programs for calculating the deductions and coverage amounts for plan types 1X and 2X.
• Involved in understanding the process of HSA plan type and created Application Engine program and customized open enrollment form to include HSA plan type.
• Involved in customizations of online pages of Benefits.
• Involved in creation of Test cases and Unit testing.
• Involved in fixing of defects and maintenance by running the jobs