PROFESSIONAL SUMMARY:

• Areas of expertise include Oracle 11g, HP-Unix Ver. 11.0, and SQL Server 2005/2008.
• Expertise in preparing the Functional and Tech. Design Specifications.
• Excellent understanding and experience in PeopleSoft Internet Architecture and System Admin.
• Strong Expertise in Reporting Tools like SQR, Crystal Reports, XML Publisher, PS nVision.
• Excellent knowledge and experience in PeopleTools - Application Designer, PeopleCode, Application Engine, File Layout, Component Interface, Security, PS Query, Tree Manager, Process Scheduler Manager, Data Mover.
• 13 years of experiences in building and deploying and administering new Web-, Application- and Process Scheduler Servers for PeopleSoft Applications and administering the Servers.
• Analysis, Design, Coding, Testing, Implementation, Customization, Interfaces, Reports and Upgrade of PeopleSoft HRMS/HCM HR, Payroll North America, Payroll Interface, Benefits Administration, Time Labor, Talent Acquisition Manager, eProfile, eBenefits, ESS , MSS PeopleTools 8.45/8.49/8.51.
• 13 Years of Techno Functional experience in PeopleSoft Platform in Singapore and the U.S.A, which includes Software Lifecycle and Methodologies with following modules
• Over 14 Years of experience in Information Technology, and in the software industry involving Analysis, Design, Development, Testing, Implementing, upgrade and support of application software.
• Expertise in Approval Workflow Engine AWE and setting up and administering Integration Broker/Web Services.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

• Working as Team Lead: Production Support for PeopleSoft HCM, Base Benefits, NA Payroll, Time Labor and Talent Acquisition Manager, eProfile, eBenefits, PeopleSoft Campus Solutions, PeopleSoft Payroll Interface modules.
• Work on Break fixes/Change Requests/New Projects/Enhancements, design, develop, unit test and migrate code changes/interfaces to Test database. Update the HP Quality Center ticket queue with the resolution status. Create RFCs and CRs Change Requests for migrations, co-ordinate migrations across environments and update/close the requests.
• Co-ordinate work allocation, follow up, peer review code, arrange for testing and migration to production for all the HP Quality Center tickets.
• Co-ordinate with the DBA/System Admin teams for application of Bundles/Tax Updates/Patches to DEMO, retrofitting, testing and migrating to other environments and finally to Production. Recently applied Bundle 16 and Tax Update 14C to HRMS and Bundle 34 to CS.
• Modified customized PAY003 and DDP003 SQRs and BI Publisher PYSMTPLT.rtf sub-templates to print Total Current Hrs and Total YTD Hrs for Hawaii Employees per Hawaii State Labor Regulations.
• Modified custom program ULPYEXPX.SQR to process Expense Transfer on multiple positions correctly.
• Modified custom Bonus Processing SQR to stop processing if the OFF CYCLE is missing and RUN ID does not match OFF CYCLE flag and PAY END DT in PAY CALENDAR table.
• Data fix for PRIMARY INDICATOR field in Diverse Ethnic table so that all US Employees have one primary ethnicity.
• Data Fix for EEO Verbiage for the job openings: Replace the verbiage with the updated one for job openings with certain statuses this was achieved thru SQL Update statement.
• Modified custom SQR for loading Voluntary Benefits data into GENL DEDUCTION so that the correct row of JOB data table is picked prior to this, the interface process was erroring out if the Employee had a previous CWR row.
• Modified custom SQR to set the correct output folder path and archive folder path in line with other SQRs.
• TAM: Created a new PS Job by adding a custom SQR to the delivered App. Indexing process, so that the temp. Folders are deleted after the indexing process completed.
• Create Service Requests on Oracle Support website to post problems/issues in the applications, follow up and implement resolutions recommended by Oracle.
• Driving the implementation of eBenefits and automate Benefits for Open Enrollment and year-long Events Processing.
• Enhancement to weekly Medical File to Anthem Medical, for capturing the different scenarios of termination, benefit plan changes etc. an SQR Process , complete testing and migration to Production.
• Configured the Delegated Framework Access in CS 9.0 as required by the customer.
• Planning for the implementation of Higher Education Constituent Hub HECH for the customer.
• Performance tuning of applications where there is problem: take a comprehensive look at the SQL, Indexes, Index rebuild/reorganize and get solutions from Oracle Support thru Service Requests where needed.
• Data Archive Manager: Archived data of Job Openings older than 3 years.
• Reconfigure refreshed database instances for the Integration Broker and other set up etc.
• Mentoring fresh appointees and junior resources.

