Financial Analyst Accounting

Augustin Vielot, MBA

**** *** ***** ***** 407-***-****

Winter Park, FL 32835 *******@*****.***

results and accomplishments

Developed Labor Utilization report that placed a 5% cap on Overtime spend dollars Year over Year.

Slashed Month-end report processing by 80% by including Visual Basic Code into Year-end Forecast dashboards.

Summary

Finance & Accounting Professional with an MBA seeking to leverage over fifteen years of progressive experience in multiple finance & accounting disciplines including: financial analysis, cost analysis, staff accounting. Key Strengths include strong financial planning and reporting skills, with the ability to interpret and apply GAAP within the accounting environment. Outstanding problem solving and analytical skills. Highly computer proficient individual, committed to achieving corporate objectives and delivering quality projects under strict timelines. Fully bilingual in English and French.

Technical Skills

SAS – Business Intelligence & Analytics, SQL, R, ETL, Visual Basic (VBA), MS Excel, MS Access, MS Outlook, Hyperion (Essbase Spreadsheet), SAP, Cognos BI, Blackline, Oracle DB, Visio, Tableau, JD Edwards, Expandable, PeopleSoft, FMS, Citrix, Quick Books, 10-key calculator, and Typing (50 wpm).

Professional Experience

Temporary Consultation, Lake Mary, FL SEP2016 – Present

Senior Financial Analyst

Responsible for remediation of Prior/Current Year income statements into Vertical Account Summary presentation format. Worked with extremely large raw datasets in excel for eventual presentation into Managerial reports and for Supplemental Corporate Financial reporting. Leveraged SAP experience and data-mining skills to extract and reconcile to newer format. Re-casted financials for 2014, 2015 and 2016 and Translated Foreign Exchange rates to USD in Vertical format.

JBT Corp., ORLANDO, FL 2015-SEP 2016

Cost Accountant

Responsible for the reporting of costs incurred in Job Order Costing system. Performing monthly reconciliation and Variance Analysis of Accounts in timely manner. Developed and maintained VBA macros to assist with the evaluation of Inventory Accounts namely WIP. Maintenance of Equipment Accrual Accounts & Accurate Posting of Job Order JE’s. Adjusted Standard Costs through Cost Roll. Assisted in Excess and Obsolete candidate listing. Collaborate with Senior Managers regarding progression of Customer Orders for accurate COGS reporting and analysis.

SODEXO, INC., Altamonte Springs, FL 2007-2015

Financial Analyst

Administrator of Corporate Budget Model, enabling Finance department to produce and upload yearly budgets, in timely fashion. Responsible for the review and analysis of Profit and Loss Statements and to monitor achievement of financial goals. Assist in monthly/ quarterly/ year-end close process to ensure integrity of results at all levels of hierarchy. Highly skilled in the retrieval of high-level data through Data-Mining, for staging presentations in newly constructed Dashboards. Effectively finds ways to minimize inefficiencies by understanding models and streamline processes. Present and explain Key Results Indicators (KRI’s) to managers to provide more informed decision on past, present and forecasted results. Develop many “value-added” reports that target company initiatives. Weekly ETL processing. Remediation of Dashboards to new Chart of Accounts structure.

Created Division-first P&L forecast upload tool enabling managers’ access to Forecasted results within Essbase.

Automated month-end Unit Growth-Rate model helping save significant month-end processing time.

Temporary Consultation, Orlando, FL 2006 – 2007

Senior Accountant/ Financial Analyst

Performed a variety of functions for several companies within the Orlando area; primarily Harcourt, Walt Disney World, and most recently Siemens Power Generation. Responsible for the capture of Sales, Cost and Gross Profit amounts incurred on Percentage of Completion revenue recognition methods. Audited Payroll to validate processes within Sarbanes Oxley Compliance. Analyzed Fixed Asset policies; Reconciled Fixed Asset balances within the Project Costing and Asset Management modules. Analyzed job cost variances and performed P-Card Audits. Assisted with the compilation of budget and forecast reporting tools. Assisted members of the Finance team as needed.

Developed a Fixed Asset retirement policy.

Recommended changes to the current business process in an effort to streamline month end close.

ges exposition services, Orlando, FL 2005 - 2006

Financial Analyst - Forecasting & Reporting

Prepared month end journal entries in compliance with GAAP. Worked with the operations analysts and city team members to perform analysis on P & L results. Governed the Month End Close Package, analyzed results in comparison to Plan & Forecast. Performed Job Variance analysis. Prepared Forward Look forecasts for planned and non-planned tradeshows outside the current quarter.

Oversaw Sarbanes Oxley Section 404 compliance for all company process controls.

Darden Restaurants Inc., Orlando, FL 2002 - 2004

Fixed Asset Accountant

Interpreted and applied fixed asset policies and capitalization guidelines based on the review of invoices and construction in-process documents. Maintained fixed asset records in Oracle Mass Additions. Tracked and audited month-end exception reports for 100% accuracy. Identified errors and completed necessary adjustments, enabling users to capture variances more accurately.

Developed a more user-friendly spreadsheet to accurately convert asset’s book life to the lease-end date. Enabled the company to better accelerate depreciation, reducing taxable income to 20%.

Staff Accountant 1998 - 2002

At Solarte Inc., held a range of functions including both financial and office management responsibilities. Controlled accounting records of two retailed stores, performing day to day AP, AR duties, weekly Payroll submission, Monthly account reconciliation/analysis and Financial Statement preparation. Established a company-first forecast and reporting tool to better drive in-store sales.

Daily responsibilities for defense contractor ECC International included calculation of time/material job cost billing. Perform Job Cost Variance Analysis against Standard Costing. Produced monthly inventory analysis and reconciliation and new business reports for reporting purposes. Cycle-counting of Physical Inventory.

Coordinated the streamlining of the wholesale accounting department. Improved internal controls by modifying the credit and collection processes, resulting in an increase in working capital of ~ 20%.

Performed cost/benefit analysis of new payroll agency consideration, saving the company ~ $1200 in additional costs.

Introduced company-wide Section 125 Healthcare plan, reducing the taxable income to employees by 7.5%, along with the employer related FICA tax used to pay premiums.

Core Strengths include:

Fixed Assets & Asset Utilization

Reconciliations

Job Cost Variance Analysis & Tracking

Investment Analysis

Budget Process & Implementation

Forecasting

Business Valuation

Regression Analysis

Education

Florida Metropolitan University, Orlando, FL

Masters of Business Administration Degree, with concentration in Accounting, 2004 Cum Laude

Saint Thomas Aquinas College, Sparkill, NY

Bachelor of Science Degree, major in Accounting

Additional Relevant Experience

Member of the Accounting Professionals Association of Florida Metropolitan University

New Horizons Computer Learning Centers - Excel 2007 VBA Programming

Served with H & R Block, Pearl River, NY in Income Tax Preparation (Business & Individual)

Contact this candidate