Mitchell Spear Email & Phone Number

Washington, District Of Columbia, United States

Validate monthly data ingestion and promotion of 10 DoD financial feeder system data sets containing millions of records in accordance with the Federal Information System Controls Audit Manual (FISCAM) guidelines and the approved Feeder System's Common Data Model (CDM) housed on the Advana platformUtilize SQL data tools (i.e. Databricks and Redash) to verify the transformation of customer provided source data into the appropriate Universe of Transactions (UoT) fieldIdentify… Show more Validate monthly data ingestion and promotion of 10 DoD financial feeder system data sets containing millions of records in accordance with the Federal Information System Controls Audit Manual (FISCAM) guidelines and the approved Feeder System's Common Data Model (CDM) housed on the Advana platformUtilize SQL data tools (i.e. Databricks and Redash) to verify the transformation of customer provided source data into the appropriate Universe of Transactions (UoT) fieldIdentify, escalate and remedy data discrepancies via the Jira Ticketing SystemCollaborate with Data Engineers, Feeder System Owners and ADVANA users to ensure data mapping accuracy of pipeline logic vs. business rule compliance based on the customer source data provided. Revise CDM when updates are warranted by the customer to aid in the betterment of more accurate reconciliation of financial dataUtilize Slack and Microsoft Teams online collaboration tools with remote employee workforce Show less

Fort Belvoir, Virginia, United States

Served as Data Cleanse Coordinator for DoD related Contract Specialist staff to troubleshoot financial discrepancies preventing vendor payment, proper accounting/reconciliation of goods in the system of record regarding and the direct cite contracts. Compiled, distributed, and monitored several data reports regarding financial data discrepancies such as: unliquidated obligations, blocked & failed invoices, and negative liabilities). Performed technical analysis/research in the… Show more Served as Data Cleanse Coordinator for DoD related Contract Specialist staff to troubleshoot financial discrepancies preventing vendor payment, proper accounting/reconciliation of goods in the system of record regarding and the direct cite contracts. Compiled, distributed, and monitored several data reports regarding financial data discrepancies such as: unliquidated obligations, blocked & failed invoices, and negative liabilities). Performed technical analysis/research in the EBS/SAP, Wide Area Workflow (WAWF) and Electronic Document Access (EDA) applications to determine both the root cause and proper resolution steps of hundreds of lines of discrepant data ranging in the millions of dollars. Provided additional support and guidance to staff by engaging with internal Finance Division and Defense Finance and Accounting Services (DFAS) to remedy payment or accounting discrepancies linked to aged purchase orders. Collaborated with Deputy Director and Contracting Officers on a Bi-Weekly basis regarding data cleanse metrics. Received and annotated team deliverables on metrics via powerpoint for Deputy Director to use in briefings with DLA Energy Acting Deputy Commander.Participated in Bi-Weekly briefings regarding data cleanse metrics linked to Contract Specialist Team. Show less

Fort Belvoir

Performed accounting analysis using the Enterprise Business Solution (EBS) system of record in addition to Wide Area Workflow (WAWF) and Electronic Document Access (EDA) to determine both the root cause and proper resolution steps to remedy discrepant invoice and goods receipt data associated with the DLA Energy Facilities Sustainment & Installation Operations-Environmental Division projects. Compiled daily spreadsheets regarding blocked & failed invoices, and/or negative payable items… Show more Performed accounting analysis using the Enterprise Business Solution (EBS) system of record in addition to Wide Area Workflow (WAWF) and Electronic Document Access (EDA) to determine both the root cause and proper resolution steps to remedy discrepant invoice and goods receipt data associated with the DLA Energy Facilities Sustainment & Installation Operations-Environmental Division projects. Compiled daily spreadsheets regarding blocked & failed invoices, and/or negative payable items affecting vendor payment to ensure auditability and the proper reconciliation of purchase orders associated with the aforementioned lines of business.Provided support in the collection of Evidentiary Matter (EM) from vendors, contract specialists and Defense Finance and Accounting Services (DFAS) to remedy payment discrepancies and/or aged purchase orders. Distributed timely delivery of EM to the appropriate Accountable Receipt Official (ARO) to properly process or reverse Goods Receipts housed in EBS. Delivered progress reports and participate in weekly status briefs to federal employee staff to contribute to the overall DLA Energy Data Cleanse effort.Worked closely with internal workforce (Project Managers, Engineers, and Environmentalists) and Vendors to expedite payment to customer for services rendered. Gathered, analyzed and resolved unliquidated obligations (ULOs) preventing project closeout procedures of direct cite or reimbursable Military Interdepartmental Purchase Requests (MIPRs). Show less

Alexandria, Va

