SUMMARY

• An IT professional with 8 years of experience in Peoplesoft HR/HCM,FSCM Solutions with varied expertise in HRMS modules .
• Worked on various Production Support, Implementation and peoplesoft Upgrade projects.
• Worked on Requirement Gathering, Designing and Development of Business solutions to the problem or change.
• Experience in Conversions, Migrations, Interfaces and Reporting.
• Provide effective systems development using: PeopleTools, PeopleCode, Application Designer, Application Engine, Component Interfaces, Integration broker, Application Messaging, PeopleSoft Security, Process Scheduler, Data Mover, PS Query, Crystal, and SQR.
• Hands on experience on working with Oracle and SQL Server databases.
• Benefits administration, ePerformance,eCompensation, N.A Payroll,Maintain Workforce, Personal Profile, Employee Self Service,BaseBenefits, Manager Self Service,General ledger.
• Expertise in performing Fit - Gap Analysis and technical designs and business process flow in a peoplesoft version upgrade projects for upgrade projects to 9.1.
• Expertise in Application development in using PeopleTools (7.5 to 8.51 xs).
• Experience in Transferring existing data from legacy system to PeopleSoft application database tables using SQRs, Component Interfaces, Application Engines & File Layouts.
• Strong technical expertise in writing/debugging People Code.
• Worked on various testing phases on full cycle project (unit testing, functional testing, regression testing performance testing, integration testing, UAT testing) in Peoplesoft (mainly technical).
• Good communication (verbal/listening) and presentation skills. Hands on experience on handling client & business calls and meetings.
• Excellent skills and in presenting workshops and at team meetings.
• Worked with technical and functional team and User community. Able to work independently as well as in a team.

TECHNICAL SKILLS

ERP Technology: PeopleSoft Peoplesoft 8.0/8.0 SP1, 8.3, 8.8,8.9,9.0,9.1 SQR, SQL database, PeopleCodeApplication Engine, CI, oracle PL/SQL programming etc

Application Area: HRMS (Maintain Workforce, Personal Profile, Employee Self Service, Manager Self Service,ePerformance,eCompensation,N.APayroll,Time & Labor,Benefits Administration): Finance (eProcurement,General Ledger).

People Tools: People Tools 7.5, 8.0, 8.43, 8.44, 8.45, 8.46,8.5.8.51

RDBMS: Oracle 10i, MS SQL Server,Mainframe

App/Web Server: BEA Weblogic,Dotnet Framework 2.0

Reporting Tools: SQR, Crystal Reports, PS/Query

Operating Systems: Windows NT, Windows 95/98/ME/XP, MS-DOS, UNIX etc.

Database Tools: TOAD, PL/SQL Developer, Query Analyzer etc.

Programming Lang: C#,VB.net,Peoplecode

Migration Tools: Harvest,Stat5.5.5

PROFESSIONAL EXPERIENCE

Confidential, Atlanta,GA

Peoplesoft HCM 9.1 Technical Consultant

Responsibilities:

• Worked with BN HIPAA5010 Appengine Interface program,Fixed the issue in the interface file such as benefits effective date cannot be less than current CED subscriber effdt,Added DTP348 rows for termination,EE transfers from one company to another send Jobeffdt .
• Modified the interfaces to make it compatible for the Open Enrollment 2013
• Developed new interface file for new FLEX corp vendor and, created the Eligibility and Contribution files using Application Engine.
• Worked with the custom interface,EE Exports to Allegiance Benefit This interface provides an export of only COBRA Eligible employees.Eligible events are Terminations,Retirements,Death,DependentBecoming ineligible,Reduced hours,Divorce/Seperation.
• Created a Setup page to Derive the HIPPA Plan code for the 2013 open enrollment process.
• Created the Disability data map conversion program using Application Engine, Component Interface and file layout.
• Worked on Integration broker to send Vendor data from Peoplesoft Accounts payable to PeopleSoft HCM in order for vendors to be selected for garnishment payments.
• Used Integration broker to enter Employee Reimbursements through Expense module. Inorder to minimize data entry, it was programmed in a way that HCM would only send over non-sensitive Employee data to pay the employee and create the Employee Profile within the Expense Module.

