Email: j333dj@r.postjobfree.com

Phone: 404-***-****

Pravat Banerjee PeopleSoft HCM

Profile

• Nearly twelve years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.

• Extensive experience with analysis, design, development, customizations and implementation of software applications including ERP applications.

• Proficient in analyzing and translating business requirements to technical requirements and architecture.

• Strong database skills and development knowledge

• Experience in leading and managing teams. Handled multiple roles - Project Lead, Software Architect, Developer, ERP Systems Analyst

• Executed software projects for Automotive, Insurance and Content Management industries

• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Skill Set

ERP: PeopleSoft HRMS 7.5, 8.3, 8.8 and 8.9

Functional Modules: NA Payroll, Time and Labor, Employee Self Service, Manager Self Service and Workforce Administration.

RDBMS: Oracle 8i, DB2 version 9

Languages: PeopleCode, Oracle SQL and Visual Basic

O/S: Windows 95/98/NT/2000/XP, DOS, SCO UNIX, MAINFRAME

Processes: IBM’s QMS (Quality Management System)

GUI : Developer 2000, Visual Basic 6.0

Other Tools : PeopleTools 8.49, 8.47, 8.41, 8.19 SQR, Crystal Reports, MS Office

Other Skills: PeopleSoft DBA basics, strong batch programming (windows environment)

Professional Experience.

March 2007 – Till date, Onsite Support Lead/ERP Consultant IBM India Pvt. Ltd. at SunTrust Banks, Inc. Atlanta, Georgia

Client: SunTrust Banks, Inc.

As an Onsite Lead responsible for Analysis, design, development, testing and implementation of customized Baan ERP solutions for new implementations and upgrades for our IBM US customers

North American Payroll

Responsible to resolve all issues related to NA Payroll on a day to day basis

Concept of On and Off-Cycle payroll.

Developed custom incentive load programs

Cobol trace in case of PROD abend and a trace is necessary

Developed a checklist to execute before every on-cycle payroll to make sure no potential issues are there.

Customized the TL payable time load process that is loaded by default in each preliminary pay calculation.

Unconfirmed a confirmed payroll and reconfirmed.

Time and Labor

Resolve all issues related Time admin process on a day to day basis.

Created multiple dynamic groups to process 30K+ employees within a specific time frame.

Time and Labor Security redesigned.

Setup Time Reporting Codes with different level (Employee, Manager and System) of access.

Value List, Rules and Recompilation of rules.

Setting up load date and Time offsets for daylight savings.

Analyze Time and Labor -> Archived Batches

Custom SQR report to identify payable time discrepancies.

PeopleSoft Security

Good understanding on PeopleSoft Security

Menu, Component and Portal access.

Portal Sync job.

Department Security, SJT class All, SJT Operator Class.

Custom PeopleSoft password control.

Custom process to enroll new employees in PeopleSoft.

Concept of Symbolic ID, Access ID, Connect ID and how database access is controlled.

PeopleSoft DBA

Install and configuring the Application and Web Servers

Setting up Process Scheduler to control maximum number of supported threads (AE, SQR etc).

Setting up/maintenance of reports nodes for posting reports.

Putting custom system outage message when there is schedule maintenance.

Setting up WSH to setup 3-Tier connections for the business users.

Setting up Disaster Recovery environment.

Custom processes

Developed generic Component Interface to load job, job code data as per requirement from business team.

Custom Component Interface process to load New-Hire information into Peoplesoft received from recruiting vendor Taleo

Many other custom SQR interfaces.

Responsible for leading a support team in offshore-onsite model and delivering solution to our customer in the Banking sector using leadership capabilities.

Every year suggesting some perfective maintenance to the client that is helping client to save lot of manual effort.

Deliver quickly and detail resolution for the production problems in a high demanding environment using capabilities of bringing different groups together to resolve critical production problems when it is not confined within PeopleSoft application only.

Responsible for production ticket resolve on a 24X7 basis using SQR (Structured Query Reporting), SQL (Structured Query Language) and Mainframe JCL (Job Control Language)

Responsible for effective communication between the offshore and onsite project team and the customer. Provide day to day direction to the project team at offshore and regular project status to the customer using Microsoft Live Meeting, Microsoft Excel, Microsoft PowerPoint and conference calls

Translate customer requirements (small and minor enhancements) into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results using Microsoft Word to document the client requirements and the process flows, unit testing steps that are set and documented by the business in a Microsoft word document. Also SQR (Structured Query Reporting), SQL (Structured Query Language) and Mainframe JCL (Job Control Language) are used during testing.

Utilize in-depth knowledge of functional and technical experience in PeopleSoft HRMS (Human Resources Management System) ERP (Enterprise Resource Planning) and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.

Environment: Mainframe z/OS, DB2, PeopleSoft NA Payroll, Time & Labor, Base Benefits, Workforce Administration, Employee Self Service, Manager Self Service.

Team Size : 5

July 2006 – March 2007, Offshore Team Lead IBM India Pvt. Ltd. Kolkata, India

Client: MetLife

Head quartered in New York, NY, MetLife and its affiliates offer a full range of insurance and other financial products and services. In addition to life, non-medical health and property and casualty insurance, MetLife is a leader in savings and retirement products and services for individuals, small businesses and large institutions. MetLife is the largest life insurer in terms of life insurance "in-force" in North America, and offers financial products and services to 88 of the Fortune 100SM companies. MetLife has engaged IBM for its current 8.3 to 8.9 PeopleSoft (HRMS, Benefit, Time and Labor and NA Payroll modules) upgrade project.

