Summary
Overview
Work History
Education
Skills
Awards
Timeline
Generic

Dallas Kaleipuanani Wilcox

Honolulu,HI

Summary

Performed specialized sales accounting in compliance with GAAP and company policies, analyzing and supporting new business initiatives while refining accounting models and processes. Managed reconciliations for Direct Sales (Station/NDC) and Indirect Sales (ARC/BSP/NDC) and contributed to collaborative projects. Developed and maintained dashboards for ARC/BSP settlement and memo reconciliations, delivering KPI insights to stakeholders. Supported the Interline/Lifts/Cargo team operations as well as Reservations, Web Support, Airport Operations, GSA, and Sales. Oversaw outsourced vendors in executing business processes and monitored their performance against SLAs and KPIs.

Overview

38
38
years of professional experience

Work History

Accountant – Passenger Sales

Hawaiian Airlines
01.2017 - Current
  • Performed detailed accounting principles as well as acquired software applications and upgrades
  • Responsibilities included maintenance of records and accounts covering business transactions according to established guidelines and procedures
  • Ensured that the job requirements of the Accounting Department are carried out in accordance with the Manager’s/Senior Director’s instructions and established guidelines and procedures
  • Primary responsibility is to maintain and support ARC and BSP reporting and settlement, month end journal entries, and reconciliations in collaboration with offshore team TCS
  • Reviewed other reconciliations and journal entries for assigned transactions by outsourced vendors
  • Work directly with Revera Business Analyst to incorporate process improvements in Revera for Memo Accounting
  • Implemented RNT Dashboard to provide a snapshot of business trends
  • Identified and recommended process improvements in the Revenue Accounting System Revera
  • Assist, train, and support offshore vendors continuously
  • Implemented and continue to implement sales and memo dashboards for analysis by internal, and external teams to align to Accounting’s 2020 plan
  • Support Refund, Interline Revenue, and Lift team in day-to-day operations
  • Worked closely with and supported Reservations, CAO, Web Support, Teleperformance, TCS, Accelya, Airport Operations, Legal, GSA, and Sales and Marketing
  • Working on HA’s Distribution initiative New Distribution Capability (NDC) by gained familiarization and understanding to the NDC processes and Channels.
  • Mainly involved in testing between ARC transactions and flows to Revera to validate completeness in policy, procedure, data transition, and accounting.
  • Supported the Passenger Service System (PSS)/Amadeus transition in testing data reporting between Amadeus and Revera integration and other Revenue Accounting functions to insure completeness in policy, procedure, data transition, and accounting
  • All projects are truly a collaborative team effort with the business workstreams at Hawaiian Airlines
  • Performed other duties as assigned

Accounting Associate – Passenger Sales and Refunds

Hawaiian Airlines
01.2011 - 01.2017
  • Transition from Contract to Non-Contract position
  • Performed detailed accounting principles as well as acquired software applications and upgrades
  • Supervised and evaluated offshore vendors
  • Responsibilities included maintenance of records and accounts covering business transactions according to established guidelines and procedures
  • Ensured that the job requirements of the Accounting Department are carried out in accordance with the Manager’s/Senior Director’s instructions and established guidelines and procedures
  • Supported and collaborated with offshore vendors TCS in Refund research, validation, and processing
  • Implemented Refund Dashboard to provide a snapshot of business trends
  • Subject Matter Expert (SME) in the development of Revera – Revenue Accounting System Passenger Sales module
  • Worked collaboratively to implement Electronic Miscellaneous Documents (EMD) to support ancillary revenue
  • Supported Interline Revenue and Lifts team in day-to-day operations
  • Worked closely with and supported Reservations, CAO, Web Support, Teleperformance, TCS, Airport Operations, Legal, GSA, and Sales and Marketing
  • Performed other duties as assigned

Accounting Clerk II – Revenue Accounting

