Interview question- 125 words
SAMIR PATEL
SUMMARY:
· Finance and Accounting Professional
· Highly detailed and accurate Accountant and CPA candidate with over 10 years of experience in the finance industry with strong knowledge of General Ledgers, Reconciliations, Process Improvements, Researching Variances, Payroll, and Audit Support.
· Thrives in data and deadline intensive environments by completing tasks accurately and ahead of schedule.
· Reconciled up to $50M in monthly revenue, including GL accounts, Cash, AR, AP, & other Asset and Liability Accounts.
· Performed collections exceeding $5 billion in revenue with a 60% recovery rate.
SKILLS:
· General Accounting Operations
· Monthly & Quarterly Sales Tax
· Tax Return Analysis
· Knowledge of Auditing Procedures
· Financial Reporting Preparation
· Employee Benefit Audits
· Data Analysis & Review
· Variance Analysis
· Fraud Prevention
· Bank Reconciliations
· Payroll Accounting
· Customer Resolution
· Technical Skills: QuickBooks, Great Plains, Yardi, Access, PeopleSoft, SQL, ITI, ACT, ADP 3.00, CounterPoint, Comerica, Hyperion, MAS 90, and Advanced MS Excel, including Formulas, Macros, Lookup, Pivot Tables, VBA, Graphs, ACL, AutoAudit, SAP, SAGE/MIP/ABILA
EDUCATION:
· University of California, Irvine 2004 Bachelor of Science in Mathematics
Relevant Coursework: Financial Accounting | Managerial Accounting (completed)
· Foothill College Continuing Education Los Altos Hills 2009 – 2015
· Certificate in Financial Accounting (Spring 2014) | Certificate in Payroll Accounting (Fall 2013) | CPA Examination Preparation Certificate of Achievement (Fall 2015)
EXPERIENCE
GOODWILL OF SILICON VALLEY, San Jose, CA
2/2016 to 10/2016
Finance Department (Agency-Expandability)
· Reconciled 17 stores daily using Vantiv and Excel.
· Assisted with the annual audit by finding audit sampling documents and by auditing stores to ensure accurate credit card transactions.
· Audited store procedures to ensure accurate policies were followed. Audited daily transactions where there was a cash discrepancy greater than $20.
· Audited 6 petty cash funds on a monthly basis. Provided on the job training to two coworkers related to using pivot tables, understanding reconciliation processes, journal entries, and store sales audit policies and procedures.
· Performed 10-20 collections and chargeback calls a day resulting in __ revenue a month.
· Investigated fraudulent accounts retrieving $2-3K in revenue for 19 stores.
· Provided on the job training to two coworkers teaching pivot tables, understanding of reconciliation processes, journal entries, and store sales audit policies and procedures leading to greater efficiency and completing projects well under deadline.
· Posted month-end and daily closing journal entries into Great Plains for sales of 17 stores accounting for over $3 million a month.
· Observed inventory counts procedures on a monthly basis utilizing Microsoft Excel tools including v-look ups, if statements, and formulas to improve accuracy.
Healthsouk.com, Mountain View, CA
8/2013 – 7/2014
Financial Analyst
· Analyzed financial data to build financial forecasts used for headcount, procurement, and expansion purposes.
· Managed general ledger activities for A/P, bank transactions, payroll, billing, and accruals.
· Prepared financial reports and forecasts used by senior executives to secure additional funding.
· Conducted financial closings by preparing journal entries, account reconciliations, and financial analysis.
PERALTA COMMUNITY COLLEGE, Oakland, CA
7/2012 to 1/2013
District Accounting Technician
· Matched, batch, and coded 40 invoices per week into PeopleSoft. Performed check runs for up to 100 invoices a week. Worked with internal auditors on process flow activity to prepare for annual college budget. Prepared and analyzed monthly reconciliations and researched joining values for District Office reporting.
· Applied extensive use of data analysis skills in evaluating Office of Management Funds to ensure $14M was distributed to colleges throughout the East Bay (Laney, Berkeley City, Merritt, and College of Alameda).
· Demonstrated initiative and keen attention to detail in analyzing and sorting 6 funds and $17M in monthly transactions.
GREATER OPPORTUNITIES, Santa Clara, CA
1/2011 to 5/2011
Accounting Assistant (Temporary)
· Reconciled payments consisting of dental payments, day program, and activities. Researched variances related to profit and loss by examining journal entries and financial statements exceeding $2M.
· Results:
· Performed collections calls that exceeded $800K in monthly revenue methodically and thoroughly, resulting in an 80% recovery rate.
· Detected $2M in variances by thoroughly investigating books and subsequently organizing them with precision and accuracy.
· Completed bank reconciliations 3x faster by automating processes using pivot tables.
· Demonstrated team player attitude by serving as a backup for accounts receivable.
· Delegated work load among team members based on their strengths and weaknesses to break down projects piece by piece to ensure deadline expectations were met and exceeded.
· Resolved customer questions, disputes, and complaints by phone ensuring customer satisfaction.
ATMAS CONSULTING, Palo Alto, CA
6/2007 -3/ 2009
Accounting Analyst
· Prepared audit schedules for management and external auditors. Researched variances for external auditors and management to assess comparison of actual vs. budgeted expenses.
· Reconciled $20M in monthly revenue, which included GL accounts, Cash, AR, AP, and other Asset and Liability Accounts.
· Tracked incoming payments for $5M in outstanding receivables.
· Distributed W-2’s for 1,000+ employees annually and maintained payroll files for 6,000+ employees.
· Reconciled bank statements three times faster than previous employees while adapting to changing priorities during annual audit.
WEST LA MUSIC, Santa Monica, CA
1/2007-3/2007
Staff Accountant (Independent Contractor)
· Supported three external auditors by finding audit sampling documents. Resolved discrepancies between Counterpoint, Comerica, and MAS 90 for management.
· Independently deduced pattern to reconcile cash bank statements and completed task three times faster than past employees.
· Prepared bank account reconciliation for $10M in monthly revenue.
· Improved accuracy by breaking down projects into smaller segments.
Alliance Bank, Culver City, CA
10/2006-11/2006
Staff Accountant (temporary position)
· Posted daily closing and month-end journal entries to GL of entries exceeding $50M in daily revenue.
Marketwire, El Segundo, CA
3/2006-5/2006
Junior Staff Accountant (temporary positon)
· Reconciled bank statements of $30M in weekly revenue.
· Maintained neat and orderly files for 300 vendors and 150 invoices per week using Great Plains. Performed coding on 100 accounts payable invoices a week using ITI.
· Maintained and updated bank’s financial statements.
· Performed collection calls involving $150M in receivables and successfully recovered 70% via payment plans or collection in full.
· Improved inventory process by switching to online retailer saving 20-25% in weekly delivery costs while saving company time.
Aramark, Mountain View, CA
5/ 2005-11/2005
Accounting Assistant
· Made collection calls of $100K in store revenue to vendors with a 90% success rate