Michael Garcia

Miami, FL *****

786-***-****

acek9j@r.postjobfree.com

Skills

Possess strong reporting, analytical and research skills. Proficient in

Quickbooks, Excel, Word, PowerPoint, Visio, Lotus Notes, Outlook,

SalesForce, Documentum, ADP payroll system, Apple computers and payroll

process. Familiar with GAAP as well as working with SAP Business One and

Access. Fluent in English and Spanish.

Education

Florida International University, Miami, FL August 2015

Bachelor of Accounting

Florida International University, Miami, FL August 2006

Bachelor of Business Administration

Graduated Cum Laude and Golden Key Honor Society member.

Experience

Automatic Data Processing, Miami, FL 2011 - Present

ADP offers a wide range of human resource, payroll, tax and benefits

administration solutions from a single source.

Technical Analyst

. Analyze year-end, quarter-end and month-end payroll data for client and

ensure its accuracy.

. Analyze client's data in ADP payroll system containing redundant data

and/or errors and provide timely solution.

. Create ADP custom reports as well as SQL reports using ReportSmith for

clients on an ad-hoc basis.

. Support and assist with all technical problems (i.e. performance,

security, etc.) for ADP supported products.

. Perform data imports and exports of employee data, validation tables, pay

data batches and benefits information into ADP payroll module.

FPL FiberNet, Miami, FL 2009- 2011

FPL FiberNet, LLC delivers wholesale and enterprise telecommunication

services throughout most major metropolitan areas in Florida and Texas with

additional connectivity to Arkansas, Georgia, Louisiana and Oklahoma.

Sales Analyst/Accounting Assistant

. Created sales metrics in Excel utilizing v-lookups, array functions,

pivot tables, as well as charts and graphs.

. Developed KPI's to measure raw numbers and changes percentage-wise in

regards to new sales, changes in sales, lost opportunities, new

customers, etc.

. Created variance reports using Excel to look for discrepancies in

departmental budgets using data gathered from SAP.

. Assisted Accounting department by logging invoices into SAP and verified

cash close data using SAP.

. Transformed raw sales data from accounting department into user-friendly

reports using Excel and SalesForce CRM.

. Created expense reports for Lead Team utilizing SAP and verified expense

reports submitted by sales representatives.

. Worked with director of sales gathering and analyzing data in Excel for

sales forecast for given period.

. Administered SalesForce CRM and created dashboards as well as ad-hoc

reports for lead team and financial analysts.

. Created PowerPoint presentations for internal meetings focusing on sales

performance for the company.

MAG Wholesale, Hialeah, FL 2006 - 2011

Since 1976 MAG Wholesale has served as an automotive wholesale distributor

throughout Florida.

Sales Analyst

. Maintained data files of current and prospective clients as well as sales

using Quickbooks and Excel.

. Gathered and analyzed sales data in order to assist sales manager create

yearly forecasts for sales representatives.

. Created ad-hoc reports based on sales data gathered from various

departments for sales manager.

. Assisted in providing analysis of company performance by calculating

inventory turnover, current ratio and acid test ratio.

The Home Depot, Miami, FL 2002 - 2006

The Home Depot is the world's largest home improvement specialty retailer.

Sales Associate

. Maintained a 3.8 GPA in school while working full-time.

Contact this candidate