● Managed complete payroll cycle functions for biweekly payroll● Created pre-payroll production reports to prevent payroll errors● Processed off-cycle checks for termed and manual checks● Data entries for garnishment/child support and timecard adjustments in Lawson Payroll system● Filed payroll tax deposits for Federal and State● Paid electronically child support to various states● Reconciled G/L accounts related to payroll● Provided excellent customer services to employees by phone and email● Educated employees on using API Time Keeping system● Collaborated with HR on various payroll issues● Created job aids to document payroll functions● Created various reports for management using Excel Vlookup/Pivot

• Payroll System Administrator• Ensure accurate and timely bonus/incentive processing for bi-weekly and semi-monthly payrolls• Deliver payroll accuracy processing 10,000+ timecards in payroll system• Supported interfaces between payroll and time & labor systems including resolution of system issues and upgrades• Mass record updates, imputed income recording, batch processing delivery to ensure efficient year-end processing • Supported business partners, running periodic and ad hoc reports• Participate in special projects including time & labor system implementation and payroll vendor system upgrades• Delivered data analysis using Excel and Access

• Created report specs by studying behaviors of database tables using TOAD.• Performed QA on new reports or modifications of existing reports.• Researched report issues by analyzing database tables via SQL.• Performed extensive QA on new report module by testing outputs, UI, functions, and applying common computer conventions and guided offshore Development Team for improvement of new module.• Scheduled and automated report generation process in new report module by enhancing report parameters.

Application Developer• Wrote custom reports and interfaces using FoxPro and SQL for clients and 3rd party vendors, allowing clients to electronically and accurately update system with payroll data. • Set up clients’ general ledger modules for payroll and wrote interface files for clients’ accounting system, eliminating manual entries from payroll. • Analyzed and reconciled database tables and reports for discrepancies upon clients’ requests, ensuring satisfaction and confidence in ADP. • Programmed custom payroll computations per clients’ specifications, eliminating manual calculations of certain pays such as commissions, 401k’s and overtimes. • Performed testing and QA on new application utilities and supported development team, increasing user-friendliness and accuracy of new utilities. • Consulted clients and vendors on reports and interfaces, creating ways to accommodate clients’ needs and ensuring satisfaction with flexibility offered. • Analyzed payroll system and reported bugs to development team, thus preventing company embarrassment to clients. • Wrote programs, facilitating routine data analysis.• Spearheaded solution to why Nortel’s general ledger interface files could not be balanced, writing guidelines for client to follow and ensuring correct data flow as well as receiving monetary compensation and personal acknowledgement from Senior Vice President of sales.• Contributed to department receiving numerous consecutive years well above 95% in client satisfaction surveys.

G/L and System Accountant• Administered 50-user LAN on Novell 3.12. Duties included daily backup, maintaining server space, setting user rights, administering email server and purchasing hardwares/softwares.• Managed general ledger of 30MM engineering firm. • Performed periodic account analysis and sub-ledgers such as WIP, A/R, and A/P. • Prepared monthly financial statements for board members. • Designed and maintained fixed asset inventory using MS Access in order to generate reports tailored to specific needs. • Reduced the period closing time from 2 weeks to 1 week by automating routine general ledger computations such as vacation accruals and depreciations.• Expedited reporting process using Excel macros.