Financial Analyst Accounting

CESAR SANCHEZ

Cell Phone # 603-***-****

Home Phone# 603-***-****

Email: ******************@*****.***

Skype Id: cesarcesar3133

PERSONAL HIGHLIGHTS

Over 10 year s of Financial Analysis experience utilizing SAP and Oracle ERP Systems.

Over 10 years using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access, and Ad-hoc reports.

Over 5 years of Hyperion Financial Management for consolidation, reporting and analysis.

Over 15 years experience with Ad-hoc Reports.

Over 5 Years experience in Budget Control and Variance Analysis

Time Management

Cash Flow Forecasting

Good People skills and self motivated

Total fluency in Spanish and Portuguese language.

Technical Skills

SAP WAVE-Athena ERP-Financials and Operations; Oracle Financial Applications; All Microsoft Office Products; HYPERION Financial Management (HFM); Crystal Reports Software; ADP Payroll Systems for Windows; Dimension/Budget Cube System; ESSBASE Add-in Financial Software System; QuickBooks, MAS90/200/500 Accounting Systems, MFG/PRO Financial Management, Sage-FAS 500 Fixed Asset Accounting, FRx Report Designer version 6.7, Business Objects; MAPICS-AS400 & MAPICS XA-Enterprise PDM; AP Self Service & Shipping Notice Management Tools; CorVu-Perfomance Management-CorBusiness Analysis/Development Environment ver. 5.1; AssureNET GL-Web-based Process Management System for General Ledger Accounts; Cognizant- Catalyst-Invoice Processing (end-user); Internal Control Toolkit (ICT) Reporting; Trintech-Cadency Record to Report (R2R) System; Sanofi-Global Material Identification (GMID) Web Master Data; Structure by C/F Data Systems; JD Edwards-Enterprise-One edition; Microsoft Dynamics-NAVISION; Jet Reports-Professional 2018 (64-bit); CMI-Fixed Assets.

Professional Experience

Faith Casler & Associates, Inc. – South Natick, MA 01760 06/18/2018 to 04/05/2019

Senior Cost Accountant – Professional services at Home Market Foods, Inc. – Norwood, MA 02062

Home Market Foods has provided premium food products demanded by American consumers.

General Responsibilities Included:

Inventory Management Control

oSetting-Up New Items in the Inventory Master Data

oSetting-Up and Analyze Bill of Materials (BOM)

oSetting-Up Routings

oRoll-Up Bill of Materials (BOMs)

oReviewing and Setting-Up Cost Standards

oAnalyzing Cost Variances

oReviewing Cycle Counts

oPurchase Price Variance (PPV) Analysis

oAnalyzing Spending Variances

Product Over-pack Report

Continuous Improvement Projects

Outside Storage forecast

CAPEX-Capitalizing expenses

Headcounts-Direct labor report

Cost Improvement/Savings Tracking Projects

Providing Finance Support to Manufacturing Operations Engineers

Providing Finance Support to the Global Technology Department (IT)

Reviewed and Analyzed HMF’s Utility Contracts

Capital Leasing Projects

Sale/Collection of Commodities including Yellow Grease

Updated Fixed Asset Logs

Ad/Hoc Reporting (Manipulating large databases)

Leading Special Projects

Financial Staffing & Consulting, LLC - North Andover, MA 01845 09/13/2017 to 04/27/2018

Senior General Ledger Accountant – Professional services at NE Finish Systems LLC; Painting Systems of NE; ALLAN Construction LLC; Specialty Services of NE all under same company umbrella Marquis Management LLC.

General Responsibilities Included:

• Bank Reconciliations of five constructions companies under the Marquis Management LLC umbrella.

Overview of the Credit Cards Bank Report Expense, and responsible of coding the five companies credit card holders (over 200 credit cards) expenses.

Overseen A/P, A/R, Payroll department activities

General Ledger Journal Entries for Bank Reconciliation adjustments.

Overseen daily ACH’s bank transaction for each company and booked to GL.

Special Projects

