SUMMARY

• Having 10+ years of experience in PeopleSoft applications as a Technical/Techno functional Consultant implemented, upgraded, customized, and maintained PeopleSoft HCM/FSCM and Oracle based applications.
• Highly expertise in using People Tools (APPLICATION DESIGNER, PEOPLECODE, APPLICATION ENGINE, FILE LAYOUT, COMPONENT INTERFACE, APPLICATION PACKAGES Integration Broker, Data Mover and PS/Query).
• Developed various interfaces using APPLICATION ENGINE, SQR, and Data Conversion programs.
• Good functional knowledge in PS HRMS/HCM Version 7.5 to 9.2 (Workforce Administration, Benefits, ESS, MSS, Recruiting, TAM, NA Payroll, Global Payroll) and FSCM (AP, AR, PO, Billing, GL).
• Analyzed Functional requirements on basis of Functional design documents and also part of team while gathering the business requirements from clients.
• Prepared Technical design documentation for various developing/customized developments.
• Performed Peer reviews in onsite/offshore models.
• Highly commended for performance and commitment from the customers and clients. Possess very good client interactive and communication skills.
• Proficient in customizing and developing various reports using SQR, PS/Query, XML Publisher and Crystal reports.
• Expert in fixing performance issues of SQR reports, APPLICATION ENGINE programs and online application by tuning SQL.
• Having experience in resolving production issues and solving data related issues.
• 24/7 on call support for Production and Support Applications.
• Worked and followed agile methodology for various projects to update the status of the tasks.
• Extensively worked with PS SQL and proficient TOAD/SQL developer tools.
• Running jobs using Putty tool and Shell scripts.
• Very Good knowledge in maintaining Security and User profiles.
• Proficient in customizing modules based on organizational needs and requirements.
• Worked on various environments like Mainframe, UNIX and Windows.
• Involved in project meetings and status meetings with Onsite consultants and/or Clients
• Good Knowledge in SDLC, Manual Testing like UAT, Functional, System (SIT) and Regression.
• Good Knowledge in Java/J2EE, LDAP, SAOP and web services.

TECHNICAL SKILLS

ERP: PeopleSoft HRMS/HCM v 7.5/8.3/8.8/8.9/9.0/9.1 (HR, Payroll, Payroll Interface, Benefits, Benefit Administration Self Service Modules, Recruiting, NA payroll, Global Payroll), PeopleSoft Financials v8.4/8.9 (GL, AP and Project Costing.) PeopleTools v 7.5/8.42/8.47/8.49/8.5/8.51/8.52

Reporting Tools: SQR,PS/Query, XML Publisher and Crystal Reports

People Tools: Application Engine, Component Interface, File Layout.

Designing & Development: Application Designer, People Code, QuestStat, HTML, XML, JSP.

Programming Languages: C, C++,SQR, JAVA, Java Script, SQL

Web Servers: Apache Tomcat, BEA Web Logic9.1, IBM Web sphere

Development Tool Kits: JDK, J2EE, PeopleSoft

RDBMS: Oracle7x/8x/9x/10g/11g, SQL - Server 7.x/2000/DB2

Operating Systems: Windows Family (9x, NT, 200x), UNIX, Mainframe

PROFESSIONAL EXPERIENCE

Confidential, MO

Techno-functional Consultant

Environment: Windows, Oracle11g, PeopleSoft HCM 9.1 People Tools 8.52(Application Designer, People Code, Application Engine, Component Interface, File Layout, PS Query, Data mover,XML Publisher and IB) and SQR.

Responsibilities:

