SUMMARY

• Extensive experience in Implementation, customization, Upgrade, Development, Testing and Production Support of PeopleSoft 9.2/9.1/9,0/8.9/8.8/HRMS/HCM in various modules HR, Time & Labor, ESS, MSS, ePerformance,eRecruitement Benefits and NA Confidential .
• Expertise in gathering the requirements and analyzing those requirements and evaluating on more enhancements of the product which suits the company for better performance and user convenience.
• In - Depth understanding of PeopleSoft Internet Architecture (PIA), Data models and client server applications on Windows and UNIX platforms.
• Expertise in assessing business requirements, developing queries, analyzing data, writing functional specifications, troubleshooting system defects and resolving productions issues.
• As a quality engineer have involved in full cycle of Quality Assurance for various modules and has good exposure to Software quality processes and people soft standards.
• Expertise in Databases like Oracle and SQL Server.
• Demonstrate advanced understanding of business processes, internal control risk management, IT controls and related standards.
• Excellent communications, interpersonal and organizational skills with attention to detail and clear understanding of business procedures and ability to work as an individual as well as part of a team.

TECHNICAL SKILLS

Development Tools: Application Designer (8.4x/8.1x), Application Packages, Application Engine, People Code, HTML

Administrative Tools: Security Administrator, Data Mover, Import manager, Tree Manager, Definition Security, Upgrade assistant, process scheduler and Quest Stat 5.4

Reporting Tools: SQR 6.0, PeopleSoft Query

Integration Tools: File Layout, Component interface, Integration Broker

Data Management Tools: Data Mover, Import Manager, Toad, MySQL, MS-Access, Oracle 9i & 10g, DB2, Informix 2.70

