Quality Assurance Project

MATTHEW WILLIAMS

*** ******** ****** ( Rochester, MI

48307

248-***-**** (Cell) (

*******.****.********@*****.***

http://msu1l.blogspot.com/

EDUCATION

Iowa State University

Ames, IA

Master of Science, Statistics

December 2002

. Recipient of Industrial Scholarship (2001)

St. Olaf College

Northfield, MN

Bachelor of Arts, Philosophy and Statistics

May 2000

. Recipient of Bachus Scholarship (1999)

PROFESSIONAL EXPERIENCE

County of San Diego

San Diego, CA

Statistician

May 2007 - Present

. Executed Monthly Reporting, including Executive Monthly Fact Sheet,

Monthly Performance Report, Social Work Justified, Residential Placement

Report, Project Keep, Trends Report, and Referrals Pending Over 40 Days.

. Performed statistical analysis, and used linear regression to predict

number of referrals for a given region in the county of San Diego.

. Validated data to ensure quality assurance of monthly reports and ad hoc

reports.

. Created survey reporting, including the generation of standard surveys

for intra-county of San Diego surveys.

. Led projects concerning child welfare statistics, and served as project

lead and consultant on over 44 different projects.

. Collaborated with statisticians and analysts on team projects and ad hoc

reporting in a highly collaborative environment.

. Programmed in Visual Basic in Excel, and trained other statisticians and

analysts on how to program in Visual Basic.

. Programmed in SQL to recreate standard reports, pulling data from a large

Oracle database.

. Used Access extensively to generate monthly reports, and gained

familiarity with database creation, queries, macros, and reporting.

HR Block

San Diego, CA

Enrolled Agent (PT Evenings)

December 2005 - Present

. Prepared individual income tax returns, business tax returns, and estates

and trust tax returns for Federal and CA state filing.

. Acquired experience in Federal and CA state tax laws, including:

Reporting of wages, filing status, dependents, child care and dependent

care credits, child credit, adoption credit, earned income credit,

additional child credit, interest, dividends, capital gains, withholding,

estimated tax, IRAs, pensions, unemployment, all education credits,

itemized deductions, self employment, and business expenses.

Grossmont-Cuyamaca College

San Diego, CA

Statistics Instructor

January 2006 - May 2006

. Instructed undergraduate students in introductory statistical concepts

including: Univariate data, bivariate data, introduction to probability,

normal distribution, point estimation, confidence intervals, hypothesis

testing, power, ANOVA, Prediction, sample size computations, t-

distributions, t-tests, and z-tests

. Prepared labs and course exams to evaluate the knowledge of students in

statistics, and incorporated syllabus to reflect fair grading and

evaluation of student progress.

. Met high standards of teaching excellence at class review conducted by

the course coordinator and the dean of academic affairs.

Contract Positions (Lennar Homes, Home Depot Supply, Leap Wireless)

San Diego, CA Staff Accountant & Project

Accountant May 2005 -

May 2007

. Analyzed balance sheet, income statement, and statement of cash flows for

corporate entity.

. Organized and interpreted raw statistical data comparing multiple files

containing financial information for billing and for reconciliation

purposes in Excel.

. Wrote summary reports on findings and results of variance figures and

presented them to senior management.

MATTHEW WILLIAMS

154 Ferndale Street ( Rochester, MI

48307

248-***-**** (Cell) (

*******.****.********@*****.***

Page 2 of 2

PROFESSIONAL EXPERIENCE (Continued)

. Analyzed and researched daily and weekly cash account variances using

Excel and various reports from American Express, Chase Card Services,

Discover Card, and Visa/ MasterCard.

. Performed Inter-Company account function for month-end-close consisting

of exchanging all invoices between Home Depot and Home Depot Supply.

. Documented the processes of Cash reconciliations and inter-company

functions by creating written instruction manuals.

. Coordinated with professionals in marketing on budgeting issues and

variance figures pertaining to inter-company invoices, and coordinated

with the accounts payable department.

. Completed Monthly Excise Tax forms for State filing using existing Excel

spreadsheets and online State filing procedures.

. Managed Access database containing telecommunications lease information.

. Transferred data from Access into Oracle to pay $4.4 M in lease payments

(2505 inv.) each month.

. Communicated with all levels of administration and management at

corporate headquarters, and attended and participated in monthly

department meetings.

. Processed and accrued for daily invoices in Oracle (monthly averages):

P.O. & non-P.O. $2.6M 507 invoices, Backhaul invoices $5.8M 288 invoices,

FedEx invoices $67K 507 invoices, and Tax $2.2M 59 invoices.

Best Western Hotels

San Diego, CA

Night Auditor

May 2004 - May 2005

. Closed books using the CHMS computer system, resolved computer and

accounting related problems in a timely manner, and calculated occupancy

ratios and percentages for day, month, and year.

. Responsible for oversight of hotel operations during weekday night

shifts, checked-in and checked-out guests upon arrival and departure, and

handled emergency situations and nightly delivery of goods and services.

McKibbin & Co.

San Diego, CA

Accountant

May 2003 - May 2004

. Prepared actual verses budgeted variance figures for forecasting future

revenues, interpreted results, and recommended budgeting actions.

. Invoiced 7,000 homeowners monthly, and deposited incoming checks toward

homeowner accounts using Data Trust Software (approx. $350,000 each

month).

. Debited association dues each month using ACH Software database.

. Coded invoices and ran checks for 13 homeowner associations weekly, and

generated records using Excel of the vendors and amounts being paid

according to budgets.

. Created journal entries for interest on bank accounts for prior months,

and created journal entries for Reserve Allocations made each month

according to the budgets of the Associations.

. Reconciled 45 bank statements per month for operating, investing, and

money market accounts, and made Reserve Allocations each month for 13

Associations.

SOFTWARE & PROGRAMMING LANGUAGES

. Access, Excel, Word, PowerPoint, Business Objects, Oracle, Oracle

Discoverer, SPSS, SAS, SQL, Visual Basic (Excel), C++, C, R

Contact this candidate