Customer Service Manager
Resume:
Yoko Katayama
Alhambra, CA 91803-4351
*******@***.***
Credited in the creation of the audit documentation system for Sarbane
Oaxley for inventory department of major entertainment studio in which
never exited and passed with flying colors everytime.
Development of new system mainframe by inputting ideas, enhancements, and
adjustments.
Allowed freedom of creativity for ideas on system design and testing to
ensure users of the system to all authorized personnel upon acceptance of
system program.
WORK HISTORY
2005-2010 Financial Analyst/Office Coordinator, Sony Pictures Entertainment
$48,500.00
Prepare monthly balance sheet, cost of goods sold schedules and variance
analysis, assisting Sr. Financial Analyst/ Manager in preparing the monthly
inventory entries, prepare journal entries to record accruals, allocate
expenses and make any reclass adjustments, review title and SKU level
reconciliation and inventory adjustments, responsible for gathering data
and preparation multi-branch, multi country inventory reconciliation at the
SKU, format title and aggregate level, assist in reconciliation of physical
inventor, cycle count programs, establish cost reviews and correct SKU's
utilizing bill of materials, monitor daily average unit of cost, branch,
transfer, analyze for accuracy and correct as needed, assisting the Sr.
Financial Analyst/Manager with special requests and analysis, responsible
for all data entry in support of the financial processes, including daily
posting and correction of posting related discrepancies, maintenance on
analytical spreadsheets and schedules, etc., assist Sr. Financial
Analyst/Manager in preparing reports for management, review of bill of
materials (product makeup) report for accuracy and cost reasonability,
create report for management Physical Inventory, Book-to-Book and Cycle
Count Adjustments, create and post month-end journal entry report
destruction of physical inventory for management, keep office inventory up-
to-date.
2002-2004 Administrative Budget Assistant, USC(Educational Opportunities
Program) $46,000.00
Assists with budget preparation for grant proposals. Gather pertinent
information and assists in developing budget projections. Gathers
information on financial requirements for the department.
Processes bi-weekly and other payrolls for faculty, staff and other
personnel. Monitors payroll activity. Receives and distributes paychecks.
Interfaces with the Payroll Office to resolve problems.
Monitors expenditures for interdepartmental personnel and external vendors.
Reconciles vendor statements and pay invoices. Interfaces with purchasing,
external vendors and accounts payable to verify prices and resolve
discrepancies.
Prepares, process and reviews paperwork, e.g., department orders and check
requests, requisitions and other budget and business forms. Prepares and
processes travel advances and reimbursements for personnel. Tracks
purchases and obtains maintenance contracts.
Composes and produces business correspondence, reports and related
materials or guides the work of other staff personnel. Reviews and signs,
as authorized.
Performs administrative duties associated with scheduling and coordinating
meetings and planning events. Arranges with vendors for services, prepares
agendas, gathers and organizes supporting information, and oversees
production and distribution of related materials.
Attends functions to ensure satisfactory outcome. Records minutes and
summarizes for typing and distribution. This is done only on as needed
basis.
Oversees office operations, implements changes or enhancements to
procedures to improve productivity, efficiency and service.
Ensures confidentiality and controls access to sensitive information such
as staff personnel files.
Reconciles internal records to company's financial system ASR's (Account
Status Reports).
Researches problems and corrects errors.
Researches and gathers data for departmental reports. Conducts preliminary
analysis of data.
Recommends report content and format to display findings most effectively.
Special projects on a as needed basis.
1999-2000 Billing Analyst, oCen Communications LLC $45,000.00
Audit and reconcile wholesale carrier invoices. Vendor payment
authorizations. Resolve billing issues/discrepancies and dispute mediation.
Manage purchase/sell rate databases.
Compile, prepare, and accountable for accounting reports. Act as liaison
between billing and
corporation. Overall support of Billing Team. Accounting, billing, and
Customer Service in Telecommunications/IT industry. Ability to handle
multiple tasks. Treasury cash accountant.
Analytical and detailed oriented. Use of great interpersonal and customer
service skills.
Prepared monthly billing statements/invoices for payment. Database
maintenance and troubleshooter. Payroll. Directly supervised three
employees, training them on calling card departmental rules and
regulations. Maintained goals set by management. Oversee, monitor and
controlled the day to day transactions of the staff. Interpret, implement
and enforce company policies. Wrote company policies and procedures.
Interviewed potential candidates. Maintained accounting records. Compile,
verify, and reconcile financial data, prepare reports. Investigated and
resolve errors and discrepancies. Read and interpreted computer generated
reports.
Administrative duties when needed, booking airfare hotel, etc., prepare
CFO's expense reports, scheduling, arrange meetings, greeting vendors,
guests etc., anticipate CFO's daily office tasks.
1997-1999 Accountant/Administrative Assistant, California Power Exchange
(non-profit)
Budget Development/Procurement/Management. Contract administrator maintain
all vendor contracts by verifying the accuracy and contractual agreements
are being maintained by their invoices thereto. Assure signatures of
approvals are accurate by maintaining mutual communications with all
personnel on a daily basis. All accounting functions practiced.
Daily PeopleSoft input data entry of invoice batches. General Ledger /Trial
balance maintenance, 1099, assist in month-end, and year-end preparation.
Payroll. Responsible for leading the finance department and with close
contact with the Chief Financial Officer.
Responsible to auditors on all financial functions. Worked closely with
PeopleSoft Consultants on developing the financial software for company
from start to finish. Trained all staff personnel on procedures and
monitored work flows on a daily basis. Oversee, monitor, and control day to
day workflow of staff.
EDUCATION
University of Phoenix to pursue my degree in business information system
Devry Institute University attended
California State University, Los Angeles continuing student
COMPUTER SKILLS
JD Edwards, Business Objects, Arriba, TAAS,Oracle SQL, Synopsis Nucleus,
SQL Server, Spreadsheet Jockey, Access2000, PeopleSoft, Lotus Notes,
Windows2000, Microsoft Office2000 which includes: Word, Excel, PowerPoint,
Access, COBOL, Internet networking, Lotus, WordPerfect, Symphony, IBM PC's,
Walker, LAN, DBASE, DOS, MSDOS, Windows MS Works, Quicken, Quickbooks, and
Peachtree.
Albeit that most of my experience being in and around the financial world
reports are always generated and created every day I have and will always
take responsibility for the presentation and the accuracy of them.
Whenever I have come into a company it always surprises me when it comes to
being audited whether it be internal or external the lack of any correct
policies and procedures until I instill my vast years of knowledge and
experience and share that with them in order to get a successful complete
audit.
Although unsurprising to myself through time my honesty and trust shows
through hard work and respect is gained highly whereas appointed by
thorough and complete communication as the "go to" point to person of the
department every place that I am employed. My professional attitude and
positive mannerism always wins one hundred percent.
When you peruse my resume you will see the vast knowledge that I have when
it comes to the array of software that I have in my repertoire. I cannot
say that I am at expert level since software changes all the time. I do
know such advance skills as pivot tables, graphs etc. enough to create
reports in a corporate setting.
Contact this candidate