Functional Domains: People Soft HRMS (9.1/9.0/8.9/8.3 x) (Core HR, Base Benefits, Self-Service, eBenefits, eRecruitment, Time & Labor, NA Confidential and Confidential Interfaces.

PROFESSIONAL EXPERIENCE

Functional & Application Support Consultant

• Working as Confidential Lead and end to end enhancements and testing of all the Confidential and tax update requirements.
• Working on Requirements, Assignments, Test Plans and Test Summary Reports for the Confidential releases and Tax Updates testing.
• Working on applying and testing Tax changes, Patches, SQR changes and Object changes delivered and validate the delivered changes do not have an impact on the customized judiciary changes.
• Executing Biweekly and Monthly Confidential for the Tax Update Releases.
• Executing Nightly and Recurrence Jobs and validation of Jobs for Tax Update Releases.
• Working on Regression testing, Processing HR Transactions for Biweekly and Monthly employees, eService changes, Negative tests for states not affected by Tax Update and validating the Earning statements and Home page.
• Working on the HR, Benefits and Confidential Critical Off cycle Change Requests for Production move.
• Worked on Benefits FEHB Temporary Seasonal Intermittent Release and validated FEHB Eligibility Logic and calculations for FEHB Temp Seas Intermittent Judiciary Employees.
• Worked on Benefits Phased Retirement Release, and validated Phased Retirees work Part time and ensured they receive additional annuity and validated FEHB and FEGLI Deductions, Interfaces, IRR’s and Reports.
• Worked on Confidential Retro FEGLI Release, and ensured Retro requests, Retro benefit deductions are calculated correctly and ensured new functionality has not affected FEGLI & FEHB Processing.
• Worked on regular Operation & Maintenance Releases and various Production Enhancements for modules eService, Interfaces, Business Reports, ePerformance, Confidential and Interfaces.
• Worked on Confidential Affordable Care Act Release and validated ADP-ACA Confidential Extract file and Confidential, Leave and Benefits File Counts on the file.
• Worked on various Interfaces modifications FAST, RITS, CLERS, AFSD Vendor Interface, eOPF SF2810 Outbound, eOPF SF2810 Macon and OPM Interface Data feeds modifications.
• Worked on Confidential TSP Release and validated TSP1 and TSP1 Catch up forms from data using TSP Inbound file from ADP.
• Worked on Confidential FERS Federal Employment Retirement System and FRAE Further Revised Annuity functionality configuration changes for electing and enrolling employees in new OPM Retirement plans.
• Worked on Benefits FEHB Self Plus One Release and validated new coverage codes can be processed in HRMIS.
• Worked on Confidential PAMS Release and validated TAS BETC Setup, TAS Attributes and Treasury File layouts for Check, EFT and Vendor file layouts and reconciled with Confidential Summary reports.
• Worked on Confidential SF2817 release and ADP creating and transmitting SF2817 files and SF2817 Electronic transmission to OPM.
• Working on Ongoing 9.2 Upgrade Release on various modules Human Resources, Benefits, Time and Labor and Confidential .
• Created various issues in Clear Quest on 9.2 Release, Retro changes, Manual checks, FEGLI Retirement deductions calculations, Issue with HR PAR Transactions for Hires, Rehires and Concurrent Hires, Remote data entry Phased Retirement issues for 615 Phased Retirement, 616 Opt out phased retirement transactions, Remote Data Entry CHRD User access issues, Warning message issue on 713 WGI HR transactions, Confidential Error messages issue with Benefit Plan changes, Security issues.

TL Functional Consultant & Production Support

• Gathering the Requirements from Business users and creating the functional Design Documents and future process flow diagrams.
• Supported Confidential in production run biweekly and worked on errors or issues related to Confidential .
• Worked on customizations to objects delivered in Tax Updates on Confidential for North America Application.
• Prepared the documents for customizing the NA Confidential batch processes and online components.
• Worked on creating Tax Form Definitions, Tax Form print parameters and Loading Year End data records and involved in other year end setup.
• Worked on Year End Data Validations and Reconciliations and creating the W2 Federal, State and Local Files.
• Involved in creating online checks for any adjustments for earnings and deductions.
• Involved in support of Off cycle Confidential and various validations.
• Responsible for implementing Confidential tax updates, including testing and coordinating with different teams.
• Involved in various Time and Labor process Time Entry, Approve Time, Payable Status Report and the Time Administrative process and reconciliations involved between Time entry and Confidential .
• Working on adding new TRCs to Time and Labor setup tables and tested them by running the Time and Labor processes.
• Worked on Time and Labor functionality for report time, overtime, flexible schedules and Manager Approvals.
• Involved in resolving the trouble tickets and issues related to custom reports and processes.
• Created Custom Adhoc Reports and People Soft Queries based on the User requirements.
• Involved in end to end Implementation process.
• Extensively worked on Production Support by handling tickets on North American Confidential , HR, Benefits and Time and Labor modules.
• Involved in various Confidential Interfaces like GL, Batch Publish and Treasury Interface and debugging any issues and fixed them.
• Adding permission lists to the run control pages and used process scheduler to run the reports online.
• Worked on testing SQR reports for premium journal Reports in Benefits and Garnishment Reports in Confidential .
• Conducting Confidential testing sessions. Execution of Confidential process and analyzed the results to determine if those were correct in accordance with Confidential manager.
• Prepared fit gap analysis and business requirements documents and developed functional design documents.
• Involved in logging all the defects in the code in Clear Quest.
• Involved in developing the Test Strategy, planning, estimate, risk assessment, mitigation and test cases for QA Evaluations.
• Assigning task and responsibilities to members of the team, including functional and technical activities.
• Elaborating all the delivery documentation according to the methodology including Gap Analysis and Development designs.
• Monitor task progress to ensure adherence to established schedules.
• Participated in group meetings for building the testing schedules.
• Testing modules setup for inconsistencies and missing steps-Test scripts and Users Acceptance Test (UAT).
• Validating results for unit and integration testing and in the UAT sessions.
• Worked on providing the input into developing and modifying systems to meet client needs. Develops business specifications to support these modifications.
• Documented the customizations, development programs for the user reference.
• Participated in technical review meetings and inspections to verify intent of change is carried through the entire project.
• Giving power point demonstrations to the Business users to get their feedback from existed People soft and customized functionality.
• Prepared test conditions for business sign off.
• Go-live and post go-live support to operations team.

Confidential & Time and Labor Functional Consultant

• As a Techno Functional Consultant involved in Business Analysis, Functional, Technical Design and documentation of business processes for various modules HR, Benefits, Time and Labor and Confidential .
• Modified the Business processes in the upgraded system as per the requirements of users.
• Performed Fit/Gap analysis of the HRMS processes and identified the customizations that needed to be carried forward.
• Worked on Entitlements and accruals for vacations.
• Worked on Maintenance Packs and Fixes and executed compare reports between Demo database and copy of Production database to determine the customizations.
• Developed custom time and labor rules for Rounding rules, Schedule Day off and custom process for hourly employee counts for Full time and Part time and number of hours worked.
• Worked on data mapping between two systems, reports include Absence History, Employee Review Audit and Department Salaries using SQR for HR.
• Performed troubleshooting of Time Admin Process failure and analyzed exceptions, time reporter active status, effective dates, rules and time reporter data.
• Performed end to end Functional Testing including mid pay period pay group changes, validating Additional Pay, Garnishments and General Deductions.
• Worked on designing and testing Confidential interfaces to upload Balance tables and map earning and deduction codes from acquired companies into the HR systems.
• Responsible for coordinating, implementing and maintaining project test schedules, test strategies, test plans, test procedures and coordination of test execution and documentation.
• Worked on User Acceptance Testing and Post migration validations.

Confidential amp; TL Functional Consultant & Production Support

• Gathering the requirements from Business users and involved in creating the Functional and Technical Design discussions and documents.
• Understand the business processes inputs, processing, and outputs being designed and tested.
• Worked with Confidential Users in updating Pay sheets and calculating salaries for a specific pay period to perform pay in Confidential module and used pay calculations to calculate employee's gross pay and process manual checks.
• Used Data Mover to move data from development database to testing database and from testing database to production database.
• Worked on Census Customizations to objects delivered in Tax Updates and various Confidential Tickets in Confidential for North America Application.
• Worked on Confidential Interface to create and update the Confidential Information such as Employee Tax Data, Direct Deposit, Additional Pay, General Deduction and Tax Distribution and run Calculate and Confirm processes and verified the error messages.
• Customized the Confidential Interface components according to business needs.
• Prepared the documents for customizing the NA Confidential batch processes and online components.
• Involved in resolving the trouble tickets and issues related to custom reports and processes.
• Conducted multiple presentations on analysis of new requirements with possible solutions for 9.0 Confidential applications.
• Suggested and done modifications to the existing reports that are impacted by customization and newly developed reports/processes as per the Business user requests.
• Worked on Year End Setup, Tax Form Definitions, Tax Print Parameters, Loading Year End data records.
• Worked on Creating the Federal File, State File and audited the files to check if they meet SSA Requirements.
• Provided the solution to create a report to do the quick Tax Calculation process FLSA and Contractual Calculations for all the Non Exempt Employees.
• Worked on testing the Confidential Calculations for Exempt and Non Exempt Employees.
• Worked on Performance tuning and bottlenecks removal of People Soft applications.
• Involved in analysis, designs, and development, bug fixing, applying patches and testing of various applications.
• Tested different new customizations and SQR Reports based on the Client’s requirements.
• Developed Queries using PS Query and export the results with Microsoft Excel and perform further calculations and develop report.
• Involved in analysis, customization and implementation of HR, Confidential , eRecruit, Time and Labor modules using People Soft 8.8 and Oracle 9i.
• Worked with STAT tool for code migration from one environment to the other.
• Worked on developing and testing various Confidential interfaces Treasury, General Ledger.
• Performed comparison test between the demo database and the copy of production to identify, customization and analyzed the reports.
• Executed test scripts for system updates, fixes, upgrades, and enhancements for PeopleSoft v9.0 Implementation.
• Created and scheduled several PS Queries on Core HR and Confidential Data to deliver periodic reports using roles/distribution list to Business effectively.
• Designed, developed and tested PS Queries.
• Customized and Tested the SQR’s as per the requirements of the client.
• Managed People Soft access for all global users. Duties included assigning roles to end-users, creating and or modifying permission lists, attaching permission lists to roles and assigning row level security.
• Tagging the Requirements into Requisite Pro and creating and mapping the test cases in Quality center.
• Involved in end to end Quality Assurance process.

 People Soft Time and Labor & Confidential Consultant

• Involved in Analysis and documentation of business requirements and processes.
• Point of Contact for Biweekly Time and Labor and Confidential Production issues and processing of On cycle and off cycle Confidential (pay sheets, calc, confirm, unsheet, reversal/ reissue, adjustment etc) and reporting against Confidential and balance table validations.
• Worked on trouble shooting People soft Confidential Errors and processing various Quarterly and Annual reports.
• Worked on end to end Confidential functional testing garnishments, deductions, additional pay, direct deposit changes and tax overrides.
• Involved in Confidential reconcilations and perform any adjustments to employee’s timesheet .
• Involved in resolving the trouble tickets and issues related to custom reports and processes.
• Worked on modifying the People soft user security using People soft security administrator and Operation preferences and testing People code and SQR Changes.
• Worked and tested setup process for calendars, workgroups, Task groups, TRC’s, Schedules, Time reporter data.
• Verified Template based Time and Labor rules for holiday schedules, rule programs, TL Security Groups and assigned Permission Lists.