ERP

PeopleSoft 8.8, 9.0, 9.1 - HCM,CRM Portal

GUI

People Tools 8.52, 8.51, 8.49,8.47

PeopleTools

Application Designer, PeopleCode, Application Engine, File Layout, Data Mover, Application Package, Integration Broker, AAF, ERMS, JMS

Development Tools

Application Designer, Ultra edit, Toad, Putty, UPK

Reporting Tools

XML Publisher, PS Query, SQR, PL/SQL

Operating Systems

Windows Platforms, UNIX, LINUX

DBMS

Oracle 10g, Oracle 11g

Migration Tools

STAT

Scheduling Tools

Autosys

Content Management

Enterprise Portal and Documentum

Client

Confidential

Duration

Confidential

Position

Lead Consultant

Environment

PeopleSoft 9.1, People Tools 8.52, Oracle 11g

Responsibilities

Have been involved in -

• Creating the functional specification document understanding the user requirements.
• Developing technical specifications for the XMLP reports.
• Create a PEN Query SQR process to load data into a flat table with 200 columns.
• Create a SQR process to load retiree Monthly pay stub from the GP results table to Custom table for reporting
• Created 10 reports with dynamic sections.
• Created a new PeopleSoft site and Portal Home page.
• Modified the PT Branding app package to include custom sections.
• Modified the Email Application package to include the new Pension emails.
• Retrofitted the old email packages to use the new HCM tables.
• Created Data Mover scripts to migrate the configuration of the Email packages
• Hosted the reports in an external portal site.
• Integrated the data flow between the reporting instance and the transactional instance.
• Created pagelets to display the information to the retirees.
• Handled Permission and Role for the new site.

Client

Confidential

Duration

Confidential

Position

Lead Consultant

Environment

PeopleSoft 9.1, People Tools 8.52, Oracle 11g, PL/SQL

Responsibilities

Have been involved in -

• Leading the Core HR Self Service team from offshore.
• Created a custom self-service framework to handle events.
• Event handing logic was written in application packages and reused across multiple components.
• New Portal site ROOMBA was created for ESS and MSS transactions alone.
• 48 Self-service transaction where handled by the Self Service framework.
• Created page design for all the 48 Transactions.
• Custom Worklist and Email notifications were created to the Managers.
• Created a quick links pagelet for the most needed links.
• Mass reorganization process was created to help half yearly staff movement.
• Developed Position Management Application engine for the HR to identify all open positions.
• Created a new Component interface to update employee information from a flat file.
• Custom module was created to handle Awards in the HR domain.
• Created setup pages for defining Awards for the current year.
• Created transaction pages to store Awards detain for every VPU.
• Developed reports to display the Awards associated with every VPU and the employee details.
• Data migration and mapping between the old and new systems.
• Developed SQL's to migrate data across applications.
• Integration with third party system using Integration broker for HCM information.
• Developed a Message for consuming department information from the SAP system.
• Retrofitted PL/SQL procedures which served as a data source for third party applications.

Client

Confidential

Duration

Confidential

Position

Lead Consultant

Environment

PeopleSoft 9.0, People Tools 8.49, Oracle 11g, STAT

Responsibilities

Have been involved in -

• Portal Redesign Created branding and themes using PeopleSoft enterprise portal
• Content Management Created application engine to publish new contents created in documentum.
• Roles and permissions management where assigned dynamically using a new application engine which I developed with the business requirements.
• Signin page modifications to enhance user experience and provide system messages to the users.
• Handled Redirections from Signin page to Service agreement pages outside of PeopleSoft
• Single Sign on integration with oracle OAM was deployed and customization where done on the sign in components of PeopleSoft.
• IPhone integration- created web services forIPhone application to consume data from PeopleSoft.
• MSS transaction where hosted in IPhone App.
• Pagelet creation from Room and Desk booking system was developed.
• Organization wide Room management application was developed in PeopleSoft.
• Conference rooms listing and real time availability pages were developed.
• Multiple Portal sites were hosted for HR Admin and Managers.
• Role based Portal design to differentiated UI experience was done.
• ERMS implementation in CRM was handled for the HR Operations team.
• Automatic case creation was performed for high priority users dynamically.
• Added 64 mailboxes with varying Polling frequency to avoid clogging at IB.
• Active Analytical Framework was workflows were created and maintained.
• JMS Integration between Cop Clark and SCB to retrieve holiday information.
• Published Holiday Data in Peoplesoftusing ISIS JMS Bus connectivity.
• Deployed JMS client in Peoplesoft Webservers.

Client

Confidential

Duration

Confidential

Position

Senior Software Engineer

Environment

PeopleSoft 9.0, People Tools 8.49, Oracle 10g, STAT, Autosys

Responsibilities

Have been involved in -

• Fit Gap analysis between the 8.X and 9.1 systems were performed.
• Object identification classifications as AS-IS, retire, Custom and Customize were identified.
• Retrofitting of SQR process to include the new table structure.
• Application engine development for Mass Change.
• Developed Standard Portal a custom solution when a new country is on boarded in Pfizer.
• With a Currency and Location setup a set of Self-service screens for the country was immediately launched with the Standard Portal.
• Setting up Integration between PeopleSoft HCM and CRM.
• Workforce Full sync was modified to suit customer requirement.
• User Profile and Person Basic sync was deployed realtime compared to a batch process in Vanilla.
• Bug fixes on blank messages from Finance were identified and resolution was provided.
• 360 Degree Setup was done to give the call centre agents complete information of the calling in user.
• HCM sections were included in the 360 degree setup to provide job information of the employees.
• Row level security was enforced to view HCM data.
• Quick Links pagelet was included in the Case page for faster HR information.
• Toolbars in CRM case screens where modified to include Text Tray.
• Grey sparling integration with PeopleSoft was deployed for users need not sign in to PeopleSoftseparately.
• Verity process for Portal was deployed with Thesaurus
• Pagelet creation for sign on statistics was developed
• Documentum integration for Content Management.
• Point of Contact for all third party integrations
• Disability management system Custom module.
• Designed Puerto Rico DMS system using the US with minimal changes to the application.
• Developed Application engine process to run over right to capture DMS data.
• Developed reports for DMS system report employee availability.

Client

Confidential

Duration

Position

Software Engineer

Environment

PeopleSoft 8.8, People Tools 8.47, Oracle 9i

Responsibilities

Have been involved in -

• Creation of Components, Pages and Records.
• Performance tuning for long running SQL's.
• Explain plan and Cost analysis was done for long running SQL's
• Compute STATS was automated in tables which were having large chuck on non-indexed data.
• People code changes to populate the relationship based contact information in the case page.
• BO Search enhancements to display Customer Employee Contact methods
• Archival of Helpdesk Data which is more than 3 years old.
• Data conversion scripts for provider group attribute changes.
• Developed an Application engine to send emails to the provider group owner on the time taken to clear a worklist item.
• Modified the worklist component to display the number of unread items in the component.
• Moved the code from Component level to Application package's to enhance reusability.
• Downstream integration with business objects to provide data for reporting.
• All cases grouped by certain criteria were published to the BO tables.
• All Provider group data was published to the BO tables using an Application engine.
• Reports were developed based on the data published from Peoplesoft.