Environment: Peoplesoft HRMS module Benefits Administration and Core HR. Peopletools 8.51, PS version 9.1,App Engine,Component Interface,Integeration broker,peoplecode Oracle Database

Confidential, Warren, NJ

Peoplesoft HR/HCM 9.1 Report Analyst

Responsibilities:

• Developed a compensation view report for all active employees based on the pay period using sqr.
• Worked on Lotus notes outbound interface to feed the General profile,Employee profile and Employment profile files created using sqr to the peoplesoft.
• Created script to get the pri HR mgr and his roles from the DEPT ROLE table and display in column basis.
• Developed App engine program to load location zip code from flat file to Geographic Location Elig Table.
• Additionally added compare report logic.
• Defined user document and design specification.
• Involved in testing and creating test document for GEO code.
• Worked on developing the sqr to generate Self Assessment & RA PDF reports for 6 month Annual,6month client, IP LA and below.
• Created ad-hoc sql queries to pull Roles, Goals and Development data from production for Senior Associates.
• Created ad-hoc query to pull data against all the closed FY2011 PDPs.
• Setup Template definition for 6 month IP LA and Below Reviewer assessment and for 6 month IP LA and Below Self assessment
• Modified delivered page, Added Push button name View Pdf document, through this button passing Runctl id and generate PDF file.
• Created Page called ePerformancePdf solution. Its similar to a Setup Page, using this page, one can dynamically add/change PDF Version of documents, like which SQR Report Process Definition belongs to which Template and document type.
• Involved in creating Application Engine Program to Do batch or Mass ePerformance Document Print and email. It was altered so that only Super User or HR Manager can select multiple employees’ document, print and email it.
• Worked On Integeration Broker PeopleSoft AP will send Vendor data to PeopleSoft HCM in order for vendors to be selected for garnishment payments.
• Developed new search page to search employees with given criteria for Batch ePerformance document print Project, which involves we can select particular employees.

Environment: Peoplesoft HRMS modul eEperformance,Benefits Administration and Core HR. Peopletools 8.51, PS version 9.1, Oracle Database,SQR,UNIX,Mainframe

Confidential, Pittsburgh,PA

Technical Consultant

Responsibilities:

• Worked on BW ( Black Water) acquisition, Loaded nearly 100 employees through conversion programs.
• Modified the ESS home address page to in corporate the PA Act 32.On the ESS page the PA residency certification form was added.
• Fixed the Comp Summary page for 2009 for GIS so that the salaries for acquisition displays on the page. The program was updated to get the salary from the dev table to populate the page.
• Worked on ProHis Currency Conversion Rate to produce the required output in the ProHis pages and printout.
• Set up Ethnic code on the regional tab such that the ethnic description displays and the ability to update the field is only available under the US flag where as it is not for all other flags (AUS, GBR, MYS, NZ, SGP).
• Worked on Wage data load from NGA interface audit and Stock Option Expense GL Posting sqr’s.
• Modified program ZVCM027 SQR to issue a warning message when upon attempting to insert a new plan row into the plan table it recognizes that the most current row for the period in question is already a plan row. The program allowedInsertion to proceed but warning message was generated..
• Worked on adding Query security: Added row security to the following queries table 'VC EMP PL MB', 'INCTV REPO VWMB', INCTV-REPOS2-MB', 'INCTV-REPOS1 mb' and 'VC EMP PLD VWMB'.
• Updated MDA reports to included U and T status: In the reports to listing for MDA, updated the list to include reports that are in U status and reports that are in T status for the current calendar year.
• Modified ZINT223 and ZINT223a SQRs: ZINT223 SQR was modified in order to exclude any employees who have LTO, LTD or LTA printed in either of these fields. In turn, ZINT223a will also exclude these employees as it is a summary of the output of the ZINT223 file.
• Updated ProHis Salary on Current Job and History: Updated the history page on ProHis to only include base salary for non-US employees.Also modified the page so that the ethnic description appears on the ProHis Employee Demographics whose Business Unit is MEL.
• Modified EMP DEV VW MB: removed any reference to the “DEV3” table within the view.
• Updated ZCOM007 SQR so that the non-US Leave Ls and Ps drop into job when the Business Unit does not equal Mel.
• Inorder to show additional employees on the MDA Reports to Screen, the list was updated to include reports that are in U status and reports that are in T status for the current calendar year.
• Wrote sql scripts to delete rows in PS PAY PAGE that do not have any corresponding child records and to update missing term dates in Job and Term data table.

