SUMMARY:

• Over 8 Years of extensive IT industrial experience in design, development, and implementation of commercial multi - user software packages on diversified platforms with various versions of PeopleSoft implementations (PeopleSoft V 9.2/9.1/8.8/8.4 )
• Extensive experience in PeopleTools (App Engine, Component Interface), PeopleCode, SQR, Crystal Reports, PS/Query, PeopleSoft Security, and wide experience in building pages.
• Post implementation support to AP, PO, AR, GL and BI.
• Knowledge in PeopleSoft HRMS (Core HR, Base Benefits, NA Payroll, Time, and Labor).
• Experience in upgrading the PeopleSoft system from 8.45 to 8.51.
• Experience includes PeopleSoft Finance modules like GL, Treasury, AP, Purchase Order, eProcurement, Purchasing.
• Strong experience having developed several reports in SQR, Crystal Reports, BI Publisher and PS Query. Strong experience with PL/SQL scripts using SQLs having complex joins.
• Proficient in the creation of complex reports using SQR, XML Publisher / BI Publisher and Crystal Reports.
• Experience in generating reports using SQR, Crystal Reports and N-vision.
• Experience in People Tools like PS Security, Process Scheduler, Data Mover, Import Manager, Integration Broker, Process Monitor, Application Package, Workflow, and Utilities (SQL Trace and People Code trace)
• Strong Techno-Functional experience in PeopleSoft Finance 9.x,8.8, 8.4, 8.3, 8.0, 7.5, 7.0 and Experience in analysis, design, development and testing of various PeopleSoft modules such as GL, Purchase Order.
• Experience in Upgrades and new Implementations, Conversions, Migrations, Interfaces, and Reporting.
• Expertise in all phases of the System Development Life Cycle including Requirements Definition, Data Conversion, and System Implementation.
• Experience in Trouble shoot and provide resolutions and hands-on experience on PeopleSoft Internet Architecture (PIA). Experience in good Project Management and decision making skills and Proficient in mapping business requirements, designing & developing customized solutions, trouble-shooting for complex information systems management.
• Integration Broker specialist with a knowledge on both PeopleSoft to PeopleSoft and PeopleSoft - external system integration and integrated with many third-party vendors.
• Experience in work planning, management, project scope, status and tracking, project staffing, team integration and managing overall project quality and deliverables.
• Good experience in Requirement Analysis and preparing Functional and Technical design documents for Enterprise Portal. Good knowledge of whole PeopleSoft Enterprise Portal functionality to do impact analysis for any customizations.
• Experience in Peoplesoft production support, enhancements, and upgrades to existing and new PeopleSoft HCM and Peoplesoft CRM Customer Support.
• Experience in solving P0, P1, P2 tickets efficiently in HCM and FINANCE application.
• Experience in PeopleSoft Financials and Used Application Designer, UNIX shell scripting, HTML/DHTML, People Code, SQR, Application Engine, Application Package, Crystal Reports, Integration Broker, Component Interface, JavaScript, and Oracle (creation of complex SQL, Query optimization, creating database triggers, creation packages and procedures) from version 8 to 9i.
• Performed multiple consulting roles during my career including Technical and Functional Consultant.
• Experience in maintain the message between PeopleSoft FSCM and HRMS modules using the integration broker monitor and toolset.
• Experience Installation, administration, and upgrades of PeopleSoft environments on an Oracle/Solaris, PeopleSoft application architecture including the table structure, delivered objects, design standards, protocols and Involved in various PeopleSoft Applications Up gradation using Upgrade/ Change Assistant.
• Intangibles: Solid team leading capabilities, Dependable Communication Skills, Mechanical Focus and Discipline, High Work ethics, Reliable Organizational and multi-tasking skills, Strong Analytical and Problem Solving skills, Patient, and Professional attitude.
• Application Upgrade from 8.8 to 9.1
• Extensively worked in tuning the performance of the SQL for SQR processes.
• Expertise in handling RDBMS like Oracle.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows NT, Windows 2000/XP

Databases: Oracle 11g/10i/9i/8.x/7.x, Sybase 11, SQL server

Languages: C, C++, PL/SQL and HTML

PeopleSoft Related: People Tools, People Code, SQL, SQR, Tree Manager, SQL Plus, PL/SQL, PeopleSoft Security, Component Interfaces, Patches/Fixes, Process Scheduler, Application Engine, Data Mover, Integration Broker.

Report Writers: SQR, Crystal Reports9.0 and PS-Query, nVision, XML/BI Publisher.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. PeopleSoft Techno-functional Consultant

Responsibilities:

• Designed and developed custom GL functionality to accommodate the need for approval process for the University to be in compliant with the state and Federal regulations.
• Setup and make the environment ready for nVision reporting.
• Worked on SciQuest integration to PeopleSoft Projects. Wrote AE, CI to create a PO from a requisition.
• Involved in creating application engine to re-distribute employee/employer benefit deductions for employers working temporary for health and life insurance.
• Provided full project life cycle implementation from requirement gathering, planning project, to live production and post production support.
• Worked with PeopleSoft Fluid UI in creating a completely responsive device independent design providing advanced user experience.
• Created fields, records, pages, and Defined components for Fluid applications.
• Upgraded PeopleSoft HRMS from 9.0 to 9.2.
• Upgraded PeopleSoft FSCM from 9.0 to 9.1.
• Worked with PeopleSoft Integration Broker to perform synchronous and asynchronous messaging among internal systems and third party systems.
• Designed and developed custom data migration utility that allowed Business users to move configuration data between environments
• Prepared excel data interfaces to allow Payroll personnel to key in positive input and absence data into the system and to stream-line the business process.
• Developed views, online pages, components, Folders.
• Developed PeopleCode to create dynamic grids to populate Ledger information relating to budgets, encumbrances and actual from Finance, HR, and Student admin modules.
• Production support for Finance.
• Reapply customizations and identify/fix issues after bundles.
• Fixed Banking setup related issues for WIRE transfers.

Environment: PeopleSoft HCM 9.2, Finance 9.2/9.1, People Tools 8.55/8.53.

Confidential, Atlanta, GA

PeopleSoft Techno-Functional Consultant

• Providing support to integrations of PeopleSoft and third party systems
• Handling the issues related to PeopleSoft Security, Processes, PS Query, Integration Broker, Reporting issues etc.
• Modification done into an automated system to upload of HRMS transactions into PeopleSoft.
• Modified and tested various SQR. Unit testing of application.
• Developed an application using App Engine People code.
• Developed SQR reports to display critical process reports. Created AR Statement and Invoice reports in BI Publisher and used the BURST method for different vendors.
• Involved in creating Permission list, Role and assign it users. Resolved the login related issues.
• Involved in creating department tree.
• Worked on the Performance tuning of PS/Queries.
• Customized delivered Application Engine, SQR, Crystal and BI Publisher modules to handle Pay Cycle, General Deductions, W2 and 1099 withholding, ProBiz and ADP.
• Extensive experience working with People Tools, People Code, Application Designer, Application Packages, Application Engine, Component Interface, File Layout, Application Messaging, Integration Broker, Security, Tree Manager, PS Query, Process Scheduler, Data Mover, Import Manager, Workflow (AWE), Upgrade and Change Assistant, SQR, Crystal Reports and XML Publisher.
• Developed SQR Interface to send employees job details, tax details, and personal details to ADP.
• Modification done in an Application Engine Interface between Brass Ring and ING which handles New hire process.
• Modification done in Application Engine process which is an interface between PeopleSoft and OIM.
• Written PS/Query to get contractors data.
• Interacting with users to get requirement for change request.
• Coordinating with Ad Security team to resolve the issues regarding SSO registration, Email addressing, login issues.
• Worked with Application Security team to assign roles, add table into Query tree, modify Department tree.
• Modification done in 'Death Master Report' SQR as per new format of input file received by Social Administration Office.
• Modification done in App Message, Application Engine to fix the issue of Department Messages sending to Brass Ring.
• Developed 'Daily Termination Report', 'PS to MISS', 'Valid Email Report', and report in SQR.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.

Environment: PeopleSoft Finance 8.8, People Tools 8.45, Component Interface, Application Engine, SQR, PS Query, Application Designer, Workflow, Integration Broker, People Code, Process scheduler, PeopleSoft Security, MSS, ESS, e-Performance and Base Benefits.

Confidential, Beverly, MA

Sr. PeopleSoft Developer

Responsibilities:

• Creation of Master Company Statistics Reports (MCR) using SQR and Crystal Reports. These numbers are directly fed into corporate General Ledger.
• Created queries using PS-Query for users to run. These queries include policies not billed, tagged items in the system etc.
• Created Pages, Components, Menus
• Wrote AE Programs to load data from CRS into PeopleSoft Billing.
• Extensive use of PeopleCode and File Layout object in this App Engine program.
• Involved in major archiving process for AR and Billing Modules.
• Worked on tuning the Queries in SQRs to improve the performance for custom programs.
• Extensive work done on Crystal Reports to generate various reports like mailing lists, invoices, dunning letters etc.
• Created Several XML and SQR reports, such as Contract month wise invoice calculation report, Project master report, Quarter wise invoice report, Event Details report, Event Based FP contract report, Active Project valid contract Report, Non-Event FP contract report, Project Details Report, Active Project Valid contract report, IDU Wise PMO Details report, Non-Event Fixed price CA report, Project contract linking report, Team details reports.
• Involved in a major Database tuning to improve the timing of the nightly batch processing time. Tasks involved identifying SQL statements to tune and perform tuning creating indices to increase the response times.
• Created AE program to export data to PEGA.
• Worked on sending information to Harbor Payments. The Information sent included invoices, installment schedule, dunning letters etc. This interface is both inbound and outbound interface.
• Worked on PeopleCode to validate data entered by users on various pages.
• Created large number of pages for customer service group to show information like PCN’s, Policy information, Commission information, Payments made towards a policy etc.
• Worked on Parent/Child records premium header and premium detail tables
• Created an automated process to create worksheets thru a SQR program which reduced the number of data entry operators required.
• Create an automated process to transfer the policies to the external collection agencies.
• Extensively involved in transferring business logic used in PeopleSoft to SAP implementation team.
• Worked as a security administrator for the application.

