Bob Blanchard
Financial Controller at Air Transport International- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Air Transport International, Inc.
-
United States
-
Aviation and Aerospace Component Manufacturing
-
500 - 600 Employee
-
Financial Controller
-
Jul 2013 - Present
-
-
-
ASTAR Air Cargo
-
Airlines and Aviation
-
100 - 200 Employee
-
Operations Finance Director
-
2003 - 2012
•Performed accounting duties such as account reconciliations, purchase/repair/service accruals, year-over-year analyticals, trend analysis’, monthly depreciation calculations, inventory sub ledger interfaces, and book/tax depreciation forecasts. •Implemented fresh start purchase accounting and created asset system in Excel for book, IRS, AMT, and personal property tax records. •Implemented TRAX inventory and maintenance and engineering software – including functional design requirements… Show more •Performed accounting duties such as account reconciliations, purchase/repair/service accruals, year-over-year analyticals, trend analysis’, monthly depreciation calculations, inventory sub ledger interfaces, and book/tax depreciation forecasts. •Implemented fresh start purchase accounting and created asset system in Excel for book, IRS, AMT, and personal property tax records. •Implemented TRAX inventory and maintenance and engineering software – including functional design requirements, user-acceptance-testing, and data conversion for inventory, purchasing and accounts payable; designed TRAX Front-End ODBC database interfaces via Access for data collection, analysis and GL interfaces. •Implemented Microsoft Dynamics Navision for budgeting and financial analysis and managed budget process including departmental build-ups, historical unit rates comparisons, variance analysis and reporting; prepared monthly management financial book summarizing month and YTD results along with multiple analyses including department and divisional variances explanations, headcount summaries, and results by chart fields within income statement groups. •Created Access flight database(s) of all aircraft flights, arrivals, departures, flight and block hours, destinations, and flight dates facilitating budget reviews, service accruals, property-tax allocations and aircraft/engine tracking. •Integrated Tax, Fixed Asset and Capitalized Part (Rotable) inventory data into linked/shared Access databases to Trax Oracle database providing timely modeling, forecasting, and part tracking. •Administered Company’s American Express credit card programs for seven basic control accounts. •Created Company Finance policies and forms; documented procedures and re-engineered workflow processes between two headquarter locations. •Organized and directed CVG external audits of fixed assets, inventory, payables and mx accounting. •Implemented project costing for Heavy Maintenance Visits (airframe and engine). Show less •Performed accounting duties such as account reconciliations, purchase/repair/service accruals, year-over-year analyticals, trend analysis’, monthly depreciation calculations, inventory sub ledger interfaces, and book/tax depreciation forecasts. •Implemented fresh start purchase accounting and created asset system in Excel for book, IRS, AMT, and personal property tax records. •Implemented TRAX inventory and maintenance and engineering software – including functional design requirements… Show more •Performed accounting duties such as account reconciliations, purchase/repair/service accruals, year-over-year analyticals, trend analysis’, monthly depreciation calculations, inventory sub ledger interfaces, and book/tax depreciation forecasts. •Implemented fresh start purchase accounting and created asset system in Excel for book, IRS, AMT, and personal property tax records. •Implemented TRAX inventory and maintenance and engineering software – including functional design requirements, user-acceptance-testing, and data conversion for inventory, purchasing and accounts payable; designed TRAX Front-End ODBC database interfaces via Access for data collection, analysis and GL interfaces. •Implemented Microsoft Dynamics Navision for budgeting and financial analysis and managed budget process including departmental build-ups, historical unit rates comparisons, variance analysis and reporting; prepared monthly management financial book summarizing month and YTD results along with multiple analyses including department and divisional variances explanations, headcount summaries, and results by chart fields within income statement groups. •Created Access flight database(s) of all aircraft flights, arrivals, departures, flight and block hours, destinations, and flight dates facilitating budget reviews, service accruals, property-tax allocations and aircraft/engine tracking. •Integrated Tax, Fixed Asset and Capitalized Part (Rotable) inventory data into linked/shared Access databases to Trax Oracle database providing timely modeling, forecasting, and part tracking. •Administered Company’s American Express credit card programs for seven basic control accounts. •Created Company Finance policies and forms; documented procedures and re-engineered workflow processes between two headquarter locations. •Organized and directed CVG external audits of fixed assets, inventory, payables and mx accounting. •Implemented project costing for Heavy Maintenance Visits (airframe and engine). Show less
-
-
-
National Airlines
-
United States
-
Airlines and Aviation
-
200 - 300 Employee
-
General Accounting Manager/Director
-
Dec 1998 - Jun 2003
•Created RFP for GL, AP and fixed assets and implemented Navision software modules for GL, AP, and Purchasing; implemented Best FAS accounting and Crystal report writer for Fixed Assets, and ADP PC-Payroll for windows. •Organized year-end audit with external auditors; prepared all audit lead schedules and ensured all follow-up was completed. •Managed employees in General Accounting, Accounts Payable and Payroll and ensured accurate completion of all month-end close activity utilizing… Show more •Created RFP for GL, AP and fixed assets and implemented Navision software modules for GL, AP, and Purchasing; implemented Best FAS accounting and Crystal report writer for Fixed Assets, and ADP PC-Payroll for windows. •Organized year-end audit with external auditors; prepared all audit lead schedules and ensured all follow-up was completed. •Managed employees in General Accounting, Accounts Payable and Payroll and ensured accurate completion of all month-end close activity utilizing Microsoft Navision Accounting software. •Ensured accurate and timely completion of all income and balance sheet account reconciliations; performed monthly variance analysis and imported related accruals, adjustments and all other vouchers to Navision utilizing MS Excel and Access; created internal financial statements and prepared monthly and quarterly Form 41 financial statements for DOT; prepared monthly trustee financial operating and pro-forma statements for US Trustee due to Chapter 11 filing. •Designed various access databases to efficiently record and/or analyze fuel ticket uplift, catering expenses, actual/FTE company headcount and annual bottoms-up budgets with cost center and divisional rollups. •Assisted in the creation of all accounting policies and procedures upon airline start-up such as expense report reimbursements, travel advances, check requests, wire transfers, invoice approval authority guidelines and capital expenditure requests. •Reviewed monthly ADP payroll transactions and related account reconciliations; designed, implemented and maintained ADP payroll interfaces to the Navision general ledger. Show less •Created RFP for GL, AP and fixed assets and implemented Navision software modules for GL, AP, and Purchasing; implemented Best FAS accounting and Crystal report writer for Fixed Assets, and ADP PC-Payroll for windows. •Organized year-end audit with external auditors; prepared all audit lead schedules and ensured all follow-up was completed. •Managed employees in General Accounting, Accounts Payable and Payroll and ensured accurate completion of all month-end close activity utilizing… Show more •Created RFP for GL, AP and fixed assets and implemented Navision software modules for GL, AP, and Purchasing; implemented Best FAS accounting and Crystal report writer for Fixed Assets, and ADP PC-Payroll for windows. •Organized year-end audit with external auditors; prepared all audit lead schedules and ensured all follow-up was completed. •Managed employees in General Accounting, Accounts Payable and Payroll and ensured accurate completion of all month-end close activity utilizing Microsoft Navision Accounting software. •Ensured accurate and timely completion of all income and balance sheet account reconciliations; performed monthly variance analysis and imported related accruals, adjustments and all other vouchers to Navision utilizing MS Excel and Access; created internal financial statements and prepared monthly and quarterly Form 41 financial statements for DOT; prepared monthly trustee financial operating and pro-forma statements for US Trustee due to Chapter 11 filing. •Designed various access databases to efficiently record and/or analyze fuel ticket uplift, catering expenses, actual/FTE company headcount and annual bottoms-up budgets with cost center and divisional rollups. •Assisted in the creation of all accounting policies and procedures upon airline start-up such as expense report reimbursements, travel advances, check requests, wire transfers, invoice approval authority guidelines and capital expenditure requests. •Reviewed monthly ADP payroll transactions and related account reconciliations; designed, implemented and maintained ADP payroll interfaces to the Navision general ledger. Show less
-
-
-
America West Airlines
-
Airlines and Aviation
-
1 - 100 Employee
-
Fixed Assets and Inventory Manager, AP Supv
-
Sep 1986 - Dec 1998
•Implemented SCEPTRE materials management, purchasing and planning system, NOMAD report writer, QSP-OLAS for AP and Cyborg Fixed Assets. •Created and mapped transaction interfaces for SCEPTRE/OLAS AP, Mapper Purchasing /Cyborg Fixed Assets and NOMAD/Cyborg Fixed Assets. •Implemented fresh start accounting for the Fixed Assets database upon emergence from Chapter 11 bankruptcy in August 1994; revalued and recorded fair market value of assets for over 75 thousand records in Cyborg… Show more •Implemented SCEPTRE materials management, purchasing and planning system, NOMAD report writer, QSP-OLAS for AP and Cyborg Fixed Assets. •Created and mapped transaction interfaces for SCEPTRE/OLAS AP, Mapper Purchasing /Cyborg Fixed Assets and NOMAD/Cyborg Fixed Assets. •Implemented fresh start accounting for the Fixed Assets database upon emergence from Chapter 11 bankruptcy in August 1994; revalued and recorded fair market value of assets for over 75 thousand records in Cyborg database. •Developed controls, policies and procedures to improve daily operations and provide appropriate internal control. •Provided development opportunities to team members including training in MS Office, OLAS and NOMAD and administered performance evaluations in association with key performance measures. •Supervised monthly expendable inventory reconciliations and capital inventory tracking. •Reviewed all transactions associated with Fixed Assets and ensured proper accounting treatment for each transaction; calculated monthly depreciation and amortization expense and posted amounts to general ledger; performed monthly account reconciliations between the Fixed Assets subledger, work in process accounts and the general ledger; reviewed and supervised the preparation of lead schedules and PP&E for the external auditors and Form 41 inventory schedules for the DOT. •Prepared depreciation and amortization forecasting models for the annual plan. •Reviewed and administered annual physical inventories for ground equipment assets used in airport operations across the United States. Show less •Implemented SCEPTRE materials management, purchasing and planning system, NOMAD report writer, QSP-OLAS for AP and Cyborg Fixed Assets. •Created and mapped transaction interfaces for SCEPTRE/OLAS AP, Mapper Purchasing /Cyborg Fixed Assets and NOMAD/Cyborg Fixed Assets. •Implemented fresh start accounting for the Fixed Assets database upon emergence from Chapter 11 bankruptcy in August 1994; revalued and recorded fair market value of assets for over 75 thousand records in Cyborg… Show more •Implemented SCEPTRE materials management, purchasing and planning system, NOMAD report writer, QSP-OLAS for AP and Cyborg Fixed Assets. •Created and mapped transaction interfaces for SCEPTRE/OLAS AP, Mapper Purchasing /Cyborg Fixed Assets and NOMAD/Cyborg Fixed Assets. •Implemented fresh start accounting for the Fixed Assets database upon emergence from Chapter 11 bankruptcy in August 1994; revalued and recorded fair market value of assets for over 75 thousand records in Cyborg database. •Developed controls, policies and procedures to improve daily operations and provide appropriate internal control. •Provided development opportunities to team members including training in MS Office, OLAS and NOMAD and administered performance evaluations in association with key performance measures. •Supervised monthly expendable inventory reconciliations and capital inventory tracking. •Reviewed all transactions associated with Fixed Assets and ensured proper accounting treatment for each transaction; calculated monthly depreciation and amortization expense and posted amounts to general ledger; performed monthly account reconciliations between the Fixed Assets subledger, work in process accounts and the general ledger; reviewed and supervised the preparation of lead schedules and PP&E for the external auditors and Form 41 inventory schedules for the DOT. •Prepared depreciation and amortization forecasting models for the annual plan. •Reviewed and administered annual physical inventories for ground equipment assets used in airport operations across the United States. Show less
-
-
Education
-
Arizona State University
Bachelor of Applied Science (BASc), Accounting