TalentBurst, Inc. – Staffing Solutions – Framingham, Massachusetts 08/06/2012 to 09/08/2017

Senior Cost Analyst – Professional services at Genzyme a Sanofi Company – Westborough-Massachusetts.

General Responsibilities Included:

• Supporting Framingham-Biologics - Plant Controller

Prepare and distribute monthly results to site management and for corporate consolidation within Sanofi reporting format.

At Sanofi-Genzyme one of my primary responsibilities is to review BOM’s and setting up product recipes, and setting Accounting and Costing View in SAP.

Monthly review of the material purchase variance out of the P&L Statement and continuous communication with the Procurement & Logistics Team.

Inventory Cycle Count Coordinator with all Biotech Plants

Material Purchase Order & Receipts price analysis

Liaison of Annual Standard Cost with Plant Controllers

Standard cost Roll-Up per material

Month End Closing journal entries

SOX compliance for internal and external audits.

Supporting Contract Manufacturing Operations (CMO) - Plant Controller Specialty Care External Manufacturing with the preparation of entries, reconciliations reports, and analyses required by the monthly financial closing.

CMO-Internal Control Reporting

Supporting Westborough Industrial Affairs –Finance Director of Methods & Procedures (Specialty Care Processes)

Controlling Inventory Clearing Account

Intercompany Transfer Price Control

Work Order Variance Analysis-Using Business Objects.CorVu applications

Supporting Sanofi-Genzyme Northborough Distribution Center - Plant Controller with Month End Closing, and Buyers.

Special projects supporting the site controllers.

BFS Associates, Inc. – Financial Staffing Solutions - Woburn, Massachusetts 10/14/2010 to 08/03/2012

Senior Accountant/Financial Analyst – Professional services at Aspen Technology Inc. – Burlington, Massachusetts; ITT-Flow Control –Marine Division - Gloucester, Massachusetts; Princeton Instruments – Acton, Massachusetts.

General Responsibilities Included:

International Financial Reporting Standards (IFRS) vs. US Generally Accepted Accounting Principles (GAAP)

Providing Accounting Support to the Director International Accounting & Treasury Department with Latino America Countries

Oversee and Analysis of G/L – Trial Balance Submitted by PWC Latino America

G/L-Reconciliations

Intercompany Reconciliation with Aspen Technology HQ US Sub-ledgers

Review of the Management Report – 3 Month Trend Report

Run Oracle G/L- Consolidation – Revaluation and Translation – FAS52 for Currency Exchange Changes

Review / Reconciliation of the Trial Balance Bridges submitted by PWC Latino America

Flux Finance Reports and Analyze Accounts Variances.

Hyperion Financial Management for consolidation, reporting and analysis

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Managing Data Information through Business Object Applications.

Pre-Close Activities

G/L-Payroll & Benefits booking and posting

G/L-Journal Entries received from Pricewaterhouse & Cooper (PWC) from Latino America region (Argentina, Brazil, Mexico, & Venezuela).

Oversee of the G/L Journal Entries received from PWC Latino America.

A/P Accruals and Latino America Local/Payroll Taxes.

G/L-Cash Management (Oracle Cash Management)

G/L-Intercompany

G/L-FX Transfer Pricing Calculated

Latino America Local Tax Entries based on Transfer Price

Final Trial Balance and General Ledger All Accounts

Business Analysis and Flow Charting the Cost Accounting Process at ITT-Flow Control.

Documentation Control

Month End Closing at ITT-Flow Control.

Act-1 Technical & Professional Services – Manhattan, New York 03/16/2009 to 03/26/2010

Senior Financial Analyst/ Cost Accountant – Professional services at General Electric – Energy Division – Somersworth, New Hampshire.

General Responsibilities Included:

Budget to actual variance analysis.

Margin by product line tracking and analysis

Revenue recognition

Inventory Accounting including cost and variance analysis

Run Business Objects daily backlog report, to ensure no sales go out without cost

Determine list of Uncosted Backlog of Catalog Numbers (made parts)

Monthly, quarterly and year-end corporate backlog reporting, both site and divisional.

