SUMMARY

• A PeopleSoft professional with 10 years of experience in the IT field in different capacities in the implementation of several successful and challenging projects.
• Profound and Proven track record as Technical consultant in the Implementation/development/support of PeopleSoft HCM, CRM and FSCM modules.
• Extensive experience in the areas of System Analysis, Design, Gap - analysis, Functional Design, Implementation, Unit Testing, Parallel Testing, Data mapping and Conversion of data from legacy systems to PeopleSoft system.
• PeopleSoft HRMS/HCM/FSCM 7.02/7.5/8.0/8.3/8.8/8.9/9.0/9.1 development and Production Support to the modules (Core HR, Benefits, Benefits Administration, Payroll NA and Global, Time and Labor, Self Service, Recruiting, Inventory, Order Management, Purchasing, GL, Workflow and Work Flow administration process.
• Expertise with development Tools Application Designer, Application Engine, PeopleCode, Component Interface, Process Scheduler, Process Monitor and Workflow.
• Strong on Reporting Tools like SQR, Crystal Reports, PS/Query, PeopleSoft Security and PS/nVision.
• Experience in Manual Testing - Testing Application using Win runner, Load runner, Developing Test Strategy, Test Plan, Test Cases, and Test Script.
• Expertise in Control-M, PVCS and Clarify tools.
• Extensive experience in the analysis of business processes, setups, and report customization, upgrades, data conversion from Legacy Systems to PeopleSoft application databases, writing interface programs, testing, trouble shooting and providing online support.
• Worked with users to analyze their needs to successfully develop PeopleSoft modules.
• Production support, Troubleshoot/Debug processes and fixing data/code issues in DEV/TST and migrating to PRD.
• Extensive experience in Conversion and upgrade of PeopleSoft Applications.
• Strong documentation and written presentation skills, and developed various functional and technical specifications with Test Plans and Procedures.
• Excellent communication skills, has clear understanding of business procedures and ability to work as an individual and also as a part of team.

TECHNICAL SKILLS

PeopleSoftVersions: 9.1/9.0/8.x/7.5/7.06(HRMS/ HCM/ CRM/ FSCM)

HRMS: HR, Benefits, Benefits Admin, Payroll (NA and Global), Time & Labor, Payroll Interface, Training Admin, Absent Management, Position Management.

CRM: Support module

FSCM: Inventory, Purchasing, Order Management and GL e-Modulese: Benefits, eProfile, eRecruit, eCompensation, ePay, ePerformance, eDevelopment, eProcurement (ESS, MSS, EHD, MHD)

Development Tools: Application Designer, Process Scheduler, Tree Manager, Workflow.

Integration Tools: Application Engine, Component Interface, Business Interlinks, File Layout, Application Messaging

Reporting Tool: PS Query, Crystal Reports, SQR, PS/N-Vision.

Administration Tools: Data Mover, Update Assistant, Security Administrator, Configuration Manager

Languages: PeopleCode, SQR, SQL, C, C++, Java, VB, VB & Java Script, ASP.

Internet Tools: HTML, DHTML, Java Script, JSP, XML, XSS.

Middle Tier: MS IIS, IBM WebSphere, BEA Web Logic 5.1, Tuxedo 6.5 and Jolt 1.2

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/7.0, DB2, MS Access.

Packages: MS Office, Visual Studio, Macromedia (Flash, Dream Weaver, Fireworks), Adobe, MS FrontPage, TOAD, STAT, Report Smith

Version Control Sys: PVCS, Oracle STAT.

Job Scheduling Tools: Control-M.

Operating Systems: Windows 98/NT/2000/XP, UNIX, LINUX, MS-DOS 6.22.

PROFESSIONAL EXPERIENCE

PeopleSoft Developer

Confidential, NYC

Responsibilities:

• As a senior programmer developer involved in Conversion of implementing Global PeopleSoft 9.1 HRMS across the Globe.
• Worked on Conversion of Configuration Data Load, Language Load, Employee & Non-Emp Data, Person Profile and Miscellaneous data for countries Japan, Korea, LATAM and EMEA.
• Worked on conversion process for loading Configuration loads - Account Codes, Location, Job Codes, Department, Position Data, School, Content Item, and Faculty.
• Worked on conversion process for loading Employee Data Loads - ID Delete process, Personal Data, Job Hire and Job Conversion rows for employees and Non-Emp, Job Additional and Annual target amounts.
• Worked on conversion process for loading Employee Benefits Data, Health Benefits, Life and Add Benefits, Simple Benefits, Disabilities, Disciplinary Action.
• Worked on conversion processes for loading miscellaneous loads - Dependent Data, Contract Data, Additional Names, Emergency Contact, Prior Work Experience, Payee Bank Load, Bank Branch, Badge, Retirement Plan, Health Benefits, General Deductions, Additional Pay, Citizenship, School, Content Item, Faculty, Person Profile, Badge, Physical Exam and Review Rating.
• Worked on Excel to CI tool to load School and Content Items details for Japan country.
• As a conversion process worked on Excel loads to populate language related record like Location Language, Job Code Language, Department Language, Account Code Language and Position Language and Addresses and NAME AC and Position Extended Title.
• Extensively used tools Data mover, Application Designer, PS Query, PeopleCode, Application Engine and Component Interface.
• Used HP QC Tool to tack and communicate business users on conversion issues during Post Go-Live and after Go-Live.
• As a senior team member provided support to Post Go-Live activities and resolved all conversion issues before Go-Live and after Go-Live.

Environment: PeopleSoft HCM 9.1 Core HR, Benefits, Payroll, People Tools 8.51, People Code, App Engine, Component Interface, PS Query, Data Mover, Oracle 11g, UNIX

PeopleSoft Developer

Confidential, NYC

Responsibilities:

• Involved actively in design, coding, testing of HRMS PAC-RETROFIT project implementation.
• Worked on Department Budget and Valid Combo Code Application Engine Conversion Process.
• Modified WAM (Workflow Access Management) page to display and process transaction Roles online page.
• Worked on Salary Distribution page for employee allocation added criteria when selecting the Combination Code prompt on page.
• Worked on Additional Pay for Department Employees and Employees outside Depart added criteria when allocating new Combination Codes.
• Created new page to process PAC COA Override Conversion page to enter Chart of accounts details FAS Account, Site, Initiative and Segment for employees.
• Created new page Combination Code Table to create New Combo Codes.
• Worked on LDS Project to Date Conversion Application Engine Process.
• Worked Build Packet Conversion Pay Earn History Distributions Application Engine Process.
• Worked Valid Combo Extract to Outbound File Application Engine Process.
• Worked Employee Conversion Application Engine inbound interface process.
• Worked in HR Conversion Pay Earn History Distributions Application Engine Process.
• Worked on Department Budget Load Interface from outbound file Process.
• Modified search results for Combination Code in Salary Distributionand Additional Pay Department EE.
• Created Batch Schedules to UC4 for scheduling jobs daily, weekly, Semi Monthly, Monthly and Quarterly.
• Created technical design and Build documents for the new work units.

Environment: PeopleSoft HCM 9.0 (HR /Payroll, LA, ESS, MSS, Labor Accounting), People Tools 8.49, SQR, People Code, App Engine, Component Interface, Data Mover, Oracle 11g, Windows Server 2003, UNIX

PeopleSoft Developer

Confidential, NYC

Responsibilities:

• Involved in Implementation and Customization of Core HR, North America Payroll and self Service modules which included creating and modifying fields, records, pages Menu and Components.
• Created Technical design specs, program coding/debugging, unit testing based on functional design documents
• Customized Location Table page to add 4 new fields on the page to get Parent Location, Borough, Location Type, Directions to Location.
• Customized Job Code Table page to add 5 new fields on the page to get NYCT Occupational Group, OMP Position, OMB Occ Code, DOP Code and Special Payment Code.
• Created new page under Self-Service to get W-4 State Data details i.e., SWT Marital/Tax Status, Withholding Allowances, Amount, Percentage.
• Created outbound SQR programs which transfer the data through Flat File to the other systems.
• Created new outbound SQR process to combine T&L and Payroll data to create a file of hours and dollars for the employees in NYT and MAB.
• Created new outbound interface for NYS Pre Tax Deductions Report which need to run for biweekly.
• Created new SQR reports One in three Violation rule report, One in three violation summary report and Cross-section report under Employment.
• Created new DB links to access BSC HR information for other agency business reporting.
• Created inbound SQR program to update deduction table.
• Created new SQR report Garnishment Letters for Child Support and Marshall, CWA (Communications Workers Union) all annuity deductions for its members in union code 17, B7 and 05 and NYS Pre Tax Deductions Report.
• Worked on custom Exam module which includes all RICE activities.
• Developed new Bi-directional Novell Identity Manager (I-Vault) component interface for tracking personal changes from I-Vault and PeopleSoft.
• Developed new business process to send email when there is a change in email address of the users in I-Vault and PeopleSoft.
• Worked on Release1 production issues
• Created test cases, documenting/analyzing test results of Unit Testing.

Environment: PeopleSoft HCM 9.0 (HR /Payroll/Benefits/Recruit Workforce and /T&L), People Tools 8.49, SQR, People Code, App Engine, Component Interface, Integration Broker, XML Publisher, Business Process, Oracle 11g, Windows XP, UNIX

Sr.PeopleSoft Technical Consultant

Confidential, Chapel Hill, NC

Responsibilities:

• Involved in Analysis, Design, Implementation and Production Support of PeopleSoft Student Admin - (Campus Community, Student Records, Financials, Admissions and Financial Aid)
• Prepared Technical design documents for the enhancements in Student Records, Campus Community, Financials, Admissions and Financial Aid
• Collected the requirements from the users and prepared both functional and technical speciation documents
• Created Custom Fields, Record, Pages and Components for report run control pages.
• Created Term Fix Budget Report and Residency Fix Budget Reports using Query Manager and XML Publisher.
• Created new SQR reports Athlete Course Breakdown, Recently Dropped Courses Report, Enrollment Dates and Stops, Athlete Twelve Hour Report, UNC Billing Report, UNC Daily Refund Report, Tuition Waiver Amount by Year, Tuition Waiver Report, Courses Waived Report, J1 Students Changes Report, Nursing Appls By Admit Term Report
• Developed and customized PeopleSoft delivered SQR reports srclsrst- Class Roster, sr803-Enrollment Verification, sr740a-Repeat Code, sr744- SR Class Notes, sr720b- Class Level Designation, sr742a- Course Attribute value
• Generated Data Mover Scripts for migrating data from development and test environments to PRD.
• Created Checklist, Communication and Comment (3C’s) business views, UNC CCI Grant View and ISIR Data Business View
• Worked on SEVIS (Student and Exchange Visitor Information System) component to create user specific PS Query’s to collect data, monitors changes, and reports student and exchange visitor changes.
• Involved in coding and unit testing and review of the requests in the Projects
• Responsible to create, move to production documents and projects (CR’s) migrating using conventional application designer upgrade tool.

Environment: PeopleSoft 9.0 (Student Records, Campus Community, Academic Advising, Financial Aid, Student Financials), ORACLE 10i, People Tools, SQR, Crystal reports, PS Query, Windows NT, UNIX.

Sr.PeopleSoft Technical Consultant

Confidential, San Francisco CA

Responsibilities:

• Involved in developing and customizing the reports using the tools PS Query and SQR.
• 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.
• Worked on new business requirement for capturing new production booking and Approval where added couple of new functionalities apart from normal booking and also added email functionality for sending emails to Marketing managers to approve or unapproved the new production booking. When the production is created and submitted by user online, automatically send an email to user and as well as Marketing Persons mentioning Customer ID, Equipment Type and Quantity of the new booking.
• Developed and customized record definitions and views, using Application Designer.
• Involved in analysis and doing retrofit of customizations for the following modules Purchasing, Inventory, AP, AR, Budgets and PC.
• Involved in preparing Unit, system and integration test cases and technical standards, Quality testing, performance tuning, data conversion, interface designing and Application of patches and fixes.
• Business requirement analysis. - Worked with client to identify and map business requirement.
• Done analysis and Retrofitted multiple SQR programs to enable table changes to Chatfield data and also retrofitted multiple SQR’s in PO module (POPO005, PORFQ01) and Pickplan report in inventory module.
• Modified FZ NPD (Net Per Diem) Application Engine process to cut down processing time and also modified calculation rules.
• Interacted with users for developing new SQR reports from scratch like NP Booking Report, Net Per Diem Report and Aging Detail by Customer.
• Created new SQR processes like Customer 12 months On-Lease Profile and Aging Details by Customer to insert data into temporary tables to make use of CRM.
• Troubleshot and fixing problems on development, Test Environment and moving changes to Production Environment

Environment: PS Financials 8.4/8.9 (GL,AP,AR, Inventory, Purchasing and Order Management) modules, PeopleTools 8.48, SQR, Application Engine, Component Interface, App Msg, Integration Broker, Crystal Reports.

Sr. PeopleSoft Consultant

Confidential, IL

Environment: PeopleSoft 8.9 HRMS (HR, Benefits, NA Payroll, Self Service), People Tools 8.46, Application Engine, PS Query, Process Scheduler, SQR, Oracle, Windows XP

Responsibilities:

• Implementation and customization of PeopleSoft HRMS 8.9 (HR, Payroll, Base Benefits and Benefits Administration).
• Worked with users for collecting business requirements and prepared functional and technical specification documents.
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Involved in developing new People Code and customizing existing People Code based on specific client functional requirements.
• Modified the existing run control pages to run reports based on location specific and also modified the delivered SQR reports to run based on location specific like Payroll Summary, Payroll Register, Deduction Register, Other Earning and Tax Deposit Summary.
• Developed, modified, Tested SQR’s and run control pages and run control records for user requested reports.
• Interacting with users and for developing new SQR reports from scratch like Layoff Status Report, Eligibility Summary by Health Benefit Plan, Eligibility Summary by CSA and Eligibility Summary by CSA/HMO.
• Played team lead role to manage four IBM off-shore resources for daily development and Support activities in build process
• Preparing test cases, documenting/ analyzing test results of Unit testing, System Testing, Integration Testing and User Acceptance Testing, Issue Tracking and resolutions.
• Created user manuals for running for reports.

Sr. PeopleSoft Techno-Functional Consultant

Confidential, NY

Responsibilities:

• Active participant for Re-Implementation of FSCM/SCM 7.02/7.5/8.3/8.8 through the entire life cycle of the project (Fit Gap, Functional Design, Configuration, Implementation)
• Performed Fit Gap Analysis, provides Current System Business Process, Process Flows, Security, Issues, Defects, Reports information and mapping to Future system with certain definitions like Gap, Adequate, In Adequate
• Gathered and Defined requirements, overall scope definition in terms of functional & technical requirements, Gap-Fit analysis, data mapping, legacy system integration, and customizations
• Online support to the users
• Involved in customizations needed for the users
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Worked on new functionality to capture Master BOL. PeopleSoft only created BOL within one BU. The Master BOL would capture data that is on the BOL and combine it between BU for whatever is shipped on particular truck.
• Worked on reports bill of lading, user preferences report, finished goods and new inventory by area report, Open order report, Die costed inventory report.
• Effectively communicated with business users, functional and technical team also interpreted functional specifications and built solid technical specifications.
• Project co-ordination between customers and technical staff.
• Created new SQR that read the data from text file and updates the PeopleSoft delivered tables to store item related information.
• Provided Solutions to Gap, Adequate, and Inadequate items by Matching with PeopleSoft 8.8.
• Created Job Aids, Trained End user, Process Design.
• Interacting with Functional consultants and users to discuss new requirements across the business.
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Designed and developed new panels and panelgroups according to the parameters required and attached to Menus and given security to run reports.
• Online support to the user on Workflow related issues.
• Played Team Lead role to manage a team of six resources
• Created new run control Id’s and scheduled these to run in process scheduler and as well as Control-M tool.
• Set up of daily/weekly/monthly batch processing.
• Customized various SQR’s and Crystal Reports and troubleshoot Application Engine Programs, Pages and PeopleCode.
• Created Quality assurance plan for post go live usage. Created all testing, training and end user documentation for FSCM
• Performance tuning of Application Engine Programs and SQRs.
• Mentor junior programmers on PeopleSoft functionalities and tools.
• Working with customers to analyze and design systems functionality to meet business requirements.
• Prepared test cases for Navigational testing, Functionality testing and UAT.
• Involved in writing queries to verify the results from the Financial tables and documented them in test scripts.
• Provided on call support to handle Production Support issues and resolved all the tickets as per the SLA’s defined by the client teams.
• Proving online support to the users across the Globe.

Environment: PeopleSoft FSCM/SCM 7.02,7.5, 8.3, 8.8, GL, Billing, Inventory, Purchasing, Order Management, Crystal Reports, SQR, Windows 2000/XP, Toad and Oracle 8.x,9i.

Sr. PeopleSoft Technical Consultant

Confidential, GA

Responsibilities:

• Conducted Fit/ gap analysis for core HRMS functionality in PeopleSoft HRMS 8.8
• Primary responsibility is with the implementation of benefits, Compensation
• Duties included analysis of benefit policies and compliance with State/Federal regulation, and the application to PeopleSoft base benefits.
• Responsible for creation of custom reports for support of Benefits
• Created new and customized the existing PeopleSoft Objects such as Fields, Records, Pages, Components and Menus.
• Involved in performance tuning of SQR and PS Query’s by creating indexes
• Developed Run control pages as per business requirements and attached to menu to run the SQR’s.
• Component, record and Field level People Coding.
• Involved in modifying PeopleCode and application engine programs to meet the business process requirements.
• Performance tuning of Application Engine Programs and SQRs
• Health Coverage: This report lists the detailed information of the employees who falls under a coverage type within a particular time period.
• Health Plan Participants: This interface generates the list of employees who comes under health benefits based on their union affiliation and place in to the respective tables. This also gives details about the Plan, Benefit, Coverage Date and employee Premium.
• Employee Job History: A detail Report which prints an employee's entire job history and any compensation changes that occurred during his tenure.
• Promotion Report: This report prints details of employees' promotion from date of joining to a user input date.
• Leave Report: This report prints leave details of Employee.
• Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on PeopleCode, Application Engine, COBOL, SQR’s & Online.
• Tested various SQR, nVision Reports and Peoplecode.
• Interacting with functional consultants to take updated functional requirements.
• Involved in writing test plans and developing test cases from Business Requirements
• Prepared test cases for Navigational testing, Functionality testing and GUI testing using Test Director.

Environment: PeopleSoft HRMS 8.3, People Tools 8.16, Core HR, Benefits, Payroll, Benefits Administration, Recruitment, Time & Labor, Process Scheduler, SQRW, Crystal, SCM Windows 2000/Xp, Toad and Oracle 8.x On HP-Unix

PeopleSoft Consultant

Confidential

Responsibilities:

• The implementation process involved modifications/additions and support to the PeopleSoft delivered software package. Record definitions, pages, components and people code needed to be changed to meet the business needs of the Client, which encompasses study of the Business process and business flow.
• Active participant for implementation of CRM 8.8 support module through the entire life cycle of the project (Fit Gap, Functional Design, Configuration, Implementation)
• Performed Fit Gap Analysis, provides Current System Business Process, Process Flows, Security, Issues, Defects, Reports information and mapping to Future system with certain definitions like Gap, Adequate, In Adequate
• Gathered and Defined requirements, overall scope definition in terms of functional & technical requirements, Gap-Fit analysis, data mapping, legacy system integration and customizations
• Developed functional specifications for the custom report based on the client requirement.
• Responsible for the successful development, coding and testing of PeopleSoft CRM (support module).
• Customized many pages according to client specs like adding check boxes, radio buttons, push buttons, disabling certain fields.
• Create/modify user interface pages and writing PeopleCode for various events.
• Used People Code to control the program flow and logic for validation to meet the current business requirements.
• Generated Flat file according to client requirement.
• Involved in preparing test scripts and testing the individual components like page, PeopleCode, and workflows.

Environment: PeopleSoft 8.8, People Tools 8.42, Process Scheduler, CRM, Support Module, PS Query, SQRW, Crystal, Windows 2000/Xp, Toad and Oracle 8.x On HP-Unix, People Tools - Security Administrator, Trees, PS Query, Process Scheduler, Application Engine and Application Designer.

Sr. PeopleSoft Programmer

Confidential, Stamford, CT

Responsibilities:

• Design and development of Confidential - GPHR application which includes Core HRMS and Self Service modules.
• Duties included analysis of benefit policies and compliance with State/Federal regulation, and the application to PeopleSoft base benefits.
• Primary responsibility is with the implementation of benefits, Compensation
• Responsible for the successful development, Coding, Testing and preparing unit test plans for the deliverables on the Core HR and Self Service modules.
• Involved in developing and customizing the reports using the tools PS Query, PeopleCode and SQR.
• Developed record definitions, pages, components, and queries.
• Developed Run control pages as per business requirements and attached to menu to run the SQR’s.
• Component, record and Field level People Coding.
• Involved in modifying PeopleCode and application engine programs to meet the business requirements.
• Fulfilling client requirements like Format, Default values, File Type, Null validation, Delimiter, Table Column.
• Workflow for Hiring, Rehiring, Transfer, Termination, Leave Approval, Leave Cancel, Leave Rejection and Personal Action Request.
• Provided online changes by adding customized translate values, modifying PeopleCode, adding fields to pages and modifying components and menus.
• Used Object based PeopleCode methods and built-in functions extensively for the customizations, modified pages writing PeopleCode like adding fields and new functionally to the existing pages.
• Interacting with functional consultants to take updated functional requirements
• Responsible for creation of custom reports for support of Benefits
• Created new and customized the existing PeopleSoft Objects such as Fields, Records, Pages, Components and Menus.
• Configured set up for Payroll, earnings, deductions etc
• Added new Benefit Plan types, Absence Types and Absence Take Types.
• Tested recruitment module based on company specifications.
• Modifying the test scripts according to the customizations
• Tested and prepared user manuals for various SQR Reports.
• Test the customization of various Pages, Components, and Records in HRMS.

Environment: PeopleSoft 8.8, People Tools 8.42, Core HRMS, Self Service, Global payroll core 8.8,Benefits, Recruitment, Process Scheduler, PS Query, SQRW, Crystal Reports, Windows 2000/Xp, Toad and Oracle 8.x On HP-Unix, People Tools - Security Administrator, Trees, PS Query, Process Scheduler, Application Engine and Application Designer.