SUMMARY

• 8+ years of IT experience in the Analysis, Design, Development, Implementation and Testing in different modules of the ERP - PeopleSoft HRMS.
• Experience in versions 8.8,8.9,9.0,9.1 and 9.2 providing functional support in various modules in PeopleSoft Financials and Supply Chain including PO, ePro, AP, AM, AR, BI, Ex, KK and GL
• Extensively worked with Inbound and Outbound Application Engine Programs using File layout and testing.
• Expertise in Application Designer, People Code, SQR, Process Scheduler, XML Publisher PS-Query, Workflow, and Application Engine.
• Proficient in Module Development, Upgrade, Interfacing, Conversion, Data Migration using People Code and People Tools.
• Knowledgeable in the creation of complex database reports using SQR, PS/Query and XML Publisher.
• Strong working knowledge of RDBMS such as Oracle, SQL Server and MySQL.
• Worked on industry products like PeopleSoft (HCM, ELM, and TAM), Oracle, HP Quality Centre and HP Application Life-cycle Management.
• Proficient in all phases of the systems development life cycle including requirements definition, data conversion, system implementation, system testing and acceptance testing.
• Experience in PeopleSoft implementation, development, customization and production support in HRMS.
• Primary areas of expertise include application development, writing conversion and interfaces programs using SQR’s, Application Engines and Excel to CI, developing reports using XML Publisher and SQR, supporting and administering PeopleSoft environments and providing technical assistance and guidance to support staff and project teams.
• Good experience in documentation of functional/technical designs, code modifications, and analyzing test results.
• Experienced in Reports, Interfaces, Conversions, Enhancements and Workflow.
• Extensive knowledge in PeopleSoft Data (Row-Level) Security, Creating & assigning Roles, Permission lists, User profile, User Security and Object Security.

TECHNICAL SKILLS

Languages: People Code, SQL, C

Databases: Oracle 10/9 and DB2

Applications: MS Word, Excel, Power Point, Outlook, P

PeopleTools: People Tools 8.4x/8.5x (Application Designer, Maintain Security, Data Mover, PeopleSoft Internet Architecture, Application Engine, Application Package, Process Scheduler, PeopleSoft Workflow etc.), SQR, XML/BI Publisher, Approval Workflow Engine, Integration Broker.

Methodology: Agile, Object-Oriented Analysis/Design, UML, SharePoint, Unix ODBC, MS Visio 2008.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Consultant/ Trainer

Responsibilities:

• Worked on PeopleSoft security and streamlined the current security set up.
• Identified the current security issues including the duplicate permission list and roles
• Automated the security process in 9.2
• Identified the total number of users and number of active users of the permission lists by querying and defined the role based access for each job role.
• Written the technical specification document for the entire current security set up process
• Working on HCM upgrade project from 9.1 to 9.2 version
• Working on Retrofits and Customizations
• Conversion of all custom Crystal reports to SQRs
• Conversion of customized delivered crystal reports to BI Publisher
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Developing custom process to enroll the employees in time and labour.
• Also working on the PeopleSoft Approval Workflow Engine (AWE) and created Header Record, Xref Record ( cross - reference record), Transaction Component, Event Handler, Configuring AWE, Configure the events, approval process setup etc

Confidential, Dover, DE

Upgrade Specialist

Responsibilities:

• PHRST is the Human Capital Management (HCM) component of the Confidential Enterprise Resource Planning (ERP) system
• PHRST system is an integrated software application consisting of four modules within Oracle (PeopleSoft): Human Resources, Benefits, Payroll and Time and Labor
• Central payroll operations for all state agencies, school districts, charters schools, and higher education institutions
• Apply routine PeopleSoft system updates
• Analyze and provide functional and system support for Benefit and Salary Plans
• Integrated workflow with First State Financials (FSF)
• Worked on Confidential PHRST and FSF upgrade from version 9.1 to version 9.2
• Designed and configured AWE Workflow for Requisition and Expenses Approval. Configured approvals based on various chart fields, dollar amount and delegations using Records, SQL and App Packages.
• Worked on AP Related Enhancements and Work Order Customization in Requisition and Procurement
• Involved in Customization of Voucher Entry Page for integration of Voucher to Projects Contracts and Non Contract related which opens up Projects Chart Field page for Contract and Non Contract vendor.
• Conversion of all custom Crystal reports to SQRs
• Conversion of customized delivered crystal reports to BI Publisher
• Working on adding the new Ethnic Categories to EEO4 Reports using PS N/vision which includes the EEO-4 Jobcode Count, EEO-4 Status Report by Jobcode, Terminations and Separations by Sex and Ethnic Group, EEO-4 Status Report, EEO-4 Status Report w/Seasonals and Temporary Employees.
• Developed custom records, pages and Components to meet the Business Requirement.
• Conversion of reading custom reports using BI Publisher
• Working independently and maintaining the design documents for updated notes on changes made to the reports
• Preparation of Technical Design document, Unit test case documents
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Implemented 9.2 Features like Work Centers, Work Bench, Mobile Approvals, Fluid Interfaces etc
• Used STAT 5.8.0 for Migration