Environment: PeopleSoft HCM 9.1, North America Payroll, Time Labor and Talent Acquisition Manager, PeopleSoft Campus Solutions 9.0, PeopleTools 8.52, SQR, Oracle 11g, Windows 2003/2008, Oracle Enterprise Linux

Confidential

Sr. Support Analyst

Responsibilities:

• Production Support for PeopleSoft HCM, NA Payroll, Time Labor and Talent Acquisition Manager, eProfile, eBenefits modules.
• Work on Break fixes/Change Request/New Projects/Enhancements, design, develop, unit test and migrate code changes/interfaces to Test database. Update the BMC ticket queue with the resolution status.
• Work on rolling out PeopleSoft HCM to new companies plan, map the data and do the data conversion.
• Setup Integration broker services such as nodes, gateway, services for synchronous updating of Business Unit from Financials to HR
• Setup Integration Broker for Concur data transfer from HR to Oracle Financials configured Java Messaging Server JMS and Integration Broker.
• Developed Component Interface and ExcelToCI for loading mass data into the custom Review Rating and Employee Review tables.
• Developed SQR for extracting data related to Europe Hotel Bookings and transfer to shared server for use by the Europe users for analysis.
• Developed Application Engine for extracting data from HR and interfacing to PSF Approvals database for use in the Access Management functionality.
• Developed custom Workflow approval for the Code Deployment to manage notification, approval etc. This process will notify the team members and the managers of the progress. On the day of deployment, a scheduled PS Query will extract the list of CRQs for deployment and email it to the migrator.
• Look for patches/bundles and fixes and Tax Updates, analyze the changes, apply the bundles to the different environments in stages
• Rotational On-call Support
• Co-ordination of Month-end Maintenance and arrange for Deployment of Code.
• DR Environment Preparation and Testing, preparing test cases for unit/integration and UAT
• Job scheduling/monitoring using BMC Control-M/Enterprise Manager and resolve issues with Vendors/Devt. Teams.
• Monitoring SCOM alerts and resolving issues.
• Documentation of programming and technical support guides

Environment: PeopleSoft HCM 9.1, North America Payroll, Time Labor and Talent Acquisition Manager, PeopleTools 8.51, SQR, MS SQL Server 2005/2008, Windows 2003/2008, BMC Control-M/Enterprise Manager 7.0

Confidential

Sr. PeopleSoft

Responsibilities:

• Application Upgrade from 8.8 to 9.1 for the Core HR, NA Payroll and Benefits, Time Labor
• Rolled out PeopleSoft HCM to employee population in Mexico, China, India, El Salvador, Colombia Conversion from Legacy system to PeopleSoft HCM and created Interface Files for their Payroll Processing using PS Payroll Interface.
• Implemented Global Payroll for India.
• Tier-3 Application Support for PeopleSoft HRMS, Base Benefits and North American Payroll and Payroll Interfaces
• Design/develop conversion strategy, test and convert data from legacy systems to PeopleSoft
• Design/develop Payroll Interface configuration using customized EAI Tools, test and implement outbound files for legacy Payroll systems in other countries/continents
• Programming and Development of new modules from End-to-end, including requirement gathering, fit-gap-analysis, Functional and Tech. Designs, Coding, testing and migration and sign-off
• Experience in Change Control Management Quest STAT 5.1
• Developed a new Application Engine for updating Department Secretary Role maintenance, which adds or removes the Web Secretary Role to the Department Table custom field and page reading from PSROLEUSER table.
• Developed new Application Engine with 25 steps for extracting data from Core HR Tables and populating custom table AV NOTRIX, data from which are used by different downstream Notes databases like Worldwide Employee and Site Data WWESD
• Developed Component Interface and ExcelToCI for loading Annual Merit Increase data for the U.S Employees into the HR database tables.
• Developed SQR for populating the Payroll RUNID automatically for the weekly, semi-monthly and Quarterly payrolls before Paysheet creation automated process runs on the day of Payroll Processing.
• Developed a set of SQRs for interfacing HR ACCOUNTING LINE table data from HR to GL and reloading the data from Financials application after processing.
• Developed new SQR and module for extracting Employee data for sending to StayWell vendor on a weekly basis interface file was PGP encrypted, deployed in DMZ server and then sent to the vendor's server using FTP protocol. Worked for opening the Firewall for sending the test and Production files.
• Modified the delivered SQRs DDP001 and PAY001 and other tax related SQRs during every tax update to retain the customizations.
• Modified the PAYGL01.SQR to retain customizations for the chart fields used in HR and Financials.
• Applying patches/bundles and fixes and Tax Updates recommended by PeopleSoft
• Applying HR Bundles as recommended by PeopleSoft
• Development and modification of SQR programs for customer interfaces, payroll, and reports as required by vendors and Application Engine programs and Component Interfaces
• Logging problems with PeopleSoft customer connection, follow up and resolution
• Implementation of Change Assistant 8.45/8.49 and manage Tax Updates/HR Bundles from download to application of fixes

Environment: PeopleSoft HRMS 8.8/9.1, North America Payroll, Time Labor, Global Payroll for India, PeopleTools 8.45/8.49/8.51 SQR, MS SQL Server 2005/2008, Windows XP Professional/Windows 2003/2008.

Confidential

Thru: Tata Consultancy Services, Singapore

Responsibilities:

• Application Support for the PeopleSoft HRMS, and Global Payroll and other modules
• Design and Development of new modules, Unit testing and migration, arrange for UAT, UAT review and final migration to Production environment
• Co-ordination of activities of Technical team, System Administration, and the users and Reporting of progress to the business user
• Preparation of data and environments for the System Tests, UAT etc.
• Resolution of day-to-day problems, bugs etc., and promotion of modified codes/objects/reports
• Search the knowledge-base of PeopleSoft Customer Connection for resolutions for problems and bugs reported by Business Users, recommend solution and apply the resolution
• Involved in the development of a new module for generating SQR Reports for Taiwan/China/USA Employees' Appraisal Data for submission to the Supervisor/HR Personnel. Used Application Designer, Process Scheduler Manager and SQR Report 6.2
• Involved in the development of a new module for HR users to input/maintain Military data for the male employees of the Taiwan fabs. Used Application Designer for designing Record Definition, Page, Component, Menu etc and SQR for the Data Upload and Reporting
• Involved in the upgrade of HRMS RW/AW/AT to ver 8.8 PeopleTools 8.42

Environment: PeopleSoft HRMS 8.8, Global Payroll 8.3, Tracking Global Assignments, eRecruit, PeopleTools 8.42, SQR 6.2, Oracle 9i, AIX UNIX, Windows NT.

Confidential

Senior PeopleSoft Consultant/Team Lead

Responsibilities:

• Application Support for the PeopleSoft HRMS, Payroll and Financial modules
• Design and Development of new modules, Unit testing and migration, arrange for UAT, UAT review and final migration to Production environment
• Co-ordination of activities of Technical Consultants, and the users and Reporting of progress to the Project Manager
• Preparation of environments for the System Tests, UAT etc.
• To oversee Design, Construction, Unit Tests and System Integration Tests for the modules
• Study and apply patches and fixes as recommended by PeopleSoft
• Register case with PeopleSoft Customer Connection for problems/bugs, search the knowledge-base for resolutions etc.
• Involved in the development of a new module for extracting Training Data for the employees' based on the selection parameters like, Department/Group, From/To Dates, and Employee Levels. Used Application Designer and SQR for the development

Environment: PeopleSoft HRMS 8.3, Global Payroll 8.3 and Financials 7.5 GL, AP, AR, AM, BI , AIX UNIX, Oracle 8.1.7