SUMMARY:

• Nearly Fourteen years of Technical and Functional experience in Analysis, Design, Development, Testing and Implementation and upgrade of PeopleSoft applications
• Experience in PeopleSoft HCM/HRMS (Workforce Administration, Core HR, Payroll, Time & Labor, Retro Payroll Processing, eRecruit, ePerformance, Employee Self Service, Manager Self Service, Federal PeopleSoft System).
• Strong knowledge and experience with PeopleSoft Development with using PeopleTools like Application Designer, PeopleCode, Application Engine, SQR’s, Component Interface and PS/Query.
• Knowledge of reporting tools like Crystal Reports/ XML Publisher.
• Experience in writing SQR’s and Application Engine Programs.
• Worked on Fit/Gap analysis for upgrade of PeopleSoft v 8.9/9.1/9.2
• Experience working with, PeopleSoft Internet Architecture.
• Experience in manual and automated testing of PeopleSoft Modules
• Extensive knowledge in all phases of Software Engineering including requirements specification, use casing, functional specification, design, estimation, implementation, debugging, testing, and documentation
• Experience with Software Development with involvement in all phases of Software Development Life Cycle (SDLC) Waterfall Methodology and Agile Methodology.
• Performed planning and development of Test Plans, Test Cases and Test Scenario to meet products business requirements
• Strong analytical and problem solving skills and able to multi - task
• Strong communicator and a good team player with excellent interpersonal skills
• Very well versed in interacting with users with regard to collecting business requirements, user-training and post implementation production support.
• Strong analytical and problem solving skills.
• Excellent communication and Interpersonal skills with ability to work in both team environments, and individually.

TECHNICAL SKILLS:

PeopleSoft Modules: PeopleSoft HRMS 7.5/8.4/8.8/8.9 /9.1/9.2 (Workforce Administration, NA Payroll, Retro Payroll Processing, Core HR, Time & Labor, eRecruit, ePerformance, ESS/MSS)

PeopleSoft development Tools: Application Designer, People Code, Application Engine Programs, PS/Query.

Reporting Tools: SQR, Crystal Reports, PS Query and XML Publisher

Database: Oracle 8i/9i/10g, MS SQL Server, MS Access, and Informix

Programming Languages: C++, C, Java, HTML, SQL, Objective C

PROFESSIONAL EXPERIENCE:

Confidential,Washington,DC

Peoplesoft Techno-Functional Consultant

• Working as Techno-Functional Consultant on HRMS 9.2 Peoplesoft application.
• Working with Payroll Subject Matter experts to process retroactive pay raise for WTU employees and Union/Non-Union Employees.
• Entered and Validated Payrate increase percentage on Salary Plan Tables
• Processed Mass HR Federal PAR Transactions for employees eligible to receive retro pay
• Worked with Retro Pay Subject Matter Experts to process and validate retro pay transactions
• Developed SQL Scripts against Retro Pay and HR Tables to verify and validate the results
• Identified retired and term employees eligible to receive retro pay and updated payroll subject matter experts to be removed from retro pay
• Worked on Technical Analysis and Development of production support tickets to modify SQR Reports
• Worked on Functional and Technical Analysis on new enhancements to HR Processing to be implemented for FEMS FTO Employees.
• Worked on creating Functional Design Document to new enhancements to be implemented for FEMS FTO Employees.
• Worked on creating Functional Design Document for Processing Custom Mass HR PAR Processing and Retro Pay Processing
• Involved in verification, validation and testing of retro pay data and HR Par Processing data
• Worked with management team to resolve and fix any HR Processing issues during validation

Environment: PeopleSoft 9.2 (T&L, CORE HR, Retro Pay Processing), People Tools 8.55, Oracle, SQL Developer, TOAD, Windows 10, SQR’s, Peoplesoft Query Manager, Application Engine, Component Interface, Peoplecode, Remedy

Confidential,Washington DC

Peoplesoft Techno-Functional Consultant

