Executive Summary:

A PeopleSoft professional with 9 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 of core PeopleSoft HRMS and FSCM modules including Inventory, Order Management ,Purchasing,Core HR, Campus Solutions, Payroll and Benefits Administration,eModules.

• 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.
• Involved in installation, configuration, administrationof 8.3/8.8/8.9/9.0, provided postproduction support after implementation.
• Extensively involved in implementation of collaborative applications (self services areas) eRecruit, eBenefits, eDevelopment, eProfile, eCompensation, ePay and ePerformanceand CRM 8.3/8.8 (Support) module.
• PeopleSoft HRMS/HCM/FSCM7.02/7.5/8.0/8.3/8.8/8.9/9.0 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.

Applications and Tools

• PeopleSoft Versions 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, Pension Admin, Training Admin, Absent Management, Position Management.
• CRM Support module
• FSCM Inventory, Purchasing, Order Management and GL.
• e-Modules eBenefits, 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 Tools PS Query, Crystal Reports, SQR, PS/N-Vision.
• Administration Tools Data Mover, Update Assistant, Security Administrator, ConfigurationManager
• 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.

WORK EXPERIENCE

PeopleSoft Developer
Client: Confidential,NYC
Date: Oct‘11 to Current
Functional Area: PeopleSoft HRMS, Payroll, Employee Self Service, Manager Self Service, Labor Accounting.

• 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
Client:Confidential,NYC
Date: Oct ‘10 to Aug’11
Functional Area: PeopleSoft Core HR, Payroll, Benefits, Recruitment and Employee Self Service

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.
• Setup Integration Broker for retrieving real time data from the legacy/source systems
• 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 Release1production 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
Client: Confidential,Chapel Hill, NC
Date: Nov’09 to Aug ‘10
Functional Area – Campus Solutions: Admissions, Student Records, Financial Aid and Student Financials.

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
Client:Confidential,San Francisco, CA
Date: March 08 to Oct’ 09
Functional Area –Production Support: GL, AP, AR, Inventory, Purchasing and Order Management.

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 andAging 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
Client: Confidential, IL
Date: October 07 to Feb 08

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,
Client: Confidential,NY.
Oct 2005 – Oct 2007.
Functional Area –Production Support: GL, Billing, Inventory, Purchasing and Order Management.

• Active participant for Re-Implementation of FSCM/SCM7.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/SCM7.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.
People Tools - Security Administrator, Trees, PS Query, Process Scheduler, Application Engine and Application Designer, MercuryQualityCenter.