Experience Summary

• Over 12 years of experience including 11 yrs dedicated to ERP Applications with 8 yrs in Peoplesoft HCM applications and 3 years in Financials on a various RDBMS platforms like Oracle 11g, Informix v8.0, DB2 v9, SQL Server v4.5.
• Experienced in PeopleSoft HCM v9.1, ELM v9.2, CRM HR HelpDesk 9.1 and Financials v8.8. Worked on Core HR processes, MSS ESS, Taleo, Workforce Administration, eCompensation, Payroll and ELM v.9.0, HR Helpdesk 9.1 and Integration between these modules.
• Certified in PeopleSoft Enterprise Learning Management ELM Release 9.0 and PeopleSoft CRM HR HelpDesk Release 9.1 from Oracle University.
• Sound implementation experience in the SDLC lifecycle and Quality Standards conforming to CMM Level 5. Worked on two major full-cycle HR implementations for global financial clients starting with requirements gathering to deployment and production support.
• Worked on two major Application and Tools upgrades using Upgrade Assistant v7.5 to 8.4 and Change Assistant, applied bundles, patches for fixes as needed.
• Have considerable experience in quality assurance, preparing test plans and executing the same and responsible for providing the status / communicating the progress of the application to the Project Manager and Management.
• Specialities : PeopleTools v8.53 - Application Designer, Application Engine, PeopleCode, Application Packages, Component Interfaces, Security, Process Scheduler, Work Flow. Integration Tools - Data Mover, Integration Broker, Application Messaging. Online Security - Processes, Reporting, Object, Application Data and Peoplesoft PIA Security, Reporting Tools - PS Query, Crystal Reports, SQR. Upgrade Assistant, Change Assistant.

Engagement Overview

Confidential

Role : Developer Analyst

Environment : PeopleSoft HRMS 9.1 Core HR, Workforce Admin, eCompensation, Payroll, Taleo , PeopleSoft ELM v9.2, PeopleTools v8.53 - App Designer, Application Engine, Application Packages, PeopleCode, Component Interfaces, SQR, Data Mover, PS Security, Oracle 11g, STAT v5.4.2, Phire Migration Tool, Security Administration.

Responsibilities:-

• Working as a technical developer and Analyst on HCM applications Core HR, eCompensation, Taleo, Payroll and ELM v.9.0 with Oracle 11g as backend.
• Project for 162 m 6 Tax Regulation developed online and batch application engine processes - worked on complex XML Publisher summary reports.
• Worked on Re-implementation of ELM Enterprise Learning Management v.9.0 to 9.2 Fit-Gap Analysis, Retrofitting custom changes, Unit and System Testing, Defect resolution using HP ALM - fixing system testing defects and user testing support.
• Worked on process changes needed for Requisition, Hiring process using Template Based Hire TBH , Manager Self Service MSS , Employee Self Service ESS for implementing Position Management, setting up a new level of Competency for the Finance employees on their My Profession Profile MPP .
• Worked in the implementation of PeopleSoft CRM HR HelpDesk 9.1 converting the Oracle CRM-On Demand Data with more than 10 GB of attachments into Peoplesoft through Application Engine.
• Excellent understanding of the BORM Data model , worked on configuring BO search pages, 360 degree view, dynamic grids, Trees/ Nodes and Roles and developed a new Application Engine to extract HCM data and import in HRHD using file layouts.
• Worked as a key developer on GL Restructure project a conversion effort to map the new GL structure in Finance with that exists in HR
• Worked in eCompensation Module designed developed the Compensation Confirmation Statement using HTML for employees.
• Worked on creating new technical design documents, discussed with the customer for approvals, created development packet that includes impact analysis, pseudo code, test scripts, test results with snapshots
• Ensured quality on all deliverables perform system and integration testing in TEST environment
• Worked in STAT Migration Tool to migrate PeopleSoft and Non-PeopleSoft objects Batch programs like SQR, SQCs and PHIRE New Migration tool for migrating PS objects.
• Well versed in UNIX written shell scripts to perform basic and advanced tasks. Good in AWK programming.

Confidential

Role : Sr. Technical Consultant