• Worked as a NA Payroll Team member to resolve tickets and develop new interfaces.
• Improved system productivity and processing execution time of Open Enrollment.
• Interaction with end-users to define system setup, improve benefits system processing and data requirements for Benefits and Open Enrollment.
• Worked on NA Payroll Year-End Processing and generating W-2’s.
• Provided Gap and Business Analysis to identify modifications and business requirements, functional and technical programming for HRMS, Benefits Administration, Payroll, Employee Self-Service, Workflow, eBenefits modules which consisted of design documentation, table structure setup and modification of workflow process for daily event processing and Open Enrollment functionality.
• Implemented complex technical and system design specifications for benefits, eBenefits and Self-Service.
• Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
• Extensively worked on Tax Updates in functional implementation parts and involved in yearend tasks particularly by applying payroll tax updates for running the payroll as expected.
• Developed an interface to Calculate pension benefits in PeopleSoft and prepare monthly pay files that include banking and deduction information, in Pension module.
• Created and managed Approval processes by using AWE (Approval work flow Engine) in PMD/ESS module. Maintaining User Security and User Preferences and permission lists.
• Supported and resolved the issues in PeopleSoft HCM v 9.0 system.

Confidential, TX

Technical Consultant

Environment: Unix,Oracle11g PeopleTools8.52 (Application Designer, People Code, Application Engine, Component Interface, File Layout, IB, PS Query, Data mover) and SQR, Toad.

Responsibilities:

• Analyzed and helped in developing System Requirements for business.
• Developed Employee Optin Process, where an employee can choose stores to work in Hiring Circle.
• Developed Web services and provided service to external applications to consume using PeopleSoft integration technology.
• Consumed a secured Web service from Oracle Fusion service bus and developed PeopleSoft objects to support HR data provision to Oracle fusion application.
• Developed App Engine programs and Integration objects to build custom Time reporting application.
• Using Integration broker Created batch programs to export time reporting data to Kronos and import calculated time segments from Kronos.
• Created parallel processing batch programs to handle heavy loads of data.
• Worked with Business closely to study their Requirement and guide through SRD as a PeopleTools .
• Done peer review for other developments which are done teammates.

Confidential, RI

Techno Functional Consultant

Environment: Unix,Oracle11g,PeopleSoft HCM9.1 PeopleTools8.52 (Application Designer, People Code, Application Engine, Component Interface, File Layout, PS Query, Data mover and IB) and SQR, Benthic.

Responsibilities:

• Developed an Interface for Cost of Employer contribution Health Coverage on Employee W2s with SQR in Benefits/Payroll modules.
• Designed and developed SQR outbound interfaces to generate Flat Files to be sent to the respective carriers, listing all the terminations and enrollments into various Base Benefit Plans during the Year-end/Open Enrollments
• Enhanced the interfaces like Credo, Computer share, LOA interfaces with adding new fields and changing file formats as per client requirements.
• Involved in setup and design of automated benefits enrollment process, setting up core tables in HR and Benefits Administration, defining eligibility rules and creating event rules.
• Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement.
• Developed Data Conversion programs(EDI) using Component Interface and Application Engine to upload legacy HR data like Personal Data, Job Data, Education, Dependent Data, Benefits Components
• Customized the Refresh Employee Compensation Process (HR CMP015) in compensation module, modified the compensation rate code on the compensation tab in the Job data.
• Analyzed and resolved performance issues in existing interfaces.
• Resolved performance issues and debugging the App Engine and SQR processes.
• As a technical team member, involved in 12D/12E tax updates and performed impact analysis.

Confidential, IL

Techno Functional Consultant

Environment: Unix,Oracle11g,PeopleSoft HCM9.0 PeopleTools8.51 (Application Designer, People Code, Application Engine, Component Interface, File Layout, PS Query, Data mover) and SQR, AQT.

Responsibilities:

• Interacted with Users to understand the business requirements and developing technical specifications. Assisted and guided employees with report and interface development.
• Performed the design and development of several HR Payroll interfaces using Application Engine, SQR and Data conversion programs.
• Responsible for Developing and modifying inbound and outbound Interfaces using Application Engine, File Layout, SQRs for vendors.
• Involved in online changes like adding customizations, modifying People Code, adding fields to Record Definitions and pages.
• Involved in Tax updates and Bundles and analyzed customizations and impact.
• Analysis, Coding, Testing and Review of various interfaces, reports and customizations.
• Made extensive edits on PAY003 and DDP003 SQR’s and made the same changes in Paycheck in ESS.
• Involved in setting up Time & Labor module. Extensively worked (Time administration) on set-up of Time periods, Shifts, Reason Codes, Task Profile Templates, Task Entity Codes, Task Groups and Work Groups.
• Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.
• Customizing pages and components and created necessary records (tables), menus and portal objects.
• Modifying People Code and running Application Reviewer, trace, debug People Code to fix any issues.
• Performed troubleshooting the problem areas in setting up HR tables that serve as the foundation of Financials system and in producing Financials reports.
• Developed multiple SQR Reports and Troubleshooting Crystal/SQR Reports Problems.
• Implemented Row Level Security by creating Views, which will be used as Search Records
• Reviewing trace files for the processes, reviewing a trace for the workflow email notification Process, recovering from an abnormal termination (trouble Shooting), unlocking and rerunning an application engine process and preparing resolutions.
• Configured security controls for User setup, Page permission access, Data permission access, and Role setup.

Confidential, VA

Sr.Technical Consultant

Environment: Windows, Oracle11g, PeopleSoft HRMS/HCM 8.9/9.1 People Tools 8.48/8.51(Application Designer, People Code, Application Engine, Component Interface, File Layout, Workflow, PS Query, Data mover) and SQR, Toad.

Responsibilities:

• Modified and upgraded the pages in e-Performance and Manager Self Service.
• Customized and developed Benefit Interfaces like Caremark Interface.
• Developed the interface of Taleo process by using the Application Engine and Component Interface (CI) program for uploading the data of applicant’s in PeopleSoft system.
• Worked interfaces from PeopleSoft to third party system in Payroll interface.
• Played vital role in fixing few issues in data conversion in upgrade.
• Involved in Custom SQRs, App Engines programs are analyzed and retro fitted in 9.1 systems and also worked to enhance performance.
• Worked with Off-shore team to fix the issues and tickets and support as Team Lead.
• Taken responsibility of the whole module NADM.
• Involved in uploading data in Location Table and JOB Data conversion.
• Performed and fixed the data validations for various data conversions and interfaces.
• Developed and upgraded many pages with HTML areas as per client requirements.
• Co-Ordination and working with off shore and onsite team as a Techno-functional consultant in the upgrade of PeopleSoft 8.8/9.1HCM.

Confidential, PA

Sr.Technical consultant

Environment: Windows,Oracle10g, PeopleSoft HRMS/HCM 8.9/9.1 People Tools8.49/8.51(Application designer, People Code, Application Engine, Component Interface, File Layout, Workflow, PS Query, Data mover) and SQR, Quest Stat.

Responsibilities:

• Worked as a Techno/Functional consultant in the upgrade of PeopleSoft 8.9/9.1 HCM.
• Worked interfaces from PeopleSoft to third party system.
• Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from technical perspective.
• Performed Retro-fit on Custom SQRs, App Engines, and Pages.
• Designed and developed SQR outbound interfaces to generate Flat Files to be sent to the respective carriers, listing all the terminations and enrollments into various Base Benefit Plans during the Year-end/Open Enrollments.
• Created Data Mover scripts to migrate setup data between environments.
• Customized Application Engine programs to load payable times to Pay Sheet table from the Time & Labor table to meet the client’s business requirements.
• Involved in mapping TRC to earning codes. Tested the Application Engine programs with respect to Time and Labor for performance issues and proper functionality.
• Developed rules using Rules templates and compiled to add relevant section in the Application Engine (TL TA RULES) controlling the time administration process.
• Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.
• Created a new page in the Manger Self Service where the manger is allowed to see his employees and upon selecting an employee he/she can view the Leave Balances of that employee.
• Approval rule set and Activities were modified to route approval transactions and email notifications to administrators based on location.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration.
• Applied Tax-Updates. Retro fitted several PayCalc issues.
• Followed by Agile methodology to update the status of the tasks.
• Used Stat tool for migrate the projects and version control.

