SUMMARY

• Over 12 years of IT experience as a Software Engineer, involved in system analysis, design, development, testing applications for clients in various industries.
• Eight years experience in Customization, Upgrade, Conversion and Implementation of PeopleSoft HCM 7.5/8.9/8.8/8.3/8.0 modules HR, Payroll, Employee Self Service, eRecruit, Time and Labor and Benefits.
• Experience in Upgrade, Customization of PeopleSoft SCM/Financials Order management, Expenses, Project Costing, Inventory, GL.
• PeopleSoft HRMS technical People Tools knowledge including Application Designer and SQR language for functional troubleshooting, and technical/functional design spec writing.
• Participated on 2 full life - cycle implementations as part of Data conversion and Reconciliation, development, testing teams.
• Experienced in requirement analysis, technical design, implementation methodologies, conversion/interface strategies, data mapping, development, customization, tuning, and issue resolution.
• PeopleSoft HRMS security expert with in-depth knowledge of profiles, roles, permissions and portal structure/registry, password controls, query security and tree management.
• Experience in PeopleSoft Internet Architecture and extensively used PeopleTools including Development Tools (Application Designer, Workflow)
• Integration Tools (Application Engine, Application Messaging, Component Interface, Business Interlink), Administration Tools (Upgrade Assistant, Security), and Reporting Tools (Process Scheduler, Query, Tree Manager).
• Experienced in performing fit/gap analysis and process discovery for several financial applications, identified problems and resolutions for implementing the respective PeopleSoft systems.
• Excellent oral and written communication skills, short learning curve and strong team work spirit with excellent leadership qualities.

TECHNICAL SKILLS

Enterprise Applications: PeopleSoft HCM 8.x HR, Time & Labor, Employee Self Service, eRecruit, Payroll, Track Global Assignments, Talent Acquisition Manager.

Development Tools: Application Designer (Data Designer, Panel Designer, Menu Designer), PeopleCode, Application Engine, component interface, SQL.

Administration Tools: Security Administrator, Object Security.

Reporting Tools: SQR and PSQuery.

Data Management Tools: Data Mover, Import Manager.

Integration Tools: Business Components, Business Interlinks and Application Messaging.

Project Migration: Quest Software tool Stat, PVCS Tracker.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Senior PeopleSoft HCM Consultant

Environment: UNIX, People Soft HRMS 7.5 / 8.16 / 9.0 , Payroll, Benefits Administration, ePay, eProfile, eBenefits, eRecruit modules, PeopleTools 8.45, SQR, Oracle, Windows

Responsibilities:

• Involved in converting customized panels into pages and panel groups into components.
• Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security).
• Designed and developed several new SQR Reports in PeopleSoft HRMS 7.5 to 9.0 and edited several reports in 9.0.
• Worked on PS Pay Calender, PS Pay Check, PS Job, PS Personal Data, PS PersNid tables and Generated reports by PayGroup, RunId in Payroll Module.
• Involved in creating Application Engine programs and File Layout definitions such as writing data to a file, reading from flat file by adding new Sections, Steps and Actions.
• Ran System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
• Performed comparison test between our demo database and our copy of production to identify customization and analyzed the reports.
• Involved in the design strategy and implementation of loading the data from Legacy HR.

Confidential, Herndon, VA

IT Application Developer II

Environment: PeopleSoft HCM 8.8 with Peopletools 8.46, PeopleSoft SCM & Financials 8.4 & 8.9, Peopletools 8.47, SQR, PSQuery, Windows NT, UNIX.

Responsibilities:

• Worked extensively with Business Partners in resolving issues related with Time Admin creating Offsets and issues with multiple pay lines for employees.
• Modified PeopleSoft delivered Time reporting Pages to auto populate Company, setid, deptid and business unit fields when a user logs into Time reporting.
• Developed a New Process which was scheduled to run everyday after the Time Admin to update an Employee’s Department.
• Added new fields to the Time Approval Page on MSS.
• Modified the Address Fields on ESS.
• Created a New Page for recruiters to track comments related to Applicants.
• Modified the custom load certification process to look at the right fields for populating a Table.
• Modified the ADP Periodic & Quarterly Tax Interfaces to add new localities.
• Tuned the HR FASTVIEW by adding a hint for better performance.
• Modified the custom MetLife Interface to meet business requirements.
• Performed Production Support tasks involving data clean up and bugs in PeopleSoft 8.4.
• Gathered requirements from users and designed Technical Specs as per the Requirement of End Users, developed pages, Analyzed end-user needs, satisfied user requests for developing pages.
• Data conversion and Reconciliations were done from PeopleSoft SCM/Financials 8.4 to 8.9.
• Developed an Interface between Confidential and Confidential tosend a Remittance detail File from PeopleSoft Accounts Payable to AMEXin PeopleSoft 8.9.
• Developed an Inbound Interface to build Vouchers for Different Vendors.
• Worked on Confidential custom Contract Vehicle Management component to define & maintain contract vehicles that can be referenced by Quotes and Sales Orders for Product Pricing.
• Fine Tuned SQL in Application Engine Programs for better performance.
• Developed SQR’s to load Files from Concur to PeopleSoft Expenses and to create expense vouchers.
• Created Component Interface in the Upgrade Environment due to changes in the component structures.
• Involved in the Configuration Set Up for PeopleSoft 8.9 Expenses.
• Cost of PS Query were Determined and tuned to reduce the Cost.
• Created technical Specifications & Migration Documents for Project Migration between environments using PVCS Tracker.

Confidential, Washington, DC

Sr. PeopleSoft Consultant

Environment: PeopleSoft HCM 8.8, PeopleTools 8.46, PeopleCode, SQR, PS/Query, Windows NT, UNIX.