• Worked as a Techno-Functional Consultant on HRMIS 9.2 Peoplesoft application.
• As a Technical consultant working closely with Product Owners, Functional Analyst, and Test Team to understand the requirement and provide solutions on existing customization or delivered functionality.
• Working closely with the team to follow Agile Methodology using JIRA Framework.
• Strong technical/functional understanding and hands on working experience with AO and Courts specific custom applications such as Leave Tracking (T&L), eRecruit (JDAR), ePerformance, eServices and all other HRMIS Applications.
• Worked on Employee Self Service and Manager Self Service applications.
• Strong understanding and experience with Federal HR Processes and Payroll Processes.
• Worked extensively on Leave Tracking customizations by analyzing and resolving production issues.
• Extensive hands on working experience on Leave Tracking functional processes such as Conversion of new users from nationwide Courts, Analyzing Leave Accrual Process, Time Administration Process, Leave Requests, Leave Dashboard and Leave Ledger.
• Worked on technical development and support of Federal specific HR applications such eOPF, SF-50
• Worked on technical development and support of custom AO processes such as AO-250, AO Load, Employment Suitability, Business Reports.
• Worked on technical development and support of various HRMIS applications such as RDE, eServices, Judges Retirement Services, Financial Disclosure Report, FEPS report.
• Worked as technical developer on HRMIS upgrade projects from version 8.9 to 9.1 and 9.1 to 9.2
• Handled bundles & patches to resolve issues during the upgrade process.
• Worked on PeopleTools 8.52/8.53/8.54 and 8.55 for development and customization of HRMIS applications.
• Hands on working experience with PeopleCode, Application Engine, Component Interface, Workflow, Fluid Pages, Workcenter, XML Publisher, SQR's.
• Conducted united testing, peer reviews and code reviews for fellow developers.
• Completed Technical Design Documentation during and after the development stage.
• Attending daily stand up meetings and status meetings

Environment: PeopleSoft 8.9/9.1/9.2 (T&L (Leave Tracking), HRMS, MSS, eServices, ePerformance, eRecruit (JDAR), PS Security), PeopleTools 8.41/8.49/8.50 /8.52/8.53/8.54/8.55, Oracle, Informix, Unix, Windows 2000/XP, SQR’s, Peoplesoft Query Manager, Application Engine, Component Interface, Rational Clear Quest, Rational Requisite Pro, Agile Methodology, JIRA Framework

Confidential,Washington DC

Production Support-Techno/Functional

• Working with production support team to resolve critical issues related to PeoplePlus HRMS
• Working on maintenance, analysis and development of Outbound and Inbound SQR interface for DOL project.
• Working on maintenance, analysis and development of HR pages to sending pay actions to federal ePayroll provider DFAS.
• Performing analysis of issues, understanding of business requirements and providing development for incidents reported against HRMS system
• Participated in gathering business requirement meetings for development of SF-182 interface using PeopleCode, Application Engine and SQR.
• Created front end interface pages using PeopleTools 8.22
• Modifying PeopleCode for components, pages and record fields.
• Working on support tickets for production migration
• Conducted fit gap/analysis for v8.3 to v9.1
• Extensively worked with Application designer to modify existing Peoplecode to accommodate new functionality for HR PAR Transactions
• Wrote Complex SQL Queries using SQL Plus to perform analysis for quick turn around on various HR Issues.
• Developed SQR report to export PII data into Excel format.
• Writing Data Mover Scripts to import and export data from Production to Development as on when required.
• Using Quest STAT for creating archives set for migration of all tickets to Production environment
• Performed Unit Testing for testing for every issue worked on.
• Creating Unit Test Cases
• Performing Manual QAT Testing
• Attending weekly meetings to update production issues and update client about status of tickets.

Environment: Peoplesoft 8.3 HRMS, PeopleTools 8.22, Oracle 10g, TOAD, Unix, Windows 2000/XP, SQR’s, Peoplesoft Query Manager, Quest STAT 5.2

Confidential,Washington DC

Peoplesoft Techno-Functional Consultant 

• Worked with production support team to resolve critical issues related to Time and Labor and HR
• Worked on support of workflow to update HR Job pages with specific PAR Action and NOA Codes
• Working on new initiatives analysis and development of Time and Labor module
• Designed and developed components, pages and menu structures required to interface with existing T&L pages.
• Worked on implementing T&L security conversion process to grant T&L security to Time Approvers, Time Keeper and Time Administrators.
• Worked on setting up T&L Security, Dynamic Groups, Group Security Permissions before implementing Security conversion process
• Worked on setting up Core HRMS security and T&L Security for new users
• Worked extensively with Manager Self Service, eServices and ePerformance modules
• Worked closely with Functional team members with requirement analysis and technical analysis.
• Performed analysis on specific government required leave accrual plans, enrollment and balances
• Developed complex SQL queries to update the GVT HRS Balances under leave accrual summary, leave ledger tables
• Extensively worked with Government Leave Accrual COBOL program
• Developed batch email program using Application Engine to remind Time Reporters, Time Keepers and Time Approvers about Timesheet submission status
• Developed custom PeopleSoft pages to display user current annual leave balances, projected year-end balance and Use or loose hours based on accrual plan
• Performed analysis and development of custom pages to display and calculate real time compensatory balances versus comp balance calculated by Time Admin process
• Working closely with functional team in implementing court user time reporter data and leave balances in Time and Labor.
• Worked on development and enhancement of batch conversion program developed in Application engine.
• Performed Manual Peer Unit Testing
• Trained Help Desk support users on Time and Labor enhancements implemented.
• Attended PeopleSoft 9.1 upgrade fit/gap analysis meetings.
• Worked on comparing v8.9 customization with v9.1 in regards to HR and T&L.
• Worked with functional analysts and end users to understand and map current PeopleSoft v8.9 functionality with PeopleSoft v9.1
• Worked on migration of PeopleSoft objects between different environments to conduct Peer Unit Testing
• Attending weekly meetings to update production issues and update client about status of tickets.
• Using Rational Clear Quest and Requisite Pro for bug tracking and reporting and storing functional requirements.

