PROFILE SUMMARY

• Over 8 years of Information Technology experience in Business Application Development involving Designing, Developing, Implementing, Customizing, Upgrading, Testing, Enhancement and Production Support of PeopleSoft HRMS/HCM/Finance Applications.
• PeopleSoft Techno-Functional expertise in HCM/Finance involving ePerformance, eDevelopment, Training, eRecruitment, Promotion, Payroll, Accounts Payable(AP), Accounts Receivable(AR), General Ledger(GL), Travel and Expenses(T&E), Billing, Self Service and Manager Self Service modules.
• Experience in Upgrade projects. (PeopleSoft HRMS from v8.3 to v8.9, HRMS v8.8 to v9.0)
• Experience in Payroll Interface in HCM v8.9; Global Payroll and Absence Management in PeopleSoft HRMS v8.8.
• Experience with North America Payroll, Base Benefits, Benefit Administration, Time and Labour.
• Exposure to major Customizations and reimplementation.
• Familiarity with Data Warehouse tools Business Objects XI, Data Integrator 11.5, ETL and Teradata
• Experience in Production Support, Applying updates and fixes, Development of Reports and Interfaces.
• Strong understanding of Peoplesoft Internet Architecture(PIA)
• Strong problem solving and troubleshooting skills, highly motivated and ability to work as an individual and also as a dynamic member in a team.
• Has been a Lead for many projects, including Architect role. Involved in all phases, performed work allocation and quality audits, good knowledge of SEI-CMM Level 5 quality processes and IBM Quality processes.
• Technically Skilled in PeopleTools, Application Designer, PeopleCode, Application Engine, Component Interface, SQR, Application Package, Application Messaging, File Layout, Data Mover, PS Query, Portal and Security.
• Expertise in PeopleSoft Projects Migrations between lower life cycles and production environments. Experiencing in setting up and using STAT tool for project migrations. Experience in taking backup of PeopleSoft projects during data refresh and upgrades.

TECHNICAL SKILLS

ERP (PeopleSoft):

PeopleSoft HRMS 8.3,8.8, 8.9, 9.0 PeopleTools 8.17,8.20, 8.42, 8.45, 8.46, 8.47, 8.48,8.49, Peoplecode, SQR, Data Mover, Workflow, App Engine, Component Interface, Application Message, Application Package.

Functional Modules (PeopleSoft):

HCM, Base Benefits, Benefits Administration, NA Payroll, Global Payroll, Absence Management, Time & Labor, Recruiting, Promotion, ePerformance.

Operating systems:

Unix, Windows 9X/NT, Windows 2K.

DBMS:

Oracle 8i, Oracle 9i, Oracle 10g, Teradata, DB2, MS SQL Server, MS-Access.

Programming Languages:

SQL, PL/SQL, VB6.0, HTML, C.

Web Technology:

C++

QA tools:

STAT Version 5.2 and Version 5.4 for PeopleSoft, Serena Team Track (both from Quest Software).

Reporting Tools:

Toad for Oracle (Quest), Crystal Reports for PeopleSoft, Business Objects, ETL, Data Stage

PROFESSIONAL EXPERIENCE

Confidential,Washington DC Feb 2009 - Present

Project : PeopleSoft HRMS, Global Payroll, NA Payroll Support and Enhancements
Role : Peoplesoft Sr. Consultant
Environment : PeopleSoft HRMS 8.3, PeopleTools 8.20, Oracle 9i on UNIX, ePerformance 9.0, PeopleTools 8.48, Oracle 10g on UNIX
Modules – Workforce Administration, Workforce Development, Base Benefit, Time and Labor, Global Payroll, Payroll for North America, ePerformance

Responsibilities:

• Provide production support to PeopleSoft 8.3 HRMS and 9.0 EPM systems.
• Worked extensively on New Enhancements like Administer Merit Pay, People Manager Exception Component and Report, EmailId Update Process, Medicare Indicator for Employee Dependants, Cigna Interface Report.
• Major development tasks are based on Workflow, Application Engine, PeopleCode, PeopleTools, Tree Manager, PS Query, SQRs and Portal Security.
• Troubleshoot errors/issues that business users encountered in the areas of PeopleSoft HR, Base Benefits, NA Payroll, Global Payroll and Time & Labor.
• Handling of assigned Tickets through Team Track.
• Migration of all Peoplesoft projects and reports through STAT.
• Investigation of error out employees in Payroll and fixing the errors to run the payroll successfully on time. Support biweekly payroll process.
• Data Migration using Data Mover.
• Developing New Menu, Components, Workflow Activities, Workflow configurations, pages, Records, Portal Registry, Creating new ROLEs & Permissions, new SQRs(People Manager Exception Report, PS/EDW EmailId Update Process & Medicare Indicator Dependant Report), Creating/updating TREE structure, Importing & Exporting TREE, Migrations, Merit Pay Implementation, Data Patches, Production fixes are the major responsibilities.