Provided analytical assistance to the Sustainment, Restoration, and Modernization (SRM) division of DLA Energy in identifying and updating sustainment unit costs for their 5-yr budget model regarding tank and non-tank assets.Identified approximately 6K+ Petroleum, Oil, Lubricant specific (POL) asset types by Facility Analysis Code (FAC) currently funded and maintained by DLA Energy-SRM using a variety of proprietary and non-proprietary database tools per the Real Property Asset Database… Show more Provided analytical assistance to the Sustainment, Restoration, and Modernization (SRM) division of DLA Energy in identifying and updating sustainment unit costs for their 5-yr budget model regarding tank and non-tank assets.Identified approximately 6K+ Petroleum, Oil, Lubricant specific (POL) asset types by Facility Analysis Code (FAC) currently funded and maintained by DLA Energy-SRM using a variety of proprietary and non-proprietary database tools per the Real Property Asset Database (RPAD). Constructed a dataset matrix of relevant real property assets located at capitalized fuel sites (CONUS and OCONUS) to gather pertinent cost and service data.Gathered relevant project costs and service documents (i.e. DD Form 1391s, Military Interdepartmental Purchase Requests-MIPRs, Service Orders, contracts, & invoices) via EBS, Wide Area Workflow (WAWF), and Electronic Document Access (EDA) to establish a set of usual/customary sustainment values for asset types in question.Analyzed data collected to ensure data validity between the identified asset and the evidentiary matter gathered.Utilized current data to improve model accuracy specifically for DLA Energy fuels infrastructure by verifying and updating current DLA Energy budget modeling business rules. Show less

Alexandria, Va

Responsible for generating Military Interdepartmental Purchase Requests (MIPRs) to assist with services pertaining to worldwide DLA Installation Support for Energy related lines of business. Gathered, compiled, and uploaded Budget Execution, Operations, and Human Capital metrics regarding the Monthly Obligation Plan (MOP) associated with the DLA Installation Support for Energy (DS-FE) Business Management Office in accordance with the current Annual Operating Budget (AOB) guidelines… Show more Responsible for generating Military Interdepartmental Purchase Requests (MIPRs) to assist with services pertaining to worldwide DLA Installation Support for Energy related lines of business. Gathered, compiled, and uploaded Budget Execution, Operations, and Human Capital metrics regarding the Monthly Obligation Plan (MOP) associated with the DLA Installation Support for Energy (DS-FE) Business Management Office in accordance with the current Annual Operating Budget (AOB) guidelines. Researched, analyzed and resolved $500K in Unliquidated Obligations (ULOs) and Undelivered Orders (UDOs) spanning multiple profit centers maintained in the EBS system of record by utilizing iRAPT/WAWF for proper evidential matter, DFAS and/or the proper POCs on behalf of the DS-FE Installation Support. Provided a monthly Attestation Memo for the DS-FE Director’s approval depicting the overall number and dollar amount of ULOs that were remedied. Reconciled funds weekly to ensure commitments and obligation requests are met within budgetary guidelines.Identified all internal/external functions within the DLA Installation Support for Energy Business Management Office that is associated with funding.Created and design Standard Operating Procedures (SOPs), Job Aids, and subsequent business flow charts of the various departmental business functions. Implemented and maintained electronic SOP's via SharePoint to assist federal employee workforce gain a better understanding of roles and responsibilities within the Business Management Office. Show less

Alexandria, Va

Served as Team Lead of eight contractors that provided support to the worldwide oversight of supply chain logistics associated to the Defense Logistics Agency’s (DLA) fuel division.Duties included ensuring the proper end-of-month (EOM) fuel reconciliation in accordance with DLA Energy policy regulations. Led team research efforts in the investigation of fuel discrepancies.Resolved partial payment discrepancies to fuel vendors, unpaid fuel invoices, and failed… Show more Served as Team Lead of eight contractors that provided support to the worldwide oversight of supply chain logistics associated to the Defense Logistics Agency’s (DLA) fuel division.Duties included ensuring the proper end-of-month (EOM) fuel reconciliation in accordance with DLA Energy policy regulations. Led team research efforts in the investigation of fuel discrepancies.Resolved partial payment discrepancies to fuel vendors, unpaid fuel invoices, and failed Intermediate Documents (IDOCs) not posting properly in Enterprise Business System (EBS). Analyzed and interpreted various supporting documentation to remedy failed transactions in a timely manner. Utilized relevant accounting/information databases to monitor, identify, investigate, and resolve discrepant data. Consulted with DLA employees, Defense Finance and Accounting Services (DFAS) personnel, in addition to points-of-contact worldwide to assist in gathering pertinent information necessary to resolve discrepant data. Compiled and interpreted voluminous statistical fuel data via Microsoft Excel to identify trends that adversely affected proper fuel reconciliation and payment. Briefed supervisors regarding the overall progress and completion of team projects/duties. Provided recommendations to supervisors on corrective solutions that would mitigate workflow bottlenecks. Show less