Environment: PeopleSoft 8.9/9.1 (T&L, HRMS, MSS, eServices, ePerformance, eRecruit, PS Security), PeopleTools 8.41/8.49/8.50, Oracle, Informix, Unix, Windows 2000/XP, SQR’s, Peoplesoft Query Manager, Application Engine, Component Interface, Rational Clear Quest, Rational Requisite Pro Confidential,Chevy Chase,MD

Peoplesoft Technical Developer

• Responsible for gathering user requirements analysis and documentation of functional and technical design specification
• Modifying PeopleCode for components, pages and record fields.
• Developed workflow prototype for custom NNRL application to be used by agents nationwide.
• Attended weekly functional meetings for requirement gathering and analysis of NNRL application
• Worked on support tickets for production migration

Confidential,Washington DC

Production Support-Technical Developer

• Responsible for gathering user requirements analysis and documentation of functional and technical design specification
• Modifying PeopleCode for components, pages and record fields.
• Working on support tickets for biweekly production migration
• Extensively worked with Application designer to modify existing Peoplecode to accommodate new functionality for T&L page
• Writing Complex SQL Queries using TOAD to generate reports pertaining SGE’s Annual Leave Balances, Working Capital Fund Audit Reports, Quarterly Audit reports as per clients requirement
• Used TOAD to export result data to excel file
• Modifying SQR reports such as Time Certification report to include newly created TRC’s
• Working with Peoplesoft workgroups, paygroups, T&L Taskprofiles.
• Working on technical design documentation of new enhancement for T&L pages
• Setting up GL pay plans for LEO employees.
• Creating functional documentation for creating new TRC’s and adding them in Peoplesoft System
• Modifying customized SQR reports to calculate the difference of amount between Paymerge and Gross Pay table for biweekly pay period
• Modifying outbound SQR’s sent to DFAS (Payroll provider for EPA) for payroll processing
• Modifying inbound SQR to update TSP dates to current biweekly pay period end date.
• Writing Data Mover Scripts to import and export data from Production to Development as on when required.
• Using Quest STAT for creating archives set for migration of all tickets to Production environment
• Performing Unit Testing for testing for every issue worked on.
• Creating Unit Test Cases
• Performing Manual QAT Testing
• Attending weekly meetings to update production issues and update client about status of tickets.

Environment: Peoplesoft 8.3 (T&L), PeopleTools 8.22, Oracle 8i, TOAD, Unix, Windows 2000/XP, SQR’s, Peoplesoft Query Manager, Quest STAT 5.2

Confidential,Falls Church,VA

Programmer Analyst

• Worked on inhouse and offshore peoplesoft projects.
• Worked with users and managers to gather requirements for customizing Peoplesoft System.
• Understanding the structure of legacy system and mapping the flow with current Peoplesoft system.
• Helped in Setting up and maintaining Fundamental HRMS tables and Payroll and Payroll Interface applications.
• Modified Existing Menus, components, pages, and records to comply with the client business process
• Wrote Data Mover Scripts to import and export data from Production to Development as on when required.
• Wrote PS-Queries to export Data into MS Excel Sheets.
• Modified delivered as well as existing SQR’s for generating reports as per client specifications
• Participated in performance tuning of SQR’s programs.
• Customized People Code for pages, components, and records as per specifications
• Manually tested individual components and pages.
• Testing to ensure online functionality and data integrity before releasing new or modified applications to user.
• Testing duties involved adding, deleting, and modifying data, confirming default values and prompt lists, and directly examining application data.
• Used SQLPlus query tool to verify data on the database.
• Check permission lists, roles, and user definition.

Environment: Peoplesoft HCM 8.34(Payroll, HR Administration) Oracle8i, Windows 2000/XP and UNIX