Summary of Qualifications:

• Over 8 years of experience as a payroll analyst running and supervising payroll process for small/midsize/large companies
• Extensive knowledge and proven experience in Payroll day by day processes
• Extensive experience in the full HR/Payroll Systems implementations and maintenance: organization structure, earnings and deductions element, benefits, tax adjustments
• Customer service oriented professional with excellent communication skills and deep understanding of the payroll data confidentiality and sensitivity

Oracle HR, Oracle Payroll, Oracle Time & Labor, Oracle Financials, Lawson HR, Lawson Payroll, ADP, Ceridian Tax Filing System, MS Excel, MS Word, MS Access, MS PowerPoint

Professional Experience:

Confidential September, 2009 - Present
Payroll Analyst (Consultant)

• Set up payroll deductions, earnings, and benefits enrollments, payroll general ledger
• Build company organizational structures ( locations, positions, levels, etc)
• Enter/import employees demographic and payroll data into the Estratex system
• Process payrolls and run reports to validate accurate calculations in the new system vs old system
• Reconciled general ledger accounts for compensation activities
• Write requirements documentation
• Prepare the training material for the new clients

Confidential May, 2009 – August, 2009
Payroll Analyst/ Consultant

• Set up Oracle Payroll module - created new earning and deduction elements
• Set up Oracle Time and Labor module- created shifts, shift differential policies, and premiums
• Entered/imported employees time entry and payroll data into the system
• Processed payrolls and run reports to compare payroll calculations in Oracle system vs Lawson
• Prepared business requirements for implementing Oracle Time and Labor module
• Trained users on the future Oracle Payroll and Oracle Time and Labor modules

Confidential November, 2007 – August, 2008
Payroll Consultant

• Served as contact between IT department and Oracle ERP users
• Conducted interviews and product analysis to gather user requirements via workshops, questionnaires, site visits
• Analyzed and verified requirements for completeness, consistency, comprehensibility, feasibility
• Mapped and prioritized conceptual users requirements into functional requirements (changes, enhancements, and modifications) through written documentation to project team
• Managed and tracked status of requirements throughout the project lifecycle; enforced and redefined as required by project time line
• Wrote tests scenarios and assisted with quality assurance / testing of products and solutions
• Prepared documentation for setups and training manuals
• Facilitated new implemented Oracle E-Business system’s functionality to users through training sessions and demos
• Designed and managed integration process of 3rd party data to the system
• Ran setups and provided functional insights on various ways of system’s settings
• Resolved data issues (retrieved/changed data stored in Oracle DB using SQL queries)
• Designed and prepared custom reports upon users requests

Confidential May, 2007- November, 2007
Payroll System Analyst

• Wrote tests scenarios and tested Oracle payroll process for over 18,000 employees (union/non-union)
• Facilitated new implemented Oracle Financial and HR Payroll application functionality to users
• Acted as contact between Finance department, respective application functional teams and ESS technical team
• Managed activities in support of analysis, design, configuration, conversion, deployment and postproduction support
• Responsible for all of Oracle system schedule maintenance updates (family packs, year-end, etc.)
• Resolved data issues (retrieved/changed data stored in Oracle DB using SQL queries)
• Designed and prepared custom reports upon users requests

Confidential September, 2006- April, 2007 
Payroll Consultant

• Team member of a group of Oracle consultants who developed the full lifecycle Oracle implementation for HR, Payroll, at the City of Detroit
• Created multiple recurring and non-recurring payroll elements for the City of Detroit employees
• Ran multiple payrolls, under differenttest scenarios, toverify all payroll-relatedelementsand deductions had been calculated accurately
• Provided detailed functional specifications for Payroll FastFormulas for calculating multiple Earnings and Deductions
• Applied, processed, and tested year-end mandatory patches from Oracle
• Validated data conversions from legacy systems to Oracle
• Updated Oracle Payroll Setup documentation.

ConfidentialJune, 2001 – September, 2006
Payroll Analyst

• Payroll team member for the full lifecycle implementation of Oracle HRMS that implemented Oracle HR, Payroll, Employee and Manager Self-Service, and OTL at the Chicago HQ and field offices in Washington, DC and San Francisco, CA.
• On-going responsibilities included:
• Running payroll for entire company on bi-weekly basis
• Adding and creating new elements
• Updating taxrates
• Creating and running various reports
• Administrating the Oracle Time and Labor system
• Setting up new employee time entry details
• Verifying timecard entries
• Creating system accounts, and assigning them responsibilities
• Producing paychecks and transfers using NACHA (direct deposits)
• Responsible for balancing and recording payroll.
• Coordinated the transmission of contributions between company payroll and benefit plan providers and performing quarterly reconciliations.
• Researched tax and regulatory requirements to ensure financial systems and procedures are up-to-date and in compliance.
• Monitored and reconciled general ledger accounts for compensation and investment activities.
• Processed journal entries and reconciled financial system entries.
• Performed detailed ad-hoc analysis and prepared supporting presentations as required.
• Provided reports and analysis concerning Association 401k withholdings.
• Balance Federal, State and Unemployment Taxes bi-weekly basis using the Ceridian/Oracle Tax Filing interface.
• Year End responsibilities included:
• Applying, processing, and testing year-end mandatory patches from Oracle
• Performing employeebalance and tax adjustments for year-end
• Performing both quarterly updates and year-end updates for various states

Education: Confidential University 
BS in Accounting