Financial Aid General Ledger

Vivian Crystal Venegas-Keiser (C): 720-***-**** ************@*****.***

Education

Bachelor of Science: Finance December 12, 2015

Metropolitan State University 890 Auraria Parkway Denver, Colorado Associate of Arts: Business Designation 2012

Community College of Aurora 1600 East Centre Tech Parkway Aurora, Colorado 80011 Related courses: Insurance, Investments, and Markets & Institutions, Communications, Physcology, STATS & Computer Science, Economics I & II, Marketing and Accounting Principles II, and Legal Environment of business Skills: Microsoft Office 365 Workday CORE Alfresco Adobe Portfol PeopleSoft Salesforce Character: Amiable, Proactive, Analytical, Ethical, Strategic and Clever Certifications: Green belt (Lean/ Six Sigma; phase I of certification & registered for Black belt which is the final phase of certification),Uniform Administrative Requirements for Federal Grants: 2 CFR 200 (Subparts A-D) Work History

Staff Accountant September 2020-Current

Community College of Denver (CCD) 800 Curtis Street, Denver, CO 80204

● Provide professional level support to the Controller, Assistant Controller, and Fiscal Grant Manager in grant and financial aid scholarship activities, including:

Ensuring the general ledger properly reflects financial aid activity, performing reconciliations, processing check requests, and working with the Financial Aid Department to clear outstanding items found in reconciliations

● Ensuring the general ledger properly reflects grant activities on an accrual basis, performing reconciliations, preparing reports and meeting regularly with departments and grant managers.

● Ensure that grant activities comply with all applicable regulations and guidance, including State legislation, Federal grant regulations, the Compliance Supplement, State Fiscal Procedures and Rules.

● Performed travel related functions for Fiscal Services, including issuing travel authorization numbers for all staff, reconcile all travel expense reimbursement requests and any mileage

● Reimbursement requests, acted as a liaison between Fiscal Services and college departments to provide information in a timely manner, respond to various employee inquiries and provide training when necessary.

● Assisted with the development and testing of the rate tables each semester.

● Periodically reconcile billings, invoices, and/or accounts related to student activity.

● Processing of interagency transactions in CORE.

● Provided back-up coverage for other departmental functions/tasks.

● Processes various general ledger transactions, prepares numerous reconciliations, invoices as needed, monitors and clears diagnostic/exception reports, monthly, quarterly, and year end closes,

● Participated in the preparation of schedules and other items for internal and external audit purposes, and year- end financial reporting.

Accounting Technician II February 2017- August 2020 City and County of Denver, Department of Housing and Stability (HOST) 201 W Colfax Ave, Denver, CO 80202

● Processed requisitions and submitted change orders to purchasing.

● Assisted in RFP bid reviews by giving financial and programmatic advice

● Processed service contracts by calculating indirect costs and personnel costs

● Processed Temporary Rental and Utility Assistance contracts

● Audited and reviewed loan Gap financing contractual draws

Construction contracts: Davis bacon and prevailing wage compliance

Small business loan and Neighborhood Business Revitalization contracts

● Research of federal laws and regulations by auditing AP & AR draws to ensure compliance by interpreting data, grant terms, conditions.

● Maintained general ledger system by preparing original and correcting journal entries to assure all financial data is included and balanced.

● Prepared billings/invoices and follow-up on accounts receivable. Tracked and correct overpayment of grants.

● Filing projects for loan payoffs ensured compliance with proper subordination documents such as line of credit requests, payoff statements, late fee notices and non-cash adjustments.

● Assist in the preparation and maintenance of budget adjustments and amendments.

● Served as a resource for program staff on accounting related processes and deadlines.

● Assist program managers with financial data entry in the city’s billing database, and reconciling the database to internal accounting records.

● Trained suppliers/vendors with presentations, checklists and step-by-step on how I authorize draws

● Assisted in developing monthly budget reports such as CDBG draw-down reports for program managers. Project Management: An “Ambassador” to empower colleagues to provide innovative concrete performance solutions.

● Reviewed financial model like key performance indicators from conducted benchmarking and process analysis

● Consult with management to guide and influence long term and strategic decision making

● Create decision-support analytics and communicate to Senior Leadership

● Member of Equity, Diversity and Inclusion team to accomplish mayoral initiatives. Temporary Accounting Technician III March 2015-December 2016 Colorado Department of Labor & Employment (CDLE) 633 17th Street Suite 1100 Denver CO 80202-3660

● Reconciliation of cash program reports to general ledger and processed cash receipts in CORE.

● Maintain monthly ledgers for each program in the organization and reconcile all bank accounts.

● Accounts Receivable functions to include electronic deposits, physical bank deposits, and monitoring of client accounts to ensure payments are up to date within Bill.com.

● Accounts Payable functions to include bill entry, approval verification, and payment within Bill.com.

● Reconciled Oil & Public Safety encumbrances in CORE vs. program Adobe subsidiary system.

● Created purchase orders in CORE and closing purchase orders for year end closing.

● Generated reports to analyze abnormal balance sheets, expenditures and revenues.

● Financial reporting of general fund revenues and drawdown requests.

● Accruals by clearing rejected postings of invoices (DO, PO, CT, IN & GAX), and rescinding balances. Temporary Administrative Assistant

State of Colorado, Health Care Policy and Financing (HCPF)

● Data entered Case workers information into CBMS which has Applicants tracking number, verified documents Cash Assistance and Food Assistance.

● Recorder in meetings and sent relevant parties minutes of those meetings.

● Conference room setups and meeting moderator.

Contact this candidate