Environment: Peoplesoft HRMS module,NA payroll, Benefits Administration and Core HR. Peopletools 8.49, PS version 8.9, Oracle Database,UNIX,Mainframe,Harvest,Stat5.5.5

Confidential, VA

Technical Consultant

Responsibilities:

• Worked on Configuration pages on eCompensation salary planning process tables.
• Created the HR Support Assignment Page and programmed it to distribute the assigned population of eligible employees into several HR Support users. Overall Approver Assignments can be performed by HR Leads using this page. HR Leads were able to use the page to identify the Overall Approver by assigning the approver’s name to the selected organizational alignment group.
• Worked on Planning & Approving manager Assignment Page, the main goal of was to be used by the HR Support user to assign Planning, Approving and Overall Approving Managers utilizing the previously assigned roster of employees.
• Developed an Application Engine program for Update Assignment Process, the developed program recreates the planning group totals table for all future cycles and summarizes the amounts and counts for the planning group.
• This program was also designed to be only executed when the Cycles are Close (for the first time the Cycle will be in Build Status) and just before opening the Cycle.
• Used App Designer such as page, component, menu, record for Runcntl page to develop run control page.
• Involved in making changes like adding customized translate values, modifying PeopleCode, adding new fields to the pages, etc.
• Developed XML Publisher reports to print Average Merit Increase by level and rating.
• Created XML Publisher reports to planning Merit /promotion/MSA/ spend by market and account.
• Developed PS Query to dump the salary planning data and salary exceptions.
• Monitored batch jobs through Process Monitor and emailed end users logs, reports.
• Technical and functional testing based on functional specification document
• Analyzed business requirements, functional specifications, UML documents and dataflow diagrams and developed Test Requirements.

Environment: Peoplesoft HRMS module, Peopletools 8.50, PS version 9.0,Ecompensation,XML Publisher,AppEngine,AppDesigner, peoplecode,Oracle Database

Confidential, Hamilton,VA

Technical Consultant

Responsibilities:

• Participated in appropriate fit / gap sessions, to create and resolve issues related to upgrade, conversions, customizations, and interfaces.
• Identified the areas where upgrade is required and then applying the fixes where needed (batch programs).
• Involved in data analysis and data conversion during the implementation of the person model.
• Ran Compare Reports between Demo Database and Current Production Version and prepared the Upgrade Analysis document.
• Developed technical requirement documents for the new customizations in accordance with the functional requirements.
• Upgraded all the changed objects from current production version to new version as specified in the Upgrade Analysis Document.
• Customized the existing records, pages & components and Created New Fields, Records, Pages, Components & Menu definitions as per the client requirements using Application Designer.
• Extensively used PeopleCode during customizations as well as in new development.
• Modified the existing Application Engine & SQR programs as per the table changes of 9.0 without affecting the existing functionality. Modified customized SQR Programs and Reports in version 9.0 to make it version 9.0 compatible and to accommodate the new key structure.
• Modified & Developed interfaces using SQRs.
• Involved in configuring security for modules including permission lists, roles, and user profiles.
• Developed and customized workflows based on the business requirement.
• Used PS Query extensively and experienced in attaching PS Query Security to various custom records by creating trees and access groups.
• Developed various component Interfaces to convert data from existing databases, Flat filesand Excel spreadsheets into the PeopleSoft system.

Environment: People Tools 8.50(App Design, App Engine, People Code, Component Interface, Workflow, Process Scheduler, PS Query, PS Security, PeopleSoft Architecture (PIA).), SQR, Oracle 9i and Windows XP

Confidential, Topeka,KS

Technical Consultant and Developer

Responsibilities:

