SUMMARY:

• Progressive experience in software development life cycle with rich experience in application support, requirements gathering, analysis, design, development, implementation and testing of PeopleSoft HR applications .
• Highly skilled at full life cycle implementation, Upgrade, Development and support of PeopleSoft HRMS solutions covering all major modules such as Core Human Resources, Benefits, NA payroll, Canadian Payroll and Base Benefits.
• Strong implementation/support skills and high level business process knowledge starting with version PeopleSoft 8.x, 9.0, 9.1 and 9.2. The most recent experience includes 9.2 on Tools 8.54.
• Worked as a Techno - Functional consultant in end to end PeopleSoft Canadian pay and benefits implementation.
• Proficient in People Tools - Application Designer, People Code, Application Package, Application Engine, Integration Broker, Upgrade Assistant, Maintain Security, File Layout, Component Interface, Process Scheduler, PS Query and Data Mover.
• Working Experiences in Databases like Oracle and SQL Server
• Involved in documentation of technical specifications and developing unit test cases .

TECHNICAL SKILLS:

Module: Canadian Payroll NA Payroll Core HR Base Benefits Recruiting ePerformance

People Tools: Application Designer People Code Application Engine Component Interface Application Package Integration Broker File Layout Java Script Data Mover STAT

Reporting Tools: SQR PS Query

RDBMS: SQL Server 2005 Oracle PL/SQL 9.0

Other Technologies: C# .Net, VB, VBA and VC++

PROFESSIONAL EXPERIENCE:

Confidential, NYC

PeopleSoft Developer

Environment: PeopleSoft 9.0 to 9.2

Responsibilities:

• Retrofitting Components, Pages, Application Package, PeopleCode, Application Engine, and Queries to 9.2 based on 9.0 customizations.
• Developed new Synchronous Interfaces to exchange arrest information between FISA and Deportment of Education.
• Retrofitted both Synchronous and Asynchronous interfaces for Ethnicity structure changes to all external vendors.
• Designed and customized existing page for Ethnicity Information changes.
• Created Application Engine and Component Interface programs to convert Accomplishment and Ethnicity information data from 9.0 to 9.2.
• Retrofitted HR and Recruiting based on new requirements and customizations
• Retrofitted several views to carry forward 9.0 customizations to 9.2.
• Involved in the testing phase during various cycles of testing of the application by setting up the test cases and analyzing and fixing the issues reported
• Used STAT for all versions of PeopleSoft objects (including non-application designer objects) AND flat files (including SQR, SQL, SQL and scripts) are versioned and stored indefinitely in the Stat repository
• Created jobsets to schedule/automate the daily process to clean up the data.
• Involving in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.
• Involving in resolving day-to-day production tickets and application maintenance.

Payroll Design Architect

Environment: PeopleSoft 9.2

Confidential, Albany

Responsibilities:

• Involved requirement gathering and setting up Core HR, Base benefits, Paygroup, Earnings, Deductions retro pay/deductions and pay calendar tables.
• Converted all payrolls and benefit data from legacy system to PeopleSoft such as Person, job, benefit elections, Balances, Tax, Earnings, Deduction, Direct deposit.
• Designed and developed Excel - to - CI tool for person, direct deposit, saving and pension plan.
• Designed template based outbound interface for external files.
• Worked closely with development team to complete the interfaces.
• Involved in collecting Case document from Canada and setting up Garnishment in PeopleSoft system.
• Involved in fit gap analysis for the base benefits and students reimbursement.
• Design and implementing page and row level security for Canadian population.
• Worked with internal businesses to setting up SFTP connection for submitting the T&L files.
• Worked with External vendors to setting up internal/external file transfer.
• Created template for manual tax calculation for each province.
• Involved in requirement gathering, design and config for tuition reimbursement workflow and pension base benefits.
• Reconcile the Earnings, taxable earnings, deduction, tax and accumulators against legacy system.
• Manually calculating the tax for all states
• Working with security team on infrastructure readies for each stage.
• Updated and maintained payroll document and process.
• Involved loading all T&L, special pay and deduction files for testing and fixing the errors; Ongoing User support, application training and troubleshooting for HR users

Developer - PeopleSoft ERP

Environment: PeopleSoft 8.9,9.1

Confidential, Albany

Responsibilities:

• Performed retrofits on SQR’s, Components, Pages, Application Package, PeopleCode, Application Engine, and Queries to 9.1 based on 8.9 customizations
• Created an Application Engine program using Component Interface to convert HR, Benefit and Payroll data from legacy system to PeopleSoft such as Person, Job, Benefit elections, Balances, Tax, Earnings, Deduction, Direct deposit.
• Developed various Outbound and Inbound Interfaces for transmitting employee health enrollments and dependent details to Benefits vendors and process the incoming data to insert into various PeopleSoft tables.
• Created Components, Pages and written various complex PeopleCode for new enhancements
• Development of enhancements/reports and associated Technical Specification Documentation and review.
• Customization and enhancements on various modules as per Business need starting from requirement gathering till migration to live environment including necessary quality documentation and audits as per CMMI
• Involved in analysis of the defects reported during various cycles of testing and responsible for fixing the issues reported
• Involved in production support of HR, Benefits, and Payroll and Self Service modules.
• Educating payroll leads to understand payroll setup/config required for their testing scenarios.
• Created a program to setup up calendars, assigning runID’s and to artificially confirms all prior calendars.
• Developed an SQR to print the employee’s personal information, benefit plan type, and the deductions amount for the plan and plan type using HR, Benefits and Payroll tables.
• Involved in setup of security for all the custom components and pages.
• Involved in validation of payroll inputs such as T & L, special pay and deductions both file and table level.
• Involved in analyzing payroll processing jobs such as Calculation errors, Overrides, insurance pro-ration.
• Understanding the payroll errors both setup level and employee level and helping on the fix.
• Reconcile the paycheck such as Earnings, taxable earnings, deduction, Tax and Garnishment against production during the releases and get sign off from respective leads.
• Updated and maintained payroll document and process.
• Coordinate with the payroll team to meet planed deadline for the payroll processing.
• Developed Tool to Semi-Automate Payroll reconciliation - to reduce manual reconciliation effort and time using VB Macro code.
• Developed Tool to help Marketshare calculation using VB Macro code.
• Developed Tool to help Marketshare projection using VB Macro code.
• Ongoing User support, application training and troubleshooting for HR users

Sr. PeopleSoft Developer

Environment: PEOPLETOOLS 8.52 and Oracle 9.1

Confidential

Responsibilities:

• Obtain high level business requirements from the business users and translate it into detailed Business Requirement Document
• Created technical specification document based on the business requirement
• Involved in creating a customized dashboard to track client’s multiple business information across the Globe.
• Created PeopleSoft Interactive Charts, Navigation links using Java Script, Drill down Level unique information, Pop up window using Java Script to show the information in user friendly format
• Created Components, Pages and written complex PeopleCode to show information in dimensional view
• Created SQR programs to produce various reports containing the HR OPS, PAYROLL OPS, CRM, PORTAL, RNR, LSA, INTERPAY & e - Leave data
• Created application program for inbound interface.
• Created Application package program to maintain the complex PeopleCode.
• Written PeopleCode to restrict the view and update of information in the geographical page based on the user role
• Development of enhancements/reports and associated Technical designs and review
• Involved in creation of a custom portal page using Pagelets and Workcenter.
• Modified stylesheet and web-lib PeopleCode to meet the look and feel of the business requirement
• Created various Components, Pages and written complex PeopleCode to meet client requirements
• Involved in data mapping between the legacy and PeopleSoft system
• Created an Application Engine program to load HR and Benefits data into PeopleSoft using Component interface
• Created a custom PeopleSoft page to facilitate the Acquisitions and Dispositions with the business information, employee details etc.
• Implemented row level security and restrict user updating of fields using role based security.
• Created SQR program to generate various business reports.
• Involved in creation of custom reservation line module to assist the support desk in automating the reservation of seats.
• Created various Component and PeopleSoft pages to track employee’s information, reserve seats and to schedule appointments. data mapping between the legacy and PeopleSoft system
• Created an automatic process using Application engine to move the wait list employees to the confirmed state based on the cancellation from the reserved list
• Created a workflow notification using send mail functionality to communicate the change in status to the employees
• Created various reports to show the list of reservations and wait list details and the insurance and other benefits data

Confidential

PeopleSoft Developer

Environment: PeopleSoft 8.8 -9.0

Responsibilities:

• Involved in fit-gap analysis using compare reports to retro fit using the custom built in house tool
• Performed retrofits on SQR’s, Components, Pages, Application Package, PeopleCode, Application Engine, and Queries to 9.0 based on 8.8 customizations.
• Created new enhancements on HR and Benefits modules based on new requirements and functionalities.
• Retrofitted several views/records to carry forward 8.8 customizations to 9.0
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators based on Permission Lists and Data Security.
• Created Unit test scripts to test the business functionality for the delivered code based on the requirements.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Involved in the testing phase during various cycles of testing of the Application by setting up the test cases and analyzing and fixing the issues reported; Ongoing User support, application training and troubleshooting for HR users.

Confidential

Software Developer

Environment: C# . Net 2003 and 2005, VB and VC++

Responsibilities:

• Siveillance™ Fusion, which is a Security Management system integrating Access Control, Intrusion, Fire & Safety, Video Management and Building Automation into single system. It provides a platform independent, extendable and user friendly solution for complete building automation through web and desktop interfaces. It is light weight and has interoperability since it uses XML over remoting.
• Worked in Virtual Matrix module which is involving rendering videos in user selected matrix format (1X1, 2X2 etc…). It supports both analog and VGA monitors and the high level user access security is implemented to view this virtual matrix.