SUMMARY

• Over 8 years of experience as PeopleSoft Technical Consultant in implementation, Customization, Upgrade and Maintenance
• Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development,Testing and Deployment.
• Strong technical expertise in People Code, SQRs, XML Publisher, Component Interface, Application Engine, Application Package and Approval Work Flow Engine.
• Expertise in Application Designer, Process Scheduler, PS - Query, Tree Manager, Integration Broker, Excel to CI, Web Services.
• Experience in Customizations and Implementation of PeopleSoft - HRMS/HCM (Core HR, North America Payroll, Time and Labor, ESS, MSS, Benefits and ePerformance).
• Used the File Layout for Data Import and Export from the flat files and CSV files using Application Engine and People Code.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Development and modification of Outbound and Inbound SQR interfaces.
• Performed extensive debugging and performance tuning of various processes.
• Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Worked extensively in setting up Security Setups.
• Applied in Tax updates in PeopleSoft vanilla version and client environment.
• Extensively worked on interfaces and conversions from Legacy/third party systems to PeopleSoft using SQR
• Effective communication skills and record for coordination between different teams in the account and across different locations.
• Project delivery under stringent timelines and high pressure.
• Key strengths include Excellent analytical and problem solving skills, quick learning on the job, good communication skills, good interpersonal skills and a good team player.
• Successfully completed end-to-end PeopleSoft implementation and enhancement for different client systems.

TECHNICAL SKILLS

ERP: PeopleSoft 8.8/8.9/9.0/9.1 , People Tools 8.x, Application Designer, XML Publisher, Application Engine, Application Package, People Code, File Layout, Data Mover, Tree Manager, Mass Change, Process Scheduler, Application Messaging, Component Interface, STAT and Control-M.

Database: SQL SERVER, Oracle7.x/8.x/9.x/10g/11g

Operating System: Unix, Windows NT, Windows2007, Windows XP.

Reporting Tools: PeopleSoft Query, SQR 4.x/6.x

Programming Languages: People Code, SQL, C++

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

PeopleSoft Technical Consultant

Responsibilities:

• Developed various outbound Interfaces using SQR’s for Transmitting Employee Data to Benefits vendors.
• Developed various Inbound Interfaces using SQR’s for receiving Data and process them and insert to various PeopleSoft Tables.
• Performed system configurations for HR, Benefits, Payroll, uploaded data in HR Tables, setup and configured HR/Benefit Tables.
• Setup employee data
• Create and update pay sheets.
• Process on cycle and off cycle payrolls
• Setup and process benefit deductions, garnishments, and company table setup
• Configure Payroll integrations.
• Create customizations of Payroll, T&L, and Absence Management tables.
• Develop Payroll interfaces to GL.
• Develop and create SQRs.
• Setup integration broker.
• Change and modify code via Peoplecode in App Designer.
• Customize and develop Payroll, T&L, and Absence Management reports.
• Developed SQR reports that displayed Leave Accrual information by leave plan and employee.
• It included information such as plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date and remaining leave balances.
• Extensively worked on configuring the workflow notification by creating custom AUDIT record for all the setup tables to intimate the business users whenever there is a change on the tables.
• Perform migration between environments.
• Setup installation table for Payroll.
• Setup frequency and compensation setup
• Setup source bank accounts, earnings codes, earnings programs, pay groups, deductions, and special accumulators.
• Setup Payroll tax tables.
• Setup sources of employee data, employee HR data, and employee pay data, employee tax data, general deductions, payroll options for employees, and employee direct deposit data.
• Setup balance ids, pay calendars, pay run ids, pay sheets, pay lines, and rapid entry methods
• Configure payroll calculations
• Configure printing checks and advices, check reprinting, direct deposit transmittals, payroll and tax reports, payroll results online, and pay confirmations.
• Configure reversing of checks, manual checks, online checks, error processing, and final paycheck processing and retroactive processing.
• Setup holiday schedule, advance earnings options, yearend form transactions, and gross ups.
• Setup ePay security and workflow setup.
• Performed mass data load into tables
• Act as a liaison for divisions by providing functional and technical support for 9.0 upgrade.
• Provide project documents via vlookups, pivot tables, and other excels functions.
• Managed and developed functional custom specifications.
• Test and validated results of data and tools upgrade process.
• Test of delivered reports, delivered processes, and customizations.
• Provided functional configuration for modules. .
• Assisted users and developed training documents for each module.
• Setup user profiles, provided security changes, setup roles, permission lists, and row level security.

Environment: PeopleSoft HRMS, Benefits, Payroll), Manager Self Service, Employee Service, eBenefits, eRecruit, eCompensation, Benefits, Workflow, Career Planning, Succession Planning, Competencies, and Performance and Profile Management (eProfile and ePerformance)

Confidential, Atlanta, GA

PeopleSoft Technical Consultant

Responsibilities:

• Involved in FIT-GAP Analysis before and after applying patches between PeopleSoft 8.9 and PeopleSoft 9.1 HCM
• Involved in customizing the Upgrade scripts as per the client requirements and implementation.
• Involved in implementation of enhancements for Core HR pages and components.
• Retrofitted People Code, SQR to accommodate customizations to meet the business requirements.
• Applied fixes and patches delivered by PeopleSoft during the upgrade and tested them before applying the development database.
• Designing of Excel to CI templates as per the customer requirement for the migration of Legacy Data.
• Developed various PS Queries in order to help the client day-to-day activity.
• Customized delivered Web Time Clock to load the hours to the time sheet page for the employees whose schedule type is punch time.
• Designed and configured the Roles and Permission Lists according to the responsibilities and functions of the users.
• Redesign the Approval workflow engine for employee transfer process and also created new Application Package for user list setup.
• Developed the ePerformance multiple approval process for Performance Document and Development documents using AWE
• Worked on HTML to create the mail format and URL in AWE Generic Templates.
• Involved in the Strategic planning for the Project back up’s and also responsible for migrating projects across multiple environments using STAT Tool.
• This involved running and analyzing audit and compare reports before migrating to different environments.
• Reviewed and implemented Technical design specifications based on Functional Documents.
• Maintained Security for tree manager in HRMS.
• Added departments and companies in HRMS environment to appropriate tree node (business unit)
• Maintained effective - dated trees within HRMS to make sure appropriate departments and companies were added.
• Customized payroll company table within application designer to fit Security structure for payroll departments
• Created queries according to user requests.

Environment: PeopleSoft 9.1 HCM (ESS, MSS, NA Payroll and Time and Labor), People Tools 8.52, Application Engine, File Layout, Component Interface, People Code, SQR, PS Query.

Confidential, Charlotte NC

PeopleSoft Technical Consultant

Responsibilities:

• Designed and developed in-bound and out-bound interfaces to read and load the data from Merill Lynch and Fidelity systems using SQRs
• Interaction with the business users in gathering requirements and sign offs for functional and technical specification.
• Involved in retrofitting delivered payroll SQR’s
• Involved in fit-gap analysis, compare reports between Hewitt Confidential and HR and payroll modules.
• Retrofitted HR and Payroll based on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Wrote People Code to customize the delivered objects for HR records.
• Worked on several customs Table Audits and created Test scripts for functional test.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, Job Code, Deductions and Processes such as Paysheet creation, PayCalc, Pay confirm, Tax Tables etc.
• Involved in running semimonthly and biweekly payroll with functional team and error solving.
• Involved in sending payroll deduction information to 3rd party vendors.
• Applied ADP patches to PeopleSoft.
• Involved in adding new pay groups to all the customizations.
• Created Run control Pages, Components and Records and attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Created Unit test scripts to test the business functionality for the delivered code based on the requirements.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Developed Custom Time and Labor Reports which included Compare Reports, which were extensively used while doing the move from a Third party system to PeopleSoft Time and Labor
• Involved in development of HR/Payroll inbound and outbound interface.
• Involved in review and quality analysis of all deliverables and involved in migration of project from one instance to another instance.
• Involved in UAT support and was available on-call to support the Users and Ops team.
• Handling Critical Confidential Production support
• Involved in Resolving day-to-day production tickets and provided the analysis on time.
• Involved in solving Payroll error’s in quick turnaround time.
• Involved in clean payroll activity for previous years along with operational team.
• Creating and Scheduling Control-M Jobs.
• Involved in weekly status meeting and prepared weekly status reports.
• Created and administered CSRs (Change/Service Request) in STAT for each business processes and migrate the retrofitted objects from one PeopleSoft Instance to other using STAT.

