Ryan Wagner Email & Phone Number

Ryan Wagner is a Accountant at DFAS at DFAS. He possess expertise in microsoft access, microsoft word, microsoft sql server, microsoft excel, cmis and 1 more skills.

Listed skills include Microsoft Access, Microsoft Word, Microsoft Sql Server, Microsoft Excel, and 2 others.

• 

  Accountant

  Dfas

  May 2009 - Present

  Serve as the lead Microsoft SQL Developer for the Army Fund Balance with Treasury System.Current Responsibilities:- Developing, testing, and implementing system change requests and program trouble reports using Microsoft SQL Server Management Studios and Microsoft SQL Server Integration Services.- Create and maintain SQL Server Reporting Services reports for three different customers.- Maintain all programming logic and change control using Configuration Management Information System and Subversion.- Perform annual system control checks for audit and create/implement any corrective action plans due to any findings.Previous Responsibilities:- Reconciled Defense Agencies accounting systems transactions with US Treasury account balances.- Researched, identified, and corrected over seventy million dollars worth of disbursement/collection variances.- Supervised an Accounts Payable team that reduced overage invoices by 17% in six months.- Managed six Microsoft Access Databases that helped manage workflow and produce reports for all of Accounts Payable.- Managed the monthly utility billing process for Fort Bragg in Accounts Receivable reducing overage invoices by over nine million dollars.- Developed standard operating procedures for numerous processes and performed audit test to ensure proper controls were in place.