PROFESSIONAL SUMMARY:

• Result - Oriented HCM functional consultant with over 10+ Years of experience in Implementation, Upgrade, Support of Enterprise Resource Planning Applications. Experienced in Providing Solutions in PeopleSoft HCM Design, Development, Implementation, Customizations, Upgrading, Reporting and Production support Projects.
• SME Expert on PeopleSoft9.2Core HR, NA Payroll, NA Payroll integrations, Time and Labor, Absence Management, Time and Labor, Base Benefits, Benefits Administration, Security, Self Service and Dash- boarding.
• Implementedand Supported PeopleSoftHCM 9.2/9.1 for various clients. Expert in Configuring Setup tables related to Core HR, Position Management, Compensation, NA Payroll, Commitment Accounting and Budgets, Time & Labor, Benefits, Benefits Administration, Absence Management, Talent Acquisition Management/ Candidate Gateway, Performance Management, and Security.
• Expert in RequirementsGathering, Analysis, Prototyping and documenting current and new Business Processes in Implementation, Upgrade, Integrations, Business Intelligence and Data warehouse projects.
• Experienced in Fit/Gap Analysis, Keep Drop Analysis, Optimization, System/ Integration/Parallel/Performance Testing, Problem Analysis/Resolution & User Training as part of Upgrade and Support Projects
• Expert in Analysis and Review of Business, Functional Design and Technical Requirements Specification documents.
• Experience in designing exhaustivetest plans, test scripts, test casesfor multiple phases oftesting - Functional Unit testing, System integration testing (SIT), Regression testing, Coordinated User Acceptance Testing (UAT).
• Involved in setup of Payroll, Time and Labor, Benefits and Benefits Administration related tables.
• Expert in converting data from legacy system and designing inbound and outbound integrations.
• Expertise in designing validations using Application Engine programs, PeopleCode, Component Interfaces (CI), Excel to CI, Workflow, Application Packages, Application Messages, Web Services, On-line Customizations using the Application Designer and working with the Integration Broker.
• Expert in designing and developing reports in SQR, Crystal Reports, BI Publisher and PS Query. Expert in creating PL/SQL scripts used for databases and integrations.
• Expertise in writing ad-hoc queries using PS Query and Query Manager.
• Excellent in verbal, written communication skills and good team player.

TECHNICAL SKILLS:

PeopleSoft HCM: Core HR, Payroll NA, Global Payroll, Position Management, Benefits, Ben Admin, T&L, Absence Management, TBH, TAM/CG, Compensation, Performance Management, eProfile, ePay, ESS and MSS.

People Tools: App. Designer, App. Engine, App. Messaging, Activities, Business processes, Component Interfaces, Business Interlinks, PeopleCode, Upgrade Assistant, Tree Manager, Query Manger and Workflow.

PS Admin Tools: Process Scheduler, Data Mover, Security, Application Server, Tree Manager.

Reporting & OLAP: SQR 3.x/4.x/6.0, PS Query, Query Manager, Query Tree.

Database/Servers: Oracle 12cR2/11gR2/10g/9i, MS Access, DB2, MS SQL Server.

Operating System: UNIX, Windows 98/NT/2000

PROFESSIONAL EXPERIENCE:

Confidential, NY

PeopleSoftHCM Functional Consultant