Environment: PeopleSoft 8.4, Sybase 11 on UNIX Server, Application Designer, SQR, Application Engine, Component Interface, Crystal Reports, Data Mover, Process Scheduler, PS-Query, Security Administrator.

Confidential

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in Development, Enhancement, Upgrade and Maintenance of HR, Base Benefits, Benefits Administration, Payroll, and Time & Labor.
• Involved in Install PeopleSoft Demo Database and People Tools Demo Environment.
• Setup Change Assistant to run upgrades Processes and Scripts.
• Performed Fit/Gap analysis in the system and interacted with Business Analysts to figure out the Process flow in various Business processes.
• Setup Person Model Functionality and customized a COBOL DMS Section to pay pensioners that are terminated with pay.
• Responsible to run various Initial Audit Reports, Application Audit Reports, Compare Reports, and Scripts Modifications involved in the Upgrade Process.
• Involved in system testing and bug fixing during the initial and move to the Production phase of the Application Upgrade. Developed several reports in SQR, XML publisher, PS query reports, Nvision and Crystal reports.
• Built several XML/BI publisher reports within PeopleSoft system using Microsoft Word to create the templates.
• Modified the Delivered Upgrade scripts and Data Migration Scripts to convert the data from PS 8.3 to PS 8.9
• Responsible for modifying & upgrading several customized SQRs from PeopleSoft 8.3 to PeopleSoft 8.9.
• Analyze the SYSAUDIT report to determine the quires invalidated by upgrade.
• Analyze the Queries and Crystal reports to determine necessary record and field modifications.
• Implemented row level security and created new permission lists, Roles, and User profiles as part of Implementation.
• Involved in Employee Self service (ESS) and Managerial Self Service (MSS) to provide Unilever HRBPs a web based Interface to maintain position management information in the Global PeopleSoft System.
• Created Technical Design Document from Functional Design Documents in Core HR, Benefits, Payroll and Time and Labor.
• Wrote a SQR Service Award Report to make a provision for employees who have been in service for 25 and 40 years.
• Developed an Application Engine with component Interface to integrate Unilever Denmark Payroll System.
• Developed SQR Tax Code Table Interface to Citibank.
• Resolved several complex Production Issues in Benefits Administration, Payroll, and Time & Labor.
• Created Several Test Scripts for Reports and Online-Mods.

Environment: People Tools 8.48, PeopleSoft HRMS 8.8/8.9 (HR, Benefits Administration, Payroll, and Time & Labor), SQR, Application Engine, Component Interface, File Layout, PS Query, Data Mover, Oracle 10g, Windows NT, UNIX

Confidential

PeopleSoft Consultant

Responsibilities:

• Performed business process review for AP and PeopleSoft GL process.
• Responsibilities included data conversion, implementation of all business practices and business logic, providing technical assistance to the implementation process.
• Worked on writing technical specifications for SQR's and interfaces in PeopleSoft FSCM (OM, INV, PO, AP) modules.
• Designed PeopleSoft GL journal approval workflow.
• Responsible for the analysis of PeopleSoft 8.8 and 9.0 release notes and involved in the impact assessment and prepared upgrade document.
• Worked on core team member in the upgrade of PeopleSoft 8.4/8.9
• Use Integration Broker, Component Interface, and PeopleSoft Rapid Time Sheet Entry page for integration with TCD and swipe devices.
• Worked on performing System Development Life Cycle (SDLC) from analysis and design through testing and support.
• Customized AP check printing process using XML publisher.
• Developed a new PS Query, SQR to pull records of terminated employees and inserts into a table. Also, created script and attached it to the batch process to run the SQR nightly.
• Involved in developing and customizing the reports using the tools PS Query, SQR and crystal reports.
• Worked on created Quality assurance plan for post go live usage. Created all testing, training, and end user documentation for FSCM.
• Worked on involved in resolving the upgrade issues from PeopleSoft 8.4 to v8.9
• Developed PS Query, SQR Interfaces (inbound & outbound) and Reports to load data from external systems into PeopleSoft GL.
• Involved in Data Conversion for payroll from external system using SQR and Application Engine.
• As part of the leave accrual customization developed online page for vacation requests. Developed an App Engine program that sends vacation hours to Payroll and e-mail about the request to the manager.
• Configured new journal source and troubleshoot new PeopleSoft GL Interface issues.
• Worked on interacting with users and collecting business requirements and prepared functional and technical specification documents.
• Involved in developing new People Code and customizing existing People Code based on user requirements.
• Created new and customized existing Record definitions, Pages, Components for the client specific functionality.
• Involved in documentation of Unit and Integration Test Plans.

Environment: PeopleSoft FSCM 8.4(AP, PO, AR, OM), People Tools 8.41/8.44, and Oracle