Location
US-CA-San Diego (will consider relocating)
Posted
Mar-30-09
RESUME DETAILS
EXPERIENCE
May '07-Present County of San Diego, Statistician San Diego, CA
• Executed Monthly Reporting - Executive Monthly Fact Sheet, Monthly Performance Report, Social Work Justified, Residential Placement Report, Project Keep, Trends Report, Referrals Pending Over 40 Days • Performed Statistical Analysis. Used linear regression to predict number of referrals for a given region in the county of San Diego. • Report Validation. Validated data to ensure quality assurance of monthly reports and AdHoc reports. • Created Survey Reporting. Generated standard surveys for intra-County of San Diego surveys. • Led projects concerning child welfare statistics. Served as project lead and consultant on over 44 different projects. • Collaborated with Statisticians and Analysts on team projects and AdHoc reporting in a highly collaborative environment. • Programmed in Visual Basic in Excel. Trained other Statisticians and Analysts on how to program in Visual Basic in an in service tutorial. • Programmed in SQL to recreate standard reports, pulling data from a large Oracle database. • Used Access extensively in generating monthly reports. Familiar with database creation, queries, macros, and reporting.
Dec '05-Present HR Block, Tax Preparer (PT Evenings) San Diego, CA
• Prepared individual income tax returns for Federal and CA state filing. • Knowledgeable on all 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.
Jan '06-May '06 Grossmont-Cuyamaca College, Statistics Instructor San Diego, CA
• 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, z-tests • Prepared labs and course exams to evaluate the knowledge of students in statistics. • Incorporated syllabus to reflect fair grading and evaluation of student progress. • Met high standards of teaching excellence at class review by course coodinator and dean of academic affairs.
May '05-May '07 San Diego, CA Contract Positions (Lennar Homes, Home Depot Supply, Leap Wireless)
Staff Accountant
• 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.
Staff Accountant
• 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. • Mass uploading of Journal Entries in Forms Runtime software using Excel. • Documented the processes of Cash reconciliations and Inter-company functions through creating written instruction manuals. • Coordinated with professionals in Marketing on budgeting issues and variance figures pertaining to Inter-Company invoices. Coordinated with Accounts Payable department. • Completed Monthly Excise Tax forms for State filing using existing Excel spreadsheets and online State filing procedures.
Project Accountant
• 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. • Analyzed and compared the accuracy of new accounting software to that of previous accounting system to implement software conversion. • Successfully communicated with all levels of administration and management at corporate headquarters. Attended and participated in monthly department meetings. • Processed and accrued for daily invoices in Oracle (monthly averages):P.O. & non P.O. $2.6 M 507 invoices; Backhaul Invoices $5.8 M 288 invoices FedEx Invoices $67 K 507 invoices; Tax $2.2 M 59 invoices
May '04-May '05 Best Western Hotels, Night Auditor San Diego, CA
• Responsible for oversight of hotel operations during weekday night shifts. Handled emergency situations and nightly delivery of goods and services. Presented myself professionally in representing the hotel. • Checked-in and checked-out guests upon arrival and departure. Informed guests of parking policies and hotel procedures. Asked about the guests' stay and invited them back for future stays. • Closed books using the CHMS computer system. Resolved computer and accounting related problems in a timely manner. Calculated occupancy ratios and percentages for day, month, and year.
May '03-May '04 A . McKibbin & Co., Accountant San Diego, CA
• Prepared actual vs. budgeted variance figures for forecasting future revenues. Interpreted results and recommended budgeting actions. • Invoiced 7,000 homeowners monthly. 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. Created records using Excel of the vendors and amounts being paid according to budgets. • Created journal entries for interest on bank accounts for prior months. 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. Made Reserve Allocations each month for 13 Associations.
2000-2002 Iowa State University, Statistics Research/Teaching Assistant Ames, IA
• Conducted research in many areas of statistics: Mixed Linear Models, Bayesian Statistics, Statistical Computing, and Markov Chain Monte Carlo Methods. • Programmed extensively in C++ and translated Fortran into C++. Simulated data sets and analyzed them using SAS and S-Plus. • Wrote 60-page technical document outlining research. Successful in presenting results to professors of Mathematics and Statistics. • Consulted with graduate students in Psychology and Sociology on multiple research projects. Instructed students on how to use SPSS software.
EDUCATION
University of California San Diego, San Diego, CA Oracle database administration, In Progress
Keller Graduate School of Management, San Diego, CA Certificate in Accounting, In Progress
Iowa State University, Ames, IA Masters of Science in Statistics, December 2002; Recipient of Industrial Scholarship (2001)
St. Olaf College, Northfield, MN Bachelor of Arts in Philosophy and Statistics, May 2000; Recipient of Bachus Scholarship
CLASSES OF RELEVANCE
Keller Graduate School of Management, San Diego, CA
Accounting and Finance, Managerial Accounting, Intermediate Accounting I, Intermediate Accounting II, Federal Taxation
Iowa State University, Ames, IA
Multivariate Methods, Statistical Models, Reliability, Biostatistics, Statistical Methods, Probability and Statistics I, Probability and Statistics II
SOFTWARE and PROGRAMMING LANGUAGES
Access, Excel, Word, PowerPoint, Business Objects, Oracle, Oracle Discoverer, SPSS, SAS, SQL, Visual Basic (Excel), C++, C, R
Certifications
Oracle 10g OCA and OCP in progress
CONTACT DETAILS
You must be logged in and have a current resume access subscription. Login or Register »