Ngoc-Ngan (Tyra) Thai
Milpitas,CA
Summary
Multiple years of accounting experience with full cycle from A/P, A/R, Month-close, Year-close, assisting with year-end audit. Two years working with non-profit organization as Program Financial Analyst with variety of tasks and responsibilities from Budgeting, Forecasting and Re-forecasting Budgeting, Budget Modifications Supporting, Grants, Contracts Services and Program Management, Assisting Program Teams on Financial Budget, Planning, Activities and Reports
Overview
16
16
years of professional experience
Work History
Program Financial Analyst
Catholic Charities of Santa Clara County
09.2021 - Current
- Perform annual/seasonal budgets and billings to submit to funders and government entities including First 5, Franklin-McKinley School District, San Jose Unified School District, Alpha Public School, City of San Jose, County of Santa Clara County, California Department of Education, Foundations, Business Donation, and Private Donation.
- Perform Budget Forecasting at beginning of Fiscal year and Re-forecasting midyear for 70+ programs.
- Prepare and submit Budget Modification/Revision request as needed.
- Conduct Analysis for Salary and Benefits, Program Expenses, General Ledgers, Profit and Loss, A/R for Outstanding/Aging.
- Perform Ad hoc Analysis and Reports per requests
- Develop financial models to assess and monitor programs ' performance against budgets, Actual Expenses against Budgets
- Review, analyze and approve programs' spending in accordance with budget line items in compliance with contract terms.
- Prepare journals entries and assure general ledger accuracy for recording Admin Overhead Rate and Revenues for Billing purposes and Account Receivables, and follow-up with outstanding/aging receivables.
- Release Temporarily Restricted Net Assets for Donation Funds
- Closely working and in collaboration with Compliance, Development, Grants and Contracts, H/R, Payroll, A/P, A/R, Program teams departments and funders.
- Assist with Month-end and Year-end Closing, Auditing.
- Assist with Monthly Recurring Revenue and Financial Reports: presenting, explaining variances and key issues.
Accounting and Sales Specialist
Discovery Furniture LLC
09.2020 - 09.2021
- General accounting activities, including customer service, cash accounting, monitoring inventory, and processing payroll.
- Complete and maintain accounting journals, ledgers, and other records.
- Set up vendors, create purchase orders, sale invoices, and credit memos.
- Match, batch, code, and enter invoices.
- Track invoices, obtain corresponding approvals, and process payment documents.
- Analyze and process accounts payable via check or ACH.
- Process incoming payments by cash, check, credit card, and EFT.
- Review and process work-related travel and expenses.
- Adjust on price discrepancy, post payments to vendors, issue refunds to customers.
- Reconcile accounts to ensure money leaving account matches amount spent, and prevent balance sheet errors.
- Research previously processed invoices/information, and determine appropriate status of account.
- Review and verify invoices to determine that they comply with frameworks dictated by related contract or agreement.
- Introduce customers wide range of store’s products and make recommendations to meet their expectation.
- Handle phone calls from customers and manufactures, and resolve any issues if any.
- Maintain efficient, professional workflow, and profitable operations.
- Analyze warehouse availability and place orders with manufactures.
- Prioritize delivery in urgent manner.
Accounting Specialist
TS Nails LLC
01.2015 - 03.2020
- Handle the full accounting cycle from day-to-day operations to help with the month-end close and year-end filings.
- Supervise facility operation, manage employees’ schedules and performance, as well as make sure the business is profitable.
- Process incoming payments by cash, credit card, and check.
- Prepare and make bank deposits.
- Receive, process, and reconcile statements.
- Analyze and process accounts payable.
- Maintain accurate records, including ledgers, journals, receipts, and invoices.
- Make sure all supply inventories are stocked.
- Implement planning of cycle count ABC’s for inventory control. • Ensure compliance with internal accounting procedures.
- Interact with outside vendors to reconcile vendor accounts with open and/or questionable balances, and make necessary adjustments to the accounts and/or initiate vendor action.
Order Management Specialist
Greystone Data Systems Inc.
04.2007 - 09.2010
- Run daily Open Deliveries Report to meet service level.
- Run Current Inventory for Selected Locations for inventory control.
- Manage and resolve Aging order, Backlog, and Backorder.
- Perform sub-inventory transfers, view on-hand quantities, reserved products, and material transactions.
- Transfer products by pallet/package/serial number using Oracle IOX application and barcode scanner.
- Identify inventory issues and resolve accordingly.
- Adjust inventory by changing part number and/or serial number.
- Create pallet/package ID using Oracle DPS application, as needed.
- Utilize Oracle application to ship and receive products, and update orders.
- Create Order detail reports for Outbound shipments (by serial number, model, country of origin, pallet ID, and order details) imported from Oracle to Excel, and manage file with use of Pivot Table, VLOOKUP, Sorting, Filtering functions in order to generate various reports.
- Create and update weekly Internal Requisitions for billing purpose.
- Release Sales Order of outbound products going to APAC for recertification, between 150,000 – 200,000 monthly.
- Manage monthly Billing Reports from Oracle for both receipt and shipment of all products, typical monthly volumes 185,000 – 250,000.
- Instrumental in implementing process improvements working with Process Engineering, Information Technology, and Quality teams.
Education
Bachelor of Science - Financial Economics
University of Maryland-Baltimore County
Baltimore, MD12.2014
Skills
- Multiple years in full cycle accounting
- Accounting Specialist and Program Financial Analyst roles with Advanced Microsoft Excel skills: Pivot Tables, Power Query, Power Pivot, Power BI, Conditional Formatting, Charts, Data Validation, What-if Analysis
- Proficient in MIP Fund Accounting Application, SAP Concur for Travel, Invoice and Expense Management, Workday Adaptive Planning, Budgeting and Financial Management, Persimmony for Budget Tracking and Invoicing and Supporting Documents Submitting, UKG Ultipro for Time Management and Payroll Timesheet
- SignNow, Google Sheet, Adobe, Tipalti's Supplier Hub for Invoice Submission
- Many years of data analysis, statistical analysis, trend analysis, reports from extracting data from large database application to Excel
- Proficiency with 10-key typing and data entry
- Strong mathematical, organizational and analytical skills
- Journal Entries
- General Ledger Analysis
- Forecasting
- Budgeting
- Financial Analysis
Accomplishments
- Manage and invoice more than $1M+ per month for more than 70+ programs.
- Use Microsoft Excel to develop worksheet and data models to monitor the performance of programs.
- Create ways to manage, streamline, and facilitate on supporting documents: by G/L, Transactions Description, Line Items.. for a big volume of backups documents each month.
- Handle two big Divisions: School District Systems and Children's Initiatives at the Organization.
Languages
English
Full Professional
Vietnamese
Native or Bilingual
Timeline
Program Financial Analyst
Catholic Charities of Santa Clara County
09.2021 - Current
Accounting and Sales Specialist
Discovery Furniture LLC
09.2020 - 09.2021
Accounting Specialist
TS Nails LLC
01.2015 - 03.2020
Order Management Specialist
Greystone Data Systems Inc.
04.2007 - 09.2010
Bachelor of Science - Financial Economics
University of Maryland-Baltimore County
Similar Profiles
Joseph GiacintoJoseph Giacinto
Volunteer at Catholic Charities of Santa Clara CountyVolunteer at Catholic Charities of Santa Clara County
Juan Barraza RosalesJuan Barraza Rosales
Coral After School Instructor (CASI) at Catholic Charities of Santa Clara CountyCoral After School Instructor (CASI) at Catholic Charities of Santa Clara County
Jenny GuanJenny Guan
Afterschool Instructor at Catholic Charities of Santa Clara CountyAfterschool Instructor at Catholic Charities of Santa Clara County
Jessyca MorenoJessyca Moreno
After School Instructor at Catholic Charities of Santa Clara CountyAfter School Instructor at Catholic Charities of Santa Clara County
Vincent A. GonzalesVincent A. Gonzales
Materials Handler at Randstad Staffing (GXO/Applied Materials)Materials Handler at Randstad Staffing (GXO/Applied Materials)