Provided financial management to IT systems organizations at DISA/DoD. Supported PMs through maintaining of financials for 19+ T&M and FFP projects, as part of PMO at PSI. Excel wizard, U.S citizen, Secret clearance.
Provided financial management to DISA, in support of the fiscal year budgetary process in requesting annual funds and projecting 10 years of cost/obligation estimates
Assisted development of $11M+ program budget, annual/monthly spend plans, commitment and obligation estimates, and Appropriated and DWCF funding packages to the RMO
Provided expert analysis in managing fiscal year quarterly funding allocations for O&M Infrastructure Executive (IE) programs, while under Continuing Resolution and fiscal budget restrictions
Developed financial reports with Excel/Tableau to senior management, in support of funding package development, status of funds reconciliation, funding re-alignments, and financial process improvement, in meeting department-wide financial goals
Supported PMO and PMs in maintaining the financials of 19+ projects through budgeting of funds across various OYs, forecasting profit/loss and gross margin, and recording/adjusting of employee and sub-contractor labor hours, cost/bill rates, and indirect rates
Performed financial/trend analysis of project variances, while working closely with PMs and CFO, to ensure resources are managed optimally, efficiently, and under budget to increase cost savings
Gathered project progress data/statistics and produced reports, tracking benefits and managing dependencies across multiple projects to deliver projects ahead of schedule
Experienced in applying EVM methodology in calculating project cost and schedule progress/baseline
Mentored and co-presented with PMs of project financials in presentation of PMRs to CEO, COO, CFO, VPs, as an important role for senior decision support and performance management
Assisted DoD in implementing plan for audit readiness in E&C and Valuation of Real Property, to prioritize assets that are material, address weaknesses in the process
Formulated complete process narratives/flows in areas of BRAC, DM, Heritage assets, Transfer Out
Assisted in developing/monitoring corrective action plans for identified control weaknesses in conformance with FISCAM
Verified physical inventory of RP assets of E&C and assisted AF RP offices in valuing RP assets at: JB Andrews, Vandenberg AFB, JB Elmendorf-Richardson, USAFA
Analyzed/calculated new pay rates for 10,000+ union employees of New Mexico (using Excel algorithms), who were owed varying increases, to ensure union members received their corrected gross back pay starting from 2009
Utilized Excel to manipulate 300,000+ data items with pivot tables and implemented match checks in order to resolve variances that occurred during calculations and ensure data output accuracy
Innovated financial strategies to streamline back pay processes and meet crucial pay advice deadlines
Assisted legal and risk management in ensuring commodities wholesale compliance to FERC and Dodd Frank through creation of trade monitoring strategies
Collaborated with IT security to reduce costs, review policies/procedures, appraisals of IT systems, recommend escalation measures, document deviations and irregularities – while manipulating data in Excel to produce reports for management, including infographs, tables, & other statistics/compilations
Maintained Constellation as a non-swap dealer via commodities group support, trade evaluation for operational and market risks, improving internal controls, and analysis/reporting of virtual transactions