Mari Lewis Email and Phone Number

After many years in the Workday implementation space and exploring change management (CrossVue Consulting) I sought an opportunity to work in Workday post-production support. I was very fortunate to find a position with Collaborative Solutions as a member of the Specialized Support Squad, working closely with clients in the Education and Government sectors. Collaborative Solutions is now fully integrated with Cognizant Technology Solutions after having been acquired in June of 2020.

• Managed two payroll departments processing multi-state payroll for 300-plus and 400-plus employees.• Managed Trulia’s payroll Workday implementation (ADP was legacy system). Provided business requirements to configure payroll and assisted with absence management. Project began on 11/20/13, first Workday payroll processed on 4/10/14. Six-month project completed in four months.• Notification on 6/4/14 that Market Leader would be rolled into Trulia as of 9/1/14. Redesigned the payroll transition process to eliminate employee/employer tax impact and streamline W2 reporting. • Worked with Trulia HR and Payroll teams, Meteorix and One Source Virtual to successfully transition Market Leader’s payroll data to Trulia’s, on time and with a high level of accuracy

• Converted to ADP Workforce Now internet payroll solution from ADP PC Payroll for Windows. This reduced data entry and the need for multiple user IDs/passwords.• Back-up HRIS Administrator. Assisted with HRIS upgrade to Spectrum iVantage 5.0 including timeline, testing, building Employee Service Center (“intranet” site that was part of iVantage), manager training and rewriting reports. • Market Leader purchased two companies in 2011. Immediately responsible for all aspects of payroll for both, initially setting them up as separate companies in ADP, then consolidating them into Market Leader’s payroll. Managed Accounts Payable team through associated increase in their workload.

• Managed Payroll & Accounts Payable.• Managed credit card provider revenue-share program: increased rebate by 30% year-over year. • Received training on Spectrum iVantage HR system. Assisted with HRIS upgrade including timeline, testing, building Employee Service Center, manager training and replacement reports.• 2010, covered Billing Manager’s maternity leave: began process to automate monthly billing process; participated in weekly Business Operations Team meetings; proposed process to enable company to track revenue by real estate brokerage; worked with Data Operations Team to create custom revenue reports. Participation in these processes continued after Billing Manager returned.• At the request of the CFO, supported launch of large, new strategic partnership; worked with Director, Multiple Listing Service Relationships and Data Operations Team to create monthly reports required to track uptake results and billable services.• Created a matrix of business partnership/contract details to summarize pertinent data into an easily consumable format.• Market Leader purchased two companies in 2011: immediately responsible for all aspects of payroll for each new company. Ultimately rolled both companies into Market Leader’s payroll.• 2012, implemented ADP Workforce Now online payroll solution from ADP PC Payroll for Windows. This solution provided unification of the Payroll and Time & Attendance systems, reducing data entry and the need for separate User IDs/passwords.• Revenue: took over billing/revenue processes, reporting and revenue share calculations for Sharper Agent business line from Accountant in Denver office. Created revenue input integration process and streamlined reconciliation, making it possible to complete these processes in hours instead of days. Worked with internal auditors to bring processes to SOX compliance.

• Process payroll for 300+ employees (RIF in previous years); administered timekeeping system; employee 401K deferrals and garnishments.• Calculated monthly commissions (five plans); assisted Compensation Manager to test new scenarios; created new Excel spreadsheets for calculations; created detailed accrual vs. actual variance analyses. • Maintained GL mapping for payroll journal entries. Performed journal entries and account reconciliations.• Created monthly/quarterly reports for the finance and accounting teams.• Adhered to SOX controls and provided auditors with requested information.• Special project: assisted Manager, Financial & SEC Reporting with full audit and rewrite of company’s SOX controls and documentation.• Create payroll processing and procedures manual. • Trained HR Systems and Compensation Manager as back-up to payroll processing.• Receive training from HR Systems and Compensation Manager to back up HRIS and performance management system.

• Processed payroll for 600+ employees; administered timekeeping system; employee 401K deferrals and contributions and garnishments.• Corrected errors to GL mapping; maintained GL mapping for payroll journal entries.• Audited and corrected employee PTO accruals and corrected PTO accrual calculations at ADP.• Created monthly/quarterly reports for the finance and accounting teams• Created year-end checklist for payroll.• Participated in new-employee orientations.• Created and submitted quarterly Washington L&I reporting• Adhered to SOX controls and provided auditors with requested information.

• Processed bi-weekly, multi-state payroll for 600+ employees in four companies one of which was under a union contract.• Maintained all employee files (hard copies), new-hire to term, including I-9s, W-4s; maintained employee file number system: communicated new-hire information directly to store managers.• Initiated quarterly verification of employee Social Security numbers.• Corrected errors to GL mapping.• Assisted HR with annual performance appraisal process.• Initiated project to sort 3+ years of employee benefit paperwork that had not been filed and created new system to ensure this stayed up-to-date going forward.

• Managed team of full time and part time store bookkeepers for all locations: daily counting and balancing of cash, credit card and check receipts and recording in bookkeeping system; daily reports from the time and attendance system for management team and weekly balancing of scheduled time to actual time worked; completed e-timesheets forwarded to payroll for processing. Covered vacation/sick days etc. as needed; monthly, uploaded data from stores into accounting system for month-end close.• On team that researched a new POS system (including cash registers, back-end receiving/inventory control and pricing) and assisted with company-wide implementation; created new processes to gather necessary data for bookkeeping system.• On team that implemented a new time & attendance system (from Lawson to ADP e-Time); created a manual and cycle of responsibility at store and corporate levels to improve process flow; trained managers to use new system.• Collaborated with Store Directors on annual performance reviews of bookkeepers.• Worked with ADP to update systems to reflect union contract changes.• Back-up to Payroll Specialist; processing bi-weekly payroll for +/- 1,000 employees.• Assisted the accounting team with other month-end close tasks; invoice entry; manual check balancing.

• Worked my way up from food service through several positions to become Front End Lead of the Queen Ann location in April 2001. • As Front End Lead, managed team of +/- 25 courtesy clerks, checkers and customer service staff; team met or exceeded company standards; created weekly schedules; in charge of store when Directors were not present; successfully handled emergency and sensitive situations.