SEARCH

Grants and Data Manager Resume Example

Resume Score: 90%

Love this resume? Build Your Own Now
GRANTS AND DATA MANAGER
Highlights
  • Accurate forecasting
  • MS Office Suite
  • Advanced computer proficiency (both PC and Mac)
  • Complex problem solving
  • Superior time management
Experience
Grants and Data Manager, 09/2010 to Current Maryland State Arts Council MSAC － Baltimore, Maryland
  • Manage the agency's grants database and custom Web-based granting system (e-Grant); Organize application testing and recommend system modifications; Work directly with the contractor (Bromelkamp) to maintain schedules, ensure requested changes to e-Grant are implemented; Develop and maintain an Access database to manage annual report data for a stand-alone grant program; Design and create Access queries/reports to ensure data transfer and automate routine processes; Use Excel's Advance features (e.g.
  • advanced filters, functions-if, vlookup, pivotTables, charts, name manager, etc.) on proprietary and collected (Maryland Cultural Data Project-MDCDP) data for analyzing; Prepare and analyze grant status reports for MSAC senior management and program staff; Provide technical assistance to non-profits, county arts councils, individual artists, and K-12 schools; Answer inquiries from grantees regarding completion of forms, formats for reports, and procedures relating to report extensions; Approve extension requests for reports; Serves as the primary liaison with the DBED AG Office to ensure legal form and sufficiency for grant award agreements; Edit all grant-program guidelines, interim reports, and final reports; Prepare grant recommendation worksheets and calculate allowable requests using formulas and percentages; Perform grant closeout and ensure all requirements have been met; Assist in the preparation of the Basic State Grant final report to the NEA by overseeing the compilation of data from grantees; Prepare data for inclusion in MFR documents; and Serve as: the primary point of contact with the Governor's Grants Office; the liaison to the MDCDP tech staff to ensure that MD applicants submit required financial and organizational information used for internal and external reports; and along with Executive Director, a member of MDCDP Steering Committee to determine policy and procedures for the use of CDP data.
  • Train staff on the agency's new grants system.
Education Assistance Benefits (EAB) Manager, 01/2008 to 01/2010 Johns Hopkins University － Baltimore, Maryland
  • Managed the university's education benefits for 10,000+ employees, their spouses and dependents; Researched other colleges' and universities' educational benefits policy to establish / confirm applicants' eligibility; Forecasted budget ($15,000,000) for Tuition Grant Plan (important retention tool for the university); Allocated funds across 9 JHU academic divisions for training programs; Coordinated day-to-day operations; Interpreted and communicated policies, procedures across and outside the university; Collaborated with business and admissions offices, the Controller's Office, Accounts Receivable Shared Services, and Human Resources to identify and resolve concerns; Developed alternate billing arrangements to secure students' registrations; Designed, developed and administered databases; Ensured website content accuracy; Revised application forms consistent with governing laws (Title 26-sections 117, 127 and 132); Drafted response statements related to education assistance for senior management; Supervised, counseled and coached two full time support staff people; Served as a reference resource, and a liaison between University Administration, departments, and public relations efforts.
Manager, 01/2002 to 01/2008 Johns Hopkins University － Baltimore, Maryland
  • Subject matter expert for the University's six tuition benefit plans (available to 10,000+ FTEs); Directed daily operations, and established operating procedures across the divisions supported by tuition benefits dollars; Interpreted established policies, procedures and regulations; Communicated with faculty, staff, officers and deans to advise regarding the availability of resources, explain policies and procedures, and approve/deny requests for exceptions; Provided senior management with timely feedback, statistical reports and recommendations; Solved problems associated with the use and abuse of funds, the review, approval and processing of vouchers, and the coordination of roles of various academic divisions; Communicated with part-time instructors to arrange/discuss/review contract terms; Enforced policies across employee categories; Planned annual activities for university's tuition programs; Ensured appropriate billing / charging by cultivating ongoing partnerships and effectively communicating policy allowances, limitations and related tax law; Announced and implemented changes (eligibility criteria, application processing procedures, etc.); Wrote Education Assistance Plan Annual Report, and articles for internal publications; Co-wrote training contracts with the Director for the General Counsel's review; Successfully addressed requests for clarifications /exceptions / waivers; Evaluated and responded to department's requests for benefits dollars for workshops;.
