Pragnya Rashmi Lenka

abkyuq@r.postjobfree.com

Mobile - 630-***-****

PROFILE SUMMARY

. About 9 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, XML Publisher.

Functional HCM, Base Benefits, Benefits Administration, NA Payroll,

Modules Global Payroll, Absence Management, Time & Labor,

(PeopleSoft) Recruiting, Promotion, ePerformance.

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

systems

DBMS Oracle 8i, Oracle 9i, Oracle 10g, Teradata, DB2, MS SQL

Server, MS-Access.

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

Languages

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

Michelin, Greenville, South Carolina

June 2010 - Present

Project : PeopleSoft HRMS, Global Payroll, NA Payroll, Payroll

Interface Support

Role : Peoplesoft Lead Consultant

Environment : PeopleSoft HRMS 8.9, PeopleTools 8.48, Oracle 10g on UNIX

Modules - Workforce Administration, Workforce Development, eProfile,

eManager, Global Payroll, Payroll for North America, Payroll

Interface, ePerformance, Compensation

Responsibilities:

. Providing Global production support for 52 countries and Handling of

assigned Tickets through ESM and JIRA tracking system.

. Troubleshoot errors/issues that business users encountered in the

areas of PeopleSoft HR, Workforce Administration and custom module

eComp+.

. Generating PS Queries and extracting data for users using Query

Analyzer.

. Customizing XML Publisher Reports.

. Coordinating with the offshore team.

. Monitoring Service requests in Integration Broker.

. Preparing Technical Design documents and test cases.

Inter-American Development Bank, Washington DC

Nov 2008 - April 2010

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.49, 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 27 countries including North America for

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.

. Troubleshooting the error out employees in 9.0 environment

EPerformance which gets the data from 8.3 through Integration Broker.

Familiarity with Service-Oriented Architecture. Analysis and

production fix of the Interfaces work for SOA.

. Worked on Taleo Implementation project which is integrated with the

PeopleSoft system. Developed New Interfaces as a part of the System

Integration.

. Worked on Career Module Framework for realignment of positions and

salary Admin Plan. Data Conversion was a major task in this project.

. 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.

Benfield, Chicago

Feb 2008 - Sept 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

BENFIELD is a Insurance Company. IBM team implemented PeopleSoft

applications (Financial and HR). Reimplementation of certain modules and

Post Production Support for BENFIELD was done from IBM USA and IBM INDIA

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.

. Project and Application Tracking with the help of RPM Tool.

. 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.

Mitchels And Butler, 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

Mitchell & Butler HCM & Payroll 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.

Kiewit, 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

Kiewit Corporation 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.

Phelps Dodge, Phoenix, USA

Nov 2005 - Mar 2006

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

Phelps Dodge is 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.

Punjab National Bank, Delhi, India

Dec 2003 - Sept 2005

Project : Customization and Reimplementation of HRMS Modules

and Global Payroll

Company : K-Square InfoTech Pvt. 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

Punjab National Bank, 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.

National Thermal Power Corporation, Delhi, India

Aug 2002 - Oct 2003

Project : Implementation of HRMS Modules

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.

National Thermal Power Corporation, Delhi, India

Jan 2002 - Aug 2002

Project Name : Implementation of Online Feedback System

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.

Maxim InfoTech Pvt. Ltd., Delhi, India

Jun 2001 - Dec 2001

Project : Implementation of Online Marketing Commission Chain System

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), Delhi, India.

. Post Graduate Diploma in HRD Management, NIHRD, India

. Bachelor's Degree in Science, Khallikote College, India

References can be furnished upon request.

Contact this candidate