Summary:

• Over 7 years of IT experience in system analysis, design, development, testing and implementation of ERP applications.
• Completed Oracle PeopleSoft Developer I: PeopleTools PeopleCode 1Z0 - 241 Certification in April 2011.
• Experience in customization, implementation, and upgrades of PeopleSoft HRMS/HCM, including Human Resource, Base Benefits, Employee self Service.
• Experienced in design of technical/functional specification based on the end user interaction.
• Being a Consultant expert in dealing with HRMS, explains them the pros cons of developing projects provides innovative and alternate solutions for their requirements.
• Expertise in Peoplecode, Application Engine, SQR, Application package. Has also worked on Web Services and Integration Broker.
• Proficient in performing fit gap analysis, design, Interfacing, conversion and report writing using People tools, People code, application Engine SQR.
• Experience in full life cycle implementation for Global deployment.
• Possess good understanding about Roles, Permission List and PeopleSoft Row Level security.
• Strong functional expertise in Human Resources, Employee self-service, Base benefits.
• Solid experience in complex reporting using SQR, PS/Query.
• Expertise in Designing Functional Technical Specifications as Per CMM Level 5 6-sigma Standards.
• Commendable experience in Data Conversion, Migration, Import and Upgrade involving the tools like People Tools, SQL,SQR, AE programs, Component Interfaces, Data Mover and Import Manager.
• Expertise in developing interfaces to Taleo Applications.
• Experienced in Unit testing and Integration Testing of Peoplesoft objects and work products.
• Expertise in developing Oracle PL/SQL,SQL stored procedures.
• Experienced in the SSIS package for cross platform integration also worked on sql server.
• Experienced in using version control tools TFS Team Foundation server .
• Experienced in using Remedy tools Service Now.
• Motivated, hardworking individual with excellent communication skills.
• Utilizing the APP Designer tool, researched the Field, Page or Record layout to expedite the development team's resolution to functional issues.
• Produced many ad-hoc reports using PL/SQL, SQL and PS Query to verify data within the system data tables.
• Worked on Web application tool Oracle Application Express tool APEX

Technical Skills:

• PeopleSoft ERP : PS HRMS 9.2 / 9.1 / 9.0 / 8.x - HR, Workforce Admin, Base Benefits, Employee self-service and Manager self service
• People Tools : People Tools 8.5x / 8.4x- Application Designer, Application Engine, Component Interface, Application Messaging, File Layout, Query Manager, Change Assistant, Data Mover, Configuration Manager, Process Scheduler, Web services
• Programming Languages: People code, SQL, PL/SQL, SqlServer, SSIS
• Reporting Tools : XML Publisher, SQR, Toad
• Data Bases : Oracle 9i/10g, 11g, SQL Server
• Operating Systems : UNIX, Windows NT/2000/XP.

Work Experience:

Confidential

PeopleSoft Techno Functional Consultant

Environment:

• ERP : PeopleSoft HCM HR, Employee self-service and Base Benefits 8.9
• Languages/Tools : SQR, SQL, People Tools 8.51, People Code, Application
• Engine, Application packages, web services and Integration Broker.
• Database : Oracle 11g

Responsibilities:

• Developed SSIS scripts to import data from different database.
• Involved in change requests for database fixes which included writing complex sql scripts. Have fundamental knowledge on sql joins pl/sql.
• Used File Layouts to import/export data in/out of PeopleSoft system using App Engine
• Create technical specification for reports/interfaces
• Application Engine /SQR interfaces/reports to send Payroll information to vendors
• Create application engine programs for outbound/inbound interfaces
• Create online pages/components/People Code validations for dynamic data interface bolt on application.
• Component Interface for Taleo information load through application engine.
• Create component interfaces to load data in to additional country feeds.
• Prepare and test ExceltoCI to load data in to PeopleSoft through component interfaces
• Guide the users in UAT in testing interfaces and reports
• Developed web services to update the data feed from third party applications using integration broker.
• Build online pages and components to store setup data for bolt on applications.
• Perform migrations and security setups as needed for each country deployment.
• Participated in user acceptance meetings to guide the users.
• Develop interfaces to convert data from legacy systems to PeopleSoft as part of conversion project.

Confidential

PeopleSoft Techno Functional Consultant