Confidential, Atlanta, GA

Developer

Responsibilities:

• Customizing existing PeopleSoft functionality as per user requirements.
• Developing inbound, outbound interface to receive and send data from PeopleSoft HCM 9.2.
• Worked on resolving issues with workflow approvals & AWE issues.
• Developed custom pages for the maintaining GM agreements and storing GM specific Learning management fields.
• Worked on crystal Reports, SQR, XML publisher. converted Crystal to Bi publisher and SQR
• Developed custom application engine programs to inactivate the courses, learning paths etc.
• Used PHIRE migration tool for migrating the projects across different PeopleSoft instances.
• Created custom reports using BI publisher.
• Preparation of Technical Design document, Unit test case documents.
• UAT, cut over support and post production support.

Environment: PeopleSoft 9.2, People Tools 8.53, Oracle 10g, Windows, UNIX.

Confidential, Columbia, SC

PeopleSoft Consultant

Responsibilities:

• The project involved implementation, customization of PeopleSoft HCM (HR, Payroll, and Benefits).
• Gathered requirements, designed, developed and tested application enhancements.
• Played key role in development of Interfaces using SQR’s, Application Engine.
• Developed custom reports using SQR and XML Publisher.
• Created custom approval process using Application Workflow Engine (AWE) for terminations.
• Designed and developed an SQR process to generate files, containing all checks issued and reversed, to be used for Account Reconciliation.
• Developed an Application Engine program to generate a file (biweekly or annual) containing hours worked in Terminals to be used for staffing and budgeting purpose.
• Developed an automated process to calculate and load adjusted salary used to determine life and disability benefits for commissioned employees using Application Engine and Component Interface.
• Created a SQR process to load the file containing Short Term Disability monthly payments from Hartford. Developed custom objects to store short-term payments made to employees.
• Resolved various issues with Time Admin runs.
• Designed and developed a custom process to enrol employees in Time and Labour using Application Engine.
• Developed a Reconciliation process to report variances between Reported time and Payable time using SQR.
• Created Test scripts and executed various test cycles for System testing and parallel testing.
• Developed custom reports needed per the client requirements using PS Query.
• Worked in a Production Support role to resolve issues related to Payroll processing.
• Provided quality documentation including Design Documents, and Test Scripts.

Environment: HRMS 9.2, People Tools 8.53, SQR, Oracle 11i, Windows NT, UNIX, Toad.

Confidential, Bedminster, NJ

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Requirements Analysis for new Change requests.
• Development and Retrofitting.
• Integration and System Testing Support.
• UAT Support for Job change transaction
• Deployment
• Support bug fixes and issues reported in Job change transaction, Termination
• Status reporting to Verizon Communication Management.
• Extensively involved in the analysis and retrofitting the existing People code, SQL’s, SQR’s, Application Engine’s and other PeopleSoft impacted objects.
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.

Environment: People Soft HRMS 8.8/9.1, People Tools 8.45/8.51, Windows, Application Designer, People Code, SQR, SQL, PS/Query, Crystal Reports, Oracle 10, PL/SQL.

Confidential, Altamonte Springs, FL

PeopleSoft Developer

Responsibilities:

• Involved with functional team to gather technical and reporting specifications and information for customizations, and designing reports.
• Worked on various People Tools such as Application Designer, Application Engine, Maintain security, Object Security, Process Scheduler, Process Monitor, PS Query, nVision, and Tree Manager.
• Modified and tested various SQR interfaces like General Ledger activity, Posted Journal summary and Journal entry details
• Designed an nVision report, which shows Revenue by Worksite for Business Unit, Products, and Departments by period. The report lists about the details of the revenue for each account in details by period.
• Designed an nVision report, which gives the monthly summary of total revenue by product for the given period.
• Designed an nVision report, which gives the Revenue for Department/Location by time spans. This report mainly summarizes about the revenue of each and every staffing office around the US to monitor the marketing leader’s business.
• Modification and development of new reports and queries using SQR, Seagate Crystal Report, nVision, Tree Manager, PeopleSoft Query for analysis, data integrity, reconciliation of the flow of data among modules of PeopleSoft
• Designed a Crystal Report, which captures Lost Orders for each Business Unit, Product and department by period. The report lists about the details of the lost orders and their contacts
• Designed a Crystal Report, which captures Open Orders for each Business Unit, Product and department by period. The report lists about the details of the lost orders and their contacts
• Generated a report using SQR to display the error data in the file sent by the carriers by comparing with the system tables.
• Developed new SQR Report, which gives the business unit breakdown of vendor information along with the total amount paid during the year.