Confidential

Techno Functional consultant

Environment: WindowsXP,Oracle10g, PeopleSoft HRMS/HCM 7.5/8.3/9.0 People Tools8.5(Application designer, PeopleCode, Application Engine, Component Interface, File Layout, Workflow, Data mover, PS Query) and SQR, Toad.

Responsibilities:

• Customized delivered components according to user requirements and extensively worked on the Resume Processing application in e-Recruiting/TAM module.
• Customizing the Direct Deposit ACH transmittal file(DDP001) in NA Payroll.
• Created a People code Function (name -UO 180 Day Rule) to handle the 180 day rule logic that is called from the JOB record save in Benefit module.
• Resolved complicated defects related to their Pre hire and Rehire.
• Profile, Meal Period, Time Keeper Code, Device Group, Accrual Profile and Workforce Manager.
• Developed Data Conversion programs using Component Interface and Application Engine to upload legacy HR data like Personal Data, Job Data, Education, Dependent Data, Benefits Components.
• Many fields validations like Address field validations and Performed with People Code, and also used data traversing classes for retrieving the data in Component buffer .
• Customized and Retro fitted SQRs with new enhancements. Developed new SQRs according to requirements.
• Resolved performance issues and debugging the App Engine and SQR processes.
• Resolved performance issues like SQL tuning.
• Created and managed Approval processes by using AWE (Approval work flow Engine) in PMD/ESS module. Maintaining User Security and User Preferences and permission lists.
• Resolved production issues and Performance issues and Written Technical Specification Documentation.
• Done Technical specifications Documentation.
• Interacted with Business people to gather requirements along with functional consultants.

Confidential

Techno-Functional consultant

Environment: Unix, SQL Server, PeopleSoft HRMS/HCM, People Tools 8.48 (Application designer, PeopleCode, Application Engine, Component Interface, File Layout, Workflow, PS Query), and SQR.

Responsibilities:

• Designed and developed custom components under Employee and Manger Self service using the application designer based on the business requirement to in corporate reporting and approval of the Discipline and Ethic cases by the Managers.
• Developed e-Leave customized module which is facilitates the employee to apply leave and asks for Manager’s approval.
• Involved mainly in the customization of the tasks related to the benefits module reports
• 401 k interface has been developed in Pension module.
• Extensively worked with application designer to modify record definitions, pages, components, menus and giving access to them by using maintain security.
• Involved in creating Application Engine programs, File layout object for reading and writing from flat files by adding new sections, steps and actions through application designer
• Developed new records and pages definition as well as putting many reports and interfaces PeopleSoft online.
• Excessively worked with SQR for generating customize reports as required by the client.
• Process scheduler was used to run the SQR Reports. Created new process definitions for SQR Reports to run from the process scheduler
• Created queries for HR and Benefits using PeopleSoft Query tool.
• Developed and tested Excel to CI.
• Executed jobs on Putty tool and analyzed Perl Scripts.
• Data accessed in to Component buffer by Data traversing classes.
• Concentrated in design, code, develop, and debug new and existing reports, interfaces using people tools, SQL/SQR and PeopleCode.
• Toad is used to check the SQL scripts.
• Done Technical specifications Documentation.
• Done peer reviews and performed Unit Test cases.

Confidential

Technical consultant

