Data Analyst, Financial Analyst

REFERENCES ARE AVAILABLE UPON REQUEST

SATOSHI HAYATA

714-***-**** • *************@*****.***

Relocation Note : I will move to Arizona at April 20th, 2018 SPECIALTY

Data Management and Visualization • IT Support • Process Streamlining • Inventory

& Shipping Analysis • Forecasting • Cost Streamlining Solutions & Cost Modeling EDUCATION California State University Long Beach - Bachelor of Science and Mathematics RELATED

COURSES

Accounting, Applied Mathematics, Statistics, Physics SKILLS

COMPUTER SKILLS:

Intuit: Quickbooks

Oracle : People Soft

Microsoft: Excel, Access, Word

and PowerPoint

Mathworks: Matlab

FLUENT LANGUAGES:

English and Japanese

EXPERIENCE

Bandai America, Incorporated

Brand Finance Analyst/Administrator, 2014 - (Current)

Aid in the customization and implementation of a Product Life-cycle Management (PLM) system

Develop a database using Access/MySQL that enhances forecasting, order shipment, sell-in and sell-through inventory through consolidation and provide better visibility for replenishing orders

Create a centralized Product Information system that houses all product related information in one centralized location to improve data integrity and productivity

Act as the Principal Administrator of the PLM system maintaining rate tables, assigning control on all users, attend and solve users’ issues and other PLM related system issues.

Create interfaces to download data from People Soft to all defined reports requested by management

Create ad hoc reports as required by management through People Soft queries and rendering the output report using Crystal Reporting software

Track and maintain Marketing Spending report, Forecast-Inventory report and 3-month Inventory report on a monthly basis

Track and maintained weekly sales revenue

Provide support in system enhancement and process improvement initiatives Analyst/ Administrator – Supply Chain Management Department and Research and Development Department

Gather, review and analyze data and integrate data from different data sources to create a database using Access and My SQL platforms

Generate reports using Crystal Reporting software to create reports such as Cost of Goods (COG) History report, Product Development Approval report, REFERENCES ARE AVAILABLE UPON REQUEST

Financial Line Projection (TLP) and Forecasting and Inventory report

Support cost modeling and forecasting modeling scenarios and other ad hoc reports

Convert Shipping Reports into .csv file for integration into People Soft (ERP) system on a monthly basis

Sakamaki & Baumgartner Attorneys At Law.

Accounting Clerk, 2012 - 2013

Reconciled costs and payments by calculating actual total cost and amount of remittances for open and closed court cases.

Processed weekly incoming client payments for deposit.

Organized and managed all incoming client correspondences in relation to cost and payment and created an accessible system for easier workflow and information access.

Maintained accurate and well-organized bookkeeping records. Aglow Technologies, Inc.

Contract Accounting, 2011-2012, Clerk Associate, 2009-2011

Reconciled client accounts for past due amounts and developed plans with acting supervisor to resolve any issues and settle the accounts.

Flagged and communicated any invoicing or credit memo errors identified when applying remittances.

Prepared all documents and related information for government auditors.

Managed all accounts receivable financing interactions between the company and bank

Assisted the sales team by generating reports of order processes. REFERENCES ARE AVAILABLE UPON REQUEST

Contact this candidate