Alma Ramirez-Sherrill Email & Phone Number

Bentonville, Arkansas, United States

Fully Online

Graduated with a Bachelor of Business Administration (BBA). Major in Accounting ProgramHonors: cum laude

Neosho, Mo

Graduate with an Associate in Applied Science, Business Administration.Dean's List 2018 - 2019

San Antonio, Texas

Supervised over $2.6 Million in billing and expense accounts, including all state, state pass-through partnerships, and other grants and contractsManage all aspects of day to day bookkeeping and accounting processes including but not limited to: A/R, payroll, journal entries, and bank reconciliation in accordance with GAAP.Prepare Journal Entries for prepaid expense, deferred revenue and payroll cash accountsReceive and deposit all organizational revenue.Execute monthly payroll activities using a 3rd party payroll service provider.Prepare monthly and quarterly financial reports, including standard financial reports, budget vs. actual reports and grant-specific financial reports.Ensure the billing is in compliance with all internal policies, controls, and relevant regulations and ensure filings are completed in a timely manner.Prepare billing and bill various government agencies.Assist Program Managers in the financial reporting and other administrative requirements of their grants/contracts, state Memorandum of Agreements.Report and track actual expenditures and variations from the budgetMonitoring/tracking the status of each program through its program life cycleManage time tracking process for employees with hours billable to grants, payroll entries for financial and grant reporting.Work closely with Controller to execute month-end closing procedures and postings.Coordinate with Controller and Auditors in preparation of the year-end audit.Support Program Managers in development and analysis of annual organization budget.Produce reports as needed by program staff

Austin, Texas Area

Prioritized and compared quarterly estimated $5.7 million costs to actual output cost (variance vs. budget) for the property managerOrganized and prepared first run variance vs. budget and forecast analysis budget of $7.9 million for the property manager to adjustStrong operational knowledge of GAAPResponsible for data entry of Accounts Payable help gain extensive knowledge of cost-related auditing for yearly budget cost analysisHelped the property manager quarterly compare estimated costs to actual output cost (Variance vs. Budget)Yearly cost analysis (w/ average of 3 yrs) Variance vs. Budget and Forecast analysis for first-run budget preparations for the property managerPrepared first run Variance vs. Budget and Forecast analysis budget for the property manager to adjustPrepared monthly, quarterly, and year-end closings – monthly distributionsGenerated complete financial package - income statement, balance sheet, and profit and loss statements.Responsible for the Profit & Loss to Balance Sheet to General Ledger to cash at the end of months reconciliationsInvestigated and resolved accounting discrepancies or errorsReconciled up to 20 bank statements & maintain up to date bank balanceMaintained & processed 1099 tax information on vendorsI ran 1096 for the controller to review and signEntered receipts for over 450 customer accountsPrepared customer's monthly statementsInvestigated and resolved billing and account discrepanciesResponsible for scanning all invoices for vendor voucher packages, including filing all non-negotiable check copies with the packages for auditing purposes according to established policiesResponsible for voiding checks that are improperly generated & ensuring properly filing of voided checks/invoicesExcellent multi-tasking skills that allowed me to prioritize various ongoing projectsCreated custom Excel spreadsheets to meet needsUsed QuickBooks, MS Office Suite, and a variety of custom Excel spreadsheets

Austin, Texas Area

Supervised and managed all company's financial operations grossing $3.3 million in revenueIncreased the profit margin from 2004 to 2009 by 72%Originated an out-of-the-box solution to save the multimillion-dollar US Army mobile learning program Promoted and ensured transparency in business dealings of the organizationPrepared monthly, quarterly, and year-end closings – monthly franchise royalty distributionsGenerated full financial package - income statement, balance sheet, and profit and loss statements.Prepared monthly accruals-Profit and Loss statementResponsible for the Balance Sheet & general to ledger accounts reconciliationsResearched and corrected accounting errors or discrepanciesReconciled 6 bank statements & maintain up to date bank balanceWorked closely with the CPA to resolve problemsMaintained 1099 tax information on vendorsAnalyzed and reviewed the packages for accuracy, distributed the packages to appropriate partiesPerformed a variety of concurrent tasks with ambiguous or little directionsExcellent multi-tasking skills that allowed me to prioritize various ongoing projectsCreated custom Excel spreadsheets to meet Corporate Headquarters, Management, and Account Executive needsUsed QuickBooks Enterprise, MS Office Suite 2007 and a variety of custom Excel spreadsheets

Tempted with Real Estate companies, oil and gas industry, and Law FirmUsed AMSI, QuickBooks, and variety of accounting softwareThe real estate was responsible for 11 properties with on-site computer systemsUsed a variety of all accounting transactions: accounts receivable, accounts payable, mortgage and insurance payments, tax processing and preparing bank reconciliationsReviewed annual budget and compared actual expense to budget, investigated variancePrepared monthly accruals to the Profit and Loss statementReconciled the bank security account, general ledger, & Balance Sheet accountWith all companies, I used MS Outlook and a variety of custom Excel spreadsheets

Charleston, South Carolina Area

Transferred thousands of rapidly degrading MS-DOS records to Yardi, in time to accomplish year-end closingResponsible for monthly, quarterly, and year-end closingsFinancial package +budget comparison, CAM & CPI reconciliations, and tenant rent roll 7 commercial propertiesReconciled 21 bank statements & maintain up to date bank balance.Assisted with annual budget setup and oversaw the monthly forecast and compared actual expense to budgetInvestigated variance &prepared monthly budget reportsAnalyzed & reviewed the packages for accuracy, distributed the packages to appropriate partiesDeveloped many easy to read Excel spreadsheets for the property managers, owners, and invested partnersWorked with Yardi, Lotus Notes, Microsoft 95 & 98, Microsoft Office 2000, MS Word, and Excel

Fort Sam Houston San Antonio, Tx

I earned a Department of the Treasury award. I was a specialist in charge of a 90-person company with a staff of five. It was my responsibility to oversee the delegation of duties of training, housing, and other administrative duties for the 90-personnel to Army standards. I was responsible for a payroll of 15,000 soldiers with the operating budget of $5.5 million. I earned a reputation as a shrewd analyst after meticulously paying attention to details of research data by identifying over $400,000.00 in dollars that were incorrectly disbursed in entitlements and travel payments due to a computer glitch. I developed and implemented a soldier training program related to entitlements and travel allowance. I was trained to work with a variety of software. As the Finance Specialist, I worked with all aspects of accounting.

Bachelor Of Business Administration - Bba, Accounting, 3.5

Networking Technology Specialization, Network Support

Activities and Societies: Junior Achievement (JA)Honors Program: 19 September 2002 ID Number: 02G11003

Associate In Applied Science, Business Administration, 3.7

Activities and Societies: PBL, MOCPA(student), AICPA(student), IMA(student)