Grants And Data Manager Resume Example Maryland State Arts Council MSAC

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 CurrentMaryland 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/2010Johns 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/2008Johns 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/2002Johns 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/1996Johns 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/1995Johns 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/1993Johns 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/1989United 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 2005Johns Hopkins University

Leadership Development Training Course, U.S. Army, 1988 Instructor Training Course:1 1987U.S. ArmyNational Education Corporation, Paralegal Course

1 1984Oberlin 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

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

Grants and Data Manager Resume Example

Resume Score: 90%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes