Project Description :Approved time off in workday and upload in ADP.Terminations and final check creation.Onetime /Bonus/Retro payment, one time deduction and COLA payment. Garnishment deductions & STD calculation and set up in employee a/c.Payroll preparation and keying the data into ADPNew Hires, Compensation Change & Inbound Transfers Report & setup.Unpaired Punch Report and correction.Futa, Suta, Federal & State Tax, SS deduction etc. setup.Registration… Show more Project Description :Approved time off in workday and upload in ADP.Terminations and final check creation.Onetime /Bonus/Retro payment, one time deduction and COLA payment. Garnishment deductions & STD calculation and set up in employee a/c.Payroll preparation and keying the data into ADPNew Hires, Compensation Change & Inbound Transfers Report & setup.Unpaired Punch Report and correction.Futa, Suta, Federal & State Tax, SS deduction etc. setup.Registration for withholding tax in different states.Signoff &Transmit payroll by ADP software.New pay period set upRun ADP Report & iReportsUpload Revised workday hours accrualComplete Recon sheetComplete Journal.Technical Area: Implement SQL Query (using DML & DDL).Retrieving data from client sever to analyze error report.Data analysis using pivot table, charts, vlookup, excel formulas etc.Analyzing process step and Job sequencing.Process optimization.Client Relationship Management:Accountable for service delivery to client, Meeting deadlines Meeting and Exceeding client expectations Building effective relationship and alliances with the clients, within dept. and other cross functions.Encouraging participation, teamwork, and establishing an open and trusting work environment.Foreseeing continuous interaction with clients to ensure that any areas of concern can be worked upon for improved service levels. Quality/Compliance: Prepared Training new hires, overseeing and maintaining high-quality, elevating customer satisfaction, while adhering to the SLAs and work processes.Devising & defining quality standards for operational areas and ensuring adherence. Show less

 Understand Database structure Implement SQL Query (using DML & DDL). Data analysis using pivot table, charts, vlookup, formulas etc. Payroll deduction & premium price analysis. Client escalation and adhoc work handling. R&D in Tools like Peopelsoft,Mainframe,Myworkbence etc. Analyzing process step and Job sequencing.- Prepare daily, weekly and monthly Payroll reports.. Prepare MI reports on a Daily, Weekly & Monthly basis. Prepare Agent… Show more  Understand Database structure Implement SQL Query (using DML & DDL). Data analysis using pivot table, charts, vlookup, formulas etc. Payroll deduction & premium price analysis. Client escalation and adhoc work handling. R&D in Tools like Peopelsoft,Mainframe,Myworkbence etc. Analyzing process step and Job sequencing.- Prepare daily, weekly and monthly Payroll reports.. Prepare MI reports on a Daily, Weekly & Monthly basis. Prepare Agent Performance & KPI Reports,MAS (mapping & sequencing), APR (Agent Per Revenue). Analysing WFM Report Show less

 Direct billing : Pre-queries analysis, Delinquency and Retroactive adjustment Weekly & Bi-Weekly Payroll Calculation. Payrate change, HR Suspense, T&L Report & Exception. Reconciliation for daily, weekly & monthly transaction.  Default Maintenance on coverage. Delinquency and retroactive adjustment on premium.  Healthcare benefit, Life insurance row setup For Employees. Verifying dependents covered under employees benefit. Vendor file & Error report… Show more  Direct billing : Pre-queries analysis, Delinquency and Retroactive adjustment Weekly & Bi-Weekly Payroll Calculation. Payrate change, HR Suspense, T&L Report & Exception. Reconciliation for daily, weekly & monthly transaction.  Default Maintenance on coverage. Delinquency and retroactive adjustment on premium.  Healthcare benefit, Life insurance row setup For Employees. Verifying dependents covered under employees benefit. Vendor file & Error report Analysis. Show less