SUMMARY:

• A highly experienced PeopleSoft Technical / Functional Consultant with more than 19 years of solid experience in software implementations, upgrades, development, customizations and support.
• Have more than 17 years of progressive technical, functional experience in customization, upgrade and implementation of PeopleSoft HCM ( HR, North American Payroll, Payroll Interface, Benefits Administration ( Confidential, Benefits Billing), Base Benefits, and Time & Labor.
• Have 8+ years of experience as an on - shore lead coordinator in an onsite/offshore support model.
• Have very good experience in maintaining Sarbanes-Oxley ( SOX) compliance with internal application level controls and segregation of duties.
• Roles have included requirement definition, design analysis, strategy consultation, time estimation, prototyping, coding, testing, performance tuning, user training and support.
• Proficient in Module Design, Development, Upgrade, Batch Processing, Interfacing, Data Conversion, Security design using PeopleTools 8.5x, 8.4x, 8.19, 7.5, 6.0 ,PeopleCode and SQR.
• Have good experience in self-service modules like eRecruit (Talent Acquisition Manager ), eProfile, ePay, eBenefits.
• Expertise with Application Designer, PeopleCode, Application Engine, Component Interfaces, Integration Broker, Web Services, Application Packages, Security, Business Workflow , SQL and SQR .
• Worked on PeopleSoft HRMS Upgrades version 5.0 to 6.0, 6.0 to 7.5, 7.5 to 8.3, 8.8 to 9.1 and 9.1 to 9.2.
• Have excellent experience in designing and writing reports using BI Publisher, SQR and PS/Query.
• Have excellent knowledge of job scheduling via PeopleSoft Process Scheduler and Autosys.
• Have excellent knowledge of PeopleSoft Internet Architecture and technology.
• Have strong analytical and troubleshooting skills.
• A dedicated, energetic person with excellent organizational, communication and client liaison skills.

TECHNICAL SKILLS:

ERP Packages: Peoplesoft HCM (Public/Commercial) 9.2,9.1, 9.0, 8.9, 8.8, 8.3, 7.5, 6.0, 5.0 . Confidential EHRMS Enterprise Version 3

ERP: Modules ePay, eProfile, eRecruit, eBenefits, ePerformance.

Softwares/Tools: PeopleTools 8.5x, 8.4x, 8.1x, 7.x, 6.x, 5.1x ( Application Designer, People Code, Application Engine, Component Interfaces, Integration Broker, Workflow, Business Process Maps, ExcelToCI, EDI Manager, Data Mover, Process Scheduler, Security, Tree Manager), Confidential EBuilder V3, Ecode, Java Batch, Oracle Developer 2000, Centura SQL Windows, Power Builder

Reporting/Query Tools: SQR, Crystal Report, PS Query, SQL, XML/ BI Publisher, DB Artisan, IBM Cognos Impromptu

Database Systems: DB2, Oracle 9i, 8i, 7.x, MS SQL Server 7.0, SQL Base, MS Access

Web Technologies: HTML, XML, Java, Java Script, PHP, MySQL

Languages: C, C++, VB, SQL, PL/SQL, JAVA, Pro*C, Unix and DOS scripting.

Operating Systems: Windows 7/Vista/XP/2000/NT/98/95, Windows Server 2003, MS-DOS, UNIX, SCO-XENIX, HP-UX, Sun Solaris, AIX

Other Tools: Visio, ER Diagrams, MS Project, MS Office, Autosys, UltraEdit, Dimensions PVCS, MS Sharepoint, STAT, FTP Utilities.

WORK EXPERIENCE:

Confidential, Auburn Hills, MI

PeopleSoft Technical and Functional Consultant / Business Process Manager

Responsibilities:

• Worked as Project Manager for PeopleSoft HCM 9.2 Upgrade and also provided SME support.
• Worked as Technical/Functional Lead on Redesign of Unified Attendance Program module for managing attendance and discipline for UAW population.
• Lead DB2 10.5 Upgrade of PeopleSoft HR and worked with Independent testing team and internal testing team to write scripts, test scripts and perform stress test.
• Worked as Technical/Functional lead in implementation of HR Service Center for Request/Approval based Hire/Job transactions.
• Worked as Technical lead / SME on conversion of legacy mainframe hourly payroll to PeopleSoft Hourly Payroll System.
• Worked on assessment and design of implementation of hourly payroll in PeopleSoft Payroll system. Guided Infosys assessment team on hourly payroll fit/gap analysis and designing of SUB ( Supplemental Unemployment Benefits),Vacation, Shortage, 24 hour check processes. Proposed multiple employee record mechanism to pay one employee under multiple companies while utilizing PeopleSoft’s delivered gross to net functionality for calculations.
• Lead a major system improvement by removing about 1200 Autosys inbound file watcher scripts and replacing them by a Single File watcher PeopleSoft Solution.
• Worked on PeopleSoft HRMS 9.1 upgrade as key subject matter expert and actively participated in all the phases including fit gap analysis, customization verification, system integration and parallel testing.
• Re-Designed the Online Payroll Batch execution by removing usage of third party scheduling tool (Autosys) from its design and replaced by PeopleSoft’s delivered process scheduling mechanism.
• Performed application fit gap analysis for estimating work scope for PeopleSoft 9.1 upgrade.
• Worked on designing of data warehouse solution for allowing external users to access PeopleSoft payroll data using a front end interface and without constant assistance from IT. Worked on Cognos Impromptu for writing tax reports.
• Worked as technical lead on tasks involving change of bank from Comerica to JP Morgan as well as implementing new IAT ( International ACH Transaction) changes in the Direct deposit feed.
• Lead the implementation of State and Local Tax project in PeopleSoft. Designed the processes for Extracting State/Local Tax information from Self Service (Dashboard) system via XML and updating PeopleSoft Payroll System.
• Designed and developed “Sync Engine” module for converting legacy employee balances into PeopleSoft Balances for mid-year launch of US Biweekly Payroll.
• Worked on Upgrade from People Tools to 8.50.
• Wrote programs and procedures for implementing SOX compliance and segregation of duties.
• Designed and developed various Application Classes using application package objects for providing common logic for standard inbound interface validations and computations.
• Designed and developed various Application Engine loading and posting programs.
• Designed and developed web based PIE Online system for allowing the users to view the payroll data and approve the required transactions for posting to Peoplesoft Payroll tables. Demonstrated and trained the users on using the PIE Online system.
• Designed and developed Rapid Entry Excel Worksheets using ExcelToCI utility for validating and loading inbound bulk data into the PIE staging tables manually. Developed Component Interfaces for capturing Earnings, Deductions and Taxes inbound data via Rapid Entry Excel spread sheets.
• Wrote detailed designs for the FICA Adjustments inbound interface and various summary and balance reports for the payroll Year End Processing. Documented and tracked modification versions for complying with Sarbanes-Oxley Act requirements.
• Implemented PeopleSoft’s Variable Compensation module for processing and approving eligibility awards and integrated with PIE system. Used integration broker, Component interface and Application engines for customizing and creating new objects for custom eligibility implementation.

Environment: PeopleSoft HCM 9.2, 9.1, 8.8 (HR, Payroll, Base Benefits), PeopleTools 8.5x,8.4x, SQR, DB2 UDB, Windows 7, ExcelToCI, PS Query, FTP, AIX Version 5, Dimensions Version Tracking, XML Spy, STAT, Autosys, Cognos Impromptu 7.4, MS Sharepoint, Lotus notes, UltraEdit.

Confidential, Albany, NY

PeopleSoft Technical and Functional Consultant

Responsibilities:

• Created detail designs for customizing delivered HR/Payroll pages for incorporating custom business rules required by the clients.
• Designed and developed a Confidential interface to identify Confidential eligible employees and/or their dependents along with their Medical / Dental / Vision and Flexible Spending Accounts elections. A new field was added on the Health Dependent Page.
• Modified Confidential Interface from Enterprise to Confidential Services to correctly process the automated generation of the Confidential Initial Rights Notice.
• Created database agent/ message agents for implementing payroll interface batch system. Setup the Java Batch and scheduling of the interfaces. Worked on various benefits and payroll SQR reports.
• Designed and developed route control profiles, workflow objects for routing worklists and emails to various level of payroll approvers. Worked on setting up the security for users.
• Worked on applying delivered patches and fixes. Analyzed the comparison reports and maintained the customizations. Worked extensively on debugging and troubleshooting eCode and SQRs.

Environment: Confidential EHRMS Enterprise Version 3 (HR/Payroll/Benefits), Etools ( Ebuilder,Ecode, Query, Application Upgrader), MS SQL Server 2000, MS Project,, SQR 4.2, UltraEdit, Windows 2000.

Confidential, Albany, NY

PeopleSoft Technical and Functional Consultant

Responsibilities:

• Performed fit-gap analysis by reviewing release notes and Personal Information related customizations. Identified upgrade tasks and estimated time duration for three major modules (Personal Online transactions, Batch process and Mass Change Process).
• Played active role in implementation of self service modules like (eBenefits, eProfile ).
• Created roles for eProfile Desktop Manager to authorize full/part time, location changes request for termination and other changes. Customized eBenefits pages for displaying additional information related to elected benefit plans.
• Implemented eRecruit module.
• Assisted in setting up installation tables and requisition & resume option setup in eRecruit.
• A large volume of candidates apply for state wide positions monthly at Confidential .
• Effective dated functionality for Personal components was accepted in version 8.3 for the first time. Modified various personal information related pages, components and Name search methods. Also modified New Hire and custom Job Request/Approval Components.
• Developed an interface program that enabled providers to obtain information on Confidential eligible employees. These names would print to a flat file. Any change JOB data or Coverage Code would be monitored during the user-specified period. All employees were then validated for client specified candidates.
• Involved in running Upgrade Scripts & Process using Upgrade Assistant Tool. Performed several iterations of Test Moves to Production, using Upgrade Assistant.
• Re-Designed Batch Processes completely by using Component Interfaces, Application Engine and Process Scheduler. Developed and managed test plans for testing Batch system.
• Created/Modified Application Messages for enhancing the data synchronization.
• Developed custom workflows in Time & Labor for elapsed time reporting. Created rules for overtime, holiday, time reporter status, approvals and computed time.
• Wrote extensive amount of Object Oriented PeopleCode for adding new customizations to meet the business and legal requirements of the department. Replaced obsolete commands with version 8 code.
• Created/modified various iScripts for dynamic web content generation. Wrote HTML for page html area to view and print grid, documents from web.
• Created/Modified Workflow business processes for various modules. Modified Workflow component.
• Gathered reporting requirements and modified various SQRs and SQL scripts. Tuned queries for performance. Created/Modified Unix and MS-DOS scripts for processing Batch.
• Modified security for various Permission Lists, Roles and Process profiles.
• Tracked/maintained upgrade plan and development using MS Project / Excel.

Environment: PeopleSoft HRMS 8.3/7.5 (HR, Payroll Interface, Benefits, Time & Labor, eModules), PeopleTools 8.12/8.19, SQR 4.2, Crystal 8.0, Oracle 9i, 8i, Windows NT/2000, Sun Solaris, MS Project, UltraEdit.

Confidential, Albany, NY

PeopleSoft Technical and Functional Consultant

Responsibilities:

• Modified the New Hire and Transaction Approval panels, records and views for using the Confidential functionality.
• Modified delivered/customized SQR and SQL scripts. Designed, created custom Setup Sqc files for printing custom reports in different fonts.
• Generated and compared various comparison reports and identified appropriate actions for upgrading. Determined data requirements and mappings for upgrade process and wrote complex data conversion SQRs.
• Analyzed and modified custom Workflow attributes for Batch Processes.
• Modified batch related database/message agent definitions. Added Confidential to the mappings of customized / new database agents and workflow objects. Created test plans for testing Batch system.
• Developed custom reports like health plan participants, savings plan participants, employee dependents, absence history, employee earnings using SQR and crystal reports.
• Tracked upgrade progress and development using MS Project / Excel Spread Sheets.

Environment: PeopleSoft HRMS 7.5/6.0 (HR, Payroll Interface, Benefits, Time & Labor), PeopleTools 7.5/7.61/6.0 , SQR, Crystal, Oracle 8i, Windows 98/NT, Sun Solaris, MS Project, UltraEdit.

Confidential, Albany, NY

PeopleSoft Technical Consultant

Responsibilities:

• Developed major customizations to the Administer Workforce module, including new tables, views, panels, business process maps and extensive PeopleCode.
• Led technical development for a very complex, user-friendly custom module called Title and Position Management (TPM) Mass Change process, which was composed of Peoplesoft Technology, SQR and Visual Basic. Developed an automated system for approving positions at various levels of business by using complex SQRs, Workflow, Message, Database agents and process scheduler.
• Created a Request and Approval process for all Job transactions. Used Business Process Designer for developing workflow for the request and approval process. Assigned role names, route control profiles and defined worklist records.
• Coded more than 100 action/action-reason combinations to accommodate complex New York State business rules and legal requirements.
• Used EDI Manager for capturing Batch transactions sent by external agencies in form of flat files. Used inbound agent SQR and mappings for loading the staging tables.
• Designed and developed various Message agents and Database agents for processing transactions in a batch. Provided time estimates, test plans for Batch SQRs and Peoplesoft Workflow setup.
• Customized Peoplesoft HR modules, including Probation, Traineeship, Performance evaluation. Designed, developed and tested Appoint Leave/Continue change control.
• Developed custom SQRs for benefits billing and also modified delivered BEN040 (Benefits Billing Statement SQR) for proper formatting and adding supplementary benefits information.
• Developed custom payroll and benefits reports using SQR and Crystal Reports that give information about employee earnings, deductions, tax reports and also exception reports like Negative Net Pay.

Environment: PeopleSoft HRMS 6.0 (HR, Payroll Interface, Benefits, Time & Labor), PeopleTools 6.12, SQR, Crystal, Oracle 7, Windows 98/NT, Sun Solaris, Visual Basic, MS Project, UltraEdit.

Confidential, Cambridge, MA

PeopleSoft Technical Consultant

Responsibilities:

• Used PeopleSoft Application Upgrader, Batch Transfer, Database Setup, Data Mover, Import Manager, WinQVT/Net, SQR / Crystal Reports, SQL Plus.
• Created Application Update Databases with projects like HC511PRJ and TX511PRJ and imported/copied them to a demo database. Analyzed database comparison reports and performed cleanup steps. Consulted PeopleSoft Global Support Center regularly for patches and fixes.
• Base Benefits, Benefits Admin Modules and Payroll Interface: Customized, developed new records, views and panels. Wrote PeopleCode to in corporate new and complex validations. Wrote SQRs for Payroll Analysis, Summary of % Salary increase of the Employees, Long Term Disability Plan Enrollment, Location/Department wise Terminated/Retired Employees, Employee Summary.

Environment: PeopleSoft HRMS 6.0/5.0 (HR, Benefits, Payroll Interface), PeopleTools 6.0/5.11/5.0 , SQR, Windows 95.

Confidential

Systems Analyst/Programmer

Responsibilities:

• Developed various tables, forms and on-line reports using Centura SQL Windows, SQL Base and SQL Talk tools. Created a test plan for reports testing.
• Worked on Sales Module (Enquiry, Offer, Order, Dispatch, EGP and Invoice processing), Distribution (Stock Transfer Advice, Material Receipt Note, Stock Processing) and Accounts module (Collection / Payments, Credit / Debit Notes, Voucher Processing).

Environment: Centura SQL Windows, Power Builder 5.0, Oracle 7.1, SQL Base, DB2, Windows 95, 3.11 (LAN), SQL Talk.