Responsibilities:

• As PeopleSoft developer, enhanced PeopleSoft HCM to fit Company s business including many custom pages as well as modifying delivered pages with PeopleCode and SQR s.
• Implemented process controls for both business functions and technology support functions.
• Application Designer has used extensively to customize time reporting page, daily summary page and daily task pages according to the specification and requirement.
• Modified several benefits SQR reports to meet the business requirement.
• Updated message displayed on a page and give security access to this page for Employees
• Modified the SQR report HR00100 to include grade 7 new hires to be granted with 150 hours for Family sick leave.
• All absence management time and prior period adjustments without requiring manager’s approval.
• Customized the payroll and compensation page for non-CA officers and directors to have access to view the leave balance page.
• Customized Time & labor to have an edit against an employee cost center to allow only valid restricted project code for the employee current time reporting period.
• Fixed the errors/bugs coming out of the PS Payroll/ Time labor modules.
• Project Migrations were done between environments using the Quest Software tool Stat.

Confidential, San Ramon, CA

Sr. PeopleSoft Consultant

Environment: PeopleSoft HCM 8.8, PeopleTools 8.45, PeopleCode, SQR, PS/Query, Windows NT, UNIX.

Responsibilities:

• Involved in customization and implementation of PeopleSoft Employee Self Service and time & labor modules.
• Developed and customized the Benefits reports in HCM using SQR and Crystal reports.
• Updated time run control and also involved in building time period calendars.
• Enabled Security through Maintain Security.
• Developed generic PeopleCode Functionary programs for various tasks, for example implementing field level security based on end user roles.
• Designed and developed customized overtime calculation reports for the employees with shift and more than 40-hour work week calculation.
• Customization for Leave Module Pages and coded SQR report for Leave Exception report.
• Developed many customized SQR reports/processes to read data from flat files and process Employee Transfers, Terminations, Promotions and Union Deduction Increases.
• Involved in setting up various configuration options such as workflow e-mail notifications, worklists as per the requirement of the organization
• Used Data Mover to export data from conversion database to production database.
• Involved in testing and resolving errors in SQR programs.

Confidential, Dallas, TX

PeopleSoft Technical Consultant

Environment: PeopleSoft HCM 8.3, PeopleTools 8.42, People Code, SQR 5.3.2, SQL, OS/390, Windows 2000 and Oracle.

Responsibilities:

• Involved in applying on-line customizations to HR, Payroll and Time & labor of PeopleSoft HCM v8.3.
• Designed, developed and maintaining interfaces between TL, Payroll, and GL.
• Involved in customizing PeopleSoft delivered SQR reports such as Benefits enrollment report Employee Earnings Report (PAY014).
• Extensively used PeopleSoft Application designer, Report Manager, Process Scheduler, PeopleSoft Query and other development tools.
• Performance tuning of Application Engine programs was done successfully.
• For example, the initial processing time of Application Engine program PERS UPDATE that was 2.5 hours was brought down to 1 hour.
• Worked with PeopleCode to automate the various processes with conditional logic for the e-Recruit collaborative application.

Confidential, Dallas, TX

Environment: PeopleSoft CRM8.4, PeopleTools 8.45, People Code, SQR 5.3.2, SQL, OS/390, Windows 2000 and Oracle.

Responsibilities:

• Reviewed and implemented Technical design specifications based on Functional Docs.
• Customized the RO CAPTURE component to include the Preliminary Customer
• Management page according to the requirements.
• Customized the Case Page by adding additional customized sub page to it called CPE Details.
• Developed several Application Engine programs, which are associated to Business Projects and also stand alone Application Engine programs, which run as batch processes.
• Modified the RC CASE Record by adding additional customized fields to it.
• Used Application Engine programs, Component Interfaces and File Layouts to migrate data, which is coming in as a .CSV file.
• Developed Integration Broker objects like inbound and outbound messages for transactions with ACE (billing system) and MPS (user management system).
• Used message people code to add functionality to the Integration Broker messages developed.
• Designed and developed new Business Projects to fulfill Orders according to various product items and bundles.
• Designed the CEM logic to run the Business Projects and execute the tasks (Create Account, Add Installed Services, Add Billing services).
• Designed Data conversion process for massaging and importing legacy data in the PeopleSoft Customer Data model (BORM).
• Used Application Packages in retrieving and adding information to the Customer object.
• Customized the 360-degree view, to display information in ACE (Billing System) and to show the customers account profile.
• Fine Tuned SQL in Application Engine Programs for better performance.
• Performed Production Support tasks involving data clean up and administration of PeopleSoft servers.
• Used PL/SQL scripts in cleaning up the production problems.
• Developed AE programs to load all the products in a staging table to publish in SuperPages.com.
• Debugger, trace to debug PeopleCode and AE programs when doing development and production support
• Implemented Interactions upload process from legacy by using Component Interface and Application Engine programs.

Confidential, Portland, OR

PeopleSoft Consultant

Environment: PeopleSoft HCM 8.3(Time &Labor, Benefits, HR), PeopleTools 8.42 Application Designer, PeopleCode, Application Engine programs and Component Interface, PS Query, SQL server, Enterprise Manager, Windows NT.

Responsibilities:

• Analyzed and Developed/Modified SQR interface programs/reports in Payroll & Benefits to meet the business requirements of PGE.
• Evaluating and applying the PS delivered patches and fixes on a regular basis to enhance HRMS functionality.
• Fixed the errors/bugs coming out of the PS Payroll/ Time & labor modules.
• Created an interface to load the captured time of employees to the database and scheduled it to run periodically.
• Developed new SQR reports in Time & Labor / Payroll/ HR as enhancements to support end users.