Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.
Transition from a Oracle PeopleSoft 9.2 HCM application to an Oracle HCM Cloud application. Perform production support for the existing PeopleSoft HCM 9.2 environment in the areas of Payroll and Benefits.
Implement Tax Updates patches, batches, retrofitting customizations that includes HCM Paycheck numbers encryption.
Prior Period adjustments recovery processes changes over 8 weeks’ notice and deduction policy, perform regression testing to see existing interfaces and processes work correctly.
Perform changes in PHSUP_TXN customized file layout process, create multiple queries and generate reports. Load Peoplesoft tables with Excel2CI templates for several configuration tables.
Resolve recruitment configuration issues with Job Opening templates and screening pages for Contract Recruiters without person Id assigned.
Complete Retrofitting and payroll End to End testing for all pay cycles implementing Patches & Tax Updates.
Develop interfaces for STD, LTD, FMLA and Absence Management interfaces files for various benefit vendors. Work on new cobra vendors with file layout similar to 834 HIPPA format.
Resolve issues with Cority interfaces queries and reports that includes Recruiting module.Worked on process changes needed for Requisition, Hiring process using Template Based Hire TBH , Manager Self Service MSS , Employee Self Service ESS.
Created proofs of concept for innovative new solutions.
Provided on-going operations and maintenance support for PeopleSoft Federal Financials 8.9 including Receivables, Purchasing, Accounts Payable, General Ledger and Commitment Control.
Performed accounting reconciliation of purchasing and vouchers for budget years, 2014 and 2015, from the initial budgeting and as it progressed from pre-encumbrance to encumbrance and finally to expenses.
Reviewed unit test scripts and executes test scripts by the deadlines.
Modified PeopleSoft delivered Accounts Payable and Receivable Cash Receipts Process to force entry of certain ChartFields.
Modified PeopleSoft Queries and Crystal Reports for various accounts payable and purchasing reports.
Involved in Design, Development, Testing, and Enhancement of PeopleSoft HCM for Core HR Workforce Administration, NA Payroll and Base Benefits\Benefits Administration modules. Conducting meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.
Preparing Function Design Documents and Technical Specs especially in areas where business background demands complex processing while communicating the complexity to end users and can adapt the processing techniques, that involves both manual and automated steps.
Worked on Several Payroll and Pension Inbound and Outbound Interfaces, especially NYCERS Interface conversion where from SAAS, had to interact with several associates with legacy system to conclude on Pension plans and percentage of contribution in General Deductions based on the eligibility and seniority.
Good Understanding on the functionality of Project Costing, Revenue projects, billing models, chargeback, Charge codes, Analysis types COM, ACT, CRV, workflow associated with client projects and the interfacing with PO, AP, BI, AR modules.
Developed several Conversion SQR and Application Engine for SAAS information on Flat files to be loaded to Staging tables and to PeopleSoft. Data extract and data massaging for transformation and loading to tables.
Well versed with major base tables on HCM major modules to be able to generate Reports for any module. Loading health benefits and dependent benefits using Component interface that’s customized to load conditional information.
Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table. Used File Layout Definition to get data from the legacy system to people soft tables.
Active role in changing the SQRs as per the change requests from the users.
Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
Handled bundles for the process of solving the issues in the enhancements.
Customized PeopleSoft TAM application for complete hiring process from Applicant in Draft status to integrating with Workforce Admin once the applicant status is hired as per business requirement.
Developed Application Engine Interfaces to automate the Custom Cobra process to automate the Cobra enrollments
Developed Application Engine\CI Interfaces to automate the Medicare Part A and B flags updates received from CMS\AETNA and update the Medicare Entitlement date for Medicare Coverage.
Developed GASB SQR Multiple Report for actives and retirees for several agencies with different requirement for Supplemental payments.
Transition\Moving employees from multiple vendors
Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables.
Involved in enhancements to customize the annualization factor in compensation pages depending upon various agencies and rounding computation, which required customization of delivered functions.
One time\Mass load of earnings, deductions, overrides, positive pay for banks, garnishments, Union dues general deductions, Pre-Tax deductions, Update Additional Pay data all issues are handled instantly through scripts or minimal object migrations.
Exceptionally generating\Void ACA forms manually through SQL scripts for any agencies who were maintained by them though Benefits billing were handled by MTA and responsible for mailing the 1095B and 1095C forms.
Developed number of Interfaces\reports using SQR\Application Engine to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
Building jobs to synch with Control-M scheduling for reading Timekeeping files those need to be processed in order, reading more than 200 files in different paths based on agencies with header and trailers to consolidate data for Time and Labor load time process.
Quality Control and Process Improvement