• It’s an interface application, gathering audit data from HRMS database for employee details, which includes employee’s personal details, job details and etc...
• This application takes information about employees audit details over given period of dates. Means its collect information about what updates made for given period of time. And stored in file and transferred to external system.
• Worked on Custom bolt-on application to Load the daily timkecard activities for hourly employees using Time entry timesheet also validate summarize and load this information into a specific paysheet(upload process).
• Worked on Project Time report in T&L,This report shows the total hours charged to a project by employees for a week,month, year or a custom time period using XML Publisher.
• Worked on Time reporting codes report,This report shows the total hours reported for time reporting codes for an employee or a department. This report is run on an ad-hoc basis
• We developed this application using App engine, since its collect mass data. And this application runs through process scheduler on daily basis.
• Helped with QA team for hire employee and setup job table and personal tables like transfer employee, location change, dept change and so on.
• Involved in production support and online transaction for personal and job data for instance employee department change, location change, action change, terminate employee, re-hire employee and hire a new employee for testing in HRUAT.
• Customized the app engine, peoplecode, Component Interfaces, pages, components, menus, SQR, PS Query, Crystal reports etc.
• Used App Designer such as page, component, menu, record for Runcntl page to develop run control page.
• Defined user document and design specification.
• Involved unit testing and creating test document for interface application.
• Analyzed business requirements, functional specifications, UML documents and dataflow diagrams and developed Test Requirements.
• Involved in configuring security for HRMS modules including permission lists, roles, and user profiles.

Environment: Peoplesoft HR and tools 8.47 in peoplesoft version 8.8,XML Publisher,T&L Oracle Database

Confidential, Virginia

Peoplesoft HRMS Development and support

Responsibilities:

• Setup Template definition for 6 month IP LA and Below Reviewer assessment and for 6 month IP LA and Below Self assessment
• Worked on gathering requirements on ESS and MSS modules and designing the business process for clients to request a requisition for open position, compensation, promotion and transfer of direct reports.
• Worked on Time Reporting Codes, establishing workgroups, task reporting requirements in Time and Labor module.
• Custom rules design required around schedule definitions and beginning of shift or majority of shift configuration.
• Set up Time and Labor tables for implementation.
• Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security).
• Online customization to support business requirements and performance improvements for timely data entry for Timesheet and security changes for manager access.
• Modified an existing rule using online tools, set up and view trace files, and use recommended troubleshooting procedures
• Customized record definitions and pages of Time and Labor module
• Customized and developed Queries as per the user requirement.
• Developed Process flows in the Time and Labor application
• Worked in creating new Application Engine programs and also in debugging existing programs.
• Analyzed the Test plan and responsible to enhance in the areas of Automation approach, Test Methodology, quality considerations and Metrics
• Maintaining PeopleSoft user security using user profiles, roles & permission lists.
• Analyzed business requirements, functional specifications, UML documents and dataflow diagrams and developed Test Requirements.

Environment: Peoplesoft HRMS module, PL/SQL programming in Oracle, Peopletools 8.46, peoplesoft 8.8.

Confidential

Peoplesoft HCM support

Responsibilities:

• Worked on the design part of the project on technical side.
• Collected the requirements from the business.
• Did the fit-gap analysis, requirement gathering and created functional and technical documents.
• Configuration of core set-up tables, creation of custom records for prompt & translate tables as well as populating the set-up table.
• Worked with creating a new Job entry process. This took care of the requests made by various departments to accept the new employees (or changes to the existing information) as entered by them.
• Translating business requirements into technical design documents that can be used to further enhance the product's feature set.
• Involved in setup of SetID table, Company Information, Establishments, Location, Department, Salary plan, Job Code and Pay Group tables for HRMS System.
• Enrol employees into benefit plans and setup dependent and beneficiary data.
• Modified existing workflows like promotion and salary change approval from a two step to three step process.
• Designed & Developed Workflows for sending notifications to managers. All the safety cases created should be reviewed and classified before submitting to the vendor. To ensure this, we implemented Workflow with Work list & email notifications sent to their supervisors.
• Involved in Data Migration for NA Payroll. Migrated payroll data from ADP system to PeopleSoft.
• Created new permission list and assign the permission lists to the roles and assigns the role to the user as per the business requirements.
• Configured and maintained all the tables involved in Payroll processing such as Pay calendar, Pay Group, Deductions and processes such as Pay sheet creation, Pay Calc, Pay confirm, Tax Tables etc
• Uploaded data into JOB data component using CI for new hire and update data for existing employees or terminate employee based on data in flat file.
• Translated some of the overlapping departments and Job codes.
• Involved in setting up connectivity between third party system and PeopleSoft using integration broker.
• Designed and Developed workflow for leave approval process as per the client requirement.
• Upgraded SQR Reports and SQC’s per keeping in view of the changed structures of the table.
• Customizations using People Code depending on the client requirements.
• Daily reports were created and sent to appropriate users via emails generated through workflows.
• Maintaining PeopleSoft user security using user profiles, roles & permission lists.
• Worked with the Testing team and the users and helped them out in the testing process of different SQR’s.