Environment: PeopleSoft HCM 9.1, PeopleTools 8.51, PeopleSoft HR, Payroll, Time and Labor, Oracle and UNIX

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Involved in documentation of different business requirement and estimation.
• Involved in weekly status meeting and prepared weekly status reports.
• Interaction with the business users in gathering requirements and sign offs for functional and technical specification.
• Designed, developed and done end-to-end testing of additional requirements
• Written and Modified People Code for various validations as required by business processes
• Extensively used Application Engine, Component Interface and File Layouts for inbound and outbound interfaces.
• Worked with Prompt tables, Dynamic prompt tables and also worked in SQL Views and Dynamic Views to optimize the Query performance and used views as search records.
• Created new online Objects like Run Control Pages along with validations to run the SQRs and Application Engines based on requirement.
• Migrated PeopleSoft objects between environments and did upgrade and compare reports between databases for missing objects
• Migrated PeopleSoft objects between environments and did upgrade and compare reports between databases for missing objects
• Actively involved in Analysis, Specification Preparation, Coding and Testing of the application and reports.
• Created technical design, unit test plan and test case documents for the development.
• Involved in development of inbound and outbound interface.
• Involved in creating and scheduling Jobs in Control-M.
• Involved in development of critical custom process for Confidential
• Wrote people code to customized Application engine such as Mass Event 457.
• Worked on Goldmansachs customized pages such as Leave, Termination and FWA pages.
• Reviewed code changes, test data and test results for quality and made sure that quality and standards are maintained.
• Created Test Script and Test data.
• Documented defects as part of SIT and UAT.
• Involved in review and quality analysis of all deliverables and coordination with PS Admin team in migration of project from one instance to another instance.
• Maintained all the impacted objects and distribution of same across team members.
• Coordinated with the team member in completing the assigned tasks and conducted reviews for quality and standards.
• Remediation and testing of all inbound and outbound interfaces as part of upgrade.
• Involved in analysis of SQLs used in the interfaces and reports for performance tuning and coordination with performance testing team.
• Involved in supporting the Users and the Onsite team during the full UAT phase.
• Involved in status meeting, internal quality audits and project closure audits.
• Created and administered CSRs (Change/Service Request) in STAT for each business processes and migrate the retrofitted objects from one PeopleSoft Instance to other using STAT.
• Provided support for critical production issues.
• Coordination with Onshore and Offshore teams.
• Involved in Year End activities.

Environment: PeopleSoft HCM 8.8, PeopleTools 8.43, PeopleSoft HR and UNIX

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Coordination with Onshore and Offshore teams
• Involved in creating Technical design documents according to the functional specifications provided in Business Requirement Document
• Designed and developed complex in-bound and out-bound interfaces to read and load the data from Mercer and Fidelity systems using SQRs.
• Designed and developed inbound and outbound interfaces by using Application Engine such as Virtual Edge Hire and Transfer process
• Creation of objects specified in Technical Design document and changes the design as and when requires to match the client requirement.
• Worked extensively on SQR’s, Application Engines and created several inbound and outbound interfaces from scratch to meet the client’s requirements.
• Created CIs for loading data into different instances.
• Created custom application pages and records as per client business needs.
• Modified & Created records, on-line pages, and components according to the requirements using Application Designer.
• Developed and Customized People Code to control the program flow & business logic to meet the current business requirements.
• Implementing Control-M tool for Confidential to automate all interfaces and other process to monitor on a regular basis and to simplify user manual intervention
• Attending the Weekly review meetings, and Update the Client regarding the status of development
• Involved in preparing unit testing planning document and executing the test scenarios for the process developed and ensure in delivering it with 0% defect.
• Involved in System Integration Testing and validation of all HR Conversion programs and reports.
• Documented defects as part of SIT and UAT
• Documented CRs as part of enhancement
• Created Test Script and Test data.
• Reviewed code changes, test data and test results for quality and made sure that quality and standards are maintained.
• Involved in Production cut-over activities
• Extensive involved in creating and tuning Unix batch scripts to archive and automate the batch process and critical process
• Involved in applying Tax updates patches to all environments and year end activity along with operation’s and BA’s to validate.

Environment: PeopleSoft HCM 9.1, People Tools 8.51, PeopleSoft HR, Payroll, SQR, PS-Query