• ProvidedProduction support with respect to HCM Time & Labor, Ben Admin, Tax up gradation & Yearend process as well as supporting PeopleSoft Project Costing.
• Provided project-wide troubleshooting in PeopleSoft development tools, application and tools SQL, and Oracle DBA-related challenges.
• Configured Incident, Injury and Illness Tracking using the Peoplesoft Health and Safety module.
• Resolved pending issues with Work related incidents, Medical Services Information and Employee Health Card information.
• Set up Health and Safety Incident tracking mechanism for tracking incidents.
• Assisted in processing rehabilitation, Claims and Examination data using the Peoplesoft application.
• Configuring HCM system,   Data   Conversion related activities e.g. scripts for extract and load HR   data   and validate   data   prior and after loading to People-Soft. Preparation of test cases and scripts, defect tracker and other QA documents.
• Configured the PeopleSoft Payroll system which included Earnings codes, Earnings Programs, Paygroups, Pay Calendars, and Pay Run Ids.
• Installed the software of PeopleTools 8.47 and Financials SCM 8.9, HRMS 8.9 and CRM 8.9 application on various Tiers of the PeopleSoft like database Tier, AppServer, Process Scheduler and Webserver
• Installed the Demo, Development and Production Environments for HRMS, FSCM and CRM applications
• Debugged issues related to several payroll processes which included Load Time and Labor, Pay Calculation, Pay Confirmation.
• Completed in-depth analyzes of PUM images delivered by Oracle which included identifying bug fixes as well as identifying new enhancements which have been delivered.
• Set up Time Reporting codes, Time Reporting programs, Workgroups, Rule programs in PeopleSoft Time and Labor.
• Built Templated built as well as Custom Time and Labor rules.
• Participated in walkthrough and defect report meetings periodically.
• Created Test plans and Test Cases as per the business and Technical requirements.
• Coordinated disparate technical/functional teams to create design and deliver on-time solution
• Prepare Requirement Traceability Metrics and Test documents by analyzing the Functional and Business Requirements and prepare Test plans based on it. 
• Playing major role in  Functional, Integration and Regression  testing
• Manage all verification and validation activities for all production modifications including projects, releases and changes.
• Defects are logged in  Silk Central & Implemented Software Quality Assurance (SQA) development policies, procedures and testing methodologies.

Environment: PeopleSoft HR, Payroll, Ben Admin, T& L, TAM, ESS PeopleSoft HCM 9.1, PeopleSoft HCM 9.2, People tools 8.54/8.55, People Code, 3 rd party interface processes, Web logic, Toad, Oracle 11g.

Confidential, Ft. Washington, PA

PeopleSoftHCM Functional, Business Analyst

• HR, Benefits Administration, NA Payroll, Time & Labor, TAM, ePerformance, ESS & MSS self-service Modules
• Project management & support for PeopleSoft Payroll North America which included PeopleSoft Tax updates, Testing & Year end process.
• Reputed Knowledge in creating specifications, project schedules, analyzing the upgrade process to re-customize and reapply the customizations, supervising design activities and interfacing with customers for successful completion of project.
• Preparation of scripts and   validation   SQL and generating excel file for   Data   upload into new application.
• Developed the functional Design Document based on the initial requirements and the fit-gap analysis.
• Process W-2 information and create W-2c’s for any year end adjustments Earnings, deductions & Garnishments from 2014 to 2016.
• Coordinated testing (ST, UAT) for enhancements which were implemented as part of the TAM modules.
• HR Compliance Assistance in the areas of FMLA, COBRA, HIPPA, ERISA and compliance with Benefit Plan Designs and IRS regulations
• Conducted various demonstrations of Business functionality and facilitated strategic planning and analysis for upper level management
• Balances all quarterly and year end tax reports and submit reports to ADP for processing
• Provide payroll production support based on on-call schedule.
• Conducted fit/gap analysis when working for both versions, communicated with users, gathered feedbacks and requirements on HR, Payroll & Benefits Administration modules , acted as business development liaison between customers and technical development team, identified and clarified business requirements & project risks, translated the requirements into highly detailed functional system specifications, recommended solutions, UAT Testing, conducted query and reporting
• Completed the QA test process for the following: PeopleSoft tax updates, PeopleSoft Payroll, Benefits Administration, Production Assurance, Management Hierarchy, Organizational Chart Reporting, Cobra Administration, Open Enrollment, eBenefits, and network patches
• Setup any new Locations, Earnings, Deductions, Plans, Garnishments, state min wages etc., as per client request.
• Worked extensively in Security by designing & developing Roles, Permission List & User Profile for development environment.
• Managed and organized Corporate Payroll Services department to assure timely and efficient delivery of products.
• Involved from Analysis, Build and Test Phase of the code fixes made.
• Design functional test conditions, scenarios and data with clients, specialists and other testers.
• Participates in problem solving and root cause analysis of issues the team encounters.
• Created & testing UAT scripts for PeopleSoft delivered North American Payroll, Tax Updates, Ben Admin since 2 plus years.
• Tracking the issues for the Project and alerting the Top Management for any major issues
• Experience with determining if the product met the quality standards set by the business, operations, and support groups, in order to improve application quality and make continual changes and upgrades to it. Testing and all changes coordinated in both test and production environments.
• Have built and setup template-built and custom Time and Labor rules written processes to incorporate and apply business rules, override rates and reports for reconciling reported time coming in from external sources
• Developed Time and Labor adjustments messages. It populates Time and Labor holding table to adjust override rate for an employee/assignment. The message is sent from PeopleSoft Financials to PeopleSoft HR. Used Integration Broker/application messaging for this task.