Environment:

• ERP : PeopleSoft HCM HR, NA Payroll, Employee self-service and Base Benefits 9.0/9.1
• Languages/Tools : SQR, SQL, People Tools 8.51, People Code, Application
• Engine, Application packages.
• Database : Oracle 11g

Responsibilities:

• Prepared Technical design documents based on the functional design.
• Prepared technical specification from functional specification and Fit- Gap analysis for Retro-Fitting.
• Retro-Fitting of customized Fields, Records, Pages, and Components
• Retro-Fitting of Application Engine and SQR programs.
• Prepared Test Cases and Test Results for business process, AE and SQR programs.
• Performed Unit Testing, System Integration Testing for PeopleSoft objects, and SQR programs.
• Prepared Technical Design Documents for the SQR's

Confidential

Peopletools upgrade from 8.49 to 8.51

PeopleSoft Techno Functional Consultant

Environment:

• ERP : PeopleSoft HCM HR, Benefits 8.9
• Languages/Tools : SQR, SQL, People Tools 8.48- 8.51, People Code, Application
• Engine, Application packages.
• Database : Oracle 10g

Responsibilities:

• Retrofitting of PeopleCode SQR Processes in 8.51
• Responsible for Unit testing the work units and capture the results in a Unit Test document with screenshots.
• Developed PL/SQL scripts for data fixes
• Implemented various Page level Customizations and developed various SQR processes in 8.51
• Involved in tuning the application engine and sqr.

Confidential

PS Campus solution Implementation

PeopleSoft Technical Consultant

Environment:

• ERP : PeopleSoft Campus Solution 9.0
• Languages/Tools : SQR, SQL, People Tools 8.50, People Code, Application
• Engine, Application packages.
• Database : Oracle 10g

Responsibilities:

• Worked as a senior developer support on site team for fit -gap analysis
• Performed Data migration process
• Completed Required Setups for Campus Solution Modules
• Analysis of requirements and Customized Admission Module.
• Performed Code Review and Unit testing within the team.
• Prepared/Discuss Technical design documents based on the functional design.
• Responsible for creating Application Engine Programs load/extract data using flat files.
• Used File Layouts to import/export data in/out of PeopleSoft system using App Engine.
• Developed Component Interface to load data in PS from third party system.
• Develop SQR interface to collect data from external files and with proper validation migrate data into PeopleSoft.
• Develop a people code for expected validate on job data.
• Worked on data mover tool for data migration.

Confidential

Application Upgrade from 8.9 to 9.1

PeopleSoft Technical Consultant

Environment:

• ERP : PeopleSoft HCM HR, NA Payroll, Absence Management, Time and labor 8.9 / 9.1
• Languages/Tools : SQR, SQL, People Tools 8.49, People Code, Application
• Engine, Application packages.
• Database : Oracle 10g

Responsibilities:

• Prepared Technical design documents based on the functional design.
• Prepared technical specification from functional specification and Fit- Gap analysis for Retro-Fitting.
• Retro-Fitting of customized Fields, Records, Pages, and Components
• Retro-Fitting of Application Engine and SQR programs.
• Prepared Test Cases and Test Results for business process, AE and SQR programs.
• Performed Unit Testing, System Integration Testing for PeopleSoft objects, and SQR programs.
• Prepared Technical Design Documents for the SQR's
• Worked on data mover tool for data migration.
• Was responsible for data comparison after data migration
• Worked on extraction, transformation

Confidential

PS HRMS Support and maintenance

PeopleSoft Technical Consultant

Environment:

• ERP : PeopleSoft HCM HR, NA Payroll 9.0
• Languages/Tools : SQR, SQL, People Tools 8.49, People Code, Application
• Engine, Application packages.
• Database : Oracle 10g

Responsibilities:

• Provided advanced service to clients ensuring excellent application programming.
• Created fields, records, pages and components using Application Designer in 9.0v.
• Work on Workflow to follow business rules by sending emails or work-list and get them approved by the manager.
• Created new test cases and Technical design documents according to the BRD.
• Used people code to implement the business logic according to requirement.
• Information gathering from the Client in the Function walk through.
• Created new application Engine programs using the File Layout concept to import the data from the Flat files to PeopleSoft database.