Confidential,Chicago, USA Feb 2008 – Dec 2008

Project : PeopleSoft HCM & Payroll Interface, Finance Support and Reimplementation
Company : IBM
Role : Project Lead
Environment : PeopleSoft HRMS 8.9, PeopleSoft FINANCE 8.8, PeopleTools 8.47(HR), 8.45(Finance), Application Messaging; SQL, UNIX
Modules – Workforce Administration, Payroll Interface, ePerformance, eRecruitment, eDevelopment, Base Benefit, Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Travel and Expenses (T&E), Billing, Amex Load, and Cognos tool for Payroll Interface

Confidential, is a Finance Company established at UK and USA. IBM team implemented PeopleSoft applications (Financial and HR). Reimplementation of certain modules and Post Production Support for Confidential, was done from IBM USA and IBM UK for both the client locations i.e. UK and USA.

Responsibilities:

• Responsible to work with a very challenging Role as a Senior Technical Consultant for both the modules and as a Project Lead to complete Project Management tasks.
• Responsible for Project Deliverables and Production Support. Conducted Peer-Review and Brain storming sessions, Advised and Mentored team members, suggested improvements and alternate methods.
• Estimation of HR and Finance Change Request/Service Requests and to fix them based on High Priority.
• Knowledge Transition and Work Allocation to off-shore.
• Worked extensively on Workflow, Application Packages, PeopleCode, Application Engine and Portal Security.
• Worked on interfaces in to legacy and third party system like Cognos for Payroll Interface.
• Reimplementation of Self Service and Manager Self Service of Performance Management Module.
• Customization of Printable version of all the ePerformance Documents.
• Customizing PeopleCode of Application Packaging EP_FUNCTIONS.
• Functional Support for Workforce Administration Module.
• Developed Inbound and Outbound Carrier Interfaces using SQR for Benefit Plans like Medical, Dental, Managed Mental Health, Service Awards and Pension Plans
• Worked on Bug fixing of Financial Application Engine programs like B00_MSG_UPD, B00_GLI005
• Fixing and Posting the unposted reports in AP/AR, customizing Expense sheet.
• Analyzed and summarized Billing and Accounts receivable activity.
• Customized Training Module Workflow.
• Preparing Weekly Status Report and Change Request Status Report.
• Responsible for code walkthrough and Review of all developments and Production Migration for quality Delivery.
• Preparation of Technical Specification Doc, Test Case (UTP) Doc, Solution Outline Documents.
• Preparation of various project management documents for example - Project Plan Document, Process Improvement Plan Document, Defect Tracking Document, Task Tracking Document, Training Planner Document, and Risk Management Document.

Confidential,UK Jun 2007 - Jan 2008

Project : PeopleSoft HCM & Global Payroll Upgrade from 8.3 to 8.9
Company : IBM
Role : Team Lead
Environment : PeopleSoft HRMS 8.3, HCM 8.9, PeopleTools 8.48; UNIX, DB2
Modules – Workforce Administration, ePerformance, eRecruitment, Training, Self Service, Manager Self Service, Time and Labor, Global Payroll

Confidential,Upgrade project was the first upgrade project from PeopleSoft HRMS version 8.3 to v8.9. The scope of this project was limited to development of RICE objects that included retrofitting the objects in v8.9; modify existing tech design, unit testing and support during SIT & UAT phase

Responsibilities:

• Involved in Upgrade planning - Application and reports upgrade from 8.3 to 8.9.
• Business Analysis of Impact and Review of Delta customization impacts for Reports, Interfaces, RICE Objects.
• Analysis, Data Conversion and Data load through EDI reports.
• Retrofit of SQR Reports, Interfaces, Peoplecode and Online Objects.
• Major Customizations in Letter Generation Reports for Training, Recruitment ; Accumulator Report ; MAB Year End Report ; EDI Reports EP14 and EP35
• Customizations to Salary Plan Page of Job, Recruitment Pages, Job Summary Page, Student Enrollment Page, Fixing CI Programs.
• Performed security services by creating new Security Roles and Permissions and attaching permission lists and role assignments to Operator IDs to use new pages, components, and menus
• Customizing/Retrofitting PS delivered Time and Labour Reports.
• Unit/System Testing of Reports, Interfaces and Online objects.
• Prepare and review compare reports using Application Upgrade/Designer. Identify Custom Inbound and Outbound SQRs, Application Engine, Trees, COBOL’s & Queries. Discuss with the DBA regarding the compare reports and its impact on the Upgrade.
• Applying upgrade patches, fixes and testing of delta after applying tax patches.
• Data upload using File Layouts and Component Interface.
• Prepared Unit Test Plan Documents and reviewed the UTP Docs of other team members.
• Resolving issues related with Test Plan Reports (TPRs) during UAT.

