Budget Optimization Specialist

Budget Optimization Specialist - 508535 Department: Federal Services Employment Type: Full Time Location: San Francisco, CA Description TeleSolv Consulting has multiple openings for a Sr. Budget Analyst to support a federal law enforcement agency in San Francisco, CA. Please note that this is an onsite position requiring all applicants be local to the San Francisco, CA location. The qualified candidate shall provide financial management support to regional and headquarters offices within a Federal program, assisting in the analysis, tracking, and monitoring of accounting activities through an approved Federal financial management system. Duties include performing a range of budgetary, analytical, technical, and administrative functions in support of key organizational operations. The individual must demonstrate proficiency in applying generally accepted accounting principles (GAAP) and communicating financial and budgetary information effectively across multiple levels of management. Responsibilities The contract employee shall support the Region 9 and West Zone federal government agency's financial management and senior level staff by assisting in analyzing, tracking and monitoring accounting functions in the Federal Financial Management System (FFMS). Tasks include supporting a variety of budgetary, analytical, technical, and administrative functions for substantive organizational programs and support activities. The contract employees must be able to apply generally accepted accounting principles to diverse tasks and be able to clearly and effectively communicate accounting and budget information to all levels of staff. Performs a variety of record keeping, reporting, and informational duties in support of the government programs. Compiles, maintains and updates data, lists, and reports. Checks and verifies data by direct comparison with source documents, pointing out discrepancies, and checks or verifies textual material. Performs work related to gathering, acquiring, and developing resource materials and other information to support the law enforcement, security, compliance, and or inspection programs. Updates manuals on policies, directives, and memoranda. Maintains bulletin board(s), selecting and filing new and/or removing deleted material for future reference. Records, sorts, assembles, and files information on specific projects, facilities, contracts, financial documentation, current project, or studies. Monitors, coordinates and maintains a variety of records. Extracts information, enters information into databases, analyzes data to determine if trends or patterns exist, and generates various management reports used in decision making. May assist users in the organization with software, hardware, and automation problems. Performs other office automation work, solely or in combination with clerical or technical work performed as part of the general office support duties. Uses computer software to produce, store and retrieve a variety of documents, including spreadsheets, databases, and graphics. Responsible for sorting, arranging, and maintaining records in file cabinets or electronically in accordance with either an approved records management file plan, numbering systems or alphabetical order. Assembles records to ensure that material on specific transactions or subjects are kept together. Possess and demonstrates advanced proficiency and competence in computer skills, specifically in Microsoft Windows office programs (Excel, Word, Access, Outlook, Visio, and PowerPoint), Adobe, and has the ability to learn and become proficient in various federal government agency's computer programs and applications after initial training and orientation. Capable of operating routine office equipment, such as scanners, copy machines, fax machines, and other miscellaneous office equipment. Performs basic analysis of security data and prepares multiple sensitive security documents for management review. Additionally, analyzes accounting data, reconciles accounts, and drafts documentation to justify reprogramming actions and submit reclassification requests. These requests are routed through the Supervisory Budget Analyst, Supervisory CORs, and/or Financial Program/Cost Analyst for approval and implementation in the financial system. Review invoices, verify information (to include 139s) and ensure sufficient funds have been obligated for payment of invoices on multi-million-dollar contracts. Facilitates the approval process of all invoices in accordance with stringent federal government agency's invoice procedures, within specified timelines.,. Creates the FFMS Receiving ticket after receiving the approval of the COR for invoice payment. Assists CORS in the preparation of invoice correction or rejection documentation for uploading into Webview or other system as appropriate Responsible for the notifying the appropriate federal government agency's employee that the FFMS documentation has been completed and included in Webview per agency standard operating procedures. If invoices are not accurate, the contract employee shall elevate the invoice to the appropriate Government employee. Responsible for creating and maintaining the FM151 vendor payment reconciliation report spreadsheet, ensuring accurate reconciliation and close-out throughout the life of the contract obligation. If needed, conducts research, prepares, and submits expense reclassifications to correct any discrepancies in expenditures. Assist the appropriate government employee with initiating, estimating, collecting, processing orders, monitoring, reconciling, and closing Security Work Authorizations (SWA’s) in accordance with agency standard operating procedures. Verifies and processes accounts receivable and reimbursable agreement transactions. Processes transactions into financial systems, reviews data entry for accuracy and performs adjustments, if needed. Assists the government in analyzing the region's revenue and expenditures across various funding sources, including guard services and contracts. Responsibilities include conducting Monthly Billing Analysis, Monthly SWA Analysis, Spend Plan reviews, 1/12th billing analysis, and monitoring Undelivered and Unliquidated Orders. Additionally, supports the compilation, preparation, and maintenance of reports summarizing accounting data for the organization. Proficient in FFMS, responsible for creating G514 commitments, reviewing obligations, reviewing change orders, making modifications, and generating various analysis reports (e.g., CM040, FM151, PM020, FM140, FM085) accurately and on time, in compliance with agency standard operating procedures. Ensures that all G514s and supporting documentation are submitted to the Consolidated Contract Team (CCG) within the required deadlines. Assists with contract and obligation closeout process per agency standard operational procedures. Assists CORs and regional budget team in the creation/preparation/submission of required agency documentation requesting specific contractual services, i.e., permanent/temporary/emergency Protective Security Officer (PSO) services, security projects and security system repairs per agency guidelines or standard operating procedures. Assist federal government agency's Management with the monthly, quarterly, and/or annual financial submission, execution, reconciliation and close-out of yearly appropriations based on developing and standard practices. Assisting in the package development of the unfunded security countermeasure requirements for submission to the federal government agency's national Acquisition Review Board. Assist regional staff in processing official travel documents in Concur, to include supporting budget staff with funding documentation and tracking travel documents and requirements for official travel. Maintain current Exhibit 1 (post spreadsheet) for the guard contracts containing approximately 1230 Protective Security Officers in approximately 644 guard posts, serving several different Federal Government agencies in 4 states and various Pacific Islands. Modify Exhibit 1 frequently to reflect Contracting Officer (CO)/Contracting Officer’s Representative (COR) authorized implemented service request per requesting agency. Perform budget administrative duties as needed by the Resource Management Branch (RMB) and Security Operations Branch in support of federal government agency's PSO requirements. Drafts special research requests for review. Drafts conventional and precedent statistical products. Retrieves financial system data and utilizing standard statistical methods to assist in analyzing data. Provides assistance to special projects to be identified by Region 9 and West Zone financial and senior level management. Prepares a variety of technical presentations, performs basic analysis of security and financial information. Processes critical program data in proprietary databases. Possess the ability to take raw information, input in specific locations for archive, and retrieval, and reporting purposes, and create various reports from the information in the various locations using whichever format (i.e., Access, Microsoft Office Excel and pivot tables) deemed appropriate, or as instructed. For example, but not inclusive, databases include Federal Financial Management System (FFMS), Webview, and Revenue Management System (RMS) for various reporting systems and document repository. Ability to create, monitor, and maintain Excel spreadsheets used in the analysis of financial and budgetary information pertaining to federal government agency's contracts and contractor payments. Assists in the package development of the unfunded security countermeasure requirements for submission to the federal government agency's national Acquisition Review Board. Analyzes estimates for consolidation of funding requests; assist in verifying cost estimates received from others by evaluating the consistency of dollar estimates against PSO contract exhibits. Reviews and analyzes financial and budgetary expenditures matters. Drafts, copies, edits, calculates, revises, retrieves, stores, and prints a wide range of documents in final form (e.g. reports, graphs, statistics, mailing labels, tables, and etc.). Follows direction from federal employees, to help resolve agency client account discrepancies and administratively support accurate/timely invoicing records processing. Records and monitors activities related to the expenditure and disbursement of funds, and track/analyze the status of funds. Performs verbal and written communication with various levels of management and operating personnel to assist Management with daily operations. Verifies funding status of prior year Security Work Authorizations (SWA), collects financial information that is required for audit responses, assisting in validating and verifying accounts, responding to agency requests for documentation to support invoiced amounts, assisting in certifying undelivered orders, and completing special projects. Analyzes accounting data, reconciling accounts, and drafting documents to justify reprogramming actions and submit re-classification requests for approval thru the Supervisory Budget Analyst and/or Financial Program/Cost Analyst for changes in the financial system. Analyzes estimates for consolidation of funding requests; assist in verifying cost estimates received from others by evaluating the consistency of dollar estimates against PSO contract exhibits. Qualifications Minimum BS/BA degree that includes at least 24 hours coursework in finance, quantitative methods, or accounting. An active secret clearance, or the ability to acquire one. Must have at least four (4) years of active experience in federal financial policy, procedures, regulations, and guidelines applicable to financial management programs, processes, and systems, with the skills and ability to apply such knowledge to a broad scope of complex assignments. Advanced knowledge and proficiency in Microsoft Office products, including Word, Access, intermediate Excel, and PowerPoint. Excellent communication skills (both written and verbal) with the ability to prepare and make group/executive presentations. Excellent presentation skills. Strong analytical skills. Ability to conduct online research. Resourcefulness, initiative and skill to function in a fast-paced environment. Attention to detail in goal/task accomplishment with minimal supervision. Professionalism and the ability to interact effectively with others. Ability to meet planned and unscheduled deadlines in a timely manner. All contract personnel will be required to undergo a background suitability clearance (HSPD-12) by the federal government agency's Office of Professional Responsibility, prior to report to work and maintain this suitability clearance. All personnel shall be able to work independently. Adequate supervision shall be provided by the contractor to ensure successful performance under this contract. All contract employees shall dress in casual business attire and will be required to act in a professional manner at all times. #J-18808-Ljbffr