Environment: PeopleSoft HRMS/HCM 8.9(HR, ESS, MSS, Benefits, e-Recruitment, Global Payroll) and GL People Tools 8.42(SQR, Application Engine, Component Interface, File Layout, Workflow, PS Query, Oracle8i, SQR, Crystal Reports, Windows2000.

Responsibilities:

• Many Field validations have done on Personnel information pages like addresses, city, phone number by using PeopleCode according to Client’s requirements
• All existing PS/Queries are analyzed and created by user specifications.
• Made extensive edits on PAY003 and DDP003 SQR’s and made the same changes in Paycheck in ESS.
• An interface developed between PS systems to non-ps Payroll system to send a Tax-exclusion code.
• Customized Application Engine programs to load payable times to Pay Sheet table from the Time & Labor table to meet the client’s business requirements.
• Created and customized new objects like Field, record, page, component and menu according to Client’s requirements.
• Few page fields are modified according to Clients requirements by using Application designer.
• Many SQR programs are tested, analyzed and Peer reviewed of other team mates developed.
• By Using file layout data been uploaded into PeopleSoft system.
• By Using SQR have developed reports like Employee details of Employee status, joining date, termination date etc.
• Many interfaces have been developed by using SQR for inbound and out bound operations.
• Done Technical specifications Documentation.

Confidential

Technical Team member

Environment: Mainframe, DB2, PeopleSoft HRMS 8.4, People Tools 8.40 Application designer, PeopleCode, Application Engine, Component Interface, File Layout, Workflow, PS Query) and SQR.

Responsibilities:

• Responsible for development and implementation of PeopleSoft applications, using People Tools, People Code, Query, Crystal and SQR programs.
• Tuned SQL statements to improve performance of HR and Payroll processes.
• Worked as a developer in HRMS (7.01/7.03) implementation project. Converted Payroll and HR data from ADP to PeopleSoft.
• Ran many job processes by using JCLs.
• Used application designer to modify existing tables and create some new tables and views to meet the application needs, created many pages and modified the existing menus to reflect the customized pages and controlling the program flow with People Code.
• Developed programs to upload the data into PeopleSoft application tables from flat file using SQR and Application Engine.
• Employee time card interface (PeopleSoft and Kronos) is developed in Time and Labor module.
• Used People Code to control the program flow and logic and for validations to meet the current business requirement.
• Performed Unit Testing on the customized SQR reports
• Extensively worked on SQR in Account Payables module, generated reports according to the Technical Specs.
• Prepared Technical specification Documents, according to task.

Confidential

Technical Consultant

Environment: PeopleSoft HRMS 8.8, People Tools 8.42, DB2, SQR, Mainframe.

Responsibilities:

• Involved in the complete life cycle of PeopleSoft HRMS. The modules include Human Resources and Benefits.
• Created run control pages and records using PeopleTools with input sort parameters to run the reports through the process scheduler.
• Customizing the existing reports and also creating new HRMS reports Using SQR like personal data changes report, employee and employer Contributions monthly wise reports.
• Customized various Records, Pages and Component according to the client’s requirements using application designer.
• Developed an interface for employees who are enrolled in different life plan types. This output interface generates a text file, which contains all active employees based on company.
• Prepare Technical design documents based on the Business Requirement Document.
• Responsible for writing SQR for uploading to PeopleSoft database from Flat Files for HR tables.
• Executed job process by using JCLs.

Confidential

Technical Team member

Environment: Windows NT, Oracle 8.0, PeopleSoft FSCM 8.4(GL, AP, AR, PO, AR), People Tools 8.40.

Responsibilities:

• Responsible for development and implementation of PeopleSoft applications, using People Tools, People Code, Query, Crystal and SQR programs.
• Used application designer to modify existing tables and create some new tables and views to meet the application needs, created many pages and modified the existing menus to reflect the customized pages and controlling the program flow with People Code.
• Developed programs to upload the data into PeopleSoft application tables from flat file using SQR and Application Engine.
• Used People Code to control the program flow and logic and for validations to meet the current business requirement.
• Performed several online customizations for PeopleSoft Project Costing module.
• Performed Unit Testing on the customized SQR reports
• Extensively worked on SQR in Account Payables module, generated reports according to the Technical Specs.
• Prepared Technical specification Documents, according to task.