PROFILE - SUMMARY:

• 6+ years of experience in the IT industry, in the area of ERP (Peoplesoft) customization, development and security.
• Strong communication, collaboration, team building and inter-personal skills.
• Good team player and a proven individual contributor.
• Proficient in PeopleSoft technologies and customization/development of PeopleSoft Applications using PeopleTools (Releases 8.47 to 8.49) technologies and tool sets - Application Designer, PeopleCode, Application Engine, File Layout, SQR/SQL, Workflow, Component Interface, BI Publisher and PS Query.
• Open work authorization to work anywhere in US without need of sponsorship or such.

TECHNICAL SKILLS:

PeopleSoft: Peopletools 8.55, 8.54, 8.49, 8.47, HCM 9.2, 9.0, 8.9

RDBMS: SQL Server, Oracle 11g

Language: SQR, PeopleCode, SQL, PL/SQL

OS: Windows XP

Tools: Application Designer, PeopleCode, Application Engine, File Layout, Workflow, Component Interface, PS Query, data mover, Toad, SQL developer, Oracle UPK, PTF, XML Publisher

EMPLOYMENT HISTORY:

PeopleSoft Developer

Confidential

Tools: and Technology: People Tools 8.55, HCM 9.2, Oracle 12c

Responsibilities:

• Working on pilot development projects for HCM9.2 applications and PUM retrofitting project.
• Working on interacting with power users, understanding business process and developing Peoplesoft test framework (PTF) scripts for various HCM modules and building functional test cases.
• Working on customization and development of various interfaces.
• Working on Application packages, Component Interface and Application Engines.
• Report development using BI Publisher.

PeopleSoft HCM Security Administration

Confidential

Tools: and Technology: People Tools 8.48, HCM 8.9, Sybase

Responsibilities:

• Worked on Peoplesoft security assignment to users as per ticket requests
• Developed and delivered documentation for all security administration tasks related to the new configuration.
• PeopleSoft HCM 8.9 (Platform UNIX) Custom Development/Enhancement project, People Tools version 8.48

Confidential, Washington, DC

Consultant

Tools: and Technology: People Tools 8.48, HCM 8.9, Oracle 10g, SQL Developer

Responsibilities:

• Analysis and development for bolt-on application.
• Developed SQRs/PS Queries for custom reports as per user requirement.
• Involved in enhancement for bolt-on applications as per user requirement.
• Working on design and development of specification documents.
• Participating in meetings with user POC to understand requirement specifics.

Environment: PeopleSoft HCM 9.0 (Platform UNIX) Implementation and Support project, People Tools version 8.49

Confidential, MI

Consultant

Tools: and Technology: People Tools 8.49, HCM 9.0, Oracle 10g, SQL Developer

Responsibilities:

• Development of custom reports in SQR/PS Query, custom pages.
• Customization in delivered SQR reports/pages as per user requirement.
• Developed SQRs/PS Queries for custom reports as per user requirement.
• Involved in NA Payroll runs in the system.
• Post production support of Benefits, Workforce administration and Time & Labor modules
• Handling production support for Payroll, Benefits and Time & Labor
• Working on design and development of specification documents.
• Participating in meetings with user POC to understand requirement specifics.

Environment: PeopleSoft HCM 9.0 NA Payroll (Platform UNIX) Implementation project, People Tools version 8.49

Confidential, OH

Associate consultant

Tools: and Technology: PeopleTools 8.49, HCM 9.0, Oracle 10g, SQL Developer

Responsibilities:

• Working on customization and development of various interfaces for North American payroll implementation.
• Working on Component Interface and Application Engines.
• Developed utility to upload payroll data.
• Working on rewriting SQRs as per requirement documents.
• Working on New SQRs for custom reports as per requirement documents.
• Working on design and development of specification documents.
• Working on UAT scripts and User Manuals for various interfaces developed.
• Participating in meetings with user POC to understand requirement specifics.

Environment: PeopleSoft HCM 9.0 (Platform NT) Implementation project, People Tools version 8.49

Confidential, Kentucky

Associate consultant

Tools: and Technology: PT8.49, HCM 9.0, UPK 3.5

Responsibilities:

• Worked with the Organizational Change Management OCM team for the development of appropriate training materials relevant to PeopleSoft HCM using Oracle UPK Tool.
• Interacted with end users to understand requirement closely.

Environment: PeopleSoft HCM 8.9 (Platform UNIX) Implementation Project, People Tools version 8.47

Confidential

Associate consultant

Tools: and Technology: PT8.47, HCM 8.9, Oracle 9i, SQL Developer, SQR, Application Designer, Data Mover

Responsibilities:

• Worked in development and customization of PeopleSoft promotion and investment modules which included extensive testing, debugging and problem solving.
• Worked in rewriting SQR based on changes of UAT
• Developed queries as per the requirements and provided support and knowledge transfer to functional Team.

Environment: PeopleSoft Core HR and TAM 9.0 (Platform HP- UNIX) Implementation Project, People Tools version 8.49

Confidential

Associate consultant

Tools: and Technology: PT8.49, HCM 9.0, 10g, TOAD, SQL Developer, SQR, Application Designer, Data Mover

Responsibilities:

• Worked in development and customization of Peoplesoft modules (Power of Attorney, Signing Power and Promotion) which included extensive testing, debugging and problem solving.
• Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security).
• Designed and developed several new SQR Reports in PeopleSoft HRMS 9.0 and edited several reports.
• Ran System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
• Performed Vanilla Comparison test between our demo database and our copy of production to identify customization and analyzed the reports.
• Used Application Designer to modify existing records, pages, and menus.
• Created Run control panels, panel groups, attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Used Application Engine to perform background SQL processing against the database.
• Written DMS scripts for data conversion using data mover.
• Developed queries as per the requirements and provided support and knowledge transfer to functional Team.
• Developed main SQR programs to convert legacy system data to Global PeopleSoft HRMS Training System. SQR functionality included data validation, processing, and error handling procedures.
• Creation of test cases, unit test plans and test data to test the programs that were changed as per user requirements
• Did System test of the programs with actual production data. Involved in customizing Table Structures, panels, pages and components.
• Worked on various customize as well bolt-on Peoplesoft modules independently