Working as a Team Lead to analyze SQR (Structured Query Reporting) and structure differences between 8.3 and 8.9 versions using PeopleTools and SQR.

Distribution of the work among the team members, guidance to the team to on-time bug free delivery using leadership capabilities

Resolving issues, maintenance of work status, weekly status meeting with the onsite members using Microsoft Live Meeting, Microsoft Excel, Microsoft Word, Microsoft PowerPoint and conference calls

Building the unit test cases steps using Microsoft Word to document the unit steps that will ensure the client expectations are met.

Analysis, Design and Testing for the Time and Labor customization process using Microsoft Word to document the client requirements and the process flows, unit testing steps that are set and documented by the business in a Microsoft word document. Also SQR (Structured Query Reporting), SQL (Structured Query Language) were used during testing.

Resolutions for TPR (Test Problem Reports) during system testing using PeopleSoft SQR (Structured Query Reporting), PeopleTools and SQL (Structured Query Languages)

Client assistance on demand basis.

Environment: PeopleSoft HCM 8.9, PeopleTools 8.47, UNIX, Oracle 10g, SQR

Apr 2006 - June 2006, Offshore Team Lead IBM India Pvt. Ltd., Kolkata, India

Client: General Motors

Analysis of the processes using PeopleSoft SQR (Structured Query Reporting)

Distribution of the work among the team members using leadership capabilities

Guidance to the new team members to on-time bug free delivery using leadership capabilities and mentoring the new members.

Resolving issues, maintenance of work status, weekly status meeting with the onsite members using Microsoft Live Meeting, Microsoft Excel, Microsoft Word, Microsoft PowerPoint and conference calls

Building the test cases for both system integration and user acceptance testing using unit testing steps that are set and documented by the business in a Microsoft word document. Also SQR (Structured Query Reporting), SQL (Structured Query Language) were used during testing.

Environment: PeopleSoft HRMS 8.8, Oracle 9i

April 2005 – March 2006, Systems Analyst/ Programmer IBM India Pvt. Ltd., Kolkata, India

Client: ProQuest Information and Learning.

Analysis, Development and maintenance of the new Web Hire module using PeopleTools, SQR (Structured Query Reporting) and SQL (Structured Query Language)

Open Enrolment system customization for the year 2006 using PeopleTools, SQR (Structured Query Reporting) and SQL (Structured Query Language)

Health care vendor feeds and Fidelity, 401K process customization using PeopleTools, SQR (Structured Query Reporting) and SQL (Structured Query Language)

SQR analysis and development for different management reports using SQR (Structured Query Reporting) and SQL (Structured Query Language)

Development of UNIX shell script for file transfer (using FTP) using UNIX shell scripts

Maintenance of all Project related work in Rational Portfolio Manager (RPM) and eRequester starting from creation of the service request to the closure using IBM Rational Portfolio Manager and client specific tool eRequester

Environment: PeopleSoft HRMS 8SP1, Oracle 8i

Achievements: Received a Special Recognition Award from IBM for maintaining good client relationship.

March 2004 – March 2005, Systems Analyst/Developer IBM India Pvt. Ltd., Kolkata, India

Client: General Motors

SQR Analysis and Development/Upgrade of Batch/Interface processes from Peoplesoft HRMS version 7.5 to 8.8 using PeopleSoft (Structured Query Reporting) and SQL (Structured Query Language)

Object Modification/Creation for the upgrade process using PeopleTools

Functional, Technical Specification and Unit Test Plans Creation and Testing of SQR for the 8.8 HRMS implementation process using Microsoft Word, PeopleTools, SQR (Structured Query Reporting) and SQL (Structured Query Language)

Environment: PeopleSoft HRMS 8.8, Oracle 9i

November 2003 – March 2004, Systems Analyst/Developer, IBM India Pvt. Ltd., Kolkata, India

Client: The Home Depot

SQR Analysis and Development using PeopleSoft (Structured Query Reporting) and SQL (Structured Query Language)

Environment: PeopleSoft HRMS 8.8, DB2

May 2002 - September 2003, Software Engineer, CMC Limited, Kolkata, India

Client: In House

System Analysis

Design, Construction and testing

Assistance in Implementation

Provide solutions for Reports.

Database Backup & Recovery, Importing& Exporting Database, Creating and Granting Roles

Environment: Windows 2000, Oracle 8i, Developer 2000 (Forms 6i and Reports 6i)

April 2001 - April 2002, Software Engineer, CMC Limited, Kolkata, India

Client: OTTO India Pvt. Ltd.

Analysis

Design

Development and Testing

Implementation & Support

Database Backup & Recovery, Importing & Exporting Database, Creating and Granting Roles

Environment: Windows 2000, Oracle 8i, Developer 2000 (Forms 6i and Reports 6i).

April 2000 – March 2001, Software Engineer, CMC Limited, Kolkata, India

Client: Rifle Factory Ishapore & Ordnance Factory Balangir

Development and Testing of PO module

User interaction & Training

Environment: HCL server, UNIX, Informix 7.3, Visual Basic 5

Education:

Bachelor’s in Chemical Engineering - 1997, Calcutta University, India,

Contact this candidate