Environment : PeopleSoft HRMS 9.0 Administer Workforce, Base Benefits, Payroll , PeopleTools v8.49 - App Designer, Application Engine, PeopleCode, Component Interfaces, SQR, Data Mover, PS Security, Oracle 10g, HP Mercury Quality Center, Security Administration, Microsoft Project Plan.

Responsibilities:-

• This is a PeopleSoft HRMS 9.0 HRMS, Base Benefits and Payroll Implementation Project with Oracle 10g as backend. I played a techno-functional role in this assignment.

• Major work done include processing of Conversion files using SQRs and App Engines, developing new interfaces internal external / 3rd party vendors , setting up payroll tables, run payroll to test the post-pay interfaces, create Unit test scripts and System Integration test scripts.

• Co-ordinate with the Functional Team Business Analysts to identify and clarify business requirements before development phase.

• Developed an Application Engine tool that would validate the conversion data and produce an error report. It just takes the type of validation to be performed - Xlats, prompt table or an SQL condition.

• Worked on HRMS Setup configuration, customizations involving online processes that includes implementing business rules for Shift Differentials, Local Taxation Process, Savings and FSA plans, and interfaces inbound and outbound based on client requirements.

• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Payconfirm, Tax Tables

• Worked on customizations to employee self-service pages like Personal Information, Leave Balances Benefits confirmation and the associated workflow setup.

• Developed new SQR programs to pull the Payroll related data from PeopleSoft HRMS Database and to generate Flat files.

• Developed a GL Interface from HRMS that pulls the payroll expenses earnings deductions and taxes , processes settlement entries for inter-company movement , accrual entries and populates a staging table from which an outbound GL file is sent to PS Financials.

• Worked on Payroll Setup for testing the post-pay interfaces like creating new General Dedn, Addl Pay, Fed/State/Local taxes, Garnishments, overriding Job Pay, General Dedn, run pre-sheet and pre-calc audit reports, run Pay Calc and Pay Confirm processes.

• Setup the Org structure as a Department Security tree and the new PS security Join Tables SJT Tables used on search pages and the refresh jobs that populates these tables.

• Developed Complex SQL queries in Oracle 10g including usage of OLAP functions, temp tables, co-related and sub-queries.

• Created Unit Testing and Results document for all interfaces with positive and negative test cases for each business requirement.
• Preparation of System Integration test scripts in Mercury HP Quality Center for all the External and Internal interfaces to ensure there is a complete integration with the online business processes.

• Well-versed with online debugging tools in App designer and SQR and have good knowledge and exposure to Unix Shell Scripting.

• Worked on the change requests that come up during the User Acceptance Testing phase and perform a full round of testing.

.

Confidential

Role : Technical Consultant

Environment : PeopleSoft HRMS 8.8 Administer Workforce, Benefits, T L, Payroll , PeopleTools v8.49 - App Designer, Application Engine, Component Interfaces, PeopleCode, SQR, Data Mover, Oracle 10g.

Responsibilities:-

• Worked on a PeopleSoft HRMS v8.8 Conversion project for 4 months playing the role of a technical consultant

• This project involves bringing employees of the acquired firm into the current HRMS Workforce Administration System.

• Major work done include conversion of two SQR GL Interface programs to App Engine processes that writes Payroll data to flat file which is later loaded into GL Module in PeopleSoft Finance.

• Developed Complex SQL queries in Oracle 10g including usage of OLAP functions and temp tables, performance tuning.

• Played key role in loading the hire, rehire, direct deposit, tax distribution and the time files thru Excel to CI programs, setting up of benefit and payroll tables for the new employees.

• Modified the open enrolment SQR in Benefits to load default benefit elections for converted employees,

• Other work done include validation of the time file sent from mainframe, validating the payroll results, validation of GL interfaces

• Developed test scripts at each testing phase like Unit, System testing I and II.

Confidential

Role : Technical Lead

Environment : PeopleSoft SCM Financials v8.8 AP, PO, OM, AR, BI, GL , PeopleTools v8.48 - App Designer, Application Engine, PeopleCode, SQR, Data Mover, PS Query, Crystal Reports v8.0, Change Assistant, SQL Server v4.5.

Responsibilities:-