Confidential,Omaha, USA Apr 2006 - May 2007

Project : PeopleSoft HRMS Upgrade from 8.8 to 9.0 and Maintenance
Company : Hexaware Technologies Ltd
Role : Techno Functional Consultant
Environment : PeopleSoft HRMS 8.8 and 9.0 PeopleTools 8.46 and 8.49; UNIX, NT; Oracle 10g
Modules – Workforce Administration, North America Payroll, Base benefits, Benefit Administration, Time and Labour

Confidential,is One of North America\'s largest and most respected construction organizations. The scope of the project is to upgrade the current system from PeopleSoft HRMS 8.8/8.46 to 9.0/8.49 and to re-customize Batch programs, Online Objects.

Responsibilities:

• Analysis of Impact and Initial Customization analysis for Batch programs, Online Objects.
• Analysis and recreation of bolt on objects for functionality carry forward.
• Business Analysis and performing Data Conversion for various tables in PS.
• Analysis of Delta customization impacts in PeopleTools and PeopleCode.
• Customized the delivered Peoplesoft pages used for HR and Time and Labor functionality.
• Retrofit of SQRs, Application Engine, Component Interface, Application Packaging, Peoplecode and Online Objects.
• Testing of Batch Programs, Online objects and preparing test cases based on the Technical Design Specification Document.
• Worked with other team members to help them in applying upgrade patches and Maintenance Packs.
• Worked with team in setting up Base Benefits table configuration with Payroll. Created new Vendors, Benefit Programs, Benefit Plans, and Deduction Codes.
• Coordinated with third party vendors to gather specifications for Benefit Carrier Interface files.
• Developed SQRs for sending Benefits Information like Medical, Dental, Disability, FSA, and 401k.
• Process run for Pay Calcs and Confirms.
• Running the Pay Calculation for North America Payroll and testing of Reports.

Project : EDW HR Implementation
Company : Hexaware Technologies Ltd
Role : Onsite Coordinator
Environment : Business Objects XI, Data Integrator 11.5, ETL, Data Stage, People Tool 8.20, People tool 8.46 ; SQL, Teradata, and Oracle 9i.
Modules – Workforce, Compensation, Base Benefits

Confidential,is a Mining Company. It has two different Databases; South America Data in Oracle and North America Data in SQL. Modules for South America, implemented in PeopleSoft v8.3 and North America in PeopleSoft v8.8. To merge and maintain the data accurately and to generate the reports according to their business need, Business Objects Data Warehouse Technology implemented by Hexaware Team.

Responsibilities:

• Understanding Business Requirement and Requirement Analysis.
• Interacting with client team in needs analysis, design, development and delivery of work.
• Coordination with the offshore team.
• Creating Business Logics out of SQRs and Application Engines based on Workforce Administration, Base Benefits and Compensation.
• Analyzed various Benefit Plans and Benefit Programs offered by subsidiaries and parent company to identify commonalities and differences.
• Prepared the functional and technical design documents for the consolidation process.
• Created many new tables in Teradata by using Data Integrator Tool.
• Data stage using the source data and target data in ETL tool.
• Analysis of Table mapping from PeopleSoft to Teradata and Data Load into a Teradata data warehousing system using FASTLOAD and MLOAD utilities.
• Unit/System Testing of Universal Reports.
• Prepared Unit Test Plan Documents, Technical Design documents.

Confidential,Delhi, India Dec 2003 - May 2005

Project : Customization and Reimplementation of HRMS Modules and Global Payroll
Company : Hexaware Technologies Ltd.
Role : Team Lead
Environment : PeopleSoft 8.8, People Tools 8.45; UNIX, NT 4.0, Oracle 9i
Modules – Workforce Administration, eRecruitment, Promotion, Transfer, Self Service, Manager Self Service, Global payroll, Absence Management

Confidential,India is a leading banking Organization, has implemented PeopleSoft HRMS and Global Payroll system to maintain their human resource data and payroll for more than 64,000 employees. Hexaware did the reimplementation of the Absence Management and Global Payroll system to meet the requirement of the client; this implementation required the postproduction technical and functional support for the HRMS and Global Payroll system.

Responsibilities:

• Worked closely with the client team in analysis, design, development and delivery of work Request in form of ticket.
• Identified the areas of customization and estimated the man-day efforts involved in the design, development, unit testing & integration testing of CRs raised by the client.
• Coordinating with the Offshore Manager.
• Created new Views, Pages, Component, Menu, Portal Registry and Security Definition.
• Configured some additional payroll elements in PeopleSoft Global Payroll 8.8 for PNB-India, which had 64000 employees.
• Developed new Global payroll elements like Formulas and Brackets.
• Running Global Payroll process for payroll calculation and testing of payroll reports.
• Developed New Application Engine Programs for Officiating, New Applicant Recruitment Detail, Absence Employee Upload.
• Worked on major Customization in Pay Slip SQR.
• Customization in Peoplecode, pages and workflow routing of Promotion and Transfer Module.
• Developed several complex PS Queries for Users. Worked on performance tuning and cost-based optimization of queries. Data upload using File Layouts and Component Interface.
• Created new Security Roles and Permissions for new objects.
• Production Migration of Online Objects.
• Performed Unit testing and prepared UTP.
• Preparation of Weekly status report for Client update, Issue log.

Confidential,Delhi, India Aug 2002 - Oct 2003

Company : K-Square InfoTech Pvt. Ltd.
Role : Peoplesoft Technical Consultant
Environment : PeopleSoft 8.8, People Tools 8.43, NT 4.0, Oracle 8i, PL-SQL
Modules – Workforce Administration, Benefits, Administer Training, Career Planning, Pension, Promotion, Health Management

The Human Resources Operations within NTPC were being automated with the help of PeopleSoft HRMS core module, with small customizations. The modules implemented were Workforce Admin, Base Benefits, Administer Training, Career Planning, On Duty, Attendance, LTC, HBA, Issue Of certificates, Telephone, Health Management, employee Pension Scheme, Promotion. There were 48 modules implemented as per the government rules and functionality.

Responsibilities:

• Extensively worked on new development of custom record definitions, fields, pages, Components.
• Developed Self Service Career Planning Talent Management module which used Application Engine, Component Interface, Workflow, SQR & PeopleCode
• Worked on customizations in Administer Training & Employee Pension Scheme.
• Worked on Customization/Troubleshooting of PS delivered SQR processes, Reports, Interfaces and Application Engines. Scheduling processes and reports through Process scheduler.
• Involved in setting up of new run control records, pages, components, menus and processes for a new Business unit.
• Independently worked on the set up configuration of Career Planning and Administer Training (External) Module.
• Developed new Security Roles and Permissions for new objects.
• Worked closely with end user to develop specifications to write new SQRs for various HR, Benefits, and Payroll reporting and maintenance needs.
• Migration of objects/projects from between environments.
• Technical Documentation for all the Objects Implemented.
• Technical support for PS Queries, SQL Queries and PL-SQL scripts.
• Functional support to the end users of NTPC.

Company : K-Square InfoTech Pvt. Ltd.
Role : Peoplesoft Technical Consultant
Environment : PeopleSoft 8.8, People Tools 8.43, NT 4.0, Oracle 8i

An Employee Self service and Manager Self Service system Implemented for the employees of NTPC to enter their feed back with respect to the specific functionality.

Responsibilities:

• Involved in development of online objects, workflow and Reports.
• Unit testing and debugging interfaces, SQRs, technical and functional setups.
• Developed new Employee Feed Back Reports based on the business need.
• Scheduling processes and reports through Process scheduler.
• Involved in setting up of new run control pages, components, menus and processes for the same module.
• Setting up Business rule for the Workflow functionality as per user requirement.
• Prepared Technical Documentation and test case reports.
• Coordination with Project Lead on daily status and maintenance.
• Created complex PS Queries for business users.

Confidential,Delhi, India Jun 2001 - Dec 2001

Company : DICS Technologies Pvt. Ltd.
Role : Programmer
Environment : Visual Basic 6.0, COM, Crystal Report 6.0, SQL Server, PL-SQL

The scope of this project is online marketing, aimed at maintaining the details of the super user and all the sub users, their invested money, commission of each sub user, all the dates of investment as well the no of new users at the respective date and at last the no of sub users under each parent user. It takes care of the system with authentic information of each user, to maintain the levels up to any extend and generate a interlinked chain of users. Various reports like list of customers, commission dispatch, Invoice statement, outstanding statement were created with required functionality.

Responsibilities:

• Requirement gathering, Needs Analysis, Table Structure Design.
• Designed various Data Entry Screens.
• Coding and Unit testing of the interfaces.
• Involved in Data Validation and User and Password security measures.
• Prepared Technical Specification Document and User’s Guide.
• Developed Crystal Reports and Unit Testing.
• Generation of PL-SQL scripts to code in the program.

EDUCATION

• Masters in Computer Application (MCA)
• Post Graduate Diploma in HRD Management
• Bachelor’s Degree in Science