Environment: PeopleSoft HRMS/HCM 9.1 People tools 8.54, People Code, SQR, Process Scheduler, ADP interface process, Web logic, Microsoft Access Database, SQR, Toad & Oracle 9.1.0.62

Confidential, Saddle Brook, NJ

Business Analyst, Production support

• Post Production support Core HRMS, Payroll modules and day-to-day support of USA and CAN payroll. User documents prepared for Pay Check Reversals, Adjustments, etc.
• Holiday Pay, Reliability Pay process and Mail to Code functionality customized processed designed and implanted successfully for which helps the associate to pick up the check at their nearest branch.
• Designed and developed a transfer process to accommodate all types of transfers for associates at Ajilon i.e. different branches with in same database, one database to another database and between different front office systems.
• I was responsible for post implementation support activities for General Ledger, Accounts Receivable, Billing, Accounts Receivable, Project Costiing and Contracts processes
• Modified and changed the layout of Paycheck to accommodate company’s needs.
• Created new TRCs (Time Recording Codes) for recording overtime to meet company's requirements in T& L.
• Time and labor duties include setting up reporting schedules, edits, rules, time clock, configuration, customization of batch T&L processes, creating a ORACLE financials labor interfaces and writing client specific reports
• Involved in creation of Time and labor rules, Rule Programs and rounding options
• Involved in testing Time and Labor scenarios such as Time reporting, Adjustments and Time interface to external database
• Collect system requirements from business owners and document requirements following Ajilon methodology.
• Develop and Test delivered and custom Workflow.
• Setup Resume Processing & Recruit USA & CANADA
• Create Functional Specification documents for new functionality
• Create Unit and UAT Test Scripts.
• Test customizations and troubleshoot issues with technical consultants
• Involved in testing the Projects to Time and Labor processes.
• Testing cases cover coverage level change, COBRA, Surviving Spouse, New Hire, Terminations, Retirees, Promotion between Benefit Programs, data change, data correction, etc. designed and tested CIGNA Medical and Dental Billing SQR reports.
• Extensively worked with Application Designer to modify record definitions, pages, components, menus and giving access to users by using maintain security.
• Support Functional various issues in production environment.
• Responsible for performance tuning of the reports using Stored Procedures and Temp Tables.
• Product support for Payroll and Time & Labor modules
• Developed an interface program for External Ajilon TALX System and populating the Paycheck information to TALX agency.
• Fixing while payroll process for Employee Tax Data, Payroll Errors messages and Time Cards
• Play a key role in the planning and implementation of patches and upgrades.
• Handled various day-to-day Payroll issues

Environment: PeopleSoft9.0 HCM ( HR, Benefits Administration, Payroll , eRecruit, CRM, Employee Self Service, Manager Self Service and T&L ) PeopleTools 8.53, People Code, SQR, Process Scheduler, Web logic, UNIX, SQR, PeopleSoft Financials 8.4, General Ledger, Accounts Receivable, Billing, Accounts Receivable, Project Costiing and Contracts

Confidential, Schenectady, NY

Senior PeopleSoft (HR, Benefits Administration

• Involved in coordinating the Payroll, Benefits & Pension work from onsite team and estimating the work and assigning the task to the right recourse offshore, also involved in maintaining proper documentation and delivery of the task to US onsite team
• Developed/Modified different interfaces and reports using App Engine and SQR’s for Payroll, Benefits, pension, ePay, ePerformance, eProfile, eCompensation , &eBenefits.
• Setting up Benefit plans and Retirement/Pension plans as per client requirement.
• Worked in Analysis, Coding, testing (FUT, SIT) and review of various interfaces, reports and customizations.
• This included custom approval work flows for the PeopleSoft applications, eBenefits customizations, Open Enrollment processes, COBRA processing
• Resolved employees Benefit (COBRA/LEAVE) enrollment issues & plan participation issues.
• System integration testing of COBRA Qualified Event (QE) for participant and dependent Based on qualified events such as divorce, retirement, leave of absence, termination, acquisitions, rehires, return to work, lack of work, age 65 and death.
• Created System Test scripts and coordinated sample employee data for the System Test Cycle.
• Worked with Pension Post-Production functional team to transfer knowledge Created user-training materials for the Training rollout.
• Supporting Business User for System Testing.
• Reviewing and Testing the Code Delivered by Offshore Team.
• Actively involved in People soft Benefits & Pension Functional User Testing (FUT), and part of FUT developed.
• Provided alternative solutions to functional users for complex scenarios.
• Worked with Functional People for System Integration (SIT) writing SQL’s for the test scenarios to Prepare Detail Data Worksheet (DDW) for Pension Life Events.

Environment: PeopleSoft HRMS 8.9., People tools 8.51, People Code, SQR, Process Scheduler, Web logic, HP-UX 11.0, Tuxedo 6.5 and Oracle Oracle10g Enterprise Edition Release Enterprise Edition Release 9.2.0.4.0,SFTP, SQR, Toad and PL/SQL (v6.0.3.893) Developer, Rational Clear Quest & QTP.

Confidential, Virginia Beach, VA

Senior PeopleSoft Techno functional Consultant

• Strong understanding of the PeopleSoft Upgrade Methodology, PeopleTools, and PeopleSoft technical architecture, SQL, and People Tools.
• Modified code that validates the data in the interface staging area, verifying its integrity and compliance with PeopleSoft HRMS business rules.
• Compared SQR reports with the vanilla 8.8 version reports and analyzed the fit gap between those two, and modified the code.
• System integration testing of health Insurance portability and Accountability Act (HIPAA) outbound file to vendor when an employee, dependent or retiree under the age of 65 loses their medical coverage.
• Compared all the objects in version8.3 to 8.8 vanilla versions, and included them on project to be migrated to production.
• Verified the objects that need to be migrated to the new version and those that need to be dropped. All the objects are documented in an excel sheet.
• Customization is based on the TL Review and Approve Time process.
• Participated in verifying Time and Labor set up for various time collection sources
• Involved in setting up of Workforce and time reporting codes in Time & Labor.
• Provide status to Functional Team Contact on Vendor testing, Code and test software per Functional Vendor Lead feedback.
• Play a key role in the planning and implementation of patches and upgrades.
• Strong knowledge of the PeopleSoft tools including; PeopleTools, Peoplecode, SQR, HTML and Internet Architecture.
• Demonstrated problem solving skills, Strong organizational, communication and time management skills.

Environment: PeopleSoft HRMS (8.8/8.30.0.0 ), People tools (8.42.05/8.19.09 ), People Code, SQR, Crystal reports, Process Scheduler, workflow Administrator, Web logic, HP-UX 11.0, and Microsoft SQL server.

Confidential, Baltimore, MD

PeopleSoft Techno functional Consultant

• Created different Design documents for payroll & Benefits inbound & outbound interfaces As per client requirement.
• Trained PeopleSoft Benefits Administration flow for End Users.
• Creating Functional and Technical spec’s for Benefits Administration according to the client requirement and END Users requirement .
• Developed third Party Interfaces both In bounds and Out bounds for the Vendors like TROW PRICE, FIDELITY, JONJAY. Etc for 401K, Retirement Plan, Loan Repayments, Cash Balances. Etc.
• HIPPA files sent through jobs using PGP and securely transfer them using FTPS (TLS/SSL). 
• Developed New Component Interfaces for Mass Updates for new hires & Mass Updates for reorganization positions.
• Created Record definitions, Pages, Menus, Fields added to their corresponding records. Administered security by row-level security using SQL-views, query views and department security using Tree Manager.
• Responsible for the administration, tuning of PeopleSoft Time and Labor. Worked on all project phases: Project Preview, Fit/Gap Analysis, Setup and Testing of reported time and actual payable time
• Developed Custom Retroactive Process.
• Involved in both Retroactive and one-time Payroll adjustments.
• Was involved as a co-ordinate for the development team to search and fix issues at the Unit Test and the System Integration Testing Level.
• Involved in designing inbound and outbound interfaces from Tesseract, EQDB, and Oracle Financials to PeopleSoft and vice versa.
• Handled Problem iBug Request (IBR) - bug fixing, on a daily basis.
• Tested the functionality of most commonly used pages, created and added logic to the script with conditional statements, loops and arithmetic operators to create more powerful and complex test, created check points (GUI, Database, Text & Bitmap), synchronizing for timing issues
• Tested Batch Transaction Processing System in UNIX.

Environment: PeopleSoft HRMS 8.80.0.0, People tools 8.42.05, People Code, SQR, Crystal reports, Process Scheduler, workflow Administrator, Web logic, HP-UX 11.0, Tuxedo 6.5 and Oracle Oracle9i Enterprise Edition Release 9.2.0.2.0,TOAD, SQR: Through PeopleTools 8.42.05 and Quest Stat.

Confidential, St. Louis, MO

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in Implementation and customization of PeopleSoft HR, Payroll and Benefits Administration Modules.
• Designed and developed interface integrating HR and payroll modules
• Created an SQR interface from PeopleSoft HRMS to Pro Business Payroll. The program is responsible for tracking all changes in job, personal, benefit, stock, 401k, federal, state, and local tax data, for over 16,000 employees, within Confidential and sending changes to payroll system.
• Setting up COBRA Administration by activating COBRA, identifying, linking COBRA to Benefit packages, identifying COBRA eligible plans, establishing coverage codes for COBRA, defining COBRA qualified events, identifying COBRA events and COBRA administrator.
• Running the COBRA Process through the Run Control page
• Setting up of the module control tables such as benefit plan table, coverage group table, leave plan table, salary rate table, include field for employee deduction and company contributions.
• Created and modified Benefits related SQRs and Run Control panels according to functional requirements of Production.
• To identify Fits and Gaps in a Fit/Gap analysis document, which is then used to build client project plans and delineate development efforts toward successful implementation.
• Versatile in SQR and Reporting tools Crystal Reports, PS-Query.
• Project involved modification of PeopleSoft delivered multiple SQL scripts, creating custom SQR programs, modifying PeopleSoft delivered SQR code, and developing PeopleSoft projects, objects and People Code.
• Responsible for application and database tuning. Tuned SQR’s, application engine programs and COBOL programs. Responsible for setting up the process scheduler automation via, run recurrence and job definition.
• Designed and developed PeopleSoft objects like pages, components.

Environment: PeopleSoft 8.12/8.3 HRMS. PeopleTools, SQR, SQL Server 2000, Windows NT

Confidential, White Plains, NY

Sr. PeopleSoft Consultant

Responsibilities:

• Involved in PeopleSoft upgrade from 7.5 to 8.12
• Using JMAC, Developed Self Service applications for employees/managers (eBenefits, direct deposit, pay check, transfer, terminations, State, Federal W4 info, Mail Drop, Address Change, Emergency contacts, Name Change etc.)
• Supported implementation of Self/Service application for different clients.
• Provide access to complete benefits information and transactions from a single page and with a single signon.
• Involved in the project startup from product mapping, modules mapping, technical design and architecture, resource mapping, design of the project plan, hardware and software selection, scope, architecting, and designing. Involved in the day-to-day production support, user interaction and functional aspect of the upgrade.
• Developed and implemented a customized process for allowing MetLife Employees to enroll them in Medical Benefits from the Hire Date onwards. Normally the employees are eligible for COBRA benefits after one month from the date of Hire.
• Pre-integrated links connect employees directly with benefits suppliers.
• Worked on PeopleSoft Versions 8.12, which was installed on Sun Solaris Version 2.6 . Developed Number of SQLs & Stored procedures according to JCI HR, Payroll& Benefits Administration Knowledge Management and other ProAct Tech clients.
• Develop and design the PeopleSoft Version 8.12 Upgrade project map definition.
• Design and develop the Upgrade templates for PeopleSoft HRMS, for use with the Upgrade Assistant for Johnson & Johnson Control project.
• Ran Time and Labor Processes like Create Employee Schedule, Create Time, Rapid Entry, Date Validation, Rapid Time Validation, Rapid Update, Apply Rules, Edit Time, Approve Time and Update to Payroll including error reports and few custom processes.
• Extensively worked with Data Designer, Panel Designer, Menu Designer, Operator Security, Object Security, Process Scheduler, PS/Query, Crystal Reports, Import Manager, Data Mover, PeopleCode, Application Upgrade, and Application Reviewer.
• Starting from release 7.54.10 PeopleSoft delivers a JMAC toolset. JMAC is a Java written product and it is equivalent to the PeopleSoft's Message Agent APIs.
• Converted copy of production database from 7.5 to 8.12 using Upgrade Assistant. Used PeopleSoft's delivered JOB template   in Upgrade assistant
• Performed Regression Test using SQA Robot test scripts
• Conducted Volume, Integration & Regression Tests.

Environment: PeopleSoft 7.5 & 8.12, Oracle 8.04 & 8i, DB2 V5, MS SQL Server 2000, nVision, Crystal reports Windows NT, UNIX Web sphere