• Technical Lead for this application upgrade project involving application of maintenance packs from MP3 to MP9 for FSCM 8.8 SP1 on Tools 8.48 and other separate bundles including the pre-requisites and post-requisites.

• Responsible for setting up the offshore team and the connectivity for offshore.

• Application upgrade activities involve using the Change Assistant, configuring the CA, appserver and the webserver agents, recording the steps completed manually due to errors, performing manual post-update instructions and the audits for checking the consistency of PeopleSoft and database objects.

• Preparation of the Deployment Checklist document that details all the steps/instructions for the upgrade with an estimated time to complete for each step. This document will be used for production upgrade.

• Running the compare report between DMO and a copy of production to identify and analyze the list of customizations that need to be re-applied or retrofitted and for those to keep the delivered functionality after discussions with developers and business users.

• Analyze the non-database or batch objects like crystal reports and SQRs, PS queries that are impacted by the patches due to record fields' addition, deletion or property changes.

• Preparation of technical specs for the offshore team for the customizations to be retrofitted, clarification of issues related to the changes, review of the work done by offshore.

• Worked on other custom programs developed in PeopleCode, Application engine, PS Query, Component Interfaces, Security to identify changes and do the fit-gap.

• Preparation of test cases and Unit testing of all issues in DEV and migration requests for projects created, from DEV to TST.

• Co-ordinate with the testers for the issues or defects raised and support the end users during User Acceptance testing UAT

• Provide post-production support and ensure the deployment was successful

Confidential

Role : Technical Consultant

Environment : PeopleSoft Financials v8.8 Project costing Commitment Accounting , PeopleTools v8.47 - App Designer, Application Engine, PeopleCode, SQR, Process Scheduler, Data Mover, PS Query, DB2 UDB v.8.5, Workflow Setup

Responsibilities:-

• Good Understanding on the functionality of Project Costing Application encompassing Costing Revenue projects, billing models, chargeback, Charge codes, Analysis types COM, ACT, CRV , workflow associated with client projects and the interfacing with PO, AP, BI, AR modules.
• Worked on PeopleTools version 8.47 like PeopleCode, Application engine, Process Scheduler, Process Monitor, PS Query, Security and Application Messaging. Also worked on SQR
• Development work
• Created a new Application Engine process that reads the latest role assignments for revenue projects managed by client managers and client project approvers.
• Redesigned the program logic for triggering the workflow when critical costing fields are modified on the project request page and all the changes are captured for tracking purposes in the history tables.
• Worked on the Data Archival Tool to archive the history rows in PS PROJ RESOURCE to the history tables.

Confidential

Role : Technical Analyst

Environment : PeopleSoft HRMS 8.8 Workforce Admin, Payroll , PeopleTools v8.43 - App Designer, Application Engine, PeopleCode, Component Interfaces, Application Messaging, Integration Broker, SQR, Data Mover, PS Security, DB2 v8.1, PS Workflow.

Responsibilities:-

• This was a PeopleSoft HRMS v 8.8 Implementation Workforce Admin system on PeopleTools v 8.43.12

• Well versed with HRMS / HCM database model and the Entity-relationships between the data structures.

• Analyze the business requirement documents created for multiple regions across the globe and discuss with the business users for clarifications.

• Preparation of the Technical requirement Documents from business requirement documents.
• Analysis and Specification Design, Program Preparation and Development of the Offer Management / New Hire Flows of the Workforce Management Application.

• Worked on setting up/maintaining core payroll tables, employee pay data, Pay groups and HR information used in payroll process.

• Preparation of specs for Workflow Management among multiple roles and user groups which involves setting, configuring the action alerts, info alerts and email notifications and triggering them when a particular business event happens.

• Created messaging structures in Application designer which is used to capture the component buffer data and send them as an XML using the Integration Broker Setup.

• Development also include creating a component interface for the Employment data component which contains the complete data for an EE and creating an Application Engine program which calls and populates the CI to delete the Employee data when an EE rescinds or withdraws an offer made.

• Responsible for interacting/assisting with the internal testers initially as well as during the User Acceptance Testing UAT done in different environments by the client teams and ensuring all the issues are resolved in timely manner
• Responsible for working closely with management / business team specialists to ensure that the final system meets or exceeds all current service levels and reporting requirements.