Finance and accounting professional with nearly thirteen years of professional accounting experience in Government (BFS), Government Contracting, and Corporate Oil and Gas. My goal is to improve the general wellbeing of an organization, as well as embrace the financial goals to help the organization reach its strategic goals. Areas of strength include monthly and year-end general accounting, cost accounting, internal controls, financial analysis, and public law analysis and interpretation. A Positive work ethic, always trying to better myself and others, as well as genuinely caring about the best interest of others allows me to be the best version of me. Advanced level skills in preparing and presenting information in excel using complex formulas such as v-lookups and macros to transform raw data into summarized data for different level of users. Process documentation with high regard to efficiency and accuracy.
Hi, I’m
Mandi Hornick
Beverly,WV
Summary
Overview
13
years of professional experience
Work History
Bureau of the Fiscal Service, US Department of Treasury
Supervisor Accountant – ARC, ARAD, RAB1
11.2023 - Current
Job overview
- Supervise a team of 4 accountants ranging from entry level to senior level experience
- Managed weekly, monthly, quarterly and annual accounting processes including journal entries, ad hoc reporting, general ledger and subledger reconciliations for 28 FUNDS
- Analyze transactions on a monthly basis to ensure accuracy and provide recommendations to customer agency
- Communicate with many different departments within ARC (Accounts receivable, Accounts Payable, Intragov, Payroll, PRISM Reporting Team, Oracle Support team)
- Communicate with outside Agencies including HUD, our customer agency as well as Office of Management and Budget (OMB)
- Supervised a special team for quarterly reporting; prepare financial statements and various reports and supporting documentation. As well as provide support to customer agency auditors
- Verify the accuracy of the data provided to the Office of Management and Budget (OMB)
- Communicating with customer to ensure records are completed accurately and efficiently
- Review and Approve SOPs for department ensuring they reflect the most efficient process as well as maintain operating requirements, audit requirements and accounting principles
- Responsible for managing schedules of employees, including approving leave, overtime (comp time), and timecards
- Applied strong leadership talents and problem-solving skills to maintain team efficiency and organize workflows.
- Improved customer satisfaction with timely response to inquiries, addressing concerns, and finding effective solutions.
- Increased team productivity by implementing efficient workflows and setting clear expectations for staff members.
- Resolved conflicts among team members promptly, maintaining a harmonious working environment conducive to productivity.
- Enhanced communication within the team by holding regular meetings and encouraging open dialogue among all members.
- Mentored junior staff members in their career development, sharing knowledge from years of experience in the field.
- Conducted performance evaluations for staff members, identifying areas of improvement and guiding professional development plans.
- Oracle, OneStream, CARS; Connect, SharePoint; Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access). WebTA
Bureau of the Fiscal Service, US Department of Treasury
Senior Financial Systems Analyst – ARC, OSD, RTSB, AIS
01.2023 - 10.2023
Job overview
- Took on Change Management Report and distribution; also changed the report per management request to better present data
- Reviewed RFI Responses for Automated Testing – prepared a summary document to keep track of responses as well as recommend the vendor to move on to the next phase of the project. Communicated, organized, and scheduled demos from Vendors for the RFI
- Define and write requirements; develop project plans; conduct briefings and training sessions; manage projects; identify and recommend changes in the processes for manual and automated systems, and the accounting and processing controls
- Gather information and report on the status of projects
- Create test scripts and run tests
- Develop and write quick reference guides for users
- Track technology developments and recommend changes to processes
- Act as system/application administrator over systems running on personal computers or client servers.
- Serve as technical advisor to the Branch Manager and other management officials on matters involving the composition, requirements, and operation of automated financial management systems.
- Provide consulting services to customers on financial system setup and interfaces. Provide demonstrations of the financial systems to customers
- Maintained thorough documentation of all implemented changes within the financial system environment, simplifying future audits or reviews.
- Collaborated with cross-functional teams to integrate financial systems and improve data flow.
- Facilitated communication between IT and Finance departments, bridging knowledge gaps for seamless collaboration.
- Communicated and explained business requirements to team members to understand and implement functional demands.
Bureau of the Fiscal Service, US Department of Treasury
Accountant – FA, CARD, BRB
11.2020 - 01.2023
Job overview
- Converted the Part II of the FASTBook (Federal Account Symbols and Titles) from a PDF File to and Excel workbook making the file more user friendly. The conversion was a request from government agencies to allow for easier searches by making more attributes available for sorting and searching.
- Enhanced and maintained process to track COVID relating funding on a monthly basis as well as provide reporting on an as needed basis
- Developed and maintained a process to analyze data for an account rollover reconciliation process to comply with request of GAO
- Participated in the General Fund Audit by collaborating with other team members to respond to AIFs.
- Provided Efficiency and timeliness to pre-existing projects by thinking outside of the box and manipulating the data to allow for the output to benefit more than just one audience
- Participated in large presentation reaching well over 500 federal employees to discuss a new module being released in our CARS System as well as some new forms that were being released
- Establish new Treasury Account Symbols at the request of Agency, also review and approve the establishments and amendments to Treasury account Symbols
- Analyze Public Laws upon passing and process appropriations that contain time purpose and amount
- Complete Daily transactions when requested by the agency and permitted by law, IE Non-expenditure transfers and Warrants, including high profile transactions
- Effectively communicate with many internal and external customers to ensure all aspects of jobs and processing are being completed efficiently and accurately.
- CARS; MAX, Content Manager, SharePoint; Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access)
PDC Energy
Revenue Accountant II
01.2019 - 10.2020
Job overview
- Developed a new process for the GLO reporting and documented the process; decreased timeliness of process and was able to relieve the contractor and accosts associated and bring the process in house
- Prepare monthly revenue vouchers for oil and gas production - Tasks include verifying production and payment, preparing cash receipts and confirming wire payments, reconciling accounting and production figures to ensure systems are in sync, perform yield calculations and month over month comparisons to ensure no significant changes without explanations
- Prepare and Process Accruals on a monthly basis for oil and gas production
- Monthly Analysis of Sales and Pricing
- Prepare General Journal Entries when necessary
- Complete Month End reconciliations for Revenue accounts
- File reports to the General Land Office (GLO) of Texas for Oil and Gas Production; review the data provided from SAP for the report and compare it to production; submit reports by deadlines provided by the GLO; and make the necessary payment on behalf of PDC
- Effectively communicate with many departments to ensure all aspects of jobs and processing are being completed efficiently and accurately.
- BOLO; SAP ERP Software; Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access)
Allegheny Science and Technology
Financial Analyst
11.2015 - 01.2019
Job overview
- Prepare, review and disburse monthly budgets as well as provide Job Summary Reports for each contract and disburse to contract managers for proper project management.
- Complete budget to actual analysis to determine deviations from the budget to adjust going forward.
- Prepare Monthly Financial information to assist in the closing process: Sales by Month, Profit by Job, Gross Profit and Margin Analysis, CFO Analysis (Compilation of Income Statement and Balance Sheet to give CFO quick glance of both statement).
- Complete invoices process for multiple government agencies from start to finish — tasks include prepping the invoice, reconciling hours worked, and expenses charged, contract information, prior contract cumulative, distributing to the customer, as well as ensuring that all invoices reconcile to the accounting software.
- Assist with the project control process by preparing weekly, and monthly reports for Project Managers to review hours worked by employees to ensure that time worked is being used well.
- Complete Financial Analysis on separate projects to ensure projects are on budget and do not have any major threats or make myself aware of opportunities.
- Prepare DCAA Audit Annually
- Cross train to complete accounts payable, employee expense reports, company-wide payroll
- Deltek ERP (GCS, Time and Expense, Budgeting and Planning), Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access, ADP Payroll)
Gas Analytical Services, Inc.
US Accounting Supervisor
02.2014 - 09.2015
Job overview
- Increased supervision from two direct reports to eight; 2 billers, 1 accounts receivable, 1 accounts payable, 1 inventory manager, 2 administrative assistants, and 1 senior accountant.
- Developed policies and procedures in accordance with CSOX and IFRS for Inventory, Invoicing, Accounts Receivable, Accounts Payable, Bank Reconciliations, and Fixed Assets.
- Monitored and Controlled Internal Controls
- Planned, monitored and analyzed the month end financials for US Operations before being submitted for inclusions in Parent Company (Canada)
- Lead Transitions for two major acquisitions including development and training on new systems, processes, procedures, and cultural changes
- Continued to Improve the inventory process reducing variances allowing for a reduction in physical counts transitioning from quarterly to semi-annually.
- Prepared budget for US operations using COGNOS, assisting separate business units with forecasting
- Developed Statement of Operations in US Dollars for US operations management, as the financials were released in Canadian Dollars.
- Microsoft Dynamics GP, Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access), ADP Payroll
Gas Analytical Services, Inc.
Senior Accountant
07.2013 - 02.2014
Job overview
- Managed $5 million inventory in multiple locations in the Northeastern US.
- Improved the inventory process by generating a calendar and delegating tasks reducing confusion.
- Reduced inventory variances from $75,000.00 to less than $10,000.00 by completing variance research.
- Developed a report showing profitability snapshots for inventory and business units
- Controlled Goods Received, Not Invoiced by generating report to clarify what was received versus received and invoiced.
- Improved the invoicing process by encouraging daily billings, which improved the aging of customer bills.
- Reduced the number of credits and re-bills by educating the billers on what happens in the field giving them a better understanding of the billing process. This allowed for more time to focus on additional billing and a better relationship with customers and operations.
- Involved in Quarterly, and Year-end close regarding balance sheet account reconciliations, variance analysis, adjusting & month-end journal entries
- Improved the monthly closing process reducing the time from two weeks to one.
- Managed two direct reports which both maintained the billings for all of US Operations.
- Lead the year-end audit for US Operations with good organization and preparation. This led to an early completion of the interim audit, as well as reduce the amount of money spent for audits in the future.
- International travel to Canada to represent US Operations in the year-end audit completed by KPMG.
- Microsoft Dynamics GP, Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access), ADP Payroll
Gas Analytical Services, Inc.
Junior Accountant
09.2012 - 07.2013
Job overview
- Sales order processing- entered sales into the ERP system to generate revenue for services provided.
- Developed more useful work ticket to benefit both operations and accounting allowing information to be processed in a more accurate and timely manner.
- Supervised physical inventory counts to prove accuracy.
- Recorded general journal entries monthly for fixed asset depreciation and amortization, as well as additions and disposals.
- Created value sheets for physical assets on hand which justified the value recorded on the financial statements.
- Developed a better relationship with operations and accounting creating a more efficient work environment.
- Trained to complete payroll for US operations
- Microsoft Dynamics GP, Microsoft Office Suite (Excel, Word, PowerPoint, Outlook, Access), ADP Payroll
Education
Fairmont State UniversityFairmont
Bachelor of Science from Accounting
05.2012
University Overview
Skills
- Training and mentoring
- Goal oriented
- Staff management
- Customer service
- Attention to detail
- Employee motivation
- Decision-making
- Complex Problem-solving
- Strategic planning
- Staff development
- Processes and procedures
- Change management
- Teamwork and collaboration
- Problem-solving
- Multitasking
- Advanced Excel, Microsoft Office Suite, ERP Systems (Oracle, SAP, Microsoft Dynamics), One Stream, Deltek, WebTA, ADP Payroll experience
Timeline
Supervisor Accountant – ARC, ARAD, RAB1
Bureau of the Fiscal Service, US Department of Treasury
11.2023 - Current
Senior Financial Systems Analyst – ARC, OSD, RTSB, AIS
Bureau of the Fiscal Service, US Department of Treasury
01.2023 - 10.2023
Accountant – FA, CARD, BRB
Bureau of the Fiscal Service, US Department of Treasury
11.2020 - 01.2023
Revenue Accountant II
PDC Energy
01.2019 - 10.2020
Financial Analyst
Allegheny Science and Technology
11.2015 - 01.2019
US Accounting Supervisor
Gas Analytical Services, Inc.
02.2014 - 09.2015
Senior Accountant
Gas Analytical Services, Inc.
07.2013 - 02.2014
Junior Accountant
Gas Analytical Services, Inc.
09.2012 - 07.2013
Fairmont State University
Bachelor of Science from Accounting
Similar Profiles
Kimberly M. SmithKimberly M. Smith
Director, Office of External Affairs, Office of Customer Experience Management (OCEM) at DEPARTMENT OF TREASURY, BUREAU OF FISCAL SERVICE (FISCAL)Director, Office of External Affairs, Office of Customer Experience Management (OCEM) at DEPARTMENT OF TREASURY, BUREAU OF FISCAL SERVICE (FISCAL)
Tricia G. Arnold, C.P.A.Tricia G. Arnold, C.P.A.
Accountant – Reporting & Analysis Branch 1 at US Department of Treasury | Bureau of Fiscal Services | ARCAccountant – Reporting & Analysis Branch 1 at US Department of Treasury | Bureau of Fiscal Services | ARC
BRITTNE ROBERTSBRITTNE ROBERTS
Debt Collection Analyst at Bureau of Fiscal Services/ TreasuryDebt Collection Analyst at Bureau of Fiscal Services/ Treasury
Katie RawsonKatie Rawson
Executive Director, Process Improvement & Analysis at TTECExecutive Director, Process Improvement & Analysis at TTEC
Adam BurkyAdam Burky
Senior Director of Engineering at Rev.ioSenior Director of Engineering at Rev.io