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.
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