SUMMARY:

• A highly accomplished professional with over 9+ years of experience in software analysis, design, business process reengineering, systems engineering and software development.
• Professional experience in implementing, customizing and upgrading various PeopleSoft HCM modules such as Core HR, Time & Labor, Benefits, Ben Admin, Task Group Administration, NA Payroll, MSS, ESS, Position Management.
• Project Management - Prepare Project scope, plan, and status reports, conduct meetings and coordinate between Onsite & Offshore.
• Professional consulting experience includes all phases of project initiation, planning, architecture, requirements gathering & analysis, process reengineering & mapping, functional design, development & configuration, testing, Online Pages, implementation, UAT activities & error resolution, user training and post-Go-Live support.
• Excellent Project Management experience in resource management, budget and time management, project status communication to stake holders, quality assurance and delivery management.
• Proficient in report distribution strategies, auditing principles and accounting principles.
• Demonstrated excellent Technical Leader skills on numerous projects by coordinating onsite and offshore resources, gathering requirements from the clients/customers, creating documentation, developing solutions and design, performing technical control and testing of delivered work, keeping track on project progress, leading meetings and conference calls.
• Strong documentation and written presentation skills, and developed various functional and technical specifications with Test Plans and Procedures.
• Skilled trainer, mentor and project leader; able to communicate effectively with management, business users, vendors and team; adapt at creating and maintaining project schedules delivering presentations, demos & briefing to executives and in facilitating with users and multi-faceted team meetings.
• Elicit Requirements using interview, document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, and task / workflow analysis.
• Determine how proposed business requirements will successfully meet business goals and identify potential solutions to business problems by applying technical and non-technical analysis and Provide requests for Proposal to the Team.
• Understand the flow of activities and document as-is process and to-be process by proactively communicating and collaborating with business users and deliver the applicable artifacts as needed: Functional Requirements- BRD, Use Cases, GUI, Screen and Interface designs.
• Support planning and coordinate execution of acceptance testing activities with stakeholders & end-users.
• Apply Lessons Learned to future project efforts.

TECHNICAL SKILLS:

ERP /PS Applications: HRMS/HCM 9.2/9.1/9.0/8.9 (Core HR/ NA Payroll/Time and labor/Commitment Accounting/Benefits/Benefits Admin/MSS/ESS/Position Management/Task Group Administration) People Tools 8.54/ 8.53/8.52/8.51/8.50/8.49/8.48

Programming Languages: Java Scripts, SQR, People Code, SQL, PL/SQL

People soft Tools: Application Designer, Application Engine, Query Manager, File Layout, Application Upgrade Asst/ Change Assistant, Process Scheduler, Component interface, Maintain Security, Approval Workflow Engine (AWE), Integration Broker, Web Services

Development Tools: SQL Developer, SQL Navigator, TOAD

Reporting Tools: SQR, Crystal Reports 9.x/8.x, XML Publisher, n-Vision and PS Query

Operating Systems: Windows 2000/XP/Windows 7, Unix

Database Environments: Oracle 11g/10g/9.x/ 8.x, SQL Server 2012/2008 R2/2000 and MS Access

Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, Phire, Control-M, STAT

PROFESSIONAL EXPERIENCE:

Confidential, Madison, Wisconsin

Responsibilities:

• Worked in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for Core HR, NA Payroll, Time and Labor, and Base Benefits
• Involved in implementation of PeopleSoft 9.2, gathered business requirements and collaborated to prepare functional design, developed Tech design and obtained approval from functional team.
• Application of the fixes, enhancements and support from Unit test till the production move.
• Involved in running Payroll cycles.
• Involved in providing resolutions to Payroll related issues.
• Developed/Enhanced/maintained various interfaces like HIPAA, ADP Garnishments, ADP Check Printing, UAR and numerous client specific interfaces.
• Responsible of batch issues in the existing system.
• Worked as Module Lead for Quarterly End Adjustment Payroll (Off Cycle).
• Developed PS Queries depending on the end user requirements
• Conducted training of the client systems to the users.
• Involved in Business Requirement documents and Functional design documents for the development of reports and their strategies.
• Upgrading, Support and Troubleshooting Technical & Functional issues.
• Writing and running Test cases/scripts.
• Streamlined Tax Updates and Compensation Management System projects and enhanced the scope of involvement.
• Developed interfaces to external vendors from benefits and payroll.
• Involved in various testing phases of upgrade (SIT, UAT, and parallel testing).
• Supported the parallel testing at client’s site.
• Designed and developed interface programs to validate the data coming in flat files from different health care providers and to load that data into HR and Benefits tables using Component Interfaces.
• Customized delivered Open Enrolment Confirmation Form BAS005, and developed online confirmation form to provide employees the ability to print their own Confirmation Statement.
• Worked on interface between two systems PeopleSoft Time and Labor and Live link (which is a document management system), which will create shortcuts for Group timesheet images which are submitted manually.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration.
• Mapped time reporting codes to the proper earnings code to meet payroll requirements.
• Designed and developed a process, which will update the attributes of images on Live link system, after the group timesheets from PeopleSoft are approved and Batch and reference numbers are populated for respected timesheets. Also, responsible for designing the web service, for process, which updates the Live link attributes.
• Developed Test Cases for NA Payroll utilizing functional requirements specifications and software requirement specifications document. Independently developed test scripts for On Cycle and Off Cycle basis according to specifications.
• Execution of manual test cases and reporting
• Involved in the setup of Deduction Data, Earnings Data, and Payroll Schedules in the Payroll Interface module as per the Business rules.
• Maintained security for permission lists, roles, user profiles and route controls using Security Administration, Tree Manager and Access groups.
• Involved in tracing and fixing the problems for Benefits and Job Data.
• Created and used new roles to implement security
• Involved in Payroll year-end processes.
• Designed and developed several interfaces to load data into PeopleSoft Payroll from different vendors/systems using SQR.
• Created mapping tables used by all PeopleSoft HRMS applications to map input files.
• Automatic handling of transfer of taxes and general deductions during Job Transfers on a daily basis.
• To identify the employee Job Changes like Company, department and pay group on a daily basis.
• Integrated the payroll module to synchronize changes for following:
• General Deductions for the affected employee
• Complete set of Garnishments for the affected employee
• Taxes for the effected employee
• Generate Audit and error report for end users to review the issues in automation and resolve manually where required
• Technical error report for any issues that end user cannot understand using above report and those that does not depict the real technical picture.

Environment: PeopleSoft HRMS 9.2, People Tools 8.54, Application designer, People Code, Process Scheduler, PS-Query, SQR, Application Engine, Oracle 11g,Toad, MS Excel, Crystal Reports, Unix.

Confidential, Jacksonville, Florida

Responsibilities:

• Involved in North America regional implementation of Payroll upgrade from 8.9 to 9.2 Versions
• This project involved testing various batch jobs and online components which were upgraded from 8.9 to 9.2.
• Actively involved with giving the Estimates for the development work to be done for the Tech designs prepared.
• Played role as ONC Tech Lead at Onsite in parallel testing for all North American batch programs.
• Tested around 300 batch programs and fixed 8.9 coding issues whenever required.
• Verified run control navigation and data setup for batch programs.
• Verified that the North American batch programs are functioning as desired in 9.2 environment.
• Transmitted 9.2 interface files to external Vendors and ensured it gets processed at their end without any issue.
• Year End Off-Cycle Adjustment payrolls will be run after the regular On-Cycle payrolls for that particular year were completed.
• Yearend process duration will be typically from October and February every year. Before we start the year-end process, we must ensure that the data the system uses to create the year-end reports is current and accurate.
• Manage tax years and adjust employee data.
• Review tax form definitions and footnotes.
• Audit Tax Form Definitions and Tax Form Footnotes tables.
• Review tax table setup.
• Calculate pension amounts.
• Review data sources for tax forms.
• Perform complete Off-Cycle payroll process.
• Raised various defects at database and program level and worked with Technical team for issue resolution.
• Responsible to ensure the compliance with client directive for software delivery.
• Provided technical / pre-production support for testing of Release1.
• Worked on retrofitting/reimplementation of Payroll Audit Reports and Payroll Archive processes which includes Mercer Error Report, Daily Rehires Report for Payroll Operations, Daily terms Reports, Pay Period Overtime Reports, and Employees Not Processed in Current payroll, Payroll Archive Process. Reports and processes include SQRs and Application Engines.
• Applied retrofits to all Tax/Batch Processes and Reports in Payroll, which includes Tax Location Change Report, WC Quarterly/Monthly Wages and Premium report, Labor Department Report, Tax Deposit Summery (TAX001), Local Tax Deposit summary (TAX009).
• Provided written documentation support for existing system functionality as well as future upgrade functions to maintain a baseline of customizations and standards for the modules and applications.
• Created User Manuals with screen shots for users to know flow of Business Processes for various entries.
• Involved in data validation testing using SQL queries (select, update, Joins, views statements).
• Involved in designing and developing HCM to FRS interface. This interface retrieves and processes payroll data and generates flat files. This process originally is a COBOL program.
• Managed Development team of 7+ consultants.
• ERP Process Solutions - New Development: Requirements and Planning - Client Management
• Planning and executing innovative strategies, introducing solutions meeting complex and custom requirements.
• Meeting objectives for operational and infrastructure improvement.
• Focus: application offerings to improve existing operations, align complex enhancements, identify opportunities
• Extensive experience in XML Publisher Reports
• PeopleSoft Performance Testing PeopleSoft Test Framework Automation Tool
• Created Regression Test Scripts to ensure that existing functionality has not broken due to adding new functionality
• Troubleshooting the problem areas in interfaces with Benefits programs, enrolling employees into Benefit plan.

Environment: PeopleSoft HRMS 8.9/9.2, People Tools 8.48/8.54, Application designer, People Code, Process Scheduler, PS-Query, SQR, Application Engine, Oracle 11g,Toad, MS Excel, Crystal Reports, Unix.

Confidential, Atlanta, GA

Responsibilities:

• Worked on different kinds of issues on Core HR, Time and Labor, NA Payroll in System Integration Testing.
• Liaison between the development and business teams to discuss and configure efficient solutions.
• Played key role in Data Conversion, Online Customizations using SQR’s, People Code and Application Engine for PeopleSoft HR, Benefits.
• Worked jointly with end-users to identify system inefficiencies, document technical specifications, and assist developers with technical design.
• Created SQL ad-hoc reports for performance metrics reports and initiated change management plan to achieve greater productivity.
• Involved in implementing the information systems that manage data, implement workflows and to automate business processes to maintain accuracy and timeless reporting.
• Worked on Benefits processes/reports regarding Leave Plan Enrollment, which includes process Automatic Benefit Plan Assignments, and report Employee Benefit Plan Data Audit Report.
• Created new and customized Record definitions, Pages, Components for the client specific functionality.
• Involved in the business process meetings with client along with Project management to identify the customizations.
• Seamless integration with other People Tools like Process Scheduler, PS Query and Data Mover using PeopleSoft Test Framework
• Execute multiple iterations of test data for one test script with MS Excel template for testing using PeopleSoft Test Framework Tool.
• Executed processes to analyze the quality of the data imported from the old system using business rules and analyzed the errors to perform configuration and data conversion changes to eliminate them.
• Recommend and develop reports for validation of data using the PeopleSoft query tool and SQL query.
• Test tax updates with company name 's customizations applied. Verify all processes have been successfully tested before migration to production.
• Create, maintain and update all Portal Structure &Content (Folders and Content References) providing security to the L1 users as per the client requirement.
• Part of a team to develop a custom self-service application within PeopleSoft Time and Labor, that allows candidates to enter and submit time online, print timesheets, view timesheets and timesheet history and clients to approve, print, and view timesheets.
• Experienced in working with PHIRE tool to perform version control and change management and migration.
• Fixed the issue in peoplecode when Operating Unit is getting blank on Task Profile Page.
• Fixed the people code related to Add Attachment () function in People Code when user is uploading the resumes as attachments in TAM.
• Played the key role for setting up the PS and Time and Labor security.
• Performed design, development and modifications to PeopleSoft Objects such as records, pages, components and menus. Involved in Requirements gathering, Test Analysis, Test script planning schedule, Organizing Load Test Metrics Test Report preparation.
• Worked on interface between two systems PeopleSoft Payroll and ADP Payroll which are submitted manually.
• Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.
• Worked on Benefits processes/reports regarding Leave Plan Enrollment, which includes process Automatic Benefit Plan Assignments, and report Employee Benefit Plan Data Audit Report
• Design and Developed user training materials using Oracle UPK (User Productivity Tool) tool, for different modules including Payroll.
• Integrating between PeopleSoft System and third party application
• Developed complex SQR reports and SQC’s to suit the needs of the company. Used Process Scheduler to make SQR available from within PeopleSoft.
• Involved in user training to use the new system, Preparing the user guide and job aids for end user training.
• Redesigned and implemented sqr process in MSS, which reassigns supervisors when the supervisor has terminated. Redesigned the SQR process as an Application Engine, which uses CI logic instead of Update SQLs in SQRs.
• Designed and developed Component Interfaces for Job Data components to load the data from Staging Tables to PeopleSoft Application tables

Environment: PeopleSoft HCM 9.1, People Tools 8.52, SQR, TOAD, ORACLE 10g, STAT 5.3, SQL PLUS 9.0.1.

Confidential, New York

PeopleSoft Techno Functional consultant

Responsibilities:

• Worked in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR and Base Benefits and Payroll.
• Extensively worked with designing, analysis, evaluation, testing, debugging, documentation, and upgrade of PeopleSoft HCM 8.9 to 9.0.
• Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from technical perspective.
• Created a new page in the Manger Self Service where the manger is allowed to see his employees and upon selecting an employee he/she can view the Leave Balances of that employee.
• Created new Menu and registered that in Portal and given Permissions and securities for the above page in Manager self service so that only Managers can view that page.
• Created workflow for self-service so that whenever an employee changes the address in the Personal page work list will be sent to his manager
• Involved in setup and design of automated benefits enrollment process, setting up core tables in HR and Benefits, defining eligibility rules and creating event rules
• Done the Modifications in the FSA Benefits Page.
• Worked on payroll processes issues where it can execute a bi-weekly payroll and validate paychecks for deductions and earnings
• Responsible for design and development of a process involving multiple Peoplesoft components, pages, excel data capture templates and Excel to CI templates by utilizing the PS Application Engine and Component Interface technology to process the acquired company’s HR data into Peoplesoft HCM.
• The conversion process could be used by a business analyst to process the conversion data of the acquired company without the need of IS department involvement. The whole process is reusable for future acquisitions.
• Processed newly acquired company HR data into HCM using Component Interfaces.
• Developed department load program to load new departments by HRIS users.
• Assist in PS upgrade by helping in fit-gap analysis.
• Designed and developed several interface programs to legacy systems.
• Worked on several day to day production issues covering both HR and Payroll areas.
• Worked on retrofitting Total Rewards interface in Benefits. Due to project deadline limitations, the vendor was unable to accept all the changes in benefit health plans, so I have created the Benefit plan translations table, to map the new benefit plans to old benefit plans.
• Created interface File with summary of all benefit Plans employee is currently enrolled in, to Generate Benefit Statements.
• Developed Benefits Interface for creating file with Vision Plan.
• Worked on retrofitting the interfaces in HRMS and Payroll interface, includes interfaces, Pub-Sub data repository interface, Market pay interface, World travel interface, Course Mill to PS interface etc.
• Customize the Pub-Sub interface, according to client requirements. This was one of the most important interfaces for the client, which was scheduled to run every night. This interface used to collect data from HR & payroll tables and put that on Pub-Sub repository, which is the separate DB. Data was picked up by all the vendors.
• Designing interfaces to send HR data, HR updates from HCM to Finance System.
• Working with custom check print program(s) and troubleshooting issues.
• Training the End Users and New Clients who signs on Client PS Project.
• Executing and supporting UAT and coordinating with End Users for Release sign-off.

Environment: PeopleSoft HRMS 8.9/9.0 (HR, Benefits, Payroll), People Tools 8.48/8.50, SQR, Crystal Reports, Oracle and UNIX.

Confidential, Buffalo, New York

PeopleSoft Technical Analyst

Responsibilities:

• Prioritized and estimated modifications, reports, and data conversions, conducted scope review of modifications, facilitated issue resolution with functional leads and program management and customer leads.
• Area of work includes, creating Custom interface processes using Application Engines, Worked on web services as well as Integration Broker, as part of Interface between different systems. Development of custom Reports, Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs
• Involved in preparing design and test documents for the enhancements given from Client.
• Modified existing interfaces, reports and processes. Designed and developed the Data Conversion process using SQR. Customized Payroll / T&L delivered SQR’s to meet the client’s requirements like PAY002.SQR, TL002.SQR, DDP001.SQR and PAY003.SQR.
• Involved in Design and development of Leave Accrual Process. Development of New Application Engine Process Includes, Paid Balances Adjustment Program, which will update the balances on TL COMPLEAV TBL. Developed reports for the process, Leave Balances Report, Historical Leave Report, Leave Excess report.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration. Involved in the testing of the Benefits Administration process for Open Enrollment, Snap and Event maintenance. Complete understanding of the Benefits Administration process from scheduling to enrollment
• Guided the QA team in defining test conditions & scenarios related to the upgrades and enhancements and coordinated the SIT & UAT’s along with issue resolution
• Worked on configuring & testing the core HR
• Create Test Plans, Test Scripts various HR Modules, and Benefits.

Environment: PeopleSoft HRMS 9.0, PeopleTools8.49, Crystal Reports, SQR, Toad, Query Analyzer, Application Designer, People Code, SQR, PS/Query, security/View, Process Scheduler.

Confidential

PeopleSoft Developer

Responsibilities:

• Work involved development of SQR’s and also customization using People tools based on the technical design specification given by client.
• Worked on analysis, coding, testing and review phases of work based on user requirement.
• Moving application data between two PeopleSoft databases using Data conversion.
• Co-ordination of the work with on-site development team and conducting conference calls.
• Data validations, setting default values, dynamically deriving the field values, implementing business rules etc. using People Code. Debugging the People Code using Debugger.
• Extracted data such as Personal Data, Job, Job Code, Department, Location, Pay Earnings, and other Benefits from PeopleSoft applications tables for HR. Generated reports using Query and Crystal Reports.
• Produced Excel spreadsheet report format for Payroll via n Vision reporting tool.
• Involved in the design, development and testing of all HR, Benefits.
• Involved in Data mapping between the two systems.
• Customized HR, payroll menus, enquiry pages as per the user requirement so that user can view more information.
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Involved in setup of Set ID table, Company Information, Establishments, Location, Department, Salary plan, Job Code and Pay Group tables for HRMS System.
• Generated SQR reports to create Time Load to pay sheets, master employee listing, employee pension plan data, new hires and terminations.
• Maintaining PeopleSoft user security using user profiles, roles & permission lists.

Environment: PeopleSoft HRMS 8.9, People Tools 8.48, Crystal Reports, SQR, Query Analyzer, Application Designer, People Code, SQR, PS/Query, security/View, Process Scheduler.