Susie Smith Email & Phone Number

• Database administration• CCSG data curation and metrics, including: • Data Tables 1 & 2 • Center publication metrics• Team leader with 2 FTEs and 2 temporary PTEs• System analysis and SOPs• Staff newsletter

• Responsible for enrollment and data collection for anticipated 1800+ study participants.• Design and maintain MS Access tracking database for study participants.• Develop REDCap interface for data collection.• Create and update documentation for study protocols, including IRB submissions, interviewing instructions, and administrative procedures.• Create informational materials including website, brochures, and posters for variety of stakeholders

Unc School Of Medicine, Department Of Social Medicine

∙ Analyzed recruitment and applicant data collected during annual call for applications; built visual reports and presentations to inform future recruitment efforts using Tableau, Excel, and PowerPoint.∙ Drafted Standard Operating Procedure documents for communications workflows and software usage.∙ Led training sessions for project management software, Asana, and cloud-based collaboration platform, SharePoint.∙ Created and delivered tailored messaging used on program social media accounts, website, and newsletters.

Chapel Hill, Nc

∙ Created templates for Center's reports and newsletters using Piktochart and Tableau. ∙ Drafted standard operating procedures for communications team workflow.∙ Updated Center's website to include current events and opportunities.∙ Performed literature searches used in Center's "Evidence Briefs," such as the one linked below.

Chapel Hill, Nc

Gillings School Of Global Public Health

∙ Oversaw and improved stewardship program involving over 120 donor-sponsored scholarships and endowments.∙ Authored external communications, including acknowledgement letters, annual endowment reports, and mass communications to School’s alumni and top donors.∙ Built complex queries and reports for school-wide colleagues and leaders using alumni and donor CRM.∙ Led a team to analyze and streamline deposit and acknowledgement process.

Unc Orthopaedics

∙ Mastered use of university systems and applications for reimbursements and travel requisitions using ePro, CABS, and ConnectCarolina.∙ Initiated and disseminated new intra-departmental processes to ensure timely accurate payments for vendors and faculty.∙ Managed surgical and academic schedules for four surgeons. ∙ Maintained reference records for surgeons’ portfolio and to ensure correct patient billing.

Eshelman School Of Pharmacy

Unc Chemistry

∙ Held leadership role in innovating and transitioning invoicing system from local MS Access to online database.∙ Managed all billing of recharge centers for Chemistry and Pharmacy.∙ Researched multifaceted issues related to outstanding invoices that resulted in direct revenue to departments.∙ Oversaw management of customer records.

∙ Maintained accurate records of product data in proprietary sales database to ensure accurate customer ordering and billing.∙ Designed and marketed product sample displays to over 200 clients in the Northeast.∙ Authored all customer communications involving new product notifications and discontinuations.∙ Created and implemented training programs and product tours for new customer service representatives.

Farmington, Me

Summer 2001: UMF ArchivesSummer 2003: UMF Department of Geology

Master’S Degree, Information Science/Studies

Activities and Societies: Member, Beta Phi Mu International Library and Information Studies Honor Society Peer Mentor, Information.

Bachelor'S Degree, History

Activities and Societies: President, UMF Civil War Society; History Club; Otaku Club

High School Diploma

Activities and Societies: History Club; Monmouth Academy Drama; Monmouth Historical Society; Concert Band; Tennis; Track & Field; Student.