Sofia Lehmann Email & Phone Number

• Wrote and submitted 16 applications for CDBG-DR, Mitigation, and CDBG programs procuring over $39 million in funding for Texas rural communities. • Provided application preparation and technical assistance to clients as well as acting as liaison with elected officials, staff, engineers, and state agencies.• TxCDBG Certified Administrator for two years.• Gather data from the U.S. Census Bureau and other agencies to create complex scoring spreadsheets to assess client eligibility.• Gathered and analyzed data for any ad hoc report needed by upper management• Serve as beneficiary subject matter expert including managing project beneficiary surveys and compiling beneficiary packets.• Provided training to new application assistants and application specialist in the department.

• Maintain and track all financial expenditures for the $3.8 million Community Development Block COVID Grant.• Manage 14 grant subrecipients.• Review and process all subrecipient monthly financial and reimbursement reports.• Conduct biannual on-site financial audits of all 14 grant subrecipients to ensure HUD compliance.• Provide assistance with the Community Development Block Grant and the Emergency Solutions Grant as needed.• Create any ad hoc spreadsheets and reports as needed by the Assistant Director and Director.

Houston, Texas, United States

• Maintains the Communications budget including acquiring quotes and managing all financial paperwork.• Creates various marketing reports tracking social media metrics, traditional media mentions, SEO, and email marketing metrics for upper management and director.• Proofreads and edits media alerts, press releases, newsletters, and other print media produced by the Houston Public Library.• Manages team gear and swag item inventory.• Manages all customer comments through various social media outlets and Google.• Creating ad hoc reports

Tallahassee, Florida Area

• Conducted 13 management audits of water, electric, gas, and telephone utilities throughout Florida.• Project scopes included cyber and physical security, gas distribution facilities inspections, dataaccuracy of electric reliability reporting, and project management of internal controls for nuclear plantconstruction projects.• Prepared formal written reports of audit results on the adequacy and effectiveness of the performanceof systems, internal controls, and other activities.• Gathered, managed, and analyzed quantitative and qualitative data.• Conducted and led interviews with utility personnel as part of the data gathering process.• Prepared testimony and publicly testified at Commission hearings.

Tallahassee, Florida Area

Greenville, South Carolina Area

• Created a programmatic budget for our $250 million Endowment as well as supplementary analysis• Created and delivered a presentation for the Board of Directors on the budget as well as my current research• Maintained and update the website• Conducted a qualitative research project on the perceptions of poverty in Jefferson County, GA where we currently have an ongoing project• Created a database of watershed protection programs around the country• Collected and organized request for proposals

· Supervise the social media outlets for the Center for Sustainability and the Furman Farm · Responsible for publishing the biannual newsletter, The Long View · Assist with website improvements and updates

· Worked with the other fellow to create a social media strategic plan for the Center for Sustainability. · Maintained all social media for the Center and the Furman Farm including Facebook, Twitter, Wordpress, and Flickr · Increased the public knowledge of the mission of the Center · Developed the framework for an educational workshop on sustainability for the Admission Office · Developed, organized, and delivered a Freshman Orientation programSustainable Connections Liaison 8/2010-5/2011 · Created communication between the 8 groups on campus that deal with sustainability · Assisted groups in finding sponsors and other groups to co-host events · Created publicity campaign for events that the Center for Sustainability sponsored