Environment: Peoplesoft HRMS module, Peopletools 8.46, Peoplesoft 8.8.

Confidential

Technical Consultant

Responsibilities:

• Configuring and set up of self service application
• Responsible for delivering Understanding business requirement by interacting with the business users.
• Designed. Developed and customized the Configurable search setup and saved search.
• Customized the Core modules.
• Worked with Peoplecode to customize application with strong use of Application engine.
• Creation of High/Low level designs for the use cases.
• Handled technical/functional issues during production.
• Analysis of functional requirements, preparing technical specifications, test plans, co-ordination of user acceptance testing for every change management requests.
• Extensively worked with Application Designer to modify record definitions, pages, components, menus and giving access to them by using maintain security.
• Involved in estimation, analysis, coding, testing and review phases of work based on user requirement.
• Worked on development of PS queries using core HRMS tables for end user frequent requirements.
• Developed various Crystal Reports for analysis with the help of graphs.
• Implementation of PeopleSoft customized application objects from development into production.
• Helped in setting up security in version 8 environment, creating permission lists and assigning them to roles.

Confidential

Technical Consultant and Developer

Responsibilities:

• Involved in development and maintenance of ePro
• Tailored People Code to implement data validation and to enforce field level security.
• Involved in creating complex queries using SQR and PS Query Manager.
• Developed interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interface.
• Developed different custom reports using SQR and PS QUERY Reports according to user specifications
• Generated reports using SQRs, to calculate how many requisitions have been made in ePro for the given duration and gave permission and roles for that particular page to run the report.
• Worked on permission list for giving access to pages designed in App Designer.
• Used Process Scheduler to run scheduled processes at a specific time and/or run recursively at a specific interval and used Process Monitor to view status of the process.
• Used file layouts and SQL classes while pulling and pushing data from People soft applications and Flat files.
• Customized the Item definition page extensively.
• Unit testing and demo to the business of tasks worked on.
• Worked closely with the DBA to optimize SQL, thus performance tune applications
• Developed new Run Control Pages for the process scheduler.
• Technical and functional testing based on functional specification document

Confidential

Dot Net Developer

Responsibilities:

• Involved in developing complex data structures, views and business oriented stored procedures.
• Developed web services in the business layer to communicate with the application layer using C#.NET
• Involved in implementing Active Directory - AD group based security, roles & permissions for the application.
• Involved in implementing Microsoft Application Blocks for data access, security and logging.
• Involved in designing the user interfaces using Web Forms.
• Used N-Tier Architecture for presentation layer, the business layer and data access layer and coded in C#.
• Designed User Interface using ASP.NET, HTML, CSS and JavaScript.
• Designed the Time entry module that deals with attaching, viewing and deleting files.
• Designed the Voucher Invoice module that deals with sending email, email to client etc.
• Created Reports by using Crystal reports for the Manager who wants to send the details of Invoice based on monthly, semi-monthly, Weekly and bi-weekly.
• Coordinated with QA team during QA and Preproduction testing process for the project.
• Writing Test cases and performing Unit tests and regression tests.
• Involved in fine tuning of the application for better performance.
• Involved in creating small scripts to import excel data to SQL server database.
• Followed agile methodology (Scrum Methodology) for developing the application.

Environment: C#.NET, Web forms, Visual Studio 2005, DOTNET Framework 2.0, SQL Server 2005, Crystal Reports, CSS, and Windows XP.