Devan Hidalgo Email & Phone Number

Huntsville, Alabama Area

Performs budget formulation, consolidation, shortfalls, and trade-offs analyses efforts based on functional requirements and authorized funding. Develops and propose alternative methods of financing unfunded requirements. Reviews and analyzes historical and current data using quantitative and qualitative analytical techniques to determine spending trends and forecast funding needs. Prepares a variety of reports covering the status of funds and advises program managers and the Business Financial Manager on the availability of funds. Performs research to obtain a variety of cost, schedule, and performance data used in formulating mitigation strategies for cost and schedule variances. Monitors year-end funding to ensure proper and full use of funds. Serves as financial advisor to the program office technical and program managers on contract management issues including fact finding, carry-over and fall-out exercises, budget what-if drills, and analyses. Has maintained budgets for subcontractor’s hours, expenses and approved subcontractor invoices and subcontractor modifications. Verify customer and subcontractor invoices for accuracy with regards to hours, funding availability and recommens changes as needed. Approves all modifications from prime contractors. Directs employees as to what charge numbers their time should be coded to. Responsible for updating financial information for division Program Manager’s Meetings (PMR’s) using S Curve charts. Submit weekly financial reports to upper management detailing overhead expenditures, indirect costs spent and utilization of employees. Perform Earned Value tasks for projects within the in Deltek Cobra system. Update PM’s on status of programs weekly. Provide EV reports to CAM’s on a monthly basis. Transitioned from Deltek Cosptoint to SAP accounting system for tracking costs. Also, using SAP Business Intelligence (BI) tool to generate hours reports and track open commitments.

Primary financial analyst responsible for accounts receivable with customer database of over 30 customers and revenue totaling several million dollars. Principal focal point between customers to ensure accurate billing, reconcile discrepancies, and ensuring customer satisfaction. Responsible for all aspects of collections: customer communications including commercial and government (DFAS), accounts, billing, and reporting. Submitted all government customer invoices into Wide Area Workflow (WAWF), the government invoicing system and followed up with government officials when necessary. Compiled data and issued bi-weekly invoices of private corporation and government customers using Deltek Costpoint software system. Created and maintained financial and collection report(s) for CFO and staff. Maintained files of current invoices and previous customer invoices. Created customer files and database with customer contact information. Responsible for updating and maintaining monthly depreciation schedule of fixed assets.

Accounts Receivable/Collections Administrator, SirsiDynix Corp., Huntsville, AL, Feb 2005 to April 2007.Responsible for the maintenance and data integrity of customer and billing/collections in the Great Plains accounting system. Database included over 3400 customers with customer demographics along with tax schedules and sales-related data. Responsible for customer collection/billing typically requiring over 700 line items totaling over $1,600,525 monthly. Issued all pro forma invoices (pre-billings) requested by our customers. Responsible for all collections of legacy company customers, which consisted of over 1700 customers. Maintained the collection module in Great Plains software system and built queries for collection information. Issued all credits, voids and debit memos for refunds ensuring data integrity for general ledger accounting. Communicated with customers directly via telephone calls or e-mails; coordinate with Legal department as required for collections. Responded to all accounts receivables questions from customers which consisted of Directors of Libraries, Purchasing Agents and Accounts Payable Administrators. Validated all incoming orders from customers for accuracy regarding addresses, pricing and purchase order numbers. Responsible for maintaining all deferred accounts. Month-end responsibilities included creating aging report and matching up any outstanding payments or credits; clearing invoices, generating and sending out month end statements to customers. Assisted co-workers with any invoicing questions. Software and websites/portals used regularly included all MS Office applications (Word, Excel, etc.), Crystal Reports, WAWF (Wide Area Work Flow) which is the government contract billing website, Eli Lilly, Ford Motor Co., Hewlett Packard, Johnson & Johnson and GSA (General Services Administration).

Bachelors, Management/Business Administration

Education record