Administrator, 01/1996 to 01/2002 Johns Hopkins University － Baltimore, Maryland
  • Through timely audit of integrated student accounting system (ISIS) ensured employee compliance with university and federal guidelines; Monitored employee and family members' use of benefits dollars; Ensured data reliability-maintained legacy systems data integrity--updated core dBASE III (DOS) dbf files to reflect current university and federal policies; Created Paradox and Access databases to track program participation; Managed web site content in collaboration with IT; Determined position needs, and created related job descriptions; Recruited, hired, supervised and trained administrative and program staff; Reviewed staff eligibility for salary growth; Documented application processes/flow and managed other related employee issues to ensure efficient office operations and foster cross collaboration; Developed content and distribution schedule for annual advisory letters; Facilitated information sessions to encourage increase program awareness/ knowledge and participation; Met with staff at various levels of the institution to discuss policy; Designed a customer satisfaction survey (SPSS); Evaluated survey results and recommended and implemented changes to address findings; Ensured the prompt flow of policy information and products (notices, applications, and payments); participated in University-wide committees and activities.
Coordinator, 01/1995 to 01/1996 Johns Hopkins University － Baltimore, Maryland
  • Prepared and forecasted university-wide $15 million tuition grant budget; Managed the allocation of $8 million in remission funds to academic divisions; Developed rate schedules (fee structure) for benefits pool training programs; Approved, monitored and analyzed actual expenditures and prepared reports to maintain balanced accounts; Revised projections to manage cost center and commitment items charges; Provided administrative expertise and technical advice to director on appropriate fund use and interpretation of tuition policy.
  • Ensured proper charging rates (employees versus dependents) used by academic divisions; Managed 1700 student and 400 vendor accounts annually; Administered faculty, staff and student payroll, purchasing, employee reimbursement and contracts; Recommended alternate funding for unallowable costs; Represented the director at executive level budget meetings; Responded to auditors' data requests; Served as liaison with peer institutions.
Budget Assistant, 01/1993 to 01/1995 Johns Hopkins University － Baltimore, Maryland
  • Coordinated office budgets and services; Reconciled expenditure statements; Prepared purchasing requests, petty cash documents; Designed and developed registration system for training program; Interviewed for and wrote the Department's monthly new letter, Auxiliary Enterprises; Compiled and edited monthly Activity Report.
Administrative Assistant, 01/1991 to 01/1993 Johns Hopkins University Auxiliary Enterprises － Baltimore, Maryland
  • Managed all personnel and facility matters; Coordinated contractual arrangements with independent contractors; Developed, prepared and monitored budgets; Represented the director at budget/financial meetings; Designed registration system to track participation in training programs.
Air Condition & Refrigeration Repair Specialist / Instructor- Writer / Student Controller, 01/1984 to 01/1989 United States Army － Aberdeen Proving Ground, Maryland
  • Repaired air condition and refrigeration units; Facilitated training sessions on subjects ranging from basic electricity to reading; Reviewed and assisted in the revision of the Standard Operating Procedures Guide; Counseled student soldiers on conduct and performance; Maintained sound accountability of assigned property with zero losses; Coordinated training schedules for more than 900 students.
Education
B.S: 5 2005 Johns Hopkins University
Leadership Development Training Course, U.S. Army, 1988 Instructor Training Course: 1 1987 U.S. Army National Education Corporation, Paralegal Course
1 1984 Oberlin College － Ohio
Skills
academic, accounting, Accounts Receivable, administrative, Army, arts, agency, automate, Basic, benefits, billing, budgets, budget, charts, content, contracts, Controller, customer satisfaction, data transfer, databases, database, dBASE III, DOS, Edit, senior management, features, financial, forms, funds, Grants, Human Resources, Instructor, interpretation, ISIS, Leadership Development, law, legal, letters, Director, meetings, Access, Access database, Excel, Office, organizational, Paradox, Paralegal, payroll, personnel, policies, processes, public relations, publications, purchasing, reading, sound, SPSS, tax, technical assistance, training programs, web site content, website content, workshops, articles
Build Your Own Now

Resume Overview

Companies Worked For:

  • Maryland State Arts Council MSAC
  • Johns Hopkins University
  • Johns Hopkins University Auxiliary Enterprises
  • United States Army

School Attended

  • Johns Hopkins University
  • U.S. Army
  • Oberlin College

Job Titles Held:

  • Grants and Data Manager
  • Education Assistance Benefits (EAB) Manager
  • Manager
  • Administrator
  • Coordinator
  • Budget Assistant
  • Administrative Assistant
  • Air Condition & Refrigeration Repair Specialist / Instructor- Writer / Student Controller

Degrees

  • B.S : 5 2005
    Leadership Development Training Course, U.S. Army, 1988 Instructor Training Course : 1 1987
    1 1984

Advertisement

Similar Resumes

View All

Post Award Grants Coordinator

The George Washington University

Hyattsville, Maryland

Posted 1963 days ago