Reviewing Financial Impact of Engineering Changes (ECO’s)

Reviewing & Cost Bill of Materials (BOM’s) & Routings (#’s of Operations) in MAPICS as required.

Comparisons of the Standard vs. Current Costs overseen for disconnections.

Leading costing process in MAPICS for new parts

Costing buy parts that have zero standard.

Roll Standard Cost for Catalog Numbers (made parts).

Compare Families Cost for reasonableness.

Providing product cost information and updates to support the supply chain and commercial teams

Entering Standard Cost into 1Stop – GE Industrial Systems (marketing & sales database) and identify differences and investigate root cause of the differences.

Review Open Pos and Receipts (receiving) for buy parts, and compare to the MAPICS database data (utilizing MS Access database queries) to determine parts bought with zero cost standards.

Credit and re-bill to correct cost on customer invoices.

Receipt accrual preparation and analysis, PPV analysis.

Process receipt corrections (quantity and cost) thru Shipping Notice Management Tools to GE AP

Review of the entire Inventory Database looking for parts that have been bought with zero cost.

Participate in Physical Inventory & Reconciliation Team.

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Provide training and guidance to staff in India

Ad-hoc projects as needed by CFO.

KForce - Professional Staffing – Burlington, Massachusetts 08/07/2006 to 12/09/2008

Senior Financial Analyst/ Cost Accountant at the following companies: Fuji MicroDisk Corp., Brooks Automation Corporation.

Worldwide Consolidations

World Financing Reports

Financial Statements analysis

Provide Accounting and Finance support to the Upper Management of the company (including Branch / Plants worldwide)

Advance Ad-hoc Inventory Reports with all standard company software.

Hyperion Financial Management for consolidation, reporting and analysis

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Special Projects

FASB 52 – Foreign Currency Translation

Generally Accepted Accounting Principles (GAAP)

Manufacturing Cost Accounting using J.D. Edwards ERP System

Perpetual Inventory Control

Standard Cost Control

GL Closing Journal Entries Month and Year End

Oracle Financials implementation group from J.D. Edwards Systems.

Part of the Command Center for the Corporation mid-year and end of the year Physical Inventory.

Sarbanes-Oxley (SOX) Compliance – Inventory Issues and PPV Key Controls.

Roll-up Standard Costs.

Work Orders completed by Manufacturing to financially close

Accountemps - Specialized Financial Staffing – Manchester, New Hampshire - 3/22 /2005 to 7/31/2006

Senior Financial /Accounting Consultant at the following companies: Shyer’s Lobster Pounds – Salem, NH, Senecal Beverage, Inc. – Merrimack, NH, NCC Business Solutions – Nashua, NH, FAMM Steel Inc., CLECO Manufacturing, National Arborist Association, NTP Software – Nashua, NH, FCI USA Inc., Investors Capital Corporation-Lynnfield-MA

General Responsibilities Included:

Budget Preparation (Providing financial information to the CEO).

CFO Special Projects and ad hoc reports

Assistance for the Company SEC Reporting

Supervisory skills (managing AP, AR, Payroll employees) performed at NTP Software

Counting Cash on Hand and generates a bank deposit for retail and wholesale sales.

Prepared and processed Accounts Receivable and Accounts Payable.

Cash and Bank reconciliation

Prepared and call employee payroll data to the payroll company.

Generate AR, AP and Payroll Journal Entries to the General Ledger.

GL Reconciliation with sub-ledgers (AR, AP, IC, PO, Sales)

Preparation and Analysis of financial statements into Accrual and Cash Basis Accounting.

Month End Closing (Period and Year End)

Hyperion Financial Management for consolidation, reporting and analysis

Corporate and Sales Taxes at Senecal Beverage, Inc.

Automation of the internal accounting control using advance MS Excel and MS Access functions and programming statements.

Cost Accounting

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Public Accounting

Venture Vehicles – Division of Turf Products Corp. – Contoocook, New Hampshire 03/2004 - 03/7/2005

Senior Financial/Accounting System Analyst:

Responsibilities Included:

Provide Accounting and finance support to the Controller of the Division.

Assisting Controller with the Annual Budgeting

Operating Cash Flow

In charge of the Golf Cars Inventory Control

In charge of the maintenance of the Inventory Control Software System (Wintrack) database.

Downloading data information from the GE-Financial Company web site database, in order to analyze and creating financial ad-hoc reports, to be use for the upper management, to make executive financial decisions.

Provide Financial and Inventory ad-hoc reports to the GE Financial Auditors for the monthly floor check.

Provide IT support to the entire Division (in house software development maintenance, set up new users, database maintenance, etc.)

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Winter, Wyman – Temporary Accounting Solutions – Waltham, Massachusetts 7/99 – 3/2004

Financial Analyst /Accounting System Analyst at Staples, Inc. – Corporate Office

Responsibilities Included:

Providing Accounting, Finance, and IT Support to the Director of the Risk Management Department for the Workers Compensation Program.

Departmental Budget

Downloading data information from the two insurance companies database RSKCo-CNA and ESIS-Insurance Services, in order to analyze and creating financial ad-hoc reports, to be use for the Director of the Department, to make executive financial decisions with the upper management of Staples.

Hyperion Financial Management for consolidation, reporting and analysis

In charge of the Workers Compensation Allocation Charge-back Program (Medical & Indemnity Claims) versus Company Budget nationwide.

In charge of the Workers Compensation Summary of Incidents by Staples Business Unit versus Budget/Challenge nationwide.

In charge of the Risk Management Department journal entry worksheets to uploaded to Oracle GL System.

In charge to prepare and distribute monthly claim listing to all Staples Business Units (Staples Superstores, Retail Distributions, and Staples Commercial & Contract) 250 to 300 claims per month.

Work with Staples Business Units to resolve all disputes dealing with prior month’s charges to P&L.

Prepare journal entries reflecting Staples Business Units approved charges.

Forward detail of the journal entry back to Staples Business Units for reconciliation purposes.

Prepare and distribute a quarterly summary of actual charges back to Staples Business Units.

Prepare reports correlating charges to budget and incurred losses and #’s of losses to Staples Business Units.

Design, Development, and Implementation of programs in MS Access in conjunction with MS Excel for Departmental Internal Control.

Design and Development of Special Projects to the Director of the Risk Management Department.

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Source Electronics Corporation – Hollis, New Hampshire 4/96 – 5/99

Financial Analyst /Accounting System Analyst – IS Department

Responsibilities Included:

Provide Accounting and finance support to the CFO

Design and Development of special projects to the CFO

Cash Reconciliation

GL Reconciliation with sub-ledgers (AR, AP, IC, PO, Sales)

Preparation and Analysis of financial statements

Budgets by Department

Operating Cash Flows

Generate Journal Entries (including generating payroll journal entry to General Ledger)

Month End Closing (Period and Year End)

Provide IT support to the entire company (in house software development maintenance, set up new users, database maintenance, etc.)

Using advance Pivot Tables, Formulas, Macros, Database Design, Queries, and Reporting in MS Excel & Access.

Education

* Almeda University – Bachelor of BA and MBA-Accounting -05/2004 - 06/2007

* Peruvian Business Institute – Lima – Peru -Associate Degree in Accounting – 12/1973

* Associated Technical Institute ATI - Woburn - Massachusetts. – Associate Degree in Computer Programming – 06/1991

* La Guardia Community College - Queens - New York – COBOL Programmer - 06/1983

* FoxPro 2.0 and FoxPro 2.5 & 2.6 for Windows Training Seminar at Tara Sheraton - Boston - Massachusetts.

* General Ledger Module for Dataworks Avante Software Burlington - Massachusetts

* PowerPlay and Impromptu Training Seminar at COGNOS – Burlington – Massachusetts.

* Arbor Essbase Software Add-in for MS Excel for Windows – Training Seminar at Staples Inc University.

* Oracle Applications ver. 11.0.300 for end users – Training Seminar at Staples Inc University.

REFERENCES

Available upon request

Contact this candidate