Hawaiian Airlines
01.2005 - 01.2010
  • Performed the same function as the Accounting Clerk I (Travel Agency Audit) position except with more of a detailed understanding of accounting principles as well as acquired software applications and upgrades
  • Supervised and evaluated other employees
  • Assigned and trained other employees of a lower classification
  • Established employees’ work schedule
  • Responsibilities included maintenance of records and accounts covering business transactions according to established guidelines and procedures
  • Ensured that the job requirements of the Accounting Department are carried out in accordance with the Manager’s/Senior Director’s instructions and established guidelines and procedures
  • Worked with many informational websites critical to job function such as American Express, Merchant Connect (Visa/Master), Discover Card, ABANCO, ARC, BSP, IATA, Fare Manager, Sabre, Hawaiian Miles, etc
  • Responsible for knowledge transfer to TCS (India) and Sitel (Philippines) per HA’s outsourcing project
  • Knowledge in Microsoft Office Suite (Excel, Access, Powerpoint, Word, etc.)
  • Acquired knowledge and extensive use in Peoplesoft (Oracle) and query language
  • Worked closely with and supported Reservations, CAO, Web Support, Sitel, TCS, Airport Operations, Legal, and Sales and Marketing

Accounting Clerk II – Statistics

Hawaiian Airlines
01.2004 - 01.2005
  • Responsibilities include the research of electronic ticketing issues, preparation of various state and federal air transportation statistics, preparation of SOH landing fee and joint use self-invoice, preparation of various monthly statistical reports for internal users, DBEDT, and trade publications, preparation of journal entries primarily landing fees and various expense accounts, accommodated special request from various departments
  • Knowledge fostered in Excel, Access, and government transportation databases (Bureau of Transportation Statistics BTS)
  • Knowledge in Microsoft Office Suite (Excel, Access, Powerpoint, Word, etc.)

Accounting Clerk I - Accounts Receivable

Hawaiian Airlines
01.1991 - 01.2004
  • Responsibilities include - Reconciliation of all credit card forms of payments
  • Handled inquiry of charges from both credit card companies and cardholders which entailed problem solving combined with customer service
  • Performed billings, collections, and reconciliation
  • Acquired knowledge and instrumental in the implementation of automated Revenue Accounting system RevTrack
  • Possess knowledge in process of refunds, interline, cargo, sales audit, pricing, and general accounting functions
  • Knowledge in Microsoft Office Suite (Excel, Access, Powerpoint, Word, etc.)

Reservations

Hawaiian Airlines
01.1990 - 01.1991
  • Responsibilities included customer service and sales through flight seat bookings for inter-island and transpacific routes
  • Important customer service aspect of position entailed possessing full knowledge of airfares to accommodate the customer with the best value and service possible
  • Utilized Sabre GDS while accommodating passengers and travel agency via call for flight travel on Hawaiian Airlines

Sales Representative Promotions

Hawaiian Airlines
01.1987 - 01.1990
  • Traveled abroad and worked in a team promoting Hawaii and Hawaiian Airlines through song and dance
  • The position required public relations with individuals in other travel related industries as well as potential Hawaiian Airlines guests

Education

Bachelors in Science - Business Administration

University of Phoenix
Honolulu, HI
01.2005

Associate in Science Degree - Accounting, Data Processing ICS

University of Hawaii - Kapiolani
Honolulu, HI
01.1986

High School -

Kalani High School
Honolulu, HI
01.1981

Skills

  • Accounting and bookkeeping
  • Accounts payable and receivable
  • Bank reconciliation
  • Account reconciliation
  • Accounts payable
  • Data analysis
  • General ledger entries
  • Account reconciliation processes
  • General ledger management
  • General ledger accounting
  • MS office suite
  • Customer relations

Awards

  • Reengineering Task Force, 12/31/97
  • Kupono Award Recipient, 12/31/12
  • Employee Resource Group (ERG) – HA Giving Program, Current

Timeline

Accountant – Passenger Sales

Hawaiian Airlines
01.2017 - Current

Accounting Associate – Passenger Sales and Refunds

Hawaiian Airlines
01.2011 - 01.2017

Accounting Clerk II – Revenue Accounting

Hawaiian Airlines
01.2005 - 01.2010

Accounting Clerk II – Statistics

Hawaiian Airlines
01.2004 - 01.2005

Accounting Clerk I - Accounts Receivable

Hawaiian Airlines
01.1991 - 01.2004

Reservations

Hawaiian Airlines
01.1990 - 01.1991

Sales Representative Promotions

Hawaiian Airlines
01.1987 - 01.1990

Associate in Science Degree - Accounting, Data Processing ICS

University of Hawaii - Kapiolani

High School -

Kalani High School

Bachelors in Science - Business Administration

University of Phoenix

Similar Profiles

CREATE PROFILE
Dallas Kaleipuanani Wilcox